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/77707306-8ffe-432b-8231-49340174c0e8

Alerts

시도명 has constant value ""Constant
비고 has constant value ""Constant
생산일시 has constant value ""Constant
전력량 is highly overall correlated with 전력사용량경부하 and 1 other fieldsHigh correlation
전력사용량경부하 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
전력량 has unique valuesUnique
전력사용량경부하 has unique valuesUnique
전력사용량중부하 has 11 (36.7%) zerosZeros
전력사용량최대부하 has 13 (43.3%) zerosZeros

Reproduction

Analysis started2023-12-10 14:18:49.691355
Analysis finished2023-12-10 14:18:54.370731
Duration4.68 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-10T23:18:54.450526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

시군구명
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)23.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
시흥시
11 
김포시
9 
안양시
3 
안성시
3 
광명시
2 
Other values (2)
2 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique2 ?
Unique (%)6.7%

Sample

1st row김포시
2nd row김포시
3rd row시흥시
4th row시흥시
5th row김포시

Common Values

ValueCountFrequency (%)
시흥시 11
36.7%
김포시 9
30.0%
안양시 3
 
10.0%
안성시 3
 
10.0%
광명시 2
 
6.7%
평택시 1
 
3.3%
화성시 1
 
3.3%

Length

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

Common Values (Plot)

2023-12-10T23:18:54.844558image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시흥시 11
36.7%
김포시 9
30.0%
안양시 3
 
10.0%
안성시 3
 
10.0%
광명시 2
 
6.7%
평택시 1
 
3.3%
화성시 1
 
3.3%

충전일시
Date

Distinct21
Distinct (%)70.0%
Missing0
Missing (%)0.0%
Memory size372.0 B
Minimum2023-01-01 00:00:00
Maximum2023-01-30 00:00:00
2023-12-10T23:18:55.021445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:55.196616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

전력량
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean88867.667
Minimum5780
Maximum483135
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:18:55.351256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5780
5-th percentile6910.85
Q118448.75
median39303
Q347953.5
95-th percentile454779
Maximum483135
Range477355
Interquartile range (IQR)29504.75

Descriptive statistics

Standard deviation143888.74
Coefficient of variation (CV)1.6191349
Kurtosis2.9767067
Mean88867.667
Median Absolute Deviation (MAD)19635.5
Skewness2.0850675
Sum2666030
Variance2.070397 × 1010
MonotonicityNot monotonic
2023-12-10T23:18:55.538893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
18568 1
 
3.3%
46032 1
 
3.3%
39855 1
 
3.3%
43650 1
 
3.3%
38751 1
 
3.3%
44097 1
 
3.3%
51783 1
 
3.3%
19387 1
 
3.3%
41409 1
 
3.3%
286839 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
5780 1
3.3%
6122 1
3.3%
7875 1
3.3%
10607 1
3.3%
11694 1
3.3%
12679 1
3.3%
13120 1
3.3%
18409 1
3.3%
18568 1
3.3%
19387 1
3.3%
ValueCountFrequency (%)
483135 1
3.3%
477810 1
3.3%
426630 1
3.3%
292674 1
3.3%
286839 1
3.3%
52455 1
3.3%
51783 1
3.3%
48594 1
3.3%
46032 1
3.3%
44097 1
3.3%

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

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean62636.633
Minimum2226
Maximum477810
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:18:55.695729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2226
5-th percentile3241.85
Q15748.25
median15012
Q340744.5
95-th percentile363724.05
Maximum477810
Range475584
Interquartile range (IQR)34996.25

Descriptive statistics

Standard deviation122351.85
Coefficient of variation (CV)1.9533592
Kurtosis6.1680661
Mean62636.633
Median Absolute Deviation (MAD)9360
Skewness2.6220405
Sum1879099
Variance1.4969974 × 1010
MonotonicityNot monotonic
2023-12-10T23:18:55.841142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
4151 1
 
3.3%
46032 1
 
3.3%
15696 1
 
3.3%
16203 1
 
3.3%
38751 1
 
3.3%
18765 1
 
3.3%
20214 1
 
3.3%
5729 1
 
3.3%
41409 1
 
3.3%
286839 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
2226 1
3.3%
2498 1
3.3%
4151 1
3.3%
4868 1
3.3%
5348 1
3.3%
5575 1
3.3%
5729 1
3.3%
5743 1
3.3%
5764 1
3.3%
5780 1
3.3%
ValueCountFrequency (%)
477810 1
3.3%
426630 1
3.3%
286839 1
3.3%
187500 1
3.3%
118332 1
3.3%
46032 1
3.3%
42909 1
3.3%
41409 1
3.3%
38751 1
3.3%
20349 1
3.3%

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

HIGH CORRELATION  ZEROS 

Distinct20
Distinct (%)66.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14393.267
Minimum0
Maximum155115
Zeros11
Zeros (%)36.7%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:18:55.997581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median7731
Q314002.75
95-th percentile59256.6
Maximum155115
Range155115
Interquartile range (IQR)14002.75

Descriptive statistics

Standard deviation31145.417
Coefficient of variation (CV)2.163888
Kurtosis15.619383
Mean14393.267
Median Absolute Deviation (MAD)7731
Skewness3.8304629
Sum431798
Variance9.7003702 × 108
MonotonicityNot monotonic
2023-12-10T23:18:56.175887image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)
ValueCountFrequency (%)
0 11
36.7%
7896 1
 
3.3%
14454 1
 
3.3%
12342 1
 
3.3%
15453 1
 
3.3%
25326 1
 
3.3%
18108 1
 
3.3%
7630 1
 
3.3%
87018 1
 
3.3%
2985 1
 
3.3%
Other values (10) 10
33.3%
ValueCountFrequency (%)
0 11
36.7%
1846 1
 
3.3%
2985 1
 
3.3%
4550 1
 
3.3%
7630 1
 
3.3%
7832 1
 
3.3%
7896 1
 
3.3%
7942 1
 
3.3%
8031 1
 
3.3%
9315 1
 
3.3%
ValueCountFrequency (%)
155115 1
3.3%
87018 1
3.3%
25326 1
3.3%
18108 1
3.3%
16722 1
3.3%
16584 1
3.3%
15453 1
3.3%
14454 1
3.3%
12649 1
3.3%
12342 1
3.3%

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

HIGH CORRELATION  ZEROS 

Distinct18
Distinct (%)60.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11769.7
Minimum0
Maximum139650
Zeros13
Zeros (%)43.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:18:56.333304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median2809.5
Q310563
95-th percentile54718.6
Maximum139650
Range139650
Interquartile range (IQR)10563

Descriptive statistics

Standard deviation28909.533
Coefficient of variation (CV)2.4562677
Kurtosis14.849754
Mean11769.7
Median Absolute Deviation (MAD)2809.5
Skewness3.8075892
Sum353091
Variance8.3576112 × 108
MonotonicityNot monotonic
2023-12-10T23:18:56.480775image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)
ValueCountFrequency (%)
0 13
43.3%
6473 1
 
3.3%
12801 1
 
3.3%
11769 1
 
3.3%
11925 1
 
3.3%
13398 1
 
3.3%
5995 1
 
3.3%
86845 1
 
3.3%
2376 1
 
3.3%
2042 1
 
3.3%
Other values (8) 8
26.7%
ValueCountFrequency (%)
0 13
43.3%
2042 1
 
3.3%
2376 1
 
3.3%
3243 1
 
3.3%
5995 1
 
3.3%
6122 1
 
3.3%
6473 1
 
3.3%
6775 1
 
3.3%
6792 1
 
3.3%
6945 1
 
3.3%
ValueCountFrequency (%)
139650 1
3.3%
86845 1
3.3%
15453 1
3.3%
14487 1
3.3%
13398 1
3.3%
12801 1
3.3%
11925 1
3.3%
11769 1
3.3%
6945 1
3.3%
6792 1
3.3%

평균충전SOC
Real number (ℝ)

Distinct13
Distinct (%)43.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean24.566667
Minimum17
Maximum35
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2023-12-10T23:18:56.599303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum17
5-th percentile18
Q122.25
median25
Q327
95-th percentile29
Maximum35
Range18
Interquartile range (IQR)4.75

Descriptive statistics

Standard deviation4.0826237
Coefficient of variation (CV)0.1661855
Kurtosis0.29274563
Mean24.566667
Median Absolute Deviation (MAD)2
Skewness0.025961906
Sum737
Variance16.667816
MonotonicityNot monotonic
2023-12-10T23:18:56.721868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
27 4
13.3%
29 4
13.3%
26 4
13.3%
24 3
10.0%
23 3
10.0%
18 3
10.0%
25 2
6.7%
22 2
6.7%
21 1
 
3.3%
35 1
 
3.3%
Other values (3) 3
10.0%
ValueCountFrequency (%)
17 1
 
3.3%
18 3
10.0%
19 1
 
3.3%
21 1
 
3.3%
22 2
6.7%
23 3
10.0%
24 3
10.0%
25 2
6.7%
26 4
13.3%
27 4
13.3%
ValueCountFrequency (%)
35 1
 
3.3%
29 4
13.3%
28 1
 
3.3%
27 4
13.3%
26 4
13.3%
25 2
6.7%
24 3
10.0%
23 3
10.0%
22 2
6.7%
21 1
 
3.3%

비고
Categorical

CONSTANT 

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

Length

Max length24
Median length24
Mean length24
Min length24

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

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

Common Values (Plot)

2023-12-10T23:18:56.959406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-04-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
2023-04-03 11:05:29
30 

Length

Max length19
Median length19
Mean length19
Min length19

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-04-03 11:05:29
2nd row2023-04-03 11:05:29
3rd row2023-04-03 11:05:29
4th row2023-04-03 11:05:29
5th row2023-04-03 11:05:29

Common Values

ValueCountFrequency (%)
2023-04-03 11:05:29 30
100.0%

Length

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

Common Values (Plot)

2023-12-10T23:18:57.144648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-04-03 30
50.0%
11:05:29 30
50.0%

Interactions

2023-12-10T23:18:52.934257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.024412image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.573550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:51.112037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:51.947191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:53.100157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.146402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.653037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:51.236701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:52.129383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:53.222997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.262979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.752994image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:51.347839image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:52.299868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:53.371263image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.385533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.869774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:51.536582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:52.496317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:53.499462image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.485465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:50.995136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:51.721346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-10T23:18:52.701447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-10T23:18:57.211310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시군구명충전일시전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC
시군구명1.0000.0000.7480.6830.5690.4890.710
충전일시0.0001.0000.7360.6960.9770.9540.861
전력량0.7480.7361.0001.0000.7100.7080.746
전력사용량경부하0.6830.6961.0001.0000.8970.8950.673
전력사용량중부하0.5690.9770.7100.8971.0000.9940.000
전력사용량최대부하0.4890.9540.7080.8950.9941.0000.000
평균충전SOC0.7100.8610.7460.6730.0000.0001.000
2023-12-10T23:18:57.321419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC시군구명
전력량1.0000.8590.3390.306-0.4400.583
전력사용량경부하0.8591.000-0.048-0.091-0.2850.483
전력사용량중부하0.339-0.0481.0000.820-0.1880.396
전력사용량최대부하0.306-0.0910.8201.000-0.1900.326
평균충전SOC-0.440-0.285-0.188-0.1901.0000.460
시군구명0.5830.4830.3960.3260.4601.000

Missing values

2023-12-10T23:18:53.676895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-10T23:18:54.286190image/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-01-0918568415178966473212023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
1경기도김포시2023-01-1723046691093156775272023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
2경기도시흥시2023-01-1648594173191672214487272023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
3경기도시흥시2023-01-29429094290900272023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
4경기도김포시2023-01-1019948576480316122242023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
5경기도김포시2023-01-1120016534878326792242023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
6경기도김포시2023-01-1320489557579426945232023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
7경기도김포시2023-01-14184095743126490252023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
8경기도평택시2023-01-2012679486845503243232023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
9경기도안양시2023-01-0142663042663000182023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
시도명시군구명충전일시전력량전력사용량경부하전력사용량중부하전력사용량최대부하평균충전SOC비고생산일시
20경기도안성시2023-01-257875249829852376352023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
21경기도광명시2023-01-062926741183328701886845172023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
22경기도광명시2023-01-2228683928683900192023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
23경기도시흥시2023-01-01414094140900262023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
24경기도김포시2023-01-1219387572976305995222023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
25경기도시흥시2023-01-0351783202141810813398282023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
26경기도시흥시2023-01-074409718765253260252023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
27경기도시흥시2023-01-08387513875100262023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
28경기도시흥시2023-01-1143650162031545311925222023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29
29경기도시흥시2023-01-1239855156961234211769232023-04-03 지역별 충전 전력 소모량2023-04-03 11:05:29