Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows185
Duplicate rows (%)1.8%
Total size in memory546.9 KiB
Average record size in memory56.0 B

Variable types

Categorical3
Text1
DateTime2

Dataset

Description경상남도 거제시 불법주정차단속정보현황(단속일자, 단속시간, 시군구, 단속장소명, 단속구분, 기준일자)등에 대한 정보를 제공합니다.
Author경상남도 거제시
URLhttps://bigdata.gyeongnam.go.kr/index.gn?menuCd=DOM_000000114002001000&publicdatapk=15087238

Alerts

시군명 has constant value ""Constant
기준일자 has constant value ""Constant
Dataset has 185 (1.8%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-11 00:52:19.926423
Analysis finished2023-12-11 00:52:20.521118
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
경상남도 거제시
10000 

Length

Max length8
Median length8
Mean length8
Min length8

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

Common Values (Plot)

2023-12-11T09:52:20.656066image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경상남도 10000
50.0%
거제시 10000
50.0%

단속장소명
Text

Distinct2261
Distinct (%)22.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-11T09:52:20.839914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length24
Median length20
Mean length13.4484
Min length5

Characters and Unicode

Total characters134484
Distinct characters362
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

Unique1392 ?
Unique (%)13.9%

Sample

1st row능포 옥수공영주차장CCTV
2nd row고현홍콩반점사거리CCTV
3rd row장평동 장평1로10길
4th row장평동 피솔길
5th row옥포동 옥포중앙로
ValueCountFrequency (%)
고현동 3546
 
16.4%
cctv 1322
 
6.1%
장평동 1287
 
6.0%
아주동 1161
 
5.4%
옥포동 1053
 
4.9%
옥포 498
 
2.3%
앞 479
 
2.2%
고현 398
 
1.8%
공영주차장 386
 
1.8%
상동동 305
 
1.4%
Other values (2259) 11189
51.7%
2023-12-11T09:52:21.227196image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11635
 
8.7%
동 8368
 
6.2%
고 7463
 
5.5%
( 6979
 
5.2%
) 6787
 
5.0%
C 6163
 
4.6%
현 4418
 
3.3%
1 3852
 
2.9%
로 3228
 
2.4%
주 3182
 
2.4%
Other values (352) 72409
53.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 78346
58.3%
Decimal Number 16633
 
12.4%
Uppercase Letter 12253
 
9.1%
Space Separator 11635
 
8.7%
Open Punctuation 6979
 
5.2%
Close Punctuation 6787
 
5.0%
Dash Punctuation 1764
 
1.3%
Lowercase Letter 80
 
0.1%
Other Punctuation 7
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 8368
 
10.7%
고 7463
 
9.5%
현 4418
 
5.6%
로 3228
 
4.1%
주 3182
 
4.1%
시 3137
 
4.0%
신 3104
 
4.0%
민 2992
 
3.8%
포 2733
 
3.5%
장 2705
 
3.5%
Other values (328) 37016
47.2%
Decimal Number
ValueCountFrequency (%)
1 3852
23.2%
2 2606
15.7%
3 2066
12.4%
4 1289
 
7.7%
9 1250
 
7.5%
0 1184
 
7.1%
7 1134
 
6.8%
6 1132
 
6.8%
5 1103
 
6.6%
8 1017
 
6.1%
Uppercase Letter
ValueCountFrequency (%)
C 6163
50.3%
T 3082
25.2%
V 2991
24.4%
K 12
 
0.1%
G 2
 
< 0.1%
S 1
 
< 0.1%
L 1
 
< 0.1%
U 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
11635
100.0%
Open Punctuation
ValueCountFrequency (%)
( 6979
100.0%
Close Punctuation
ValueCountFrequency (%)
) 6787
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1764
100.0%
Lowercase Letter
ValueCountFrequency (%)
e 80
100.0%
Other Punctuation
ValueCountFrequency (%)
, 7
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 78346
58.3%
Common 43805
32.6%
Latin 12333
 
9.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 8368
 
10.7%
고 7463
 
9.5%
현 4418
 
5.6%
로 3228
 
4.1%
주 3182
 
4.1%
시 3137
 
4.0%
신 3104
 
4.0%
민 2992
 
3.8%
포 2733
 
3.5%
장 2705
 
3.5%
Other values (328) 37016
47.2%
Common
ValueCountFrequency (%)
11635
26.6%
( 6979
15.9%
) 6787
15.5%
1 3852
 
8.8%
2 2606
 
5.9%
3 2066
 
4.7%
- 1764
 
4.0%
4 1289
 
2.9%
9 1250
 
2.9%
0 1184
 
2.7%
Other values (5) 4393
 
10.0%
Latin
ValueCountFrequency (%)
C 6163
50.0%
T 3082
25.0%
V 2991
24.3%
e 80
 
0.6%
K 12
 
0.1%
G 2
 
< 0.1%
S 1
 
< 0.1%
L 1
 
< 0.1%
U 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 78346
58.3%
ASCII 56138
41.7%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11635
20.7%
( 6979
12.4%
) 6787
12.1%
C 6163
11.0%
1 3852
 
6.9%
T 3082
 
5.5%
V 2991
 
5.3%
2 2606
 
4.6%
3 2066
 
3.7%
- 1764
 
3.1%
Other values (14) 8213
14.6%
Hangul
ValueCountFrequency (%)
동 8368
 
10.7%
고 7463
 
9.5%
현 4418
 
5.6%
로 3228
 
4.1%
주 3182
 
4.1%
시 3137
 
4.0%
신 3104
 
4.0%
민 2992
 
3.8%
포 2733
 
3.5%
장 2705
 
3.5%
Other values (328) 37016
47.2%

단속일자
Date

Distinct364
Distinct (%)3.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 00:00:00
Maximum2021-12-31 00:00:00
2023-12-11T09:52:21.373431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:21.542086image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속시간
Date

Distinct977
Distinct (%)9.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-11 00:00:00
Maximum2023-12-11 23:56:00
2023-12-11T09:52:21.689741image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-11T09:52:21.802041image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속구분
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
CCTV
6421 
시민신고
3043 
교통과
 
520
교통행정과
 
16

Length

Max length5
Median length4
Mean length3.9496
Min length3

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
CCTV 6421
64.2%
시민신고 3043
30.4%
교통과 520
 
5.2%
교통행정과 16
 
0.2%

Length

2023-12-11T09:52:21.994606image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:52:22.128784image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
cctv 6421
64.2%
시민신고 3043
30.4%
교통과 520
 
5.2%
교통행정과 16
 
0.2%

기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-09-04
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-09-04
2nd row2023-09-04
3rd row2023-09-04
4th row2023-09-04
5th row2023-09-04

Common Values

ValueCountFrequency (%)
2023-09-04 10000
100.0%

Length

2023-12-11T09:52:22.540082image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-11T09:52:22.664449image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-09-04 10000
100.0%

Missing values

2023-12-11T09:52:20.362837image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-11T09:52:20.466431image/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

시군명단속장소명단속일자단속시간단속구분기준일자
16773경상남도 거제시능포 옥수공영주차장CCTV2021-06-2618:07CCTV2023-09-04
19293경상남도 거제시고현홍콩반점사거리CCTV2021-07-1413:53CCTV2023-09-04
7580경상남도 거제시장평동 장평1로10길2021-04-1214:43CCTV2023-09-04
30503경상남도 거제시장평동 피솔길2021-10-1910:42CCTV2023-09-04
18463경상남도 거제시옥포동 옥포중앙로2021-07-0810:18CCTV2023-09-04
6231경상남도 거제시고현동 거제중앙로31길(곡2021-03-2910:53CCTV2023-09-04
27304경상남도 거제시장평동 319-9(시민신고)(복)2021-09-2010:48시민신고2023-09-04
2905경상남도 거제시아주동 아주1로2021-02-1610:04CCTV2023-09-04
10274경상남도 거제시능포 옥수시장주변 CCTV2021-05-0613:07CCTV2023-09-04
10895경상남도 거제시고현거제중앙병원 CCTV2021-05-1117:31CCTV2023-09-04
시군명단속장소명단속일자단속시간단속구분기준일자
22959경상남도 거제시고현 거제중앙병원CCTV2021-08-129:45CCTV2023-09-04
34978경상남도 거제시옥포 e편한 사거리 CCTV2021-11-1917:27CCTV2023-09-04
4679경상남도 거제시고현동 거제중앙로26길2021-03-1210:04CCTV2023-09-04
19354경상남도 거제시장평동 장평3로6길(복)2021-07-1514:07CCTV2023-09-04
16024경상남도 거제시고현동 거제아동병원CCTV2021-06-2116:01CCTV2023-09-04
40088경상남도 거제시수월동 수양로(횡단)2021-12-2415:09CCTV2023-09-04
35539경상남도 거제시고현동 로망헤어2021-11-2310:30교통과2023-09-04
22317경상남도 거제시고현동 755-49(시민신고)(곡)2021-08-0714:46시민신고2023-09-04
2708경상남도 거제시고현 수협사거리 CCTV2021-02-1019:29CCTV2023-09-04
15046경상남도 거제시고현동 서울삼겹살2021-06-1415:28교통과2023-09-04

Duplicate rows

Most frequently occurring

시군명단속장소명단속일자단속시간단속구분기준일자# duplicates
11경상남도 거제시고현동 거제중앙로24길2021-03-1216:49CCTV2023-09-043
20경상남도 거제시고현동 거제중앙로26길2021-08-2516:37CCTV2023-09-043
24경상남도 거제시고현동 거제중앙로26길2021-10-2814:55CCTV2023-09-043
44경상남도 거제시고현동 중곡1로2021-06-1614:35CCTV2023-09-043
95경상남도 거제시아주동 아주1로4길2021-01-289:53CCTV2023-09-043
100경상남도 거제시아주동 아주1로4길2021-05-189:51CCTV2023-09-043
109경상남도 거제시아주동 아주로1길2021-08-1710:48CCTV2023-09-043
119경상남도 거제시연초면 연하해안로2021-11-2514:11CCTV2023-09-043
155경상남도 거제시장평동 장평3로7길2021-08-039:54CCTV2023-09-043
156경상남도 거제시장평동 장평3로7길2021-08-0410:17CCTV2023-09-043