Accidents dataset


 

Dataset summary

Records 538,989
Columns 14
Memory usage 362.49 MB

Attribute # of categoriesCategoriesMemory usage
Driver_Age_Band 816 - 20, 21 - 25, 26 - 35, 36 - 45, 46 - 55, 56 - 65, 66 - 75, Over 7531.02 MB
Driver_IMD 101.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.04.11 MB
Sex 2Female, Male30.61 MB
Journey 52,Commuting to/from work, 3,Taking pupil to/from school, 4,Pupil riding to/from school, 5 Other/Not known, Part of work37.95 MB
Hit_Objects_in 120.0, 1.0, 2.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.0, 12.04.11 MB
Hit_Objects_off 120.0, 1.0, 2.0, 3.0, 4.0, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0, 11.04.11 MB
Casualties 131, 2, 3, 4, 5, 6, 1, 2, 3, 4, 5, 6, 7 - 6829.47 MB
Severity 3Fatal, Serious, Slight32.47 MB
Area 21,Urban, 2,Rural32.90 MB
Vehicle_Age 171, 10, 11, 12, 13, 14, 15, 16-20, 2, 3, 4, 5, 6, 7, 8, 9, >2026.32 MB
Road_Type 51,Roundabout, 2,One way street, 3,Dual carriageway, 6,Single carriageway, 7,Slip road39.02 MB
Speed_limit 810, 15, 20, 30, 40, 50, 60, 704.11 MB
Light 51,Daylight, 4,Darkness - lights lit, 5,Darkness - lights unlit, 6,Darkness - no lighting, 7,Darkness - lighting unknown36.77 MB
Vehicle_Location 100,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)49.50 MB

The profile of the variables
 

Driver_Age_Band

Categories 9
Most frequent 26 - 35 (102,643 values, 19.04%)
Least frequent Over 75 (13,041 values, 2.42%)
mem_usage 31.02 MB
Missings 61,389 (11.39%)
Driver_Age_BandCountFrequencyDriver_Age_Band Frequency
16 - 207003212.99%16 - 20
12.99% 
21 - 256778512.58%21 - 25
12.58% 
26 - 3510264319.04%26 - 35
19.04% 
36 - 459276817.21%36 - 45
17.21% 
46 - 556961512.92%46 - 55
12.92% 
56 - 65426757.92%56 - 65
7.92% 
66 - 75190413.53%66 - 75
 
3.53%
Over 75130412.42%Over 75
 
2.42%
Variable Driver_Age_Band
Categories 9
Most frequent 26 - 35 (102,643 values, 19.04%)
Least frequent Over 75 (13,041 values, 2.42%)
mem_usage 31.02 MB
Missings 61,389 (11.39%)
Driver_Age_BandCountFrequency
16 - 207003212.99%
21 - 256778512.58%
26 - 3510264319.04%
36 - 459276817.21%
46 - 556961512.92%
56 - 65426757.92%
66 - 75190413.53%
Over 75130412.42%
Driver_Age_Band
16 - 20
12.99% 
21 - 25
12.58% 
26 - 35
19.04% 
36 - 45
17.21% 
46 - 55
12.92% 
56 - 65
7.92% 
66 - 75
 
3.53%
Over 75
 
2.42%

Driver_IMD

Categories 11
Most frequent 2.0 (37,705 values, 7.00%)
Least frequent 10.0 (26,931 values, 5.00%)
mem_usage 4.11 MB
Missings 199,869 (37.08%)
Driver_IMDCountFrequencyDriver_IMD Frequency
1.0368296.83%1.0
6.83% 
2.0377057.00%2.0
7.00% 
3.0371026.88%3.0
6.88% 
4.0360796.69%4.0
6.69% 
5.0350906.51%5.0
6.51% 
6.0345496.41%6.0
6.41% 
7.0330766.14%7.0
6.14% 
8.0316715.88%8.0
5.88% 
9.0300885.58%9.0
5.58% 
10.0269315.00%10.0
 
5.00%
Variable Driver_IMD
Categories 11
Most frequent 2.0 (37,705 values, 7.00%)
Least frequent 10.0 (26,931 values, 5.00%)
mem_usage 4.11 MB
Missings 199,869 (37.08%)
Driver_IMDCountFrequency
1.0368296.83%
2.0377057.00%
3.0371026.88%
4.0360796.69%
5.0350906.51%
6.0345496.41%
7.0330766.14%
8.0316715.88%
9.0300885.58%
10.0269315.00%
Driver_IMD
1.0
6.83% 
2.0
7.00% 
3.0
6.88% 
4.0
6.69% 
5.0
6.51% 
6.0
6.41% 
7.0
6.14% 
8.0
5.88% 
9.0
5.58% 
10.0
 
5.00%

Sex

Categories 3
Most frequent Male (365,266 values, 67.77%)
Least frequent Female (137,270 values, 25.47%)
mem_usage 30.61 MB
Missings 36,453 (6.76%)
SexCountFrequencySex Frequency
Female13727025.47%Female
25.47% 
Male36526667.77%Male
67.77% 
Variable Sex
Categories 3
Most frequent Male (365,266 values, 67.77%)
Least frequent Female (137,270 values, 25.47%)
mem_usage 30.61 MB
Missings 36,453 (6.76%)
SexCountFrequency
Female13727025.47%
Male36526667.77%
Sex
Female
25.47% 
Male
67.77% 

Journey

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%)
mem_usage 37.95 MB
Missings 0 (0.00%)
JourneyCountFrequencyJourney Frequency
2,Commuting to/from work474508.80%2,Commuting to/from work
8.80% 
3,Taking pupil to/from school71831.33%3,Taking pupil to/from school
 
1.33%
4,Pupil riding to/from school13370.25%4,Pupil riding to/from school
 
0.25%
5 Other/Not known37874970.27%5 Other/Not known
70.27% 
Part of work10427019.35%Part of work
19.35% 
Variable Journey
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%)
mem_usage 37.95 MB
Missings 0 (0.00%)
JourneyCountFrequency
2,Commuting to/from work474508.80%
3,Taking pupil to/from school71831.33%
4,Pupil riding to/from school13370.25%
5 Other/Not known37874970.27%
Part of work10427019.35%
Journey
2,Commuting to/from work
8.80% 
3,Taking pupil to/from school
 
1.33%
4,Pupil riding to/from school
 
0.25%
5 Other/Not known
70.27% 
Part of work
19.35% 

Hit_Objects_in

Categories 13
Most frequent 0.0 (490,583 values, 91.02%)
Least frequent 1.0 (26 values, 0.00%)
mem_usage 4.11 MB
Missings 41 (0.01%)
Hit_Objects_inCountFrequencyHit_Objects_in Frequency
0.049058391.02%0.0
91.02% 
1.0260.00%1.0
 
0.00%
2.06800.13%2.0
 
0.13%
4.03280.06%4.0
 
0.06%
5.03320.06%5.0
 
0.06%
6.014260.26%6.0
 
0.26%
7.076591.42%7.0
 
1.42%
8.0430.01%8.0
 
0.01%
9.021050.39%9.0
 
0.39%
10.0286095.31%10.0
5.31% 
11.042560.79%11.0
 
0.79%
12.029010.54%12.0
 
0.54%
Variable Hit_Objects_in
Categories 13
Most frequent 0.0 (490,583 values, 91.02%)
Least frequent 1.0 (26 values, 0.00%)
mem_usage 4.11 MB
Missings 41 (0.01%)
Hit_Objects_inCountFrequency
0.049058391.02%
1.0260.00%
2.06800.13%
4.03280.06%
5.03320.06%
6.014260.26%
7.076591.42%
8.0430.01%
9.021050.39%
10.0286095.31%
11.042560.79%
12.029010.54%
Hit_Objects_in
0.0
91.02% 
1.0
 
0.00%
2.0
 
0.13%
4.0
 
0.06%
5.0
 
0.06%
6.0
 
0.26%
7.0
 
1.42%
8.0
 
0.01%
9.0
 
0.39%
10.0
5.31% 
11.0
 
0.79%
12.0
 
0.54%

Hit_Objects_off

Categories 13
Most frequent 0.0 (378,896 values, 70.30%)
Least frequent 8.0 (237 values, 0.04%)
mem_usage 4.11 MB
Missings 11 (0.00%)
Hit_Objects_offCountFrequencyHit_Objects_off Frequency
0.037889670.30%0.0
70.30% 
1.0130802.43%1.0
 
2.43%
2.0153112.84%2.0
 
2.84%
3.063371.18%3.0
 
1.18%
4.0311005.77%4.0
5.77% 
5.011570.21%5.0
 
0.21%
6.091611.70%6.0
 
1.70%
7.0115292.14%7.0
 
2.14%
8.02370.04%8.0
 
0.04%
9.0165433.07%9.0
 
3.07%
10.0505209.37%10.0
9.37% 
11.051070.95%11.0
 
0.95%
Variable Hit_Objects_off
Categories 13
Most frequent 0.0 (378,896 values, 70.30%)
Least frequent 8.0 (237 values, 0.04%)
mem_usage 4.11 MB
Missings 11 (0.00%)
Hit_Objects_offCountFrequency
0.037889670.30%
1.0130802.43%
2.0153112.84%
3.063371.18%
4.0311005.77%
5.011570.21%
6.091611.70%
7.0115292.14%
8.02370.04%
9.0165433.07%
10.0505209.37%
11.051070.95%
Hit_Objects_off
0.0
70.30% 
1.0
 
2.43%
2.0
 
2.84%
3.0
 
1.18%
4.0
5.77% 
5.0
 
0.21%
6.0
 
1.70%
7.0
 
2.14%
8.0
 
0.04%
9.0
 
3.07%
10.0
9.37% 
11.0
 
0.95%

Casualties

Categories 13
Most frequent 1 (460,856 values, 85.50%)
Least frequent 6 (6 values, 0.00%)
mem_usage 29.47 MB
Missings 0 (0.00%)
CasualtiesCountFrequencyCasualties Frequency
1144582.68%1
 
2.68%
214410.27%2
 
0.27%
33100.06%3
 
0.06%
41370.03%4
 
0.03%
5320.01%5
 
0.01%
660.00%6
 
0.00%
146085685.50%1
85.50% 
2466778.66%2
8.66% 
396201.78%3
 
1.78%
437500.70%4
 
0.70%
512220.23%5
 
0.23%
62500.05%6
 
0.05%
7 - 682300.04%7 - 68
 
0.04%
Variable Casualties
Categories 13
Most frequent 1 (460,856 values, 85.50%)
Least frequent 6 (6 values, 0.00%)
mem_usage 29.47 MB
Missings 0 (0.00%)
CasualtiesCountFrequency
1144582.68%
214410.27%
33100.06%
41370.03%
5320.01%
660.00%
146085685.50%
2466778.66%
396201.78%
437500.70%
512220.23%
62500.05%
7 - 682300.04%
Casualties
1
 
2.68%
2
 
0.27%
3
 
0.06%
4
 
0.03%
5
 
0.01%
6
 
0.00%
1
85.50% 
2
8.66% 
3
 
1.78%
4
 
0.70%
5
 
0.23%
6
 
0.05%
7 - 68
 
0.04%

Severity

Categories 3
Most frequent Slight (422,886 values, 78.46%)
Least frequent Fatal (10,349 values, 1.92%)
mem_usage 32.47 MB
Missings 0 (0.00%)
SeverityCountFrequencySeverity Frequency
Fatal103491.92%Fatal
 
1.92%
Serious10575419.62%Serious
19.62% 
Slight42288678.46%Slight
78.46% 
Variable Severity
Categories 3
Most frequent Slight (422,886 values, 78.46%)
Least frequent Fatal (10,349 values, 1.92%)
mem_usage 32.47 MB
Missings 0 (0.00%)
SeverityCountFrequency
Fatal103491.92%
Serious10575419.62%
Slight42288678.46%
Severity
Fatal
 
1.92%
Serious
19.62% 
Slight
78.46% 

Area

Categories 3
Most frequent 1,Urban (340,200 values, 63.12%)
Least frequent 2,Rural (198,743 values, 36.87%)
mem_usage 32.90 MB
Missings 46 (0.01%)
AreaCountFrequencyArea Frequency
1,Urban34020063.12%1,Urban
63.12% 
2,Rural19874336.87%2,Rural
36.87% 
Variable Area
Categories 3
Most frequent 1,Urban (340,200 values, 63.12%)
Least frequent 2,Rural (198,743 values, 36.87%)
mem_usage 32.90 MB
Missings 46 (0.01%)
AreaCountFrequency
1,Urban34020063.12%
2,Rural19874336.87%
Area
1,Urban
63.12% 
2,Rural
36.87% 

Vehicle_Age

Categories 18
Most frequent 7 (31,222 values, 5.79%)
Least frequent >20 (3,403 values, 0.63%)
mem_usage 26.32 MB
Missings 147,143 (27.30%)
Vehicle_AgeCountFrequencyVehicle_Age Frequency
1294325.46%1
5.46% 
10282195.24%10
5.24% 
11248004.60%11
 
4.60%
12208013.86%12
 
3.86%
13159992.97%13
 
2.97%
14110662.05%14
 
2.05%
1579011.47%15
 
1.47%
16-20126872.35%16-20
 
2.35%
2279765.19%2
5.19% 
3280625.21%3
5.21% 
4295205.48%4
5.48% 
5302285.61%5
5.61% 
6303805.64%6
5.64% 
7312225.79%7
5.79% 
8304695.65%8
5.65% 
9296815.51%9
5.51% 
>2034030.63%>20
 
0.63%
Variable Vehicle_Age
Categories 18
Most frequent 7 (31,222 values, 5.79%)
Least frequent >20 (3,403 values, 0.63%)
mem_usage 26.32 MB
Missings 147,143 (27.30%)
Vehicle_AgeCountFrequency
1294325.46%
10282195.24%
11248004.60%
12208013.86%
13159992.97%
14110662.05%
1579011.47%
16-20126872.35%
2279765.19%
3280625.21%
4295205.48%
5302285.61%
6303805.64%
7312225.79%
8304695.65%
9296815.51%
>2034030.63%
Vehicle_Age
1
5.46% 
10
5.24% 
11
 
4.60%
12
 
3.86%
13
 
2.97%
14
 
2.05%
15
 
1.47%
16-20
 
2.35%
2
5.19% 
3
5.21% 
4
5.48% 
5
5.61% 
6
5.64% 
7
5.79% 
8
5.65% 
9
5.51% 
>20
 
0.63%

Road_Type

Categories 6
Most frequent 6,Single carriageway (427,848 values, 79.38%)
Least frequent 7,Slip road (4,897 values, 0.91%)
mem_usage 39.02 MB
Missings 4,357 (0.81%)
Road_TypeCountFrequencyRoad_Type Frequency
1,Roundabout182753.39%1,Roundabout
 
3.39%
2,One way street176653.28%2,One way street
 
3.28%
3,Dual carriageway6594712.24%3,Dual carriageway
12.24% 
6,Single carriageway42784879.38%6,Single carriageway
79.38% 
7,Slip road48970.91%7,Slip road
 
0.91%
Variable Road_Type
Categories 6
Most frequent 6,Single carriageway (427,848 values, 79.38%)
Least frequent 7,Slip road (4,897 values, 0.91%)
mem_usage 39.02 MB
Missings 4,357 (0.81%)
Road_TypeCountFrequency
1,Roundabout182753.39%
2,One way street176653.28%
3,Dual carriageway6594712.24%
6,Single carriageway42784879.38%
7,Slip road48970.91%
Road_Type
1,Roundabout
 
3.39%
2,One way street
 
3.28%
3,Dual carriageway
12.24% 
6,Single carriageway
79.38% 
7,Slip road
 
0.91%

Speed_limit

Categories 8
Most frequent 30 (350,099 values, 64.95%)
Least frequent 15 (10 values, 0.00%)
mem_usage 4.11 MB
Missings 0 (0.00%)
Speed_limitCountFrequencySpeed_limit Frequency
10160.00%10
 
0.00%
15100.00%15
 
0.00%
2096361.79%20
 
1.79%
3035009964.95%30
64.95% 
40313355.81%40
5.81% 
50132342.46%50
 
2.46%
6010079518.70%60
18.70% 
70338646.28%70
6.28% 
Variable Speed_limit
Categories 8
Most frequent 30 (350,099 values, 64.95%)
Least frequent 15 (10 values, 0.00%)
mem_usage 4.11 MB
Missings 0 (0.00%)
Speed_limitCountFrequency
10160.00%
15100.00%
2096361.79%
3035009964.95%
40313355.81%
50132342.46%
6010079518.70%
70338646.28%
Speed_limit
10
 
0.00%
15
 
0.00%
20
 
1.79%
30
64.95% 
40
5.81% 
50
 
2.46%
60
18.70% 
70
6.28% 

Light

Categories 5
Most frequent 1,Daylight (358,282 values, 66.47%)
Least frequent 5,Darkness - lights unlit (2,934 values, 0.54%)
mem_usage 36.77 MB
Missings 0 (0.00%)
LightCountFrequencyLight Frequency
1,Daylight35828266.47%1,Daylight
66.47% 
4,Darkness - lights lit11816821.92%4,Darkness - lights lit
21.92% 
5,Darkness - lights unlit29340.54%5,Darkness - lights unlit
 
0.54%
6,Darkness - no lighting529239.82%6,Darkness - no lighting
9.82% 
7,Darkness - lighting unknown66821.24%7,Darkness - lighting unknown
 
1.24%
Variable Light
Categories 5
Most frequent 1,Daylight (358,282 values, 66.47%)
Least frequent 5,Darkness - lights unlit (2,934 values, 0.54%)
mem_usage 36.77 MB
Missings 0 (0.00%)
LightCountFrequency
1,Daylight35828266.47%
4,Darkness - lights lit11816821.92%
5,Darkness - lights unlit29340.54%
6,Darkness - no lighting529239.82%
7,Darkness - lighting unknown66821.24%
Light
1,Daylight
66.47% 
4,Darkness - lights lit
21.92% 
5,Darkness - lights unlit
 
0.54%
6,Darkness - no lighting
9.82% 
7,Darkness - lighting unknown
 
1.24%

Vehicle_Location

Categories 11
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%)
mem_usage 49.50 MB
Missings 43 (0.01%)
Vehicle_LocationCountFrequencyVehicle_Location Frequency
0,On main c'way - not in restricted lane51845196.19%0,On main c'way - not in restricted lane
96.19% 
1,Tram/Light rail track5040.09%1,Tram/Light rail track
 
0.09%
2,Bus lane41690.77%2,Bus lane
 
0.77%
3,Busway (including guided busway)10010.19%3,Busway (including guided busway)
 
0.19%
4,Cycle lane (on main carriageway)3220.06%4,Cycle lane (on main carriageway)
 
0.06%
5,Cycleway or shared use footway (not part of main carriageway)5990.11%5,Cycleway or shared use footway (not part of main carriageway)
 
0.11%
6,On lay-by or hard shoulder13040.24%6,On lay-by or hard shoulder
 
0.24%
7,Entering lay-by or hard shoulder4740.09%7,Entering lay-by or hard shoulder
 
0.09%
8,Leaving lay-by or hard shoulder6770.13%8,Leaving lay-by or hard shoulder
 
0.13%
9,Footway (pavement)114452.12%9,Footway (pavement)
 
2.12%
Variable Vehicle_Location
Categories 11
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%)
mem_usage 49.50 MB
Missings 43 (0.01%)
Vehicle_LocationCountFrequency
0,On main c'way - not in restricted lane51845196.19%
1,Tram/Light rail track5040.09%
2,Bus lane41690.77%
3,Busway (including guided busway)10010.19%
4,Cycle lane (on main carriageway)3220.06%
5,Cycleway or shared use footway (not part of main carriageway)5990.11%
6,On lay-by or hard shoulder13040.24%
7,Entering lay-by or hard shoulder4740.09%
8,Leaving lay-by or hard shoulder6770.13%
9,Footway (pavement)114452.12%
Vehicle_Location
0,On main c'way - not in restricted lane
96.19% 
1,Tram/Light rail track
 
0.09%
2,Bus lane
 
0.77%
3,Busway (including guided busway)
 
0.19%
4,Cycle lane (on main carriageway)
 
0.06%
5,Cycleway or shared use footway (not part of main carriageway)
 
0.11%
6,On lay-by or hard shoulder
 
0.24%
7,Entering lay-by or hard shoulder
 
0.09%
8,Leaving lay-by or hard shoulder
 
0.13%
9,Footway (pavement)
 
2.12%

Correlations

Overall correlations


Individual correlations





































































































































































































 
 
Created by pandas profiling categorical version 0.1.0