Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows124
Duplicate rows (%)1.2%
Total size in memory478.5 KiB
Average record size in memory49.0 B

Variable types

Categorical3
DateTime1
Text1

Alerts

자치단체코드 has constant value ""Constant
단속구 has constant value ""Constant
Dataset has 124 (1.2%) duplicate rowsDuplicates

Reproduction

Analysis started2024-01-28 12:28:07.403901
Analysis finished2024-01-28 12:28:09.181469
Duration1.78 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

자치단체코드
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
28237
10000 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row28237
2nd row28237
3rd row28237
4th row28237
5th row28237

Common Values

ValueCountFrequency (%)
28237 10000
100.0%

Length

2024-01-28T21:28:09.231219image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T21:28:09.308022image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
28237 10000
100.0%

단속일시
Date

Distinct9736
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 01:09:17
Maximum2023-04-30 16:49:00
2024-01-28T21:28:09.402050image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T21:28:09.518544image/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
인천광역시 부평구
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

2024-01-28T21:28:09.620715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T21:28:09.687917image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천광역시 10000
50.0%
부평구 10000
50.0%

단속장소
Text

Distinct1632
Distinct (%)16.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-01-28T21:28:09.850420image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length21
Mean length12.2428
Min length3

Characters and Unicode

Total characters122428
Distinct characters513
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

Unique744 ?
Unique (%)7.4%

Sample

1st row주부토로65번길
2nd rowT002 인천노인전문병원 맞은편
3rd rowT047 삼산사거리
4th row원적로 부성아파트주변
5th rowT010 가요톱텐(시장로 24)
ValueCountFrequency (%)
정문 688
 
3.1%
앞 682
 
3.1%
부흥로 409
 
1.8%
시장로 370
 
1.7%
충선로 333
 
1.5%
맞은편 331
 
1.5%
광장로 289
 
1.3%
장제로 286
 
1.3%
마장로 236
 
1.1%
주부토로 232
 
1.0%
Other values (1621) 18399
82.7%
2024-01-28T21:28:10.154171image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
12259
 
10.0%
로 7839
 
6.4%
0 5188
 
4.2%
주 4392
 
3.6%
부 4289
 
3.5%
변 3329
 
2.7%
T 3046
 
2.5%
장 2402
 
2.0%
평 2333
 
1.9%
길 2297
 
1.9%
Other values (503) 75054
61.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 84780
69.2%
Decimal Number 18323
 
15.0%
Space Separator 12259
 
10.0%
Uppercase Letter 4635
 
3.8%
Close Punctuation 1199
 
1.0%
Open Punctuation 1199
 
1.0%
Lowercase Letter 26
 
< 0.1%
Other Punctuation 6
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 7839
 
9.2%
주 4392
 
5.2%
부 4289
 
5.1%
변 3329
 
3.9%
장 2402
 
2.8%
평 2333
 
2.8%
길 2297
 
2.7%
동 2226
 
2.6%
번 1926
 
2.3%
대 1925
 
2.3%
Other values (465) 51822
61.1%
Uppercase Letter
ValueCountFrequency (%)
T 3046
65.7%
B 594
 
12.8%
S 538
 
11.6%
U 124
 
2.7%
C 119
 
2.6%
K 108
 
2.3%
G 61
 
1.3%
M 9
 
0.2%
R 9
 
0.2%
J 8
 
0.2%
Other values (7) 19
 
0.4%
Decimal Number
ValueCountFrequency (%)
0 5188
28.3%
2 2287
12.5%
1 2279
12.4%
4 1608
 
8.8%
3 1463
 
8.0%
7 1209
 
6.6%
5 1136
 
6.2%
8 1078
 
5.9%
9 1041
 
5.7%
6 1034
 
5.6%
Lowercase Letter
ValueCountFrequency (%)
k 13
50.0%
c 4
 
15.4%
e 4
 
15.4%
s 3
 
11.5%
u 1
 
3.8%
j 1
 
3.8%
Space Separator
ValueCountFrequency (%)
12259
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1199
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1199
100.0%
Other Punctuation
ValueCountFrequency (%)
. 6
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 84780
69.2%
Common 32987
 
26.9%
Latin 4661
 
3.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 7839
 
9.2%
주 4392
 
5.2%
부 4289
 
5.1%
변 3329
 
3.9%
장 2402
 
2.8%
평 2333
 
2.8%
길 2297
 
2.7%
동 2226
 
2.6%
번 1926
 
2.3%
대 1925
 
2.3%
Other values (465) 51822
61.1%
Latin
ValueCountFrequency (%)
T 3046
65.4%
B 594
 
12.7%
S 538
 
11.5%
U 124
 
2.7%
C 119
 
2.6%
K 108
 
2.3%
G 61
 
1.3%
k 13
 
0.3%
M 9
 
0.2%
R 9
 
0.2%
Other values (13) 40
 
0.9%
Common
ValueCountFrequency (%)
12259
37.2%
0 5188
15.7%
2 2287
 
6.9%
1 2279
 
6.9%
4 1608
 
4.9%
3 1463
 
4.4%
7 1209
 
3.7%
) 1199
 
3.6%
( 1199
 
3.6%
5 1136
 
3.4%
Other values (5) 3160
 
9.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 84780
69.2%
ASCII 37648
30.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
12259
32.6%
0 5188
13.8%
T 3046
 
8.1%
2 2287
 
6.1%
1 2279
 
6.1%
4 1608
 
4.3%
3 1463
 
3.9%
7 1209
 
3.2%
) 1199
 
3.2%
( 1199
 
3.2%
Other values (28) 5911
15.7%
Hangul
ValueCountFrequency (%)
로 7839
 
9.2%
주 4392
 
5.2%
부 4289
 
5.1%
변 3329
 
3.9%
장 2402
 
2.8%
평 2333
 
2.8%
길 2297
 
2.7%
동 2226
 
2.6%
번 1926
 
2.3%
대 1925
 
2.3%
Other values (465) 51822
61.1%

단속구분
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
PDA단속
3994 
고정형CCTV
3992 
안전신문고(24시)
1835 
차량형CCTV
 
121
버스탑재형
 
55

Length

Max length10
Median length7
Mean length6.7398
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row안전신문고(24시)
2nd row고정형CCTV
3rd row고정형CCTV
4th rowPDA단속
5th row고정형CCTV

Common Values

ValueCountFrequency (%)
PDA단속 3994
39.9%
고정형CCTV 3992
39.9%
안전신문고(24시) 1835
18.4%
차량형CCTV 121
 
1.2%
버스탑재형 55
 
0.5%
인력단속 3
 
< 0.1%

Length

2024-01-28T21:28:10.264500image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T21:28:10.348199image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
pda단속 3994
39.9%
고정형cctv 3992
39.9%
안전신문고(24시 1835
18.4%
차량형cctv 121
 
1.2%
버스탑재형 55
 
0.5%
인력단속 3
 
< 0.1%

Missing values

2024-01-28T21:28:09.059172image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-28T21:28:09.139470image/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

자치단체코드단속일시단속구단속장소단속구분
7523282372023-01-21 / 22:12:08인천광역시 부평구주부토로65번길안전신문고(24시)
29906282372023-03-20 / 09:07:53인천광역시 부평구T002 인천노인전문병원 맞은편고정형CCTV
11617282372023-02-03 / 14:04:59인천광역시 부평구T047 삼산사거리고정형CCTV
44430282372023-04-27 / 20:28:00인천광역시 부평구원적로 부성아파트주변PDA단속
31901282372023-03-24 / 14:15:28인천광역시 부평구T010 가요톱텐(시장로 24)고정형CCTV
6659282372023-01-19 / 14:32:01인천광역시 부평구부평동 부흥로 장모족발 부근차량형CCTV
9167282372023-01-28 / 23:31:46인천광역시 부평구길주남로안전신문고(24시)
12791282372023-02-06 / 17:22:23인천광역시 부평구B005 부평서초등학교 정문고정형CCTV
38951282372023-04-12 / 14:35:15인천광역시 부평구T070 후정초(삼산도서관 앞)고정형CCTV
25433282372023-03-09 / 10:29:18인천광역시 부평구T036 부평시장역 김밥천국앞고정형CCTV
자치단체코드단속일시단속구단속장소단속구분
13118282372023-02-07 / 15:17:00인천광역시 부평구주부토로 로얄프라자주변PDA단속
18753282372023-02-20 / 17:46:25인천광역시 부평구충선로203번길안전신문고(24시)
4909282372023-01-15 / 10:47:00인천광역시 부평구장제로 동부교회주변PDA단속
6583282372023-01-19 / 12:44:34인천광역시 부평구B065 십정초등학교 정문고정형CCTV
14929282372023-02-11 / 16:30:00인천광역시 부평구청중로 청천아파트주변PDA단속
25404282372023-03-09 / 09:09:12인천광역시 부평구T016 삼산한의원 사거리고정형CCTV
30423282372023-03-21 / 09:18:25인천광역시 부평구T068 인천테크노밸리U1센터 앞고정형CCTV
4103282372023-01-12 / 16:14:00인천광역시 부평구부흥북로 부일아파트주변PDA단속
74282372023-01-01 / 15:38:47인천광역시 부평구마장로272번길안전신문고(24시)
42920282372023-04-23 / 18:58:49인천광역시 부평구동수천로안전신문고(24시)

Duplicate rows

Most frequently occurring

자치단체코드단속일시단속구단속장소단속구분# duplicates
43282372023-02-17 / 14:47:00인천광역시 부평구부흥로 동아웰빙타운주변PDA단속3
61282372023-03-04 / 16:38:00인천광역시 부평구평천로 아이즈빌주변PDA단속3
65282372023-03-09 / 15:00:00인천광역시 부평구부흥북로 청림아파트주변PDA단속3
0282372023-01-02 / 18:06:00인천광역시 부평구평천로 오리온주변PDA단속2
1282372023-01-03 / 11:15:00인천광역시 부평구광장로 광장로24번길일대PDA단속2
2282372023-01-04 / 19:47:00인천광역시 부평구시장로 티윌드주변PDA단속2
3282372023-01-05 / 19:42:00인천광역시 부평구광장로 광장로24번길일대PDA단속2
4282372023-01-07 / 09:56:00인천광역시 부평구경원대로 더베리타스주변PDA단속2
5282372023-01-08 / 16:42:00인천광역시 부평구부흥로 한라비발디주변PDA단속2
6282372023-01-10 / 14:51:00인천광역시 부평구안남로 안남로123번길주변PDA단속2