Overview

Dataset statistics

Number of variables6
Number of observations990
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory48.5 KiB
Average record size in memory50.1 B

Variable types

Numeric2
Text2
Categorical1
DateTime1

Dataset

Description충청남도 보령시 신재생에너지발전사업허가현황(발전소명, 발전소 주소, 설비용량, 발전원, 사업허가일)에 대한 데이터
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=45&beforeMenuCd=DOM_000000201001001000&publicdatapk=15113952

Alerts

발전원 is highly imbalanced (97.4%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-09 22:15:07.589293
Analysis finished2024-01-09 22:15:08.332396
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct990
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean495.5
Minimum1
Maximum990
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.8 KiB
2024-01-10T07:15:08.392694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile50.45
Q1248.25
median495.5
Q3742.75
95-th percentile940.55
Maximum990
Range989
Interquartile range (IQR)494.5

Descriptive statistics

Standard deviation285.93268
Coefficient of variation (CV)0.5770589
Kurtosis-1.2
Mean495.5
Median Absolute Deviation (MAD)247.5
Skewness0
Sum490545
Variance81757.5
MonotonicityStrictly increasing
2024-01-10T07:15:08.499691image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
652 1
 
0.1%
654 1
 
0.1%
655 1
 
0.1%
656 1
 
0.1%
657 1
 
0.1%
658 1
 
0.1%
659 1
 
0.1%
660 1
 
0.1%
661 1
 
0.1%
Other values (980) 980
99.0%
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 (%)
990 1
0.1%
989 1
0.1%
988 1
0.1%
987 1
0.1%
986 1
0.1%
985 1
0.1%
984 1
0.1%
983 1
0.1%
982 1
0.1%
981 1
0.1%

발전소명
Text

Distinct974
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2024-01-10T07:15:08.645492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length18
Mean length11.348485
Min length3

Characters and Unicode

Total characters11235
Distinct characters330
Distinct categories11 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique959 ?
Unique (%)96.9%

Sample

1st row지파이브 태양광발전소
2nd row지포 태양광발전소
3rd row지쓰리 태양광발전소
4th row지투 태양광발전소
5th row지원 태양광발전소
ValueCountFrequency (%)
태양광발전소 762
34.2%
발전소 146
 
6.5%
태양광 141
 
6.3%
ds하만 33
 
1.5%
요암동 17
 
0.8%
ds궁포 17
 
0.8%
제석 17
 
0.8%
신흑동 15
 
0.7%
은포리 15
 
0.7%
2호 10
 
0.4%
Other values (922) 1057
47.4%
2024-01-10T07:15:09.136742image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1240
 
11.0%
양 962
 
8.6%
광 959
 
8.5%
전 955
 
8.5%
태 950
 
8.5%
소 950
 
8.5%
발 937
 
8.3%
호 505
 
4.5%
1 237
 
2.1%
2 165
 
1.5%
Other values (320) 3375
30.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9016
80.2%
Space Separator 1240
 
11.0%
Decimal Number 757
 
6.7%
Uppercase Letter 150
 
1.3%
Close Punctuation 19
 
0.2%
Open Punctuation 19
 
0.2%
Lowercase Letter 15
 
0.1%
Dash Punctuation 9
 
0.1%
Other Symbol 7
 
0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
양 962
 
10.7%
광 959
 
10.6%
전 955
 
10.6%
태 950
 
10.5%
소 950
 
10.5%
발 937
 
10.4%
호 505
 
5.6%
동 85
 
0.9%
성 85
 
0.9%
에 79
 
0.9%
Other values (276) 2549
28.3%
Uppercase Letter
ValueCountFrequency (%)
S 58
38.7%
D 55
36.7%
E 6
 
4.0%
G 4
 
2.7%
J 4
 
2.7%
N 3
 
2.0%
Y 3
 
2.0%
K 3
 
2.0%
H 3
 
2.0%
L 2
 
1.3%
Other values (8) 9
 
6.0%
Decimal Number
ValueCountFrequency (%)
1 237
31.3%
2 165
21.8%
3 103
13.6%
0 52
 
6.9%
4 50
 
6.6%
5 40
 
5.3%
6 34
 
4.5%
7 31
 
4.1%
8 24
 
3.2%
9 21
 
2.8%
Lowercase Letter
ValueCountFrequency (%)
e 3
20.0%
k 2
13.3%
p 2
13.3%
c 2
13.3%
o 2
13.3%
r 1
 
6.7%
t 1
 
6.7%
a 1
 
6.7%
w 1
 
6.7%
Space Separator
ValueCountFrequency (%)
1240
100.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 9
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 7
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9023
80.3%
Common 2047
 
18.2%
Latin 165
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
양 962
 
10.7%
광 959
 
10.6%
전 955
 
10.6%
태 950
 
10.5%
소 950
 
10.5%
발 937
 
10.4%
호 505
 
5.6%
동 85
 
0.9%
성 85
 
0.9%
에 79
 
0.9%
Other values (277) 2556
28.3%
Latin
ValueCountFrequency (%)
S 58
35.2%
D 55
33.3%
E 6
 
3.6%
G 4
 
2.4%
J 4
 
2.4%
N 3
 
1.8%
Y 3
 
1.8%
e 3
 
1.8%
K 3
 
1.8%
H 3
 
1.8%
Other values (17) 23
 
13.9%
Common
ValueCountFrequency (%)
1240
60.6%
1 237
 
11.6%
2 165
 
8.1%
3 103
 
5.0%
0 52
 
2.5%
4 50
 
2.4%
5 40
 
2.0%
6 34
 
1.7%
7 31
 
1.5%
8 24
 
1.2%
Other values (6) 71
 
3.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9016
80.2%
ASCII 2212
 
19.7%
None 7
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1240
56.1%
1 237
 
10.7%
2 165
 
7.5%
3 103
 
4.7%
S 58
 
2.6%
D 55
 
2.5%
0 52
 
2.4%
4 50
 
2.3%
5 40
 
1.8%
6 34
 
1.5%
Other values (33) 178
 
8.0%
Hangul
ValueCountFrequency (%)
양 962
 
10.7%
광 959
 
10.6%
전 955
 
10.6%
태 950
 
10.5%
소 950
 
10.5%
발 937
 
10.4%
호 505
 
5.6%
동 85
 
0.9%
성 85
 
0.9%
에 79
 
0.9%
Other values (276) 2549
28.3%
None
ValueCountFrequency (%)
㈜ 7
100.0%

발전소 주소
Text

Distinct704
Distinct (%)71.1%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
2024-01-10T07:15:09.367404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length48
Mean length24.643434
Min length16

Characters and Unicode

Total characters24397
Distinct characters187
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique594 ?
Unique (%)60.0%

Sample

1st row충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장
2nd row충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장
3rd row충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장
4th row충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장
5th row충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장
ValueCountFrequency (%)
충청남도 990
 
17.5%
보령시 990
 
17.5%
천북면 222
 
3.9%
산 156
 
2.8%
남포면 126
 
2.2%
주산면 116
 
2.0%
웅천읍 108
 
1.9%
주교면 94
 
1.7%
청소면 91
 
1.6%
1호 81
 
1.4%
Other values (782) 2689
47.5%
2024-01-10T07:15:09.696353image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4673
19.2%
청 1159
 
4.8%
남 1136
 
4.7%
보 1024
 
4.2%
령 1007
 
4.1%
충 1000
 
4.1%
도 995
 
4.1%
시 990
 
4.1%
1 868
 
3.6%
면 818
 
3.4%
Other values (177) 10727
44.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 14817
60.7%
Space Separator 4673
 
19.2%
Decimal Number 4373
 
17.9%
Dash Punctuation 384
 
1.6%
Other Punctuation 88
 
0.4%
Close Punctuation 31
 
0.1%
Open Punctuation 30
 
0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 1159
 
7.8%
남 1136
 
7.7%
보 1024
 
6.9%
령 1007
 
6.8%
충 1000
 
6.7%
도 995
 
6.7%
시 990
 
6.7%
면 818
 
5.5%
리 706
 
4.8%
지 560
 
3.8%
Other values (161) 5422
36.6%
Decimal Number
ValueCountFrequency (%)
1 868
19.8%
2 597
13.7%
3 496
11.3%
6 417
9.5%
4 402
9.2%
7 345
 
7.9%
5 341
 
7.8%
9 336
 
7.7%
0 290
 
6.6%
8 281
 
6.4%
Space Separator
ValueCountFrequency (%)
4673
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 384
100.0%
Other Punctuation
ValueCountFrequency (%)
, 88
100.0%
Close Punctuation
ValueCountFrequency (%)
) 31
100.0%
Open Punctuation
ValueCountFrequency (%)
( 30
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 14818
60.7%
Common 9579
39.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 1159
 
7.8%
남 1136
 
7.7%
보 1024
 
6.9%
령 1007
 
6.8%
충 1000
 
6.7%
도 995
 
6.7%
시 990
 
6.7%
면 818
 
5.5%
리 706
 
4.8%
지 560
 
3.8%
Other values (162) 5423
36.6%
Common
ValueCountFrequency (%)
4673
48.8%
1 868
 
9.1%
2 597
 
6.2%
3 496
 
5.2%
6 417
 
4.4%
4 402
 
4.2%
- 384
 
4.0%
7 345
 
3.6%
5 341
 
3.6%
9 336
 
3.5%
Other values (5) 720
 
7.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 14817
60.7%
ASCII 9579
39.3%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4673
48.8%
1 868
 
9.1%
2 597
 
6.2%
3 496
 
5.2%
6 417
 
4.4%
4 402
 
4.2%
- 384
 
4.0%
7 345
 
3.6%
5 341
 
3.6%
9 336
 
3.5%
Other values (5) 720
 
7.5%
Hangul
ValueCountFrequency (%)
청 1159
 
7.8%
남 1136
 
7.7%
보 1024
 
6.9%
령 1007
 
6.8%
충 1000
 
6.7%
도 995
 
6.7%
시 990
 
6.7%
면 818
 
5.5%
리 706
 
4.8%
지 560
 
3.8%
Other values (161) 5422
36.6%
None
ValueCountFrequency (%)
㈜ 1
100.0%

설비용량(kW)
Real number (ℝ)

Distinct295
Distinct (%)29.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean220.96666
Minimum10.92
Maximum2998.8
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size8.8 KiB
2024-01-10T07:15:09.806630image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10.92
5-th percentile29.636
Q198.28
median99.28
Q399.96
95-th percentile997.56
Maximum2998.8
Range2987.88
Interquartile range (IQR)1.68

Descriptive statistics

Standard deviation352.6326
Coefficient of variation (CV)1.5958634
Kurtosis19.469182
Mean220.96666
Median Absolute Deviation (MAD)0.73
Skewness3.9722961
Sum218756.99
Variance124349.75
MonotonicityNot monotonic
2024-01-10T07:15:09.909995image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 95
 
9.6%
99.96 58
 
5.9%
99.2 58
 
5.9%
99.4 52
 
5.3%
97.2 36
 
3.6%
99.36 33
 
3.3%
97.31 29
 
2.9%
98.8 27
 
2.7%
99.45 27
 
2.7%
98.55 25
 
2.5%
Other values (285) 550
55.6%
ValueCountFrequency (%)
10.92 1
0.1%
15.08 2
0.2%
15.3 1
0.1%
15.6 1
0.1%
17.75 1
0.1%
18.0 2
0.2%
18.68 1
0.1%
18.72 1
0.1%
18.9 1
0.1%
19.0 2
0.2%
ValueCountFrequency (%)
2998.8 1
0.1%
2802.0 1
0.1%
2749.95 2
0.2%
2497.5 1
0.1%
2250.4 1
0.1%
2007.36 1
0.1%
2004.48 1
0.1%
2003.22 1
0.1%
2001.6 1
0.1%
1996.8 1
0.1%

발전원
Categorical

IMBALANCE 

Distinct6
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
태양광
984 
소수력
 
2
바이오가스
 
1
화력
 
1
수력
 
1

Length

Max length5
Median length3
Mean length2.9989899
Min length2

Unique

Unique4 ?
Unique (%)0.4%

Sample

1st row태양광
2nd row태양광
3rd row태양광
4th row태양광
5th row태양광

Common Values

ValueCountFrequency (%)
태양광 984
99.4%
소수력 2
 
0.2%
바이오가스 1
 
0.1%
화력 1
 
0.1%
수력 1
 
0.1%
풍력 1
 
0.1%

Length

2024-01-10T07:15:10.008350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T07:15:10.098312image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
태양광 984
99.4%
소수력 2
 
0.2%
바이오가스 1
 
0.1%
화력 1
 
0.1%
수력 1
 
0.1%
풍력 1
 
0.1%

사업허가일
Date

Distinct302
Distinct (%)30.5%
Missing0
Missing (%)0.0%
Memory size7.9 KiB
Minimum1996-05-09 00:00:00
Maximum2023-05-12 00:00:00
2024-01-10T07:15:10.199841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:15:10.329146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-01-10T07:15:08.049180image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:15:07.892317image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:15:08.120225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T07:15:07.964227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T07:15:10.392361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)발전원
연번1.0000.6150.083
설비용량(kW)0.6151.0000.107
발전원0.0830.1071.000
2024-01-10T07:15:10.458616image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)발전원
연번1.0000.1390.043
설비용량(kW)0.1391.0000.056
발전원0.0430.0561.000

Missing values

2024-01-10T07:15:08.219664image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T07:15:08.298272image/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지파이브 태양광발전소충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장64.8태양광2023-05-12
12지포 태양광발전소충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장97.2태양광2023-05-12
23지쓰리 태양광발전소충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장97.2태양광2023-05-12
34지투 태양광발전소충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장97.2태양광2023-05-12
45지원 태양광발전소충청남도 보령시 주포면 관산공단길 60, 에스비정공 보령 2공장97.2태양광2023-05-12
56하늘 태양광발전소충청남도 보령시 남포면 보령남로 43950.4태양광2023-05-12
67김운일 태양광발전소충청남도 보령시 천북면 하만리 398499.8태양광2023-05-09
78이현문 태양광발전소충청남도 보령시 천북면 홍보로 537-104499.8태양광2023-05-09
89삼원에너지2 태양광 발전소충청남도 보령시 웅천읍 웅천산단2길 6193.73태양광2023-05-01
910삼원에너지 태양광 발전소충청남도 보령시 웅천읍 구룡리 943499.38태양광2023-05-01
연번발전소명발전소 주소설비용량(kW)발전원사업허가일
980981청소세기1호태양광충청남도 보령시 청소면 장좌울길 123996.84태양광2015-04-13
981982보령장산태양광충청남도 보령시 청라면 백현장산길 1862802.0태양광2015-03-12
982983단비영농조합법인천북면태양광발전소충청남도 보령시 천북면 홍보로 146-1131000.0태양광2015-03-02
983984의석 태양광발전소충청남도 보령시 청소면 원안송동길 53994.5태양광2014-11-20
984985(유)보령해냄충청남도 보령시 웅천읍 성동큰길 3221996.8태양광2014-10-24
985986해맞이 태양광발전소㈜충청남도 보령시 천북면 홍보로 1061646.38태양광2014-08-22
986987보령참빛 태양광 발전소충청남도 보령시 주산면 대창증산로 627500.85태양광2014-07-21
987988최순애 태양광발전소충청남도 보령시 천북면 오마니길 2855.0태양광2014-07-10
988989(유)일광 태양광발전소충청남도 보령시 웅천읍 성동큰길 322990.0태양광2014-05-22
989990조양10호충청남도 보령시 청라면 황룡장현길 131-50693.77태양광2014-05-22