Overview

Dataset statistics

Number of variables12
Number of observations84
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory8.1 KiB
Average record size in memory98.6 B

Variable types

Categorical11
Numeric1

Dataset

Description한국지역난방공사에서 공급하는 온수, 냉수별 요금체계(계약종별, 용도별, 요금종별)에 대한 데이터로 금액, 요금적용기준에 대한 내용을 제공합니다. (2009년~)
Author한국지역난방공사
URLhttps://www.data.go.kr/data/3070430/fileData.do

Alerts

구분 is highly overall correlated with 금액 and 4 other fieldsHigh correlation
계약종별 is highly overall correlated with 구분 and 1 other fieldsHigh correlation
요금적용기준단위 is highly overall correlated with 금액 and 3 other fieldsHigh correlation
적용단위 is highly overall correlated with 금액 and 3 other fieldsHigh correlation
요금종별 is highly overall correlated with 금액 and 3 other fieldsHigh correlation
금액 is highly overall correlated with 구분 and 4 other fieldsHigh correlation
용도 is highly overall correlated with 구분 and 3 other fieldsHigh correlation
용량범위 is highly overall correlated with 금액 and 4 other fieldsHigh correlation
절기구분 is highly overall correlated with 용도 and 1 other fieldsHigh correlation
시간대별 차등 is highly overall correlated with 구분 and 1 other fieldsHigh correlation
냉동기종류 is highly overall correlated with 절기구분High correlation
용량범위 is highly imbalanced (62.2%)Imbalance
냉동기종류 is highly imbalanced (53.7%)Imbalance

Reproduction

Analysis started2023-12-11 22:53:31.772557
Analysis finished2023-12-11 22:53:33.159886
Duration1.39 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준일자
Categorical

Distinct3
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size804.0 B
2022-10-01
28 
2023-06-01
28 
2023-07-01
28 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-10-01
2nd row2022-10-01
3rd row2022-10-01
4th row2022-10-01
5th row2022-10-01

Common Values

ValueCountFrequency (%)
2022-10-01 28
33.3%
2023-06-01 28
33.3%
2023-07-01 28
33.3%

Length

2023-12-12T07:53:33.222304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:33.323069image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-10-01 28
33.3%
2023-06-01 28
33.3%
2023-07-01 28
33.3%

구분
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size804.0 B
온수
63 
냉수
21 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row온수
2nd row온수
3rd row온수
4th row온수
5th row온수

Common Values

ValueCountFrequency (%)
온수 63
75.0%
냉수 21
 
25.0%

Length

2023-12-12T07:53:33.450051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:33.572073image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
온수 63
75.0%
냉수 21
 
25.0%

계약종별
Categorical

HIGH CORRELATION 

Distinct4
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size804.0 B
주택용
21 
업무용
21 
공공용
21 
전체
21 

Length

Max length3
Median length3
Mean length2.75
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주택용
2nd row주택용
3rd row주택용
4th row주택용
5th row주택용

Common Values

ValueCountFrequency (%)
주택용 21
25.0%
업무용 21
25.0%
공공용 21
25.0%
전체 21
25.0%

Length

2023-12-12T07:53:33.714278image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:33.867422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주택용 21
25.0%
업무용 21
25.0%
공공용 21
25.0%
전체 21
25.0%

용도
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size804.0 B
냉방용
45 
난방용
39 

Length

Max length3
Median length3
Mean length3
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row난방용
2nd row난방용
3rd row난방용
4th row난방용
5th row난방용

Common Values

ValueCountFrequency (%)
냉방용 45
53.6%
난방용 39
46.4%

Length

2023-12-12T07:53:34.026559image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:34.163094image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
냉방용 45
53.6%
난방용 39
46.4%

요금종별
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)2.4%
Missing0
Missing (%)0.0%
Memory size804.0 B
사용요금
63 
기본요금
21 

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 (%)
사용요금 63
75.0%
기본요금 21
 
25.0%

Length

2023-12-12T07:53:34.281708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:34.398309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
사용요금 63
75.0%
기본요금 21
 
25.0%

금액
Real number (ℝ)

HIGH CORRELATION 

Distinct43
Distinct (%)51.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean424.97619
Minimum25.11
Maximum3822
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size888.0 B
2023-12-12T07:53:34.549356image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum25.11
5-th percentile25.11
Q175.0525
median104.16
Q3135.41
95-th percentile2124
Maximum3822
Range3796.89
Interquartile range (IQR)60.3575

Descriptive statistics

Standard deviation850.72035
Coefficient of variation (CV)2.0018071
Kurtosis7.7585302
Mean424.97619
Median Absolute Deviation (MAD)31.25
Skewness2.8257047
Sum35698
Variance723725.11
MonotonicityNot monotonic
2023-12-12T07:53:34.721531image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)
ValueCountFrequency (%)
25.11 9
 
10.7%
101.91 4
 
4.8%
89.88 4
 
4.8%
116.69 4
 
4.8%
52.4 3
 
3.6%
104.16 3
 
3.6%
135.41 3
 
3.6%
1550.0 3
 
3.6%
1754.0 3
 
3.6%
2124.0 3
 
3.6%
Other values (33) 45
53.6%
ValueCountFrequency (%)
25.11 9
10.7%
29.87 3
 
3.6%
34.2 3
 
3.6%
52.4 3
 
3.6%
62.49 3
 
3.6%
79.24 1
 
1.2%
83.02 1
 
1.2%
88.06 1
 
1.2%
89.55 1
 
1.2%
89.88 4
4.8%
ValueCountFrequency (%)
3822.0 3
3.6%
2124.0 3
3.6%
1754.0 3
3.6%
1550.0 3
3.6%
396.79 3
3.6%
361.98 3
3.6%
151.66 1
 
1.2%
140.61 1
 
1.2%
135.41 3
3.6%
134.21 1
 
1.2%

요금적용기준단위
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size804.0 B
Mcal
63 
계약용량
18 
계약면적
 
3

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row계약면적
2nd rowMcal
3rd rowMcal
4th rowMcal
5th rowMcal

Common Values

ValueCountFrequency (%)
Mcal 63
75.0%
계약용량 18
 
21.4%
계약면적 3
 
3.6%

Length

2023-12-12T07:53:34.919998image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:35.078224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mcal 63
75.0%
계약용량 18
 
21.4%
계약면적 3
 
3.6%

용량범위
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct5
Distinct (%)6.0%
Missing0
Missing (%)0.0%
Memory size804.0 B
미해당
72 
0-1000
 
3
1001-2000
 
3
2001-3000
 
3
3000초과
 
3

Length

Max length9
Median length3
Mean length3.6428571
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row미해당
2nd row미해당
3rd row미해당
4th row미해당
5th row미해당

Common Values

ValueCountFrequency (%)
미해당 72
85.7%
0-1000 3
 
3.6%
1001-2000 3
 
3.6%
2001-3000 3
 
3.6%
3000초과 3
 
3.6%

Length

2023-12-12T07:53:35.217143image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:35.352064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미해당 72
85.7%
0-1000 3
 
3.6%
1001-2000 3
 
3.6%
2001-3000 3
 
3.6%
3000초과 3
 
3.6%

적용단위
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size804.0 B
Mcal
63 
Mcal/h
18 
m2
 
3

Length

Max length6
Median length4
Mean length4.3571429
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowm2
2nd rowMcal
3rd rowMcal
4th rowMcal
5th rowMcal

Common Values

ValueCountFrequency (%)
Mcal 63
75.0%
Mcal/h 18
 
21.4%
m2 3
 
3.6%

Length

2023-12-12T07:53:35.501549image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:35.634302image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
mcal 63
75.0%
mcal/h 18
 
21.4%
m2 3
 
3.6%

절기구분
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size804.0 B
미해당
48 
5~9월
15 
1~4월, 10~12월
9 
단일요금
 
3
춘추절기
 
3
Other values (2)
6 

Length

Max length12
Median length3
Mean length4.2142857
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row미해당
2nd row단일요금
3rd row춘추절기
4th row하절기
5th row동절기

Common Values

ValueCountFrequency (%)
미해당 48
57.1%
5~9월 15
 
17.9%
1~4월, 10~12월 9
 
10.7%
단일요금 3
 
3.6%
춘추절기 3
 
3.6%
하절기 3
 
3.6%
동절기 3
 
3.6%

Length

2023-12-12T07:53:35.775736image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:35.922081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미해당 48
51.6%
5~9월 15
 
16.1%
1~4월 9
 
9.7%
10~12월 9
 
9.7%
단일요금 3
 
3.2%
춘추절기 3
 
3.2%
하절기 3
 
3.2%
동절기 3
 
3.2%

시간대별 차등
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size804.0 B
미해당
57 
단일요금
6 
수요관리시간
6 
수요관리이외
6 
첨두부하시간
 
3
Other values (2)
6 

Length

Max length6
Median length3
Mean length3.7857143
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row미해당
2nd row미해당
3rd row미해당
4th row미해당
5th row미해당

Common Values

ValueCountFrequency (%)
미해당 57
67.9%
단일요금 6
 
7.1%
수요관리시간 6
 
7.1%
수요관리이외 6
 
7.1%
첨두부하시간 3
 
3.6%
중간부하시간 3
 
3.6%
경부하시간 3
 
3.6%

Length

2023-12-12T07:53:36.116763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:36.280311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미해당 57
67.9%
단일요금 6
 
7.1%
수요관리시간 6
 
7.1%
수요관리이외 6
 
7.1%
첨두부하시간 3
 
3.6%
중간부하시간 3
 
3.6%
경부하시간 3
 
3.6%

냉동기종류
Categorical

HIGH CORRELATION  IMBALANCE 

Distinct3
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size804.0 B
미해당
72 
1단냉동기
 
6
2단냉동기
 
6

Length

Max length5
Median length3
Mean length3.2857143
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row미해당
2nd row미해당
3rd row미해당
4th row미해당
5th row미해당

Common Values

ValueCountFrequency (%)
미해당 72
85.7%
1단냉동기 6
 
7.1%
2단냉동기 6
 
7.1%

Length

2023-12-12T07:53:36.457350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:53:36.605611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미해당 72
85.7%
1단냉동기 6
 
7.1%
2단냉동기 6
 
7.1%

Interactions

2023-12-12T07:53:32.513886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T07:53:36.706458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자구분계약종별용도요금종별금액요금적용기준단위용량범위적용단위절기구분시간대별 차등냉동기종류
기준일자1.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000
구분0.0001.0001.0000.7080.5670.8860.3020.5700.3020.4090.5520.109
계약종별0.0001.0001.0000.7330.5710.7300.4010.4190.4010.5580.4980.233
용도0.0000.7080.7331.0000.0000.4950.1100.2610.1100.5810.5240.215
요금종별0.0000.5670.5710.0001.0000.8861.0000.5701.0000.4090.2850.109
금액0.0000.8860.7300.4950.8861.0000.5261.0000.5260.0000.0000.000
요금적용기준단위0.0000.3020.4010.1101.0000.5261.0000.5741.0000.3360.1340.204
용량범위0.0000.5700.4190.2610.5701.0000.5741.0000.5740.0000.0000.000
적용단위0.0000.3020.4010.1101.0000.5261.0000.5741.0000.3360.1340.204
절기구분0.0000.4090.5580.5810.4090.0000.3360.0000.3361.0000.0000.672
시간대별 차등0.0000.5520.4980.5240.2850.0000.1340.0000.1340.0001.0000.000
냉동기종류0.0000.1090.2330.2150.1090.0000.2040.0000.2040.6720.0001.000
2023-12-12T07:53:36.845772image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구분용도시간대별 차등계약종별요금적용기준단위적용단위냉동기종류절기구분기준일자용량범위요금종별
구분1.0000.5010.5750.9880.4850.4850.1780.4240.0000.6760.384
용도0.5011.0000.5440.5190.1810.1810.3490.6060.0000.3120.000
시간대별 차등0.5750.5441.0000.3580.0830.0830.0000.0000.0000.0000.294
계약종별0.9880.5190.3581.0000.3890.3890.2200.4100.0000.3510.386
요금적용기준단위0.4850.1810.0830.3891.0001.0000.0610.2320.0000.5140.994
적용단위0.4850.1810.0830.3891.0001.0000.0610.2320.0000.5140.994
냉동기종류0.1780.3490.0000.2200.0610.0611.0000.5650.0000.0000.178
절기구분0.4240.6060.0000.4100.2320.2320.5651.0000.0000.0000.424
기준일자0.0000.0000.0000.0000.0000.0000.0000.0001.0000.0000.000
용량범위0.6760.3120.0000.3510.5140.5140.0000.0000.0001.0000.676
요금종별0.3840.0000.2940.3860.9940.9940.1780.4240.0000.6761.000
2023-12-12T07:53:36.994738image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
금액기준일자구분계약종별용도요금종별요금적용기준단위용량범위적용단위절기구분시간대별 차등냉동기종류
금액1.0000.0000.6850.3680.3310.6850.5250.9940.5250.0000.0000.000
기준일자0.0001.0000.0000.0000.0000.0000.0000.0000.0000.0000.0000.000
구분0.6850.0001.0000.9880.5010.3840.4850.6760.4850.4240.5750.178
계약종별0.3680.0000.9881.0000.5190.3860.3890.3510.3890.4100.3580.220
용도0.3310.0000.5010.5191.0000.0000.1810.3120.1810.6060.5440.349
요금종별0.6850.0000.3840.3860.0001.0000.9940.6760.9940.4240.2940.178
요금적용기준단위0.5250.0000.4850.3890.1810.9941.0000.5141.0000.2320.0830.061
용량범위0.9940.0000.6760.3510.3120.6760.5141.0000.5140.0000.0000.000
적용단위0.5250.0000.4850.3890.1810.9941.0000.5141.0000.2320.0830.061
절기구분0.0000.0000.4240.4100.6060.4240.2320.0000.2321.0000.0000.565
시간대별 차등0.0000.0000.5750.3580.5440.2940.0830.0000.0830.0001.0000.000
냉동기종류0.0000.0000.1780.2200.3490.1780.0610.0000.0610.5650.0001.000

Missing values

2023-12-12T07:53:32.928918image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:53:33.096253image/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

기준일자구분계약종별용도요금종별금액요금적용기준단위용량범위적용단위절기구분시간대별 차등냉동기종류
02022-10-01온수주택용난방용기본요금52.4계약면적미해당m2미해당미해당미해당
12022-10-01온수주택용난방용사용요금89.88Mcal미해당Mcal단일요금미해당미해당
22022-10-01온수주택용난방용사용요금88.06Mcal미해당Mcal춘추절기미해당미해당
32022-10-01온수주택용난방용사용요금79.24Mcal미해당Mcal하절기미해당미해당
42022-10-01온수주택용난방용사용요금92.5Mcal미해당Mcal동절기미해당미해당
52022-10-01온수주택용냉방용사용요금25.11Mcal미해당Mcal5~9월미해당미해당
62022-10-01온수주택용냉방용사용요금89.88Mcal미해당Mcal1~4월, 10~12월미해당미해당
72022-10-01온수업무용난방용기본요금396.79계약용량미해당Mcal/h미해당미해당미해당
82022-10-01온수업무용난방용사용요금116.69Mcal미해당Mcal미해당단일요금미해당
92022-10-01온수업무용난방용사용요금134.21Mcal미해당Mcal미해당수요관리시간미해당
기준일자구분계약종별용도요금종별금액요금적용기준단위용량범위적용단위절기구분시간대별 차등냉동기종류
742023-07-01온수공공용냉방용사용요금29.87Mcal미해당Mcal5~9월미해당1단냉동기
752023-07-01온수공공용냉방용사용요금25.11Mcal미해당Mcal5~9월미해당2단냉동기
762023-07-01온수공공용냉방용사용요금101.91Mcal미해당Mcal1~4월, 10~12월미해당미해당
772023-07-01냉수전체냉방용기본요금3822.0계약용량0-1000Mcal/h미해당미해당미해당
782023-07-01냉수전체냉방용기본요금2124.0계약용량1001-2000Mcal/h미해당미해당미해당
792023-07-01냉수전체냉방용기본요금1754.0계약용량2001-3000Mcal/h미해당미해당미해당
802023-07-01냉수전체냉방용기본요금1550.0계약용량3000초과Mcal/h미해당미해당미해당
812023-07-01냉수전체냉방용사용요금135.41Mcal미해당Mcal미해당첨두부하시간미해당
822023-07-01냉수전체냉방용사용요금104.16Mcal미해당Mcal미해당중간부하시간미해당
832023-07-01냉수전체냉방용사용요금62.49Mcal미해당Mcal미해당경부하시간미해당