Overview

Dataset statistics

Number of variables6
Number of observations165
Missing cells52
Missing cells (%)5.3%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.0 KiB
Average record size in memory49.8 B

Variable types

Text2
Numeric1
DateTime3

Dataset

Description경상남도 진주시 소재 태양광발전소의 정보(태양광발전소명, 설비용량, 발전소주소, 최초허가일, 사업개시일)를 제공합니다.
Author경상남도 진주시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15033945

Alerts

기준일자 has constant value ""Constant
사업개시일 has 52 (31.5%) missing valuesMissing

Reproduction

Analysis started2023-12-29 22:16:49.875395
Analysis finished2023-12-29 22:16:53.831822
Duration3.96 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

태양광발전소명
Text

Distinct162
Distinct (%)98.2%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-29T22:16:54.172239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length23
Mean length10.890909
Min length2

Characters and Unicode

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

Unique

Unique159 ?
Unique (%)96.4%

Sample

1st row주식회사 제이에스태양광 발전소
2nd row용진에너지
3rd row소현 태양광발전소
4th row부경 태양광발전소
5th row연화 태양광발전소
ValueCountFrequency (%)
발전소 34
 
11.7%
태양광 34
 
11.7%
태양광발전소 33
 
11.4%
고속도로태양광발전(주 6
 
2.1%
진성태양광발전소 3
 
1.0%
에너지 2
 
0.7%
사봉태양광발전소 2
 
0.7%
송원 2
 
0.7%
신진 2
 
0.7%
주)진수전력 2
 
0.7%
Other values (169) 170
58.6%
2023-12-29T22:16:55.158957image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 167
 
9.3%
전 163
 
9.1%
태 157
 
8.7%
발 157
 
8.7%
양 155
 
8.6%
소 152
 
8.5%
129
 
7.2%
주 31
 
1.7%
진 29
 
1.6%
( 28
 
1.6%
Other values (178) 629
35.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 1561
86.9%
Space Separator 129
 
7.2%
Decimal Number 33
 
1.8%
Open Punctuation 28
 
1.6%
Close Punctuation 28
 
1.6%
Uppercase Letter 10
 
0.6%
Dash Punctuation 5
 
0.3%
Other Punctuation 3
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 167
 
10.7%
전 163
 
10.4%
태 157
 
10.1%
발 157
 
10.1%
양 155
 
9.9%
소 152
 
9.7%
주 31
 
2.0%
진 29
 
1.9%
지 21
 
1.3%
호 16
 
1.0%
Other values (158) 513
32.9%
Uppercase Letter
ValueCountFrequency (%)
K 2
20.0%
M 1
10.0%
H 1
10.0%
S 1
10.0%
G 1
10.0%
N 1
10.0%
E 1
10.0%
O 1
10.0%
D 1
10.0%
Decimal Number
ValueCountFrequency (%)
2 12
36.4%
1 10
30.3%
0 4
 
12.1%
6 3
 
9.1%
4 2
 
6.1%
3 2
 
6.1%
Space Separator
ValueCountFrequency (%)
129
100.0%
Open Punctuation
ValueCountFrequency (%)
( 28
100.0%
Close Punctuation
ValueCountFrequency (%)
) 28
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 5
100.0%
Other Punctuation
ValueCountFrequency (%)
: 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 1561
86.9%
Common 226
 
12.6%
Latin 10
 
0.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 167
 
10.7%
전 163
 
10.4%
태 157
 
10.1%
발 157
 
10.1%
양 155
 
9.9%
소 152
 
9.7%
주 31
 
2.0%
진 29
 
1.9%
지 21
 
1.3%
호 16
 
1.0%
Other values (158) 513
32.9%
Common
ValueCountFrequency (%)
129
57.1%
( 28
 
12.4%
) 28
 
12.4%
2 12
 
5.3%
1 10
 
4.4%
- 5
 
2.2%
0 4
 
1.8%
: 3
 
1.3%
6 3
 
1.3%
4 2
 
0.9%
Latin
ValueCountFrequency (%)
K 2
20.0%
M 1
10.0%
H 1
10.0%
S 1
10.0%
G 1
10.0%
N 1
10.0%
E 1
10.0%
O 1
10.0%
D 1
10.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 1561
86.9%
ASCII 236
 
13.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 167
 
10.7%
전 163
 
10.4%
태 157
 
10.1%
발 157
 
10.1%
양 155
 
9.9%
소 152
 
9.7%
주 31
 
2.0%
진 29
 
1.9%
지 21
 
1.3%
호 16
 
1.0%
Other values (158) 513
32.9%
ASCII
ValueCountFrequency (%)
129
54.7%
( 28
 
11.9%
) 28
 
11.9%
2 12
 
5.1%
1 10
 
4.2%
- 5
 
2.1%
0 4
 
1.7%
: 3
 
1.3%
6 3
 
1.3%
4 2
 
0.8%
Other values (10) 12
 
5.1%

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

Distinct94
Distinct (%)57.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean229.70127
Minimum10
Maximum3315
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.6 KiB
2023-12-29T22:16:55.583519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile18
Q140
median97.2
Q3200
95-th percentile988
Maximum3315
Range3305
Interquartile range (IQR)160

Descriptive statistics

Standard deviation384.15969
Coefficient of variation (CV)1.6724317
Kurtosis25.898599
Mean229.70127
Median Absolute Deviation (MAD)68.2
Skewness4.1656605
Sum37900.71
Variance147578.67
MonotonicityNot monotonic
2023-12-29T22:16:55.982378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 17
 
10.3%
20.0 9
 
5.5%
200.0 4
 
2.4%
98.0 4
 
2.4%
97.0 4
 
2.4%
29.0 4
 
2.4%
1000.0 4
 
2.4%
96.0 4
 
2.4%
18.0 4
 
2.4%
30.0 4
 
2.4%
Other values (84) 107
64.8%
ValueCountFrequency (%)
10.0 2
1.2%
12.0 1
 
0.6%
14.0 1
 
0.6%
14.6 1
 
0.6%
15.0 1
 
0.6%
17.0 1
 
0.6%
17.28 1
 
0.6%
18.0 4
2.4%
19.0 1
 
0.6%
19.04 1
 
0.6%
ValueCountFrequency (%)
3315.0 1
 
0.6%
1624.0 1
 
0.6%
1311.0 1
 
0.6%
1000.0 4
2.4%
995.0 2
1.2%
960.0 2
1.2%
925.0 1
 
0.6%
905.0 1
 
0.6%
815.0 1
 
0.6%
800.0 3
1.8%

발전소주소
Text

Distinct159
Distinct (%)96.4%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
2023-12-29T22:16:56.575249image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length43
Median length31
Mean length23.969697
Min length14

Characters and Unicode

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

Unique

Unique153 ?
Unique (%)92.7%

Sample

1st row경상남도 진주시 진성면 진성로276번길 278
2nd row경상남도 진주시 솔밭로31번길 7 (상평동)
3rd row경상남도 진주시 대신로 181 (상평동)
4th row경상남도 진주시 진성면 동부로1307번길 24
5th row경상남도 진주시 의병로111번길 5-13 (상봉동, 연화빌라)
ValueCountFrequency (%)
진주시 164
 
19.2%
경상남도 138
 
16.2%
금산면 16
 
1.9%
문산읍 15
 
1.8%
집현면 11
 
1.3%
산 11
 
1.3%
진성면 10
 
1.2%
상평동 10
 
1.2%
지수면 10
 
1.2%
상대동 9
 
1.1%
Other values (312) 460
53.9%
2023-12-29T22:16:57.601514image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
691
 
17.5%
진 199
 
5.0%
주 173
 
4.4%
상 168
 
4.2%
시 164
 
4.1%
1 151
 
3.8%
남 147
 
3.7%
도 144
 
3.6%
경 143
 
3.6%
면 108
 
2.7%
Other values (134) 1867
47.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2356
59.6%
Decimal Number 720
 
18.2%
Space Separator 691
 
17.5%
Close Punctuation 56
 
1.4%
Open Punctuation 56
 
1.4%
Dash Punctuation 54
 
1.4%
Other Punctuation 20
 
0.5%
Uppercase Letter 2
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
진 199
 
8.4%
주 173
 
7.3%
상 168
 
7.1%
시 164
 
7.0%
남 147
 
6.2%
도 144
 
6.1%
경 143
 
6.1%
면 108
 
4.6%
번 92
 
3.9%
로 88
 
3.7%
Other values (116) 930
39.5%
Decimal Number
ValueCountFrequency (%)
1 151
21.0%
2 100
13.9%
3 74
10.3%
6 73
10.1%
7 67
9.3%
9 66
9.2%
5 55
 
7.6%
4 54
 
7.5%
8 45
 
6.2%
0 35
 
4.9%
Other Punctuation
ValueCountFrequency (%)
, 19
95.0%
. 1
 
5.0%
Uppercase Letter
ValueCountFrequency (%)
H 1
50.0%
I 1
50.0%
Space Separator
ValueCountFrequency (%)
691
100.0%
Close Punctuation
ValueCountFrequency (%)
) 56
100.0%
Open Punctuation
ValueCountFrequency (%)
( 56
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 54
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2356
59.6%
Common 1597
40.4%
Latin 2
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
진 199
 
8.4%
주 173
 
7.3%
상 168
 
7.1%
시 164
 
7.0%
남 147
 
6.2%
도 144
 
6.1%
경 143
 
6.1%
면 108
 
4.6%
번 92
 
3.9%
로 88
 
3.7%
Other values (116) 930
39.5%
Common
ValueCountFrequency (%)
691
43.3%
1 151
 
9.5%
2 100
 
6.3%
3 74
 
4.6%
6 73
 
4.6%
7 67
 
4.2%
9 66
 
4.1%
) 56
 
3.5%
( 56
 
3.5%
5 55
 
3.4%
Other values (6) 208
 
13.0%
Latin
ValueCountFrequency (%)
H 1
50.0%
I 1
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2356
59.6%
ASCII 1599
40.4%

Most frequent character per block

ASCII
ValueCountFrequency (%)
691
43.2%
1 151
 
9.4%
2 100
 
6.3%
3 74
 
4.6%
6 73
 
4.6%
7 67
 
4.2%
9 66
 
4.1%
) 56
 
3.5%
( 56
 
3.5%
5 55
 
3.4%
Other values (8) 210
 
13.1%
Hangul
ValueCountFrequency (%)
진 199
 
8.4%
주 173
 
7.3%
상 168
 
7.1%
시 164
 
7.0%
남 147
 
6.2%
도 144
 
6.1%
경 143
 
6.1%
면 108
 
4.6%
번 92
 
3.9%
로 88
 
3.7%
Other values (116) 930
39.5%

최초허가일
Date

Distinct113
Distinct (%)68.5%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2007-01-10 00:00:00
Maximum2018-10-29 00:00:00
2023-12-29T22:16:57.918505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-29T22:16:58.327958image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Date

MISSING 

Distinct94
Distinct (%)83.2%
Missing52
Missing (%)31.5%
Memory size1.4 KiB
Minimum2007-11-15 00:00:00
Maximum2018-10-26 00:00:00
2023-12-29T22:16:58.685949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-29T22:16:59.151693image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.6%
Missing0
Missing (%)0.0%
Memory size1.4 KiB
Minimum2018-11-06 00:00:00
Maximum2018-11-06 00:00:00
2023-12-29T22:16:59.368188image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-29T22:16:59.555322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-29T22:16:52.994984image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-29T22:16:59.777960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설비용량(KW)사업개시일
설비용량(KW)1.0001.000
사업개시일1.0001.000

Missing values

2023-12-29T22:16:53.352797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-29T22:16:53.696569image/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주식회사 제이에스태양광 발전소395.28경상남도 진주시 진성면 진성로276번길 2782018-10-29<NA>2018-11-06
1용진에너지76.65경상남도 진주시 솔밭로31번길 7 (상평동)2018-10-25<NA>2018-11-06
2소현 태양광발전소19.04경상남도 진주시 대신로 181 (상평동)2018-10-25<NA>2018-11-06
3부경 태양광발전소92.16경상남도 진주시 진성면 동부로1307번길 242018-10-25<NA>2018-11-06
4연화 태양광발전소14.6경상남도 진주시 의병로111번길 5-13 (상봉동, 연화빌라)2018-10-23<NA>2018-11-06
5세영 태양광발전소85.68경상남도 진주시 집현면 진산로 9412018-10-19<NA>2018-11-06
6명진철강 태양광발전소198.32경상남도 진주시 공단로 58 (상평동)2018-10-17<NA>2018-11-06
7(주)호산 태양광 발전소1호335.07경상남도 진주시 진성면 동부로1259번길 25-192018-10-02<NA>2018-11-06
8마실 태양광 발전소795.6경상남도 진주시 수곡면 사곡리 산1번지2018-09-21<NA>2018-11-06
9경남직물진주실크공업협동조합 태양광발전소198.9경상남도 진주시 문산읍 월아산로 996번길 432018-09-13<NA>2018-11-06
태양광발전소명설비용량(KW)발전소주소최초허가일사업개시일기준일자
155정광태양광발전소29.0경상남도 진주시 금산면 속사길 23-32008-08-122008-09-252018-11-06
156진우태양광발전소30.0경상남도 진주시 진주대로 1417 (이현동)2008-03-042009-12-032018-11-06
157광명태양광발전소28.0경상남도 진주시 금산면 속사길 912008-02-122008-07-252018-11-06
158대광태양광발전소28.0경상남도 진주시 금산면 속사길 772008-02-122008-07-252018-11-06
159이대식태양광발전소20.0경상남도 진주시 금산면 속사길57번길 82007-11-052008-05-282018-11-06
160진주태양광발전소(법인명:(주)진주태양광발전소)1000.0경상남도 진주시 사봉면 봉곡리 산 222번지 8호 , 1145-22007-10-022009-08-172018-11-06
161진수전력태양광발전소 (법인명 :(주)진수전력)1000.0경상남도 진주시 수곡면 효자리 산 26번지 , 산27번지2007-09-03<NA>2018-11-06
162임용택태양광발전소10.0경상남도 진주시 진양호로97번길 19-17 (평거동)2007-06-132007-11-152018-11-06
163신한태양광발전소134.0경상남도 진주시 명석면 외율리 산 136번지 8호2007-04-022009-11-092018-11-06
164광발전(주)99.0경상남도 진주시 정촌면 예상리 산 13번지2007-01-102009-11-012018-11-06