Overview

Dataset statistics

Number of variables7
Number of observations406
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory23.1 KiB
Average record size in memory58.3 B

Variable types

Numeric2
Text2
Categorical1
DateTime2

Dataset

Description충청남도 보령시 신재생에너지발전소에 대한 데이터(신재생에너지발전소명, 면적, 발전원, 허가일, 주소 등)를 제공합니다.
URLhttps://www.data.go.kr/data/15037771/fileData.do

Alerts

발전원 has constant value ""Constant
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:57:05.136404
Analysis finished2023-12-12 19:57:06.124946
Duration0.99 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct406
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean203.5
Minimum1
Maximum406
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2023-12-13T04:57:06.185667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile21.25
Q1102.25
median203.5
Q3304.75
95-th percentile385.75
Maximum406
Range405
Interquartile range (IQR)202.5

Descriptive statistics

Standard deviation117.34635
Coefficient of variation (CV)0.57664056
Kurtosis-1.2
Mean203.5
Median Absolute Deviation (MAD)101.5
Skewness0
Sum82621
Variance13770.167
MonotonicityStrictly increasing
2023-12-13T04:57:06.302586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
269 1
 
0.2%
279 1
 
0.2%
278 1
 
0.2%
277 1
 
0.2%
276 1
 
0.2%
275 1
 
0.2%
274 1
 
0.2%
273 1
 
0.2%
272 1
 
0.2%
Other values (396) 396
97.5%
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 (%)
406 1
0.2%
405 1
0.2%
404 1
0.2%
403 1
0.2%
402 1
0.2%
401 1
0.2%
400 1
0.2%
399 1
0.2%
398 1
0.2%
397 1
0.2%

발전소명
Text

Distinct405
Distinct (%)99.8%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2023-12-13T04:57:06.635576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length17
Median length14
Mean length10.8867
Min length3

Characters and Unicode

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

Unique

Unique404 ?
Unique (%)99.5%

Sample

1st row수정 태양광발전소
2nd row샘실 태양광발전소
3rd row광재 태양광발전소
4th row용 태양광발전소
5th row창암 태양광발전소
ValueCountFrequency (%)
태양광발전소 381
44.9%
ds궁포 18
 
2.1%
제석 17
 
2.0%
수부리 5
 
0.6%
2호 5
 
0.6%
청소 4
 
0.5%
도미항 3
 
0.4%
현대낙동 3
 
0.4%
13호 3
 
0.4%
14호 3
 
0.4%
Other values (395) 407
47.9%
2023-12-13T04:57:07.074345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
443
 
10.0%
광 393
 
8.9%
전 393
 
8.9%
소 391
 
8.8%
양 390
 
8.8%
태 386
 
8.7%
발 384
 
8.7%
호 217
 
4.9%
1 103
 
2.3%
성 64
 
1.4%
Other values (212) 1256
28.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3592
81.3%
Space Separator 443
 
10.0%
Decimal Number 321
 
7.3%
Uppercase Letter 53
 
1.2%
Open Punctuation 4
 
0.1%
Close Punctuation 4
 
0.1%
Other Punctuation 2
 
< 0.1%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 393
10.9%
전 393
10.9%
소 391
10.9%
양 390
10.9%
태 386
10.7%
발 384
10.7%
호 217
 
6.0%
성 64
 
1.8%
현 47
 
1.3%
동 47
 
1.3%
Other values (187) 880
24.5%
Decimal Number
ValueCountFrequency (%)
1 103
32.1%
2 61
19.0%
3 36
 
11.2%
0 27
 
8.4%
4 24
 
7.5%
5 18
 
5.6%
6 17
 
5.3%
7 14
 
4.4%
8 11
 
3.4%
9 10
 
3.1%
Uppercase Letter
ValueCountFrequency (%)
S 21
39.6%
D 19
35.8%
J 4
 
7.5%
H 3
 
5.7%
F 1
 
1.9%
Y 1
 
1.9%
E 1
 
1.9%
L 1
 
1.9%
K 1
 
1.9%
M 1
 
1.9%
Space Separator
ValueCountFrequency (%)
443
100.0%
Open Punctuation
ValueCountFrequency (%)
( 4
100.0%
Close Punctuation
ValueCountFrequency (%)
) 4
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3593
81.3%
Common 774
 
17.5%
Latin 53
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 393
10.9%
전 393
10.9%
소 391
10.9%
양 390
10.9%
태 386
10.7%
발 384
10.7%
호 217
 
6.0%
성 64
 
1.8%
현 47
 
1.3%
동 47
 
1.3%
Other values (188) 881
24.5%
Common
ValueCountFrequency (%)
443
57.2%
1 103
 
13.3%
2 61
 
7.9%
3 36
 
4.7%
0 27
 
3.5%
4 24
 
3.1%
5 18
 
2.3%
6 17
 
2.2%
7 14
 
1.8%
8 11
 
1.4%
Other values (4) 20
 
2.6%
Latin
ValueCountFrequency (%)
S 21
39.6%
D 19
35.8%
J 4
 
7.5%
H 3
 
5.7%
F 1
 
1.9%
Y 1
 
1.9%
E 1
 
1.9%
L 1
 
1.9%
K 1
 
1.9%
M 1
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3592
81.3%
ASCII 827
 
18.7%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
443
53.6%
1 103
 
12.5%
2 61
 
7.4%
3 36
 
4.4%
0 27
 
3.3%
4 24
 
2.9%
S 21
 
2.5%
D 19
 
2.3%
5 18
 
2.2%
6 17
 
2.1%
Other values (14) 58
 
7.0%
Hangul
ValueCountFrequency (%)
광 393
10.9%
전 393
10.9%
소 391
10.9%
양 390
10.9%
태 386
10.7%
발 384
10.7%
호 217
 
6.0%
성 64
 
1.8%
현 47
 
1.3%
동 47
 
1.3%
Other values (187) 880
24.5%
None
ValueCountFrequency (%)
㈜ 1
100.0%

면적(제곱미터)
Real number (ℝ)

Distinct311
Distinct (%)76.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1501.6207
Minimum92
Maximum8424
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size3.7 KiB
2023-12-13T04:57:07.200406image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum92
5-th percentile234.75
Q1973
median1329.5
Q31600
95-th percentile3819.25
Maximum8424
Range8332
Interquartile range (IQR)627

Descriptive statistics

Standard deviation1168.9919
Coefficient of variation (CV)0.77848679
Kurtosis10.862887
Mean1501.6207
Median Absolute Deviation (MAD)310
Skewness2.9709278
Sum609658
Variance1366542
MonotonicityNot monotonic
2023-12-13T04:57:07.319407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1055 19
 
4.7%
1533 9
 
2.2%
646 9
 
2.2%
965 7
 
1.7%
1331 6
 
1.5%
1500 5
 
1.2%
1580 4
 
1.0%
973 3
 
0.7%
1231 3
 
0.7%
882 3
 
0.7%
Other values (301) 338
83.3%
ValueCountFrequency (%)
92 1
 
0.2%
102 1
 
0.2%
107 1
 
0.2%
108 1
 
0.2%
109 3
0.7%
110 1
 
0.2%
112 1
 
0.2%
130 1
 
0.2%
132 1
 
0.2%
138 1
 
0.2%
ValueCountFrequency (%)
8424 1
0.2%
7468 1
0.2%
6976 1
0.2%
6838 1
0.2%
6784 1
0.2%
6552 1
0.2%
6523 1
0.2%
6468 1
0.2%
6181 1
0.2%
6010 1
0.2%

발전원
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
태양광
406 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
태양광 406
100.0%

Length

2023-12-13T04:57:07.440567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T04:57:07.520705image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
태양광 406
100.0%

사업허가일
Date

Distinct113
Distinct (%)27.8%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
Minimum2012-04-09 00:00:00
Maximum2020-04-13 00:00:00
2023-12-13T04:57:07.603227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:57:07.713856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Date

Distinct127
Distinct (%)31.3%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
Minimum2013-06-14 00:00:00
Maximum2020-07-28 00:00:00
2023-12-13T04:57:07.825608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:57:07.933122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

발전소 주소
Text

Distinct336
Distinct (%)82.8%
Missing0
Missing (%)0.0%
Memory size3.3 KiB
2023-12-13T04:57:08.146368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length50
Mean length25.08867
Min length19

Characters and Unicode

Total characters10186
Distinct characters138
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

Unique304 ?
Unique (%)74.9%

Sample

1st row충청남도 보령시 청라면 원모루길 160
2nd row충청남도 보령시 주산면 삼곡리 558
3rd row충청남도 보령시 주산면 신구길 49-23
4th row충청남도 보령시 주산면 창암리 13번지 3호 , 14
5th row충청남도 보령시 주산면 창암리 13번지 1호 , 13-3, 14
ValueCountFrequency (%)
충청남도 404
 
17.1%
보령시 404
 
17.1%
천북면 82
 
3.5%
주산면 67
 
2.8%
남포면 49
 
2.1%
웅천읍 49
 
2.1%
청소면 42
 
1.8%
청라면 40
 
1.7%
주교면 36
 
1.5%
1호 36
 
1.5%
Other values (343) 1156
48.9%
2023-12-13T04:57:08.493172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1959
19.2%
청 489
 
4.8%
남 457
 
4.5%
보 409
 
4.0%
도 408
 
4.0%
령 407
 
4.0%
시 406
 
4.0%
충 404
 
4.0%
1 401
 
3.9%
리 339
 
3.3%
Other values (128) 4507
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6309
61.9%
Space Separator 1959
 
19.2%
Decimal Number 1794
 
17.6%
Dash Punctuation 66
 
0.6%
Other Punctuation 26
 
0.3%
Open Punctuation 16
 
0.2%
Close Punctuation 16
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 489
 
7.8%
남 457
 
7.2%
보 409
 
6.5%
도 408
 
6.5%
령 407
 
6.5%
시 406
 
6.4%
충 404
 
6.4%
리 339
 
5.4%
면 339
 
5.4%
지 327
 
5.2%
Other values (113) 2324
36.8%
Decimal Number
ValueCountFrequency (%)
1 401
22.4%
2 275
15.3%
6 194
10.8%
3 180
10.0%
7 156
 
8.7%
9 138
 
7.7%
5 125
 
7.0%
4 118
 
6.6%
0 107
 
6.0%
8 100
 
5.6%
Space Separator
ValueCountFrequency (%)
1959
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 66
100.0%
Other Punctuation
ValueCountFrequency (%)
, 26
100.0%
Open Punctuation
ValueCountFrequency (%)
( 16
100.0%
Close Punctuation
ValueCountFrequency (%)
) 16
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6309
61.9%
Common 3877
38.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 489
 
7.8%
남 457
 
7.2%
보 409
 
6.5%
도 408
 
6.5%
령 407
 
6.5%
시 406
 
6.4%
충 404
 
6.4%
리 339
 
5.4%
면 339
 
5.4%
지 327
 
5.2%
Other values (113) 2324
36.8%
Common
ValueCountFrequency (%)
1959
50.5%
1 401
 
10.3%
2 275
 
7.1%
6 194
 
5.0%
3 180
 
4.6%
7 156
 
4.0%
9 138
 
3.6%
5 125
 
3.2%
4 118
 
3.0%
0 107
 
2.8%
Other values (5) 224
 
5.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6309
61.9%
ASCII 3877
38.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1959
50.5%
1 401
 
10.3%
2 275
 
7.1%
6 194
 
5.0%
3 180
 
4.6%
7 156
 
4.0%
9 138
 
3.6%
5 125
 
3.2%
4 118
 
3.0%
0 107
 
2.8%
Other values (5) 224
 
5.8%
Hangul
ValueCountFrequency (%)
청 489
 
7.8%
남 457
 
7.2%
보 409
 
6.5%
도 408
 
6.5%
령 407
 
6.5%
시 406
 
6.4%
충 404
 
6.4%
리 339
 
5.4%
면 339
 
5.4%
지 327
 
5.2%
Other values (113) 2324
36.8%

Interactions

2023-12-13T04:57:05.782571image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:57:05.629454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:57:05.856762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:57:05.710005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:57:08.567976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번면적(제곱미터)
연번1.0000.447
면적(제곱미터)0.4471.000
2023-12-13T04:57:08.632608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번면적(제곱미터)
연번1.0000.040
면적(제곱미터)0.0401.000

Missing values

2023-12-13T04:57:05.961919image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:57:06.078689image/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수정 태양광발전소92태양광2020-04-132020-06-29충청남도 보령시 청라면 원모루길 160
12샘실 태양광발전소507태양광2019-12-172020-06-02충청남도 보령시 주산면 삼곡리 558
23광재 태양광발전소108태양광2019-12-032020-07-28충청남도 보령시 주산면 신구길 49-23
34용 태양광발전소1105태양광2019-06-122020-06-02충청남도 보령시 주산면 창암리 13번지 3호 , 14
45창암 태양광발전소1105태양광2019-06-122020-06-02충청남도 보령시 주산면 창암리 13번지 1호 , 13-3, 14
56평전 태양광발전소109태양광2019-05-292019-10-10충청남도 보령시 청소면 평전길 13
67노천3호 태양광발전소1361태양광2018-12-272019-06-12충청남도 보령시 웅천읍 노천리 562번지
78노천2호 태양광발전소1584태양광2018-12-272019-06-12충청남도 보령시 웅천읍 노천리 563번지
89노천1호 태양광발전소1737태양광2018-12-272019-06-12충청남도 보령시 웅천읍 노천리 563번지
910엔에스산업03호 태양광발전소1250태양광2018-12-072019-05-27충청남도 보령시 주포면 배재길 6-77
연번발전소명면적(제곱미터)발전원사업허가일사업개시일발전소 주소
396397보령1호 태양광발전소1835태양광2014-04-092015-01-06충청남도 보령시 천북면 하만리 639번지 1호
397398덕광전자(주)1342태양광2014-04-092015-03-31충청남도 보령시 주교면 주교리 605번지 1호
398399루스터3호 태양광발전소360태양광2014-04-092015-03-31충청남도 보령시 주교면 주교리 605번지
399400루스터2호 태양광발전소357태양광2014-04-092015-03-31충청남도 보령시 주교면 주교리 606번지
400401조양6호 태양광발전소629태양광2014-04-032015-06-12충청남도 보령시 청라면 장현리 961번지 76호
401402조양5호 태양광발전소629태양광2014-04-032015-06-12충청남도 보령시 청라면 장현리 961번지 47호
402403엔에스산업 태양광발전소6523태양광2014-03-052015-06-01충청남도 보령시 주포면 배재길 6-77
403404화산제1호 태양광발전소594태양광2014-02-252014-07-10충청남도 보령시 대청로 397 (화산동)
404405원산미영 태양광발전소196태양광2013-03-142013-06-14충청남도 보령시 오천면 원산도3길 157
405406보령그린환경㈜보령그린 발전소130태양광2012-04-092016-05-20충청남도 보령시 해안로 543 (남곡동)