Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows369
Duplicate rows (%)3.7%
Total size in memory468.8 KiB
Average record size in memory48.0 B

Variable types

DateTime2
Categorical2
Text1

Dataset

Description불법주정차단속(일자, 시간, 장소), 기간 : 2017년 ~ 2020. 8. 31.
Author경상남도 창원시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15064342

Alerts

구청 구분 has constant value ""Constant
Dataset has 369 (3.7%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-10 22:58:37.261247
Analysis finished2023-12-10 22:58:37.765141
Duration0.5 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

단속일자
Date

Distinct608
Distinct (%)6.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-01-02 00:00:00
Maximum2018-10-02 00:00:00
2023-12-11T07:58:37.831267image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:58:37.976484image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속시간
Date

Distinct789
Distinct (%)7.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-11 01:05:00
Maximum2023-12-11 23:21:00
2023-12-11T07:58:38.109059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:58:38.250397image/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 length3
Median length3
Mean length3
Min length3

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-11T07:58:38.397307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T07:58:38.469624image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의창구 10000
100.0%

단속장소명
Text

Distinct1225
Distinct (%)12.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T07:58:38.645034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length21
Median length15
Mean length8.7308
Min length3

Characters and Unicode

Total characters87308
Distinct characters460
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

Unique684 ?
Unique (%)6.8%

Sample

1st row창원중앙역
2nd row용호동 73
3rd row북면근린공원앞
4th row팔용동 메리츠화재 주변
5th row용호동원이대로579번
ValueCountFrequency (%)
주변 2456
 
15.6%
북면근린공원앞 799
 
5.1%
팔용동 655
 
4.2%
용호동 549
 
3.5%
창원중앙역 388
 
2.5%
팔용동주민센터주변 295
 
1.9%
도계초등학교 288
 
1.8%
봉곡동봉곡삼거리 281
 
1.8%
팔용동벽산아파트주변 266
 
1.7%
팔용동사화로 263
 
1.7%
Other values (1192) 9461
60.3%
2023-12-11T07:58:38.963307image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 7421
 
8.5%
5717
 
6.5%
용 4308
 
4.9%
주 3891
 
4.5%
변 3403
 
3.9%
팔 2930
 
3.4%
원 2804
 
3.2%
로 2677
 
3.1%
북 1360
 
1.6%
아 1327
 
1.5%
Other values (450) 51470
59.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 77785
89.1%
Space Separator 5717
 
6.5%
Decimal Number 3435
 
3.9%
Uppercase Letter 164
 
0.2%
Dash Punctuation 127
 
0.1%
Lowercase Letter 35
 
< 0.1%
Close Punctuation 20
 
< 0.1%
Open Punctuation 20
 
< 0.1%
Other Punctuation 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 7421
 
9.5%
용 4308
 
5.5%
주 3891
 
5.0%
변 3403
 
4.4%
팔 2930
 
3.8%
원 2804
 
3.6%
로 2677
 
3.4%
북 1360
 
1.7%
아 1327
 
1.7%
창 1320
 
1.7%
Other values (405) 46344
59.6%
Uppercase Letter
ValueCountFrequency (%)
C 55
33.5%
I 40
24.4%
Y 37
22.6%
B 6
 
3.7%
A 6
 
3.7%
T 5
 
3.0%
G 4
 
2.4%
L 2
 
1.2%
K 2
 
1.2%
S 2
 
1.2%
Other values (5) 5
 
3.0%
Lowercase Letter
ValueCountFrequency (%)
k 6
17.1%
l 5
14.3%
c 4
11.4%
s 4
11.4%
g 3
8.6%
t 3
8.6%
a 2
 
5.7%
x 2
 
5.7%
n 2
 
5.7%
y 2
 
5.7%
Other values (2) 2
 
5.7%
Decimal Number
ValueCountFrequency (%)
2 548
16.0%
3 524
15.3%
1 523
15.2%
5 377
11.0%
7 352
10.2%
9 333
9.7%
6 241
7.0%
0 210
 
6.1%
8 184
 
5.4%
4 143
 
4.2%
Close Punctuation
ValueCountFrequency (%)
) 18
90.0%
] 2
 
10.0%
Open Punctuation
ValueCountFrequency (%)
( 18
90.0%
[ 2
 
10.0%
Other Punctuation
ValueCountFrequency (%)
. 4
80.0%
& 1
 
20.0%
Space Separator
ValueCountFrequency (%)
5717
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 127
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 77785
89.1%
Common 9324
 
10.7%
Latin 199
 
0.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 7421
 
9.5%
용 4308
 
5.5%
주 3891
 
5.0%
변 3403
 
4.4%
팔 2930
 
3.8%
원 2804
 
3.6%
로 2677
 
3.4%
북 1360
 
1.7%
아 1327
 
1.7%
창 1320
 
1.7%
Other values (405) 46344
59.6%
Latin
ValueCountFrequency (%)
C 55
27.6%
I 40
20.1%
Y 37
18.6%
B 6
 
3.0%
A 6
 
3.0%
k 6
 
3.0%
T 5
 
2.5%
l 5
 
2.5%
c 4
 
2.0%
s 4
 
2.0%
Other values (17) 31
15.6%
Common
ValueCountFrequency (%)
5717
61.3%
2 548
 
5.9%
3 524
 
5.6%
1 523
 
5.6%
5 377
 
4.0%
7 352
 
3.8%
9 333
 
3.6%
6 241
 
2.6%
0 210
 
2.3%
8 184
 
2.0%
Other values (8) 315
 
3.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 77785
89.1%
ASCII 9523
 
10.9%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 7421
 
9.5%
용 4308
 
5.5%
주 3891
 
5.0%
변 3403
 
4.4%
팔 2930
 
3.8%
원 2804
 
3.6%
로 2677
 
3.4%
북 1360
 
1.7%
아 1327
 
1.7%
창 1320
 
1.7%
Other values (405) 46344
59.6%
ASCII
ValueCountFrequency (%)
5717
60.0%
2 548
 
5.8%
3 524
 
5.5%
1 523
 
5.5%
5 377
 
4.0%
7 352
 
3.7%
9 333
 
3.5%
6 241
 
2.5%
0 210
 
2.2%
8 184
 
1.9%
Other values (35) 514
 
5.4%

단속구분(단속장비)
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
CCTV
6892 
현장단속
2683 
주차민원
 
425

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowCCTV
2nd row주차민원
3rd rowCCTV
4th row현장단속
5th rowCCTV

Common Values

ValueCountFrequency (%)
CCTV 6892
68.9%
현장단속 2683
 
26.8%
주차민원 425
 
4.2%

Length

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

Common Values (Plot)

2023-12-11T07:58:39.152386image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
cctv 6892
68.9%
현장단속 2683
 
26.8%
주차민원 425
 
4.2%

Missing values

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

단속일자단속시간구청 구분단속장소명단속구분(단속장비)
280062017-06-2916:15의창구창원중앙역CCTV
46332017-02-0617:37의창구용호동 73주차민원
553002018-01-0320:37의창구북면근린공원앞CCTV
47102017-02-0714:25의창구팔용동 메리츠화재 주변현장단속
153522017-04-0720:52의창구용호동원이대로579번CCTV
564142018-01-1715:05의창구팔용동 숲속나라어린이집 주현장단속
652822018-03-2315:29의창구창원터미널CCTV
173182017-04-2214:47의창구팔용동 창원시외터미널 주변현장단속
365002017-08-2316:06의창구북면근린공원앞CCTV
185242017-05-0214:26의창구팔용동 경남테크노파크 주변현장단속
단속일자단속시간구청 구분단속장소명단속구분(단속장비)
583652018-01-3111:07의창구중동 메트로병원 주변현장단속
188642017-05-0417:38의창구팔용동주민센터주변CCTV
622672018-03-0414:21의창구팔용동 시외버스종합터미널현장단속
828792018-07-1616:32의창구봉곡동지귀로CCTV
14222017-01-1210:57의창구중동 새마을금고 주변현장단속
912342018-09-0311:23의창구팔용동창원대로363번CCTV
764332018-05-3014:40의창구팔용동벽산아파트주변CCTV
123452017-03-2216:40의창구팔용동 온누리주유소 주변현장단속
815352018-07-0815:01의창구창원중앙역CCTV
689192018-04-1310:10의창구북면근린공원앞CCTV

Duplicate rows

Most frequently occurring

단속일자단속시간구청 구분단속장소명단속구분(단속장비)# duplicates
3662018-10-019:47의창구용호동중앙대로CCTV6
212017-03-1519:10의창구팔용동사화로CCTV5
3242018-07-2018:26의창구사림동퇴촌로CCTV5
3412018-08-1715:39의창구사림동퇴촌로CCTV5
702017-08-0116:04의창구팔용동사화로18번길CCTV4
902017-09-0913:55의창구두대동창원천로94번길CCTV4
1882018-02-2320:02의창구도계동도계로CCTV4
1902018-02-2411:17의창구팔용동사화로CCTV4
2382018-04-138:08의창구도계동도계로CCTV4
2492018-04-2415:39의창구팔용동창원대로397번CCTV4