Overview

Dataset statistics

Number of variables10
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory888.7 KiB
Average record size in memory91.0 B

Variable types

Numeric2
Categorical6
Text1
DateTime1

Dataset

Description대전광역시 서구 관내 장애인전용 주차구역위반 과태료 부과현황(부과번호, 부과일자, 수납일자, 수납금액 등) 정보를 제공합니다.
URLhttps://www.data.go.kr/data/15113112/fileData.do

Alerts

부서 has constant value ""Constant
과목코드 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
부과번호 has unique valuesUnique

Reproduction

Analysis started2023-12-12 14:47:14.012457
Analysis finished2023-12-12 14:47:15.060033
Duration1.05 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean7458.0642
Minimum2
Maximum14902
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T23:47:15.122687image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2
5-th percentile767.95
Q13717
median7500.5
Q311191.25
95-th percentile14171.05
Maximum14902
Range14900
Interquartile range (IQR)7474.25

Descriptive statistics

Standard deviation4308.6701
Coefficient of variation (CV)0.57771964
Kurtosis-1.2041895
Mean7458.0642
Median Absolute Deviation (MAD)3743
Skewness-0.0056214503
Sum74580642
Variance18564638
MonotonicityNot monotonic
2023-12-12T23:47:15.260477image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
8385 1
 
< 0.1%
3984 1
 
< 0.1%
3889 1
 
< 0.1%
7605 1
 
< 0.1%
7549 1
 
< 0.1%
3228 1
 
< 0.1%
2563 1
 
< 0.1%
9008 1
 
< 0.1%
2007 1
 
< 0.1%
9563 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
2 1
< 0.1%
3 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
11 1
< 0.1%
12 1
< 0.1%
13 1
< 0.1%
ValueCountFrequency (%)
14902 1
< 0.1%
14901 1
< 0.1%
14900 1
< 0.1%
14899 1
< 0.1%
14897 1
< 0.1%
14896 1
< 0.1%
14894 1
< 0.1%
14893 1
< 0.1%
14892 1
< 0.1%
14891 1
< 0.1%

부서
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
주민복지국 노인장애인과
10000 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주민복지국 노인장애인과
2nd row주민복지국 노인장애인과
3rd row주민복지국 노인장애인과
4th row주민복지국 노인장애인과
5th row주민복지국 노인장애인과

Common Values

ValueCountFrequency (%)
주민복지국 노인장애인과 10000
100.0%

Length

2023-12-12T23:47:15.401106image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:47:15.481429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주민복지국 10000
50.0%
노인장애인과 10000
50.0%

회계연도
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2019
2747 
2020
2413 
2022
1990 
2021
1733 
2023
1117 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021
2nd row2020
3rd row2020
4th row2021
5th row2021

Common Values

ValueCountFrequency (%)
2019 2747
27.5%
2020 2413
24.1%
2022 1990
19.9%
2021 1733
17.3%
2023 1117
11.2%

Length

2023-12-12T23:47:15.566990image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:47:15.693868image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2019 2747
27.5%
2020 2413
24.1%
2022 1990
19.9%
2021 1733
17.3%
2023 1117
11.2%

과목코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
41-288130
10000 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row41-288130
2nd row41-288130
3rd row41-288130
4th row41-288130
5th row41-288130

Common Values

ValueCountFrequency (%)
41-288130 10000
100.0%

Length

2023-12-12T23:47:15.811493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:47:15.911784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
41-288130 10000
100.0%

과목명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
장애인주차구역위반과태료
10000 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row장애인주차구역위반과태료
2nd row장애인주차구역위반과태료
3rd row장애인주차구역위반과태료
4th row장애인주차구역위반과태료
5th row장애인주차구역위반과태료

Common Values

ValueCountFrequency (%)
장애인주차구역위반과태료 10000
100.0%

Length

2023-12-12T23:47:16.028162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:47:16.119900image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
장애인주차구역위반과태료 10000
100.0%

부과번호
Text

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T23:47:16.288368image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length14
Mean length14
Min length14

Characters and Unicode

Total characters140000
Distinct characters11
Distinct categories2 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique10000 ?
Unique (%)100.0%

Sample

1st row2021-000852-00
2nd row2020-003763-00
3rd row2020-001933-00
4th row2021-002939-00
5th row2021-000216-00
ValueCountFrequency (%)
2021-000852-00 1
 
< 0.1%
2021-001659-00 1
 
< 0.1%
2020-000067-00 1
 
< 0.1%
2022-001626-00 1
 
< 0.1%
2019-005312-00 1
 
< 0.1%
2020-005123-00 1
 
< 0.1%
2020-005052-00 1
 
< 0.1%
2019-004410-00 1
 
< 0.1%
2019-003527-00 1
 
< 0.1%
2019-005527-00 1
 
< 0.1%
Other values (9990) 9990
99.9%
2023-12-12T23:47:16.679685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
0 57782
41.3%
2 24392
17.4%
- 20000
 
14.3%
1 9892
 
7.1%
3 5922
 
4.2%
9 5571
 
4.0%
4 4138
 
3.0%
5 3442
 
2.5%
6 2996
 
2.1%
8 2984
 
2.1%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 120000
85.7%
Dash Punctuation 20000
 
14.3%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
0 57782
48.2%
2 24392
20.3%
1 9892
 
8.2%
3 5922
 
4.9%
9 5571
 
4.6%
4 4138
 
3.4%
5 3442
 
2.9%
6 2996
 
2.5%
8 2984
 
2.5%
7 2881
 
2.4%
Dash Punctuation
ValueCountFrequency (%)
- 20000
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 140000
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
0 57782
41.3%
2 24392
17.4%
- 20000
 
14.3%
1 9892
 
7.1%
3 5922
 
4.2%
9 5571
 
4.0%
4 4138
 
3.0%
5 3442
 
2.5%
6 2996
 
2.1%
8 2984
 
2.1%

Most occurring blocks

ValueCountFrequency (%)
ASCII 140000
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
0 57782
41.3%
2 24392
17.4%
- 20000
 
14.3%
1 9892
 
7.1%
3 5922
 
4.2%
9 5571
 
4.0%
4 4138
 
3.0%
5 3442
 
2.5%
6 2996
 
2.1%
8 2984
 
2.1%

부과일자
Date

Distinct574
Distinct (%)5.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2019-01-04 00:00:00
Maximum2023-08-14 00:00:00
2023-12-12T23:47:16.842195image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:47:16.988095image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

수납금액
Real number (ℝ)

Distinct21
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean96364.35
Minimum0
Maximum2000000
Zeros32
Zeros (%)0.3%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T23:47:17.125611image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum0
5-th percentile50000
Q180000
median80000
Q3100000
95-th percentile100000
Maximum2000000
Range2000000
Interquartile range (IQR)20000

Descriptive statistics

Standard deviation128150.01
Coefficient of variation (CV)1.3298487
Kurtosis135.37668
Mean96364.35
Median Absolute Deviation (MAD)0
Skewness11.379669
Sum9.636435 × 108
Variance1.6422425 × 1010
MonotonicityNot monotonic
2023-12-12T23:47:17.254955image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=21)
ValueCountFrequency (%)
80000 6313
63.1%
100000 3000
30.0%
40000 418
 
4.2%
50000 86
 
0.9%
1600000 53
 
0.5%
400000 34
 
0.3%
0 32
 
0.3%
200000 18
 
0.2%
500000 17
 
0.2%
2000000 7
 
0.1%
Other values (11) 22
 
0.2%
ValueCountFrequency (%)
0 32
 
0.3%
20000 1
 
< 0.1%
40000 418
 
4.2%
50000 86
 
0.9%
80000 6313
63.1%
100000 3000
30.0%
101000 1
 
< 0.1%
101240 1
 
< 0.1%
101260 1
 
< 0.1%
160000 1
 
< 0.1%
ValueCountFrequency (%)
2000000 7
 
0.1%
1600000 53
0.5%
1500000 1
 
< 0.1%
1150000 1
 
< 0.1%
1000000 5
 
0.1%
800000 2
 
< 0.1%
700000 3
 
< 0.1%
500000 17
 
0.2%
400000 34
0.3%
250000 5
 
0.1%

수납구분
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
수납
10000 

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 (%)
수납 10000
100.0%

Length

2023-12-12T23:47:17.652510image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:47:17.753811image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수납 10000
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-08-17
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-17
2nd row2023-08-17
3rd row2023-08-17
4th row2023-08-17
5th row2023-08-17

Common Values

ValueCountFrequency (%)
2023-08-17 10000
100.0%

Length

2023-12-12T23:47:17.856185image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T23:47:17.961222image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-17 10000
100.0%

Interactions

2023-12-12T23:47:14.622227image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:47:14.411325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:47:14.718810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T23:47:14.508370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T23:47:18.019204image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번회계연도수납금액
순번1.0000.9980.073
회계연도0.9981.0000.060
수납금액0.0730.0601.000
2023-12-12T23:47:18.103573image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번수납금액회계연도
순번1.000-0.2050.932
수납금액-0.2051.0000.037
회계연도0.9320.0371.000

Missing values

2023-12-12T23:47:14.854874image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T23:47:14.996228image/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

순번부서회계연도과목코드과목명부과번호부과일자수납금액수납구분데이터기준일
83848385주민복지국 노인장애인과202141-288130장애인주차구역위반과태료2021-000852-002021-03-1980000수납2023-08-17
65646565주민복지국 노인장애인과202041-288130장애인주차구역위반과태료2020-003763-002020-09-17100000수납2023-08-17
52965297주민복지국 노인장애인과202041-288130장애인주차구역위반과태료2020-001933-002020-03-2480000수납2023-08-17
98569857주민복지국 노인장애인과202141-288130장애인주차구역위반과태료2021-002939-002021-10-1880000수납2023-08-17
79007901주민복지국 노인장애인과202141-288130장애인주차구역위반과태료2021-000216-002021-01-0880000수납2023-08-17
77917792주민복지국 노인장애인과202141-288130장애인주차구역위반과태료2021-000070-002021-01-0480000수납2023-08-17
1237112372주민복지국 노인장애인과202241-288130장애인주차구역위반과태료2022-003167-002022-09-2180000수납2023-08-17
63136314주민복지국 노인장애인과202041-288130장애인주차구역위반과태료2020-003445-002020-08-13100000수납2023-08-17
1282912830주민복지국 노인장애인과202241-288130장애인주차구역위반과태료2022-003824-002022-11-1080000수납2023-08-17
84988499주민복지국 노인장애인과202141-288130장애인주차구역위반과태료2021-001005-002021-05-10100000수납2023-08-17
순번부서회계연도과목코드과목명부과번호부과일자수납금액수납구분데이터기준일
49644965주민복지국 노인장애인과202041-288130장애인주차구역위반과태료2020-001439-002020-02-2080000수납2023-08-17
47304731주민복지국 노인장애인과202041-288130장애인주차구역위반과태료2020-000928-002020-01-2380000수납2023-08-17
87558756주민복지국 노인장애인과202141-288130장애인주차구역위반과태료2021-001339-002021-06-07100000수납2023-08-17
50725073주민복지국 노인장애인과202041-288130장애인주차구역위반과태료2020-001609-002020-04-13100000수납2023-08-17
75327533주민복지국 노인장애인과202041-288130장애인주차구역위반과태료2020-005029-002020-11-0640000수납2023-08-17
1441114412주민복지국 노인장애인과202341-288130장애인주차구역위반과태료2023-001865-002023-05-1280000수납2023-08-17
30563057주민복지국 노인장애인과201941-288130장애인주차구역위반과태료2019-004183-002019-09-0980000수납2023-08-17
700701주민복지국 노인장애인과201941-288130장애인주차구역위반과태료2019-000981-002019-03-19100000수납2023-08-17
1340013401주민복지국 노인장애인과202341-288130장애인주차구역위반과태료2023-000270-002023-01-2080000수납2023-08-17
13561357주민복지국 노인장애인과201941-288130장애인주차구역위반과태료2019-001891-002019-05-0780000수납2023-08-17