Overview

Dataset statistics

Number of variables7
Number of observations153
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory9.2 KiB
Average record size in memory61.9 B

Variable types

Numeric5
Categorical2

Dataset

Description한국지역난방공사에서 제공하는 태양광 판매 정보와 관련하여 실적년월, 열공급시설 구분, 판매량, 단가, 금액 구분에 따른 정보를 제공합니다
Author한국지역난방공사
URLhttps://www.data.go.kr/data/15123995/fileData.do

Alerts

실적년월 is highly overall correlated with 단가High correlation
열공급시설ID is highly overall correlated with 판매량 and 2 other fieldsHigh correlation
판매량 is highly overall correlated with 열공급시설ID and 2 other fieldsHigh correlation
단가 is highly overall correlated with 실적년월High correlation
금액 is highly overall correlated with 열공급시설ID and 1 other fieldsHigh correlation
열공급시설 is highly overall correlated with 열공급시설ID and 2 other fieldsHigh correlation
호기 is highly overall correlated with 열공급시설High correlation
판매량 has unique valuesUnique
금액 has unique valuesUnique
단가 has 26 (17.0%) zerosZeros

Reproduction

Analysis started2023-12-12 17:25:11.471109
Analysis finished2023-12-12 17:25:14.885561
Duration3.41 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

실적년월
Real number (ℝ)

HIGH CORRELATION 

Distinct8
Distinct (%)5.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean202304.49
Minimum202301
Maximum202308
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T02:25:14.945831image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum202301
5-th percentile202301
Q1202303
median202304
Q3202306
95-th percentile202308
Maximum202308
Range7
Interquartile range (IQR)3

Descriptive statistics

Standard deviation2.2944947
Coefficient of variation (CV)1.1341788 × 10-5
Kurtosis-1.2361785
Mean202304.49
Median Absolute Deviation (MAD)2
Skewness0.011125821
Sum30952587
Variance5.2647059
MonotonicityDecreasing
2023-12-13T02:25:15.069006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=8)
ValueCountFrequency (%)
202303 20
13.1%
202308 19
12.4%
202307 19
12.4%
202306 19
12.4%
202305 19
12.4%
202304 19
12.4%
202302 19
12.4%
202301 19
12.4%
ValueCountFrequency (%)
202301 19
12.4%
202302 19
12.4%
202303 20
13.1%
202304 19
12.4%
202305 19
12.4%
202306 19
12.4%
202307 19
12.4%
202308 19
12.4%
ValueCountFrequency (%)
202308 19
12.4%
202307 19
12.4%
202306 19
12.4%
202305 19
12.4%
202304 19
12.4%
202303 20
13.1%
202302 19
12.4%
202301 19
12.4%

열공급시설ID
Real number (ℝ)

HIGH CORRELATION 

Distinct15
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean740.6732
Minimum703
Maximum783
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T02:25:15.183347image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum703
5-th percentile709.6
Q1718
median730
Q3781
95-th percentile782.4
Maximum783
Range80
Interquartile range (IQR)63

Descriptive statistics

Standard deviation28.481257
Coefficient of variation (CV)0.038453202
Kurtosis-1.3550485
Mean740.6732
Median Absolute Deviation (MAD)13
Skewness0.60543616
Sum113323
Variance811.18197
MonotonicityNot monotonic
2023-12-13T02:25:15.299639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
781 24
15.7%
732 16
 
10.5%
714 16
 
10.5%
723 9
 
5.9%
782 8
 
5.2%
718 8
 
5.2%
721 8
 
5.2%
722 8
 
5.2%
703 8
 
5.2%
730 8
 
5.2%
Other values (5) 40
26.1%
ValueCountFrequency (%)
703 8
5.2%
714 16
10.5%
717 8
5.2%
718 8
5.2%
721 8
5.2%
722 8
5.2%
723 9
5.9%
728 8
5.2%
730 8
5.2%
732 16
10.5%
ValueCountFrequency (%)
783 8
 
5.2%
782 8
 
5.2%
781 24
15.7%
780 8
 
5.2%
733 8
 
5.2%
732 16
10.5%
730 8
 
5.2%
728 8
 
5.2%
723 9
 
5.9%
722 8
 
5.2%

열공급시설
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
광양함태양광
24 
세종열공급시설
16 
분당열공급시설
16 
판교열공급시설
9 
미래개발원태양광
 
8
Other values (10)
80 

Length

Max length9
Median length7
Mean length6.7908497
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row광양함태양광
2nd row세종열공급시설
3rd row세종열공급시설
4th row미래개발원태양광
5th row장안열공급시설

Common Values

ValueCountFrequency (%)
광양함태양광 24
15.7%
세종열공급시설 16
 
10.5%
분당열공급시설 16
 
10.5%
판교열공급시설 9
 
5.9%
미래개발원태양광 8
 
5.2%
장안열공급시설 8
 
5.2%
화성열공급시설 8
 
5.2%
파주열공급시설 8
 
5.2%
강남열공급시설 8
 
5.2%
광교열공급시설 8
 
5.2%
Other values (5) 40
26.1%

Length

2023-12-13T02:25:15.437164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
광양함태양광 24
15.7%
세종열공급시설 16
 
10.5%
분당열공급시설 16
 
10.5%
판교열공급시설 9
 
5.9%
미래개발원태양광 8
 
5.2%
장안열공급시설 8
 
5.2%
화성열공급시설 8
 
5.2%
파주열공급시설 8
 
5.2%
강남열공급시설 8
 
5.2%
광교열공급시설 8
 
5.2%
Other values (5) 40
26.1%

호기
Categorical

HIGH CORRELATION 

Distinct9
Distinct (%)5.9%
Missing0
Missing (%)0.0%
Memory size1.3 KiB
1호기
104 
2호기
20 
2~4호기
 
8
3호기
 
8
주차장 태양광
 
5
Other values (4)
 
8

Length

Max length8
Median length3
Mean length3.2810458
Min length2

Unique

Unique2 ?
Unique (%)1.3%

Sample

1st row1호기
2nd row2호기
3rd row1호기
4th row1호기
5th row1호기

Common Values

ValueCountFrequency (%)
1호기 104
68.0%
2호기 20
 
13.1%
2~4호기 8
 
5.2%
3호기 8
 
5.2%
주차장 태양광 5
 
3.3%
2호 4
 
2.6%
주차장 태양광 2
 
1.3%
1호 1
 
0.7%
주차장태양 1
 
0.7%

Length

2023-12-13T02:25:15.546751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T02:25:15.649010image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
1호기 104
65.0%
2호기 20
 
12.5%
2~4호기 8
 
5.0%
3호기 8
 
5.0%
주차장 7
 
4.4%
태양광 7
 
4.4%
2호 4
 
2.5%
1호 1
 
0.6%
주차장태양 1
 
0.6%

판매량
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct153
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean47547.235
Minimum0
Maximum407277
Zeros1
Zeros (%)0.7%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T02:25:15.756610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile4357.4
Q18534
median26658
Q349308
95-th percentile196707.4
Maximum407277
Range407277
Interquartile range (IQR)40774

Descriptive statistics

Standard deviation77939.725
Coefficient of variation (CV)1.6392062
Kurtosis12.073614
Mean47547.235
Median Absolute Deviation (MAD)18700
Skewness3.4590035
Sum7274727
Variance6.0746007 × 109
MonotonicityNot monotonic
2023-12-13T02:25:15.872823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
54594 1
 
0.7%
32640 1
 
0.7%
37048 1
 
0.7%
60474 1
 
0.7%
9818 1
 
0.7%
51440 1
 
0.7%
8534 1
 
0.7%
8237 1
 
0.7%
392957 1
 
0.7%
53467 1
 
0.7%
Other values (143) 143
93.5%
ValueCountFrequency (%)
0 1
0.7%
1 1
0.7%
2629 1
0.7%
3447 1
0.7%
3927 1
0.7%
4038 1
0.7%
4145 1
0.7%
4301 1
0.7%
4395 1
0.7%
4528 1
0.7%
ValueCountFrequency (%)
407277 1
0.7%
407266 1
0.7%
403513 1
0.7%
392957 1
0.7%
336631 1
0.7%
307059 1
0.7%
286028 1
0.7%
272518 1
0.7%
146167 1
0.7%
141919 1
0.7%

단가
Real number (ℝ)

HIGH CORRELATION  ZEROS 

Distinct14
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean143.59477
Minimum0
Maximum254
Zeros26
Zeros (%)17.0%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T02:25:15.985639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q1144
median154
Q3165
95-th percentile241
Maximum254
Range254
Interquartile range (IQR)21

Descriptive statistics

Standard deviation72.590546
Coefficient of variation (CV)0.5055236
Kurtosis0.20587955
Mean143.59477
Median Absolute Deviation (MAD)10
Skewness-0.93501428
Sum21970
Variance5269.3873
MonotonicityNot monotonic
2023-12-13T02:25:16.092944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
147 28
18.3%
0 26
17.0%
216 19
12.4%
144 14
9.2%
154 12
7.8%
160 12
7.8%
162 11
 
7.2%
165 7
 
4.6%
157 7
 
4.6%
254 7
 
4.6%
Other values (4) 10
 
6.5%
ValueCountFrequency (%)
0 26
17.0%
144 14
9.2%
147 28
18.3%
151 1
 
0.7%
153 1
 
0.7%
154 12
7.8%
157 7
 
4.6%
160 12
7.8%
161 1
 
0.7%
162 11
 
7.2%
ValueCountFrequency (%)
254 7
 
4.6%
241 7
 
4.6%
216 19
12.4%
165 7
 
4.6%
162 11
7.2%
161 1
 
0.7%
160 12
7.8%
157 7
 
4.6%
154 12
7.8%
153 1
 
0.7%

금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct153
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7788540.2
Minimum0
Maximum83829693
Zeros1
Zeros (%)0.7%
Negative0
Negative (%)0.0%
Memory size1.5 KiB
2023-12-13T02:25:16.210577image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile761603.2
Q11550455
median4296357
Q37558274
95-th percentile35962429
Maximum83829693
Range83829693
Interquartile range (IQR)6007819

Descriptive statistics

Standard deviation12988265
Coefficient of variation (CV)1.6676122
Kurtosis14.171143
Mean7788540.2
Median Absolute Deviation (MAD)2907365
Skewness3.6508572
Sum1.1916467 × 109
Variance1.6869502 × 1014
MonotonicityNot monotonic
2023-12-13T02:25:16.355560image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
8037328 1
 
0.7%
7046976 1
 
0.7%
7998663 1
 
0.7%
13056336 1
 
0.7%
2119706 1
 
0.7%
11105896 1
 
0.7%
1842490 1
 
0.7%
1778367 1
 
0.7%
83829693 1
 
0.7%
11543471 1
 
0.7%
Other values (143) 143
93.5%
ValueCountFrequency (%)
0 1
0.7%
147 1
0.7%
403603 1
0.7%
636340 1
0.7%
647031 1
0.7%
660289 1
0.7%
702533 1
0.7%
748450 1
0.7%
770372 1
0.7%
776489 1
0.7%
ValueCountFrequency (%)
83829693 1
0.7%
63416694 1
0.7%
61760146 1
0.7%
60585294 1
0.7%
55908326 1
0.7%
48658901 1
0.7%
45561672 1
0.7%
43945605 1
0.7%
30640312 1
0.7%
20995427 1
0.7%

Interactions

2023-12-13T02:25:14.261479image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:11.894302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.529034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:13.056619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:13.831895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:14.353559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.032620image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.640385image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:13.164730image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:13.913526image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:14.453963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.184624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.755564image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:13.279357image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:14.013663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:14.549094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.325098image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.873463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:13.656960image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:14.109111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:14.617294image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.442949image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:12.960303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:13.758409image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T02:25:14.185243image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T02:25:16.460881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
실적년월열공급시설ID열공급시설호기판매량단가금액
실적년월1.0000.0000.0000.0000.0000.8040.000
열공급시설ID0.0001.0001.0000.5330.5700.4470.414
열공급시설0.0001.0001.0000.8420.8270.6120.764
호기0.0000.5330.8421.0000.6110.2550.603
판매량0.0000.5700.8270.6111.0000.3170.979
단가0.8040.4470.6120.2550.3171.0000.433
금액0.0000.4140.7640.6030.9790.4331.000
2023-12-13T02:25:16.560582image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
열공급시설호기
열공급시설1.0000.534
호기0.5341.000
2023-12-13T02:25:16.646213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
실적년월열공급시설ID판매량단가금액열공급시설호기
실적년월1.0000.0020.045-0.685-0.0560.0000.000
열공급시설ID0.0021.0000.502-0.2900.5030.9660.307
판매량0.0450.5021.000-0.3250.9860.5310.354
단가-0.685-0.290-0.3251.000-0.2110.2960.147
금액-0.0560.5030.986-0.2111.0000.4470.348
열공급시설0.0000.9660.5310.2960.4471.0000.534
호기0.0000.3070.3540.1470.3480.5341.000

Missing values

2023-12-13T02:25:14.714006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T02:25:14.834125image/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

실적년월열공급시설ID열공급시설호기판매량단가금액
0202308781광양함태양광1호기5459408037328
1202308732세종열공급시설2호기539521477926088
2202308732세종열공급시설1호기92401471357448
3202308782미래개발원태양광1호기215781473176713
4202308718장안열공급시설1호기4772147702533
5202308721화성열공급시설1호기271791474001292
6202308722파주열공급시설1호기513401477558274
7202308703강남열공급시설1호기445501476558651
8202308730광교열공급시설1호기256521473776487
9202308714분당열공급시설2호기70701471040845
실적년월열공급시설ID열공급시설호기판매량단가금액
143202301718장안열공급시설1호기3927241945660
144202301717수원열공급시설1호기83182412003057
145202301781광양함태양광3호기259231604150531
146202301781광양함태양광2호기443381607098957
147202301781광양함태양광1호기491381607867485
148202301733광주전남열공급시설주차장 태양광222241603556804
149202301722파주열공급시설1호기354221605671416
150202301783강릉태양광2~4호기30705916048658901
151202301732세종열공급시설2호기403221606455955
152202301732세종열공급시설1호기61802411488205