Overview

Dataset statistics

Number of variables4
Number of observations7542
Missing cells0
Missing cells (%)0.0%
Duplicate rows1050
Duplicate rows (%)13.9%
Total size in memory235.8 KiB
Average record size in memory32.0 B

Variable types

Categorical2
DateTime2

Dataset

Description대전광역시 서구 불법주정차 현장단속 현황입니다. 시군구정보, 단속동, 날속날짜, 단속시간 등의 항목을 제공합니다.
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15122496/fileData.do

Alerts

시군구정보 has constant value ""Constant
Dataset has 1050 (13.9%) duplicate rowsDuplicates
단속동 is highly imbalanced (58.7%)Imbalance

Reproduction

Analysis started2023-12-11 23:03:45.332199
Analysis finished2023-12-11 23:03:45.588927
Duration0.26 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군구정보
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size59.1 KiB
서구
7542 

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 (%)
서구 7542
100.0%

Length

2023-12-12T08:03:45.643407image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:03:45.724589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서구 7542
100.0%

단속동
Categorical

IMBALANCE 

Distinct21
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size59.1 KiB
둔산1동
4250 
둔산2동
1538 
탄방동
1308 
둔산동
 
100
월평동
 
52
Other values (16)
 
294

Length

Max length4
Median length4
Mean length3.7673031
Min length2

Unique

Unique4 ?
Unique (%)0.1%

Sample

1st row둔산2동
2nd row둔산2동
3rd row둔산2동
4th row둔산2동
5th row둔산2동

Common Values

ValueCountFrequency (%)
둔산1동 4250
56.4%
둔산2동 1538
 
20.4%
탄방동 1308
 
17.3%
둔산동 100
 
1.3%
월평동 52
 
0.7%
용문동 50
 
0.7%
괴정동 48
 
0.6%
관저동 42
 
0.6%
도안동 42
 
0.6%
도마동 31
 
0.4%
Other values (11) 81
 
1.1%

Length

2023-12-12T08:03:45.823267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
둔산1동 4250
56.4%
둔산2동 1538
 
20.4%
탄방동 1308
 
17.3%
둔산동 100
 
1.3%
월평동 52
 
0.7%
용문동 50
 
0.7%
괴정동 48
 
0.6%
관저동 42
 
0.6%
도안동 42
 
0.6%
도마동 31
 
0.4%
Other values (11) 81
 
1.1%

단속날짜
Date

Distinct196
Distinct (%)2.6%
Missing0
Missing (%)0.0%
Memory size59.1 KiB
Minimum2022-08-01 00:00:00
Maximum2023-08-29 00:00:00
2023-12-12T08:03:45.934909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:03:46.076754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속시간
Date

Distinct309
Distinct (%)4.1%
Missing0
Missing (%)0.0%
Memory size59.1 KiB
Minimum2023-12-12 07:48:00
Maximum2023-12-12 20:36:00
2023-12-12T08:03:46.208856image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:03:46.357346image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

Missing values

2023-12-12T08:03:45.481176image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:03:45.556190image/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서구둔산2동2022-08-0109:41
1서구둔산2동2022-08-0109:43
2서구둔산2동2022-08-0109:43
3서구둔산2동2022-08-0109:44
4서구둔산2동2022-08-0109:45
5서구둔산2동2022-08-0109:46
6서구둔산2동2022-08-0109:49
7서구둔산2동2022-08-0109:50
8서구둔산2동2022-08-0109:51
9서구둔산2동2022-08-0109:52
시군구정보단속동단속날짜단속시간
7532서구둔산1동2023-08-2815:45
7533서구둔산1동2023-08-2815:46
7534서구둔산1동2023-08-2815:47
7535서구둔산1동2023-08-2815:47
7536서구둔산1동2023-08-2816:00
7537서구둔산1동2023-08-2816:01
7538서구둔산1동2023-08-2816:02
7539서구둔산1동2023-08-2816:02
7540서구둔산1동2023-08-2816:03
7541서구둔산동2023-08-2910:38

Duplicate rows

Most frequently occurring

시군구정보단속동단속날짜단속시간# duplicates
0서구가수원동2022-08-2410:392
1서구괴정동2023-03-0710:072
2서구괴정동2023-03-0710:092
3서구괴정동2023-03-0815:182
4서구괴정동2023-05-0914:152
5서구내동2022-09-0614:002
6서구도마동2022-09-0809:572
7서구도안동2023-04-2816:362
8서구둔산1동2022-08-0115:522
9서구둔산1동2022-08-0115:562