Overview

Dataset statistics

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

Variable types

Categorical2
DateTime3
Text1

Dataset

Description대구광역시 북구 관내 불법주정차 단속에 따른 데이터 기준일자까지의 위반 정보를(위반일자, 위반시간, 위반장소 등) 제공합니다
Author대구광역시 북구
URLhttps://www.data.go.kr/data/15037708/fileData.do

Alerts

구분 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 222 (2.2%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-16 15:41:13.104401
Analysis finished2023-12-16 15:41:17.194843
Duration4.09 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 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-16T15:41:17.627196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:41:18.044338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
불법주정차 10000
100.0%

위반일자
Date

Distinct332
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:00:00
Maximum2023-11-29 00:00:00
2023-12-16T15:41:19.121000image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:41:20.097578image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반시간
Date

Distinct1045
Distinct (%)10.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-16 00:01:00
Maximum2023-12-16 23:59:00
2023-12-16T15:41:20.807492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:41:21.614747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소
Text

Distinct2221
Distinct (%)22.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-16T15:41:22.549659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length17
Mean length12.348
Min length3

Characters and Unicode

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

Unique

Unique1249 ?
Unique (%)12.5%

Sample

1st row동천동 962-1 부근 모퉁이
2nd row산격동 1636 부근
3rd row관음동 관음중앙로 110 부근
4th row산격동 1643 부근 횡단보도
5th row북부초등학교
ValueCountFrequency (%)
부근 6261
 
21.6%
횡단보도 1194
 
4.1%
동천동 984
 
3.4%
산격동 664
 
2.3%
모퉁이 619
 
2.1%
앞 600
 
2.1%
태전동 551
 
1.9%
침산동 547
 
1.9%
복현동 438
 
1.5%
구암동 355
 
1.2%
Other values (1867) 16822
57.9%
2023-12-16T15:41:24.364352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
19036
 
15.4%
동 9309
 
7.5%
부 6475
 
5.2%
근 6297
 
5.1%
1 5382
 
4.4%
2 3415
 
2.8%
- 3221
 
2.6%
3 2783
 
2.3%
로 2364
 
1.9%
4 2095
 
1.7%
Other values (223) 63103
51.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 76716
62.1%
Decimal Number 23736
 
19.2%
Space Separator 19036
 
15.4%
Dash Punctuation 3221
 
2.6%
Uppercase Letter 393
 
0.3%
Open Punctuation 249
 
0.2%
Close Punctuation 106
 
0.1%
Lowercase Letter 12
 
< 0.1%
Other Punctuation 11
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 9309
 
12.1%
부 6475
 
8.4%
근 6297
 
8.2%
로 2364
 
3.1%
산 2042
 
2.7%
천 1751
 
2.3%
도 1491
 
1.9%
성 1388
 
1.8%
단 1354
 
1.8%
보 1348
 
1.8%
Other values (197) 42897
55.9%
Decimal Number
ValueCountFrequency (%)
1 5382
22.7%
2 3415
14.4%
3 2783
11.7%
4 2095
 
8.8%
9 1876
 
7.9%
0 1698
 
7.2%
7 1678
 
7.1%
8 1609
 
6.8%
5 1609
 
6.8%
6 1591
 
6.7%
Uppercase Letter
ValueCountFrequency (%)
C 99
25.2%
N 99
25.2%
K 52
13.2%
B 52
13.2%
H 34
 
8.7%
L 34
 
8.7%
M 23
 
5.9%
Lowercase Letter
ValueCountFrequency (%)
e 9
75.0%
c 1
 
8.3%
g 1
 
8.3%
v 1
 
8.3%
Space Separator
ValueCountFrequency (%)
19036
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3221
100.0%
Open Punctuation
ValueCountFrequency (%)
( 249
100.0%
Close Punctuation
ValueCountFrequency (%)
) 106
100.0%
Other Punctuation
ValueCountFrequency (%)
& 11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 76716
62.1%
Common 46359
37.5%
Latin 405
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 9309
 
12.1%
부 6475
 
8.4%
근 6297
 
8.2%
로 2364
 
3.1%
산 2042
 
2.7%
천 1751
 
2.3%
도 1491
 
1.9%
성 1388
 
1.8%
단 1354
 
1.8%
보 1348
 
1.8%
Other values (197) 42897
55.9%
Common
ValueCountFrequency (%)
19036
41.1%
1 5382
 
11.6%
2 3415
 
7.4%
- 3221
 
6.9%
3 2783
 
6.0%
4 2095
 
4.5%
9 1876
 
4.0%
0 1698
 
3.7%
7 1678
 
3.6%
8 1609
 
3.5%
Other values (5) 3566
 
7.7%
Latin
ValueCountFrequency (%)
C 99
24.4%
N 99
24.4%
K 52
12.8%
B 52
12.8%
H 34
 
8.4%
L 34
 
8.4%
M 23
 
5.7%
e 9
 
2.2%
c 1
 
0.2%
g 1
 
0.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 76716
62.1%
ASCII 46764
37.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
19036
40.7%
1 5382
 
11.5%
2 3415
 
7.3%
- 3221
 
6.9%
3 2783
 
6.0%
4 2095
 
4.5%
9 1876
 
4.0%
0 1698
 
3.6%
7 1678
 
3.6%
8 1609
 
3.4%
Other values (16) 3971
 
8.5%
Hangul
ValueCountFrequency (%)
동 9309
 
12.1%
부 6475
 
8.4%
근 6297
 
8.2%
로 2364
 
3.1%
산 2042
 
2.7%
천 1751
 
2.3%
도 1491
 
1.9%
성 1388
 
1.8%
단 1354
 
1.8%
보 1348
 
1.8%
Other values (197) 42897
55.9%

과태료부과일자
Date

Distinct332
Distinct (%)3.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-02 00:00:00
Maximum2023-11-30 00:00:00
2023-12-16T15:41:25.002136image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-16T15:41:25.670644image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

데이터기준일자
Categorical

CONSTANT 

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

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-30
2nd row2023-11-30
3rd row2023-11-30
4th row2023-11-30
5th row2023-11-30

Common Values

ValueCountFrequency (%)
2023-11-30 10000
100.0%

Length

2023-12-16T15:41:26.290119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-16T15:41:26.865355image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-30 10000
100.0%

Missing values

2023-12-16T15:41:15.886504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-16T15:41:16.786536image/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

구분위반일자위반시간위반장소과태료부과일자데이터기준일자
39591불법주정차2023-05-1918:36동천동 962-1 부근 모퉁이2023-05-202023-11-30
51464불법주정차2023-06-2811:24산격동 1636 부근2023-06-292023-11-30
37264불법주정차2023-05-1207:58관음동 관음중앙로 110 부근2023-05-132023-11-30
2725불법주정차2023-01-1920:22산격동 1643 부근 횡단보도2023-01-202023-11-30
52998불법주정차2023-07-0315:29북부초등학교2023-07-042023-11-30
17954불법주정차2023-03-1307:52동호동 151-1 부근2023-03-142023-11-30
15141불법주정차2023-03-0415:13사수동 962 부근 횡단보도2023-03-052023-11-30
9560불법주정차2023-02-1518:19동천동 928-1 부근 모퉁이2023-02-162023-11-30
83682불법주정차2023-10-1710:28사수동 977 부근2023-10-182023-11-30
55641불법주정차2023-07-1118:28동천동 903-1 부근 횡단보도2023-07-122023-11-30
구분위반일자위반시간위반장소과태료부과일자데이터기준일자
94442불법주정차2023-11-1813:44웨딩메르디앙 앞2023-11-192023-11-30
82081불법주정차2023-10-1215:01관음동 칠곡중앙대로 419 부근2023-10-132023-11-30
69578불법주정차2023-08-2816:33남다른 감자탕2023-08-292023-11-30
74635불법주정차2023-09-1215:16동천동 971-1 부근2023-09-132023-11-30
39231불법주정차2023-05-1814:23침산동 옥산로 65 부근2023-05-192023-11-30
9562불법주정차2023-02-1516:30고성동3가 147 부근 소화전2023-02-162023-11-30
42926불법주정차2023-05-3107:30침산동 134-6 부근 소화전2023-06-012023-11-30
78018불법주정차2023-09-2215:18산격동 1428-12 부근 모퉁이2023-09-232023-11-30
35352불법주정차2023-05-0515:48동천동 898-1 부근 모퉁이2023-05-062023-11-30
69618불법주정차2023-08-2815:56관음동 관음동로 12 부근2023-08-292023-11-30

Duplicate rows

Most frequently occurring

구분위반일자위반시간위반장소과태료부과일자데이터기준일자# duplicates
24불법주정차2023-02-2010:51고성동1가 113-20 부근2023-02-212023-11-303
28불법주정차2023-02-2315:22산격동 대동로1길 40 부근2023-02-242023-11-303
35불법주정차2023-03-0511:33국우동 486 부근2023-03-062023-11-303
56불법주정차2023-03-2310:37태전동 209-20 부근2023-03-242023-11-303
88불법주정차2023-05-1214:36구암동 837 부근2023-05-132023-11-303
121불법주정차2023-06-2207:20고성동 104-21 부근2023-06-232023-11-303
143불법주정차2023-07-3115:00동천동 팔거천동로 226 부근2023-08-012023-11-303
157불법주정차2023-08-3014:25고성동 104-21 부근2023-08-312023-11-303
169불법주정차2023-09-2014:35연경동 동화천로 부근2023-09-212023-11-303
193불법주정차2023-10-2616:07침산동 침산로 205 부근2023-10-272023-11-303