Overview

Dataset statistics

Number of variables9
Number of observations2122
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory153.5 KiB
Average record size in memory74.1 B

Variable types

Numeric1
DateTime2
Categorical6

Dataset

Description경기도 화성시 주정차단속현황(산척동728-6) 관련한 데이터로 순번, 위반일자, 위반시간, 위반장소명, 과태료금액, 사진여부, 위반법조항, 관리기관, 데이터 기준일을 포함합니다.
Author경기도 화성시
URLhttps://www.data.go.kr/data/15124404/fileData.do

Alerts

사진여부 has constant value ""Constant
위반법조항 has constant value ""Constant
관리기관 has constant value ""Constant
데이터기준일 has constant value ""Constant
순번 is highly overall correlated with 위반장소명High correlation
위반장소명 is highly overall correlated with 순번High correlation
과태료금액 is highly imbalanced (92.1%)Imbalance
순번 has unique valuesUnique

Reproduction

Analysis started2023-12-11 23:05:46.550897
Analysis finished2023-12-11 23:05:47.143239
Duration0.59 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

순번
Real number (ℝ)

HIGH CORRELATION  UNIQUE 

Distinct2122
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean1061.5
Minimum1
Maximum2122
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size18.8 KiB
2023-12-12T08:05:47.204724image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile107.05
Q1531.25
median1061.5
Q31591.75
95-th percentile2015.95
Maximum2122
Range2121
Interquartile range (IQR)1060.5

Descriptive statistics

Standard deviation612.71296
Coefficient of variation (CV)0.57721428
Kurtosis-1.2
Mean1061.5
Median Absolute Deviation (MAD)530.5
Skewness0
Sum2252503
Variance375417.17
MonotonicityStrictly increasing
2023-12-12T08:05:47.325916image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
1 1
 
< 0.1%
1411 1
 
< 0.1%
1425 1
 
< 0.1%
1424 1
 
< 0.1%
1423 1
 
< 0.1%
1422 1
 
< 0.1%
1421 1
 
< 0.1%
1420 1
 
< 0.1%
1419 1
 
< 0.1%
1418 1
 
< 0.1%
Other values (2112) 2112
99.5%
ValueCountFrequency (%)
1 1
< 0.1%
2 1
< 0.1%
3 1
< 0.1%
4 1
< 0.1%
5 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
8 1
< 0.1%
9 1
< 0.1%
10 1
< 0.1%
ValueCountFrequency (%)
2122 1
< 0.1%
2121 1
< 0.1%
2120 1
< 0.1%
2119 1
< 0.1%
2118 1
< 0.1%
2117 1
< 0.1%
2116 1
< 0.1%
2115 1
< 0.1%
2114 1
< 0.1%
2113 1
< 0.1%
Distinct279
Distinct (%)13.1%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
Minimum2023-01-01 00:00:00
Maximum2023-10-10 00:00:00
2023-12-12T08:05:47.431554image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:05:47.552377image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct559
Distinct (%)26.3%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
Minimum2023-12-12 07:00:00
Maximum2023-12-12 21:49:00
2023-12-12T08:05:47.662163image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:05:47.788303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소명
Categorical

HIGH CORRELATION 

Distinct5
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
산척동 우성상가 부근
1215 
산척동 우성센트럴사거리
737 
산척동 더제이시티삼거리
139 
산척동 우성에듀파크부근
 
24
산척동 우성센트럴삼거리
 
7

Length

Max length12
Median length11
Mean length11.427427
Min length11

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row산척동 우성에듀파크부근
2nd row산척동 우성에듀파크부근
3rd row산척동 우성에듀파크부근
4th row산척동 우성에듀파크부근
5th row산척동 우성에듀파크부근

Common Values

ValueCountFrequency (%)
산척동 우성상가 부근 1215
57.3%
산척동 우성센트럴사거리 737
34.7%
산척동 더제이시티삼거리 139
 
6.6%
산척동 우성에듀파크부근 24
 
1.1%
산척동 우성센트럴삼거리 7
 
0.3%

Length

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

Common Values (Plot)

2023-12-12T08:05:47.995778image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
산척동 2122
38.9%
우성상가 1215
22.3%
부근 1215
22.3%
우성센트럴사거리 737
 
13.5%
더제이시티삼거리 139
 
2.5%
우성에듀파크부근 24
 
0.4%
우성센트럴삼거리 7
 
0.1%

과태료금액
Categorical

IMBALANCE 

Distinct4
Distinct (%)0.2%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
40000
2077 
50000
 
41
80000
 
3
0
 
1

Length

Max length5
Median length5
Mean length4.998115
Min length1

Unique

Unique1 ?
Unique (%)< 0.1%

Sample

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

Common Values

ValueCountFrequency (%)
40000 2077
97.9%
50000 41
 
1.9%
80000 3
 
0.1%
0 1
 
< 0.1%

Length

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

Common Values (Plot)

2023-12-12T08:05:48.216493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
40000 2077
97.9%
50000 41
 
1.9%
80000 3
 
0.1%
0 1
 
< 0.1%

사진여부
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
2122 

Length

Max length1
Median length1
Mean length1
Min length1

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2122
100.0%

Length

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

Common Values (Plot)

2023-12-12T08:05:48.396668image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2122
100.0%

위반법조항
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
도로교통법 제33조
2122 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도로교통법 제33조
2nd row도로교통법 제33조
3rd row도로교통법 제33조
4th row도로교통법 제33조
5th row도로교통법 제33조

Common Values

ValueCountFrequency (%)
도로교통법 제33조 2122
100.0%

Length

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

Common Values (Plot)

2023-12-12T08:05:48.556147image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도로교통법 2122
50.0%
제33조 2122
50.0%

관리기관
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
화성시
2122 

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 (%)
화성시 2122
100.0%

Length

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

Common Values (Plot)

2023-12-12T08:05:48.715350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
화성시 2122
100.0%

데이터기준일
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.7 KiB
2023-10-11
2122 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023-10-11 2122
100.0%

Length

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

Common Values (Plot)

2023-12-12T08:05:48.875416image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-10-11 2122
100.0%

Interactions

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

Correlations

2023-12-12T08:05:48.927225image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위반장소명과태료금액
순번1.0000.9240.000
위반장소명0.9241.0000.150
과태료금액0.0000.1501.000
2023-12-12T08:05:49.004241image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
위반장소명과태료금액
위반장소명1.0000.123
과태료금액0.1231.000
2023-12-12T08:05:49.358947image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
순번위반장소명과태료금액
순번1.0000.6320.000
위반장소명0.6321.0000.123
과태료금액0.0000.1231.000

Missing values

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

순번위반일자위반시간위반장소명과태료금액사진여부위반법조항관리기관데이터기준일
012023-10-0516:21산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
122023-04-1416:00산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
232023-02-2808:16산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
342023-02-2315:01산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
452023-07-2707:02산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
562023-04-1307:32산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
672023-05-3007:01산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
782023-08-1707:01산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
892023-02-2819:32산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
9102023-08-2407:01산척동 우성에듀파크부근40000도로교통법 제33조화성시2023-10-11
순번위반일자위반시간위반장소명과태료금액사진여부위반법조항관리기관데이터기준일
211221132023-05-0218:00산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
211321142023-03-2217:10산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
211421152023-03-1017:03산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
211521162023-08-1916:55산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
211621172023-08-0408:33산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
211721182023-08-2220:10산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
211821192023-09-1610:38산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
211921202023-03-2917:36산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
212021212023-06-2708:02산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11
212121222023-04-1415:55산척동 더제이시티삼거리40000도로교통법 제33조화성시2023-10-11