Overview

Dataset statistics

Number of variables6
Number of observations527
Missing cells118
Missing cells (%)3.7%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory25.9 KiB
Average record size in memory50.3 B

Variable types

Numeric2
Text2
DateTime2

Dataset

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

Alerts

완공일 개시일 has 118 (22.4%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2024-03-14 00:19:42.246617
Analysis finished2024-03-14 00:19:42.972789
Duration0.73 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct527
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean264
Minimum1
Maximum527
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.8 KiB
2024-03-14T09:19:43.029022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile27.3
Q1132.5
median264
Q3395.5
95-th percentile500.7
Maximum527
Range526
Interquartile range (IQR)263

Descriptive statistics

Standard deviation152.27607
Coefficient of variation (CV)0.57680328
Kurtosis-1.2
Mean264
Median Absolute Deviation (MAD)132
Skewness0
Sum139128
Variance23188
MonotonicityStrictly increasing
2024-03-14T09:19:43.133592image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
348 1
 
0.2%
362 1
 
0.2%
361 1
 
0.2%
360 1
 
0.2%
359 1
 
0.2%
358 1
 
0.2%
357 1
 
0.2%
356 1
 
0.2%
355 1
 
0.2%
Other values (517) 517
98.1%
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 (%)
527 1
0.2%
526 1
0.2%
525 1
0.2%
524 1
0.2%
523 1
0.2%
522 1
0.2%
521 1
0.2%
520 1
0.2%
519 1
0.2%
518 1
0.2%

법인명 발전소명
Text

Distinct510
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2024-03-14T09:19:43.422892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length21
Mean length9.1631879
Min length4

Characters and Unicode

Total characters4829
Distinct characters325
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

Unique494 ?
Unique (%)93.7%

Sample

1st row세종 태양광전력
2nd row인후태양광발전소
3rd row우아태양광발전소
4th row주유소 태양광
5th row파워택태양광발전소
ValueCountFrequency (%)
태양광발전소 109
 
16.5%
태양광 5
 
0.8%
성덕태양광발전소 3
 
0.5%
서광태양광발전소 2
 
0.3%
유한회사 2
 
0.3%
에너지 2
 
0.3%
주식회사 2
 
0.3%
bs 2
 
0.3%
solar 2
 
0.3%
평화태양광발전소 2
 
0.3%
Other values (514) 530
80.2%
2024-03-14T09:19:43.778179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
태 496
 
10.3%
광 496
 
10.3%
양 484
 
10.0%
전 477
 
9.9%
소 454
 
9.4%
발 451
 
9.3%
호 140
 
2.9%
136
 
2.8%
1 71
 
1.5%
2 51
 
1.1%
Other values (315) 1573
32.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4424
91.6%
Decimal Number 165
 
3.4%
Space Separator 136
 
2.8%
Uppercase Letter 49
 
1.0%
Close Punctuation 20
 
0.4%
Open Punctuation 20
 
0.4%
Other Symbol 13
 
0.3%
Other Punctuation 1
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
태 496
 
11.2%
광 496
 
11.2%
양 484
 
10.9%
전 477
 
10.8%
소 454
 
10.3%
발 451
 
10.2%
호 140
 
3.2%
성 44
 
1.0%
에 41
 
0.9%
지 39
 
0.9%
Other values (281) 1302
29.4%
Uppercase Letter
ValueCountFrequency (%)
S 8
16.3%
J 7
14.3%
Y 4
 
8.2%
O 3
 
6.1%
B 3
 
6.1%
D 3
 
6.1%
M 2
 
4.1%
K 2
 
4.1%
P 2
 
4.1%
I 2
 
4.1%
Other values (9) 13
26.5%
Decimal Number
ValueCountFrequency (%)
1 71
43.0%
2 51
30.9%
3 22
 
13.3%
4 12
 
7.3%
5 4
 
2.4%
6 2
 
1.2%
0 1
 
0.6%
8 1
 
0.6%
7 1
 
0.6%
Space Separator
ValueCountFrequency (%)
136
100.0%
Close Punctuation
ValueCountFrequency (%)
) 20
100.0%
Open Punctuation
ValueCountFrequency (%)
( 20
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 13
100.0%
Other Punctuation
ValueCountFrequency (%)
. 1
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4437
91.9%
Common 343
 
7.1%
Latin 49
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
태 496
 
11.2%
광 496
 
11.2%
양 484
 
10.9%
전 477
 
10.8%
소 454
 
10.2%
발 451
 
10.2%
호 140
 
3.2%
성 44
 
1.0%
에 41
 
0.9%
지 39
 
0.9%
Other values (282) 1315
29.6%
Latin
ValueCountFrequency (%)
S 8
16.3%
J 7
14.3%
Y 4
 
8.2%
O 3
 
6.1%
B 3
 
6.1%
D 3
 
6.1%
M 2
 
4.1%
K 2
 
4.1%
P 2
 
4.1%
I 2
 
4.1%
Other values (9) 13
26.5%
Common
ValueCountFrequency (%)
136
39.7%
1 71
20.7%
2 51
 
14.9%
3 22
 
6.4%
) 20
 
5.8%
( 20
 
5.8%
4 12
 
3.5%
5 4
 
1.2%
6 2
 
0.6%
. 1
 
0.3%
Other values (4) 4
 
1.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4424
91.6%
ASCII 392
 
8.1%
None 13
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
태 496
 
11.2%
광 496
 
11.2%
양 484
 
10.9%
전 477
 
10.8%
소 454
 
10.3%
발 451
 
10.2%
호 140
 
3.2%
성 44
 
1.0%
에 41
 
0.9%
지 39
 
0.9%
Other values (281) 1302
29.4%
ASCII
ValueCountFrequency (%)
136
34.7%
1 71
18.1%
2 51
 
13.0%
3 22
 
5.6%
) 20
 
5.1%
( 20
 
5.1%
4 12
 
3.1%
S 8
 
2.0%
J 7
 
1.8%
Y 4
 
1.0%
Other values (23) 41
 
10.5%
None
ValueCountFrequency (%)
㈜ 13
100.0%

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

Distinct191
Distinct (%)36.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean59.246486
Minimum3
Maximum99.96
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.8 KiB
2024-03-14T09:19:43.907822image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile15.0225
Q124.8
median50
Q399
95-th percentile99.45
Maximum99.96
Range96.96
Interquartile range (IQR)74.2

Descriptive statistics

Standard deviation34.528762
Coefficient of variation (CV)0.58279848
Kurtosis-1.6991877
Mean59.246486
Median Absolute Deviation (MAD)30.56
Skewness0.035115913
Sum31222.898
Variance1192.2354
MonotonicityNot monotonic
2024-03-14T09:19:44.058475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 60
 
11.4%
20.0 41
 
7.8%
99.45 27
 
5.1%
30.0 26
 
4.9%
50.0 23
 
4.4%
99.2 10
 
1.9%
99.36 10
 
1.9%
99.4 10
 
1.9%
49.5 9
 
1.7%
99.9 8
 
1.5%
Other values (181) 303
57.5%
ValueCountFrequency (%)
3.0 2
 
0.4%
3.2 1
 
0.2%
4.8 1
 
0.2%
6.8 1
 
0.2%
7.5 1
 
0.2%
8.0 1
 
0.2%
9.0 1
 
0.2%
9.9 1
 
0.2%
10.0 6
1.1%
10.4 1
 
0.2%
ValueCountFrequency (%)
99.96 2
 
0.4%
99.9 8
 
1.5%
99.84 2
 
0.4%
99.75 6
 
1.1%
99.72 1
 
0.2%
99.645 1
 
0.2%
99.47 2
 
0.4%
99.45 27
5.1%
99.4 10
 
1.9%
99.36 10
 
1.9%

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

Distinct488
Distinct (%)92.6%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2024-03-14T09:19:44.377293image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length76
Median length49
Mean length26.994307
Min length18

Characters and Unicode

Total characters14226
Distinct characters170
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

Unique458 ?
Unique (%)86.9%

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 (%)
전라북도 527
18.5%
전주시 527
18.5%
덕진구 399
 
14.0%
완산구 128
 
4.5%
성덕동 41
 
1.4%
남정동 32
 
1.1%
금상동 24
 
0.8%
화전동 21
 
0.7%
2가 17
 
0.6%
반월동 16
 
0.6%
Other values (803) 1121
39.3%
2024-03-14T09:19:44.810591image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2462
 
17.3%
전 1107
 
7.8%
1 697
 
4.9%
- 567
 
4.0%
주 542
 
3.8%
북 540
 
3.8%
도 533
 
3.7%
구 533
 
3.7%
시 527
 
3.7%
라 527
 
3.7%
Other values (160) 6191
43.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7641
53.7%
Decimal Number 3155
22.2%
Space Separator 2462
 
17.3%
Dash Punctuation 567
 
4.0%
Other Punctuation 144
 
1.0%
Open Punctuation 129
 
0.9%
Close Punctuation 127
 
0.9%
Other Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 1107
14.5%
주 542
 
7.1%
북 540
 
7.1%
도 533
 
7.0%
구 533
 
7.0%
시 527
 
6.9%
라 527
 
6.9%
동 488
 
6.4%
덕 464
 
6.1%
진 417
 
5.5%
Other values (144) 1963
25.7%
Decimal Number
ValueCountFrequency (%)
1 697
22.1%
2 502
15.9%
3 335
10.6%
4 287
9.1%
5 259
 
8.2%
6 257
 
8.1%
7 245
 
7.8%
8 195
 
6.2%
9 194
 
6.1%
0 184
 
5.8%
Space Separator
ValueCountFrequency (%)
2462
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 567
100.0%
Other Punctuation
ValueCountFrequency (%)
, 144
100.0%
Open Punctuation
ValueCountFrequency (%)
( 129
100.0%
Close Punctuation
ValueCountFrequency (%)
) 127
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7642
53.7%
Common 6584
46.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 1107
14.5%
주 542
 
7.1%
북 540
 
7.1%
도 533
 
7.0%
구 533
 
7.0%
시 527
 
6.9%
라 527
 
6.9%
동 488
 
6.4%
덕 464
 
6.1%
진 417
 
5.5%
Other values (145) 1964
25.7%
Common
ValueCountFrequency (%)
2462
37.4%
1 697
 
10.6%
- 567
 
8.6%
2 502
 
7.6%
3 335
 
5.1%
4 287
 
4.4%
5 259
 
3.9%
6 257
 
3.9%
7 245
 
3.7%
8 195
 
3.0%
Other values (5) 778
 
11.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7641
53.7%
ASCII 6584
46.3%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2462
37.4%
1 697
 
10.6%
- 567
 
8.6%
2 502
 
7.6%
3 335
 
5.1%
4 287
 
4.4%
5 259
 
3.9%
6 257
 
3.9%
7 245
 
3.7%
8 195
 
3.0%
Other values (5) 778
 
11.8%
Hangul
ValueCountFrequency (%)
전 1107
14.5%
주 542
 
7.1%
북 540
 
7.1%
도 533
 
7.0%
구 533
 
7.0%
시 527
 
6.9%
라 527
 
6.9%
동 488
 
6.4%
덕 464
 
6.1%
진 417
 
5.5%
Other values (144) 1963
25.7%
None
ValueCountFrequency (%)
㈜ 1
100.0%

최초허가일
Date

Distinct255
Distinct (%)48.4%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
Minimum2006-09-14 00:00:00
Maximum2018-10-30 00:00:00
2024-03-14T09:19:44.926411image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T09:19:45.255043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

완공일 개시일
Date

MISSING 

Distinct269
Distinct (%)65.8%
Missing118
Missing (%)22.4%
Memory size4.2 KiB
Minimum2007-06-27 00:00:00
Maximum2018-11-02 00:00:00
2024-03-14T09:19:45.380264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T09:19:45.510190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-03-14T09:19:42.691122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T09:19:42.527789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T09:19:42.759656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-14T09:19:42.610785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-14T09:19:45.613758image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비허가 용량(kW)
연번1.0000.300
설비허가 용량(kW)0.3001.000
2024-03-14T09:19:45.687496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비허가 용량(kW)
연번1.0000.249
설비허가 용량(kW)0.2491.000

Missing values

2024-03-14T09:19:42.845974image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-14T09:19:42.937231image/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-262006-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.904전라북도 전주시 완산구 삼천동 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)발전소주소(설치장소)최초허가일완공일 개시일
517518빠른태양광발전소99.33전라북도 전주시 덕진구 남정동 2492018-10-01<NA>
518519으뜸태양광발전소99.33전라북도 전주시 덕진구 남정동 2492018-10-01<NA>
519520믿음태양광발전소99.33전라북도 전주시 덕진구 남정동 2492018-10-01<NA>
520521더존1태양광발전소99.33전라북도 전주시 덕진구 남정동 345-12018-10-01<NA>
521522하늘공장태양광발전소1호99.72전라북도 전주시 덕진구 우아동1가 5642018-10-08<NA>
522523아이숲태양광발전소51.0전라북도 전주시 덕진구 고랑동 332-12018-10-08<NA>
523524서광태양광발전소20.0전라북도 전주시 완산구 서신로 482014-01-07<NA>
524525규범태양광발전소19.8전라북도 전주시 덕진구 우아동3가 744-762018-10-30<NA>
525526영주태양광발전소24.8전라북도 전주시 덕진구 우아동3가 752-232018-10-30<NA>
526527호성교회태양광발전소29.64전라북도 전주시 덕진구 호성동3가 41-1, 43, 198-52018-10-30<NA>