Overview

Dataset statistics

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

Variable types

Categorical3
DateTime2
Text1

Dataset

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

Alerts

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

Reproduction

Analysis started2023-12-10 19:10:58.115194
Analysis finished2023-12-10 19:10:58.957212
Duration0.84 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-11T04:10:59.063886image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

위반일자
Date

Distinct288
Distinct (%)2.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-01-02 00:00:00
Maximum2017-11-05 00:00:00
2023-12-11T04:10:59.470755image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T04:10:59.739364image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반시간
Date

Distinct765
Distinct (%)7.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-11 06:30:00
Maximum2023-12-11 23:27:00
2023-12-11T04:10:59.969186image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T04:11:00.207696image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소명
Text

Distinct833
Distinct (%)8.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T04:11:00.600061image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length14
Mean length9.0708
Min length4

Characters and Unicode

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

Unique

Unique409 ?
Unique (%)4.1%

Sample

1st row조달청부근
2nd row월배새마을금고월성지점
3rd row성서우체국부근
4th row원더풀스파랜드
5th row계대농협부근
ValueCountFrequency (%)
부근 3639
 
19.6%
상인동 541
 
2.9%
대우월드마크부근 453
 
2.4%
이곡동 446
 
2.4%
두류동 437
 
2.4%
월배새마을금고월성지점 417
 
2.2%
본리동 390
 
2.1%
감삼동 389
 
2.1%
월성동 364
 
2.0%
진천동 352
 
1.9%
Other values (740) 11157
60.0%
2023-12-11T04:11:01.267345image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
8850
 
9.8%
동 5730
 
6.3%
부 5597
 
6.2%
근 5427
 
6.0%
로 3907
 
4.3%
월 3104
 
3.4%
성 2287
 
2.5%
대 1944
 
2.1%
리 1521
 
1.7%
상 1413
 
1.6%
Other values (388) 50928
56.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 77987
86.0%
Space Separator 8850
 
9.8%
Decimal Number 1964
 
2.2%
Uppercase Letter 1659
 
1.8%
Dash Punctuation 108
 
0.1%
Close Punctuation 56
 
0.1%
Open Punctuation 56
 
0.1%
Lowercase Letter 28
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 5730
 
7.3%
부 5597
 
7.2%
근 5427
 
7.0%
로 3907
 
5.0%
월 3104
 
4.0%
성 2287
 
2.9%
대 1944
 
2.5%
리 1521
 
2.0%
상 1413
 
1.8%
마 1359
 
1.7%
Other values (349) 45698
58.6%
Uppercase Letter
ValueCountFrequency (%)
E 367
22.1%
G 333
20.1%
C 333
20.1%
V 329
19.8%
A 122
 
7.4%
K 101
 
6.1%
T 26
 
1.6%
P 25
 
1.5%
L 4
 
0.2%
N 4
 
0.2%
Other values (8) 15
 
0.9%
Decimal Number
ValueCountFrequency (%)
3 534
27.2%
1 368
18.7%
4 263
13.4%
2 237
12.1%
9 205
 
10.4%
5 113
 
5.8%
8 94
 
4.8%
7 57
 
2.9%
0 53
 
2.7%
6 40
 
2.0%
Lowercase Letter
ValueCountFrequency (%)
i 11
39.3%
c 10
35.7%
e 3
 
10.7%
t 1
 
3.6%
l 1
 
3.6%
m 1
 
3.6%
f 1
 
3.6%
Space Separator
ValueCountFrequency (%)
8850
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 108
100.0%
Close Punctuation
ValueCountFrequency (%)
) 56
100.0%
Open Punctuation
ValueCountFrequency (%)
( 56
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 77987
86.0%
Common 11034
 
12.2%
Latin 1687
 
1.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 5730
 
7.3%
부 5597
 
7.2%
근 5427
 
7.0%
로 3907
 
5.0%
월 3104
 
4.0%
성 2287
 
2.9%
대 1944
 
2.5%
리 1521
 
2.0%
상 1413
 
1.8%
마 1359
 
1.7%
Other values (349) 45698
58.6%
Latin
ValueCountFrequency (%)
E 367
21.8%
G 333
19.7%
C 333
19.7%
V 329
19.5%
A 122
 
7.2%
K 101
 
6.0%
T 26
 
1.5%
P 25
 
1.5%
i 11
 
0.7%
c 10
 
0.6%
Other values (15) 30
 
1.8%
Common
ValueCountFrequency (%)
8850
80.2%
3 534
 
4.8%
1 368
 
3.3%
4 263
 
2.4%
2 237
 
2.1%
9 205
 
1.9%
5 113
 
1.0%
- 108
 
1.0%
8 94
 
0.9%
7 57
 
0.5%
Other values (4) 205
 
1.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 77987
86.0%
ASCII 12721
 
14.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
8850
69.6%
3 534
 
4.2%
1 368
 
2.9%
E 367
 
2.9%
G 333
 
2.6%
C 333
 
2.6%
V 329
 
2.6%
4 263
 
2.1%
2 237
 
1.9%
9 205
 
1.6%
Other values (29) 902
 
7.1%
Hangul
ValueCountFrequency (%)
동 5730
 
7.3%
부 5597
 
7.2%
근 5427
 
7.0%
로 3907
 
5.0%
월 3104
 
4.0%
성 2287
 
2.9%
대 1944
 
2.5%
리 1521
 
2.0%
상 1413
 
1.8%
마 1359
 
1.7%
Other values (349) 45698
58.6%

소관부서
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-11T04:11:01.494418image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T04:11:01.662038image/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
2022-07-07
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-07-07
2nd row2022-07-07
3rd row2022-07-07
4th row2022-07-07
5th row2022-07-07

Common Values

ValueCountFrequency (%)
2022-07-07 10000
100.0%

Length

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

Common Values (Plot)

2023-12-11T04:11:01.978744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-07-07 10000
100.0%

Missing values

2023-12-11T04:10:58.677174image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T04:10:58.869451image/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

단속기관위반일자위반시간위반장소명소관부서기준일자
55842대구광역시 달서구2017-06-3014:07조달청부근주차관리과2022-07-07
81411대구광역시 달서구2017-09-1315:56월배새마을금고월성지점주차관리과2022-07-07
79038대구광역시 달서구2017-09-0617:07성서우체국부근주차관리과2022-07-07
60532대구광역시 달서구2017-07-1410:46원더풀스파랜드주차관리과2022-07-07
88729대구광역시 달서구2017-10-1714:17계대농협부근주차관리과2022-07-07
70443대구광역시 달서구2017-08-1110:37장기동 한국통신주차관리과2022-07-07
41270대구광역시 달서구2017-05-1014:49블랙야크두류점주차관리과2022-07-07
33328대구광역시 달서구2017-04-1214:11성서E마트부근주차관리과2022-07-07
29531대구광역시 달서구2017-03-3011:14성서E마트부근주차관리과2022-07-07
11102대구광역시 달서구2017-02-0616:22월성동 조암로 부근주차관리과2022-07-07
단속기관위반일자위반시간위반장소명소관부서기준일자
40482대구광역시 달서구2017-05-0811:05상인동 월배로 부근주차관리과2022-07-07
21650대구광역시 달서구2017-03-0715:49도원동 한실로 부근주차관리과2022-07-07
61802대구광역시 달서구2017-07-1818:36본리동우체국주차관리과2022-07-07
72277대구광역시 달서구2017-08-1719:02본리동우체국주차관리과2022-07-07
5947대구광역시 달서구2017-01-1916:13도원동 한실로 부근주차관리과2022-07-07
25551대구광역시 달서구2017-03-1710:44홈플러스성서점뒤편주차관리과2022-07-07
21029대구광역시 달서구2017-03-0513:38용산동 달구벌대로 부근주차관리과2022-07-07
50909대구광역시 달서구2017-06-1409:54월성협성휴포레앞주차관리과2022-07-07
90484대구광역시 달서구2017-10-2217:22월성CGV주차관리과2022-07-07
10975대구광역시 달서구2017-02-0614:20성당동 대명천로 부근주차관리과2022-07-07

Duplicate rows

Most frequently occurring

단속기관위반일자위반시간위반장소명소관부서기준일자# duplicates
1대구광역시 달서구2017-01-0216:27월성동 조암로 부근주차관리과2022-07-074
27대구광역시 달서구2017-01-1715:47상인동 상화로 부근주차관리과2022-07-074
31대구광역시 달서구2017-01-1916:13도원동 한실로 부근주차관리과2022-07-074
71대구광역시 달서구2017-02-1014:41감삼동 장기로 부근주차관리과2022-07-074
99대구광역시 달서구2017-03-0113:22용산동 달구벌대로 부근주차관리과2022-07-074
116대구광역시 달서구2017-03-1307:36이곡동 선원남로 부근주차관리과2022-07-074
154대구광역시 달서구2017-03-3015:20신당동 신당로 부근주차관리과2022-07-074
360대구광역시 달서구2017-11-0114:42두류동 야외음악당로33길주차관리과2022-07-074
3대구광역시 달서구2017-01-0410:01본리동 대명천로 부근주차관리과2022-07-073
4대구광역시 달서구2017-01-0414:51이곡동 이곡서로 부근주차관리과2022-07-073