Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory498.0 KiB
Average record size in memory51.0 B

Variable types

Numeric3
Categorical2

Dataset

Description충청남도 내 공공요금 물가 정보에 대한 데이터입니다. 제공 정보는 (연도, 월, 물품, 지역, 물가)을 제공합니다.
Author충청남도
URLhttps://www.data.go.kr/data/15110408/fileData.do

Alerts

물가 has 1903 (19.0%) zerosZeros

Reproduction

Analysis started2023-12-12 04:44:29.066589
Analysis finished2023-12-12 04:44:30.826919
Duration1.76 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연도
Real number (ℝ)

Distinct11
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2016.2797
Minimum2012
Maximum2022
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T13:44:30.893378image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2012
5-th percentile2012
Q12014
median2016
Q32019
95-th percentile2021
Maximum2022
Range10
Interquartile range (IQR)5

Descriptive statistics

Standard deviation2.9165251
Coefficient of variation (CV)0.0014464883
Kurtosis-0.96572769
Mean2016.2797
Median Absolute Deviation (MAD)2
Skewness0.32171652
Sum20162797
Variance8.5061185
MonotonicityNot monotonic
2023-12-12T13:44:31.043588image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=11)
ValueCountFrequency (%)
2014 1218
12.2%
2013 1208
12.1%
2015 1189
11.9%
2016 1129
11.3%
2017 982
9.8%
2012 891
8.9%
2018 870
8.7%
2019 767
7.7%
2021 685
6.9%
2020 602
6.0%
ValueCountFrequency (%)
2012 891
8.9%
2013 1208
12.1%
2014 1218
12.2%
2015 1189
11.9%
2016 1129
11.3%
2017 982
9.8%
2018 870
8.7%
2019 767
7.7%
2020 602
6.0%
2021 685
6.9%
ValueCountFrequency (%)
2022 459
 
4.6%
2021 685
6.9%
2020 602
6.0%
2019 767
7.7%
2018 870
8.7%
2017 982
9.8%
2016 1129
11.3%
2015 1189
11.9%
2014 1218
12.2%
2013 1208
12.1%

월
Real number (ℝ)

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean6.601
Minimum1
Maximum12
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T13:44:31.185100image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q14
median7
Q310
95-th percentile12
Maximum12
Range11
Interquartile range (IQR)6

Descriptive statistics

Standard deviation3.3996698
Coefficient of variation (CV)0.51502345
Kurtosis-1.1727463
Mean6.601
Median Absolute Deviation (MAD)3
Skewness-0.045895998
Sum66010
Variance11.557755
MonotonicityNot monotonic
2023-12-12T13:44:31.333204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=12)
ValueCountFrequency (%)
6 897
9.0%
7 886
8.9%
9 878
8.8%
10 866
8.7%
8 862
8.6%
5 854
8.5%
12 823
8.2%
11 823
8.2%
2 810
8.1%
4 776
7.8%
Other values (2) 1525
15.2%
ValueCountFrequency (%)
1 765
7.6%
2 810
8.1%
3 760
7.6%
4 776
7.8%
5 854
8.5%
6 897
9.0%
7 886
8.9%
8 862
8.6%
9 878
8.8%
10 866
8.7%
ValueCountFrequency (%)
12 823
8.2%
11 823
8.2%
10 866
8.7%
9 878
8.8%
8 862
8.6%
7 886
8.9%
6 897
9.0%
5 854
8.5%
4 776
7.8%
3 760
7.6%

물품
Categorical

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
정화조청소료
1021 
납입금(고등학교)
1015 
문화시설입장료
1005 
쓰레기봉투
1001 
시내버스료
1000 
Other values (5)
4958 

Length

Max length9
Median length6
Mean length5.4137
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row문화시설입장료
2nd row문화시설입장료
3rd row도시가스
4th row납입금(고등학교)
5th row시내버스료

Common Values

ValueCountFrequency (%)
정화조청소료 1021
10.2%
납입금(고등학교) 1015
10.2%
문화시설입장료 1005
10.1%
쓰레기봉투 1001
10.0%
시내버스료 1000
10.0%
하수도료 1000
10.0%
공연예술관람료 995
10.0%
도시가스 994
9.9%
상수도료 988
9.9%
택시료 981
9.8%

Length

2023-12-12T13:44:31.565322image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T13:44:31.716153image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
정화조청소료 1021
10.2%
납입금(고등학교 1015
10.2%
문화시설입장료 1005
10.1%
쓰레기봉투 1001
10.0%
시내버스료 1000
10.0%
하수도료 1000
10.0%
공연예술관람료 995
10.0%
도시가스 994
9.9%
상수도료 988
9.9%
택시료 981
9.8%

지역명
Categorical

Distinct16
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
예산군
915 
홍성군
899 
천안시
885 
계룡시
877 
공주시
872 
Other values (11)
5552 

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 (%)
예산군 915
9.2%
홍성군 899
9.0%
천안시 885
8.8%
계룡시 877
8.8%
공주시 872
8.7%
서천군 848
 
8.5%
당진시 673
 
6.7%
부여군 669
 
6.7%
보령시 643
 
6.4%
청양군 555
 
5.5%
Other values (6) 2164
21.6%

Length

2023-12-12T13:44:31.889698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
예산군 915
9.2%
홍성군 899
9.0%
천안시 885
8.8%
계룡시 877
8.8%
공주시 872
8.7%
서천군 848
 
8.5%
당진시 673
 
6.7%
부여군 669
 
6.7%
보령시 643
 
6.4%
청양군 555
 
5.5%
Other values (6) 2164
21.6%

물가
Real number (ℝ)

ZEROS 

Distinct514
Distinct (%)5.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean26075.265
Minimum0
Maximum311440
Zeros1903
Zeros (%)19.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T13:44:32.034554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q1387.5
median2800
Q313750
95-th percentile247900
Maximum311440
Range311440
Interquartile range (IQR)13362.5

Descriptive statistics

Standard deviation70514.243
Coefficient of variation (CV)2.704258
Kurtosis9.0627949
Mean26075.265
Median Absolute Deviation (MAD)2800
Skewness3.2625707
Sum2.6075265 × 108
Variance4.9722585 × 109
MonotonicityNot monotonic
2023-12-12T13:44:32.213565image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
0 1903
 
19.0%
2800 562
 
5.6%
1300 329
 
3.3%
1400 276
 
2.8%
13000 272
 
2.7%
3300 213
 
2.1%
400 201
 
2.0%
5000 169
 
1.7%
1200 150
 
1.5%
300 144
 
1.4%
Other values (504) 5781
57.8%
ValueCountFrequency (%)
0 1903
19.0%
14 7
 
0.1%
15 9
 
0.1%
16 8
 
0.1%
22 1
 
< 0.1%
33 1
 
< 0.1%
48 21
 
0.2%
118 4
 
< 0.1%
150 1
 
< 0.1%
200 1
 
< 0.1%
ValueCountFrequency (%)
311440 8
 
0.1%
305400 36
 
0.4%
303900 55
0.5%
303600 36
 
0.4%
302600 2
 
< 0.1%
300900 9
 
0.1%
300000 105
1.1%
299800 27
 
0.3%
298000 9
 
0.1%
297900 38
 
0.4%

Interactions

2023-12-12T13:44:30.364651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:44:29.483797image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:44:29.780196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:44:30.465536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:44:29.590110image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:44:29.862085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:44:30.561043image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:44:29.691586image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T13:44:30.242469image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T13:44:32.342916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도월물품지역명물가
연도1.0000.0930.0000.3990.154
월0.0931.0000.0000.0340.000
물품0.0000.0001.0000.0000.728
지역명0.3990.0340.0001.0000.318
물가0.1540.0000.7280.3181.000
2023-12-12T13:44:32.465848image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
지역명물품
지역명1.0000.000
물품0.0001.000
2023-12-12T13:44:32.553049image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연도월물가물품지역명
연도1.000-0.108-0.0480.0000.156
월-0.1081.0000.0030.0000.013
물가-0.0480.0031.0000.3020.130
물품0.0000.0000.3021.0000.000
지역명0.1560.0130.1300.0001.000

Missing values

2023-12-12T13:44:30.674926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T13:44:30.775782image/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

연도월물품지역명물가
917520174문화시설입장료보령시1000
7631201612문화시설입장료부여군1500
117020213도시가스계룡시36000
111201511납입금(고등학교)보령시303900
878720134시내버스료논산시1200
1160620133공연예술관람료보령시0
386520189정화조청소료서천군13000
598120167하수도료예산군3300
209820132상수도료논산시20500
851820193시내버스료홍성군1300
연도월물품지역명물가
653820147택시료천안시2800
8146201511시내버스료아산시1350
706720185택시료서천군2800
1394820224납입금(고등학교)서천군0
192120212상수도료서천군22770
1236820155문화시설입장료서천군0
1103202010정화조청소료계룡시49000
858920211시내버스료부여군1300
597920165하수도료예산군3300
21520133납입금(고등학교)예산군300000