Overview

Dataset statistics

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

Variable types

Categorical3
DateTime2
Text1

Dataset

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

Alerts

단속기관 has constant value ""Constant
소관부서 has constant value ""Constant
기준일자 has constant value ""Constant
Dataset has 220 (2.2%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-10 18:58:17.370173
Analysis finished2023-12-10 18:58:18.154068
Duration0.78 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

단속기관
Categorical

CONSTANT 

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-12-11T03:58:18.562524image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T03:58:18.698281image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
대구광역시 10000
50.0%
달서구 10000
50.0%

위반일자
Date

Distinct329
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2020-01-01 00:00:00
Maximum2020-11-26 00:00:00
2023-12-11T03:58:18.848159image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T03:58:19.037297image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반시간
Date

Distinct986
Distinct (%)9.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-11 00:01:00
Maximum2023-12-11 23:59:00
2023-12-11T03:58:19.228595image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T03:58:19.429034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소명
Text

Distinct2014
Distinct (%)20.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T03:58:19.725552image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length18
Mean length11.472
Min length4

Characters and Unicode

Total characters114720
Distinct characters264
Distinct categories6 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1191 ?
Unique (%)11.9%

Sample

1st row대곡동 1140 부근
2nd row농협하나로마트성서점
3rd row이곡동 이곡동로 17 부근
4th row최정유치원
5th row진천계룡리슈빌APT삼거리
ValueCountFrequency (%)
부근 4267
 
16.2%
용산동 906
 
3.4%
부 732
 
2.8%
횡단보도 660
 
2.5%
이곡동 578
 
2.2%
상인동 479
 
1.8%
달구벌대로 461
 
1.8%
월성동 455
 
1.7%
감삼동 415
 
1.6%
인도 410
 
1.6%
Other values (1428) 16958
64.4%
2023-12-11T03:58:20.245497image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
16429
 
14.3%
부 7302
 
6.4%
근 6510
 
5.7%
동 6439
 
5.6%
1 4145
 
3.6%
로 4104
 
3.6%
3 2466
 
2.1%
2 2122
 
1.8%
월 1944
 
1.7%
산 1899
 
1.7%
Other values (254) 61360
53.5%

Most occurring categories

ValueCountFrequency (%)
Other Letter 78861
68.7%
Decimal Number 17731
 
15.5%
Space Separator 16429
 
14.3%
Dash Punctuation 1079
 
0.9%
Uppercase Letter 616
 
0.5%
Lowercase Letter 4
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 7302
 
9.3%
근 6510
 
8.3%
동 6439
 
8.2%
로 4104
 
5.2%
월 1944
 
2.5%
산 1899
 
2.4%
성 1777
 
2.3%
장 1676
 
2.1%
대 1641
 
2.1%
리 1424
 
1.8%
Other values (230) 44145
56.0%
Decimal Number
ValueCountFrequency (%)
1 4145
23.4%
3 2466
13.9%
2 2122
12.0%
5 1678
9.5%
0 1495
 
8.4%
7 1333
 
7.5%
4 1320
 
7.4%
9 1208
 
6.8%
6 1005
 
5.7%
8 959
 
5.4%
Uppercase Letter
ValueCountFrequency (%)
E 240
39.0%
A 120
19.5%
P 112
18.2%
T 112
18.2%
K 8
 
1.3%
M 6
 
1.0%
N 6
 
1.0%
H 6
 
1.0%
G 6
 
1.0%
Lowercase Letter
ValueCountFrequency (%)
c 2
50.0%
k 1
25.0%
w 1
25.0%
Space Separator
ValueCountFrequency (%)
16429
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1079
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 78861
68.7%
Common 35239
30.7%
Latin 620
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 7302
 
9.3%
근 6510
 
8.3%
동 6439
 
8.2%
로 4104
 
5.2%
월 1944
 
2.5%
산 1899
 
2.4%
성 1777
 
2.3%
장 1676
 
2.1%
대 1641
 
2.1%
리 1424
 
1.8%
Other values (230) 44145
56.0%
Common
ValueCountFrequency (%)
16429
46.6%
1 4145
 
11.8%
3 2466
 
7.0%
2 2122
 
6.0%
5 1678
 
4.8%
0 1495
 
4.2%
7 1333
 
3.8%
4 1320
 
3.7%
9 1208
 
3.4%
- 1079
 
3.1%
Other values (2) 1964
 
5.6%
Latin
ValueCountFrequency (%)
E 240
38.7%
A 120
19.4%
P 112
18.1%
T 112
18.1%
K 8
 
1.3%
M 6
 
1.0%
N 6
 
1.0%
H 6
 
1.0%
G 6
 
1.0%
c 2
 
0.3%
Other values (2) 2
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 78861
68.7%
ASCII 35859
31.3%

Most frequent character per block

ASCII
ValueCountFrequency (%)
16429
45.8%
1 4145
 
11.6%
3 2466
 
6.9%
2 2122
 
5.9%
5 1678
 
4.7%
0 1495
 
4.2%
7 1333
 
3.7%
4 1320
 
3.7%
9 1208
 
3.4%
- 1079
 
3.0%
Other values (14) 2584
 
7.2%
Hangul
ValueCountFrequency (%)
부 7302
 
9.3%
근 6510
 
8.3%
동 6439
 
8.2%
로 4104
 
5.2%
월 1944
 
2.5%
산 1899
 
2.4%
성 1777
 
2.3%
장 1676
 
2.1%
대 1641
 
2.1%
리 1424
 
1.8%
Other values (230) 44145
56.0%

소관부서
Categorical

CONSTANT 

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-12-11T03:58:20.426420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T03:58:20.548136image/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
2021-01-25
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2021-01-25
2nd row2021-01-25
3rd row2021-01-25
4th row2021-01-25
5th row2021-01-25

Common Values

ValueCountFrequency (%)
2021-01-25 10000
100.0%

Length

2023-12-11T03:58:20.708172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T03:58:20.843999image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2021-01-25 10000
100.0%

Missing values

2023-12-11T03:58:17.924053image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T03:58:18.090397image/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

단속기관위반일자위반시간위반장소명소관부서기준일자
80904대구광역시 달서구2020-10-0816:18대곡동 1140 부근주차관리과2021-01-25
7073대구광역시 달서구2020-01-1809:51농협하나로마트성서점주차관리과2021-01-25
85798대구광역시 달서구2020-10-2114:57이곡동 이곡동로 17 부근주차관리과2021-01-25
18503대구광역시 달서구2020-02-1808:47최정유치원주차관리과2021-01-25
8679대구광역시 달서구2020-01-2214:01진천계룡리슈빌APT삼거리주차관리과2021-01-25
32010대구광역시 달서구2020-06-0419:32신당동 달구벌대로 1095주차관리과2021-01-25
58973대구광역시 달서구2020-08-0610:26본리동우체국 부근주차관리과2021-01-25
43688대구광역시 달서구2020-06-3011:00감삼동 달구벌대로 1542주차관리과2021-01-25
73022대구광역시 달서구2020-09-1315:18용산동 972 부근 횡단보도주차관리과2021-01-25
93819대구광역시 달서구2020-11-1120:13이곡동 1219 부근 횡단보도주차관리과2021-01-25
단속기관위반일자위반시간위반장소명소관부서기준일자
68804대구광역시 달서구2020-09-0215:59이곡동 1247 부근 횡단보도주차관리과2021-01-25
37895대구광역시 달서구2020-06-1714:10진천동 545-2 부근 횡단보도주차관리과2021-01-25
38740대구광역시 달서구2020-06-1810:31죽전네거리부근주차관리과2021-01-25
84789대구광역시 달서구2020-10-1915:29한솔초등학교부근주차관리과2021-01-25
79165대구광역시 달서구2020-09-2817:13신당동 달구벌대로 1095주차관리과2021-01-25
34264대구광역시 달서구2020-06-0919:41와룡초등학교부근주차관리과2021-01-25
2899대구광역시 달서구2020-01-0818:41성서경찰서부근주차관리과2021-01-25
13423대구광역시 달서구2020-02-0615:05상인동 월곡로45길 49 부주차관리과2021-01-25
94787대구광역시 달서구2020-11-1216:15광장코아건너편주차관리과2021-01-25
55665대구광역시 달서구2020-07-2916:34서남시장부근주차관리과2021-01-25

Duplicate rows

Most frequently occurring

단속기관위반일자위반시간위반장소명소관부서기준일자# duplicates
203대구광역시 달서구2020-11-0813:56장기동 한들로 55 부근주차관리과2021-01-255
56대구광역시 달서구2020-05-2016:33본리동 장기로 189 부근주차관리과2021-01-253
107대구광역시 달서구2020-07-0315:49신당동 신당로 55 부근주차관리과2021-01-253
119대구광역시 달서구2020-07-0919:23신당동 달구벌대로 1095주차관리과2021-01-253
136대구광역시 달서구2020-08-1016:01월성동 조암로 9 부근주차관리과2021-01-253
158대구광역시 달서구2020-09-0810:22본리동 대명천로 153 부주차관리과2021-01-253
188대구광역시 달서구2020-10-2314:25용산동 달구벌대로291길주차관리과2021-01-253
202대구광역시 달서구2020-11-0615:30이곡동 달구벌대로251길주차관리과2021-01-253
0대구광역시 달서구2020-01-0715:58월성동 조암로6길 20 부주차관리과2021-01-252
1대구광역시 달서구2020-01-0716:49상인동 상인서로 10 부근주차관리과2021-01-252