Overview

Dataset statistics

Number of variables7
Number of observations2997
Missing cells1
Missing cells (%)< 0.1%
Duplicate rows1
Duplicate rows (%)< 0.1%
Total size in memory167.0 KiB
Average record size in memory57.0 B

Variable types

Text3
Numeric1
DateTime2
Categorical1

Dataset

Description충청남도 논산시 태양광 발전 현황 데이터로 발전소명, 설비용량, 설치주소, 허가일, 사업개시일, 영업구분, 데이터기준일을 제공하고 있습니다.
Author충청남도 논산시
URLhttps://www.data.go.kr/data/15112794/fileData.do

Alerts

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

Reproduction

Analysis started2024-01-14 13:37:41.582307
Analysis finished2024-01-14 13:37:42.376958
Duration0.79 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

발전소명
Text

Distinct2736
Distinct (%)91.3%
Missing0
Missing (%)0.0%
Memory size23.5 KiB
2024-01-14T22:37:42.556175image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length22
Mean length9.8038038
Min length1

Characters and Unicode

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

Unique

Unique2552 ?
Unique (%)85.2%

Sample

1st row우주
2nd row대명
3rd row상도
4th row부경
5th row득윤
ValueCountFrequency (%)
태양광발전소 2476
43.9%
발전소 36
 
0.6%
태양광 17
 
0.3%
황금알 9
 
0.2%
대명 8
 
0.1%
1호 7
 
0.1%
에너지 7
 
0.1%
2호 7
 
0.1%
한빛 7
 
0.1%
광석 7
 
0.1%
Other values (2696) 3061
54.3%
2024-01-14T22:37:43.013198image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2655
 
9.0%
광 2653
 
9.0%
전 2623
 
8.9%
소 2615
 
8.9%
양 2600
 
8.8%
발 2591
 
8.8%
태 2583
 
8.8%
호 1212
 
4.1%
1 516
 
1.8%
2 476
 
1.6%
Other values (456) 8858
30.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 24673
84.0%
Space Separator 2655
 
9.0%
Decimal Number 1746
 
5.9%
Uppercase Letter 207
 
0.7%
Lowercase Letter 41
 
0.1%
Other Symbol 27
 
0.1%
Close Punctuation 10
 
< 0.1%
Open Punctuation 10
 
< 0.1%
Other Punctuation 5
 
< 0.1%
Dash Punctuation 3
 
< 0.1%
Other values (2) 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
광 2653
 
10.8%
전 2623
 
10.6%
소 2615
 
10.6%
양 2600
 
10.5%
발 2591
 
10.5%
태 2583
 
10.5%
호 1212
 
4.9%
지 360
 
1.5%
에 314
 
1.3%
산 301
 
1.2%
Other values (400) 6821
27.6%
Uppercase Letter
ValueCountFrequency (%)
S 55
26.6%
K 21
 
10.1%
J 21
 
10.1%
H 18
 
8.7%
E 11
 
5.3%
G 10
 
4.8%
M 9
 
4.3%
P 7
 
3.4%
Y 7
 
3.4%
D 6
 
2.9%
Other values (12) 42
20.3%
Lowercase Letter
ValueCountFrequency (%)
e 8
19.5%
a 5
12.2%
h 5
12.2%
r 4
9.8%
o 3
 
7.3%
c 3
 
7.3%
n 3
 
7.3%
t 3
 
7.3%
l 2
 
4.9%
w 1
 
2.4%
Other values (4) 4
9.8%
Decimal Number
ValueCountFrequency (%)
1 516
29.6%
2 476
27.3%
3 258
14.8%
4 136
 
7.8%
5 94
 
5.4%
6 65
 
3.7%
7 58
 
3.3%
8 52
 
3.0%
9 51
 
2.9%
0 40
 
2.3%
Other Punctuation
ValueCountFrequency (%)
. 3
60.0%
& 2
40.0%
Letter Number
ValueCountFrequency (%)
Ⅲ 1
50.0%
Ⅱ 1
50.0%
Space Separator
ValueCountFrequency (%)
2655
100.0%
Other Symbol
ValueCountFrequency (%)
㈜ 27
100.0%
Close Punctuation
ValueCountFrequency (%)
) 10
100.0%
Open Punctuation
ValueCountFrequency (%)
( 10
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 24700
84.1%
Common 4432
 
15.1%
Latin 250
 
0.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
광 2653
 
10.7%
전 2623
 
10.6%
소 2615
 
10.6%
양 2600
 
10.5%
발 2591
 
10.5%
태 2583
 
10.5%
호 1212
 
4.9%
지 360
 
1.5%
에 314
 
1.3%
산 301
 
1.2%
Other values (401) 6848
27.7%
Latin
ValueCountFrequency (%)
S 55
22.0%
K 21
 
8.4%
J 21
 
8.4%
H 18
 
7.2%
E 11
 
4.4%
G 10
 
4.0%
M 9
 
3.6%
e 8
 
3.2%
P 7
 
2.8%
Y 7
 
2.8%
Other values (28) 83
33.2%
Common
ValueCountFrequency (%)
2655
59.9%
1 516
 
11.6%
2 476
 
10.7%
3 258
 
5.8%
4 136
 
3.1%
5 94
 
2.1%
6 65
 
1.5%
7 58
 
1.3%
8 52
 
1.2%
9 51
 
1.2%
Other values (7) 71
 
1.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 24673
84.0%
ASCII 4680
 
15.9%
None 27
 
0.1%
Number Forms 2
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2655
56.7%
1 516
 
11.0%
2 476
 
10.2%
3 258
 
5.5%
4 136
 
2.9%
5 94
 
2.0%
6 65
 
1.4%
7 58
 
1.2%
S 55
 
1.2%
8 52
 
1.1%
Other values (43) 315
 
6.7%
Hangul
ValueCountFrequency (%)
광 2653
 
10.8%
전 2623
 
10.6%
소 2615
 
10.6%
양 2600
 
10.5%
발 2591
 
10.5%
태 2583
 
10.5%
호 1212
 
4.9%
지 360
 
1.5%
에 314
 
1.3%
산 301
 
1.2%
Other values (400) 6821
27.6%
None
ValueCountFrequency (%)
㈜ 27
100.0%
Number Forms
ValueCountFrequency (%)
Ⅲ 1
50.0%
Ⅱ 1
50.0%

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

Distinct593
Distinct (%)19.8%
Missing1
Missing (%)< 0.1%
Infinite0
Infinite (%)0.0%
Mean128.01214
Minimum9
Maximum2449.5
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size26.5 KiB
2024-01-14T22:37:43.220031image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum9
5-th percentile29
Q197.92
median99.12
Q399.76
95-th percentile458.69625
Maximum2449.5
Range2440.5
Interquartile range (IQR)1.84

Descriptive statistics

Standard deviation141.64177
Coefficient of variation (CV)1.1064714
Kurtosis43.55586
Mean128.01214
Median Absolute Deviation (MAD)0.78
Skewness5.2733287
Sum383524.37
Variance20062.39
MonotonicityNot monotonic
2024-01-14T22:37:43.371251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
99.0 378
 
12.6%
99.96 162
 
5.4%
99.18 144
 
4.8%
97.2 109
 
3.6%
97.92 97
 
3.2%
99.84 97
 
3.2%
99.6 90
 
3.0%
98.28 87
 
2.9%
99.9 70
 
2.3%
98.55 68
 
2.3%
Other values (583) 1694
56.5%
ValueCountFrequency (%)
9.0 1
< 0.1%
9.96 1
< 0.1%
10.0 2
0.1%
10.08 1
< 0.1%
10.125 1
< 0.1%
11.0 1
< 0.1%
12.0 1
< 0.1%
12.3 1
< 0.1%
12.6 1
< 0.1%
12.74 2
0.1%
ValueCountFrequency (%)
2449.5 1
 
< 0.1%
1506.6 1
 
< 0.1%
1474.0 1
 
< 0.1%
1399.86 1
 
< 0.1%
999.0 4
0.1%
998.64 1
 
< 0.1%
998.4 1
 
< 0.1%
997.6 1
 
< 0.1%
997.56 3
0.1%
996.0 1
 
< 0.1%

설치 주소
Text

Distinct2348
Distinct (%)78.3%
Missing0
Missing (%)0.0%
Memory size23.5 KiB
2024-01-14T22:37:43.774346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length91
Median length68
Mean length25.875542
Min length14

Characters and Unicode

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

Unique

Unique2045 ?
Unique (%)68.2%

Sample

1st row충청남도 논산시 내동 501-5
2nd row충청남도 논산시 상도리 45
3rd row충청남도 논산시 상도리 44-1
4th row충청남도 논산시 양지리 613
5th row충청남도 논산시 득윤리 63-1, 513-11, 517-2
ValueCountFrequency (%)
충청남도 2997
 
17.9%
논산시 2997
 
17.9%
노성면 487
 
2.9%
광석면 442
 
2.6%
연무읍 329
 
2.0%
가야곡면 280
 
1.7%
은진면 267
 
1.6%
상월면 263
 
1.6%
성동면 230
 
1.4%
읍내리 202
 
1.2%
Other values (3257) 8262
49.3%
2024-01-14T22:37:44.447813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13808
 
17.8%
- 3950
 
5.1%
산 3658
 
4.7%
1 3433
 
4.4%
남 3076
 
4.0%
도 3061
 
3.9%
청 3014
 
3.9%
시 3007
 
3.9%
충 2997
 
3.9%
논 2997
 
3.9%
Other values (152) 34548
44.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 39070
50.4%
Decimal Number 18837
24.3%
Space Separator 13808
 
17.8%
Dash Punctuation 3950
 
5.1%
Other Punctuation 1818
 
2.3%
Open Punctuation 33
 
< 0.1%
Close Punctuation 33
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
산 3658
 
9.4%
남 3076
 
7.9%
도 3061
 
7.8%
청 3014
 
7.7%
시 3007
 
7.7%
충 2997
 
7.7%
논 2997
 
7.7%
리 2916
 
7.5%
면 2548
 
6.5%
성 751
 
1.9%
Other values (136) 11045
28.3%
Decimal Number
ValueCountFrequency (%)
1 3433
18.2%
2 2656
14.1%
4 2207
11.7%
3 2197
11.7%
5 2037
10.8%
6 1459
7.7%
7 1318
 
7.0%
9 1230
 
6.5%
8 1151
 
6.1%
0 1149
 
6.1%
Other Punctuation
ValueCountFrequency (%)
, 1812
99.7%
. 6
 
0.3%
Space Separator
ValueCountFrequency (%)
13808
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3950
100.0%
Open Punctuation
ValueCountFrequency (%)
( 33
100.0%
Close Punctuation
ValueCountFrequency (%)
) 33
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 39070
50.4%
Common 38479
49.6%

Most frequent character per script

Hangul
ValueCountFrequency (%)
산 3658
 
9.4%
남 3076
 
7.9%
도 3061
 
7.8%
청 3014
 
7.7%
시 3007
 
7.7%
충 2997
 
7.7%
논 2997
 
7.7%
리 2916
 
7.5%
면 2548
 
6.5%
성 751
 
1.9%
Other values (136) 11045
28.3%
Common
ValueCountFrequency (%)
13808
35.9%
- 3950
 
10.3%
1 3433
 
8.9%
2 2656
 
6.9%
4 2207
 
5.7%
3 2197
 
5.7%
5 2037
 
5.3%
, 1812
 
4.7%
6 1459
 
3.8%
7 1318
 
3.4%
Other values (6) 3602
 
9.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 39041
50.3%
ASCII 38479
49.6%
Compat Jamo 29
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13808
35.9%
- 3950
 
10.3%
1 3433
 
8.9%
2 2656
 
6.9%
4 2207
 
5.7%
3 2197
 
5.7%
5 2037
 
5.3%
, 1812
 
4.7%
6 1459
 
3.8%
7 1318
 
3.4%
Other values (6) 3602
 
9.4%
Hangul
ValueCountFrequency (%)
산 3658
 
9.4%
남 3076
 
7.9%
도 3061
 
7.8%
청 3014
 
7.7%
시 3007
 
7.7%
충 2997
 
7.7%
논 2997
 
7.7%
리 2916
 
7.5%
면 2548
 
6.5%
성 751
 
1.9%
Other values (123) 11016
28.2%
Compat Jamo
ValueCountFrequency (%)
ㄴ 5
17.2%
ㄱ 5
17.2%
ㄹ 4
13.8%
ㄷ 3
10.3%
ㅁ 3
10.3%
ㅂ 2
 
6.9%
ㅋ 1
 
3.4%
ㅍ 1
 
3.4%
ㅌ 1
 
3.4%
ㅊ 1
 
3.4%
Other values (3) 3
10.3%

허가일
Date

Distinct607
Distinct (%)20.3%
Missing0
Missing (%)0.0%
Memory size23.5 KiB
Minimum2006-08-03 00:00:00
Maximum2023-11-28 00:00:00
2024-01-14T22:37:44.652740image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-14T22:37:44.810150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

사업개시일
Text

Distinct640
Distinct (%)21.4%
Missing0
Missing (%)0.0%
Memory size23.5 KiB
2024-01-14T22:37:45.123291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length10
Median length10
Mean length9.1554888
Min length4

Characters and Unicode

Total characters27439
Distinct characters20
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

Unique237 ?
Unique (%)7.9%

Sample

1st row2006-09-25
2nd row2007-07-24
3rd row2008-05-30
4th row2008-04-22
5th row2010-12-20
ValueCountFrequency (%)
자료부존재 505
 
16.8%
2022-10-17 37
 
1.2%
2020-02-05 34
 
1.1%
2020-12-23 33
 
1.1%
2023-04-24 28
 
0.9%
2020-12-18 25
 
0.8%
2023-09-19 25
 
0.8%
2020-04-14 25
 
0.8%
2020-12-22 24
 
0.8%
2020-12-15 23
 
0.8%
Other values (631) 2239
74.7%
2024-01-14T22:37:45.672280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 6152
22.4%
2 5568
20.3%
- 4982
18.2%
1 3592
13.1%
9 905
 
3.3%
3 856
 
3.1%
5 662
 
2.4%
8 597
 
2.2%
4 597
 
2.2%
7 549
 
2.0%
Other values (10) 2979
10.9%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 19928
72.6%
Dash Punctuation 4982
 
18.2%
Other Letter 2528
 
9.2%
Space Separator 1
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 6152
30.9%
2 5568
27.9%
1 3592
18.0%
9 905
 
4.5%
3 856
 
4.3%
5 662
 
3.3%
8 597
 
3.0%
4 597
 
3.0%
7 549
 
2.8%
6 450
 
2.3%
Other Letter
ValueCountFrequency (%)
자 505
20.0%
료 505
20.0%
재 505
20.0%
존 505
20.0%
부 505
20.0%
발 1
 
< 0.1%
전 1
 
< 0.1%
중 1
 
< 0.1%
Dash Punctuation
ValueCountFrequency (%)
- 4982
100.0%
Space Separator
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 24911
90.8%
Hangul 2528
 
9.2%

Most frequent character per script

Common
ValueCountFrequency (%)
0 6152
24.7%
2 5568
22.4%
- 4982
20.0%
1 3592
14.4%
9 905
 
3.6%
3 856
 
3.4%
5 662
 
2.7%
8 597
 
2.4%
4 597
 
2.4%
7 549
 
2.2%
Other values (2) 451
 
1.8%
Hangul
ValueCountFrequency (%)
자 505
20.0%
료 505
20.0%
재 505
20.0%
존 505
20.0%
부 505
20.0%
발 1
 
< 0.1%
전 1
 
< 0.1%
중 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 24911
90.8%
Hangul 2528
 
9.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 6152
24.7%
2 5568
22.4%
- 4982
20.0%
1 3592
14.4%
9 905
 
3.6%
3 856
 
3.4%
5 662
 
2.7%
8 597
 
2.4%
4 597
 
2.4%
7 549
 
2.2%
Other values (2) 451
 
1.8%
Hangul
ValueCountFrequency (%)
자 505
20.0%
료 505
20.0%
재 505
20.0%
존 505
20.0%
부 505
20.0%
발 1
 
< 0.1%
전 1
 
< 0.1%
중 1
 
< 0.1%

영업구분
Categorical

Distinct2
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size23.5 KiB
사업개시
2492 
인허가
505 

Length

Max length4
Median length4
Mean length3.8314982
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
사업개시 2492
83.1%
인허가 505
 
16.9%

Length

2024-01-14T22:37:45.855482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-14T22:37:45.986096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사업개시 2492
83.1%
인허가 505
 
16.9%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size23.5 KiB
Minimum2023-12-28 00:00:00
Maximum2023-12-28 00:00:00
2024-01-14T22:37:46.111113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-14T22:37:46.249488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-14T22:37:42.086720image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-14T22:37:46.321537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설비용량(kw)영업구분
설비용량(kw)1.0000.131
영업구분0.1311.000
2024-01-14T22:37:46.421789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
설비용량(kw)영업구분
설비용량(kw)1.0000.098
영업구분0.0981.000

Missing values

2024-01-14T22:37:42.211442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-14T22:37:42.325101image/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우주10.0충청남도 논산시 내동 501-52006-08-032006-09-25사업개시2023-12-28
1대명29.4충청남도 논산시 상도리 452007-05-102007-07-24사업개시2023-12-28
2상도29.0충청남도 논산시 상도리 44-12007-11-082008-05-30사업개시2023-12-28
3부경83.0충청남도 논산시 양지리 6132007-11-292008-04-22사업개시2023-12-28
4득윤99.0충청남도 논산시 득윤리 63-1, 513-11, 517-22007-12-182010-12-20사업개시2023-12-28
5신화29.0충청남도 논산시 연무읍 신화리 41-32007-12-242008-03-10사업개시2023-12-28
6석종29.0충청남도 논산시 상월면 석종리 892008-01-172008-03-10사업개시2023-12-28
7계룡산29.0충청남도 논산시 상월면 석종리 892008-01-172008-03-10사업개시2023-12-28
8누리29.0충청남도 논산시 가야곡면 두월리 2482008-01-312008-04-01사업개시2023-12-28
9누리29.0충청남도 논산시 가야곡면 두월리 2482008-01-312008-04-01사업개시2023-12-28
발전소명설비용량(kw)설치 주소허가일사업개시일영업구분데이터기준일
2987상도 태양광발전소19.52충청남도 논산시 상월면 상도리 139-72023-11-09자료부존재인허가2023-12-28
2988우곤리1호 태양광발전소19.84충청남도 논산시 성동면 우곤리 6292023-11-09자료부존재인허가2023-12-28
2989종회1호 태양광발전소99.6충청남도 논산시 광석면 갈산리 120-1, 120-22023-11-13자료부존재인허가2023-12-28
2990종회2호 태양광발전소99.6충청남도 논산시 광석면 갈산리 120-1, 120-22023-11-13자료부존재인허가2023-12-28
2991종회3호 태양광발전소99.6충청남도 논산시 광석면 갈산리 120-1, 120-22023-11-13자료부존재인허가2023-12-28
2992종회4호 태양광발전소99.6충청남도 논산시 광석면 갈산리 498-1, 501-3, 501-52023-11-13자료부존재인허가2023-12-28
2993종회5호 태양광발전소99.6충청남도 논산시 광석면 갈산리 498-1, 501-3, 501-52023-11-13자료부존재인허가2023-12-28
2994명화 태양광발전소19.14충청남도 논산시 채운면 용화리 300-412023-11-14자료부존재인허가2023-12-28
2995유희 태양광발전소 3호19.04충청남도 논산시 연산면 장전리 590-22023-11-14자료부존재인허가2023-12-28
2996다올1호 태양광발전소79.8충청남도 논산시 연산면 장전리 615, 616-62023-11-28자료부존재인허가2023-12-28

Duplicate rows

Most frequently occurring

발전소명설비용량(kw)설치 주소허가일사업개시일영업구분데이터기준일# duplicates
0누리29.0충청남도 논산시 가야곡면 두월리 2482008-01-312008-04-01사업개시2023-12-282