Overview

Dataset statistics

Number of variables11
Number of observations785
Missing cells0
Missing cells (%)0.0%
Duplicate rows94
Duplicate rows (%)12.0%
Total size in memory69.1 KiB
Average record size in memory90.2 B

Variable types

Categorical7
Numeric1
DateTime3

Dataset

Description충청남도 서천군 지방세 ARS간편납부시스템에 대한 데이터로 세목, 고지구분,고지금액, 부과일자, 징수일자, 수납형태 항목을 제공합니다.
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=320&beforeMenuCd=DOM_000000201001001000&publicdatapk=15092071

Alerts

시도명 has constant value ""Constant
시군구명 has constant value ""Constant
자치단체코드 has constant value ""Constant
수납형태 has constant value ""Constant
선택납부 has constant value ""Constant
기준일자 has constant value ""Constant
Dataset has 94 (12.0%) duplicate rowsDuplicates
고지구분 is highly imbalanced (62.5%)Imbalance

Reproduction

Analysis started2024-01-09 20:38:26.138895
Analysis finished2024-01-09 20:38:26.692291
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
충청남도
785 

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 (%)
충청남도 785
100.0%

Length

2024-01-10T05:38:26.742109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:38:26.818485image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
충청남도 785
100.0%

시군구명
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
서천군
785 

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 (%)
서천군 785
100.0%

Length

2024-01-10T05:38:26.902338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:38:26.978638image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서천군 785
100.0%

자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
44770
785 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
44770 785
100.0%

Length

2024-01-10T05:38:27.061261image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:38:27.138708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
44770 785
100.0%

세목명
Categorical

Distinct10
Distinct (%)1.3%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
재산세(토지)
308 
자동차세(자동차)
204 
재산세(주택)
149 
주민세(개인분)
49 
등록면허세(면허)
34 
Other values (5)
41 

Length

Max length11
Median length7
Mean length7.7592357
Min length7

Unique

Unique2 ?
Unique (%)0.3%

Sample

1st row등록면허세(면허)
2nd row등록면허세(면허)
3rd row등록면허세(면허)
4th row등록면허세(면허)
5th row등록면허세(면허)

Common Values

ValueCountFrequency (%)
재산세(토지) 308
39.2%
자동차세(자동차) 204
26.0%
재산세(주택) 149
19.0%
주민세(개인분) 49
 
6.2%
등록면허세(면허) 34
 
4.3%
재산세(건축물) 30
 
3.8%
지방소득세(종합소득) 5
 
0.6%
지방소득세(양도소득) 4
 
0.5%
자동차세(기계장비) 1
 
0.1%
주민세(사업소분) 1
 
0.1%

Length

2024-01-10T05:38:27.229280image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:38:27.355163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
재산세(토지 308
39.2%
자동차세(자동차 204
26.0%
재산세(주택 149
19.0%
주민세(개인분 49
 
6.2%
등록면허세(면허 34
 
4.3%
재산세(건축물 30
 
3.8%
지방소득세(종합소득 5
 
0.6%
지방소득세(양도소득 4
 
0.5%
자동차세(기계장비 1
 
0.1%
주민세(사업소분 1
 
0.1%

고지구분
Categorical

IMBALANCE 

Distinct3
Distinct (%)0.4%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
미납
675 
체납
109 
자납
 
1

Length

Max length2
Median length2
Mean length2
Min length2

Unique

Unique1 ?
Unique (%)0.1%

Sample

1st row미납
2nd row체납
3rd row미납
4th row미납
5th row미납

Common Values

ValueCountFrequency (%)
미납 675
86.0%
체납 109
 
13.9%
자납 1
 
0.1%

Length

2024-01-10T05:38:27.473427image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:38:27.558256image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
미납 675
86.0%
체납 109
 
13.9%
자납 1
 
0.1%

고지금액
Real number (ℝ)

Distinct560
Distinct (%)71.3%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean112265.71
Minimum2420
Maximum1792020
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size7.0 KiB
2024-01-10T05:38:27.658173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2420
5-th percentile5858
Q115240
median54970
Q3144040
95-th percentile373378
Maximum1792020
Range1789600
Interquartile range (IQR)128800

Descriptive statistics

Standard deviation180592.4
Coefficient of variation (CV)1.6086159
Kurtosis32.875213
Mean112265.71
Median Absolute Deviation (MAD)44120
Skewness4.835416
Sum88128580
Variance3.2613614 × 1010
MonotonicityNot monotonic
2024-01-10T05:38:27.827459image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
11000 45
 
5.7%
9000 20
 
2.5%
27070 15
 
1.9%
82150 5
 
0.6%
27000 5
 
0.6%
8850 5
 
0.6%
129870 4
 
0.5%
142630 4
 
0.5%
181540 4
 
0.5%
10850 4
 
0.5%
Other values (550) 674
85.9%
ValueCountFrequency (%)
2420 1
 
0.1%
2580 1
 
0.1%
2600 2
0.3%
2700 1
 
0.1%
2770 1
 
0.1%
2860 1
 
0.1%
2880 3
0.4%
2940 1
 
0.1%
3030 1
 
0.1%
3070 2
0.3%
ValueCountFrequency (%)
1792020 1
0.1%
1759580 1
0.1%
1562150 2
0.3%
1151250 1
0.1%
1070080 1
0.1%
996620 1
0.1%
985060 2
0.3%
955840 1
0.1%
746710 1
0.1%
701580 2
0.3%

부과일자
Date

Distinct20
Distinct (%)2.5%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
Minimum2021-01-05 00:00:00
Maximum2021-09-13 00:00:00
2024-01-10T05:38:27.940834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:38:28.035594image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=20)

징수일자
Date

Distinct18
Distinct (%)2.3%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
Minimum2021-01-05 00:00:00
Maximum2021-09-14 00:00:00
2024-01-10T05:38:28.130086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:38:28.219005image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=18)

수납형태
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
카드결제
785 

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 (%)
카드결제 785
100.0%

Length

2024-01-10T05:38:28.315567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:38:28.393305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
카드결제 785
100.0%

선택납부
Categorical

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
X
785 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
X 785
100.0%

Length

2024-01-10T05:38:28.473842image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T05:38:28.560499image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
x 785
100.0%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size6.3 KiB
Minimum2021-09-30 00:00:00
Maximum2021-09-30 00:00:00
2024-01-10T05:38:28.644320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T05:38:28.738122image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-10T05:38:26.383806image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T05:38:28.816348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
세목명고지구분고지금액부과일자징수일자
세목명1.0000.4310.4000.9940.973
고지구분0.4311.0000.0000.8960.551
고지금액0.4000.0001.0000.2730.376
부과일자0.9940.8960.2731.0000.997
징수일자0.9730.5510.3760.9971.000
2024-01-10T05:38:28.928112image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고지구분세목명
고지구분1.0000.286
세목명0.2861.000
2024-01-10T05:38:29.020318image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
고지금액세목명고지구분
고지금액1.0000.1920.000
세목명0.1921.0000.286
고지구분0.0000.2861.000

Missing values

2024-01-10T05:38:26.505793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T05:38:26.638707image/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충청남도서천군44770등록면허세(면허)미납270002021-01-052021-01-05카드결제X2021-09-30
1충청남도서천군44770등록면허세(면허)체납90002021-01-062021-01-06카드결제X2021-09-30
2충청남도서천군44770등록면허세(면허)미납90002021-01-062021-01-06카드결제X2021-09-30
3충청남도서천군44770등록면허세(면허)미납90002021-01-062021-01-06카드결제X2021-09-30
4충청남도서천군44770등록면허세(면허)미납90002021-01-062021-01-06카드결제X2021-09-30
5충청남도서천군44770등록면허세(면허)미납90002021-01-062021-01-06카드결제X2021-09-30
6충청남도서천군44770등록면허세(면허)미납180002021-01-062021-01-06카드결제X2021-09-30
7충청남도서천군44770등록면허세(면허)미납90002021-01-062021-01-06카드결제X2021-09-30
8충청남도서천군44770등록면허세(면허)미납90002021-01-062021-01-06카드결제X2021-09-30
9충청남도서천군44770등록면허세(면허)미납90002021-01-062021-01-06카드결제X2021-09-30
시도명시군구명자치단체코드세목명고지구분고지금액부과일자징수일자수납형태선택납부기준일자
775충청남도서천군44770재산세(토지)미납770402021-09-032021-09-03카드결제X2021-09-30
776충청남도서천군44770재산세(토지)미납117902021-09-032021-09-03카드결제X2021-09-30
777충청남도서천군44770재산세(토지)미납67902021-09-032021-09-03카드결제X2021-09-30
778충청남도서천군44770재산세(토지)미납248002021-09-032021-09-03카드결제X2021-09-30
779충청남도서천군44770재산세(토지)미납1085002021-09-032021-09-03카드결제X2021-09-30
780충청남도서천군44770재산세(토지)미납222102021-09-032021-09-03카드결제X2021-09-30
781충청남도서천군44770재산세(토지)미납1588702021-09-032021-09-03카드결제X2021-09-30
782충청남도서천군44770재산세(토지)미납1588702021-09-032021-09-03카드결제X2021-09-30
783충청남도서천군44770지방소득세(종합소득)미납1483002021-09-012021-09-09카드결제X2021-09-30
784충청남도서천군44770주민세(사업소분)미납550002021-09-132021-09-14카드결제X2021-09-30

Duplicate rows

Most frequently occurring

시도명시군구명자치단체코드세목명고지구분고지금액부과일자징수일자수납형태선택납부기준일자# duplicates
90충청남도서천군44770주민세(개인분)미납110002021-08-062021-08-06카드결제X2021-09-3033
1충청남도서천군44770등록면허세(면허)미납90002021-01-062021-01-06카드결제X2021-09-3015
91충청남도서천군44770주민세(개인분)체납110002021-08-062021-08-06카드결제X2021-09-3012
5충청남도서천군44770자동차세(자동차)미납270702021-06-082021-06-09카드결제X2021-09-3010
0충청남도서천군44770등록면허세(면허)미납88502021-01-062021-01-06카드결제X2021-09-305
27충청남도서천군44770자동차세(자동차)체납270702021-06-082021-06-09카드결제X2021-09-305
3충청남도서천군44770등록면허세(면허)미납270002021-01-062021-01-06카드결제X2021-09-304
17충청남도서천군44770자동차세(자동차)미납1815402021-06-082021-06-09카드결제X2021-09-304
28충청남도서천군44770자동차세(자동차)체납617502021-06-082021-06-09카드결제X2021-09-304
54충청남도서천군44770재산세(주택)미납821502021-07-072021-07-07카드결제X2021-09-304