Overview

Dataset statistics

Number of variables4
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory410.2 KiB
Average record size in memory42.0 B

Variable types

DateTime1
Categorical1
Numeric2

Dataset

Description전력시장에 참여하는 발전기의 연료원별 일별 시간대별 전력거래량 합계 자료입니다.단위 : MWh* 본 데이터는 전력시장에 참여하는 발전기의 전력거래량으로, 전기사업법 시행령 제19조 1항 2호에 따라 한국전력공사와 직접 거래하는 발전기, 자가용 등은 포함하지 않습니다.전력거래량은 소내용 및 주변압기 손실분 등을 제외한 송전단 기준 발전량이며, 수정정산 등에 의해 값이 변동될 수 있습니다.
Author한국전력거래소
URLhttps://www.data.go.kr/data/15081098/fileData.do

Alerts

전력거래량(MWh) has 2291 (22.9%) zerosZeros

Reproduction

Analysis started2023-12-12 14:29:33.681238
Analysis finished2023-12-12 14:29:34.592784
Duration0.91 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

거래일
Date

Distinct167
Distinct (%)1.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-05-01 00:00:00
Maximum2022-10-14 00:00:00
2023-12-12T23:29:34.673599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:29:34.847024image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

연료원
Categorical

Distinct25
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
폐기물
 
444
LNG
 
438
유연탄
 
432
원자력
 
428
부생가스
 
426
Other values (20)
7832 

Length

Max length6
Median length5
Mean length3.3372
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row원자력
2nd row수력
3rd row부생가스
4th row바이오가스
5th row가스압

Common Values

ValueCountFrequency (%)
폐기물 444
 
4.4%
LNG 438
 
4.4%
유연탄 432
 
4.3%
원자력 428
 
4.3%
부생가스 426
 
4.3%
경유 426
 
4.3%
태양광 422
 
4.2%
IGCC 415
 
4.2%
양수 412
 
4.1%
풍력 412
 
4.1%
Other values (15) 5745
57.5%

Length

2023-12-12T23:29:35.020149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
폐기물 444
 
4.4%
lng 438
 
4.4%
유연탄 432
 
4.3%
원자력 428
 
4.3%
부생가스 426
 
4.3%
경유 426
 
4.3%
태양광 422
 
4.2%
igcc 415
 
4.2%
양수 412
 
4.1%
풍력 412
 
4.1%
Other values (15) 5745
57.5%

거래시간
Real number (ℝ)

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

Quantile statistics

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

Descriptive statistics

Standard deviation6.9606193
Coefficient of variation (CV)0.55495383
Kurtosis-1.2109878
Mean12.5427
Median Absolute Deviation (MAD)6
Skewness-0.0050300873
Sum125427
Variance48.450222
MonotonicityNot monotonic
2023-12-12T23:29:35.268909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
11 451
 
4.5%
23 442
 
4.4%
22 435
 
4.3%
24 431
 
4.3%
12 429
 
4.3%
8 429
 
4.3%
16 428
 
4.3%
19 428
 
4.3%
17 427
 
4.3%
2 424
 
4.2%
Other values (14) 5676
56.8%
ValueCountFrequency (%)
1 423
4.2%
2 424
4.2%
3 417
4.2%
4 401
4.0%
5 424
4.2%
6 414
4.1%
7 412
4.1%
8 429
4.3%
9 402
4.0%
10 363
3.6%
ValueCountFrequency (%)
24 431
4.3%
23 442
4.4%
22 435
4.3%
21 418
4.2%
20 385
3.9%
19 428
4.3%
18 396
4.0%
17 427
4.3%
16 428
4.3%
15 408
4.1%

전력거래량(MWh)
Real number (ℝ)

ZEROS 

Distinct7700
Distinct (%)77.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2652.8634
Minimum0
Maximum32925.79
Zeros2291
Zeros (%)22.9%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T23:29:35.405635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q14.0645678
median75.639782
Q3574.51167
95-th percentile19967.824
Maximum32925.79
Range32925.79
Interquartile range (IQR)570.4471

Descriptive statistics

Standard deviation6530.3663
Coefficient of variation (CV)2.4616293
Kurtosis4.3884874
Mean2652.8634
Median Absolute Deviation (MAD)75.639782
Skewness2.4357284
Sum26528634
Variance42645684
MonotonicityNot monotonic
2023-12-12T23:29:35.542139image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 2291
 
22.9%
0.06048 2
 
< 0.1%
70.103488 2
 
< 0.1%
240.88456 2
 
< 0.1%
331.66689 2
 
< 0.1%
0.0864 2
 
< 0.1%
17.730548 2
 
< 0.1%
0.0882 2
 
< 0.1%
0.0909 2
 
< 0.1%
30.703876 2
 
< 0.1%
Other values (7690) 7691
76.9%
ValueCountFrequency (%)
0.0 2291
22.9%
0.00024 1
 
< 0.1%
0.000376 1
 
< 0.1%
0.001008 1
 
< 0.1%
0.001882 1
 
< 0.1%
0.002509 1
 
< 0.1%
0.00288 1
 
< 0.1%
0.00334 1
 
< 0.1%
0.00648 1
 
< 0.1%
0.008155 1
 
< 0.1%
ValueCountFrequency (%)
32925.79006 1
< 0.1%
29383.01712 1
< 0.1%
29343.71322 1
< 0.1%
29163.30812 1
< 0.1%
28672.56903 1
< 0.1%
28474.96006 1
< 0.1%
28408.92609 1
< 0.1%
28353.47931 1
< 0.1%
28286.07111 1
< 0.1%
28234.3482 1
< 0.1%

Interactions

2023-12-12T23:29:34.175547image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:29:33.931264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:29:34.294097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:29:34.045261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:29:35.635814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연료원거래시간전력거래량(MWh)
연료원1.0000.0000.787
거래시간0.0001.0000.131
전력거래량(MWh)0.7870.1311.000
2023-12-12T23:29:35.721726image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
거래시간전력거래량(MWh)연료원
거래시간1.0000.0620.000
전력거래량(MWh)0.0621.0000.416
연료원0.0000.4161.000

Missing values

2023-12-12T23:29:34.431337image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:29:34.549232image/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)
270172022-06-15원자력1819964.53387
721582022-08-29수력15713.853524
457082022-07-16부생가스1331.952448
126722022-05-22바이오가스147.386064
148442022-05-25가스압130.0
928012022-10-02경유1870.065184
568212022-08-03해양에너지140.0
882662022-09-25무연탄19164.132543
831332022-09-16LNG2222297.85461
976042022-10-10경유2170.231392
거래일연료원거래시간전력거래량(MWh)
386552022-07-04태양광161809.893471
281432022-06-16RPS160.0
799192022-09-11부생가스2434.499633
567602022-08-03연료전지1580.142543
690402022-08-24유연탄1725521.21742
899862022-09-27바이오SRF110.0
556022022-08-01경유190.0
369502022-07-01LPG1517.625104
232472022-06-08가스압160.0
888782022-09-26바이오가스723.190544