Overview

Dataset statistics

Number of variables5
Number of observations8784
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory360.4 KiB
Average record size in memory42.0 B

Variable types

DateTime1
Numeric2
Categorical2

Dataset

Description광주광역시 태양광 발전량(전력거래량)을 일별 시간대별로 정리한 자료입니다. ※ 전력거래량(MWh)은 한전 수급계약(PPA) 발전기의 발전량이 제외되어있어 광주광역시 전체의 태양광 발전량이 아님 단위 : MWh
Author한국전력거래소
URLhttps://www.data.go.kr/data/15069949/fileData.do

Alerts

지역 has constant value ""Constant
연료원 has constant value ""Constant
시간 has 366 (4.2%) zerosZeros
전력거래량(MWh) has 1593 (18.1%) zerosZeros

Reproduction

Analysis started2023-12-12 01:43:42.186948
Analysis finished2023-12-12 01:43:43.010189
Duration0.82 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

날짜
Date

Distinct366
Distinct (%)4.2%
Missing0
Missing (%)0.0%
Memory size68.8 KiB
Minimum2020-01-01 00:00:00
Maximum2020-12-31 00:00:00
2023-12-12T10:43:43.119787image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:43:43.291589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

시간
Real number (ℝ)

ZEROS 

Distinct24
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11.5
Minimum0
Maximum23
Zeros366
Zeros (%)4.2%
Negative0
Negative (%)0.0%
Memory size77.3 KiB
2023-12-12T10:43:43.444987image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile1
Q15.75
median11.5
Q317.25
95-th percentile22
Maximum23
Range23
Interquartile range (IQR)11.5

Descriptive statistics

Standard deviation6.9225806
Coefficient of variation (CV)0.60196353
Kurtosis-1.2041763
Mean11.5
Median Absolute Deviation (MAD)6
Skewness0
Sum101016
Variance47.922122
MonotonicityNot monotonic
2023-12-12T10:43:43.604654image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
1 366
 
4.2%
14 366
 
4.2%
0 366
 
4.2%
23 366
 
4.2%
22 366
 
4.2%
21 366
 
4.2%
20 366
 
4.2%
19 366
 
4.2%
18 366
 
4.2%
17 366
 
4.2%
Other values (14) 5124
58.3%
ValueCountFrequency (%)
0 366
4.2%
1 366
4.2%
2 366
4.2%
3 366
4.2%
4 366
4.2%
5 366
4.2%
6 366
4.2%
7 366
4.2%
8 366
4.2%
9 366
4.2%
ValueCountFrequency (%)
23 366
4.2%
22 366
4.2%
21 366
4.2%
20 366
4.2%
19 366
4.2%
18 366
4.2%
17 366
4.2%
16 366
4.2%
15 366
4.2%
14 366
4.2%

지역
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size68.8 KiB
광주시
8784 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광주시
2nd row광주시
3rd row광주시
4th row광주시
5th row광주시

Common Values

ValueCountFrequency (%)
광주시 8784
100.0%

Length

2023-12-12T10:43:43.748468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T10:43:43.864539image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주시 8784
100.0%

연료원
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size68.8 KiB
태양광
8784 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row태양광
2nd row태양광
3rd row태양광
4th row태양광
5th row태양광

Common Values

ValueCountFrequency (%)
태양광 8784
100.0%

Length

2023-12-12T10:43:43.995398image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T10:43:44.132244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
태양광 8784
100.0%

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

ZEROS 

Distinct6193
Distinct (%)70.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7.9549336
Minimum0
Maximum45.562448
Zeros1593
Zeros (%)18.1%
Negative0
Negative (%)0.0%
Memory size77.3 KiB
2023-12-12T10:43:44.256590image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q10.0250635
median1.50799
Q312.716002
95-th percentile33.774579
Maximum45.562448
Range45.562448
Interquartile range (IQR)12.690939

Descriptive statistics

Standard deviation11.556557
Coefficient of variation (CV)1.4527534
Kurtosis0.7523917
Mean7.9549336
Median Absolute Deviation (MAD)1.50799
Skewness1.4195399
Sum69876.136
Variance133.55401
MonotonicityNot monotonic
2023-12-12T10:43:44.402181image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0.0 1593
 
18.1%
0.1764 136
 
1.5%
0.00192 73
 
0.8%
0.00288 60
 
0.7%
0.00336 58
 
0.7%
0.00048 56
 
0.6%
0.00144 48
 
0.5%
0.00096 42
 
0.5%
0.17928 35
 
0.4%
0.17616 34
 
0.4%
Other values (6183) 6649
75.7%
ValueCountFrequency (%)
0.0 1593
18.1%
4.8e-05 1
 
< 0.1%
7.2e-05 3
 
< 0.1%
0.00012 1
 
< 0.1%
0.0002 11
 
0.1%
0.000232 1
 
< 0.1%
0.000272 3
 
< 0.1%
0.000304 1
 
< 0.1%
0.000344 3
 
< 0.1%
0.000352 1
 
< 0.1%
ValueCountFrequency (%)
45.562448 1
< 0.1%
45.475741 1
< 0.1%
45.424599 1
< 0.1%
45.05543 1
< 0.1%
44.927301 1
< 0.1%
44.845764 1
< 0.1%
44.69862 1
< 0.1%
44.612447 1
< 0.1%
44.603287 1
< 0.1%
44.441783 1
< 0.1%

Interactions

2023-12-12T10:43:42.608121image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:43:42.395561image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:43:42.700792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T10:43:42.490619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T10:43:44.532131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시간전력거래량(MWh)
시간1.0000.729
전력거래량(MWh)0.7291.000
2023-12-12T10:43:44.629531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
시간전력거래량(MWh)
시간1.0000.417
전력거래량(MWh)0.4171.000

Missing values

2023-12-12T10:43:42.824525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T10:43:42.941094image/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)
02020-01-011광주시태양광0.00312
12020-01-012광주시태양광0.0
22020-01-013광주시태양광0.0
32020-01-014광주시태양광0.0
42020-01-015광주시태양광0.0
52020-01-016광주시태양광0.0
62020-01-017광주시태양광0.0
72020-01-018광주시태양광0.024782
82020-01-019광주시태양광2.793274
92020-01-0110광주시태양광8.886056
날짜시간지역연료원전력거래량(MWh)
87742020-12-3114광주시태양광1.650067
87752020-12-3115광주시태양광0.941544
87762020-12-3116광주시태양광0.113484
87772020-12-3117광주시태양광0.00168
87782020-12-3118광주시태양광0.0
87792020-12-3119광주시태양광0.0
87802020-12-3120광주시태양광0.0
87812020-12-3121광주시태양광0.0
87822020-12-3122광주시태양광0.0
87832020-12-3123광주시태양광0.0