Overview

Dataset statistics

Number of variables8
Number of observations67
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory4.6 KiB
Average record size in memory70.0 B

Variable types

Categorical5
Numeric3

Dataset

Description양평군의 지방세 미환급 유형별 미환급금 현황 및 연간 누적률을 제공하는 데이터로 자치단체의 환급금 해소 노력 확인이 가능합니다.
Author경기도 양평군
URLhttps://www.data.go.kr/data/15080432/fileData.do

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
자치단체코드 has constant value ""Constant
지급구분 has constant value ""Constant
미지급건수 is highly overall correlated with 미지급금액High correlation
미지급금액 is highly overall correlated with 미지급건수High correlation
미지급금액 has unique valuesUnique

Reproduction

Analysis started2023-12-12 11:33:39.308765
Analysis finished2023-12-12 11:33:41.220588
Duration1.91 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
경기도
67 

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 (%)
경기도 67
100.0%

Length

2023-12-12T20:33:41.887602image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:33:42.053400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 67
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
양평군
67 

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 (%)
양평군 67
100.0%

Length

2023-12-12T20:33:42.224704image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:33:42.404244image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양평군 67
100.0%

자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
41830
67 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row41830
2nd row41830
3rd row41830
4th row41830
5th row41830

Common Values

ValueCountFrequency (%)
41830 67
100.0%

Length

2023-12-12T20:33:42.601947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:33:42.798679image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
41830 67
100.0%

과세년도
Real number (ℝ)

Distinct6
Distinct (%)9.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2020.8806
Minimum2018
Maximum2023
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2023-12-12T20:33:42.953061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2018
5-th percentile2018
Q12020
median2021
Q32022
95-th percentile2023
Maximum2023
Range5
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.6192253
Coefficient of variation (CV)0.00080124738
Kurtosis-0.94072527
Mean2020.8806
Median Absolute Deviation (MAD)1
Skewness-0.39693202
Sum135399
Variance2.6218905
MonotonicityIncreasing
2023-12-12T20:33:43.154231image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=6)
ValueCountFrequency (%)
2022 16
23.9%
2021 14
20.9%
2023 12
17.9%
2020 10
14.9%
2018 8
11.9%
2019 7
10.4%
ValueCountFrequency (%)
2018 8
11.9%
2019 7
10.4%
2020 10
14.9%
2021 14
20.9%
2022 16
23.9%
2023 12
17.9%
ValueCountFrequency (%)
2023 12
17.9%
2022 16
23.9%
2021 14
20.9%
2020 10
14.9%
2019 7
10.4%
2018 8
11.9%

세목
Categorical

Distinct18
Distinct (%)26.9%
Missing0
Missing (%)0.0%
Memory size668.0 B
106001 자동차세(자동차)
6 
140001 지방소득세(종합소득)
6 
140003 지방소득세(법인소득)
6 
114001 등록면허세(면허)
6 
105304 재산세(토지)
6 
Other values (13)
37 

Length

Max length18
Median length17
Mean length16.268657
Min length14

Unique

Unique4 ?
Unique (%)6.0%

Sample

1st row106001 자동차세(자동차)
2nd row105304 재산세(토지)
3rd row106002 자동차세(이륜차)
4th row140001 지방소득세(종합소득)
5th row140003 지방소득세(법인소득)

Common Values

ValueCountFrequency (%)
106001 자동차세(자동차) 6
 
9.0%
140001 지방소득세(종합소득) 6
 
9.0%
140003 지방소득세(법인소득) 6
 
9.0%
114001 등록면허세(면허) 6
 
9.0%
105304 재산세(토지) 6
 
9.0%
106002 자동차세(이륜차) 6
 
9.0%
140002 지방소득세(양도소득) 5
 
7.5%
105305 재산세(주택) 4
 
6.0%
140004 지방소득세(특별징수) 4
 
6.0%
114002 등록면허세(등록) 3
 
4.5%
Other values (8) 15
22.4%

Length

2023-12-12T20:33:43.405182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
106001 6
 
4.5%
등록면허세(면허 6
 
4.5%
자동차세(자동차 6
 
4.5%
106002 6
 
4.5%
재산세(토지 6
 
4.5%
105304 6
 
4.5%
자동차세(이륜차 6
 
4.5%
114001 6
 
4.5%
지방소득세(법인소득 6
 
4.5%
140003 6
 
4.5%
Other values (26) 74
55.2%

지급구분
Categorical

CONSTANT 

Distinct1
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size668.0 B
미지급
67 

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 (%)
미지급 67
100.0%

Length

2023-12-12T20:33:43.648672image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T20:33:43.807418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미지급 67
100.0%

미지급건수
Real number (ℝ)

HIGH CORRELATION 

Distinct29
Distinct (%)43.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean60.268657
Minimum1
Maximum1325
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2023-12-12T20:33:43.961372image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q12
median4
Q331
95-th percentile361.3
Maximum1325
Range1324
Interquartile range (IQR)29

Descriptive statistics

Standard deviation186.53918
Coefficient of variation (CV)3.0951276
Kurtosis33.008419
Mean60.268657
Median Absolute Deviation (MAD)3
Skewness5.3339022
Sum4038
Variance34796.866
MonotonicityNot monotonic
2023-12-12T20:33:44.197040image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=29)
ValueCountFrequency (%)
1 15
22.4%
3 9
13.4%
4 6
 
9.0%
2 6
 
9.0%
10 3
 
4.5%
5 2
 
3.0%
31 2
 
3.0%
120 2
 
3.0%
6 2
 
3.0%
24 1
 
1.5%
Other values (19) 19
28.4%
ValueCountFrequency (%)
1 15
22.4%
2 6
 
9.0%
3 9
13.4%
4 6
 
9.0%
5 2
 
3.0%
6 2
 
3.0%
7 1
 
1.5%
8 1
 
1.5%
10 3
 
4.5%
14 1
 
1.5%
ValueCountFrequency (%)
1325 1
1.5%
486 1
1.5%
477 1
1.5%
367 1
1.5%
348 1
1.5%
120 2
3.0%
84 1
1.5%
74 1
1.5%
67 1
1.5%
66 1
1.5%

미지급금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct67
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2129345.2
Minimum30
Maximum41230740
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size735.0 B
2023-12-12T20:33:44.521527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum30
5-th percentile1804
Q118905
median83830
Q3746600
95-th percentile10488474
Maximum41230740
Range41230710
Interquartile range (IQR)727695

Descriptive statistics

Standard deviation6761788.5
Coefficient of variation (CV)3.1755248
Kurtosis21.773171
Mean2129345.2
Median Absolute Deviation (MAD)80160
Skewness4.5427865
Sum1.4266613 × 108
Variance4.5721783 × 1013
MonotonicityNot monotonic
2023-12-12T20:33:44.782639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
624590 1
 
1.5%
6437310 1
 
1.5%
268370 1
 
1.5%
82260 1
 
1.5%
60910 1
 
1.5%
259700 1
 
1.5%
643800 1
 
1.5%
2019360 1
 
1.5%
826710 1
 
1.5%
121490 1
 
1.5%
Other values (57) 57
85.1%
ValueCountFrequency (%)
30 1
1.5%
1230 1
1.5%
1270 1
1.5%
1780 1
1.5%
1860 1
1.5%
3670 1
1.5%
3750 1
1.5%
4500 1
1.5%
4940 1
1.5%
5000 1
1.5%
ValueCountFrequency (%)
41230740 1
1.5%
31046750 1
1.5%
19473790 1
1.5%
12043050 1
1.5%
6861130 1
1.5%
6437310 1
1.5%
3887300 1
1.5%
2188450 1
1.5%
2102070 1
1.5%
2089120 1
1.5%

Interactions

2023-12-12T20:33:40.453520image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:33:39.576351image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:33:40.023585image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:33:40.594874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:33:39.741682image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:33:40.164677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:33:40.755159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:33:39.883991image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T20:33:40.301521image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T20:33:44.940634image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
과세년도세목미지급건수미지급금액
과세년도1.0000.0000.0000.000
세목0.0001.0000.0000.000
미지급건수0.0000.0001.0001.000
미지급금액0.0000.0001.0001.000
2023-12-12T20:33:45.102790image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
과세년도미지급건수미지급금액세목
과세년도1.0000.1520.3730.000
미지급건수0.1521.0000.6960.000
미지급금액0.3730.6961.0000.000
세목0.0000.0000.0001.000

Missing values

2023-12-12T20:33:40.945698image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T20:33:41.146204image/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

시도명시군구명자치단체코드과세년도세목지급구분미지급건수미지급금액
0경기도양평군418302018106001 자동차세(자동차)미지급52624590
1경기도양평군418302018105304 재산세(토지)미지급62121490
2경기도양평군418302018106002 자동차세(이륜차)미지급311020
3경기도양평군418302018140001 지방소득세(종합소득)미지급20106330
4경기도양평군418302018140003 지방소득세(법인소득)미지급41270
5경기도양평군418302018140004 지방소득세(특별징수)미지급115030
6경기도양평군418302018114001 등록면허세(면허)미지급127980
7경기도양평군418302018140002 지방소득세(양도소득)미지급280630
8경기도양평군418302019106001 자동차세(자동차)미지급67821850
9경기도양평군418302019140001 지방소득세(종합소득)미지급311056220
시도명시군구명자치단체코드과세년도세목지급구분미지급건수미지급금액
57경기도양평군418302023106001 자동차세(자동차)미지급47719473790
58경기도양평군418302023106002 자동차세(이륜차)미지급31860
59경기도양평군418302023105305 재산세(주택)미지급7200670
60경기도양평군418302023140003 지방소득세(법인소득)미지급6448930
61경기도양평군418302023140004 지방소득세(특별징수)미지급340320
62경기도양평군418302023105301 재산세(건축물)미지급1671350
63경기도양평군418302023114001 등록면허세(면허)미지급1095150
64경기도양평군418302023140002 지방소득세(양도소득)미지급331046750
65경기도양평군418302023106003 자동차세(기계장비)미지급147120
66경기도양평군418302023114002 등록면허세(등록)미지급42089120