Overview

Dataset statistics

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

Variable types

Categorical3
DateTime1
Text1

Dataset

Description인천광역시 부평구 불법주정차 단속 현황입니다. (자치단체,단속일시,단속구ex) 28237,2021-01-01 1:02,인천광역시 부평구,항동로 광일아파트 부근,안전신문고(24시)
URLhttps://www.data.go.kr/data/15083642/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 21:14:25.841164
Analysis finished2023-12-12 21:14:28.205586
Duration2.36 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

2023-12-13T06:14:28.273636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:14:28.366130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
28237 10000
100.0%

단속일시
Date

Distinct9786
Distinct (%)97.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:06:43
Maximum2023-04-30 17:01:00
2023-12-13T06:14:28.475780image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:14:28.643549image/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

2023-12-13T06:14:28.794491image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:14:28.907374image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
인천광역시 10000
50.0%
부평구 10000
50.0%

단속장소
Text

Distinct1623
Distinct (%)16.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T06:14:29.207163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length28
Median length22
Mean length12.2406
Min length3

Characters and Unicode

Total characters122406
Distinct characters505
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

Unique725 ?
Unique (%)7.2%

Sample

1st rowT051 벽돌막사거리 국민은행
2nd rowT019 천주교부평4동교회 (부흥로)
3rd row광장로 광장로24번길일대
4th rowT059 삼산동 스타벅스
5th row길주로647번길
ValueCountFrequency (%)
정문 727
 
3.2%
앞 689
 
3.1%
부흥로 397
 
1.8%
시장로 364
 
1.6%
충선로 358
 
1.6%
맞은편 319
 
1.4%
광장로 288
 
1.3%
부평대로 284
 
1.3%
장제로 264
 
1.2%
마장로 250
 
1.1%
Other values (1576) 18439
82.4%
2023-12-13T06:14:29.705011image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
12379
 
10.1%
로 7803
 
6.4%
0 5245
 
4.3%
주 4334
 
3.5%
부 4255
 
3.5%
변 3296
 
2.7%
T 3051
 
2.5%
1 2397
 
2.0%
평 2299
 
1.9%
길 2298
 
1.9%
Other values (495) 75049
61.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 84451
69.0%
Decimal Number 18442
 
15.1%
Space Separator 12379
 
10.1%
Uppercase Letter 4671
 
3.8%
Close Punctuation 1210
 
1.0%
Open Punctuation 1210
 
1.0%
Lowercase Letter 38
 
< 0.1%
Dash Punctuation 3
 
< 0.1%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 7803
 
9.2%
주 4334
 
5.1%
부 4255
 
5.0%
변 3296
 
3.9%
평 2299
 
2.7%
길 2298
 
2.7%
장 2256
 
2.7%
동 2192
 
2.6%
대 2045
 
2.4%
번 1863
 
2.2%
Other values (456) 51810
61.3%
Uppercase Letter
ValueCountFrequency (%)
T 3051
65.3%
B 636
 
13.6%
S 518
 
11.1%
U 142
 
3.0%
C 131
 
2.8%
K 99
 
2.1%
G 55
 
1.2%
M 11
 
0.2%
R 5
 
0.1%
H 5
 
0.1%
Other values (7) 18
 
0.4%
Decimal Number
ValueCountFrequency (%)
0 5245
28.4%
1 2397
13.0%
2 2256
12.2%
4 1626
 
8.8%
3 1357
 
7.4%
7 1276
 
6.9%
5 1110
 
6.0%
8 1093
 
5.9%
9 1050
 
5.7%
6 1032
 
5.6%
Lowercase Letter
ValueCountFrequency (%)
k 17
44.7%
e 7
18.4%
s 5
 
13.2%
c 4
 
10.5%
u 2
 
5.3%
j 2
 
5.3%
t 1
 
2.6%
Space Separator
ValueCountFrequency (%)
12379
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1210
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1210
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 3
100.0%
Other Punctuation
ValueCountFrequency (%)
. 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 84451
69.0%
Common 33246
 
27.2%
Latin 4709
 
3.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 7803
 
9.2%
주 4334
 
5.1%
부 4255
 
5.0%
변 3296
 
3.9%
평 2299
 
2.7%
길 2298
 
2.7%
장 2256
 
2.7%
동 2192
 
2.6%
대 2045
 
2.4%
번 1863
 
2.2%
Other values (456) 51810
61.3%
Latin
ValueCountFrequency (%)
T 3051
64.8%
B 636
 
13.5%
S 518
 
11.0%
U 142
 
3.0%
C 131
 
2.8%
K 99
 
2.1%
G 55
 
1.2%
k 17
 
0.4%
M 11
 
0.2%
e 7
 
0.1%
Other values (14) 42
 
0.9%
Common
ValueCountFrequency (%)
12379
37.2%
0 5245
15.8%
1 2397
 
7.2%
2 2256
 
6.8%
4 1626
 
4.9%
3 1357
 
4.1%
7 1276
 
3.8%
) 1210
 
3.6%
( 1210
 
3.6%
5 1110
 
3.3%
Other values (5) 3180
 
9.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 84451
69.0%
ASCII 37955
31.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
12379
32.6%
0 5245
13.8%
T 3051
 
8.0%
1 2397
 
6.3%
2 2256
 
5.9%
4 1626
 
4.3%
3 1357
 
3.6%
7 1276
 
3.4%
) 1210
 
3.2%
( 1210
 
3.2%
Other values (29) 5948
15.7%
Hangul
ValueCountFrequency (%)
로 7803
 
9.2%
주 4334
 
5.1%
부 4255
 
5.0%
변 3296
 
3.9%
평 2299
 
2.7%
길 2298
 
2.7%
장 2256
 
2.7%
동 2192
 
2.6%
대 2045
 
2.4%
번 1863
 
2.2%
Other values (456) 51810
61.3%

단속구분
Categorical

Distinct6
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
고정형CCTV
4034 
PDA단속
3952 
안전신문고(24시)
1822 
차량형CCTV
 
138
버스탑재형
 
48

Length

Max length10
Median length7
Mean length6.7448
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 (%)
고정형CCTV 4034
40.3%
PDA단속 3952
39.5%
안전신문고(24시) 1822
18.2%
차량형CCTV 138
 
1.4%
버스탑재형 48
 
0.5%
인력단속 6
 
0.1%

Length

2023-12-13T06:14:29.844352image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:14:29.967453image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고정형cctv 4034
40.3%
pda단속 3952
39.5%
안전신문고(24시 1822
18.2%
차량형cctv 138
 
1.4%
버스탑재형 48
 
0.5%
인력단속 6
 
0.1%

Missing values

2023-12-13T06:14:28.026054image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:14:28.154281image/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

자치단체코드단속일시단속구단속장소단속구분
33562282372023-03-28 / 16:44:47인천광역시 부평구T051 벽돌막사거리 국민은행고정형CCTV
8319282372023-01-26 / 14:07:13인천광역시 부평구T019 천주교부평4동교회 (부흥로)고정형CCTV
27801282372023-03-14 / 20:01:00인천광역시 부평구광장로 광장로24번길일대PDA단속
10228282372023-01-31 / 15:35:04인천광역시 부평구T059 삼산동 스타벅스고정형CCTV
25779282372023-03-09 / 20:40:01인천광역시 부평구길주로647번길안전신문고(24시)
39167282372023-04-13 / 09:03:41인천광역시 부평구평천로142번길안전신문고(24시)
27333282372023-03-13 / 19:14:00인천광역시 부평구부평북로 인천예향교회주변PDA단속
12825282372023-02-06 / 19:19:00인천광역시 부평구부흥로 유진마젤란주변PDA단속
30169282372023-03-20 / 15:31:05인천광역시 부평구S289 부개서초등학교 사거리고정형CCTV
19780282372023-02-22 / 21:15:58인천광역시 부평구부흥로안전신문고(24시)
자치단체코드단속일시단속구단속장소단속구분
41960282372023-04-20 / 17:19:15인천광역시 부평구T079 청천초등학교(평천로)고정형CCTV
10000282372023-01-31 / 09:10:40인천광역시 부평구T044 동암우체국 맞은편고정형CCTV
24348282372023-03-06 / 17:25:16인천광역시 부평구T053 윤산부인과 사거리고정형CCTV
569282372023-01-03 / 08:25:52인천광역시 부평구T078 부평서초 (한길안과)고정형CCTV
16298282372023-02-15 / 08:00:30인천광역시 부평구충선로안전신문고(24시)
26748282372023-03-12 / 15:51:00인천광역시 부평구광장로 현대더로프트주변PDA단속
24120282372023-03-06 / 14:08:59인천광역시 부평구장제로안전신문고(24시)
14060282372023-02-09 / 16:14:47인천광역시 부평구T086 원길삼거리고정형CCTV
6740282372023-01-19 / 15:53:56인천광역시 부평구T004 부평구새마을회관(장제로)고정형CCTV
18930282372023-02-21 / 11:00:00인천광역시 부평구아트센트로 동암역주변PDA단속

Duplicate rows

Most frequently occurring

자치단체코드단속일시단속구단속장소단속구분# duplicates
31282372023-02-10 / 20:36:00인천광역시 부평구시장로 한남프라자주변PDA단속3
55282372023-03-04 / 16:29:00인천광역시 부평구부평북로 아이즈빌주변PDA단속3
0282372023-01-02 / 11:10:00인천광역시 부평구주부토로 로얄프라자주변PDA단속2
1282372023-01-02 / 20:10:00인천광역시 부평구길주남로 래미안아파트주변PDA단속2
2282372023-01-04 / 20:12:00인천광역시 부평구부흥로 프리상뜨주변PDA단속2
3282372023-01-06 / 19:56:00인천광역시 부평구마장로 한신휴아파트주변PDA단속2
4282372023-01-07 / 15:51:00인천광역시 부평구광장로 광장로24번길일대PDA단속2
5282372023-01-09 / 14:51:00인천광역시 부평구부평북로 은혜와진리교회주변PDA단속2
6282372023-01-10 / 19:05:22인천광역시 부평구부흥로안전신문고(24시)2
7282372023-01-12 / 09:11:00인천광역시 부평구경원대로 룩소르주변PDA단속2