Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory556.6 KiB
Average record size in memory57.0 B

Variable types

Numeric1
Categorical2
DateTime2
Text1

Dataset

Description2023년도 양평군 내 각 읍면별 불법 주정차 단속 현황(연번, 시군명, 단속일자, 단속시간, 단속읍면명, 단속세부장소 등) 입니다.
Author경기도 양평군
URLhttps://www.data.go.kr/data/15125347/fileData.do

Alerts

시군명 has constant value ""Constant
단속읍면명 is highly imbalanced (66.0%)Imbalance
연번 has unique valuesUnique

Reproduction

Analysis started2023-12-12 10:20:27.776499
Analysis finished2023-12-12 10:20:28.462644
Duration0.69 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

연번
Real number (ℝ)

UNIQUE 

Distinct10000
Distinct (%)100.0%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean11714.331
Minimum3
Maximum23417
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-12T19:20:28.534928image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum3
5-th percentile1231.8
Q15832.25
median11664.5
Q317584.25
95-th percentile22245.05
Maximum23417
Range23414
Interquartile range (IQR)11752

Descriptive statistics

Standard deviation6757.6811
Coefficient of variation (CV)0.57687297
Kurtosis-1.2060981
Mean11714.331
Median Absolute Deviation (MAD)5883.5
Skewness0.0047308835
Sum1.1714331 × 108
Variance45666253
MonotonicityNot monotonic
2023-12-12T19:20:28.713191image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
ValueCountFrequency (%)
9775 1
 
< 0.1%
5455 1
 
< 0.1%
21884 1
 
< 0.1%
7741 1
 
< 0.1%
1140 1
 
< 0.1%
13037 1
 
< 0.1%
10906 1
 
< 0.1%
8468 1
 
< 0.1%
11116 1
 
< 0.1%
5980 1
 
< 0.1%
Other values (9990) 9990
99.9%
ValueCountFrequency (%)
3 1
< 0.1%
4 1
< 0.1%
6 1
< 0.1%
7 1
< 0.1%
16 1
< 0.1%
17 1
< 0.1%
18 1
< 0.1%
20 1
< 0.1%
23 1
< 0.1%
25 1
< 0.1%
ValueCountFrequency (%)
23417 1
< 0.1%
23416 1
< 0.1%
23415 1
< 0.1%
23413 1
< 0.1%
23412 1
< 0.1%
23407 1
< 0.1%
23404 1
< 0.1%
23400 1
< 0.1%
23395 1
< 0.1%
23393 1
< 0.1%

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

Common Values (Plot)

2023-12-12T19:20:29.047729image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
양평군 10000
100.0%
Distinct320
Distinct (%)3.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-02 00:00:00
Maximum2023-11-30 00:00:00
2023-12-12T19:20:29.570013image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:20:29.730567image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)
Distinct769
Distinct (%)7.7%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-12-12 00:01:00
Maximum2023-12-12 23:42:00
2023-12-12T19:20:29.924727image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T19:20:30.096681image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속읍면명
Categorical

IMBALANCE 

Distinct12
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
경기도 양평군 양평읍
6469 
경기도 양평군 용문면
2911 
경기도 양평군 양서면
 
555
경기도 양평군 지평면
 
28
경기도 양평군 서종면
 
9
Other values (7)
 
28

Length

Max length11
Median length11
Mean length11
Min length11

Unique

Unique2 ?
Unique (%)< 0.1%

Sample

1st row경기도 양평군 양평읍
2nd row경기도 양평군 양평읍
3rd row경기도 양평군 용문면
4th row경기도 양평군 용문면
5th row경기도 양평군 용문면

Common Values

ValueCountFrequency (%)
경기도 양평군 양평읍 6469
64.7%
경기도 양평군 용문면 2911
29.1%
경기도 양평군 양서면 555
 
5.5%
경기도 양평군 지평면 28
 
0.3%
경기도 양평군 서종면 9
 
0.1%
경기도 양평군 강하면 8
 
0.1%
경기도 양평군 개군면 8
 
0.1%
경기도 양평군 옥천면 5
 
0.1%
경기도 양평군 강상면 3
 
< 0.1%
경기도 양평군 양동면 2
 
< 0.1%
Other values (2) 2
 
< 0.1%

Length

2023-12-12T19:20:30.250309image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
경기도 10000
33.3%
양평군 10000
33.3%
양평읍 6469
21.6%
용문면 2911
 
9.7%
양서면 555
 
1.8%
지평면 28
 
0.1%
서종면 9
 
< 0.1%
강하면 8
 
< 0.1%
개군면 8
 
< 0.1%
옥천면 5
 
< 0.1%
Other values (4) 7
 
< 0.1%
Distinct584
Distinct (%)5.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-12T19:20:30.444426image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length23
Median length22
Mean length8.2124
Min length4

Characters and Unicode

Total characters82124
Distinct characters155
Distinct categories7 ?
Distinct scripts2 ?
Distinct blocks2 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique447 ?
Unique (%)4.5%

Sample

1st row양평읍양근리397-3(인도)
2nd row역전길 부근
3rd row용문로사거리부근
4th row용문교회 부근
5th row용문로사거리부근
ValueCountFrequency (%)
부근 5067
25.7%
삼거리 1264
 
6.4%
양평시장 1254
 
6.3%
용문로사거리부근 1038
 
5.3%
양평역 1038
 
5.3%
944
 
4.8%
용문교회 679
 
3.4%
사거리 642
 
3.3%
본죽 621
 
3.1%
역전길 593
 
3.0%
Other values (601) 6611
33.5%
2023-12-12T19:20:30.810128image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9751
 
11.9%
7052
 
8.6%
6145
 
7.5%
5178
 
6.3%
4842
 
5.9%
4105
 
5.0%
3875
 
4.7%
2695
 
3.3%
2324
 
2.8%
2197
 
2.7%
Other values (145) 33960
41.4%

Most occurring categories

ValueCountFrequency (%)
Other Letter 66543
81.0%
Space Separator 9751
 
11.9%
Decimal Number 3583
 
4.4%
Open Punctuation 813
 
1.0%
Close Punctuation 813
 
1.0%
Dash Punctuation 619
 
0.8%
Other Punctuation 2
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
7052
 
10.6%
6145
 
9.2%
5178
 
7.8%
4842
 
7.3%
4105
 
6.2%
3875
 
5.8%
2695
 
4.1%
2324
 
3.5%
2197
 
3.3%
2033
 
3.1%
Other values (130) 26097
39.2%
Decimal Number
ValueCountFrequency (%)
1 814
22.7%
2 546
15.2%
3 370
10.3%
6 307
 
8.6%
4 295
 
8.2%
9 291
 
8.1%
0 270
 
7.5%
7 258
 
7.2%
8 227
 
6.3%
5 205
 
5.7%
Space Separator
ValueCountFrequency (%)
9751
100.0%
Open Punctuation
ValueCountFrequency (%)
( 813
100.0%
Close Punctuation
ValueCountFrequency (%)
) 813
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 619
100.0%
Other Punctuation
ValueCountFrequency (%)
, 2
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 66543
81.0%
Common 15581
 
19.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
7052
 
10.6%
6145
 
9.2%
5178
 
7.8%
4842
 
7.3%
4105
 
6.2%
3875
 
5.8%
2695
 
4.1%
2324
 
3.5%
2197
 
3.3%
2033
 
3.1%
Other values (130) 26097
39.2%
Common
ValueCountFrequency (%)
9751
62.6%
1 814
 
5.2%
( 813
 
5.2%
) 813
 
5.2%
- 619
 
4.0%
2 546
 
3.5%
3 370
 
2.4%
6 307
 
2.0%
4 295
 
1.9%
9 291
 
1.9%
Other values (5) 962
 
6.2%

Most occurring blocks

ValueCountFrequency (%)
Hangul 66543
81.0%
ASCII 15581
 
19.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9751
62.6%
1 814
 
5.2%
( 813
 
5.2%
) 813
 
5.2%
- 619
 
4.0%
2 546
 
3.5%
3 370
 
2.4%
6 307
 
2.0%
4 295
 
1.9%
9 291
 
1.9%
Other values (5) 962
 
6.2%
Hangul
ValueCountFrequency (%)
7052
 
10.6%
6145
 
9.2%
5178
 
7.8%
4842
 
7.3%
4105
 
6.2%
3875
 
5.8%
2695
 
4.1%
2324
 
3.5%
2197
 
3.3%
2033
 
3.1%
Other values (130) 26097
39.2%

Interactions

2023-12-12T19:20:28.179303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-12T19:20:30.904669image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번단속읍면명
연번1.0000.053
단속읍면명0.0531.000
2023-12-12T19:20:30.992157image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
연번단속읍면명
연번1.0000.022
단속읍면명0.0221.000

Missing values

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

연번시군명단속일자단속시간단속읍면명단속세부장소
97749775양평군2023-05-3014:36경기도 양평군 양평읍양평읍양근리397-3(인도)
87108711양평군2023-05-1315:01경기도 양평군 양평읍역전길 부근
39063907양평군2023-03-1010:35경기도 양평군 용문면용문로사거리부근
49844985양평군2023-03-2509:07경기도 양평군 용문면용문교회 부근
25972598양평군2023-02-1613:55경기도 양평군 용문면용문로사거리부근
1826118262양평군2023-09-2516:56경기도 양평군 용문면용문로사거리부근
10571058양평군2023-01-1816:25경기도 양평군 양평읍양평삼거리 부근
77587759양평군2023-05-0218:42경기도 양평군 용문면용문로사거리부근
1531315314양평군2023-08-1615:16경기도 양평군 용문면용문로사거리부근
2071120712양평군2023-10-2816:42경기도 양평군 양서면신원리504-19(일반주정차금지구역)
연번시군명단속일자단속시간단속읍면명단속세부장소
1679016791양평군2023-09-0617:52경기도 양평군 양평읍양평시장 내 삼거리
63896390양평군2023-04-1309:10경기도 양평군 양평읍역전길 부근
1068010681양평군2023-06-1116:30경기도 양평군 양평읍양평역 앞 부근
1784817849양평군2023-09-2016:03경기도 양평군 용문면용문로사거리부근
2241522416양평군2023-11-1810:42경기도 양평군 양평읍우리예식장 앞
2333323334양평군2023-11-3010:20경기도 양평군 양평읍양평시장 내 삼거리
393394양평군2023-01-0710:20경기도 양평군 양평읍남한강마트 부근
415416양평군2023-01-0714:58경기도 양평군 용문면용문역 부근
2148421485양평군2023-11-0808:07경기도 양평군 양평읍양평삼거리 부근
18731874양평군2023-02-0318:57경기도 양평군 양평읍양평시장 전광판