Overview

Dataset statistics

Number of variables8
Number of observations400
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory27.1 KiB
Average record size in memory69.3 B

Variable types

Categorical6
Numeric2

Alerts

ETL일시 has constant value ""Constant
기준년월일 has constant value ""Constant
행정동코드 has constant value ""Constant
ETL날짜 has constant value ""Constant
24시간대구분코드 is highly overall correlated with 인구수High correlation
인구수 is highly overall correlated with 24시간대구분코드High correlation
24시간대구분코드 has 28 (7.0%) zerosZeros

Reproduction

Analysis started2023-12-10 06:23:14.267821
Analysis finished2023-12-10 06:23:15.549732
Duration1.28 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

ETL일시
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2020-02-10 00:12:43.0
400 

Length

Max length21
Median length21
Mean length21
Min length21

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2020-02-10 00:12:43.0
2nd row2020-02-10 00:12:43.0
3rd row2020-02-10 00:12:43.0
4th row2020-02-10 00:12:43.0
5th row2020-02-10 00:12:43.0

Common Values

ValueCountFrequency (%)
2020-02-10 00:12:43.0 400
100.0%

Length

2023-12-10T15:23:15.667055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:23:15.821681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020-02-10 400
50.0%
00:12:43.0 400
50.0%

기준년월일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
20200201
400 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20200201 400
100.0%

Length

2023-12-10T15:23:15.982323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:23:16.141060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20200201 400
100.0%

24시간대구분코드
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct15
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.7925
Minimum0
Maximum14
Zeros28
Zeros (%)7.0%
Negative0
Negative (%)0.0%
Memory size3.6 KiB
2023-12-10T15:23:16.662774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q13
median7
Q310
95-th percentile13
Maximum14
Range14
Interquartile range (IQR)7

Descriptive statistics

Standard deviation4.2129343
Coefficient of variation (CV)0.62023325
Kurtosis-1.2031045
Mean6.7925
Median Absolute Deviation (MAD)4
Skewness-0.0055588647
Sum2717
Variance17.748816
MonotonicityIncreasing
2023-12-10T15:23:16.867066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
0 28
 
7.0%
1 28
 
7.0%
8 28
 
7.0%
9 28
 
7.0%
10 28
 
7.0%
11 28
 
7.0%
12 28
 
7.0%
13 28
 
7.0%
2 27
 
6.8%
3 27
 
6.8%
Other values (5) 122
30.5%
ValueCountFrequency (%)
0 28
7.0%
1 28
7.0%
2 27
6.8%
3 27
6.8%
4 27
6.8%
5 27
6.8%
6 27
6.8%
7 27
6.8%
8 28
7.0%
9 28
7.0%
ValueCountFrequency (%)
14 14
3.5%
13 28
7.0%
12 28
7.0%
11 28
7.0%
10 28
7.0%
9 28
7.0%
8 28
7.0%
7 27
6.8%
6 27
6.8%
5 27
6.8%

성별구분코드
Categorical

Distinct2
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
F
207 
M
193 

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 207
51.7%
M 193
48.2%

Length

2023-12-10T15:23:17.066202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:23:17.223013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
f 207
51.7%
m 193
48.2%

연령대구분코드
Categorical

Distinct14
Distinct (%)3.5%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
age_10
29 
age_15
29 
age_20
29 
age_25
29 
age_30
29 
Other values (9)
255 

Length

Max length6
Median length6
Mean length6
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowage_00
2nd rowage_10
3rd rowage_15
4th rowage_20
5th rowage_25

Common Values

ValueCountFrequency (%)
age_10 29
 
7.2%
age_15 29
 
7.2%
age_20 29
 
7.2%
age_25 29
 
7.2%
age_30 29
 
7.2%
age_35 29
 
7.2%
age_40 29
 
7.2%
age_45 29
 
7.2%
age_50 29
 
7.2%
age_55 29
 
7.2%
Other values (4) 110
27.5%

Length

2023-12-10T15:23:17.411049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
age_10 29
 
7.2%
age_15 29
 
7.2%
age_20 29
 
7.2%
age_25 29
 
7.2%
age_30 29
 
7.2%
age_35 29
 
7.2%
age_40 29
 
7.2%
age_45 29
 
7.2%
age_50 29
 
7.2%
age_55 29
 
7.2%
Other values (4) 110
27.5%

행정동코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
11110560
400 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
11110560 400
100.0%

Length

2023-12-10T15:23:17.613129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:23:17.779159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
11110560 400
100.0%

인구수
Real number (ℝ)

HIGH CORRELATION 

Distinct225
Distinct (%)56.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean129.4775
Minimum1
Maximum566
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.6 KiB
2023-12-10T15:23:17.978451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile6
Q137
median85
Q3199.25
95-th percentile376
Maximum566
Range565
Interquartile range (IQR)162.25

Descriptive statistics

Standard deviation121.08784
Coefficient of variation (CV)0.93520373
Kurtosis0.85193175
Mean129.4775
Median Absolute Deviation (MAD)61
Skewness1.2148892
Sum51791
Variance14662.265
MonotonicityNot monotonic
2023-12-10T15:23:18.243644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
41 6
 
1.5%
55 6
 
1.5%
27 6
 
1.5%
6 5
 
1.2%
24 5
 
1.2%
14 5
 
1.2%
1 5
 
1.2%
3 5
 
1.2%
16 5
 
1.2%
89 4
 
1.0%
Other values (215) 348
87.0%
ValueCountFrequency (%)
1 5
1.2%
2 3
0.8%
3 5
1.2%
4 3
0.8%
5 3
0.8%
6 5
1.2%
7 2
 
0.5%
8 4
1.0%
9 3
0.8%
11 1
 
0.2%
ValueCountFrequency (%)
566 1
0.2%
526 1
0.2%
513 1
0.2%
511 1
0.2%
485 1
0.2%
476 1
0.2%
464 1
0.2%
463 1
0.2%
459 1
0.2%
457 1
0.2%

ETL날짜
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
20200201
400 

Length

Max length8
Median length8
Mean length8
Min length8

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
20200201 400
100.0%

Length

2023-12-10T15:23:18.457343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-10T15:23:18.608456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
20200201 400
100.0%

Interactions

2023-12-10T15:23:14.926045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:23:14.565947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:23:15.063454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T15:23:14.771505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T15:23:18.710246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
24시간대구분코드성별구분코드연령대구분코드인구수
24시간대구분코드1.0000.0000.0000.578
성별구분코드0.0001.0000.0000.319
연령대구분코드0.0000.0001.0000.516
인구수0.5780.3190.5161.000
2023-12-10T15:23:18.858263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
성별구분코드연령대구분코드
성별구분코드1.0000.000
연령대구분코드0.0001.000
2023-12-10T15:23:19.000400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
24시간대구분코드인구수성별구분코드연령대구분코드
24시간대구분코드1.0000.5320.0000.000
인구수0.5321.0000.2390.235
성별구분코드0.0000.2391.0000.000
연령대구분코드0.0000.2350.0001.000

Missing values

2023-12-10T15:23:15.256558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T15:23:15.465295image/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

ETL일시기준년월일24시간대구분코드성별구분코드연령대구분코드행정동코드인구수ETL날짜
02020-02-10 00:12:43.0202002010Fage_0011110560720200201
12020-02-10 00:12:43.0202002010Fage_10111105601320200201
22020-02-10 00:12:43.0202002010Fage_15111105604520200201
32020-02-10 00:12:43.0202002010Fage_201111056012020200201
42020-02-10 00:12:43.0202002010Fage_251111056013420200201
52020-02-10 00:12:43.0202002010Fage_30111105609320200201
62020-02-10 00:12:43.0202002010Fage_35111105608220200201
72020-02-10 00:12:43.0202002010Fage_40111105606920200201
82020-02-10 00:12:43.0202002010Fage_451111056010520200201
92020-02-10 00:12:43.0202002010Fage_50111105609820200201
ETL일시기준년월일24시간대구분코드성별구분코드연령대구분코드행정동코드인구수ETL날짜
3902020-02-10 00:12:43.02020020114Fage_251111056023520200201
3912020-02-10 00:12:43.02020020114Fage_301111056020220200201
3922020-02-10 00:12:43.02020020114Fage_351111056025420200201
3932020-02-10 00:12:43.02020020114Fage_401111056019320200201
3942020-02-10 00:12:43.02020020114Fage_451111056030320200201
3952020-02-10 00:12:43.02020020114Fage_501111056042520200201
3962020-02-10 00:12:43.02020020114Fage_551111056036020200201
3972020-02-10 00:12:43.02020020114Fage_601111056025520200201
3982020-02-10 00:12:43.02020020114Fage_651111056013120200201
3992020-02-10 00:12:43.02020020114Fage_701111056012520200201