Overview

Dataset statistics

Number of variables5
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows230
Duplicate rows (%)2.3%
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://www.data.go.kr/data/15064342/fileData.do

Alerts

Dataset has 230 (2.3%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 21:41:52.840882
Analysis finished2023-12-12 21:41:53.454676
Duration0.61 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-13T06:41:53.821210image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:41:53.963982image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속시간
Date

Distinct891
Distinct (%)8.9%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-13 00:05:00
Maximum2023-12-13 23:20:00
2023-12-13T06:41:54.099315image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:41:54.225830image/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
마산회원구
2568 
의창구
2389 
성산구
2178 
마산합포구
2104 
진해구
761 

Length

Max length5
Median length3
Mean length3.9344
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
마산회원구 2568
25.7%
의창구 2389
23.9%
성산구 2178
21.8%
마산합포구 2104
21.0%
진해구 761
 
7.6%

Length

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

Common Values (Plot)

2023-12-13T06:41:54.524464image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
마산회원구 2568
25.7%
의창구 2389
23.9%
성산구 2178
21.8%
마산합포구 2104
21.0%
진해구 761
 
7.6%

단속장소명
Text

Distinct1856
Distinct (%)18.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T06:41:54.766150image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length20
Mean length9.1043
Min length3

Characters and Unicode

Total characters91043
Distinct characters527
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

Unique1026 ?
Unique (%)10.3%

Sample

1st row양덕동 경남은행건너편 주변
2nd row산호동합포로
3rd row오동동회원천북길
4th row중앙동경남오피스텔
5th row동성신호대주변
ValueCountFrequency (%)
주변 2623
 
15.8%
상남동 542
 
3.3%
팔용동 240
 
1.4%
용원동 229
 
1.4%
북면근린공원앞 191
 
1.1%
양덕2동사거리 165
 
1.0%
중앙동 139
 
0.8%
용호동 138
 
0.8%
부근 132
 
0.8%
팔용동주민센터주변 127
 
0.8%
Other values (1821) 12097
72.8%
2023-12-13T06:41:55.204421image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
동 7679
 
8.4%
6639
 
7.3%
주 5357
 
5.9%
변 4665
 
5.1%
원 2040
 
2.2%
로 1832
 
2.0%
남 1776
 
2.0%
용 1588
 
1.7%
상 1497
 
1.6%
산 1320
 
1.4%
Other values (517) 56650
62.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 80332
88.2%
Space Separator 6639
 
7.3%
Decimal Number 3196
 
3.5%
Uppercase Letter 394
 
0.4%
Dash Punctuation 138
 
0.2%
Other Punctuation 133
 
0.1%
Open Punctuation 126
 
0.1%
Close Punctuation 70
 
0.1%
Lowercase Letter 15
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 7679
 
9.6%
주 5357
 
6.7%
변 4665
 
5.8%
원 2040
 
2.5%
로 1832
 
2.3%
남 1776
 
2.2%
용 1588
 
2.0%
상 1497
 
1.9%
산 1320
 
1.6%
리 1053
 
1.3%
Other values (468) 51525
64.1%
Uppercase Letter
ValueCountFrequency (%)
H 101
25.6%
M 88
22.3%
C 44
11.2%
Y 30
 
7.6%
S 22
 
5.6%
I 21
 
5.3%
A 18
 
4.6%
K 15
 
3.8%
U 14
 
3.6%
G 12
 
3.0%
Other values (10) 29
 
7.4%
Decimal Number
ValueCountFrequency (%)
1 818
25.6%
2 616
19.3%
3 571
17.9%
5 412
12.9%
6 158
 
4.9%
7 157
 
4.9%
4 142
 
4.4%
0 124
 
3.9%
9 106
 
3.3%
8 92
 
2.9%
Lowercase Letter
ValueCountFrequency (%)
g 3
20.0%
t 3
20.0%
k 3
20.0%
i 1
 
6.7%
c 1
 
6.7%
v 1
 
6.7%
s 1
 
6.7%
b 1
 
6.7%
y 1
 
6.7%
Other Punctuation
ValueCountFrequency (%)
· 125
94.0%
, 6
 
4.5%
. 1
 
0.8%
& 1
 
0.8%
Open Punctuation
ValueCountFrequency (%)
( 121
96.0%
[ 5
 
4.0%
Close Punctuation
ValueCountFrequency (%)
) 69
98.6%
] 1
 
1.4%
Space Separator
ValueCountFrequency (%)
6639
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 138
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 80332
88.2%
Common 10302
 
11.3%
Latin 409
 
0.4%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 7679
 
9.6%
주 5357
 
6.7%
변 4665
 
5.8%
원 2040
 
2.5%
로 1832
 
2.3%
남 1776
 
2.2%
용 1588
 
2.0%
상 1497
 
1.9%
산 1320
 
1.6%
리 1053
 
1.3%
Other values (468) 51525
64.1%
Latin
ValueCountFrequency (%)
H 101
24.7%
M 88
21.5%
C 44
10.8%
Y 30
 
7.3%
S 22
 
5.4%
I 21
 
5.1%
A 18
 
4.4%
K 15
 
3.7%
U 14
 
3.4%
G 12
 
2.9%
Other values (19) 44
10.8%
Common
ValueCountFrequency (%)
6639
64.4%
1 818
 
7.9%
2 616
 
6.0%
3 571
 
5.5%
5 412
 
4.0%
6 158
 
1.5%
7 157
 
1.5%
4 142
 
1.4%
- 138
 
1.3%
· 125
 
1.2%
Other values (10) 526
 
5.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 80332
88.2%
ASCII 10586
 
11.6%
None 125
 
0.1%

Most frequent character per block

Hangul
ValueCountFrequency (%)
동 7679
 
9.6%
주 5357
 
6.7%
변 4665
 
5.8%
원 2040
 
2.5%
로 1832
 
2.3%
남 1776
 
2.2%
용 1588
 
2.0%
상 1497
 
1.9%
산 1320
 
1.6%
리 1053
 
1.3%
Other values (468) 51525
64.1%
ASCII
ValueCountFrequency (%)
6639
62.7%
1 818
 
7.7%
2 616
 
5.8%
3 571
 
5.4%
5 412
 
3.9%
6 158
 
1.5%
7 157
 
1.5%
4 142
 
1.3%
- 138
 
1.3%
0 124
 
1.2%
Other values (38) 811
 
7.7%
None
ValueCountFrequency (%)
· 125
100.0%

단속구분(단속장비)
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
CCTV
6981 
현장단속
2697 
주차민원
 
321
<NA>
 
1

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
CCTV 6981
69.8%
현장단속 2697
 
27.0%
주차민원 321
 
3.2%
<NA> 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-13T06:41:55.474144image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
cctv 6981
69.8%
현장단속 2697
 
27.0%
주차민원 321
 
3.2%
na 1
 
< 0.1%

Correlations

2023-12-13T06:41:55.552522image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구청 구분단속구분(단속장비)
구청 구분1.0000.491
단속구분(단속장비)0.4911.000
2023-12-13T06:41:55.634113image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구청 구분단속구분(단속장비)
구청 구분1.0000.425
단속구분(단속장비)0.4251.000
2023-12-13T06:41:55.720537image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
구청 구분단속구분(단속장비)
구청 구분1.0000.425
단속구분(단속장비)0.4251.000

Missing values

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

단속일자단속시간구청 구분단속장소명단속구분(단속장비)
130522017-01-1914:11마산회원구양덕동 경남은행건너편 주변CCTV
853192017-05-1810:28마산합포구산호동합포로CCTV
581182017-03-3110:38마산합포구오동동회원천북길CCTV
359752017-02-2713:44성산구중앙동경남오피스텔CCTV
195952017-02-0209:55마산합포구동성신호대주변CCTV
403142017-03-0616:29성산구상남동 위드빌딩 주변현장단속
455522017-03-1319:34진해구이동 염전사거리 Lg전자 주변현장단속
861382017-05-1917:37성산구대암로 부근CCTV
112312017-01-1717:03성산구대방동와이몰CCTV
393132017-03-0320:56마산회원구시외버스터미널건너편주CCTV
단속일자단속시간구청 구분단속장소명단속구분(단속장비)
451822017-03-1311:14마산합포구월영동가포로CCTV
787892017-05-0810:46마산합포구오동동오동동15길CCTV
559152017-03-2814:07마산회원구양덕로CCTV
937902017-05-3016:14성산구가음정119안전센터0CCTV
563182017-03-2914:04성산구상남동 리베라컨벤션 주변현장단속
882942017-05-2315:04의창구용지호수CCTV
848452017-05-1813:44의창구북면근린공원앞CCTV
440842017-03-1020:16마산회원구석전초등학교주변CCTV
190292017-02-0108:16진해구용원동 안청초등학교 주변현장단속
101062017-01-1611:29성산구상남동 칠성상가 주변현장단속

Duplicate rows

Most frequently occurring

단속일자단속시간구청 구분단속장소명단속구분(단속장비)# duplicates
802017-02-2009:56마산합포구산호동산호동로CCTV4
1002017-03-0808:19의창구북면감계로140번길CCTV4
1282017-03-2115:07마산합포구진동면신서촌로CCTV4
112017-01-0610:20마산회원구금강로CCTV3
252017-01-1615:26마산회원구합성남로CCTV3
282017-01-1716:08마산회원구합성남로CCTV3
342017-01-1815:00마산합포구창포동3가문화동13길CCTV3
412017-01-2019:28마산합포구해운동월영동4길CCTV3
592017-02-0607:41의창구명서동명서로CCTV3
642017-02-1007:48의창구봉곡동봉곡로CCTV3