Overview

Dataset statistics

Number of variables4
Number of observations48
Missing cells24
Missing cells (%)12.5%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.8 KiB
Average record size in memory37.8 B

Variable types

DateTime1
Categorical1
Numeric2

Dataset

Description2018년 ~ 2021년까지의 월별 제주 신재생 에너지 발전 제어량 데이터입니다. 태양광 차단횟수, 풍력 발전 제어량(MWh), 풍력 발전 제어 횟수를 제공합니다. ※제주 태양광발전제어량은 제어대상 설비와 차단시간에 차단되지 않은 설비의 이용률로 환산한 값으로 기상상황, 지리적 위치, 설비의 성능에 따라 유동적이므로 단순 참고 사항임을 알려드립니다. ※제주 풍력발전제어량은 제어대상 설비의 차단시점 발전량을 차단시간으로 환산한 값으로 기상상황, 지리적 위치, 설비의 성능에 따라 유동적이므로 단순 참고 사항임을 알려드립니다.
Author한국전력거래소
URLhttps://www.data.go.kr/data/15100208/fileData.do

Alerts

풍력 발전 제어량(MWh) is highly overall correlated with 풍력 발전 제어 횟수High correlation
풍력 발전 제어 횟수 is highly overall correlated with 풍력 발전 제어량(MWh)High correlation
태양광 차단 횟수 is highly imbalanced (85.4%)Imbalance
풍력 발전 제어량(MWh) has 12 (25.0%) missing valuesMissing
풍력 발전 제어 횟수 has 12 (25.0%) missing valuesMissing
기간 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:42:07.142717
Analysis finished2023-12-12 05:42:07.832687
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기간
Date

UNIQUE 

Distinct48
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size516.0 B
Minimum2018-01-31 00:00:00
Maximum2021-12-31 00:00:00
2023-12-12T14:42:07.895208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:42:08.016895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=48)

태양광 차단 횟수
Categorical

IMBALANCE 

Distinct2
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size516.0 B
<NA>
47 
1
 
1

Length

Max length4
Median length4
Mean length3.9375
Min length1

Unique

Unique1 ?
Unique (%)2.1%

Sample

1st row<NA>
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 47
97.9%
1 1
 
2.1%

Length

2023-12-12T14:42:08.143790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T14:42:08.257993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
na 47
97.9%
1 1
 
2.1%

풍력 발전 제어량(MWh)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct36
Distinct (%)100.0%
Missing12
Missing (%)25.0%
Infinite0
Infinite (%)0.0%
Mean1168.1806
Minimum0.4
Maximum6481.1
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size564.0 B
2023-12-12T14:42:08.375943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.4
5-th percentile7.175
Q172.075
median528.3
Q32059.025
95-th percentile3745.65
Maximum6481.1
Range6480.7
Interquartile range (IQR)1986.95

Descriptive statistics

Standard deviation1449.7407
Coefficient of variation (CV)1.2410245
Kurtosis4.0788775
Mean1168.1806
Median Absolute Deviation (MAD)515.95
Skewness1.8259449
Sum42054.5
Variance2101748
MonotonicityNot monotonic
2023-12-12T14:42:08.539764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=36)
ValueCountFrequency (%)
4204.5 1
 
2.1%
1475.6 1
 
2.1%
118.6 1
 
2.1%
9.0 1
 
2.1%
193.5 1
 
2.1%
3054.3 1
 
2.1%
2205.4 1
 
2.1%
579.2 1
 
2.1%
424.5 1
 
2.1%
2054.8 1
 
2.1%
Other values (26) 26
54.2%
(Missing) 12
25.0%
ValueCountFrequency (%)
0.4 1
2.1%
1.7 1
2.1%
9.0 1
2.1%
15.7 1
2.1%
41.2 1
2.1%
43.3 1
2.1%
55.5 1
2.1%
56.0 1
2.1%
72.0 1
2.1%
72.1 1
2.1%
ValueCountFrequency (%)
6481.1 1
2.1%
4204.5 1
2.1%
3592.7 1
2.1%
3054.3 1
2.1%
2312.9 1
2.1%
2205.4 1
2.1%
2161.9 1
2.1%
2140.2 1
2.1%
2071.7 1
2.1%
2054.8 1
2.1%

풍력 발전 제어 횟수
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct13
Distinct (%)36.1%
Missing12
Missing (%)25.0%
Infinite0
Infinite (%)0.0%
Mean5.6111111
Minimum1
Maximum16
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size564.0 B
2023-12-12T14:42:08.670481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median5.5
Q39
95-th percentile13
Maximum16
Range15
Interquartile range (IQR)8

Descriptive statistics

Standard deviation4.4354274
Coefficient of variation (CV)0.7904722
Kurtosis-0.37854074
Mean5.6111111
Median Absolute Deviation (MAD)3.5
Skewness0.66545988
Sum202
Variance19.673016
MonotonicityNot monotonic
2023-12-12T14:42:08.792059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
1 10
20.8%
9 5
10.4%
2 4
 
8.3%
6 3
 
6.2%
3 2
 
4.2%
8 2
 
4.2%
16 2
 
4.2%
7 2
 
4.2%
11 2
 
4.2%
4 1
 
2.1%
Other values (3) 3
 
6.2%
(Missing) 12
25.0%
ValueCountFrequency (%)
1 10
20.8%
2 4
 
8.3%
3 2
 
4.2%
4 1
 
2.1%
5 1
 
2.1%
6 3
 
6.2%
7 2
 
4.2%
8 2
 
4.2%
9 5
10.4%
10 1
 
2.1%
ValueCountFrequency (%)
16 2
 
4.2%
12 1
 
2.1%
11 2
 
4.2%
10 1
 
2.1%
9 5
10.4%
8 2
 
4.2%
7 2
 
4.2%
6 3
6.2%
5 1
 
2.1%
4 1
 
2.1%

Interactions

2023-12-12T14:42:07.415923image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:42:07.238794image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:42:07.498829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:42:07.319298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:42:08.894862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기간풍력 발전 제어량(MWh)풍력 발전 제어 횟수
기간1.0001.0001.000
풍력 발전 제어량(MWh)1.0001.0000.893
풍력 발전 제어 횟수1.0000.8931.000
2023-12-12T14:42:09.051374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
풍력 발전 제어량(MWh)풍력 발전 제어 횟수태양광 차단 횟수
풍력 발전 제어량(MWh)1.0000.927NaN
풍력 발전 제어 횟수0.9271.000NaN
태양광 차단 횟수NaNNaN1.000

Missing values

2023-12-12T14:42:07.601755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:42:07.674163image/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.
2023-12-12T14:42:07.777323image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

기간태양광 차단 횟수풍력 발전 제어량(MWh)풍력 발전 제어 횟수
02018-01-31<NA><NA><NA>
12018-02-28<NA>1.71
22018-03-31<NA><NA><NA>
32018-04-30<NA>477.44
42018-05-31<NA>43.32
52018-06-30<NA><NA><NA>
62018-07-31<NA><NA><NA>
72018-08-31<NA>0.41
82018-09-30<NA>635.73
92018-10-31<NA>80.82
기간태양광 차단 횟수풍력 발전 제어량(MWh)풍력 발전 제어 횟수
382021-03-31<NA>2140.211
392021-04-30<NA>3592.716
402021-05-31<NA>2161.99
412021-06-30<NA><NA><NA>
422021-07-31<NA><NA><NA>
432021-08-31<NA><NA><NA>
442021-09-30<NA><NA><NA>
452021-10-3111497.77
462021-11-30<NA>72.01
472021-12-31<NA>72.11