Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows348
Duplicate rows (%)3.5%
Total size in memory546.9 KiB
Average record size in memory56.0 B

Variable types

Categorical6

Dataset

Description대구광역시 달서구_불법주정차 단속 현황_20230101
Author대구광역시 달서구
URLhttp://data.daegu.go.kr/open/data/dataView.do?dataSetId=15037876&dataSetDetailId=150378761bf56ea981ce0&provdMethod=FILE

Alerts

해당구 has constant value "대구광역시 달서구"Constant
부서명 has constant value "주차관리과"Constant
기준일자 has constant value "2023-01-01"Constant
Dataset has 348 (3.5%) duplicate rowsDuplicates
위반일자 has a high cardinality: 294 distinct valuesHigh cardinality
위반시간 has a high cardinality: 763 distinct valuesHigh cardinality
위반장소명 has a high cardinality: 831 distinct valuesHigh cardinality

Reproduction

Analysis started2023-07-15 13:22:05.391678
Analysis finished2023-07-15 13:22:06.145578
Duration0.75 seconds
Software versionpandas-profiling v3.6.6
Download configurationconfig.json

Variables

해당구
Categorical

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
대구광역시 달서구
10000 

Length

Max length9
Median length9
Mean length9
Min length9

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row대구광역시 달서구
2nd row대구광역시 달서구
3rd row대구광역시 달서구
4th row대구광역시 달서구
5th row대구광역시 달서구

Common Values

ValueCountFrequency (%)
대구광역시 달서구 10000
100.0%

Length

2023-07-15T22:22:06.232390image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-07-15T22:22:06.687862image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
ValueCountFrequency (%)
대구광역시 10000
50.0%
달서구 10000
50.0%

위반일자
Categorical

Distinct294
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2017-08-02
 
78
2017-08-04
 
70
2017-01-24
 
70
2017-02-24
 
69
2017-01-10
 
68
Other values (289)
9645 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique5 ?
Unique (%)< 0.1%

Sample

1st row2017-04-25
2nd row2017-01-05
3rd row2017-07-18
4th row2017-09-28
5th row2017-09-20

Common Values

ValueCountFrequency (%)
2017-08-02 78
 
0.8%
2017-08-04 70
 
0.7%
2017-01-24 70
 
0.7%
2017-02-24 69
 
0.7%
2017-01-10 68
 
0.7%
2017-02-13 68
 
0.7%
2017-02-08 67
 
0.7%
2017-07-12 66
 
0.7%
2017-02-02 64
 
0.6%
2017-03-20 63
 
0.6%
Other values (284) 9317
93.2%

Length

2023-07-15T22:22:06.839555image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
2017-08-02 78
 
0.8%
2017-01-24 70
 
0.7%
2017-08-04 70
 
0.7%
2017-02-24 69
 
0.7%
2017-01-10 68
 
0.7%
2017-02-13 68
 
0.7%
2017-02-08 67
 
0.7%
2017-07-12 66
 
0.7%
2017-02-02 64
 
0.6%
2017-03-20 63
 
0.6%
Other values (284) 9317
93.2%

위반시간
Categorical

Distinct763
Distinct (%)7.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
14:12
 
57
14:24
 
54
14:30
 
52
14:35
 
51
14:38
 
50
Other values (758)
9736 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique68 ?
Unique (%)0.7%

Sample

1st row16:04
2nd row16:04
3rd row09:19
4th row16:01
5th row15:52

Common Values

ValueCountFrequency (%)
14:12 57
 
0.6%
14:24 54
 
0.5%
14:30 52
 
0.5%
14:35 51
 
0.5%
14:38 50
 
0.5%
14:33 49
 
0.5%
14:46 47
 
0.5%
14:28 47
 
0.5%
14:11 46
 
0.5%
14:51 46
 
0.5%
Other values (753) 9501
95.0%

Length

2023-07-15T22:22:07.042812image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
14:12 57
 
0.6%
14:24 54
 
0.5%
14:30 52
 
0.5%
14:35 51
 
0.5%
14:38 50
 
0.5%
14:33 49
 
0.5%
14:46 47
 
0.5%
14:28 47
 
0.5%
14:11 46
 
0.5%
14:51 46
 
0.5%
Other values (753) 9501
95.0%

위반장소명
Categorical

Distinct831
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
대우월드마크부근
 
428
월배새마을금고월성지점
 
408
월성CGV
 
370
진천역환승주차장입구
 
307
본리동 당산로 부근
 
223
Other values (826)
8264 

Length

Max length22
Median length18
Mean length9.071
Min length4

Unique

Unique407 ?
Unique (%)4.1%

Sample

1st row성당레미안앞네거리
2nd row장기동협성휴포레
3rd row진천역환승주차장입구
4th row월배새마을금고월성지점
5th row대우월드마크 E-1충전소

Common Values

ValueCountFrequency (%)
대우월드마크부근 428
 
4.3%
월배새마을금고월성지점 408
 
4.1%
월성CGV 370
 
3.7%
진천역환승주차장입구 307
 
3.1%
본리동 당산로 부근 223
 
2.2%
본리동우체국 208
 
2.1%
감삼동 장기로 부근 201
 
2.0%
월성동 조암로 부근 194
 
1.9%
월배E마트 184
 
1.8%
진천동 월배로 부근 178
 
1.8%
Other values (821) 7299
73.0%

Length

2023-07-15T22:22:07.223583image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
부근 3610
 
19.5%
상인동 549
 
3.0%
감삼동 441
 
2.4%
두류동 432
 
2.3%
대우월드마크부근 428
 
2.3%
이곡동 421
 
2.3%
월배새마을금고월성지점 408
 
2.2%
용산동 379
 
2.0%
본리동 377
 
2.0%
월성cgv 370
 
2.0%
Other values (732) 11123
60.0%

부서명
Categorical

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
주차관리과
10000 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주차관리과
2nd row주차관리과
3rd row주차관리과
4th row주차관리과
5th row주차관리과

Common Values

ValueCountFrequency (%)
주차관리과 10000
100.0%

Length

2023-07-15T22:22:07.389899image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-07-15T22:22:07.549932image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
ValueCountFrequency (%)
주차관리과 10000
100.0%

기준일자
Categorical

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

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-01-01
2nd row2023-01-01
3rd row2023-01-01
4th row2023-01-01
5th row2023-01-01

Common Values

ValueCountFrequency (%)
2023-01-01 10000
100.0%

Length

2023-07-15T22:22:07.669475image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-07-15T22:22:07.813996image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
ValueCountFrequency (%)
2023-01-01 10000
100.0%

Missing values

2023-07-15T22:22:05.792494image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
A simple visualization of nullity by column.
2023-07-15T22:22:06.041718image/svg+xmlMatplotlib v3.7.1, https://matplotlib.org/
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

Sample

해당구위반일자위반시간위반장소명부서명기준일자
37628대구광역시 달서구2017-04-2516:04성당레미안앞네거리주차관리과2023-01-01
1592대구광역시 달서구2017-01-0516:04장기동협성휴포레주차관리과2023-01-01
61756대구광역시 달서구2017-07-1809:19진천역환승주차장입구주차관리과2023-01-01
86267대구광역시 달서구2017-09-2816:01월배새마을금고월성지점주차관리과2023-01-01
83736대구광역시 달서구2017-09-2015:52대우월드마크 E-1충전소주차관리과2023-01-01
21254대구광역시 달서구2017-03-0610:23본리동 대명천로42길 부주차관리과2023-01-01
71863대구광역시 달서구2017-08-1608:46용산동맥도날드주차관리과2023-01-01
86670대구광역시 달서구2017-10-1010:32진천역환승주차장입구주차관리과2023-01-01
88992대구광역시 달서구2017-10-1810:25성당동 성당로 부근주차관리과2023-01-01
66257대구광역시 달서구2017-08-0110:54상인동 월촌고가교주차관리과2023-01-01
해당구위반일자위반시간위반장소명부서명기준일자
72555대구광역시 달서구2017-08-1814:39조달청부근주차관리과2023-01-01
21346대구광역시 달서구2017-03-0610:33블랙야크주차관리과2023-01-01
14570대구광역시 달서구2017-02-1414:37진천역환승주차장입구주차관리과2023-01-01
53879대구광역시 달서구2017-06-2511:11월성CGV주차관리과2023-01-01
56773대구광역시 달서구2017-07-0414:14대우월드마크부근주차관리과2023-01-01
20336대구광역시 달서구2017-03-0215:57상인동롯데리아주차관리과2023-01-01
3790대구광역시 달서구2017-01-1214:53이곡동 이곡동로 부근주차관리과2023-01-01
27708대구광역시 달서구2017-03-2410:26두류동 달구벌대로344길주차관리과2023-01-01
43497대구광역시 달서구2017-05-1814:37두류동 달구벌대로344길주차관리과2023-01-01
4263대구광역시 달서구2017-01-1311:04원더풀스파랜드주차관리과2023-01-01

Duplicate rows

Most frequently occurring

해당구위반일자위반시간위반장소명부서명기준일자# duplicates
36대구광역시 달서구2017-01-2510:48상인동 상화로 부근주차관리과2023-01-014
102대구광역시 달서구2017-03-1214:13감삼동 용산로 부근주차관리과2023-01-014
105대구광역시 달서구2017-03-1307:42이곡동 선원남로 부근주차관리과2023-01-014
221대구광역시 달서구2017-06-1411:09본리동 당산로 부근주차관리과2023-01-014
236대구광역시 달서구2017-06-2814:44두류동 달구벌대로 부근주차관리과2023-01-014
288대구광역시 달서구2017-08-0415:01상인동 상화로 부근주차관리과2023-01-014
301대구광역시 달서구2017-08-1620:00도원동 도원로서길 부근주차관리과2023-01-014
304대구광역시 달서구2017-08-2013:32용산동 달구벌대로 부근주차관리과2023-01-014
5대구광역시 달서구2017-01-0418:50유천동 543 부근주차관리과2023-01-013
6대구광역시 달서구2017-01-0516:19대곡동 비슬로 부근주차관리과2023-01-013