Overview

Dataset statistics

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

Variable types

Numeric1
Categorical4
DateTime1
Text1

Dataset

Description경기도_양주시_주정차 위반 단속 위치 현황에 관련한 데이터로 단속년도,단속일시 정보,단속장소,단속방법 등을 포함하고 있습니다.
URLhttps://www.data.go.kr/data/3077201/fileData.do

Alerts

시군명 has constant value ""Constant
관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
단속방법 is highly imbalanced (59.2%)Imbalance

Reproduction

Analysis started2023-12-11 23:04:33.011679
Analysis finished2023-12-11 23:04:33.849888
Duration0.84 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

집계년도
Real number (ℝ)

Distinct9
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean2016.5906
Minimum2010
Maximum2018
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T08:04:33.922371image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum2010
5-th percentile2015
Q12016
median2017
Q32018
95-th percentile2018
Maximum2018
Range8
Interquartile range (IQR)2

Descriptive statistics

Standard deviation1.1916097
Coefficient of variation (CV)0.00059090312
Kurtosis2.0017822
Mean2016.5906
Median Absolute Deviation (MAD)1
Skewness-0.82920118
Sum20165906
Variance1.4199336
MonotonicityNot monotonic
2023-12-12T08:04:34.069456image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=9)
ValueCountFrequency (%)
2017 2776
27.8%
2018 2750
27.5%
2016 2438
24.4%
2015 1919
19.2%
2014 29
 
0.3%
2013 28
 
0.3%
2011 27
 
0.3%
2010 21
 
0.2%
2012 12
 
0.1%
ValueCountFrequency (%)
2010 21
 
0.2%
2011 27
 
0.3%
2012 12
 
0.1%
2013 28
 
0.3%
2014 29
 
0.3%
2015 1919
19.2%
2016 2438
24.4%
2017 2776
27.8%
2018 2750
27.5%
ValueCountFrequency (%)
2018 2750
27.5%
2017 2776
27.8%
2016 2438
24.4%
2015 1919
19.2%
2014 29
 
0.3%
2013 28
 
0.3%
2012 12
 
0.1%
2011 27
 
0.3%
2010 21
 
0.2%

시군명
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-12T08:04:34.218754image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:04:34.332454image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양주시 10000
100.0%

단속일시정보
Date

Distinct9881
Distinct (%)98.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2010-01-21 10:40:00
Maximum2018-11-28 15:11:00
2023-12-12T08:04:34.761251image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:04:34.930422image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속장소
Text

Distinct722
Distinct (%)7.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T08:04:35.206013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length14
Median length12
Mean length8.7206
Min length3

Characters and Unicode

Total characters87206
Distinct characters322
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

Unique390 ?
Unique (%)3.9%

Sample

1st row양주고등학교 앞
2nd row롯데시네마
3rd row덕정동덕정초교
4th row덕정동 그랑시떼 후면
5th row양주테크노시티 앞
ValueCountFrequency (%)
롯데시네마 1913
 
10.8%
앞 1323
 
7.4%
덕정동 1315
 
7.4%
광사동 1075
 
6.0%
후면 912
 
5.1%
그랑시떼 912
 
5.1%
뒷편 709
 
4.0%
도로 635
 
3.6%
메가시티프라자 605
 
3.4%
고읍동 604
 
3.4%
Other values (724) 7790
43.8%
2023-12-12T08:04:35.565798image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
7793
 
8.9%
동 5696
 
6.5%
시 4033
 
4.6%
덕 3368
 
3.9%
정 3051
 
3.5%
마 2526
 
2.9%
사 2448
 
2.8%
데 2121
 
2.4%
롯 2058
 
2.4%
네 2013
 
2.3%
Other values (312) 52099
59.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 77806
89.2%
Space Separator 7793
 
8.9%
Decimal Number 1022
 
1.2%
Uppercase Letter 412
 
0.5%
Other Punctuation 70
 
0.1%
Lowercase Letter 67
 
0.1%
Dash Punctuation 32
 
< 0.1%
Close Punctuation 2
 
< 0.1%
Open Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 5696
 
7.3%
시 4033
 
5.2%
덕 3368
 
4.3%
정 3051
 
3.9%
마 2526
 
3.2%
사 2448
 
3.1%
데 2121
 
2.7%
롯 2058
 
2.6%
네 2013
 
2.6%
광 1972
 
2.5%
Other values (279) 48520
62.4%
Uppercase Letter
ValueCountFrequency (%)
S 182
44.2%
A 61
 
14.8%
T 53
 
12.9%
P 49
 
11.9%
L 15
 
3.6%
H 15
 
3.6%
I 10
 
2.4%
K 8
 
1.9%
B 8
 
1.9%
U 3
 
0.7%
Other values (5) 8
 
1.9%
Decimal Number
ValueCountFrequency (%)
2 327
32.0%
1 198
19.4%
3 179
17.5%
7 112
 
11.0%
4 40
 
3.9%
6 37
 
3.6%
8 35
 
3.4%
5 32
 
3.1%
0 32
 
3.1%
9 30
 
2.9%
Lowercase Letter
ValueCountFrequency (%)
e 61
91.0%
c 4
 
6.0%
k 2
 
3.0%
Space Separator
ValueCountFrequency (%)
7793
100.0%
Other Punctuation
ValueCountFrequency (%)
@ 70
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 32
100.0%
Close Punctuation
ValueCountFrequency (%)
) 2
100.0%
Open Punctuation
ValueCountFrequency (%)
( 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 77806
89.2%
Common 8921
 
10.2%
Latin 479
 
0.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 5696
 
7.3%
시 4033
 
5.2%
덕 3368
 
4.3%
정 3051
 
3.9%
마 2526
 
3.2%
사 2448
 
3.1%
데 2121
 
2.7%
롯 2058
 
2.6%
네 2013
 
2.6%
광 1972
 
2.5%
Other values (279) 48520
62.4%
Latin
ValueCountFrequency (%)
S 182
38.0%
A 61
 
12.7%
e 61
 
12.7%
T 53
 
11.1%
P 49
 
10.2%
L 15
 
3.1%
H 15
 
3.1%
I 10
 
2.1%
K 8
 
1.7%
B 8
 
1.7%
Other values (8) 17
 
3.5%
Common
ValueCountFrequency (%)
7793
87.4%
2 327
 
3.7%
1 198
 
2.2%
3 179
 
2.0%
7 112
 
1.3%
@ 70
 
0.8%
4 40
 
0.4%
6 37
 
0.4%
8 35
 
0.4%
5 32
 
0.4%
Other values (5) 98
 
1.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 77806
89.2%
ASCII 9400
 
10.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
7793
82.9%
2 327
 
3.5%
1 198
 
2.1%
S 182
 
1.9%
3 179
 
1.9%
7 112
 
1.2%
@ 70
 
0.7%
A 61
 
0.6%
e 61
 
0.6%
T 53
 
0.6%
Other values (23) 364
 
3.9%
Hangul
ValueCountFrequency (%)
동 5696
 
7.3%
시 4033
 
5.2%
덕 3368
 
4.3%
정 3051
 
3.9%
마 2526
 
3.2%
사 2448
 
3.1%
데 2121
 
2.7%
롯 2058
 
2.6%
네 2013
 
2.6%
광 1972
 
2.5%
Other values (279) 48520
62.4%

단속방법
Categorical

IMBALANCE 

Distinct4
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
고정형CCTV
7666 
차량형CCTV
2294 
민원신고(생활불편신고)
 
27
인력단속
 
13

Length

Max length12
Median length7
Mean length7.0096
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 7666
76.7%
차량형CCTV 2294
 
22.9%
민원신고(생활불편신고) 27
 
0.3%
인력단속 13
 
0.1%

Length

2023-12-12T08:04:35.734893image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:04:35.868789image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고정형cctv 7666
76.7%
차량형cctv 2294
 
22.9%
민원신고(생활불편신고 27
 
0.3%
인력단속 13
 
0.1%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
양주시 차량관리과
10000 

Length

Max length9
Median length9
Mean length9
Min length9

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-12T08:04:35.988291image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:04:36.076880image/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
2023-08-17
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-08-17
2nd row2023-08-17
3rd row2023-08-17
4th row2023-08-17
5th row2023-08-17

Common Values

ValueCountFrequency (%)
2023-08-17 10000
100.0%

Length

2023-12-12T08:04:36.173505image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T08:04:36.259028image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-08-17 10000
100.0%

Interactions

2023-12-12T08:04:33.452394image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T08:04:36.311285image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
집계년도단속방법
집계년도1.0000.196
단속방법0.1961.000
2023-12-12T08:04:36.388320image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
집계년도단속방법
집계년도1.0000.090
단속방법0.0901.000

Missing values

2023-12-12T08:04:33.624744image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T08:04:33.776859image/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

집계년도시군명단속일시정보단속장소단속방법관리기관명데이터기준일자
483332017양주시2017-05-09 13:33양주고등학교 앞고정형CCTV양주시 차량관리과2023-08-17
312382016양주시2016-08-03 19:44롯데시네마고정형CCTV양주시 차량관리과2023-08-17
180702015양주시2015-11-23 10:19덕정동덕정초교차량형CCTV양주시 차량관리과2023-08-17
898922018양주시2018-10-05 13:47덕정동 그랑시떼 후면고정형CCTV양주시 차량관리과2023-08-17
312132016양주시2016-08-03 18:26양주테크노시티 앞고정형CCTV양주시 차량관리과2023-08-17
469672017양주시2017-04-14 15:01양주고등학교 앞고정형CCTV양주시 차량관리과2023-08-17
104572015양주시2015-05-29 18:02광사동 해동프라자사거리고정형CCTV양주시 차량관리과2023-08-17
1122010양주시2010-05-04 16:24덕정주공5단지 앞고정형CCTV양주시 차량관리과2023-08-17
535632017양주시2017-08-02 15:57백석읍백석동화옥시존5차차량형CCTV양주시 차량관리과2023-08-17
650272017양주시2017-11-19 15:59롯데시네마고정형CCTV양주시 차량관리과2023-08-17
집계년도시군명단속일시정보단속장소단속방법관리기관명데이터기준일자
838122018양주시2018-07-06 19:32롯데시네마고정형CCTV양주시 차량관리과2023-08-17
91202015양주시2015-05-04 17:42고읍동 덕현농협 뒷편고정형CCTV양주시 차량관리과2023-08-17
89852015양주시2015-05-02 13:44한국유통옆고정형CCTV양주시 차량관리과2023-08-17
477072017양주시2017-04-29 15:52메가시티프라자 뒷편고정형CCTV양주시 차량관리과2023-08-17
559552017양주시2017-08-27 15:20롯데시네마고정형CCTV양주시 차량관리과2023-08-17
667842017양주시2017-12-10 13:32덕계동 덕계초등학교고정형CCTV양주시 차량관리과2023-08-17
154392015양주시2015-09-06 14:55고읍동 덕현농협 뒷편고정형CCTV양주시 차량관리과2023-08-17
68202015양주시2015-03-25 16:27고읍동 덕현농협 뒷편고정형CCTV양주시 차량관리과2023-08-17
825612018양주시2018-06-16 14:33롯데시네마고정형CCTV양주시 차량관리과2023-08-17
9752013양주시2013-12-05 15:48덕정동미도상가차량형CCTV양주시 차량관리과2023-08-17