Overview

Dataset statistics

Number of variables11
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows185
Duplicate rows (%)1.8%
Total size in memory957.0 KiB
Average record size in memory98.0 B

Variable types

Categorical7
DateTime2
Text1
Numeric1

Dataset

Description광주광역시 북구 주정차단속정보(단속연도, 시도명, 시군구명, 기관명, 단속일시, 단속장소, 단속구분)입니다.
Author광주광역시 북구
URLhttps://www.data.go.kr/data/15086023/fileData.do

Alerts

단속연도 has constant value ""Constant
시도명 has constant value ""Constant
시군구명 has constant value ""Constant
기관명 has constant value ""Constant
관련법령 has constant value ""Constant
데이터기준일 has constant value ""Constant
Dataset has 185 (1.8%) duplicate rowsDuplicates

Reproduction

Analysis started2023-12-12 21:49:56.745138
Analysis finished2023-12-12 21:49:57.703843
Duration0.96 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
2022
10000 

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

Length

2023-12-13T06:49:57.779876image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:49:57.878216image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
2022 10000
100.0%

시도명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
광주광역시
10000 

Length

Max length5
Median length5
Mean length5
Min length5

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-13T06:49:57.976155image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:49:58.064859image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
광주광역시 10000
100.0%

시군구명
Categorical

CONSTANT 

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

Length

Max length2
Median length2
Mean length2
Min length2

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-13T06:49:58.151528image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:49:58.265985image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
북구 10000
100.0%

기관명
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
교통지도과
10000 

Length

Max length5
Median length5
Mean length5
Min length5

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-13T06:49:58.380006image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:49:58.469683image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
교통지도과 10000
100.0%

단속일시
Date

Distinct9483
Distinct (%)94.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-01 10:00:00
Maximum2022-10-11 10:47:00
2023-12-13T06:49:58.572640image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:49:58.700118image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

단속동
Categorical

Distinct47
Distinct (%)0.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
신용동
1303 
중흥동
905 
문흥동
846 
일곡동
775 
운암동
733 
Other values (42)
5438 

Length

Max length5
Median length3
Mean length3.0117
Min length2

Unique

Unique3 ?
Unique (%)< 0.1%

Sample

1st row신용동
2nd row운암동
3rd row일곡동
4th row신용동
5th row우산동

Common Values

ValueCountFrequency (%)
신용동 1303
13.0%
중흥동 905
 
9.0%
문흥동 846
 
8.5%
일곡동 775
 
7.8%
운암동 733
 
7.3%
우산동 689
 
6.9%
용봉동 674
 
6.7%
두암동 613
 
6.1%
연제동 421
 
4.2%
양산동 350
 
3.5%
Other values (37) 2691
26.9%

Length

2023-12-13T06:49:59.135238image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
신용동 1303
13.0%
중흥동 905
 
9.0%
문흥동 846
 
8.5%
일곡동 775
 
7.8%
운암동 733
 
7.3%
우산동 689
 
6.9%
용봉동 674
 
6.7%
두암동 613
 
6.1%
연제동 421
 
4.2%
양산동 350
 
3.5%
Other values (37) 2691
26.9%

단속장소
Text

Distinct1729
Distinct (%)17.3%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2023-12-13T06:49:59.393057image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length29
Median length19
Mean length10.3449
Min length1

Characters and Unicode

Total characters103449
Distinct characters262
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

Unique958 ?
Unique (%)9.6%

Sample

1st row신용동 임방울대로1042번길
2nd row운암프라자 사거리
3rd row848-2 부근 횡단보도
4th row861 부근 횡단보도
5th row동강대 건너편
ValueCountFrequency (%)
부근 3751
 
15.9%
횡단보도 1496
 
6.3%
말바우시장 555
 
2.4%
사거리 499
 
2.1%
모퉁이 406
 
1.7%
인도 400
 
1.7%
앞 305
 
1.3%
운암동 305
 
1.3%
소화전 257
 
1.1%
일곡동 253
 
1.1%
Other values (1406) 15382
65.2%
2023-12-13T06:49:59.810671image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
13610
 
13.2%
1 4052
 
3.9%
부 3873
 
3.7%
근 3839
 
3.7%
0 3198
 
3.1%
동 2406
 
2.3%
로 2297
 
2.2%
B 2190
 
2.1%
8 2104
 
2.0%
7 2077
 
2.0%
Other values (252) 63803
61.7%

Most occurring categories

ValueCountFrequency (%)
Other Letter 65264
63.1%
Decimal Number 20633
 
19.9%
Space Separator 13610
 
13.2%
Uppercase Letter 2190
 
2.1%
Dash Punctuation 1741
 
1.7%
Other Punctuation 6
 
< 0.1%
Lowercase Letter 5
 
< 0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
부 3873
 
5.9%
근 3839
 
5.9%
동 2406
 
3.7%
로 2297
 
3.5%
단 2033
 
3.1%
도 1967
 
3.0%
보 1549
 
2.4%
횡 1496
 
2.3%
대 1250
 
1.9%
학 1215
 
1.9%
Other values (233) 43339
66.4%
Decimal Number
ValueCountFrequency (%)
1 4052
19.6%
0 3198
15.5%
8 2104
10.2%
7 2077
10.1%
3 1992
9.7%
2 1864
9.0%
9 1785
8.7%
6 1397
 
6.8%
4 1186
 
5.7%
5 978
 
4.7%
Lowercase Letter
ValueCountFrequency (%)
e 1
20.0%
m 1
20.0%
s 1
20.0%
o 1
20.0%
k 1
20.0%
Space Separator
ValueCountFrequency (%)
13610
100.0%
Uppercase Letter
ValueCountFrequency (%)
B 2190
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 1741
100.0%
Other Punctuation
ValueCountFrequency (%)
, 6
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 65264
63.1%
Common 35990
34.8%
Latin 2195
 
2.1%

Most frequent character per script

Hangul
ValueCountFrequency (%)
부 3873
 
5.9%
근 3839
 
5.9%
동 2406
 
3.7%
로 2297
 
3.5%
단 2033
 
3.1%
도 1967
 
3.0%
보 1549
 
2.4%
횡 1496
 
2.3%
대 1250
 
1.9%
학 1215
 
1.9%
Other values (233) 43339
66.4%
Common
ValueCountFrequency (%)
13610
37.8%
1 4052
 
11.3%
0 3198
 
8.9%
8 2104
 
5.8%
7 2077
 
5.8%
3 1992
 
5.5%
2 1864
 
5.2%
9 1785
 
5.0%
- 1741
 
4.8%
6 1397
 
3.9%
Other values (3) 2170
 
6.0%
Latin
ValueCountFrequency (%)
B 2190
99.8%
e 1
 
< 0.1%
m 1
 
< 0.1%
s 1
 
< 0.1%
o 1
 
< 0.1%
k 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 65264
63.1%
ASCII 38185
36.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
13610
35.6%
1 4052
 
10.6%
0 3198
 
8.4%
B 2190
 
5.7%
8 2104
 
5.5%
7 2077
 
5.4%
3 1992
 
5.2%
2 1864
 
4.9%
9 1785
 
4.7%
- 1741
 
4.6%
Other values (9) 3572
 
9.4%
Hangul
ValueCountFrequency (%)
부 3873
 
5.9%
근 3839
 
5.9%
동 2406
 
3.7%
로 2297
 
3.5%
단 2033
 
3.1%
도 1967
 
3.0%
보 1549
 
2.4%
횡 1496
 
2.3%
대 1250
 
1.9%
학 1215
 
1.9%
Other values (233) 43339
66.4%

단속구분
Categorical

Distinct5
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
고정형CCTV
4730 
시민신고웹
3063 
주행형CCTV
2150 
버스장착형CCTV
 
51
일반도보
 
6

Length

Max length9
Median length7
Mean length6.3958
Min length4

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row주행형CCTV
2nd row고정형CCTV
3rd row시민신고웹
4th row시민신고웹
5th row고정형CCTV

Common Values

ValueCountFrequency (%)
고정형CCTV 4730
47.3%
시민신고웹 3063
30.6%
주행형CCTV 2150
21.5%
버스장착형CCTV 51
 
0.5%
일반도보 6
 
0.1%

Length

2023-12-13T06:49:59.961643image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:50:00.100816image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
고정형cctv 4730
47.3%
시민신고웹 3063
30.6%
주행형cctv 2150
21.5%
버스장착형cctv 51
 
0.5%
일반도보 6
 
0.1%

단속원금
Real number (ℝ)

Distinct10
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean50334.5
Minimum10000
Maximum130000
Zeros0
Zeros (%)0.0%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2023-12-13T06:50:00.214858image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

Minimum10000
5-th percentile40000
Q140000
median40000
Q340000
95-th percentile120000
Maximum130000
Range120000
Interquartile range (IQR)0

Descriptive statistics

Standard deviation26453.177
Coefficient of variation (CV)0.52554763
Kurtosis2.9795815
Mean50334.5
Median Absolute Deviation (MAD)0
Skewness2.1901881
Sum5.03345 × 108
Variance6.9977059 × 108
MonotonicityNot monotonic
2023-12-13T06:50:00.329431image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=10)
ValueCountFrequency (%)
40000 8343
83.4%
120000 1175
 
11.8%
50000 242
 
2.4%
80000 137
 
1.4%
20000 47
 
0.5%
130000 32
 
0.3%
10000 20
 
0.2%
90000 2
 
< 0.1%
60000 1
 
< 0.1%
25000 1
 
< 0.1%
ValueCountFrequency (%)
10000 20
 
0.2%
20000 47
 
0.5%
25000 1
 
< 0.1%
40000 8343
83.4%
50000 242
 
2.4%
60000 1
 
< 0.1%
80000 137
 
1.4%
90000 2
 
< 0.1%
120000 1175
 
11.8%
130000 32
 
0.3%
ValueCountFrequency (%)
130000 32
 
0.3%
120000 1175
 
11.8%
90000 2
 
< 0.1%
80000 137
 
1.4%
60000 1
 
< 0.1%
50000 242
 
2.4%
40000 8343
83.4%
25000 1
 
< 0.1%
20000 47
 
0.5%
10000 20
 
0.2%

관련법령
Categorical

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
도로교통법 제32조
10000 

Length

Max length10
Median length10
Mean length10
Min length10

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row도로교통법 제32조
2nd row도로교통법 제32조
3rd row도로교통법 제32조
4th row도로교통법 제32조
5th row도로교통법 제32조

Common Values

ValueCountFrequency (%)
도로교통법 제32조 10000
100.0%

Length

2023-12-13T06:50:00.457148image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category

Common Values (Plot)

2023-12-13T06:50:00.541179image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
ValueCountFrequency (%)
도로교통법 10000
50.0%
제32조 10000
50.0%

데이터기준일
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2023-11-23 00:00:00
Maximum2023-11-23 00:00:00
2023-12-13T06:50:00.612084image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2023-12-13T06:50:00.697728image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2023-12-13T06:49:57.336129image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2023-12-13T06:50:00.756723image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속동단속구분단속원금
단속동1.0000.6540.500
단속구분0.6541.0000.293
단속원금0.5000.2931.000
2023-12-13T06:50:00.841220image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속구분단속동
단속구분1.0000.368
단속동0.3681.000
2023-12-13T06:50:00.935350image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
단속원금단속동단속구분
단속원금1.0000.2130.184
단속동0.2131.0000.368
단속구분0.1840.3681.000

Missing values

2023-12-13T06:49:57.463201image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
A simple visualization of nullity by column.
2023-12-13T06:49:57.632551image/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

단속연도시도명시군구명기관명단속일시단속동단속장소단속구분단속원금관련법령데이터기준일
604982022광주광역시북구교통지도과2022-07-25 17:12신용동신용동 임방울대로1042번길주행형CCTV40000도로교통법 제32조2023-11-23
304752022광주광역시북구교통지도과2022-04-18 16:36운암동운암프라자 사거리고정형CCTV40000도로교통법 제32조2023-11-23
187222022광주광역시북구교통지도과2022-03-05 16:05일곡동848-2 부근 횡단보도시민신고웹40000도로교통법 제32조2023-11-23
802592022광주광역시북구교통지도과2022-09-30 19:55신용동861 부근 횡단보도시민신고웹40000도로교통법 제32조2023-11-23
94692022광주광역시북구교통지도과2022-02-07 15:27우산동동강대 건너편고정형CCTV40000도로교통법 제32조2023-11-23
226992022광주광역시북구교통지도과2022-03-19 11:06풍향동808 부근 횡단보도시민신고웹50000도로교통법 제32조2023-11-23
78022022광주광역시북구교통지도과2022-01-31 08:16삼각동삼각우미타운고정형CCTV40000도로교통법 제32조2023-11-23
187052022광주광역시북구교통지도과2022-03-05 14:49우산동B082 말바우시장 진입로 주변고정형CCTV40000도로교통법 제32조2023-11-23
270692022광주광역시북구교통지도과2022-04-05 15:00용봉동반룡로28번길 부근주행형CCTV40000도로교통법 제32조2023-11-23
63642022광주광역시북구교통지도과2022-01-25 13:10신용동용두초고정형CCTV40000도로교통법 제32조2023-11-23
단속연도시도명시군구명기관명단속일시단속동단속장소단속구분단속원금관련법령데이터기준일
18842022광주광역시북구교통지도과2022-01-09 10:23오치동1048-28 부근 소화전시민신고웹40000도로교통법 제32조2023-11-23
788702022광주광역시북구교통지도과2022-09-26 16:19신용동B077 첨단 대성베르힐고정형CCTV40000도로교통법 제32조2023-11-23
35832022광주광역시북구교통지도과2022-01-15 07:41삼각동523 부근 횡단보도시민신고웹40000도로교통법 제32조2023-11-23
18762022광주광역시북구교통지도과2022-01-09 10:12용봉동1043 부근 횡단보도시민신고웹40000도로교통법 제32조2023-11-23
380242022광주광역시북구교통지도과2022-05-13 19:21두암동광주병원고정형CCTV40000도로교통법 제32조2023-11-23
823412022광주광역시북구교통지도과2022-10-09 14:51오치동1000 부근 횡단보도시민신고웹20000도로교통법 제32조2023-11-23
176052022광주광역시북구교통지도과2022-03-01 13:13오치동오정초등학교고정형CCTV120000도로교통법 제32조2023-11-23
307652022광주광역시북구교통지도과2022-04-19 15:31용봉동반룡로28번길 부근주행형CCTV40000도로교통법 제32조2023-11-23
717302022광주광역시북구교통지도과2022-08-30 12:10운암동357-7 부근 이중주차시민신고웹40000도로교통법 제32조2023-11-23
415782022광주광역시북구교통지도과2022-05-25 10:22신용동B106 용두초등학교 후문고정형CCTV120000도로교통법 제32조2023-11-23

Duplicate rows

Most frequently occurring

단속연도시도명시군구명기관명단속일시단속동단속장소단속구분단속원금관련법령데이터기준일# duplicates
152022광주광역시북구교통지도과2022-01-18 15:03중흥동중흥동 서양로93번길주행형CCTV40000도로교통법 제32조2023-11-234
32022광주광역시북구교통지도과2022-01-06 08:42오치동오치동 서하로주행형CCTV40000도로교통법 제32조2023-11-233
42022광주광역시북구교통지도과2022-01-07 10:19운암동운암동 북문대로33번길주행형CCTV40000도로교통법 제32조2023-11-233
112022광주광역시북구교통지도과2022-01-14 15:29신용동신용동 첨단연신로91번길주행형CCTV40000도로교통법 제32조2023-11-233
312022광주광역시북구교통지도과2022-02-21 15:40유동유동 중가로주행형CCTV40000도로교통법 제32조2023-11-233
492022광주광역시북구교통지도과2022-03-08 15:24각화동각화동 각화대로주행형CCTV40000도로교통법 제32조2023-11-233
562022광주광역시북구교통지도과2022-03-17 14:55중흥동무등로 부근주행형CCTV40000도로교통법 제32조2023-11-233
632022광주광역시북구교통지도과2022-03-28 10:38운암동운암동 북문대로159번길주행형CCTV40000도로교통법 제32조2023-11-233
732022광주광역시북구교통지도과2022-04-14 15:27운암동금호로40번길 부근주행형CCTV40000도로교통법 제32조2023-11-233
752022광주광역시북구교통지도과2022-04-18 10:15용전동용전동 빛고을대로주행형CCTV40000도로교통법 제32조2023-11-233