Overview

Dataset statistics

Number of variables3
Number of observations372
Missing cells1
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.2 KiB
Average record size in memory25.4 B

Variable types

Categorical1
Text1
Numeric1

Dataset

Description자치구명,행정동명,현황(개소)
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-2796/S/1/datasetView.do

Alerts

현황(개소) is highly overall correlated with 자치구명High correlation
자치구명 is highly overall correlated with 현황(개소)High correlation

Reproduction

Analysis started2023-12-11 09:21:47.322144
Analysis finished2023-12-11 09:21:47.771954
Duration0.45 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구명
Categorical

HIGH CORRELATION 

Distinct26
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Memory size3.0 KiB
송파구
27 
강서구
 
21
관악구
 
21
성동구
 
20
서초구
 
19
Other values (21)
264 

Length

Max length4
Median length3
Mean length3.0725806
Min length1

Unique

Unique1 ?
Unique (%)0.3%

Sample

1st row계
2nd row종로구
3rd row종로구
4th row종로구
5th row종로구

Common Values

ValueCountFrequency (%)
송파구 27
 
7.3%
강서구 21
 
5.6%
관악구 21
 
5.6%
성동구 20
 
5.4%
서초구 19
 
5.1%
영등포구 19
 
5.1%
양천구 19
 
5.1%
강동구 18
 
4.8%
마포구 18
 
4.8%
종로구 16
 
4.3%
Other values (16) 174
46.8%

Length

2023-12-11T18:21:47.857658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
송파구 27
 
7.3%
관악구 21
 
5.6%
강서구 21
 
5.6%
성동구 20
 
5.4%
서초구 19
 
5.1%
영등포구 19
 
5.1%
양천구 19
 
5.1%
강동구 18
 
4.8%
마포구 18
 
4.8%
종로구 16
 
4.3%
Other values (16) 174
46.8%

행정동명
Text

Distinct345
Distinct (%)93.0%
Missing1
Missing (%)0.3%
Memory size3.0 KiB
2023-12-11T18:21:48.181713image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length11
Median length7
Mean length3.5121294
Min length2

Characters and Unicode

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

Unique

Unique342 ?
Unique (%)92.2%

Sample

1st row합계
2nd row청운효자동
3rd row사직동
4th row부암동
5th row평창동
ValueCountFrequency (%)
합계 25
 
6.7%
신사동 2
 
0.5%
삼성동 2
 
0.5%
잠실4동 1
 
0.3%
당산2동 1
 
0.3%
신길3동 1
 
0.3%
신길2동 1
 
0.3%
신길1동 1
 
0.3%
문래동 1
 
0.3%
도림동 1
 
0.3%
Other values (335) 335
90.3%
2023-12-11T18:21:48.671420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 349
26.8%
2 54
 
4.1%
1 52
 
4.0%
신 35
 
2.7%
3 31
 
2.4%
계 29
 
2.2%
합 26
 
2.0%
가 23
 
1.8%
산 16
 
1.2%
4 16
 
1.2%
Other values (175) 672
51.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1127
86.5%
Decimal Number 171
 
13.1%
Other Punctuation 5
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 349
31.0%
신 35
 
3.1%
계 29
 
2.6%
합 26
 
2.3%
가 23
 
2.0%
산 16
 
1.4%
화 16
 
1.4%
곡 15
 
1.3%
수 14
 
1.2%
제 14
 
1.2%
Other values (165) 590
52.4%
Decimal Number
ValueCountFrequency (%)
2 54
31.6%
1 52
30.4%
3 31
18.1%
4 16
 
9.4%
5 7
 
4.1%
6 6
 
3.5%
7 4
 
2.3%
8 1
 
0.6%
Other Punctuation
ValueCountFrequency (%)
. 4
80.0%
, 1
 
20.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1127
86.5%
Common 176
 
13.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 349
31.0%
신 35
 
3.1%
계 29
 
2.6%
합 26
 
2.3%
가 23
 
2.0%
산 16
 
1.4%
화 16
 
1.4%
곡 15
 
1.3%
수 14
 
1.2%
제 14
 
1.2%
Other values (165) 590
52.4%
Common
ValueCountFrequency (%)
2 54
30.7%
1 52
29.5%
3 31
17.6%
4 16
 
9.1%
5 7
 
4.0%
6 6
 
3.4%
7 4
 
2.3%
. 4
 
2.3%
, 1
 
0.6%
8 1
 
0.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1127
86.5%
ASCII 176
 
13.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 349
31.0%
신 35
 
3.1%
계 29
 
2.6%
합 26
 
2.3%
가 23
 
2.0%
산 16
 
1.4%
화 16
 
1.4%
곡 15
 
1.3%
수 14
 
1.2%
제 14
 
1.2%
Other values (165) 590
52.4%
ASCII
ValueCountFrequency (%)
2 54
30.7%
1 52
29.5%
3 31
17.6%
4 16
 
9.1%
5 7
 
4.0%
6 6
 
3.4%
7 4
 
2.3%
. 4
 
2.3%
, 1
 
0.6%
8 1
 
0.6%

현황(개소)
Real number (ℝ)

HIGH CORRELATION 

Distinct41
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.422043
Minimum1
Maximum3219
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.4 KiB
2023-12-11T18:21:48.850221image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q37
95-th percentile47.9
Maximum3219
Range3218
Interquartile range (IQR)5

Descriptive statistics

Standard deviation167.27553
Coefficient of variation (CV)9.6013726
Kurtosis364.57763
Mean17.422043
Median Absolute Deviation (MAD)2
Skewness19.002532
Sum6481
Variance27981.102
MonotonicityNot monotonic
2023-12-11T18:21:49.047742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=41)
ValueCountFrequency (%)
3 63
16.9%
2 62
16.7%
4 55
14.8%
1 40
10.8%
5 32
8.6%
7 24
 
6.5%
6 21
 
5.6%
8 14
 
3.8%
9 8
 
2.2%
13 6
 
1.6%
Other values (31) 47
12.6%
ValueCountFrequency (%)
1 40
10.8%
2 62
16.7%
3 63
16.9%
4 55
14.8%
5 32
8.6%
6 21
 
5.6%
7 24
 
6.5%
8 14
 
3.8%
9 8
 
2.2%
10 2
 
0.5%
ValueCountFrequency (%)
3219 1
 
0.3%
113 1
 
0.3%
107 1
 
0.3%
101 1
 
0.3%
92 1
 
0.3%
90 1
 
0.3%
78 1
 
0.3%
74 1
 
0.3%
73 1
 
0.3%
71 3
0.8%

Interactions

2023-12-11T18:21:47.494176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T18:21:49.200465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
자치구명현황(개소)
자치구명1.0001.000
현황(개소)1.0001.000
2023-12-11T18:21:49.298992image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
현황(개소)자치구명
현황(개소)1.0000.967
자치구명0.9671.000

Missing values

2023-12-11T18:21:47.634434image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T18:21:47.732678image/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

자치구명행정동명현황(개소)
0계<NA>3219
1종로구합계43
2종로구청운효자동7
3종로구사직동3
4종로구부암동5
5종로구평창동1
6종로구무악동1
7종로구교남동1
8종로구가회동2
9종로구종로1.2.3.4가동3
자치구명행정동명현황(개소)
362강동구암사2동5
363강동구암사3동1
364강동구천호1동2
365강동구천호2동5
366강동구천호3동3
367강동구성내1동3
368강동구성내3동3
369강동구길동10
370강동구둔촌1동3
371강동구둔촌2동5