Overview

Dataset statistics

Number of variables6
Number of observations21
Missing cells19
Missing cells (%)15.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.2 KiB
Average record size in memory57.3 B

Variable types

Categorical2
DateTime1
Numeric2
Text1

Dataset

Description한국동서발전의 울산시민가상발전소 정보입니다. 한국동서발전에서 운영중인 VPP(울산시민가상발전소) 용량, 월별 발전량, 이용율 등의 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15117994/fileData.do

Alerts

발전소명 has constant value ""Constant
용량(MW) has constant value ""Constant
비고 has constant value ""Constant
발전량(kW) is highly overall correlated with 이용율(비율)High correlation
이용율(비율) is highly overall correlated with 발전량(kW)High correlation
비고 has 19 (90.5%) missing valuesMissing
구분 has unique valuesUnique
발전량(kW) has unique valuesUnique
이용율(비율) has unique valuesUnique

Reproduction

Analysis started2023-12-12 07:39:48.943547
Analysis finished2023-12-12 07:39:49.609051
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

발전소명
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
울산시민가상발전소
21 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row울산시민가상발전소
2nd row울산시민가상발전소
3rd row울산시민가상발전소
4th row울산시민가상발전소
5th row울산시민가상발전소

Common Values

ValueCountFrequency (%)
울산시민가상발전소 21
100.0%

Length

2023-12-12T16:39:49.687003image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:39:49.784853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
울산시민가상발전소 21
100.0%

용량(MW)
Categorical

CONSTANT 

Distinct1
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size300.0 B
1.5
21 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row1.5
2nd row1.5
3rd row1.5
4th row1.5
5th row1.5

Common Values

ValueCountFrequency (%)
1.5 21
100.0%

Length

2023-12-12T16:39:49.901516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:39:50.015538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1.5 21
100.0%

구분
Date

UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size300.0 B
Minimum2021-04-01 00:00:00
Maximum2022-12-01 00:00:00
2023-12-12T16:39:50.126310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:39:50.267679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)

발전량(kW)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean159623.29
Minimum52281
Maximum270355
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-12T16:39:50.423235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum52281
5-th percentile99769
Q1139238
median160661
Q3177942
95-th percentile222114
Maximum270355
Range218074
Interquartile range (IQR)38704

Descriptive statistics

Standard deviation42752.859
Coefficient of variation (CV)0.26783598
Kurtosis2.8552914
Mean159623.29
Median Absolute Deviation (MAD)21423
Skewness0.12537714
Sum3352089
Variance1.8278069 × 109
MonotonicityNot monotonic
2023-12-12T16:39:50.549550image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
52281 1
 
4.8%
99769 1
 
4.8%
138502 1
 
4.8%
164421 1
 
4.8%
145128 1
 
4.8%
163446 1
 
4.8%
177942 1
 
4.8%
195726 1
 
4.8%
270355 1
 
4.8%
222114 1
 
4.8%
Other values (11) 11
52.4%
ValueCountFrequency (%)
52281 1
4.8%
99769 1
4.8%
134219 1
4.8%
136163 1
4.8%
138502 1
4.8%
139238 1
4.8%
145128 1
4.8%
146435 1
4.8%
155660 1
4.8%
156198 1
4.8%
ValueCountFrequency (%)
270355 1
4.8%
222114 1
4.8%
195726 1
4.8%
183529 1
4.8%
182673 1
4.8%
177942 1
4.8%
164421 1
4.8%
164064 1
4.8%
163565 1
4.8%
163446 1
4.8%

이용율(비율)
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct21
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.779048
Minimum4.84
Maximum25.03
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size321.0 B
2023-12-12T16:39:50.689691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4.84
5-th percentile9.24
Q112.89
median14.88
Q316.48
95-th percentile20.57
Maximum25.03
Range20.19
Interquartile range (IQR)3.59

Descriptive statistics

Standard deviation3.9581598
Coefficient of variation (CV)0.26782239
Kurtosis2.8559817
Mean14.779048
Median Absolute Deviation (MAD)1.99
Skewness0.1255142
Sum310.36
Variance15.667029
MonotonicityNot monotonic
2023-12-12T16:39:50.869695image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
4.84 1
 
4.8%
9.24 1
 
4.8%
12.82 1
 
4.8%
15.22 1
 
4.8%
13.44 1
 
4.8%
15.13 1
 
4.8%
16.48 1
 
4.8%
18.12 1
 
4.8%
25.03 1
 
4.8%
20.57 1
 
4.8%
Other values (11) 11
52.4%
ValueCountFrequency (%)
4.84 1
4.8%
9.24 1
4.8%
12.43 1
4.8%
12.61 1
4.8%
12.82 1
4.8%
12.89 1
4.8%
13.44 1
4.8%
13.56 1
4.8%
14.41 1
4.8%
14.46 1
4.8%
ValueCountFrequency (%)
25.03 1
4.8%
20.57 1
4.8%
18.12 1
4.8%
16.99 1
4.8%
16.91 1
4.8%
16.48 1
4.8%
15.22 1
4.8%
15.19 1
4.8%
15.14 1
4.8%
15.13 1
4.8%

비고
Text

CONSTANT  MISSING 

Distinct1
Distinct (%)50.0%
Missing19
Missing (%)90.5%
Memory size300.0 B
2023-12-12T16:39:51.023818image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length6
Median length6
Mean length6
Min length6

Characters and Unicode

Total characters12
Distinct characters6
Distinct categories2 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row순차적 준공
2nd row순차적 준공
ValueCountFrequency (%)
순차적 2
50.0%
준공 2
50.0%
2023-12-12T16:39:51.296078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
순 2
16.7%
차 2
16.7%
적 2
16.7%
2
16.7%
준 2
16.7%
공 2
16.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10
83.3%
Space Separator 2
 
16.7%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
순 2
20.0%
차 2
20.0%
적 2
20.0%
준 2
20.0%
공 2
20.0%
Space Separator
ValueCountFrequency (%)
2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10
83.3%
Common 2
 
16.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
순 2
20.0%
차 2
20.0%
적 2
20.0%
준 2
20.0%
공 2
20.0%
Common
ValueCountFrequency (%)
2
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10
83.3%
ASCII 2
 
16.7%

Most frequent character per block

Hangul
ValueCountFrequency (%)
순 2
20.0%
차 2
20.0%
적 2
20.0%
준 2
20.0%
공 2
20.0%
ASCII
ValueCountFrequency (%)
2
100.0%

Interactions

2023-12-12T16:39:49.234450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:39:49.061908image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:39:49.317962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:39:49.143376image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T16:39:51.400445image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분발전량(kW)이용율(비율)
구분1.0001.0001.000
발전량(kW)1.0001.0001.000
이용율(비율)1.0001.0001.000
2023-12-12T16:39:51.484921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발전량(kW)이용율(비율)
발전량(kW)1.0001.000
이용율(비율)1.0001.000

Missing values

2023-12-12T16:39:49.437234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:39:49.555872image/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

발전소명용량(MW)구분발전량(kW)이용율(비율)비고
0울산시민가상발전소1.52021-04-01522814.84순차적 준공
1울산시민가상발전소1.52021-05-01997699.24순차적 준공
2울산시민가상발전소1.52021-06-0113616312.61<NA>
3울산시민가상발전소1.52021-07-0113923812.89<NA>
4울산시민가상발전소1.52021-08-0116356515.14<NA>
5울산시민가상발전소1.52021-09-0115619814.46<NA>
6울산시민가상발전소1.52021-10-0113421912.43<NA>
7울산시민가상발전소1.52021-11-0116406415.19<NA>
8울산시민가상발전소1.52021-12-0114643513.56<NA>
9울산시민가상발전소1.52022-01-0116066114.88<NA>
발전소명용량(MW)구분발전량(kW)이용율(비율)비고
11울산시민가상발전소1.52022-03-0118352916.99<NA>
12울산시민가상발전소1.52022-04-0118267316.91<NA>
13울산시민가상발전소1.52022-05-0122211420.57<NA>
14울산시민가상발전소1.52022-06-0127035525.03<NA>
15울산시민가상발전소1.52022-07-0119572618.12<NA>
16울산시민가상발전소1.52022-08-0117794216.48<NA>
17울산시민가상발전소1.52022-09-0116344615.13<NA>
18울산시민가상발전소1.52022-10-0114512813.44<NA>
19울산시민가상발전소1.52022-11-0116442115.22<NA>
20울산시민가상발전소1.52022-12-0113850212.82<NA>