Overview

Dataset statistics

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

Variable types

Numeric2
Text2
DateTime2

Dataset

Description전북특별자치도 전주시 태양광발전소 현황으로 발전소명, 설치장소, 설비용량, 허가일, 사용개시일을 제공합니다.항목 : 발전소명, 설치장소, 설비용량, 허가일, 사용개시일제공부서 : 기후변화대응과
Author전북특별자치도 전주시
URLhttps://www.data.go.kr/data/15034062/fileData.do

Alerts

연번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 12:07:06.108134
Analysis finished2024-03-14 12:07:08.418893
Duration2.31 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct699
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean350
Minimum1
Maximum699
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.3 KiB
2024-03-14T21:07:08.624786image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile35.9
Q1175.5
median350
Q3524.5
95-th percentile664.1
Maximum699
Range698
Interquartile range (IQR)349

Descriptive statistics

Standard deviation201.92821
Coefficient of variation (CV)0.57693773
Kurtosis-1.2
Mean350
Median Absolute Deviation (MAD)175
Skewness0
Sum244650
Variance40775
MonotonicityStrictly increasing
2024-03-14T21:07:09.077142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
471 1
 
0.1%
463 1
 
0.1%
464 1
 
0.1%
465 1
 
0.1%
466 1
 
0.1%
467 1
 
0.1%
468 1
 
0.1%
469 1
 
0.1%
470 1
 
0.1%
Other values (689) 689
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 (%)
699 1
0.1%
698 1
0.1%
697 1
0.1%
696 1
0.1%
695 1
0.1%
694 1
0.1%
693 1
0.1%
692 1
0.1%
691 1
0.1%
690 1
0.1%

발전소명
Text

Distinct667
Distinct (%)95.4%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
2024-03-14T21:07:10.008648image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length8.8655222
Min length3

Characters and Unicode

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

Unique

Unique641 ?
Unique (%)91.7%

Sample

1st row인후태양광발전소
2nd row세종태양광전력
3rd row우아태양광발전소
4th row주유소 태양광
5th row파워택태양광발전소
ValueCountFrequency (%)
태양광발전소 75
 
9.4%
태양광 5
 
0.6%
우리태양광발전소 4
 
0.5%
금상태양광발전소 3
 
0.4%
성덕태양광발전소 3
 
0.4%
우아태양광발전소 3
 
0.4%
평화태양광발전소 3
 
0.4%
믿음태양광발전소 3
 
0.4%
삼천태양광발전소 2
 
0.3%
dy태양광발전소 2
 
0.3%
Other values (668) 691
87.0%
2024-03-14T21:07:11.190401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 639
 
10.3%
태 637
 
10.3%
전 634
 
10.2%
양 626
 
10.1%
소 596
 
9.6%
발 595
 
9.6%
호 173
 
2.8%
97
 
1.6%
1 75
 
1.2%
2 69
 
1.1%
Other values (360) 2056
33.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5800
93.6%
Decimal Number 198
 
3.2%
Space Separator 97
 
1.6%
Uppercase Letter 63
 
1.0%
Other Symbol 12
 
0.2%
Close Punctuation 11
 
0.2%
Open Punctuation 11
 
0.2%
Dash Punctuation 4
 
0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 639
 
11.0%
태 637
 
11.0%
전 634
 
10.9%
양 626
 
10.8%
소 596
 
10.3%
발 595
 
10.3%
호 173
 
3.0%
에 58
 
1.0%
성 57
 
1.0%
지 55
 
0.9%
Other values (324) 1730
29.8%
Uppercase Letter
ValueCountFrequency (%)
S 10
15.9%
J 8
12.7%
C 6
 
9.5%
O 5
 
7.9%
Y 4
 
6.3%
P 3
 
4.8%
D 3
 
4.8%
K 3
 
4.8%
T 2
 
3.2%
M 2
 
3.2%
Other values (10) 17
27.0%
Decimal Number
ValueCountFrequency (%)
1 75
37.9%
2 69
34.8%
3 24
 
12.1%
4 14
 
7.1%
5 6
 
3.0%
6 4
 
2.0%
0 2
 
1.0%
8 2
 
1.0%
7 1
 
0.5%
9 1
 
0.5%
Space Separator
ValueCountFrequency (%)
97
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 12
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5812
93.8%
Common 322
 
5.2%
Latin 63
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 639
 
11.0%
태 637
 
11.0%
전 634
 
10.9%
양 626
 
10.8%
소 596
 
10.3%
발 595
 
10.2%
호 173
 
3.0%
에 58
 
1.0%
성 57
 
1.0%
지 55
 
0.9%
Other values (325) 1742
30.0%
Latin
ValueCountFrequency (%)
S 10
15.9%
J 8
12.7%
C 6
 
9.5%
O 5
 
7.9%
Y 4
 
6.3%
P 3
 
4.8%
D 3
 
4.8%
K 3
 
4.8%
T 2
 
3.2%
M 2
 
3.2%
Other values (10) 17
27.0%
Common
ValueCountFrequency (%)
97
30.1%
1 75
23.3%
2 69
21.4%
3 24
 
7.5%
4 14
 
4.3%
) 11
 
3.4%
( 11
 
3.4%
5 6
 
1.9%
6 4
 
1.2%
- 4
 
1.2%
Other values (5) 7
 
2.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5800
93.6%
ASCII 385
 
6.2%
None 12
 
0.2%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 639
 
11.0%
태 637
 
11.0%
전 634
 
10.9%
양 626
 
10.8%
소 596
 
10.3%
발 595
 
10.3%
호 173
 
3.0%
에 58
 
1.0%
성 57
 
1.0%
지 55
 
0.9%
Other values (324) 1730
29.8%
ASCII
ValueCountFrequency (%)
97
25.2%
1 75
19.5%
2 69
17.9%
3 24
 
6.2%
4 14
 
3.6%
) 11
 
2.9%
( 11
 
2.9%
S 10
 
2.6%
J 8
 
2.1%
C 6
 
1.6%
Other values (25) 60
15.6%
None
ValueCountFrequency (%)
㈜ 12
100.0%

설치장소
Text

Distinct682
Distinct (%)97.6%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
2024-03-14T21:07:11.862932image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length87
Median length61
Mean length33.529328
Min length21

Characters and Unicode

Total characters23437
Distinct characters227
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

Unique667 ?
Unique (%)95.4%

Sample

1st row전북특별자치도 전주시 덕진구 인후동1가659-119
2nd row전북특별자치도 전주시 덕진구 팔복동2가797-26건물상부
3rd row전북특별자치도 전주시 덕진구 우아동3가751-37
4th row전북특별자치도 전주시 덕진구 완주로55(호성동2가593-4외4필지)
5th row전북특별자치도 전주시 완산구 삼천동2가373-2
ValueCountFrequency (%)
전북특별자치도 699
25.0%
전주시 699
25.0%
덕진구 528
18.9%
완산구 171
 
6.1%
여의동550-1(여산로122-2,건물상부 3
 
0.1%
화전동74-6 3
 
0.1%
호남로2519-19(성덕동76-6 2
 
0.1%
강흥동126-4(도강길166 2
 
0.1%
반월동620-7건물지붕 2
 
0.1%
여의동558-4,건물상부 2
 
0.1%
Other values (676) 685
24.5%
2024-03-14T21:07:12.844009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2097
 
8.9%
전 1476
 
6.3%
1 1114
 
4.8%
주 844
 
3.6%
- 843
 
3.6%
2 809
 
3.5%
자 736
 
3.1%
동 718
 
3.1%
구 714
 
3.0%
북 714
 
3.0%
Other values (217) 13372
57.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 14294
61.0%
Decimal Number 4938
 
21.1%
Space Separator 2097
 
8.9%
Dash Punctuation 843
 
3.6%
Open Punctuation 430
 
1.8%
Close Punctuation 428
 
1.8%
Other Punctuation 353
 
1.5%
Uppercase Letter 28
 
0.1%
Lowercase Letter 21
 
0.1%
Other Symbol 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 1476
 
10.3%
주 844
 
5.9%
자 736
 
5.1%
동 718
 
5.0%
구 714
 
5.0%
북 714
 
5.0%
도 710
 
5.0%
시 700
 
4.9%
치 699
 
4.9%
특 699
 
4.9%
Other values (190) 6284
44.0%
Decimal Number
ValueCountFrequency (%)
1 1114
22.6%
2 809
16.4%
3 535
10.8%
4 460
9.3%
6 389
 
7.9%
5 388
 
7.9%
7 351
 
7.1%
8 331
 
6.7%
9 295
 
6.0%
0 266
 
5.4%
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 (%)
, 334
94.6%
. 16
 
4.5%
: 2
 
0.6%
/ 1
 
0.3%
Other Symbol
ValueCountFrequency (%)
㎡ 3
75.0%
㈜ 1
 
25.0%
Space Separator
ValueCountFrequency (%)
2097
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 843
100.0%
Open Punctuation
ValueCountFrequency (%)
( 430
100.0%
Close Punctuation
ValueCountFrequency (%)
) 428
100.0%
Lowercase Letter
ValueCountFrequency (%)
k 21
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 14295
61.0%
Common 9093
38.8%
Latin 49
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 1476
 
10.3%
주 844
 
5.9%
자 736
 
5.1%
동 718
 
5.0%
구 714
 
5.0%
북 714
 
5.0%
도 710
 
5.0%
시 700
 
4.9%
치 699
 
4.9%
특 699
 
4.9%
Other values (191) 6285
44.0%
Common
ValueCountFrequency (%)
2097
23.1%
1 1114
12.3%
- 843
9.3%
2 809
 
8.9%
3 535
 
5.9%
4 460
 
5.1%
( 430
 
4.7%
) 428
 
4.7%
6 389
 
4.3%
5 388
 
4.3%
Other values (10) 1600
17.6%
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 (%)
Hangul 14291
61.0%
ASCII 9139
39.0%
CJK Compat 3
 
< 0.1%
Compat Jamo 3
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2097
22.9%
1 1114
12.2%
- 843
9.2%
2 809
 
8.9%
3 535
 
5.9%
4 460
 
5.0%
( 430
 
4.7%
) 428
 
4.7%
6 389
 
4.3%
5 388
 
4.2%
Other values (15) 1646
18.0%
Hangul
ValueCountFrequency (%)
전 1476
 
10.3%
주 844
 
5.9%
자 736
 
5.2%
동 718
 
5.0%
구 714
 
5.0%
북 714
 
5.0%
도 710
 
5.0%
시 700
 
4.9%
치 699
 
4.9%
특 699
 
4.9%
Other values (188) 6281
44.0%
CJK Compat
ValueCountFrequency (%)
㎡ 3
100.0%
Compat Jamo
ValueCountFrequency (%)
ㄴ 2
66.7%
ㄱ 1
33.3%
None
ValueCountFrequency (%)
㈜ 1
100.0%

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

Distinct305
Distinct (%)43.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean70.994961
Minimum3
Maximum785.89
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size6.3 KiB
2024-03-14T21:07:13.088388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile15.58
Q124.91
median50
Q399
95-th percentile150.249
Maximum785.89
Range782.89
Interquartile range (IQR)74.09

Descriptive statistics

Standard deviation77.40217
Coefficient of variation (CV)1.0902488
Kurtosis25.265982
Mean70.994961
Median Absolute Deviation (MAD)30.56
Skewness4.236957
Sum49625.478
Variance5991.096
MonotonicityNot monotonic
2024-03-14T21:07:13.349652image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 57
 
8.2%
20.0 43
 
6.2%
99.45 28
 
4.0%
30.0 26
 
3.7%
50.0 24
 
3.4%
99.36 10
 
1.4%
99.6 9
 
1.3%
49.5 9
 
1.3%
99.33 8
 
1.1%
19.8 7
 
1.0%
Other values (295) 478
68.4%
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.9%
10.88 1
 
0.1%
11.85 1
 
0.1%
ValueCountFrequency (%)
785.89 1
0.1%
700.0 1
0.1%
530.0 1
0.1%
500.0 1
0.1%
498.42 1
0.1%
496.8 1
0.1%
448.95 1
0.1%
438.0 1
0.1%
410.0 2
0.3%
408.03 1
0.1%

허가일
Date

Distinct372
Distinct (%)53.2%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Minimum2006-09-14 00:00:00
Maximum2021-12-14 00:00:00
2024-03-14T21:07:13.604957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:07:13.904952image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Date

Distinct467
Distinct (%)66.8%
Missing0
Missing (%)0.0%
Memory size5.6 KiB
Minimum2007-06-27 00:00:00
Maximum2022-02-28 00:00:00
2024-03-14T21:07:14.298481image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:07:14.719525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-14T21:07:07.252533image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:07:06.694972image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:07:07.535596image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T21:07:06.967523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T21:07:14.967694image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)
연번1.0000.150
설비용량(kW)0.1501.000
2024-03-14T21:07:15.196391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)
연번1.0000.114
설비용량(kW)0.1141.000

Missing values

2024-03-14T21:07:07.919781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T21:07:08.274601image/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인후태양광발전소전북특별자치도 전주시 덕진구 인후동1가659-1193.02007-05-182007-06-27
12세종태양광전력전북특별자치도 전주시 덕진구 팔복동2가797-26건물상부9.02006-09-142007-12-11
23우아태양광발전소전북특별자치도 전주시 덕진구 우아동3가751-373.22007-10-022007-12-15
34주유소 태양광전북특별자치도 전주시 덕진구 완주로55(호성동2가593-4외4필지)3.02007-10-172007-12-15
45파워택태양광발전소전북특별자치도 전주시 완산구 삼천동2가373-295.92008-02-212008-05-06
56㈜내일은해가뜬다전북특별자치도 전주시 덕진구 원동산209번지95.22008-08-122008-09-30
67세종태양광발전소3호기전북특별자치도 전주시 덕진구 팔복동2가797-263층옥상6.82008-12-052008-12-31
78알파태양광발전소전북특별자치도 전주시 덕진구 여의동550-1(여산로122-2,건물상부)48.02009-02-262009-11-23
89경진태양광발전소전북특별자치도 전주시 덕진구 화전동74-628.62009-08-262009-12-14
910팔선태양광발전소전북특별자치도 전주시 덕진구 원동산126-197.022008-12-052010-03-29
연번발전소명설치장소설비용량(kW)허가일사업개시일
689690순수태양광발전소전북특별자치도 전주시 덕진구 용정동189-1(용신길75)49.952021-02-222021-12-21
690691밝은태양광발전소전북특별자치도 전주시 덕진구 전미중앙로185-152.02021-10-262021-12-21
691692우아태양광발전소전북특별자치도 전주시 덕진구 우아동3가746-26(우아2길10)19.112021-08-172021-12-22
692693세일태양광발전소전북특별자치도 전주시 덕진구 여의동530-11(주1)84.242021-10-202021-12-29
693694신한태양광발전소전북특별자치도 전주시 완산구 평화동2가714-1(건물상부)30.522021-12-142021-12-29
694695대홍태양광발전소전북특별자치도 전주시 덕진구 장동유통로2-8(장동900-14)건물상부27.22021-08-172021-12-30
695696민하태양광발전소전북특별자치도 전주시 덕진구 팔복동2가417-11(3동,건물상부)43.682021-11-042022-01-14
696697민규식태양광발전소전북특별자치도 전주시 완산구 중노송동447-119.112021-11-262022-02-03
697698정하태양광발전소전북특별자치도 전주시 덕진구 팔복동2가417-11,팔복동3가223-5(5동,건물상부)87.362021-11-022022-02-17
698699광성태양광발전소전북특별자치도 전주시 완산구 중화산동2가768-1(건물상부)29.762021-11-272022-02-28