Overview

Dataset statistics

Number of variables6
Number of observations1231
Missing cells523
Missing cells (%)7.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory61.4 KiB
Average record size in memory51.1 B

Variable types

Text2
Numeric3
DateTime1

Dataset

Description충청남도_홍성군_태양광전기사업허가현황(발전소명, 설비용량 발전소주소 최초허가일 사업개시일) 항목을 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=399&beforeMenuCd=DOM_000000201001001000&publicdatapk=15042036

Alerts

데이터기준일 has constant value ""Constant
최초허가일 is highly overall correlated with 사업개시일High correlation
사업개시일 is highly overall correlated with 최초허가일High correlation
사업개시일 has 523 (42.5%) missing valuesMissing

Reproduction

Analysis started2024-01-09 20:54:39.983219
Analysis finished2024-01-09 20:54:41.524890
Duration1.54 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

발전소명
Text

Distinct1170
Distinct (%)95.0%
Missing0
Missing (%)0.0%
Memory size9.7 KiB
2024-01-10T05:54:41.713096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length23
Mean length9.8870837
Min length2

Characters and Unicode

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

Unique

Unique1121 ?
Unique (%)91.1%

Sample

1st row가정길2 태양광발전소
2nd row갈산3호 태양광발전소
3rd row갈산2호 태양광발전소
4th row갈산1호 태양광발전소
5th row김동식 태양광
ValueCountFrequency (%)
태양광발전소 393
 
22.7%
발전소 16
 
0.9%
태양광 12
 
0.7%
수상태양광발전소 11
 
0.6%
홍성2차 11
 
0.6%
홍성 9
 
0.5%
무량 8
 
0.5%
솔라앤팜 5
 
0.3%
그린 5
 
0.3%
에너지 5
 
0.3%
Other values (1171) 1255
72.5%
2024-01-10T05:54:42.081512image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 1177
 
9.7%
양 1154
 
9.5%
태 1146
 
9.4%
전 1134
 
9.3%
소 1129
 
9.3%
발 1121
 
9.2%
501
 
4.1%
호 488
 
4.0%
2 182
 
1.5%
1 181
 
1.5%
Other values (340) 3958
32.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 10812
88.8%
Decimal Number 636
 
5.2%
Space Separator 501
 
4.1%
Uppercase Letter 99
 
0.8%
Close Punctuation 49
 
0.4%
Open Punctuation 49
 
0.4%
Other Symbol 18
 
0.1%
Dash Punctuation 4
 
< 0.1%
Other Punctuation 2
 
< 0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 1177
 
10.9%
양 1154
 
10.7%
태 1146
 
10.6%
전 1134
 
10.5%
소 1129
 
10.4%
발 1121
 
10.4%
호 488
 
4.5%
성 157
 
1.5%
홍 107
 
1.0%
이 94
 
0.9%
Other values (305) 3105
28.7%
Uppercase Letter
ValueCountFrequency (%)
S 24
24.2%
M 12
12.1%
Y 10
10.1%
H 8
 
8.1%
A 7
 
7.1%
B 7
 
7.1%
D 6
 
6.1%
E 5
 
5.1%
N 4
 
4.0%
G 4
 
4.0%
Other values (7) 12
12.1%
Decimal Number
ValueCountFrequency (%)
2 182
28.6%
1 181
28.5%
3 88
13.8%
4 48
 
7.5%
5 37
 
5.8%
6 24
 
3.8%
7 23
 
3.6%
0 22
 
3.5%
8 18
 
2.8%
9 13
 
2.0%
Other Punctuation
ValueCountFrequency (%)
＆ 1
50.0%
. 1
50.0%
Space Separator
ValueCountFrequency (%)
501
100.0%
Close Punctuation
ValueCountFrequency (%)
) 49
100.0%
Open Punctuation
ValueCountFrequency (%)
( 49
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 18
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 10830
89.0%
Common 1241
 
10.2%
Latin 100
 
0.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 1177
 
10.9%
양 1154
 
10.7%
태 1146
 
10.6%
전 1134
 
10.5%
소 1129
 
10.4%
발 1121
 
10.4%
호 488
 
4.5%
성 157
 
1.4%
홍 107
 
1.0%
이 94
 
0.9%
Other values (306) 3123
28.8%
Latin
ValueCountFrequency (%)
S 24
24.0%
M 12
12.0%
Y 10
10.0%
H 8
 
8.0%
A 7
 
7.0%
B 7
 
7.0%
D 6
 
6.0%
E 5
 
5.0%
N 4
 
4.0%
G 4
 
4.0%
Other values (8) 13
13.0%
Common
ValueCountFrequency (%)
501
40.4%
2 182
 
14.7%
1 181
 
14.6%
3 88
 
7.1%
) 49
 
3.9%
( 49
 
3.9%
4 48
 
3.9%
5 37
 
3.0%
6 24
 
1.9%
7 23
 
1.9%
Other values (6) 59
 
4.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 10812
88.8%
ASCII 1339
 
11.0%
None 19
 
0.2%
Number Forms 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 1177
 
10.9%
양 1154
 
10.7%
태 1146
 
10.6%
전 1134
 
10.5%
소 1129
 
10.4%
발 1121
 
10.4%
호 488
 
4.5%
성 157
 
1.5%
홍 107
 
1.0%
이 94
 
0.9%
Other values (305) 3105
28.7%
ASCII
ValueCountFrequency (%)
501
37.4%
2 182
 
13.6%
1 181
 
13.5%
3 88
 
6.6%
) 49
 
3.7%
( 49
 
3.7%
4 48
 
3.6%
5 37
 
2.8%
6 24
 
1.8%
S 24
 
1.8%
Other values (22) 156
 
11.7%
None
ValueCountFrequency (%)
㈜ 18
94.7%
＆ 1
 
5.3%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

설비용량
Real number (ℝ)

Distinct394
Distinct (%)32.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean198.15758
Minimum5.04
Maximum1495.44
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.9 KiB
2024-01-10T05:54:42.206573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum5.04
5-th percentile29.325
Q197.28
median99.23
Q399.96
95-th percentile994.28
Maximum1495.44
Range1490.4
Interquartile range (IQR)2.68

Descriptive statistics

Standard deviation249.89733
Coefficient of variation (CV)1.2611041
Kurtosis4.9399451
Mean198.15758
Median Absolute Deviation (MAD)1.95
Skewness2.4208243
Sum243931.98
Variance62448.674
MonotonicityNot monotonic
2024-01-10T05:54:42.324648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.9 85
 
6.9%
99.0 82
 
6.7%
97.92 61
 
5.0%
99.28 54
 
4.4%
99.36 40
 
3.2%
99.2 35
 
2.8%
997.92 30
 
2.4%
97.2 27
 
2.2%
99.23 27
 
2.2%
99.84 26
 
2.1%
Other values (384) 764
62.1%
ValueCountFrequency (%)
5.04 1
 
0.1%
9.6 1
 
0.1%
10.0 2
0.2%
14.4 1
 
0.1%
14.53 1
 
0.1%
15.0 3
0.2%
15.12 1
 
0.1%
15.3 1
 
0.1%
16.06 1
 
0.1%
16.2 1
 
0.1%
ValueCountFrequency (%)
1495.44 1
 
0.1%
1000.0 1
 
0.1%
999.99 1
 
0.1%
999.6 3
 
0.2%
999.0 7
 
0.6%
998.4 2
 
0.2%
997.92 30
2.4%
997.56 6
 
0.5%
996.96 1
 
0.1%
996.84 1
 
0.1%

발전소주소
Text

Distinct1004
Distinct (%)81.6%
Missing0
Missing (%)0.0%
Memory size9.7 KiB
2024-01-10T05:54:42.590261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length91
Median length62
Mean length28.562145
Min length18

Characters and Unicode

Total characters35160
Distinct characters168
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

Unique887 ?
Unique (%)72.1%

Sample

1st row충청남도 홍성군 광천읍 가정리 432 부2동(건물위)
2nd row충청남도 홍성군 갈산면 대사리 258 주6동(건물위)
3rd row충청남도 홍성군 갈산면 대사리 258 , 257-1 주5동(건물위)
4th row충청남도 홍성군 갈산면 대사리 258 , 257-1 주5동(건물위)
5th row충청남도 홍성군 홍성읍 남장리 448-3 (건물위)
ValueCountFrequency (%)
충청남도 1228
 
16.0%
홍성군 1227
 
16.0%
은하면 150
 
2.0%
결성면 149
 
1.9%
산 148
 
1.9%
구항면 147
 
1.9%
갈산면 138
 
1.8%
광천읍 128
 
1.7%
113
 
1.5%
서부면 104
 
1.4%
Other values (1488) 4128
53.9%
2024-01-10T05:54:42.997447image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6429
 
18.3%
홍 1505
 
4.3%
성 1499
 
4.3%
1 1490
 
4.2%
남 1305
 
3.7%
청 1268
 
3.6%
충 1242
 
3.5%
도 1234
 
3.5%
군 1227
 
3.5%
리 1060
 
3.0%
Other values (158) 16901
48.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 19043
54.2%
Decimal Number 7390
 
21.0%
Space Separator 6429
 
18.3%
Dash Punctuation 944
 
2.7%
Other Punctuation 768
 
2.2%
Close Punctuation 287
 
0.8%
Open Punctuation 287
 
0.8%
Math Symbol 11
 
< 0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
홍 1505
 
7.9%
성 1499
 
7.9%
남 1305
 
6.9%
청 1268
 
6.7%
충 1242
 
6.5%
도 1234
 
6.5%
군 1227
 
6.4%
리 1060
 
5.6%
면 979
 
5.1%
번 619
 
3.3%
Other values (139) 7105
37.3%
Decimal Number
ValueCountFrequency (%)
1 1490
20.2%
2 1023
13.8%
3 914
12.4%
4 764
10.3%
5 660
8.9%
6 606
8.2%
7 580
 
7.8%
8 539
 
7.3%
9 422
 
5.7%
0 392
 
5.3%
Other Punctuation
ValueCountFrequency (%)
, 764
99.5%
/ 3
 
0.4%
. 1
 
0.1%
Space Separator
ValueCountFrequency (%)
6429
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 944
100.0%
Close Punctuation
ValueCountFrequency (%)
) 287
100.0%
Open Punctuation
ValueCountFrequency (%)
( 287
100.0%
Math Symbol
ValueCountFrequency (%)
~ 11
100.0%
Uppercase Letter
ValueCountFrequency (%)
A 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 19043
54.2%
Common 16116
45.8%
Latin 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
홍 1505
 
7.9%
성 1499
 
7.9%
남 1305
 
6.9%
청 1268
 
6.7%
충 1242
 
6.5%
도 1234
 
6.5%
군 1227
 
6.4%
리 1060
 
5.6%
면 979
 
5.1%
번 619
 
3.3%
Other values (139) 7105
37.3%
Common
ValueCountFrequency (%)
6429
39.9%
1 1490
 
9.2%
2 1023
 
6.3%
- 944
 
5.9%
3 914
 
5.7%
4 764
 
4.7%
, 764
 
4.7%
5 660
 
4.1%
6 606
 
3.8%
7 580
 
3.6%
Other values (8) 1942
 
12.1%
Latin
ValueCountFrequency (%)
A 1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 19043
54.2%
ASCII 16117
45.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6429
39.9%
1 1490
 
9.2%
2 1023
 
6.3%
- 944
 
5.9%
3 914
 
5.7%
4 764
 
4.7%
, 764
 
4.7%
5 660
 
4.1%
6 606
 
3.8%
7 580
 
3.6%
Other values (9) 1943
 
12.1%
Hangul
ValueCountFrequency (%)
홍 1505
 
7.9%
성 1499
 
7.9%
남 1305
 
6.9%
청 1268
 
6.7%
충 1242
 
6.5%
도 1234
 
6.5%
군 1227
 
6.4%
리 1060
 
5.6%
면 979
 
5.1%
번 619
 
3.3%
Other values (139) 7105
37.3%

최초허가일
Real number (ℝ)

HIGH CORRELATION 

Distinct410
Distinct (%)33.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean43257.655
Minimum39220
Maximum44593
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.9 KiB
2024-01-10T05:54:43.133545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum39220
5-th percentile42064.5
Q142856
median43333
Q343691
95-th percentile44340.5
Maximum44593
Range5373
Interquartile range (IQR)835

Descriptive statistics

Standard deviation677.63775
Coefficient of variation (CV)0.015665152
Kurtosis1.2332896
Mean43257.655
Median Absolute Deviation (MAD)370
Skewness-0.53242534
Sum53250173
Variance459192.92
MonotonicityNot monotonic
2024-01-10T05:54:43.260418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
42289 32
 
2.6%
42825 17
 
1.4%
43409 16
 
1.3%
43339 14
 
1.1%
43341 12
 
1.0%
43683 12
 
1.0%
43530 12
 
1.0%
42781 12
 
1.0%
43124 12
 
1.0%
43334 11
 
0.9%
Other values (400) 1081
87.8%
ValueCountFrequency (%)
39220 1
0.1%
39918 1
0.1%
40604 1
0.1%
41022 1
0.1%
41143 1
0.1%
41186 1
0.1%
41281 1
0.1%
41393 1
0.1%
41572 2
0.2%
41688 2
0.2%
ValueCountFrequency (%)
44593 4
0.3%
44556 3
0.2%
44553 4
0.3%
44549 6
0.5%
44542 5
0.4%
44532 2
 
0.2%
44524 1
 
0.1%
44505 5
0.4%
44504 1
 
0.1%
44503 2
 
0.2%

사업개시일
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct290
Distinct (%)41.0%
Missing523
Missing (%)42.5%
Infinite0
Infinite (%)0.0%
Mean43642.16
Minimum39371
Maximum44574
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.9 KiB
2024-01-10T05:54:43.382668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum39371
5-th percentile42194.5
Q143251
median43825
Q344158
95-th percentile44420
Maximum44574
Range5203
Interquartile range (IQR)907

Descriptive statistics

Standard deviation671.92744
Coefficient of variation (CV)0.015396292
Kurtosis2.8594147
Mean43642.16
Median Absolute Deviation (MAD)352.5
Skewness-1.383596
Sum30898649
Variance451486.49
MonotonicityNot monotonic
2024-01-10T05:54:43.496422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
44172 25
 
2.0%
43403 17
 
1.4%
44194 14
 
1.1%
43762 13
 
1.1%
42902 12
 
1.0%
43770 12
 
1.0%
43992 12
 
1.0%
44200 10
 
0.8%
44158 10
 
0.8%
42865 10
 
0.8%
Other values (280) 573
46.5%
(Missing) 523
42.5%
ValueCountFrequency (%)
39371 1
0.1%
41107 1
0.1%
41240 1
0.1%
41298 1
0.1%
41502 1
0.1%
41572 2
0.2%
41736 1
0.1%
41739 1
0.1%
41774 1
0.1%
41795 2
0.2%
ValueCountFrequency (%)
44574 4
0.3%
44571 1
 
0.1%
44565 2
0.2%
44564 2
0.2%
44561 1
 
0.1%
44560 4
0.3%
44558 1
 
0.1%
44553 1
 
0.1%
44552 1
 
0.1%
44550 1
 
0.1%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size9.7 KiB
Minimum2022-01-31 00:00:00
Maximum2022-01-31 00:00:00
2024-01-10T05:54:43.584147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:43.662883image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-10T05:54:41.111406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:40.524149image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:40.809373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:41.203556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:40.618451image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:40.920339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:41.303653image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:40.720326image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:54:41.018011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:54:43.720319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설비용량최초허가일사업개시일
설비용량1.0000.2050.276
최초허가일0.2051.0000.831
사업개시일0.2760.8311.000
2024-01-10T05:54:43.801135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설비용량최초허가일사업개시일
설비용량1.000-0.089-0.045
최초허가일-0.0891.0000.784
사업개시일-0.0450.7841.000

Missing values

2024-01-10T05:54:41.398116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:54:41.487882image/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

발전소명설비용량발전소주소최초허가일사업개시일데이터기준일
0가정길2 태양광발전소94.08충청남도 홍성군 광천읍 가정리 432 부2동(건물위)44593<NA>2022-01-31
1갈산3호 태양광발전소28.42충청남도 홍성군 갈산면 대사리 258 주6동(건물위)44593<NA>2022-01-31
2갈산2호 태양광발전소99.76충청남도 홍성군 갈산면 대사리 258 , 257-1 주5동(건물위)44593<NA>2022-01-31
3갈산1호 태양광발전소99.76충청남도 홍성군 갈산면 대사리 258 , 257-1 주5동(건물위)44593<NA>2022-01-31
4김동식 태양광30.24충청남도 홍성군 홍성읍 남장리 448-3 (건물위)44556<NA>2022-01-31
5SH발전소19.78충청남도 홍성군 홍성읍 내법리 105-1844556<NA>2022-01-31
6와이에이치 소향에너지파크92.7충청남도 홍성군 홍성읍 소향리 255-24 주1동, 부1동(건물위)44556<NA>2022-01-31
7세딸4호 태양광발전소95.04충청남도 홍성군 홍북읍 갈산리 124-13 , 124-14 주2동(건물위)44553445742022-01-31
8세딸3호 태양광발전소95.04충청남도 홍성군 홍북읍 갈산리 124-13 , 124-14 주2동(건물위)44553445742022-01-31
9세딸2호 태양광발전소95.04충청남도 홍성군 홍북읍 갈산리 124-13 , 124-14 주1동(건물위)44553445742022-01-31
발전소명설비용량발전소주소최초허가일사업개시일데이터기준일
1221대율 태양광발전소999.0충청남도 홍성군 은하면 대율리 39842530428912022-01-31
1222월림산 태양광발전소999.0충청남도 홍성군 광천읍 광금남로63번길 109-1442443430072022-01-31
1223㈜우리파워15호 태양광발전소603.84충청남도 홍성군 장곡면 옥계리 산 9042443430982022-01-31
1224대송 태양광발전소999.0충청남도 홍성군 결성면 형산리 산 168-1242422427942022-01-31
1225백현 태양광발전소870.0충청남도 홍성군 은하면 장곡리 462-1 대율리 51-7, 51-842338428032022-01-31
1226성남리2호 태양광발전소990.0충청남도 홍성군 결성면 성남리 1106-242254426682022-01-31
1227성남리1호 태양광발전소990.0충청남도 홍성군 결성면 성남리 1106-242254426682022-01-31
1228삼산에너지발전소700.0충청남도 홍성군 장곡면 신풍리 76942193424572022-01-31
1229단비덕실 태양광발전소934.2충청남도 홍성군 은하면 홍남로22번길 14942123426732022-01-31
1230(주)미르에너지 태양광발전소993.24충청남도 홍성군 구항면 신곡리 산 56-342068432152022-01-31