Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
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연도별 연료원별 시간대별 설비용량 및 전력거래량 정보입니다.본자료는 전력시장에서 거래하는 발전기의 정보만 포함하고 있습니다.전력거래량(발전량)은 소내용 및 주변압기 손실분 등을 제외한 송전단 기준 발전량입니다.추후 수정정산 등에 의해 수치는 변경될 수 있습니다.
Author한국전력거래소
URLhttps://www.data.go.kr/data/15127395/fileData.do

Alerts

설비용량(MW) is highly overall correlated with 전력거래량(MWh) and 1 other fieldsHigh correlation
전력거래량(MWh) is highly overall correlated with 설비용량(MW) High correlation
연료원 is highly overall correlated with 설비용량(MW) High correlation
전력거래량(MWh) has 1275 (12.8%) zerosZeros

Reproduction

Analysis started2024-04-06 08:26:33.223569
Analysis finished2024-04-06 08:26:36.400939
Duration3.18 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

거래일자
Date

Distinct208
Distinct (%)2.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:00:00
Maximum2023-07-27 00:00:00
2024-04-06T17:26:36.594639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:36.898731image/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.4861
Minimum1
Maximum24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:26:37.334290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2
Q17
median12
Q318
95-th percentile23
Maximum24
Range23
Interquartile range (IQR)11

Descriptive statistics

Standard deviation6.8769133
Coefficient of variation (CV)0.55076551
Kurtosis-1.1851692
Mean12.4861
Median Absolute Deviation (MAD)6
Skewness0.010932732
Sum124861
Variance47.291936
MonotonicityNot monotonic
2024-04-06T17:26:37.655735image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
10 459
 
4.6%
16 458
 
4.6%
15 442
 
4.4%
8 437
 
4.4%
23 434
 
4.3%
5 432
 
4.3%
18 427
 
4.3%
22 423
 
4.2%
11 419
 
4.2%
3 418
 
4.2%
Other values (14) 5651
56.5%
ValueCountFrequency (%)
1 402
4.0%
2 406
4.1%
3 418
4.2%
4 390
3.9%
5 432
4.3%
6 418
4.2%
7 417
4.2%
8 437
4.4%
9 416
4.2%
10 459
4.6%
ValueCountFrequency (%)
24 405
4.0%
23 434
4.3%
22 423
4.2%
21 396
4.0%
20 385
3.9%
19 380
3.8%
18 427
4.3%
17 415
4.2%
16 458
4.6%
15 442
4.4%

연료원
Categorical

HIGH CORRELATION 

Distinct21
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
폐기물
 
536
수력
 
536
무연탄
 
519
태양광
 
517
원자력
 
516
Other values (16)
7376 

Length

Max length6
Median length5
Mean length3.3096
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row바이오가스
2nd row기타
3rd row매립가스
4th row양수
5th row경유

Common Values

ValueCountFrequency (%)
폐기물 536
 
5.4%
수력 536
 
5.4%
무연탄 519
 
5.2%
태양광 517
 
5.2%
원자력 516
 
5.2%
바이오중유 514
 
5.1%
바이오가스 512
 
5.1%
연료전지 508
 
5.1%
매립가스 498
 
5.0%
IGCC 498
 
5.0%
Other values (11) 4846
48.5%

Length

2024-04-06T17:26:37.963349image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
폐기물 536
 
5.4%
수력 536
 
5.4%
무연탄 519
 
5.2%
태양광 517
 
5.2%
원자력 516
 
5.2%
바이오중유 514
 
5.1%
바이오가스 512
 
5.1%
연료전지 508
 
5.1%
매립가스 498
 
5.0%
igcc 498
 
5.0%
Other values (11) 4846
48.5%

설비용량(MW)
Real number (ℝ)

HIGH CORRELATION 

Distinct176
Distinct (%)1.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6596.9845
Minimum5
Maximum43963
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:26:38.266510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5
5-th percentile64
Q1346
median864
Q34700
95-th percentile39181
Maximum43963
Range43958
Interquartile range (IQR)4354

Descriptive statistics

Standard deviation12713.314
Coefficient of variation (CV)1.9271402
Kurtosis2.8277342
Mean6596.9845
Median Absolute Deviation (MAD)779
Skewness2.0958391
Sum65969845
Variance1.6162835 × 108
MonotonicityNot monotonic
2024-04-06T17:26:38.560985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
400 519
 
5.2%
24650 516
 
5.2%
390 514
 
5.1%
1803 507
 
5.1%
346 498
 
5.0%
64 497
 
5.0%
39181 495
 
5.0%
4700 485
 
4.9%
612 476
 
4.8%
109 469
 
4.7%
Other values (166) 5024
50.2%
ValueCountFrequency (%)
5 25
 
0.2%
60 1
 
< 0.1%
64 497
5.0%
74 58
 
0.6%
75 72
 
0.7%
83 142
 
1.4%
85 240
2.4%
109 469
4.7%
110 4
 
< 0.1%
149 213
2.1%
ValueCountFrequency (%)
43963 115
 
1.1%
43933 68
 
0.7%
43842 92
 
0.9%
43459 72
 
0.7%
43229 18
 
0.2%
43090 9
 
0.1%
42418 25
 
0.2%
41923 29
 
0.3%
41805 64
 
0.6%
39181 495
5.0%

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

HIGH CORRELATION  ZEROS 

Distinct2527
Distinct (%)25.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean3091.375
Minimum0
Maximum35417
Zeros1275
Zeros (%)12.8%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-04-06T17:26:39.177285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q128
median140
Q3707
95-th percentile20011.05
Maximum35417
Range35417
Interquartile range (IQR)679

Descriptive statistics

Standard deviation6850.4598
Coefficient of variation (CV)2.2159912
Kurtosis2.8677104
Mean3091.375
Median Absolute Deviation (MAD)140
Skewness2.1250537
Sum30913750
Variance46928800
MonotonicityNot monotonic
2024-04-06T17:26:39.444051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1275
 
12.8%
71 202
 
2.0%
26 128
 
1.3%
28 120
 
1.2%
2 110
 
1.1%
27 102
 
1.0%
165 86
 
0.9%
17 86
 
0.9%
1 84
 
0.8%
29 81
 
0.8%
Other values (2517) 7726
77.3%
ValueCountFrequency (%)
0 1275
12.8%
1 84
 
0.8%
2 110
 
1.1%
3 57
 
0.6%
4 24
 
0.2%
5 73
 
0.7%
6 38
 
0.4%
7 11
 
0.1%
8 15
 
0.1%
9 21
 
0.2%
ValueCountFrequency (%)
35417 1
< 0.1%
31592 1
< 0.1%
29975 1
< 0.1%
29410 1
< 0.1%
29358 1
< 0.1%
28517 1
< 0.1%
28340 1
< 0.1%
28216 1
< 0.1%
28146 1
< 0.1%
28105 1
< 0.1%

Interactions

2024-04-06T17:26:35.357454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:34.093742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:34.722593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:35.603947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:34.318875image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:34.921535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:35.835865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:34.502156image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-06T17:26:35.120397image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-06T17:26:39.611194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시간연료원설비용량(MW)전력거래량(MWh)
시간1.0000.0360.0140.150
연료원0.0361.0001.0000.772
설비용량(MW)0.0141.0001.0000.915
전력거래량(MWh)0.1500.7720.9151.000
2024-04-06T17:26:39.785090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시간설비용량(MW)전력거래량(MWh)연료원
시간1.0000.0060.0870.013
설비용량(MW)0.0061.0000.6870.999
전력거래량(MWh)0.0870.6871.0000.416
연료원0.0130.9990.4161.000

Missing values

2024-04-06T17:26:36.120236image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-06T17:26:36.314175image/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

거래일자시간연료원설비용량(MW)전력거래량(MWh)
452072023-04-0516바이오가스8521
892732023-07-0518기타1092
982322023-07-241매립가스6428
54322023-01-129양수47001229
118602023-01-255경유61271
535372023-04-2218폐기물367102
767702023-06-0919바이오중유390159
251322023-02-225매립가스6430
833332023-06-236LNG4396312631
835032023-06-238기타1091
거래일자시간연료원설비용량(MW)전력거래량(MWh)
292942023-03-0315원자력2465020587
139832023-01-3016무연탄400334
829622023-06-2219바이오매스1265860
127882023-01-2721LNG4180525231
380002023-03-219바이오가스8522
898622023-07-077부생가스434043
736592023-06-034태양광76192
478712023-04-1016경유6120
261502023-02-2415태양광73414079
392942023-03-237IGCC3460