Overview

Dataset statistics

Number of variables3
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows345
Duplicate rows (%)3.5%
Total size in memory312.5 KiB
Average record size in memory32.0 B

Variable types

DateTime2
Text1

Dataset

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

Alerts

Dataset has 345 (3.5%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-10 17:52:30.817745
Analysis finished2023-12-10 17:52:31.951563
Duration1.13 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

위반일자
Date

Distinct691
Distinct (%)6.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-01-05 00:00:00
Maximum2017-07-28 00:00:00
2023-12-11T02:52:32.124275image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:52:32.541624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반시간
Date

Distinct747
Distinct (%)7.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-11 04:40:00
Maximum2023-12-11 22:50:00
2023-12-11T02:52:32.899685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T02:52:33.194732image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소명
Text

Distinct655
Distinct (%)6.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T02:52:33.813162image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length9.1609
Min length3

Characters and Unicode

Total characters91609
Distinct characters344
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

Unique357 ?
Unique (%)3.6%

Sample

1st row평리1동주민센터
2nd row서구청건너
3rd row내당동 서대구로 부근
4th row평리동 국채보상로 부근
5th row중리동 평리로 부근
ValueCountFrequency (%)
부근 3765
17.5%
내당동 2243
 
10.4%
평리동 1813
 
8.4%
비산동 1774
 
8.3%
서대구로 888
 
4.1%
북비산로 835
 
3.9%
국채보상로 795
 
3.7%
문화로 680
 
3.2%
달구벌대로 626
 
2.9%
이현동 548
 
2.5%
Other values (553) 7526
35.0%
2023-12-11T02:52:34.772495image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11493
 
12.5%
동 7552
 
8.2%
로 7298
 
8.0%
부 4867
 
5.3%
근 4253
 
4.6%
리 3864
 
4.2%
평 3223
 
3.5%
구 3034
 
3.3%
산 2913
 
3.2%
비 2827
 
3.1%
Other values (334) 40285
44.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 77976
85.1%
Space Separator 11493
 
12.5%
Decimal Number 2021
 
2.2%
Uppercase Letter 64
 
0.1%
Dash Punctuation 19
 
< 0.1%
Other Punctuation 16
 
< 0.1%
Close Punctuation 9
 
< 0.1%
Lowercase Letter 9
 
< 0.1%
Open Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 7552
 
9.7%
로 7298
 
9.4%
부 4867
 
6.2%
근 4253
 
5.5%
리 3864
 
5.0%
평 3223
 
4.1%
구 3034
 
3.9%
산 2913
 
3.7%
비 2827
 
3.6%
서 2634
 
3.4%
Other values (302) 35511
45.5%
Decimal Number
ValueCountFrequency (%)
3 752
37.2%
5 324
16.0%
1 251
 
12.4%
7 183
 
9.1%
2 158
 
7.8%
4 153
 
7.6%
9 70
 
3.5%
6 52
 
2.6%
0 48
 
2.4%
8 30
 
1.5%
Uppercase Letter
ValueCountFrequency (%)
C 14
21.9%
S 12
18.8%
U 10
15.6%
I 7
10.9%
L 6
9.4%
O 6
9.4%
K 5
 
7.8%
G 3
 
4.7%
F 1
 
1.6%
Lowercase Letter
ValueCountFrequency (%)
k 2
22.2%
s 2
22.2%
t 1
11.1%
g 1
11.1%
a 1
11.1%
o 1
11.1%
m 1
11.1%
Other Punctuation
ValueCountFrequency (%)
. 9
56.2%
, 7
43.8%
Space Separator
ValueCountFrequency (%)
11493
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 19
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 77976
85.1%
Common 13560
 
14.8%
Latin 73
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 7552
 
9.7%
로 7298
 
9.4%
부 4867
 
6.2%
근 4253
 
5.5%
리 3864
 
5.0%
평 3223
 
4.1%
구 3034
 
3.9%
산 2913
 
3.7%
비 2827
 
3.6%
서 2634
 
3.4%
Other values (302) 35511
45.5%
Common
ValueCountFrequency (%)
11493
84.8%
3 752
 
5.5%
5 324
 
2.4%
1 251
 
1.9%
7 183
 
1.3%
2 158
 
1.2%
4 153
 
1.1%
9 70
 
0.5%
6 52
 
0.4%
0 48
 
0.4%
Other values (6) 76
 
0.6%
Latin
ValueCountFrequency (%)
C 14
19.2%
S 12
16.4%
U 10
13.7%
I 7
9.6%
L 6
8.2%
O 6
8.2%
K 5
 
6.8%
G 3
 
4.1%
k 2
 
2.7%
s 2
 
2.7%
Other values (6) 6
8.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 77976
85.1%
ASCII 13633
 
14.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11493
84.3%
3 752
 
5.5%
5 324
 
2.4%
1 251
 
1.8%
7 183
 
1.3%
2 158
 
1.2%
4 153
 
1.1%
9 70
 
0.5%
6 52
 
0.4%
0 48
 
0.4%
Other values (22) 149
 
1.1%
Hangul
ValueCountFrequency (%)
동 7552
 
9.7%
로 7298
 
9.4%
부 4867
 
6.2%
근 4253
 
5.5%
리 3864
 
5.0%
평 3223
 
4.1%
구 3034
 
3.9%
산 2913
 
3.7%
비 2827
 
3.6%
서 2634
 
3.4%
Other values (302) 35511
45.5%

Missing values

2023-12-11T02:52:31.674603image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T02:52:31.871784image/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

위반일자위반시간위반장소명
226662015-09-1614:37평리1동주민센터
139202015-05-2614:53서구청건너
701962017-02-0814:53내당동 서대구로 부근
866182017-05-2916:03평리동 국채보상로 부근
907332017-06-2710:25중리동 평리로 부근
574092016-10-2007:38내당동 평리로 부근
500732016-08-0319:23대평중학교부근
746332017-03-1408:12내당동 달구벌대로 부근
852772017-05-2208:20대성초등학교
772062017-03-2819:03평리동 북비산로 부근
위반일자위반시간위반장소명
692372017-01-3114:40내당동 달구벌대로 부근
281902015-11-2519:03원대동3가 팔달로
674472017-01-1114:41중리동 평리로 부근
128272015-05-1214:08북부정류장입구
467222016-07-0509:47내당동 국채보상로 부근
524262016-08-2915:00평리지하도
9362015-01-1309:59평리동 문화로
224432015-09-1119:35비산동 서대구로
615702016-11-2320:15중리동 국채보상로34길
401662016-04-2515:07이현초등학교

Duplicate rows

Most frequently occurring

위반일자위반시간위반장소명# duplicates
342015-03-1707:45내당동 평리로4
912015-09-0919:48내당동 평리로4
3342017-06-2316:43이현동 문화로 부근4
242015-02-2507:47내당동 평리로3
512015-05-0614:30이현동 북비산로3
982015-10-1420:05비산동 달서로3
1072015-10-2814:26내당동 서대구로3
1082015-11-0209:51평리동 서대구로3
1162015-11-2619:52비산동 팔달로3
1302016-01-1810:17내당동 서대구로3