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

Categorical7
Numeric1

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 started2024-04-17 13:03:38.581426
Analysis finished2024-04-17 13:03:38.950255
Duration0.37 seconds
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

2024-04-17T22:03:38.995813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T22:03:39.061118image/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

2024-04-17T22:03:39.138806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T22:03:39.218386image/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

2024-04-17T22:03:39.295840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T22:03:39.358534image/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

2024-04-17T22:03:39.426815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T22:03:39.495687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
청운효자동 100
100.0%

기준일자
Categorical

Distinct5
Distinct (%)5.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
20190803
22 
20190804
22 
20190801
21 
20190802
21 
20190805
14 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20190803 22
22.0%
20190804 22
22.0%
20190801 21
21.0%
20190802 21
21.0%
20190805 14
14.0%

Length

2024-04-17T22:03:39.563315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T22:03:39.639813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20190803 22
22.0%
20190804 22
22.0%
20190801 21
21.0%
20190802 21
21.0%
20190805 14
14.0%

성별
Categorical

HIGH CORRELATION 

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

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 52
52.0%
M 44
44.0%
X 4
 
4.0%

Length

2024-04-17T22:03:39.724912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-17T22:03:39.794649image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 52
52.0%
m 44
44.0%
x 4
 
4.0%

연령대
Categorical

HIGH CORRELATION 

Distinct13
Distinct (%)13.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
15
10 
20
10 
25
10 
30
9 
35
9 
Other values (8)
52 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)1.0%

Sample

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

Common Values

ValueCountFrequency (%)
15 10
10.0%
20 10
10.0%
25 10
10.0%
30 9
9.0%
35 9
9.0%
40 9
9.0%
45 9
9.0%
50 9
9.0%
55 9
9.0%
60 8
8.0%
Other values (3) 8
8.0%

Length

2024-04-17T22:03:39.878011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
15 10
10.0%
20 10
10.0%
25 10
10.0%
30 9
9.0%
35 9
9.0%
40 9
9.0%
45 9
9.0%
50 9
9.0%
55 9
9.0%
60 8
8.0%
Other values (3) 8
8.0%

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

Distinct40
Distinct (%)40.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean148.74
Minimum22
Maximum480
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2024-04-17T22:03:39.977766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22
5-th percentile30
Q174
median111
Q3188.5
95-th percentile406.4
Maximum480
Range458
Interquartile range (IQR)114.5

Descriptive statistics

Standard deviation113.18971
Coefficient of variation (CV)0.76099042
Kurtosis0.94498121
Mean148.74
Median Absolute Deviation (MAD)52
Skewness1.3206651
Sum14874
Variance12811.912
MonotonicityNot monotonic
2024-04-17T22:03:40.079282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=40)
ValueCountFrequency (%)
81 8
 
8.0%
96 5
 
5.0%
103 5
 
5.0%
111 5
 
5.0%
44 5
 
5.0%
59 4
 
4.0%
66 4
 
4.0%
74 4
 
4.0%
22 4
 
4.0%
163 4
 
4.0%
Other values (30) 52
52.0%
ValueCountFrequency (%)
22 4
4.0%
30 2
 
2.0%
37 2
 
2.0%
44 5
5.0%
52 3
 
3.0%
59 4
4.0%
66 4
4.0%
74 4
4.0%
81 8
8.0%
89 3
 
3.0%
ValueCountFrequency (%)
480 1
1.0%
465 1
1.0%
436 2
2.0%
414 1
1.0%
406 1
1.0%
392 1
1.0%
369 2
2.0%
347 1
1.0%
318 1
1.0%
303 1
1.0%

Interactions

2024-04-17T22:03:38.736750image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-17T22:03:40.144730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자성별연령대소비인구(명)
기준일자1.0000.0000.0000.000
성별0.0001.0000.8050.555
연령대0.0000.8051.0000.535
소비인구(명)0.0000.5550.5351.000
2024-04-17T22:03:40.220509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
성별연령대기준일자
성별1.0000.6270.000
연령대0.6271.0000.000
기준일자0.0000.0001.000
2024-04-17T22:03:40.285624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소비인구(명)기준일자성별연령대
소비인구(명)1.0000.0000.3830.248
기준일자0.0001.0000.0000.000
성별0.3830.0001.0000.627
연령대0.2480.0000.6271.000

Missing values

2024-04-17T22:03:38.825150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T22:03:38.914979image/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서울특별시종로구청운효자동20190801F1544
11111051500서울특별시종로구청운효자동20190801F2089
21111051500서울특별시종로구청운효자동20190801F25155
31111051500서울특별시종로구청운효자동20190801F30163
41111051500서울특별시종로구청운효자동20190801F3574
51111051500서울특별시종로구청운효자동20190801F40140
61111051500서울특별시종로구청운효자동20190801F45118
71111051500서울특별시종로구청운효자동20190801F5059
81111051500서울특별시종로구청운효자동20190801F5566
91111051500서울특별시종로구청운효자동20190801F6044
행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
901111051500서울특별시종로구청운효자동20190805F35111
911111051500서울특별시종로구청운효자동20190805F40163
921111051500서울특별시종로구청운효자동20190805F45133
931111051500서울특별시종로구청운효자동20190805F5096
941111051500서울특별시종로구청운효자동20190805F5552
951111051500서울특별시종로구청운효자동20190805F6022
961111051500서울특별시종로구청운효자동20190805F6530
971111051500서울특별시종로구청운효자동20190805M1566
981111051500서울특별시종로구청운효자동20190805M20347
991111051500서울특별시종로구청운효자동20190805M25436