Overview

Dataset statistics

Number of variables3
Number of observations105
Missing cells22
Missing cells (%)7.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory2.8 KiB
Average record size in memory27.3 B

Variable types

Numeric2
Categorical1

Dataset

Description- 제주도 내 주유소 연평균 판매 가격 정보를 제공합니다. - 평균 판매 가격은 개별 주유소 판매가격의 합을 전체 주유소 개수로 나눈 값입니다. - 고급휘발유의 경우 2012년부터 데이터가 존재하고, 보일러등유의 경우 2010년까지만 데이터가 존재합니다. - 데이터 제공처: 한국석유공사 오피넷
Author제주특별자치도 미래성장과
URLhttps://www.jejudatahub.net/data/view/data/893

Alerts

연도 is highly overall correlated with 판매 가격(원/리터)High correlation
판매 가격(원/리터) is highly overall correlated with 연도 and 1 other fieldsHigh correlation
제품 구분 is highly overall correlated with 판매 가격(원/리터)High correlation
판매 가격(원/리터) has 22 (21.0%) missing valuesMissing

Reproduction

Analysis started2023-12-11 20:11:46.310504
Analysis finished2023-12-11 20:11:47.016960
Duration0.71 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Real number (ℝ)

HIGH CORRELATION 

Distinct21
Distinct (%)20.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2010
Minimum2000
Maximum2020
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2023-12-12T05:11:47.087950image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2000
5-th percentile2001
Q12005
median2010
Q32015
95-th percentile2019
Maximum2020
Range20
Interquartile range (IQR)10

Descriptive statistics

Standard deviation6.0843431
Coefficient of variation (CV)0.0030270364
Kurtosis-1.205495
Mean2010
Median Absolute Deviation (MAD)5
Skewness0
Sum211050
Variance37.019231
MonotonicityIncreasing
2023-12-12T05:11:47.237930image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
2000 5
 
4.8%
2001 5
 
4.8%
2020 5
 
4.8%
2019 5
 
4.8%
2018 5
 
4.8%
2017 5
 
4.8%
2016 5
 
4.8%
2015 5
 
4.8%
2014 5
 
4.8%
2013 5
 
4.8%
Other values (11) 55
52.4%
ValueCountFrequency (%)
2000 5
4.8%
2001 5
4.8%
2002 5
4.8%
2003 5
4.8%
2004 5
4.8%
2005 5
4.8%
2006 5
4.8%
2007 5
4.8%
2008 5
4.8%
2009 5
4.8%
ValueCountFrequency (%)
2020 5
4.8%
2019 5
4.8%
2018 5
4.8%
2017 5
4.8%
2016 5
4.8%
2015 5
4.8%
2014 5
4.8%
2013 5
4.8%
2012 5
4.8%
2011 5
4.8%

제품 구분
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)4.8%
Missing0
Missing (%)0.0%
Memory size972.0 B
고급휘발유
21 
보통휘발유
21 
자동차용경유
21 
실내등유
21 
보일러등유
21 

Length

Max length6
Median length5
Mean length5
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고급휘발유
2nd row보통휘발유
3rd row자동차용경유
4th row실내등유
5th row보일러등유

Common Values

ValueCountFrequency (%)
고급휘발유 21
20.0%
보통휘발유 21
20.0%
자동차용경유 21
20.0%
실내등유 21
20.0%
보일러등유 21
20.0%

Length

2023-12-12T05:11:47.381749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T05:11:47.480556image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고급휘발유 21
20.0%
보통휘발유 21
20.0%
자동차용경유 21
20.0%
실내등유 21
20.0%
보일러등유 21
20.0%

판매 가격(원/리터)
Real number (ℝ)

HIGH CORRELATION  MISSING 

Distinct83
Distinct (%)100.0%
Missing22
Missing (%)21.0%
Infinite0
Infinite (%)0.0%
Mean1307.4559
Minimum552.18
Maximum2425.46
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size1.1 KiB
2023-12-12T05:11:47.592830image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum552.18
5-th percentile576.013
Q1940.8
median1314.31
Q31620.815
95-th percentile2135.843
Maximum2425.46
Range1873.28
Interquartile range (IQR)680.015

Descriptive statistics

Standard deviation481.41317
Coefficient of variation (CV)0.36820605
Kurtosis-0.57867747
Mean1307.4559
Median Absolute Deviation (MAD)365.41
Skewness0.32844314
Sum108518.84
Variance231758.64
MonotonicityNot monotonic
2023-12-12T05:11:47.731636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1769.69 1
 
1.0%
1339.41 1
 
1.0%
1552.92 1
 
1.0%
2112.02 1
 
1.0%
1192.66 1
 
1.0%
1651.47 1
 
1.0%
1834.57 1
 
1.0%
2351.26 1
 
1.0%
1314.31 1
 
1.0%
1950.07 1
 
1.0%
Other values (73) 73
69.5%
(Missing) 22
 
21.0%
ValueCountFrequency (%)
552.18 1
1.0%
555.83 1
1.0%
569.75 1
1.0%
571.12 1
1.0%
574.85 1
1.0%
586.48 1
1.0%
637.16 1
1.0%
646.56 1
1.0%
664.39 1
1.0%
678.52 1
1.0%
ValueCountFrequency (%)
2425.46 1
1.0%
2376.41 1
1.0%
2351.26 1
1.0%
2232.0 1
1.0%
2138.49 1
1.0%
2112.02 1
1.0%
2025.28 1
1.0%
1987.7 1
1.0%
1958.57 1
1.0%
1950.07 1
1.0%

Interactions

2023-12-12T05:11:46.673170image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:11:46.416339image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:11:46.801835image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:11:46.529542image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T05:11:47.833179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도제품 구분판매 가격(원/리터)
연도1.0000.0000.691
제품 구분0.0001.0000.859
판매 가격(원/리터)0.6910.8591.000
2023-12-12T05:11:47.932266image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도판매 가격(원/리터)제품 구분
연도1.0000.5400.000
판매 가격(원/리터)0.5401.0000.513
제품 구분0.0000.5131.000

Missing values

2023-12-12T05:11:46.910164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T05:11:46.981802image/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

연도제품 구분판매 가격(원/리터)
02000고급휘발유<NA>
12000보통휘발유1272.32
22000자동차용경유637.16
32000실내등유569.75
42000보일러등유552.18
52001고급휘발유<NA>
62001보통휘발유1305.65
72001자동차용경유678.52
82001실내등유586.48
92001보일러등유574.85
연도제품 구분판매 가격(원/리터)
952019고급휘발유1958.57
962019보통휘발유1533.02
972019자동차용경유1400.18
982019실내등유972.27
992019보일러등유<NA>
1002020고급휘발유1805.72
1012020보통휘발유1423.38
1022020자동차용경유1247.54
1032020실내등유768.82
1042020보일러등유<NA>