Overview

Dataset statistics

Number of variables7
Number of observations525
Missing cells6
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory29.9 KiB
Average record size in memory58.3 B

Variable types

Numeric2
Text2
DateTime3

Dataset

Description전라남도 영광군의 태양광발전소인허가현황 데이터로 연번, 상호명(발전소명), 소재지 주소, 설비용량(KW), 발전사업허가일, 사업개시일, 데이터기준일자가 있습니다.
URLhttps://www.data.go.kr/data/15113332/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
사업개시일 has 6 (1.1%) missing valuesMissing
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:25:47.399046
Analysis finished2023-12-12 05:25:48.508654
Duration1.11 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct525
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean263
Minimum1
Maximum525
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.7 KiB
2023-12-12T14:25:48.588597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile27.2
Q1132
median263
Q3394
95-th percentile498.8
Maximum525
Range524
Interquartile range (IQR)262

Descriptive statistics

Standard deviation151.69871
Coefficient of variation (CV)0.5768012
Kurtosis-1.2
Mean263
Median Absolute Deviation (MAD)131
Skewness0
Sum138075
Variance23012.5
MonotonicityStrictly increasing
2023-12-12T14:25:48.759422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
362 1
 
0.2%
360 1
 
0.2%
359 1
 
0.2%
358 1
 
0.2%
357 1
 
0.2%
356 1
 
0.2%
355 1
 
0.2%
354 1
 
0.2%
353 1
 
0.2%
Other values (515) 515
98.1%
ValueCountFrequency (%)
1 1
0.2%
2 1
0.2%
3 1
0.2%
4 1
0.2%
5 1
0.2%
6 1
0.2%
7 1
0.2%
8 1
0.2%
9 1
0.2%
10 1
0.2%
ValueCountFrequency (%)
525 1
0.2%
524 1
0.2%
523 1
0.2%
522 1
0.2%
521 1
0.2%
520 1
0.2%
519 1
0.2%
518 1
0.2%
517 1
0.2%
516 1
0.2%

상호명
Text

Distinct518
Distinct (%)98.7%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2023-12-12T14:25:49.238477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length27
Mean length12.091429
Min length4

Characters and Unicode

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

Unique

Unique513 ?
Unique (%)97.7%

Sample

1st row경인 태양광발전소
2nd row해오름 태양광발전소
3rd row한길 태양광발전소
4th row효은 태양광발전소
5th row월촌 태양광발전소
ValueCountFrequency (%)
태양광발전소 378
39.1%
태양광발전소2호 10
 
1.0%
발전소 7
 
0.7%
에덴 6
 
0.6%
태양광발전소3호 6
 
0.6%
월계농장 6
 
0.6%
성대 5
 
0.5%
송림 4
 
0.4%
태양광 4
 
0.4%
명성 4
 
0.4%
Other values (513) 537
55.5%
2023-12-12T14:25:49.899667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
광 522
 
8.2%
전 493
 
7.8%
태 491
 
7.7%
양 491
 
7.7%
발 491
 
7.7%
소 487
 
7.7%
442
 
7.0%
( 194
 
3.1%
) 193
 
3.0%
에 152
 
2.4%
Other values (287) 2392
37.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 5269
83.0%
Space Separator 442
 
7.0%
Open Punctuation 221
 
3.5%
Close Punctuation 220
 
3.5%
Decimal Number 183
 
2.9%
Uppercase Letter 10
 
0.2%
Other Symbol 2
 
< 0.1%
Letter Number 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 522
 
9.9%
전 493
 
9.4%
태 491
 
9.3%
양 491
 
9.3%
발 491
 
9.3%
소 487
 
9.2%
에 152
 
2.9%
호 146
 
2.8%
지 135
 
2.6%
너 117
 
2.2%
Other values (266) 1744
33.1%
Decimal Number
ValueCountFrequency (%)
2 63
34.4%
1 46
25.1%
3 29
15.8%
4 19
 
10.4%
5 9
 
4.9%
6 7
 
3.8%
7 4
 
2.2%
9 2
 
1.1%
8 2
 
1.1%
0 2
 
1.1%
Uppercase Letter
ValueCountFrequency (%)
L 3
30.0%
S 3
30.0%
J 2
20.0%
K 2
20.0%
Open Punctuation
ValueCountFrequency (%)
( 194
87.8%
[ 27
 
12.2%
Close Punctuation
ValueCountFrequency (%)
) 193
87.7%
] 27
 
12.3%
Space Separator
ValueCountFrequency (%)
442
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 2
100.0%
Letter Number
ValueCountFrequency (%)
Ⅰ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 5271
83.0%
Common 1066
 
16.8%
Latin 11
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 522
 
9.9%
전 493
 
9.4%
태 491
 
9.3%
양 491
 
9.3%
발 491
 
9.3%
소 487
 
9.2%
에 152
 
2.9%
호 146
 
2.8%
지 135
 
2.6%
너 117
 
2.2%
Other values (267) 1746
33.1%
Common
ValueCountFrequency (%)
442
41.5%
( 194
18.2%
) 193
18.1%
2 63
 
5.9%
1 46
 
4.3%
3 29
 
2.7%
] 27
 
2.5%
[ 27
 
2.5%
4 19
 
1.8%
5 9
 
0.8%
Other values (5) 17
 
1.6%
Latin
ValueCountFrequency (%)
L 3
27.3%
S 3
27.3%
J 2
18.2%
K 2
18.2%
Ⅰ 1
 
9.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 5269
83.0%
ASCII 1076
 
17.0%
None 2
 
< 0.1%
Number Forms 1
 
< 0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
광 522
 
9.9%
전 493
 
9.4%
태 491
 
9.3%
양 491
 
9.3%
발 491
 
9.3%
소 487
 
9.2%
에 152
 
2.9%
호 146
 
2.8%
지 135
 
2.6%
너 117
 
2.2%
Other values (266) 1744
33.1%
ASCII
ValueCountFrequency (%)
442
41.1%
( 194
18.0%
) 193
17.9%
2 63
 
5.9%
1 46
 
4.3%
3 29
 
2.7%
] 27
 
2.5%
[ 27
 
2.5%
4 19
 
1.8%
5 9
 
0.8%
Other values (9) 27
 
2.5%
None
ValueCountFrequency (%)
㈜ 2
100.0%
Number Forms
ValueCountFrequency (%)
Ⅰ 1
100.0%

소재지 주소
Text

Distinct153
Distinct (%)29.1%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
2023-12-12T14:25:50.167536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length16
Mean length16.495238
Min length16

Characters and Unicode

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

Unique

Unique69 ?
Unique (%)13.1%

Sample

1st row전라남도 영광군 법성면 굴비로4길
2nd row전라남도 영광군 군남면 월죽로3길
3rd row전라남도 영광군 법성면 용성월산로1길
4th row전라남도 영광군 법성면 용성월산로1길
5th row전라남도 영광군 법성면 용성월산로
ValueCountFrequency (%)
전라남도 525
25.0%
영광군 525
25.0%
염산면 116
 
5.5%
영광읍 78
 
3.7%
백수읍 69
 
3.3%
법성면 68
 
3.2%
봉남리 57
 
2.7%
군서면 56
 
2.7%
군남면 47
 
2.2%
하사리 39
 
1.9%
Other values (141) 521
24.8%
2023-12-12T14:25:50.624328image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1615
18.6%
남 659
 
7.6%
군 633
 
7.3%
영 632
 
7.3%
광 608
 
7.0%
전 527
 
6.1%
도 525
 
6.1%
라 525
 
6.1%
면 341
 
3.9%
리 305
 
3.5%
Other values (107) 2290
26.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 6965
80.4%
Space Separator 1615
 
18.6%
Decimal Number 80
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
남 659
 
9.5%
군 633
 
9.1%
영 632
 
9.1%
광 608
 
8.7%
전 527
 
7.6%
도 525
 
7.5%
라 525
 
7.5%
면 341
 
4.9%
리 305
 
4.4%
읍 187
 
2.7%
Other values (97) 2023
29.0%
Decimal Number
ValueCountFrequency (%)
1 18
22.5%
3 13
16.2%
9 13
16.2%
2 12
15.0%
5 8
10.0%
4 6
 
7.5%
7 5
 
6.2%
6 4
 
5.0%
8 1
 
1.2%
Space Separator
ValueCountFrequency (%)
1615
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 6965
80.4%
Common 1695
 
19.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
남 659
 
9.5%
군 633
 
9.1%
영 632
 
9.1%
광 608
 
8.7%
전 527
 
7.6%
도 525
 
7.5%
라 525
 
7.5%
면 341
 
4.9%
리 305
 
4.4%
읍 187
 
2.7%
Other values (97) 2023
29.0%
Common
ValueCountFrequency (%)
1615
95.3%
1 18
 
1.1%
3 13
 
0.8%
9 13
 
0.8%
2 12
 
0.7%
5 8
 
0.5%
4 6
 
0.4%
7 5
 
0.3%
6 4
 
0.2%
8 1
 
0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 6965
80.4%
ASCII 1695
 
19.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1615
95.3%
1 18
 
1.1%
3 13
 
0.8%
9 13
 
0.8%
2 12
 
0.7%
5 8
 
0.5%
4 6
 
0.4%
7 5
 
0.3%
6 4
 
0.2%
8 1
 
0.1%
Hangul
ValueCountFrequency (%)
남 659
 
9.5%
군 633
 
9.1%
영 632
 
9.1%
광 608
 
8.7%
전 527
 
7.6%
도 525
 
7.5%
라 525
 
7.5%
면 341
 
4.9%
리 305
 
4.4%
읍 187
 
2.7%
Other values (97) 2023
29.0%

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

Distinct222
Distinct (%)42.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean320.1485
Minimum10
Maximum3024
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.7 KiB
2023-12-12T14:25:50.774998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10
5-th percentile20.98
Q197.2
median99.9
Q3496.64
95-th percentile999
Maximum3024
Range3014
Interquartile range (IQR)399.44

Descriptive statistics

Standard deviation363.83545
Coefficient of variation (CV)1.1364584
Kurtosis5.0607996
Mean320.1485
Median Absolute Deviation (MAD)70.5
Skewness1.7365176
Sum168077.96
Variance132376.23
MonotonicityNot monotonic
2023-12-12T14:25:50.909725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 41
 
7.8%
999.0 29
 
5.5%
305.28 21
 
4.0%
99.9 21
 
4.0%
996.48 19
 
3.6%
99.96 13
 
2.5%
99.5 12
 
2.3%
999.9 12
 
2.3%
496.64 12
 
2.3%
97.92 10
 
1.9%
Other values (212) 335
63.8%
ValueCountFrequency (%)
10.0 1
0.2%
10.4 1
0.2%
14.4 1
0.2%
15.0 1
0.2%
15.02 1
0.2%
15.2 1
0.2%
16.0 1
0.2%
16.5 2
0.4%
16.8 1
0.2%
18.0 1
0.2%
ValueCountFrequency (%)
3024.0 1
 
0.2%
1000.0 1
 
0.2%
999.9 12
2.3%
999.68 2
 
0.4%
999.34 1
 
0.2%
999.0 29
5.5%
998.4 7
 
1.3%
996.84 4
 
0.8%
996.48 19
3.6%
994.18 3
 
0.6%

발전사업허가일
Date

Distinct217
Distinct (%)41.3%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
Minimum2007-01-30 00:00:00
Maximum2022-11-21 00:00:00
2023-12-12T14:25:51.076480image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:25:51.240167image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Date

MISSING 

Distinct232
Distinct (%)44.7%
Missing6
Missing (%)1.1%
Memory size4.2 KiB
Minimum2007-11-15 00:00:00
Maximum2023-03-21 00:00:00
2023-12-12T14:25:51.374543image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:25:51.524849image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size4.2 KiB
Minimum2023-04-10 00:00:00
Maximum2023-04-10 00:00:00
2023-12-12T14:25:51.652772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:25:51.760681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-12T14:25:48.145170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:25:47.711756image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:25:48.228444image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:25:48.059448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:25:51.831986image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(KW)
연번1.0000.538
설비용량(KW)0.5381.000
2023-12-12T14:25:51.913582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(KW)
연번1.0000.184
설비용량(KW)0.1841.000

Missing values

2023-12-12T14:25:48.334464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:25:48.456805image/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경인 태양광발전소전라남도 영광군 법성면 굴비로4길19.472022-11-212023-02-212023-04-10
12해오름 태양광발전소전라남도 영광군 군남면 월죽로3길19.62022-10-192023-01-272023-04-10
23한길 태양광발전소전라남도 영광군 법성면 용성월산로1길149.642022-08-222023-03-072023-04-10
34효은 태양광발전소전라남도 영광군 법성면 용성월산로1길49.882022-08-222023-03-072023-04-10
45월촌 태양광발전소전라남도 영광군 법성면 용성월산로99.02022-07-282022-12-302023-04-10
56월촌 태양광발전소2호전라남도 영광군 법성면 용성월산로85.52022-07-272022-12-302023-04-10
67월계농장 제6태양광발전소전라남도 영광군 법성면 신장길2길98.942022-07-112023-02-222023-04-10
78월계농장 제5태양광발전소전라남도 영광군 법성면 신장길3길98.942022-07-112023-02-222023-04-10
89월계농장 제4태양광발전소전라남도 영광군 법성면 신장길4길98.942022-07-112023-02-222023-04-10
910월계농장 제3태양광발전소전라남도 영광군 법성면 신장길5길99.432022-07-112023-02-222023-04-10
연번상호명소재지 주소설비용량(KW)발전사업허가일사업개시일데이터기준일자
515516송림 태양광발전소전라남도 영광군 영광읍 송림리499.82007-10-182008-09-242023-04-10
516517송림 태양광발전소전라남도 영광군 영광읍 장궁길1길499.82007-10-182008-02-272023-04-10
517518미래쏠라(주)(미래쏠라 태양광발전소)전라남도 영광군 군서면 만곡리297.62007-10-012013-11-202023-04-10
518519(주)제이에스에너지(JS에너지제2발전소)전라남도 영광군 군남면 월죽로600.02007-08-312008-06-092023-04-10
519520(주)제이에스에너지(JS에너지 제1발전소)전라남도 영광군 군서면 만곡리400.322007-08-312008-06-092023-04-10
520521태형솔라(주)(태형솔라 태양광발전소)전라남도 영광군 군서면 성지로500.02007-08-292010-05-242023-04-10
521522(유)대융에너지(대융에너지 태양광발전소)전라남도 영광군 군서면 만곡리99.02007-02-022007-11-152023-04-10
522523유한회사 경일이앤씨전라남도 영광군 군서면 만곡리99.02007-01-302007-12-282023-04-10
523524(주)동일태양광발전(동일 태양광발전소)전라남도 영광군 군서면 백수로700.02007-01-302008-08-112023-04-10
524525엘쏠라 태양광발전소전라남도 영광군 군서면 송학리100.02007-01-302008-08-132023-04-10