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 소비인구(명) and 1 other fieldsHigh correlation
연령대 is highly overall correlated with 성별High correlation

Reproduction

Analysis started2023-12-10 10:14:33.111554
Analysis finished2023-12-10 10:14:34.439591
Duration1.33 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-10T19:14:34.573550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:14:34.749228image/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-10T19:14:34.919341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:14:35.086153image/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-10T19:14:35.246184image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T19:14:35.408474image/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-10T19:14:35.600706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

기준일자
Real number (ℝ)

Distinct6
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20200804
Minimum20200801
Maximum20200806
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:14:35.874002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20200801
5-th percentile20200801
Q120200802
median20200804
Q320200805
95-th percentile20200806
Maximum20200806
Range5
Interquartile range (IQR)3

Descriptive statistics

Standard deviation1.5986105
Coefficient of variation (CV)7.9135986 × 10-8
Kurtosis-1.1207244
Mean20200804
Median Absolute Deviation (MAD)1
Skewness-0.10596441
Sum2.0200804 × 109
Variance2.5555556
MonotonicityNot monotonic
2023-12-10T19:14:36.073315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
20200805 21
21.0%
20200804 20
20.0%
20200803 18
18.0%
20200801 15
15.0%
20200802 15
15.0%
20200806 11
11.0%
ValueCountFrequency (%)
20200801 15
15.0%
20200802 15
15.0%
20200803 18
18.0%
20200804 20
20.0%
20200805 21
21.0%
20200806 11
11.0%
ValueCountFrequency (%)
20200806 11
11.0%
20200805 21
21.0%
20200804 20
20.0%
20200803 18
18.0%
20200802 15
15.0%
20200801 15
15.0%

성별
Categorical

HIGH CORRELATION 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
F 48
48.0%
M 47
47.0%
X 5
 
5.0%

Length

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

Common Values (Plot)

2023-12-10T19:14:36.521020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 48
48.0%
m 47
47.0%
x 5
 
5.0%

연령대
Categorical

HIGH CORRELATION 

Distinct12
Distinct (%)12.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
25
12 
50
11 
45
11 
30
11 
35
9 
Other values (7)
46 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
25 12
12.0%
50 11
11.0%
45 11
11.0%
30 11
11.0%
35 9
9.0%
40 9
9.0%
55 9
9.0%
60 8
8.0%
20 7
7.0%
xx 5
5.0%
Other values (2) 8
8.0%

Length

2023-12-10T19:14:36.846906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
25 12
12.0%
50 11
11.0%
45 11
11.0%
30 11
11.0%
35 9
9.0%
40 9
9.0%
55 9
9.0%
60 8
8.0%
20 7
7.0%
xx 5
5.0%
Other values (2) 8
8.0%

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

HIGH CORRELATION 

Distinct18
Distinct (%)18.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean56.197706
Minimum22.479082
Maximum239.77688
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T19:14:37.068452image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22.479082
5-th percentile22.479082
Q129.97211
median44.958165
Q367.437247
95-th percentile119.88844
Maximum239.77688
Range217.2978
Interquartile range (IQR)37.465137

Descriptive statistics

Standard deviation39.051267
Coefficient of variation (CV)0.69489077
Kurtosis9.5069546
Mean56.197706
Median Absolute Deviation (MAD)14.986055
Skewness2.7488135
Sum5619.7706
Variance1525.0014
MonotonicityNot monotonic
2023-12-10T19:14:37.255881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
37.465137325 18
18.0%
44.95816479 14
14.0%
29.97210986 14
14.0%
22.479082395 12
12.0%
52.451192255 8
8.0%
74.93027465 7
 
7.0%
59.94421972 7
 
7.0%
82.423302115 5
 
5.0%
67.437247185 3
 
3.0%
104.90238451 2
 
2.0%
Other values (8) 10
10.0%
ValueCountFrequency (%)
22.479082395 12
12.0%
29.97210986 14
14.0%
37.465137325 18
18.0%
44.95816479 14
14.0%
52.451192255 8
8.0%
59.94421972 7
 
7.0%
67.437247185 3
 
3.0%
74.93027465 7
 
7.0%
82.423302115 5
 
5.0%
89.91632958 2
 
2.0%
ValueCountFrequency (%)
239.77687888 1
 
1.0%
224.79082395 1
 
1.0%
217.29779649 1
 
1.0%
127.38146691 1
 
1.0%
119.88843944 2
 
2.0%
112.39541198 1
 
1.0%
104.90238451 2
 
2.0%
97.409357045 1
 
1.0%
89.91632958 2
 
2.0%
82.423302115 5
5.0%

Interactions

2023-12-10T19:14:33.754966image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:14:33.446162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:14:33.911627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T19:14:33.604731image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T19:14:37.411662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자성별연령대소비인구(명)
기준일자1.0000.0000.0000.000
성별0.0001.0000.9110.677
연령대0.0000.9111.0000.558
소비인구(명)0.0000.6770.5581.000
2023-12-10T19:14:37.586653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
성별연령대
성별1.0000.638
연령대0.6381.000
2023-12-10T19:14:37.738137image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자소비인구(명)성별연령대
기준일자1.0000.0860.0000.000
소비인구(명)0.0861.0000.5730.302
성별0.0000.5731.0000.638
연령대0.0000.3020.6381.000

Missing values

2023-12-10T19:14:34.095820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T19:14:34.331329image/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서울특별시종로구청운효자동20200804M5037.465137
11111051500서울특별시종로구청운효자동20200806M2029.97211
21111051500서울특별시종로구청운효자동20200803F2037.465137
31111051500서울특별시종로구청운효자동20200804M45104.902385
41111051500서울특별시종로구청운효자동20200805M3574.930275
51111051500서울특별시종로구청운효자동20200806F6037.465137
61111051500서울특별시종로구청운효자동20200801Xxx59.94422
71111051500서울특별시종로구청운효자동20200802Xxx44.958165
81111051500서울특별시종로구청운효자동20200803M6067.437247
91111051500서울특별시종로구청운효자동20200804M4052.451192
행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
901111051500서울특별시종로구청운효자동20200804F5037.465137
911111051500서울특별시종로구청운효자동20200804F5529.97211
921111051500서울특별시종로구청운효자동20200804F7022.479082
931111051500서울특별시종로구청운효자동20200804M2544.958165
941111051500서울특별시종로구청운효자동20200804M5522.479082
951111051500서울특별시종로구청운효자동20200804M6044.958165
961111051500서울특별시종로구청운효자동20200804M7037.465137
971111051500서울특별시종로구청운효자동20200804Xxx239.776879
981111051500서울특별시종로구청운효자동20200806M3082.423302
991111051500서울특별시종로구청운효자동20200806M2597.409357