Overview

Dataset statistics

Number of variables5
Number of observations273
Missing cells1
Missing cells (%)0.1%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory11.3 KiB
Average record size in memory42.5 B

Variable types

Numeric2
Text2
Categorical1

Dataset

Description전라남도 목포시 신재생에너지사업 현황에 대하여 상호, 소재지(지번), 영업구분, 설비용량KW의 자료를 정보제공하고 있습니다.
Author전라남도 목포시
URLhttps://www.data.go.kr/data/15029836/fileData.do

Alerts

순번 is highly overall correlated with 영업구분High correlation
영업구분 is highly overall correlated with 순번High correlation
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:40:23.237895
Analysis finished2023-12-12 14:40:24.168140
Duration0.93 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct273
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean137
Minimum1
Maximum273
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.5 KiB
2023-12-12T23:40:24.254211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile14.6
Q169
median137
Q3205
95-th percentile259.4
Maximum273
Range272
Interquartile range (IQR)136

Descriptive statistics

Standard deviation78.952517
Coefficient of variation (CV)0.57629575
Kurtosis-1.2
Mean137
Median Absolute Deviation (MAD)68
Skewness0
Sum37401
Variance6233.5
MonotonicityStrictly increasing
2023-12-12T23:40:24.440470image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.4%
181 1
 
0.4%
187 1
 
0.4%
186 1
 
0.4%
185 1
 
0.4%
184 1
 
0.4%
183 1
 
0.4%
182 1
 
0.4%
180 1
 
0.4%
206 1
 
0.4%
Other values (263) 263
96.3%
ValueCountFrequency (%)
1 1
0.4%
2 1
0.4%
3 1
0.4%
4 1
0.4%
5 1
0.4%
6 1
0.4%
7 1
0.4%
8 1
0.4%
9 1
0.4%
10 1
0.4%
ValueCountFrequency (%)
273 1
0.4%
272 1
0.4%
271 1
0.4%
270 1
0.4%
269 1
0.4%
268 1
0.4%
267 1
0.4%
266 1
0.4%
265 1
0.4%
264 1
0.4%

상호
Text

Distinct266
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
2023-12-12T23:40:24.917567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length26
Median length24
Mean length11.446886
Min length4

Characters and Unicode

Total characters3125
Distinct characters221
Distinct categories7 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique260 ?
Unique (%)95.2%

Sample

1st row석현태양광발전소
2nd rowNH 태양광발전소
3rd row대양 태양광발전소
4th row영재태양광발전소
5th row율도1호 태양광발전소
ValueCountFrequency (%)
태양광발전소 210
35.6%
1호 33
 
5.6%
2호 25
 
4.2%
3호 10
 
1.7%
발전소 6
 
1.0%
지명스포츠 6
 
1.0%
호반eng 6
 
1.0%
대양 4
 
0.7%
목포 4
 
0.7%
나연물류 4
 
0.7%
Other values (237) 282
47.8%
2023-12-12T23:40:25.527857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
317
 
10.1%
전 274
 
8.8%
양 272
 
8.7%
광 271
 
8.7%
발 271
 
8.7%
태 269
 
8.6%
소 269
 
8.6%
호 119
 
3.8%
1 48
 
1.5%
2 39
 
1.2%
Other values (211) 976
31.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2589
82.8%
Space Separator 317
 
10.1%
Decimal Number 127
 
4.1%
Uppercase Letter 52
 
1.7%
Open Punctuation 19
 
0.6%
Close Punctuation 19
 
0.6%
Letter Number 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 274
 
10.6%
양 272
 
10.5%
광 271
 
10.5%
발 271
 
10.5%
태 269
 
10.4%
소 269
 
10.4%
호 119
 
4.6%
지 32
 
1.2%
이 31
 
1.2%
에 26
 
1.0%
Other values (185) 755
29.2%
Uppercase Letter
ValueCountFrequency (%)
M 9
17.3%
G 9
17.3%
N 8
15.4%
E 7
13.5%
H 6
11.5%
Y 4
7.7%
S 3
 
5.8%
J 3
 
5.8%
F 1
 
1.9%
L 1
 
1.9%
Decimal Number
ValueCountFrequency (%)
1 48
37.8%
2 39
30.7%
3 13
 
10.2%
5 7
 
5.5%
4 7
 
5.5%
6 6
 
4.7%
7 3
 
2.4%
8 2
 
1.6%
0 1
 
0.8%
9 1
 
0.8%
Letter Number
ValueCountFrequency (%)
Ⅱ 1
50.0%
Ⅰ 1
50.0%
Space Separator
ValueCountFrequency (%)
317
100.0%
Open Punctuation
ValueCountFrequency (%)
( 19
100.0%
Close Punctuation
ValueCountFrequency (%)
) 19
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2589
82.8%
Common 482
 
15.4%
Latin 54
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 274
 
10.6%
양 272
 
10.5%
광 271
 
10.5%
발 271
 
10.5%
태 269
 
10.4%
소 269
 
10.4%
호 119
 
4.6%
지 32
 
1.2%
이 31
 
1.2%
에 26
 
1.0%
Other values (185) 755
29.2%
Common
ValueCountFrequency (%)
317
65.8%
1 48
 
10.0%
2 39
 
8.1%
( 19
 
3.9%
) 19
 
3.9%
3 13
 
2.7%
5 7
 
1.5%
4 7
 
1.5%
6 6
 
1.2%
7 3
 
0.6%
Other values (3) 4
 
0.8%
Latin
ValueCountFrequency (%)
M 9
16.7%
G 9
16.7%
N 8
14.8%
E 7
13.0%
H 6
11.1%
Y 4
7.4%
S 3
 
5.6%
J 3
 
5.6%
Ⅱ 1
 
1.9%
F 1
 
1.9%
Other values (3) 3
 
5.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2589
82.8%
ASCII 534
 
17.1%
Number Forms 2
 
0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
317
59.4%
1 48
 
9.0%
2 39
 
7.3%
( 19
 
3.6%
) 19
 
3.6%
3 13
 
2.4%
M 9
 
1.7%
G 9
 
1.7%
N 8
 
1.5%
5 7
 
1.3%
Other values (14) 46
 
8.6%
Hangul
ValueCountFrequency (%)
전 274
 
10.6%
양 272
 
10.5%
광 271
 
10.5%
발 271
 
10.5%
태 269
 
10.4%
소 269
 
10.4%
호 119
 
4.6%
지 32
 
1.2%
이 31
 
1.2%
에 26
 
1.0%
Other values (185) 755
29.2%
Number Forms
ValueCountFrequency (%)
Ⅱ 1
50.0%
Ⅰ 1
50.0%

소재지(지번)
Text

Distinct204
Distinct (%)75.0%
Missing1
Missing (%)0.4%
Memory size2.3 KiB
2023-12-12T23:40:25.796385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length42
Mean length25.459559
Min length15

Characters and Unicode

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

Unique

Unique170 ?
Unique (%)62.5%

Sample

1st row전라남도 목포시 영산로 646 (석현동)
2nd row전라남도 목포시 산정동 1420-6
3rd row전라남도 목포시 산정동 1415번지
4th row전라남도 목포시 대양동 산 83번지
5th row전라남도 목포시 율도동 147번지
ValueCountFrequency (%)
전라남도 220
 
14.9%
목포시 193
 
13.1%
대양동 51
 
3.5%
상동 34
 
2.3%
율도동 20
 
1.4%
석현동 19
 
1.3%
산정동 18
 
1.2%
광주광역시 18
 
1.2%
용해동 18
 
1.2%
연산동 17
 
1.2%
Other values (479) 864
58.7%
2023-12-12T23:40:26.238769image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1200
 
17.3%
1 462
 
6.7%
동 329
 
4.8%
시 260
 
3.8%
도 254
 
3.7%
남 237
 
3.4%
전 235
 
3.4%
라 231
 
3.3%
0 214
 
3.1%
포 200
 
2.9%
Other values (215) 3303
47.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 3952
57.1%
Decimal Number 1666
24.1%
Space Separator 1200
 
17.3%
Dash Punctuation 88
 
1.3%
Other Punctuation 9
 
0.1%
Close Punctuation 3
 
< 0.1%
Open Punctuation 3
 
< 0.1%
Lowercase Letter 3
 
< 0.1%
Uppercase Letter 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 329
 
8.3%
시 260
 
6.6%
도 254
 
6.4%
남 237
 
6.0%
전 235
 
5.9%
라 231
 
5.8%
포 200
 
5.1%
목 194
 
4.9%
호 183
 
4.6%
지 163
 
4.1%
Other values (198) 1666
42.2%
Decimal Number
ValueCountFrequency (%)
1 462
27.7%
0 214
12.8%
3 176
 
10.6%
2 171
 
10.3%
5 133
 
8.0%
6 109
 
6.5%
9 108
 
6.5%
7 100
 
6.0%
8 99
 
5.9%
4 94
 
5.6%
Space Separator
ValueCountFrequency (%)
1200
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 88
100.0%
Other Punctuation
ValueCountFrequency (%)
, 9
100.0%
Close Punctuation
ValueCountFrequency (%)
) 3
100.0%
Open Punctuation
ValueCountFrequency (%)
( 3
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 3
100.0%
Uppercase Letter
ValueCountFrequency (%)
S 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 3952
57.1%
Common 2969
42.9%
Latin 4
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 329
 
8.3%
시 260
 
6.6%
도 254
 
6.4%
남 237
 
6.0%
전 235
 
5.9%
라 231
 
5.8%
포 200
 
5.1%
목 194
 
4.9%
호 183
 
4.6%
지 163
 
4.1%
Other values (198) 1666
42.2%
Common
ValueCountFrequency (%)
1200
40.4%
1 462
 
15.6%
0 214
 
7.2%
3 176
 
5.9%
2 171
 
5.8%
5 133
 
4.5%
6 109
 
3.7%
9 108
 
3.6%
7 100
 
3.4%
8 99
 
3.3%
Other values (5) 197
 
6.6%
Latin
ValueCountFrequency (%)
e 3
75.0%
S 1
 
25.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 3952
57.1%
ASCII 2973
42.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1200
40.4%
1 462
 
15.5%
0 214
 
7.2%
3 176
 
5.9%
2 171
 
5.8%
5 133
 
4.5%
6 109
 
3.7%
9 108
 
3.6%
7 100
 
3.4%
8 99
 
3.3%
Other values (7) 201
 
6.8%
Hangul
ValueCountFrequency (%)
동 329
 
8.3%
시 260
 
6.6%
도 254
 
6.4%
남 237
 
6.0%
전 235
 
5.9%
라 231
 
5.8%
포 200
 
5.1%
목 194
 
4.9%
호 183
 
4.6%
지 163
 
4.1%
Other values (198) 1666
42.2%

영업구분
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size2.3 KiB
사업개시
150 
인허가
79 
공사진행
35 
인허가취소
 
9

Length

Max length5
Median length4
Mean length3.7435897
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row사업개시
2nd row사업개시
3rd row사업개시
4th row사업개시
5th row사업개시

Common Values

ValueCountFrequency (%)
사업개시 150
54.9%
인허가 79
28.9%
공사진행 35
 
12.8%
인허가취소 9
 
3.3%

Length

2023-12-12T23:40:26.395015image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:40:26.512264image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사업개시 150
54.9%
인허가 79
28.9%
공사진행 35
 
12.8%
인허가취소 9
 
3.3%

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

Distinct141
Distinct (%)51.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean179.80436
Minimum11.88
Maximum999
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.5 KiB
2023-12-12T23:40:26.664914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum11.88
5-th percentile21.82
Q129.97
median99.2
Q3175.5
95-th percentile719.4
Maximum999
Range987.12
Interquartile range (IQR)145.53

Descriptive statistics

Standard deviation234.64584
Coefficient of variation (CV)1.3050064
Kurtosis4.9518635
Mean179.80436
Median Absolute Deviation (MAD)69.32
Skewness2.330395
Sum49086.59
Variance55058.668
MonotonicityNot monotonic
2023-12-12T23:40:26.807812image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.2 42
 
15.4%
29.7 22
 
8.1%
99.0 15
 
5.5%
999.0 9
 
3.3%
29.75 6
 
2.2%
29.58 6
 
2.2%
99.65 5
 
1.8%
99.19 5
 
1.8%
97.2 5
 
1.8%
99.84 4
 
1.5%
Other values (131) 154
56.4%
ValueCountFrequency (%)
11.88 1
 
0.4%
14.95 1
 
0.4%
14.96 1
 
0.4%
18.0 1
 
0.4%
18.66 1
 
0.4%
19.11 3
1.1%
19.14 1
 
0.4%
19.57 1
 
0.4%
19.74 1
 
0.4%
19.88 1
 
0.4%
ValueCountFrequency (%)
999.0 9
3.3%
998.64 1
 
0.4%
998.55 1
 
0.4%
998.4 1
 
0.4%
998.0 1
 
0.4%
750.0 1
 
0.4%
699.0 1
 
0.4%
684.0 1
 
0.4%
609.43 1
 
0.4%
604.8 1
 
0.4%

Interactions

2023-12-12T23:40:23.799632image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:40:23.589546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:40:23.895367image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:40:23.703295image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:40:26.909625image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번영업구분설비용량(KW)
순번1.0000.7380.328
영업구분0.7381.0000.236
설비용량(KW)0.3280.2361.000
2023-12-12T23:40:27.023833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번설비용량(KW)영업구분
순번1.000-0.3610.539
설비용량(KW)-0.3611.0000.151
영업구분0.5390.1511.000

Missing values

2023-12-12T23:40:24.009930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:40:24.122347image/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석현태양광발전소전라남도 목포시 영산로 646 (석현동)사업개시25.0
12NH 태양광발전소전라남도 목포시 산정동 1420-6사업개시177.5
23대양 태양광발전소전라남도 목포시 산정동 1415번지사업개시29.64
34영재태양광발전소전라남도 목포시 대양동 산 83번지사업개시998.4
45율도1호 태양광발전소전라남도 목포시 율도동 147번지사업개시99.0
56율도2호 태양광발전소전라남도 목포시 율도동 349사업개시99.0
67율도3호 태양광발전사업광주광역시 서구 금호동 809번지 금호5차호반리젠시빌아파트사업개시99.0
78율도4호기 태양광발전소전라남도 목포시 율도동 1472번지사업개시99.0
89율도 5호태양열발전소전라남도 목포시 율도동 113번지 4호사업개시99.0
910이마트 목포 태양광 발전소전라남도 목포시 옥암동 915번지 25호사업개시75.6
순번상호소재지(지번)영업구분설비용량(KW)
263264현대 2호 태양광발전소전라남도 목포시 상동 1004-8인허가99.19
264265MS 1호 태양광발전소전라남도 목포시 상동 1004-8인허가19.11
265266MS 2호 태양광발전소전라남도 목포시 상동 1004-8인허가19.11
266267우성 태양광발전소전라남도 목포시 상동 1004-8인허가29.58
267268이승희 1호 태양광발전소광주광역시 북구 운암동 69 벽산 블루밍 메가씨티 305동인허가99.65
268269보물섬 1호 태양광발전소서울특별시 광진구 자양동 663-13 쉐르빌 501호인허가29.04
269270보물섬 2호 태양광발전소서울특별시 광진구 자양동 663-13 쉐르빌 501호인허가11.88
270271보물섬 3호 태양광발전소서울특별시 광진구 자양동 663-13 쉐르빌 501호인허가29.04
271272MH 3호 태양광발전소전라남도 목포시 상동 578인허가96.8
272273보물창고 3호 태양광발전소광주광역시 남구 백운동 38-9 태광하우스 204호인허가29.04