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 기준일자 and 1 other fieldsHigh correlation
행정동명 is highly overall correlated with 기준일자 and 1 other fieldsHigh correlation
기준일자 is highly overall correlated with 행정동코드 and 1 other fieldsHigh correlation
성별 is highly overall correlated with 연령대High correlation
연령대 is highly overall correlated with 성별High correlation

Reproduction

Analysis started2023-12-10 12:19:23.718949
Analysis finished2023-12-10 12:19:25.033119
Duration1.31 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정동코드
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
1111061500
52 
1111053000
48 

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 (%)
1111061500 52
52.0%
1111053000 48
48.0%

Length

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

Common Values (Plot)

2023-12-10T21:19:25.219864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1111061500 52
52.0%
1111053000 48
48.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:19:25.322382image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

행정동명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
종로1.2.3.4가동
52 
사직동
48 

Length

Max length11
Median length11
Mean length7.16
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사직동
2nd row사직동
3rd row사직동
4th row사직동
5th row사직동

Common Values

ValueCountFrequency (%)
종로1.2.3.4가동 52
52.0%
사직동 48
48.0%

Length

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

Common Values (Plot)

2023-12-10T21:19:25.966370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
종로1.2.3.4가동 52
52.0%
사직동 48
48.0%

기준일자
Real number (ℝ)

HIGH CORRELATION 

Distinct39
Distinct (%)39.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20200355
Minimum20200301
Maximum20200520
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:19:26.080961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20200301
5-th percentile20200301
Q120200305
median20200310
Q320200417
95-th percentile20200515
Maximum20200520
Range219
Interquartile range (IQR)112

Descriptive statistics

Standard deviation76.035167
Coefficient of variation (CV)3.764051 × 10-6
Kurtosis-0.15006092
Mean20200355
Median Absolute Deviation (MAD)7
Skewness1.1935548
Sum2.0200355 × 109
Variance5781.3466
MonotonicityNot monotonic
2023-12-10T21:19:26.256788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=39)
ValueCountFrequency (%)
20200304 9
 
9.0%
20200301 6
 
6.0%
20200307 6
 
6.0%
20200310 6
 
6.0%
20200306 6
 
6.0%
20200302 5
 
5.0%
20200312 4
 
4.0%
20200305 4
 
4.0%
20200417 4
 
4.0%
20200311 4
 
4.0%
Other values (29) 46
46.0%
ValueCountFrequency (%)
20200301 6
6.0%
20200302 5
5.0%
20200303 4
4.0%
20200304 9
9.0%
20200305 4
4.0%
20200306 6
6.0%
20200307 6
6.0%
20200308 4
4.0%
20200309 3
 
3.0%
20200310 6
6.0%
ValueCountFrequency (%)
20200520 1
1.0%
20200519 1
1.0%
20200518 1
1.0%
20200517 1
1.0%
20200516 1
1.0%
20200515 1
1.0%
20200513 1
1.0%
20200509 2
2.0%
20200508 2
2.0%
20200506 1
1.0%

성별
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
M
79 
F
20 
X
 
1

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
M 79
79.0%
F 20
 
20.0%
X 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T21:19:26.523279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
m 79
79.0%
f 20
 
20.0%
x 1
 
1.0%

연령대
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20
42 
25
29 
30
16 
15
5 
55
 
2
Other values (4)
6 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique2 ?
Unique (%)2.0%

Sample

1st row55
2nd row25
3rd row20
4th row20
5th row20

Common Values

ValueCountFrequency (%)
20 42
42.0%
25 29
29.0%
30 16
 
16.0%
15 5
 
5.0%
55 2
 
2.0%
35 2
 
2.0%
40 2
 
2.0%
50 1
 
1.0%
xx 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T21:19:26.766459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20 42
42.0%
25 29
29.0%
30 16
 
16.0%
15 5
 
5.0%
55 2
 
2.0%
35 2
 
2.0%
40 2
 
2.0%
50 1
 
1.0%
xx 1
 
1.0%

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

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

Quantile statistics

Minimum22.861429
5-th percentile22.861429
Q122.861429
median22.861429
Q330.481906
95-th percentile53.343335
Maximum68.584288
Range45.722859
Interquartile range (IQR)7.6204765

Descriptive statistics

Standard deviation9.8974374
Coefficient of variation (CV)0.33302438
Kurtosis2.7591066
Mean29.719858
Median Absolute Deviation (MAD)0
Skewness1.7133921
Sum2971.9858
Variance97.959268
MonotonicityNot monotonic
2023-12-10T21:19:27.028867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
22.86142941 54
54.0%
30.48190588 23
23.0%
38.10238235 12
 
12.0%
53.34333529 5
 
5.0%
45.72285882 4
 
4.0%
60.96381176 1
 
1.0%
68.58428823 1
 
1.0%
ValueCountFrequency (%)
22.86142941 54
54.0%
30.48190588 23
23.0%
38.10238235 12
 
12.0%
45.72285882 4
 
4.0%
53.34333529 5
 
5.0%
60.96381176 1
 
1.0%
68.58428823 1
 
1.0%
ValueCountFrequency (%)
68.58428823 1
 
1.0%
60.96381176 1
 
1.0%
53.34333529 5
 
5.0%
45.72285882 4
 
4.0%
38.10238235 12
 
12.0%
30.48190588 23
23.0%
22.86142941 54
54.0%

Interactions

2023-12-10T21:19:24.234467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:19:24.019747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:19:24.680120image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:19:24.135489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T21:19:27.141868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동코드행정동명기준일자성별연령대소비인구(명)
행정동코드1.0000.9990.5970.2300.3750.271
행정동명0.9991.0000.5970.2300.3750.271
기준일자0.5970.5971.0000.0000.0000.000
성별0.2300.2300.0001.0000.9320.000
연령대0.3750.3750.0000.9321.0000.000
소비인구(명)0.2710.2710.0000.0000.0001.000
2023-12-10T21:19:27.279578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연령대행정동코드행정동명성별
연령대1.0000.3610.3610.674
행정동코드0.3611.0000.9800.373
행정동명0.3610.9801.0000.373
성별0.6740.3730.3731.000
2023-12-10T21:19:27.389272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자소비인구(명)행정동코드행정동명성별연령대
기준일자1.000-0.1640.6890.6890.0000.000
소비인구(명)-0.1641.0000.2810.2810.0000.000
행정동코드0.6890.2811.0000.9800.3730.361
행정동명0.6890.2810.9801.0000.3730.361
성별0.0000.0000.3730.3731.0000.674
연령대0.0000.0000.3610.3610.6741.000

Missing values

2023-12-10T21:19:24.795316image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T21:19:24.966870image/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서울특별시종로구사직동20200430M5522.861429
11111053000서울특별시종로구사직동20200303M2522.861429
21111053000서울특별시종로구사직동20200509M2030.481906
31111053000서울특별시종로구사직동20200323M2022.861429
41111053000서울특별시종로구사직동20200320M2022.861429
51111053000서울특별시종로구사직동20200307M2522.861429
61111053000서울특별시종로구사직동20200417F2022.861429
71111053000서울특별시종로구사직동20200304M3022.861429
81111053000서울특별시종로구사직동20200508M2022.861429
91111053000서울특별시종로구사직동20200503M1522.861429
행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
901111061500서울특별시종로구종로1.2.3.4가동20200305M2538.102382
911111061500서울특별시종로구종로1.2.3.4가동20200305F2522.861429
921111061500서울특별시종로구종로1.2.3.4가동20200305F2022.861429
931111061500서울특별시종로구종로1.2.3.4가동20200311M2038.102382
941111061500서울특별시종로구종로1.2.3.4가동20200304Xxx22.861429
951111061500서울특별시종로구종로1.2.3.4가동20200304M3030.481906
961111061500서울특별시종로구종로1.2.3.4가동20200304M2553.343335
971111061500서울특별시종로구종로1.2.3.4가동20200312F3022.861429
981111061500서울특별시종로구종로1.2.3.4가동20200304M2022.861429
991111061500서울특별시종로구종로1.2.3.4가동20200301F2022.861429