Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows452
Duplicate rows (%)4.5%
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/15125266/fileData.do

Alerts

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

Reproduction

Analysis started2023-12-12 18:20:42.384164
Analysis finished2023-12-12 18:20:43.222154
Duration0.84 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
2022
10000 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2022 10000
100.0%

Length

2023-12-13T03:20:43.314813image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:20:43.445163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 10000
100.0%

시군명
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-13T03:20:43.587391image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:20:43.693963image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
수원시 10000
100.0%

관리기관명
Categorical

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
권선구청
2912 
팔달구청
2880 
영통구청
2743 
장안구청
1465 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row팔달구청
2nd row권선구청
3rd row권선구청
4th row권선구청
5th row영통구청

Common Values

ValueCountFrequency (%)
권선구청 2912
29.1%
팔달구청 2880
28.8%
영통구청 2743
27.4%
장안구청 1465
14.6%

Length

2023-12-13T03:20:43.812536image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:20:43.949841image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
권선구청 2912
29.1%
팔달구청 2880
28.8%
영통구청 2743
27.4%
장안구청 1465
14.6%
Distinct8539
Distinct (%)85.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-01 08:11:00
Maximum2022-04-01 23:59:00
2023-12-13T03:20:44.128834image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T03:20:44.329665image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct2131
Distinct (%)21.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T03:20:44.607579image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length47
Median length43
Mean length13.7045
Min length1

Characters and Unicode

Total characters137045
Distinct characters394
Distinct categories11 ?
Distinct scripts4 ?
Distinct blocks4 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1207 ?
Unique (%)12.1%

Sample

1st row인계동 KBS드라마센터
2nd row평동 평동로77번길
3rd row호매실동 화홍병원
4th row권선동 1133
5th row영통동 벽적공원 사거리
ValueCountFrequency (%)
인계동 1774
 
6.3%
1179
 
4.2%
권선동 587
 
2.1%
이의동 489
 
1.7%
매탄동 478
 
1.7%
영통동 417
 
1.5%
수원시 396
 
1.4%
금곡동 387
 
1.4%
서둔동 373
 
1.3%
원천동 362
 
1.3%
Other values (2134) 21744
77.1%
2023-12-13T03:20:45.064310image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
18210
 
13.3%
12073
 
8.8%
3685
 
2.7%
1 3541
 
2.6%
2816
 
2.1%
2240
 
1.6%
2197
 
1.6%
2183
 
1.6%
2110
 
1.5%
2103
 
1.5%
Other values (384) 85887
62.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 100476
73.3%
Space Separator 18210
 
13.3%
Decimal Number 14369
 
10.5%
Uppercase Letter 1095
 
0.8%
Open Punctuation 854
 
0.6%
Close Punctuation 854
 
0.6%
Dash Punctuation 822
 
0.6%
Lowercase Letter 287
 
0.2%
Other Punctuation 37
 
< 0.1%
Math Symbol 30
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
12073
 
12.0%
3685
 
3.7%
2816
 
2.8%
2240
 
2.2%
2197
 
2.2%
2183
 
2.2%
2110
 
2.1%
2103
 
2.1%
1991
 
2.0%
1954
 
1.9%
Other values (346) 67124
66.8%
Uppercase Letter
ValueCountFrequency (%)
C 242
22.1%
K 148
13.5%
S 145
13.2%
V 130
11.9%
G 123
11.2%
U 69
 
6.3%
E 57
 
5.2%
B 48
 
4.4%
J 41
 
3.7%
T 29
 
2.6%
Other values (5) 63
 
5.8%
Decimal Number
ValueCountFrequency (%)
1 3541
24.6%
2 1970
13.7%
9 1250
 
8.7%
3 1239
 
8.6%
5 1184
 
8.2%
4 1141
 
7.9%
0 1118
 
7.8%
7 1102
 
7.7%
8 981
 
6.8%
6 843
 
5.9%
Lowercase Letter
ValueCountFrequency (%)
m 197
68.6%
o 36
 
12.5%
t 18
 
6.3%
r 18
 
6.3%
s 18
 
6.3%
Other Punctuation
ValueCountFrequency (%)
, 36
97.3%
. 1
 
2.7%
Space Separator
ValueCountFrequency (%)
18210
100.0%
Open Punctuation
ValueCountFrequency (%)
( 854
100.0%
Close Punctuation
ValueCountFrequency (%)
) 854
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 822
100.0%
Math Symbol
ValueCountFrequency (%)
~ 30
100.0%
Letter Number
ValueCountFrequency (%)
11
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 100475
73.3%
Common 35176
 
25.7%
Latin 1393
 
1.0%
Han 1
 
< 0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
12073
 
12.0%
3685
 
3.7%
2816
 
2.8%
2240
 
2.2%
2197
 
2.2%
2183
 
2.2%
2110
 
2.1%
2103
 
2.1%
1991
 
2.0%
1954
 
1.9%
Other values (345) 67123
66.8%
Latin
ValueCountFrequency (%)
C 242
17.4%
m 197
14.1%
K 148
10.6%
S 145
10.4%
V 130
9.3%
G 123
8.8%
U 69
 
5.0%
E 57
 
4.1%
B 48
 
3.4%
J 41
 
2.9%
Other values (11) 193
13.9%
Common
ValueCountFrequency (%)
18210
51.8%
1 3541
 
10.1%
2 1970
 
5.6%
9 1250
 
3.6%
3 1239
 
3.5%
5 1184
 
3.4%
4 1141
 
3.2%
0 1118
 
3.2%
7 1102
 
3.1%
8 981
 
2.8%
Other values (7) 3440
 
9.8%
Han
ValueCountFrequency (%)
1
100.0%

Most occurring blocks

ValueCountFrequency (%)
Hangul 100475
73.3%
ASCII 36558
 
26.7%
Number Forms 11
 
< 0.1%
CJK 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
18210
49.8%
1 3541
 
9.7%
2 1970
 
5.4%
9 1250
 
3.4%
3 1239
 
3.4%
5 1184
 
3.2%
4 1141
 
3.1%
0 1118
 
3.1%
7 1102
 
3.0%
8 981
 
2.7%
Other values (27) 4822
 
13.2%
Hangul
ValueCountFrequency (%)
12073
 
12.0%
3685
 
3.7%
2816
 
2.8%
2240
 
2.2%
2197
 
2.2%
2183
 
2.2%
2110
 
2.1%
2103
 
2.1%
1991
 
2.0%
1954
 
1.9%
Other values (345) 67123
66.8%
Number Forms
ValueCountFrequency (%)
11
100.0%
CJK
ValueCountFrequency (%)
1
100.0%

단속방법
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
고정형
5249 
주행형
3061 
국민신문고
1245 
보행
 
431
주민신고제
 
14

Length

Max length5
Median length3
Mean length3.2087
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row고정형
2nd row주행형
3rd row고정형
4th row국민신문고
5th row고정형

Common Values

ValueCountFrequency (%)
고정형 5249
52.5%
주행형 3061
30.6%
국민신문고 1245
 
12.4%
보행 431
 
4.3%
주민신고제 14
 
0.1%

Length

2023-12-13T03:20:45.240246image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:20:45.367979image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고정형 5249
52.5%
주행형 3061
30.6%
국민신문고 1245
 
12.4%
보행 431
 
4.3%
주민신고제 14
 
0.1%

데이터기준일자
Categorical

CONSTANT 

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

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-01
2nd row2023-12-01
3rd row2023-12-01
4th row2023-12-01
5th row2023-12-01

Common Values

ValueCountFrequency (%)
2023-12-01 10000
100.0%

Length

2023-12-13T03:20:45.482961image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T03:20:45.578042image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-01 10000
100.0%

Correlations

2023-12-13T03:20:45.633435image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관명단속방법
관리기관명1.0000.203
단속방법0.2031.000
2023-12-13T03:20:45.711164image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관명단속방법
관리기관명1.0000.167
단속방법0.1671.000
2023-12-13T03:20:46.062576image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관명단속방법
관리기관명1.0000.167
단속방법0.1671.000

Missing values

2023-12-13T03:20:42.968810image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T03:20:43.145297image/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

집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자
458252022수원시팔달구청2022-02-16 07:35:00인계동 KBS드라마센터고정형2023-12-01
288732022수원시권선구청2022-01-28 14:42:00평동 평동로77번길주행형2023-12-01
704252022수원시권선구청2022-03-11 14:34:00호매실동 화홍병원고정형2023-12-01
681092022수원시권선구청2022-03-09 11:37:00권선동 1133국민신문고2023-12-01
921232022수원시영통구청2022-03-30 10:18:00영통동 벽적공원 사거리고정형2023-12-01
62012022수원시장안구청2022-01-07 09:45:00조원동 조원공원 사거리고정형2023-12-01
777002022수원시팔달구청2022-03-17 14:34:00매산로2가 매산로2가 향교로63주행형2023-12-01
651002022수원시팔달구청2022-03-06 13:01:00고등동 수원역푸르지오 행복주택 앞고정형2023-12-01
687962022수원시장안구청2022-03-10 09:09:00조원동 조원공원 사거리(고정형CCTV)보행2023-12-01
235512022수원시팔달구청2022-01-23 16:55:00인계동 경기도 여성비전센터고정형2023-12-01
집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자
524772022수원시영통구청2022-02-22 13:53:00영통구 영통동1069국민신문고2023-12-01
114852022수원시장안구청2022-01-12 14:02:00송죽동 연세수요양병원고정형2023-12-01
21732022수원시권선구청2022-01-03 17:35:00호매실동 금호프라자 대각 맞은편고정형2023-12-01
511462022수원시영통구청2022-02-21 10:57:00하동 오름법조프라자고정형2023-12-01
112932022수원시팔달구청2022-01-12 10:32:00화서동 화서동184-89부근 (소화전 5m이내)국민신문고2023-12-01
497562022수원시장안구청2022-02-19 15:07:00천천동 화산로187번길주행형2023-12-01
17392022수원시팔달구청2022-01-03 14:41:00인계동 국민연금관리공단고정형2023-12-01
715632022수원시영통구청2022-03-12 13:57:00하동 광교 효성해링턴 출구고정형2023-12-01
395982022수원시장안구청2022-02-09 16:37:00천천동 망월재 사거리고정형2023-12-01
744102022수원시장안구청2022-03-15 08:51:00율전동 율전파출소고정형2023-12-01

Duplicate rows

Most frequently occurring

집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자# duplicates
602022수원시권선구청2022-01-25 14:18:00금곡동 금곡로197번길주행형2023-12-016
2212022수원시영통구청2022-02-05 12:24:00신동 권선로908번길주행형2023-12-016
612022수원시권선구청2022-01-25 14:18:00세류동 세류로90번길주행형2023-12-015
1642022수원시권선구청2022-03-23 14:41:00오목천동 오목천로27번길주행형2023-12-015
2072022수원시영통구청2022-01-21 10:50:00매탄동 인계로291번길주행형2023-12-015
252022수원시권선구청2022-01-11 09:55:00곡반정동 곡반정로주행형2023-12-014
2282022수원시영통구청2022-02-09 14:54:00신동 권선로882번길주행형2023-12-014
3382022수원시장안구청2022-02-23 19:25:00정자동 영화로주행형2023-12-014
3742022수원시팔달구청2022-01-07 15:01:00고등동 고등동 고등로33번길주행형2023-12-014
02022수원시권선구청2022-01-02 15:29:00세류동 권선로주행형2023-12-013