gimi9 Pandas Profiling

Dataset statistics

Number of variables	15
Number of observations	23
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.1 KiB
Average record size in memory	136.6 B

Variable types

Numeric	11
Categorical	2
Text	2

Dataset

Description	서울특별시 종로구 공공태양광 발전량 현황(단체명, 설치연도, 설치장소, 도로명주소, 설비용량, 설치비, 연간발전량)에 대한 데이터를 제공합니다.
Author	서울특별시 종로구
URL	https://www.data.go.kr/data/15126264/fileData.do

Alerts

`단체명` has constant value ""	Constant
`데이터기준일자` has constant value ""	Constant
`연번` is highly overall correlated with `설치연도` and 1 other fields	High correlation
`설치연도` is highly overall correlated with `연번` and 2 other fields	High correlation
`설비용량(KW)` is highly overall correlated with `설치비(백만원)` and 6 other fields	High correlation
`설치비(백만원)` is highly overall correlated with `설비용량(KW)` and 6 other fields	High correlation
`2016년 발전량(kWh)` is highly overall correlated with `연번` and 3 other fields	High correlation
`2017년 발전량(kWh)` is highly overall correlated with `설치연도` and 8 other fields	High correlation
`2018년 발전량(kWh)` is highly overall correlated with `설비용량(KW)` and 7 other fields	High correlation
`2019년 발전량(kWh)` is highly overall correlated with `설비용량(KW)` and 6 other fields	High correlation
`2020년 발전량(kWh)` is highly overall correlated with `설비용량(KW)` and 6 other fields	High correlation
`2021년 발전량(kWh)` is highly overall correlated with `설비용량(KW)` and 6 other fields	High correlation
`2022년 발전량(kWh)` is highly overall correlated with `설비용량(KW)` and 6 other fields	High correlation
`연번` has unique values	Unique
`설치장소` has unique values	Unique
`도로명주소` has unique values	Unique
`2020년 발전량(kWh)` has unique values	Unique
`2022년 발전량(kWh)` has unique values	Unique
`2016년 발전량(kWh)` has 11 (47.8%) zeros	Zeros
`2017년 발전량(kWh)` has 9 (39.1%) zeros	Zeros
`2018년 발전량(kWh)` has 7 (30.4%) zeros	Zeros
`2019년 발전량(kWh)` has 3 (13.0%) zeros	Zeros
`2020년 발전량(kWh)` has 1 (4.3%) zeros	Zeros
`2021년 발전량(kWh)` has 1 (4.3%) zeros	Zeros

Reproduction

Analysis started	2024-03-15 00:41:03.767550
Analysis finished	2024-03-15 00:41:36.252158
Duration	32.48 seconds
Software version	ydata-profiling vv4.5.1
Download configuration	config.json

연번
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	23
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12

Minimum	1
Maximum	23
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	1
5-th percentile	2.1
Q1	6.5
median	12
Q3	17.5
95-th percentile	21.9
Maximum	23
Range	22
Interquartile range (IQR)	11

Descriptive statistics

Standard deviation	6.78233
Coefficient of variation (CV)	0.56519417
Kurtosis	-1.2
Mean	12
Median Absolute Deviation (MAD)	6
Skewness	0
Sum	276
Variance	46
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
1	1	4.3%
2	1	4.3%
23	1	4.3%
22	1	4.3%
21	1	4.3%
20	1	4.3%
19	1	4.3%
18	1	4.3%
17	1	4.3%
16	1	4.3%
Other values (13)	13	56.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	4.3%
2	1	4.3%
3	1	4.3%
4	1	4.3%
5	1	4.3%
6	1	4.3%
7	1	4.3%
8	1	4.3%
9	1	4.3%
10	1	4.3%

Value	Count	Frequency (%)
23	1	4.3%
22	1	4.3%
21	1	4.3%
20	1	4.3%
19	1	4.3%
18	1	4.3%
17	1	4.3%
16	1	4.3%
15	1	4.3%
14	1	4.3%

단체명
Categorical

CONSTANT

Distinct	1
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Memory size	312.0 B

종로구	23

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	종로구
2nd row	종로구
3rd row	종로구
4th row	종로구
5th row	종로구

Common Values

Value	Count	Frequency (%)
종로구	23	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
종로구	23	100.0%

설치연도
Real number (ℝ)

HIGH CORRELATION

Distinct	10
Distinct (%)	43.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2014.087

Minimum	2009
Maximum	2021
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	2009
5-th percentile	2009
Q1	2009.5
median	2015
Q3	2017.5
95-th percentile	2018
Maximum	2021
Range	12
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	3.9417698
Coefficient of variation (CV)	0.0019571001
Kurtosis	-1.4541638
Mean	2014.087
Median Absolute Deviation (MAD)	3
Skewness	-0.14890424
Sum	46324
Variance	15.537549
Monotonicity	Increasing

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2009	6	26.1%
2018	5	21.7%
2015	3	13.0%
2017	3	13.0%
2010	1	4.3%
2011	1	4.3%
2012	1	4.3%
2014	1	4.3%
2016	1	4.3%
2021	1	4.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
2009	6	26.1%
2010	1	4.3%
2011	1	4.3%
2012	1	4.3%
2014	1	4.3%
2015	3	13.0%
2016	1	4.3%
2017	3	13.0%
2018	5	21.7%
2021	1	4.3%

Value	Count	Frequency (%)
2021	1	4.3%
2018	5	21.7%
2017	3	13.0%
2016	1	4.3%
2015	3	13.0%
2014	1	4.3%
2012	1	4.3%
2011	1	4.3%
2010	1	4.3%
2009	6	26.1%

설치장소
Text

UNIQUE

Distinct	23
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	312.0 B

Length

Max length	28
Median length	16
Mean length	9.9130435
Min length	5

Characters and Unicode

Total characters	228
Distinct characters	89
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23 ?
Unique (%)	100.0%

Sample

1st row	평창동주민센터
2nd row	삼청동주민센터
3rd row	종로노인복지관(별관)
4th row	무악어린이집
5th row	청운어린이집

Value	Count	Frequency (%)
평창동주민센터	1	3.6%
삼청동주민센터	1	3.6%
착한주차안내소	1	3.6%
부암경로당	1	3.6%
와룡공영주차장	1	3.6%
인왕산도시자연공원청운화장실	1	3.6%
삼청공원공중화장실1	1	3.6%
환경미화원휴게소	1	3.6%
청사	1	3.6%
종로1234가동	1	3.6%
Other values (18)	18	64.3%

Most occurring characters

Value	Count	Frequency (%)
종	13	5.7%
로	10	4.4%
관	10	4.4%
센	8	3.5%
터	8	3.5%
지	7	3.1%
동	6	2.6%
복	6	2.6%
인	6	2.6%
이	5	2.2%
Other values (79)	149	65.4%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	212	93.0%
Space Separator	5	2.2%
Decimal Number	5	2.2%
Open Punctuation	3	1.3%
Close Punctuation	3	1.3%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
종	13	6.1%
로	10	4.7%
관	10	4.7%
센	8	3.8%
터	8	3.8%
지	7	3.3%
동	6	2.8%
복	6	2.8%
인	6	2.8%
이	5	2.4%
Other values (72)	133	62.7%

Decimal Number

Value	Count	Frequency (%)
1	2	40.0%
2	1	20.0%
3	1	20.0%
4	1	20.0%

Space Separator

Value	Count	Frequency (%)
	5	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	3	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	212	93.0%
Common	16	7.0%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
종	13	6.1%
로	10	4.7%
관	10	4.7%
센	8	3.8%
터	8	3.8%
지	7	3.3%
동	6	2.8%
복	6	2.8%
인	6	2.8%
이	5	2.4%
Other values (72)	133	62.7%

Common

Value	Count	Frequency (%)
	5	31.2%
(	3	18.8%
)	3	18.8%
1	2	12.5%
2	1	6.2%
3	1	6.2%
4	1	6.2%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	212	93.0%
ASCII	16	7.0%

Most frequent character per block

Hangul

Value	Count	Frequency (%)
종	13	6.1%
로	10	4.7%
관	10	4.7%
센	8	3.8%
터	8	3.8%
지	7	3.3%
동	6	2.8%
복	6	2.8%
인	6	2.8%
이	5	2.4%
Other values (72)	133	62.7%

ASCII

Value	Count	Frequency (%)
	5	31.2%
(	3	18.8%
)	3	18.8%
1	2	12.5%
2	1	6.2%
3	1	6.2%
4	1	6.2%

도로명주소
Text

UNIQUE

Distinct	23
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	312.0 B

Length

Max length	20
Median length	19
Mean length	17.913043
Min length	16

Characters and Unicode

Total characters	412
Distinct characters	56
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	23 ?
Unique (%)	100.0%

Sample

1st row	서울특별시 종로구 평창문화로 65
2nd row	서울특별시 종로구 삼청동 1051
3rd row	서울특별시 종로구 이화동251
4th row	서울특별시 종로구 무악동 79
5th row	서울특별시 종로구 청운동 63

Value	Count	Frequency (%)
서울특별시	23	25.6%
종로구	23	25.6%
통일로14길	2	2.2%
청운동	2	2.2%
성균관로	1	1.1%
신문로2가	1	1.1%
인왕산로1길	1	1.1%
21	1	1.1%
36	1	1.1%
이화동	1	1.1%
Other values (34)	34	37.8%

Most occurring characters

Value	Count	Frequency (%)
	67	16.3%
로	34	8.3%
서	23	5.6%
울	23	5.6%
특	23	5.6%
별	23	5.6%
시	23	5.6%
종	23	5.6%
구	23	5.6%
1	15	3.6%
Other values (46)	135	32.8%

Most occurring categories

Value	Count	Frequency (%)
Other Letter	269	65.3%
Decimal Number	76	18.4%
Space Separator	67	16.3%

Most frequent character per category

Other Letter

Value	Count	Frequency (%)
로	34	12.6%
서	23	8.6%
울	23	8.6%
특	23	8.6%
별	23	8.6%
시	23	8.6%
종	23	8.6%
구	23	8.6%
동	10	3.7%
길	8	3.0%
Other values (35)	56	20.8%

Decimal Number

Value	Count	Frequency (%)
1	15	19.7%
3	10	13.2%
4	9	11.8%
7	8	10.5%
2	8	10.5%
6	7	9.2%
5	7	9.2%
0	6	7.9%
9	4	5.3%
8	2	2.6%

Space Separator

Value	Count	Frequency (%)
	67	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Hangul	269	65.3%
Common	143	34.7%

Most frequent character per script

Hangul

Value	Count	Frequency (%)
로	34	12.6%
서	23	8.6%
울	23	8.6%
특	23	8.6%
별	23	8.6%
시	23	8.6%
종	23	8.6%
구	23	8.6%
동	10	3.7%
길	8	3.0%
Other values (35)	56	20.8%

Common

Value	Count	Frequency (%)
	67	46.9%
1	15	10.5%
3	10	7.0%
4	9	6.3%
7	8	5.6%
2	8	5.6%
6	7	4.9%
5	7	4.9%
0	6	4.2%
9	4	2.8%

Most occurring blocks

Value	Count	Frequency (%)
Hangul	269	65.3%
ASCII	143	34.7%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	67	46.9%
1	15	10.5%
3	10	7.0%
4	9	6.3%
7	8	5.6%
2	8	5.6%
6	7	4.9%
5	7	4.9%
0	6	4.2%
9	4	2.8%

Hangul

Value	Count	Frequency (%)
로	34	12.6%
서	23	8.6%
울	23	8.6%
특	23	8.6%
별	23	8.6%
시	23	8.6%
종	23	8.6%
구	23	8.6%
동	10	3.7%
길	8	3.0%
Other values (35)	56	20.8%

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

HIGH CORRELATION

Distinct	16
Distinct (%)	69.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19.135652

Minimum	3
Maximum	160
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	3
5-th percentile	3.46
Q1	4.7
median	10
Q3	22.85
95-th percentile	32.94
Maximum	160
Range	157
Interquartile range (IQR)	18.15

Descriptive statistics

Standard deviation	32.450031
Coefficient of variation (CV)	1.6957892
Kurtosis	17.790213
Mean	19.135652
Median Absolute Deviation (MAD)	6
Skewness	4.0318152
Sum	440.12
Variance	1053.0045
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=16)

Value	Count	Frequency (%)
10.0	5	21.7%
5.0	2	8.7%
3.46	2	8.7%
4.0	2	8.7%
5.2	1	4.3%
32.0	1	4.3%
160.0	1	4.3%
18.2	1	4.3%
27.5	1	4.3%
28.8	1	4.3%
Other values (6)	6	26.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.0	1	4.3%
3.46	2	8.7%
4.0	2	8.7%
4.4	1	4.3%
5.0	2	8.7%
5.2	1	4.3%
6.3	1	4.3%
10.0	5	21.7%
14.4	1	4.3%
18.2	1	4.3%

Value	Count	Frequency (%)
160.0	1	4.3%
33.0	1	4.3%
32.4	1	4.3%
32.0	1	4.3%
28.8	1	4.3%
27.5	1	4.3%
18.2	1	4.3%
14.4	1	4.3%
10.0	5	21.7%
6.3	1	4.3%

설치비(백만원)
Real number (ℝ)

HIGH CORRELATION

Distinct	19
Distinct (%)	82.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	77.434783

Minimum	8
Maximum	321
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	8
5-th percentile	8.5
Q1	36
median	78
Q3	89.5
95-th percentile	157.6
Maximum	321
Range	313
Interquartile range (IQR)	53.5

Descriptive statistics

Standard deviation	68.039979
Coefficient of variation (CV)	0.87867463
Kurtosis	6.8388185
Mean	77.434783
Median Absolute Deviation (MAD)	34
Skewness	2.1750365
Sum	1781
Variance	4629.4387
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
78	2	8.7%
8	2	8.7%
136	2	8.7%
87	2	8.7%
65	1	4.3%
90	1	4.3%
321	1	4.3%
57	1	4.3%
14	1	4.3%
15	1	4.3%
Other values (9)	9	39.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	2	8.7%
13	1	4.3%
14	1	4.3%
15	1	4.3%
31	1	4.3%
41	1	4.3%
44	1	4.3%
45	1	4.3%
57	1	4.3%
65	1	4.3%

Value	Count	Frequency (%)
321	1	4.3%
160	1	4.3%
136	2	8.7%
98	1	4.3%
90	1	4.3%
89	1	4.3%
87	2	8.7%
80	1	4.3%
78	2	8.7%
65	1	4.3%

2016년 발전량(kWh)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	13
Distinct (%)	56.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6409.1304

Minimum	0
Maximum	40501
Zeros	11
Zeros (%)	47.8%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2386
Q3	9964
95-th percentile	25063.4
Maximum	40501
Range	40501
Interquartile range (IQR)	9964

Descriptive statistics

Standard deviation	9924.2637
Coefficient of variation (CV)	1.5484571
Kurtosis	5.9857556
Mean	6409.1304
Median Absolute Deviation (MAD)	2386
Skewness	2.3037604
Sum	147410
Variance	98491010
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
0	11	47.8%
5901	1	4.3%
9784	1	4.3%
10144	1	4.3%
11314	1	4.3%
2643	1	4.3%
11434	1	4.3%
5536	1	4.3%
2386	1	4.3%
12926	1	4.3%
Other values (3)	3	13.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11	47.8%
2386	1	4.3%
2643	1	4.3%
5536	1	4.3%
5901	1	4.3%
8429	1	4.3%
9784	1	4.3%
10144	1	4.3%
11314	1	4.3%
11434	1	4.3%

Value	Count	Frequency (%)
40501	1	4.3%
26412	1	4.3%
12926	1	4.3%
11434	1	4.3%
11314	1	4.3%
10144	1	4.3%
9784	1	4.3%
8429	1	4.3%
5901	1	4.3%
5536	1	4.3%

2017년 발전량(kWh)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	15
Distinct (%)	65.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8379.3043

Minimum	0
Maximum	37048
Zeros	9
Zeros (%)	39.1%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	5048
Q3	10901
95-th percentile	32322.6
Maximum	37048
Range	37048
Interquartile range (IQR)	10901

Descriptive statistics

Standard deviation	10719.357
Coefficient of variation (CV)	1.2792658
Kurtosis	2.0529872
Mean	8379.3043
Median Absolute Deviation (MAD)	5048
Skewness	1.6190676
Sum	192724
Variance	1.1490462 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=15)

Value	Count	Frequency (%)
0	9	39.1%
5510	1	4.3%
10213	1	4.3%
10683	1	4.3%
11017	1	4.3%
3840	1	4.3%
11923	1	4.3%
5048	1	4.3%
27675	1	4.3%
12556	1	4.3%
Other values (5)	5	21.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9	39.1%
3840	1	4.3%
4908	1	4.3%
5048	1	4.3%
5510	1	4.3%
8679	1	4.3%
10213	1	4.3%
10683	1	4.3%
10785	1	4.3%
11017	1	4.3%

Value	Count	Frequency (%)
37048	1	4.3%
32839	1	4.3%
27675	1	4.3%
12556	1	4.3%
11923	1	4.3%
11017	1	4.3%
10785	1	4.3%
10683	1	4.3%
10213	1	4.3%
8679	1	4.3%

2018년 발전량(kWh)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	17
Distinct (%)	73.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11420.478

Minimum	0
Maximum	38660
Zeros	7
Zeros (%)	30.4%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	7248
Q3	16738.5
95-th percentile	37347.5
Maximum	38660
Range	38660
Interquartile range (IQR)	16738.5

Descriptive statistics

Standard deviation	13071.949
Coefficient of variation (CV)	1.1446061
Kurtosis	-0.028466534
Mean	11420.478
Median Absolute Deviation (MAD)	7248
Skewness	1.1206201
Sum	262671
Variance	1.7087586 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=17)

Value	Count	Frequency (%)
0	7	30.4%
5850	1	4.3%
12880	1	4.3%
20597	1	4.3%
26275	1	4.3%
37010	1	4.3%
38660	1	4.3%
37385	1	4.3%
7248	1	4.3%
3148	1	4.3%
Other values (7)	7	30.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	30.4%
3148	1	4.3%
4560	1	4.3%
4760	1	4.3%
5850	1	4.3%
7248	1	4.3%
7814	1	4.3%
8858	1	4.3%
10200	1	4.3%
10571	1	4.3%

Value	Count	Frequency (%)
38660	1	4.3%
37385	1	4.3%
37010	1	4.3%
26855	1	4.3%
26275	1	4.3%
20597	1	4.3%
12880	1	4.3%
10571	1	4.3%
10200	1	4.3%
8858	1	4.3%

2019년 발전량(kWh)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	21
Distinct (%)	91.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11593.522

Minimum	0
Maximum	37232
Zeros	3
Zeros (%)	13.0%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	0
5-th percentile	0
Q1	3592
median	7314
Q3	14255.5
95-th percentile	36232.9
Maximum	37232
Range	37232
Interquartile range (IQR)	10663.5

Descriptive statistics

Standard deviation	12037.422
Coefficient of variation (CV)	1.0382886
Kurtosis	0.34621984
Mean	11593.522
Median Absolute Deviation (MAD)	4449
Skewness	1.247013
Sum	266651
Variance	1.4489952 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=21)

Value	Count	Frequency (%)
0	3	13.0%
5904	1	4.3%
36106	1	4.3%
4687	1	4.3%
3694	1	4.3%
21578	1	4.3%
4079	1	4.3%
2800	1	4.3%
16748	1	4.3%
37232	1	4.3%
Other values (11)	11	47.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3	13.0%
2143	1	4.3%
2800	1	4.3%
3490	1	4.3%
3694	1	4.3%
4079	1	4.3%
4316	1	4.3%
4687	1	4.3%
5904	1	4.3%
7314	1	4.3%

Value	Count	Frequency (%)
37232	1	4.3%
36247	1	4.3%
36106	1	4.3%
28276	1	4.3%
21578	1	4.3%
16748	1	4.3%
11763	1	4.3%
10797	1	4.3%
10644	1	4.3%
9887	1	4.3%

2020년 발전량(kWh)
Real number (ℝ)

HIGH CORRELATION UNIQUE ZEROS

Distinct	23
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12625.429

Minimum	0
Maximum	37925
Zeros	1
Zeros (%)	4.3%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	0
5-th percentile	3196.7165
Q1	4293
median	9468.8746
Q3	15461.5
95-th percentile	35159.561
Maximum	37925
Range	37925
Interquartile range (IQR)	11168.5

Descriptive statistics

Standard deviation	11431.805
Coefficient of variation (CV)	0.90545869
Kurtosis	0.26085752
Mean	12625.429
Median Absolute Deviation (MAD)	5553.8746
Skewness	1.2193231
Sum	290384.87
Variance	1.3068616 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
6040.0	1	4.3%
9468.874598	1	4.3%
0.0	1	4.3%
3915.0	1	4.3%
3437.0	1	4.3%
18263.0	1	4.3%
3688.0	1	4.3%
3448.0	1	4.3%
5146.098901	1	4.3%
22825.0	1	4.3%
Other values (13)	13	56.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.0	1	4.3%
3170.018315	1	4.3%
3437.0	1	4.3%
3448.0	1	4.3%
3688.0	1	4.3%
3915.0	1	4.3%
4671.0	1	4.3%
5146.098901	1	4.3%
6040.0	1	4.3%
6264.27	1	4.3%

Value	Count	Frequency (%)
37925.0	1	4.3%
35210.0	1	4.3%
34705.6129	1	4.3%
28992.0	1	4.3%
22825.0	1	4.3%
18263.0	1	4.3%
12660.0	1	4.3%
11684.0	1	4.3%
11199.0	1	4.3%
10929.0	1	4.3%

2021년 발전량(kWh)
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	22
Distinct (%)	95.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11367.522

Minimum	0
Maximum	34881
Zeros	1
Zeros (%)	4.3%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	0
5-th percentile	1185.9
Q1	3931.5
median	6393
Q3	16333.5
95-th percentile	33816.4
Maximum	34881
Range	34881
Interquartile range (IQR)	12402

Descriptive statistics

Standard deviation	10275.575
Coefficient of variation (CV)	0.90394157
Kurtosis	0.45595144
Mean	11367.522
Median Absolute Deviation (MAD)	4038
Skewness	1.1778291
Sum	261453
Variance	1.0558745 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=22)

Value	Count	Frequency (%)
3498	2	8.7%
6253	1	4.3%
34881	1	4.3%
0	1	4.3%
4365	1	4.3%
20126	1	4.3%
2355	1	4.3%
4987	1	4.3%
21956	1	4.3%
34746	1	4.3%
Other values (12)	12	52.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	4.3%
1056	1	4.3%
2355	1	4.3%
3171	1	4.3%
3498	2	8.7%
4365	1	4.3%
4987	1	4.3%
5723	1	4.3%
5787	1	4.3%
6253	1	4.3%

Value	Count	Frequency (%)
34881	1	4.3%
34746	1	4.3%
25450	1	4.3%
22232	1	4.3%
21956	1	4.3%
20126	1	4.3%
12541	1	4.3%
11896	1	4.3%
10975	1	4.3%
9793	1	4.3%

2022년 발전량(kWh)
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	23
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	19685.783

Minimum	1622
Maximum	186425
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	335.0 B

Quantile statistics

Minimum	1622
5-th percentile	2439.1
Q1	5054.5
median	11165
Q3	19851
95-th percentile	34766.8
Maximum	186425
Range	184803
Interquartile range (IQR)	14796.5

Descriptive statistics

Standard deviation	37505.433
Coefficient of variation (CV)	1.9052041
Kurtosis	19.90046
Mean	19685.783
Median Absolute Deviation (MAD)	6751
Skewness	4.3405836
Sum	452773
Variance	1.4066575 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
6305	1	4.3%
9982	1	4.3%
186425	1	4.3%
4414	1	4.3%
3503	1	4.3%
20241	1	4.3%
3331	1	4.3%
2340	1	4.3%
4925	1	4.3%
19461	1	4.3%
Other values (13)	13	56.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1622	1	4.3%
2340	1	4.3%
3331	1	4.3%
3503	1	4.3%
4414	1	4.3%
4925	1	4.3%
5184	1	4.3%
5337	1	4.3%
5927	1	4.3%
6305	1	4.3%

Value	Count	Frequency (%)
186425	1	4.3%
35540	1	4.3%
27808	1	4.3%
25830	1	4.3%
23722	1	4.3%
20241	1	4.3%
19461	1	4.3%
13900	1	4.3%
12310	1	4.3%
11798	1	4.3%

데이터기준일자
Categorical

CONSTANT

Distinct	1
Distinct (%)	4.3%
Missing	0
Missing (%)	0.0%
Memory size	312.0 B

2024-01-05	23

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2024-01-05
2nd row	2024-01-05
3rd row	2024-01-05
4th row	2024-01-05
5th row	2024-01-05

Common Values

Value	Count	Frequency (%)
2024-01-05	23	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2024-01-05	23	100.0%

Phik (φk)
Auto

Heatmap
Table

	연번	설치연도	설치장소	도로명주소	설비용량(KW)	설치비(백만원)	2016년 발전량(kWh)	2017년 발전량(kWh)	2018년 발전량(kWh)	2019년 발전량(kWh)	2020년 발전량(kWh)	2021년 발전량(kWh)	2022년 발전량(kWh)
연번	1.000	0.910	1.000	1.000	0.571	0.000	0.087	0.429	0.645	0.622	0.576	0.668	0.000
설치연도	0.910	1.000	1.000	1.000	0.853	0.760	0.678	0.713	0.000	0.000	0.755	0.531	0.753
설치장소	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
도로명주소	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000	1.000
설비용량(KW)	0.571	0.853	1.000	1.000	1.000	0.768	0.249	0.410	0.697	0.702	0.730	0.752	0.988
설치비(백만원)	0.000	0.760	1.000	1.000	0.768	1.000	0.354	0.503	0.636	0.601	0.714	0.602	0.730
2016년 발전량(kWh)	0.087	0.678	1.000	1.000	0.249	0.354	1.000	0.896	0.817	0.791	0.507	0.465	0.210
2017년 발전량(kWh)	0.429	0.713	1.000	1.000	0.410	0.503	0.896	1.000	0.918	0.765	0.837	0.796	0.384
2018년 발전량(kWh)	0.645	0.000	1.000	1.000	0.697	0.636	0.817	0.918	1.000	0.961	0.926	0.844	0.634
2019년 발전량(kWh)	0.622	0.000	1.000	1.000	0.702	0.601	0.791	0.765	0.961	1.000	0.987	0.953	0.704
2020년 발전량(kWh)	0.576	0.755	1.000	1.000	0.730	0.714	0.507	0.837	0.926	0.987	1.000	0.978	0.744
2021년 발전량(kWh)	0.668	0.531	1.000	1.000	0.752	0.602	0.465	0.796	0.844	0.953	0.978	1.000	0.726
2022년 발전량(kWh)	0.000	0.753	1.000	1.000	0.988	0.730	0.210	0.384	0.634	0.704	0.744	0.726	1.000

Heatmap
Table

	연번	설치연도	설비용량(KW)	설치비(백만원)	2016년 발전량(kWh)	2017년 발전량(kWh)	2018년 발전량(kWh)	2019년 발전량(kWh)	2020년 발전량(kWh)	2021년 발전량(kWh)	2022년 발전량(kWh)
연번	1.000	0.984	-0.028	-0.175	-0.597	-0.492	-0.282	-0.119	-0.252	-0.178	-0.035
설치연도	0.984	1.000	-0.014	-0.147	-0.616	-0.506	-0.270	-0.109	-0.269	-0.177	-0.040
설비용량(KW)	-0.028	-0.014	1.000	0.943	0.323	0.574	0.715	0.616	0.727	0.646	0.965
설치비(백만원)	-0.175	-0.147	0.943	1.000	0.383	0.620	0.646	0.521	0.656	0.611	0.911
2016년 발전량(kWh)	-0.597	-0.616	0.323	0.383	1.000	0.856	0.576	0.497	0.493	0.361	0.304
2017년 발전량(kWh)	-0.492	-0.506	0.574	0.620	0.856	1.000	0.809	0.740	0.736	0.616	0.533
2018년 발전량(kWh)	-0.282	-0.270	0.715	0.646	0.576	0.809	1.000	0.933	0.884	0.815	0.674
2019년 발전량(kWh)	-0.119	-0.109	0.616	0.521	0.497	0.740	0.933	1.000	0.838	0.785	0.589
2020년 발전량(kWh)	-0.252	-0.269	0.727	0.656	0.493	0.736	0.884	0.838	1.000	0.903	0.722
2021년 발전량(kWh)	-0.178	-0.177	0.646	0.611	0.361	0.616	0.815	0.785	0.903	1.000	0.672
2022년 발전량(kWh)	-0.035	-0.040	0.965	0.911	0.304	0.533	0.674	0.589	0.722	0.672	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	연번	단체명	설치연도	설치장소	도로명주소	설비용량(KW)	설치비(백만원)	2016년 발전량(kWh)	2017년 발전량(kWh)	2018년 발전량(kWh)	2019년 발전량(kWh)	2020년 발전량(kWh)	2021년 발전량(kWh)	2022년 발전량(kWh)	데이터기준일자
0	1	종로구	2009	평창동주민센터	서울특별시 종로구 평창문화로 65	5.2	65	5901	5510	5850	5904	6040.0	6253	6305	2024-01-05
1	2	종로구	2009	삼청동주민센터	서울특별시 종로구 삼청동 1051	10.0	87	9784	10213	10200	9887	9468.874598	9771	9982	2024-01-05
2	3	종로구	2009	종로노인복지관(별관)	서울특별시 종로구 이화동251	10.0	80	10144	10683	10571	10644	10038.0	9793	11703	2024-01-05
3	4	종로구	2009	무악어린이집	서울특별시 종로구 무악동 79	10.0	78	11314	11017	8858	8946	10929.0	1056	11165	2024-01-05
4	5	종로구	2009	청운어린이집	서울특별시 종로구 청운동 63	5.0	41	2643	3840	4760	2143	6264.27	5723	5337	2024-01-05
5	6	종로구	2009	종로종합사회복지관	서울특별시 종로구 창신동 23344	10.0	78	11434	11923	7814	10797	12660.0	10975	11798	2024-01-05
6	7	종로구	2010	종로구육아종합지원센터	서울특별시 종로구 명륜3가 1471	10.0	87	0	0	0	0	11199.0	11896	13900	2024-01-05
7	8	종로구	2011	혜화동자치회관	서울특별시 종로구 혜화동 7430	4.4	31	5536	5048	4560	4316	4671.0	5787	5927	2024-01-05
8	9	종로구	2012	종로장애인복지관 및 푸르메재활센터	서울특별시 종로구 신교동 66	33.0	160	2386	27675	26855	28276	28992.0	25450	27808	2024-01-05
9	10	종로구	2014	무악동노인복지센터(종로노인종합복지관 분관 무악센터)	서울특별시 종로구 통일로14길 30	3.0	13	0	0	3148	3490	3170.018315	3171	1622	2024-01-05

	연번	단체명	설치연도	설치장소	도로명주소	설비용량(KW)	설치비(백만원)	2016년 발전량(kWh)	2017년 발전량(kWh)	2018년 발전량(kWh)	2019년 발전량(kWh)	2020년 발전량(kWh)	2021년 발전량(kWh)	2022년 발전량(kWh)	데이터기준일자
13	14	종로구	2016	무악동주민센터	서울특별시 종로구 통일로14길 36	32.4	89	26412	32839	38660	36247	37925.0	22232	23722	2024-01-05
14	15	종로구	2017	종로노인종합복지관	서울특별시 종로구 이화동 2501	32.0	98	0	4908	37010	37232	34705.6129	34746	25830	2024-01-05
15	16	종로구	2017	종로1234가동 청사	서울특별시 종로구 삼일대로30길 47	27.5	90	0	10785	26275	16748	22825.0	21956	19461	2024-01-05
16	17	종로구	2017	환경미화원휴게소	서울특별시 종로구 신문로2가 154	5.0	44	0	0	0	0	5146.098901	4987	4925	2024-01-05
17	18	종로구	2018	삼청공원공중화장실1	서울특별시 종로구 북촌로1343	4.0	15	0	0	0	2800	3448.0	3498	2340	2024-01-05
18	19	종로구	2018	인왕산도시자연공원청운화장실	서울특별시 종로구 청운동 727	4.0	14	0	0	0	4079	3688.0	2355	3331	2024-01-05
19	20	종로구	2018	와룡공영주차장	서울특별시 종로구 명륜길 28	18.2	57	0	0	20597	21578	18263.0	20126	20241	2024-01-05
20	21	종로구	2018	부암경로당	서울특별시 종로구 자하문로 260	3.46	8	0	0	0	3694	3437.0	3498	3503	2024-01-05
21	22	종로구	2018	착한주차안내소	서울특별시 종로구 율곡로19길 178	3.46	8	0	0	0	4687	3915.0	4365	4414	2024-01-05
22	23	종로구	2021	올림픽기념국민생활관	서울특별시 종로구 성균관로 91	160.0	321	0	0	0	0	0.0	0	186425	2024-01-05

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Space Separator

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

Hangul

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Other Letter

Decimal Number

Space Separator

Most occurring scripts

Most frequent character per script

Hangul

Common

Most occurring blocks

Most frequent character per block

ASCII

Hangul

Common Values

Length

Common Values (Plot)

Interactions

Correlations

Missing values

Sample