Overview

Dataset statistics

Number of variables6
Number of observations823
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory40.3 KiB
Average record size in memory50.2 B

Variable types

Numeric2
Text2
DateTime2

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=15113954

Alerts

연번 has unique valuesUnique

Reproduction

Analysis started2024-01-09 20:10:12.792775
Analysis finished2024-01-09 20:10:13.820960
Duration1.03 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct823
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean412
Minimum1
Maximum823
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.4 KiB
2024-01-10T05:10:13.902256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile42.1
Q1206.5
median412
Q3617.5
95-th percentile781.9
Maximum823
Range822
Interquartile range (IQR)411

Descriptive statistics

Standard deviation237.72393
Coefficient of variation (CV)0.57699983
Kurtosis-1.2
Mean412
Median Absolute Deviation (MAD)206
Skewness0
Sum339076
Variance56512.667
MonotonicityStrictly increasing
2024-01-10T05:10:14.074042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
554 1
 
0.1%
544 1
 
0.1%
545 1
 
0.1%
546 1
 
0.1%
547 1
 
0.1%
548 1
 
0.1%
549 1
 
0.1%
550 1
 
0.1%
551 1
 
0.1%
Other values (813) 813
98.8%
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 (%)
823 1
0.1%
822 1
0.1%
821 1
0.1%
820 1
0.1%
819 1
0.1%
818 1
0.1%
817 1
0.1%
816 1
0.1%
815 1
0.1%
814 1
0.1%

발전소명
Text

Distinct810
Distinct (%)98.4%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
2024-01-10T05:10:14.281622image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length17
Mean length11.376671
Min length3

Characters and Unicode

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

Unique

Unique797 ?
Unique (%)96.8%

Sample

1st row은골태양광 주식회사
2nd row행복7호 태양광 발전소
3rd row미산 태양광 발전소
4th row우주 태양광 발전소
5th row임종현 2호 태양광 발전소
ValueCountFrequency (%)
태양광발전소 685
37.1%
발전소 86
 
4.7%
태양광 80
 
4.3%
ds하만 33
 
1.8%
ds궁포 17
 
0.9%
요암동 17
 
0.9%
제석 17
 
0.9%
은포리 15
 
0.8%
신흑동 15
 
0.8%
2호 8
 
0.4%
Other values (751) 871
47.2%
2024-01-10T05:10:14.704706image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1021
 
10.9%
전 804
 
8.6%
양 801
 
8.6%
광 798
 
8.5%
소 798
 
8.5%
태 789
 
8.4%
발 788
 
8.4%
호 430
 
4.6%
1 211
 
2.3%
2 141
 
1.5%
Other values (286) 2782
29.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7494
80.0%
Space Separator 1021
 
10.9%
Decimal Number 667
 
7.1%
Uppercase Letter 131
 
1.4%
Open Punctuation 14
 
0.1%
Close Punctuation 14
 
0.1%
Lowercase Letter 10
 
0.1%
Dash Punctuation 8
 
0.1%
Other Punctuation 2
 
< 0.1%
Other Symbol 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 804
 
10.7%
양 801
 
10.7%
광 798
 
10.6%
소 798
 
10.6%
태 789
 
10.5%
발 788
 
10.5%
호 430
 
5.7%
동 82
 
1.1%
성 75
 
1.0%
제 69
 
0.9%
Other values (251) 2060
27.5%
Uppercase Letter
ValueCountFrequency (%)
S 56
42.7%
D 55
42.0%
J 4
 
3.1%
H 3
 
2.3%
Y 2
 
1.5%
G 2
 
1.5%
K 2
 
1.5%
P 1
 
0.8%
L 1
 
0.8%
F 1
 
0.8%
Other values (4) 4
 
3.1%
Decimal Number
ValueCountFrequency (%)
1 211
31.6%
2 141
21.1%
3 81
 
12.1%
0 50
 
7.5%
4 43
 
6.4%
5 36
 
5.4%
6 34
 
5.1%
7 29
 
4.3%
8 22
 
3.3%
9 20
 
3.0%
Lowercase Letter
ValueCountFrequency (%)
p 2
20.0%
o 2
20.0%
c 2
20.0%
k 2
20.0%
e 2
20.0%
Space Separator
ValueCountFrequency (%)
1021
100.0%
Open Punctuation
ValueCountFrequency (%)
( 14
100.0%
Close Punctuation
ValueCountFrequency (%)
) 14
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 8
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7496
80.1%
Common 1726
 
18.4%
Latin 141
 
1.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 804
 
10.7%
양 801
 
10.7%
광 798
 
10.6%
소 798
 
10.6%
태 789
 
10.5%
발 788
 
10.5%
호 430
 
5.7%
동 82
 
1.1%
성 75
 
1.0%
제 69
 
0.9%
Other values (252) 2062
27.5%
Latin
ValueCountFrequency (%)
S 56
39.7%
D 55
39.0%
J 4
 
2.8%
H 3
 
2.1%
p 2
 
1.4%
Y 2
 
1.4%
G 2
 
1.4%
o 2
 
1.4%
c 2
 
1.4%
k 2
 
1.4%
Other values (9) 11
 
7.8%
Common
ValueCountFrequency (%)
1021
59.2%
1 211
 
12.2%
2 141
 
8.2%
3 81
 
4.7%
0 50
 
2.9%
4 43
 
2.5%
5 36
 
2.1%
6 34
 
2.0%
7 29
 
1.7%
8 22
 
1.3%
Other values (5) 58
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7494
80.0%
ASCII 1867
 
19.9%
None 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1021
54.7%
1 211
 
11.3%
2 141
 
7.6%
3 81
 
4.3%
S 56
 
3.0%
D 55
 
2.9%
0 50
 
2.7%
4 43
 
2.3%
5 36
 
1.9%
6 34
 
1.8%
Other values (24) 139
 
7.4%
Hangul
ValueCountFrequency (%)
전 804
 
10.7%
양 801
 
10.7%
광 798
 
10.6%
소 798
 
10.6%
태 789
 
10.5%
발 788
 
10.5%
호 430
 
5.7%
동 82
 
1.1%
성 75
 
1.0%
제 69
 
0.9%
Other values (251) 2060
27.5%
None
ValueCountFrequency (%)
㈜ 2
100.0%

발전소 주소
Text

Distinct601
Distinct (%)73.0%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
2024-01-10T05:10:15.084788image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length57
Median length48
Mean length25.014581
Min length16

Characters and Unicode

Total characters20587
Distinct characters162
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

Unique521 ?
Unique (%)63.3%

Sample

1st row충청남도 보령시 성주면 만수로 860-6
2nd row충청남도 보령시 남포면 양항리 542-2
3rd row충청남도 보령시 미산면 늑전리 510-1
4th row충청남도 보령시 천북면 홍보로 619-18
5th row충청남도 보령시 주산면 야룡리 452-4
ValueCountFrequency (%)
충청남도 823
 
17.1%
보령시 823
 
17.1%
천북면 172
 
3.6%
산 148
 
3.1%
남포면 103
 
2.1%
주산면 96
 
2.0%
웅천읍 95
 
2.0%
청소면 82
 
1.7%
1호 81
 
1.7%
주교면 75
 
1.6%
Other values (655) 2305
48.0%
2024-01-10T05:10:15.610960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3980
19.3%
청 971
 
4.7%
남 941
 
4.6%
보 837
 
4.1%
령 831
 
4.0%
충 828
 
4.0%
도 826
 
4.0%
시 823
 
4.0%
1 742
 
3.6%
면 672
 
3.3%
Other values (152) 9136
44.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 12465
60.5%
Space Separator 3980
 
19.3%
Decimal Number 3735
 
18.1%
Dash Punctuation 283
 
1.4%
Other Punctuation 80
 
0.4%
Open Punctuation 22
 
0.1%
Close Punctuation 22
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
청 971
 
7.8%
남 941
 
7.5%
보 837
 
6.7%
령 831
 
6.7%
충 828
 
6.6%
도 826
 
6.6%
시 823
 
6.6%
면 672
 
5.4%
리 645
 
5.2%
지 552
 
4.4%
Other values (137) 4539
36.4%
Decimal Number
ValueCountFrequency (%)
1 742
19.9%
2 514
13.8%
3 433
11.6%
6 354
9.5%
4 314
8.4%
7 308
8.2%
9 306
8.2%
5 285
 
7.6%
8 251
 
6.7%
0 228
 
6.1%
Space Separator
ValueCountFrequency (%)
3980
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 283
100.0%
Other Punctuation
ValueCountFrequency (%)
, 80
100.0%
Open Punctuation
ValueCountFrequency (%)
( 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 22
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 12465
60.5%
Common 8122
39.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
청 971
 
7.8%
남 941
 
7.5%
보 837
 
6.7%
령 831
 
6.7%
충 828
 
6.6%
도 826
 
6.6%
시 823
 
6.6%
면 672
 
5.4%
리 645
 
5.2%
지 552
 
4.4%
Other values (137) 4539
36.4%
Common
ValueCountFrequency (%)
3980
49.0%
1 742
 
9.1%
2 514
 
6.3%
3 433
 
5.3%
6 354
 
4.4%
4 314
 
3.9%
7 308
 
3.8%
9 306
 
3.8%
5 285
 
3.5%
- 283
 
3.5%
Other values (5) 603
 
7.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 12465
60.5%
ASCII 8122
39.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3980
49.0%
1 742
 
9.1%
2 514
 
6.3%
3 433
 
5.3%
6 354
 
4.4%
4 314
 
3.9%
7 308
 
3.8%
9 306
 
3.8%
5 285
 
3.5%
- 283
 
3.5%
Other values (5) 603
 
7.4%
Hangul
ValueCountFrequency (%)
청 971
 
7.8%
남 941
 
7.5%
보 837
 
6.7%
령 831
 
6.7%
충 828
 
6.6%
도 826
 
6.6%
시 823
 
6.6%
면 672
 
5.4%
리 645
 
5.2%
지 552
 
4.4%
Other values (137) 4539
36.4%

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

Distinct211
Distinct (%)25.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean159.94819
Minimum10.92
Maximum2497.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.4 KiB
2024-01-10T05:10:15.786886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10.92
5-th percentile29.61
Q198.41
median99.2
Q399.87
95-th percentile498.96
Maximum2497.5
Range2486.58
Interquartile range (IQR)1.46

Descriptive statistics

Standard deviation201.76002
Coefficient of variation (CV)1.2614086
Kurtosis28.625449
Mean159.94819
Median Absolute Deviation (MAD)0.7
Skewness4.3684346
Sum131637.36
Variance40707.106
MonotonicityNot monotonic
2024-01-10T05:10:15.970279image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 95
 
11.5%
99.2 58
 
7.0%
99.96 52
 
6.3%
99.4 52
 
6.3%
99.36 33
 
4.0%
97.2 31
 
3.8%
97.31 29
 
3.5%
98.8 27
 
3.3%
99.45 27
 
3.3%
98.55 25
 
3.0%
Other values (201) 394
47.9%
ValueCountFrequency (%)
10.92 1
0.1%
15.08 1
0.1%
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%
19.0 2
0.2%
19.11 1
0.1%
ValueCountFrequency (%)
2497.5 1
 
0.1%
999.0 1
 
0.1%
998.4 2
 
0.2%
997.92 6
0.7%
996.84 1
 
0.1%
996.8 1
 
0.1%
996.48 2
 
0.2%
994.95 2
 
0.2%
994.5 1
 
0.1%
993.6 1
 
0.1%

사업허가일
Date

Distinct219
Distinct (%)26.6%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
Minimum1996-05-09 00:00:00
Maximum2022-10-12 00:00:00
2024-01-10T05:10:16.133806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:10:16.283249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Date

Distinct248
Distinct (%)30.1%
Missing0
Missing (%)0.0%
Memory size6.6 KiB
Minimum1996-05-09 00:00:00
Maximum2023-04-04 00:00:00
2024-01-10T05:10:16.459755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:10:16.624779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-01-10T05:10:13.392380image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:10:13.167071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:10:13.497652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:10:13.267738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:10:16.713696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)
연번1.0000.481
설비용량(kW)0.4811.000
2024-01-10T05:10:16.804807image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)
연번1.000-0.049
설비용량(kW)-0.0491.000

Missing values

2024-01-10T05:10:13.661028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:10:13.775437image/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은골태양광 주식회사충청남도 보령시 성주면 만수로 860-610.922022-10-122022-12-07
12행복7호 태양광 발전소충청남도 보령시 남포면 양항리 542-229.52022-09-202022-12-30
23미산 태양광 발전소충청남도 보령시 미산면 늑전리 510-119.112022-09-152023-01-11
34우주 태양광 발전소충청남도 보령시 천북면 홍보로 619-1819.722022-08-242022-11-07
45임종현 2호 태양광 발전소충청남도 보령시 주산면 야룡리 452-499.362022-07-192022-12-15
56아인 태양광 발전소충청남도 보령시 주교면 배다리길 122-2919.52022-07-142022-11-10
67덕창기업(주)1호 태양광 발전소충청남도 보령시 주교면 배다리길 116-999.842022-06-082023-02-23
78덕창기업(주)2호 태양광 발전소충청남도 보령시 주교면 배다리길 116-985.442022-06-082023-02-23
89세종 태양광 발전소충청남도 보령시 천북면 사호리 775-826.882022-03-112022-06-17
910태양2호 태양광 발전소충청남도 보령시 천북면 장은리 79099.762022-02-152022-10-01
연번발전소명발전소 주소설비용량(kW)사업허가일사업개시일
813814보령선에너지1호 태양광발전소충청남도 보령시 천북면 홍보로 1061992.82017-08-312019-04-20
814815(주)도솔사호리 태양광발전소충청남도 보령시 천북면 늘문이길 45952.02017-08-222018-12-27
815816보령장은리 태양광충청남도 보령시 천북면 홍보로 1061994.952017-03-272019-07-11
816817(주)대창 태양광발전소충청남도 보령시 웅천읍 대창증산로 922497.52016-11-012017-12-08
817818청소세기1호태양광충청남도 보령시 청소면 장좌울길 123996.842015-04-132016-01-11
818819의석 태양광발전소충청남도 보령시 청소면 원안송동길 53994.52014-11-202015-06-06
819820해맞이 태양광발전소㈜충청남도 보령시 천북면 홍보로 1061646.382014-08-222016-09-01
820821보령참빛 태양광 발전소충청남도 보령시 주산면 대창증산로 627500.852014-07-212014-10-06
821822(유)일광 태양광발전소충청남도 보령시 웅천읍 성동큰길 322990.02014-05-222015-05-19
822823조양10호충청남도 보령시 청라면 황룡장현길 131-50693.772014-05-222015-06-11