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-11124/S/1/datasetView.do

Alerts

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

Reproduction

Analysis started2024-05-03 22:26:56.169625
Analysis finished2024-05-03 22:26:57.365378
Duration1.2 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-03T22:26:57.579255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T22:26:57.980650image/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-03T22:26:58.257861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-03T22:26:58.532279image/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-03T22:26:59.025773image/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-03T22:27:00.039050image/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 (ℝ)

Distinct26
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean45.769231
Minimum1
Maximum224
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size483.0 B
2024-05-03T22:27:00.505524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4
Q112
median20
Q338
95-th percentile183.9
Maximum224
Range223
Interquartile range (IQR)26

Descriptive statistics

Standard deviation60.453315
Coefficient of variation (CV)1.3208287
Kurtosis2.2422137
Mean45.769231
Median Absolute Deviation (MAD)10
Skewness1.8681209
Sum1785
Variance3654.6032
MonotonicityNot monotonic
2024-05-03T22:27:01.013761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
17 3
 
7.7%
14 3
 
7.7%
37 2
 
5.1%
39 2
 
5.1%
20 2
 
5.1%
12 2
 
5.1%
10 2
 
5.1%
8 2
 
5.1%
155 2
 
5.1%
4 2
 
5.1%
Other values (16) 17
43.6%
ValueCountFrequency (%)
1 1
 
2.6%
4 2
5.1%
6 1
 
2.6%
8 2
5.1%
10 2
5.1%
11 1
 
2.6%
12 2
5.1%
14 3
7.7%
15 1
 
2.6%
17 3
7.7%
ValueCountFrequency (%)
224 1
2.6%
201 1
2.6%
182 1
2.6%
155 2
5.1%
152 1
2.6%
78 2
5.1%
39 2
5.1%
37 2
5.1%
33 1
2.6%
29 1
2.6%

Interactions

2024-05-03T22:26:56.367831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

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

Missing values

2024-05-03T22:26:56.773132image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-03T22:26:57.207413image/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성북구길음동152
13070000성북구돈암동78
23070000성북구동선동1가78
33070000성북구동선동2가37
43070000성북구동선동3가11
53070000성북구동선동4가39
63070000성북구동선동5가20
73070000성북구동소문동1가12
83070000성북구동소문동2가10
93070000성북구동소문동3가8
자치구코드자치구명법정동명업소수
293070000성북구성북동1가14
303070000성북구안암동1가15
313070000성북구안암동2가14
323070000성북구안암동3가6
333070000성북구안암동4가4
343070000성북구안암동5가33
353070000성북구장위동182
363070000성북구정릉동224
373070000성북구종암동155
383070000성북구하월곡동201