Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows266
Duplicate rows (%)2.7%
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/15037876/fileData.do

Alerts

해당구 has constant value ""Constant
부서명 has constant value ""Constant
기준일자 has constant value ""Constant
Dataset has 266 (2.7%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 02:27:41.361582
Analysis finished2023-12-12 02:27:42.057853
Duration0.7 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-12T11:27:42.201370image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

위반일자
Date

Distinct324
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:00:00
Maximum2023-11-20 00:00:00
2023-12-12T11:27:42.478945image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:27:42.655878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반시간
Date

Distinct1135
Distinct (%)11.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-12 00:00:00
Maximum2023-12-12 23:59:00
2023-12-12T11:27:42.854311image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:27:43.015982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소명
Text

Distinct2077
Distinct (%)20.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T11:27:43.310751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length20
Mean length12.0051
Min length4

Characters and Unicode

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

Unique

Unique1246 ?
Unique (%)12.5%

Sample

1st row성서경찰서부근
2nd row두류동 두류남1길
3rd row감삼동 314-30 부근 횡단보도
4th row감삼동 360-3
5th row성서경찰서부근
ValueCountFrequency (%)
부근 5552
 
20.2%
횡단보도 1183
 
4.3%
용산동 839
 
3.1%
이곡동 791
 
2.9%
인도 632
 
2.3%
감삼동 611
 
2.2%
월성동 523
 
1.9%
부 435
 
1.6%
두류동 430
 
1.6%
상인동 426
 
1.5%
Other values (1665) 16078
58.5%
2023-12-12T11:27:43.820467image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
17507
 
14.6%
부 8279
 
6.9%
근 7722
 
6.4%
동 7186
 
6.0%
1 5624
 
4.7%
- 2898
 
2.4%
2 2793
 
2.3%
로 2469
 
2.1%
3 2444
 
2.0%
도 2376
 
2.0%
Other values (228) 60753
50.6%

Most occurring categories

ValueCountFrequency (%)
Other Letter 75412
62.8%
Decimal Number 23940
 
19.9%
Space Separator 17507
 
14.6%
Dash Punctuation 2898
 
2.4%
Uppercase Letter 289
 
0.2%
Close Punctuation 2
 
< 0.1%
Open Punctuation 2
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 8279
 
11.0%
근 7722
 
10.2%
동 7186
 
9.5%
로 2469
 
3.3%
도 2376
 
3.2%
이 1739
 
2.3%
성 1552
 
2.1%
산 1546
 
2.1%
월 1460
 
1.9%
인 1256
 
1.7%
Other values (205) 39827
52.8%
Decimal Number
ValueCountFrequency (%)
1 5624
23.5%
2 2793
11.7%
3 2444
10.2%
5 2196
 
9.2%
0 2148
 
9.0%
4 2061
 
8.6%
8 1780
 
7.4%
6 1773
 
7.4%
7 1599
 
6.7%
9 1522
 
6.4%
Uppercase Letter
ValueCountFrequency (%)
E 262
90.7%
G 5
 
1.7%
V 5
 
1.7%
C 5
 
1.7%
H 5
 
1.7%
N 5
 
1.7%
K 1
 
0.3%
A 1
 
0.3%
Space Separator
ValueCountFrequency (%)
17507
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2898
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%
Math Symbol
ValueCountFrequency (%)
× 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 75412
62.8%
Common 44350
36.9%
Latin 289
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 8279
 
11.0%
근 7722
 
10.2%
동 7186
 
9.5%
로 2469
 
3.3%
도 2376
 
3.2%
이 1739
 
2.3%
성 1552
 
2.1%
산 1546
 
2.1%
월 1460
 
1.9%
인 1256
 
1.7%
Other values (205) 39827
52.8%
Common
ValueCountFrequency (%)
17507
39.5%
1 5624
 
12.7%
- 2898
 
6.5%
2 2793
 
6.3%
3 2444
 
5.5%
5 2196
 
5.0%
0 2148
 
4.8%
4 2061
 
4.6%
8 1780
 
4.0%
6 1773
 
4.0%
Other values (5) 3126
 
7.0%
Latin
ValueCountFrequency (%)
E 262
90.7%
G 5
 
1.7%
V 5
 
1.7%
C 5
 
1.7%
H 5
 
1.7%
N 5
 
1.7%
K 1
 
0.3%
A 1
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 75412
62.8%
ASCII 44638
37.2%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
17507
39.2%
1 5624
 
12.6%
- 2898
 
6.5%
2 2793
 
6.3%
3 2444
 
5.5%
5 2196
 
4.9%
0 2148
 
4.8%
4 2061
 
4.6%
8 1780
 
4.0%
6 1773
 
4.0%
Other values (12) 3414
 
7.6%
Hangul
ValueCountFrequency (%)
부 8279
 
11.0%
근 7722
 
10.2%
동 7186
 
9.5%
로 2469
 
3.3%
도 2376
 
3.2%
이 1739
 
2.3%
성 1552
 
2.1%
산 1546
 
2.1%
월 1460
 
1.9%
인 1256
 
1.7%
Other values (205) 39827
52.8%
None
ValueCountFrequency (%)
× 1
100.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-12T11:27:44.003111image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T11:27:44.126641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
주차관리과 10000
100.0%

기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-11-30 00:00:00
Maximum2023-11-30 00:00:00
2023-12-12T11:27:44.248308image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T11:27:44.396045image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Missing values

2023-12-12T11:27:41.826289image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T11:27:41.981030image/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

해당구위반일자위반시간위반장소명부서명기준일자
21997대구광역시 달서구2023-03-1315:12성서경찰서부근주차관리과2023-11-30
45786대구광역시 달서구2023-06-0117:14두류동 두류남1길주차관리과2023-11-30
61259대구광역시 달서구2023-07-2321:36감삼동 314-30 부근 횡단보도주차관리과2023-11-30
31199대구광역시 달서구2023-04-1116:47감삼동 360-3주차관리과2023-11-30
64546대구광역시 달서구2023-08-0116:43성서경찰서부근주차관리과2023-11-30
74393대구광역시 달서구2023-08-3011:41송현동 프라임마트부근주차관리과2023-11-30
99879대구광역시 달서구2023-11-2009:41진천계룡리슈빌부근주차관리과2023-11-30
48801대구광역시 달서구2023-06-1217:35성당레미안네거리주차관리과2023-11-30
5940대구광역시 달서구2023-01-1914:37장기동 1-15 부근주차관리과2023-11-30
47183대구광역시 달서구2023-06-0714:45내당동 달구벌대로 1827주차관리과2023-11-30
해당구위반일자위반시간위반장소명부서명기준일자
29001대구광역시 달서구2023-04-0409:42본동 1150-33 부근주차관리과2023-11-30
96345대구광역시 달서구2023-11-0815:12이곡동 달구벌대로251안주차관리과2023-11-30
32218대구광역시 달서구2023-04-1410:31용산동 494 부근주차관리과2023-11-30
53158대구광역시 달서구2023-06-2714:19유천동 월배로 51 부근주차관리과2023-11-30
4793대구광역시 달서구2023-01-1615:16국민은행성서지점부근주차관리과2023-11-30
26731대구광역시 달서구2023-03-2716:44시온교회부근주차관리과2023-11-30
94590대구광역시 달서구2023-11-0307:30이곡동 890-13 부근 인도주차관리과2023-11-30
75492대구광역시 달서구2023-09-0216:46월배E마트부근주차관리과2023-11-30
75173대구광역시 달서구2023-09-0115:09용산동 산 37 부근주차관리과2023-11-30
46363대구광역시 달서구2023-06-0416:09용산동 230-32 부근 인도주차관리과2023-11-30

Duplicate rows

Most frequently occurring

해당구위반일자위반시간위반장소명부서명기준일자# duplicates
162대구광역시 달서구2023-08-0215:14용산동 958 부근주차관리과2023-11-304
193대구광역시 달서구2023-09-0116:52월성동 1861 부근주차관리과2023-11-304
17대구광역시 달서구2023-01-1214:37대곡동 1041 부근주차관리과2023-11-303
65대구광역시 달서구2023-03-1509:56감삼동 와룡로 169 부근주차관리과2023-11-303
69대구광역시 달서구2023-03-1814:01두류동 495-48 부근 인도주차관리과2023-11-303
85대구광역시 달서구2023-04-0615:08용산동 958-32 부근주차관리과2023-11-303
100대구광역시 달서구2023-04-2016:33대곡동 19-2 부근주차관리과2023-11-303
107대구광역시 달서구2023-05-1715:01도원동 도원로 45 부근주차관리과2023-11-303
128대구광역시 달서구2023-06-1315:06이곡동 이곡동로 32 부근주차관리과2023-11-303
138대구광역시 달서구2023-06-2315:13이곡동 달구벌대로251안주차관리과2023-11-303