Overview

Dataset statistics

Number of variables7
Number of observations43
Missing cells129
Missing cells (%)42.9%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.7 KiB
Average record size in memory65.1 B

Variable types

DateTime1
Numeric6

Dataset

Description한국광해광업공단에서는 연탄가격 지원금을 통해 저렴한 가격으로 연탄을 구매할 수 있도록 최고 판매가격을 고시로 정하고, 생산원가와 판매가격의 차액을 연탄제조업자 및 수송업자에게 지원해 서민생계와 물가안정을 유도하고 있습니다. 이와 관련, 연도별 연탄가격 추이 현황을 공개 및 개방합니다.
URLhttps://www.data.go.kr/data/3077881/fileData.do

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 공장도 가격(원) and 3 other fieldsHigh correlation
판매소도 인상율(퍼센트) is highly overall correlated with 공장도 가격(원) and 2 other fieldsHigh correlation
가정도 가격(원) is highly overall correlated with 공장도 가격(원) and 1 other fieldsHigh correlation
가정도 인상율(퍼센트) is highly overall correlated with 공장도 인상율(퍼센트)High correlation
공장도 인상율(퍼센트) has 30 (69.8%) missing valuesMissing
판매소도 인상율(퍼센트) has 30 (69.8%) missing valuesMissing
가정도 가격(원) has 33 (76.7%) missing valuesMissing
가정도 인상율(퍼센트) has 36 (83.7%) missing valuesMissing
기준일자 has unique valuesUnique

Reproduction

Analysis started2023-12-12 05:28:38.864213
Analysis finished2023-12-12 05:28:43.380876
Duration4.52 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준일자
Date

UNIQUE 

Distinct43
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size476.0 B
Minimum1981-08-14 00:00:00
Maximum2022-12-05 00:00:00
2023-12-12T14:28:43.455683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:43.672375image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=43)

공장도 가격(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct14
Distinct (%)32.6%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean271.52344
Minimum131
Maximum639
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size519.0 B
2023-12-12T14:28:43.816534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum131
5-th percentile135
Q1167.25
median167.25
Q3373.5
95-th percentile639
Maximum639
Range508
Interquartile range (IQR)206.25

Descriptive statistics

Standard deviation167.62986
Coefficient of variation (CV)0.61736793
Kurtosis0.32183868
Mean271.52344
Median Absolute Deviation (MAD)22.25
Skewness1.2797144
Sum11675.508
Variance28099.772
MonotonicityIncreasing
2023-12-12T14:28:43.951671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=14)
ValueCountFrequency (%)
167.25 15
34.9%
373.5 7
16.3%
639.0 5
 
11.6%
184.0 4
 
9.3%
135.0 3
 
7.0%
131.0 1
 
2.3%
140.0 1
 
2.3%
145.0 1
 
2.3%
151.0 1
 
2.3%
160.0 1
 
2.3%
Other values (4) 4
 
9.3%
ValueCountFrequency (%)
131.0 1
 
2.3%
135.0 3
 
7.0%
140.0 1
 
2.3%
145.0 1
 
2.3%
151.0 1
 
2.3%
160.0 1
 
2.3%
167.25 15
34.9%
184.0 4
 
9.3%
221.0 1
 
2.3%
287.25 1
 
2.3%
ValueCountFrequency (%)
639.0 5
 
11.6%
534.25 1
 
2.3%
446.758 1
 
2.3%
373.5 7
16.3%
287.25 1
 
2.3%
221.0 1
 
2.3%
184.0 4
 
9.3%
167.25 15
34.9%
160.0 1
 
2.3%
151.0 1
 
2.3%

공장도 인상율(퍼센트)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct10
Distinct (%)76.9%
Missing30
Missing (%)69.8%
Infinite0
Infinite (%)0.0%
Mean13.553846
Minimum3.1
Maximum30
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size519.0 B
2023-12-12T14:28:44.097402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3.1
5-th percentile3.4
Q14.1
median12.4
Q319.6
95-th percentile30
Maximum30
Range26.9
Interquartile range (IQR)15.5

Descriptive statistics

Standard deviation10.113408
Coefficient of variation (CV)0.74616519
Kurtosis-1.2754706
Mean13.553846
Median Absolute Deviation (MAD)7.9
Skewness0.44961404
Sum176.2
Variance102.28103
MonotonicityNot monotonic
2023-12-12T14:28:44.245830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
19.6 3
 
7.0%
30.0 2
 
4.7%
12.4 1
 
2.3%
3.1 1
 
2.3%
3.7 1
 
2.3%
3.6 1
 
2.3%
4.1 1
 
2.3%
6.0 1
 
2.3%
4.5 1
 
2.3%
20.0 1
 
2.3%
(Missing) 30
69.8%
ValueCountFrequency (%)
3.1 1
 
2.3%
3.6 1
 
2.3%
3.7 1
 
2.3%
4.1 1
 
2.3%
4.5 1
 
2.3%
6.0 1
 
2.3%
12.4 1
 
2.3%
19.6 3
7.0%
20.0 1
 
2.3%
30.0 2
4.7%
ValueCountFrequency (%)
30.0 2
4.7%
20.0 1
 
2.3%
19.6 3
7.0%
12.4 1
 
2.3%
6.0 1
 
2.3%
4.5 1
 
2.3%
4.1 1
 
2.3%
3.7 1
 
2.3%
3.6 1
 
2.3%
3.1 1
 
2.3%

판매소도 가격(원)
Real number (ℝ)

HIGH CORRELATION 

Distinct15
Distinct (%)34.9%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean288.85465
Minimum145
Maximum665.75
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size519.0 B
2023-12-12T14:28:44.397244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum145
5-th percentile150
Q1185
median185
Q3391.25
95-th percentile656.75
Maximum665.75
Range520.75
Interquartile range (IQR)206.25

Descriptive statistics

Standard deviation168.61783
Coefficient of variation (CV)0.5837463
Kurtosis0.3252738
Mean288.85465
Median Absolute Deviation (MAD)29
Skewness1.2769644
Sum12420.75
Variance28431.974
MonotonicityNot monotonic
2023-12-12T14:28:44.544370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=15)
ValueCountFrequency (%)
185.0 15
34.9%
391.25 7
16.3%
201.75 4
 
9.3%
656.75 4
 
9.3%
150.0 3
 
7.0%
145.0 1
 
2.3%
151.0 1
 
2.3%
156.0 1
 
2.3%
168.0 1
 
2.3%
177.0 1
 
2.3%
Other values (5) 5
 
11.6%
ValueCountFrequency (%)
145.0 1
 
2.3%
150.0 3
 
7.0%
151.0 1
 
2.3%
156.0 1
 
2.3%
168.0 1
 
2.3%
177.0 1
 
2.3%
185.0 15
34.9%
201.75 4
 
9.3%
238.75 1
 
2.3%
305.0 1
 
2.3%
ValueCountFrequency (%)
665.75 1
 
2.3%
656.75 4
 
9.3%
552.0 1
 
2.3%
464.5 1
 
2.3%
391.25 7
16.3%
305.0 1
 
2.3%
238.75 1
 
2.3%
201.75 4
 
9.3%
185.0 15
34.9%
177.0 1
 
2.3%

판매소도 인상율(퍼센트)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct13
Distinct (%)100.0%
Missing30
Missing (%)69.8%
Infinite0
Infinite (%)0.0%
Mean12.807692
Minimum0.7
Maximum28.3
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size519.0 B
2023-12-12T14:28:44.672321image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0.7
5-th percentile2.14
Q14.5
median11.1
Q318.8
95-th percentile27.94
Maximum28.3
Range27.6
Interquartile range (IQR)14.3

Descriptive statistics

Standard deviation9.5036363
Coefficient of variation (CV)0.74202566
Kurtosis-1.24693
Mean12.807692
Median Absolute Deviation (MAD)7.7
Skewness0.3631814
Sum166.5
Variance90.319103
MonotonicityNot monotonic
2023-12-12T14:28:44.791225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=13)
ValueCountFrequency (%)
11.1 1
 
2.3%
3.1 1
 
2.3%
0.7 1
 
2.3%
3.3 1
 
2.3%
7.7 1
 
2.3%
5.4 1
 
2.3%
4.5 1
 
2.3%
18.3 1
 
2.3%
27.7 1
 
2.3%
28.3 1
 
2.3%
Other values (3) 3
 
7.0%
(Missing) 30
69.8%
ValueCountFrequency (%)
0.7 1
2.3%
3.1 1
2.3%
3.3 1
2.3%
4.5 1
2.3%
5.4 1
2.3%
7.7 1
2.3%
11.1 1
2.3%
18.3 1
2.3%
18.7 1
2.3%
18.8 1
2.3%
ValueCountFrequency (%)
28.3 1
2.3%
27.7 1
2.3%
18.9 1
2.3%
18.8 1
2.3%
18.7 1
2.3%
18.3 1
2.3%
11.1 1
2.3%
7.7 1
2.3%
5.4 1
2.3%
4.5 1
2.3%

가정도 가격(원)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct7
Distinct (%)70.0%
Missing33
Missing (%)76.7%
Infinite0
Infinite (%)0.0%
Mean171.9
Minimum153
Maximum195
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size519.0 B
2023-12-12T14:28:44.906781image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum153
5-th percentile155.25
Q1158
median168.5
Q3184.75
95-th percentile195
Maximum195
Range42
Interquartile range (IQR)26.75

Descriptive statistics

Standard deviation16.003125
Coefficient of variation (CV)0.093095548
Kurtosis-1.4653118
Mean171.9
Median Absolute Deviation (MAD)10.5
Skewness0.45100524
Sum1719
Variance256.1
MonotonicityIncreasing
2023-12-12T14:28:45.033893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
158 3
 
7.0%
195 2
 
4.7%
153 1
 
2.3%
166 1
 
2.3%
171 1
 
2.3%
178 1
 
2.3%
187 1
 
2.3%
(Missing) 33
76.7%
ValueCountFrequency (%)
153 1
 
2.3%
158 3
7.0%
166 1
 
2.3%
171 1
 
2.3%
178 1
 
2.3%
187 1
 
2.3%
195 2
4.7%
ValueCountFrequency (%)
195 2
4.7%
187 1
 
2.3%
178 1
 
2.3%
171 1
 
2.3%
166 1
 
2.3%
158 3
7.0%
153 1
 
2.3%

가정도 인상율(퍼센트)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct6
Distinct (%)85.7%
Missing36
Missing (%)83.7%
Infinite0
Infinite (%)0.0%
Mean5.1142857
Minimum3
Maximum10.9
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size519.0 B
2023-12-12T14:28:45.141021image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile3.09
Q13.7
median4.3
Q35.1
95-th percentile9.16
Maximum10.9
Range7.9
Interquartile range (IQR)1.4

Descriptive statistics

Standard deviation2.6748387
Coefficient of variation (CV)0.52301315
Kurtosis5.1097376
Mean5.1142857
Median Absolute Deviation (MAD)0.8
Skewness2.1539712
Sum35.8
Variance7.1547619
MonotonicityNot monotonic
2023-12-12T14:28:45.307508image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
5.1 2
 
4.7%
10.9 1
 
2.3%
3.3 1
 
2.3%
3.0 1
 
2.3%
4.1 1
 
2.3%
4.3 1
 
2.3%
(Missing) 36
83.7%
ValueCountFrequency (%)
3.0 1
2.3%
3.3 1
2.3%
4.1 1
2.3%
4.3 1
2.3%
5.1 2
4.7%
10.9 1
2.3%
ValueCountFrequency (%)
10.9 1
2.3%
5.1 2
4.7%
4.3 1
2.3%
4.1 1
2.3%
3.3 1
2.3%
3.0 1
2.3%

Interactions

2023-12-12T14:28:42.463805image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:39.348214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:39.869621image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.490520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.260237image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.881209image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.565147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:39.431067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:39.962817image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.577336image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.358305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.971725image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.670232image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:39.513766image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.062680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.732897image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.456178image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.066496image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.765390image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:39.592379image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.154907image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.878448image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.547429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.179688image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.851611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:39.678239image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.264615image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.986207image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.646113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.269127image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.935401image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:39.755801image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:40.357785image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.125674image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:41.752006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T14:28:42.346823image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T14:28:45.420067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준일자공장도 가격(원)공장도 인상율(퍼센트)판매소도 가격(원)판매소도 인상율(퍼센트)가정도 가격(원)가정도 인상율(퍼센트)
기준일자1.0001.0001.0001.0001.0001.0001.000
공장도 가격(원)1.0001.0000.7081.0000.000NaNNaN
공장도 인상율(퍼센트)1.0000.7081.0000.7080.9151.0000.662
판매소도 가격(원)1.0001.0000.7081.0000.000NaNNaN
판매소도 인상율(퍼센트)1.0000.0000.9150.0001.0001.0000.888
가정도 가격(원)1.000NaN1.000NaN1.0001.0001.000
가정도 인상율(퍼센트)1.000NaN0.662NaN0.8881.0001.000
2023-12-12T14:28:45.564442image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
공장도 가격(원)공장도 인상율(퍼센트)판매소도 가격(원)판매소도 인상율(퍼센트)가정도 가격(원)가정도 인상율(퍼센트)
공장도 가격(원)1.0000.7161.0000.7751.000-0.162
공장도 인상율(퍼센트)0.7161.0000.7160.9270.1790.811
판매소도 가격(원)1.0000.7161.0000.7751.000-0.162
판매소도 인상율(퍼센트)0.7750.9270.7751.0000.0710.396
가정도 가격(원)1.0000.1791.0000.0711.000-0.162
가정도 인상율(퍼센트)-0.1620.811-0.1620.396-0.1621.000

Missing values

2023-12-12T14:28:43.070886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T14:28:43.193060image/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.
2023-12-12T14:28:43.313068image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

Sample

기준일자공장도 가격(원)공장도 인상율(퍼센트)판매소도 가격(원)판매소도 인상율(퍼센트)가정도 가격(원)가정도 인상율(퍼센트)
01981-08-14131.012.4145.011.115310.9
11982-07-01135.03.1150.03.11583.3
21983-05-13135.0<NA>150.0<NA>158<NA>
31984-05-17135.0<NA>150.0<NA>158<NA>
41985-04-14140.03.7151.00.71665.1
51985-09-05145.03.6156.03.31713.0
61986-05-05151.04.1168.07.71784.1
71987-04-09160.06.0177.05.41875.1
81988-05-01167.254.5185.04.51954.3
91989-06-03167.25<NA>185.0<NA>195<NA>
기준일자공장도 가격(원)공장도 인상율(퍼센트)판매소도 가격(원)판매소도 인상율(퍼센트)가정도 가격(원)가정도 인상율(퍼센트)
332013-12-26373.5<NA>391.25<NA><NA><NA>
342014-12-18373.5<NA>391.25<NA><NA><NA>
352015-11-03373.5<NA>391.25<NA><NA><NA>
362016-11-03446.75819.6464.518.7<NA><NA>
372017-11-28534.2519.6552.018.8<NA><NA>
382018-12-04639.019.6665.7518.9<NA><NA>
392019-09-20639.0<NA>656.75<NA><NA><NA>
402020-12-16639.0<NA>656.75<NA><NA><NA>
412021-12-17639.0<NA>656.75<NA><NA><NA>
422022-12-05639.0<NA>656.75<NA><NA><NA>