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:18:21.791960
Analysis finished2023-12-10 13:18:23.109569
Duration1.32 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
1111051500
100 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1111051500 100
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:18:23.360580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1111051500 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:18:23.644048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:18:23.924858image/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:18:24.161267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:18:24.404508image/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 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:18:24.709511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T22:18:24.902531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청운효자동 100
100.0%

기준일자
Real number (ℝ)

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

Quantile statistics

Minimum20200301
5-th percentile20200301
Q120200302
median20200304
Q320200306
95-th percentile20200307
Maximum20200307
Range6
Interquartile range (IQR)4

Descriptive statistics

Standard deviation1.8908605
Coefficient of variation (CV)9.3605548 × 10-8
Kurtosis-1.1559635
Mean20200304
Median Absolute Deviation (MAD)2
Skewness-0.034702682
Sum2.0200304 × 109
Variance3.5753535
MonotonicityIncreasing
2023-12-10T22:18:25.443238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
20200305 17
17.0%
20200306 16
16.0%
20200302 15
15.0%
20200303 15
15.0%
20200304 15
15.0%
20200301 12
12.0%
20200307 10
10.0%
ValueCountFrequency (%)
20200301 12
12.0%
20200302 15
15.0%
20200303 15
15.0%
20200304 15
15.0%
20200305 17
17.0%
20200306 16
16.0%
20200307 10
10.0%
ValueCountFrequency (%)
20200307 10
10.0%
20200306 16
16.0%
20200305 17
17.0%
20200304 15
15.0%
20200303 15
15.0%
20200302 15
15.0%
20200301 12
12.0%

성별
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
F
47 
M
47 
X
6 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
F 47
47.0%
M 47
47.0%
X 6
 
6.0%

Length

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

Common Values (Plot)

2023-12-10T22:18:25.879919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 47
47.0%
m 47
47.0%
x 6
 
6.0%

연령대
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20
14 
25
14 
30
14 
35
14 
45
12 
Other values (4)
32 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20 14
14.0%
25 14
14.0%
30 14
14.0%
35 14
14.0%
45 12
12.0%
40 11
11.0%
50 9
9.0%
xx 6
6.0%
55 6
6.0%

Length

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

Common Values (Plot)

2023-12-10T22:18:26.848465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20 14
14.0%
25 14
14.0%
30 14
14.0%
35 14
14.0%
45 12
12.0%
40 11
11.0%
50 9
9.0%
xx 6
6.0%
55 6
6.0%

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

Distinct21
Distinct (%)21.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean79.938798
Minimum22.861429
Maximum213.37334
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:18:27.052119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22.861429
5-th percentile22.861429
Q145.722859
median68.584288
Q3114.30715
95-th percentile167.65048
Maximum213.37334
Range190.51191
Interquartile range (IQR)68.584288

Descriptive statistics

Standard deviation44.322215
Coefficient of variation (CV)0.55445185
Kurtosis-0.23982271
Mean79.938798
Median Absolute Deviation (MAD)30.481906
Skewness0.69581119
Sum7993.8798
Variance1964.4587
MonotonicityNot monotonic
2023-12-10T22:18:27.264157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
60.96381176 11
 
11.0%
22.86142941 8
 
8.0%
38.10238235 8
 
8.0%
30.48190588 8
 
8.0%
45.72285882 8
 
8.0%
76.2047647 7
 
7.0%
68.58428823 6
 
6.0%
99.06619411 5
 
5.0%
91.44571764 5
 
5.0%
129.54809999 4
 
4.0%
Other values (11) 30
30.0%
ValueCountFrequency (%)
22.86142941 8
8.0%
30.48190588 8
8.0%
38.10238235 8
8.0%
45.72285882 8
8.0%
53.34333529 3
 
3.0%
60.96381176 11
11.0%
68.58428823 6
6.0%
76.2047647 7
7.0%
83.82524117 2
 
2.0%
91.44571764 5
5.0%
ValueCountFrequency (%)
213.37334116 1
 
1.0%
182.89143528 1
 
1.0%
167.65048234 4
4.0%
160.03000587 1
 
1.0%
144.78905293 4
4.0%
137.16857646 3
3.0%
129.54809999 4
4.0%
121.92762352 4
4.0%
114.30714705 4
4.0%
106.68667058 3
3.0%

Interactions

2023-12-10T22:18:22.462583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:18:22.096878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:18:22.611542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:18:22.271810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:18:27.401596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자성별연령대소비인구(명)
기준일자1.0000.0000.0000.000
성별0.0001.0000.9230.000
연령대0.0000.9231.0000.603
소비인구(명)0.0000.0000.6031.000
2023-12-10T22:18:27.547182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
성별연령대
성별1.0000.655
연령대0.6551.000
2023-12-10T22:18:27.708627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자소비인구(명)성별연령대
기준일자1.0000.1360.0000.000
소비인구(명)0.1361.0000.0000.318
성별0.0000.0001.0000.655
연령대0.0000.3180.6551.000

Missing values

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

행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
01111051500서울특별시종로구청운효자동20200301F2091.445718
11111051500서울특별시종로구청운효자동20200301F2583.825241
21111051500서울특별시종로구청운효자동20200301F3053.343335
31111051500서울특별시종로구청운효자동20200301F3560.963812
41111051500서울특별시종로구청운효자동20200301F4530.481906
51111051500서울특별시종로구청운효자동20200301M2045.722859
61111051500서울특별시종로구청운효자동20200301M25182.891435
71111051500서울특별시종로구청운효자동20200301M30129.5481
81111051500서울특별시종로구청운효자동20200301M3560.963812
91111051500서울특별시종로구청운효자동20200301M4030.481906
행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
901111051500서울특별시종로구청운효자동20200307F20121.927624
911111051500서울특별시종로구청운효자동20200307F25213.373341
921111051500서울특별시종로구청운효자동20200307F3091.445718
931111051500서울특별시종로구청운효자동20200307F3576.204765
941111051500서울특별시종로구청운효자동20200307F4545.722859
951111051500서울특별시종로구청운효자동20200307F5060.963812
961111051500서울특별시종로구청운효자동20200307M2099.066194
971111051500서울특별시종로구청운효자동20200307M25144.789053
981111051500서울특별시종로구청운효자동20200307M30114.307147
991111051500서울특별시종로구청운효자동20200307M3591.445718