Overview

Dataset statistics

Number of variables7
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows262
Duplicate rows (%)2.6%
Total size in memory625.0 KiB
Average record size in memory64.0 B

Variable types

Categorical5
DateTime1
Text1

Dataset

Description파주시 주정차위반 발생현황에 대한 데이터로서 차종(승용, 화물4톤이하, 화물4톤초과, 건설중기특수, 승합), 단속일시, 단속동, 단속장소 등의 정보를 제공합니다.
Author경기도 파주시
URLhttps://www.data.go.kr/data/15017267/fileData.do

Alerts

관리기관명 has constant value ""Constant
관리기관전화번호 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 262 (2.6%) duplicate rowsDuplicates
차종 is highly imbalanced (68.1%)Imbalance

Reproduction

Analysis started2023-12-12 06:58:25.414437
Analysis finished2023-12-12 06:58:26.112292
Duration0.7 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

차종
Categorical

IMBALANCE 

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
승용
8651 
화물4톤이하
902 
승합
 
339
화물4톤초과
 
74
건설+중기+특수
 
34

Length

Max length8
Median length2
Mean length2.4108
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row승용
2nd row승용
3rd row승용
4th row승용
5th row화물4톤이하

Common Values

ValueCountFrequency (%)
승용 8651
86.5%
화물4톤이하 902
 
9.0%
승합 339
 
3.4%
화물4톤초과 74
 
0.7%
건설+중기+특수 34
 
0.3%

Length

2023-12-12T15:58:26.172920image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:58:26.260659image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
승용 8651
86.5%
화물4톤이하 902
 
9.0%
승합 339
 
3.4%
화물4톤초과 74
 
0.7%
건설+중기+특수 34
 
0.3%

단속일시
Date

Distinct9340
Distinct (%)93.4%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2021-01-01 08:50:00
Maximum2022-05-22 15:58:00
2023-12-12T15:58:26.379450image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T15:58:26.500747image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속동
Categorical

Distinct28
Distinct (%)0.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
야당동
1821 
금촌동
1746 
와동동
1502 
문산읍
1037 
월롱면
806 
Other values (23)
3088 

Length

Max length6
Median length3
Mean length3.0012
Min length3

Unique

Unique3 ?
Unique (%)< 0.1%

Sample

1st row교하동
2nd row와동동
3rd row금촌동
4th row월롱면
5th row문발동

Common Values

ValueCountFrequency (%)
야당동 1821
18.2%
금촌동 1746
17.5%
와동동 1502
15.0%
문산읍 1037
10.4%
월롱면 806
8.1%
문발동 613
 
6.1%
목동동 541
 
5.4%
아동동 402
 
4.0%
동패동 360
 
3.6%
조리읍 357
 
3.6%
Other values (18) 815
8.2%

Length

2023-12-12T15:58:26.612190image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
야당동 1821
18.2%
금촌동 1746
17.5%
와동동 1502
15.0%
문산읍 1037
10.4%
월롱면 806
8.1%
문발동 613
 
6.1%
목동동 541
 
5.4%
아동동 402
 
4.0%
동패동 360
 
3.6%
조리읍 357
 
3.6%
Other values (18) 815
8.2%

단속장소
Text

Distinct1156
Distinct (%)11.6%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T15:58:26.826063image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length25
Median length23
Mean length9.0384
Min length2

Characters and Unicode

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

Unique

Unique572 ?
Unique (%)5.7%

Sample

1st row아이비타워 앞
2nd row와동동 가람로116번길
3rd row금촌동 한마음1길
4th row월롱면 엘씨디로8번길
5th row문발동 문발로
ValueCountFrequency (%)
앞 2846
 
13.2%
부근 1166
 
5.4%
야당동 834
 
3.9%
금촌동 770
 
3.6%
건너편 714
 
3.3%
와동동 505
 
2.3%
문발동 486
 
2.3%
월롱면 369
 
1.7%
아동동 325
 
1.5%
경의로1004번길 302
 
1.4%
Other values (1132) 13174
61.3%
2023-12-12T15:58:27.179348image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
11509
 
12.7%
동 5520
 
6.1%
로 3960
 
4.4%
앞 2997
 
3.3%
길 2783
 
3.1%
1 2279
 
2.5%
금 1686
 
1.9%
번 1614
 
1.8%
문 1547
 
1.7%
리 1335
 
1.5%
Other values (397) 55154
61.0%

Most occurring categories

ValueCountFrequency (%)
Other Letter 68657
76.0%
Space Separator 11509
 
12.7%
Decimal Number 8614
 
9.5%
Uppercase Letter 1046
 
1.2%
Dash Punctuation 355
 
0.4%
Close Punctuation 71
 
0.1%
Open Punctuation 71
 
0.1%
Connector Punctuation 26
 
< 0.1%
Lowercase Letter 21
 
< 0.1%
Other Punctuation 12
 
< 0.1%
Other values (2) 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 5520
 
8.0%
로 3960
 
5.8%
앞 2997
 
4.4%
길 2783
 
4.1%
금 1686
 
2.5%
번 1614
 
2.4%
문 1547
 
2.3%
리 1335
 
1.9%
부 1190
 
1.7%
근 1171
 
1.7%
Other values (353) 44854
65.3%
Uppercase Letter
ValueCountFrequency (%)
A 196
18.7%
T 170
16.3%
P 169
16.2%
M 129
12.3%
H 125
12.0%
I 66
 
6.3%
L 49
 
4.7%
G 34
 
3.3%
K 30
 
2.9%
C 26
 
2.5%
Other values (7) 52
 
5.0%
Decimal Number
ValueCountFrequency (%)
1 2279
26.5%
2 1260
14.6%
4 1254
14.6%
0 1150
13.4%
8 849
 
9.9%
6 452
 
5.2%
3 411
 
4.8%
7 360
 
4.2%
5 329
 
3.8%
9 270
 
3.1%
Lowercase Letter
ValueCountFrequency (%)
c 6
28.6%
l 3
14.3%
u 3
14.3%
d 3
14.3%
t 2
 
9.5%
m 2
 
9.5%
s 2
 
9.5%
Other Punctuation
ValueCountFrequency (%)
. 7
58.3%
/ 4
33.3%
# 1
 
8.3%
Space Separator
ValueCountFrequency (%)
11509
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 355
100.0%
Close Punctuation
ValueCountFrequency (%)
) 71
100.0%
Open Punctuation
ValueCountFrequency (%)
( 71
100.0%
Connector Punctuation
ValueCountFrequency (%)
_ 26
100.0%
Math Symbol
ValueCountFrequency (%)
~ 1
100.0%
Control
ValueCountFrequency (%)
1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 68657
76.0%
Common 20660
 
22.9%
Latin 1067
 
1.2%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 5520
 
8.0%
로 3960
 
5.8%
앞 2997
 
4.4%
길 2783
 
4.1%
금 1686
 
2.5%
번 1614
 
2.4%
문 1547
 
2.3%
리 1335
 
1.9%
부 1190
 
1.7%
근 1171
 
1.7%
Other values (353) 44854
65.3%
Latin
ValueCountFrequency (%)
A 196
18.4%
T 170
15.9%
P 169
15.8%
M 129
12.1%
H 125
11.7%
I 66
 
6.2%
L 49
 
4.6%
G 34
 
3.2%
K 30
 
2.8%
C 26
 
2.4%
Other values (14) 73
 
6.8%
Common
ValueCountFrequency (%)
11509
55.7%
1 2279
 
11.0%
2 1260
 
6.1%
4 1254
 
6.1%
0 1150
 
5.6%
8 849
 
4.1%
6 452
 
2.2%
3 411
 
2.0%
7 360
 
1.7%
- 355
 
1.7%
Other values (10) 781
 
3.8%

Most occurring blocks

ValueCountFrequency (%)
Hangul 68657
76.0%
ASCII 21727
 
24.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
11509
53.0%
1 2279
 
10.5%
2 1260
 
5.8%
4 1254
 
5.8%
0 1150
 
5.3%
8 849
 
3.9%
6 452
 
2.1%
3 411
 
1.9%
7 360
 
1.7%
- 355
 
1.6%
Other values (34) 1848
 
8.5%
Hangul
ValueCountFrequency (%)
동 5520
 
8.0%
로 3960
 
5.8%
앞 2997
 
4.4%
길 2783
 
4.1%
금 1686
 
2.5%
번 1614
 
2.4%
문 1547
 
2.3%
리 1335
 
1.9%
부 1190
 
1.7%
근 1171
 
1.7%
Other values (353) 44854
65.3%

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

Common Values (Plot)

2023-12-12T15:58:27.440248image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
경기도 10000
50.0%
파주시청 10000
50.0%

관리기관전화번호
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
031-940-5969
10000 

Length

Max length12
Median length12
Mean length12
Min length12

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row031-940-5969
2nd row031-940-5969
3rd row031-940-5969
4th row031-940-5969
5th row031-940-5969

Common Values

ValueCountFrequency (%)
031-940-5969 10000
100.0%

Length

2023-12-12T15:58:27.530898image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:58:27.637722image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
031-940-5969 10000
100.0%

데이터기준일자
Categorical

CONSTANT 

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

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

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

Length

2023-12-12T15:58:27.734333image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T15:58:27.819488image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-11-13 10000
100.0%

Correlations

2023-12-12T15:58:27.871783image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
차종단속동
차종1.0000.128
단속동0.1281.000
2023-12-12T15:58:27.945004image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속동차종
단속동1.0000.061
차종0.0611.000
2023-12-12T15:58:28.029953image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
차종단속동
차종1.0000.061
단속동0.0611.000

Missing values

2023-12-12T15:58:25.945604image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T15:58:26.055315image/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

차종단속일시단속동단속장소관리기관명관리기관전화번호데이터기준일자
29210승용2021-07-05 16:14교하동아이비타워 앞경기도 파주시청031-940-59692023-11-13
81113승용2022-03-25 10:22와동동와동동 가람로116번길경기도 파주시청031-940-59692023-11-13
62359승용2021-12-19 09:55금촌동금촌동 한마음1길경기도 파주시청031-940-59692023-11-13
78908승용2022-03-15 09:57월롱면월롱면 엘씨디로8번길경기도 파주시청031-940-59692023-11-13
64674화물4톤이하2021-12-30 11:00문발동문발동 문발로경기도 파주시청031-940-59692023-11-13
66086승용2022-01-06 09:29아동동원앙길 부근경기도 파주시청031-940-59692023-11-13
35610승용2021-08-10 17:06와동동와동동 가람로21번길경기도 파주시청031-940-59692023-11-13
58180승용2021-11-30 15:15동패동동패동 남북로경기도 파주시청031-940-59692023-11-13
85220승용2022-04-10 14:57금촌동투썸플레이스 파주금촌동점 앞경기도 파주시청031-940-59692023-11-13
1320화물4톤이하2021-01-11 10:08문산읍문산읍 개포래로경기도 파주시청031-940-59692023-11-13
차종단속일시단속동단속장소관리기관명관리기관전화번호데이터기준일자
54459승용2021-11-14 15:49교하동이지타운 앞경기도 파주시청031-940-59692023-11-13
33489승용2021-07-30 15:28동패동동패동 1762경기도 파주시청031-940-59692023-11-13
15983승용2021-04-22 10:38야당동삼융시네마 건너편경기도 파주시청031-940-59692023-11-13
15099화물4톤이하2021-04-16 09:24금촌동금촌순복음교회 사거리 앞경기도 파주시청031-940-59692023-11-13
68445승용2022-01-17 10:39월롱면월롱면 엘씨디로경기도 파주시청031-940-59692023-11-13
50148화물4톤이하2021-10-27 09:31와동동가람로116번길 부근경기도 파주시청031-940-59692023-11-13
94806승용2022-05-20 22:59목동동목동동 1094경기도 파주시청031-940-59692023-11-13
74496승용2022-02-23 14:21와동동남양휴튼APT 건너편경기도 파주시청031-940-59692023-11-13
5550승용2021-02-15 14:34월롱면월롱면 엘씨디로경기도 파주시청031-940-59692023-11-13
85547승용2022-04-11 16:04문산읍문산 선유APT 4단지 정문 앞경기도 파주시청031-940-59692023-11-13

Duplicate rows

Most frequently occurring

차종단속일시단속동단속장소관리기관명관리기관전화번호데이터기준일자# duplicates
119승용2021-10-13 09:41와동동가람로 부근경기도 파주시청031-940-59692023-11-136
217승용2022-03-28 14:28와동동와동동 가람로경기도 파주시청031-940-59692023-11-134
223승용2022-04-05 14:21와동동와동동 가람로116번길경기도 파주시청031-940-59692023-11-134
0승용2021-01-01 16:55야당동야당동 경의로1004번길경기도 파주시청031-940-59692023-11-133
7승용2021-01-15 14:10야당동경의로1004번길 부근경기도 파주시청031-940-59692023-11-133
13승용2021-02-16 10:01문발동문발로 부근경기도 파주시청031-940-59692023-11-133
15승용2021-02-27 17:20야당동야당동 소리천로8번길경기도 파주시청031-940-59692023-11-133
34승용2021-05-04 15:02문발동문발동 문발로경기도 파주시청031-940-59692023-11-133
63승용2021-07-01 15:28와동동와동동 가람로경기도 파주시청031-940-59692023-11-133
86승용2021-08-18 16:35조리읍조리읍 안능안길경기도 파주시청031-940-59692023-11-133