Overview

Dataset statistics

Number of variables5
Number of observations141
Missing cells23
Missing cells (%)3.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory5.8 KiB
Average record size in memory41.9 B

Variable types

Text2
Numeric1
DateTime2

Dataset

Description충청남도 홍성군 태양광발전설치현황에 대한 데이터로 발전소명, 설비용량, 발전소주소, 최초허가일, 데이터기준일자에 대한 정보를 제공합니다. 　　　　
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=431&beforeMenuCd=DOM_000000201001001000&publicdatapk=15034093

Alerts

사업개시일 has 23 (16.3%) missing valuesMissing

Reproduction

Analysis started2024-01-09 21:49:14.287414
Analysis finished2024-01-09 21:49:14.789994
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

발전소명
Text

Distinct140
Distinct (%)99.3%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-01-10T06:49:14.885358image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length20
Mean length9.1205674
Min length5

Characters and Unicode

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

Unique

Unique139 ?
Unique (%)98.6%

Sample

1st row수란마을회 태양광발전소
2nd row㈜에스에프씨 홍성 태양광발전소 2호기
3rd row일흥목장3호태양광발전소
4th row썬플라워태양광발전소
5th row조양8호태양광발전소
ValueCountFrequency (%)
태양광 35
 
17.9%
태양광발전소 7
 
3.6%
솔라앤팜 5
 
2.6%
내포태양광발전소 2
 
1.0%
금곡리 2
 
1.0%
준우태양광발전소 1
 
0.5%
이호05호 1
 
0.5%
일흥목장 1
 
0.5%
4호 1
 
0.5%
이호04호 1
 
0.5%
Other values (139) 139
71.3%
2024-01-10T06:49:15.147367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
양 144
 
11.2%
태 143
 
11.1%
광 142
 
11.0%
전 83
 
6.5%
발 81
 
6.3%
소 81
 
6.3%
54
 
4.2%
호 50
 
3.9%
1 24
 
1.9%
성 16
 
1.2%
Other values (154) 468
36.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1124
87.4%
Decimal Number 74
 
5.8%
Space Separator 54
 
4.2%
Uppercase Letter 21
 
1.6%
Other Symbol 5
 
0.4%
Other Punctuation 3
 
0.2%
Open Punctuation 2
 
0.2%
Close Punctuation 2
 
0.2%
Letter Number 1
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
양 144
12.8%
태 143
12.7%
광 142
 
12.6%
전 83
 
7.4%
발 81
 
7.2%
소 81
 
7.2%
호 50
 
4.4%
성 16
 
1.4%
에 16
 
1.4%
이 13
 
1.2%
Other values (130) 355
31.6%
Decimal Number
ValueCountFrequency (%)
1 24
32.4%
2 13
17.6%
0 11
14.9%
3 6
 
8.1%
4 6
 
8.1%
5 5
 
6.8%
7 3
 
4.1%
6 3
 
4.1%
8 2
 
2.7%
9 1
 
1.4%
Uppercase Letter
ValueCountFrequency (%)
D 6
28.6%
A 5
23.8%
Y 5
23.8%
M 2
 
9.5%
S 2
 
9.5%
J 1
 
4.8%
Other Punctuation
ValueCountFrequency (%)
& 1
33.3%
. 1
33.3%
: 1
33.3%
Space Separator
ValueCountFrequency (%)
54
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1129
87.8%
Common 135
 
10.5%
Latin 22
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
양 144
 
12.8%
태 143
 
12.7%
광 142
 
12.6%
전 83
 
7.4%
발 81
 
7.2%
소 81
 
7.2%
호 50
 
4.4%
성 16
 
1.4%
에 16
 
1.4%
이 13
 
1.2%
Other values (131) 360
31.9%
Common
ValueCountFrequency (%)
54
40.0%
1 24
17.8%
2 13
 
9.6%
0 11
 
8.1%
3 6
 
4.4%
4 6
 
4.4%
5 5
 
3.7%
7 3
 
2.2%
6 3
 
2.2%
( 2
 
1.5%
Other values (6) 8
 
5.9%
Latin
ValueCountFrequency (%)
D 6
27.3%
A 5
22.7%
Y 5
22.7%
M 2
 
9.1%
S 2
 
9.1%
J 1
 
4.5%
Ⅱ 1
 
4.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1124
87.4%
ASCII 156
 
12.1%
None 5
 
0.4%
Number Forms 1
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
양 144
12.8%
태 143
12.7%
광 142
 
12.6%
전 83
 
7.4%
발 81
 
7.2%
소 81
 
7.2%
호 50
 
4.4%
성 16
 
1.4%
에 16
 
1.4%
이 13
 
1.2%
Other values (130) 355
31.6%
ASCII
ValueCountFrequency (%)
54
34.6%
1 24
15.4%
2 13
 
8.3%
0 11
 
7.1%
3 6
 
3.8%
4 6
 
3.8%
D 6
 
3.8%
A 5
 
3.2%
Y 5
 
3.2%
5 5
 
3.2%
Other values (12) 21
 
13.5%
None
ValueCountFrequency (%)
㈜ 5
100.0%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

설비용량
Real number (ℝ)

Distinct73
Distinct (%)51.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean146.41387
Minimum9.6
Maximum499.84
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.4 KiB
2024-01-10T06:49:15.261204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9.6
5-th percentile19.32
Q197.2
median99
Q399.75
95-th percentile496
Maximum499.84
Range490.24
Interquartile range (IQR)2.55

Descriptive statistics

Standard deviation134.40383
Coefficient of variation (CV)0.91797203
Kurtosis1.8433472
Mean146.41387
Median Absolute Deviation (MAD)1.08
Skewness1.7591931
Sum20644.355
Variance18064.39
MonotonicityNot monotonic
2024-01-10T06:49:15.595114image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
98.28 14
 
9.9%
99.36 11
 
7.8%
99.225 9
 
6.4%
99.75 9
 
6.4%
99.0 7
 
5.0%
99.2 4
 
2.8%
97.92 4
 
2.8%
92.0 4
 
2.8%
98.49 3
 
2.1%
97.2 3
 
2.1%
Other values (63) 73
51.8%
ValueCountFrequency (%)
9.6 1
0.7%
10.0 2
1.4%
14.4 1
0.7%
15.0 1
0.7%
16.5 1
0.7%
19.32 2
1.4%
19.8 2
1.4%
20.0 1
0.7%
29.68 1
0.7%
29.76 1
0.7%
ValueCountFrequency (%)
499.84 1
0.7%
499.7 1
0.7%
499.2 1
0.7%
497.7 1
0.7%
497.61 2
1.4%
496.4 1
0.7%
496.0 2
1.4%
495.36 1
0.7%
494.46 1
0.7%
492.75 1
0.7%

발전소주소
Text

Distinct119
Distinct (%)84.4%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
2024-01-10T06:49:15.809126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length86
Median length44
Mean length22.028369
Min length14

Characters and Unicode

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

Unique

Unique113 ?
Unique (%)80.1%

Sample

1st row홍성군 홍동면 수란리 517(건물위)
2nd row홍성군 구항면 공리 456-3외 2필지
3rd row홍성군 홍동면 구정리 431-1(건물위)
4th row홍성군 홍동면 구정리 704외 1필지(건물위)
5th row홍성군 광천읍 가정리 263, 264, 264-1, 15-2
ValueCountFrequency (%)
홍성군 142
 
21.7%
결성면 34
 
5.2%
광천읍 20
 
3.1%
갈산면 17
 
2.6%
홍동면 15
 
2.3%
서부면 13
 
2.0%
은하면 11
 
1.7%
구항면 10
 
1.5%
홍성읍 10
 
1.5%
무량리 10
 
1.5%
Other values (236) 371
56.8%
2024-01-10T06:49:16.149214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
513
 
16.5%
성 195
 
6.3%
홍 178
 
5.7%
- 146
 
4.7%
군 142
 
4.6%
1 141
 
4.5%
리 138
 
4.4%
2 138
 
4.4%
면 111
 
3.6%
4 96
 
3.1%
Other values (88) 1308
42.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1517
48.8%
Decimal Number 786
25.3%
Space Separator 513
 
16.5%
Dash Punctuation 146
 
4.7%
Other Punctuation 58
 
1.9%
Close Punctuation 43
 
1.4%
Open Punctuation 43
 
1.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
성 195
 
12.9%
홍 178
 
11.7%
군 142
 
9.4%
리 138
 
9.1%
면 111
 
7.3%
산 71
 
4.7%
지 36
 
2.4%
결 34
 
2.2%
읍 32
 
2.1%
위 27
 
1.8%
Other values (72) 553
36.5%
Decimal Number
ValueCountFrequency (%)
1 141
17.9%
2 138
17.6%
4 96
12.2%
5 92
11.7%
6 74
9.4%
3 68
8.7%
8 61
7.8%
7 54
 
6.9%
9 33
 
4.2%
0 29
 
3.7%
Other Punctuation
ValueCountFrequency (%)
, 56
96.6%
/ 2
 
3.4%
Space Separator
ValueCountFrequency (%)
513
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 146
100.0%
Close Punctuation
ValueCountFrequency (%)
) 43
100.0%
Open Punctuation
ValueCountFrequency (%)
( 43
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 1589
51.2%
Hangul 1517
48.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
성 195
 
12.9%
홍 178
 
11.7%
군 142
 
9.4%
리 138
 
9.1%
면 111
 
7.3%
산 71
 
4.7%
지 36
 
2.4%
결 34
 
2.2%
읍 32
 
2.1%
위 27
 
1.8%
Other values (72) 553
36.5%
Common
ValueCountFrequency (%)
513
32.3%
- 146
 
9.2%
1 141
 
8.9%
2 138
 
8.7%
4 96
 
6.0%
5 92
 
5.8%
6 74
 
4.7%
3 68
 
4.3%
8 61
 
3.8%
, 56
 
3.5%
Other values (6) 204
 
12.8%

Most occurring blocks

ValueCountFrequency (%)
ASCII 1589
51.2%
Hangul 1517
48.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
513
32.3%
- 146
 
9.2%
1 141
 
8.9%
2 138
 
8.7%
4 96
 
6.0%
5 92
 
5.8%
6 74
 
4.7%
3 68
 
4.3%
8 61
 
3.8%
, 56
 
3.5%
Other values (6) 204
 
12.8%
Hangul
ValueCountFrequency (%)
성 195
 
12.9%
홍 178
 
11.7%
군 142
 
9.4%
리 138
 
9.1%
면 111
 
7.3%
산 71
 
4.7%
지 36
 
2.4%
결 34
 
2.2%
읍 32
 
2.1%
위 27
 
1.8%
Other values (72) 553
36.5%

최초허가일
Date

Distinct76
Distinct (%)53.9%
Missing0
Missing (%)0.0%
Memory size1.2 KiB
Minimum2014-02-18 00:00:00
Maximum2018-08-21 00:00:00
2024-01-10T06:49:16.258981image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:49:16.366635image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Date

MISSING 

Distinct65
Distinct (%)55.1%
Missing23
Missing (%)16.3%
Memory size1.2 KiB
Minimum2014-04-10 00:00:00
Maximum2019-04-19 00:00:00
2024-01-10T06:49:16.485948image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:49:16.596599image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-01-10T06:49:14.610600image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T06:49:16.672123image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설비용량최초허가일사업개시일
설비용량1.0000.9690.917
최초허가일0.9691.0000.995
사업개시일0.9170.9951.000

Missing values

2024-01-10T06:49:14.691422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:49:14.761943image/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수란마을회 태양광발전소10.0홍성군 홍동면 수란리 517(건물위)2014-02-182014-04-10
1㈜에스에프씨 홍성 태양광발전소 2호기302.59홍성군 구항면 공리 456-3외 2필지2014-02-182014-06-05
2일흥목장3호태양광발전소30.0홍성군 홍동면 구정리 431-1(건물위)2014-02-18<NA>
3썬플라워태양광발전소98.28홍성군 홍동면 구정리 704외 1필지(건물위)2014-03-252014-05-15
4조양8호태양광발전소497.61홍성군 광천읍 가정리 263, 264, 264-1, 15-22014-04-232015-07-29
5경우태양광발전소97.5홍성군 구항면 남산리 4-12014-06-11<NA>
6속동태양광발전소16.5홍성군 서부면 상황리 685-1 (건물위)2014-06-112014-09-11
7보영1호태양광발전소99.0홍성군 결성면 성남리 산68-22014-08-072016-02-01
8S&M1호태양광발전소99.0홍성군 결성면 성남리 산682014-08-072016-02-01
9성민태양광발전소99.0홍성군 금마면 덕정리 515-1, 516-22014-08-112015-04-07
발전소명설비용량발전소주소최초허가일사업개시일
131야베스태양광발전소97.09홍성군 은하면 대율리 365-12018-04-112018-12-21
132학계리2호태양광발전소19.32홍성군 홍성읍 학계리 284-3(건물위)2018-04-232019-01-22
133학계리1호태양광발전소19.32홍성군 홍성읍 학계리 284-1(건물위)2018-04-242019-01-22
134곡천태양광발전소14.4홍성군 갈산면 동성리 326-10외 2필지(건물위)2018-06-052018-12-06
135수완발전소48.96홍성군 홍북읍 상하리 349-1, 345-2 (건물위)2018-06-052018-02-28
136서일태양광발전소99.36홍성군 광천읍 월림리 356-82018-06-052018-12-08
137금일태양광발전소99.36홍성군 광천읍 월림리 356-92018-06-052018-12-08
138홍성예닮태양광발전소49.275홍성군 홍성읍 월산리 858-1외 5필지(건물위)2018-07-25<NA>
139월산제3호태양광발전소52.65홍성군 홍성읍 월산리 551-4(건물위)2018-07-262019-01-22
140양희네태양광발전소98.42홍성군 광천읍 가정리 산 13-1(부지위)2018-08-21<NA>