Overview

Dataset statistics

Number of variables7
Number of observations37
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.3 KiB
Average record size in memory64.6 B

Variable types

Categorical2
Numeric5

Dataset

Description부산광역시_도시가스요금표_20240101
Author부산광역시
URLhttp://data.busan.go.kr/dataSet/detail.nm?contentId=10&publicdatapk=3076496

Alerts

도매요금(조정전) 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 용도별1High correlation
소비자요금(조정전) is highly overall correlated with 도매요금(조정전) and 3 other fieldsHigh correlation
소비자요금(조정후) is highly overall correlated with 도매요금(조정전) and 2 other fieldsHigh correlation
용도별1 is highly overall correlated with 도매요금(조정전) and 3 other fieldsHigh correlation

Reproduction

Analysis started2024-03-13 13:19:04.295056
Analysis finished2024-03-13 13:19:07.332977
Duration3.04 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

용도별1
Categorical

HIGH CORRELATION 

Distinct15
Distinct (%)40.5%
Missing0
Missing (%)0.0%
Memory size428.0 B
주택용
3 
영업용1
3 
영업용2
3 
냉난방공조용
3 
산업용1
3 
Other values (10)
22 

Length

Max length6
Median length4
Mean length4.3243243
Min length3

Unique

Unique4 ?
Unique (%)10.8%

Sample

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

Common Values

ValueCountFrequency (%)
주택용 3
8.1%
영업용1 3
8.1%
영업용2 3
8.1%
냉난방공조용 3
8.1%
산업용1 3
8.1%
산업용2 3
8.1%
산업용3 3
8.1%
산업용4 3
8.1%
산업용5 3
8.1%
열병합용1 3
8.1%
Other values (5) 7
18.9%

Length

2024-03-13T22:19:07.400990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
주택용 3
8.1%
영업용1 3
8.1%
영업용2 3
8.1%
냉난방공조용 3
8.1%
산업용1 3
8.1%
산업용2 3
8.1%
산업용3 3
8.1%
산업용4 3
8.1%
산업용5 3
8.1%
열병합용1 3
8.1%
Other values (5) 7
18.9%

용도별2
Categorical

Distinct7
Distinct (%)18.9%
Missing0
Missing (%)0.0%
Memory size428.0 B
동절기
10 
하절기
10 
기타월
10 
일반
4 
취사용
 
1
Other values (2)
2 

Length

Max length4
Median length3
Mean length2.9459459
Min length2

Unique

Unique3 ?
Unique (%)8.1%

Sample

1st row취사용
2nd row개별난방
3rd row중앙난방
4th row동절기
5th row하절기

Common Values

ValueCountFrequency (%)
동절기 10
27.0%
하절기 10
27.0%
기타월 10
27.0%
일반 4
 
10.8%
취사용 1
 
2.7%
개별난방 1
 
2.7%
중앙난방 1
 
2.7%

Length

2024-03-13T22:19:07.541199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-13T22:19:07.663725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동절기 10
27.0%
하절기 10
27.0%
기타월 10
27.0%
일반 4
 
10.8%
취사용 1
 
2.7%
개별난방 1
 
2.7%
중앙난방 1
 
2.7%

도매요금(조정전)
Real number (ℝ)

HIGH CORRELATION 

Distinct15
Distinct (%)40.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean18.973957
Minimum13.3995
Maximum21.4649
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2024-03-13T22:19:07.783588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum13.3995
5-th percentile17.71534
Q118.2509
median19.208
Q319.4395
95-th percentile21.1955
Maximum21.4649
Range8.0654
Interquartile range (IQR)1.1886

Descriptive statistics

Standard deviation1.3928512
Coefficient of variation (CV)0.073408578
Kurtosis6.1793789
Mean18.973957
Median Absolute Deviation (MAD)0.9073
Skewness-1.5173787
Sum702.0364
Variance1.9400344
MonotonicityNot monotonic
2024-03-13T22:19:07.915105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
18.2509 6
16.2%
20.1153 5
13.5%
19.208 5
13.5%
19.2589 5
13.5%
19.4395 3
8.1%
17.9961 2
 
5.4%
17.7892 2
 
5.4%
17.8018 2
 
5.4%
21.4649 1
 
2.7%
21.2631 1
 
2.7%
Other values (5) 5
13.5%
ValueCountFrequency (%)
13.3995 1
 
2.7%
17.4199 1
 
2.7%
17.7892 2
 
5.4%
17.8018 2
 
5.4%
17.9961 2
 
5.4%
18.2509 6
16.2%
19.18 1
 
2.7%
19.208 5
13.5%
19.2589 5
13.5%
19.4395 3
8.1%
ValueCountFrequency (%)
21.4649 1
 
2.7%
21.2631 1
 
2.7%
21.1786 1
 
2.7%
20.2213 1
 
2.7%
20.1153 5
13.5%
19.4395 3
8.1%
19.2589 5
13.5%
19.208 5
13.5%
19.18 1
 
2.7%
18.2509 6
16.2%

도매요금(조정후)
Real number (ℝ)

HIGH CORRELATION 

Distinct15
Distinct (%)40.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.445703
Minimum14.8712
Maximum23.4271
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2024-03-13T22:19:08.023873image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum14.8712
5-th percentile17.7892
Q119.4395
median21.1702
Q321.2211
95-th percentile23.1577
Maximum23.4271
Range8.5559
Interquartile range (IQR)1.7816

Descriptive statistics

Standard deviation1.8408134
Coefficient of variation (CV)0.090034243
Kurtosis0.95959733
Mean20.445703
Median Absolute Deviation (MAD)0.9566
Skewness-0.85829138
Sum756.491
Variance3.3885939
MonotonicityNot monotonic
2024-03-13T22:19:08.127047image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
20.2136 6
16.2%
22.0775 5
13.5%
21.1702 5
13.5%
21.2211 5
13.5%
19.4395 3
8.1%
17.9961 2
 
5.4%
17.7892 2
 
5.4%
17.8018 2
 
5.4%
23.4271 1
 
2.7%
23.2253 1
 
2.7%
Other values (5) 5
13.5%
ValueCountFrequency (%)
14.8712 1
 
2.7%
17.7892 2
 
5.4%
17.8018 2
 
5.4%
17.9961 2
 
5.4%
19.3826 1
 
2.7%
19.4395 3
8.1%
20.2136 6
16.2%
21.1422 1
 
2.7%
21.1702 5
13.5%
21.2211 5
13.5%
ValueCountFrequency (%)
23.4271 1
 
2.7%
23.2253 1
 
2.7%
23.1408 1
 
2.7%
22.1835 1
 
2.7%
22.0775 5
13.5%
21.2211 5
13.5%
21.1702 5
13.5%
21.1422 1
 
2.7%
20.2136 6
16.2%
19.4395 3
8.1%

공급비용
Real number (ℝ)

HIGH CORRELATION 

Distinct14
Distinct (%)37.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1.6836838
Minimum0.6028
Maximum3.199
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2024-03-13T22:19:08.231009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.6028
5-th percentile0.88992
Q10.9608
median1.2325
Q32.3226
95-th percentile3.199
Maximum3.199
Range2.5962
Interquartile range (IQR)1.3618

Descriptive statistics

Standard deviation0.84606786
Coefficient of variation (CV)0.50250995
Kurtosis-0.92764531
Mean1.6836838
Median Absolute Deviation (MAD)0.3184
Skewness0.70643801
Sum62.2963
Variance0.71583082
MonotonicityNot monotonic
2024-03-13T22:19:08.359166image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
0.9608 4
10.8%
2.3226 3
8.1%
3.199 3
8.1%
2.1518 3
8.1%
3.1542 3
8.1%
1.2325 3
8.1%
1.1913 3
8.1%
1.1361 3
8.1%
0.9578 3
8.1%
0.9141 3
8.1%
Other values (4) 6
16.2%
ValueCountFrequency (%)
0.6028 1
 
2.7%
0.7932 1
 
2.7%
0.9141 3
8.1%
0.9578 3
8.1%
0.9608 4
10.8%
1.1361 3
8.1%
1.1913 3
8.1%
1.2325 3
8.1%
1.9199 3
8.1%
2.1518 3
8.1%
ValueCountFrequency (%)
3.199 3
8.1%
3.1542 3
8.1%
2.5192 1
 
2.7%
2.3226 3
8.1%
2.1518 3
8.1%
1.9199 3
8.1%
1.2325 3
8.1%
1.1913 3
8.1%
1.1361 3
8.1%
0.9608 4
10.8%

소비자요금(조정전)
Real number (ℝ)

HIGH CORRELATION 

Distinct31
Distinct (%)83.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean20.657641
Minimum15.9187
Maximum24.6191
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2024-03-13T22:19:08.470903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum15.9187
5-th percentile19.01198
Q120.1479
median20.3993
Q321.2514
95-th percentile23.58386
Maximum24.6191
Range8.7004
Interquartile range (IQR)1.1035

Descriptive statistics

Standard deviation1.5266856
Coefficient of variation (CV)0.073904162
Kurtosis3.1690626
Mean20.657641
Median Absolute Deviation (MAD)0.6165
Skewness0.093406902
Sum764.3327
Variance2.330769
MonotonicityNot monotonic
2024-03-13T22:19:08.652359image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
21.7621 3
 
8.1%
19.2117 3
 
8.1%
20.1708 3
 
8.1%
21.1951 1
 
2.7%
22.1394 1
 
2.7%
18.2131 1
 
2.7%
19.7828 1
 
2.7%
20.173 1
 
2.7%
20.1221 1
 
2.7%
21.0294 1
 
2.7%
Other values (21) 21
56.8%
ValueCountFrequency (%)
15.9187 1
 
2.7%
18.2131 1
 
2.7%
19.2117 3
8.1%
19.7828 1
 
2.7%
19.941 1
 
2.7%
19.9536 1
 
2.7%
20.1221 1
 
2.7%
20.1479 1
 
2.7%
20.1658 1
 
2.7%
20.1708 3
8.1%
ValueCountFrequency (%)
24.6191 1
 
2.7%
24.4173 1
 
2.7%
23.3755 1
 
2.7%
22.1394 1
 
2.7%
21.7621 3
8.1%
21.3478 1
 
2.7%
21.3066 1
 
2.7%
21.2514 1
 
2.7%
21.1951 1
 
2.7%
21.0731 1
 
2.7%

소비자요금(조정후)
Real number (ℝ)

HIGH CORRELATION 

Distinct31
Distinct (%)83.8%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean22.129386
Minimum17.3904
Maximum26.5813
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size465.0 B
2024-03-13T22:19:08.784496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum17.3904
5-th percentile19.95108
Q121.1744
median22.1335
Q322.4536
95-th percentile25.54606
Maximum26.5813
Range9.1909
Interquartile range (IQR)1.2792

Descriptive statistics

Standard deviation1.7026156
Coefficient of variation (CV)0.076939124
Kurtosis2.3284422
Mean22.129386
Median Absolute Deviation (MAD)0.9018
Skewness0.372385
Sum818.7873
Variance2.8988999
MonotonicityNot monotonic
2024-03-13T22:19:08.908193image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=31)
ValueCountFrequency (%)
21.7621 3
 
8.1%
21.1744 3
 
8.1%
22.1335 3
 
8.1%
21.1951 1
 
2.7%
24.1016 1
 
2.7%
20.1758 1
 
2.7%
21.745 1
 
2.7%
22.1352 1
 
2.7%
22.0843 1
 
2.7%
22.9916 1
 
2.7%
Other values (21) 21
56.8%
ValueCountFrequency (%)
17.3904 1
 
2.7%
19.941 1
 
2.7%
19.9536 1
 
2.7%
20.1479 1
 
2.7%
20.1758 1
 
2.7%
20.9882 1
 
2.7%
21.0008 1
 
2.7%
21.1744 3
8.1%
21.1951 1
 
2.7%
21.745 1
 
2.7%
ValueCountFrequency (%)
26.5813 1
2.7%
26.3795 1
2.7%
25.3377 1
2.7%
24.1016 1
2.7%
23.31 1
2.7%
23.2688 1
2.7%
23.2136 1
2.7%
23.0353 1
2.7%
22.9916 1
2.7%
22.4536 1
2.7%

Interactions

2024-03-13T22:19:06.745520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:04.910688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.372377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.848403image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.289936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.835152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.012780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.466344image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.947092image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.422845image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.915877image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.101005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.541071image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.036029image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.507615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.998046image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.189458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.650304image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.118808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.587816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:07.068862image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.288078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:05.765136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.201147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-13T22:19:06.655152image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-13T22:19:09.014068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
용도별1용도별2도매요금(조정전)도매요금(조정후)공급비용소비자요금(조정전)소비자요금(조정후)
용도별11.0000.0000.9110.9060.9710.9160.858
용도별20.0001.0000.4750.7520.7510.1840.280
도매요금(조정전)0.9110.4751.0000.9970.9120.8820.893
도매요금(조정후)0.9060.7520.9971.0000.9330.8490.900
공급비용0.9710.7510.9120.9331.0000.8310.760
소비자요금(조정전)0.9160.1840.8820.8490.8311.0000.977
소비자요금(조정후)0.8580.2800.8930.9000.7600.9771.000
2024-03-13T22:19:09.123704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
용도별2용도별1
용도별21.0000.000
용도별10.0001.000
2024-03-13T22:19:09.211946image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
도매요금(조정전)도매요금(조정후)공급비용소비자요금(조정전)소비자요금(조정후)용도별1용도별2
도매요금(조정전)1.0000.873-0.1000.7830.8860.6120.167
도매요금(조정후)0.8731.000-0.3330.5340.9480.6010.343
공급비용-0.100-0.3331.0000.425-0.1110.7600.343
소비자요금(조정전)0.7830.5340.4251.0000.6970.6110.042
소비자요금(조정후)0.8860.948-0.1110.6971.0000.4990.120
용도별10.6120.6010.7600.6110.4991.0000.000
용도별20.1670.3430.3430.0420.1200.0001.000

Missing values

2024-03-13T22:19:07.171122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-13T22:19:07.281668image/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

용도별1용도별2도매요금(조정전)도매요금(조정후)공급비용소비자요금(조정전)소비자요금(조정후)
0주택용취사용19.439519.43952.322621.762121.7621
1주택용개별난방19.439519.43952.322621.762121.7621
2주택용중앙난방19.439519.43952.322621.762121.7621
3영업용1동절기17.996117.99613.19921.195121.1951
4영업용1하절기17.789217.78923.19920.988220.9882
5영업용1기타월17.801817.80183.19921.000821.0008
6영업용2동절기17.996117.99612.151820.147920.1479
7영업용2하절기17.789217.78922.151819.94119.941
8영업용2기타월17.801817.80182.151819.953619.9536
9업무난방용일반21.464923.42713.154224.619126.5813
용도별1용도별2도매요금(조정전)도매요금(조정후)공급비용소비자요금(조정전)소비자요금(조정후)
27산업용5기타월19.258921.22110.914120.17322.1352
28수송용일반19.1821.14220.602819.782821.745
29열병합용1동절기18.250920.21361.919920.170822.1335
30열병합용1하절기18.250920.21361.919920.170822.1335
31열병합용1기타월18.250920.21361.919920.170822.1335
32열병합용2동절기18.250920.21360.960819.211721.1744
33열병합용2하절기18.250920.21360.960819.211721.1744
34열병합용2기타월18.250920.21360.960819.211721.1744
35연료전지용일반17.419919.38260.793218.213120.1758
36열전용설비용일반21.178623.14080.960822.139424.1016