Overview

Dataset statistics

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

Variable types

DateTime2
Categorical2
Text1

Dataset

Description공공데이터 제공신청에 따른 창원시 불법주정차 단속 정보입니다.
Author경상남도 창원시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15100139

Alerts

Dataset has 233 (2.3%) duplicate rowsDuplicates
구청 구분 is highly overall correlated with 단속구분(단속장비)High correlation
단속구분(단속장비) is highly overall correlated with 구청 구분High correlation

Reproduction

Analysis started2023-12-10 23:25:16.814667
Analysis finished2023-12-10 23:25:17.641003
Duration0.83 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

단속일자
Date

Distinct140
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-01 00:00:00
Maximum2022-05-20 00:00:00
2023-12-11T08:25:17.738338image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:25:18.245059image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속시간
Date

Distinct1094
Distinct (%)10.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-11 00:01:00
Maximum2023-12-11 23:59:00
2023-12-11T08:25:18.405593image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T08:25:18.562878image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

구청 구분
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
성산구
2431 
마산합포구
2257 
의창구청
1993 
진해구
1801 
마산회원구
1518 

Length

Max length5
Median length4
Mean length3.9543
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row성산구
2nd row마산회원구
3rd row마산합포구
4th row진해구
5th row마산합포구

Common Values

ValueCountFrequency (%)
성산구 2431
24.3%
마산합포구 2257
22.6%
의창구청 1993
19.9%
진해구 1801
18.0%
마산회원구 1518
15.2%

Length

2023-12-11T08:25:18.725085image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T08:25:18.853898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
성산구 2431
24.3%
마산합포구 2257
22.6%
의창구청 1993
19.9%
진해구 1801
18.0%
마산회원구 1518
15.2%

단속장소명
Text

Distinct2352
Distinct (%)23.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T08:25:19.128033image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length33
Median length30
Mean length10.1466
Min length3

Characters and Unicode

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

Unique

Unique1542 ?
Unique (%)15.4%

Sample

1st row상남동 16 부근
2nd row삼계공영주차장앞
3rd row해운동드림베이대로
4th row용원동 복합공영주차타워
5th row해운동문화동15길
ValueCountFrequency (%)
주변 1163
 
6.6%
부근 969
 
5.5%
용원동 605
 
3.4%
횡단보도 349
 
2.0%
상남동 274
 
1.6%
대방동 271
 
1.5%
석동 228
 
1.3%
힐스테이트아티움시티1 202
 
1.1%
용동한마음병원주변 199
 
1.1%
용원 181
 
1.0%
Other values (2394) 13172
74.8%
2023-12-11T08:25:19.604157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7641
 
7.5%
동 7561
 
7.5%
주 4306
 
4.2%
변 3665
 
3.6%
원 2529
 
2.5%
부 2311
 
2.3%
1 2229
 
2.2%
근 2112
 
2.1%
용 2097
 
2.1%
로 1999
 
2.0%
Other values (514) 65016
64.1%

Most occurring categories

ValueCountFrequency (%)
Other Letter 82952
81.8%
Decimal Number 8508
 
8.4%
Space Separator 7641
 
7.5%
Dash Punctuation 808
 
0.8%
Open Punctuation 482
 
0.5%
Close Punctuation 474
 
0.5%
Uppercase Letter 466
 
0.5%
Other Punctuation 95
 
0.1%
Lowercase Letter 40
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 7561
 
9.1%
주 4306
 
5.2%
변 3665
 
4.4%
원 2529
 
3.0%
부 2311
 
2.8%
근 2112
 
2.5%
용 2097
 
2.5%
로 1999
 
2.4%
남 1679
 
2.0%
상 1254
 
1.5%
Other values (458) 53439
64.4%
Uppercase Letter
ValueCountFrequency (%)
Y 86
18.5%
C 70
15.0%
S 64
13.7%
G 45
9.7%
H 38
8.2%
L 35
7.5%
I 31
 
6.7%
K 22
 
4.7%
T 18
 
3.9%
N 16
 
3.4%
Other values (11) 41
8.8%
Lowercase Letter
ValueCountFrequency (%)
s 8
20.0%
k 8
20.0%
c 4
10.0%
e 3
 
7.5%
h 2
 
5.0%
n 2
 
5.0%
p 2
 
5.0%
t 1
 
2.5%
w 1
 
2.5%
b 1
 
2.5%
Other values (8) 8
20.0%
Decimal Number
ValueCountFrequency (%)
1 2229
26.2%
3 1275
15.0%
5 1036
12.2%
2 993
11.7%
4 624
 
7.3%
0 584
 
6.9%
6 554
 
6.5%
9 445
 
5.2%
7 431
 
5.1%
8 337
 
4.0%
Other Punctuation
ValueCountFrequency (%)
, 50
52.6%
· 41
43.2%
. 4
 
4.2%
Space Separator
ValueCountFrequency (%)
7641
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 808
100.0%
Open Punctuation
ValueCountFrequency (%)
( 482
100.0%
Close Punctuation
ValueCountFrequency (%)
) 474
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 82952
81.8%
Common 18008
 
17.7%
Latin 506
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 7561
 
9.1%
주 4306
 
5.2%
변 3665
 
4.4%
원 2529
 
3.0%
부 2311
 
2.8%
근 2112
 
2.5%
용 2097
 
2.5%
로 1999
 
2.4%
남 1679
 
2.0%
상 1254
 
1.5%
Other values (458) 53439
64.4%
Latin
ValueCountFrequency (%)
Y 86
17.0%
C 70
13.8%
S 64
12.6%
G 45
8.9%
H 38
7.5%
L 35
6.9%
I 31
 
6.1%
K 22
 
4.3%
T 18
 
3.6%
N 16
 
3.2%
Other values (29) 81
16.0%
Common
ValueCountFrequency (%)
7641
42.4%
1 2229
 
12.4%
3 1275
 
7.1%
5 1036
 
5.8%
2 993
 
5.5%
- 808
 
4.5%
4 624
 
3.5%
0 584
 
3.2%
6 554
 
3.1%
( 482
 
2.7%
Other values (7) 1782
 
9.9%

Most occurring blocks

ValueCountFrequency (%)
Hangul 82952
81.8%
ASCII 18473
 
18.2%
None 41
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7641
41.4%
1 2229
 
12.1%
3 1275
 
6.9%
5 1036
 
5.6%
2 993
 
5.4%
- 808
 
4.4%
4 624
 
3.4%
0 584
 
3.2%
6 554
 
3.0%
( 482
 
2.6%
Other values (45) 2247
 
12.2%
Hangul
ValueCountFrequency (%)
동 7561
 
9.1%
주 4306
 
5.2%
변 3665
 
4.4%
원 2529
 
3.0%
부 2311
 
2.8%
근 2112
 
2.5%
용 2097
 
2.5%
로 1999
 
2.4%
남 1679
 
2.0%
상 1254
 
1.5%
Other values (458) 53439
64.4%
None
ValueCountFrequency (%)
· 41
100.0%

단속구분(단속장비)
Categorical

HIGH CORRELATION 

Distinct18
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
CCTV
3472 
민원신고
1256 
고정형
1232 
cctv
1195 
이동식cctv
796 
Other values (13)
2049 

Length

Max length7
Median length4
Mean length4.1701
Min length2

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st row야간이동형
2nd rowCCTV
3rd row이동식cctv
4th rowCCTV
5th row이동식cctv

Common Values

ValueCountFrequency (%)
CCTV 3472
34.7%
민원신고 1256
 
12.6%
고정형 1232
 
12.3%
cctv 1195
 
11.9%
이동식cctv 796
 
8.0%
현장단속 343
 
3.4%
안전신문고 320
 
3.2%
주차민원 304
 
3.0%
1팀 256
 
2.6%
이동형 237
 
2.4%
Other values (8) 589
 
5.9%

Length

2023-12-11T08:25:19.754606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
cctv 4667
46.7%
민원신고 1256
 
12.6%
고정형 1232
 
12.3%
이동식cctv 796
 
8.0%
현장단속 343
 
3.4%
안전신문고 320
 
3.2%
주차민원 304
 
3.0%
1팀 256
 
2.6%
이동형 237
 
2.4%
야간이동형 225
 
2.2%
Other values (7) 364
 
3.6%

Correlations

2023-12-11T08:25:19.842641image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구청 구분단속구분(단속장비)
구청 구분1.0000.919
단속구분(단속장비)0.9191.000
2023-12-11T08:25:19.975583image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구청 구분단속구분(단속장비)
구청 구분1.0000.776
단속구분(단속장비)0.7761.000
2023-12-11T08:25:20.074105image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구청 구분단속구분(단속장비)
구청 구분1.0000.776
단속구분(단속장비)0.7761.000

Missing values

2023-12-11T08:25:17.438488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T08:25:17.568011image/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

단속일자단속시간구청 구분단속장소명단속구분(단속장비)
345152022-02-2519:36성산구상남동 16 부근야간이동형
557492022-03-2910:19마산회원구삼계공영주차장앞CCTV
75692022-01-1310:48마산합포구해운동드림베이대로이동식cctv
525282022-03-2418:18진해구용원동 복합공영주차타워CCTV
496742022-03-2110:18마산합포구해운동문화동15길이동식cctv
551052022-03-2815:53의창구청상남로이동형
267202022-02-1319:44의창구청중동어반브릭스앞고정형
425052022-03-1010:50마산합포구연세병원주변cctv
434112022-03-1111:49성산구신촌동유신상가부근CCTV
261862022-02-1211:10의창구청창원터미널고정형
단속일자단속시간구청 구분단속장소명단속구분(단속장비)
572902022-03-3122:06성산구대방동 372 교차로 모퉁이민원신고
188892022-01-3107:05마산회원구내서읍 안계초 버스정류장 주변주차민원
780582022-04-2709:08의창구청팔용동탑마트주변고정형
5752022-01-0219:07성산구대방동 355(경동프라자부근) 횡단보도민원신고
8812022-01-0314:42성산구상남동 지원빌딩 주변1팀
454222022-03-1415:20마산회원구국민은행동마산지점주변CCTV
739012022-04-2211:57마산합포구동성동 150-1주변민원신고
585662022-04-0114:57진해구경화동 조천로 부근CCTV
568662022-03-3015:47진해구경화동 조천로 부근CCTV
854152022-05-0814:56성산구중앙동 대흥인터빌 주변일요일1

Duplicate rows

Most frequently occurring

단속일자단속시간구청 구분단속장소명단속구분(단속장비)# duplicates
272022-01-1919:44성산구상남동 16 부근야간이동형4
282022-01-2010:13마산회원구합성남로CCTV4
802022-03-0615:51진해구용원동 용원동로 부근CCTV4
922022-03-1414:20마산합포구창포동3가신마산시장길이동식cctv4
1222022-03-2819:53성산구상남동 16 부근야간이동형4
1302022-03-3114:55진해구경화동 조천로 부근CCTV4
1382022-04-0215:22진해구경화동 조천북로 부근CCTV4
312022-01-2110:30마산회원구바냇들1길CCTV3
432022-01-2719:46성산구마디미공원 부근야간이동형3
502022-02-0719:44성산구상남동 16 부근야간이동형3