Overview

Dataset statistics

Number of variables10
Number of observations79
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory6.6 KiB
Average record size in memory85.7 B

Variable types

Numeric2
Text2
Categorical4
DateTime2

Dataset

Description통영시 관내 태양광발전설치현황에 대한 허가일자,사업개시일자,공사계획신고일자,상호(발전소명),소재지 도로명주소,소재지 지번주소,설비용량(kW),공급전압(V),주파수(Hz),사업상태 정보를 제공합니다.
Author경상남도 통영시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15034040

Alerts

영업구분 has constant value ""Constant
원동력의종류 has constant value ""Constant
주파수(헤르츠) has constant value ""Constant
순번 is highly overall correlated with 공급전압(볼트)High correlation
설비용량(킬로와트) is highly overall correlated with 공급전압(볼트)High correlation
공급전압(볼트) is highly overall correlated with 순번 and 1 other fieldsHigh correlation
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-10 23:41:51.952626
Analysis finished2023-12-10 23:41:53.108229
Duration1.16 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct79
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean40.202532
Minimum1
Maximum80
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size843.0 B
2023-12-11T08:41:53.182098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile4.9
Q120.5
median40
Q359.5
95-th percentile76.1
Maximum80
Range79
Interquartile range (IQR)39

Descriptive statistics

Standard deviation23.232592
Coefficient of variation (CV)0.57788878
Kurtosis-1.1874652
Mean40.202532
Median Absolute Deviation (MAD)20
Skewness0.02579871
Sum3176
Variance539.75333
MonotonicityStrictly increasing
2023-12-11T08:41:53.335534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
1.3%
2 1
 
1.3%
59 1
 
1.3%
58 1
 
1.3%
57 1
 
1.3%
56 1
 
1.3%
55 1
 
1.3%
54 1
 
1.3%
53 1
 
1.3%
52 1
 
1.3%
Other values (69) 69
87.3%
ValueCountFrequency (%)
1 1
1.3%
2 1
1.3%
3 1
1.3%
4 1
1.3%
5 1
1.3%
6 1
1.3%
7 1
1.3%
8 1
1.3%
9 1
1.3%
10 1
1.3%
ValueCountFrequency (%)
80 1
1.3%
79 1
1.3%
78 1
1.3%
77 1
1.3%
76 1
1.3%
75 1
1.3%
74 1
1.3%
73 1
1.3%
72 1
1.3%
71 1
1.3%

상호
Text

Distinct77
Distinct (%)97.5%
Missing0
Missing (%)0.0%
Memory size764.0 B
2023-12-11T08:41:53.630507image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length26
Mean length11.329114
Min length7

Characters and Unicode

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

Unique

Unique75 ?
Unique (%)94.9%

Sample

1st row양복열 태양광발전소
2nd row원산 태양광발전소
3rd row청명 태양광발전소
4th row연화1호 태양광발전소
5th row가온태양광발전소
ValueCountFrequency (%)
태양광발전소 39
31.7%
태양도산발전소 2
 
1.6%
원평 2
 
1.6%
연명태양광발전소 2
 
1.6%
장군태양광발전소1 1
 
0.8%
진주빌 1
 
0.8%
동백태양광발전소 1
 
0.8%
황리프라임발전소 1
 
0.8%
장평태양광발전소 1
 
0.8%
태원태양광발전소 1
 
0.8%
Other values (72) 72
58.5%
2023-12-11T08:41:54.157884image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
양 81
 
9.1%
태 79
 
8.8%
소 79
 
8.8%
광 78
 
8.7%
발 78
 
8.7%
전 78
 
8.7%
44
 
4.9%
이 24
 
2.7%
호 22
 
2.5%
에 21
 
2.3%
Other values (104) 311
34.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 762
85.1%
Decimal Number 47
 
5.3%
Space Separator 44
 
4.9%
Lowercase Letter 20
 
2.2%
Dash Punctuation 12
 
1.3%
Close Punctuation 5
 
0.6%
Open Punctuation 5
 
0.6%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
양 81
10.6%
태 79
 
10.4%
소 79
 
10.4%
광 78
 
10.2%
발 78
 
10.2%
전 78
 
10.2%
이 24
 
3.1%
호 22
 
2.9%
에 21
 
2.8%
스 20
 
2.6%
Other values (85) 202
26.5%
Decimal Number
ValueCountFrequency (%)
1 20
42.6%
2 8
 
17.0%
6 6
 
12.8%
3 5
 
10.6%
5 2
 
4.3%
0 2
 
4.3%
7 1
 
2.1%
8 1
 
2.1%
9 1
 
2.1%
4 1
 
2.1%
Lowercase Letter
ValueCountFrequency (%)
o 4
20.0%
k 4
20.0%
e 4
20.0%
p 4
20.0%
c 4
20.0%
Space Separator
ValueCountFrequency (%)
44
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 12
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 762
85.1%
Common 113
 
12.6%
Latin 20
 
2.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
양 81
10.6%
태 79
 
10.4%
소 79
 
10.4%
광 78
 
10.2%
발 78
 
10.2%
전 78
 
10.2%
이 24
 
3.1%
호 22
 
2.9%
에 21
 
2.8%
스 20
 
2.6%
Other values (85) 202
26.5%
Common
ValueCountFrequency (%)
44
38.9%
1 20
17.7%
- 12
 
10.6%
2 8
 
7.1%
6 6
 
5.3%
3 5
 
4.4%
) 5
 
4.4%
( 5
 
4.4%
5 2
 
1.8%
0 2
 
1.8%
Other values (4) 4
 
3.5%
Latin
ValueCountFrequency (%)
o 4
20.0%
k 4
20.0%
e 4
20.0%
p 4
20.0%
c 4
20.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 762
85.1%
ASCII 133
 
14.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
양 81
10.6%
태 79
 
10.4%
소 79
 
10.4%
광 78
 
10.2%
발 78
 
10.2%
전 78
 
10.2%
이 24
 
3.1%
호 22
 
2.9%
에 21
 
2.8%
스 20
 
2.6%
Other values (85) 202
26.5%
ASCII
ValueCountFrequency (%)
44
33.1%
1 20
15.0%
- 12
 
9.0%
2 8
 
6.0%
6 6
 
4.5%
3 5
 
3.8%
) 5
 
3.8%
( 5
 
3.8%
o 4
 
3.0%
k 4
 
3.0%
Other values (9) 20
15.0%

설치장소소재지
Text

Distinct61
Distinct (%)77.2%
Missing0
Missing (%)0.0%
Memory size764.0 B
2023-12-11T08:41:54.521460image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length46
Median length34
Mean length24.063291
Min length18

Characters and Unicode

Total characters1901
Distinct characters129
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

Unique57 ?
Unique (%)72.2%

Sample

1st row경상남도 통영시 정동1길 12, 신나리모텔 (정량동)
2nd row경상남도 통영시 도산면 원동길 30-62
3rd row경상남도 통영시 미나리4길 26-7(무전동)
4th row경상남도 통영시 욕지면 십리골길 1-6
5th row경상남도 통영시 도산면 법송3길 54-25
ValueCountFrequency (%)
통영시 80
19.1%
경상남도 79
18.9%
광도면 25
 
6.0%
황리 20
 
4.8%
1661 16
 
3.8%
산양읍 14
 
3.3%
도산면 12
 
2.9%
용남면 7
 
1.7%
욕지면 7
 
1.7%
도산일주로 5
 
1.2%
Other values (121) 154
36.8%
2023-12-11T08:41:54.952836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
340
17.9%
도 123
 
6.5%
남 97
 
5.1%
1 86
 
4.5%
통 82
 
4.3%
영 82
 
4.3%
시 80
 
4.2%
경 79
 
4.2%
상 79
 
4.2%
6 60
 
3.2%
Other values (119) 793
41.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1170
61.5%
Space Separator 340
 
17.9%
Decimal Number 306
 
16.1%
Dash Punctuation 29
 
1.5%
Other Punctuation 22
 
1.2%
Close Punctuation 17
 
0.9%
Open Punctuation 17
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
도 123
 
10.5%
남 97
 
8.3%
통 82
 
7.0%
영 82
 
7.0%
시 80
 
6.8%
경 79
 
6.8%
상 79
 
6.8%
면 53
 
4.5%
산 42
 
3.6%
리 37
 
3.2%
Other values (104) 416
35.6%
Decimal Number
ValueCountFrequency (%)
1 86
28.1%
6 60
19.6%
2 29
 
9.5%
3 25
 
8.2%
9 24
 
7.8%
4 22
 
7.2%
5 19
 
6.2%
0 17
 
5.6%
7 13
 
4.2%
8 11
 
3.6%
Space Separator
ValueCountFrequency (%)
340
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 29
100.0%
Other Punctuation
ValueCountFrequency (%)
, 22
100.0%
Close Punctuation
ValueCountFrequency (%)
) 17
100.0%
Open Punctuation
ValueCountFrequency (%)
( 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1170
61.5%
Common 731
38.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
도 123
 
10.5%
남 97
 
8.3%
통 82
 
7.0%
영 82
 
7.0%
시 80
 
6.8%
경 79
 
6.8%
상 79
 
6.8%
면 53
 
4.5%
산 42
 
3.6%
리 37
 
3.2%
Other values (104) 416
35.6%
Common
ValueCountFrequency (%)
340
46.5%
1 86
 
11.8%
6 60
 
8.2%
2 29
 
4.0%
- 29
 
4.0%
3 25
 
3.4%
9 24
 
3.3%
, 22
 
3.0%
4 22
 
3.0%
5 19
 
2.6%
Other values (5) 75
 
10.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1170
61.5%
ASCII 731
38.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
340
46.5%
1 86
 
11.8%
6 60
 
8.2%
2 29
 
4.0%
- 29
 
4.0%
3 25
 
3.4%
9 24
 
3.3%
, 22
 
3.0%
4 22
 
3.0%
5 19
 
2.6%
Other values (5) 75
 
10.3%
Hangul
ValueCountFrequency (%)
도 123
 
10.5%
남 97
 
8.3%
통 82
 
7.0%
영 82
 
7.0%
시 80
 
6.8%
경 79
 
6.8%
상 79
 
6.8%
면 53
 
4.5%
산 42
 
3.6%
리 37
 
3.2%
Other values (104) 416
35.6%

영업구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size764.0 B
사업개시
79 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
사업개시 79
100.0%

Length

2023-12-11T08:41:55.104048image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:41:55.206575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사업개시 79
100.0%

원동력의종류
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size764.0 B
태양광
79 

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 (%)
태양광 79
100.0%

Length

2023-12-11T08:41:55.305216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:41:55.392945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
태양광 79
100.0%

설비용량(킬로와트)
Real number (ℝ)

HIGH CORRELATION 

Distinct54
Distinct (%)68.4%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean310.16127
Minimum8.97
Maximum999.18
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size843.0 B
2023-12-11T08:41:55.503131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum8.97
5-th percentile14.765
Q128.925
median71.68
Q3749.79
95-th percentile999.18
Maximum999.18
Range990.21
Interquartile range (IQR)720.865

Descriptive statistics

Standard deviation413.006
Coefficient of variation (CV)1.3315847
Kurtosis-0.90336235
Mean310.16127
Median Absolute Deviation (MAD)51.88
Skewness1.0182977
Sum24502.74
Variance170573.96
MonotonicityNot monotonic
2023-12-11T08:41:55.669131image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
999.18 19
24.1%
24.0 3
 
3.8%
699.69 2
 
2.5%
46.08 2
 
2.5%
98.28 2
 
2.5%
19.09 2
 
2.5%
30.0 2
 
2.5%
39.6 1
 
1.3%
90.45 1
 
1.3%
20.4 1
 
1.3%
Other values (44) 44
55.7%
ValueCountFrequency (%)
8.97 1
1.3%
12.6 1
1.3%
13.65 1
1.3%
14.0 1
1.3%
14.85 1
1.3%
18.0 1
1.3%
18.36 1
1.3%
18.53 1
1.3%
18.6 1
1.3%
19.09 2
2.5%
ValueCountFrequency (%)
999.18 19
24.1%
799.89 1
 
1.3%
699.69 2
 
2.5%
200.0 1
 
1.3%
198.0 1
 
1.3%
180.0 1
 
1.3%
149.1 1
 
1.3%
133.88 1
 
1.3%
117.03 1
 
1.3%
99.9 1
 
1.3%

공급전압(볼트)
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.8%
Missing0
Missing (%)0.0%
Memory size764.0 B
380
50 
22900
21 
220
8 

Length

Max length5
Median length3
Mean length3.5316456
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
380 50
63.3%
22900 21
26.6%
220 8
 
10.1%

Length

2023-12-11T08:41:55.810898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:41:55.928028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
380 50
63.3%
22900 21
26.6%
220 8
 
10.1%

주파수(헤르츠)
Categorical

CONSTANT 

Distinct1
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size764.0 B
60
79 

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 79
100.0%

Length

2023-12-11T08:41:56.043892image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:41:56.181677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
60 79
100.0%

허가일자
Date

Distinct49
Distinct (%)62.0%
Missing0
Missing (%)0.0%
Memory size764.0 B
Minimum2010-03-15 00:00:00
Maximum2021-12-09 00:00:00
2023-12-11T08:41:56.344914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:41:56.523468image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=49)

사업개시일
Date

Distinct52
Distinct (%)65.8%
Missing0
Missing (%)0.0%
Memory size764.0 B
Minimum2011-01-13 00:00:00
Maximum2022-09-15 00:00:00
2023-12-11T08:41:56.703519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:41:56.897911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2023-12-11T08:41:52.661584image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:41:52.470825image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:41:52.759418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:41:52.571183image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-11T08:41:57.009332image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번상호설치장소소재지설비용량(킬로와트)공급전압(볼트)허가일자사업개시일
순번1.0001.0000.8990.8190.7680.9390.943
상호1.0001.0000.9371.0000.9181.0001.000
설치장소소재지0.8990.9371.0001.0001.0001.0000.999
설비용량(킬로와트)0.8191.0001.0001.0000.7010.8260.720
공급전압(볼트)0.7680.9181.0000.7011.0000.9850.984
허가일자0.9391.0001.0000.8260.9851.0000.999
사업개시일0.9431.0000.9990.7200.9840.9991.000
2023-12-11T08:41:57.149111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번설비용량(킬로와트)공급전압(볼트)
순번1.000-0.3740.615
설비용량(킬로와트)-0.3741.0000.674
공급전압(볼트)0.6150.6741.000

Missing values

2023-12-11T08:41:52.871070image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:41:53.044003image/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

순번상호설치장소소재지영업구분원동력의종류설비용량(킬로와트)공급전압(볼트)주파수(헤르츠)허가일자사업개시일
01양복열 태양광발전소경상남도 통영시 정동1길 12, 신나리모텔 (정량동)사업개시태양광29.76380602021-12-092022-09-15
12원산 태양광발전소경상남도 통영시 도산면 원동길 30-62사업개시태양광18.53380602021-11-042022-06-16
23청명 태양광발전소경상남도 통영시 미나리4길 26-7(무전동)사업개시태양광19.56380602021-09-082021-12-22
34연화1호 태양광발전소경상남도 통영시 욕지면 십리골길 1-6사업개시태양광29.96380602021-07-082021-10-06
45가온태양광발전소경상남도 통영시 도산면 법송3길 54-25사업개시태양광48.96380602021-06-162021-11-05
56에스케이피씨3호 태양광발전소경상남도 통영시 광도면 황리 1622사업개시태양광999.1822900602021-03-252022-01-14
67에스케이피씨1호 태양광발전소경상남도 통영시 광도면 황리 1621사업개시태양광999.1822900602021-03-252022-01-14
78에스케이피비3호 태양광발전소경상남도 통영시 광도면 황리 1661사업개시태양광999.1822900602021-03-252022-01-14
89에스케이피비2호 태양광발전소경상남도 통영시 광도면 황리 1661사업개시태양광999.1822900602021-03-252022-01-14
910에스케이피비1호 태양광발전소경상남도 통영시 광도면 황리 1661사업개시태양광999.1822900602021-03-252022-01-14
순번상호설치장소소재지영업구분원동력의종류설비용량(킬로와트)공급전압(볼트)주파수(헤르츠)허가일자사업개시일
6971장군태양광발전소2경상남도 통영시 산양읍 장군봉문개길 178, (주)동남무역사업개시태양광62.79380602014-08-142015-02-02
7072장군태양광발전소1경상남도 통영시 산양읍 장군봉문개길 191사업개시태양광8.97380602014-08-142015-02-02
7173제이와이태양광발전소경상남도 통영시 도산면 도산일주로 1509사업개시태양광69.42380602014-05-082014-09-05
7274덕영2호태양광발전소경상남도 통영시 도산면 남해안대로 1461사업개시태양광19.8380602014-02-182014-04-21
7375일주태양광발전소경상남도 통영시 산양읍 산양일주로 1697, (주)지앤아이사업개시태양광39.6380602013-11-132013-12-20
7476경임태양광발전소경상남도 통영시 항남1길 25, 해광국기사 (항남동)사업개시태양광29.4380602013-09-232014-01-14
7577천보태양광발전소경상남도 통영시 중앙로 129, 천보빌딩 (항남동)사업개시태양광21.6220602013-04-102018-05-14
7678(주)이마트통영태양광발전소경상남도 통영시 광도면 죽림4로 9, 이마트통영점사업개시태양광72.8380602012-08-092014-04-30
7779국제태양광발전소경상남도 통영시 용남면 화포1길 59-83사업개시태양광30.0380602012-06-252012-09-03
7880롯데쇼핑(주) 통영태양광경상남도 통영시 무전대로 65, 롯데마트통영점 (무전동)사업개시태양광99.25380602010-03-152011-01-13