Overview

Dataset statistics

Number of variables4
Number of observations1826
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory62.5 KiB
Average record size in memory35.1 B

Variable types

DateTime1
Numeric3

Dataset

Description한국동서발전의 원료원별 일별 발전량 정보입니다. 연료원별 일별 발전량은 일자, 액화천연가스 LNG(MWh), 석탄(MWh), 중유(MWh) 항목으로 제공합니다.
Author한국동서발전(주)
URLhttps://www.data.go.kr/data/15071020/fileData.do

Alerts

일자 has unique valuesUnique
중유(MWh) has 851 (46.6%) zerosZeros

Reproduction

Analysis started2023-12-11 23:28:13.087094
Analysis finished2023-12-11 23:28:14.443227
Duration1.36 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

일자
Date

UNIQUE 

Distinct1826
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size14.4 KiB
Minimum2015-01-01 00:00:00
Maximum2019-12-31 00:00:00
2023-12-12T08:28:14.522227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:14.682718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

액화천연가스 LNG(MWh)
Real number (ℝ)

Distinct1749
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean21341.22
Minimum0
Maximum56372
Zeros13
Zeros (%)0.7%
Negative0
Negative (%)0.0%
Memory size16.2 KiB
2023-12-12T08:28:14.827019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile8691.75
Q116037.5
median20589.5
Q325822.25
95-th percentile35801.75
Maximum56372
Range56372
Interquartile range (IQR)9784.75

Descriptive statistics

Standard deviation8454.8356
Coefficient of variation (CV)0.39617395
Kurtosis1.4927508
Mean21341.22
Median Absolute Deviation (MAD)4888.5
Skewness0.6063236
Sum38969068
Variance71484244
MonotonicityNot monotonic
2023-12-12T08:28:14.951952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 13
 
0.7%
14755 3
 
0.2%
18619 3
 
0.2%
13527 2
 
0.1%
18418 2
 
0.1%
23563 2
 
0.1%
18151 2
 
0.1%
31275 2
 
0.1%
15274 2
 
0.1%
11218 2
 
0.1%
Other values (1739) 1793
98.2%
ValueCountFrequency (%)
0 13
0.7%
5 1
 
0.1%
112 1
 
0.1%
285 1
 
0.1%
491 1
 
0.1%
1138 1
 
0.1%
1364 1
 
0.1%
1508 1
 
0.1%
2005 1
 
0.1%
2066 1
 
0.1%
ValueCountFrequency (%)
56372 1
0.1%
54593 1
0.1%
54401 1
0.1%
53273 1
0.1%
52815 1
0.1%
51787 1
0.1%
51754 1
0.1%
51739 1
0.1%
51397 1
0.1%
51288 1
0.1%

석탄(MWh)
Real number (ℝ)

Distinct1794
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean108355.33
Minimum57989
Maximum137347
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.2 KiB
2023-12-12T08:28:15.108109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum57989
5-th percentile81928.25
Q198982.5
median109729
Q3118385
95-th percentile130669.75
Maximum137347
Range79358
Interquartile range (IQR)19402.5

Descriptive statistics

Standard deviation14734.243
Coefficient of variation (CV)0.13598078
Kurtosis-0.083785736
Mean108355.33
Median Absolute Deviation (MAD)9593.5
Skewness-0.43776941
Sum1.9785684 × 108
Variance2.170979 × 108
MonotonicityNot monotonic
2023-12-12T08:28:15.277042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
98717 3
 
0.2%
106216 2
 
0.1%
119708 2
 
0.1%
98552 2
 
0.1%
121546 2
 
0.1%
118173 2
 
0.1%
117840 2
 
0.1%
105827 2
 
0.1%
107962 2
 
0.1%
103820 2
 
0.1%
Other values (1784) 1805
98.8%
ValueCountFrequency (%)
57989 1
0.1%
59332 1
0.1%
60144 1
0.1%
60358 1
0.1%
64479 1
0.1%
66016 1
0.1%
66221 1
0.1%
66263 1
0.1%
67530 1
0.1%
67896 1
0.1%
ValueCountFrequency (%)
137347 1
0.1%
136948 1
0.1%
136796 1
0.1%
136655 1
0.1%
136641 1
0.1%
136582 1
0.1%
136484 1
0.1%
136470 1
0.1%
136431 1
0.1%
136358 1
0.1%

중유(MWh)
Real number (ℝ)

ZEROS 

Distinct952
Distinct (%)52.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean8027.1928
Minimum0
Maximum27184
Zeros851
Zeros (%)46.6%
Negative0
Negative (%)0.0%
Memory size16.2 KiB
2023-12-12T08:28:15.445503image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median4346.5
Q316134
95-th percentile25198.5
Maximum27184
Range27184
Interquartile range (IQR)16134

Descriptive statistics

Standard deviation9219.1903
Coefficient of variation (CV)1.1484949
Kurtosis-1.0560247
Mean8027.1928
Median Absolute Deviation (MAD)4346.5
Skewness0.66571387
Sum14657654
Variance84993469
MonotonicityNot monotonic
2023-12-12T08:28:15.633203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 851
46.6%
26473 2
 
0.1%
13738 2
 
0.1%
7282 2
 
0.1%
6315 2
 
0.1%
12615 2
 
0.1%
6242 2
 
0.1%
59 2
 
0.1%
6265 2
 
0.1%
16344 2
 
0.1%
Other values (942) 957
52.4%
ValueCountFrequency (%)
0 851
46.6%
1 1
 
0.1%
9 1
 
0.1%
29 1
 
0.1%
41 2
 
0.1%
45 1
 
0.1%
46 1
 
0.1%
58 1
 
0.1%
59 2
 
0.1%
66 1
 
0.1%
ValueCountFrequency (%)
27184 1
0.1%
27172 1
0.1%
27166 1
0.1%
27164 1
0.1%
27154 1
0.1%
27150 1
0.1%
27141 1
0.1%
27127 1
0.1%
27118 1
0.1%
27117 2
0.1%

Interactions

2023-12-12T08:28:13.957577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:13.254856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:13.569968image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:14.071383image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:13.356055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:13.691831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:14.214049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:13.472893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:28:13.827402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:28:15.711758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
액화천연가스 LNG(MWh)석탄(MWh)중유(MWh)
액화천연가스 LNG(MWh)1.0000.4890.527
석탄(MWh)0.4891.0000.398
중유(MWh)0.5270.3981.000
2023-12-12T08:28:15.810012image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
액화천연가스 LNG(MWh)석탄(MWh)중유(MWh)
액화천연가스 LNG(MWh)1.0000.3760.214
석탄(MWh)0.3761.0000.032
중유(MWh)0.2140.0321.000

Missing values

2023-12-12T08:28:14.330535image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:28:14.408592image/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

일자액화천연가스 LNG(MWh)석탄(MWh)중유(MWh)
02015-01-0129190985250
12015-01-02320761154240
22015-01-03273921174900
32015-01-04267351126040
42015-01-05303731176658501
52015-01-062961411750212746
62015-01-073567611811215121
72015-01-083432411812416015
82015-01-09363741178909978
92015-01-10310031172010
일자액화천연가스 LNG(MWh)석탄(MWh)중유(MWh)
18162019-12-22218721105410
18172019-12-23282471113899040
18182019-12-24312751119164645
18192019-12-25243901125260
18202019-12-26334081122680
18212019-12-27291241114640
18222019-12-28226111113810
18232019-12-29218521115300
18242019-12-30301331101140
18252019-12-31292311114920