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/15071022/fileData.do

Alerts

일자 has unique valuesUnique
중유(MWh) has 850 (46.5%) zerosZeros

Reproduction

Analysis started2023-12-12 21:54:42.161682
Analysis finished2023-12-12 21:54:43.780136
Duration1.62 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-13T06:54:43.839933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:43.977587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

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

Distinct1750
Distinct (%)95.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20869.725
Minimum0
Maximum55427
Zeros14
Zeros (%)0.8%
Negative0
Negative (%)0.0%
Memory size16.2 KiB
2023-12-13T06:54:44.128092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile8530.25
Q115717.25
median20083
Q325259.75
95-th percentile35096.5
Maximum55427
Range55427
Interquartile range (IQR)9542.5

Descriptive statistics

Standard deviation8314.855
Coefficient of variation (CV)0.39841708
Kurtosis1.5352047
Mean20869.725
Median Absolute Deviation (MAD)4807.5
Skewness0.62534572
Sum38108118
Variance69136814
MonotonicityNot monotonic
2023-12-13T06:54:44.269119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 14
 
0.8%
7920 2
 
0.1%
26355 2
 
0.1%
9481 2
 
0.1%
18542 2
 
0.1%
21020 2
 
0.1%
18670 2
 
0.1%
17973 2
 
0.1%
18101 2
 
0.1%
17740 2
 
0.1%
Other values (1740) 1794
98.2%
ValueCountFrequency (%)
0 14
0.8%
2 1
 
0.1%
51 1
 
0.1%
379 1
 
0.1%
1136 1
 
0.1%
1344 1
 
0.1%
1488 1
 
0.1%
1973 1
 
0.1%
2004 1
 
0.1%
2312 1
 
0.1%
ValueCountFrequency (%)
55427 1
0.1%
53677 1
0.1%
53462 1
0.1%
52586 1
0.1%
52353 1
0.1%
51898 1
0.1%
50863 1
0.1%
50854 1
0.1%
50852 1
0.1%
50501 1
0.1%

석탄(MWh)
Real number (ℝ)

Distinct1789
Distinct (%)98.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean104242.16
Minimum62708
Maximum129927
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size16.2 KiB
2023-12-13T06:54:44.440867image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum62708
5-th percentile84002.75
Q195682
median105185.5
Q3112208.75
95-th percentile123482
Maximum129927
Range67219
Interquartile range (IQR)16526.75

Descriptive statistics

Standard deviation12067.096
Coefficient of variation (CV)0.11576022
Kurtosis-0.19549572
Mean104242.16
Median Absolute Deviation (MAD)8482.5
Skewness-0.26076822
Sum1.9034619 × 108
Variance1.4561481 × 108
MonotonicityNot monotonic
2023-12-13T06:54:44.646376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
102730 2
 
0.1%
100465 2
 
0.1%
94358 2
 
0.1%
107510 2
 
0.1%
105792 2
 
0.1%
107654 2
 
0.1%
96423 2
 
0.1%
111991 2
 
0.1%
95840 2
 
0.1%
108709 2
 
0.1%
Other values (1779) 1806
98.9%
ValueCountFrequency (%)
62708 1
0.1%
64065 1
0.1%
64440 1
0.1%
66291 1
0.1%
66704 1
0.1%
66932 1
0.1%
68024 1
0.1%
68467 1
0.1%
68791 1
0.1%
68989 1
0.1%
ValueCountFrequency (%)
129927 1
0.1%
129539 1
0.1%
129410 1
0.1%
129235 1
0.1%
129228 1
0.1%
129192 1
0.1%
129165 1
0.1%
129113 1
0.1%
128982 1
0.1%
128974 1
0.1%

중유(MWh)
Real number (ℝ)

ZEROS 

Distinct955
Distinct (%)52.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7508.1468
Minimum0
Maximum25516
Zeros850
Zeros (%)46.5%
Negative0
Negative (%)0.0%
Memory size16.2 KiB
2023-12-13T06:54:44.794691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10
median4057
Q315116.5
95-th percentile23530.75
Maximum25516
Range25516
Interquartile range (IQR)15116.5

Descriptive statistics

Standard deviation8625.8062
Coefficient of variation (CV)1.1488596
Kurtosis-1.0488173
Mean7508.1468
Median Absolute Deviation (MAD)4057
Skewness0.66844891
Sum13709876
Variance74404533
MonotonicityNot monotonic
2023-12-13T06:54:44.983691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 850
46.5%
11749 2
 
0.1%
20808 2
 
0.1%
25453 2
 
0.1%
7122 2
 
0.1%
5814 2
 
0.1%
5878 2
 
0.1%
15175 2
 
0.1%
18311 2
 
0.1%
22828 2
 
0.1%
Other values (945) 958
52.5%
ValueCountFrequency (%)
0 850
46.5%
1 1
 
0.1%
9 1
 
0.1%
27 1
 
0.1%
37 1
 
0.1%
41 1
 
0.1%
44 2
 
0.1%
54 1
 
0.1%
55 1
 
0.1%
57 1
 
0.1%
ValueCountFrequency (%)
25516 1
0.1%
25509 1
0.1%
25503 1
0.1%
25498 1
0.1%
25490 1
0.1%
25484 1
0.1%
25474 1
0.1%
25463 1
0.1%
25453 2
0.1%
25451 1
0.1%

Interactions

2023-12-13T06:54:42.966360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:42.307015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:42.634017image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:43.092816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:42.422152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:42.744196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:43.199776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:42.541554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:54:42.868363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:54:45.088424image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
액화천연가스 LNG(MWh)석탄(MWh)중유(MWh)
액화천연가스 LNG(MWh)1.0000.4630.523
석탄(MWh)0.4631.0000.352
중유(MWh)0.5230.3521.000
2023-12-13T06:54:45.201320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
액화천연가스 LNG(MWh)석탄(MWh)중유(MWh)
액화천연가스 LNG(MWh)1.0000.3840.215
석탄(MWh)0.3841.0000.112
중유(MWh)0.2150.1121.000

Missing values

2023-12-13T06:54:43.656832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:54:43.743256image/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-0128554931030
12015-01-02314131092360
22015-01-03267991112260
32015-01-04261501065720
42015-01-05297411114217936
52015-01-062901511127711924
62015-01-073498611183614146
72015-01-083362911181415000
82015-01-09356611117759338
92015-01-10303581109310
일자액화천연가스 LNG(MWh)석탄(MWh)중유(MWh)
18162019-12-22213271040800
18172019-12-23276631048968414
18182019-12-24306281054444323
18192019-12-25238321060160
18202019-12-26327371057670
18212019-12-27284901050040
18222019-12-28220601050390
18232019-12-29213071051960
18242019-12-30294771040120
18252019-12-31285911021500