Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells3560
Missing cells (%)7.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory498.0 KiB
Average record size in memory51.0 B

Variable types

DateTime1
Numeric3
Categorical1

Dataset

Description지역별(광역시도별) 시간대별 태양광, 풍력 발전량 자료입니다.(과거데이터는 하단 주기성 과거데이터에서 다운로드 가능합니다.)항목 : 거래일자, 거래시간, 지역, 발전량단위 : MWh* 본 데이터는 전력시장에 참여하는 발전기의 전력거래량으로, 전기사업법 시행령 제19조 1항 2호에 따라 한국전력공사와 직접 거래하는 발전기, 자가용 등은 포함하지 않습니다.전력거래량은 소내용 및 주변압기 손실분 등을 제외한 송전단 기준 발전량이며, 수정정산 등에 의해 값이 변동될 수 있습니다.* 심야시간대 태양광 발전량은 ESS 방전에 의해 소량 발생할 수 있음
Author한국전력거래소
URLhttps://www.data.go.kr/data/15065269/fileData.do

Alerts

풍력발전량(Mwh) has 3560 (35.6%) missing valuesMissing
태양광발전량(Mwh) has 2071 (20.7%) zerosZeros
풍력발전량(Mwh) has 2112 (21.1%) zerosZeros

Reproduction

Analysis started2023-12-23 07:47:16.049459
Analysis finished2023-12-23 07:47:24.635376
Duration8.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

거래일자
Date

Distinct91
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-09-01 00:00:00
Maximum2023-11-30 00:00:00
2023-12-23T07:47:25.133932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:26.057646image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

거래시간
Real number (ℝ)

Distinct24
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean12.5138
Minimum1
Maximum24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-23T07:47:26.617381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q16
median13
Q318
95-th percentile23
Maximum24
Range23
Interquartile range (IQR)12

Descriptive statistics

Standard deviation6.9092969
Coefficient of variation (CV)0.55213419
Kurtosis-1.2003581
Mean12.5138
Median Absolute Deviation (MAD)6
Skewness-0.0027264658
Sum125138
Variance47.738383
MonotonicityNot monotonic
2023-12-23T07:47:27.158239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
14 444
 
4.4%
17 440
 
4.4%
11 438
 
4.4%
5 437
 
4.4%
10 427
 
4.3%
23 427
 
4.3%
6 427
 
4.3%
18 423
 
4.2%
21 422
 
4.2%
19 420
 
4.2%
Other values (14) 5695
57.0%
ValueCountFrequency (%)
1 411
4.1%
2 409
4.1%
3 417
4.2%
4 407
4.1%
5 437
4.4%
6 427
4.3%
7 400
4.0%
8 408
4.1%
9 401
4.0%
10 427
4.3%
ValueCountFrequency (%)
24 414
4.1%
23 427
4.3%
22 401
4.0%
21 422
4.2%
20 401
4.0%
19 420
4.2%
18 423
4.2%
17 440
4.4%
16 419
4.2%
15 392
3.9%

지역명
Categorical

Distinct17
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
대전시
 
636
제주도
 
608
광주시
 
606
경상북도
 
593
강원도
 
592
Other values (12)
6965 

Length

Max length4
Median length3
Mean length3.3487
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row울산시
2nd row울산시
3rd row경상북도
4th row강원도
5th row인천시

Common Values

ValueCountFrequency (%)
대전시 636
 
6.4%
제주도 608
 
6.1%
광주시 606
 
6.1%
경상북도 593
 
5.9%
강원도 592
 
5.9%
경기도 590
 
5.9%
대구시 589
 
5.9%
울산시 586
 
5.9%
충청북도 585
 
5.9%
인천시 585
 
5.9%
Other values (7) 4030
40.3%

Length

2023-12-23T07:47:28.030147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
대전시 636
 
6.4%
제주도 608
 
6.1%
광주시 606
 
6.1%
경상북도 593
 
5.9%
강원도 592
 
5.9%
경기도 590
 
5.9%
대구시 589
 
5.9%
울산시 586
 
5.9%
인천시 585
 
5.9%
충청북도 585
 
5.9%
Other values (7) 4030
40.3%

태양광발전량(Mwh)
Real number (ℝ)

ZEROS 

Distinct7551
Distinct (%)75.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean66.732031
Minimum0
Maximum1794.5669
Zeros2071
Zeros (%)20.7%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-23T07:47:29.145813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.0020765
median4.003974
Q339.978566
95-th percentile372.11126
Maximum1794.5669
Range1794.5669
Interquartile range (IQR)39.97649

Descriptive statistics

Standard deviation168.35079
Coefficient of variation (CV)2.5227883
Kurtosis25.713399
Mean66.732031
Median Absolute Deviation (MAD)4.003974
Skewness4.5056961
Sum667320.31
Variance28341.988
MonotonicityNot monotonic
2023-12-23T07:47:29.982761image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 2071
 
20.7%
4e-05 36
 
0.4%
8e-05 30
 
0.3%
6e-06 23
 
0.2%
0.0014 19
 
0.2%
0.0004 16
 
0.2%
0.0002 14
 
0.1%
0.00144 11
 
0.1%
0.2644 10
 
0.1%
0.00216 9
 
0.1%
Other values (7541) 7761
77.6%
ValueCountFrequency (%)
0.0 2071
20.7%
3e-06 3
 
< 0.1%
6e-06 23
 
0.2%
1.2e-05 1
 
< 0.1%
2.4e-05 1
 
< 0.1%
2.8e-05 1
 
< 0.1%
3e-05 1
 
< 0.1%
3.2e-05 1
 
< 0.1%
3.3e-05 1
 
< 0.1%
3.6e-05 1
 
< 0.1%
ValueCountFrequency (%)
1794.566869 1
< 0.1%
1792.254292 1
< 0.1%
1736.105798 1
< 0.1%
1586.698046 1
< 0.1%
1581.872612 1
< 0.1%
1575.50204 1
< 0.1%
1527.661485 1
< 0.1%
1524.480793 1
< 0.1%
1485.563124 1
< 0.1%
1475.29182 1
< 0.1%

풍력발전량(Mwh)
Real number (ℝ)

MISSING  ZEROS 

Distinct4219
Distinct (%)65.5%
Missing3560
Missing (%)35.6%
Infinite0
Infinite (%)0.0%
Mean34.635893
Minimum0
Maximum389.84719
Zeros2112
Zeros (%)21.1%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-23T07:47:30.986334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median1.932
Q331.022513
95-th percentile208.73245
Maximum389.84719
Range389.84719
Interquartile range (IQR)31.022513

Descriptive statistics

Standard deviation69.162751
Coefficient of variation (CV)1.9968519
Kurtosis6.3104962
Mean34.635893
Median Absolute Deviation (MAD)1.932
Skewness2.5858542
Sum223055.15
Variance4783.4861
MonotonicityNot monotonic
2023-12-23T07:47:31.723685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 2112
21.1%
0.000723 8
 
0.1%
0.336 7
 
0.1%
0.001085 6
 
0.1%
0.00192 6
 
0.1%
0.00576 6
 
0.1%
0.001808 6
 
0.1%
0.000362 5
 
0.1%
0.00384 5
 
0.1%
0.672 4
 
< 0.1%
Other values (4209) 4275
42.8%
(Missing) 3560
35.6%
ValueCountFrequency (%)
0.0 2112
21.1%
5.6e-05 1
 
< 0.1%
0.000241 2
 
< 0.1%
0.000288 1
 
< 0.1%
0.00036 2
 
< 0.1%
0.000362 5
 
0.1%
0.000482 1
 
< 0.1%
0.000504 1
 
< 0.1%
0.00054 3
 
< 0.1%
0.000672 1
 
< 0.1%
ValueCountFrequency (%)
389.847194 1
< 0.1%
380.739766 1
< 0.1%
378.613857 1
< 0.1%
370.82111 1
< 0.1%
362.750671 1
< 0.1%
357.524721 1
< 0.1%
354.583375 1
< 0.1%
354.025774 1
< 0.1%
353.821173 1
< 0.1%
351.665233 1
< 0.1%

Interactions

2023-12-23T07:47:21.282274image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:17.931095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:19.511195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:22.055313image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:18.362836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:20.000215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:22.742242image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:19.104500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-23T07:47:20.806580image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-23T07:47:32.249575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
거래일자거래시간지역명태양광발전량(Mwh)풍력발전량(Mwh)
거래일자1.0000.0000.0000.1540.477
거래시간0.0001.0000.0000.4330.058
지역명0.0000.0001.0000.5080.482
태양광발전량(Mwh)0.1540.4330.5081.0000.083
풍력발전량(Mwh)0.4770.0580.4820.0831.000
2023-12-23T07:47:32.836404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
거래시간태양광발전량(Mwh)풍력발전량(Mwh)지역명
거래시간1.0000.3410.0260.000
태양광발전량(Mwh)0.3411.0000.1450.225
풍력발전량(Mwh)0.0260.1451.0000.228
지역명0.0000.2250.2281.000

Missing values

2023-12-23T07:47:23.456783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-23T07:47:24.259631image/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

거래일자거래시간지역명태양광발전량(Mwh)풍력발전량(Mwh)
60752023-09-154울산시0.00.0
334212023-11-2114울산시29.905460.0
143642023-10-0613경상북도475.545731.659299
102452023-09-2622강원도0.089560.42085
369662023-11-307인천시0.09.703425
321382023-11-183대구시0.0<NA>
363202023-11-299경기도32.0347320.050259
62542023-09-1615전라북도10.7688390.0348
273332023-11-0622부산시0.00.0
139372023-10-0518경상남도44.9977585.063362
거래일자거래시간지역명태양광발전량(Mwh)풍력발전량(Mwh)
62412023-09-162전라북도0.00.114778
202062023-10-2023제주도0.918028195.21487
186642023-10-1617광주시15.756408<NA>
165052023-10-1118충청북도46.170354<NA>
271052023-11-0610충청북도3.580037<NA>
100372023-09-256인천시0.02.212402
293082023-11-115세종시0.0<NA>
32662023-09-093경기도0.00.0
65022023-09-1623울산시0.00.0
195732023-10-1814부산시67.1228160.0