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

Categorical3
DateTime2
Numeric5

Dataset

Description샘플 데이터
Author펌프킨
URLhttps://bigdata-region.kr/#/dataset/36b1a412-e5f1-4c23-9b29-00bd908b5091

Alerts

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

Reproduction

Analysis started2023-12-10 13:54:58.234780
Analysis finished2023-12-10 13:55:03.963624
Duration5.73 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

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

Common Values (Plot)

2023-12-10T22:55:04.287954image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 30
100.0%

시군구명
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
안성시
10 
광명시
3 
고양시
3 
부천시
3 
안양시
2 
Other values (5)
9 

Length

Max length4
Median length3
Mean length3.0666667
Min length3

Unique

Unique1 ?
Unique (%)3.3%

Sample

1st row광명시
2nd row안성시
3rd row안성시
4th row안양시
5th row광명시

Common Values

ValueCountFrequency (%)
안성시 10
33.3%
광명시 3
 
10.0%
고양시 3
 
10.0%
부천시 3
 
10.0%
안양시 2
 
6.7%
남양주시 2
 
6.7%
양평군 2
 
6.7%
용인시 2
 
6.7%
파주시 2
 
6.7%
오산시 1
 
3.3%

Length

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

Common Values (Plot)

2023-12-10T22:55:04.632695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
안성시 10
33.3%
광명시 3
 
10.0%
고양시 3
 
10.0%
부천시 3
 
10.0%
안양시 2
 
6.7%
남양주시 2
 
6.7%
양평군 2
 
6.7%
용인시 2
 
6.7%
파주시 2
 
6.7%
오산시 1
 
3.3%

충전일시
Date

Distinct14
Distinct (%)46.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-04-01 00:00:00
Maximum2023-04-28 00:00:00
2023-12-10T22:55:04.856435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:05.065164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)

전력량
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean83545.567
Minimum1013
Maximum315420
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:05.286984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1013
5-th percentile1439.4
Q14513
median27319.5
Q3189908.75
95-th percentile285323.7
Maximum315420
Range314407
Interquartile range (IQR)185395.75

Descriptive statistics

Standard deviation113640.47
Coefficient of variation (CV)1.3602215
Kurtosis-0.65164165
Mean83545.567
Median Absolute Deviation (MAD)22994.5
Skewness1.0827281
Sum2506367
Variance1.2914157 × 1010
MonotonicityNot monotonic
2023-12-10T22:55:05.645468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
279266 1
 
3.3%
4618 1
 
3.3%
32985 1
 
3.3%
226005 1
 
3.3%
76822 1
 
3.3%
81620 1
 
3.3%
1200 1
 
3.3%
234957 1
 
3.3%
270590 1
 
3.3%
266781 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
1013 1
3.3%
1200 1
3.3%
1732 1
3.3%
1794 1
3.3%
4257 1
3.3%
4393 1
3.3%
4410 1
3.3%
4478 1
3.3%
4618 1
3.3%
4784 1
3.3%
ValueCountFrequency (%)
315420 1
3.3%
290280 1
3.3%
279266 1
3.3%
270590 1
3.3%
266781 1
3.3%
234957 1
3.3%
230629 1
3.3%
226005 1
3.3%
81620 1
3.3%
76822 1
3.3%

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

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean46316.867
Minimum292
Maximum230629
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:06.054627image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum292
5-th percentile503.45
Q11949.75
median10269
Q386923
95-th percentile196001.7
Maximum230629
Range230337
Interquartile range (IQR)84973.25

Descriptive statistics

Standard deviation69153.811
Coefficient of variation (CV)1.4930589
Kurtosis1.4273391
Mean46316.867
Median Absolute Deviation (MAD)9190.5
Skewness1.5662896
Sum1389506
Variance4.7822495 × 109
MonotonicityNot monotonic
2023-12-10T22:55:06.282250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
159331 1
 
3.3%
1744 1
 
3.3%
11487 1
 
3.3%
226005 1
 
3.3%
28219 1
 
3.3%
30319 1
 
3.3%
669 1
 
3.3%
105791 1
 
3.3%
109252 1
 
3.3%
136509 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
292 1
3.3%
368 1
3.3%
669 1
3.3%
1488 1
3.3%
1683 1
3.3%
1732 1
3.3%
1744 1
3.3%
1923 1
3.3%
2030 1
3.3%
2043 1
3.3%
ValueCountFrequency (%)
230629 1
3.3%
226005 1
3.3%
159331 1
3.3%
136509 1
3.3%
123255 1
3.3%
112170 1
3.3%
109252 1
3.3%
105791 1
3.3%
30319 1
3.3%
29187 1
3.3%

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

HIGH CORRELATION  ZEROS 

Distinct24
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean28885.7
Minimum0
Maximum192060
Zeros7
Zeros (%)23.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:06.578378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q1170.5
median1618.5
Q324920.25
95-th percentile130257.45
Maximum192060
Range192060
Interquartile range (IQR)24749.75

Descriptive statistics

Standard deviation51528.42
Coefficient of variation (CV)1.783873
Kurtosis2.8129626
Mean28885.7
Median Absolute Deviation (MAD)1618.5
Skewness1.9283424
Sum866571
Variance2.6551781 × 109
MonotonicityNot monotonic
2023-12-10T22:55:06.870568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
0 7
23.3%
119800 1
 
3.3%
192060 1
 
3.3%
11793 1
 
3.3%
27459 1
 
3.3%
28925 1
 
3.3%
133 1
 
3.3%
76312 1
 
3.3%
93377 1
 
3.3%
130181 1
 
3.3%
Other values (14) 14
46.7%
ValueCountFrequency (%)
0 7
23.3%
133 1
 
3.3%
283 1
 
3.3%
988 1
 
3.3%
1314 1
 
3.3%
1452 1
 
3.3%
1502 1
 
3.3%
1543 1
 
3.3%
1578 1
 
3.3%
1659 1
 
3.3%
ValueCountFrequency (%)
192060 1
3.3%
130320 1
3.3%
130181 1
3.3%
119800 1
3.3%
93377 1
3.3%
76312 1
3.3%
28925 1
3.3%
27459 1
3.3%
17304 1
3.3%
11793 1
3.3%

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

HIGH CORRELATION  ZEROS 

Distinct17
Distinct (%)56.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8278.7667
Minimum0
Maximum67552
Zeros14
Zeros (%)46.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:07.083355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median380
Q36421.25
95-th percentile50200.3
Maximum67552
Range67552
Interquartile range (IQR)6421.25

Descriptive statistics

Standard deviation17361.659
Coefficient of variation (CV)2.097131
Kurtosis5.3748971
Mean8278.7667
Median Absolute Deviation (MAD)380
Skewness2.4600608
Sum248363
Variance3.0142719 × 108
MonotonicityNot monotonic
2023-12-10T22:55:07.318338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=17)
ValueCountFrequency (%)
0 14
46.7%
47370 1
 
3.3%
9651 1
 
3.3%
21055 1
 
3.3%
22275 1
 
3.3%
398 1
 
3.3%
52516 1
 
3.3%
67552 1
 
3.3%
8103 1
 
3.3%
11100 1
 
3.3%
Other values (7) 7
23.3%
ValueCountFrequency (%)
0 14
46.7%
362 1
 
3.3%
398 1
 
3.3%
1303 1
 
3.3%
1314 1
 
3.3%
1317 1
 
3.3%
1332 1
 
3.3%
1339 1
 
3.3%
1376 1
 
3.3%
8103 1
 
3.3%
ValueCountFrequency (%)
67552 1
3.3%
52516 1
3.3%
47370 1
3.3%
22275 1
3.3%
21055 1
3.3%
11100 1
3.3%
9651 1
3.3%
8103 1
3.3%
1376 1
3.3%
1339 1
3.3%

평균충전SOC
Real number (ℝ)

HIGH CORRELATION 

Distinct18
Distinct (%)60.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean23.266667
Minimum14
Maximum39
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T22:55:07.513012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum14
5-th percentile15
Q118.25
median23
Q326.75
95-th percentile36.1
Maximum39
Range25
Interquartile range (IQR)8.5

Descriptive statistics

Standard deviation6.5228158
Coefficient of variation (CV)0.28035025
Kurtosis0.17046333
Mean23.266667
Median Absolute Deviation (MAD)4
Skewness0.69868538
Sum698
Variance42.547126
MonotonicityNot monotonic
2023-12-10T22:55:07.732461image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
15 3
 
10.0%
22 3
 
10.0%
25 3
 
10.0%
23 3
 
10.0%
17 2
 
6.7%
19 2
 
6.7%
27 2
 
6.7%
30 2
 
6.7%
20 1
 
3.3%
35 1
 
3.3%
Other values (8) 8
26.7%
ValueCountFrequency (%)
14 1
 
3.3%
15 3
10.0%
16 1
 
3.3%
17 2
6.7%
18 1
 
3.3%
19 2
6.7%
20 1
 
3.3%
22 3
10.0%
23 3
10.0%
24 1
 
3.3%
ValueCountFrequency (%)
39 1
 
3.3%
37 1
 
3.3%
35 1
 
3.3%
30 2
6.7%
28 1
 
3.3%
27 2
6.7%
26 1
 
3.3%
25 3
10.0%
24 1
 
3.3%
23 3
10.0%

비고
Categorical

CONSTANT 

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

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-07-18 지역별 충전 전력 소모량
2nd row2023-07-18 지역별 충전 전력 소모량
3rd row2023-07-18 지역별 충전 전력 소모량
4th row2023-07-18 지역별 충전 전력 소모량
5th row2023-07-18 지역별 충전 전력 소모량

Common Values

ValueCountFrequency (%)
2023-07-18 지역별 충전 전력 소모량 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T22:55:08.169510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-07-18 30
20.0%
지역별 30
20.0%
충전 30
20.0%
전력 30
20.0%
소모량 30
20.0%

생산일시
Date

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-07-18 09:47:00
Maximum2023-07-18 09:47:00
2023-12-10T22:55:08.334292image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:08.482283image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-10T22:55:02.494127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:58.688683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:59.414343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:00.566881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:01.659214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:02.643474image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:58.822932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:59.543986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:00.908453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:01.834025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:02.834272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:58.937397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:00.051775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:01.078152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:01.979577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:03.060652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:59.091277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:00.248670image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:01.309837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:02.159766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:03.251365image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:54:59.249161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:00.425591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:01.502618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T22:55:02.349781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T22:55:08.628949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명충전일시전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC
시군구명1.0000.2220.8880.6380.7600.9360.873
충전일시0.2221.0000.5580.0000.5640.3960.000
전력량0.8880.5581.0000.9120.9510.7520.579
전력사용량경부하0.6380.0000.9121.0000.9110.6380.000
전력사용량중부하0.7600.5640.9510.9111.0000.8580.000
전력사용량최대부하0.9360.3960.7520.6380.8581.0000.525
평균충전SOC0.8730.0000.5790.0000.0000.5251.000
2023-12-10T22:55:08.839998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC시군구명
전력량1.0000.9340.6570.200-0.7250.670
전력사용량경부하0.9341.0000.3930.013-0.6800.369
전력사용량중부하0.6570.3931.0000.451-0.4610.477
전력사용량최대부하0.2000.0130.4511.000-0.4160.583
평균충전SOC-0.725-0.680-0.461-0.4161.0000.538
시군구명0.6700.3690.4770.5830.5381.000

Missing values

2023-12-10T22:55:03.531927image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T22:55:03.856996image/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-04-012792661593311198000202023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
1경기도안성시2023-04-164784478400232023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
2경기도안성시2023-04-024410441000242023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
3경기도안양시2023-04-2129028011217013032047370152023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
4경기도광명시2023-04-0223062923062900192023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
5경기도남양주시2023-04-031013368283362282023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
6경기도고양시2023-04-16266132661300152023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
7경기도양평군2023-04-01179429215020372023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
8경기도양평군2023-04-021732173200392023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
9경기도안성시2023-04-174800217213141303252023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
시도명시군구명충전일시전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC비고생산일시
20경기도용인시2023-04-012802610719173040352023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
21경기도용인시2023-04-23291872918700302023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
22경기도부천시2023-04-012667811365091301810222023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
23경기도부천시2023-04-032705901092529337767552222023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
24경기도광명시2023-04-032349571057917631252516162023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
25경기도남양주시2023-04-041200669133398302023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
26경기도파주시2023-04-1281620303192892522275182023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
27경기도파주시2023-04-2876822282192745921055172023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
28경기도부천시2023-04-2322600522600500222023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00
29경기도고양시2023-04-173298511487117939651172023-07-18 지역별 충전 전력 소모량2023-07-18 09:47:00