Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows379
Duplicate rows (%)3.8%
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 379 (3.8%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-10 22:58:40.649099
Analysis finished2023-12-10 22:58:41.387313
Duration0.74 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

단속일자
Date

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

단속시간
Date

Distinct792
Distinct (%)7.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-11 04:56:00
Maximum2023-12-11 23:10:00
2023-12-11T07:58:41.669667image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:58:41.811831image/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:41.926639image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

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

단속장소명
Text

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

Length

Max length17
Median length15
Mean length8.7514
Min length3

Characters and Unicode

Total characters87514
Distinct characters476
Distinct categories10 ?
Distinct scripts3 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique681 ?
Unique (%)6.8%

Sample

1st row팔용동창원대로397번
2nd row창원중앙역
3rd row북면근린공원앞
4th row도계동원이대로82번길
5th row서상동평산로211번길
ValueCountFrequency (%)
주변 2496
 
15.8%
북면근린공원앞 763
 
4.8%
팔용동 612
 
3.9%
용호동 531
 
3.4%
창원중앙역 355
 
2.3%
봉곡동봉곡삼거리 307
 
1.9%
도계초등학교 300
 
1.9%
팔용동주민센터주변 269
 
1.7%
봉곡동 261
 
1.7%
팔용동사화로 258
 
1.6%
Other values (1180) 9602
60.9%
2023-12-11T07:58:42.509079image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 7482
 
8.5%
5780
 
6.6%
용 4242
 
4.8%
주 3865
 
4.4%
변 3410
 
3.9%
팔 2805
 
3.2%
로 2696
 
3.1%
원 2685
 
3.1%
봉 1351
 
1.5%
아 1349
 
1.5%
Other values (466) 51849
59.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 78073
89.2%
Space Separator 5780
 
6.6%
Decimal Number 3261
 
3.7%
Uppercase Letter 200
 
0.2%
Dash Punctuation 122
 
0.1%
Lowercase Letter 33
 
< 0.1%
Open Punctuation 15
 
< 0.1%
Close Punctuation 15
 
< 0.1%
Other Punctuation 14
 
< 0.1%
Math Symbol 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 7482
 
9.6%
용 4242
 
5.4%
주 3865
 
5.0%
변 3410
 
4.4%
팔 2805
 
3.6%
로 2696
 
3.5%
원 2685
 
3.4%
봉 1351
 
1.7%
아 1349
 
1.7%
북 1344
 
1.7%
Other values (420) 46844
60.0%
Uppercase Letter
ValueCountFrequency (%)
C 58
29.0%
Y 44
22.0%
I 35
17.5%
B 15
 
7.5%
K 10
 
5.0%
G 9
 
4.5%
S 8
 
4.0%
T 7
 
3.5%
A 6
 
3.0%
U 2
 
1.0%
Other values (6) 6
 
3.0%
Lowercase Letter
ValueCountFrequency (%)
c 6
18.2%
t 4
12.1%
x 4
12.1%
l 3
9.1%
i 3
9.1%
k 3
9.1%
s 3
9.1%
u 2
 
6.1%
b 2
 
6.1%
g 2
 
6.1%
Decimal Number
ValueCountFrequency (%)
2 516
15.8%
3 511
15.7%
1 487
14.9%
5 356
10.9%
9 325
10.0%
7 283
8.7%
6 255
7.8%
8 220
6.7%
0 199
 
6.1%
4 109
 
3.3%
Open Punctuation
ValueCountFrequency (%)
( 13
86.7%
[ 2
 
13.3%
Close Punctuation
ValueCountFrequency (%)
) 13
86.7%
] 2
 
13.3%
Other Punctuation
ValueCountFrequency (%)
. 10
71.4%
& 4
 
28.6%
Space Separator
ValueCountFrequency (%)
5780
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 122
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 78073
89.2%
Common 9208
 
10.5%
Latin 233
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 7482
 
9.6%
용 4242
 
5.4%
주 3865
 
5.0%
변 3410
 
4.4%
팔 2805
 
3.6%
로 2696
 
3.5%
원 2685
 
3.4%
봉 1351
 
1.7%
아 1349
 
1.7%
북 1344
 
1.7%
Other values (420) 46844
60.0%
Latin
ValueCountFrequency (%)
C 58
24.9%
Y 44
18.9%
I 35
15.0%
B 15
 
6.4%
K 10
 
4.3%
G 9
 
3.9%
S 8
 
3.4%
T 7
 
3.0%
c 6
 
2.6%
A 6
 
2.6%
Other values (17) 35
15.0%
Common
ValueCountFrequency (%)
5780
62.8%
2 516
 
5.6%
3 511
 
5.5%
1 487
 
5.3%
5 356
 
3.9%
9 325
 
3.5%
7 283
 
3.1%
6 255
 
2.8%
8 220
 
2.4%
0 199
 
2.2%
Other values (9) 276
 
3.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 78073
89.2%
ASCII 9441
 
10.8%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 7482
 
9.6%
용 4242
 
5.4%
주 3865
 
5.0%
변 3410
 
4.4%
팔 2805
 
3.6%
로 2696
 
3.5%
원 2685
 
3.4%
봉 1351
 
1.7%
아 1349
 
1.7%
북 1344
 
1.7%
Other values (420) 46844
60.0%
ASCII
ValueCountFrequency (%)
5780
61.2%
2 516
 
5.5%
3 511
 
5.4%
1 487
 
5.2%
5 356
 
3.8%
9 325
 
3.4%
7 283
 
3.0%
6 255
 
2.7%
8 220
 
2.3%
0 199
 
2.1%
Other values (36) 509
 
5.4%

단속구분(단속장비)
Categorical

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

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
CCTV 6898
69.0%
현장단속 2735
 
27.4%
주차민원 367
 
3.7%

Length

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

Common Values (Plot)

2023-12-11T07:58:42.705439image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
cctv 6898
69.0%
현장단속 2735
 
27.4%
주차민원 367
 
3.7%

Missing values

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

단속일자단속시간구청 구분단속장소명단속구분(단속장비)
459392017-10-2410:59의창구팔용동창원대로397번CCTV
787162018-06-1613:42의창구창원중앙역CCTV
795482018-06-2214:46의창구북면근린공원앞CCTV
899302018-08-2419:54의창구도계동원이대로82번길CCTV
403582017-09-1308:59의창구서상동평산로211번길CCTV
156842017-04-1115:58의창구용지호수CCTV
428892017-09-2611:14의창구창원터미날CCTV
709932018-04-2610:42의창구대원동두대로CCTV
878862018-08-1109:29의창구팔용동탑마트CCTV
442632017-10-1320:43의창구북면근린공원앞CCTV
단속일자단속시간구청 구분단속장소명단속구분(단속장비)
402082017-09-1208:50의창구용지공원앞 한국자유총연맹앞주차민원
669792018-04-0307:53의창구팔용동반계로CCTV
140992017-03-3020:10의창구봉림동태복산로CCTV
259612017-06-1910:44의창구도계동보훈회관주변CCTV
456262017-10-2307:51의창구도계동도계두리길CCTV
565682018-01-1715:44의창구북면근린공원앞CCTV
144262017-04-0316:54의창구대원동 시티세븐 주변현장단속
868212018-08-0715:22의창구대원동 시티세븐 주변현장단속
264112017-06-2119:26의창구팔용동주민센터주변CCTV
344652017-08-0815:04의창구봉곡동 코오롱아파트 주변현장단속

Duplicate rows

Most frequently occurring

단속일자단속시간구청 구분단속장소명단속구분(단속장비)# duplicates
2232018-03-3017:44의창구용호동중앙대로CCTV5
282017-03-2220:39의창구도계동원이대로56번길CCTV4
312017-03-2420:42의창구도계동원이대로56번길CCTV4
452017-05-1820:47의창구도계동원이대로56번길CCTV4
2342018-04-1107:34의창구용호동외동반림로CCTV4
2362018-04-1215:25의창구사림동퇴촌로CCTV4
2442018-04-1710:57의창구팔용동무역로549번길CCTV4
3022018-06-1715:56의창구대원동원이대로CCTV4
3782018-10-0109:47의창구용호동중앙대로CCTV4
232017-03-1519:08의창구팔용동사화로CCTV3