Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows442
Duplicate rows (%)4.4%
Total size in memory634.8 KiB
Average record size in memory65.0 B

Variable types

Categorical5
DateTime1
Text1

Dataset

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

Alerts

시군명 has constant value ""Constant
관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 442 (4.4%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 07:39:44.849487
Analysis finished2023-12-12 07:39:45.401473
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

집계년도
Categorical

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2022
5321 
2023
4679 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2022 5321
53.2%
2023 4679
46.8%

Length

2023-12-12T16:39:45.468859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:39:45.556118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 5321
53.2%
2023 4679
46.8%

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
여주시
10000 

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 (%)
여주시 10000
100.0%

Length

2023-12-12T16:39:45.652545image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:39:45.736532image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
여주시 10000
100.0%

관리기관명
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-12T16:39:45.823305image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:39:45.907771image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 10000
50.0%
여주시청 10000
50.0%

단속일시정보
Date

Distinct8939
Distinct (%)89.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-02 07:58:00
Maximum2023-11-20 14:21:00
2023-12-12T16:39:46.008993image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T16:39:46.169711image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속장소
Text

Distinct1047
Distinct (%)10.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T16:39:46.527566image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length31
Median length26
Mean length10.6685
Min length3

Characters and Unicode

Total characters106685
Distinct characters201
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

Unique690 ?
Unique (%)6.9%

Sample

1st row가남읍 경충대로
2nd row태평리 가남파출소 부근
3rd row도예로 55 여주축협 학동지점주변
4th row교동 교동로
5th row태평리 가남터미널사거리
ValueCountFrequency (%)
부근 3255
 
14.0%
홍문동 1968
 
8.5%
태평리 1600
 
6.9%
교동 1475
 
6.3%
가남터미널사거리 913
 
3.9%
현암동 907
 
3.9%
교동로 865
 
3.7%
가업동 541
 
2.3%
이마트물류센터 540
 
2.3%
현대아파트 475
 
2.0%
Other values (1029) 10710
46.1%
2023-12-12T16:39:46.894665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13250
 
12.4%
동 8818
 
8.3%
부 3485
 
3.3%
근 3374
 
3.2%
리 3078
 
2.9%
교 2990
 
2.8%
로 2928
 
2.7%
문 2831
 
2.7%
홍 2212
 
2.1%
가 2077
 
1.9%
Other values (191) 61642
57.8%

Most occurring categories

ValueCountFrequency (%)
Other Letter 80862
75.8%
Space Separator 13250
 
12.4%
Decimal Number 9201
 
8.6%
Close Punctuation 1130
 
1.1%
Open Punctuation 1119
 
1.0%
Dash Punctuation 1084
 
1.0%
Uppercase Letter 33
 
< 0.1%
Other Punctuation 6
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 8818
 
10.9%
부 3485
 
4.3%
근 3374
 
4.2%
리 3078
 
3.8%
교 2990
 
3.7%
로 2928
 
3.6%
문 2831
 
3.5%
홍 2212
 
2.7%
가 2077
 
2.6%
트 1916
 
2.4%
Other values (174) 47153
58.3%
Decimal Number
ValueCountFrequency (%)
1 2023
22.0%
2 1163
12.6%
9 983
10.7%
0 949
10.3%
4 875
9.5%
3 852
9.3%
5 794
 
8.6%
6 577
 
6.3%
8 513
 
5.6%
7 472
 
5.1%
Uppercase Letter
ValueCountFrequency (%)
C 22
66.7%
K 11
33.3%
Space Separator
ValueCountFrequency (%)
13250
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1130
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1119
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1084
100.0%
Other Punctuation
ValueCountFrequency (%)
, 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 80862
75.8%
Common 25790
 
24.2%
Latin 33
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 8818
 
10.9%
부 3485
 
4.3%
근 3374
 
4.2%
리 3078
 
3.8%
교 2990
 
3.7%
로 2928
 
3.6%
문 2831
 
3.5%
홍 2212
 
2.7%
가 2077
 
2.6%
트 1916
 
2.4%
Other values (174) 47153
58.3%
Common
ValueCountFrequency (%)
13250
51.4%
1 2023
 
7.8%
2 1163
 
4.5%
) 1130
 
4.4%
( 1119
 
4.3%
- 1084
 
4.2%
9 983
 
3.8%
0 949
 
3.7%
4 875
 
3.4%
3 852
 
3.3%
Other values (5) 2362
 
9.2%
Latin
ValueCountFrequency (%)
C 22
66.7%
K 11
33.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 80862
75.8%
ASCII 25823
 
24.2%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13250
51.3%
1 2023
 
7.8%
2 1163
 
4.5%
) 1130
 
4.4%
( 1119
 
4.3%
- 1084
 
4.2%
9 983
 
3.8%
0 949
 
3.7%
4 875
 
3.4%
3 852
 
3.3%
Other values (7) 2395
 
9.3%
Hangul
ValueCountFrequency (%)
동 8818
 
10.9%
부 3485
 
4.3%
근 3374
 
4.2%
리 3078
 
3.8%
교 2990
 
3.7%
로 2928
 
3.6%
문 2831
 
3.5%
홍 2212
 
2.7%
가 2077
 
2.6%
트 1916
 
2.4%
Other values (174) 47153
58.3%

단속방법
Categorical

Distinct3
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
고정형CCTV
6143 
이동형CCTV
2570 
새올민원
1287 

Length

Max length7
Median length7
Mean length6.6139
Min length4

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 6143
61.4%
이동형CCTV 2570
25.7%
새올민원 1287
 
12.9%

Length

2023-12-12T16:39:47.045909image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:39:47.135084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고정형cctv 6143
61.4%
이동형cctv 2570
25.7%
새올민원 1287
 
12.9%

데이터기준일자
Categorical

CONSTANT 

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

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023-11-15 10000
100.0%

Length

2023-12-12T16:39:47.242937image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T16:39:47.337685image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-15 10000
100.0%

Correlations

2023-12-12T16:39:47.390855image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
집계년도단속방법
집계년도1.0000.099
단속방법0.0991.000
2023-12-12T16:39:47.469034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속방법집계년도
단속방법1.0000.165
집계년도0.1651.000
2023-12-12T16:39:47.556767image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
집계년도단속방법
집계년도1.0000.165
단속방법0.1651.000

Missing values

2023-12-12T16:39:45.228651image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T16:39:45.349828image/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

집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자
132362023여주시경기도 여주시청2023-05-17 14:29가남읍 경충대로이동형CCTV2023-11-15
170132023여주시경기도 여주시청2023-10-11 14:54태평리 가남파출소 부근고정형CCTV2023-11-15
3632022여주시경기도 여주시청2022-01-17 10:19도예로 55 여주축협 학동지점주변이동형CCTV2023-11-15
137052023여주시경기도 여주시청2023-06-12 10:08교동 교동로이동형CCTV2023-11-15
119302023여주시경기도 여주시청2023-03-27 10:55태평리 가남터미널사거리고정형CCTV2023-11-15
112562023여주시경기도 여주시청2023-03-02 10:01교동 교동로이동형CCTV2023-11-15
138672023여주시경기도 여주시청2023-06-16 12:18태평리 새마을금고 부근고정형CCTV2023-11-15
36012022여주시경기도 여주시청2022-06-22 10:14교동 여주역입구 삼거리고정형CCTV2023-11-15
182992023여주시경기도 여주시청2023-11-16 13:49현암동 이안아파트 부근고정형CCTV2023-11-15
168612023여주시경기도 여주시청2023-10-05 17:59오학동257-3(인도)새올민원2023-11-15
집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자
156622023여주시경기도 여주시청2023-08-14 09:17홍문동 한전사거리 부근고정형CCTV2023-11-15
173802023여주시경기도 여주시청2023-10-20 14:24오학동 KCC교차로부근고정형CCTV2023-11-15
159772023여주시경기도 여주시청2023-08-24 14:33가업동 이마트물류센터고정형CCTV2023-11-15
145072023여주시경기도 여주시청2023-07-05 13:49가업동 이마트물류센터고정형CCTV2023-11-15
181622023여주시경기도 여주시청2023-11-13 10:20교동 498-150이동형CCTV2023-11-15
104892023여주시경기도 여주시청2023-02-06 13:48상동 청심로이동형CCTV2023-11-15
180462023여주시경기도 여주시청2023-11-08 10:19상동536-26(모퉁이)새올민원2023-11-15
137902023여주시경기도 여주시청2023-06-14 09:58태평리 가남터미널사거리고정형CCTV2023-11-15
173932023여주시경기도 여주시청2023-10-20 13:42창동5-1(어린이보호)새올민원2023-11-15
8052022여주시경기도 여주시청2022-02-21 13:59가업동 이마트물류센터고정형CCTV2023-11-15

Duplicate rows

Most frequently occurring

집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자# duplicates
1442022여주시경기도 여주시청2022-10-07 10:13교동 교동로이동형CCTV2023-11-159
1512022여주시경기도 여주시청2022-10-12 14:03교동 교동로이동형CCTV2023-11-159
3442023여주시경기도 여주시청2023-04-20 14:05삼교동 장여로이동형CCTV2023-11-159
2002022여주시경기도 여주시청2022-11-10 10:36교동 교동로이동형CCTV2023-11-158
2012022여주시경기도 여주시청2022-11-10 10:37교동 교동로이동형CCTV2023-11-158
3502023여주시경기도 여주시청2023-04-21 10:13삼교동 던드레길이동형CCTV2023-11-158
1572022여주시경기도 여주시청2022-10-14 10:03상동 여흥로160번길이동형CCTV2023-11-157
42022여주시경기도 여주시청2022-01-04 14:00교동2길 50주변이동형CCTV2023-11-156
1262022여주시경기도 여주시청2022-09-28 14:39교동로이동형CCTV2023-11-156
1452022여주시경기도 여주시청2022-10-07 10:15교동 교동로이동형CCTV2023-11-156