Overview

Dataset statistics

Number of variables6
Number of observations10000
Missing cells0
Missing cells (%)0.0%
Duplicate rows418
Duplicate rows (%)4.2%
Total size in memory556.6 KiB
Average record size in memory57.0 B

Variable types

DateTime3
Text1
Numeric1
Categorical1

Dataset

Description2024년 광주광역시 동구 관내 불법주정차 단속 현황 데이터 입니다.차종(승용차, 화물차), 단속형태, 어린이보호구역 위반여부, 위반장소명 등으로 구성되어있습니다.
Author광주광역시 동구
URLhttps://www.data.go.kr/data/15065025/fileData.do

Alerts

데이터기준일자 has constant value ""Constant
Dataset has 418 (4.2%) duplicate rowsDuplicates
과태료 has 147 (1.5%) zerosZeros

Reproduction

Analysis started2024-03-14 17:04:43.042962
Analysis finished2024-03-14 17:04:44.607865
Duration1.56 second
Software versionydata-profiling vv4.5.1
Download configurationconfig.json

Variables

위반일자
Date

Distinct650
Distinct (%)6.5%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2022-01-01 00:00:00
Maximum2023-10-31 00:00:00
2024-03-15T02:04:44.819273image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:04:45.330027image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반시간
Date

Distinct917
Distinct (%)9.2%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-03-15 00:20:00
Maximum2024-03-15 23:56:00
2024-03-15T02:04:45.785214image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:04:46.438202image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=50)

위반장소명
Text

Distinct779
Distinct (%)7.8%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
2024-03-15T02:04:48.269078image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Length

Max length36
Median length24
Mean length9.0593
Min length3

Characters and Unicode

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

Unique

Unique373 ?
Unique (%)3.7%

Sample

1st row충장로1가입구 부근
2nd row중앙로160번길 36
3rd row대인동 중앙로
4th row계림동 구성로
5th row황금동 서석로
ValueCountFrequency (%)
동명동 663
 
3.4%
부근 569
 
2.9%
대인동 539
 
2.7%
구성로 458
 
2.3%
전대병원 435
 
2.2%
계림동 418
 
2.1%
학동 401
 
2.0%
부설주차장 362
 
1.8%
문화전당 362
 
1.8%
주변 357
 
1.8%
Other values (619) 15187
76.9%
2024-03-15T02:04:50.456904image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Most occurring characters

ValueCountFrequency (%)
9751
 
10.8%
로 7086
 
7.8%
동 6221
 
6.9%
길 2439
 
2.7%
번 2257
 
2.5%
장 2181
 
2.4%
1 2146
 
2.4%
주 1690
 
1.9%
문 1680
 
1.9%
2 1555
 
1.7%
Other values (169) 53587
59.2%

Most occurring categories

ValueCountFrequency (%)
Other Letter 68048
75.1%
Decimal Number 10105
 
11.2%
Space Separator 9751
 
10.8%
Uppercase Letter 2271
 
2.5%
Dash Punctuation 301
 
0.3%
Other Punctuation 117
 
0.1%

Most frequent character per category

Other Letter
ValueCountFrequency (%)
로 7086
 
10.4%
동 6221
 
9.1%
길 2439
 
3.6%
번 2257
 
3.3%
장 2181
 
3.2%
주 1690
 
2.5%
문 1680
 
2.5%
대 1414
 
2.1%
남 1398
 
2.1%
구 1313
 
1.9%
Other values (146) 40369
59.3%
Decimal Number
ValueCountFrequency (%)
1 2146
21.2%
2 1555
15.4%
5 1087
10.8%
6 1085
10.7%
4 997
9.9%
3 890
8.8%
9 781
 
7.7%
0 584
 
5.8%
7 503
 
5.0%
8 477
 
4.7%
Uppercase Letter
ValueCountFrequency (%)
C 611
26.9%
A 508
22.4%
T 374
16.5%
P 314
13.8%
N 225
 
9.9%
L 176
 
7.7%
K 60
 
2.6%
E 1
 
< 0.1%
V 1
 
< 0.1%
W 1
 
< 0.1%
Space Separator
ValueCountFrequency (%)
9751
100.0%
Dash Punctuation
ValueCountFrequency (%)
- 301
100.0%
Other Punctuation
ValueCountFrequency (%)
, 117
100.0%

Most occurring scripts

ValueCountFrequency (%)
Hangul 68048
75.1%
Common 20274
 
22.4%
Latin 2271
 
2.5%

Most frequent character per script

Hangul
ValueCountFrequency (%)
로 7086
 
10.4%
동 6221
 
9.1%
길 2439
 
3.6%
번 2257
 
3.3%
장 2181
 
3.2%
주 1690
 
2.5%
문 1680
 
2.5%
대 1414
 
2.1%
남 1398
 
2.1%
구 1313
 
1.9%
Other values (146) 40369
59.3%
Common
ValueCountFrequency (%)
9751
48.1%
1 2146
 
10.6%
2 1555
 
7.7%
5 1087
 
5.4%
6 1085
 
5.4%
4 997
 
4.9%
3 890
 
4.4%
9 781
 
3.9%
0 584
 
2.9%
7 503
 
2.5%
Other values (3) 895
 
4.4%
Latin
ValueCountFrequency (%)
C 611
26.9%
A 508
22.4%
T 374
16.5%
P 314
13.8%
N 225
 
9.9%
L 176
 
7.7%
K 60
 
2.6%
E 1
 
< 0.1%
V 1
 
< 0.1%
W 1
 
< 0.1%

Most occurring blocks

ValueCountFrequency (%)
Hangul 68048
75.1%
ASCII 22545
 
24.9%

Most frequent character per block

ASCII
ValueCountFrequency (%)
9751
43.3%
1 2146
 
9.5%
2 1555
 
6.9%
5 1087
 
4.8%
6 1085
 
4.8%
4 997
 
4.4%
3 890
 
3.9%
9 781
 
3.5%
C 611
 
2.7%
0 584
 
2.6%
Other values (13) 3058
 
13.6%
Hangul
ValueCountFrequency (%)
로 7086
 
10.4%
동 6221
 
9.1%
길 2439
 
3.6%
번 2257
 
3.3%
장 2181
 
3.2%
주 1690
 
2.5%
문 1680
 
2.5%
대 1414
 
2.1%
남 1398
 
2.1%
구 1313
 
1.9%
Other values (146) 40369
59.3%

과태료
Real number (ℝ)

ZEROS 

Distinct7
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Infinite0
Infinite (%)0.0%
Mean48688.5
Minimum0
Maximum130000
Zeros147
Zeros (%)1.5%
Negative0
Negative (%)0.0%
Memory size166.0 KiB
2024-03-15T02:04:50.864463image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Quantile statistics

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

Descriptive statistics

Standard deviation25956.499
Coefficient of variation (CV)0.53311355
Kurtosis3.63822
Mean48688.5
Median Absolute Deviation (MAD)0
Skewness2.2111687
Sum4.86885 × 108
Variance6.7373984 × 108
MonotonicityNot monotonic
2024-03-15T02:04:51.225055image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=7)
ValueCountFrequency (%)
40000 8535
85.4%
120000 1090
 
10.9%
50000 155
 
1.6%
0 147
 
1.5%
80000 49
 
0.5%
130000 23
 
0.2%
25000 1
 
< 0.1%
ValueCountFrequency (%)
0 147
 
1.5%
25000 1
 
< 0.1%
40000 8535
85.4%
50000 155
 
1.6%
80000 49
 
0.5%
120000 1090
 
10.9%
130000 23
 
0.2%
ValueCountFrequency (%)
130000 23
 
0.2%
120000 1090
 
10.9%
80000 49
 
0.5%
50000 155
 
1.6%
40000 8535
85.4%
25000 1
 
< 0.1%
0 147
 
1.5%

비고
Categorical

Distinct14
Distinct (%)0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
<NA>
5425 
충장동
1564 
동명동
922 
학동
627 
계림1동
591 
Other values (9)
871 

Length

Max length4
Median length4
Mean length3.6048
Min length2

Unique

Unique0 ?
Unique (%)0.0%

Sample

1st row충장동
2nd row<NA>
3rd row<NA>
4th row<NA>
5th row<NA>

Common Values

ValueCountFrequency (%)
<NA> 5425
54.2%
충장동 1564
 
15.6%
동명동 922
 
9.2%
학동 627
 
6.3%
계림1동 591
 
5.9%
지산1동 170
 
1.7%
학운동 151
 
1.5%
지원2동 112
 
1.1%
산수1동 98
 
1.0%
지원1동 78
 
0.8%
Other values (4) 262
 
2.6%

Length

2024-03-15T02:04:51.649657image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram of lengths of the category
ValueCountFrequency (%)
na 5425
54.2%
충장동 1564
 
15.6%
동명동 922
 
9.2%
학동 627
 
6.3%
계림1동 591
 
5.9%
지산1동 170
 
1.7%
학운동 151
 
1.5%
지원2동 112
 
1.1%
산수1동 98
 
1.0%
지원1동 78
 
0.8%
Other values (4) 262
 
2.6%

데이터기준일자
Date

CONSTANT 

Distinct1
Distinct (%)< 0.1%
Missing0
Missing (%)0.0%
Memory size156.2 KiB
Minimum2024-01-08 00:00:00
Maximum2024-01-08 00:00:00
2024-03-15T02:04:51.980833image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
2024-03-15T02:04:52.200088image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
Histogram with fixed size bins (bins=1)

Interactions

2024-03-15T02:04:43.684325image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/

Correlations

2024-03-15T02:04:52.325504image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
과태료비고
과태료1.0000.573
비고0.5731.000
2024-03-15T02:04:52.698921image/svg+xmlMatplotlib v3.7.2, https://matplotlib.org/
과태료비고
과태료1.0000.393
비고0.3931.000

Missing values

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

위반일자위반시간위반장소명과태료비고데이터기준일자
760012022-02-1315:21:00충장로1가입구 부근40000충장동2024-01-08
581152023-03-2719:55:00중앙로160번길 3640000<NA>2024-01-08
829772023-10-1110:01:00대인동 중앙로40000<NA>2024-01-08
236972022-07-0114:22:00계림동 구성로40000<NA>2024-01-08
475632023-01-1215:22:00황금동 서석로40000<NA>2024-01-08
227262023-08-1515:46:00광주남초등학교0지원1동2024-01-08
290912022-08-0714:39:00계림동 경양로40000<NA>2024-01-08
461102022-03-2718:27:00문화전당 부설주차장120000동명동2024-01-08
268302022-07-2114:12:00동명동 백서로40000<NA>2024-01-08
668832023-06-0709:51:00불로동 문화전당로35번길40000<NA>2024-01-08
위반일자위반시간위반장소명과태료비고데이터기준일자
344292023-04-1317:46:00동명동 창억떡집 주변0동명동2024-01-08
344602022-09-2514:33:00금남로5가 금남로169번길40000<NA>2024-01-08
814182023-09-1915:15:00궁동 예술길120000<NA>2024-01-08
112252022-03-2416:55:00남문로693번길 1440000<NA>2024-01-08
680852023-04-0808:00:00전대병원 1주차빌딩 앞40000학동2024-01-08
91012023-01-1018:39:00구성로 마사회40000계림1동2024-01-08
317402022-08-2814:18:00계림동 경양로247번길40000<NA>2024-01-08
710292023-07-0810:39:00중앙로196번길 840000<NA>2024-01-08
703422023-01-1808:30:00전대병원 홀짝제40000학동2024-01-08
132532022-03-2511:35:00그랜드센트럴APT 1문120000계림1동2024-01-08

Duplicate rows

Most frequently occurring

위반일자위반시간위반장소명과태료비고데이터기준일자# duplicates
02022-01-0310:25:00학동 남문로693번길40000<NA>2024-01-084
442022-02-2714:21:00대인동 독립로264번길40000<NA>2024-01-084
1192022-06-2614:03:00대인동 독립로264번길40000<NA>2024-01-084
2952023-03-1415:19:00계림동 무등로306번길40000<NA>2024-01-084
52022-01-0414:10:00궁동 예술길120000<NA>2024-01-083
112022-01-1014:05:00학동 남문로40000<NA>2024-01-083
602022-03-1314:14:00대인동 독립로264번길40000<NA>2024-01-083
622022-03-1414:23:00산수동 갈마로40000<NA>2024-01-083
852022-05-0614:08:00동명동 동계천로40000<NA>2024-01-083
952022-05-2714:05:00대인동 구성로194번길40000<NA>2024-01-083