Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows121
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 121 (1.2%) duplicate rowsDuplicates

Reproduction

Analysis started2024-01-28 12:28:11.709486
Analysis finished2024-01-28 12:28:13.535197
Duration1.83 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:13.592211image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

단속일시
Date

Distinct9740
Distinct (%)97.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:06:43
Maximum2023-04-30 17:12:00
2024-01-28T21:28:13.757182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-28T21:28:13.873049image/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:13.974751image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-28T21:28:14.044623image/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:14.256820image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length21
Mean length12.2489
Min length3

Characters and Unicode

Total characters122489
Distinct characters516
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

Unique746 ?
Unique (%)7.5%

Sample

1st rowT048 시장로 동부교회 맞은편
2nd rowT043 동암 신협 앞
3rd row평천로 인향아파트주변
4th rowT018 세월천사거리(마장로)
5th row동수로
ValueCountFrequency (%)
앞 703
 
3.1%
정문 685
 
3.1%
시장로 387
 
1.7%
부흥로 384
 
1.7%
충선로 348
 
1.6%
맞은편 326
 
1.5%
광장로 310
 
1.4%
장제로 290
 
1.3%
부평대로 255
 
1.1%
주부토로 254
 
1.1%
Other values (1593) 18394
82.4%
2024-01-28T21:28:14.592509image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
12336
 
10.1%
로 7841
 
6.4%
0 5081
 
4.1%
주 4501
 
3.7%
부 4220
 
3.4%
변 3440
 
2.8%
T 2984
 
2.4%
장 2354
 
1.9%
1 2331
 
1.9%
길 2294
 
1.9%
Other values (506) 75107
61.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 84979
69.4%
Decimal Number 18154
 
14.8%
Space Separator 12336
 
10.1%
Uppercase Letter 4610
 
3.8%
Open Punctuation 1183
 
1.0%
Close Punctuation 1183
 
1.0%
Lowercase Letter 37
 
< 0.1%
Dash Punctuation 4
 
< 0.1%
Other Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 7841
 
9.2%
주 4501
 
5.3%
부 4220
 
5.0%
변 3440
 
4.0%
장 2354
 
2.8%
길 2294
 
2.7%
평 2287
 
2.7%
동 2141
 
2.5%
대 2020
 
2.4%
번 1871
 
2.2%
Other values (465) 52010
61.2%
Uppercase Letter
ValueCountFrequency (%)
T 2984
64.7%
B 634
 
13.8%
S 506
 
11.0%
U 138
 
3.0%
C 131
 
2.8%
K 113
 
2.5%
G 63
 
1.4%
M 14
 
0.3%
R 7
 
0.2%
H 5
 
0.1%
Other values (7) 15
 
0.3%
Decimal Number
ValueCountFrequency (%)
0 5081
28.0%
1 2331
12.8%
2 2253
12.4%
4 1591
 
8.8%
3 1479
 
8.1%
7 1214
 
6.7%
5 1122
 
6.2%
8 1074
 
5.9%
9 1016
 
5.6%
6 993
 
5.5%
Lowercase Letter
ValueCountFrequency (%)
k 11
29.7%
c 7
18.9%
s 6
16.2%
e 5
13.5%
j 4
 
10.8%
u 2
 
5.4%
h 1
 
2.7%
b 1
 
2.7%
Other Punctuation
ValueCountFrequency (%)
. 2
66.7%
, 1
33.3%
Space Separator
ValueCountFrequency (%)
12336
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1183
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1183
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 4
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 84979
69.4%
Common 32863
 
26.8%
Latin 4647
 
3.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 7841
 
9.2%
주 4501
 
5.3%
부 4220
 
5.0%
변 3440
 
4.0%
장 2354
 
2.8%
길 2294
 
2.7%
평 2287
 
2.7%
동 2141
 
2.5%
대 2020
 
2.4%
번 1871
 
2.2%
Other values (465) 52010
61.2%
Latin
ValueCountFrequency (%)
T 2984
64.2%
B 634
 
13.6%
S 506
 
10.9%
U 138
 
3.0%
C 131
 
2.8%
K 113
 
2.4%
G 63
 
1.4%
M 14
 
0.3%
k 11
 
0.2%
R 7
 
0.2%
Other values (15) 46
 
1.0%
Common
ValueCountFrequency (%)
12336
37.5%
0 5081
15.5%
1 2331
 
7.1%
2 2253
 
6.9%
4 1591
 
4.8%
3 1479
 
4.5%
7 1214
 
3.7%
( 1183
 
3.6%
) 1183
 
3.6%
5 1122
 
3.4%
Other values (6) 3090
 
9.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 84979
69.4%
ASCII 37510
30.6%

Most frequent character per block

ASCII
ValueCountFrequency (%)
12336
32.9%
0 5081
13.5%
T 2984
 
8.0%
1 2331
 
6.2%
2 2253
 
6.0%
4 1591
 
4.2%
3 1479
 
3.9%
7 1214
 
3.2%
( 1183
 
3.2%
) 1183
 
3.2%
Other values (31) 5875
15.7%
Hangul
ValueCountFrequency (%)
로 7841
 
9.2%
주 4501
 
5.3%
부 4220
 
5.0%
변 3440
 
4.0%
장 2354
 
2.8%
길 2294
 
2.7%
평 2287
 
2.7%
동 2141
 
2.5%
대 2020
 
2.4%
번 1871
 
2.2%
Other values (465) 52010
61.2%

단속구분
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
PDA단속
4076 
고정형CCTV
3934 
안전신문고(24시)
1806 
차량형CCTV
 
135
버스탑재형
 
44

Length

Max length10
Median length7
Mean length6.7163
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
PDA단속 4076
40.8%
고정형CCTV 3934
39.3%
안전신문고(24시) 1806
18.1%
차량형CCTV 135
 
1.4%
버스탑재형 44
 
0.4%
인력단속 5
 
0.1%

Length

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

Common Values (Plot)

2024-01-28T21:28:14.793417image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
pda단속 4076
40.8%
고정형cctv 3934
39.3%
안전신문고(24시 1806
18.1%
차량형cctv 135
 
1.4%
버스탑재형 44
 
0.4%
인력단속 5
 
< 0.1%

Missing values

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

자치단체코드단속일시단속구단속장소단속구분
17155282372023-02-16 / 16:20:53인천광역시 부평구T048 시장로 동부교회 맞은편고정형CCTV
5596282372023-01-17 / 10:33:53인천광역시 부평구T043 동암 신협 앞고정형CCTV
8561282372023-01-27 / 08:10:00인천광역시 부평구평천로 인향아파트주변PDA단속
22940282372023-03-03 / 09:17:13인천광역시 부평구T018 세월천사거리(마장로)고정형CCTV
23347282372023-03-03 / 19:07:13인천광역시 부평구동수로안전신문고(24시)
14367282372023-02-10 / 12:54:05인천광역시 부평구경원대로1417번길안전신문고(24시)
38596282372023-04-11 / 14:40:22인천광역시 부평구T059 삼산동 스타벅스고정형CCTV
30942282372023-03-22 / 14:05:14인천광역시 부평구T059 삼산동 스타벅스고정형CCTV
43765282372023-04-26 / 10:38:00인천광역시 부평구충선로 충선로203번길일대PDA단속
5240282372023-01-16 / 14:08:58인천광역시 부평구T017 청천사거리고정형CCTV
자치단체코드단속일시단속구단속장소단속구분
22097282372023-02-28 / 17:27:00인천광역시 부평구부흥북로 부평고등학교주변PDA단속
40296282372023-04-16 / 15:08:00인천광역시 부평구장제로 동부교회주변PDA단속
30038282372023-03-20 / 12:54:07인천광역시 부평구길주로647번길안전신문고(24시)
34311282372023-03-30 / 11:29:00인천광역시 부평구부평북로 더원스테이트주변PDA단속
43635282372023-04-25 / 17:10:49인천광역시 부평구B044 미산초등학교 정문고정형CCTV
20247282372023-02-23 / 23:00:17인천광역시 부평구부일로안전신문고(24시)
40604282372023-04-17 / 15:07:35인천광역시 부평구T065 일신초등학교 정문고정형CCTV
28181282372023-03-15 / 15:40:00인천광역시 부평구부일로 부개역주변PDA단속
23367282372023-03-03 / 19:44:09인천광역시 부평구시장로안전신문고(24시)
31708282372023-03-23 / 20:06:22인천광역시 부평구충선로203번길안전신문고(24시)

Duplicate rows

Most frequently occurring

자치단체코드단속일시단속구단속장소단속구분# duplicates
0282372023-01-01 / 15:08:00인천광역시 부평구대정로 앱스주변PDA단속2
1282372023-01-03 / 14:51:00인천광역시 부평구부평대로 부평대로12번길일대PDA단속2
2282372023-01-04 / 07:57:00인천광역시 부평구충선로 부평농협주변PDA단속2
3282372023-01-06 / 15:08:00인천광역시 부평구굴포로 희빈빌딩주변PDA단속2
4282372023-01-06 / 15:54:00인천광역시 부평구부흥북로 부평쌈밥주변PDA단속2
5282372023-01-08 / 15:32:00인천광역시 부평구시장로 어독도주변PDA단속2
6282372023-01-08 / 16:42:00인천광역시 부평구광장로 롯데마트주변PDA단속2
7282372023-01-08 / 17:18:00인천광역시 부평구동수북로 부평남부역주변PDA단속2
8282372023-01-15 / 15:06:00인천광역시 부평구부흥로 부흥로315번길일대PDA단속2
9282372023-01-16 / 17:09:00인천광역시 부평구충선로 충선로203번길일대PDA단속2