Overview

Dataset statistics

Number of variables7
Number of observations251
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory15.1 KiB
Average record size in memory61.5 B

Variable types

Categorical3
Numeric4

Dataset

Description한국서부발전 발전설비 의 발전소별 발전량 입니다.제공항목은 운전일,사업소명,호기명,용량,최대 발전량,최소 발전량,총발전량 데이터를 제공합니다.
Author한국서부발전(주)
URLhttps://www.data.go.kr/data/15123066/fileData.do

Alerts

사업소명 has constant value ""Constant
호기 is highly overall correlated with 최대 발전량 and 3 other fieldsHigh correlation
최대 발전량 is highly overall correlated with 호기 and 3 other fieldsHigh correlation
최소 발전량 is highly overall correlated with 호기 and 3 other fieldsHigh correlation
총발전량 is highly overall correlated with 호기 and 3 other fieldsHigh correlation
용량 is highly overall correlated with 호기 and 3 other fieldsHigh correlation

Reproduction

Analysis started2023-12-12 21:33:04.029030
Analysis finished2023-12-12 21:33:06.244851
Duration2.22 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

운전일
Categorical

Distinct31
Distinct (%)12.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
2022-12-19
 
9
2022-12-18
 
9
2022-12-15
 
9
2022-12-02
 
8
2022-12-03
 
8
Other values (26)
208 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-12-01
2nd row2022-12-01
3rd row2022-12-01
4th row2022-12-01
5th row2022-12-01

Common Values

ValueCountFrequency (%)
2022-12-19 9
 
3.6%
2022-12-18 9
 
3.6%
2022-12-15 9
 
3.6%
2022-12-02 8
 
3.2%
2022-12-03 8
 
3.2%
2022-12-04 8
 
3.2%
2022-12-05 8
 
3.2%
2022-12-06 8
 
3.2%
2022-12-07 8
 
3.2%
2022-12-08 8
 
3.2%
Other values (21) 168
66.9%

Length

2023-12-13T06:33:06.346244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2022-12-19 9
 
3.6%
2022-12-15 9
 
3.6%
2022-12-18 9
 
3.6%
2022-12-16 8
 
3.2%
2022-12-01 8
 
3.2%
2022-12-17 8
 
3.2%
2022-12-30 8
 
3.2%
2022-12-29 8
 
3.2%
2022-12-28 8
 
3.2%
2022-12-27 8
 
3.2%
Other values (21) 168
66.9%

사업소명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
태안
251 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row태안
2nd row태안
3rd row태안
4th row태안
5th row태안

Common Values

ValueCountFrequency (%)
태안 251
100.0%

Length

2023-12-13T06:33:06.473666image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:33:06.562829image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
태안 251
100.0%

호기
Real number (ℝ)

HIGH CORRELATION 

Distinct9
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5.7450199
Minimum1
Maximum10
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-13T06:33:06.642625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q13
median5
Q38
95-th percentile10
Maximum10
Range9
Interquartile range (IQR)5

Descriptive statistics

Standard deviation3.042158
Coefficient of variation (CV)0.52952958
Kurtosis-1.3391264
Mean5.7450199
Median Absolute Deviation (MAD)3
Skewness-0.14865896
Sum1442
Variance9.2547251
MonotonicityNot monotonic
2023-12-13T06:33:06.757601image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
4 31
12.4%
5 31
12.4%
7 31
12.4%
8 31
12.4%
9 31
12.4%
10 31
12.4%
1 29
11.6%
2 28
11.2%
3 8
 
3.2%
ValueCountFrequency (%)
1 29
11.6%
2 28
11.2%
3 8
 
3.2%
4 31
12.4%
5 31
12.4%
7 31
12.4%
8 31
12.4%
9 31
12.4%
10 31
12.4%
ValueCountFrequency (%)
10 31
12.4%
9 31
12.4%
8 31
12.4%
7 31
12.4%
5 31
12.4%
4 31
12.4%
3 8
 
3.2%
2 28
11.2%
1 29
11.6%

용량
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)0.8%
Missing0
Missing (%)0.0%
Memory size2.1 KiB
500
189 
1050
62 

Length

Max length4
Median length3
Mean length3.247012
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
500 189
75.3%
1050 62
 
24.7%

Length

2023-12-13T06:33:06.883176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:33:06.987965image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
500 189
75.3%
1050 62
 
24.7%

최대 발전량
Real number (ℝ)

HIGH CORRELATION 

Distinct231
Distinct (%)92.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean537185.33
Minimum159693.22
Maximum1239391.8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-13T06:33:07.113262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum159693.22
5-th percentile385632.69
Q1391000
median406150
Q3473281
95-th percentile975664
Maximum1239391.8
Range1079698.6
Interquartile range (IQR)82281

Descriptive statistics

Standard deviation229293.58
Coefficient of variation (CV)0.42684259
Kurtosis-0.29985765
Mean537185.33
Median Absolute Deviation (MAD)22882.541
Skewness1.1818684
Sum1.3483352 × 108
Variance5.2575546 × 1010
MonotonicityNot monotonic
2023-12-13T06:33:07.261408image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
394000.0 6
 
2.4%
388000.0 5
 
2.0%
392000.0 4
 
1.6%
391000.0 3
 
1.2%
441000.0 2
 
0.8%
443000.0 2
 
0.8%
390000.0 2
 
0.8%
393000.0 2
 
0.8%
397000.0 2
 
0.8%
389000.0 2
 
0.8%
Other values (221) 221
88.0%
ValueCountFrequency (%)
159693.223 1
0.4%
181220.192 1
0.4%
357000.0 1
0.4%
381374.716 1
0.4%
382425.598 1
0.4%
382983.406 1
0.4%
383267.459 1
0.4%
383511.617 1
0.4%
384446.721 1
0.4%
384505.379 1
0.4%
ValueCountFrequency (%)
1239391.8 1
0.4%
984109.35 1
0.4%
980890.6 1
0.4%
980001.317 1
0.4%
979386.483 1
0.4%
978724.283 1
0.4%
978253.55 1
0.4%
978054.233 1
0.4%
977835.95 1
0.4%
976920.617 1
0.4%

최소 발전량
Real number (ℝ)

HIGH CORRELATION 

Distinct228
Distinct (%)90.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean420180.87
Minimum322.2
Maximum951764.72
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-13T06:33:07.388277image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum322.2
5-th percentile22295.591
Q1341399.31
median349712
Q3401590.6
95-th percentile785936.23
Maximum951764.72
Range951442.52
Interquartile range (IQR)60191.288

Descriptive statistics

Standard deviation214366.45
Coefficient of variation (CV)0.51017661
Kurtosis-0.019622002
Mean420180.87
Median Absolute Deviation (MAD)34225.6
Skewness0.56028616
Sum1.054654 × 108
Variance4.5952975 × 1010
MonotonicityNot monotonic
2023-12-13T06:33:07.552845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
344000.0 7
 
2.8%
347000.0 5
 
2.0%
343000.0 4
 
1.6%
346000.0 4
 
1.6%
345000.0 2
 
0.8%
348000.0 2
 
0.8%
1000.0 2
 
0.8%
340000.0 2
 
0.8%
339000.0 2
 
0.8%
336000.0 2
 
0.8%
Other values (218) 219
87.3%
ValueCountFrequency (%)
322.2 1
0.4%
844.8 1
0.4%
1000.0 2
0.8%
3000.0 1
0.4%
3166.667 1
0.4%
4000.0 1
0.4%
4741.0 1
0.4%
10527.853 1
0.4%
15162.4 1
0.4%
15208.0 1
0.4%
ValueCountFrequency (%)
951764.717 1
0.4%
868785.683 1
0.4%
865560.95 1
0.4%
839895.233 1
0.4%
828577.9 1
0.4%
793106.283 1
0.4%
793091.067 1
0.4%
789388.517 1
0.4%
787840.95 1
0.4%
787754.583 1
0.4%

총발전량
Real number (ℝ)

HIGH CORRELATION 

Distinct250
Distinct (%)99.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11292498
Minimum159693.22
Maximum23178415
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.3 KiB
2023-12-13T06:33:07.679190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum159693.22
5-th percentile4199878.8
Q18976524.8
median9256000
Q310089205
95-th percentile21822836
Maximum23178415
Range23018722
Interquartile range (IQR)1112680.4

Descriptive statistics

Standard deviation5298108.3
Coefficient of variation (CV)0.46917062
Kurtosis0.022340083
Mean11292498
Median Absolute Deviation (MAD)412606
Skewness1.0142727
Sum2.8344171 × 109
Variance2.8069952 × 1013
MonotonicityNot monotonic
2023-12-13T06:33:07.823792image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9224000.0 2
 
0.8%
9285269.467 1
 
0.4%
9196000.0 1
 
0.4%
19434117.0 1
 
0.4%
20334813.79 1
 
0.4%
9193425.588 1
 
0.4%
8976332.279 1
 
0.4%
8882475.964 1
 
0.4%
9180000.0 1
 
0.4%
9630967.6 1
 
0.4%
Other values (240) 240
95.6%
ValueCountFrequency (%)
159693.223 1
0.4%
181220.192 1
0.4%
2969446.721 1
0.4%
3027468.983 1
0.4%
3103456.4 1
0.4%
3292155.463 1
0.4%
3459495.265 1
0.4%
3631160.158 1
0.4%
3915744.8 1
0.4%
3968000.0 1
0.4%
ValueCountFrequency (%)
23178415.01 1
0.4%
22924640.59 1
0.4%
22881595.99 1
0.4%
22832678.81 1
0.4%
22723126.39 1
0.4%
22710696.19 1
0.4%
22670834.4 1
0.4%
22650705.19 1
0.4%
22420477.61 1
0.4%
22407837.0 1
0.4%

Interactions

2023-12-13T06:33:05.665868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:04.266163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:04.852555image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.302276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.753287image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:04.338655image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:04.965176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.390200image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.848657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:04.415096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.095482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.476683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.930330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:04.780035image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.192667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:33:05.573440image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:33:07.917897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
운전일호기용량최대 발전량최소 발전량총발전량
운전일1.0000.0000.0000.0000.3260.307
호기0.0001.0001.0000.6420.8480.839
용량0.0001.0001.0001.0000.9040.921
최대 발전량0.0000.6421.0001.0000.8720.860
최소 발전량0.3260.8480.9040.8721.0000.866
총발전량0.3070.8390.9210.8600.8661.000
2023-12-13T06:33:08.016119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
운전일용량
운전일1.0000.000
용량0.0001.000
2023-12-13T06:33:08.121499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
호기최대 발전량최소 발전량총발전량운전일용량
호기1.0000.6900.6690.6920.0000.986
최대 발전량0.6901.0000.5490.7220.0000.990
최소 발전량0.6690.5491.0000.8790.1110.924
총발전량0.6920.7220.8791.0000.1030.947
운전일0.0000.0000.1110.1031.0000.000
용량0.9860.9900.9240.9470.0001.000

Missing values

2023-12-13T06:33:06.056169image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:33:06.188463image/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

운전일사업소명호기용량최대 발전량최소 발전량총발전량
02022-12-01태안1500441000.0335000.09285269.467
12022-12-01태안3500433900.282336623.5399174954.317
22022-12-01태안4500431943.008343276.4749192245.009
32022-12-01태안5500439879.0349833.09324000.0
42022-12-01태안7500438330.4400186.09781410.4
52022-12-01태안8500403071.616947.67464848.0
62022-12-01태안91050923493.667781605.06719509024.41
72022-12-01태안101050965805.15780284.5520004085.8
82022-12-02태안1500389000.0334000.09048930.42
92022-12-02태안3500385449.396336368.9838947331.481
운전일사업소명호기용량최대 발전량최소 발전량총발전량
2412022-12-30태안91050927591.917780204.31719733850.41
2422022-12-30태안101050975689.167779877.96720858646.41
2432022-12-31태안1500357000.0209468.9833027468.983
2442022-12-31태안2500441948.053332000.08430948.053
2452022-12-31태안4500429585.47338521.9098435705.048
2462022-12-31태안5500468612.0347354.08848000.0
2472022-12-31태안7500400168.8153649.63103456.4
2482022-12-31태안8500466998.4343641.69627576.0
2492022-12-31태안91050925367.717779497.51719436918.81
2502022-12-31태안101050870755.232635.66698354.0