Overview

Dataset statistics

Number of variables21
Number of observations869
Missing cells6443
Missing cells (%)35.3%
Duplicate rows5
Duplicate rows (%)0.6%
Total size in memory150.3 KiB
Average record size in memory177.2 B

Variable types

Categorical9
Text4
Numeric1
DateTime1
Unsupported6

Dataset

Description화성시 태양광 발전사업 현황(허가기관, 시군명, 용도, 세부용도, 발전소명, 설치장소, 설비용량 등)
Author경기도 화성시
URLhttps://www.data.go.kr/data/15050008/fileData.do

Alerts

허가기관 has constant value ""Constant
시군명 has constant value ""Constant
용도 has constant value ""Constant
세부용도 has constant value ""Constant
공급전압(V) has constant value ""Constant
주파수(HZ) has constant value ""Constant
데이터기준일 has constant value ""Constant
Dataset has 5 (0.6%) duplicate rowsDuplicates
설치장소 도로명주소 has 802 (92.3%) missing valuesMissing
설치장소 지번주소 has 67 (7.7%) missing valuesMissing
사업개시일 has 360 (41.4%) missing valuesMissing
소요부지면적(㎥) has 869 (100.0%) missing valuesMissing
집광판면적(㎥) has 869 (100.0%) missing valuesMissing
위도 has 869 (100.0%) missing valuesMissing
경도 has 869 (100.0%) missing valuesMissing
지목 has 869 (100.0%) missing valuesMissing
비고 has 869 (100.0%) missing valuesMissing
소요부지면적(㎥) is an unsupported type, check if it needs cleaning or further analysisUnsupported
집광판면적(㎥) is an unsupported type, check if it needs cleaning or further analysisUnsupported
위도 is an unsupported type, check if it needs cleaning or further analysisUnsupported
경도 is an unsupported type, check if it needs cleaning or further analysisUnsupported
지목 is an unsupported type, check if it needs cleaning or further analysisUnsupported
비고 is an unsupported type, check if it needs cleaning or further analysisUnsupported

Reproduction

Analysis started2023-12-12 16:56:55.594330
Analysis finished2023-12-12 16:56:56.136978
Duration0.54 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

허가기관
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
화성시
869 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row화성시
2nd row화성시
3rd row화성시
4th row화성시
5th row화성시

Common Values

ValueCountFrequency (%)
화성시 869
100.0%

Length

2023-12-13T01:56:56.225693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:56:56.344629image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
화성시 869
100.0%

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
화성시
869 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row화성시
2nd row화성시
3rd row화성시
4th row화성시
5th row화성시

Common Values

ValueCountFrequency (%)
화성시 869
100.0%

Length

2023-12-13T01:56:56.471482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:56:56.619484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
화성시 869
100.0%

용도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
전기사업용
869 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전기사업용
2nd row전기사업용
3rd row전기사업용
4th row전기사업용
5th row전기사업용

Common Values

ValueCountFrequency (%)
전기사업용 869
100.0%

Length

2023-12-13T01:56:56.748843image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:56:56.880816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전기사업용 869
100.0%

세부용도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
발전사업용
869 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row발전사업용
2nd row발전사업용
3rd row발전사업용
4th row발전사업용
5th row발전사업용

Common Values

ValueCountFrequency (%)
발전사업용 869
100.0%

Length

2023-12-13T01:56:57.004138image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:56:57.132215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
발전사업용 869
100.0%

사업상태
Categorical

Distinct2
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
운영중
520 
사업허가
349 

Length

Max length4
Median length3
Mean length3.401611
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row운영중
2nd row운영중
3rd row운영중
4th row운영중
5th row운영중

Common Values

ValueCountFrequency (%)
운영중 520
59.8%
사업허가 349
40.2%

Length

2023-12-13T01:56:57.278619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:56:57.379523image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
운영중 520
59.8%
사업허가 349
40.2%

발전소명
Text

Distinct774
Distinct (%)89.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
2023-12-13T01:56:57.688011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length19
Median length18
Mean length9.4303797
Min length3

Characters and Unicode

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

Unique

Unique767 ?
Unique (%)88.3%

Sample

1st row화성 태양광발전소
2nd row동화 태양광발전소
3rd row해강 태양광발전소
4th row디엠에스발안 태양광발전소
5th row화성한과 시민햇빛발전소
ValueCountFrequency (%)
태양광발전소 234
 
21.7%
37
 
3.4%
1호 6
 
0.6%
선망 4
 
0.4%
2호 3
 
0.3%
발전소 3
 
0.3%
화성공장 3
 
0.3%
율암태양광발전소 3
 
0.3%
화성 3
 
0.3%
향남태양광발전소 2
 
0.2%
Other values (774) 782
72.4%
2023-12-13T01:56:58.222345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
전 845
 
10.3%
양 840
 
10.3%
발 838
 
10.2%
소 836
 
10.2%
광 832
 
10.2%
태 829
 
10.1%
* 276
 
3.4%
218
 
2.7%
호 151
 
1.8%
2 91
 
1.1%
Other values (357) 2439
29.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7326
89.4%
Other Punctuation 278
 
3.4%
Decimal Number 240
 
2.9%
Space Separator 218
 
2.7%
Uppercase Letter 75
 
0.9%
Lowercase Letter 27
 
0.3%
Other Symbol 18
 
0.2%
Open Punctuation 5
 
0.1%
Close Punctuation 5
 
0.1%
Letter Number 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 845
11.5%
양 840
11.5%
발 838
11.4%
소 836
11.4%
광 832
11.4%
태 829
11.3%
호 151
 
2.1%
성 76
 
1.0%
이 71
 
1.0%
화 59
 
0.8%
Other values (305) 1949
26.6%
Uppercase Letter
ValueCountFrequency (%)
S 12
16.0%
H 8
10.7%
P 6
 
8.0%
K 6
 
8.0%
D 6
 
8.0%
E 5
 
6.7%
C 5
 
6.7%
Y 4
 
5.3%
B 3
 
4.0%
A 3
 
4.0%
Other values (11) 17
22.7%
Lowercase Letter
ValueCountFrequency (%)
e 4
14.8%
l 3
11.1%
s 3
11.1%
r 3
11.1%
n 3
11.1%
t 2
7.4%
u 2
7.4%
k 2
7.4%
a 2
7.4%
f 1
 
3.7%
Other values (2) 2
7.4%
Decimal Number
ValueCountFrequency (%)
2 91
37.9%
1 90
37.5%
3 29
 
12.1%
4 11
 
4.6%
5 6
 
2.5%
9 3
 
1.2%
8 3
 
1.2%
6 3
 
1.2%
7 2
 
0.8%
0 2
 
0.8%
Other Punctuation
ValueCountFrequency (%)
* 276
99.3%
& 2
 
0.7%
Letter Number
ValueCountFrequency (%)
Ⅰ 1
50.0%
Ⅱ 1
50.0%
Space Separator
ValueCountFrequency (%)
218
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 18
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7344
89.6%
Common 747
 
9.1%
Latin 104
 
1.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 845
11.5%
양 840
11.4%
발 838
11.4%
소 836
11.4%
광 832
11.3%
태 829
11.3%
호 151
 
2.1%
성 76
 
1.0%
이 71
 
1.0%
화 59
 
0.8%
Other values (306) 1967
26.8%
Latin
ValueCountFrequency (%)
S 12
 
11.5%
H 8
 
7.7%
P 6
 
5.8%
K 6
 
5.8%
D 6
 
5.8%
E 5
 
4.8%
C 5
 
4.8%
Y 4
 
3.8%
e 4
 
3.8%
l 3
 
2.9%
Other values (25) 45
43.3%
Common
ValueCountFrequency (%)
* 276
36.9%
218
29.2%
2 91
 
12.2%
1 90
 
12.0%
3 29
 
3.9%
4 11
 
1.5%
5 6
 
0.8%
( 5
 
0.7%
) 5
 
0.7%
9 3
 
0.4%
Other values (6) 13
 
1.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7326
89.4%
ASCII 849
 
10.4%
None 18
 
0.2%
Number Forms 2
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
전 845
11.5%
양 840
11.5%
발 838
11.4%
소 836
11.4%
광 832
11.4%
태 829
11.3%
호 151
 
2.1%
성 76
 
1.0%
이 71
 
1.0%
화 59
 
0.8%
Other values (305) 1949
26.6%
ASCII
ValueCountFrequency (%)
* 276
32.5%
218
25.7%
2 91
 
10.7%
1 90
 
10.6%
3 29
 
3.4%
S 12
 
1.4%
4 11
 
1.3%
H 8
 
0.9%
P 6
 
0.7%
K 6
 
0.7%
Other values (39) 102
 
12.0%
None
ValueCountFrequency (%)
㈜ 18
100.0%
Number Forms
ValueCountFrequency (%)
Ⅰ 1
50.0%
Ⅱ 1
50.0%

설치장소 도로명주소
Text

MISSING 

Distinct64
Distinct (%)95.5%
Missing802
Missing (%)92.3%
Memory size6.9 KiB
2023-12-13T01:56:58.549302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length24
Mean length20.656716
Min length14

Characters and Unicode

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

Unique

Unique61 ?
Unique (%)91.0%

Sample

1st row경기도 화성시 남양읍 남양리 901
2nd row경기도 화성시 봉담읍 고시길 10
3rd row경기도 화성시 팔탄면 지월길 40
4th row경기도 화성시 팔탄면 시청로721번길 60
5th row경기도 화성시 봉담읍 고시길 31-5
ValueCountFrequency (%)
경기도 67
20.6%
화성시 67
20.6%
팔탄면 21
 
6.5%
우정읍 9
 
2.8%
장안면 8
 
2.5%
서신면 5
 
1.5%
석포로 5
 
1.5%
양감면 4
 
1.2%
사격장길 4
 
1.2%
봉담읍 4
 
1.2%
Other values (108) 131
40.3%
2023-12-13T01:56:58.986619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
272
19.7%
화 74
 
5.3%
기 70
 
5.1%
시 70
 
5.1%
성 69
 
5.0%
도 68
 
4.9%
경 67
 
4.8%
길 48
 
3.5%
면 43
 
3.1%
1 40
 
2.9%
Other values (98) 563
40.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 859
62.1%
Space Separator 272
 
19.7%
Decimal Number 226
 
16.3%
Dash Punctuation 27
 
2.0%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
화 74
 
8.6%
기 70
 
8.1%
시 70
 
8.1%
성 69
 
8.0%
도 68
 
7.9%
경 67
 
7.8%
길 48
 
5.6%
면 43
 
5.0%
로 30
 
3.5%
탄 23
 
2.7%
Other values (86) 297
34.6%
Decimal Number
ValueCountFrequency (%)
1 40
17.7%
4 31
13.7%
2 26
11.5%
3 24
10.6%
6 23
10.2%
5 22
9.7%
7 20
8.8%
8 16
 
7.1%
0 16
 
7.1%
9 8
 
3.5%
Space Separator
ValueCountFrequency (%)
272
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 27
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 859
62.1%
Common 525
37.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
화 74
 
8.6%
기 70
 
8.1%
시 70
 
8.1%
성 69
 
8.0%
도 68
 
7.9%
경 67
 
7.8%
길 48
 
5.6%
면 43
 
5.0%
로 30
 
3.5%
탄 23
 
2.7%
Other values (86) 297
34.6%
Common
ValueCountFrequency (%)
272
51.8%
1 40
 
7.6%
4 31
 
5.9%
- 27
 
5.1%
2 26
 
5.0%
3 24
 
4.6%
6 23
 
4.4%
5 22
 
4.2%
7 20
 
3.8%
8 16
 
3.0%
Other values (2) 24
 
4.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 859
62.1%
ASCII 525
37.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
272
51.8%
1 40
 
7.6%
4 31
 
5.9%
- 27
 
5.1%
2 26
 
5.0%
3 24
 
4.6%
6 23
 
4.4%
5 22
 
4.2%
7 20
 
3.8%
8 16
 
3.0%
Other values (2) 24
 
4.6%
Hangul
ValueCountFrequency (%)
화 74
 
8.6%
기 70
 
8.1%
시 70
 
8.1%
성 69
 
8.0%
도 68
 
7.9%
경 67
 
7.8%
길 48
 
5.6%
면 43
 
5.0%
로 30
 
3.5%
탄 23
 
2.7%
Other values (86) 297
34.6%

설치장소 지번주소
Text

MISSING 

Distinct730
Distinct (%)91.0%
Missing67
Missing (%)7.7%
Memory size6.9 KiB
2023-12-13T01:56:59.373715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length26.5
Mean length20.72818
Min length12

Characters and Unicode

Total characters16624
Distinct characters159
Distinct categories5 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique678 ?
Unique (%)84.5%

Sample

1st row경기도 화성시 장안면 장안리 573-5
2nd row경기도 화성시 봉담읍 동화리 451
3rd row경기도 화성시 장안면 덕다리 505-1
4th row경기도 화성시 팔탄면 지월리 781-13
5th row경기도 화성시 양감면 사창리 519-1
ValueCountFrequency (%)
화성시 803
20.0%
경기도 802
20.0%
팔탄면 123
 
3.1%
정남면 116
 
2.9%
장안면 102
 
2.5%
우정읍 79
 
2.0%
향남읍 59
 
1.5%
송산면 54
 
1.3%
양감면 49
 
1.2%
남양읍 41
 
1.0%
Other values (882) 1779
44.4%
2023-12-13T01:56:59.890879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
3238
19.5%
화 851
 
5.1%
도 833
 
5.0%
기 826
 
5.0%
성 804
 
4.8%
시 803
 
4.8%
경 802
 
4.8%
리 765
 
4.6%
1 627
 
3.8%
- 578
 
3.5%
Other values (149) 6497
39.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9745
58.6%
Space Separator 3238
 
19.5%
Decimal Number 3056
 
18.4%
Dash Punctuation 578
 
3.5%
Uppercase Letter 7
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
화 851
 
8.7%
도 833
 
8.5%
기 826
 
8.5%
성 804
 
8.3%
시 803
 
8.2%
경 802
 
8.2%
리 765
 
7.9%
면 555
 
5.7%
정 236
 
2.4%
남 223
 
2.3%
Other values (133) 3047
31.3%
Decimal Number
ValueCountFrequency (%)
1 627
20.5%
2 371
12.1%
3 321
10.5%
6 288
9.4%
4 284
9.3%
5 283
9.3%
8 251
8.2%
7 229
 
7.5%
9 218
 
7.1%
0 184
 
6.0%
Uppercase Letter
ValueCountFrequency (%)
A 3
42.9%
C 2
28.6%
J 1
 
14.3%
B 1
 
14.3%
Space Separator
ValueCountFrequency (%)
3238
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 578
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 9745
58.6%
Common 6872
41.3%
Latin 7
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
화 851
 
8.7%
도 833
 
8.5%
기 826
 
8.5%
성 804
 
8.3%
시 803
 
8.2%
경 802
 
8.2%
리 765
 
7.9%
면 555
 
5.7%
정 236
 
2.4%
남 223
 
2.3%
Other values (133) 3047
31.3%
Common
ValueCountFrequency (%)
3238
47.1%
1 627
 
9.1%
- 578
 
8.4%
2 371
 
5.4%
3 321
 
4.7%
6 288
 
4.2%
4 284
 
4.1%
5 283
 
4.1%
8 251
 
3.7%
7 229
 
3.3%
Other values (2) 402
 
5.8%
Latin
ValueCountFrequency (%)
A 3
42.9%
C 2
28.6%
J 1
 
14.3%
B 1
 
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 9745
58.6%
ASCII 6879
41.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
3238
47.1%
1 627
 
9.1%
- 578
 
8.4%
2 371
 
5.4%
3 321
 
4.7%
6 288
 
4.2%
4 284
 
4.1%
5 283
 
4.1%
8 251
 
3.6%
7 229
 
3.3%
Other values (6) 409
 
5.9%
Hangul
ValueCountFrequency (%)
화 851
 
8.7%
도 833
 
8.5%
기 826
 
8.5%
성 804
 
8.3%
시 803
 
8.2%
경 802
 
8.2%
리 765
 
7.9%
면 555
 
5.7%
정 236
 
2.4%
남 223
 
2.3%
Other values (133) 3047
31.3%

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

Distinct470
Distinct (%)54.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean98.631571
Minimum3
Maximum500
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.8 KiB
2023-12-13T01:57:00.086322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile16.425
Q138
median91
Q399.63
95-th percentile297.936
Maximum500
Range497
Interquartile range (IQR)61.63

Descriptive statistics

Standard deviation90.222007
Coefficient of variation (CV)0.91473761
Kurtosis6.1971585
Mean98.631571
Median Absolute Deviation (MAD)41.58
Skewness2.2879289
Sum85710.835
Variance8140.0105
MonotonicityNot monotonic
2023-12-13T01:57:00.308190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 52
 
6.0%
99.36 19
 
2.2%
97.2 18
 
2.1%
30.0 17
 
2.0%
99.9 16
 
1.8%
97.92 15
 
1.7%
99.28 13
 
1.5%
15.0 11
 
1.3%
98.55 9
 
1.0%
20.0 9
 
1.0%
Other values (460) 690
79.4%
ValueCountFrequency (%)
3.0 1
 
0.1%
9.0 2
0.2%
9.087 1
 
0.1%
9.8 1
 
0.1%
9.96 1
 
0.1%
10.0 3
0.3%
10.56 1
 
0.1%
11.04 1
 
0.1%
11.7 1
 
0.1%
11.88 1
 
0.1%
ValueCountFrequency (%)
500.0 1
0.1%
499.72 1
0.1%
499.675 1
0.1%
499.2 1
0.1%
499.0 1
0.1%
498.96 1
0.1%
496.8 1
0.1%
496.4 1
0.1%
495.67 1
0.1%
494.76 1
0.1%

공급전압(V)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
380
869 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row380
2nd row380
3rd row380
4th row380
5th row380

Common Values

ValueCountFrequency (%)
380 869
100.0%

Length

2023-12-13T01:57:00.526597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:57:00.665281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
380 869
100.0%

주파수(HZ)
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
60
869 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row60
2nd row60
3rd row60
4th row60
5th row60

Common Values

ValueCountFrequency (%)
60 869
100.0%

Length

2023-12-13T01:57:00.808308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:57:00.995667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
60 869
100.0%

사업허가일
Date

Distinct453
Distinct (%)52.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
Minimum2007-11-23 00:00:00
Maximum2019-12-06 00:00:00
2023-12-13T01:57:01.199161image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T01:57:01.498688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Text

MISSING 

Distinct331
Distinct (%)65.0%
Missing360
Missing (%)41.4%
Memory size6.9 KiB
2023-12-13T01:57:01.989522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.9980354
Min length9

Characters and Unicode

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

Unique

Unique229 ?
Unique (%)45.0%

Sample

1st row2005-06-22
2nd row2008-08-11
3rd row2008-09-30
4th row2009-02-13
5th row2010-04-09
ValueCountFrequency (%)
2018-08-20 12
 
2.4%
2017-05-02 6
 
1.2%
2012-09-11 6
 
1.2%
2019-08-01 5
 
1.0%
2015-12-30 5
 
1.0%
2019-04-17 5
 
1.0%
2018-04-17 5
 
1.0%
2018-08-27 5
 
1.0%
2018-11-09 5
 
1.0%
2017-12-12 5
 
1.0%
Other values (321) 450
88.4%
2023-12-13T01:57:02.543543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 1154
22.7%
- 1018
20.0%
1 938
18.4%
2 851
16.7%
8 240
 
4.7%
9 234
 
4.6%
7 186
 
3.7%
5 134
 
2.6%
3 126
 
2.5%
4 123
 
2.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 4071
80.0%
Dash Punctuation 1018
 
20.0%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 1154
28.3%
1 938
23.0%
2 851
20.9%
8 240
 
5.9%
9 234
 
5.7%
7 186
 
4.6%
5 134
 
3.3%
3 126
 
3.1%
4 123
 
3.0%
6 85
 
2.1%
Dash Punctuation
ValueCountFrequency (%)
- 1018
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 5089
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 1154
22.7%
- 1018
20.0%
1 938
18.4%
2 851
16.7%
8 240
 
4.7%
9 234
 
4.6%
7 186
 
3.7%
5 134
 
2.6%
3 126
 
2.5%
4 123
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 5089
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 1154
22.7%
- 1018
20.0%
1 938
18.4%
2 851
16.7%
8 240
 
4.7%
9 234
 
4.6%
7 186
 
3.7%
5 134
 
2.6%
3 126
 
2.5%
4 123
 
2.4%

소요부지면적(㎥)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing869
Missing (%)100.0%
Memory size7.8 KiB

집광판면적(㎥)
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing869
Missing (%)100.0%
Memory size7.8 KiB

위도
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing869
Missing (%)100.0%
Memory size7.8 KiB

경도
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing869
Missing (%)100.0%
Memory size7.8 KiB

설치위치구분
Categorical

Distinct3
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
건물
705 
토지
143 
건물, 토지
 
21

Length

Max length6
Median length2
Mean length2.0966628
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row건물
2nd row건물
3rd row건물
4th row건물
5th row건물

Common Values

ValueCountFrequency (%)
건물 705
81.1%
토지 143
 
16.5%
건물, 토지 21
 
2.4%

Length

2023-12-13T01:57:03.103832image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:57:03.226896image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
건물 726
81.6%
토지 164
 
18.4%

지목
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing869
Missing (%)100.0%
Memory size7.8 KiB

비고
Unsupported

MISSING  REJECTED  UNSUPPORTED 

Missing869
Missing (%)100.0%
Memory size7.8 KiB

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.9 KiB
2019-12-11
869 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2019-12-11
2nd row2019-12-11
3rd row2019-12-11
4th row2019-12-11
5th row2019-12-11

Common Values

ValueCountFrequency (%)
2019-12-11 869
100.0%

Length

2023-12-13T01:57:03.357096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T01:57:03.475113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019-12-11 869
100.0%

Sample

허가기관시군명용도세부용도사업상태발전소명설치장소 도로명주소설치장소 지번주소설비용량(KW)공급전압(V)주파수(HZ)사업허가일사업개시일소요부지면적(㎥)집광판면적(㎥)위도경도설치위치구분지목비고데이터기준일
0화성시화성시전기사업용발전사업용운영중화성 태양광발전소<NA>경기도 화성시 장안면 장안리 573-599.0380602007-11-232005-06-22<NA><NA><NA><NA>건물<NA><NA>2019-12-11
1화성시화성시전기사업용발전사업용운영중동화 태양광발전소<NA>경기도 화성시 봉담읍 동화리 45113.68380602008-07-112008-08-11<NA><NA><NA><NA>건물<NA><NA>2019-12-11
2화성시화성시전기사업용발전사업용운영중해강 태양광발전소<NA>경기도 화성시 장안면 덕다리 505-199.0380602008-07-252008-09-30<NA><NA><NA><NA>건물<NA><NA>2019-12-11
3화성시화성시전기사업용발전사업용운영중디엠에스발안 태양광발전소<NA>경기도 화성시 팔탄면 지월리 781-1315.84380602008-12-102009-02-13<NA><NA><NA><NA>건물<NA><NA>2019-12-11
4화성시화성시전기사업용발전사업용운영중화성한과 시민햇빛발전소<NA>경기도 화성시 양감면 사창리 519-19.8380602009-02-042010-04-09<NA><NA><NA><NA>건물<NA><NA>2019-12-11
5화성시화성시전기사업용발전사업용운영중유화 태양광발전소<NA>경기도 화성시 봉담읍 상기리 402-119.6380602009-02-042009-09-02<NA><NA><NA><NA>건물<NA><NA>2019-12-11
6화성시화성시전기사업용발전사업용운영중화성 태양광발전소<NA>경기도 화성시 우정읍 화산리 1205-1299.2380602009-06-242009-12-17<NA><NA><NA><NA>건물<NA><NA>2019-12-11
7화성시화성시전기사업용발전사업용운영중유일 화성공장 태양광발전소<NA>경기도 화성시 팔탄면 구장리 127-2899.36380602009-10-212010-03-12<NA><NA><NA><NA>건물<NA><NA>2019-12-11
8화성시화성시전기사업용발전사업용운영중롯데마트 화성 태양광발전소<NA>경기도 화성시 반월동 123-599.258380602010-02-242011-01-14<NA><NA><NA><NA>건물<NA><NA>2019-12-11
9화성시화성시전기사업용발전사업용운영중사곳리 태양광발전소<NA>경기도 화성시 서신면 사곳리 1359.087380602010-02-252010-09-09<NA><NA><NA><NA>건물<NA><NA>2019-12-11
허가기관시군명용도세부용도사업상태발전소명설치장소 도로명주소설치장소 지번주소설비용량(KW)공급전압(V)주파수(HZ)사업허가일사업개시일소요부지면적(㎥)집광판면적(㎥)위도경도설치위치구분지목비고데이터기준일
859화성시화성시전기사업용발전사업용사업허가상승태양광발전소<NA>경기도 화성시 팔탄면 율암리 38799.84380602019-11-26<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
860화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 정남면 고지리 162-247.25380602019-11-26<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
861화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 정남면 고지리 162-247.25380602019-11-26<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
862화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 정남면 고지리 162-239.0380602019-11-26<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
863화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 정남면 고지리 162-226.25380602019-11-28<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
864화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 정남면 고지리 162-289.25380602019-11-28<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
865화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 정남면 고지리 162-257.75380602019-11-28<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
866화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 정남면 고지리 162-1926.25380602019-11-28<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
867화성시화성시전기사업용발전사업용사업허가홍옥태양광발전소<NA>경기도 화성시 서신면 전곡리 1110-3232.5380602019-12-06<NA><NA><NA><NA><NA>건물<NA><NA>2019-12-11
868화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 서신면 백미리 469-199.9380602019-12-06<NA><NA><NA><NA><NA>토지<NA><NA>2019-12-11

Duplicate rows

Most frequently occurring

허가기관시군명용도세부용도사업상태발전소명설치장소 도로명주소설치장소 지번주소설비용량(KW)공급전압(V)주파수(HZ)사업허가일사업개시일설치위치구분데이터기준일# duplicates
1화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 장안면 노진리 144861.6380602019-10-08<NA>건물2019-12-114
0화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 장안면 노진리 144857.6380602019-10-08<NA>건물2019-12-112
2화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 장안면 노진리 144867.2380602019-10-08<NA>건물2019-12-112
3화성시화성시전기사업용발전사업용사업허가***태양광발전소<NA>경기도 화성시 정남면 고지리 162-247.25380602019-11-26<NA>건물2019-12-112
4화성시화성시전기사업용발전사업용운영중*** 태양광발전소<NA>경기도 화성시 송산면 용포리 738-1199.0380602015-02-112015-04-14건물2019-12-112