Overview

Dataset statistics

Number of variables5
Number of observations798
Missing cells442
Missing cells (%)11.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory32.1 KiB
Average record size in memory41.2 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 442 (55.4%) missing valuesMissing

Reproduction

Analysis started2024-01-09 21:49:11.320161
Analysis finished2024-01-09 21:49:11.747003
Duration0.43 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

발전소명
Text

Distinct776
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size6.4 KiB
2024-01-10T06:49:11.930403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length20
Mean length9.5125313
Min length2

Characters and Unicode

Total characters7591
Distinct characters317
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

Unique757 ?
Unique (%)94.9%

Sample

1st row(주)에스에프씨 홍성 태양광발전소
2nd row일흥목장3호 태양광발전소
3rd row(주)에스에프씨 홍성 태양광 발전소 2호기
4th row썬플라워 태양광발전소
5th row홍동면 수란마을회태양광발전소
ValueCountFrequency (%)
태양광발전소 182
 
17.5%
발전소 9
 
0.9%
무량 8
 
0.8%
태양광 7
 
0.7%
홍성2차 5
 
0.5%
에너지 5
 
0.5%
그린 5
 
0.5%
솔라앤팜 5
 
0.5%
4호 3
 
0.3%
주식회사 3
 
0.3%
Other values (776) 810
77.7%
2024-01-10T06:49:12.272248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 748
 
9.9%
태 746
 
9.8%
양 743
 
9.8%
전 716
 
9.4%
소 714
 
9.4%
발 711
 
9.4%
호 298
 
3.9%
246
 
3.2%
1 106
 
1.4%
2 105
 
1.4%
Other values (307) 2458
32.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6811
89.7%
Decimal Number 401
 
5.3%
Space Separator 246
 
3.2%
Uppercase Letter 81
 
1.1%
Close Punctuation 23
 
0.3%
Open Punctuation 23
 
0.3%
Dash Punctuation 2
 
< 0.1%
Other Punctuation 2
 
< 0.1%
Other Symbol 1
 
< 0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 748
 
11.0%
태 746
 
11.0%
양 743
 
10.9%
전 716
 
10.5%
소 714
 
10.5%
발 711
 
10.4%
호 298
 
4.4%
성 86
 
1.3%
대 69
 
1.0%
제 67
 
1.0%
Other values (271) 1913
28.1%
Uppercase Letter
ValueCountFrequency (%)
S 19
23.5%
M 12
14.8%
Y 9
11.1%
D 6
 
7.4%
B 5
 
6.2%
A 5
 
6.2%
N 4
 
4.9%
H 4
 
4.9%
G 3
 
3.7%
K 3
 
3.7%
Other values (8) 11
13.6%
Decimal Number
ValueCountFrequency (%)
1 106
26.4%
2 105
26.2%
3 52
13.0%
4 33
 
8.2%
5 23
 
5.7%
0 22
 
5.5%
7 18
 
4.5%
8 17
 
4.2%
6 16
 
4.0%
9 9
 
2.2%
Other Punctuation
ValueCountFrequency (%)
. 1
50.0%
＆ 1
50.0%
Space Separator
ValueCountFrequency (%)
246
100.0%
Close Punctuation
ValueCountFrequency (%)
) 23
100.0%
Open Punctuation
ValueCountFrequency (%)
( 23
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6812
89.7%
Common 697
 
9.2%
Latin 82
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 748
 
11.0%
태 746
 
11.0%
양 743
 
10.9%
전 716
 
10.5%
소 714
 
10.5%
발 711
 
10.4%
호 298
 
4.4%
성 86
 
1.3%
대 69
 
1.0%
제 67
 
1.0%
Other values (272) 1914
28.1%
Latin
ValueCountFrequency (%)
S 19
23.2%
M 12
14.6%
Y 9
11.0%
D 6
 
7.3%
B 5
 
6.1%
A 5
 
6.1%
N 4
 
4.9%
H 4
 
4.9%
G 3
 
3.7%
K 3
 
3.7%
Other values (9) 12
14.6%
Common
ValueCountFrequency (%)
246
35.3%
1 106
15.2%
2 105
15.1%
3 52
 
7.5%
4 33
 
4.7%
) 23
 
3.3%
( 23
 
3.3%
5 23
 
3.3%
0 22
 
3.2%
7 18
 
2.6%
Other values (6) 46
 
6.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6811
89.7%
ASCII 777
 
10.2%
None 2
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 748
 
11.0%
태 746
 
11.0%
양 743
 
10.9%
전 716
 
10.5%
소 714
 
10.5%
발 711
 
10.4%
호 298
 
4.4%
성 86
 
1.3%
대 69
 
1.0%
제 67
 
1.0%
Other values (271) 1913
28.1%
ASCII
ValueCountFrequency (%)
246
31.7%
1 106
13.6%
2 105
13.5%
3 52
 
6.7%
4 33
 
4.2%
) 23
 
3.0%
( 23
 
3.0%
5 23
 
3.0%
0 22
 
2.8%
S 19
 
2.4%
Other values (23) 125
16.1%
None
ValueCountFrequency (%)
㈜ 1
50.0%
＆ 1
50.0%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

설비용량
Real number (ℝ)

Distinct244
Distinct (%)30.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean144.69179
Minimum9.6
Maximum499.8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.1 KiB
2024-01-10T06:49:12.390800image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9.6
5-th percentile48.492
Q197.92
median99.28
Q399.9
95-th percentile495.72
Maximum499.8
Range490.2
Interquartile range (IQR)1.98

Descriptive statistics

Standard deviation118.46636
Coefficient of variation (CV)0.81874969
Kurtosis2.974515
Mean144.69179
Median Absolute Deviation (MAD)1.01
Skewness2.027187
Sum115464.05
Variance14034.278
MonotonicityNot monotonic
2024-01-10T06:49:12.498166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.9 82
 
10.3%
99.0 63
 
7.9%
99.28 42
 
5.3%
97.92 41
 
5.1%
99.36 34
 
4.3%
99.2 33
 
4.1%
95.76 31
 
3.9%
97.2 23
 
2.9%
99.84 22
 
2.8%
99.23 22
 
2.8%
Other values (234) 405
50.8%
ValueCountFrequency (%)
9.6 1
0.1%
10.0 2
0.3%
14.4 1
0.1%
14.53 1
0.1%
15.0 2
0.3%
15.12 1
0.1%
16.2 1
0.1%
16.38 1
0.1%
16.43 1
0.1%
16.5 1
0.1%
ValueCountFrequency (%)
499.8 4
0.5%
499.62 1
 
0.1%
499.59 2
0.3%
499.5 1
 
0.1%
499.38 2
0.3%
499.32 2
0.3%
499.28 1
 
0.1%
499.2 4
0.5%
499.0 3
0.4%
498.96 1
 
0.1%

발전소주소
Text

Distinct627
Distinct (%)78.6%
Missing0
Missing (%)0.0%
Memory size6.4 KiB
2024-01-10T06:49:12.766023image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length63
Median length56
Mean length24.870927
Min length15

Characters and Unicode

Total characters19847
Distinct characters134
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

Unique560 ?
Unique (%)70.2%

Sample

1st row충남 홍성군 구항면 공리 456-3외 1필지
2nd row충남 홍성군 홍동면 구정리 431-1
3rd row충남 홍성군 구항면 공리 456-3외 2필지
4th row홍성군 홍동면 구정리 704, 705-7(건물위)
5th row홍성군 홍동면 광금북로 114번길 13
ValueCountFrequency (%)
홍성군 798
 
17.7%
충남 681
 
15.1%
은하면 115
 
2.5%
결성면 98
 
2.2%
광천읍 92
 
2.0%
갈산면 90
 
2.0%
구항면 87
 
1.9%
충청남도 80
 
1.8%
홍동면 78
 
1.7%
서부면 75
 
1.7%
Other values (995) 2324
51.4%
2024-01-10T06:49:13.158219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3722
18.8%
성 961
 
4.8%
홍 955
 
4.8%
1 894
 
4.5%
- 849
 
4.3%
군 799
 
4.0%
남 789
 
4.0%
리 786
 
4.0%
충 764
 
3.8%
면 645
 
3.2%
Other values (124) 8683
43.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9755
49.2%
Decimal Number 4617
23.3%
Space Separator 3722
 
18.8%
Dash Punctuation 849
 
4.3%
Other Punctuation 484
 
2.4%
Close Punctuation 210
 
1.1%
Open Punctuation 210
 
1.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
성 961
 
9.9%
홍 955
 
9.8%
군 799
 
8.2%
남 789
 
8.1%
리 786
 
8.1%
충 764
 
7.8%
면 645
 
6.6%
산 312
 
3.2%
위 194
 
2.0%
건 159
 
1.6%
Other values (107) 3391
34.8%
Decimal Number
ValueCountFrequency (%)
1 894
19.4%
2 635
13.8%
3 573
12.4%
4 506
11.0%
5 423
9.2%
7 374
8.1%
6 357
 
7.7%
8 341
 
7.4%
0 263
 
5.7%
9 251
 
5.4%
Other Punctuation
ValueCountFrequency (%)
, 480
99.2%
/ 3
 
0.6%
. 1
 
0.2%
Space Separator
ValueCountFrequency (%)
3722
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 849
100.0%
Close Punctuation
ValueCountFrequency (%)
) 210
100.0%
Open Punctuation
ValueCountFrequency (%)
( 210
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 10092
50.8%
Hangul 9755
49.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
성 961
 
9.9%
홍 955
 
9.8%
군 799
 
8.2%
남 789
 
8.1%
리 786
 
8.1%
충 764
 
7.8%
면 645
 
6.6%
산 312
 
3.2%
위 194
 
2.0%
건 159
 
1.6%
Other values (107) 3391
34.8%
Common
ValueCountFrequency (%)
3722
36.9%
1 894
 
8.9%
- 849
 
8.4%
2 635
 
6.3%
3 573
 
5.7%
4 506
 
5.0%
, 480
 
4.8%
5 423
 
4.2%
7 374
 
3.7%
6 357
 
3.5%
Other values (7) 1279
 
12.7%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10092
50.8%
Hangul 9755
49.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3722
36.9%
1 894
 
8.9%
- 849
 
8.4%
2 635
 
6.3%
3 573
 
5.7%
4 506
 
5.0%
, 480
 
4.8%
5 423
 
4.2%
7 374
 
3.7%
6 357
 
3.5%
Other values (7) 1279
 
12.7%
Hangul
ValueCountFrequency (%)
성 961
 
9.9%
홍 955
 
9.8%
군 799
 
8.2%
남 789
 
8.1%
리 786
 
8.1%
충 764
 
7.8%
면 645
 
6.6%
산 312
 
3.2%
위 194
 
2.0%
건 159
 
1.6%
Other values (107) 3391
34.8%

최초허가일
Date

Distinct272
Distinct (%)34.1%
Missing0
Missing (%)0.0%
Memory size6.4 KiB
Minimum2013-01-07 00:00:00
Maximum2020-03-31 00:00:00
2024-01-10T06:49:13.270212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:49:13.375745image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Date

MISSING 

Distinct161
Distinct (%)45.2%
Missing442
Missing (%)55.4%
Memory size6.4 KiB
Minimum2014-04-07 00:00:00
Maximum2020-03-27 00:00:00
2024-01-10T06:49:13.469899image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:49:13.574614image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

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

Missing values

2024-01-10T06:49:11.630225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:49:11.703592image/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(주)에스에프씨 홍성 태양광발전소430.5충남 홍성군 구항면 공리 456-3외 1필지2013-01-072014-06-05
1일흥목장3호 태양광발전소30.0충남 홍성군 홍동면 구정리 431-12014-02-182014-04-07
2(주)에스에프씨 홍성 태양광 발전소 2호기302.59충남 홍성군 구항면 공리 456-3외 2필지2014-02-182014-06-05
3썬플라워 태양광발전소98.28홍성군 홍동면 구정리 704, 705-7(건물위)2014-03-252014-05-15
4홍동면 수란마을회태양광발전소10.0홍성군 홍동면 광금북로 114번길 132014-04-102014-04-10
5조양8호태양광발전소497.61충남 홍성군 광첩은 가정리 263, 264, 264-1, 15-22014-04-23<NA>
6속동태양광발전소16.2충남 홍성군 서부면 상황리 685-1(건물위)2014-06-112014-09-11
7경우 태양광발전소97.5충남 홍성군 구항면 남산리 4-1(건물위)2014-06-112014-07-10
8이호태양광발전소99.0충남 홍성군 서부면 이호리 394-1, 2(건물위)2014-08-062014-09-26
9보영1호 태양광발전소99.0충남 홍성군 결성면 성남리 산68-22014-08-072016-02-01
발전소명설비용량발전소주소최초허가일사업개시일
788학산2호태양광발전소97.09충남 홍성군 홍북읍 중계리 556-102020-02-18<NA>
789나빈2태양광발전소99.75충남 홍성군 장곡면 지정리 778-7(건물위)2020-02-21<NA>
790양지태양광발전소21.17충남 홍성군 홍성읍 월산리 831-4(건물위)2020-02-25<NA>
791명2호태양광발전소99.6홍성군 홍동면 구정리 476, 470-3, 471,475-2(건물위)2020-03-17<NA>
792홍동2호태양광발전소119.68홍성군 홍동면 구정리 476, 470-3, 471, 475-2(건물위)2020-03-17<NA>
793홍동1호태양광발전소99.6홍성군 홍동면 구정리 476, 470-1, 471, 475-2(건물위)2020-03-17<NA>
794한울태양광14.53충남 홍성군 구항면 장양리 606-1(건물위)2020-03-27<NA>
795병철태양광발전소82.17충남 홍성군 광천읍 상정리 327-9(건물위)2020-03-31<NA>
796병렬태양광발전소91.3충남 홍성군 광천읍 상정리 327-9(건물위)2020-03-31<NA>
797병오태양광발전소91.3충남 홍성군 광천읍 상정리 327-9(건물위)2020-03-31<NA>