Overview

Dataset statistics

Number of variables12
Number of observations30
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory3.1 KiB
Average record size in memory107.4 B

Variable types

Categorical7
Numeric5

Dataset

Description미환급 유형별 미환급금 현황 및 연간 누적률 제공과세연도, 세목별, 미환급 유형, 건수, 누적 건수 및 금액 증감률 제공
Author전북특별자치도 완주군
URLhttps://www.data.go.kr/data/15078407/fileData.do

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
자치단체코드 has constant value ""Constant
미환급유형 has constant value ""Constant
당해미환급건수 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 2 other fieldsHigh correlation
누적미환급금액 is highly overall correlated with 당해미환급건수 and 2 other fieldsHigh correlation
납세자유형 is highly overall correlated with 당해미환급건수High correlation
당해미환급금액 has unique valuesUnique
누적미환급금액 has unique valuesUnique
누적미환급금액증감 has 4 (13.3%) zerosZeros

Reproduction

Analysis started2024-04-21 01:46:56.013813
Analysis finished2024-04-21 01:47:00.068796
Duration4.05 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
전라북도
30 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row전라북도
2nd row전라북도
3rd row전라북도
4th row전라북도
5th row전라북도

Common Values

ValueCountFrequency (%)
전라북도 30
100.0%

Length

2024-04-21T10:47:00.138142image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:47:00.229741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
전라북도 30
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
완주군
30 

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 (%)
완주군 30
100.0%

Length

2024-04-21T10:47:00.332106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:47:00.434458image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
완주군 30
100.0%

자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
45710
30 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
45710 30
100.0%

Length

2024-04-21T10:47:00.539996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:47:00.640067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
45710 30
100.0%

세목명
Categorical

Distinct5
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
자동차세
10 
지방소득세
10 
재산세
7 
주민세
2 
담배소비세
 
1

Length

Max length5
Median length4
Mean length4.0666667
Min length3

Unique

Unique1 ?
Unique (%)3.3%

Sample

1st row자동차세
2nd row자동차세
3rd row재산세
4th row지방소득세
5th row지방소득세

Common Values

ValueCountFrequency (%)
자동차세 10
33.3%
지방소득세 10
33.3%
재산세 7
23.3%
주민세 2
 
6.7%
담배소비세 1
 
3.3%

Length

2024-04-21T10:47:00.744331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:47:00.848330image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
자동차세 10
33.3%
지방소득세 10
33.3%
재산세 7
23.3%
주민세 2
 
6.7%
담배소비세 1
 
3.3%

과세년도
Categorical

Distinct5
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
2020
7 
2021
7 
2018
6 
2017
5 
2019
5 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2020 7
23.3%
2021 7
23.3%
2018 6
20.0%
2017 5
16.7%
2019 5
16.7%

Length

2024-04-21T10:47:00.961519image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:47:01.060568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2020 7
23.3%
2021 7
23.3%
2018 6
20.0%
2017 5
16.7%
2019 5
16.7%

미환급유형
Categorical

CONSTANT 

Distinct1
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size372.0 B
신규
30 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row신규
2nd row신규
3rd row신규
4th row신규
5th row신규

Common Values

ValueCountFrequency (%)
신규 30
100.0%

Length

2024-04-21T10:47:01.349570image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:47:01.429677image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
신규 30
100.0%

납세자유형
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size372.0 B
개인
15 
법인
15 

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row개인
2nd row법인
3rd row개인
4th row개인
5th row법인

Common Values

ValueCountFrequency (%)
개인 15
50.0%
법인 15
50.0%

Length

2024-04-21T10:47:01.518517image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-21T10:47:01.610064image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
개인 15
50.0%
법인 15
50.0%

당해미환급건수
Real number (ℝ)

HIGH CORRELATION 

Distinct24
Distinct (%)80.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean60.033333
Minimum1
Maximum352
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-04-21T10:47:01.708563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q110.25
median23.5
Q382.25
95-th percentile201.95
Maximum352
Range351
Interquartile range (IQR)72

Descriptive statistics

Standard deviation80.017448
Coefficient of variation (CV)1.3328836
Kurtosis5.2753797
Mean60.033333
Median Absolute Deviation (MAD)16.5
Skewness2.1722986
Sum1801
Variance6402.792
MonotonicityNot monotonic
2024-04-21T10:47:01.825702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=24)
ValueCountFrequency (%)
1 3
 
10.0%
7 3
 
10.0%
30 2
 
6.7%
18 2
 
6.7%
93 1
 
3.3%
165 1
 
3.3%
15 1
 
3.3%
83 1
 
3.3%
97 1
 
3.3%
352 1
 
3.3%
Other values (14) 14
46.7%
ValueCountFrequency (%)
1 3
10.0%
7 3
10.0%
8 1
 
3.3%
10 1
 
3.3%
11 1
 
3.3%
14 1
 
3.3%
15 1
 
3.3%
16 1
 
3.3%
18 2
6.7%
23 1
 
3.3%
ValueCountFrequency (%)
352 1
3.3%
206 1
3.3%
197 1
3.3%
165 1
3.3%
129 1
3.3%
97 1
3.3%
93 1
3.3%
83 1
3.3%
80 1
3.3%
67 1
3.3%

당해미환급금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1017276.7
Minimum810
Maximum5870310
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-04-21T10:47:01.947388image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum810
5-th percentile9078
Q177455
median356800
Q31730070
95-th percentile2945341.5
Maximum5870310
Range5869500
Interquartile range (IQR)1652615

Descriptive statistics

Standard deviation1347530.5
Coefficient of variation (CV)1.3246451
Kurtosis4.5332517
Mean1017276.7
Median Absolute Deviation (MAD)342440
Skewness1.9432061
Sum30518300
Variance1.8158386 × 1012
MonotonicityNot monotonic
2024-04-21T10:47:02.061734image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
889980 1
 
3.3%
810 1
 
3.3%
1971120 1
 
3.3%
2856940 1
 
3.3%
39120 1
 
3.3%
454210 1
 
3.3%
671160 1
 
3.3%
1084290 1
 
3.3%
5870310 1
 
3.3%
20200 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
810 1
3.3%
6630 1
3.3%
12070 1
3.3%
16650 1
3.3%
20200 1
3.3%
39120 1
3.3%
52430 1
3.3%
55240 1
3.3%
144100 1
3.3%
155470 1
3.3%
ValueCountFrequency (%)
5870310 1
3.3%
3017670 1
3.3%
2856940 1
3.3%
2773120 1
3.3%
2589030 1
3.3%
2096990 1
3.3%
1971120 1
3.3%
1930030 1
3.3%
1130190 1
3.3%
1084290 1
3.3%

누적미환급건수
Real number (ℝ)

HIGH CORRELATION 

Distinct27
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean146
Minimum1
Maximum914
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-04-21T10:47:02.178683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1.45
Q126.75
median55
Q3168
95-th percentile551.3
Maximum914
Range913
Interquartile range (IQR)141.25

Descriptive statistics

Standard deviation208.33891
Coefficient of variation (CV)1.4269789
Kurtosis5.8788139
Mean146
Median Absolute Deviation (MAD)45
Skewness2.3423287
Sum4380
Variance43405.103
MonotonicityNot monotonic
2024-04-21T10:47:02.284220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
168 2
 
6.7%
77 2
 
6.7%
1 2
 
6.7%
26 1
 
3.3%
49 1
 
3.3%
374 1
 
3.3%
2 1
 
3.3%
29 1
 
3.3%
159 1
 
3.3%
914 1
 
3.3%
Other values (17) 17
56.7%
ValueCountFrequency (%)
1 2
6.7%
2 1
3.3%
8 1
3.3%
11 1
3.3%
14 1
3.3%
19 1
3.3%
26 1
3.3%
29 1
3.3%
31 1
3.3%
38 1
3.3%
ValueCountFrequency (%)
914 1
3.3%
572 1
3.3%
526 1
3.3%
374 1
3.3%
329 1
3.3%
209 1
3.3%
200 1
3.3%
168 2
6.7%
159 1
3.3%
101 1
3.3%

누적미환급금액
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct30
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2246302.7
Minimum810
Maximum13288550
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-04-21T10:47:02.406251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum810
5-th percentile19562.5
Q1231777.5
median1210865
Q32219672.5
95-th percentile7702746
Maximum13288550
Range13287740
Interquartile range (IQR)1987895

Descriptive statistics

Standard deviation3043085.1
Coefficient of variation (CV)1.3547084
Kurtosis5.1705931
Mean2246302.7
Median Absolute Deviation (MAD)1030915
Skewness2.1693661
Sum67389080
Variance9.2603669 × 1012
MonotonicityNot monotonic
2024-04-21T10:47:02.545901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=30)
ValueCountFrequency (%)
2251500 1
 
3.3%
810 1
 
3.3%
2016930 1
 
3.3%
7889910 1
 
3.3%
94360 1
 
3.3%
1477460 1
 
3.3%
2124190 1
 
3.3%
1823350 1
 
3.3%
13288550 1
 
3.3%
45810 1
 
3.3%
Other values (20) 20
66.7%
ValueCountFrequency (%)
810 1
3.3%
12070 1
3.3%
28720 1
3.3%
35350 1
3.3%
45810 1
3.3%
55240 1
3.3%
94360 1
3.3%
189670 1
3.3%
358100 1
3.3%
525140 1
3.3%
ValueCountFrequency (%)
13288550 1
3.3%
7889910 1
3.3%
7473990 1
3.3%
6278520 1
3.3%
5039240 1
3.3%
4181530 1
3.3%
3690900 1
3.3%
2251500 1
3.3%
2124190 1
3.3%
2016930 1
3.3%

누적미환급금액증감
Real number (ℝ)

ZEROS 

Distinct27
Distinct (%)90.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean220.794
Minimum0
Maximum2517.38
Zeros4
Zeros (%)13.3%
Negative0
Negative (%)0.0%
Memory size402.0 B
2024-04-21T10:47:02.666913image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile0
Q148.96
median128.555
Q3207.2325
95-th percentile542.5805
Maximum2517.38
Range2517.38
Interquartile range (IQR)158.2725

Descriptive statistics

Standard deviation454.54738
Coefficient of variation (CV)2.0586945
Kurtosis24.353572
Mean220.794
Median Absolute Deviation (MAD)83.64
Skewness4.7605452
Sum6623.82
Variance206613.32
MonotonicityNot monotonic
2024-04-21T10:47:02.778715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=27)
ValueCountFrequency (%)
0.0 4
 
13.3%
152.98 1
 
3.3%
147.67 1
 
3.3%
2.32 1
 
3.3%
176.17 1
 
3.3%
141.21 1
 
3.3%
225.28 1
 
3.3%
216.5 1
 
3.3%
68.16 1
 
3.3%
126.37 1
 
3.3%
Other values (17) 17
56.7%
ValueCountFrequency (%)
0.0 4
13.3%
2.32 1
 
3.3%
16.78 1
 
3.3%
31.62 1
 
3.3%
42.56 1
 
3.3%
68.16 1
 
3.3%
72.49 1
 
3.3%
81.72 1
 
3.3%
91.05 1
 
3.3%
116.66 1
 
3.3%
ValueCountFrequency (%)
2517.38 1
3.3%
632.09 1
3.3%
433.18 1
3.3%
307.36 1
3.3%
225.28 1
3.3%
218.77 1
3.3%
216.5 1
3.3%
209.84 1
3.3%
199.41 1
3.3%
176.17 1
3.3%

Interactions

2024-04-21T10:46:59.343338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:57.553097image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.140888image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.521194image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.922733image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:59.437684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:57.700702image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.223002image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.619177image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.998743image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:59.529701image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:57.888841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.300212image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.704354image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:59.087819image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:59.611250image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:57.963430image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.364895image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.771116image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:59.172089image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:59.711067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.046025image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.442248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:58.853525image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-21T10:46:59.252840image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-04-21T10:47:02.859537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세목명과세년도납세자유형당해미환급건수당해미환급금액누적미환급건수누적미환급금액누적미환급금액증감
세목명1.0000.0000.0860.0000.2730.0000.0000.000
과세년도0.0001.0000.0000.0000.0000.0000.2700.380
납세자유형0.0860.0001.0000.5560.4700.6310.4080.289
당해미환급건수0.0000.0000.5561.0000.8290.9570.9570.000
당해미환급금액0.2730.0000.4700.8291.0000.8930.8240.000
누적미환급건수0.0000.0000.6310.9570.8931.0000.9010.000
누적미환급금액0.0000.2700.4080.9570.8240.9011.0000.000
누적미환급금액증감0.0000.3800.2890.0000.0000.0000.0001.000
2024-04-21T10:47:02.965394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
납세자유형과세년도세목명
납세자유형1.0000.0000.071
과세년도0.0001.0000.000
세목명0.0710.0001.000
2024-04-21T10:47:03.048343image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
당해미환급건수당해미환급금액누적미환급건수누적미환급금액누적미환급금액증감세목명과세년도납세자유형
당해미환급건수1.0000.8610.9480.8680.1880.0000.0000.537
당해미환급금액0.8611.0000.8290.931-0.0320.0000.0000.335
누적미환급건수0.9480.8291.0000.8930.3220.0000.0000.416
누적미환급금액0.8680.9310.8931.0000.2180.0000.1520.413
누적미환급금액증감0.188-0.0320.3220.2181.0000.0000.3050.176
세목명0.0000.0000.0000.0000.0001.0000.0000.071
과세년도0.0000.0000.0000.1520.3050.0001.0000.000
납세자유형0.5370.3350.4160.4130.1760.0710.0001.000

Missing values

2024-04-21T10:46:59.835624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-04-21T10:46:59.984100image/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전라북도완주군45710자동차세2017신규개인938899802002251500152.98
1전라북도완주군45710자동차세2017신규법인1815547038358100130.33
2전라북도완주군45710재산세2017신규개인71441001118967031.62
3전라북도완주군45710지방소득세2017신규개인2416474047525140218.77
4전라북도완주군45710지방소득세2017신규법인8120708120700.0
5전라북도완주군45710자동차세2018신규개인12919300303294181530116.66
6전라북도완주군45710자동차세2018신규법인2325736061615460139.14
7전라북도완주군45710재산세2018신규개인30113019041131986016.78
8전라북도완주군45710재산세2018신규법인1410232501410232500.0
9전라북도완주군45710지방소득세2018신규개인54576730101110187091.05
시도명시군구명자치단체코드세목명과세년도미환급유형납세자유형당해미환급건수당해미환급금액누적미환급건수누적미환급금액누적미환급금액증감
20전라북도완주군45710주민세2020신규법인1552401552400.0
21전라북도완주군45710지방소득세2020신규개인802773120209503924081.72
22전라북도완주군45710지방소득세2020신규법인10202003145810126.78
23전라북도완주군45710자동차세2021신규개인352587031091413288550126.37
24전라북도완주군45710자동차세2021신규법인971084290168182335068.16
25전라북도완주군45710재산세2021신규개인836711601592124190216.5
26전라북도완주군45710재산세2021신규법인15454210291477460225.28
27전라북도완주군45710주민세2021신규법인139120294360141.21
28전라북도완주군45710지방소득세2021신규개인16528569403747889910176.17
29전라북도완주군45710지방소득세2021신규법인1819711204920169302.32