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

Numeric2
Categorical6

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:02:14.108763
Analysis finished2023-12-10 12:02:15.586881
Duration1.48 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

행정동코드
Real number (ℝ)

HIGH CORRELATION 

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.1110566 × 109
Minimum1.1110515 × 109
Maximum1.11107 × 109
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:02:15.673070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1.1110515 × 109
5-th percentile1.1110515 × 109
Q11.111053 × 109
median1.1110555 × 109
Q31.111058 × 109
95-th percentile1.111065 × 109
Maximum1.11107 × 109
Range18500
Interquartile range (IQR)5000

Descriptive statistics

Standard deviation4334.8599
Coefficient of variation (CV)3.9015652 × 10-6
Kurtosis0.15054842
Mean1.1110566 × 109
Median Absolute Deviation (MAD)2500
Skewness0.94206049
Sum1.1110566 × 1011
Variance18791010
MonotonicityIncreasing
2023-12-10T21:02:15.880530image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
1111055000 21
21.0%
1111058000 16
16.0%
1111051500 15
15.0%
1111053000 14
14.0%
1111056000 14
14.0%
1111065000 11
11.0%
1111061500 5
 
5.0%
1111063000 3
 
3.0%
1111070000 1
 
1.0%
ValueCountFrequency (%)
1111051500 15
15.0%
1111053000 14
14.0%
1111055000 21
21.0%
1111056000 14
14.0%
1111058000 16
16.0%
1111061500 5
 
5.0%
1111063000 3
 
3.0%
1111065000 11
11.0%
1111070000 1
 
1.0%
ValueCountFrequency (%)
1111070000 1
 
1.0%
1111065000 11
11.0%
1111063000 3
 
3.0%
1111061500 5
 
5.0%
1111058000 16
16.0%
1111056000 14
14.0%
1111055000 21
21.0%
1111053000 14
14.0%
1111051500 15
15.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:02:16.091001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

Common Values (Plot)

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

행정동명
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
부암동
21 
교남동
16 
청운효자동
15 
사직동
14 
평창동
14 
Other values (4)
20 

Length

Max length11
Median length3
Mean length3.83
Min length3

Unique

Unique1 ?
Unique (%)1.0%

Sample

1st row청운효자동
2nd row청운효자동
3rd row청운효자동
4th row청운효자동
5th row청운효자동

Common Values

ValueCountFrequency (%)
부암동 21
21.0%
교남동 16
16.0%
청운효자동 15
15.0%
사직동 14
14.0%
평창동 14
14.0%
혜화동 11
11.0%
종로1.2.3.4가동 5
 
5.0%
종로5.6가동 3
 
3.0%
숭인1동 1
 
1.0%

Length

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

Common Values (Plot)

2023-12-10T21:02:16.988789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부암동 21
21.0%
교남동 16
16.0%
청운효자동 15
15.0%
사직동 14
14.0%
평창동 14
14.0%
혜화동 11
11.0%
종로1.2.3.4가동 5
 
5.0%
종로5.6가동 3
 
3.0%
숭인1동 1
 
1.0%

기준일자
Real number (ℝ)

Distinct52
Distinct (%)52.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20200936
Minimum20200801
Maximum20201031
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.0 KiB
2023-12-10T21:02:17.213362image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum20200801
5-th percentile20200808
Q120200824
median20200926
Q320201020
95-th percentile20201030
Maximum20201031
Range230
Interquartile range (IQR)196

Descriptive statistics

Standard deviation87.635699
Coefficient of variation (CV)4.3381998 × 10-6
Kurtosis-1.5288432
Mean20200936
Median Absolute Deviation (MAD)96
Skewness-0.34461953
Sum2.0200936 × 109
Variance7680.0158
MonotonicityNot monotonic
2023-12-10T21:02:17.430926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
20201031 5
 
5.0%
20200923 4
 
4.0%
20201028 4
 
4.0%
20200824 4
 
4.0%
20201024 4
 
4.0%
20201005 4
 
4.0%
20200822 4
 
4.0%
20201008 3
 
3.0%
20201027 3
 
3.0%
20201030 3
 
3.0%
Other values (42) 62
62.0%
ValueCountFrequency (%)
20200801 3
3.0%
20200806 2
2.0%
20200808 1
 
1.0%
20200810 2
2.0%
20200811 1
 
1.0%
20200813 1
 
1.0%
20200814 1
 
1.0%
20200817 1
 
1.0%
20200818 3
3.0%
20200819 3
3.0%
ValueCountFrequency (%)
20201031 5
5.0%
20201030 3
3.0%
20201029 2
 
2.0%
20201028 4
4.0%
20201027 3
3.0%
20201024 4
4.0%
20201023 1
 
1.0%
20201022 1
 
1.0%
20201021 1
 
1.0%
20201020 2
 
2.0%

성별
Categorical

HIGH CORRELATION 

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

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
M 49
49.0%
F 47
47.0%
X 4
 
4.0%

Length

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

Common Values (Plot)

2023-12-10T21:02:17.781349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
m 49
49.0%
f 47
47.0%
x 4
 
4.0%

연령대
Categorical

HIGH CORRELATION 

Distinct11
Distinct (%)11.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
50
25 
45
17 
35
12 
30
10 
40
10 
Other values (6)
26 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique2 ?
Unique (%)2.0%

Sample

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

Common Values

ValueCountFrequency (%)
50 25
25.0%
45 17
17.0%
35 12
12.0%
30 10
 
10.0%
40 10
 
10.0%
55 9
 
9.0%
25 8
 
8.0%
xx 4
 
4.0%
60 3
 
3.0%
70 1
 
1.0%

Length

2023-12-10T21:02:17.948118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
50 25
25.0%
45 17
17.0%
35 12
12.0%
30 10
 
10.0%
40 10
 
10.0%
55 9
 
9.0%
25 8
 
8.0%
xx 4
 
4.0%
60 3
 
3.0%
70 1
 
1.0%

소비인구(명)
Categorical

Distinct3
Distinct (%)3.0%
Missing0
Missing (%)0.0%
Memory size932.0 B
22.479082395
76 
29.97210986
19 
37.465137325
 
5

Length

Max length12
Median length12
Mean length11.81
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row22.479082395
2nd row22.479082395
3rd row22.479082395
4th row29.97210986
5th row22.479082395

Common Values

ValueCountFrequency (%)
22.479082395 76
76.0%
29.97210986 19
 
19.0%
37.465137325 5
 
5.0%

Length

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

Common Values (Plot)

2023-12-10T21:02:18.303988image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
22.479082395 76
76.0%
29.97210986 19
 
19.0%
37.465137325 5
 
5.0%

Interactions

2023-12-10T21:02:14.929061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:02:14.597217image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:02:15.091875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T21:02:14.769308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T21:02:18.423775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동코드행정동명기준일자성별연령대소비인구(명)
행정동코드1.0001.0000.1320.5050.6160.000
행정동명1.0001.0000.1260.6740.5670.000
기준일자0.1320.1261.0000.3100.1670.088
성별0.5050.6740.3101.0000.8380.202
연령대0.6160.5670.1670.8381.0000.140
소비인구(명)0.0000.0000.0880.2020.1401.000
2023-12-10T21:02:18.718834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
소비인구(명)행정동명성별연령대
소비인구(명)1.0000.0000.0610.071
행정동명0.0001.0000.3720.294
성별0.0610.3721.0000.702
연령대0.0710.2940.7021.000
2023-12-10T21:02:18.907039image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
행정동코드기준일자행정동명성별연령대소비인구(명)
행정동코드1.000-0.0170.9950.3480.3030.000
기준일자-0.0171.0000.1160.1250.0970.069
행정동명0.9950.1161.0000.3720.2940.000
성별0.3480.1250.3721.0000.7020.061
연령대0.3030.0970.2940.7021.0000.071
소비인구(명)0.0000.0690.0000.0610.0711.000

Missing values

2023-12-10T21:02:15.279788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T21:02:15.505013image/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서울특별시종로구청운효자동20201013M3522.479082
11111051500서울특별시종로구청운효자동20201027M5022.479082
21111051500서울특별시종로구청운효자동20201028M3022.479082
31111051500서울특별시종로구청운효자동20200818F4029.97211
41111051500서울특별시종로구청운효자동20201016M3022.479082
51111051500서울특별시종로구청운효자동20201023M3522.479082
61111051500서울특별시종로구청운효자동20200922M3022.479082
71111051500서울특별시종로구청운효자동20201024M4029.97211
81111051500서울특별시종로구청운효자동20200918M2529.97211
91111051500서울특별시종로구청운효자동20201015F4522.479082
행정동코드시도명시군구명행정동명기준일자성별연령대소비인구(명)
901111065000서울특별시종로구혜화동20201027F5022.479082
911111065000서울특별시종로구혜화동20201020M5022.479082
921111065000서울특별시종로구혜화동20200806M3022.479082
931111065000서울특별시종로구혜화동20201020M2029.97211
941111065000서울특별시종로구혜화동20201017M3029.97211
951111065000서울특별시종로구혜화동20201017M2522.479082
961111065000서울특별시종로구혜화동20200921M2522.479082
971111065000서울특별시종로구혜화동20200824M2537.465137
981111065000서울특별시종로구혜화동20200810M2522.479082
991111070000서울특별시종로구숭인1동20200903M3522.479082