Overview

Dataset statistics

Number of variables4
Number of observations39
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.4 KiB
Average record size in memory37.4 B

Variable types

Categorical2
Text1
Numeric1

Dataset

Description자치구코드,자치구명,법정동명,업소수
Author성북구
URLhttps://data.seoul.go.kr/dataList/OA-11123/S/1/datasetView.do

Alerts

자치구코드 has constant value ""Constant
자치구명 has constant value ""Constant
법정동명 has unique valuesUnique

Reproduction

Analysis started2024-05-03 21:31:39.049484
Analysis finished2024-05-03 21:31:40.255799
Duration1.21 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치구코드
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
3070000
39 

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row3070000
2nd row3070000
3rd row3070000
4th row3070000
5th row3070000

Common Values

ValueCountFrequency (%)
3070000 39
100.0%

Length

2024-05-03T21:31:40.500872image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T21:31:41.061987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
3070000 39
100.0%

자치구명
Categorical

CONSTANT 

Distinct1
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size444.0 B
성북구
39 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성북구
2nd row성북구
3rd row성북구
4th row성북구
5th row성북구

Common Values

ValueCountFrequency (%)
성북구 39
100.0%

Length

2024-05-03T21:31:41.585828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T21:31:41.975927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성북구 39
100.0%

법정동명
Text

UNIQUE 

Distinct39
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size444.0 B
2024-05-03T21:31:42.771981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length5
Mean length4.7692308
Min length3

Characters and Unicode

Total characters186
Distinct characters32
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

Unique39 ?
Unique (%)100.0%

Sample

1st row길음동
2nd row돈암동
3rd row동선동1가
4th row동선동2가
5th row동선동3가
ValueCountFrequency (%)
길음동 1
 
2.6%
보문동7가 1
 
2.6%
삼선동2가 1
 
2.6%
삼선동3가 1
 
2.6%
삼선동4가 1
 
2.6%
삼선동5가 1
 
2.6%
상월곡동 1
 
2.6%
석관동 1
 
2.6%
성북동 1
 
2.6%
삼선동1가 1
 
2.6%
Other values (29) 29
74.4%
2024-05-03T21:31:44.189698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 51
27.4%
가 30
16.1%
문 14
 
7.5%
선 10
 
5.4%
보 7
 
3.8%
소 7
 
3.8%
암 7
 
3.8%
1 6
 
3.2%
2 5
 
2.7%
3 5
 
2.7%
Other values (22) 44
23.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 156
83.9%
Decimal Number 30
 
16.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 51
32.7%
가 30
19.2%
문 14
 
9.0%
선 10
 
6.4%
보 7
 
4.5%
소 7
 
4.5%
암 7
 
4.5%
삼 5
 
3.2%
안 5
 
3.2%
북 2
 
1.3%
Other values (15) 18
 
11.5%
Decimal Number
ValueCountFrequency (%)
1 6
20.0%
2 5
16.7%
3 5
16.7%
5 5
16.7%
4 5
16.7%
7 2
 
6.7%
6 2
 
6.7%

Most occurring scripts

ValueCountFrequency (%)
Hangul 156
83.9%
Common 30
 
16.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 51
32.7%
가 30
19.2%
문 14
 
9.0%
선 10
 
6.4%
보 7
 
4.5%
소 7
 
4.5%
암 7
 
4.5%
삼 5
 
3.2%
안 5
 
3.2%
북 2
 
1.3%
Other values (15) 18
 
11.5%
Common
ValueCountFrequency (%)
1 6
20.0%
2 5
16.7%
3 5
16.7%
5 5
16.7%
4 5
16.7%
7 2
 
6.7%
6 2
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 156
83.9%
ASCII 30
 
16.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 51
32.7%
가 30
19.2%
문 14
 
9.0%
선 10
 
6.4%
보 7
 
4.5%
소 7
 
4.5%
암 7
 
4.5%
삼 5
 
3.2%
안 5
 
3.2%
북 2
 
1.3%
Other values (15) 18
 
11.5%
ASCII
ValueCountFrequency (%)
1 6
20.0%
2 5
16.7%
3 5
16.7%
5 5
16.7%
4 5
16.7%
7 2
 
6.7%
6 2
 
6.7%

업소수
Real number (ℝ)

Distinct38
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean202.61538
Minimum12
Maximum1037
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size483.0 B
2024-05-03T21:31:44.810650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum12
5-th percentile23.4
Q147
median82
Q3205
95-th percentile729.1
Maximum1037
Range1025
Interquartile range (IQR)158

Descriptive statistics

Standard deviation261.42269
Coefficient of variation (CV)1.2902411
Kurtosis2.3355957
Mean202.61538
Median Absolute Deviation (MAD)45
Skewness1.807421
Sum7902
Variance68341.822
MonotonicityNot monotonic
2024-05-03T21:31:45.449486image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=38)
ValueCountFrequency (%)
43 2
 
5.1%
82 1
 
2.6%
127 1
 
2.6%
30 1
 
2.6%
86 1
 
2.6%
124 1
 
2.6%
146 1
 
2.6%
610 1
 
2.6%
240 1
 
2.6%
56 1
 
2.6%
Other values (28) 28
71.8%
ValueCountFrequency (%)
12 1
2.6%
18 1
2.6%
24 1
2.6%
30 1
2.6%
35 1
2.6%
36 1
2.6%
38 1
2.6%
39 1
2.6%
43 2
5.1%
51 1
2.6%
ValueCountFrequency (%)
1037 1
2.6%
847 1
2.6%
716 1
2.6%
645 1
2.6%
615 1
2.6%
610 1
2.6%
530 1
2.6%
371 1
2.6%
240 1
2.6%
237 1
2.6%

Interactions

2024-05-03T21:31:39.336888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-03T21:31:45.794658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
법정동명업소수
법정동명1.0001.000
업소수1.0001.000

Missing values

2024-05-03T21:31:39.829539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-03T21:31:40.136645image/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

자치구코드자치구명법정동명업소수
03070000성북구길음동645
13070000성북구돈암동237
23070000성북구동선동1가371
33070000성북구동선동2가173
43070000성북구동선동3가93
53070000성북구동선동4가91
63070000성북구동선동5가66
73070000성북구동소문동1가59
83070000성북구동소문동2가103
93070000성북구동소문동3가24
자치구코드자치구명법정동명업소수
293070000성북구성북동1가82
303070000성북구안암동1가56
313070000성북구안암동2가43
323070000성북구안암동3가35
333070000성북구안암동4가18
343070000성북구안암동5가530
353070000성북구장위동716
363070000성북구정릉동1037
373070000성북구종암동615
383070000성북구하월곡동847