Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows309
Duplicate rows (%)3.1%
Total size in memory546.9 KiB
Average record size in memory56.0 B

Variable types

Categorical3
DateTime2
Text1

Dataset

Description전북특별자치도 전주시 내 불법주정차 단속 현황을 제공하며, 구청구분, 단속일자, 단속시간, 단속장소명 등을 제공합니다.항목 : 구청구분, 단속일자, 단속시간, 단속장소명, 단속구분, 데이터기준일자담당부서 : 구청 경제교통과
Author전북특별자치도 전주시
URLhttps://www.data.go.kr/data/15102352/fileData.do

Alerts

구청구분 has constant value ""Constant
데이터기준일자 has constant value ""Constant
Dataset has 309 (3.1%) duplicate rowsDuplicates

Reproduction

Analysis started2024-03-14 15:15:18.353288
Analysis finished2024-03-14 15:15:19.575275
Duration1.22 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

구청구분
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

2024-03-15T00:15:19.778529image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T00:15:20.045936image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
덕진구 10000
100.0%

단속일자
Date

Distinct400
Distinct (%)4.0%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2017-01-01 00:00:00
Maximum2018-02-27 00:00:00
2024-03-15T00:15:20.225482image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:15:20.485090image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속시간
Date

Distinct881
Distinct (%)8.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-03-15 06:23:00
Maximum2024-03-15 22:00:00
2024-03-15T00:15:20.735051image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T00:15:20.968680image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속장소명
Text

Distinct432
Distinct (%)4.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-15T00:15:21.966763image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length30
Median length25
Mean length8.0984
Min length2

Characters and Unicode

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

Unique

Unique144 ?
Unique (%)1.4%

Sample

1st row반월동 반월3길
2nd row작은모래내2길 부근
3rd row덕진동 명륜4길
4th row반월동주공아파트앞
5th row호성동 호성3길 횡단보도
ValueCountFrequency (%)
송천동 892
 
5.3%
부근 839
 
5.0%
금암동 809
 
4.8%
덕진동 752
 
4.5%
인후동 692
 
4.1%
우아동 558
 
3.3%
고속버스터미널 429
 
2.6%
권삼득로 393
 
2.3%
전북대구정문(시사영어 328
 
2.0%
호성동 323
 
1.9%
Other values (359) 10796
64.2%
2024-03-15T00:15:23.230808image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
6812
 
8.4%
동 6337
 
7.8%
로 4847
 
6.0%
천 1680
 
2.1%
진 1672
 
2.1%
아 1660
 
2.0%
송 1632
 
2.0%
덕 1612
 
2.0%
길 1362
 
1.7%
대 1328
 
1.6%
Other values (258) 52042
64.3%

Most occurring categories

ValueCountFrequency (%)
Other Letter 70567
87.1%
Space Separator 6812
 
8.4%
Decimal Number 1629
 
2.0%
Open Punctuation 959
 
1.2%
Close Punctuation 959
 
1.2%
Uppercase Letter 41
 
0.1%
Dash Punctuation 17
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
동 6337
 
9.0%
로 4847
 
6.9%
천 1680
 
2.4%
진 1672
 
2.4%
아 1660
 
2.4%
송 1632
 
2.3%
덕 1612
 
2.3%
길 1362
 
1.9%
대 1328
 
1.9%
정 1305
 
1.8%
Other values (235) 47132
66.8%
Decimal Number
ValueCountFrequency (%)
1 473
29.0%
3 348
21.4%
2 235
14.4%
5 185
 
11.4%
6 154
 
9.5%
4 106
 
6.5%
7 88
 
5.4%
8 25
 
1.5%
0 9
 
0.6%
9 6
 
0.4%
Uppercase Letter
ValueCountFrequency (%)
K 12
29.3%
T 12
29.3%
S 6
14.6%
A 3
 
7.3%
X 3
 
7.3%
O 2
 
4.9%
R 1
 
2.4%
M 1
 
2.4%
I 1
 
2.4%
Space Separator
ValueCountFrequency (%)
6812
100.0%
Open Punctuation
ValueCountFrequency (%)
( 959
100.0%
Close Punctuation
ValueCountFrequency (%)
) 959
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 17
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 70567
87.1%
Common 10376
 
12.8%
Latin 41
 
0.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
동 6337
 
9.0%
로 4847
 
6.9%
천 1680
 
2.4%
진 1672
 
2.4%
아 1660
 
2.4%
송 1632
 
2.3%
덕 1612
 
2.3%
길 1362
 
1.9%
대 1328
 
1.9%
정 1305
 
1.8%
Other values (235) 47132
66.8%
Common
ValueCountFrequency (%)
6812
65.7%
( 959
 
9.2%
) 959
 
9.2%
1 473
 
4.6%
3 348
 
3.4%
2 235
 
2.3%
5 185
 
1.8%
6 154
 
1.5%
4 106
 
1.0%
7 88
 
0.8%
Other values (4) 57
 
0.5%
Latin
ValueCountFrequency (%)
K 12
29.3%
T 12
29.3%
S 6
14.6%
A 3
 
7.3%
X 3
 
7.3%
O 2
 
4.9%
R 1
 
2.4%
M 1
 
2.4%
I 1
 
2.4%

Most occurring blocks

ValueCountFrequency (%)
Hangul 70567
87.1%
ASCII 10417
 
12.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
6812
65.4%
( 959
 
9.2%
) 959
 
9.2%
1 473
 
4.5%
3 348
 
3.3%
2 235
 
2.3%
5 185
 
1.8%
6 154
 
1.5%
4 106
 
1.0%
7 88
 
0.8%
Other values (13) 98
 
0.9%
Hangul
ValueCountFrequency (%)
동 6337
 
9.0%
로 4847
 
6.9%
천 1680
 
2.4%
진 1672
 
2.4%
아 1660
 
2.4%
송 1632
 
2.3%
덕 1612
 
2.3%
길 1362
 
1.9%
대 1328
 
1.9%
정 1305
 
1.8%
Other values (235) 47132
66.8%

단속구분
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
이동식CCTV
4907 
고정식CCTV
4158 
버스탑재형CCTV
838 
인력단속
 
78
112민원신고
 
19

Length

Max length9
Median length7
Mean length7.1442
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 (%)
이동식CCTV 4907
49.1%
고정식CCTV 4158
41.6%
버스탑재형CCTV 838
 
8.4%
인력단속 78
 
0.8%
112민원신고 19
 
0.2%

Length

2024-03-15T00:15:23.645838image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T00:15:23.967863image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
이동식cctv 4907
49.1%
고정식cctv 4158
41.6%
버스탑재형cctv 838
 
8.4%
인력단속 78
 
0.8%
112민원신고 19
 
0.2%

데이터기준일자
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2022-08-30
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row2022-08-30
2nd row2022-08-30
3rd row2022-08-30
4th row2022-08-30
5th row2022-08-30

Common Values

ValueCountFrequency (%)
2022-08-30 10000
100.0%

Length

2024-03-15T00:15:24.339360image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2024-03-15T00:15:24.631951image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022-08-30 10000
100.0%

Missing values

2024-03-15T00:15:19.062213image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2024-03-15T00:15:19.419077image/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

구청구분단속일자단속시간단속장소명단속구분데이터기준일자
47617덕진구2017-07-1210:20:00반월동 반월3길이동식CCTV2022-08-30
12551덕진구2017-02-1317:05:00작은모래내2길 부근버스탑재형CCTV2022-08-30
11151덕진구2017-02-0916:42:00덕진동 명륜4길이동식CCTV2022-08-30
85633덕진구2017-12-3111:07:00반월동주공아파트앞고정식CCTV2022-08-30
60965덕진구2017-09-1410:10:00호성동 호성3길 횡단보도이동식CCTV2022-08-30
45536덕진구2017-06-3015:40:00반월동 반월로이동식CCTV2022-08-30
73448덕진구2017-11-2014:17:00금암동 백제대로이동식CCTV2022-08-30
61316덕진구2017-09-1514:34:00농협 아중지점고정식CCTV2022-08-30
29890덕진구2017-04-1118:23:00실내체육관(정상어학원)고정식CCTV2022-08-30
56881덕진구2017-08-2814:36:00인후동 백제대로이동식CCTV2022-08-30
구청구분단속일자단속시간단속장소명단속구분데이터기준일자
26849덕진구2017-03-2914:40:00산정동 건산로이동식CCTV2022-08-30
4825덕진구2017-01-1616:41:00덕진동 가련산로이동식CCTV2022-08-30
95245덕진구2018-02-0216:26:00장동 기지로이동식CCTV2022-08-30
87050덕진구2018-01-0415:08:00우아동 석소로이동식CCTV2022-08-30
14142덕진구2017-02-1720:48:00석소로 부근버스탑재형CCTV2022-08-30
8883덕진구2017-02-0414:57:00석소로 부근버스탑재형CCTV2022-08-30
51129덕진구2017-07-3114:31:00농협 아중지점고정식CCTV2022-08-30
67080덕진구2017-10-2414:39:00진북동 팔달로이동식CCTV2022-08-30
35401덕진구2017-05-1014:33:00진북동 숲정이2길이동식CCTV2022-08-30
47682덕진구2017-07-1214:28:00우아동 안덕원로이동식CCTV2022-08-30

Duplicate rows

Most frequently occurring

구청구분단속일자단속시간단속장소명단속구분데이터기준일자# duplicates
17덕진구2017-01-1411:30:00신복천변로 부근버스탑재형CCTV2022-08-304
71덕진구2017-03-0616:18:00금암동 권삼득로이동식CCTV2022-08-304
4덕진구2017-01-0316:21:00진북동 기린대로이동식CCTV2022-08-303
20덕진구2017-01-1608:03:00신복천변로 부근버스탑재형CCTV2022-08-303
39덕진구2017-02-0714:43:00송천동 천마산로이동식CCTV2022-08-303
55덕진구2017-02-1721:33:00석소로 부근버스탑재형CCTV2022-08-303
89덕진구2017-03-2214:54:00금암동 권삼득로이동식CCTV2022-08-303
94덕진구2017-03-2321:18:00건산로 부근버스탑재형CCTV2022-08-303
109덕진구2017-04-2010:35:00팔복동 유상로이동식CCTV2022-08-303
133덕진구2017-05-2414:34:00팔복동 유상로이동식CCTV2022-08-303