Overview

Dataset statistics

Number of variables8
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.5 KiB
Average record size in memory66.3 B

Variable types

DateTime2
Numeric1
Text1
Categorical4

Alerts

전망월 has constant value ""Constant
수원_취수구분 has constant value ""Constant
전망1월 has constant value ""Constant
전망2월 has constant value ""Constant
전망3월 has constant value ""Constant
등록일자 has constant value ""Constant
행정동코드 has unique valuesUnique
주소 has unique valuesUnique

Reproduction

Analysis started2024-04-17 09:34:12.696700
Analysis finished2024-04-17 09:34:13.356314
Duration0.66 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

전망월
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2020-09-01 00:00:00
Maximum2020-09-01 00:00:00
2024-04-17T18:34:13.390289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T18:34:13.458445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

행정동코드
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.1767797 × 109
Minimum4.159053 × 109
Maximum4.2130635 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-04-17T18:34:13.554045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4.159053 × 109
5-th percentile4.1590584 × 109
Q14.1630528 × 109
median4.1670365 × 109
Q34.1830332 × 109
95-th percentile4.2111533 × 109
Maximum4.2130635 × 109
Range54010500
Interquartile range (IQR)19980500

Descriptive statistics

Standard deviation17849420
Coefficient of variation (CV)0.0042734885
Kurtosis-0.19773637
Mean4.1767797 × 109
Median Absolute Deviation (MAD)7978750
Skewness1.0504443
Sum4.1767797 × 1011
Variance3.1860179 × 1014
MonotonicityNot monotonic
2024-04-17T18:34:13.670889image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4213060000 1
 
1.0%
4180034000 1
 
1.0%
4182035000 1
 
1.0%
4182034000 1
 
1.0%
4182033000 1
 
1.0%
4182032500 1
 
1.0%
4182031000 1
 
1.0%
4182025000 1
 
1.0%
4180038000 1
 
1.0%
4180037000 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
4159053000 1
1.0%
4159054000 1
1.0%
4159055000 1
1.0%
4159056000 1
1.0%
4159057000 1
1.0%
4159058500 1
1.0%
4159058600 1
1.0%
4159058700 1
1.0%
4161025000 1
1.0%
4161025300 1
1.0%
ValueCountFrequency (%)
4213063500 1
1.0%
4213062000 1
1.0%
4213061000 1
1.0%
4213060000 1
1.0%
4213059000 1
1.0%
4211053000 1
1.0%
4211052000 1
1.0%
4211040000 1
1.0%
4211039000 1
1.0%
4211038000 1
1.0%

주소
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2024-04-17T18:34:13.850149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length9
Mean length9.05
Min length8

Characters and Unicode

Total characters905
Distinct characters98
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique100 ?
Unique (%)100.0%

Sample

1st row강원도원주시우산동
2nd row강원도원주시태장1동
3rd row강원도원주시태장2동
4th row강원도원주시봉산동
5th row경기도화성시병점1동
ValueCountFrequency (%)
강원도원주시우산동 1
 
1.0%
경기도연천군청산면 1
 
1.0%
경기도가평군하면 1
 
1.0%
경기도가평군상면 1
 
1.0%
경기도가평군청평면 1
 
1.0%
경기도가평군설악면 1
 
1.0%
경기도가평군가평읍 1
 
1.0%
경기도연천군장남면 1
 
1.0%
경기도연천군중면 1
 
1.0%
경기도연천군신서면 1
 
1.0%
Other values (90) 90
90.0%
2024-04-17T18:34:14.151238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
도 101
 
11.2%
경 84
 
9.3%
기 84
 
9.3%
시 72
 
8.0%
면 60
 
6.6%
천 45
 
5.0%
주 40
 
4.4%
동 40
 
4.4%
군 31
 
3.4%
양 28
 
3.1%
Other values (88) 320
35.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 892
98.6%
Decimal Number 13
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 101
 
11.3%
경 84
 
9.4%
기 84
 
9.4%
시 72
 
8.1%
면 60
 
6.7%
천 45
 
5.0%
주 40
 
4.5%
동 40
 
4.5%
군 31
 
3.5%
양 28
 
3.1%
Other values (84) 307
34.4%
Decimal Number
ValueCountFrequency (%)
1 5
38.5%
2 5
38.5%
3 2
 
15.4%
4 1
 
7.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 892
98.6%
Common 13
 
1.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 101
 
11.3%
경 84
 
9.4%
기 84
 
9.4%
시 72
 
8.1%
면 60
 
6.7%
천 45
 
5.0%
주 40
 
4.5%
동 40
 
4.5%
군 31
 
3.5%
양 28
 
3.1%
Other values (84) 307
34.4%
Common
ValueCountFrequency (%)
1 5
38.5%
2 5
38.5%
3 2
 
15.4%
4 1
 
7.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 892
98.6%
ASCII 13
 
1.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
도 101
 
11.3%
경 84
 
9.4%
기 84
 
9.4%
시 72
 
8.1%
면 60
 
6.7%
천 45
 
5.0%
주 40
 
4.5%
동 40
 
4.5%
군 31
 
3.5%
양 28
 
3.1%
Other values (84) 307
34.4%
ASCII
ValueCountFrequency (%)
1 5
38.5%
2 5
38.5%
3 2
 
15.4%
4 1
 
7.7%

수원_취수구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
수원
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row수원
2nd row수원
3rd row수원
4th row수원
5th row수원

Common Values

ValueCountFrequency (%)
수원 100
100.0%

Length

2024-04-17T18:34:14.264106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T18:34:14.345037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수원 100
100.0%

전망1월
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
정상
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정상
2nd row정상
3rd row정상
4th row정상
5th row정상

Common Values

ValueCountFrequency (%)
정상 100
100.0%

Length

2024-04-17T18:34:14.438184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T18:34:14.529063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 100
100.0%

전망2월
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
정상
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정상
2nd row정상
3rd row정상
4th row정상
5th row정상

Common Values

ValueCountFrequency (%)
정상 100
100.0%

Length

2024-04-17T18:34:14.620371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T18:34:14.691850image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 100
100.0%

전망3월
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
정상
100 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row정상
2nd row정상
3rd row정상
4th row정상
5th row정상

Common Values

ValueCountFrequency (%)
정상 100
100.0%

Length

2024-04-17T18:34:14.768329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T18:34:14.842319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 100
100.0%

등록일자
Date

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
Minimum2020-12-01 00:00:00
Maximum2020-12-01 00:00:00
2024-04-17T18:34:14.904343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T18:34:14.981062image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-04-17T18:34:12.850917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-17T18:34:15.036533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동코드주소
행정동코드1.0001.000
주소1.0001.000

Missing values

2024-04-17T18:34:13.214103image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T18:34:13.319259image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

전망월행정동코드주소수원_취수구분전망1월전망2월전망3월등록일자
02020-094213060000강원도원주시우산동수원정상정상정상2020-12-01
12020-094213061000강원도원주시태장1동수원정상정상정상2020-12-01
22020-094213062000강원도원주시태장2동수원정상정상정상2020-12-01
32020-094213063500강원도원주시봉산동수원정상정상정상2020-12-01
42020-094159053000경기도화성시병점1동수원정상정상정상2020-12-01
52020-094159054000경기도화성시병점2동수원정상정상정상2020-12-01
62020-094159055000경기도화성시반월동수원정상정상정상2020-12-01
72020-094159056000경기도화성시기배동수원정상정상정상2020-12-01
82020-094159057000경기도화성시화산동수원정상정상정상2020-12-01
92020-094159058500경기도화성시동탄1동수원정상정상정상2020-12-01
전망월행정동코드주소수원_취수구분전망1월전망2월전망3월등록일자
902020-094211033000강원도춘천시신동면수원정상정상정상2020-12-01
912020-094211034000강원도춘천시남면수원정상정상정상2020-12-01
922020-094211035000강원도춘천시서면수원정상정상정상2020-12-01
932020-094211036000강원도춘천시사북면수원정상정상정상2020-12-01
942020-094211038000강원도춘천시북산면수원정상정상정상2020-12-01
952020-094211039000강원도춘천시동내면수원정상정상정상2020-12-01
962020-094211040000강원도춘천시남산면수원정상정상정상2020-12-01
972020-094211052000강원도춘천시교동수원정상정상정상2020-12-01
982020-094211053000강원도춘천시조운동수원정상정상정상2020-12-01
992020-094213059000강원도원주시단계동수원정상정상정상2020-12-01