Overview

Dataset statistics

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

Variable types

Categorical3
DateTime1
Text1

Dataset

Description인천광역시 서구의 불법주정차 단속 현황(단속일자, 단속동, 단속부근, 단속구분 등)입니다. 데이터기준일자로부터 1년간의 단속현황입니다.
URLhttps://www.data.go.kr/data/15085734/fileData.do

Alerts

자치단체 has constant value ""Constant
Dataset has 2 (< 0.1%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-11 22:49:25.884423
Analysis finished2023-12-11 22:49:27.905647
Duration2.02 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
28260
10000 

Length

Max length5
Median length5
Mean length5
Min length5

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
28260 10000
100.0%

Length

2023-12-12T07:49:27.959610image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:49:28.041915image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
28260 10000
100.0%
Distinct9989
Distinct (%)99.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-08-01 09:06:52
Maximum2023-03-08 16:34:13
2023-12-12T07:49:28.123224image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T07:49:28.236135image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속동
Categorical

Distinct26
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
청라동
1447 
가좌동
1288 
원당동
1108 
가정동
1107 
석남동
767 
Other values (21)
4283 

Length

Max length5
Median length3
Mean length3.0096
Min length3

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

1st row경서동
2nd row가좌동
3rd row가정동
4th row청라동
5th row청라동

Common Values

ValueCountFrequency (%)
청라동 1447
14.5%
가좌동 1288
12.9%
원당동 1108
11.1%
가정동 1107
11.1%
석남동 767
7.7%
당하동 627
 
6.3%
마전동 493
 
4.9%
심곡동 489
 
4.9%
경서동 453
 
4.5%
연희동 437
 
4.4%
Other values (16) 1784
17.8%

Length

2023-12-12T07:49:28.354748image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
청라동 1447
14.5%
가좌동 1288
12.9%
원당동 1108
11.1%
가정동 1107
11.1%
석남동 767
7.7%
당하동 627
 
6.3%
마전동 493
 
4.9%
심곡동 489
 
4.9%
경서동 453
 
4.5%
연희동 437
 
4.4%
Other values (16) 1784
17.8%
Distinct1759
Distinct (%)17.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T07:49:28.575684image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length22
Mean length9.2307
Min length3

Characters and Unicode

Total characters92307
Distinct characters415
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique875 ?
Unique (%)8.8%

Sample

1st row한내로100번길서쪽
2nd row두산위브 아파트
3rd row염곡로498번안길 GS25옆길 민원
4th row청라 썬앤빌더테라스
5th row테트리스타워 주차장
ValueCountFrequency (%)
민원 1544
 
8.7%
원당동 682
 
3.8%
가정동 435
 
2.4%
가좌동 378
 
2.1%
당하동 322
 
1.8%
청라동 311
 
1.7%
617-1 272
 
1.5%
석남동 248
 
1.4%
469-3 194
 
1.1%
삼거리 192
 
1.1%
Other values (1801) 13230
74.3%
2023-12-12T07:49:28.893054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7825
 
8.5%
1 4334
 
4.7%
3903
 
4.2%
3488
 
3.8%
3478
 
3.8%
3254
 
3.5%
6 2515
 
2.7%
2458
 
2.7%
2 2351
 
2.5%
- 2272
 
2.5%
Other values (405) 56429
61.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 61796
66.9%
Decimal Number 19642
 
21.3%
Space Separator 7825
 
8.5%
Dash Punctuation 2272
 
2.5%
Uppercase Letter 533
 
0.6%
Lowercase Letter 108
 
0.1%
Open Punctuation 62
 
0.1%
Close Punctuation 62
 
0.1%
Other Punctuation 7
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
3903
 
6.3%
3488
 
5.6%
3478
 
5.6%
3254
 
5.3%
2458
 
4.0%
2232
 
3.6%
1426
 
2.3%
1419
 
2.3%
1243
 
2.0%
1204
 
1.9%
Other values (365) 37691
61.0%
Uppercase Letter
ValueCountFrequency (%)
K 139
26.1%
M 116
21.8%
T 73
13.7%
A 61
11.4%
P 60
11.3%
S 31
 
5.8%
N 16
 
3.0%
L 10
 
1.9%
H 10
 
1.9%
G 9
 
1.7%
Other values (6) 8
 
1.5%
Decimal Number
ValueCountFrequency (%)
1 4334
22.1%
6 2515
12.8%
2 2351
12.0%
3 2015
10.3%
4 1861
9.5%
0 1639
 
8.3%
5 1479
 
7.5%
7 1233
 
6.3%
8 1231
 
6.3%
9 984
 
5.0%
Lowercase Letter
ValueCountFrequency (%)
k 52
48.1%
s 38
35.2%
g 14
 
13.0%
m 2
 
1.9%
u 1
 
0.9%
c 1
 
0.9%
Other Punctuation
ValueCountFrequency (%)
& 4
57.1%
. 1
 
14.3%
1
 
14.3%
/ 1
 
14.3%
Space Separator
ValueCountFrequency (%)
7825
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 2272
100.0%
Open Punctuation
ValueCountFrequency (%)
( 62
100.0%
Close Punctuation
ValueCountFrequency (%)
) 62
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 61796
66.9%
Common 29870
32.4%
Latin 641
 
0.7%

Most frequent character per script

Hangul
ValueCountFrequency (%)
3903
 
6.3%
3488
 
5.6%
3478
 
5.6%
3254
 
5.3%
2458
 
4.0%
2232
 
3.6%
1426
 
2.3%
1419
 
2.3%
1243
 
2.0%
1204
 
1.9%
Other values (365) 37691
61.0%
Latin
ValueCountFrequency (%)
K 139
21.7%
M 116
18.1%
T 73
11.4%
A 61
9.5%
P 60
9.4%
k 52
 
8.1%
s 38
 
5.9%
S 31
 
4.8%
N 16
 
2.5%
g 14
 
2.2%
Other values (12) 41
 
6.4%
Common
ValueCountFrequency (%)
7825
26.2%
1 4334
14.5%
6 2515
 
8.4%
2 2351
 
7.9%
- 2272
 
7.6%
3 2015
 
6.7%
4 1861
 
6.2%
0 1639
 
5.5%
5 1479
 
5.0%
7 1233
 
4.1%
Other values (8) 2346
 
7.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 61794
66.9%
ASCII 30510
33.1%
Compat Jamo 2
 
< 0.1%
None 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7825
25.6%
1 4334
14.2%
6 2515
 
8.2%
2 2351
 
7.7%
- 2272
 
7.4%
3 2015
 
6.6%
4 1861
 
6.1%
0 1639
 
5.4%
5 1479
 
4.8%
7 1233
 
4.0%
Other values (29) 2986
 
9.8%
Hangul
ValueCountFrequency (%)
3903
 
6.3%
3488
 
5.6%
3478
 
5.6%
3254
 
5.3%
2458
 
4.0%
2232
 
3.6%
1426
 
2.3%
1419
 
2.3%
1243
 
2.0%
1204
 
1.9%
Other values (363) 37689
61.0%
Compat Jamo
ValueCountFrequency (%)
1
50.0%
1
50.0%
None
ValueCountFrequency (%)
1
100.0%

단속구분
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
고정형CCTV
5017 
PDA단속
2842 
안전신문고(24시)
1774 
차량형CCTV
 
363
인력단속
 
4

Length

Max length10
Median length7
Mean length6.9626
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고정형CCTV
2nd row고정형CCTV
3rd rowPDA단속
4th row고정형CCTV
5th row고정형CCTV

Common Values

ValueCountFrequency (%)
고정형CCTV 5017
50.2%
PDA단속 2842
28.4%
안전신문고(24시) 1774
 
17.7%
차량형CCTV 363
 
3.6%
인력단속 4
 
< 0.1%

Length

2023-12-12T07:49:29.019989image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T07:49:29.108708image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고정형cctv 5017
50.2%
pda단속 2842
28.4%
안전신문고(24시 1774
 
17.7%
차량형cctv 363
 
3.6%
인력단속 4
 
< 0.1%

Correlations

2023-12-12T07:49:29.172864image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속동단속구분
단속동1.0000.448
단속구분0.4481.000
2023-12-12T07:49:29.246096image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속동단속구분
단속동1.0000.233
단속구분0.2331.000
2023-12-12T07:49:29.311331image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속동단속구분
단속동1.0000.233
단속구분0.2331.000

Missing values

2023-12-12T07:49:27.785182image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T07:49:27.866506image/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

자치단체단속일자단속동단속부근단속구분
16475282602022-09-13 / 15:36:36경서동한내로100번길서쪽고정형CCTV
3215282602022-08-05 / 17:43:40가좌동두산위브 아파트고정형CCTV
95114282602023-03-08 / 14:42:16가정동염곡로498번안길 GS25옆길 민원PDA단속
35432282602022-10-25 / 10:25:38청라동청라 썬앤빌더테라스고정형CCTV
55444282602022-12-01 / 16:10:28청라동테트리스타워 주차장고정형CCTV
56466282602022-12-04 / 23:44:05가정동가정동 630안전신문고(24시)
4898282602022-08-11 / 16:07:54원당동원당동 824-1고정형CCTV
71222282602023-01-10 / 14:28:02가정동중앙시장역 삼거리고정형CCTV
83529282602023-02-14 / 19:20:52가정동봉오재3로 MK타워길민원PDA단속
48173282602022-11-17 / 15:38:23청라동청라커낼로260번길 드마리스길민원PDA단속
자치단체단속일자단속동단속부근단속구분
70999282602023-01-10 / 06:24:46검암동검암동 512-1안전신문고(24시)
78736282602023-02-01 / 06:52:05가좌동가좌동 30-4안전신문고(24시)
60347282602022-12-12 / 16:06:17원당동원당동 436-1고정형CCTV
95244282602023-03-08 / 15:54:30당하동당하동 산41-2고정형CCTV
59669282602022-12-09 / 19:34:06청라동한내로100번길 민원PDA단속
67355282602022-12-30 / 11:42:27당하동당하동 1029-6고정형CCTV
8829282602022-08-23 / 19:06:14가정동Nk타워 민원PDA단속
49263282602022-11-19 / 15:15:10청라동한내로100번길 민원PDA단속
51659282602022-11-24 / 11:28:03가좌동광양프런티어밸리 3차고정형CCTV
92236282602023-03-02 / 16:17:21당하동당하동 산41-2고정형CCTV

Duplicate rows

Most frequently occurring

자치단체단속일자단속동단속부근단속구분# duplicates
0282602023-01-20 / 18:41:16심곡동심곡동 266안전신문고(24시)2
1282602023-02-05 / 10:56:04가정동가정동 578안전신문고(24시)2