Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory488.3 KiB
Average record size in memory50.0 B

Variable types

DateTime1
Categorical3
Numeric1

Dataset

Description한국동서발전의 태양광 발전량 현황 정보입니다. 태양광 발전량 현황은 날짜, 발전기명, 일일발전량(Wh)의 항목으로 구성됩니다.
URLhttps://www.data.go.kr/data/15003553/fileData.do

Alerts

주소 is highly overall correlated with 발전기명 and 1 other fieldsHigh correlation
설비용량(MW) is highly overall correlated with 발전기명 and 1 other fieldsHigh correlation
발전기명 is highly overall correlated with 주소 and 1 other fieldsHigh correlation

Reproduction

Analysis started2023-12-11 23:47:13.327201
Analysis finished2023-12-11 23:47:14.058103
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

날짜
Date

Distinct2191
Distinct (%)21.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-01-01 00:00:00
Maximum2022-12-31 00:00:00
2023-12-12T08:47:14.170734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:47:14.388812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

발전기명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
울산태양광#1
2076 
광양항태양광
2070 
수원환경사업소태양광
2065 
당진태양광
2049 
동해시하수종말처리장태양광
1740 

Length

Max length13
Median length7
Mean length8.0467
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row울산태양광#1
2nd row광양항태양광
3rd row수원환경사업소태양광
4th row광양항태양광
5th row당진태양광

Common Values

ValueCountFrequency (%)
울산태양광#1 2076
20.8%
광양항태양광 2070
20.7%
수원환경사업소태양광 2065
20.6%
당진태양광 2049
20.5%
동해시하수종말처리장태양광 1740
17.4%

Length

2023-12-12T08:47:14.592904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:47:14.731459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
울산태양광#1 2076
20.8%
광양항태양광 2070
20.7%
수원환경사업소태양광 2065
20.6%
당진태양광 2049
20.5%
동해시하수종말처리장태양광 1740
17.4%

주소
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
울산시 남구 용잠로 623
2076 
전남 광양시 도이동 775
2070 
경기도 화성시 태안로 263
2065 
충남 당진시 석문면 교로리 30
2049 
강원도 동해시 공단1로 316
1740 

Length

Max length17
Median length16
Mean length15.1692
Min length14

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row울산시 남구 용잠로 623
2nd row전남 광양시 도이동 775
3rd row경기도 화성시 태안로 263
4th row전남 광양시 도이동 775
5th row충남 당진시 석문면 교로리 30

Common Values

ValueCountFrequency (%)
울산시 남구 용잠로 623 2076
20.8%
전남 광양시 도이동 775 2070
20.7%
경기도 화성시 태안로 263 2065
20.6%
충남 당진시 석문면 교로리 30 2049
20.5%
강원도 동해시 공단1로 316 1740
17.4%

Length

2023-12-12T08:47:14.875163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:47:15.003415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
울산시 2076
 
4.9%
남구 2076
 
4.9%
용잠로 2076
 
4.9%
623 2076
 
4.9%
전남 2070
 
4.9%
광양시 2070
 
4.9%
도이동 2070
 
4.9%
775 2070
 
4.9%
263 2065
 
4.9%
태안로 2065
 
4.9%
Other values (11) 21335
50.7%

설비용량(MW)
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
0.5
2076 
2.3
2070 
1.5
2065 
1.0
2049 
2.4
1740 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row0.5
2nd row2.3
3rd row1.5
4th row2.3
5th row1.0

Common Values

ValueCountFrequency (%)
0.5 2076
20.8%
2.3 2070
20.7%
1.5 2065
20.6%
1.0 2049
20.5%
2.4 1740
17.4%

Length

2023-12-12T08:47:15.166797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:47:15.264134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
0.5 2076
20.8%
2.3 2070
20.7%
1.5 2065
20.6%
1.0 2049
20.5%
2.4 1740
17.4%

일일발전량(Wh)
Real number (ℝ)

Distinct8541
Distinct (%)85.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean5039659.5
Minimum0
Maximum16059600
Zeros38
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T08:47:15.381971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile639777.6
Q12105892
median4442400
Q37431600
95-th percentile11865780
Maximum16059600
Range16059600
Interquartile range (IQR)5325708

Descriptive statistics

Standard deviation3497590.3
Coefficient of variation (CV)0.69401323
Kurtosis-0.27624478
Mean5039659.5
Median Absolute Deviation (MAD)2535624
Skewness0.71194499
Sum5.0396595 × 1010
Variance1.2233138 × 1013
MonotonicityNot monotonic
2023-12-12T08:47:15.515589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 38
 
0.4%
8578800 6
 
0.1%
9300600 5
 
0.1%
9045000 5
 
0.1%
3448800 5
 
0.1%
5360400 5
 
0.1%
6734400 4
 
< 0.1%
7758000 4
 
< 0.1%
5007600 4
 
< 0.1%
6598800 4
 
< 0.1%
Other values (8531) 9920
99.2%
ValueCountFrequency (%)
0 38
0.4%
96 1
 
< 0.1%
384 2
 
< 0.1%
1056 1
 
< 0.1%
2496 1
 
< 0.1%
2640 1
 
< 0.1%
3600 1
 
< 0.1%
3648 1
 
< 0.1%
5088 1
 
< 0.1%
5616 1
 
< 0.1%
ValueCountFrequency (%)
16059600 1
< 0.1%
15795000 1
< 0.1%
15667200 1
< 0.1%
15618600 1
< 0.1%
15532200 1
< 0.1%
15514200 1
< 0.1%
15453000 1
< 0.1%
15298200 1
< 0.1%
15258600 1
< 0.1%
15255000 1
< 0.1%

Interactions

2023-12-12T08:47:13.675915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:47:15.607583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발전기명주소설비용량(MW)일일발전량(Wh)
발전기명1.0001.0001.0000.806
주소1.0001.0001.0000.806
설비용량(MW)1.0001.0001.0000.806
일일발전량(Wh)0.8060.8060.8061.000
2023-12-12T08:47:15.698641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
주소설비용량(MW)발전기명
주소1.0001.0001.000
설비용량(MW)1.0001.0001.000
발전기명1.0001.0001.000
2023-12-12T08:47:15.795363image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
일일발전량(Wh)발전기명주소설비용량(MW)
일일발전량(Wh)1.0000.4630.4630.463
발전기명0.4631.0001.0001.000
주소0.4631.0001.0001.000
설비용량(MW)0.4631.0001.0001.000

Missing values

2023-12-12T08:47:13.865296image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:47:13.995466image/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)일일발전량(Wh)
100692021-08-16울산태양광#1울산시 남구 용잠로 6230.52113248
20222022-07-16광양항태양광전남 광양시 도이동 7752.311167200
73552020-02-26수원환경사업소태양광경기도 화성시 태안로 2631.57203600
12702020-06-24광양항태양광전남 광양시 도이동 7752.31998000
27952018-08-28당진태양광충남 당진시 석문면 교로리 301.01069248
84482017-03-01울산태양광#1울산시 남구 용잠로 6230.51864656
7952019-03-07광양항태양광전남 광양시 도이동 7752.37009200
92392019-05-07울산태양광#1울산시 남구 용잠로 6230.52777472
66672018-04-09수원환경사업소태양광경기도 화성시 태안로 2631.59090000
89332018-07-05울산태양광#1울산시 남구 용잠로 6230.5858672
날짜발전기명주소설비용량(MW)일일발전량(Wh)
18292022-01-04광양항태양광전남 광양시 도이동 7752.34843800
96292020-06-02울산태양광#1울산시 남구 용잠로 6230.52473440
17172021-09-14광양항태양광전남 광양시 도이동 7752.32633400
15332021-03-14광양항태양광전남 광양시 도이동 7752.39028800
56522021-06-25동해시하수종말처리장태양광강원도 동해시 공단1로 3162.413698000
101092021-09-25울산태양광#1울산시 남구 용잠로 6230.51254384
15452021-03-26광양항태양광전남 광양시 도이동 7752.38983800
9942019-09-22광양항태양광전남 광양시 도이동 7752.31342800
81442022-04-30수원환경사업소태양광경기도 화성시 태안로 2631.55894400
7372019-01-08광양항태양광전남 광양시 도이동 7752.34302000