Overview

Dataset statistics

Number of variables7
Number of observations4786
Missing cells0
Missing cells (%)0.0%
Duplicate rows240
Duplicate rows (%)5.0%
Total size in memory266.5 KiB
Average record size in memory57.0 B

Variable types

Categorical5
DateTime1
Text1

Dataset

Description가평군의 주정차 위반 단속 위치 현황입니다. 집계년도, 시군명, 관리기관명, 단속일시, 단속장소, 단속방법, 데이터기준일자 정보를 제공합니다.
Author경기도 가평군
URLhttps://www.data.go.kr/data/15125221/fileData.do

Alerts

집계년도 has constant value ""Constant
시군명 has constant value ""Constant
관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 240 (5.0%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 12:00:14.452563
Analysis finished2023-12-12 12:00:14.931400
Duration0.48 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

집계년도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size37.5 KiB
2023
4786 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023 4786
100.0%

Length

2023-12-12T21:00:15.010793image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:00:15.120881image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 4786
100.0%

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size37.5 KiB
가평군
4786 

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 (%)
가평군 4786
100.0%

Length

2023-12-12T21:00:15.238163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:00:15.351563image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가평군 4786
100.0%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size37.5 KiB
가평군
4786 

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 (%)
가평군 4786
100.0%

Length

2023-12-12T21:00:15.452853image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:00:15.561511image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
가평군 4786
100.0%

단속일시
Date

Distinct4344
Distinct (%)90.8%
Missing0
Missing (%)0.0%
Memory size37.5 KiB
Minimum2023-01-02 08:18:00
Maximum2023-10-31 20:55:00
2023-12-12T21:00:15.709146image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T21:00:15.883903image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속장소
Text

Distinct640
Distinct (%)13.4%
Missing0
Missing (%)0.0%
Memory size37.5 KiB
2023-12-12T21:00:16.246020image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length21
Mean length11.466987
Min length5

Characters and Unicode

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

Unique

Unique378 ?
Unique (%)7.9%

Sample

1st row프로스펙스 경찰서방향
2nd row가평읍 사거리 자리목방
3rd row가평읍 사거리 가평군청
4th row설악한의원앞1
5th row가평읍 사거리 북면방향
ValueCountFrequency (%)
가평읍 1764
 
18.2%
청평면 658
 
6.8%
읍내리 570
 
5.9%
프로스펙스 366
 
3.8%
경찰서방향 302
 
3.1%
사거리 275
 
2.8%
조종면 196
 
2.0%
달전리 194
 
2.0%
현리서울프라자약국방향 184
 
1.9%
대곡리 175
 
1.8%
Other values (662) 5028
51.8%
2023-12-12T21:00:16.704718image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
4926
 
9.0%
평 3384
 
6.2%
읍 2338
 
4.3%
리 2328
 
4.2%
가 2029
 
3.7%
방 1847
 
3.4%
향 1740
 
3.2%
청 1454
 
2.6%
로 1389
 
2.5%
면 1255
 
2.3%
Other values (165) 32191
58.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 41207
75.1%
Decimal Number 5571
 
10.2%
Space Separator 4926
 
9.0%
Close Punctuation 1148
 
2.1%
Open Punctuation 1146
 
2.1%
Dash Punctuation 798
 
1.5%
Uppercase Letter 82
 
0.1%
Other Punctuation 3
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
평 3384
 
8.2%
읍 2338
 
5.7%
리 2328
 
5.6%
가 2029
 
4.9%
방 1847
 
4.5%
향 1740
 
4.2%
청 1454
 
3.5%
로 1389
 
3.4%
면 1255
 
3.0%
스 907
 
2.2%
Other values (148) 22536
54.7%
Decimal Number
ValueCountFrequency (%)
1 979
17.6%
2 746
13.4%
3 701
12.6%
4 683
12.3%
6 627
11.3%
0 428
7.7%
5 425
7.6%
9 423
7.6%
8 284
 
5.1%
7 275
 
4.9%
Uppercase Letter
ValueCountFrequency (%)
G 41
50.0%
S 41
50.0%
Space Separator
ValueCountFrequency (%)
4926
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1148
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1146
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 798
100.0%
Other Punctuation
ValueCountFrequency (%)
, 3
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 41207
75.1%
Common 13592
 
24.8%
Latin 82
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
평 3384
 
8.2%
읍 2338
 
5.7%
리 2328
 
5.6%
가 2029
 
4.9%
방 1847
 
4.5%
향 1740
 
4.2%
청 1454
 
3.5%
로 1389
 
3.4%
면 1255
 
3.0%
스 907
 
2.2%
Other values (148) 22536
54.7%
Common
ValueCountFrequency (%)
4926
36.2%
) 1148
 
8.4%
( 1146
 
8.4%
1 979
 
7.2%
- 798
 
5.9%
2 746
 
5.5%
3 701
 
5.2%
4 683
 
5.0%
6 627
 
4.6%
0 428
 
3.1%
Other values (5) 1410
 
10.4%
Latin
ValueCountFrequency (%)
G 41
50.0%
S 41
50.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 41207
75.1%
ASCII 13674
 
24.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
4926
36.0%
) 1148
 
8.4%
( 1146
 
8.4%
1 979
 
7.2%
- 798
 
5.8%
2 746
 
5.5%
3 701
 
5.1%
4 683
 
5.0%
6 627
 
4.6%
0 428
 
3.1%
Other values (7) 1492
 
10.9%
Hangul
ValueCountFrequency (%)
평 3384
 
8.2%
읍 2338
 
5.7%
리 2328
 
5.6%
가 2029
 
4.9%
방 1847
 
4.5%
향 1740
 
4.2%
청 1454
 
3.5%
로 1389
 
3.4%
면 1255
 
3.0%
스 907
 
2.2%
Other values (148) 22536
54.7%

단속방법
Categorical

Distinct3
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size37.5 KiB
고정형CCTV단속
2275 
이동형CCTV단속
1347 
스마트폰단속
1164 

Length

Max length9
Median length9
Mean length8.2703719
Min length6

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고정형CCTV단속
2nd row고정형CCTV단속
3rd row고정형CCTV단속
4th row고정형CCTV단속
5th row고정형CCTV단속

Common Values

ValueCountFrequency (%)
고정형CCTV단속 2275
47.5%
이동형CCTV단속 1347
28.1%
스마트폰단속 1164
24.3%

Length

2023-12-12T21:00:16.909944image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:00:17.068589image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고정형cctv단속 2275
47.5%
이동형cctv단속 1347
28.1%
스마트폰단속 1164
24.3%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size37.5 KiB
2023-11-27
4786 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-11-27
2nd row2023-11-27
3rd row2023-11-27
4th row2023-11-27
5th row2023-11-27

Common Values

ValueCountFrequency (%)
2023-11-27 4786
100.0%

Length

2023-12-12T21:00:17.225342image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:00:17.357492image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-27 4786
100.0%

Missing values

2023-12-12T21:00:14.725597image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:00:14.869871image/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

집계년도시군명관리기관명단속일시단속장소단속방법데이터기준일자
02023가평군가평군2023-01-02 08:18프로스펙스 경찰서방향고정형CCTV단속2023-11-27
12023가평군가평군2023-01-02 10:01가평읍 사거리 자리목방고정형CCTV단속2023-11-27
22023가평군가평군2023-01-02 10:13가평읍 사거리 가평군청고정형CCTV단속2023-11-27
32023가평군가평군2023-01-02 13:20설악한의원앞1고정형CCTV단속2023-11-27
42023가평군가평군2023-01-02 13:36가평읍 사거리 북면방향고정형CCTV단속2023-11-27
52023가평군가평군2023-01-02 13:49설악면사무소앞 회전교차고정형CCTV단속2023-11-27
62023가평군가평군2023-01-02 13:50프로스펙스 사거리방향고정형CCTV단속2023-11-27
72023가평군가평군2023-01-02 14:14청평서울철물방향고정형CCTV단속2023-11-27
82023가평군가평군2023-01-02 14:37설악한의원앞1고정형CCTV단속2023-11-27
92023가평군가평군2023-01-02 14:43가평군 홍농종묘 앞2고정형CCTV단속2023-11-27
집계년도시군명관리기관명단속일시단속장소단속방법데이터기준일자
47762023가평군가평군2023-10-31 11:06청평면 청평리 174(횡단보도)스마트폰단속2023-11-27
47772023가평군가평군2023-10-31 11:08청평면 청평리 174(횡단보도)스마트폰단속2023-11-27
47782023가평군가평군2023-10-31 14:54가평읍 달전리 445-10스마트폰단속2023-11-27
47792023가평군가평군2023-10-31 10:00흥농종묘구역전방향고정형CCTV단속2023-11-27
47802023가평군가평군2023-10-31 17:48청평초등학교방향고정형CCTV단속2023-11-27
47812023가평군가평군2023-10-31 17:55청평역방면고정형CCTV단속2023-11-27
47822023가평군가평군2023-10-31 18:24현리조종파출소방향고정형CCTV단속2023-11-27
47832023가평군가평군2023-10-31 18:29흥농종묘구역전방향고정형CCTV단속2023-11-27
47842023가평군가평군2023-10-31 18:35현리서울프라자약국방향고정형CCTV단속2023-11-27
47852023가평군가평군2023-10-31 18:39현리조종파출소방향고정형CCTV단속2023-11-27

Duplicate rows

Most frequently occurring

집계년도시군명관리기관명단속일시단속장소단속방법데이터기준일자# duplicates
142023가평군가평군2023-01-12 14:46가평읍 가평천길이동형CCTV단속2023-11-275
222023가평군가평군2023-01-31 15:35가평읍 보납로34번길이동형CCTV단속2023-11-275
1192023가평군가평군2023-05-15 13:27신천중앙로120번길이동형CCTV단속2023-11-275
72023가평군가평군2023-01-06 16:01가평읍 석봉로이동형CCTV단속2023-11-274
112023가평군가평군2023-01-10 15:08가평읍 보납로46번길이동형CCTV단속2023-11-274
182023가평군가평군2023-01-30 14:58가평읍 굴다리길이동형CCTV단속2023-11-274
372023가평군가평군2023-02-10 14:45청평면 여울길이동형CCTV단속2023-11-274
502023가평군가평군2023-02-16 14:48청평면 강변나루로40번길이동형CCTV단속2023-11-274
582023가평군가평군2023-02-20 15:02가평읍 보납로46번길이동형CCTV단속2023-11-274
642023가평군가평군2023-02-23 15:49가평읍 석봉로이동형CCTV단속2023-11-274