Overview

Dataset statistics

Number of variables6
Number of observations1149
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory56.2 KiB
Average record size in memory50.1 B

Variable types

Numeric2
Text2
DateTime2

Dataset

Description전라북도 임실군 신재생에너지(전기사업) 상업운영 현황 데이터 입니다. 데이터 내용에는 순번, 발전소명, 발전소주소, 설비용량, 발전사업 허가일, 상업운영 시작일이 포함되어 있습니다.
URLhttps://www.data.go.kr/data/15048409/fileData.do

Alerts

순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 09:47:56.543762
Analysis finished2023-12-12 09:47:57.463043
Duration0.92 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct1149
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean575
Minimum1
Maximum1149
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.2 KiB
2023-12-12T18:47:57.534939image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile58.4
Q1288
median575
Q3862
95-th percentile1091.6
Maximum1149
Range1148
Interquartile range (IQR)574

Descriptive statistics

Standard deviation331.83204
Coefficient of variation (CV)0.57709919
Kurtosis-1.2
Mean575
Median Absolute Deviation (MAD)287
Skewness0
Sum660675
Variance110112.5
MonotonicityStrictly increasing
2023-12-12T18:47:57.665358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
765 1
 
0.1%
771 1
 
0.1%
770 1
 
0.1%
769 1
 
0.1%
768 1
 
0.1%
767 1
 
0.1%
766 1
 
0.1%
764 1
 
0.1%
773 1
 
0.1%
Other values (1139) 1139
99.1%
ValueCountFrequency (%)
1 1
0.1%
2 1
0.1%
3 1
0.1%
4 1
0.1%
5 1
0.1%
6 1
0.1%
7 1
0.1%
8 1
0.1%
9 1
0.1%
10 1
0.1%
ValueCountFrequency (%)
1149 1
0.1%
1148 1
0.1%
1147 1
0.1%
1146 1
0.1%
1145 1
0.1%
1144 1
0.1%
1143 1
0.1%
1142 1
0.1%
1141 1
0.1%
1140 1
0.1%

발전소명
Text

Distinct1095
Distinct (%)95.3%
Missing0
Missing (%)0.0%
Memory size9.1 KiB
2023-12-12T18:47:57.901381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length19
Mean length9.2889469
Min length5

Characters and Unicode

Total characters10673
Distinct characters352
Distinct categories8 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1045 ?
Unique (%)90.9%

Sample

1st row지암2호태양광발전소
2nd row영산식품태양광발전소
3rd row선원농장태양광발전소
4th row양임태양광발전소
5th row경희태양광발전소
ValueCountFrequency (%)
금성태양광발전소 3
 
0.3%
베스코태양광발전소 3
 
0.3%
행복태양광발전소 3
 
0.3%
태양광발전소 3
 
0.3%
은혜태양광발전소 3
 
0.3%
희망태양광발전소 3
 
0.3%
주현태양광발전소 2
 
0.2%
은하태양광발전소 2
 
0.2%
원광태양광발전소2호 2
 
0.2%
빛고을태양광발전소 2
 
0.2%
Other values (1089) 1132
97.8%
2023-12-12T18:47:58.297771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 1130
 
10.6%
전 1121
 
10.5%
소 1107
 
10.4%
발 1100
 
10.3%
양 1099
 
10.3%
태 1096
 
10.3%
호 484
 
4.5%
1 167
 
1.6%
2 162
 
1.5%
지 150
 
1.4%
Other values (342) 3057
28.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10054
94.2%
Decimal Number 535
 
5.0%
Uppercase Letter 53
 
0.5%
Space Separator 9
 
0.1%
Open Punctuation 7
 
0.1%
Close Punctuation 7
 
0.1%
Lowercase Letter 7
 
0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 1130
11.2%
전 1121
11.1%
소 1107
11.0%
발 1100
10.9%
양 1099
10.9%
태 1096
10.9%
호 484
 
4.8%
지 150
 
1.5%
에 112
 
1.1%
너 104
 
1.0%
Other values (304) 2551
25.4%
Uppercase Letter
ValueCountFrequency (%)
S 11
20.8%
D 5
 
9.4%
K 4
 
7.5%
H 3
 
5.7%
J 3
 
5.7%
G 3
 
5.7%
E 3
 
5.7%
U 3
 
5.7%
N 3
 
5.7%
A 2
 
3.8%
Other values (8) 13
24.5%
Decimal Number
ValueCountFrequency (%)
1 167
31.2%
2 162
30.3%
3 82
15.3%
5 32
 
6.0%
4 30
 
5.6%
6 17
 
3.2%
7 14
 
2.6%
9 11
 
2.1%
8 11
 
2.1%
0 9
 
1.7%
Lowercase Letter
ValueCountFrequency (%)
o 2
28.6%
s 1
14.3%
p 1
14.3%
w 1
14.3%
e 1
14.3%
r 1
14.3%
Space Separator
ValueCountFrequency (%)
9
100.0%
Open Punctuation
ValueCountFrequency (%)
( 7
100.0%
Close Punctuation
ValueCountFrequency (%)
) 7
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10054
94.2%
Common 559
 
5.2%
Latin 60
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 1130
11.2%
전 1121
11.1%
소 1107
11.0%
발 1100
10.9%
양 1099
10.9%
태 1096
10.9%
호 484
 
4.8%
지 150
 
1.5%
에 112
 
1.1%
너 104
 
1.0%
Other values (304) 2551
25.4%
Latin
ValueCountFrequency (%)
S 11
18.3%
D 5
 
8.3%
K 4
 
6.7%
H 3
 
5.0%
J 3
 
5.0%
G 3
 
5.0%
E 3
 
5.0%
U 3
 
5.0%
N 3
 
5.0%
A 2
 
3.3%
Other values (14) 20
33.3%
Common
ValueCountFrequency (%)
1 167
29.9%
2 162
29.0%
3 82
14.7%
5 32
 
5.7%
4 30
 
5.4%
6 17
 
3.0%
7 14
 
2.5%
9 11
 
2.0%
8 11
 
2.0%
0 9
 
1.6%
Other values (4) 24
 
4.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10054
94.2%
ASCII 619
 
5.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 1130
11.2%
전 1121
11.1%
소 1107
11.0%
발 1100
10.9%
양 1099
10.9%
태 1096
10.9%
호 484
 
4.8%
지 150
 
1.5%
에 112
 
1.1%
너 104
 
1.0%
Other values (304) 2551
25.4%
ASCII
ValueCountFrequency (%)
1 167
27.0%
2 162
26.2%
3 82
13.2%
5 32
 
5.2%
4 30
 
4.8%
6 17
 
2.7%
7 14
 
2.3%
9 11
 
1.8%
S 11
 
1.8%
8 11
 
1.8%
Other values (28) 82
13.2%

발전소 주소
Text

Distinct1067
Distinct (%)92.9%
Missing0
Missing (%)0.0%
Memory size9.1 KiB
2023-12-12T18:47:58.652396image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length77
Median length68
Mean length24.645779
Min length18

Characters and Unicode

Total characters28318
Distinct characters140
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1013 ?
Unique (%)88.2%

Sample

1st row전라북도 임실군 지사면 안하리 736번지 4호
2nd row전라북도 임실군 지사면 원산리 298-1 (건물상부)
3rd row전라북도 임실군 지사면 원산리 74-1 , 89-5(건물상부)
4th row전라북도 임실군 삼계면 학정리 430 , 431-2, 432-1(건물상부 주2)
5th row전라북도 임실군 청웅면 옥석리 674
ValueCountFrequency (%)
전라북도 1148
 
17.3%
임실군 1147
 
17.3%
관촌면 188
 
2.8%
임실읍 179
 
2.7%
삼계면 141
 
2.1%
1호 126
 
1.9%
지사면 120
 
1.8%
오수면 100
 
1.5%
덕치면 88
 
1.3%
신평면 86
 
1.3%
Other values (946) 3326
50.0%
2023-12-12T18:47:59.159173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5500
19.4%
임 1330
 
4.7%
실 1328
 
4.7%
전 1232
 
4.4%
도 1164
 
4.1%
군 1150
 
4.1%
북 1148
 
4.1%
라 1148
 
4.1%
리 1080
 
3.8%
지 1039
 
3.7%
Other values (130) 12199
43.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 17482
61.7%
Space Separator 5500
 
19.4%
Decimal Number 4866
 
17.2%
Dash Punctuation 314
 
1.1%
Other Punctuation 120
 
0.4%
Open Punctuation 17
 
0.1%
Close Punctuation 17
 
0.1%
Math Symbol 1
 
< 0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
임 1330
 
7.6%
실 1328
 
7.6%
전 1232
 
7.0%
도 1164
 
6.7%
군 1150
 
6.6%
북 1148
 
6.6%
라 1148
 
6.6%
리 1080
 
6.2%
지 1039
 
5.9%
면 970
 
5.5%
Other values (113) 5893
33.7%
Decimal Number
ValueCountFrequency (%)
1 853
17.5%
2 661
13.6%
3 597
12.3%
4 465
9.6%
5 431
8.9%
7 424
8.7%
6 414
8.5%
8 380
7.8%
0 334
 
6.9%
9 307
 
6.3%
Space Separator
ValueCountFrequency (%)
5500
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 314
100.0%
Other Punctuation
ValueCountFrequency (%)
, 120
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 17482
61.7%
Common 10835
38.3%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
임 1330
 
7.6%
실 1328
 
7.6%
전 1232
 
7.0%
도 1164
 
6.7%
군 1150
 
6.6%
북 1148
 
6.6%
라 1148
 
6.6%
리 1080
 
6.2%
지 1039
 
5.9%
면 970
 
5.5%
Other values (113) 5893
33.7%
Common
ValueCountFrequency (%)
5500
50.8%
1 853
 
7.9%
2 661
 
6.1%
3 597
 
5.5%
4 465
 
4.3%
5 431
 
4.0%
7 424
 
3.9%
6 414
 
3.8%
8 380
 
3.5%
0 334
 
3.1%
Other values (6) 776
 
7.2%
Latin
ValueCountFrequency (%)
B 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 17482
61.7%
ASCII 10836
38.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5500
50.8%
1 853
 
7.9%
2 661
 
6.1%
3 597
 
5.5%
4 465
 
4.3%
5 431
 
4.0%
7 424
 
3.9%
6 414
 
3.8%
8 380
 
3.5%
0 334
 
3.1%
Other values (7) 777
 
7.2%
Hangul
ValueCountFrequency (%)
임 1330
 
7.6%
실 1328
 
7.6%
전 1232
 
7.0%
도 1164
 
6.7%
군 1150
 
6.6%
북 1148
 
6.6%
라 1148
 
6.6%
리 1080
 
6.2%
지 1039
 
5.9%
면 970
 
5.5%
Other values (113) 5893
33.7%

설비용량KW
Real number (ℝ)

Distinct198
Distinct (%)17.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean114.23919
Minimum14.82
Maximum999.24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.2 KiB
2023-12-12T18:47:59.644312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum14.82
5-th percentile44.88
Q199
median99
Q399.4
95-th percentile245.376
Maximum999.24
Range984.42
Interquartile range (IQR)0.4

Descriptive statistics

Standard deviation97.074166
Coefficient of variation (CV)0.84974487
Kurtosis45.525395
Mean114.23919
Median Absolute Deviation (MAD)0.38
Skewness6.1005874
Sum131260.83
Variance9423.3937
MonotonicityNot monotonic
2023-12-12T18:47:59.811873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 328
28.5%
99.2 76
 
6.6%
99.75 64
 
5.6%
99.4 60
 
5.2%
99.36 54
 
4.7%
99.28 48
 
4.2%
99.45 38
 
3.3%
99.38 30
 
2.6%
99.96 29
 
2.5%
98.49 25
 
2.2%
Other values (188) 397
34.6%
ValueCountFrequency (%)
14.82 1
0.1%
14.85 1
0.1%
15.0 2
0.2%
15.75 1
0.1%
18.0 2
0.2%
18.2 1
0.1%
18.72 1
0.1%
19.36 1
0.1%
19.43 1
0.1%
19.44 2
0.2%
ValueCountFrequency (%)
999.24 1
0.1%
997.92 2
0.2%
997.5 1
0.1%
990.0 1
0.1%
988.0 1
0.1%
985.5 1
0.1%
803.52 1
0.1%
699.84 1
0.1%
499.72 1
0.1%
499.2 1
0.1%

발전사업 허가일자
Date

Distinct267
Distinct (%)23.2%
Missing0
Missing (%)0.0%
Memory size9.1 KiB
Minimum2012-12-03 00:00:00
Maximum2021-03-30 00:00:00
2023-12-12T18:47:59.981119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:48:00.141176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상업운영 시작일
Date

Distinct365
Distinct (%)31.8%
Missing0
Missing (%)0.0%
Memory size9.1 KiB
Minimum2013-09-27 00:00:00
Maximum2021-06-21 00:00:00
2023-12-12T18:48:00.269203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:48:00.419237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T18:47:57.096858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:47:56.898415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:47:57.182042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T18:47:57.005189image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T18:48:00.501575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번설비용량KW
순번1.0000.413
설비용량KW0.4131.000
2023-12-12T18:48:00.593395image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번설비용량KW
순번1.000-0.223
설비용량KW-0.2231.000

Missing values

2023-12-12T18:47:57.301621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T18:47:57.416580image/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

순번발전소명발전소 주소설비용량KW발전사업 허가일자상업운영 시작일
01지암2호태양광발전소전라북도 임실군 지사면 안하리 736번지 4호498.752017-06-072020-09-23
12영산식품태양광발전소전라북도 임실군 지사면 원산리 298-1 (건물상부)44.242021-03-302021-06-16
23선원농장태양광발전소전라북도 임실군 지사면 원산리 74-1 , 89-5(건물상부)18.22020-11-202021-04-20
34양임태양광발전소전라북도 임실군 삼계면 학정리 430 , 431-2, 432-1(건물상부 주2)18.02020-11-162021-03-23
45경희태양광발전소전라북도 임실군 청웅면 옥석리 67429.42020-08-192020-11-12
56현수태양광발전소전라북도 임실군 청웅면 옥석리 674-429.42020-08-192020-11-25
67청웅햇살태양광발전소전라북도 임실군 청웅면 향교리 575-1 (토지+건물상부 부1)19.362020-07-132020-11-01
78선숙태양광발전소전라북도 임실군 임실읍 갈마리 418 (건물상부 주1)19.82020-07-132021-01-06
89송정태양광발전소전라북도 임실군 삼계면 덕계리 363번지 1호18.02020-06-112020-09-08
910회문태양광발전소전라북도 임실군 덕치면 회문리 486번지 4호15.02020-04-212020-07-03
순번발전소명발전소 주소설비용량KW발전사업 허가일자상업운영 시작일
11391140동도쏠라3호태양광발전소전라북도 임실군 임실읍 두만리 893번지 32호 건물상부99.02013-09-022016-12-15
11401141신세계에너지태양광발전소전라북도 임실군 임실읍 두만리 893번지 35호 건물상부99.02013-09-032016-09-13
11411142온새미로태양광발전소전라북도 임실군 임실읍 두만리 893번지 21호 건물상부99.02013-09-032016-09-13
11421143발산태양광발전소전라북도 임실군 청웅면 뱃골로 86229.42013-12-132015-12-04
11431144세현2호태양광발전소전라북도 임실군 임실읍 장재리 385번지50.02013-11-152015-12-22
11441145홍곡태양광발전소전라북도 임실군 삼계면 홍곡리 371번지 1호70.02013-10-022015-09-07
11451146아진태양광발전소전라북도 임실군 신덕면 수월로 640-499.112013-09-032013-11-15
11461147상훈에너지전라북도 임실군 삼계면 덕계2길 101-6140.02013-03-152013-09-27
11471148일광11호태양광발전소전라북도 임실군 관촌면 병암리 150번지30.02013-09-032017-08-24
11481149상천에너지전라북도 임실군 삼계면 충효로 166399.02012-12-032014-04-28