Overview

Dataset statistics

Number of variables5
Number of observations1958
Missing cells21
Missing cells (%)0.2%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory80.4 KiB
Average record size in memory42.1 B

Variable types

Numeric2
Categorical3

Dataset

Description- 제주도 내 항목별 공공 요금 동향 정보를 제공합니다. - 데이터 제공처: 제주특별자치도
Author제주특별자치도 미래성장과
URLhttps://www.jejudatahub.net/data/view/data/984

Alerts

항목 중분류 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 항목 대분류 and 1 other fieldsHigh correlation
요금(원) has 21 (1.1%) missing valuesMissing

Reproduction

Analysis started2023-12-11 20:04:47.879145
Analysis finished2023-12-11 20:04:48.548276
Duration0.67 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

기준 연월
Real number (ℝ)

Distinct89
Distinct (%)4.5%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean201602.8
Minimum201101
Maximum202107
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size17.3 KiB
2023-12-12T05:04:48.618066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum201101
5-th percentile201105
Q1201211
median201709
Q3201907
95-th percentile202103
Maximum202107
Range1006
Interquartile range (IQR)696

Descriptive statistics

Standard deviation352.76718
Coefficient of variation (CV)0.0017498129
Kurtosis-1.5853945
Mean201602.8
Median Absolute Deviation (MAD)307
Skewness-0.14329471
Sum3.9473828 × 108
Variance124444.68
MonotonicityNot monotonic
2023-12-12T05:04:48.767081image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
202107 22
 
1.1%
201210 22
 
1.1%
201212 22
 
1.1%
201301 22
 
1.1%
201302 22
 
1.1%
201303 22
 
1.1%
201304 22
 
1.1%
201305 22
 
1.1%
201306 22
 
1.1%
201307 22
 
1.1%
Other values (79) 1738
88.8%
ValueCountFrequency (%)
201101 22
1.1%
201102 22
1.1%
201103 22
1.1%
201104 22
1.1%
201105 22
1.1%
201106 22
1.1%
201107 22
1.1%
201108 22
1.1%
201109 22
1.1%
201110 22
1.1%
ValueCountFrequency (%)
202107 22
1.1%
202106 22
1.1%
202105 22
1.1%
202104 22
1.1%
202103 22
1.1%
202102 22
1.1%
202101 22
1.1%
202010 22
1.1%
202009 22
1.1%
202008 22
1.1%

시군구
Categorical

HIGH CORRELATION 

Distinct3
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size15.4 KiB
서귀포시
979 
<NA>
711 
제주시
268 

Length

Max length4
Median length4
Mean length3.8631256
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row제주시
2nd row제주시
3rd row제주시
4th row제주시
5th row제주시

Common Values

ValueCountFrequency (%)
서귀포시 979
50.0%
<NA> 711
36.3%
제주시 268
 
13.7%

Length

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

Common Values (Plot)

2023-12-12T05:04:49.051650image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서귀포시 979
50.0%
na 711
36.3%
제주시 268
 
13.7%

항목 대분류
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size15.4 KiB
시내버스(성인)
356 
도시가스(516mj)
356 
정화조청소(1㎥)
356 
쓰레기봉투(20ℓ)
356 
택시(중형차)
178 
Other values (2)
356 

Length

Max length11
Median length9
Mean length8.6363636
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row시내버스(성인)
2nd row시내버스(성인)
3rd row시내버스(성인)
4th row시내버스(성인)
5th row시내버스(성인)

Common Values

ValueCountFrequency (%)
시내버스(성인) 356
18.2%
도시가스(516mj) 356
18.2%
정화조청소(1㎥) 356
18.2%
쓰레기봉투(20ℓ) 356
18.2%
택시(중형차) 178
9.1%
상수도(톤) 178
9.1%
하수도(톤) 178
9.1%

Length

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

Common Values (Plot)

2023-12-12T05:04:49.302272image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
시내버스(성인 356
18.2%
도시가스(516mj 356
18.2%
정화조청소(1㎥ 356
18.2%
쓰레기봉투(20ℓ 356
18.2%
택시(중형차 178
9.1%
상수도(톤 178
9.1%
하수도(톤 178
9.1%

항목 중분류
Categorical

HIGH CORRELATION 

Distinct10
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size15.4 KiB
평균요금
356 
현금
180 
기본요금
178 
도매
178 
소매
178 
Other values (5)
888 

Length

Max length4
Median length2
Mean length2.7272727
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row카드
2nd row카드
3rd row카드
4th row카드
5th row카드

Common Values

ValueCountFrequency (%)
평균요금 356
18.2%
현금 180
9.2%
기본요금 178
9.1%
도매 178
9.1%
소매 178
9.1%
기본 178
9.1%
초과 178
9.1%
동지역 178
9.1%
읍·면 178
9.1%
카드 176
9.0%

Length

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

Common Values (Plot)

2023-12-12T05:04:49.599906image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
평균요금 356
18.2%
현금 180
9.2%
기본요금 178
9.1%
도매 178
9.1%
소매 178
9.1%
기본 178
9.1%
초과 178
9.1%
동지역 178
9.1%
읍·면 178
9.1%
카드 176
9.0%

요금(원)
Real number (ℝ)

MISSING 

Distinct97
Distinct (%)5.0%
Missing21
Missing (%)1.1%
Infinite0
Infinite (%)0.0%
Mean1336.1147
Minimum228
Maximum15800
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size17.3 KiB
2023-12-12T05:04:49.755900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum228
5-th percentile350
Q1700
median1150
Q31490
95-th percentile2800
Maximum15800
Range15572
Interquartile range (IQR)790

Descriptive statistics

Standard deviation1162.8332
Coefficient of variation (CV)0.8703094
Kurtosis29.353503
Mean1336.1147
Median Absolute Deviation (MAD)430
Skewness4.4244655
Sum2588054.2
Variance1352181
MonotonicityNot monotonic
2023-12-12T05:04:49.887361image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1490.0 260
 
13.3%
700.0 196
 
10.0%
1150.0 103
 
5.3%
1200.0 101
 
5.2%
1580.0 91
 
4.6%
350.0 77
 
3.9%
500.0 76
 
3.9%
1000.0 76
 
3.9%
950.0 75
 
3.8%
2800.0 72
 
3.7%
Other values (87) 810
41.4%
ValueCountFrequency (%)
228.0 16
 
0.8%
264.0 14
 
0.7%
286.0 38
1.9%
328.9 8
 
0.4%
350.0 77
3.9%
374.3 44
2.2%
490.0 8
 
0.4%
500.0 76
3.9%
533.0 18
 
0.9%
592.0 16
 
0.8%
ValueCountFrequency (%)
15800.0 1
 
0.1%
8970.0 12
 
0.6%
7600.0 12
 
0.6%
6671.05 12
 
0.6%
3300.0 46
2.3%
3033.82 12
 
0.6%
2800.0 72
3.7%
2200.0 60
3.1%
1871.15 5
 
0.3%
1844.4 52
2.7%

Interactions

2023-12-12T05:04:48.244828image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:04:48.085871image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:04:48.317976image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T05:04:48.159422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T05:04:49.979732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준 연월시군구항목 대분류항목 중분류요금(원)
기준 연월1.0000.0000.0000.0000.295
시군구0.0001.0000.5560.7580.178
항목 대분류0.0000.5561.0000.9650.615
항목 중분류0.0000.7580.9651.0000.809
요금(원)0.2950.1780.6150.8091.000
2023-12-12T05:04:50.066802image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
항목 중분류시군구항목 대분류
항목 중분류1.0000.5950.912
시군구0.5951.0000.597
항목 대분류0.9120.5971.000
2023-12-12T05:04:50.146319image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
기준 연월요금(원)시군구항목 대분류항목 중분류
기준 연월1.0000.1570.0000.0000.000
요금(원)0.1571.0000.2190.4540.465
시군구0.0000.2191.0000.5970.595
항목 대분류0.0000.4540.5971.0000.912
항목 중분류0.0000.4650.5950.9121.000

Missing values

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

기준 연월시군구항목 대분류항목 중분류요금(원)
0202107제주시시내버스(성인)카드1150.0
1202106제주시시내버스(성인)카드1150.0
2202105제주시시내버스(성인)카드1150.0
3202104제주시시내버스(성인)카드1150.0
4202103제주시시내버스(성인)카드1150.0
5202102제주시시내버스(성인)카드1150.0
6202101제주시시내버스(성인)카드1150.0
7202010제주시시내버스(성인)카드1150.0
8202009제주시시내버스(성인)카드1150.0
9202008제주시시내버스(성인)카드1150.0
기준 연월시군구항목 대분류항목 중분류요금(원)
1948201110서귀포시쓰레기봉투(20ℓ)읍·면350.0
1949201109서귀포시쓰레기봉투(20ℓ)읍·면350.0
1950201108서귀포시쓰레기봉투(20ℓ)읍·면350.0
1951201107서귀포시쓰레기봉투(20ℓ)읍·면350.0
1952201106서귀포시쓰레기봉투(20ℓ)읍·면350.0
1953201105서귀포시쓰레기봉투(20ℓ)읍·면350.0
1954201104서귀포시쓰레기봉투(20ℓ)읍·면350.0
1955201103서귀포시쓰레기봉투(20ℓ)읍·면350.0
1956201102서귀포시쓰레기봉투(20ℓ)읍·면350.0
1957201101서귀포시쓰레기봉투(20ℓ)읍·면350.0