Overview

Dataset statistics

Number of variables3
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory26.3 B

Variable types

Numeric1
Categorical1
Text1

Alerts

행정동 코드 is highly overall correlated with 시도명High correlation
시도명 is highly overall correlated with 행정동 코드High correlation
행정동 코드 has unique valuesUnique
시군구명 has unique valuesUnique

Reproduction

Analysis started2023-12-10 13:11:42.868576
Analysis finished2023-12-10 13:11:43.446733
Duration0.58 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정동 코드
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2.765232 × 109
Minimum1.100101 × 109
Maximum3.5101 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:11:43.571692image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.100101 × 109
5-th percentile1.100601 × 109
Q12.220375 × 109
median3.21025 × 109
Q33.320525 × 109
95-th percentile3.421105 × 109
Maximum3.5101 × 109
Range2.409999 × 109
Interquartile range (IQR)1.10015 × 109

Descriptive statistics

Standard deviation8.6470842 × 108
Coefficient of variation (CV)0.31270737
Kurtosis-0.1711789
Mean2.765232 × 109
Median Absolute Deviation (MAD)1.105 × 108
Skewness-1.2514618
Sum2.765232 × 1011
Variance7.4772065 × 1017
MonotonicityStrictly increasing
2023-12-10T22:11:43.811923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1100101000 1
 
1.0%
3221300000 1
 
1.0%
3320500000 1
 
1.0%
3320400000 1
 
1.0%
3320300000 1
 
1.0%
3320200000 1
 
1.0%
3320100000 1
 
1.0%
3310100000 1
 
1.0%
3240100000 1
 
1.0%
3230100000 1
 
1.0%
Other values (90) 90
90.0%
ValueCountFrequency (%)
1100101000 1
1.0%
1100202000 1
1.0%
1100303000 1
1.0%
1100404000 1
1.0%
1100505000 1
1.0%
1100606000 1
1.0%
1100707000 1
1.0%
1100808000 1
1.0%
1100909000 1
1.0%
1101010000 1
1.0%
ValueCountFrequency (%)
3510100000 1
1.0%
3421500000 1
1.0%
3421400000 1
1.0%
3421300000 1
1.0%
3421200000 1
1.0%
3421100000 1
1.0%
3421000000 1
1.0%
3420900000 1
1.0%
3420800000 1
1.0%
3420700000 1
1.0%

시도명
Categorical

HIGH CORRELATION 

Distinct8
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
함경북도
21 
함경남도
21 
평양직할시
19 
자강도
18 
양강도
12 
Other values (3)
9 

Length

Max length5
Median length4
Mean length3.97
Min length3

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row평양직할시
2nd row평양직할시
3rd row평양직할시
4th row평양직할시
5th row평양직할시

Common Values

ValueCountFrequency (%)
함경북도 21
21.0%
함경남도 21
21.0%
평양직할시 19
19.0%
자강도 18
18.0%
양강도 12
12.0%
남포특별시 7
 
7.0%
나선특별시 1
 
1.0%
평안북도 1
 
1.0%

Length

2023-12-10T22:11:44.034600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:11:44.216477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
함경북도 21
21.0%
함경남도 21
21.0%
평양직할시 19
19.0%
자강도 18
18.0%
양강도 12
12.0%
남포특별시 7
 
7.0%
나선특별시 1
 
1.0%
평안북도 1
 
1.0%

시군구명
Text

UNIQUE 

Distinct100
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
2023-12-10T22:11:44.736498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length5
Median length3
Mean length3.43
Min length3

Characters and Unicode

Total characters343
Distinct characters101
Distinct categories1 ?
Distinct scripts1 ?
Distinct blocks1 ?
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%
장진군 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%
2023-12-10T22:11:45.648242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
군 59
 
17.2%
구 30
 
8.7%
역 28
 
8.2%
시 14
 
4.1%
천 9
 
2.6%
성 8
 
2.3%
강 8
 
2.3%
원 8
 
2.3%
대 7
 
2.0%
동 6
 
1.7%
Other values (91) 166
48.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 343
100.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
군 59
 
17.2%
구 30
 
8.7%
역 28
 
8.2%
시 14
 
4.1%
천 9
 
2.6%
성 8
 
2.3%
강 8
 
2.3%
원 8
 
2.3%
대 7
 
2.0%
동 6
 
1.7%
Other values (91) 166
48.4%

Most occurring scripts

ValueCountFrequency (%)
Hangul 343
100.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
군 59
 
17.2%
구 30
 
8.7%
역 28
 
8.2%
시 14
 
4.1%
천 9
 
2.6%
성 8
 
2.3%
강 8
 
2.3%
원 8
 
2.3%
대 7
 
2.0%
동 6
 
1.7%
Other values (91) 166
48.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 343
100.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
군 59
 
17.2%
구 30
 
8.7%
역 28
 
8.2%
시 14
 
4.1%
천 9
 
2.6%
성 8
 
2.3%
강 8
 
2.3%
원 8
 
2.3%
대 7
 
2.0%
동 6
 
1.7%
Other values (91) 166
48.4%

Interactions

2023-12-10T22:11:43.080514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:11:45.843509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동 코드시도명시군구명
행정동 코드1.0001.0001.000
시도명1.0001.0001.000
시군구명1.0001.0001.000
2023-12-10T22:11:45.993175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동 코드시도명
행정동 코드1.0000.979
시도명0.9791.000

Missing values

2023-12-10T22:11:43.288897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:11:43.399229image/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

행정동 코드시도명시군구명
01100101000평양직할시대동강구역
11100202000평양직할시대성구역
21100303000평양직할시동대원구역
31100404000평양직할시낙랑구역
41100505000평양직할시역포구역
51100606000평양직할시용성구역
61100707000평양직할시만경대구역
71100808000평양직할시모란봉구역
81100909000평양직할시보통강구역
91101010000평양직할시사동구역
행정동 코드시도명시군구명
903420700000자강도시중군
913420800000자강도우시군
923420900000자강도위원군
933421000000자강도자성군
943421100000자강도장강군
953421200000자강도전천군
963421300000자강도중강군
973421400000자강도초산군
983421500000자강도화평군
993510100000평안북도신의주시