Overview

Dataset statistics

Number of variables5
Number of observations28
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory1.3 KiB
Average record size in memory47.7 B

Variable types

Numeric3
Text2

Dataset

Description서울특별시 강북구 공공시설 태양광 현황(발전소명,설비용량,주소,허가년도)
Author서울특별시 강북구
URLhttps://www.data.go.kr/data/15033892/fileData.do

Alerts

연번 is highly overall correlated with 설치년도High correlation
설치년도 is highly overall correlated with 연번High correlation
연번 has unique valuesUnique
발전소명 has unique valuesUnique
설치장소 has unique valuesUnique

Reproduction

Analysis started2023-12-12 21:40:23.206452
Analysis finished2023-12-12 21:40:24.428924
Duration1.22 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean14.5
Minimum1
Maximum28
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2023-12-13T06:40:24.493942image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile2.35
Q17.75
median14.5
Q321.25
95-th percentile26.65
Maximum28
Range27
Interquartile range (IQR)13.5

Descriptive statistics

Standard deviation8.2259751
Coefficient of variation (CV)0.56730863
Kurtosis-1.2
Mean14.5
Median Absolute Deviation (MAD)7
Skewness0
Sum406
Variance67.666667
MonotonicityStrictly increasing
2023-12-13T06:40:24.615751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%)
1 1
 
3.6%
16 1
 
3.6%
28 1
 
3.6%
27 1
 
3.6%
26 1
 
3.6%
25 1
 
3.6%
24 1
 
3.6%
23 1
 
3.6%
22 1
 
3.6%
21 1
 
3.6%
Other values (18) 18
64.3%
ValueCountFrequency (%)
1 1
3.6%
2 1
3.6%
3 1
3.6%
4 1
3.6%
5 1
3.6%
6 1
3.6%
7 1
3.6%
8 1
3.6%
9 1
3.6%
10 1
3.6%
ValueCountFrequency (%)
28 1
3.6%
27 1
3.6%
26 1
3.6%
25 1
3.6%
24 1
3.6%
23 1
3.6%
22 1
3.6%
21 1
3.6%
20 1
3.6%
19 1
3.6%

발전소명
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-13T06:40:24.813637image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length13
Median length11
Mean length8.8571429
Min length5

Characters and Unicode

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

Unique

Unique28 ?
Unique (%)100.0%

Sample

1st row구립 수유2동어린이집
2nd row수유1동복합청사
3rd row강북구육아종합지원센터
4th row번동햇살 공영주차장
5th row미아동 복합청사
ValueCountFrequency (%)
공영주차장 6
 
15.8%
미아동 2
 
5.3%
구립 1
 
2.6%
벌리교(신우연립 1
 
2.6%
삼각산동복합청사 1
 
2.6%
양지마을 1
 
2.6%
사랑채 1
 
2.6%
강북문화정보도서관 1
 
2.6%
강북실버종합복지센터 1
 
2.6%
강북청소년문화정보도서관 1
 
2.6%
Other values (22) 22
57.9%
2023-12-13T06:40:25.244631image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 12
 
4.8%
10
 
4.0%
장 9
 
3.6%
공 8
 
3.2%
주 7
 
2.8%
강 7
 
2.8%
북 7
 
2.8%
차 6
 
2.4%
영 6
 
2.4%
합 6
 
2.4%
Other values (85) 170
68.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 233
94.0%
Space Separator 10
 
4.0%
Decimal Number 3
 
1.2%
Close Punctuation 1
 
0.4%
Open Punctuation 1
 
0.4%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 12
 
5.2%
장 9
 
3.9%
공 8
 
3.4%
주 7
 
3.0%
강 7
 
3.0%
북 7
 
3.0%
차 6
 
2.6%
영 6
 
2.6%
합 6
 
2.6%
복 5
 
2.1%
Other values (80) 160
68.7%
Decimal Number
ValueCountFrequency (%)
1 2
66.7%
2 1
33.3%
Space Separator
ValueCountFrequency (%)
10
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 233
94.0%
Common 15
 
6.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 12
 
5.2%
장 9
 
3.9%
공 8
 
3.4%
주 7
 
3.0%
강 7
 
3.0%
북 7
 
3.0%
차 6
 
2.6%
영 6
 
2.6%
합 6
 
2.6%
복 5
 
2.1%
Other values (80) 160
68.7%
Common
ValueCountFrequency (%)
10
66.7%
1 2
 
13.3%
2 1
 
6.7%
) 1
 
6.7%
( 1
 
6.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 233
94.0%
ASCII 15
 
6.0%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 12
 
5.2%
장 9
 
3.9%
공 8
 
3.4%
주 7
 
3.0%
강 7
 
3.0%
북 7
 
3.0%
차 6
 
2.6%
영 6
 
2.6%
합 6
 
2.6%
복 5
 
2.1%
Other values (80) 160
68.7%
ASCII
ValueCountFrequency (%)
10
66.7%
1 2
 
13.3%
2 1
 
6.7%
) 1
 
6.7%
( 1
 
6.7%

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

Distinct23
Distinct (%)82.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean25.186679
Minimum3
Maximum80.08
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2023-12-13T06:40:25.400273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile3
Q17.705
median19.21
Q336
95-th percentile73.22825
Maximum80.08
Range77.08
Interquartile range (IQR)28.295

Descriptive statistics

Standard deviation22.218078
Coefficient of variation (CV)0.88213607
Kurtosis0.69670958
Mean25.186679
Median Absolute Deviation (MAD)13.49
Skewness1.1588628
Sum705.227
Variance493.64297
MonotonicityNot monotonic
2023-12-13T06:40:25.563368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=23)
ValueCountFrequency (%)
3.0 3
 
10.7%
9.0 2
 
7.1%
36.0 2
 
7.1%
6.4 2
 
7.1%
4.8 1
 
3.6%
41.202 1
 
3.6%
8.14 1
 
3.6%
80.08 1
 
3.6%
10.14 1
 
3.6%
15.33 1
 
3.6%
Other values (13) 13
46.4%
ValueCountFrequency (%)
3.0 3
10.7%
4.8 1
 
3.6%
5.04 1
 
3.6%
6.4 2
7.1%
8.14 1
 
3.6%
9.0 2
7.1%
10.14 1
 
3.6%
12.0 1
 
3.6%
15.33 1
 
3.6%
18.4 1
 
3.6%
ValueCountFrequency (%)
80.08 1
3.6%
77.745 1
3.6%
64.84 1
3.6%
49.0 1
3.6%
45.0 1
3.6%
41.202 1
3.6%
36.0 2
7.1%
34.79 1
3.6%
30.0 1
3.6%
29.0 1
3.6%

설치장소
Text

UNIQUE 

Distinct28
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size356.0 B
2023-12-13T06:40:25.823262image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length32
Median length27
Mean length23.857143
Min length16

Characters and Unicode

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

Unique

Unique28 ?
Unique (%)100.0%

Sample

1st row서울특별시 강북구 삼양로138길 18(수유동)
2nd row서울특별시 강북구 삼양로 299(수유동)
3rd row서울특별시 강북구 인수봉로66길 9(수유동)
4th row서울특별시 강북구 오현로21길 84(번동)
5th row서울특별시 강북구 솔매로49길 14(미아동)
ValueCountFrequency (%)
서울특별시 28
24.1%
강북구 28
24.1%
오패산로 3
 
2.6%
삼양로 2
 
1.7%
삼각산로 2
 
1.7%
우이동 2
 
1.7%
덕릉로42길 2
 
1.7%
번동 2
 
1.7%
266 1
 
0.9%
89(수유동 1
 
0.9%
Other values (45) 45
38.8%
2023-12-13T06:40:26.261879image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
88
 
13.2%
구 29
 
4.3%
동 29
 
4.3%
서 28
 
4.2%
특 28
 
4.2%
별 28
 
4.2%
시 28
 
4.2%
강 28
 
4.2%
북 28
 
4.2%
울 28
 
4.2%
Other values (46) 326
48.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 416
62.3%
Decimal Number 106
 
15.9%
Space Separator 88
 
13.2%
Close Punctuation 26
 
3.9%
Open Punctuation 26
 
3.9%
Dash Punctuation 6
 
0.9%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
구 29
 
7.0%
동 29
 
7.0%
서 28
 
6.7%
특 28
 
6.7%
별 28
 
6.7%
시 28
 
6.7%
강 28
 
6.7%
북 28
 
6.7%
울 28
 
6.7%
로 26
 
6.2%
Other values (32) 136
32.7%
Decimal Number
ValueCountFrequency (%)
2 17
16.0%
4 16
15.1%
1 16
15.1%
9 15
14.2%
6 12
11.3%
8 8
7.5%
3 7
6.6%
5 7
6.6%
0 5
 
4.7%
7 3
 
2.8%
Space Separator
ValueCountFrequency (%)
88
100.0%
Close Punctuation
ValueCountFrequency (%)
) 26
100.0%
Open Punctuation
ValueCountFrequency (%)
( 26
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 416
62.3%
Common 252
37.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
구 29
 
7.0%
동 29
 
7.0%
서 28
 
6.7%
특 28
 
6.7%
별 28
 
6.7%
시 28
 
6.7%
강 28
 
6.7%
북 28
 
6.7%
울 28
 
6.7%
로 26
 
6.2%
Other values (32) 136
32.7%
Common
ValueCountFrequency (%)
88
34.9%
) 26
 
10.3%
( 26
 
10.3%
2 17
 
6.7%
4 16
 
6.3%
1 16
 
6.3%
9 15
 
6.0%
6 12
 
4.8%
8 8
 
3.2%
3 7
 
2.8%
Other values (4) 21
 
8.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 416
62.3%
ASCII 252
37.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
88
34.9%
) 26
 
10.3%
( 26
 
10.3%
2 17
 
6.7%
4 16
 
6.3%
1 16
 
6.3%
9 15
 
6.0%
6 12
 
4.8%
8 8
 
3.2%
3 7
 
2.8%
Other values (4) 21
 
8.3%
Hangul
ValueCountFrequency (%)
구 29
 
7.0%
동 29
 
7.0%
서 28
 
6.7%
특 28
 
6.7%
별 28
 
6.7%
시 28
 
6.7%
강 28
 
6.7%
북 28
 
6.7%
울 28
 
6.7%
로 26
 
6.2%
Other values (32) 136
32.7%

설치년도
Real number (ℝ)

HIGH CORRELATION 

Distinct11
Distinct (%)39.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2015.7143
Minimum2009
Maximum2020
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size384.0 B
2023-12-13T06:40:26.377912image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2009
5-th percentile2010.35
Q12014.75
median2016
Q32018
95-th percentile2019
Maximum2020
Range11
Interquartile range (IQR)3.25

Descriptive statistics

Standard deviation2.6923368
Coefficient of variation (CV)0.0013356738
Kurtosis0.54269508
Mean2015.7143
Median Absolute Deviation (MAD)2
Skewness-0.87390089
Sum56440
Variance7.2486772
MonotonicityIncreasing
2023-12-13T06:40:26.486937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
2016 5
17.9%
2018 5
17.9%
2015 4
14.3%
2017 4
14.3%
2013 2
 
7.1%
2014 2
 
7.1%
2019 2
 
7.1%
2009 1
 
3.6%
2010 1
 
3.6%
2011 1
 
3.6%
ValueCountFrequency (%)
2009 1
 
3.6%
2010 1
 
3.6%
2011 1
 
3.6%
2013 2
 
7.1%
2014 2
 
7.1%
2015 4
14.3%
2016 5
17.9%
2017 4
14.3%
2018 5
17.9%
2019 2
 
7.1%
ValueCountFrequency (%)
2020 1
 
3.6%
2019 2
 
7.1%
2018 5
17.9%
2017 4
14.3%
2016 5
17.9%
2015 4
14.3%
2014 2
 
7.1%
2013 2
 
7.1%
2011 1
 
3.6%
2010 1
 
3.6%

Interactions

2023-12-13T06:40:23.970894image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:40:23.407465image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:40:23.674608image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:40:24.066658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:40:23.485893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:40:23.772404image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:40:24.171056image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:40:23.582208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:40:23.870961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:40:26.560925image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번발전소명설비용량(kW)설치장소설치년도
연번1.0001.0000.0001.0000.897
발전소명1.0001.0001.0001.0001.000
설비용량(kW)0.0001.0001.0001.0000.269
설치장소1.0001.0001.0001.0001.000
설치년도0.8971.0000.2691.0001.000
2023-12-13T06:40:26.651037image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번설비용량(kW)설치년도
연번1.0000.0520.991
설비용량(kW)0.0521.0000.033
설치년도0.9910.0331.000

Missing values

2023-12-13T06:40:24.292163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:40:24.393862image/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구립 수유2동어린이집4.8서울특별시 강북구 삼양로138길 18(수유동)2009
12수유1동복합청사5.04서울특별시 강북구 삼양로 299(수유동)2010
23강북구육아종합지원센터18.4서울특별시 강북구 인수봉로66길 9(수유동)2011
34번동햇살 공영주차장64.84서울특별시 강북구 오현로21길 84(번동)2013
45미아동 복합청사49.0서울특별시 강북구 솔매로49길 14(미아동)2013
56오동공원 배드민턴장20.02서울특별시 강북구 덕릉로42길 49(번동)2014
67수유마을시장 공영주차장29.0서울특별시 강북구 도봉로69길 29(수유동)2014
78삼양어린이집9.0서울특별시 강북구 삼양로64길 32-14(미아동)2015
89은모루경로당3.0서울특별시 강북구 도봉로95길 38-1(수유동)2015
910구세군길 공영주차장36.0서울특별시 강북구 인수봉로20가길 21(미아동)2015
연번발전소명설비용량(kW)설치장소설치년도
1819강북문화정보도서관34.79서울특별시 강북구 오현로 145(번동)2017
1920강북실버종합복지센터77.745서울특별시 강북구 오패산로 290(미아동)2017
2021벌리교(신우연립)6.4서울특별시 강북구 번동 2662018
2122강북문화예술회관21.9서울특별시 강북구 삼각산로 85(수유동)2018
2223강북청소년문화정보도서관15.33서울특별시 강북구 삼양로54길 68(미아동)2018
2324번1동주민센터6.4서울특별시 강북구 덕릉로41길 74(번동)2018
2425강북구보훈회관36.0서울특별시 강북구 오패산로 290-1(미아동)2018
2526우이동먹거리마을태양광쉼터10.14서울특별시 강북구 우이동 209-8 우이동 먹거리마을 입구2019
2627오동근린공원배드민턴장80.08서울특별시 강북구 덕릉로42길 49 (번동)2019
2728오현숲마을활력소8.14서울특별시 강북구 오현로25나길 16(번동)2020