Overview

Dataset statistics

Number of variables10
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.6 KiB
Average record size in memory89.4 B

Variable types

Categorical4
DateTime1
Numeric5

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/81a5e4ce-367c-4d7c-bccd-d7037eeb8356

Alerts

시도명 has constant value ""Constant
비고 has constant value ""Constant
생산일시 has constant value ""Constant
전력량 is highly overall correlated with 전력사용량경부하 and 4 other fieldsHigh correlation
전력사용량경부하 is highly overall correlated with 전력량 and 2 other fieldsHigh correlation
전력사용량중부하 is highly overall correlated with 전력량 and 1 other fieldsHigh correlation
전력사용량최대부하 is highly overall correlated with 전력량 and 1 other fieldsHigh correlation
평균충전SOC is highly overall correlated with 전력량 and 2 other fieldsHigh correlation
시군구명 is highly overall correlated with 전력량 and 4 other fieldsHigh correlation
전력량 has unique valuesUnique
전력사용량경부하 has unique valuesUnique
전력사용량중부하 has 6 (20.0%) zerosZeros
전력사용량최대부하 has 10 (33.3%) zerosZeros

Reproduction

Analysis started2024-03-13 11:49:00.667923
Analysis finished2024-03-13 11:49:04.671190
Duration4 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
경기도
30 

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 (%)
경기도 30
100.0%

Length

2024-03-13T20:49:04.743438image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:49:04.862978image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 30
100.0%

시군구명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
고양시
21 
김포시
9 

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 (%)
고양시 21
70.0%
김포시 9
30.0%

Length

2024-03-13T20:49:04.993027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:49:05.102458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고양시 21
70.0%
김포시 9
30.0%

충전일시
Date

Distinct26
Distinct (%)86.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-10-01 00:00:00
Maximum2023-10-31 00:00:00
2024-03-13T20:49:05.261615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:05.444017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=26)

전력량
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean34231.733
Minimum9426
Maximum48030
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:49:05.585707image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9426
5-th percentile9634.5
Q117516
median42715
Q345092.5
95-th percentile47377.75
Maximum48030
Range38604
Interquartile range (IQR)27576.5

Descriptive statistics

Standard deviation14372.622
Coefficient of variation (CV)0.41986253
Kurtosis-1.2516751
Mean34231.733
Median Absolute Deviation (MAD)4175
Skewness-0.75142342
Sum1026952
Variance2.0657227 × 108
MonotonicityNot monotonic
2024-03-13T20:49:05.734457image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
42950 1
 
3.3%
42480 1
 
3.3%
17250 1
 
3.3%
9706 1
 
3.3%
11784 1
 
3.3%
15048 1
 
3.3%
17073 1
 
3.3%
18314 1
 
3.3%
16875 1
 
3.3%
9426 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
9426 1
3.3%
9576 1
3.3%
9706 1
3.3%
11784 1
3.3%
15048 1
3.3%
16875 1
3.3%
17073 1
3.3%
17250 1
3.3%
18314 1
3.3%
24620 1
3.3%
ValueCountFrequency (%)
48030 1
3.3%
47425 1
3.3%
47320 1
3.3%
46460 1
3.3%
45825 1
3.3%
45820 1
3.3%
45560 1
3.3%
45100 1
3.3%
45070 1
3.3%
44595 1
3.3%

전력사용량경부하
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14011.067
Minimum2514
Maximum37425
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:49:05.873811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2514
5-th percentile3906.05
Q110225.5
median14072.5
Q315618.75
95-th percentile30466.5
Maximum37425
Range34911
Interquartile range (IQR)5393.25

Descriptive statistics

Standard deviation7885.3245
Coefficient of variation (CV)0.56279259
Kurtosis3.0107732
Mean14011.067
Median Absolute Deviation (MAD)1963
Skewness1.3254618
Sum420332
Variance62178343
MonotonicityNot monotonic
2024-03-13T20:49:05.993329image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
13130 1
 
3.3%
15710 1
 
3.3%
3650 1
 
3.3%
9706 1
 
3.3%
11784 1
 
3.3%
4394 1
 
3.3%
4666 1
 
3.3%
5143 1
 
3.3%
4219 1
 
3.3%
9426 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
2514 1
3.3%
3650 1
3.3%
4219 1
3.3%
4394 1
3.3%
4666 1
3.3%
5143 1
3.3%
9426 1
3.3%
9706 1
3.3%
11784 1
3.3%
12645 1
3.3%
ValueCountFrequency (%)
37425 1
3.3%
35250 1
3.3%
24620 1
3.3%
18350 1
3.3%
17000 1
3.3%
16660 1
3.3%
15710 1
3.3%
15665 1
3.3%
15480 1
3.3%
15370 1
3.3%

전력사용량중부하
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct25
Distinct (%)83.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12668.7
Minimum0
Maximum30285
Zeros6
Zeros (%)20.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:49:06.205053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q16686
median15985
Q317382.5
95-th percentile27555.25
Maximum30285
Range30285
Interquartile range (IQR)10696.5

Descriptive statistics

Standard deviation8716.3199
Coefficient of variation (CV)0.68802007
Kurtosis-0.65326896
Mean12668.7
Median Absolute Deviation (MAD)4065
Skewness-0.018906047
Sum380061
Variance75974233
MonotonicityNot monotonic
2024-03-13T20:49:06.415333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=25)
ValueCountFrequency (%)
0 6
 
20.0%
17010 1
 
3.3%
15470 1
 
3.3%
7376 1
 
3.3%
10650 1
 
3.3%
7001 1
 
3.3%
7070 1
 
3.3%
6581 1
 
3.3%
3743 1
 
3.3%
18245 1
 
3.3%
Other values (15) 15
50.0%
ValueCountFrequency (%)
0 6
20.0%
3743 1
 
3.3%
6581 1
 
3.3%
7001 1
 
3.3%
7070 1
 
3.3%
7376 1
 
3.3%
10650 1
 
3.3%
14230 1
 
3.3%
15470 1
 
3.3%
15875 1
 
3.3%
ValueCountFrequency (%)
30285 1
3.3%
28030 1
3.3%
26975 1
3.3%
18780 1
3.3%
18245 1
3.3%
17640 1
3.3%
17615 1
3.3%
17430 1
3.3%
17240 1
3.3%
17010 1
3.3%

전력사용량최대부하
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct21
Distinct (%)70.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7506.1
Minimum0
Maximum16040
Zeros10
Zeros (%)33.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:49:06.589505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median9153
Q312940
95-th percentile14217.75
Maximum16040
Range16040
Interquartile range (IQR)12940

Descriptive statistics

Standard deviation6146.0831
Coefficient of variation (CV)0.81881178
Kurtosis-1.8041879
Mean7506.1
Median Absolute Deviation (MAD)4467
Skewness-0.19862612
Sum225183
Variance37774338
MonotonicityNot monotonic
2024-03-13T20:49:06.734182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
0 10
33.3%
12715 1
 
3.3%
13335 1
 
3.3%
6201 1
 
3.3%
5378 1
 
3.3%
6075 1
 
3.3%
6046 1
 
3.3%
3298 1
 
3.3%
12125 1
 
3.3%
16040 1
 
3.3%
Other values (11) 11
36.7%
ValueCountFrequency (%)
0 10
33.3%
3298 1
 
3.3%
5378 1
 
3.3%
6046 1
 
3.3%
6075 1
 
3.3%
6201 1
 
3.3%
12105 1
 
3.3%
12125 1
 
3.3%
12210 1
 
3.3%
12480 1
 
3.3%
ValueCountFrequency (%)
16040 1
3.3%
14580 1
3.3%
13775 1
3.3%
13710 1
3.3%
13530 1
3.3%
13335 1
3.3%
13325 1
3.3%
13015 1
3.3%
12715 1
3.3%
12680 1
3.3%

평균충전SOC
Real number (ℝ)

HIGH CORRELATION 

Distinct6
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean17.766667
Minimum16
Maximum21
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-03-13T20:49:06.864464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum16
5-th percentile16
Q117
median17
Q318.75
95-th percentile20.55
Maximum21
Range5
Interquartile range (IQR)1.75

Descriptive statistics

Standard deviation1.478194
Coefficient of variation (CV)0.083200412
Kurtosis-0.20074589
Mean17.766667
Median Absolute Deviation (MAD)1
Skewness0.84345317
Sum533
Variance2.1850575
MonotonicityNot monotonic
2024-03-13T20:49:06.987428image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
17 12
40.0%
16 5
16.7%
18 5
16.7%
20 3
 
10.0%
19 3
 
10.0%
21 2
 
6.7%
ValueCountFrequency (%)
16 5
16.7%
17 12
40.0%
18 5
16.7%
19 3
 
10.0%
20 3
 
10.0%
21 2
 
6.7%
ValueCountFrequency (%)
21 2
 
6.7%
20 3
 
10.0%
19 3
 
10.0%
18 5
16.7%
17 12
40.0%
16 5
16.7%

비고
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-01-03 지역별 충전 전력 소모량
30 

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-01-03 지역별 충전 전력 소모량
2nd row2024-01-03 지역별 충전 전력 소모량
3rd row2024-01-03 지역별 충전 전력 소모량
4th row2024-01-03 지역별 충전 전력 소모량
5th row2024-01-03 지역별 충전 전력 소모량

Common Values

ValueCountFrequency (%)
2024-01-03 지역별 충전 전력 소모량 30
100.0%

Length

2024-03-13T20:49:07.119906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:49:07.226592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-01-03 30
20.0%
지역별 30
20.0%
충전 30
20.0%
전력 30
20.0%
소모량 30
20.0%

생산일시
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
2024-01-03 10:26:14
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2024-01-03 10:26:14
2nd row2024-01-03 10:26:14
3rd row2024-01-03 10:26:14
4th row2024-01-03 10:26:14
5th row2024-01-03 10:26:14

Common Values

ValueCountFrequency (%)
2024-01-03 10:26:14 30
100.0%

Length

2024-03-13T20:49:07.342021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T20:49:07.466347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2024-01-03 30
50.0%
10:26:14 30
50.0%

Interactions

2024-03-13T20:49:03.798477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:01.008296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:01.640302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:02.546274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:03.162187image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:03.912950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:01.132091image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:01.814277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:02.666092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:03.319234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:04.083796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:01.228185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:01.927228image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:02.777580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:03.425085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:04.188517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:01.350539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:02.029884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:02.876877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:03.555763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:04.295726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:01.501462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:02.460577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:02.999543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T20:49:03.680346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T20:49:07.559745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명충전일시전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC
시군구명1.0000.0001.0000.8150.7990.9120.992
충전일시0.0001.0000.0000.8740.0000.7970.000
전력량1.0000.0001.0000.8940.7540.6300.619
전력사용량경부하0.8150.8740.8941.0000.6770.6590.509
전력사용량중부하0.7990.0000.7540.6771.0000.9130.668
전력사용량최대부하0.9120.7970.6300.6590.9131.0000.796
평균충전SOC0.9920.0000.6190.5090.6680.7961.000
2024-03-13T20:49:07.688662image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC시군구명
전력량1.0000.5860.7540.680-0.5590.886
전력사용량경부하0.5861.0000.1410.140-0.6820.811
전력사용량중부하0.7540.1411.0000.448-0.4050.710
전력사용량최대부하0.6800.1400.4481.000-0.2630.680
평균충전SOC-0.559-0.682-0.405-0.2631.0000.852
시군구명0.8860.8110.7100.6800.8521.000

Missing values

2024-03-13T20:49:04.429192image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T20:49:04.611937image/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

시도명시군구명충전일시전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC비고생산일시
0경기도고양시2023-10-0442950131301701012715172024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
1경기도고양시2023-10-0544260145801609513530172024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
2경기도고양시2023-10-0645100142901696513775172024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
3경기도고양시2023-10-073964512645269750162024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
4경기도고양시2023-10-1644500136701743013325172024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
5경기도고양시2023-10-1746460150801761513710182024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
6경기도고양시2023-10-1845070151851724012560172024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
7경기도고양시2023-10-1944305154801654512210162024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
8경기도고양시2023-10-2047425183501692512105172024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
9경기도고양시2023-10-214732017000302850172024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
시도명시군구명충전일시전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC비고생산일시
20경기도고양시2023-10-3145820153701824512125172024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
21경기도김포시2023-10-029576251437433298202024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
22경기도김포시2023-10-039426942600192024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
23경기도김포시2023-10-0416875421965816046212024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
24경기도김포시2023-10-0518314514370706075212024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
25경기도김포시2023-10-0617073466670015378192024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
26경기도김포시2023-10-07150484394106500202024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
27경기도김포시2023-10-08117841178400182024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
28경기도김포시2023-10-099706970600202024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14
29경기도김포시2023-10-1017250365073766201192024-01-03 지역별 충전 전력 소모량2024-01-03 10:26:14