Overview

Dataset statistics

Number of variables7
Number of observations222
Missing cells0
Missing cells (%)0.0%
Duplicate rows0
Duplicate rows (%)0.0%
Total size in memory12.9 KiB
Average record size in memory59.6 B

Variable types

Categorical3
Text1
Numeric2
DateTime1

Dataset

Description충청남도 부여군 주정차단속 현황에 대한 정보입니다.(단속년도, 단속구분, 단속지역, 단속위치정보, 문자발송건수, 단속건수 등)
Author충청남도
URLhttps://alldam.chungnam.go.kr/index.chungnam?menuCd=DOM_000000201001001001&st=&cds=&orgCd=&apiType=&isOpen=Y&pageIndex=411&beforeMenuCd=DOM_000000201001001000&publicdatapk=15040579

Alerts

단속년도 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 (52.7%)Imbalance
단속지역 is highly imbalanced (76.2%)Imbalance

Reproduction

Analysis started2024-01-09 21:38:41.727158
Analysis finished2024-01-09 21:38:42.325641
Duration0.6 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

단속년도
Categorical

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2022
222 

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 222
100.0%

Length

2024-01-10T06:38:42.372865image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:38:42.442914image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 222
100.0%

단속구분
Categorical

IMBALANCE 

Distinct3
Distinct (%)1.4%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
민원신고
189 
고정형CCTV단속
20 
이동형CCTV단속
 
13

Length

Max length9
Median length4
Mean length4.7432432
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 (%)
민원신고 189
85.1%
고정형CCTV단속 20
 
9.0%
이동형CCTV단속 13
 
5.9%

Length

2024-01-10T06:38:42.526429image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:38:42.608298image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
민원신고 189
85.1%
고정형cctv단속 20
 
9.0%
이동형cctv단속 13
 
5.9%

단속지역
Categorical

IMBALANCE 

Distinct6
Distinct (%)2.7%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
부여군 부여읍
199 
부여군 규암면
 
17
부여군 홍산면
 
3
부여군 임천면
 
1
부여군 은산면
 
1

Length

Max length7
Median length7
Mean length7
Min length7

Unique

Unique3 ?
Unique (%)1.4%

Sample

1st row부여군 부여읍
2nd row부여군 부여읍
3rd row부여군 부여읍
4th row부여군 규암면
5th row부여군 부여읍

Common Values

ValueCountFrequency (%)
부여군 부여읍 199
89.6%
부여군 규암면 17
 
7.7%
부여군 홍산면 3
 
1.4%
부여군 임천면 1
 
0.5%
부여군 은산면 1
 
0.5%
부여군 초촌면 1
 
0.5%

Length

2024-01-10T06:38:42.687493image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-01-10T06:38:42.770126image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
부여군 222
50.0%
부여읍 199
44.8%
규암면 17
 
3.8%
홍산면 3
 
0.7%
임천면 1
 
0.2%
은산면 1
 
0.2%
초촌면 1
 
0.2%
Distinct215
Distinct (%)96.8%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
2024-01-10T06:38:42.968109image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length22
Median length20
Mean length15.833333
Min length5

Characters and Unicode

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

Unique

Unique208 ?
Unique (%)93.7%

Sample

1st row고려약국 부근
2nd row관광주차장
3rd row궁남초등학교 주변
4th row규암초등학교 주변
5th row동산약국 앞
ValueCountFrequency (%)
부여읍 168
38.4%
부근 19
 
4.3%
규암면 16
 
3.7%
홍산면 3
 
0.7%
주변 3
 
0.7%
3
 
0.7%
새마을금고 2
 
0.5%
고려약국 2
 
0.5%
동양한의원 2
 
0.5%
이조돌구이 2
 
0.5%
Other values (214) 217
49.7%
2024-01-10T06:38:43.278173image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
215
 
6.1%
192
 
5.5%
192
 
5.5%
( 189
 
5.4%
) 189
 
5.4%
172
 
4.9%
168
 
4.8%
1 136
 
3.9%
- 133
 
3.8%
3 111
 
3.2%
Other values (124) 1818
51.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 2081
59.2%
Decimal Number 708
 
20.1%
Space Separator 215
 
6.1%
Open Punctuation 189
 
5.4%
Close Punctuation 189
 
5.4%
Dash Punctuation 133
 
3.8%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
192
 
9.2%
192
 
9.2%
172
 
8.3%
168
 
8.1%
103
 
4.9%
91
 
4.4%
84
 
4.0%
81
 
3.9%
81
 
3.9%
75
 
3.6%
Other values (110) 842
40.5%
Decimal Number
ValueCountFrequency (%)
1 136
19.2%
3 111
15.7%
2 109
15.4%
4 67
9.5%
5 60
8.5%
7 57
8.1%
6 55
7.8%
9 51
 
7.2%
8 37
 
5.2%
0 25
 
3.5%
Space Separator
ValueCountFrequency (%)
215
100.0%
Open Punctuation
ValueCountFrequency (%)
( 189
100.0%
Close Punctuation
ValueCountFrequency (%)
) 189
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 133
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 2081
59.2%
Common 1434
40.8%

Most frequent character per script

Hangul
ValueCountFrequency (%)
192
 
9.2%
192
 
9.2%
172
 
8.3%
168
 
8.1%
103
 
4.9%
91
 
4.4%
84
 
4.0%
81
 
3.9%
81
 
3.9%
75
 
3.6%
Other values (110) 842
40.5%
Common
ValueCountFrequency (%)
215
15.0%
( 189
13.2%
) 189
13.2%
1 136
9.5%
- 133
9.3%
3 111
7.7%
2 109
7.6%
4 67
 
4.7%
5 60
 
4.2%
7 57
 
4.0%
Other values (4) 168
11.7%

Most occurring blocks

ValueCountFrequency (%)
Hangul 2081
59.2%
ASCII 1434
40.8%

Most frequent character per block

ASCII
ValueCountFrequency (%)
215
15.0%
( 189
13.2%
) 189
13.2%
1 136
9.5%
- 133
9.3%
3 111
7.7%
2 109
7.6%
4 67
 
4.7%
5 60
 
4.2%
7 57
 
4.0%
Other values (4) 168
11.7%
Hangul
ValueCountFrequency (%)
192
 
9.2%
192
 
9.2%
172
 
8.3%
168
 
8.1%
103
 
4.9%
91
 
4.4%
84
 
4.0%
81
 
3.9%
81
 
3.9%
75
 
3.6%
Other values (110) 842
40.5%

문자발송건수
Real number (ℝ)

HIGH CORRELATION 

Distinct37
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.175676
Minimum1
Maximum916
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2024-01-10T06:38:43.386400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q33
95-th percentile56.85
Maximum916
Range915
Interquartile range (IQR)2

Descriptive statistics

Standard deviation72.781585
Coefficient of variation (CV)4.795937
Kurtosis110.66469
Mean15.175676
Median Absolute Deviation (MAD)0
Skewness9.6889151
Sum3369
Variance5297.159
MonotonicityNot monotonic
2024-01-10T06:38:43.482501image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
1 141
63.5%
2 24
 
10.8%
3 13
 
5.9%
4 4
 
1.8%
5 3
 
1.4%
10 3
 
1.4%
21 2
 
0.9%
37 2
 
0.9%
16 2
 
0.9%
57 1
 
0.5%
Other values (27) 27
 
12.2%
ValueCountFrequency (%)
1 141
63.5%
2 24
 
10.8%
3 13
 
5.9%
4 4
 
1.8%
5 3
 
1.4%
6 1
 
0.5%
7 1
 
0.5%
8 1
 
0.5%
9 1
 
0.5%
10 3
 
1.4%
ValueCountFrequency (%)
916 1
0.5%
398 1
0.5%
255 1
0.5%
213 1
0.5%
188 1
0.5%
145 1
0.5%
119 1
0.5%
102 1
0.5%
92 1
0.5%
63 1
0.5%

단속건수
Real number (ℝ)

HIGH CORRELATION 

Distinct37
Distinct (%)16.7%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean15.175676
Minimum1
Maximum916
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size2.1 KiB
2024-01-10T06:38:43.573618image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum1
5-th percentile1
Q11
median1
Q33
95-th percentile56.85
Maximum916
Range915
Interquartile range (IQR)2

Descriptive statistics

Standard deviation72.781585
Coefficient of variation (CV)4.795937
Kurtosis110.66469
Mean15.175676
Median Absolute Deviation (MAD)0
Skewness9.6889151
Sum3369
Variance5297.159
MonotonicityNot monotonic
2024-01-10T06:38:43.671034image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=37)
ValueCountFrequency (%)
1 141
63.5%
2 24
 
10.8%
3 13
 
5.9%
4 4
 
1.8%
5 3
 
1.4%
10 3
 
1.4%
21 2
 
0.9%
37 2
 
0.9%
16 2
 
0.9%
57 1
 
0.5%
Other values (27) 27
 
12.2%
ValueCountFrequency (%)
1 141
63.5%
2 24
 
10.8%
3 13
 
5.9%
4 4
 
1.8%
5 3
 
1.4%
6 1
 
0.5%
7 1
 
0.5%
8 1
 
0.5%
9 1
 
0.5%
10 3
 
1.4%
ValueCountFrequency (%)
916 1
0.5%
398 1
0.5%
255 1
0.5%
213 1
0.5%
188 1
0.5%
145 1
0.5%
119 1
0.5%
102 1
0.5%
92 1
0.5%
63 1
0.5%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size1.9 KiB
Minimum2022-08-31 00:00:00
Maximum2022-08-31 00:00:00
2024-01-10T06:38:43.745636image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:38:43.809759image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-01-10T06:38:42.071381image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:38:41.947715image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:38:42.127774image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-01-10T06:38:42.013568image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-01-10T06:38:43.861814image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속구분단속지역문자발송건수단속건수
단속구분1.0000.1810.3630.363
단속지역0.1811.0000.0000.000
문자발송건수0.3630.0001.0001.000
단속건수0.3630.0001.0001.000
2024-01-10T06:38:43.930739image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속지역단속구분
단속지역1.0000.074
단속구분0.0741.000
2024-01-10T06:38:43.995303image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
문자발송건수단속건수단속구분단속지역
문자발송건수1.0001.0000.2930.000
단속건수1.0001.0000.2930.000
단속구분0.2930.2931.0000.074
단속지역0.0000.0000.0741.000

Missing values

2024-01-10T06:38:42.206341image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-01-10T06:38:42.291414image/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

단속년도단속구분단속지역단속위치정보문자발송건수단속건수데이터기준일자
02022고정형CCTV단속부여군 부여읍고려약국 부근222022-08-31
12022고정형CCTV단속부여군 부여읍관광주차장14142022-08-31
22022고정형CCTV단속부여군 부여읍궁남초등학교 주변1881882022-08-31
32022고정형CCTV단속부여군 규암면규암초등학교 주변1451452022-08-31
42022고정형CCTV단속부여군 부여읍동산약국 앞2552552022-08-31
52022고정형CCTV단속부여군 부여읍동양한의원 부근332022-08-31
62022고정형CCTV단속부여군 부여읍미성삼거리16162022-08-31
72022고정형CCTV단속부여군 부여읍백제초등학교54542022-08-31
82022고정형CCTV단속부여군 부여읍부소산성 입구442022-08-31
92022고정형CCTV단속부여군 부여읍부여초등학교34342022-08-31
단속년도단속구분단속지역단속위치정보문자발송건수단속건수데이터기준일자
2122022이동형CCTV단속부여군 부여읍부여군보건소 부근16162022-08-31
2132022이동형CCTV단속부여군 부여읍부여시외버스터미널 부근28282022-08-31
2142022이동형CCTV단속부여군 부여읍새마을금고 부근1191192022-08-31
2152022이동형CCTV단속부여군 부여읍시외버스터미널 부근37372022-08-31
2162022이동형CCTV단속부여군 부여읍이조돌구이 부근21212022-08-31
2172022이동형CCTV단속부여군 부여읍정림사지 부근11112022-08-31
2182022이동형CCTV단속부여군 부여읍중앙시장입구 부근15152022-08-31
2192022이동형CCTV단속부여군 부여읍충무체육사 부근552022-08-31
2202022이동형CCTV단속부여군 부여읍하나은행 부근37372022-08-31
2212022이동형CCTV단속부여군 부여읍하이마트 부근112022-08-31