Overview

Dataset statistics

Number of variables6
Number of observations1029
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory48.4 KiB
Average record size in memory48.1 B

Variable types

Text3
DateTime2
Categorical1

Dataset

Description경상북도 예천군 내 태양광 발전 설치 현황(발전소 상호명, 소재지 주소,설비용량(KW), 허가일, 사업개시일, 기준일 등)입니다.
Author경상북도 예천군
URLhttps://www.data.go.kr/data/15034271/fileData.do

Alerts

기준일 has constant value ""Constant

Reproduction

Analysis started2023-12-12 17:37:14.155710
Analysis finished2023-12-12 17:37:14.709313
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

상호
Text

Distinct1007
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
2023-12-13T02:37:15.027152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length20
Mean length8.6520894
Min length2

Characters and Unicode

Total characters8903
Distinct characters354
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

Unique986 ?
Unique (%)95.8%

Sample

1st row예천SP태양광제2발전소
2nd row예천솔라팜
3rd row㈜솔라테크에너지 소화리태양광발전소
4th row영남햇빛 발전소
5th row솔라태양광발전소
ValueCountFrequency (%)
태양광발전소 271
 
18.5%
발전소 87
 
6.0%
태양광 17
 
1.2%
에너지 15
 
1.0%
주식회사 5
 
0.3%
해테크 3
 
0.2%
천지태양광발전소 3
 
0.2%
예함 2
 
0.1%
유한회사 2
 
0.1%
백만볼트 2
 
0.1%
Other values (1020) 1054
72.1%
2023-12-13T02:37:15.514482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
전 881
 
9.9%
소 878
 
9.9%
발 864
 
9.7%
태 802
 
9.0%
광 789
 
8.9%
양 777
 
8.7%
439
 
4.9%
호 251
 
2.8%
2 131
 
1.5%
1 103
 
1.2%
Other values (344) 2988
33.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7952
89.3%
Space Separator 439
 
4.9%
Decimal Number 352
 
4.0%
Uppercase Letter 100
 
1.1%
Other Symbol 31
 
0.3%
Close Punctuation 10
 
0.1%
Open Punctuation 10
 
0.1%
Dash Punctuation 6
 
0.1%
Lowercase Letter 2
 
< 0.1%
Other Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 881
 
11.1%
소 878
 
11.0%
발 864
 
10.9%
태 802
 
10.1%
광 789
 
9.9%
양 777
 
9.8%
호 251
 
3.2%
지 99
 
1.2%
천 73
 
0.9%
라 72
 
0.9%
Other values (306) 2466
31.0%
Uppercase Letter
ValueCountFrequency (%)
S 21
21.0%
H 18
18.0%
M 9
9.0%
J 7
 
7.0%
U 7
 
7.0%
K 5
 
5.0%
B 4
 
4.0%
O 4
 
4.0%
P 4
 
4.0%
A 4
 
4.0%
Other values (10) 17
17.0%
Decimal Number
ValueCountFrequency (%)
2 131
37.2%
1 103
29.3%
3 60
17.0%
4 18
 
5.1%
5 14
 
4.0%
6 12
 
3.4%
9 5
 
1.4%
7 5
 
1.4%
0 2
 
0.6%
8 2
 
0.6%
Lowercase Letter
ValueCountFrequency (%)
n 1
50.0%
u 1
50.0%
Space Separator
ValueCountFrequency (%)
439
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 31
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%
Other Punctuation
ValueCountFrequency (%)
& 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7983
89.7%
Common 818
 
9.2%
Latin 102
 
1.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 881
 
11.0%
소 878
 
11.0%
발 864
 
10.8%
태 802
 
10.0%
광 789
 
9.9%
양 777
 
9.7%
호 251
 
3.1%
지 99
 
1.2%
천 73
 
0.9%
라 72
 
0.9%
Other values (307) 2497
31.3%
Latin
ValueCountFrequency (%)
S 21
20.6%
H 18
17.6%
M 9
8.8%
J 7
 
6.9%
U 7
 
6.9%
K 5
 
4.9%
B 4
 
3.9%
O 4
 
3.9%
P 4
 
3.9%
A 4
 
3.9%
Other values (12) 19
18.6%
Common
ValueCountFrequency (%)
439
53.7%
2 131
 
16.0%
1 103
 
12.6%
3 60
 
7.3%
4 18
 
2.2%
5 14
 
1.7%
6 12
 
1.5%
) 10
 
1.2%
( 10
 
1.2%
- 6
 
0.7%
Other values (5) 15
 
1.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7952
89.3%
ASCII 920
 
10.3%
None 31
 
0.3%

Most frequent character per block

Hangul
ValueCountFrequency (%)
전 881
 
11.1%
소 878
 
11.0%
발 864
 
10.9%
태 802
 
10.1%
광 789
 
9.9%
양 777
 
9.8%
호 251
 
3.2%
지 99
 
1.2%
천 73
 
0.9%
라 72
 
0.9%
Other values (306) 2466
31.0%
ASCII
ValueCountFrequency (%)
439
47.7%
2 131
 
14.2%
1 103
 
11.2%
3 60
 
6.5%
S 21
 
2.3%
H 18
 
2.0%
4 18
 
2.0%
5 14
 
1.5%
6 12
 
1.3%
) 10
 
1.1%
Other values (27) 94
 
10.2%
None
ValueCountFrequency (%)
㈜ 31
100.0%

소재지
Text

Distinct721
Distinct (%)70.1%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
2023-12-13T02:37:15.817732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length75
Median length60
Mean length19.409135
Min length11

Characters and Unicode

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

Unique

Unique565 ?
Unique (%)54.9%

Sample

1st row풍양면 흔효리 168-1
2nd row지보면 어신리 산46-7외8
3rd row지보면 소화리 산77
4th row지보면 도화리 483-1(토지위)
5th row감천면 돈산리 산60
ValueCountFrequency (%)
지보면 221
 
6.1%
유천면 161
 
4.4%
풍양면 121
 
3.3%
예천읍 108
 
3.0%
감천면 105
 
2.9%
위 96
 
2.7%
보문면 79
 
2.2%
호명면 66
 
1.8%
개포면 62
 
1.7%
용궁면 53
 
1.5%
Other values (1058) 2546
70.4%
2023-12-13T02:37:16.246439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2590
 
13.0%
) 1029
 
5.2%
( 1029
 
5.2%
리 1025
 
5.1%
1 975
 
4.9%
지 940
 
4.7%
면 923
 
4.6%
위 923
 
4.6%
3 649
 
3.2%
- 645
 
3.2%
Other values (144) 9244
46.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 9389
47.0%
Decimal Number 4822
24.1%
Space Separator 2590
 
13.0%
Close Punctuation 1029
 
5.2%
Open Punctuation 1029
 
5.2%
Dash Punctuation 645
 
3.2%
Other Punctuation 468
 
2.3%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
리 1025
 
10.9%
지 940
 
10.0%
면 923
 
9.8%
위 923
 
9.8%
토 615
 
6.6%
천 416
 
4.4%
물 383
 
4.1%
건 383
 
4.1%
보 317
 
3.4%
산 239
 
2.5%
Other values (129) 3225
34.3%
Decimal Number
ValueCountFrequency (%)
1 975
20.2%
3 649
13.5%
2 600
12.4%
5 535
11.1%
4 473
9.8%
7 427
8.9%
6 331
 
6.9%
9 296
 
6.1%
8 273
 
5.7%
0 263
 
5.5%
Space Separator
ValueCountFrequency (%)
2590
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1029
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1029
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 645
100.0%
Other Punctuation
ValueCountFrequency (%)
, 468
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 10583
53.0%
Hangul 9389
47.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
리 1025
 
10.9%
지 940
 
10.0%
면 923
 
9.8%
위 923
 
9.8%
토 615
 
6.6%
천 416
 
4.4%
물 383
 
4.1%
건 383
 
4.1%
보 317
 
3.4%
산 239
 
2.5%
Other values (129) 3225
34.3%
Common
ValueCountFrequency (%)
2590
24.5%
) 1029
 
9.7%
( 1029
 
9.7%
1 975
 
9.2%
3 649
 
6.1%
- 645
 
6.1%
2 600
 
5.7%
5 535
 
5.1%
4 473
 
4.5%
, 468
 
4.4%
Other values (5) 1590
15.0%

Most occurring blocks

ValueCountFrequency (%)
ASCII 10583
53.0%
Hangul 9389
47.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2590
24.5%
) 1029
 
9.7%
( 1029
 
9.7%
1 975
 
9.2%
3 649
 
6.1%
- 645
 
6.1%
2 600
 
5.7%
5 535
 
5.1%
4 473
 
4.5%
, 468
 
4.4%
Other values (5) 1590
15.0%
Hangul
ValueCountFrequency (%)
리 1025
 
10.9%
지 940
 
10.0%
면 923
 
9.8%
위 923
 
9.8%
토 615
 
6.6%
천 416
 
4.4%
물 383
 
4.1%
건 383
 
4.1%
보 317
 
3.4%
산 239
 
2.5%
Other values (129) 3225
34.3%

용량(KW)
Text

Distinct262
Distinct (%)25.5%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
2023-12-13T02:37:16.599837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length8
Median length6
Mean length4.4139942
Min length2

Characters and Unicode

Total characters4542
Distinct characters12
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

Unique169 ?
Unique (%)16.4%

Sample

1st row350
2nd row1,000.00
3rd row490
4th row924
5th row1,000.00
ValueCountFrequency (%)
99.36 97
 
9.4%
99 90
 
8.7%
99.6 76
 
7.4%
99.9 56
 
5.4%
99.96 38
 
3.7%
99.2 33
 
3.2%
97.2 28
 
2.7%
98.28 25
 
2.4%
99.28 22
 
2.1%
96.48 19
 
1.8%
Other values (252) 545
53.0%
2023-12-13T02:37:17.114142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9 1664
36.6%
. 872
19.2%
6 392
 
8.6%
8 325
 
7.2%
2 265
 
5.8%
4 254
 
5.6%
3 173
 
3.8%
5 165
 
3.6%
7 163
 
3.6%
1 149
 
3.3%
Other values (2) 120
 
2.6%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 3666
80.7%
Other Punctuation 876
 
19.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
9 1664
45.4%
6 392
 
10.7%
8 325
 
8.9%
2 265
 
7.2%
4 254
 
6.9%
3 173
 
4.7%
5 165
 
4.5%
7 163
 
4.4%
1 149
 
4.1%
0 116
 
3.2%
Other Punctuation
ValueCountFrequency (%)
. 872
99.5%
, 4
 
0.5%

Most occurring scripts

ValueCountFrequency (%)
Common 4542
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
9 1664
36.6%
. 872
19.2%
6 392
 
8.6%
8 325
 
7.2%
2 265
 
5.8%
4 254
 
5.6%
3 173
 
3.8%
5 165
 
3.6%
7 163
 
3.6%
1 149
 
3.3%
Other values (2) 120
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
ASCII 4542
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9 1664
36.6%
. 872
19.2%
6 392
 
8.6%
8 325
 
7.2%
2 265
 
5.8%
4 254
 
5.6%
3 173
 
3.8%
5 165
 
3.6%
7 163
 
3.6%
1 149
 
3.3%
Other values (2) 120
 
2.6%

허가일
Date

Distinct196
Distinct (%)19.0%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
Minimum2007-11-05 00:00:00
Maximum2022-04-15 00:00:00
2023-12-13T02:37:17.628868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:37:17.802076image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시
Date

Distinct417
Distinct (%)40.5%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
Minimum2008-05-09 00:00:00
Maximum2022-09-06 00:00:00
2023-12-13T02:37:17.938656image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:37:18.089028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size8.2 KiB
2022-10-12
1029 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-10-12
2nd row2022-10-12
3rd row2022-10-12
4th row2022-10-12
5th row2022-10-12

Common Values

ValueCountFrequency (%)
2022-10-12 1029
100.0%

Length

2023-12-13T02:37:18.236586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:37:18.339354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-10-12 1029
100.0%

Missing values

2023-12-13T02:37:14.565877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:37:14.667738image/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)허가일사업개시기준일
0예천SP태양광제2발전소풍양면 흔효리 168-13502007-11-052009-09-082022-10-12
1예천솔라팜지보면 어신리 산46-7외81,000.002007-12-262008-05-092022-10-12
2㈜솔라테크에너지 소화리태양광발전소지보면 소화리 산774902008-01-152009-11-112022-10-12
3영남햇빛 발전소지보면 도화리 483-1(토지위)9242008-02-202010-05-262022-10-12
4솔라태양광발전소감천면 돈산리 산601,000.002008-07-032009-04-012022-10-12
5㈜청운전력6호태양광발전소개포면 황산리 351(토지위)292009-02-162009-08-312022-10-12
6수진솔라개포면 황산리 352-2, 356-1,356-2(토지위)292009-02-162009-08-312022-10-12
7㈜에스아이솔라개포면 황산리 351(토지위)292009-02-162009-08-272022-10-12
8㈜해든나라태양광발전소개포면 황산리 352-1, 352-2,355(토지위)992009-02-162009-08-312022-10-12
9대일솔라개포면 황산리 352-2,355(토지위)992009-02-162009-08-312022-10-12
상호소재지용량(KW)허가일사업개시기준일
1019혈통1호 태양광발전소지보면 송평리 649, 650, 745-2(가동)(건물위)99.92022-03-162022-06-302022-10-12
1020혈통2호 태양광발전소지보면 송평리 649, 650, 745-2(라동)(건물위)302022-03-162022-06-302022-10-12
1021은풍태양광(1호) 발전소은풍면 우곡리 124-2(건물 위)16.42022-04-152022-09-022022-10-12
1022은풍태양광(2호) 발전소은풍면 우곡리 124-2(건물 위)28.72022-04-152022-09-022022-10-12
1023정도윤 태양광발전소감천면 덕율리 536-2(건물 위)30.072022-04-152022-07-072022-10-12
1024영광 발전소지보면 어신리 1350(건물 위)99.762022-04-152022-07-122022-10-12
1025유준1 발전소지보면 어신리 1350(건물 위)99.762022-04-152022-07-122022-10-12
1026일광 발전소지보면 어신리 1350(건물 위)99.762022-04-152022-07-122022-10-12
1027정인 발전소지보면 어신리 1350(건물 위)99.762022-04-152022-07-122022-10-12
1028하준 발전소지보면 어신리 1350(건물 위)99.762022-04-152022-07-122022-10-12