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:16.208300
Analysis finished2023-12-10 13:18:17.756585
Duration1.55 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:17.855014image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

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

Common Values (Plot)

2023-12-10T22:18:18.893218image/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%
Mean20200803
Minimum20200801
Maximum20200806
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:18:19.016965image/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.6906158
Coefficient of variation (CV)8.3690523 × 10-8
Kurtosis-1.2608434
Mean20200803
Median Absolute Deviation (MAD)1.5
Skewness0.0031535215
Sum2.0200803 × 109
Variance2.8581818
MonotonicityNot monotonic
2023-12-10T22:18:19.217327image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
20200802 18
18.0%
20200805 18
18.0%
20200804 17
17.0%
20200801 16
16.0%
20200803 16
16.0%
20200806 15
15.0%
ValueCountFrequency (%)
20200801 16
16.0%
20200802 18
18.0%
20200803 16
16.0%
20200804 17
17.0%
20200805 18
18.0%
20200806 15
15.0%
ValueCountFrequency (%)
20200806 15
15.0%
20200805 18
18.0%
20200804 17
17.0%
20200803 16
16.0%
20200802 18
18.0%
20200801 16
16.0%

성별
Categorical

HIGH CORRELATION 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
F 51
51.0%
M 45
45.0%
X 4
 
4.0%

Length

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

Common Values (Plot)

2023-12-10T22:18:19.573628image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 51
51.0%
m 45
45.0%
x 4
 
4.0%

연령대
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
35
12 
30
12 
25
12 
20
12 
45
11 
Other values (6)
41 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
35 12
12.0%
30 12
12.0%
25 12
12.0%
20 12
12.0%
45 11
11.0%
40 11
11.0%
50 10
10.0%
55 8
8.0%
60 5
5.0%
xx 4
 
4.0%

Length

2023-12-10T22:18:19.719925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
35 12
12.0%
30 12
12.0%
25 12
12.0%
20 12
12.0%
45 11
11.0%
40 11
11.0%
50 10
10.0%
55 8
8.0%
60 5
5.0%
xx 4
 
4.0%

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

Distinct26
Distinct (%)26.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean84.071768
Minimum22.479082
Maximum382.1444
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T22:18:19.882318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum22.479082
5-th percentile22.479082
Q137.465137
median67.437247
Q3119.88844
95-th percentile194.81871
Maximum382.1444
Range359.66532
Interquartile range (IQR)82.423302

Descriptive statistics

Standard deviation62.406282
Coefficient of variation (CV)0.74229772
Kurtosis5.1763396
Mean84.071768
Median Absolute Deviation (MAD)37.465137
Skewness1.8628536
Sum8407.1768
Variance3894.5441
MonotonicityNot monotonic
2023-12-10T22:18:20.070129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)
ValueCountFrequency (%)
29.97210986 12
12.0%
22.479082395 11
 
11.0%
82.423302115 9
 
9.0%
67.437247185 8
 
8.0%
37.465137325 7
 
7.0%
119.88843944 5
 
5.0%
59.94421972 5
 
5.0%
44.95816479 5
 
5.0%
52.451192255 5
 
5.0%
74.93027465 4
 
4.0%
Other values (16) 29
29.0%
ValueCountFrequency (%)
22.479082395 11
11.0%
29.97210986 12
12.0%
37.465137325 7
7.0%
44.95816479 5
5.0%
52.451192255 5
5.0%
59.94421972 5
5.0%
67.437247185 8
8.0%
74.93027465 4
 
4.0%
82.423302115 9
9.0%
89.91632958 2
 
2.0%
ValueCountFrequency (%)
382.14440072 1
 
1.0%
277.24201621 1
 
1.0%
269.74898874 1
 
1.0%
209.80476902 1
 
1.0%
194.81871409 2
2.0%
179.83265916 1
 
1.0%
164.84660423 3
3.0%
157.35357677 1
 
1.0%
149.8605493 2
2.0%
142.36752184 2
2.0%

Interactions

2023-12-10T22:18:16.878371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:18:16.589697image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:18:17.060203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:18:16.725960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:18:20.223438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자성별연령대소비인구(명)
기준일자1.0000.0000.0000.162
성별0.0001.0000.8040.000
연령대0.0000.8041.0000.395
소비인구(명)0.1620.0000.3951.000
2023-12-10T22:18:20.403577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
성별연령대
성별1.0000.652
연령대0.6521.000
2023-12-10T22:18:20.538876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자소비인구(명)성별연령대
기준일자1.0000.1840.0000.000
소비인구(명)0.1841.0000.0000.186
성별0.0000.0001.0000.652
연령대0.0000.1860.6521.000

Missing values

2023-12-10T22:18:17.425178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:18:17.684131image/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서울특별시종로구청운효자동20200804M3582.423302
11111051500서울특별시종로구청운효자동20200806M30134.874494
21111051500서울특별시종로구청운효자동20200802M5022.479082
31111051500서울특별시종로구청운효자동20200804M30164.846604
41111051500서울특별시종로구청운효자동20200805M45119.888439
51111051500서울특별시종로구청운효자동20200806M25164.846604
61111051500서울특별시종로구청운효자동20200801M5522.479082
71111051500서울특별시종로구청운효자동20200802M4559.94422
81111051500서울특별시종로구청운효자동20200803M3544.958165
91111051500서울특별시종로구청운효자동20200804M25127.381467
행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
901111051500서울특별시종로구청운효자동20200804F3082.423302
911111051500서울특별시종로구청운효자동20200804F35134.874494
921111051500서울특별시종로구청운효자동20200804F4567.437247
931111051500서울특별시종로구청운효자동20200804F5022.479082
941111051500서울특별시종로구청운효자동20200804M4052.451192
951111051500서울특별시종로구청운효자동20200804M4582.423302
961111051500서울특별시종로구청운효자동20200804Xxx119.888439
971111051500서울특별시종로구청운효자동20200805F1529.97211
981111051500서울특별시종로구청운효자동20200806M40119.888439
991111051500서울특별시종로구청운효자동20200806M3597.409357