Overview

Dataset statistics

Number of variables5
Number of observations36
Missing cells0
Missing cells (%)0.0%
Duplicate rows1
Duplicate rows (%)2.8%
Total size in memory1.6 KiB
Average record size in memory45.7 B

Variable types

Text2
Numeric2
DateTime1

Dataset

Description서울대학교 조경계획연구실에서 요청하신 하남시 태양광발전기 설치현황 공개에 대해 하남시 태양광발전소명, 주소, 위도, 경도 등의 정보를 제공합니다.
Author경기도 하남시
URLhttps://www.data.go.kr/data/15096088/fileData.do

Alerts

데이터기준일 has constant value ""Constant
Dataset has 1 (2.8%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 06:26:15.179073
Analysis finished2023-12-12 06:26:16.053080
Duration0.87 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

발전소명
Text

Distinct35
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-12-12T15:26:16.227446image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length15
Median length12
Mean length10.111111
Min length5

Characters and Unicode

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

Unique

Unique34 ?
Unique (%)94.4%

Sample

1st row하남시민햇빛발전2호기
2nd row라진 태양광발전소
3rd row미래유통 태양광발전소
4th row숭일 태양광발전소
5th row태건2호 태양광발전소
ValueCountFrequency (%)
태양광발전소 24
36.4%
감북솔라에너지 2
 
3.0%
발전소 2
 
3.0%
선우 1
 
1.5%
김삼수 1
 
1.5%
호산 1
 
1.5%
케이디파워솔라 1
 
1.5%
대현1호 1
 
1.5%
김대환 1
 
1.5%
태경 1
 
1.5%
Other values (31) 31
47.0%
2023-12-12T15:26:16.601373image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
태 33
 
9.1%
발 32
 
8.8%
전 32
 
8.8%
양 31
 
8.5%
소 31
 
8.5%
광 30
 
8.2%
30
 
8.2%
호 6
 
1.6%
대 5
 
1.4%
에 5
 
1.4%
Other values (85) 129
35.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 315
86.5%
Space Separator 30
 
8.2%
Decimal Number 11
 
3.0%
Uppercase Letter 8
 
2.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
태 33
 
10.5%
발 32
 
10.2%
전 32
 
10.2%
양 31
 
9.8%
소 31
 
9.8%
광 30
 
9.5%
호 6
 
1.9%
대 5
 
1.6%
에 5
 
1.6%
라 4
 
1.3%
Other values (72) 106
33.7%
Uppercase Letter
ValueCountFrequency (%)
J 2
25.0%
I 1
12.5%
C 1
12.5%
O 1
12.5%
G 1
12.5%
B 1
12.5%
S 1
12.5%
Decimal Number
ValueCountFrequency (%)
1 4
36.4%
2 3
27.3%
0 2
18.2%
5 1
 
9.1%
6 1
 
9.1%
Space Separator
ValueCountFrequency (%)
30
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 315
86.5%
Common 41
 
11.3%
Latin 8
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
태 33
 
10.5%
발 32
 
10.2%
전 32
 
10.2%
양 31
 
9.8%
소 31
 
9.8%
광 30
 
9.5%
호 6
 
1.9%
대 5
 
1.6%
에 5
 
1.6%
라 4
 
1.3%
Other values (72) 106
33.7%
Latin
ValueCountFrequency (%)
J 2
25.0%
I 1
12.5%
C 1
12.5%
O 1
12.5%
G 1
12.5%
B 1
12.5%
S 1
12.5%
Common
ValueCountFrequency (%)
30
73.2%
1 4
 
9.8%
2 3
 
7.3%
0 2
 
4.9%
5 1
 
2.4%
6 1
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 315
86.5%
ASCII 49
 
13.5%

Most frequent character per block

Hangul
ValueCountFrequency (%)
태 33
 
10.5%
발 32
 
10.2%
전 32
 
10.2%
양 31
 
9.8%
소 31
 
9.8%
광 30
 
9.5%
호 6
 
1.9%
대 5
 
1.6%
에 5
 
1.6%
라 4
 
1.3%
Other values (72) 106
33.7%
ASCII
ValueCountFrequency (%)
30
61.2%
1 4
 
8.2%
2 3
 
6.1%
J 2
 
4.1%
0 2
 
4.1%
I 1
 
2.0%
C 1
 
2.0%
O 1
 
2.0%
G 1
 
2.0%
5 1
 
2.0%
Other values (3) 3
 
6.1%

도로명주소
Text

Distinct35
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Memory size420.0 B
2023-12-12T15:26:16.813048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length22
Mean length17.583333
Min length13

Characters and Unicode

Total characters633
Distinct characters46
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

Unique34 ?
Unique (%)94.4%

Sample

1st row경기도 하남시 아리수로 600
2nd row경기도 하남시 초광산단동로6번길 66
3rd row경기도 하남시 산곡동로86번길 36
4th row경기도 하남시 초광산단로 17
5th row경기도 하남시 미사동로 88-2
ValueCountFrequency (%)
경기도 36
25.0%
하남시 36
25.0%
초광산단로 11
 
7.6%
서하남로 3
 
2.1%
서하남로47번길 3
 
2.1%
175-15 2
 
1.4%
14 2
 
1.4%
88 2
 
1.4%
미사동로 2
 
1.4%
19 1
 
0.7%
Other values (46) 46
31.9%
2023-12-12T15:26:17.177587image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
108
17.1%
하 46
 
7.3%
남 45
 
7.1%
경 36
 
5.7%
도 36
 
5.7%
시 36
 
5.7%
기 36
 
5.7%
로 34
 
5.4%
1 24
 
3.8%
산 18
 
2.8%
Other values (36) 214
33.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 400
63.2%
Decimal Number 119
 
18.8%
Space Separator 108
 
17.1%
Dash Punctuation 6
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
하 46
11.5%
남 45
11.2%
경 36
9.0%
도 36
9.0%
시 36
9.0%
기 36
9.0%
로 34
8.5%
산 18
 
4.5%
단 16
 
4.0%
초 16
 
4.0%
Other values (24) 81
20.2%
Decimal Number
ValueCountFrequency (%)
1 24
20.2%
8 16
13.4%
2 14
11.8%
6 12
10.1%
3 11
9.2%
5 9
 
7.6%
7 9
 
7.6%
4 9
 
7.6%
0 8
 
6.7%
9 7
 
5.9%
Space Separator
ValueCountFrequency (%)
108
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 400
63.2%
Common 233
36.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
하 46
11.5%
남 45
11.2%
경 36
9.0%
도 36
9.0%
시 36
9.0%
기 36
9.0%
로 34
8.5%
산 18
 
4.5%
단 16
 
4.0%
초 16
 
4.0%
Other values (24) 81
20.2%
Common
ValueCountFrequency (%)
108
46.4%
1 24
 
10.3%
8 16
 
6.9%
2 14
 
6.0%
6 12
 
5.2%
3 11
 
4.7%
5 9
 
3.9%
7 9
 
3.9%
4 9
 
3.9%
0 8
 
3.4%
Other values (2) 13
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 400
63.2%
ASCII 233
36.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
108
46.4%
1 24
 
10.3%
8 16
 
6.9%
2 14
 
6.0%
6 12
 
5.2%
3 11
 
4.7%
5 9
 
3.9%
7 9
 
3.9%
4 9
 
3.9%
0 8
 
3.4%
Other values (2) 13
 
5.6%
Hangul
ValueCountFrequency (%)
하 46
11.5%
남 45
11.2%
경 36
9.0%
도 36
9.0%
시 36
9.0%
기 36
9.0%
로 34
8.5%
산 18
 
4.5%
단 16
 
4.0%
초 16
 
4.0%
Other values (24) 81
20.2%

위도
Real number (ℝ)

Distinct35
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean37.528284
Minimum37.503385
Maximum37.57452
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-12T15:26:17.303478image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum37.503385
5-th percentile37.511519
Q137.519834
median37.524862
Q337.529332
95-th percentile37.567871
Maximum37.57452
Range0.071134578
Interquartile range (IQR)0.0094979539

Descriptive statistics

Standard deviation0.015753006
Coefficient of variation (CV)0.00041976357
Kurtosis3.3272496
Mean37.528284
Median Absolute Deviation (MAD)0.0046965136
Skewness1.763008
Sum1351.0182
Variance0.00024815721
MonotonicityNot monotonic
2023-12-12T15:26:17.436334image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
37.5221140402 2
 
5.6%
37.5657002161 1
 
2.8%
37.5248731 1
 
2.8%
37.5249330525 1
 
2.8%
37.5504293808 1
 
2.8%
37.52830786 1
 
2.8%
37.5200405015 1
 
2.8%
37.5172355733 1
 
2.8%
37.5172734354 1
 
2.8%
37.5378717642 1
 
2.8%
Other values (25) 25
69.4%
ValueCountFrequency (%)
37.50338537 1
2.8%
37.5096557073 1
2.8%
37.5121395185 1
2.8%
37.5148141994 1
2.8%
37.5172355733 1
2.8%
37.5172734354 1
2.8%
37.5189866482 1
2.8%
37.5196312986 1
2.8%
37.519733526 1
2.8%
37.5198675688 1
2.8%
ValueCountFrequency (%)
37.5745199483 1
2.8%
37.5743832827 1
2.8%
37.5657002161 1
2.8%
37.5504293808 1
2.8%
37.5399932175 1
2.8%
37.5378717642 1
2.8%
37.5370316102 1
2.8%
37.5294335288 1
2.8%
37.5293734235 1
2.8%
37.5293182082 1
2.8%

경도
Real number (ℝ)

Distinct35
Distinct (%)97.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean127.18534
Minimum127.14739
Maximum127.27106
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size456.0 B
2023-12-12T15:26:17.573971image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum127.14739
5-th percentile127.15391
Q1127.16863
median127.17303
Q3127.20305
95-th percentile127.22972
Maximum127.27106
Range0.12366938
Interquartile range (IQR)0.0344182

Descriptive statistics

Standard deviation0.027925304
Coefficient of variation (CV)0.00021956386
Kurtosis1.0665732
Mean127.18534
Median Absolute Deviation (MAD)0.012122031
Skewness1.1479331
Sum4578.6722
Variance0.00077982258
MonotonicityNot monotonic
2023-12-12T15:26:17.715364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%)
127.1546003914 2
 
5.6%
127.1939062443 1
 
2.8%
127.1734562 1
 
2.8%
127.1728917379 1
 
2.8%
127.1938732398 1
 
2.8%
127.1684525257 1
 
2.8%
127.2013947582 1
 
2.8%
127.1732267847 1
 
2.8%
127.1473881093 1
 
2.8%
127.1724689069 1
 
2.8%
Other values (25) 25
69.4%
ValueCountFrequency (%)
127.1473881093 1
2.8%
127.1532244829 1
2.8%
127.1541410955 1
2.8%
127.1546003914 2
5.6%
127.1672197268 1
2.8%
127.1677854175 1
2.8%
127.1684525257 1
2.8%
127.1685200061 1
2.8%
127.1686656791 1
2.8%
127.1715684293 1
2.8%
ValueCountFrequency (%)
127.2710574935 1
2.8%
127.2302238 1
2.8%
127.2295504709 1
2.8%
127.2279469163 1
2.8%
127.227733284 1
2.8%
127.2219791879 1
2.8%
127.2133610498 1
2.8%
127.2036934332 1
2.8%
127.2030745903 1
2.8%
127.203038418 1
2.8%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size420.0 B
Minimum2022-12-07 00:00:00
Maximum2022-12-07 00:00:00
2023-12-12T15:26:18.186167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:26:18.303997image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T15:26:15.637214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:26:15.396674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:26:15.773640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:26:15.509266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T15:26:18.405106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
발전소명도로명주소위도경도
발전소명1.0001.0001.0001.000
도로명주소1.0001.0001.0001.000
위도1.0001.0001.0000.819
경도1.0001.0000.8191.000
2023-12-12T15:26:18.538518image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위도경도
위도1.0000.007
경도0.0071.000

Missing values

2023-12-12T15:26:15.883643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:26:16.002771image/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

발전소명도로명주소위도경도데이터기준일
0하남시민햇빛발전2호기경기도 하남시 아리수로 60037.5657127.1939062022-12-07
1라진 태양광발전소경기도 하남시 초광산단동로6번길 6637.524873127.1734562022-12-07
2미래유통 태양광발전소경기도 하남시 산곡동로86번길 3637.51214127.229552022-12-07
3숭일 태양광발전소경기도 하남시 초광산단로 1737.527477127.168522022-12-07
4태건2호 태양광발전소경기도 하남시 미사동로 88-237.574383127.2036932022-12-07
5태건1호 태양광발전소경기도 하남시 미사동로 8837.57452127.2030752022-12-07
6하남대로 506 태양광발전소경기도 하남시 하남대로 50637.518987127.2219792022-12-07
7동양 102호 태양광발전소경기도 하남시 초광로 18937.537032127.1759922022-12-07
8현대에코1 태양광발전소경기도 하남시 하산곡동 390-2137.503385127.2302242022-12-07
9비젼다모아 태양광발전소경기도 하남시 초광산단로 3737.529318127.1686662022-12-07
발전소명도로명주소위도경도데이터기준일
26태경 태양광발전소경기도 하남시 서하남로 26837.517236127.1732272022-12-07
27김삼수 태양광발전소경기도 하남시 서하남로23번길 1437.517273127.1473882022-12-07
28이주범 태양광발전소경기도 하남시 초이로80번길 1937.537872127.1724692022-12-07
29배알미동번영회경기도 하남시 아랫배알미길 6937.526592127.2710572022-12-07
30동서울지사 태양광 발전소경기도 하남시 서하남로 8837.514814127.1532242022-12-07
31디케이홀딩스 태양광발전소경기도 하남시 서하남로47번길 11637.519631127.1541412022-12-07
32고골태양광발전소경기도 하남시 춘궁로93번길 2137.509656127.2030382022-12-07
33양곡태양광발전소경기도 하남시 검단산로34번길 35-2837.519734127.2277332022-12-07
34OCI 광암 태양광발전소경기도 하남시 서하남로 29337.519868127.1715682022-12-07
35우정빌딩 태양광발전소경기도 하남시 대청로 937.539993127.2133612022-12-07

Duplicate rows

Most frequently occurring

발전소명도로명주소위도경도데이터기준일# duplicates
0감북솔라에너지경기도 하남시 서하남로47번길 175-1537.522114127.15462022-12-072