Overview

Dataset statistics

Number of variables8
Number of observations100
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.7 KiB
Average record size in memory68.3 B

Variable types

Categorical6
Numeric2

Alerts

행정동코드 has constant value ""Constant
시도명 has constant value ""Constant
시군구명 has constant value ""Constant
행정동명 has constant value ""Constant
성별 is highly overall correlated with 연령대High correlation
연령대 is highly overall correlated with 성별High correlation

Reproduction

Analysis started2023-12-10 13:10:32.653200
Analysis finished2023-12-10 13:10:33.743524
Duration1.09 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정동코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1111053000
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1111053000 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:10:33.946656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1111053000 100
100.0%

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
서울특별시
100 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row서울특별시
2nd row서울특별시
3rd row서울특별시
4th row서울특별시
5th row서울특별시

Common Values

ValueCountFrequency (%)
서울특별시 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:10:34.327375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서울특별시 100
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
종로구
100 

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 (%)
종로구 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:10:34.623374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
종로구 100
100.0%

행정동명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
사직동
100 

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 (%)
사직동 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:10:34.916143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사직동 100
100.0%

기준일자
Real number (ℝ)

Distinct8
Distinct (%)8.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20200304
Minimum20200301
Maximum20200308
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:10:35.055382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20200301
5-th percentile20200301
Q120200303
median20200304
Q320200306
95-th percentile20200308
Maximum20200308
Range7
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.0801127
Coefficient of variation (CV)1.0297432 × 10-7
Kurtosis-1.0932097
Mean20200304
Median Absolute Deviation (MAD)2
Skewness0.060532077
Sum2.0200304 × 109
Variance4.3268687
MonotonicityNot monotonic
2023-12-10T22:10:35.254787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
20200304 16
16.0%
20200303 15
15.0%
20200302 14
14.0%
20200307 14
14.0%
20200305 13
13.0%
20200306 13
13.0%
20200301 8
8.0%
20200308 7
7.0%
ValueCountFrequency (%)
20200301 8
8.0%
20200302 14
14.0%
20200303 15
15.0%
20200304 16
16.0%
20200305 13
13.0%
20200306 13
13.0%
20200307 14
14.0%
20200308 7
7.0%
ValueCountFrequency (%)
20200308 7
7.0%
20200307 14
14.0%
20200306 13
13.0%
20200305 13
13.0%
20200304 16
16.0%
20200303 15
15.0%
20200302 14
14.0%
20200301 8
8.0%

성별
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
M
52 
F
41 
X
7 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowF
2nd rowM
3rd rowM
4th rowM
5th rowM

Common Values

ValueCountFrequency (%)
M 52
52.0%
F 41
41.0%
X 7
 
7.0%

Length

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

Common Values (Plot)

2023-12-10T22:10:35.655465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
m 52
52.0%
f 41
41.0%
x 7
 
7.0%

연령대
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)10.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
40
14 
30
14 
20
13 
25
13 
45
13 
Other values (5)
33 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row40
2nd row20
3rd row25
4th row30
5th row40

Common Values

ValueCountFrequency (%)
40 14
14.0%
30 14
14.0%
20 13
13.0%
25 13
13.0%
45 13
13.0%
35 13
13.0%
50 8
8.0%
xx 7
7.0%
60 3
 
3.0%
15 2
 
2.0%

Length

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

Common Values (Plot)

2023-12-10T22:10:36.045001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
40 14
14.0%
30 14
14.0%
20 13
13.0%
25 13
13.0%
45 13
13.0%
35 13
13.0%
50 8
8.0%
xx 7
7.0%
60 3
 
3.0%
15 2
 
2.0%

소비인구(명)
Real number (ℝ)

Distinct18
Distinct (%)18.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean58.753874
Minimum22.861429
Maximum167.65048
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:10:36.555270image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22.861429
5-th percentile22.861429
Q130.481906
median53.343335
Q378.109884
95-th percentile114.68817
Maximum167.65048
Range144.78905
Interquartile range (IQR)47.627978

Descriptive statistics

Standard deviation32.535224
Coefficient of variation (CV)0.55375454
Kurtosis0.4466121
Mean58.753874
Median Absolute Deviation (MAD)22.861429
Skewness0.9648927
Sum5875.3874
Variance1058.5408
MonotonicityNot monotonic
2023-12-10T22:10:36.735258image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
30.48190588 15
15.0%
22.86142941 15
15.0%
38.10238235 10
10.0%
45.72285882 9
9.0%
53.34333529 8
8.0%
60.96381176 7
7.0%
68.58428823 7
7.0%
91.44571764 7
7.0%
106.68667058 6
 
6.0%
76.2047647 4
 
4.0%
Other values (8) 12
12.0%
ValueCountFrequency (%)
22.86142941 15
15.0%
30.48190588 15
15.0%
38.10238235 10
10.0%
45.72285882 9
9.0%
53.34333529 8
8.0%
60.96381176 7
7.0%
68.58428823 7
7.0%
76.2047647 4
 
4.0%
83.82524117 3
 
3.0%
91.44571764 7
7.0%
ValueCountFrequency (%)
167.65048234 1
 
1.0%
144.78905293 1
 
1.0%
137.16857646 1
 
1.0%
129.54809999 1
 
1.0%
121.92762352 1
 
1.0%
114.30714705 1
 
1.0%
106.68667058 6
6.0%
99.06619411 3
3.0%
91.44571764 7
7.0%
83.82524117 3
3.0%

Interactions

2023-12-10T22:10:33.204939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:10:32.916253image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:10:33.338442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:10:33.065401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:10:36.914702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자성별연령대소비인구(명)
기준일자1.0000.0000.0000.254
성별0.0001.0000.8020.544
연령대0.0000.8021.0000.353
소비인구(명)0.2540.5440.3531.000
2023-12-10T22:10:37.066964image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연령대성별
연령대1.0000.668
성별0.6681.000
2023-12-10T22:10:37.204830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자소비인구(명)성별연령대
기준일자1.000-0.1500.0000.000
소비인구(명)-0.1501.0000.3730.111
성별0.0000.3731.0000.668
연령대0.0000.1110.6681.000

Missing values

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

행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
01111053000서울특별시종로구사직동20200301F4030.481906
11111053000서울특별시종로구사직동20200301M2091.445718
21111053000서울특별시종로구사직동20200301M25144.789053
31111053000서울특별시종로구사직동20200301M3091.445718
41111053000서울특별시종로구사직동20200301M4030.481906
51111053000서울특별시종로구사직동20200301M4522.861429
61111053000서울특별시종로구사직동20200301Xxx45.722859
71111053000서울특별시종로구사직동20200302F2022.861429
81111053000서울특별시종로구사직동20200302F25137.168576
91111053000서울특별시종로구사직동20200302F3038.102382
행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
901111053000서울특별시종로구사직동20200307M5030.481906
911111053000서울특별시종로구사직동20200307Xxx45.722859
921111053000서울특별시종로구사직동20200308F2545.722859
931111053000서울특별시종로구사직동20200308F3045.722859
941111053000서울특별시종로구사직동20200308F3522.861429
951111053000서울특별시종로구사직동20200308F4030.481906
961111053000서울특별시종로구사직동20200308F4522.861429
971111053000서울특별시종로구사직동20200308M1538.102382
981111053000서울특별시종로구사직동20200308M2060.963812
991111053000서울특별시종로구사직동20200301F2022.861429