Overview

Dataset statistics

Number of variables5
Number of observations79
Missing cells79
Missing cells (%)20.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.4 KiB
Average record size in memory44.7 B

Variable types

Numeric2
Categorical2
Unsupported1

Dataset

Description공간id,자치구명,면적,기타,일련번호
Author서울특별시
URLhttps://data.seoul.go.kr/dataList/OA-21177/S/1/datasetView.do

Alerts

기타 has constant value ""Constant
공간id is highly overall correlated with 일련번호High correlation
일련번호 is highly overall correlated with 공간id and 1 other fieldsHigh correlation
자치구명 is highly overall correlated with 일련번호High correlation
면적 has 79 (100.0%) missing valuesMissing
공간id has unique valuesUnique
일련번호 has unique valuesUnique
면적 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2024-05-11 07:35:25.076829
Analysis finished2024-05-11 07:35:27.998235
Duration2.92 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

공간id
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct79
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean19871.924
Minimum19599
Maximum19917
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size843.0 B
2024-05-11T07:35:28.246006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum19599
5-th percentile19842.9
Q119858.5
median19878
Q319897.5
95-th percentile19913.1
Maximum19917
Range318
Interquartile range (IQR)39

Descriptive statistics

Standard deviation49.396816
Coefficient of variation (CV)0.0024857591
Kurtosis22.604591
Mean19871.924
Median Absolute Deviation (MAD)20
Skewness-4.3217181
Sum1569882
Variance2440.0454
MonotonicityStrictly increasing
2024-05-11T07:35:28.711512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
19599 1
 
1.3%
19600 1
 
1.3%
19897 1
 
1.3%
19896 1
 
1.3%
19895 1
 
1.3%
19894 1
 
1.3%
19893 1
 
1.3%
19892 1
 
1.3%
19891 1
 
1.3%
19890 1
 
1.3%
Other values (69) 69
87.3%
ValueCountFrequency (%)
19599 1
1.3%
19600 1
1.3%
19841 1
1.3%
19842 1
1.3%
19843 1
1.3%
19844 1
1.3%
19845 1
1.3%
19846 1
1.3%
19847 1
1.3%
19848 1
1.3%
ValueCountFrequency (%)
19917 1
1.3%
19916 1
1.3%
19915 1
1.3%
19914 1
1.3%
19913 1
1.3%
19912 1
1.3%
19911 1
1.3%
19910 1
1.3%
19909 1
1.3%
19908 1
1.3%

자치구명
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)8.9%
Missing0
Missing (%)0.0%
Memory size764.0 B
서초구
43 
강남구
25 
서대문구
6 
동대문구
 
2
도봉구
 
1
Other values (2)
 
2

Length

Max length4
Median length3
Mean length3.1012658
Min length3

Unique

Unique3 ?
Unique (%)3.8%

Sample

1st row서초구
2nd row서초구
3rd row서초구
4th row서초구
5th row서초구

Common Values

ValueCountFrequency (%)
서초구 43
54.4%
강남구 25
31.6%
서대문구 6
 
7.6%
동대문구 2
 
2.5%
도봉구 1
 
1.3%
은평구 1
 
1.3%
강서구 1
 
1.3%

Length

2024-05-11T07:35:29.119655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T07:35:29.506120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서초구 43
54.4%
강남구 25
31.6%
서대문구 6
 
7.6%
동대문구 2
 
2.5%
도봉구 1
 
1.3%
은평구 1
 
1.3%
강서구 1
 
1.3%

면적
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing79
Missing (%)100.0%
Memory size843.0 B

기타
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size764.0 B
SD913
79 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
SD913 79
100.0%

Length

2024-05-11T07:35:30.086732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-05-11T07:35:30.527609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
sd913 79
100.0%

일련번호
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct79
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean40
Minimum1
Maximum79
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size843.0 B
2024-05-11T07:35:31.172746image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.9
Q120.5
median40
Q359.5
95-th percentile75.1
Maximum79
Range78
Interquartile range (IQR)39

Descriptive statistics

Standard deviation22.949219
Coefficient of variation (CV)0.57373048
Kurtosis-1.2
Mean40
Median Absolute Deviation (MAD)20
Skewness0
Sum3160
Variance526.66667
MonotonicityNot monotonic
2024-05-11T07:35:31.734591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
6 1
 
1.3%
7 1
 
1.3%
64 1
 
1.3%
63 1
 
1.3%
62 1
 
1.3%
61 1
 
1.3%
60 1
 
1.3%
59 1
 
1.3%
58 1
 
1.3%
57 1
 
1.3%
Other values (69) 69
87.3%
ValueCountFrequency (%)
1 1
1.3%
2 1
1.3%
3 1
1.3%
4 1
1.3%
5 1
1.3%
6 1
1.3%
7 1
1.3%
8 1
1.3%
9 1
1.3%
10 1
1.3%
ValueCountFrequency (%)
79 1
1.3%
78 1
1.3%
77 1
1.3%
76 1
1.3%
75 1
1.3%
74 1
1.3%
73 1
1.3%
72 1
1.3%
71 1
1.3%
70 1
1.3%

Interactions

2024-05-11T07:35:26.602983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:35:26.096929image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:35:26.950807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-05-11T07:35:26.369791image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-05-11T07:35:32.032812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공간id자치구명일련번호
공간id1.0000.6010.860
자치구명0.6011.0000.792
일련번호0.8600.7921.000
2024-05-11T07:35:32.349690image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공간id일련번호자치구명
공간id1.0000.6440.454
일련번호0.6441.0000.551
자치구명0.4540.5511.000

Missing values

2024-05-11T07:35:27.536080image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-05-11T07:35:27.888063image/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

공간id자치구명면적기타일련번호
019599서초구<NA>SD9136
119600서초구<NA>SD9137
219841서초구<NA>SD9138
319842서초구<NA>SD9139
419843서초구<NA>SD91310
519844서초구<NA>SD91311
619845서초구<NA>SD91312
719846서초구<NA>SD91313
819847서초구<NA>SD91314
919848서초구<NA>SD91315
공간id자치구명면적기타일련번호
6919908강남구<NA>SD91375
7019909강남구<NA>SD91376
7119910강남구<NA>SD91377
7219911강남구<NA>SD91378
7319912강남구<NA>SD91379
7419913서초구<NA>SD9131
7519914서초구<NA>SD9132
7619915서초구<NA>SD9133
7719916서초구<NA>SD9134
7819917서초구<NA>SD9135