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
행정동코드 is highly overall correlated with 행정동명High correlation
행정동명 is highly overall correlated with 행정동코드High correlation
성별 is highly overall correlated with 연령대High correlation
연령대 is highly overall correlated with 성별High correlation

Reproduction

Analysis started2023-12-10 12:07:47.086929
Analysis finished2023-12-10 12:07:48.537789
Duration1.45 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정동코드
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1111071000
73 
1111061500
24 
1111063000
 
3

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
1111071000 73
73.0%
1111061500 24
 
24.0%
1111063000 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T21:07:48.799136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1111071000 73
73.0%
1111061500 24
 
24.0%
1111063000 3
 
3.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-10T21:07:48.989009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T21:07:49.120589image/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-10T21:07:49.245902image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

행정동명
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
숭인2동
73 
종로1.2.3.4가동
24 
종로5.6가동
 
3

Length

Max length11
Median length4
Mean length5.77
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row종로1.2.3.4가동
2nd row종로1.2.3.4가동
3rd row종로1.2.3.4가동
4th row종로1.2.3.4가동
5th row종로1.2.3.4가동

Common Values

ValueCountFrequency (%)
숭인2동 73
73.0%
종로1.2.3.4가동 24
 
24.0%
종로5.6가동 3
 
3.0%

Length

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

Common Values (Plot)

2023-12-10T21:07:49.664317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
숭인2동 73
73.0%
종로1.2.3.4가동 24
 
24.0%
종로5.6가동 3
 
3.0%

기준일자
Real number (ℝ)

Distinct60
Distinct (%)60.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20200378
Minimum20200301
Maximum20200527
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:07:49.825701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20200301
5-th percentile20200304
Q120200316
median20200402
Q320200419
95-th percentile20200518
Maximum20200527
Range226
Interquartile range (IQR)103.5

Descriptive statistics

Standard deviation66.35731
Coefficient of variation (CV)3.2849539 × 10-6
Kurtosis-0.58210025
Mean20200378
Median Absolute Deviation (MAD)75
Skewness0.58431131
Sum2.0200378 × 109
Variance4403.2925
MonotonicityNot monotonic
2023-12-10T21:07:50.035196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20200321 4
 
4.0%
20200315 3
 
3.0%
20200405 3
 
3.0%
20200412 3
 
3.0%
20200425 3
 
3.0%
20200329 3
 
3.0%
20200301 3
 
3.0%
20200312 3
 
3.0%
20200424 3
 
3.0%
20200309 3
 
3.0%
Other values (50) 69
69.0%
ValueCountFrequency (%)
20200301 3
3.0%
20200303 1
 
1.0%
20200304 2
2.0%
20200305 1
 
1.0%
20200307 2
2.0%
20200308 2
2.0%
20200309 3
3.0%
20200310 1
 
1.0%
20200311 1
 
1.0%
20200312 3
3.0%
ValueCountFrequency (%)
20200527 1
1.0%
20200522 1
1.0%
20200520 2
2.0%
20200519 1
1.0%
20200518 1
1.0%
20200512 1
1.0%
20200511 1
1.0%
20200503 2
2.0%
20200430 1
1.0%
20200429 1
1.0%

성별
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
M
81 
F
17 
X
 
2

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
M 81
81.0%
F 17
 
17.0%
X 2
 
2.0%

Length

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

Common Values (Plot)

2023-12-10T21:07:50.354495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
m 81
81.0%
f 17
 
17.0%
x 2
 
2.0%

연령대
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
70
48 
60
14 
65
13 
55
11 
25
5 
Other values (6)
9 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique3 ?
Unique (%)3.0%

Sample

1st row45
2nd row70
3rd row25
4th row55
5th row35

Common Values

ValueCountFrequency (%)
70 48
48.0%
60 14
 
14.0%
65 13
 
13.0%
55 11
 
11.0%
25 5
 
5.0%
35 2
 
2.0%
xx 2
 
2.0%
40 2
 
2.0%
45 1
 
1.0%
30 1
 
1.0%

Length

2023-12-10T21:07:50.479174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
70 48
48.0%
60 14
 
14.0%
65 13
 
13.0%
55 11
 
11.0%
25 5
 
5.0%
35 2
 
2.0%
xx 2
 
2.0%
40 2
 
2.0%
45 1
 
1.0%
30 1
 
1.0%

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

Distinct7
Distinct (%)7.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean30.558111
Minimum22.861429
Maximum68.584288
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:07:50.590273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22.861429
5-th percentile22.861429
Q122.861429
median30.481906
Q338.102382
95-th percentile46.103883
Maximum68.584288
Range45.722859
Interquartile range (IQR)15.240953

Descriptive statistics

Standard deviation10.014975
Coefficient of variation (CV)0.32773542
Kurtosis2.7374565
Mean30.558111
Median Absolute Deviation (MAD)7.6204765
Skewness1.6159469
Sum3055.8111
Variance100.29973
MonotonicityNot monotonic
2023-12-10T21:07:50.751888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
22.86142941 48
48.0%
30.48190588 24
24.0%
38.10238235 17
 
17.0%
45.72285882 6
 
6.0%
60.96381176 3
 
3.0%
53.34333529 1
 
1.0%
68.58428823 1
 
1.0%
ValueCountFrequency (%)
22.86142941 48
48.0%
30.48190588 24
24.0%
38.10238235 17
 
17.0%
45.72285882 6
 
6.0%
53.34333529 1
 
1.0%
60.96381176 3
 
3.0%
68.58428823 1
 
1.0%
ValueCountFrequency (%)
68.58428823 1
 
1.0%
60.96381176 3
 
3.0%
53.34333529 1
 
1.0%
45.72285882 6
 
6.0%
38.10238235 17
 
17.0%
30.48190588 24
24.0%
22.86142941 48
48.0%

Interactions

2023-12-10T21:07:48.028543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:07:47.806995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:07:48.141436image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:07:47.912798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T21:07:50.870330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동코드행정동명기준일자성별연령대소비인구(명)
행정동코드1.0001.0000.7250.7360.5900.292
행정동명1.0001.0000.7250.7360.5900.292
기준일자0.7250.7251.0000.1150.0000.000
성별0.7360.7360.1151.0000.8410.000
연령대0.5900.5900.0000.8411.0000.000
소비인구(명)0.2920.2920.0000.0000.0001.000
2023-12-10T21:07:51.006610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동코드연령대성별행정동명
행정동코드1.0000.4040.3921.000
연령대0.4041.0000.7070.404
성별0.3920.7071.0000.392
행정동명1.0000.4040.3921.000
2023-12-10T21:07:51.152896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자소비인구(명)행정동코드행정동명성별연령대
기준일자1.000-0.0530.3930.3930.0500.000
소비인구(명)-0.0531.0000.1990.1990.0000.000
행정동코드0.3930.1991.0001.0000.3920.404
행정동명0.3930.1991.0001.0000.3920.404
성별0.0500.0000.3920.3921.0000.707
연령대0.0000.0000.4040.4040.7071.000

Missing values

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

행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
01111061500서울특별시종로구종로1.2.3.4가동20200315F4522.861429
11111061500서울특별시종로구종로1.2.3.4가동20200520F7022.861429
21111061500서울특별시종로구종로1.2.3.4가동20200309F2522.861429
31111061500서울특별시종로구종로1.2.3.4가동20200520M5522.861429
41111061500서울특별시종로구종로1.2.3.4가동20200321M3530.481906
51111061500서울특별시종로구종로1.2.3.4가동20200527Xxx22.861429
61111061500서울특별시종로구종로1.2.3.4가동20200503F7030.481906
71111061500서울특별시종로구종로1.2.3.4가동20200522F3522.861429
81111061500서울특별시종로구종로1.2.3.4가동20200428Xxx22.861429
91111061500서울특별시종로구종로1.2.3.4가동20200511M2522.861429
행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
901111071000서울특별시종로구숭인2동20200401M7030.481906
911111071000서울특별시종로구숭인2동20200423M6522.861429
921111071000서울특별시종로구숭인2동20200423M7030.481906
931111071000서울특별시종로구숭인2동20200424F7030.481906
941111071000서울특별시종로구숭인2동20200331M7038.102382
951111071000서울특별시종로구숭인2동20200307M7045.722859
961111071000서울특별시종로구숭인2동20200307F6022.861429
971111071000서울특별시종로구숭인2동20200425M6030.481906
981111071000서울특별시종로구숭인2동20200305M6522.861429
991111071000서울특별시종로구숭인2동20200301M5522.861429