Overview

Dataset statistics

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

Variable types

DateTime2
Text1

Dataset

Description대구광역시 서구 불법 주정차 단속 현황입니다. 이 데이터는 불법주정차 단속일, 불법주정차 단속시간, 불법주정차 단속장소를 포함하고 있습니다.
Author대구광역시 서구
URLhttps://www.data.go.kr/data/15062020/fileData.do

Alerts

Dataset has 369 (3.7%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 08:05:21.437825
Analysis finished2023-12-12 08:05:21.926743
Duration0.49 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

위반일자
Date

Distinct679
Distinct (%)6.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2015-01-05 00:00:00
Maximum2017-07-28 00:00:00
2023-12-12T17:05:22.013257image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:05:22.171774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반시간
Date

Distinct737
Distinct (%)7.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-12 04:40:00
Maximum2023-12-12 21:17:00
2023-12-12T17:05:22.334708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T17:05:22.555389image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소명
Text

Distinct665
Distinct (%)6.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T17:05:22.836936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length17
Mean length9.1992
Min length3

Characters and Unicode

Total characters91992
Distinct characters352
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

Unique358 ?
Unique (%)3.6%

Sample

1st row비산동 서대구로 부근
2nd row평리동 북비산로 부근
3rd row내당동 평리로
4th row비산동 달서로 부근
5th row서구 비산7동
ValueCountFrequency (%)
부근 3783
17.6%
내당동 2220
 
10.3%
평리동 1832
 
8.5%
비산동 1713
 
8.0%
서대구로 892
 
4.2%
국채보상로 849
 
4.0%
북비산로 803
 
3.7%
문화로 618
 
2.9%
달구벌대로 609
 
2.8%
평리로 576
 
2.7%
Other values (565) 7583
35.3%
2023-12-12T17:05:23.393901image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11478
 
12.5%
동 7538
 
8.2%
로 7280
 
7.9%
부 4818
 
5.2%
근 4251
 
4.6%
리 4029
 
4.4%
평 3349
 
3.6%
구 3053
 
3.3%
산 2815
 
3.1%
비 2729
 
3.0%
Other values (342) 40652
44.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 78167
85.0%
Space Separator 11478
 
12.5%
Decimal Number 2213
 
2.4%
Uppercase Letter 81
 
0.1%
Lowercase Letter 16
 
< 0.1%
Other Punctuation 14
 
< 0.1%
Dash Punctuation 13
 
< 0.1%
Close Punctuation 9
 
< 0.1%
Open Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 7538
 
9.6%
로 7280
 
9.3%
부 4818
 
6.2%
근 4251
 
5.4%
리 4029
 
5.2%
평 3349
 
4.3%
구 3053
 
3.9%
산 2815
 
3.6%
비 2729
 
3.5%
서 2621
 
3.4%
Other values (306) 35684
45.7%
Uppercase Letter
ValueCountFrequency (%)
C 17
21.0%
S 16
19.8%
U 12
14.8%
K 10
12.3%
I 6
 
7.4%
G 6
 
7.4%
T 4
 
4.9%
O 3
 
3.7%
M 2
 
2.5%
L 2
 
2.5%
Other values (3) 3
 
3.7%
Decimal Number
ValueCountFrequency (%)
3 827
37.4%
5 368
16.6%
1 270
 
12.2%
7 226
 
10.2%
2 160
 
7.2%
4 159
 
7.2%
0 65
 
2.9%
9 55
 
2.5%
8 49
 
2.2%
6 34
 
1.5%
Lowercase Letter
ValueCountFrequency (%)
t 4
25.0%
n 2
12.5%
o 2
12.5%
i 2
12.5%
s 2
12.5%
g 2
12.5%
a 2
12.5%
Other Punctuation
ValueCountFrequency (%)
, 8
57.1%
. 6
42.9%
Space Separator
ValueCountFrequency (%)
11478
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 13
100.0%
Close Punctuation
ValueCountFrequency (%)
) 9
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 78167
85.0%
Common 13728
 
14.9%
Latin 97
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 7538
 
9.6%
로 7280
 
9.3%
부 4818
 
6.2%
근 4251
 
5.4%
리 4029
 
5.2%
평 3349
 
4.3%
구 3053
 
3.9%
산 2815
 
3.6%
비 2729
 
3.5%
서 2621
 
3.4%
Other values (306) 35684
45.7%
Latin
ValueCountFrequency (%)
C 17
17.5%
S 16
16.5%
U 12
12.4%
K 10
10.3%
I 6
 
6.2%
G 6
 
6.2%
T 4
 
4.1%
t 4
 
4.1%
O 3
 
3.1%
M 2
 
2.1%
Other values (10) 17
17.5%
Common
ValueCountFrequency (%)
11478
83.6%
3 827
 
6.0%
5 368
 
2.7%
1 270
 
2.0%
7 226
 
1.6%
2 160
 
1.2%
4 159
 
1.2%
0 65
 
0.5%
9 55
 
0.4%
8 49
 
0.4%
Other values (6) 71
 
0.5%

Most occurring blocks

ValueCountFrequency (%)
Hangul 78167
85.0%
ASCII 13825
 
15.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11478
83.0%
3 827
 
6.0%
5 368
 
2.7%
1 270
 
2.0%
7 226
 
1.6%
2 160
 
1.2%
4 159
 
1.2%
0 65
 
0.5%
9 55
 
0.4%
8 49
 
0.4%
Other values (26) 168
 
1.2%
Hangul
ValueCountFrequency (%)
동 7538
 
9.6%
로 7280
 
9.3%
부 4818
 
6.2%
근 4251
 
5.4%
리 4029
 
5.2%
평 3349
 
4.3%
구 3053
 
3.9%
산 2815
 
3.6%
비 2729
 
3.5%
서 2621
 
3.4%
Other values (306) 35684
45.7%

Missing values

2023-12-12T17:05:21.786160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T17:05:21.879012image/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

위반일자위반시간위반장소명
746682017-03-1410:49비산동 서대구로 부근
739532017-03-0914:28평리동 북비산로 부근
363552016-03-1409:50내당동 평리로
503662016-08-0519:53비산동 달서로 부근
123812015-05-0717:40서구 비산7동
336332016-02-0211:16비산동 달서천로
222472015-09-0919:49내당동 평리로
98622015-04-0910:01서부교육청
946642017-07-2515:33내당동 서대구로 부근
544002016-09-2316:49내당동 달서로 부근
위반일자위반시간위반장소명
554752016-10-0516:42대구서부공업고등학교부
372562016-03-2320:22내당동 달서로
237512015-10-0719:21평리푸르지오입구
928262017-07-1215:58비산동 염색공단중앙로
159672015-06-1715:45대신동 큰장로28길
378912016-03-3114:56달서로 횡단보도
241482015-10-1314:38평리푸르지오입구
193282015-07-3015:55중리동 국채보상로34길
769462017-03-2715:03비산동 북비산로 부근
825002017-05-0111:05비산동 달서천로 부근

Duplicate rows

Most frequently occurring

위반일자위반시간위반장소명# duplicates
1132015-10-1420:05비산동 달서로4
1332015-11-2518:58비산동 서대구로4
1952016-05-1216:28평리동 국채보상로53길4
2652016-11-0110:50내당동 서대구로 부근4
202015-02-0520:04비산동 달서로3
282015-02-2710:42내당동 서대구로3
352015-03-0519:25내당동 평리로3
782015-07-1010:30이현동 북비산로3
902015-08-0314:43내당동 달구벌대로3
1012015-09-1510:43내당동 서대구로3