Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows217
Duplicate rows (%)2.2%
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

Dataset has 217 (2.2%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-10 22:58:44.107381
Analysis finished2023-12-10 22:58:44.726598
Duration0.62 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

단속일자
Date

Distinct151
Distinct (%)1.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-01-01 00:00:00
Maximum2017-05-31 00:00:00
2023-12-11T07:58:44.793208image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:58:44.931836image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속시간
Date

Distinct888
Distinct (%)8.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-11 00:05:00
Maximum2023-12-11 23:18:00
2023-12-11T07:58:45.119737image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T07:58:45.276716image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

구청 구분
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
마산회원구
2612 
의창구
2322 
성산구
2215 
마산합포구
2095 
진해구
756 

Length

Max length5
Median length3
Mean length3.9414
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row의창구
2nd row의창구
3rd row마산합포구
4th row성산구
5th row성산구

Common Values

ValueCountFrequency (%)
마산회원구 2612
26.1%
의창구 2322
23.2%
성산구 2215
22.1%
마산합포구 2095
20.9%
진해구 756
 
7.6%

Length

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

Common Values (Plot)

2023-12-11T07:58:45.534019image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마산회원구 2612
26.1%
의창구 2322
23.2%
성산구 2215
22.1%
마산합포구 2095
20.9%
진해구 756
 
7.6%

단속장소명
Text

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

Length

Max length25
Median length19
Mean length9.0794
Min length3

Characters and Unicode

Total characters90794
Distinct characters502
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

Unique975 ?
Unique (%)9.8%

Sample

1st row명서동명서로
2nd row팔용동파티마빌딩사거리
3rd row산호교차로주변
4th row상남동한사랑빌딩
5th row상남동 유탑빌딩 주변
ValueCountFrequency (%)
주변 2639
 
15.9%
상남동 595
 
3.6%
용원동 223
 
1.3%
북면근린공원앞 213
 
1.3%
팔용동 211
 
1.3%
양덕2동사거리 181
 
1.1%
중앙동 150
 
0.9%
용호동 144
 
0.9%
팔용동주민센터주변 142
 
0.9%
시외버스터미널건너편주 126
 
0.8%
Other values (1769) 11989
72.2%
2023-12-11T07:58:46.150851image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 7680
 
8.5%
6626
 
7.3%
주 5382
 
5.9%
변 4651
 
5.1%
원 2050
 
2.3%
로 1802
 
2.0%
남 1785
 
2.0%
상 1543
 
1.7%
용 1530
 
1.7%
산 1291
 
1.4%
Other values (492) 56454
62.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 80132
88.3%
Space Separator 6626
 
7.3%
Decimal Number 3142
 
3.5%
Uppercase Letter 396
 
0.4%
Dash Punctuation 147
 
0.2%
Other Punctuation 138
 
0.2%
Open Punctuation 121
 
0.1%
Close Punctuation 77
 
0.1%
Lowercase Letter 15
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 7680
 
9.6%
주 5382
 
6.7%
변 4651
 
5.8%
원 2050
 
2.6%
로 1802
 
2.2%
남 1785
 
2.2%
상 1543
 
1.9%
용 1530
 
1.9%
산 1291
 
1.6%
리 1060
 
1.3%
Other values (446) 51358
64.1%
Uppercase Letter
ValueCountFrequency (%)
H 96
24.2%
M 78
19.7%
C 42
10.6%
S 33
 
8.3%
Y 31
 
7.8%
A 28
 
7.1%
I 20
 
5.1%
U 13
 
3.3%
G 12
 
3.0%
K 10
 
2.5%
Other values (9) 33
 
8.3%
Decimal Number
ValueCountFrequency (%)
1 811
25.8%
2 637
20.3%
3 541
17.2%
5 355
11.3%
4 168
 
5.3%
6 166
 
5.3%
7 144
 
4.6%
0 136
 
4.3%
9 95
 
3.0%
8 89
 
2.8%
Lowercase Letter
ValueCountFrequency (%)
t 5
33.3%
k 3
20.0%
x 2
 
13.3%
s 2
 
13.3%
c 1
 
6.7%
b 1
 
6.7%
u 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
· 122
88.4%
, 11
 
8.0%
& 3
 
2.2%
. 2
 
1.4%
Open Punctuation
ValueCountFrequency (%)
( 115
95.0%
[ 6
 
5.0%
Close Punctuation
ValueCountFrequency (%)
) 76
98.7%
] 1
 
1.3%
Space Separator
ValueCountFrequency (%)
6626
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 147
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 80132
88.3%
Common 10251
 
11.3%
Latin 411
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 7680
 
9.6%
주 5382
 
6.7%
변 4651
 
5.8%
원 2050
 
2.6%
로 1802
 
2.2%
남 1785
 
2.2%
상 1543
 
1.9%
용 1530
 
1.9%
산 1291
 
1.6%
리 1060
 
1.3%
Other values (446) 51358
64.1%
Latin
ValueCountFrequency (%)
H 96
23.4%
M 78
19.0%
C 42
10.2%
S 33
 
8.0%
Y 31
 
7.5%
A 28
 
6.8%
I 20
 
4.9%
U 13
 
3.2%
G 12
 
2.9%
K 10
 
2.4%
Other values (16) 48
11.7%
Common
ValueCountFrequency (%)
6626
64.6%
1 811
 
7.9%
2 637
 
6.2%
3 541
 
5.3%
5 355
 
3.5%
4 168
 
1.6%
6 166
 
1.6%
- 147
 
1.4%
7 144
 
1.4%
0 136
 
1.3%
Other values (10) 520
 
5.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 80132
88.3%
ASCII 10540
 
11.6%
None 122
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 7680
 
9.6%
주 5382
 
6.7%
변 4651
 
5.8%
원 2050
 
2.6%
로 1802
 
2.2%
남 1785
 
2.2%
상 1543
 
1.9%
용 1530
 
1.9%
산 1291
 
1.6%
리 1060
 
1.3%
Other values (446) 51358
64.1%
ASCII
ValueCountFrequency (%)
6626
62.9%
1 811
 
7.7%
2 637
 
6.0%
3 541
 
5.1%
5 355
 
3.4%
4 168
 
1.6%
6 166
 
1.6%
- 147
 
1.4%
7 144
 
1.4%
0 136
 
1.3%
Other values (35) 809
 
7.7%
None
ValueCountFrequency (%)
· 122
100.0%

단속구분(단속장비)
Categorical

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

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st rowCCTV
2nd rowCCTV
3rd rowCCTV
4th rowCCTV
5th row현장단속

Common Values

ValueCountFrequency (%)
CCTV 6963
69.6%
현장단속 2698
 
27.0%
주차민원 339
 
3.4%

Length

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

Common Values (Plot)

2023-12-11T07:58:46.342581image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
cctv 6963
69.6%
현장단속 2698
 
27.0%
주차민원 339
 
3.4%

Correlations

2023-12-11T07:58:46.393749image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구청 구분단속구분(단속장비)
구청 구분1.0000.499
단속구분(단속장비)0.4991.000
2023-12-11T07:58:46.462909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속구분(단속장비)구청 구분
단속구분(단속장비)1.0000.434
구청 구분0.4341.000
2023-12-11T07:58:46.531314image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구청 구분단속구분(단속장비)
구청 구분1.0000.434
단속구분(단속장비)0.4341.000

Missing values

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

단속일자단속시간구청 구분단속장소명단속구분(단속장비)
280492017-02-157:41의창구명서동명서로CCTV
649142017-04-139:58의창구팔용동파티마빌딩사거리CCTV
828262017-05-157:26마산합포구산호교차로주변CCTV
527072017-03-2315:09성산구상남동한사랑빌딩CCTV
657402017-04-1420:44성산구상남동 유탑빌딩 주변현장단속
263682017-02-137:22성산구대방동 덕산1차아파트 주변현장단속
75332017-01-1116:34진해구풍호동 한림리츠빌 주변현장단속
218392017-02-0614:05마산회원구석전동 365병원주변 인도주차민원
776052017-05-0418:49진해구풍호동 농협CCTV
216002017-02-0616:30성산구상남동두바빌딩CCTV
단속일자단속시간구청 구분단속장소명단속구분(단속장비)
85192017-01-1315:06의창구명서동 설화빙수 주변현장단속
944652017-05-319:23의창구경남과학기술진흥원CCTV
817812017-05-139:35성산구상남동 상남오거리 주변현장단속
749542017-05-0111:18의창구창원터미날CCTV
77902017-01-1214:08성산구상남동 신우주차빌딩 주변현장단속
287442017-02-1515:48마산회원구양덕동84-13CCTV
440892017-03-1021:10마산회원구시외버스터미널건너편주CCTV
493072017-03-1821:46마산회원구삼계사거리주변CCTV
681092017-04-1916:33의창구중동 새마을금고 주변현장단속
687342017-04-1916:10진해구용원동 안청초등학교 주변현장단속

Duplicate rows

Most frequently occurring

단속일자단속시간구청 구분단속장소명단속구분(단속장비)# duplicates
532017-02-0210:16마산회원구합성동금강로CCTV4
1212017-03-1420:26의창구도계동원이대로56번길CCTV4
42017-01-0414:18마산회원구합성남로CCTV3
122017-01-0915:28마산합포구창포동3가문화동13길CCTV3
442017-01-3114:18마산회원구내서읍삼계6길CCTV3
722017-02-1014:16마산회원구내서읍삼계6길CCTV3
1042017-03-0320:13의창구용호동용지로153번길CCTV3
1122017-03-0820:49의창구도계동원이대로56번길CCTV3
1182017-03-1314:46마산회원구광려천서로CCTV3
1482017-03-3114:24의창구사림동사림로CCTV3