Overview

Dataset statistics

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

Variable types

Categorical5
DateTime1
Text1

Dataset

Description안양시 주정차위반단속위치 현황(집계년도, 시군명, 관리기관명, 단일시정보, 단속장소, 단속방법,데이터기준일자) 입니다.
Author경기도 안양시
URLhttps://www.data.go.kr/data/15125346/fileData.do

Alerts

집계년도 has constant value ""Constant
시군명 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 1070 (10.7%) duplicate rowsDuplicates
관리기관명 is highly overall correlated with 단속방법High correlation
단속방법 is highly overall correlated with 관리기관명High correlation

Reproduction

Analysis started2023-12-11 23:30:10.497240
Analysis finished2023-12-11 23:30:11.123454
Duration0.63 seconds
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

집계년도
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023
10000 

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

Length

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

Common Values (Plot)

2023-12-12T08:30:11.292575image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023 10000
100.0%

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

Common Values (Plot)

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

관리기관명
Categorical

HIGH CORRELATION 

Distinct2
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
동안구청
6464 
만안구청
3536 

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 (%)
동안구청 6464
64.6%
만안구청 3536
35.4%

Length

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

Common Values (Plot)

2023-12-12T08:30:11.697926image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
동안구청 6464
64.6%
만안구청 3536
35.4%

단속일자정보
Date

Distinct278
Distinct (%)2.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-01-01 00:00:00
Maximum2023-10-05 00:00:00
2023-12-12T08:30:11.795276image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-12T08:30:11.955764image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속장소
Text

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

Length

Max length29
Median length25
Mean length9.9174
Min length3

Characters and Unicode

Total characters99174
Distinct characters389
Distinct categories9 ?
Distinct scripts3 ?
Distinct blocks3 ?
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique1215 ?
Unique (%)12.2%

Sample

1st row 와룡로
2nd row나눔초교앞
3rd row 석수로
4th row 호계동 1020-3
5th row벌말초교 앞
ValueCountFrequency (%)
관양동 2644
 
13.2%
부근 1504
 
7.5%
호계동 1229
 
6.2%
비산동 783
 
3.9%
평촌동 434
 
2.2%
앞 425
 
2.1%
안양5동 214
 
1.1%
지프서비스센터 183
 
0.9%
석수1동 175
 
0.9%
석수2동 163
 
0.8%
Other values (1941) 12217
61.2%
2023-12-12T08:30:12.555921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13931
 
14.0%
동 6780
 
6.8%
1 5389
 
5.4%
양 4390
 
4.4%
로 3938
 
4.0%
관 3134
 
3.2%
안 2189
 
2.2%
5 2119
 
2.1%
6 2056
 
2.1%
2 1953
 
2.0%
Other values (379) 53295
53.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 60855
61.4%
Decimal Number 20585
 
20.8%
Space Separator 13931
 
14.0%
Dash Punctuation 1220
 
1.2%
Close Punctuation 1108
 
1.1%
Open Punctuation 1105
 
1.1%
Uppercase Letter 284
 
0.3%
Other Punctuation 67
 
0.1%
Lowercase Letter 19
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 6780
 
11.1%
양 4390
 
7.2%
로 3938
 
6.5%
관 3134
 
5.1%
안 2189
 
3.6%
근 1656
 
2.7%
번 1607
 
2.6%
부 1572
 
2.6%
길 1498
 
2.5%
호 1367
 
2.2%
Other values (346) 32724
53.8%
Uppercase Letter
ValueCountFrequency (%)
C 72
25.4%
T 39
13.7%
K 37
13.0%
Y 35
12.3%
F 32
11.3%
I 28
 
9.9%
B 25
 
8.8%
L 5
 
1.8%
U 5
 
1.8%
V 3
 
1.1%
Other values (3) 3
 
1.1%
Decimal Number
ValueCountFrequency (%)
1 5389
26.2%
5 2119
 
10.3%
6 2056
 
10.0%
2 1953
 
9.5%
3 1768
 
8.6%
0 1720
 
8.4%
9 1621
 
7.9%
7 1597
 
7.8%
4 1452
 
7.1%
8 910
 
4.4%
Other Punctuation
ValueCountFrequency (%)
@ 64
95.5%
# 2
 
3.0%
, 1
 
1.5%
Lowercase Letter
ValueCountFrequency (%)
e 17
89.5%
f 1
 
5.3%
o 1
 
5.3%
Space Separator
ValueCountFrequency (%)
13931
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1220
100.0%
Close Punctuation
ValueCountFrequency (%)
) 1108
100.0%
Open Punctuation
ValueCountFrequency (%)
( 1105
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 60855
61.4%
Common 38016
38.3%
Latin 303
 
0.3%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 6780
 
11.1%
양 4390
 
7.2%
로 3938
 
6.5%
관 3134
 
5.1%
안 2189
 
3.6%
근 1656
 
2.7%
번 1607
 
2.6%
부 1572
 
2.6%
길 1498
 
2.5%
호 1367
 
2.2%
Other values (346) 32724
53.8%
Common
ValueCountFrequency (%)
13931
36.6%
1 5389
 
14.2%
5 2119
 
5.6%
6 2056
 
5.4%
2 1953
 
5.1%
3 1768
 
4.7%
0 1720
 
4.5%
9 1621
 
4.3%
7 1597
 
4.2%
4 1452
 
3.8%
Other values (7) 4410
 
11.6%
Latin
ValueCountFrequency (%)
C 72
23.8%
T 39
12.9%
K 37
12.2%
Y 35
11.6%
F 32
10.6%
I 28
 
9.2%
B 25
 
8.3%
e 17
 
5.6%
L 5
 
1.7%
U 5
 
1.7%
Other values (6) 8
 
2.6%

Most occurring blocks

ValueCountFrequency (%)
Hangul 60854
61.4%
ASCII 38319
38.6%
Compat Jamo 1
 
< 0.1%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13931
36.4%
1 5389
 
14.1%
5 2119
 
5.5%
6 2056
 
5.4%
2 1953
 
5.1%
3 1768
 
4.6%
0 1720
 
4.5%
9 1621
 
4.2%
7 1597
 
4.2%
4 1452
 
3.8%
Other values (23) 4713
 
12.3%
Hangul
ValueCountFrequency (%)
동 6780
 
11.1%
양 4390
 
7.2%
로 3938
 
6.5%
관 3134
 
5.2%
안 2189
 
3.6%
근 1656
 
2.7%
번 1607
 
2.6%
부 1572
 
2.6%
길 1498
 
2.5%
호 1367
 
2.2%
Other values (345) 32723
53.8%
Compat Jamo
ValueCountFrequency (%)
ㅡ 1
100.0%

단속방법
Categorical

HIGH CORRELATION 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
스마트폰
3941 
인력단속
1627 
이동식CCTV
1492 
고정식CCTV
1336 
고정형CCTV
799 
Other values (2)
805 

Length

Max length7
Median length4
Mean length5.3094
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row인력단속
2nd row고정식CCTV
3rd row인력단속
4th row스마트폰
5th row고정식CCTV

Common Values

ValueCountFrequency (%)
스마트폰 3941
39.4%
인력단속 1627
16.3%
이동식CCTV 1492
 
14.9%
고정식CCTV 1336
 
13.4%
고정형CCTV 799
 
8.0%
이동형CCTV 704
 
7.0%
버스탑재형 101
 
1.0%

Length

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

Common Values (Plot)

2023-12-12T08:30:12.789419image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
스마트폰 3941
39.4%
인력단속 1627
16.3%
이동식cctv 1492
 
14.9%
고정식cctv 1336
 
13.4%
고정형cctv 799
 
8.0%
이동형cctv 704
 
7.0%
버스탑재형 101
 
1.0%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-07
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2023-12-07
2nd row2023-12-07
3rd row2023-12-07
4th row2023-12-07
5th row2023-12-07

Common Values

ValueCountFrequency (%)
2023-12-07 10000
100.0%

Length

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

Common Values (Plot)

2023-12-12T08:30:12.953663image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2023-12-07 10000
100.0%

Correlations

2023-12-12T08:30:12.998546image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관명단속방법
관리기관명1.0000.772
단속방법0.7721.000
2023-12-12T08:30:13.062728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속방법관리기관명
단속방법1.0000.837
관리기관명0.8371.000
2023-12-12T08:30:13.126160image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
관리기관명단속방법
관리기관명1.0000.837
단속방법0.8371.000

Missing values

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

집계년도시군명관리기관명단속일자정보단속장소단속방법데이터기준일자
568322023안양시만안구청2023-06-26와룡로인력단속2023-12-07
829872023안양시동안구청2023-08-28나눔초교앞고정식CCTV2023-12-07
696432023안양시만안구청2023-07-29석수로인력단속2023-12-07
771792023안양시동안구청2023-08-16호계동 1020-3스마트폰2023-12-07
25742023안양시동안구청2023-01-11벌말초교 앞고정식CCTV2023-12-07
129132023안양시만안구청2023-02-20박달우회로(안양대교측)경기중고피아노전문점앞고정형CCTV2023-12-07
503662023안양시만안구청2023-06-09와룡로인력단속2023-12-07
976152023안양시동안구청2023-09-27관양동 1637(10분 초과 주차)스마트폰2023-12-07
420102023안양시만안구청2023-05-14병목안로142번길인력단속2023-12-07
767062023안양시만안구청2023-08-15소곡로인력단속2023-12-07
집계년도시군명관리기관명단속일자정보단속장소단속방법데이터기준일자
417672023안양시동안구청2023-05-12평촌더샵아이파크 서문고정식CCTV2023-12-07
13342023안양시동안구청2023-01-06관양동 흥안대로439번길 부근이동식CCTV2023-12-07
993352023안양시동안구청2023-10-04비산동 1140(횡단보도)스마트폰2023-12-07
925512023안양시만안구청2023-09-16박달2동 삼봉로스마트폰2023-12-07
150922023안양시만안구청2023-02-27석수2동 연현로79번길이동형CCTV2023-12-07
324412023안양시동안구청2023-04-14관양동 벌말로 부근이동식CCTV2023-12-07
681542023안양시동안구청2023-07-25하나은행 뒤고정식CCTV2023-12-07
552262023안양시동안구청2023-06-21관양동 1594-1스마트폰2023-12-07
972692023안양시만안구청2023-09-27안양로(주정차위반)인력단속2023-12-07
466852023안양시동안구청2023-05-29관양동 1641스마트폰2023-12-07

Duplicate rows

Most frequently occurring

집계년도시군명관리기관명단속일자정보단속장소단속방법데이터기준일자# duplicates
5512023안양시동안구청2023-08-20평촌동 귀인로 부근이동식CCTV2023-12-076
10452023안양시만안구청2023-09-17장내로(주정차위반)인력단속2023-12-076
372023안양시동안구청2023-01-28지프서비스센터 앞고정식CCTV2023-12-075
452023안양시동안구청2023-02-01지프서비스센터 앞고정식CCTV2023-12-075
692023안양시동안구청2023-02-10지프서비스센터 앞고정식CCTV2023-12-075
1452023안양시동안구청2023-03-21지프서비스센터 앞고정식CCTV2023-12-075
2282023안양시동안구청2023-04-29관양동 1526스마트폰2023-12-075
2812023안양시동안구청2023-05-17호계동 어바인퍼스트인력단속2023-12-075
3322023안양시동안구청2023-06-09평촌동 흥안대로 부근이동식CCTV2023-12-075
3422023안양시동안구청2023-06-15관양동 흥안대로427번길 부근이동식CCTV2023-12-075