Overview

Dataset statistics

Number of variables6
Number of observations546
Missing cells9
Missing cells (%)0.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory26.8 KiB
Average record size in memory50.2 B

Variable types

Numeric2
Text2
DateTime2

Dataset

Description영광군 신재생에너지 산업운영 현황에 관한 데이터로 발전소명, 발전소 주소, 발전사업 허가일 등의 항목을 제공합니다.
URLhttps://www.data.go.kr/data/15029937/fileData.do

Alerts

상업운전 시작일 has 9 (1.6%) missing valuesMissing
번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:54:30.151354
Analysis finished2023-12-12 14:54:31.187473
Duration1.04 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

번호
Real number (ℝ)

UNIQUE 

Distinct546
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean273.5
Minimum1
Maximum546
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.9 KiB
2023-12-12T23:54:31.292963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile28.25
Q1137.25
median273.5
Q3409.75
95-th percentile518.75
Maximum546
Range545
Interquartile range (IQR)272.5

Descriptive statistics

Standard deviation157.7609
Coefficient of variation (CV)0.57682229
Kurtosis-1.2
Mean273.5
Median Absolute Deviation (MAD)136.5
Skewness0
Sum149331
Variance24888.5
MonotonicityStrictly increasing
2023-12-12T23:54:31.469234image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
368 1
 
0.2%
362 1
 
0.2%
363 1
 
0.2%
364 1
 
0.2%
365 1
 
0.2%
366 1
 
0.2%
367 1
 
0.2%
369 1
 
0.2%
411 1
 
0.2%
Other values (536) 536
98.2%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
546 1
0.2%
545 1
0.2%
544 1
0.2%
543 1
0.2%
542 1
0.2%
541 1
0.2%
540 1
0.2%
539 1
0.2%
538 1
0.2%
537 1
0.2%

발전소명
Text

Distinct540
Distinct (%)98.9%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
2023-12-12T23:54:31.777116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length27
Mean length12.119048
Min length4

Characters and Unicode

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

Unique

Unique535 ?
Unique (%)98.0%

Sample

1st row온누리제7호 태양광발전소
2nd row온누리제6호 태양광발전소
3rd row온누리제5호 태양광발전소
4th row온누리제4호 태양광발전소
5th row경인 태양광발전소
ValueCountFrequency (%)
태양광발전소 394
39.0%
태양광발전소2호 11
 
1.1%
발전소 7
 
0.7%
에덴 6
 
0.6%
월계농장 6
 
0.6%
태양광발전소3호 6
 
0.6%
성대 5
 
0.5%
명성 4
 
0.4%
태양광 4
 
0.4%
주식회사 3
 
0.3%
Other values (538) 564
55.8%
2023-12-12T23:54:32.326447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 543
 
8.2%
전 514
 
7.8%
발 512
 
7.7%
양 511
 
7.7%
태 510
 
7.7%
소 509
 
7.7%
464
 
7.0%
( 199
 
3.0%
) 198
 
3.0%
호 156
 
2.4%
Other values (298) 2501
37.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5495
83.0%
Space Separator 464
 
7.0%
Open Punctuation 226
 
3.4%
Close Punctuation 225
 
3.4%
Decimal Number 194
 
2.9%
Uppercase Letter 10
 
0.2%
Other Symbol 2
 
< 0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 543
 
9.9%
전 514
 
9.4%
발 512
 
9.3%
양 511
 
9.3%
태 510
 
9.3%
소 509
 
9.3%
호 156
 
2.8%
에 154
 
2.8%
지 139
 
2.5%
너 118
 
2.1%
Other values (277) 1829
33.3%
Decimal Number
ValueCountFrequency (%)
2 66
34.0%
1 48
24.7%
3 30
15.5%
4 21
 
10.8%
5 10
 
5.2%
6 8
 
4.1%
7 5
 
2.6%
8 2
 
1.0%
9 2
 
1.0%
0 2
 
1.0%
Uppercase Letter
ValueCountFrequency (%)
L 3
30.0%
S 3
30.0%
J 2
20.0%
K 2
20.0%
Open Punctuation
ValueCountFrequency (%)
( 199
88.1%
[ 27
 
11.9%
Close Punctuation
ValueCountFrequency (%)
) 198
88.0%
] 27
 
12.0%
Space Separator
ValueCountFrequency (%)
464
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%
Letter Number
ValueCountFrequency (%)
Ⅰ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5497
83.1%
Common 1109
 
16.8%
Latin 11
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 543
 
9.9%
전 514
 
9.4%
발 512
 
9.3%
양 511
 
9.3%
태 510
 
9.3%
소 509
 
9.3%
호 156
 
2.8%
에 154
 
2.8%
지 139
 
2.5%
너 118
 
2.1%
Other values (278) 1831
33.3%
Common
ValueCountFrequency (%)
464
41.8%
( 199
17.9%
) 198
17.9%
2 66
 
6.0%
1 48
 
4.3%
3 30
 
2.7%
] 27
 
2.4%
[ 27
 
2.4%
4 21
 
1.9%
5 10
 
0.9%
Other values (5) 19
 
1.7%
Latin
ValueCountFrequency (%)
L 3
27.3%
S 3
27.3%
J 2
18.2%
K 2
18.2%
Ⅰ 1
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5495
83.0%
ASCII 1119
 
16.9%
None 2
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 543
 
9.9%
전 514
 
9.4%
발 512
 
9.3%
양 511
 
9.3%
태 510
 
9.3%
소 509
 
9.3%
호 156
 
2.8%
에 154
 
2.8%
지 139
 
2.5%
너 118
 
2.1%
Other values (277) 1829
33.3%
ASCII
ValueCountFrequency (%)
464
41.5%
( 199
17.8%
) 198
17.7%
2 66
 
5.9%
1 48
 
4.3%
3 30
 
2.7%
] 27
 
2.4%
[ 27
 
2.4%
4 21
 
1.9%
5 10
 
0.9%
Other values (9) 29
 
2.6%
None
ValueCountFrequency (%)
㈜ 2
100.0%
Number Forms
ValueCountFrequency (%)
Ⅰ 1
100.0%

용량
Real number (ℝ)

Distinct228
Distinct (%)41.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean319.51288
Minimum10
Maximum3024
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.9 KiB
2023-12-12T23:54:32.489317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile25.305
Q197.22
median99.9
Q3496.64
95-th percentile999
Maximum3024
Range3014
Interquartile range (IQR)399.42

Descriptive statistics

Standard deviation360.07873
Coefficient of variation (CV)1.1269616
Kurtosis5.117418
Mean319.51288
Median Absolute Deviation (MAD)71.04
Skewness1.7396978
Sum174454.03
Variance129656.69
MonotonicityNot monotonic
2023-12-12T23:54:32.643545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 42
 
7.7%
999.0 29
 
5.3%
99.9 21
 
3.8%
305.28 21
 
3.8%
996.48 19
 
3.5%
97.92 13
 
2.4%
99.96 13
 
2.4%
99.5 12
 
2.2%
999.9 12
 
2.2%
496.64 12
 
2.2%
Other values (218) 352
64.5%
ValueCountFrequency (%)
10.0 1
0.2%
10.4 1
0.2%
14.4 1
0.2%
15.0 1
0.2%
15.02 1
0.2%
15.2 1
0.2%
16.0 1
0.2%
16.5 2
0.4%
16.8 1
0.2%
18.0 1
0.2%
ValueCountFrequency (%)
3024.0 1
 
0.2%
1000.0 1
 
0.2%
999.9 12
2.2%
999.68 2
 
0.4%
999.34 1
 
0.2%
999.0 29
5.3%
998.4 7
 
1.3%
996.84 4
 
0.7%
996.48 19
3.5%
994.18 3
 
0.5%

발전소주소
Text

Distinct492
Distinct (%)90.1%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
2023-12-12T23:54:33.004496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length77
Median length57
Mean length28.941392
Min length18

Characters and Unicode

Total characters15802
Distinct characters140
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

Unique462 ?
Unique (%)84.6%

Sample

1st row전라남도 영광군 홍농읍 샘목로 745-1, 건물 위
2nd row전라남도 영광군 홍농읍 샘목로 745-1, 건물 위
3rd row전라남도 영광군 홍농읍 샘목로 745-1, 건물 위
4th row전라남도 영광군 홍농읍 샘목로 745-1, 건물 위
5th row전라남도 영광군 법성면 굴비로4길 18-12, 건물 위
ValueCountFrequency (%)
전라남도 546
 
16.1%
영광군 546
 
16.1%
위 170
 
5.0%
염산면 117
 
3.4%
영광읍 84
 
2.5%
건물 82
 
2.4%
백수읍 71
 
2.1%
법성면 68
 
2.0%
군서면 59
 
1.7%
봉남리 57
 
1.7%
Other values (812) 1600
47.1%
2023-12-12T23:54:33.505113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2854
 
18.1%
1 892
 
5.6%
남 682
 
4.3%
영 660
 
4.2%
군 657
 
4.2%
광 635
 
4.0%
전 550
 
3.5%
라 549
 
3.5%
도 546
 
3.5%
- 487
 
3.1%
Other values (130) 7290
46.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 8319
52.6%
Decimal Number 3477
22.0%
Space Separator 2854
 
18.1%
Dash Punctuation 487
 
3.1%
Other Punctuation 360
 
2.3%
Open Punctuation 150
 
0.9%
Close Punctuation 150
 
0.9%
Uppercase Letter 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 682
 
8.2%
영 660
 
7.9%
군 657
 
7.9%
광 635
 
7.6%
전 550
 
6.6%
라 549
 
6.6%
도 546
 
6.6%
면 350
 
4.2%
리 317
 
3.8%
지 216
 
2.6%
Other values (112) 3157
37.9%
Decimal Number
ValueCountFrequency (%)
1 892
25.7%
2 451
13.0%
0 380
10.9%
3 318
 
9.1%
8 307
 
8.8%
5 245
 
7.0%
4 244
 
7.0%
7 237
 
6.8%
6 219
 
6.3%
9 184
 
5.3%
Uppercase Letter
ValueCountFrequency (%)
B 2
40.0%
C 2
40.0%
A 1
20.0%
Space Separator
ValueCountFrequency (%)
2854
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 487
100.0%
Other Punctuation
ValueCountFrequency (%)
, 360
100.0%
Open Punctuation
ValueCountFrequency (%)
( 150
100.0%
Close Punctuation
ValueCountFrequency (%)
) 150
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 8319
52.6%
Common 7478
47.3%
Latin 5
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 682
 
8.2%
영 660
 
7.9%
군 657
 
7.9%
광 635
 
7.6%
전 550
 
6.6%
라 549
 
6.6%
도 546
 
6.6%
면 350
 
4.2%
리 317
 
3.8%
지 216
 
2.6%
Other values (112) 3157
37.9%
Common
ValueCountFrequency (%)
2854
38.2%
1 892
 
11.9%
- 487
 
6.5%
2 451
 
6.0%
0 380
 
5.1%
, 360
 
4.8%
3 318
 
4.3%
8 307
 
4.1%
5 245
 
3.3%
4 244
 
3.3%
Other values (5) 940
 
12.6%
Latin
ValueCountFrequency (%)
B 2
40.0%
C 2
40.0%
A 1
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 8319
52.6%
ASCII 7483
47.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2854
38.1%
1 892
 
11.9%
- 487
 
6.5%
2 451
 
6.0%
0 380
 
5.1%
, 360
 
4.8%
3 318
 
4.2%
8 307
 
4.1%
5 245
 
3.3%
4 244
 
3.3%
Other values (8) 945
 
12.6%
Hangul
ValueCountFrequency (%)
남 682
 
8.2%
영 660
 
7.9%
군 657
 
7.9%
광 635
 
7.6%
전 550
 
6.6%
라 549
 
6.6%
도 546
 
6.6%
면 350
 
4.2%
리 317
 
3.8%
지 216
 
2.6%
Other values (112) 3157
37.9%

발전사업 허가일
Date

Distinct231
Distinct (%)42.3%
Missing0
Missing (%)0.0%
Memory size4.4 KiB
Minimum2007-01-30 00:00:00
Maximum2022-12-20 00:00:00
2023-12-12T23:54:33.662574image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:54:33.834066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

상업운전 시작일
Date

MISSING 

Distinct245
Distinct (%)45.6%
Missing9
Missing (%)1.6%
Memory size4.4 KiB
Minimum2007-11-15 00:00:00
Maximum2023-07-13 00:00:00
2023-12-12T23:54:34.300282image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:54:34.474193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T23:54:30.698240image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:54:30.509790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:54:30.835001image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:54:30.604609image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:54:34.594660image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호용량
번호1.0000.539
용량0.5391.000
2023-12-12T23:54:34.692549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
번호용량
번호1.0000.181
용량0.1811.000

Missing values

2023-12-12T23:54:31.002897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:54:31.127873image/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

번호발전소명용량발전소주소발전사업 허가일상업운전 시작일
01온누리제7호 태양광발전소63.36전라남도 영광군 홍농읍 샘목로 745-1, 건물 위2022-12-202023-05-22
12온누리제6호 태양광발전소97.92전라남도 영광군 홍농읍 샘목로 745-1, 건물 위2022-12-202023-05-22
23온누리제5호 태양광발전소97.92전라남도 영광군 홍농읍 샘목로 745-1, 건물 위2022-12-202023-05-22
34온누리제4호 태양광발전소97.92전라남도 영광군 홍농읍 샘목로 745-1, 건물 위2022-12-202023-05-22
45경인 태양광발전소19.47전라남도 영광군 법성면 굴비로4길 18-12, 건물 위2022-11-212023-02-21
56해오름 태양광발전소19.6전라남도 영광군 군남면 월죽로3길 14, 건물 위2022-10-192023-01-27
67한길 태양광발전소149.64전라남도 영광군 법성면 용성월산로1길 752022-08-222023-03-07
78효은 태양광발전소49.88전라남도 영광군 법성면 용성월산로1길 27-72022-08-222023-03-07
89오천2호 태양광발전소700.0전라남도 영광군 영광읍 양평리 590 , 590-8, 건물 위2022-08-012023-05-24
910신월 태양광발전소273.11전라남도 영광군 영광읍 신월로3길 66-38, 건물 위2022-07-282023-06-29
번호발전소명용량발전소주소발전사업 허가일상업운전 시작일
536537태형솔라(주)(태형솔라 태양광발전소)500.0전라남도 영광군 군서면 성지로 396-14, (616-9,616-10,622,656-1,658)2007-08-292010-05-24
537538(주)동일태양광발전(동일 태양광발전소)700.0전라남도 영광군 군서면 백수로 1503-25, (172-14,172-23,172-24,172-26,172-27,172-28,172-43)2007-01-302008-08-11
538539(유)대융에너지(대융에너지 태양광발전소)99.0전라남도 영광군 군서면 만곡리 산 193-12007-02-022007-11-15
539540엘쏠라 태양광발전소100.0전라남도 영광군 군서면 송학리 310번지 1호 311,311-1,3142007-01-302008-08-13
540541유한회사 경일이앤씨99.0전라남도 영광군 군서면 만곡리 산 193-12007-01-302007-12-28
541542이뻐앤멋져(주)[이뻐앤멋져 제2호 태양광발전소]500.48전라남도 영광군 법성면 용성리 198, 197, 197-1(토지 위)2007-12-072008-07-31
542543알앤케이파워(주)(케이티 태양광발전소)99.79전라남도 영광군 영광읍 덕호리 233, 234, 220(토지 위)2007-11-19<NA>
543544일신에너지(주)(일신에너지 2호 태양광발전소)300.0전라남도 영광군 군남면 월흥리 875-9, 117-1, 873, 876-1, 625, 874, 876-5, 875-8, 875-7(토지위)2007-10-222008-05-31
544545송림 태양광발전소499.8전라남도 영광군 영광읍 송림리 539번지2007-10-182008-09-24
545546송이도내연발전소300.0전라남도 영광군 낙월면 송이리 158-252019-12-16<NA>