Overview

Dataset statistics

Number of variables5
Number of observations2823
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory115.9 KiB
Average record size in memory42.0 B

Variable types

Numeric2
Text2
DateTime1

Dataset

Description전라북도 임실군 신재생에너지(태양광 전기사업) 발전허가 현황 데이터 입니다. 데이터 내용에는 순번, 발전소명, 발전소 주소, 설비용량, 발전사업 허가일이 포함되어 있습니다.
URLhttps://www.data.go.kr/data/15069183/fileData.do

Alerts

순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 08:31:17.617591
Analysis finished2023-12-12 08:31:18.534527
Duration0.92 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

UNIQUE 

Distinct2823
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1412
Minimum1
Maximum2823
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size24.9 KiB
2023-12-12T17:31:18.613018image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile142.1
Q1706.5
median1412
Q32117.5
95-th percentile2681.9
Maximum2823
Range2822
Interquartile range (IQR)1411

Descriptive statistics

Standard deviation815.07423
Coefficient of variation (CV)0.57724804
Kurtosis-1.2
Mean1412
Median Absolute Deviation (MAD)706
Skewness0
Sum3986076
Variance664346
MonotonicityStrictly increasing
2023-12-12T17:31:18.740420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1942 1
 
< 0.1%
1878 1
 
< 0.1%
1879 1
 
< 0.1%
1880 1
 
< 0.1%
1881 1
 
< 0.1%
1882 1
 
< 0.1%
1883 1
 
< 0.1%
1884 1
 
< 0.1%
1885 1
 
< 0.1%
Other values (2813) 2813
99.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 (%)
2823 1
< 0.1%
2822 1
< 0.1%
2821 1
< 0.1%
2820 1
< 0.1%
2819 1
< 0.1%
2818 1
< 0.1%
2817 1
< 0.1%
2816 1
< 0.1%
2815 1
< 0.1%
2814 1
< 0.1%

발전소명
Text

Distinct2515
Distinct (%)89.1%
Missing0
Missing (%)0.0%
Memory size22.2 KiB
2023-12-12T17:31:18.991861image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length34
Median length29
Mean length9.5529578
Min length4

Characters and Unicode

Total characters26968
Distinct characters439
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

Unique2285 ?
Unique (%)80.9%

Sample

1st row지암2호태양광발전소
2nd row신촌2호태양광발전소
3rd row스타텍태양광발전소
4th row혜영태양광발전소
5th row영일태양광발전소
ValueCountFrequency (%)
상월에너지스테이션 33
 
1.1%
태양광발전소 16
 
0.6%
행복태양광발전소 7
 
0.2%
믿음태양광발전소 5
 
0.2%
호암태양광발전소 5
 
0.2%
삼계1호태양광발전소 5
 
0.2%
소망태양광발전소 5
 
0.2%
청웅태양광발전소 5
 
0.2%
에너지 5
 
0.2%
희망태양광발전소 5
 
0.2%
Other values (2515) 2804
96.9%
2023-12-12T17:31:19.706844image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 2658
 
9.9%
전 2635
 
9.8%
태 2612
 
9.7%
양 2611
 
9.7%
소 2608
 
9.7%
발 2596
 
9.6%
호 1233
 
4.6%
2 439
 
1.6%
1 438
 
1.6%
지 428
 
1.6%
Other values (429) 8710
32.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 24901
92.3%
Decimal Number 1458
 
5.4%
Uppercase Letter 166
 
0.6%
Close Punctuation 147
 
0.5%
Open Punctuation 147
 
0.5%
Space Separator 72
 
0.3%
Dash Punctuation 34
 
0.1%
Other Symbol 24
 
0.1%
Lowercase Letter 17
 
0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 2658
 
10.7%
전 2635
 
10.6%
태 2612
 
10.5%
양 2611
 
10.5%
소 2608
 
10.5%
발 2596
 
10.4%
호 1233
 
5.0%
지 428
 
1.7%
에 348
 
1.4%
너 315
 
1.3%
Other values (379) 6857
27.5%
Uppercase Letter
ValueCountFrequency (%)
B 32
19.3%
S 30
18.1%
K 10
 
6.0%
A 9
 
5.4%
J 9
 
5.4%
Y 9
 
5.4%
H 9
 
5.4%
D 9
 
5.4%
E 7
 
4.2%
N 6
 
3.6%
Other values (12) 36
21.7%
Lowercase Letter
ValueCountFrequency (%)
o 3
17.6%
r 3
17.6%
s 2
11.8%
c 1
 
5.9%
e 1
 
5.9%
w 1
 
5.9%
p 1
 
5.9%
j 1
 
5.9%
d 1
 
5.9%
i 1
 
5.9%
Other values (2) 2
11.8%
Decimal Number
ValueCountFrequency (%)
2 439
30.1%
1 438
30.0%
3 209
14.3%
4 104
 
7.1%
5 88
 
6.0%
6 57
 
3.9%
7 40
 
2.7%
8 35
 
2.4%
9 27
 
1.9%
0 21
 
1.4%
Close Punctuation
ValueCountFrequency (%)
) 147
100.0%
Open Punctuation
ValueCountFrequency (%)
( 147
100.0%
Space Separator
ValueCountFrequency (%)
72
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 34
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 24
100.0%
Other Punctuation
ValueCountFrequency (%)
& 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 24925
92.4%
Common 1860
 
6.9%
Latin 183
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 2658
 
10.7%
전 2635
 
10.6%
태 2612
 
10.5%
양 2611
 
10.5%
소 2608
 
10.5%
발 2596
 
10.4%
호 1233
 
4.9%
지 428
 
1.7%
에 348
 
1.4%
너 315
 
1.3%
Other values (380) 6881
27.6%
Latin
ValueCountFrequency (%)
B 32
17.5%
S 30
16.4%
K 10
 
5.5%
A 9
 
4.9%
J 9
 
4.9%
Y 9
 
4.9%
H 9
 
4.9%
D 9
 
4.9%
E 7
 
3.8%
N 6
 
3.3%
Other values (24) 53
29.0%
Common
ValueCountFrequency (%)
2 439
23.6%
1 438
23.5%
3 209
11.2%
) 147
 
7.9%
( 147
 
7.9%
4 104
 
5.6%
5 88
 
4.7%
72
 
3.9%
6 57
 
3.1%
7 40
 
2.2%
Other values (5) 119
 
6.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 24901
92.3%
ASCII 2043
 
7.6%
None 24
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 2658
 
10.7%
전 2635
 
10.6%
태 2612
 
10.5%
양 2611
 
10.5%
소 2608
 
10.5%
발 2596
 
10.4%
호 1233
 
5.0%
지 428
 
1.7%
에 348
 
1.4%
너 315
 
1.3%
Other values (379) 6857
27.5%
ASCII
ValueCountFrequency (%)
2 439
21.5%
1 438
21.4%
3 209
10.2%
) 147
 
7.2%
( 147
 
7.2%
4 104
 
5.1%
5 88
 
4.3%
72
 
3.5%
6 57
 
2.8%
7 40
 
2.0%
Other values (39) 302
14.8%
None
ValueCountFrequency (%)
㈜ 24
100.0%

발전소 주소
Text

Distinct2222
Distinct (%)78.7%
Missing0
Missing (%)0.0%
Memory size22.2 KiB
2023-12-12T17:31:20.272203image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length83
Median length77
Mean length24.507262
Min length18

Characters and Unicode

Total characters69184
Distinct characters175
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

Unique1920 ?
Unique (%)68.0%

Sample

1st row전라북도 임실군 지사면 안하리 736번지 4호
2nd row전라북도 임실군 성수면 월평리 531
3rd row전라북도 임실군 청웅면 두복리 313-1
4th row전라북도 임실군 신덕면 삼길리 722-3
5th row전라북도 임실군 덕치면 일중리 518-3 (건물상부)
ValueCountFrequency (%)
전라북도 2819
 
17.2%
임실군 2816
 
17.2%
관촌면 519
 
3.2%
임실읍 413
 
2.5%
산 382
 
2.3%
삼계면 311
 
1.9%
1호 300
 
1.8%
오수면 294
 
1.8%
지사면 247
 
1.5%
211
 
1.3%
Other values (2015) 8050
49.2%
2023-12-12T17:31:20.953751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13539
19.6%
임 3241
 
4.7%
실 3231
 
4.7%
전 2987
 
4.3%
도 2923
 
4.2%
군 2828
 
4.1%
라 2822
 
4.1%
북 2820
 
4.1%
리 2537
 
3.7%
면 2409
 
3.5%
Other values (165) 29847
43.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 42213
61.0%
Space Separator 13539
 
19.6%
Decimal Number 11784
 
17.0%
Dash Punctuation 1020
 
1.5%
Other Punctuation 460
 
0.7%
Close Punctuation 80
 
0.1%
Open Punctuation 80
 
0.1%
Uppercase Letter 4
 
< 0.1%
Modifier Symbol 3
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
임 3241
 
7.7%
실 3231
 
7.7%
전 2987
 
7.1%
도 2923
 
6.9%
군 2828
 
6.7%
라 2822
 
6.7%
북 2820
 
6.7%
리 2537
 
6.0%
면 2409
 
5.7%
지 2101
 
5.0%
Other values (144) 14314
33.9%
Decimal Number
ValueCountFrequency (%)
1 2220
18.8%
2 1663
14.1%
3 1269
10.8%
5 1135
9.6%
4 1121
9.5%
7 1060
9.0%
6 944
8.0%
8 873
 
7.4%
0 766
 
6.5%
9 733
 
6.2%
Uppercase Letter
ValueCountFrequency (%)
R 1
25.0%
M 1
25.0%
T 1
25.0%
B 1
25.0%
Space Separator
ValueCountFrequency (%)
13539
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1020
100.0%
Other Punctuation
ValueCountFrequency (%)
, 460
100.0%
Close Punctuation
ValueCountFrequency (%)
) 80
100.0%
Open Punctuation
ValueCountFrequency (%)
( 80
100.0%
Modifier Symbol
ValueCountFrequency (%)
` 3
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 42213
61.0%
Common 26967
39.0%
Latin 4
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
임 3241
 
7.7%
실 3231
 
7.7%
전 2987
 
7.1%
도 2923
 
6.9%
군 2828
 
6.7%
라 2822
 
6.7%
북 2820
 
6.7%
리 2537
 
6.0%
면 2409
 
5.7%
지 2101
 
5.0%
Other values (144) 14314
33.9%
Common
ValueCountFrequency (%)
13539
50.2%
1 2220
 
8.2%
2 1663
 
6.2%
3 1269
 
4.7%
5 1135
 
4.2%
4 1121
 
4.2%
7 1060
 
3.9%
- 1020
 
3.8%
6 944
 
3.5%
8 873
 
3.2%
Other values (7) 2123
 
7.9%
Latin
ValueCountFrequency (%)
R 1
25.0%
M 1
25.0%
T 1
25.0%
B 1
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 42210
61.0%
ASCII 26971
39.0%
Compat Jamo 3
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13539
50.2%
1 2220
 
8.2%
2 1663
 
6.2%
3 1269
 
4.7%
5 1135
 
4.2%
4 1121
 
4.2%
7 1060
 
3.9%
- 1020
 
3.8%
6 944
 
3.5%
8 873
 
3.2%
Other values (11) 2127
 
7.9%
Hangul
ValueCountFrequency (%)
임 3241
 
7.7%
실 3231
 
7.7%
전 2987
 
7.1%
도 2923
 
6.9%
군 2828
 
6.7%
라 2822
 
6.7%
북 2820
 
6.7%
리 2537
 
6.0%
면 2409
 
5.7%
지 2101
 
5.0%
Other values (142) 14311
33.9%
Compat Jamo
ValueCountFrequency (%)
ㄱ 2
66.7%
ㄴ 1
33.3%

설비용량KW
Real number (ℝ)

Distinct466
Distinct (%)16.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean155.83662
Minimum0
Maximum999.9
Zeros12
Zeros (%)0.4%
Negative0
Negative (%)0.0%
Memory size24.9 KiB
2023-12-12T17:31:21.142613image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile30
Q199
median99.2
Q399.75
95-th percentile499.793
Maximum999.9
Range999.9
Interquartile range (IQR)0.75

Descriptive statistics

Standard deviation191.31513
Coefficient of variation (CV)1.2276648
Kurtosis10.931612
Mean155.83662
Median Absolute Deviation (MAD)0.4
Skewness3.3475862
Sum439926.78
Variance36601.478
MonotonicityNot monotonic
2023-12-12T17:31:21.292241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 687
24.3%
99.2 124
 
4.4%
99.45 118
 
4.2%
99.75 114
 
4.0%
99.36 96
 
3.4%
99.9 94
 
3.3%
99.4 94
 
3.3%
99.28 77
 
2.7%
99.6 69
 
2.4%
99.84 64
 
2.3%
Other values (456) 1286
45.6%
ValueCountFrequency (%)
0.0 12
0.4%
5.88 1
 
< 0.1%
6.0 1
 
< 0.1%
10.0 2
 
0.1%
11.13 1
 
< 0.1%
14.56 1
 
< 0.1%
14.6 1
 
< 0.1%
14.7 1
 
< 0.1%
14.82 1
 
< 0.1%
14.85 2
 
0.1%
ValueCountFrequency (%)
999.9 1
 
< 0.1%
999.68 4
0.1%
999.6 9
0.3%
999.45 3
 
0.1%
999.24 1
 
< 0.1%
999.0 3
 
0.1%
998.4 2
 
0.1%
998.0 1
 
< 0.1%
997.92 3
 
0.1%
997.5 1
 
< 0.1%

허가일자
Date

Distinct599
Distinct (%)21.2%
Missing0
Missing (%)0.0%
Memory size22.2 KiB
Minimum2007-07-23 00:00:00
Maximum2022-09-29 00:00:00
2023-12-12T17:31:21.454740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:31:21.627769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-12T17:31:18.173815image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:31:18.015520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:31:18.263506image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:31:18.094284image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T17:31:21.734863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번설비용량KW
순번1.0000.558
설비용량KW0.5581.000
2023-12-12T17:31:21.847471image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번설비용량KW
순번1.000-0.303
설비용량KW-0.3031.000

Missing values

2023-12-12T17:31:18.413290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:31:18.498692image/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지암2호태양광발전소전라북도 임실군 지사면 안하리 736번지 4호498.752017-06-07
12신촌2호태양광발전소전라북도 임실군 성수면 월평리 53199.62022-09-29
23스타텍태양광발전소전라북도 임실군 청웅면 두복리 313-166.02021-06-07
34혜영태양광발전소전라북도 임실군 신덕면 삼길리 722-399.92021-05-25
45영일태양광발전소전라북도 임실군 덕치면 일중리 518-3 (건물상부)49.02021-05-25
56(주)임실쏠라발전소전라북도 임실군 관촌면 슬치리 산 49 , 64499.842021-05-11
67이인리2호태양광발전소전라북도 임실군 임실읍 이인리 393-1 (건물상부 주1, 주2)99.452021-05-10
78이인리3호태양광발전소전라북도 임실군 임실읍 이인리 393-4 (건물상부 주1, 주3)99.452021-05-10
89이인리4호태양광발전소전라북도 임실군 임실읍 이인리 393-4 (건물상부 주2)90.02021-05-10
910도경1태양광발전소전라북도 임실군 관촌면 신전리 203-599.192021-05-10
순번발전소명발전소 주소설비용량KW허가일자
28132814박사골정보화마을영농조합법인(박사골태양광발전소)전라북도 임실군 삼계면 봉현리 27614.72008-09-05
28142815㈜이마트군산(심병윤태양광발전소)전라북도 임실군 성수면 양지리 720-10.02008-08-28
28152816㈜대원산업(대원산업태양광발전소)전라북도 임실군 삼계면 뇌천리 산 18-10.02008-06-05
28162817(유)관촌에너지(관촌에너지태양광)전라북도 임실군 관촌면 신전리 산 223-1676.22008-05-07
28172818승선태양광발전소전라북도 임실군 삼계면 세심리 605 외1건29.42008-03-31
28182819㈜서해에너지(오수태양광)전라북도 임실군 오수면 금암리 산 34 외2건993.62008-03-07
28192820선진2호태양광발전소전라북도 임실군 삼계면 세심리 608-329.162008-02-27
28202821㈜옥시레킷벤키지(선진태양광발전소)전라북도 임실군 삼계면 세심리 608-1 외1건29.162007-10-29
28212822㈜다우바이오에너지(다우바이오에너지태양광발전소)전라북도 임실군 삼계면 오지리 511 , 외1건193.62007-09-10
28222823㈜참빛에너지(일광동화)전라북도 임실군 지사면 관기리 산 23-10.02007-07-23