Overview

Dataset statistics

Number of variables6
Number of observations738
Missing cells90
Missing cells (%)2.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory36.2 KiB
Average record size in memory50.2 B

Variable types

Numeric2
Text3
DateTime1

Dataset

Description전북특별자치도 전주시 태양광발전소 현황으로 발전소명, 설치장소, 설비용량, 허가일, 사용개시일을 제공합니다.
Author전라북도
URLhttps://www.bigdatahub.go.kr/index.jeonbuk?startPage=13&menuCd=DOM_000000103007001000&pListTypeStr=&pId=15034062

Alerts

완공일 개시일 has 90 (12.2%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-04-17 12:56:44.522511
Analysis finished2024-04-17 12:56:45.325348
Duration0.8 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct738
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean369.5
Minimum1
Maximum738
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.6 KiB
2024-04-17T21:56:45.386110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile37.85
Q1185.25
median369.5
Q3553.75
95-th percentile701.15
Maximum738
Range737
Interquartile range (IQR)368.5

Descriptive statistics

Standard deviation213.18654
Coefficient of variation (CV)0.57695951
Kurtosis-1.2
Mean369.5
Median Absolute Deviation (MAD)184.5
Skewness0
Sum272691
Variance45448.5
MonotonicityStrictly increasing
2024-04-17T21:56:45.507422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
497 1
 
0.1%
488 1
 
0.1%
489 1
 
0.1%
490 1
 
0.1%
491 1
 
0.1%
492 1
 
0.1%
493 1
 
0.1%
494 1
 
0.1%
495 1
 
0.1%
Other values (728) 728
98.6%
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 (%)
738 1
0.1%
737 1
0.1%
736 1
0.1%
735 1
0.1%
734 1
0.1%
733 1
0.1%
732 1
0.1%
731 1
0.1%
730 1
0.1%
729 1
0.1%

법인명 발전소명
Text

Distinct706
Distinct (%)95.7%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
2024-04-17T21:56:45.728255image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length8.9796748
Min length3

Characters and Unicode

Total characters6627
Distinct characters381
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

Unique678 ?
Unique (%)91.9%

Sample

1st row세종 태양광전력
2nd row인후태양광발전소
3rd row우아태양광발전소
4th row주유소 태양광
5th row파워택태양광발전소
ValueCountFrequency (%)
태양광발전소 85
 
10.0%
태양광 5
 
0.6%
우리태양광발전소 4
 
0.5%
평화태양광발전소 3
 
0.4%
금상태양광발전소 3
 
0.4%
성덕태양광발전소 3
 
0.4%
와이케이8호태양광발전소 2
 
0.2%
dy태양광발전소 2
 
0.2%
대한태양광발전소 2
 
0.2%
정태양광발전소 2
 
0.2%
Other values (710) 735
86.9%
2024-04-17T21:56:46.364779image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 675
 
10.2%
전 675
 
10.2%
태 672
 
10.1%
양 663
 
10.0%
소 632
 
9.5%
발 631
 
9.5%
호 190
 
2.9%
110
 
1.7%
1 86
 
1.3%
2 79
 
1.2%
Other values (371) 2214
33.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6167
93.1%
Decimal Number 226
 
3.4%
Space Separator 110
 
1.7%
Uppercase Letter 78
 
1.2%
Close Punctuation 12
 
0.2%
Open Punctuation 12
 
0.2%
Other Symbol 12
 
0.2%
Dash Punctuation 5
 
0.1%
Lowercase Letter 3
 
< 0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 675
 
10.9%
전 675
 
10.9%
태 672
 
10.9%
양 663
 
10.8%
소 632
 
10.2%
발 631
 
10.2%
호 190
 
3.1%
성 61
 
1.0%
에 61
 
1.0%
지 57
 
0.9%
Other values (330) 1850
30.0%
Uppercase Letter
ValueCountFrequency (%)
S 12
15.4%
J 9
11.5%
C 7
 
9.0%
Y 6
 
7.7%
K 5
 
6.4%
O 5
 
6.4%
N 4
 
5.1%
P 3
 
3.8%
G 3
 
3.8%
T 3
 
3.8%
Other values (11) 21
26.9%
Decimal Number
ValueCountFrequency (%)
1 86
38.1%
2 79
35.0%
3 27
 
11.9%
4 15
 
6.6%
5 6
 
2.7%
6 4
 
1.8%
7 3
 
1.3%
8 3
 
1.3%
0 2
 
0.9%
9 1
 
0.4%
Lowercase Letter
ValueCountFrequency (%)
e 1
33.3%
c 1
33.3%
h 1
33.3%
Other Punctuation
ValueCountFrequency (%)
& 1
50.0%
. 1
50.0%
Space Separator
ValueCountFrequency (%)
110
100.0%
Close Punctuation
ValueCountFrequency (%)
) 12
100.0%
Open Punctuation
ValueCountFrequency (%)
( 12
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 12
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6179
93.2%
Common 367
 
5.5%
Latin 81
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 675
 
10.9%
전 675
 
10.9%
태 672
 
10.9%
양 663
 
10.7%
소 632
 
10.2%
발 631
 
10.2%
호 190
 
3.1%
성 61
 
1.0%
에 61
 
1.0%
지 57
 
0.9%
Other values (331) 1862
30.1%
Latin
ValueCountFrequency (%)
S 12
14.8%
J 9
 
11.1%
C 7
 
8.6%
Y 6
 
7.4%
K 5
 
6.2%
O 5
 
6.2%
N 4
 
4.9%
P 3
 
3.7%
G 3
 
3.7%
T 3
 
3.7%
Other values (14) 24
29.6%
Common
ValueCountFrequency (%)
110
30.0%
1 86
23.4%
2 79
21.5%
3 27
 
7.4%
4 15
 
4.1%
) 12
 
3.3%
( 12
 
3.3%
5 6
 
1.6%
- 5
 
1.4%
6 4
 
1.1%
Other values (6) 11
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6167
93.1%
ASCII 448
 
6.8%
None 12
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 675
 
10.9%
전 675
 
10.9%
태 672
 
10.9%
양 663
 
10.8%
소 632
 
10.2%
발 631
 
10.2%
호 190
 
3.1%
성 61
 
1.0%
에 61
 
1.0%
지 57
 
0.9%
Other values (330) 1850
30.0%
ASCII
ValueCountFrequency (%)
110
24.6%
1 86
19.2%
2 79
17.6%
3 27
 
6.0%
4 15
 
3.3%
) 12
 
2.7%
( 12
 
2.7%
S 12
 
2.7%
J 9
 
2.0%
C 7
 
1.6%
Other values (30) 79
17.6%
None
ValueCountFrequency (%)
㈜ 12
100.0%

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

Distinct323
Distinct (%)43.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean76.611305
Minimum3
Maximum999.6
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.6 KiB
2024-04-17T21:56:46.509516image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile15.3715
Q125.92
median50.025
Q399
95-th percentile199.68
Maximum999.6
Range996.6
Interquartile range (IQR)73.08

Descriptive statistics

Standard deviation92.313656
Coefficient of variation (CV)1.2049613
Kurtosis29.647913
Mean76.611305
Median Absolute Deviation (MAD)30.87
Skewness4.6050418
Sum56539.143
Variance8521.811
MonotonicityNot monotonic
2024-04-17T21:56:46.659680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 58
 
7.9%
20.0 43
 
5.8%
30.0 28
 
3.8%
99.45 28
 
3.8%
50.0 25
 
3.4%
99.36 10
 
1.4%
99.9 10
 
1.4%
49.5 9
 
1.2%
99.6 9
 
1.2%
19.8 8
 
1.1%
Other values (313) 510
69.1%
ValueCountFrequency (%)
3.0 2
 
0.3%
3.2 1
 
0.1%
6.8 1
 
0.1%
7.5 1
 
0.1%
8.0 1
 
0.1%
9.0 1
 
0.1%
9.9 1
 
0.1%
10.0 6
0.8%
10.88 1
 
0.1%
11.85 1
 
0.1%
ValueCountFrequency (%)
999.6 1
0.1%
785.89 2
0.3%
700.0 1
0.1%
530.0 1
0.1%
500.0 1
0.1%
499.45 2
0.3%
498.42 1
0.1%
496.8 1
0.1%
448.95 1
0.1%
438.0 1
0.1%

발전소주소(설치장소)
Text

Distinct720
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
2024-04-17T21:56:46.898226image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length81
Median length52
Mean length26.636856
Min length11

Characters and Unicode

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

Unique

Unique706 ?
Unique (%)95.7%

Sample

1st row덕진구 팔복동 2가 797-26 건물상부
2nd row덕진구 인후동 1가 659-119
3rd row덕진구 우아동 3가 751-37
4th row덕진구 완주로 55(호성동 2가 593-4외 4필지)
5th row완산구 삼천동 2가 373-2
ValueCountFrequency (%)
덕진구 556
 
15.5%
전주시 460
 
12.8%
완산구 183
 
5.1%
건물상부 179
 
5.0%
전북 142
 
4.0%
성덕동 46
 
1.3%
남정동 38
 
1.1%
원동 26
 
0.7%
반월동 24
 
0.7%
화전동 24
 
0.7%
Other values (1293) 1916
53.3%
2024-04-17T21:56:47.289597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2873
 
14.6%
1 1162
 
5.9%
- 889
 
4.5%
2 856
 
4.4%
구 756
 
3.8%
동 746
 
3.8%
전 706
 
3.6%
덕 636
 
3.2%
주 607
 
3.1%
진 581
 
3.0%
Other values (219) 9846
50.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9334
47.5%
Decimal Number 5235
26.6%
Space Separator 2873
 
14.6%
Dash Punctuation 889
 
4.5%
Open Punctuation 452
 
2.3%
Close Punctuation 450
 
2.3%
Other Punctuation 371
 
1.9%
Uppercase Letter 28
 
0.1%
Lowercase Letter 21
 
0.1%
Other Symbol 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 756
 
8.1%
동 746
 
8.0%
전 706
 
7.6%
덕 636
 
6.8%
주 607
 
6.5%
진 581
 
6.2%
시 462
 
4.9%
건 335
 
3.6%
물 332
 
3.6%
상 330
 
3.5%
Other values (192) 3843
41.2%
Decimal Number
ValueCountFrequency (%)
1 1162
22.2%
2 856
16.4%
3 573
10.9%
4 483
9.2%
5 411
 
7.9%
6 410
 
7.8%
7 377
 
7.2%
8 341
 
6.5%
9 324
 
6.2%
0 298
 
5.7%
Uppercase Letter
ValueCountFrequency (%)
W 23
82.1%
K 2
 
7.1%
G 1
 
3.6%
A 1
 
3.6%
C 1
 
3.6%
Other Punctuation
ValueCountFrequency (%)
, 352
94.9%
. 16
 
4.3%
: 2
 
0.5%
/ 1
 
0.3%
Other Symbol
ValueCountFrequency (%)
㎡ 3
75.0%
㈜ 1
 
25.0%
Space Separator
ValueCountFrequency (%)
2873
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 889
100.0%
Open Punctuation
ValueCountFrequency (%)
( 452
100.0%
Close Punctuation
ValueCountFrequency (%)
) 450
100.0%
Lowercase Letter
ValueCountFrequency (%)
k 21
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 10274
52.3%
Hangul 9335
47.5%
Latin 49
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 756
 
8.1%
동 746
 
8.0%
전 706
 
7.6%
덕 636
 
6.8%
주 607
 
6.5%
진 581
 
6.2%
시 462
 
4.9%
건 335
 
3.6%
물 332
 
3.6%
상 330
 
3.5%
Other values (193) 3844
41.2%
Common
ValueCountFrequency (%)
2873
28.0%
1 1162
11.3%
- 889
 
8.7%
2 856
 
8.3%
3 573
 
5.6%
4 483
 
4.7%
( 452
 
4.4%
) 450
 
4.4%
5 411
 
4.0%
6 410
 
4.0%
Other values (10) 1715
16.7%
Latin
ValueCountFrequency (%)
W 23
46.9%
k 21
42.9%
K 2
 
4.1%
G 1
 
2.0%
A 1
 
2.0%
C 1
 
2.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10320
52.5%
Hangul 9321
47.4%
Compat Jamo 13
 
0.1%
CJK Compat 3
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2873
27.8%
1 1162
11.3%
- 889
 
8.6%
2 856
 
8.3%
3 573
 
5.6%
4 483
 
4.7%
( 452
 
4.4%
) 450
 
4.4%
5 411
 
4.0%
6 410
 
4.0%
Other values (15) 1761
17.1%
Hangul
ValueCountFrequency (%)
구 756
 
8.1%
동 746
 
8.0%
전 706
 
7.6%
덕 636
 
6.8%
주 607
 
6.5%
진 581
 
6.2%
시 462
 
5.0%
건 335
 
3.6%
물 332
 
3.6%
상 330
 
3.5%
Other values (187) 3830
41.1%
Compat Jamo
ValueCountFrequency (%)
ㄴ 5
38.5%
ㄱ 4
30.8%
ㄷ 2
 
15.4%
ㄹ 1
 
7.7%
ㅁ 1
 
7.7%
CJK Compat
ValueCountFrequency (%)
㎡ 3
100.0%
None
ValueCountFrequency (%)
㈜ 1
100.0%

최초허가일
Date

Distinct376
Distinct (%)50.9%
Missing0
Missing (%)0.0%
Memory size5.9 KiB
Minimum2006-09-14 00:00:00
Maximum2021-07-29 00:00:00
2024-04-17T21:56:47.409371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T21:56:47.525715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

완공일 개시일
Text

MISSING 

Distinct433
Distinct (%)66.8%
Missing90
Missing (%)12.2%
Memory size5.9 KiB
2024-04-17T21:56:47.764066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.9861111
Min length1

Characters and Unicode

Total characters6471
Distinct characters12
Distinct categories3 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique308 ?
Unique (%)47.5%

Sample

1st row2007-12-11
2nd row2007-06-27
3rd row2007-12-15
4th row2007-12-15
5th row2008-05-06
ValueCountFrequency (%)
2013-05-21 12
 
1.9%
2013-10-23 11
 
1.7%
2021-06-28 9
 
1.4%
2019-12-30 6
 
0.9%
2010-03-29 5
 
0.8%
2019-06-28 5
 
0.8%
2019-10-11 5
 
0.8%
2018-06-25 5
 
0.8%
2018-06-05 5
 
0.8%
2018-06-04 5
 
0.8%
Other values (422) 579
89.5%
2024-04-17T21:56:48.100595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 1463
22.6%
- 1294
20.0%
2 1218
18.8%
1 1156
17.9%
3 252
 
3.9%
4 214
 
3.3%
9 208
 
3.2%
8 189
 
2.9%
5 175
 
2.7%
6 157
 
2.4%
Other values (2) 145
 
2.2%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 5176
80.0%
Dash Punctuation 1294
 
20.0%
Space Separator 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1463
28.3%
2 1218
23.5%
1 1156
22.3%
3 252
 
4.9%
4 214
 
4.1%
9 208
 
4.0%
8 189
 
3.7%
5 175
 
3.4%
6 157
 
3.0%
7 144
 
2.8%
Dash Punctuation
ValueCountFrequency (%)
- 1294
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 6471
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 1463
22.6%
- 1294
20.0%
2 1218
18.8%
1 1156
17.9%
3 252
 
3.9%
4 214
 
3.3%
9 208
 
3.2%
8 189
 
2.9%
5 175
 
2.7%
6 157
 
2.4%
Other values (2) 145
 
2.2%

Most occurring blocks

ValueCountFrequency (%)
ASCII 6471
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 1463
22.6%
- 1294
20.0%
2 1218
18.8%
1 1156
17.9%
3 252
 
3.9%
4 214
 
3.3%
9 208
 
3.2%
8 189
 
2.9%
5 175
 
2.7%
6 157
 
2.4%
Other values (2) 145
 
2.2%

Interactions

2024-04-17T21:56:45.021962image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T21:56:44.863265image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T21:56:45.099796image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-17T21:56:44.941799image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-17T21:56:48.187097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비허가 용량(kW)
연번1.0000.190
설비허가 용량(kW)0.1901.000
2024-04-17T21:56:48.262264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비허가 용량(kW)
연번1.0000.100
설비허가 용량(kW)0.1001.000

Missing values

2024-04-17T21:56:45.205821image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-17T21:56:45.289614image/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세종 태양광전력9.0덕진구 팔복동 2가 797-26 건물상부2006-09-142007-12-11
12인후태양광발전소3.0덕진구 인후동 1가 659-1192007-05-182007-06-27
23우아태양광발전소3.2덕진구 우아동 3가 751-372007-10-022007-12-15
34주유소 태양광3.0덕진구 완주로 55(호성동 2가 593-4외 4필지)2007-10-172007-12-15
45파워택태양광발전소95.9완산구 삼천동 2가 373-22008-02-212008-05-06
56㈜내일은해가뜬다95.2덕진구 원동 산209번지2008-08-122008-09-30
67에이치비오태양광발전소26.79덕진구 용정동 1742008-11-202011-12-20
78팔선태양광발전소97.02덕진구 원동 산126-12008-12-052010-03-29
89성덕태양광발전소97.02덕진구 성덕동 170-32008-12-052010-03-29
910자카태양광발전소97.2덕진구 성덕동170-432008-12-052010-03-29
연번법인명 발전소명설비허가 용량(kW)발전소주소(설치장소)최초허가일완공일 개시일
728729세림2호태양광발전소29.575전주시 완산구 평화동1가 642-1(맏내4길 16-28, 건물상부)2021-06-16<NA>
729730태영태양광1호발전소29.76전주시 덕진구 용정동265-37, 주1 건물상부(용덕길47-45)2021-06-21<NA>
730731태영태양광2호발전소29.76전주시 덕진구 용정동265-37, 주2 건물상부(용덕길47-45)2021-06-21<NA>
731732지원엔지니어링99.19전주시 덕진구 반월동34-1(원화전1길57-46)2021-06-22<NA>
732733비지스태양광발전소19.74전주시 덕진구 팽나무4길18,(인후동1가775-3), 건물상부2021-07-16<NA>
733734휴형태양광28.9전주시 덕진구 인후동1가 509-17, 509-19(진버들2길21, 건물상부)2021-07-16<NA>
734735선에너지3호태양광발전소94.16전주시 덕진구 도강길168(1동, 2동 건물상부)2021-07-29<NA>
735736선에너지4호태양광발전소94.16전주시 덕진구 도강길168(3동, 4동 건물상부)2021-07-29<NA>
736737선에너지5호태양광발전소94.16전주시 덕진구 도강길168(5동, 6동 건물상부)2021-07-29<NA>
737738선에너지6호태양광발전소94.16전주시 덕진구 도강길168(7동, 8동 건물상부)2021-07-29<NA>