Overview

Dataset statistics

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

Variable types

Categorical1
DateTime1
Text1

Dataset

Description대전 서구 불법주정차 단속 현황(2023.1.1.~2023.11.30.)- 자치구명,단속일시,단속장소
Author대전광역시 서구
URLhttps://www.data.go.kr/data/15125356/fileData.do

Alerts

자치구명 has constant value ""Constant
Dataset has 24 (0.2%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 18:00:29.491821
Analysis finished2023-12-12 18:00:29.888075
Duration0.4 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 length2
Median length2
Mean length2
Min length2

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-13T03:00:29.949768image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:00:30.036067image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
서구 10000
100.0%

단속일시
Date

Distinct9922
Distinct (%)99.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 07:43:00
Maximum2023-06-05 11:19:00
2023-12-13T03:00:30.138715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:00:30.282172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속장소
Text

Distinct1270
Distinct (%)12.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T03:00:30.497983image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length20
Median length18
Mean length9.6481
Min length5

Characters and Unicode

Total characters96481
Distinct characters293
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

Unique629 ?
Unique (%)6.3%

Sample

1st row둔산동까치네거리
2nd row도마동해든마켓
3rd row둔산2동둔산서로부근
4th row월평동506 부근
5th row둔산2동대덕대로부근
ValueCountFrequency (%)
부근 2863
 
19.4%
앞 377
 
2.6%
둔산동하나금융투자 268
 
1.8%
둔산동둔산동학원가 259
 
1.8%
가수원동mk클리닉 228
 
1.5%
둔산점 210
 
1.4%
가수원동cgv 207
 
1.4%
가수원점 207
 
1.4%
관저동롯데시네마 174
 
1.2%
둔산동강남 161
 
1.1%
Other values (1279) 9793
66.4%
2023-12-13T03:00:30.881402image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 10397
 
10.8%
산 5144
 
5.3%
둔 4960
 
5.1%
4757
 
4.9%
부 4420
 
4.6%
근 4414
 
4.6%
1 2896
 
3.0%
원 1973
 
2.0%
2 1894
 
2.0%
로 1695
 
1.8%
Other values (283) 53931
55.9%

Most occurring categories

ValueCountFrequency (%)
Other Letter 77750
80.6%
Decimal Number 12211
 
12.7%
Space Separator 4757
 
4.9%
Uppercase Letter 1144
 
1.2%
Dash Punctuation 290
 
0.3%
Open Punctuation 154
 
0.2%
Close Punctuation 154
 
0.2%
Lowercase Letter 19
 
< 0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 10397
 
13.4%
산 5144
 
6.6%
둔 4960
 
6.4%
부 4420
 
5.7%
근 4414
 
5.7%
원 1973
 
2.5%
로 1695
 
2.2%
마 1569
 
2.0%
가 1463
 
1.9%
도 1457
 
1.9%
Other values (260) 40258
51.8%
Decimal Number
ValueCountFrequency (%)
1 2896
23.7%
2 1894
15.5%
5 1517
12.4%
4 1218
10.0%
0 998
 
8.2%
8 846
 
6.9%
9 815
 
6.7%
3 797
 
6.5%
6 647
 
5.3%
7 583
 
4.8%
Uppercase Letter
ValueCountFrequency (%)
K 245
21.4%
M 241
21.1%
G 223
19.5%
C 207
18.1%
V 207
18.1%
S 13
 
1.1%
T 8
 
0.7%
Space Separator
ValueCountFrequency (%)
4757
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 290
100.0%
Open Punctuation
ValueCountFrequency (%)
( 154
100.0%
Close Punctuation
ValueCountFrequency (%)
) 154
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 19
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 77750
80.6%
Common 17568
 
18.2%
Latin 1163
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 10397
 
13.4%
산 5144
 
6.6%
둔 4960
 
6.4%
부 4420
 
5.7%
근 4414
 
5.7%
원 1973
 
2.5%
로 1695
 
2.2%
마 1569
 
2.0%
가 1463
 
1.9%
도 1457
 
1.9%
Other values (260) 40258
51.8%
Common
ValueCountFrequency (%)
4757
27.1%
1 2896
16.5%
2 1894
 
10.8%
5 1517
 
8.6%
4 1218
 
6.9%
0 998
 
5.7%
8 846
 
4.8%
9 815
 
4.6%
3 797
 
4.5%
6 647
 
3.7%
Other values (5) 1183
 
6.7%
Latin
ValueCountFrequency (%)
K 245
21.1%
M 241
20.7%
G 223
19.2%
C 207
17.8%
V 207
17.8%
e 19
 
1.6%
S 13
 
1.1%
T 8
 
0.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 77750
80.6%
ASCII 18731
 
19.4%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 10397
 
13.4%
산 5144
 
6.6%
둔 4960
 
6.4%
부 4420
 
5.7%
근 4414
 
5.7%
원 1973
 
2.5%
로 1695
 
2.2%
마 1569
 
2.0%
가 1463
 
1.9%
도 1457
 
1.9%
Other values (260) 40258
51.8%
ASCII
ValueCountFrequency (%)
4757
25.4%
1 2896
15.5%
2 1894
 
10.1%
5 1517
 
8.1%
4 1218
 
6.5%
0 998
 
5.3%
8 846
 
4.5%
9 815
 
4.4%
3 797
 
4.3%
6 647
 
3.5%
Other values (13) 2346
12.5%

Missing values

2023-12-13T03:00:29.750719image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:00:29.844628image/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

자치구명단속일시단속장소
32163서구2023-03-02 18:19:26둔산동까치네거리
34564서구2023-03-06 17:05:34도마동해든마켓
31764서구2023-03-02 14:31:40둔산2동둔산서로부근
6951서구2023-01-14 19:11:00월평동506 부근
23912서구2023-02-17 10:11:29둔산2동대덕대로부근
99247서구2023-06-03 16:08:00도안동1507 부근
25311서구2023-02-20 10:29:09둔산2동대덕대로부근
72761서구2023-04-27 14:34:09만년동둔산대로부근
16097서구2023-02-04 13:34:00둔산동1109 부근
37684서구2023-03-10 10:12:51탄방동도솔로부근
자치구명단속일시단속장소
41646서구2023-03-16 09:19:35둔산동둔산동학원가
79026서구2023-05-05 22:23:00갈마동707 부근
71732서구2023-04-26 10:13:59관저1동관저북로부근
15067서구2023-02-02 19:15:22탄방동MG새마을금고
48570서구2023-03-26 20:53:00월평동1555 부근
8215서구2023-01-17 16:00:12월평1동월드컵대로부근
34332서구2023-03-06 14:29:47관저1동계백로부근
80503서구2023-05-09 14:32:14둔산동둔산초등학교
50855서구2023-03-29 10:24탄방동계룡건설
80357서구2023-05-09 10:36:00갈마동690 부근

Duplicate rows

Most frequently occurring

자치구명단속일시단속장소# duplicates
0서구2023-01-06 09:31둔산2동전문건설회관2
1서구2023-01-06 10:29탄방동계룡건설2
2서구2023-01-07 13:56:00둔산동1548 부근2
3서구2023-01-09 21:36:00둔산동963 부근2
4서구2023-01-14 11:45:00둔산동1529 부근2
5서구2023-01-14 12:59:00둔산동1541 부근2
6서구2023-02-11 09:56:00둔산동1123 부근2
7서구2023-02-25 14:55:00둔산동1548 부근2
8서구2023-03-04 11:04:00둔산동1528 부근2
9서구2023-03-04 11:37:00둔산동1529 부근2