Overview

Dataset statistics

Number of variables5
Number of observations1129
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory46.4 KiB
Average record size in memory42.1 B

Variable types

Numeric2
Text2
DateTime1

Dataset

Description충청북도 옥천군 태양광 발전소 설치 현황에 대한 데이터로(발전소명, 설치장소, 설비용량, 최초 허가일자 등)를 제공합니다.
Author충청북도 옥천군
URLhttps://www.data.go.kr/data/15033973/fileData.do

Alerts

연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 19:51:55.765602
Analysis finished2023-12-12 19:51:56.823253
Duration1.06 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct1129
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean565
Minimum1
Maximum1129
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.1 KiB
2023-12-13T04:51:56.926437image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile57.4
Q1283
median565
Q3847
95-th percentile1072.6
Maximum1129
Range1128
Interquartile range (IQR)564

Descriptive statistics

Standard deviation326.05853
Coefficient of variation (CV)0.57709475
Kurtosis-1.2
Mean565
Median Absolute Deviation (MAD)282
Skewness0
Sum637885
Variance106314.17
MonotonicityStrictly increasing
2023-12-13T04:51:57.100450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.1%
751 1
 
0.1%
757 1
 
0.1%
756 1
 
0.1%
755 1
 
0.1%
754 1
 
0.1%
753 1
 
0.1%
752 1
 
0.1%
750 1
 
0.1%
759 1
 
0.1%
Other values (1119) 1119
99.1%
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 (%)
1129 1
0.1%
1128 1
0.1%
1127 1
0.1%
1126 1
0.1%
1125 1
0.1%
1124 1
0.1%
1123 1
0.1%
1122 1
0.1%
1121 1
0.1%
1120 1
0.1%

발전소명
Text

Distinct1085
Distinct (%)96.1%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
2023-12-13T04:51:57.328928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length21
Mean length10.472985
Min length2

Characters and Unicode

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

Unique

Unique1046 ?
Unique (%)92.6%

Sample

1st row태식 태양광발전소
2nd row대성 태양광발전소
3rd row금순 태양광발전소
4th row현정 태양광발전소
5th row영호 태양광발전소
ValueCountFrequency (%)
태양광발전소 948
40.3%
발전소 45
 
1.9%
2호 30
 
1.3%
태양광 20
 
0.9%
3호 18
 
0.8%
1호 16
 
0.7%
한국에너지 16
 
0.7%
도덕 13
 
0.6%
충북태양광 12
 
0.5%
의지리 11
 
0.5%
Other values (1012) 1221
52.0%
2023-12-13T04:51:57.747943image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1224
 
10.4%
전 1058
 
8.9%
광 1057
 
8.9%
태 1056
 
8.9%
발 1053
 
8.9%
소 1050
 
8.9%
양 1037
 
8.8%
호 496
 
4.2%
1 210
 
1.8%
2 173
 
1.5%
Other values (353) 3410
28.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9885
83.6%
Space Separator 1224
 
10.4%
Decimal Number 622
 
5.3%
Uppercase Letter 42
 
0.4%
Dash Punctuation 22
 
0.2%
Close Punctuation 11
 
0.1%
Open Punctuation 11
 
0.1%
Other Symbol 6
 
0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 1058
 
10.7%
광 1057
 
10.7%
태 1056
 
10.7%
발 1053
 
10.7%
소 1050
 
10.6%
양 1037
 
10.5%
호 496
 
5.0%
지 118
 
1.2%
에 100
 
1.0%
이 79
 
0.8%
Other values (320) 2781
28.1%
Uppercase Letter
ValueCountFrequency (%)
S 7
16.7%
K 5
11.9%
J 5
11.9%
C 5
11.9%
Y 2
 
4.8%
D 2
 
4.8%
B 2
 
4.8%
E 2
 
4.8%
M 2
 
4.8%
G 2
 
4.8%
Other values (7) 8
19.0%
Decimal Number
ValueCountFrequency (%)
1 210
33.8%
2 173
27.8%
3 84
 
13.5%
4 48
 
7.7%
5 27
 
4.3%
6 20
 
3.2%
0 18
 
2.9%
7 18
 
2.9%
8 15
 
2.4%
9 9
 
1.4%
Space Separator
ValueCountFrequency (%)
1224
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 11
100.0%
Open Punctuation
ValueCountFrequency (%)
( 11
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 6
100.0%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9891
83.7%
Common 1890
 
16.0%
Latin 43
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 1058
 
10.7%
광 1057
 
10.7%
태 1056
 
10.7%
발 1053
 
10.6%
소 1050
 
10.6%
양 1037
 
10.5%
호 496
 
5.0%
지 118
 
1.2%
에 100
 
1.0%
이 79
 
0.8%
Other values (321) 2787
28.2%
Latin
ValueCountFrequency (%)
S 7
16.3%
K 5
11.6%
J 5
11.6%
C 5
11.6%
Y 2
 
4.7%
D 2
 
4.7%
B 2
 
4.7%
E 2
 
4.7%
M 2
 
4.7%
G 2
 
4.7%
Other values (8) 9
20.9%
Common
ValueCountFrequency (%)
1224
64.8%
1 210
 
11.1%
2 173
 
9.2%
3 84
 
4.4%
4 48
 
2.5%
5 27
 
1.4%
- 22
 
1.2%
6 20
 
1.1%
0 18
 
1.0%
7 18
 
1.0%
Other values (4) 46
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9884
83.6%
ASCII 1932
 
16.3%
None 6
 
0.1%
Compat Jamo 1
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1224
63.4%
1 210
 
10.9%
2 173
 
9.0%
3 84
 
4.3%
4 48
 
2.5%
5 27
 
1.4%
- 22
 
1.1%
6 20
 
1.0%
0 18
 
0.9%
7 18
 
0.9%
Other values (21) 88
 
4.6%
Hangul
ValueCountFrequency (%)
전 1058
 
10.7%
광 1057
 
10.7%
태 1056
 
10.7%
발 1053
 
10.7%
소 1050
 
10.6%
양 1037
 
10.5%
호 496
 
5.0%
지 118
 
1.2%
에 100
 
1.0%
이 79
 
0.8%
Other values (319) 2780
28.1%
None
ValueCountFrequency (%)
㈜ 6
100.0%
Compat Jamo
ValueCountFrequency (%)
ㅅ 1
100.0%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
100.0%

설치장소
Text

Distinct840
Distinct (%)74.4%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
2023-12-13T04:51:58.134140image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length60
Median length44
Mean length23.400354
Min length14

Characters and Unicode

Total characters26419
Distinct characters149
Distinct categories8 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique677 ?
Unique (%)60.0%

Sample

1st row충북 옥천군 이원면 강청리 92-2(건물위)
2nd row충북 옥천군 군북면 이백리 346-12(건물위)
3rd row충북 옥천군 옥천읍 수북리 196, 196-1
4th row충북 옥천군 옥천읍 수북리 196, 196-1
5th row충북 옥천군 안남면 도농리 62, 63(건물위)
ValueCountFrequency (%)
옥천군 1127
19.0%
충북 878
 
14.8%
동이면 249
 
4.2%
청산면 235
 
4.0%
옥천읍 198
 
3.3%
안내면 113
 
1.9%
이원면 111
 
1.9%
청성면 83
 
1.4%
군북면 66
 
1.1%
안남면 57
 
1.0%
Other values (1155) 2801
47.3%
2023-12-13T04:51:58.643942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4795
 
18.1%
천 1351
 
5.1%
옥 1340
 
5.1%
군 1211
 
4.6%
1 1086
 
4.1%
리 1056
 
4.0%
북 953
 
3.6%
면 932
 
3.5%
충 881
 
3.3%
- 771
 
2.9%
Other values (139) 12043
45.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 13885
52.6%
Decimal Number 5383
 
20.4%
Space Separator 4795
 
18.1%
Dash Punctuation 771
 
2.9%
Open Punctuation 565
 
2.1%
Close Punctuation 565
 
2.1%
Other Punctuation 454
 
1.7%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 1351
 
9.7%
옥 1340
 
9.7%
군 1211
 
8.7%
리 1056
 
7.6%
북 953
 
6.9%
면 932
 
6.7%
충 881
 
6.3%
위 547
 
3.9%
산 521
 
3.8%
건 478
 
3.4%
Other values (122) 4615
33.2%
Decimal Number
ValueCountFrequency (%)
1 1086
20.2%
2 679
12.6%
3 662
12.3%
5 581
10.8%
7 496
9.2%
6 474
8.8%
4 466
8.7%
8 329
 
6.1%
9 320
 
5.9%
0 290
 
5.4%
Other Punctuation
ValueCountFrequency (%)
, 452
99.6%
: 2
 
0.4%
Space Separator
ValueCountFrequency (%)
4795
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 771
100.0%
Open Punctuation
ValueCountFrequency (%)
( 565
100.0%
Close Punctuation
ValueCountFrequency (%)
) 565
100.0%
Math Symbol
ValueCountFrequency (%)
+ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 13885
52.6%
Common 12534
47.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 1351
 
9.7%
옥 1340
 
9.7%
군 1211
 
8.7%
리 1056
 
7.6%
북 953
 
6.9%
면 932
 
6.7%
충 881
 
6.3%
위 547
 
3.9%
산 521
 
3.8%
건 478
 
3.4%
Other values (122) 4615
33.2%
Common
ValueCountFrequency (%)
4795
38.3%
1 1086
 
8.7%
- 771
 
6.2%
2 679
 
5.4%
3 662
 
5.3%
5 581
 
4.6%
( 565
 
4.5%
) 565
 
4.5%
7 496
 
4.0%
6 474
 
3.8%
Other values (7) 1860
 
14.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 13885
52.6%
ASCII 12534
47.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4795
38.3%
1 1086
 
8.7%
- 771
 
6.2%
2 679
 
5.4%
3 662
 
5.3%
5 581
 
4.6%
( 565
 
4.5%
) 565
 
4.5%
7 496
 
4.0%
6 474
 
3.8%
Other values (7) 1860
 
14.8%
Hangul
ValueCountFrequency (%)
천 1351
 
9.7%
옥 1340
 
9.7%
군 1211
 
8.7%
리 1056
 
7.6%
북 953
 
6.9%
면 932
 
6.7%
충 881
 
6.3%
위 547
 
3.9%
산 521
 
3.8%
건 478
 
3.4%
Other values (122) 4615
33.2%

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

Distinct342
Distinct (%)30.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean126.81271
Minimum4.8
Maximum1000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size10.1 KiB
2023-12-13T04:51:58.808463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum4.8
5-th percentile19.8
Q195.28
median99
Q399.84
95-th percentile438
Maximum1000
Range995.2
Interquartile range (IQR)4.56

Descriptive statistics

Standard deviation142.03801
Coefficient of variation (CV)1.1200613
Kurtosis19.13646
Mean126.81271
Median Absolute Deviation (MAD)0.94
Skewness4.0344192
Sum143171.56
Variance20174.797
MonotonicityNot monotonic
2023-12-13T04:51:58.980097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 117
 
10.4%
99.9 58
 
5.1%
99.6 49
 
4.3%
97.92 33
 
2.9%
99.36 31
 
2.7%
99.45 28
 
2.5%
99.4 27
 
2.4%
99.84 27
 
2.4%
99.96 26
 
2.3%
99.2 24
 
2.1%
Other values (332) 709
62.8%
ValueCountFrequency (%)
4.8 1
 
0.1%
7.2 1
 
0.1%
9.3 3
0.3%
9.6 1
 
0.1%
10.0 3
0.3%
10.2 1
 
0.1%
11.7 1
 
0.1%
12.0 2
0.2%
12.24 1
 
0.1%
12.96 1
 
0.1%
ValueCountFrequency (%)
1000.0 3
0.3%
999.81 2
0.2%
999.63 1
 
0.1%
998.64 1
 
0.1%
997.92 1
 
0.1%
996.0 1
 
0.1%
994.95 2
0.2%
994.5 1
 
0.1%
992.25 2
0.2%
985.5 1
 
0.1%

허가일자
Date

Distinct367
Distinct (%)32.5%
Missing0
Missing (%)0.0%
Memory size8.9 KiB
Minimum2003-07-16 00:00:00
Maximum2021-03-31 00:00:00
2023-12-13T04:51:59.163008image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:51:59.336083image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-13T04:51:56.409079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:51:56.156206image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:51:56.526911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T04:51:56.279336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T04:51:59.452734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)
연번1.0000.547
설비용량(kW)0.5471.000
2023-12-13T04:51:59.612009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)
연번1.0000.005
설비용량(kW)0.0051.000

Missing values

2023-12-13T04:51:56.680485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T04:51:56.778525image/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태식 태양광발전소충북 옥천군 이원면 강청리 92-2(건물위)99.192021-03-31
12대성 태양광발전소충북 옥천군 군북면 이백리 346-12(건물위)57.22021-03-31
23금순 태양광발전소충북 옥천군 옥천읍 수북리 196, 196-176.442021-03-30
34현정 태양광발전소충북 옥천군 옥천읍 수북리 196, 196-176.442021-03-30
45영호 태양광발전소충북 옥천군 안남면 도농리 62, 63(건물위)99.02021-03-30
56명지 태양광발전소 1호기충북 옥천군 청산면 만월리 269(건물위)99.452021-03-30
67현재 태양광발전소충북 옥천군 동이면 세산리 304(건물위)43.682021-03-30
78백산 태양광발전소충북 옥천군 옥천읍 매화리 55-6, 57(건물위)364.322021-02-24
89동이3호 태양광발전소충북 옥천군 동이면 남곡리 산2399.192021-01-29
910동이2호 태양광발전소충북 옥천군 동이면 남곡리 산2399.192021-01-29
연번발전소명설치장소설비용량(kW)허가일자
11191120해윤2호 태양광발전소옥천군 옥천읍 동안리 130-2396.02019-02-13
11201121해윤3호 태양광발전소옥천군 옥천읍 동안리 130-2396.02019-02-13
11211122영규 태양광발전소옥천군 동이면 지양리 1031198.92019-02-20
11221123수호태양광발전소옥천군 군북면 증약리 602164.252019-02-14
11231124다승에너지 태양광발전소옥천군 안남면 종미리 237, 237-2, 237-3498.962019-02-28
11241125지영농장 태양광발전소옥천군 옥천읍 삼청리 366-7(건물위)299.62019-03-06
11251126귀죽 태양광발전소 4호옥천읍 구일리 864(건물위)170.942019-03-06
11261127하서리 쏠라1호옥천군 청산면 하서리 258-1, 258-2, 267, 268-1(건물위)267.542019-03-12
11271128상민 태양광발전소충북 옥천군 동이면 금암6길 143(건물위)20.02013-12-24
11281129평산 태양광발전소충북 옥천군 청성면 도장리 439-199.02014-03-12