Overview

Dataset statistics

Number of variables3
Number of observations85
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory27.5 B

Variable types

Categorical2
Numeric1

Dataset

Description2017년 ~ 2021년도까지의 광역지자체별 전력거래량을 나타냅니다.단위 : GWh※ 전력거래량은 수정정산으로 인해 값이 변경될 수 있습니다.
Author한국전력거래소
URLhttps://www.data.go.kr/data/15104278/fileData.do

Alerts

전력거래량 is highly overall correlated with 지역High correlation
지역 is highly overall correlated with 전력거래량High correlation
전력거래량 has unique valuesUnique

Reproduction

Analysis started2024-03-15 01:05:15.936268
Analysis finished2024-03-15 01:05:16.827021
Duration0.89 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

지역
Categorical

HIGH CORRELATION 

Distinct17
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Memory size808.0 B
경기도
 
5
강원도
 
5
경상남도
 
5
경상북도
 
5
전라남도
 
5
Other values (12)
60 

Length

Max length4
Median length3
Mean length3.3529412
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row경기도
2nd row강원도
3rd row경상남도
4th row경상북도
5th row전라남도

Common Values

ValueCountFrequency (%)
경기도 5
 
5.9%
강원도 5
 
5.9%
경상남도 5
 
5.9%
경상북도 5
 
5.9%
전라남도 5
 
5.9%
전라북도 5
 
5.9%
충청남도 5
 
5.9%
충청북도 5
 
5.9%
제주도 5
 
5.9%
서울시 5
 
5.9%
Other values (7) 35
41.2%

Length

2024-03-15T10:05:16.943098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 5
 
5.9%
서울시 5
 
5.9%
울산시 5
 
5.9%
세종시 5
 
5.9%
대구시 5
 
5.9%
광주시 5
 
5.9%
대전시 5
 
5.9%
인천시 5
 
5.9%
제주도 5
 
5.9%
강원도 5
 
5.9%
Other values (7) 35
41.2%

연도
Categorical

Distinct5
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size808.0 B
2017
17 
2018
17 
2019
17 
2020
17 
2021
17 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2017
2nd row2017
3rd row2017
4th row2017
5th row2017

Common Values

ValueCountFrequency (%)
2017 17
20.0%
2018 17
20.0%
2019 17
20.0%
2020 17
20.0%
2021 17
20.0%

Length

2024-03-15T10:05:17.147069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T10:05:17.433060image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2017 17
20.0%
2018 17
20.0%
2019 17
20.0%
2020 17
20.0%
2021 17
20.0%

전력거래량
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct85
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean31069.141
Minimum169
Maximum122424
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size893.0 B
2024-03-15T10:05:17.851143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum169
5-th percentile245
Q12657
median19902
Q354371
95-th percentile98309
Maximum122424
Range122255
Interquartile range (IQR)51714

Descriptive statistics

Standard deviation33219.568
Coefficient of variation (CV)1.0692142
Kurtosis0.12905421
Mean31069.141
Median Absolute Deviation (MAD)18806
Skewness0.97837846
Sum2640877
Variance1.1035397 × 109
MonotonicityNot monotonic
2024-03-15T10:05:18.151307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
58961 1
 
1.2%
80581 1
 
1.2%
169 1
 
1.2%
54608 1
 
1.2%
4956 1
 
1.2%
3829 1
 
1.2%
1551 1
 
1.2%
105447 1
 
1.2%
9871 1
 
1.2%
51713 1
 
1.2%
Other values (75) 75
88.2%
ValueCountFrequency (%)
169 1
1.2%
174 1
1.2%
177 1
1.2%
196 1
1.2%
203 1
1.2%
413 1
1.2%
422 1
1.2%
429 1
1.2%
450 1
1.2%
461 1
1.2%
ValueCountFrequency (%)
122424 1
1.2%
120715 1
1.2%
114874 1
1.2%
105447 1
1.2%
102741 1
1.2%
80581 1
1.2%
80234 1
1.2%
79858 1
1.2%
75475 1
1.2%
75178 1
1.2%

Interactions

2024-03-15T10:05:16.103637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T10:05:18.312837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역연도전력거래량
지역1.0000.0000.911
연도0.0001.0000.000
전력거래량0.9110.0001.000
2024-03-15T10:05:18.460490image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역연도
지역1.0000.000
연도0.0001.000
2024-03-15T10:05:18.699445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
전력거래량지역연도
전력거래량1.0000.6390.000
지역0.6391.0000.000
연도0.0000.0001.000

Missing values

2024-03-15T10:05:16.451866image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T10:05:16.770463image/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

지역연도전력거래량
0경기도201758961
1강원도201719803
2경상남도201752652
3경상북도201779858
4전라남도201760694
5전라북도20178650
6충청남도2017122424
7충청북도20171096
8제주도20172944
9서울시2017810
지역연도전력거래량
75충청북도20211314
76제주도20214074
77서울시20215170
78인천시202158059
79대전시2021177
80광주시2021461
81대구시20212737
82세종시20213642
83울산시202130244
84부산시202138643