Overview

Dataset statistics

Number of variables6
Number of observations471
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory23.1 KiB
Average record size in memory50.3 B

Variable types

Numeric2
Text2
Categorical1
DateTime1

Dataset

Description인천광역시 태양광 발전시설 현황 데이터로 (연번, 상호명, 설비용량(KW), 설비장소, 상태, 사업개시일)에 대한 데이터 정보를 제공하고 있습니다.
Author인천광역시
URLhttps://www.incheon.go.kr/data/DATA010201/view?docId=15098267

Alerts

상태 has constant value ""Constant
연번 has unique valuesUnique

Reproduction

Analysis started2024-01-28 09:46:44.801320
Analysis finished2024-01-28 09:46:45.574203
Duration0.77 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct471
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean236
Minimum1
Maximum471
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.3 KiB
2024-01-28T18:46:45.633911image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile24.5
Q1118.5
median236
Q3353.5
95-th percentile447.5
Maximum471
Range470
Interquartile range (IQR)235

Descriptive statistics

Standard deviation136.11025
Coefficient of variation (CV)0.57673835
Kurtosis-1.2
Mean236
Median Absolute Deviation (MAD)118
Skewness0
Sum111156
Variance18526
MonotonicityStrictly increasing
2024-01-28T18:46:45.734054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
0.2%
311 1
 
0.2%
323 1
 
0.2%
322 1
 
0.2%
321 1
 
0.2%
320 1
 
0.2%
319 1
 
0.2%
318 1
 
0.2%
317 1
 
0.2%
316 1
 
0.2%
Other values (461) 461
97.9%
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 (%)
471 1
0.2%
470 1
0.2%
469 1
0.2%
468 1
0.2%
467 1
0.2%
466 1
0.2%
465 1
0.2%
464 1
0.2%
463 1
0.2%
462 1
0.2%

상호
Text

Distinct468
Distinct (%)99.4%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
2024-01-28T18:46:46.044475image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length21
Mean length11.199575
Min length5

Characters and Unicode

Total characters5275
Distinct characters344
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

Unique465 ?
Unique (%)98.7%

Sample

1st row동검발전소
2nd row기린에코 발전소
3rd row영흥도 태양광발전소
4th row해성 태양광발전소
5th row이동근 태양광발전소
ValueCountFrequency (%)
태양광발전소 347
37.2%
발전소 14
 
1.5%
2호 8
 
0.9%
1호 6
 
0.6%
햇빛발전소 5
 
0.5%
롯데마트 4
 
0.4%
2호기 4
 
0.4%
인천 4
 
0.4%
연안솔라 4
 
0.4%
3호 4
 
0.4%
Other values (498) 534
57.2%
2024-01-28T18:46:46.472455image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
전 477
 
9.0%
발 472
 
8.9%
소 469
 
8.9%
463
 
8.8%
태 451
 
8.5%
광 446
 
8.5%
양 445
 
8.4%
호 109
 
2.1%
2 58
 
1.1%
이 51
 
1.0%
Other values (334) 1834
34.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 4506
85.4%
Space Separator 463
 
8.8%
Decimal Number 159
 
3.0%
Uppercase Letter 61
 
1.2%
Lowercase Letter 28
 
0.5%
Close Punctuation 26
 
0.5%
Open Punctuation 26
 
0.5%
Dash Punctuation 4
 
0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
전 477
 
10.6%
발 472
 
10.5%
소 469
 
10.4%
태 451
 
10.0%
광 446
 
9.9%
양 445
 
9.9%
호 109
 
2.4%
이 51
 
1.1%
인 41
 
0.9%
주 35
 
0.8%
Other values (280) 1510
33.5%
Uppercase Letter
ValueCountFrequency (%)
S 11
18.0%
G 6
9.8%
H 5
 
8.2%
K 5
 
8.2%
E 4
 
6.6%
N 4
 
6.6%
P 4
 
6.6%
O 3
 
4.9%
R 3
 
4.9%
C 2
 
3.3%
Other values (12) 14
23.0%
Lowercase Letter
ValueCountFrequency (%)
n 7
25.0%
o 4
14.3%
k 2
 
7.1%
g 2
 
7.1%
c 2
 
7.1%
e 2
 
7.1%
p 2
 
7.1%
i 1
 
3.6%
d 1
 
3.6%
a 1
 
3.6%
Other values (4) 4
14.3%
Decimal Number
ValueCountFrequency (%)
2 58
36.5%
1 46
28.9%
3 24
15.1%
4 11
 
6.9%
5 7
 
4.4%
6 4
 
2.5%
0 3
 
1.9%
7 3
 
1.9%
8 2
 
1.3%
9 1
 
0.6%
Close Punctuation
ValueCountFrequency (%)
) 24
92.3%
] 2
 
7.7%
Open Punctuation
ValueCountFrequency (%)
( 24
92.3%
[ 2
 
7.7%
Other Punctuation
ValueCountFrequency (%)
, 1
50.0%
& 1
50.0%
Space Separator
ValueCountFrequency (%)
463
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 4506
85.4%
Common 680
 
12.9%
Latin 89
 
1.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
전 477
 
10.6%
발 472
 
10.5%
소 469
 
10.4%
태 451
 
10.0%
광 446
 
9.9%
양 445
 
9.9%
호 109
 
2.4%
이 51
 
1.1%
인 41
 
0.9%
주 35
 
0.8%
Other values (280) 1510
33.5%
Latin
ValueCountFrequency (%)
S 11
 
12.4%
n 7
 
7.9%
G 6
 
6.7%
H 5
 
5.6%
K 5
 
5.6%
E 4
 
4.5%
o 4
 
4.5%
N 4
 
4.5%
P 4
 
4.5%
O 3
 
3.4%
Other values (26) 36
40.4%
Common
ValueCountFrequency (%)
463
68.1%
2 58
 
8.5%
1 46
 
6.8%
) 24
 
3.5%
( 24
 
3.5%
3 24
 
3.5%
4 11
 
1.6%
5 7
 
1.0%
- 4
 
0.6%
6 4
 
0.6%
Other values (8) 15
 
2.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 4506
85.4%
ASCII 769
 
14.6%

Most frequent character per block

Hangul
ValueCountFrequency (%)
전 477
 
10.6%
발 472
 
10.5%
소 469
 
10.4%
태 451
 
10.0%
광 446
 
9.9%
양 445
 
9.9%
호 109
 
2.4%
이 51
 
1.1%
인 41
 
0.9%
주 35
 
0.8%
Other values (280) 1510
33.5%
ASCII
ValueCountFrequency (%)
463
60.2%
2 58
 
7.5%
1 46
 
6.0%
) 24
 
3.1%
( 24
 
3.1%
3 24
 
3.1%
4 11
 
1.4%
S 11
 
1.4%
5 7
 
0.9%
n 7
 
0.9%
Other values (44) 94
 
12.2%

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

Distinct307
Distinct (%)65.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean157.51501
Minimum3
Maximum2929.24
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size4.3 KiB
2024-01-28T18:46:46.797134image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile14.64
Q129.6
median90.45
Q399.735
95-th percentile740
Maximum2929.24
Range2926.24
Interquartile range (IQR)70.135

Descriptive statistics

Standard deviation302.52057
Coefficient of variation (CV)1.9205825
Kurtosis25.891185
Mean157.51501
Median Absolute Deviation (MAD)57.69
Skewness4.5122416
Sum74189.57
Variance91518.693
MonotonicityNot monotonic
2024-01-28T18:46:46.897403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
15.0 23
 
4.9%
99.0 16
 
3.4%
97.92 14
 
3.0%
30.0 14
 
3.0%
97.2 11
 
2.3%
99.75 8
 
1.7%
18.0 6
 
1.3%
99.2 6
 
1.3%
99.28 5
 
1.1%
9.0 5
 
1.1%
Other values (297) 363
77.1%
ValueCountFrequency (%)
3.0 2
 
0.4%
6.0 1
 
0.2%
9.0 5
1.1%
9.96 1
 
0.2%
10.26 1
 
0.2%
10.8 1
 
0.2%
12.0 4
0.8%
12.15 2
 
0.4%
12.3 1
 
0.2%
12.45 1
 
0.2%
ValueCountFrequency (%)
2929.24 1
0.2%
2081.75 1
0.2%
1991.34 1
0.2%
1818.18 1
0.2%
1500.0 1
0.2%
1470.0 1
0.2%
1434.06 1
0.2%
1433.7 1
0.2%
1326.78 1
0.2%
1130.4 1
0.2%

설치장소
Text

Distinct433
Distinct (%)91.9%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
2024-01-28T18:46:47.122805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length48
Median length40
Mean length25.972399
Min length17

Characters and Unicode

Total characters12233
Distinct characters276
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

Unique400 ?
Unique (%)84.9%

Sample

1st row인천광역시 강화군 길상면 동검길 166
2nd row인천광역시 옹진군 영흥면 영흥서로 102-1
3rd row인천광역시 옹진군 영흥면 내리 1703-2
4th row인천광역시 미추홀구 인하로91번길 15, 해성보육원 (용현동)
5th row인천광역시 강화군 길상면 온수리 129-3
ValueCountFrequency (%)
인천광역시 471
 
19.2%
강화군 186
 
7.6%
서구 126
 
5.1%
중구 44
 
1.8%
남동구 42
 
1.7%
길상면 37
 
1.5%
건물위 36
 
1.5%
원창동 35
 
1.4%
하점면 34
 
1.4%
오류동 27
 
1.1%
Other values (759) 1417
57.7%
2024-01-28T18:46:47.467291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
1984
 
16.2%
천 493
 
4.0%
인 485
 
4.0%
광 474
 
3.9%
시 474
 
3.9%
역 471
 
3.9%
1 439
 
3.6%
동 357
 
2.9%
구 277
 
2.3%
3 263
 
2.1%
Other values (266) 6516
53.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 7401
60.5%
Decimal Number 2011
 
16.4%
Space Separator 1984
 
16.2%
Open Punctuation 259
 
2.1%
Close Punctuation 259
 
2.1%
Dash Punctuation 195
 
1.6%
Other Punctuation 96
 
0.8%
Uppercase Letter 28
 
0.2%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
천 493
 
6.7%
인 485
 
6.6%
광 474
 
6.4%
시 474
 
6.4%
역 471
 
6.4%
동 357
 
4.8%
구 277
 
3.7%
번 257
 
3.5%
화 219
 
3.0%
로 214
 
2.9%
Other values (237) 3680
49.7%
Uppercase Letter
ValueCountFrequency (%)
B 4
14.3%
J 4
14.3%
G 3
10.7%
E 3
10.7%
L 3
10.7%
C 2
7.1%
N 2
7.1%
A 1
 
3.6%
P 1
 
3.6%
K 1
 
3.6%
Other values (4) 4
14.3%
Decimal Number
ValueCountFrequency (%)
1 439
21.8%
3 263
13.1%
2 253
12.6%
7 180
9.0%
5 175
 
8.7%
6 171
 
8.5%
4 159
 
7.9%
0 134
 
6.7%
8 122
 
6.1%
9 115
 
5.7%
Space Separator
ValueCountFrequency (%)
1984
100.0%
Open Punctuation
ValueCountFrequency (%)
( 259
100.0%
Close Punctuation
ValueCountFrequency (%)
) 259
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 195
100.0%
Other Punctuation
ValueCountFrequency (%)
, 96
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 7401
60.5%
Common 4804
39.3%
Latin 28
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
천 493
 
6.7%
인 485
 
6.6%
광 474
 
6.4%
시 474
 
6.4%
역 471
 
6.4%
동 357
 
4.8%
구 277
 
3.7%
번 257
 
3.5%
화 219
 
3.0%
로 214
 
2.9%
Other values (237) 3680
49.7%
Common
ValueCountFrequency (%)
1984
41.3%
1 439
 
9.1%
3 263
 
5.5%
( 259
 
5.4%
) 259
 
5.4%
2 253
 
5.3%
- 195
 
4.1%
7 180
 
3.7%
5 175
 
3.6%
6 171
 
3.6%
Other values (5) 626
 
13.0%
Latin
ValueCountFrequency (%)
B 4
14.3%
J 4
14.3%
G 3
10.7%
E 3
10.7%
L 3
10.7%
C 2
7.1%
N 2
7.1%
A 1
 
3.6%
P 1
 
3.6%
K 1
 
3.6%
Other values (4) 4
14.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 7401
60.5%
ASCII 4832
39.5%

Most frequent character per block

ASCII
ValueCountFrequency (%)
1984
41.1%
1 439
 
9.1%
3 263
 
5.4%
( 259
 
5.4%
) 259
 
5.4%
2 253
 
5.2%
- 195
 
4.0%
7 180
 
3.7%
5 175
 
3.6%
6 171
 
3.5%
Other values (19) 654
 
13.5%
Hangul
ValueCountFrequency (%)
천 493
 
6.7%
인 485
 
6.6%
광 474
 
6.4%
시 474
 
6.4%
역 471
 
6.4%
동 357
 
4.8%
구 277
 
3.7%
번 257
 
3.5%
화 219
 
3.0%
로 214
 
2.9%
Other values (237) 3680
49.7%

상태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
사업개시
471 

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 (%)
사업개시 471
100.0%

Length

2024-01-28T18:46:47.564538image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T18:46:47.632661image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사업개시 471
100.0%

사업개시일
Date

Distinct349
Distinct (%)74.1%
Missing0
Missing (%)0.0%
Memory size3.8 KiB
Minimum2005-11-23 00:00:00
Maximum2021-12-29 00:00:00
2024-01-28T18:46:47.713933image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T18:46:47.819776image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Interactions

2024-01-28T18:46:45.293393image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T18:46:45.153101image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T18:46:45.363372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T18:46:45.228747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-28T18:46:47.882002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(킬로와트)
연번1.0000.149
설비용량(킬로와트)0.1491.000
2024-01-28T18:46:47.942498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(킬로와트)
연번1.0000.129
설비용량(킬로와트)0.1291.000

Missing values

2024-01-28T18:46:45.460489image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T18:46:45.540695image/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동검발전소3.0인천광역시 강화군 길상면 동검길 166사업개시2005-11-23
12기린에코 발전소3.0인천광역시 옹진군 영흥면 영흥서로 102-1사업개시2006-03-27
23영흥도 태양광발전소1000.0인천광역시 옹진군 영흥면 내리 1703-2사업개시2006-10-04
34해성 태양광발전소6.0인천광역시 미추홀구 인하로91번길 15, 해성보육원 (용현동)사업개시2008-01-02
45이동근 태양광발전소30.0인천광역시 강화군 길상면 온수리 129-3사업개시2008-05-02
56고명자 태양광발전소30.0인천광역시 강화군 길상면 온수리 160-99사업개시2008-05-02
67이건 태양광발전소27.44인천광역시 미추홀구 염전로 91, 이건창호 (도화동)사업개시2008-05-15
78고용민 태양광발전소9.0인천광역시 강화군 길상면 해란길32번길 39사업개시2008-09-16
89신은주 태양광발전소9.0인천광역시 강화군 길상면 장촌길 112사업개시2008-09-25
910국화리 태양광발전소30.0인천광역시 강화군 강화읍 국화길12번길 28사업개시2009-07-29
연번상호설비용량(킬로와트)설치장소상태사업개시일
461462전앤유에너지 발전소19.95인천광역시 서구 북항로120번길 13-26, (건물위) (원창동)사업개시2021-12-09
462463간석 태양광발전소25.38인천광역시 남동구 석산로 235, 201호(간석동)사업개시2021-12-10
463464창우2호 태양광발전소99.0인천광역시 서구 사렴로65번길 9, 창우ENG (경서동)사업개시2021-12-16
464465창우1호 태양광발전소99.0인천광역시 서구 사렴로65번길 9, 창우ENG (경서동)사업개시2021-12-16
465466우람 태양광발전소171.36인천광역시 서구 북항로207번길 33(원창동)사업개시2021-12-20
466467신광 태양광발전소16.56인천광역시 서구 율도로 43-1(신현동)사업개시2021-12-23
467468예원2호 태양광발전소46.08인천광역시 강화군 길상면 장흥리 623-3 2동,3동(건물위)사업개시2021-12-24
468469승원2호 태양광발전소95.04인천광역시 강화군 길상면 장흥리 623-3 1동,3동(건물위)사업개시2021-12-24
469470시온의 빛 태양광발전소19.26인천광역시 서구 원당대로820번1길 13(당하동)사업개시2021-12-27
470471훈민태양광발전소79.0인천광역시 부평구 안남로402번길 80, (주)아이존본사 (청천동)사업개시2021-12-29