Overview

Dataset statistics

Number of variables9
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory7.3 KiB
Average record size in memory74.3 B

Variable types

Categorical7
Numeric1
Text1

Alerts

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

Reproduction

Analysis started2024-04-19 06:13:36.931752
Analysis finished2024-04-19 06:13:37.405902
Duration0.47 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

전망주
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2021-04-07
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-04-07
2nd row2021-04-07
3rd row2021-04-07
4th row2021-04-07
5th row2021-04-07

Common Values

ValueCountFrequency (%)
2021-04-07 100
100.0%

Length

2024-04-19T15:13:37.466433image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:13:37.565584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-04-07 100
100.0%

행정동코드
Real number (ℝ)

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean4.3241623 × 109
Minimum4.278025 × 109
Maximum4.887032 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-04-19T15:13:37.667676image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4.278025 × 109
5-th percentile4.278032 × 109
Q14.2820296 × 109
median4.3112515 × 109
Q34.3114532 × 109
95-th percentile4.3130561 × 109
Maximum4.887032 × 109
Range6.09007 × 108
Interquartile range (IQR)29423675

Descriptive statistics

Standard deviation1.1636987 × 108
Coefficient of variation (CV)0.026911542
Kurtosis20.369945
Mean4.3241623 × 109
Median Absolute Deviation (MAD)1786000
Skewness4.63991
Sum4.3241623 × 1011
Variance1.3541948 × 1016
MonotonicityNot monotonic
2024-04-19T15:13:37.825094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
4278025300 1
 
1.0%
4311375100 1
 
1.0%
4311454000 1
 
1.0%
4311453000 1
 
1.0%
4311452000 1
 
1.0%
4311451000 1
 
1.0%
4311431000 1
 
1.0%
4311425300 1
 
1.0%
4311425000 1
 
1.0%
4311377000 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
4278025000 1
1.0%
4278025300 1
1.0%
4278025600 1
1.0%
4278025900 1
1.0%
4278031000 1
1.0%
4278032000 1
1.0%
4278033000 1
1.0%
4279025000 1
1.0%
4279031000 1
1.0%
4279032000 1
1.0%
ValueCountFrequency (%)
4887032000 1
1.0%
4887031000 1
1.0%
4887025000 1
1.0%
4886040000 1
1.0%
4313057100 1
1.0%
4313056000 1
1.0%
4313055000 1
1.0%
4313054000 1
1.0%
4313053500 1
1.0%
4313051500 1
1.0%

주소
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2024-04-19T15:13:38.036844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length17
Mean length11.38
Min length8

Characters and Unicode

Total characters1138
Distinct characters106
Distinct categories3 ?
Distinct scripts2 ?
Distinct blocks3 ?
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강원도철원군갈말읍
3rd row강원도철원군동송읍
4th row강원도철원군서면
5th row강원도철원군근남면
ValueCountFrequency (%)
강원도철원군김화읍 1
 
1.0%
충청북도청주시흥덕구복대2동 1
 
1.0%
충청북도청주시청원구내덕2동 1
 
1.0%
충청북도청주시청원구내덕1동 1
 
1.0%
충청북도청주시청원구우암동 1
 
1.0%
충청북도청주시청원구북이면 1
 
1.0%
충청북도청주시청원구오창읍 1
 
1.0%
충청북도청주시청원구내수읍 1
 
1.0%
충청북도청주시흥덕구강서제2동 1
 
1.0%
충청북도청주시흥덕구강서제1동 1
 
1.0%
Other values (90) 90
90.0%
2024-04-19T15:13:38.389029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
청 114
 
10.0%
도 101
 
8.9%
충 83
 
7.3%
북 66
 
5.8%
주 63
 
5.5%
원 63
 
5.5%
시 62
 
5.4%
면 49
 
4.3%
구 49
 
4.3%
동 40
 
3.5%
Other values (96) 448
39.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1113
97.8%
Decimal Number 15
 
1.3%
Other Punctuation 10
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 114
 
10.2%
도 101
 
9.1%
충 83
 
7.5%
북 66
 
5.9%
주 63
 
5.7%
원 63
 
5.7%
시 62
 
5.6%
면 49
 
4.4%
구 49
 
4.4%
동 40
 
3.6%
Other values (92) 423
38.0%
Decimal Number
ValueCountFrequency (%)
2 8
53.3%
1 7
46.7%
Other Punctuation
ValueCountFrequency (%)
· 6
60.0%
. 4
40.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1113
97.8%
Common 25
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 114
 
10.2%
도 101
 
9.1%
충 83
 
7.5%
북 66
 
5.9%
주 63
 
5.7%
원 63
 
5.7%
시 62
 
5.6%
면 49
 
4.4%
구 49
 
4.4%
동 40
 
3.6%
Other values (92) 423
38.0%
Common
ValueCountFrequency (%)
2 8
32.0%
1 7
28.0%
· 6
24.0%
. 4
16.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1113
97.8%
ASCII 19
 
1.7%
None 6
 
0.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
청 114
 
10.2%
도 101
 
9.1%
충 83
 
7.5%
북 66
 
5.9%
주 63
 
5.7%
원 63
 
5.7%
시 62
 
5.6%
면 49
 
4.4%
구 49
 
4.4%
동 40
 
3.6%
Other values (92) 423
38.0%
ASCII
ValueCountFrequency (%)
2 8
42.1%
1 7
36.8%
. 4
21.1%
None
ValueCountFrequency (%)
· 6
100.0%

수원_취수구분
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-19T15:13:38.527662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:13:38.616667image/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-19T15:13:38.707982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:13:38.793430image/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-19T15:13:38.895137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:13:39.013781image/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-19T15:13:39.126401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:13:39.210248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 100
100.0%

전망4주
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-19T15:13:39.299471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:13:39.390828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정상 100
100.0%

등록일자
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2021-04-07
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-04-07
2nd row2021-04-07
3rd row2021-04-07
4th row2021-04-07
5th row2021-04-07

Common Values

ValueCountFrequency (%)
2021-04-07 100
100.0%

Length

2024-04-19T15:13:39.479302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-19T15:13:39.563807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-04-07 100
100.0%

Interactions

2024-04-19T15:13:37.074346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-19T15:13:39.617109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동코드주소
행정동코드1.0001.000
주소1.0001.000

Missing values

2024-04-19T15:13:37.194184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-19T15:13:37.358777image/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주전망4주등록일자
02021-04-074278025300강원도철원군김화읍수원정상정상정상정상2021-04-07
12021-04-074278025600강원도철원군갈말읍수원정상정상정상정상2021-04-07
22021-04-074278025900강원도철원군동송읍수원정상정상정상정상2021-04-07
32021-04-074278031000강원도철원군서면수원정상정상정상정상2021-04-07
42021-04-074278032000강원도철원군근남면수원정상정상정상정상2021-04-07
52021-04-074278033000강원도철원군근북면수원정상정상정상정상2021-04-07
62021-04-074279025000강원도화천군화천읍수원정상정상정상정상2021-04-07
72021-04-074279031000강원도화천군간동면수원정상정상정상정상2021-04-07
82021-04-074279032000강원도화천군하남면수원정상정상정상정상2021-04-07
92021-04-074279033000강원도화천군상서면수원정상정상정상정상2021-04-07
전망주행정동코드주소수원_취수구분전망1주전망2주전망3주전망4주등록일자
902021-04-074313053500충청북도충주시교현·안림동수원정상정상정상정상2021-04-07
912021-04-074313054000충청북도충주시교현2동수원정상정상정상정상2021-04-07
922021-04-074313055000충청북도충주시용산동수원정상정상정상정상2021-04-07
932021-04-074313056000충청북도충주시지현동수원정상정상정상정상2021-04-07
942021-04-074313057100충청북도충주시문화동수원정상정상정상정상2021-04-07
952021-04-074886040000경상남도산청군신등면수원정상정상정상정상2021-04-07
962021-04-074887025000경상남도함양군함양읍수원정상정상정상정상2021-04-07
972021-04-074887031000경상남도함양군마천면수원정상정상정상정상2021-04-07
982021-04-074887032000경상남도함양군휴천면수원정상정상정상정상2021-04-07
992021-04-074278025000강원도철원군철원읍수원정상정상정상정상2021-04-07