Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows130
Duplicate rows (%)1.3%
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 130 (1.3%) duplicate rowsDuplicates

Reproduction

Analysis started2024-04-18 06:09:50.746427
Analysis finished2024-04-18 06:09:54.826007
Duration4.08 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
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-04-18T15:09:54.887658image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T15:09:54.976235image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
28237 10000
100.0%

단속일시
Date

Distinct9743
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 03:05:17
Maximum2023-04-30 17:02:00
2024-04-18T15:09:55.082837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-04-18T15:09:55.213070image/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-04-18T15:09:55.335857image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T15:09:55.433119image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천광역시 10000
50.0%
부평구 10000
50.0%

단속장소
Text

Distinct1608
Distinct (%)16.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-04-18T15:09:55.662963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length20
Mean length12.2288
Min length3

Characters and Unicode

Total characters122288
Distinct characters518
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

Unique724 ?
Unique (%)7.2%

Sample

1st row장제로 브라운스톤주변
2nd row시장로 세원약국주변
3rd row부일로 푸르지오주변
4th row부흥로 동아웰빙타운주변
5th row열우물로 동암조은약국주변
ValueCountFrequency (%)
앞 717
 
3.2%
정문 700
 
3.1%
부흥로 426
 
1.9%
시장로 376
 
1.7%
충선로 371
 
1.7%
맞은편 348
 
1.6%
장제로 300
 
1.3%
광장로 292
 
1.3%
부평대로 245
 
1.1%
마장로 241
 
1.1%
Other values (1581) 18391
82.1%
2024-04-18T15:09:56.020009image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
12407
 
10.1%
로 7814
 
6.4%
0 5211
 
4.3%
주 4295
 
3.5%
부 4279
 
3.5%
변 3281
 
2.7%
T 3058
 
2.5%
평 2319
 
1.9%
장 2314
 
1.9%
1 2269
 
1.9%
Other values (508) 75041
61.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 84540
69.1%
Decimal Number 18252
 
14.9%
Space Separator 12407
 
10.1%
Uppercase Letter 4677
 
3.8%
Close Punctuation 1185
 
1.0%
Open Punctuation 1185
 
1.0%
Lowercase Letter 35
 
< 0.1%
Other Punctuation 4
 
< 0.1%
Dash Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 7814
 
9.2%
주 4295
 
5.1%
부 4279
 
5.1%
변 3281
 
3.9%
평 2319
 
2.7%
장 2314
 
2.7%
길 2265
 
2.7%
동 2251
 
2.7%
대 1972
 
2.3%
번 1866
 
2.2%
Other values (467) 51884
61.4%
Uppercase Letter
ValueCountFrequency (%)
T 3058
65.4%
B 626
 
13.4%
S 502
 
10.7%
U 153
 
3.3%
C 145
 
3.1%
K 112
 
2.4%
G 46
 
1.0%
M 14
 
0.3%
H 4
 
0.1%
A 4
 
0.1%
Other values (8) 13
 
0.3%
Decimal Number
ValueCountFrequency (%)
0 5211
28.6%
1 2269
12.4%
2 2235
12.2%
4 1617
 
8.9%
3 1407
 
7.7%
7 1198
 
6.6%
5 1165
 
6.4%
8 1102
 
6.0%
9 1076
 
5.9%
6 972
 
5.3%
Lowercase Letter
ValueCountFrequency (%)
k 15
42.9%
e 7
20.0%
s 4
 
11.4%
c 4
 
11.4%
j 3
 
8.6%
t 1
 
2.9%
u 1
 
2.9%
Other Punctuation
ValueCountFrequency (%)
. 2
50.0%
, 2
50.0%
Space Separator
ValueCountFrequency (%)
12407
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1185
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1185
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 84540
69.1%
Common 33036
 
27.0%
Latin 4712
 
3.9%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 7814
 
9.2%
주 4295
 
5.1%
부 4279
 
5.1%
변 3281
 
3.9%
평 2319
 
2.7%
장 2314
 
2.7%
길 2265
 
2.7%
동 2251
 
2.7%
대 1972
 
2.3%
번 1866
 
2.2%
Other values (467) 51884
61.4%
Latin
ValueCountFrequency (%)
T 3058
64.9%
B 626
 
13.3%
S 502
 
10.7%
U 153
 
3.2%
C 145
 
3.1%
K 112
 
2.4%
G 46
 
1.0%
k 15
 
0.3%
M 14
 
0.3%
e 7
 
0.1%
Other values (15) 34
 
0.7%
Common
ValueCountFrequency (%)
12407
37.6%
0 5211
15.8%
1 2269
 
6.9%
2 2235
 
6.8%
4 1617
 
4.9%
3 1407
 
4.3%
7 1198
 
3.6%
) 1185
 
3.6%
( 1185
 
3.6%
5 1165
 
3.5%
Other values (6) 3157
 
9.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 84540
69.1%
ASCII 37748
30.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
12407
32.9%
0 5211
13.8%
T 3058
 
8.1%
1 2269
 
6.0%
2 2235
 
5.9%
4 1617
 
4.3%
3 1407
 
3.7%
7 1198
 
3.2%
) 1185
 
3.1%
( 1185
 
3.1%
Other values (31) 5976
15.8%
Hangul
ValueCountFrequency (%)
로 7814
 
9.2%
주 4295
 
5.1%
부 4279
 
5.1%
변 3281
 
3.9%
평 2319
 
2.7%
장 2314
 
2.7%
길 2265
 
2.7%
동 2251
 
2.7%
대 1972
 
2.3%
번 1866
 
2.2%
Other values (467) 51884
61.4%

단속구분
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
고정형CCTV
4015 
PDA단속
3923 
안전신문고(24시)
1853 
차량형CCTV
 
157
버스탑재형
 
49

Length

Max length10
Median length7
Mean length6.7606
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowPDA단속
2nd rowPDA단속
3rd rowPDA단속
4th rowPDA단속
5th rowPDA단속

Common Values

ValueCountFrequency (%)
고정형CCTV 4015
40.2%
PDA단속 3923
39.2%
안전신문고(24시) 1853
18.5%
차량형CCTV 157
 
1.6%
버스탑재형 49
 
0.5%
인력단속 3
 
< 0.1%

Length

2024-04-18T15:09:56.159714image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-04-18T15:09:56.263421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고정형cctv 4015
40.2%
pda단속 3923
39.2%
안전신문고(24시 1853
18.5%
차량형cctv 157
 
1.6%
버스탑재형 49
 
0.5%
인력단속 3
 
< 0.1%

Missing values

2024-04-18T15:09:54.779711image/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

자치단체코드단속일시단속구단속장소단속구분
35058282372023-04-01 / 11:11:00인천광역시 부평구장제로 브라운스톤주변PDA단속
8236282372023-01-25 / 20:11:00인천광역시 부평구시장로 세원약국주변PDA단속
22732282372023-03-02 / 16:02:00인천광역시 부평구부일로 푸르지오주변PDA단속
42443282372023-04-21 / 20:05:00인천광역시 부평구부흥로 동아웰빙타운주변PDA단속
35286282372023-04-02 / 14:54:00인천광역시 부평구열우물로 동암조은약국주변PDA단속
24903282372023-03-07 / 20:24:00인천광역시 부평구시장로 정보당주변PDA단속
20847282372023-02-25 / 11:19:00인천광역시 부평구장제로 힘찬빌딩주변PDA단속
1857282372023-01-06 / 10:42:00인천광역시 부평구동수북로 엘지맨션주변PDA단속
1625282372023-01-05 / 15:41:41인천광역시 부평구T070 후정초(삼산도서관 앞)고정형CCTV
38289282372023-04-10 / 16:02:54인천광역시 부평구S012 부평동초등학교 정문고정형CCTV
자치단체코드단속일시단속구단속장소단속구분
15296282372023-02-13 / 08:05:50인천광역시 부평구T070 후정초(삼산도서관 앞)고정형CCTV
25247282372023-03-08 / 16:16:20인천광역시 부평구T078 부평서초 (한길안과)고정형CCTV
36306282372023-04-05 / 09:58:43인천광역시 부평구T001 인천나누리병원 맞은편고정형CCTV
22930282372023-03-03 / 09:05:18인천광역시 부평구T058 대정로 81 CU편의점고정형CCTV
934282372023-01-03 / 19:45:00인천광역시 부평구광장로 광장로24번길일대PDA단속
28830282372023-03-17 / 05:58:39인천광역시 부평구부평북로안전신문고(24시)
8397282372023-01-26 / 15:17:19인천광역시 부평구T024 한전 인천지역본부(갈산1동)고정형CCTV
27210282372023-03-13 / 16:06:39인천광역시 부평구B212 현대더로프트 102동 앞고정형CCTV
29123282372023-03-17 / 15:38:00인천광역시 부평구주부토로 나주면옥주변PDA단속
38300282372023-04-10 / 16:12:32인천광역시 부평구T009 시장로터리 중앙고정형CCTV

Duplicate rows

Most frequently occurring

자치단체코드단속일시단속구단속장소단속구분# duplicates
0282372023-01-03 / 10:13:00인천광역시 부평구원길로 KT주변PDA단속2
1282372023-01-04 / 17:05:00인천광역시 부평구주부토로 로얄프라자주변PDA단속2
2282372023-01-04 / 17:13:00인천광역시 부평구길주남로 부개1공영주차장PDA단속2
3282372023-01-04 / 17:18:00인천광역시 부평구부흥로 동아웰빙주변PDA단속2
4282372023-01-05 / 17:17:00인천광역시 부평구부평대로 현대해상주변PDA단속2
5282372023-01-05 / 18:47:00인천광역시 부평구주부토로 다온약국주변PDA단속2
6282372023-01-06 / 18:38:00인천광역시 부평구부평북로 예스뷰티주변PDA단속2
7282372023-01-07 / 15:55:00인천광역시 부평구광장로 에코파인주변PDA단속2
8282372023-01-08 / 16:34:00인천광역시 부평구대정로 한라비발디주변PDA단속2
9282372023-01-10 / 19:05:22인천광역시 부평구부흥로안전신문고(24시)2