Accidents

Dataset profile report  ·  pandas-cat 0.1.5
Summary Variables Correlations
Summary
Records
538,989
Columns
15
Memory usage
7.72 MB
Memory usage by attribute
Attribute Type Info Memory
Driver_Age_Band 8 cats 16 - 20, 21 - 25, 26 - 35, 36 - 45, 46 - 55, 56 - 65, 66 - 75, Over 75 527.22 KB
Driver_IMD 10 cats 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 526.56 KB
Sex 2 cats Female, Male 526.70 KB
Journey 5 cats 2,Commuting to/from work, 3,Taking pupil to/from school, 4,Pupil riding to/from school, 5 Other/Not known, Part of work 527.00 KB
Hit_Objects_in 12 cats 0, 1, 2, 4, 5, 6, 7, 8, 9, 10, 11, 12 526.58 KB
Hit_Objects_off 12 cats 0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 526.58 KB
Casualties 7 cats 1, 2, 3, 4, 5, 6, 7 - 68 527.12 KB
Severity 3 cats Fatal, Serious, Slight 526.75 KB
Area 2 cats 1,Urban, 2,Rural 526.70 KB
Vehicle_Age 17 cats 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16-20, >20 527.87 KB
Road_Type 5 cats 1,Roundabout, 2,One way street, 3,Dual carriageway, 6,Single carriageway, 7,Slip road 526.97 KB
Speed_limit 8 cats 10, 15, 20, 30, 40, 50, 60, 70 526.55 KB
Light 5 cats 1,Daylight, 4,Darkness - lights lit, 5,Darkness - lights unlit, 6,Darkness - no lighting, 7,Darkness - lighting unknown 527.00 KB
Vehicle_Location 10 cats 0,On main c'way - not in restricted lane, 1,Tram/Light rail track, 2,Bus lane, 3,Busway (including guided busway), 4,Cycle lane (on main carriageway), 5,Cycleway or shared use footway (not part of main carriageway), 6,On lay-by or hard shoulder, 7,Entering lay-by or hard shoulder, 8,Leaving lay-by or hard shoulder, 9,Footway (pavement) 527.57 KB
Vehicle_Type 20 cats Van / Goods 3.5 tonnes mgw or under, 4,Motorcycle over 125cc and up to 500cc, 10,Minibus (8 - 16 passenger seats), 16,Ridden horse, Bus_coach_17+, 17,Agricultural vehicle, 18,Tram, 20,Goods over 3.5t. and under 7.5t, 21,Goods 7.5 tonnes +, 22,Mobility scooter, 23,Electric motorcycle, Motorcycle 50cc and under, 90,Other vehicle, 97,Motorcycle - unknown cc, 98,Goods vehicle - unknown weight, Motorcycle 125cc and under, Motorcycle over 500cc, Car, Pedal cycle, Taxi/Private hire car 528.42 KB
Variable Profiles

Driver_Age_Band

Categorical Ordered
Categories 8
Most frequent 26 - 35 (102,643 values, 19.04%)
Least frequent Over 75 (13,041 values, 2.42%)
Missings 61,389 (11.39%)
Memory 527.22 KB
16 - 20
12.99%
70032
21 - 25
12.58%
67785
26 - 35
19.04%
102643
36 - 45
17.21%
92768
46 - 55
12.92%
69615
56 - 65
7.92%
42675
66 - 75
3.53% 19041
Over 75
2.42% 13041

Driver_IMD

Categorical Ordered
Categories 10
Most frequent 2 (37,705 values, 7.00%)
Least frequent 10 (26,931 values, 5.00%)
Missings 199,869 (37.08%)
Memory 526.56 KB
1
6.83%
36829
2
7.00%
37705
3
6.88%
37102
4
6.69%
36079
5
6.51%
35090
6
6.41%
34549
7
6.14%
33076
8
5.88%
31671
9
5.58%
30088
10
5.00% 26931

Sex

Categorical Ordered
Categories 2
Most frequent Male (365,266 values, 67.77%)
Least frequent Female (137,270 values, 25.47%)
Missings 36,453 (6.76%)
Memory 526.70 KB
Female
25.47%
137270
Male
67.77%
365266

Journey

Categorical Ordered
Categories 5
Most frequent 5 Other/Not known (378,749 values, 70.27%)
Least frequent 4,Pupil riding to/from school (1,337 values, 0.25%)
Missings 0 (0.00%)
Memory 527.00 KB
2,Commuting to/from work
8.80%
47450
3,Taking pupil to/from school
1.33% 7183
4,Pupil riding to/from school
0.25% 1337
5 Other/Not known
70.27%
378749
Part of work
19.35%
104270

Hit_Objects_in

Categorical Ordered
Categories 12
Most frequent 0 (490,583 values, 91.02%)
Least frequent 1 (26 values, 0.00%)
Missings 41 (0.01%)
Memory 526.58 KB
0
91.02%
490583
1
0.00% 26
2
0.13% 680
4
0.06% 328
5
0.06% 332
6
0.26% 1426
7
1.42% 7659
8
0.01% 43
9
0.39% 2105
10
5.31%
28609
11
0.79% 4256
12
0.54% 2901

Hit_Objects_off

Categorical Ordered
Categories 12
Most frequent 0 (378,896 values, 70.30%)
Least frequent 8 (237 values, 0.04%)
Missings 11 (0.00%)
Memory 526.58 KB
0
70.30%
378896
1
2.43% 13080
2
2.84% 15311
3
1.18% 6337
4
5.77%
31100
5
0.21% 1157
6
1.70% 9161
7
2.14% 11529
8
0.04% 237
9
3.07% 16543
10
9.37%
50520
11
0.95% 5107

Casualties

Categorical Ordered
Categories 7
Most frequent 1 (475,314 values, 88.19%)
Least frequent 7 - 68 (230 values, 0.04%)
Missings 0 (0.00%)
Memory 527.12 KB
1
88.19%
475314
2
8.93%
48118
3
1.84% 9930
4
0.72% 3887
5
0.23% 1254
6
0.05% 256
7 - 68
0.04% 230

Severity

Categorical Ordered
Categories 3
Most frequent Slight (422,886 values, 78.46%)
Least frequent Fatal (10,349 values, 1.92%)
Missings 0 (0.00%)
Memory 526.75 KB
Fatal
1.92% 10349
Serious
19.62%
105754
Slight
78.46%
422886

Area

Categorical Ordered
Categories 2
Most frequent 1,Urban (340,200 values, 63.12%)
Least frequent 2,Rural (198,743 values, 36.87%)
Missings 46 (0.01%)
Memory 526.70 KB
1,Urban
63.12%
340200
2,Rural
36.87%
198743

Vehicle_Age

Categorical Ordered
Categories 17
Most frequent 7 (31,222 values, 5.79%)
Least frequent >20 (3,403 values, 0.63%)
Missings 147,143 (27.30%)
Memory 527.87 KB
1
5.46%
29432
2
5.19%
27976
3
5.21%
28062
4
5.48%
29520
5
5.61%
30228
6
5.64%
30380
7
5.79%
31222
8
5.65%
30469
9
5.51%
29681
10
5.24%
28219
11
4.60% 24800
12
3.86% 20801
13
2.97% 15999
14
2.05% 11066
15
1.47% 7901
16-20
2.35% 12687
>20
0.63% 3403

Road_Type

Categorical Ordered
Categories 5
Most frequent 6,Single carriageway (427,848 values, 79.38%)
Least frequent 7,Slip road (4,897 values, 0.91%)
Missings 4,357 (0.81%)
Memory 526.97 KB
1,Roundabout
3.39% 18275
2,One way street
3.28% 17665
3,Dual carriageway
12.24%
65947
6,Single carriageway
79.38%
427848
7,Slip road
0.91% 4897

Speed_limit

Categorical Ordered
Categories 8
Most frequent 30 (350,099 values, 64.95%)
Least frequent 15 (10 values, 0.00%)
Missings 0 (0.00%)
Memory 526.55 KB
10
0.00% 16
15
0.00% 10
20
1.79% 9636
30
64.95%
350099
40
5.81%
31335
50
2.46% 13234
60
18.70%
100795
70
6.28%
33864

Light

Categorical Ordered
Categories 5
Most frequent 1,Daylight (358,282 values, 66.47%)
Least frequent 5,Darkness - lights unlit (2,934 values, 0.54%)
Missings 0 (0.00%)
Memory 527.00 KB
1,Daylight
66.47%
358282
4,Darkness - lights lit
21.92%
118168
5,Darkness - lights unlit
0.54% 2934
6,Darkness - no lighting
9.82%
52923
7,Darkness - lighting unknown
1.24% 6682

Vehicle_Location

Categorical Ordered
Categories 10
Most frequent 0,On main c'way - not in restricted lane (518,451 values, 96.19%)
Least frequent 4,Cycle lane (on main carriageway) (322 values, 0.06%)
Missings 43 (0.01%)
Memory 527.57 KB
0,On main c'way - not in restricted lane
96.19%
518451
1,Tram/Light rail track
0.09% 504
2,Bus lane
0.77% 4169
3,Busway (including guided busway)
0.19% 1001
4,Cycle lane (on main carriageway)
0.06% 322
5,Cycleway or shared use footway (not part of main carriageway)
0.11% 599
6,On lay-by or hard shoulder
0.24% 1304
7,Entering lay-by or hard shoulder
0.09% 474
8,Leaving lay-by or hard shoulder
0.13% 677
9,Footway (pavement)
2.12% 11445

Vehicle_Type

Categorical Ordered
Categories 20
Most frequent Car (386,346 values, 71.68%)
Least frequent 23,Electric motorcycle (10 values, 0.00%)
Missings 141 (0.03%)
Memory 528.42 KB
Van / Goods 3.5 tonnes mgw or under
3.87% 20869
4,Motorcycle over 125cc and up to 500cc
1.05% 5660
10,Minibus (8 - 16 passenger seats)
0.32% 1731
16,Ridden horse
0.01% 59
Bus_coach_17+
7.59%
40935
17,Agricultural vehicle
0.09% 477
18,Tram
0.03% 142
20,Goods over 3.5t. and under 7.5t
0.53% 2839
21,Goods 7.5 tonnes +
1.23% 6618
22,Mobility scooter
0.03% 167
23,Electric motorcycle
0.00% 10
Motorcycle 50cc and under
1.36% 7304
90,Other vehicle
0.84% 4548
97,Motorcycle - unknown cc
0.03% 140
98,Goods vehicle - unknown weight
0.02% 101
Motorcycle 125cc and under
2.85% 15383
Motorcycle over 500cc
3.83% 20639
Car
71.68%
386346
Pedal cycle
1.77% 9533
Taxi/Private hire car
2.85% 15347
Correlations
Cramér's V — categorical variables
Crosstab heatmaps — categorical pairs