Overview

Dataset statistics

Number of variables7
Number of observations2148
Missing cells0
Missing cells (%)0.0%
Duplicate rows51
Duplicate rows (%)2.4%
Total size in memory119.7 KiB
Average record size in memory57.1 B

Variable types

Categorical5
Text2

Dataset

Description주정차위반과태료/ 부과대상/위반장소/위반내역/단속장비 등을 2020년 CCTV단속현황 상세한 정보를 알 수 있습니다.
URLhttps://www.data.go.kr/data/15089346/fileData.do

Alerts

집계년도 has constant value ""Constant
시군명 has constant value ""Constant
관리기관명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 51 (2.4%) duplicate rowsDuplicates
단속방법 is highly imbalanced (74.1%)Imbalance

Reproduction

Analysis started2023-12-12 12:56:21.996638
Analysis finished2023-12-12 12:56:22.543897
Duration0.55 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

집계년도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
2023
2148 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

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

Common Values

ValueCountFrequency (%)
2023 2148
100.0%

Length

2023-12-12T21:56:22.626290image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:56:22.752415image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 2148
100.0%

시군명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
의왕시
2148 

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 (%)
의왕시 2148
100.0%

Length

2023-12-12T21:56:22.869130image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:56:22.983762image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의왕시 2148
100.0%

관리기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
의왕시청
2148 

Length

Max length4
Median length4
Mean length4
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row의왕시청
2nd row의왕시청
3rd row의왕시청
4th row의왕시청
5th row의왕시청

Common Values

ValueCountFrequency (%)
의왕시청 2148
100.0%

Length

2023-12-12T21:56:23.118619image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:56:23.237936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
의왕시청 2148
100.0%

단속일시정보
Text

Distinct1915
Distinct (%)89.2%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
2023-12-12T21:56:23.701833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length18
Median length16
Mean length16.004655
Min length16

Characters and Unicode

Total characters34378
Distinct characters15
Distinct categories6 ?
Distinct scripts1 ?
Distinct blocks1 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1745 ?
Unique (%)81.2%

Sample

1st row2023-03-08 16:05
2nd row2023-03-08 16:00
3rd row2023-03-08 15:59
4th row2023-03-08 15:58
5th row2023-03-08 15:56
ValueCountFrequency (%)
2023-03-02 61
 
1.4%
2023-03-06 57
 
1.3%
2023-01-19 54
 
1.3%
2023-01-09 52
 
1.2%
2023-01-02 51
 
1.2%
2023-01-30 49
 
1.1%
2023-02-27 48
 
1.1%
2023-01-16 46
 
1.1%
2023-01-31 45
 
1.0%
2023-02-13 45
 
1.0%
Other values (791) 3788
88.2%
2023-12-12T21:56:24.425498image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
2 7080
20.6%
0 6735
19.6%
- 4296
12.5%
1 4088
11.9%
3 3476
10.1%
2148
 
6.2%
: 2148
 
6.2%
5 1124
 
3.3%
4 988
 
2.9%
9 767
 
2.2%
Other values (5) 1528
 
4.4%

Most occurring categories

ValueCountFrequency (%)
Decimal Number 25776
75.0%
Dash Punctuation 4296
 
12.5%
Space Separator 2148
 
6.2%
Other Punctuation 2148
 
6.2%
Open Punctuation 5
 
< 0.1%
Close Punctuation 5
 
< 0.1%

Most frequent character per category

Decimal Number
ValueCountFrequency (%)
2 7080
27.5%
0 6735
26.1%
1 4088
15.9%
3 3476
13.5%
5 1124
 
4.4%
4 988
 
3.8%
9 767
 
3.0%
6 526
 
2.0%
8 512
 
2.0%
7 480
 
1.9%
Dash Punctuation
ValueCountFrequency (%)
- 4296
100.0%
Space Separator
ValueCountFrequency (%)
2148
100.0%
Other Punctuation
ValueCountFrequency (%)
: 2148
100.0%
Open Punctuation
ValueCountFrequency (%)
( 5
100.0%
Close Punctuation
ValueCountFrequency (%)
) 5
100.0%

Most occurring scripts

ValueCountFrequency (%)
Common 34378
100.0%

Most frequent character per script

Common
ValueCountFrequency (%)
2 7080
20.6%
0 6735
19.6%
- 4296
12.5%
1 4088
11.9%
3 3476
10.1%
2148
 
6.2%
: 2148
 
6.2%
5 1124
 
3.3%
4 988
 
2.9%
9 767
 
2.2%
Other values (5) 1528
 
4.4%

Most occurring blocks

ValueCountFrequency (%)
ASCII 34378
100.0%

Most frequent character per block

ASCII
ValueCountFrequency (%)
2 7080
20.6%
0 6735
19.6%
- 4296
12.5%
1 4088
11.9%
3 3476
10.1%
2148
 
6.2%
: 2148
 
6.2%
5 1124
 
3.3%
4 988
 
2.9%
9 767
 
2.2%
Other values (5) 1528
 
4.4%

단속장소
Text

Distinct644
Distinct (%)30.0%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
2023-12-12T21:56:24.709078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length27
Median length24
Mean length15.86825
Min length9

Characters and Unicode

Total characters34085
Distinct characters425
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

Unique335 ?
Unique (%)15.6%

Sample

1st row왕곡동 위인로 주변
2nd row왕곡동 GS수퍼 주변
3rd row왕곡동 GS수퍼 주변
4th row왕곡동 GS수퍼 주변
5th row내손2동 경춘빌라 주변
ValueCountFrequency (%)
주변 1558
22.4%
횡단보도 447
 
6.4%
부곡동 302
 
4.3%
교차로 261
 
3.7%
소화전 191
 
2.7%
내손1동 187
 
2.7%
포일동 153
 
2.2%
오전동 149
 
2.1%
봇들로 138
 
2.0%
부곡초등3길 137
 
2.0%
Other values (617) 3440
49.4%
2023-12-12T21:56:25.121527image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
5846
 
17.2%
주 2293
 
6.7%
변 1974
 
5.8%
동 1168
 
3.4%
로 1117
 
3.3%
곡 805
 
2.4%
부 691
 
2.0%
단 581
 
1.7%
도 576
 
1.7%
교 524
 
1.5%
Other values (415) 18510
54.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 26564
77.9%
Space Separator 5846
 
17.2%
Decimal Number 1071
 
3.1%
Uppercase Letter 327
 
1.0%
Open Punctuation 132
 
0.4%
Close Punctuation 112
 
0.3%
Lowercase Letter 29
 
0.1%
Other Punctuation 3
 
< 0.1%
Dash Punctuation 1
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
주 2293
 
8.6%
변 1974
 
7.4%
동 1168
 
4.4%
로 1117
 
4.2%
곡 805
 
3.0%
부 691
 
2.6%
단 581
 
2.2%
도 576
 
2.2%
교 524
 
2.0%
보 521
 
2.0%
Other values (382) 16314
61.4%
Uppercase Letter
ValueCountFrequency (%)
T 65
19.9%
S 61
18.7%
G 58
17.7%
A 54
16.5%
P 49
15.0%
K 18
 
5.5%
C 8
 
2.4%
U 6
 
1.8%
M 3
 
0.9%
H 3
 
0.9%
Decimal Number
ValueCountFrequency (%)
1 383
35.8%
2 282
26.3%
3 202
18.9%
5 94
 
8.8%
4 71
 
6.6%
7 13
 
1.2%
9 10
 
0.9%
0 8
 
0.7%
6 8
 
0.7%
Lowercase Letter
ValueCountFrequency (%)
t 9
31.0%
k 9
31.0%
s 3
 
10.3%
g 3
 
10.3%
e 2
 
6.9%
b 1
 
3.4%
h 1
 
3.4%
c 1
 
3.4%
Space Separator
ValueCountFrequency (%)
5846
100.0%
Open Punctuation
ValueCountFrequency (%)
( 132
100.0%
Close Punctuation
ValueCountFrequency (%)
) 112
100.0%
Other Punctuation
ValueCountFrequency (%)
? 3
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 26564
77.9%
Common 7165
 
21.0%
Latin 356
 
1.0%

Most frequent character per script

Hangul
ValueCountFrequency (%)
주 2293
 
8.6%
변 1974
 
7.4%
동 1168
 
4.4%
로 1117
 
4.2%
곡 805
 
3.0%
부 691
 
2.6%
단 581
 
2.2%
도 576
 
2.2%
교 524
 
2.0%
보 521
 
2.0%
Other values (382) 16314
61.4%
Latin
ValueCountFrequency (%)
T 65
18.3%
S 61
17.1%
G 58
16.3%
A 54
15.2%
P 49
13.8%
K 18
 
5.1%
t 9
 
2.5%
k 9
 
2.5%
C 8
 
2.2%
U 6
 
1.7%
Other values (9) 19
 
5.3%
Common
ValueCountFrequency (%)
5846
81.6%
1 383
 
5.3%
2 282
 
3.9%
3 202
 
2.8%
( 132
 
1.8%
) 112
 
1.6%
5 94
 
1.3%
4 71
 
1.0%
7 13
 
0.2%
9 10
 
0.1%
Other values (4) 20
 
0.3%

Most occurring blocks

ValueCountFrequency (%)
Hangul 26564
77.9%
ASCII 7521
 
22.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
5846
77.7%
1 383
 
5.1%
2 282
 
3.7%
3 202
 
2.7%
( 132
 
1.8%
) 112
 
1.5%
5 94
 
1.2%
4 71
 
0.9%
T 65
 
0.9%
S 61
 
0.8%
Other values (23) 273
 
3.6%
Hangul
ValueCountFrequency (%)
주 2293
 
8.6%
변 1974
 
7.4%
동 1168
 
4.4%
로 1117
 
4.2%
곡 805
 
3.0%
부 691
 
2.6%
단 581
 
2.2%
도 576
 
2.2%
교 524
 
2.0%
보 521
 
2.0%
Other values (382) 16314
61.4%

단속방법
Categorical

IMBALANCE 

Distinct19
Distinct (%)0.9%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
민원신고
1097 
PDA단속
1032 
<NA>
 
3
민원신고/2시간이상동일장소 2023-01-10 06:16
 
1
주민신고
 
1
Other values (14)
 
14

Length

Max length49
Median length4
Mean length4.6871508
Min length4

Unique

Unique16 ?
Unique (%)0.7%

Sample

1st rowPDA단속
2nd rowPDA단속
3rd rowPDA단속
4th rowPDA단속
5th rowPDA단속

Common Values

ValueCountFrequency (%)
민원신고 1097
51.1%
PDA단속 1032
48.0%
<NA> 3
 
0.1%
민원신고/2시간이상동일장소 2023-01-10 06:16 1
 
< 0.1%
주민신고 1
 
< 0.1%
민원신고/2시간이상동일장소2023-01-23 07:25_1만원추가 1
 
< 0.1%
민원신고/2시간이상 동일장소 2023-01-23 19:42 1
 
< 0.1%
민원신고/2시간이상동일장소 2023-01-23 14:15_1만원추가 1
 
< 0.1%
민원신고/2시간이상동일장소 2023-01-16 09:24 2023-01-16 20:13 1
 
< 0.1%
민원신고_2시간이상동일장소 2023-01-14 15:40 1
 
< 0.1%
Other values (9) 9
 
0.4%

Length

2023-12-12T21:56:25.288534image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
민원신고 1100
50.3%
pda단속 1032
47.2%
민원신고/2시간이상동일장소 6
 
0.3%
2023-01-03 4
 
0.2%
동일장소 3
 
0.1%
2023-01-08 3
 
0.1%
na 3
 
0.1%
21:02 2
 
0.1%
16:38 2
 
0.1%
민원신고/2시간이상 2
 
0.1%
Other values (25) 29
 
1.3%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size16.9 KiB
2023-04-04
2148 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-04-04
2nd row2023-04-04
3rd row2023-04-04
4th row2023-04-04
5th row2023-04-04

Common Values

ValueCountFrequency (%)
2023-04-04 2148
100.0%

Length

2023-12-12T21:56:25.425215image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-12T21:56:25.544996image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-04-04 2148
100.0%

Missing values

2023-12-12T21:56:22.356400image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-12T21:56:22.482085image/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

집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자
02023의왕시의왕시청2023-03-08 16:05왕곡동 위인로 주변PDA단속2023-04-04
12023의왕시의왕시청2023-03-08 16:00왕곡동 GS수퍼 주변PDA단속2023-04-04
22023의왕시의왕시청2023-03-08 15:59왕곡동 GS수퍼 주변PDA단속2023-04-04
32023의왕시의왕시청2023-03-08 15:58왕곡동 GS수퍼 주변PDA단속2023-04-04
42023의왕시의왕시청2023-03-08 15:56내손2동 경춘빌라 주변PDA단속2023-04-04
52023의왕시의왕시청2023-03-08 15:45오전동 의왕중학교 주변PDA단속2023-04-04
62023의왕시의왕시청2023-03-08 15:44이동 이당로 주변PDA단속2023-04-04
72023의왕시의왕시청2023-03-08 15:30포일동 봇들로(포일디오네)주PDA단속2023-04-04
82023의왕시의왕시청2023-03-08 15:21내손1동 미원파크빌 주변PDA단속2023-04-04
92023의왕시의왕시청2023-03-08 15:16부곡동 손커피연구소 주변PDA단속2023-04-04
집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자
21382023의왕시의왕시청2023-01-01 20:59부곡초등3길 브라운인테리어 주변 횡단보도민원신고2023-04-04
21392023의왕시의왕시청2023-01-01 20:58부곡초등3길 대성인더스트리 주변 소화전민원신고2023-04-04
21402023의왕시의왕시청2023-01-01 20:56솔밭길 GS25 주변 교차로민원신고2023-04-04
21412023의왕시의왕시청2023-01-01 20:56솔밭길 우리함께요양원 주변 횡단보도민원신고2023-04-04
21422023의왕시의왕시청2023-01-01 20:53부곡초등3길 양지공인중개사 주변 횡단보도민원신고2023-04-04
21432023의왕시의왕시청2023-01-02 15:32포일동 봇들로(일자리센터)주PDA단속2023-04-04
21442023의왕시의왕시청2023-01-02 15:31포일동 봇들로(센트로타워)주PDA단속2023-04-04
21452023의왕시의왕시청2023-01-02 15:26내손2동 내손의왕농협 주변PDA단속2023-04-04
21462023의왕시의왕시청2023-01-02 15:08내손1동 내손우체국 주변PDA단속2023-04-04
21472023의왕시의왕시청2023-01-02 15:07내손2동 벨포레상가 주변PDA단속2023-04-04

Duplicate rows

Most frequently occurring

집계년도시군명관리기관명단속일시정보단속장소단속방법데이터기준일자# duplicates
102023의왕시의왕시청2023-01-18 21:29솔밭길 우리함께요양원 주변 교차로민원신고2023-04-043
152023의왕시의왕시청2023-01-23 11:54봇들4길 리치빌 주변 인도민원신고2023-04-043
242023의왕시의왕시청2023-02-04 09:30봇들4길 리치빌 주변 인도민원신고2023-04-043
352023의왕시의왕시청2023-02-25 15:16봇들3길 주변 인도민원신고2023-04-043
372023의왕시의왕시청2023-02-26 11:31봇들3길 주변 인도민원신고2023-04-043
422023의왕시의왕시청2023-03-01 10:48봇들3길 주변 인도민원신고2023-04-043
452023의왕시의왕시청2023-03-02 19:14봇들3길 주변 인도민원신고2023-04-043
492023의왕시의왕시청2023-03-05 11:50봇들3길 주변 인도민원신고2023-04-043
02023의왕시의왕시청2023-01-01 20:52부곡초등3길 우성5차아파트 주변 버스정류장민원신고2023-04-042
12023의왕시의왕시청2023-01-02 22:12부곡초등3길 현대빌라주변 횡단보도민원신고2023-04-042