01_data_retrieval_step_2.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "cddb9d72",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "11abc158",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\gcwhi\\anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3165: DtypeWarning: Columns (0) have mixed types.Specify dtype option on import or set low_memory=False.\n",
      "  has_raised = await self.run_ast_nodes(code_ast.body, cell_name,\n"
     ]
    },
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>200501BS00004</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>2005-01-07</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>NISSAN</td>\n",
       "      <td>ALMERA SE AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>200501BS00006</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>2005-01-11</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>AUDI</td>\n",
       "      <td>A4 SPORT CABRIOLET AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Moving off</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>200501BS00006</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>2005-01-11</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>PIAGGIO</td>\n",
       "      <td>VESPA ET4</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Motorcycle 125cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>200501BS00007</td>\n",
       "      <td>C</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>2005-01-13</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Approaching junction or waiting/parked at junc...</td>\n",
       "      <td>MERCEDES</td>\n",
       "      <td>ML 430 AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Parked</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Back</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>200501BS00009</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005.0</td>\n",
       "      <td>2005-01-14</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1.0</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>JAGUAR</td>\n",
       "      <td>XJ-S CONVERTIBLE AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "  Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards    Year  \\\n",
       "0  200501BS00004              A            Slight                None  2005.0   \n",
       "1  200501BS00006   Unclassified            Slight                None  2005.0   \n",
       "2  200501BS00006   Unclassified            Slight                None  2005.0   \n",
       "3  200501BS00007              C            Slight                None  2005.0   \n",
       "4  200501BS00009              A            Slight                None  2005.0   \n",
       "\n",
       "         Date Day_of_Week  Did_Police_Officer_Attend_Scene_of_Accident  \\\n",
       "0  2005-01-07      Friday                                          1.0   \n",
       "1  2005-01-11     Tuesday                                          1.0   \n",
       "2  2005-01-11     Tuesday                                          1.0   \n",
       "3  2005-01-13    Thursday                                          1.0   \n",
       "4  2005-01-14      Friday                                          1.0   \n",
       "\n",
       "               Junction_Control                      Junction_Detail  ...  \\\n",
       "0  Data missing or out of range  Not at junction or within 20 metres  ...   \n",
       "1  Data missing or out of range  Not at junction or within 20 metres  ...   \n",
       "2  Data missing or out of range  Not at junction or within 20 metres  ...   \n",
       "3      Give way or uncontrolled              T or staggered junction  ...   \n",
       "4  Data missing or out of range  Not at junction or within 20 metres  ...   \n",
       "\n",
       "                                   Junction_Location      make  \\\n",
       "0             Not at or within 20 metres of junction    NISSAN   \n",
       "1             Not at or within 20 metres of junction      AUDI   \n",
       "2             Not at or within 20 metres of junction   PIAGGIO   \n",
       "3  Approaching junction or waiting/parked at junc...  MERCEDES   \n",
       "4             Not at or within 20 metres of junction    JAGUAR   \n",
       "\n",
       "                     model Propulsion_Code Sex_of_Driver  \\\n",
       "0           ALMERA SE AUTO          Petrol        Female   \n",
       "1  A4 SPORT CABRIOLET AUTO          Petrol          Male   \n",
       "2                VESPA ET4          Petrol        Female   \n",
       "3              ML 430 AUTO          Petrol          Male   \n",
       "4    XJ-S CONVERTIBLE AUTO          Petrol          Male   \n",
       "\n",
       "   Towing_and_Articulation  Vehicle_Manoeuvre                Vehicle_Type  \\\n",
       "0      No tow/articulation  Going ahead other                         Car   \n",
       "1      No tow/articulation         Moving off                         Car   \n",
       "2      No tow/articulation  Going ahead other  Motorcycle 125cc and under   \n",
       "3      No tow/articulation             Parked                         Car   \n",
       "4      No tow/articulation  Going ahead other                         Car   \n",
       "\n",
       "  Was_Vehicle_Left_Hand_Drive X1st_Point_of_Impact  \n",
       "0                          No                Front  \n",
       "1                          No       Did not impact  \n",
       "2                          No       Did not impact  \n",
       "3                          No                 Back  \n",
       "4                          No                Front  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#import data set from step 1 and create a dataframe\n",
    "file_3 = \"Resources/df2.csv\"\n",
    "newdf = pd.read_csv(file_3)\n",
    "\n",
    "newdf.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "e1bb5b94",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1556240 entries, 0 to 1556239\n",
      "Data columns (total 42 columns):\n",
      " #   Column                                       Non-Null Count    Dtype  \n",
      "---  ------                                       --------------    -----  \n",
      " 0   Accident_Index                               1556240 non-null  object \n",
      " 1   1st_Road_Class                               1556240 non-null  object \n",
      " 2   Accident_Severity                            1556240 non-null  object \n",
      " 3   Carriageway_Hazards                          1556240 non-null  object \n",
      " 4   Year                                         1556240 non-null  float64\n",
      " 5   Date                                         1556240 non-null  object \n",
      " 6   Day_of_Week                                  1556240 non-null  object \n",
      " 7   Did_Police_Officer_Attend_Scene_of_Accident  1556240 non-null  float64\n",
      " 8   Junction_Control                             1556240 non-null  object \n",
      " 9   Junction_Detail                              1556240 non-null  object \n",
      " 10  Junction_Detail.1                            1556240 non-null  object \n",
      " 11  Latitude                                     1556240 non-null  float64\n",
      " 12  Light_Conditions                             1556240 non-null  object \n",
      " 13  Local_Authority_(District)                   1556240 non-null  object \n",
      " 14  Local_Authority_(Highway)                    1556240 non-null  object \n",
      " 15  Longitude                                    1556240 non-null  float64\n",
      " 16  Number_of_Casualties                         1556240 non-null  float64\n",
      " 17  Number_of_Vehicles                           1556240 non-null  float64\n",
      " 18  Road_Surface_Conditions                      1556240 non-null  object \n",
      " 19  Road_Type                                    1556240 non-null  object \n",
      " 20  Special_Conditions_at_Site                   1556240 non-null  object \n",
      " 21  Speed_limit                                  1556240 non-null  float64\n",
      " 22  Time                                         1556240 non-null  object \n",
      " 23  Urban_or_Rural_Area                          1556240 non-null  object \n",
      " 24  Weather_Conditions                           1556240 non-null  object \n",
      " 25  Age_Band_of_Driver                           1556240 non-null  object \n",
      " 26  Age_of_Vehicle                               1556240 non-null  float64\n",
      " 27  Driver_Home_Area_Type                        1556240 non-null  object \n",
      " 28  Engine_Capacity_.CC.                         1556240 non-null  float64\n",
      " 29  Hit_Object_in_Carriageway                    1556240 non-null  object \n",
      " 30  Hit_Object_off_Carriageway                   1556240 non-null  object \n",
      " 31  Journey_Purpose_of_Driver                    1556240 non-null  object \n",
      " 32  Junction_Location                            1556240 non-null  object \n",
      " 33  make                                         1556240 non-null  object \n",
      " 34  model                                        1556240 non-null  object \n",
      " 35  Propulsion_Code                              1556240 non-null  object \n",
      " 36  Sex_of_Driver                                1556240 non-null  object \n",
      " 37  Towing_and_Articulation                      1556240 non-null  object \n",
      " 38  Vehicle_Manoeuvre                            1556240 non-null  object \n",
      " 39  Vehicle_Type                                 1556240 non-null  object \n",
      " 40  Was_Vehicle_Left_Hand_Drive                  1556240 non-null  object \n",
      " 41  X1st_Point_of_Impact                         1556240 non-null  object \n",
      "dtypes: float64(9), object(33)\n",
      "memory usage: 498.7+ MB\n"
     ]
    }
   ],
   "source": [
    "#check datatypes\n",
    "newdf.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "7e3fbc3f",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('int32')"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#adjust dataypes\n",
    "newdf['Year'] = newdf['Year'].astype(\"int\")\n",
    "newdf['Year'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "e22379f3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('int32')"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#adjust dataypes\n",
    "newdf['Did_Police_Officer_Attend_Scene_of_Accident'] = newdf['Did_Police_Officer_Attend_Scene_of_Accident'].astype(\"int\")\n",
    "newdf['Did_Police_Officer_Attend_Scene_of_Accident'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "22aa546e",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2013460234852    40\n",
       "201543P296025    28\n",
       "2009559D05333    18\n",
       "2011160B00431    17\n",
       "201320T014183    12\n",
       "                 ..\n",
       "201050JC2B021     1\n",
       "200932C112609     1\n",
       "2016010008813     1\n",
       "200905EE31929     1\n",
       "201201CW10515     1\n",
       "Name: Accident_Index, Length: 500000, dtype: int64"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# look for duplicate Accident Index numbers\n",
    "index_count=newdf['Accident_Index'].value_counts()\n",
    "index_count.head(500000)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "5c4c8d4b",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1556240, 42)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "495c4b79",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>200501BS00004</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-07</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>NISSAN</td>\n",
       "      <td>ALMERA SE AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>200501BS00006</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-11</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>AUDI</td>\n",
       "      <td>A4 SPORT CABRIOLET AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Moving off</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>200501BS00006</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-11</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>PIAGGIO</td>\n",
       "      <td>VESPA ET4</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Motorcycle 125cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>200501BS00007</td>\n",
       "      <td>C</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-13</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Approaching junction or waiting/parked at junc...</td>\n",
       "      <td>MERCEDES</td>\n",
       "      <td>ML 430 AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Parked</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Back</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>200501BS00009</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-14</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>JAGUAR</td>\n",
       "      <td>XJ-S CONVERTIBLE AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556235</th>\n",
       "      <td>2016984130916</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-10-28</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Cleared junction or waiting/parked at junction...</td>\n",
       "      <td>SEAT</td>\n",
       "      <td>IBIZA ECOMOTIVE TDI</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556236</th>\n",
       "      <td>2016984130916</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-10-28</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Cleared junction or waiting/parked at junction...</td>\n",
       "      <td>RENAULT</td>\n",
       "      <td>MEGANE DYNAMIQUE 16V</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Not known</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Parked</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556237</th>\n",
       "      <td>2016984131116</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>MINI</td>\n",
       "      <td>MINI COOPER</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556238</th>\n",
       "      <td>2016984131316</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-10-29</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>VAUXHALL</td>\n",
       "      <td>VECTRA SXI 16V</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556239</th>\n",
       "      <td>2016984133416</td>\n",
       "      <td>A(M)</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-12-25</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>MAZDA</td>\n",
       "      <td>CX-7 SPORT TECH D</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1556240 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "0        200501BS00004              A            Slight                None   \n",
       "1        200501BS00006   Unclassified            Slight                None   \n",
       "2        200501BS00006   Unclassified            Slight                None   \n",
       "3        200501BS00007              C            Slight                None   \n",
       "4        200501BS00009              A            Slight                None   \n",
       "...                ...            ...               ...                 ...   \n",
       "1556235  2016984130916              B            Slight                None   \n",
       "1556236  2016984130916              B            Slight                None   \n",
       "1556237  2016984131116              B            Slight                None   \n",
       "1556238  2016984131316              B            Slight                None   \n",
       "1556239  2016984133416           A(M)            Slight                None   \n",
       "\n",
       "         Year        Date Day_of_Week  \\\n",
       "0        2005  2005-01-07      Friday   \n",
       "1        2005  2005-01-11     Tuesday   \n",
       "2        2005  2005-01-11     Tuesday   \n",
       "3        2005  2005-01-13    Thursday   \n",
       "4        2005  2005-01-14      Friday   \n",
       "...       ...         ...         ...   \n",
       "1556235  2016  2016-10-28      Friday   \n",
       "1556236  2016  2016-10-28      Friday   \n",
       "1556237  2016  2016-11-01     Tuesday   \n",
       "1556238  2016  2016-10-29    Saturday   \n",
       "1556239  2016  2016-12-25      Sunday   \n",
       "\n",
       "         Did_Police_Officer_Attend_Scene_of_Accident  \\\n",
       "0                                                  1   \n",
       "1                                                  1   \n",
       "2                                                  1   \n",
       "3                                                  1   \n",
       "4                                                  1   \n",
       "...                                              ...   \n",
       "1556235                                            1   \n",
       "1556236                                            1   \n",
       "1556237                                            1   \n",
       "1556238                                            1   \n",
       "1556239                                            1   \n",
       "\n",
       "                     Junction_Control                      Junction_Detail  \\\n",
       "0        Data missing or out of range  Not at junction or within 20 metres   \n",
       "1        Data missing or out of range  Not at junction or within 20 metres   \n",
       "2        Data missing or out of range  Not at junction or within 20 metres   \n",
       "3            Give way or uncontrolled              T or staggered junction   \n",
       "4        Data missing or out of range  Not at junction or within 20 metres   \n",
       "...                               ...                                  ...   \n",
       "1556235      Give way or uncontrolled              T or staggered junction   \n",
       "1556236      Give way or uncontrolled              T or staggered junction   \n",
       "1556237      Give way or uncontrolled                           Crossroads   \n",
       "1556238  Data missing or out of range  Not at junction or within 20 metres   \n",
       "1556239  Data missing or out of range  Not at junction or within 20 metres   \n",
       "\n",
       "         ...                                  Junction_Location      make  \\\n",
       "0        ...             Not at or within 20 metres of junction    NISSAN   \n",
       "1        ...             Not at or within 20 metres of junction      AUDI   \n",
       "2        ...             Not at or within 20 metres of junction   PIAGGIO   \n",
       "3        ...  Approaching junction or waiting/parked at junc...  MERCEDES   \n",
       "4        ...             Not at or within 20 metres of junction    JAGUAR   \n",
       "...      ...                                                ...       ...   \n",
       "1556235  ...  Cleared junction or waiting/parked at junction...      SEAT   \n",
       "1556236  ...  Cleared junction or waiting/parked at junction...   RENAULT   \n",
       "1556237  ...       Mid Junction - on roundabout or on main road      MINI   \n",
       "1556238  ...             Not at or within 20 metres of junction  VAUXHALL   \n",
       "1556239  ...             Not at or within 20 metres of junction     MAZDA   \n",
       "\n",
       "                           model Propulsion_Code Sex_of_Driver  \\\n",
       "0                 ALMERA SE AUTO          Petrol        Female   \n",
       "1        A4 SPORT CABRIOLET AUTO          Petrol          Male   \n",
       "2                      VESPA ET4          Petrol        Female   \n",
       "3                    ML 430 AUTO          Petrol          Male   \n",
       "4          XJ-S CONVERTIBLE AUTO          Petrol          Male   \n",
       "...                          ...             ...           ...   \n",
       "1556235      IBIZA ECOMOTIVE TDI       Heavy oil        Female   \n",
       "1556236     MEGANE DYNAMIQUE 16V          Petrol     Not known   \n",
       "1556237              MINI COOPER          Petrol        Female   \n",
       "1556238           VECTRA SXI 16V          Petrol          Male   \n",
       "1556239        CX-7 SPORT TECH D       Heavy oil          Male   \n",
       "\n",
       "         Towing_and_Articulation  Vehicle_Manoeuvre  \\\n",
       "0            No tow/articulation  Going ahead other   \n",
       "1            No tow/articulation         Moving off   \n",
       "2            No tow/articulation  Going ahead other   \n",
       "3            No tow/articulation             Parked   \n",
       "4            No tow/articulation  Going ahead other   \n",
       "...                          ...                ...   \n",
       "1556235      No tow/articulation  Going ahead other   \n",
       "1556236      No tow/articulation             Parked   \n",
       "1556237      No tow/articulation  Going ahead other   \n",
       "1556238      No tow/articulation  Going ahead other   \n",
       "1556239      No tow/articulation  Going ahead other   \n",
       "\n",
       "                       Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "0                               Car                          No   \n",
       "1                               Car                          No   \n",
       "2        Motorcycle 125cc and under                          No   \n",
       "3                               Car                          No   \n",
       "4                               Car                          No   \n",
       "...                             ...                         ...   \n",
       "1556235                         Car                          No   \n",
       "1556236                         Car                          No   \n",
       "1556237                         Car                          No   \n",
       "1556238                         Car                          No   \n",
       "1556239                         Car                          No   \n",
       "\n",
       "        X1st_Point_of_Impact  \n",
       "0                      Front  \n",
       "1             Did not impact  \n",
       "2             Did not impact  \n",
       "3                       Back  \n",
       "4                      Front  \n",
       "...                      ...  \n",
       "1556235                Front  \n",
       "1556236                Front  \n",
       "1556237                Front  \n",
       "1556238                Front  \n",
       "1556239             Nearside  \n",
       "\n",
       "[1556240 rows x 42 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "newdf"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "500013a6",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>200501BS00004</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-07</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>NISSAN</td>\n",
       "      <td>ALMERA SE AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>200501BS00006</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-11</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>AUDI</td>\n",
       "      <td>A4 SPORT CABRIOLET AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Moving off</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>200501BS00006</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-11</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>PIAGGIO</td>\n",
       "      <td>VESPA ET4</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Motorcycle 125cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>200501BS00007</td>\n",
       "      <td>C</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-13</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Approaching junction or waiting/parked at junc...</td>\n",
       "      <td>MERCEDES</td>\n",
       "      <td>ML 430 AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Parked</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Back</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>200501BS00009</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2005</td>\n",
       "      <td>2005-01-14</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>JAGUAR</td>\n",
       "      <td>XJ-S CONVERTIBLE AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556235</th>\n",
       "      <td>2016984130916</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-10-28</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Cleared junction or waiting/parked at junction...</td>\n",
       "      <td>SEAT</td>\n",
       "      <td>IBIZA ECOMOTIVE TDI</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556236</th>\n",
       "      <td>2016984130916</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-10-28</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Cleared junction or waiting/parked at junction...</td>\n",
       "      <td>RENAULT</td>\n",
       "      <td>MEGANE DYNAMIQUE 16V</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Not known</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Parked</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556237</th>\n",
       "      <td>2016984131116</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>MINI</td>\n",
       "      <td>MINI COOPER</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556238</th>\n",
       "      <td>2016984131316</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-10-29</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>VAUXHALL</td>\n",
       "      <td>VECTRA SXI 16V</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1556239</th>\n",
       "      <td>2016984133416</td>\n",
       "      <td>A(M)</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-12-25</td>\n",
       "      <td>Sunday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>MAZDA</td>\n",
       "      <td>CX-7 SPORT TECH D</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1556240 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "0        200501BS00004              A            Slight                None   \n",
       "1        200501BS00006   Unclassified            Slight                None   \n",
       "2        200501BS00006   Unclassified            Slight                None   \n",
       "3        200501BS00007              C            Slight                None   \n",
       "4        200501BS00009              A            Slight                None   \n",
       "...                ...            ...               ...                 ...   \n",
       "1556235  2016984130916              B            Slight                None   \n",
       "1556236  2016984130916              B            Slight                None   \n",
       "1556237  2016984131116              B            Slight                None   \n",
       "1556238  2016984131316              B            Slight                None   \n",
       "1556239  2016984133416           A(M)            Slight                None   \n",
       "\n",
       "         Year        Date Day_of_Week  \\\n",
       "0        2005  2005-01-07      Friday   \n",
       "1        2005  2005-01-11     Tuesday   \n",
       "2        2005  2005-01-11     Tuesday   \n",
       "3        2005  2005-01-13    Thursday   \n",
       "4        2005  2005-01-14      Friday   \n",
       "...       ...         ...         ...   \n",
       "1556235  2016  2016-10-28      Friday   \n",
       "1556236  2016  2016-10-28      Friday   \n",
       "1556237  2016  2016-11-01     Tuesday   \n",
       "1556238  2016  2016-10-29    Saturday   \n",
       "1556239  2016  2016-12-25      Sunday   \n",
       "\n",
       "         Did_Police_Officer_Attend_Scene_of_Accident  \\\n",
       "0                                                  1   \n",
       "1                                                  1   \n",
       "2                                                  1   \n",
       "3                                                  1   \n",
       "4                                                  1   \n",
       "...                                              ...   \n",
       "1556235                                            1   \n",
       "1556236                                            1   \n",
       "1556237                                            1   \n",
       "1556238                                            1   \n",
       "1556239                                            1   \n",
       "\n",
       "                     Junction_Control                      Junction_Detail  \\\n",
       "0        Data missing or out of range  Not at junction or within 20 metres   \n",
       "1        Data missing or out of range  Not at junction or within 20 metres   \n",
       "2        Data missing or out of range  Not at junction or within 20 metres   \n",
       "3            Give way or uncontrolled              T or staggered junction   \n",
       "4        Data missing or out of range  Not at junction or within 20 metres   \n",
       "...                               ...                                  ...   \n",
       "1556235      Give way or uncontrolled              T or staggered junction   \n",
       "1556236      Give way or uncontrolled              T or staggered junction   \n",
       "1556237      Give way or uncontrolled                           Crossroads   \n",
       "1556238  Data missing or out of range  Not at junction or within 20 metres   \n",
       "1556239  Data missing or out of range  Not at junction or within 20 metres   \n",
       "\n",
       "         ...                                  Junction_Location      make  \\\n",
       "0        ...             Not at or within 20 metres of junction    NISSAN   \n",
       "1        ...             Not at or within 20 metres of junction      AUDI   \n",
       "2        ...             Not at or within 20 metres of junction   PIAGGIO   \n",
       "3        ...  Approaching junction or waiting/parked at junc...  MERCEDES   \n",
       "4        ...             Not at or within 20 metres of junction    JAGUAR   \n",
       "...      ...                                                ...       ...   \n",
       "1556235  ...  Cleared junction or waiting/parked at junction...      SEAT   \n",
       "1556236  ...  Cleared junction or waiting/parked at junction...   RENAULT   \n",
       "1556237  ...       Mid Junction - on roundabout or on main road      MINI   \n",
       "1556238  ...             Not at or within 20 metres of junction  VAUXHALL   \n",
       "1556239  ...             Not at or within 20 metres of junction     MAZDA   \n",
       "\n",
       "                           model Propulsion_Code Sex_of_Driver  \\\n",
       "0                 ALMERA SE AUTO          Petrol        Female   \n",
       "1        A4 SPORT CABRIOLET AUTO          Petrol          Male   \n",
       "2                      VESPA ET4          Petrol        Female   \n",
       "3                    ML 430 AUTO          Petrol          Male   \n",
       "4          XJ-S CONVERTIBLE AUTO          Petrol          Male   \n",
       "...                          ...             ...           ...   \n",
       "1556235      IBIZA ECOMOTIVE TDI       Heavy oil        Female   \n",
       "1556236     MEGANE DYNAMIQUE 16V          Petrol     Not known   \n",
       "1556237              MINI COOPER          Petrol        Female   \n",
       "1556238           VECTRA SXI 16V          Petrol          Male   \n",
       "1556239        CX-7 SPORT TECH D       Heavy oil          Male   \n",
       "\n",
       "         Towing_and_Articulation  Vehicle_Manoeuvre  \\\n",
       "0            No tow/articulation  Going ahead other   \n",
       "1            No tow/articulation         Moving off   \n",
       "2            No tow/articulation  Going ahead other   \n",
       "3            No tow/articulation             Parked   \n",
       "4            No tow/articulation  Going ahead other   \n",
       "...                          ...                ...   \n",
       "1556235      No tow/articulation  Going ahead other   \n",
       "1556236      No tow/articulation             Parked   \n",
       "1556237      No tow/articulation  Going ahead other   \n",
       "1556238      No tow/articulation  Going ahead other   \n",
       "1556239      No tow/articulation  Going ahead other   \n",
       "\n",
       "                       Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "0                               Car                          No   \n",
       "1                               Car                          No   \n",
       "2        Motorcycle 125cc and under                          No   \n",
       "3                               Car                          No   \n",
       "4                               Car                          No   \n",
       "...                             ...                         ...   \n",
       "1556235                         Car                          No   \n",
       "1556236                         Car                          No   \n",
       "1556237                         Car                          No   \n",
       "1556238                         Car                          No   \n",
       "1556239                         Car                          No   \n",
       "\n",
       "        X1st_Point_of_Impact  \n",
       "0                      Front  \n",
       "1             Did not impact  \n",
       "2             Did not impact  \n",
       "3                       Back  \n",
       "4                      Front  \n",
       "...                      ...  \n",
       "1556235                Front  \n",
       "1556236                Front  \n",
       "1556237                Front  \n",
       "1556238                Front  \n",
       "1556239             Nearside  \n",
       "\n",
       "[1556240 rows x 42 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "newdf1 = newdf\n",
    "newdf1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "bafd4cb8",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1556240 entries, 0 to 1556239\n",
      "Data columns (total 42 columns):\n",
      " #   Column                                       Non-Null Count    Dtype  \n",
      "---  ------                                       --------------    -----  \n",
      " 0   Accident_Index                               1556240 non-null  object \n",
      " 1   1st_Road_Class                               1556240 non-null  object \n",
      " 2   Accident_Severity                            1556240 non-null  object \n",
      " 3   Carriageway_Hazards                          1556240 non-null  object \n",
      " 4   Year                                         1556240 non-null  int32  \n",
      " 5   Date                                         1556240 non-null  object \n",
      " 6   Day_of_Week                                  1556240 non-null  object \n",
      " 7   Did_Police_Officer_Attend_Scene_of_Accident  1556240 non-null  int32  \n",
      " 8   Junction_Control                             1556240 non-null  object \n",
      " 9   Junction_Detail                              1556240 non-null  object \n",
      " 10  Junction_Detail.1                            1556240 non-null  object \n",
      " 11  Latitude                                     1556240 non-null  float64\n",
      " 12  Light_Conditions                             1556240 non-null  object \n",
      " 13  Local_Authority_(District)                   1556240 non-null  object \n",
      " 14  Local_Authority_(Highway)                    1556240 non-null  object \n",
      " 15  Longitude                                    1556240 non-null  float64\n",
      " 16  Number_of_Casualties                         1556240 non-null  float64\n",
      " 17  Number_of_Vehicles                           1556240 non-null  float64\n",
      " 18  Road_Surface_Conditions                      1556240 non-null  object \n",
      " 19  Road_Type                                    1556240 non-null  object \n",
      " 20  Special_Conditions_at_Site                   1556240 non-null  object \n",
      " 21  Speed_limit                                  1556240 non-null  float64\n",
      " 22  Time                                         1556240 non-null  object \n",
      " 23  Urban_or_Rural_Area                          1556240 non-null  object \n",
      " 24  Weather_Conditions                           1556240 non-null  object \n",
      " 25  Age_Band_of_Driver                           1556240 non-null  object \n",
      " 26  Age_of_Vehicle                               1556240 non-null  float64\n",
      " 27  Driver_Home_Area_Type                        1556240 non-null  object \n",
      " 28  Engine_Capacity_.CC.                         1556240 non-null  float64\n",
      " 29  Hit_Object_in_Carriageway                    1556240 non-null  object \n",
      " 30  Hit_Object_off_Carriageway                   1556240 non-null  object \n",
      " 31  Journey_Purpose_of_Driver                    1556240 non-null  object \n",
      " 32  Junction_Location                            1556240 non-null  object \n",
      " 33  make                                         1556240 non-null  object \n",
      " 34  model                                        1556240 non-null  object \n",
      " 35  Propulsion_Code                              1556240 non-null  object \n",
      " 36  Sex_of_Driver                                1556240 non-null  object \n",
      " 37  Towing_and_Articulation                      1556240 non-null  object \n",
      " 38  Vehicle_Manoeuvre                            1556240 non-null  object \n",
      " 39  Vehicle_Type                                 1556240 non-null  object \n",
      " 40  Was_Vehicle_Left_Hand_Drive                  1556240 non-null  object \n",
      " 41  X1st_Point_of_Impact                         1556240 non-null  object \n",
      "dtypes: float64(7), int32(2), object(33)\n",
      "memory usage: 486.8+ MB\n"
     ]
    }
   ],
   "source": [
    "#review data types and numbers\n",
    "newdf1.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "b00aca6a",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dtype('int32')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# change dataypes\n",
    "newdf1['Number_of_Casualties'] = newdf1['Number_of_Casualties'].astype(\"int\")\n",
    "newdf1['Number_of_Casualties'].dtype"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "3ecb8342",
   "metadata": {},
   "outputs": [],
   "source": [
    "# change dataypes\n",
    "newdf1['Number_of_Vehicles'] = newdf1['Number_of_Vehicles'].astype(\"int\")\n",
    "newdf1['Speed_limit'] = newdf1['Speed_limit'].astype(\"int\") \n",
    "newdf1['Age_of_Vehicle'] = newdf1['Age_of_Vehicle'].astype(\"int\") \n",
    "newdf1['Engine_Capacity_.CC.'] = newdf1['Engine_Capacity_.CC.'].astype(\"int\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "d470d98d",
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 1556240 entries, 0 to 1556239\n",
      "Data columns (total 42 columns):\n",
      " #   Column                                       Non-Null Count    Dtype  \n",
      "---  ------                                       --------------    -----  \n",
      " 0   Accident_Index                               1556240 non-null  object \n",
      " 1   1st_Road_Class                               1556240 non-null  object \n",
      " 2   Accident_Severity                            1556240 non-null  object \n",
      " 3   Carriageway_Hazards                          1556240 non-null  object \n",
      " 4   Year                                         1556240 non-null  int32  \n",
      " 5   Date                                         1556240 non-null  object \n",
      " 6   Day_of_Week                                  1556240 non-null  object \n",
      " 7   Did_Police_Officer_Attend_Scene_of_Accident  1556240 non-null  int32  \n",
      " 8   Junction_Control                             1556240 non-null  object \n",
      " 9   Junction_Detail                              1556240 non-null  object \n",
      " 10  Junction_Detail.1                            1556240 non-null  object \n",
      " 11  Latitude                                     1556240 non-null  float64\n",
      " 12  Light_Conditions                             1556240 non-null  object \n",
      " 13  Local_Authority_(District)                   1556240 non-null  object \n",
      " 14  Local_Authority_(Highway)                    1556240 non-null  object \n",
      " 15  Longitude                                    1556240 non-null  float64\n",
      " 16  Number_of_Casualties                         1556240 non-null  int32  \n",
      " 17  Number_of_Vehicles                           1556240 non-null  int32  \n",
      " 18  Road_Surface_Conditions                      1556240 non-null  object \n",
      " 19  Road_Type                                    1556240 non-null  object \n",
      " 20  Special_Conditions_at_Site                   1556240 non-null  object \n",
      " 21  Speed_limit                                  1556240 non-null  int32  \n",
      " 22  Time                                         1556240 non-null  object \n",
      " 23  Urban_or_Rural_Area                          1556240 non-null  object \n",
      " 24  Weather_Conditions                           1556240 non-null  object \n",
      " 25  Age_Band_of_Driver                           1556240 non-null  object \n",
      " 26  Age_of_Vehicle                               1556240 non-null  int32  \n",
      " 27  Driver_Home_Area_Type                        1556240 non-null  object \n",
      " 28  Engine_Capacity_.CC.                         1556240 non-null  int32  \n",
      " 29  Hit_Object_in_Carriageway                    1556240 non-null  object \n",
      " 30  Hit_Object_off_Carriageway                   1556240 non-null  object \n",
      " 31  Journey_Purpose_of_Driver                    1556240 non-null  object \n",
      " 32  Junction_Location                            1556240 non-null  object \n",
      " 33  make                                         1556240 non-null  object \n",
      " 34  model                                        1556240 non-null  object \n",
      " 35  Propulsion_Code                              1556240 non-null  object \n",
      " 36  Sex_of_Driver                                1556240 non-null  object \n",
      " 37  Towing_and_Articulation                      1556240 non-null  object \n",
      " 38  Vehicle_Manoeuvre                            1556240 non-null  object \n",
      " 39  Vehicle_Type                                 1556240 non-null  object \n",
      " 40  Was_Vehicle_Left_Hand_Drive                  1556240 non-null  object \n",
      " 41  X1st_Point_of_Impact                         1556240 non-null  object \n",
      "dtypes: float64(2), int32(7), object(33)\n",
      "memory usage: 457.1+ MB\n"
     ]
    }
   ],
   "source": [
    "# check number and data types\n",
    "newdf1.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "cf9531ea",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2016    183800\n",
       "2015    165116\n",
       "2014    151182\n",
       "2011    147392\n",
       "2009    146912\n",
       "2010    145834\n",
       "2012    142542\n",
       "2013    141787\n",
       "2007     89414\n",
       "2008     87374\n",
       "2006     78745\n",
       "2005     76142\n",
       "Name: Year, dtype: int64"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#check index numbers per year\n",
    "newdf1['Year'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "c63988f0",
   "metadata": {},
   "outputs": [],
   "source": [
    "#safe to csv in Resources folder\n",
    "newdf1.to_csv(\"Resources/data_cleaned.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "1c54a051",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "None                                               1529953\n",
       "Other object on road                                 10658\n",
       "Any animal in carriageway (except ridden horse)       6616\n",
       "Previous accident                                     3813\n",
       "Pedestrian in carriageway - not injured               2717\n",
       "Vehicle load on road                                  1976\n",
       "Data missing or out of range                           507\n",
       "Name: Carriageway_Hazards, dtype: int64"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#check some counts to see if columns are relevant\n",
    "newdf1['Carriageway_Hazards'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "4de577c0",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Year</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Latitude</th>\n",
       "      <th>Longitude</th>\n",
       "      <th>Number_of_Casualties</th>\n",
       "      <th>Number_of_Vehicles</th>\n",
       "      <th>Speed_limit</th>\n",
       "      <th>Age_of_Vehicle</th>\n",
       "      <th>Engine_Capacity_.CC.</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>count</th>\n",
       "      <td>1.556240e+06</td>\n",
       "      <td>1.556240e+06</td>\n",
       "      <td>1.556240e+06</td>\n",
       "      <td>1.556240e+06</td>\n",
       "      <td>1.556240e+06</td>\n",
       "      <td>1.556240e+06</td>\n",
       "      <td>1.556240e+06</td>\n",
       "      <td>1.556240e+06</td>\n",
       "      <td>1.556240e+06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>mean</th>\n",
       "      <td>2.011353e+03</td>\n",
       "      <td>1.164413e+00</td>\n",
       "      <td>5.255208e+01</td>\n",
       "      <td>-1.393227e+00</td>\n",
       "      <td>1.472103e+00</td>\n",
       "      <td>2.141679e+00</td>\n",
       "      <td>3.973825e+01</td>\n",
       "      <td>7.019777e+00</td>\n",
       "      <td>1.687034e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>std</th>\n",
       "      <td>3.283035e+00</td>\n",
       "      <td>3.762302e-01</td>\n",
       "      <td>1.435422e+00</td>\n",
       "      <td>1.384689e+00</td>\n",
       "      <td>1.013126e+00</td>\n",
       "      <td>9.682066e-01</td>\n",
       "      <td>1.453201e+01</td>\n",
       "      <td>4.482254e+00</td>\n",
       "      <td>9.011550e+02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>min</th>\n",
       "      <td>2.005000e+03</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>4.991414e+01</td>\n",
       "      <td>-7.516225e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>1.000000e+01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25%</th>\n",
       "      <td>2.009000e+03</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>5.148115e+01</td>\n",
       "      <td>-2.270039e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>3.000000e+01</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>1.299000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50%</th>\n",
       "      <td>2.012000e+03</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>5.224495e+01</td>\n",
       "      <td>-1.357131e+00</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>3.000000e+01</td>\n",
       "      <td>7.000000e+00</td>\n",
       "      <td>1.598000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75%</th>\n",
       "      <td>2.014000e+03</td>\n",
       "      <td>1.000000e+00</td>\n",
       "      <td>5.345764e+01</td>\n",
       "      <td>-2.220175e-01</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>2.000000e+00</td>\n",
       "      <td>5.000000e+01</td>\n",
       "      <td>1.000000e+01</td>\n",
       "      <td>1.994000e+03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>max</th>\n",
       "      <td>2.016000e+03</td>\n",
       "      <td>3.000000e+00</td>\n",
       "      <td>6.066204e+01</td>\n",
       "      <td>1.759382e+00</td>\n",
       "      <td>9.300000e+01</td>\n",
       "      <td>6.700000e+01</td>\n",
       "      <td>7.000000e+01</td>\n",
       "      <td>7.600000e+01</td>\n",
       "      <td>9.100000e+04</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               Year  Did_Police_Officer_Attend_Scene_of_Accident  \\\n",
       "count  1.556240e+06                                 1.556240e+06   \n",
       "mean   2.011353e+03                                 1.164413e+00   \n",
       "std    3.283035e+00                                 3.762302e-01   \n",
       "min    2.005000e+03                                 1.000000e+00   \n",
       "25%    2.009000e+03                                 1.000000e+00   \n",
       "50%    2.012000e+03                                 1.000000e+00   \n",
       "75%    2.014000e+03                                 1.000000e+00   \n",
       "max    2.016000e+03                                 3.000000e+00   \n",
       "\n",
       "           Latitude     Longitude  Number_of_Casualties  Number_of_Vehicles  \\\n",
       "count  1.556240e+06  1.556240e+06          1.556240e+06        1.556240e+06   \n",
       "mean   5.255208e+01 -1.393227e+00          1.472103e+00        2.141679e+00   \n",
       "std    1.435422e+00  1.384689e+00          1.013126e+00        9.682066e-01   \n",
       "min    4.991414e+01 -7.516225e+00          1.000000e+00        1.000000e+00   \n",
       "25%    5.148115e+01 -2.270039e+00          1.000000e+00        2.000000e+00   \n",
       "50%    5.224495e+01 -1.357131e+00          1.000000e+00        2.000000e+00   \n",
       "75%    5.345764e+01 -2.220175e-01          2.000000e+00        2.000000e+00   \n",
       "max    6.066204e+01  1.759382e+00          9.300000e+01        6.700000e+01   \n",
       "\n",
       "        Speed_limit  Age_of_Vehicle  Engine_Capacity_.CC.  \n",
       "count  1.556240e+06    1.556240e+06          1.556240e+06  \n",
       "mean   3.973825e+01    7.019777e+00          1.687034e+03  \n",
       "std    1.453201e+01    4.482254e+00          9.011550e+02  \n",
       "min    1.000000e+01    1.000000e+00          1.000000e+01  \n",
       "25%    3.000000e+01    3.000000e+00          1.299000e+03  \n",
       "50%    3.000000e+01    7.000000e+00          1.598000e+03  \n",
       "75%    5.000000e+01    1.000000e+01          1.994000e+03  \n",
       "max    7.000000e+01    7.600000e+01          9.100000e+04  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#check statistical info\n",
    "newdf1.describe()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "b2fdee43",
   "metadata": {},
   "outputs": [],
   "source": [
    "# make and save csv's for 2010 so that it can be opened and studied\n",
    "df_2010 = newdf1.loc[newdf1[\"Year\"]==2010]\n",
    "df_2010.head()\n",
    "df_2010.to_csv(\"Resources/2010.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "061e91b9",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>624421</th>\n",
       "      <td>201101BS70002</td>\n",
       "      <td>C</td>\n",
       "      <td>Serious</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "      <td>2011-01-11</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>HONDA</td>\n",
       "      <td>ANF 126-6</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Motorcycle 125cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624422</th>\n",
       "      <td>201101BS70005</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "      <td>2011-01-25</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Mini-roundabout</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>LONDON TAXIS INT</td>\n",
       "      <td>TXII BRONZE AUTO</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Taxi/Private hire car</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624423</th>\n",
       "      <td>201101BS70005</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "      <td>2011-01-25</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Mini-roundabout</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>BMW</td>\n",
       "      <td>320I SE AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624424</th>\n",
       "      <td>201101BS70007</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "      <td>2011-01-06</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>VOLKSWAGEN</td>\n",
       "      <td>GOLF GTI (115 BHP)</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Slowing or stopping</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>624425</th>\n",
       "      <td>201101BS70009</td>\n",
       "      <td>C</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2011</td>\n",
       "      <td>2011-01-27</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>VOLKSWAGEN</td>\n",
       "      <td>GOLF MATCH FSI 115</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Turning right</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Offside</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "624421  201101BS70002              C           Serious                None   \n",
       "624422  201101BS70005   Unclassified            Slight                None   \n",
       "624423  201101BS70005   Unclassified            Slight                None   \n",
       "624424  201101BS70007              A            Slight                None   \n",
       "624425  201101BS70009              C            Slight                None   \n",
       "\n",
       "        Year        Date Day_of_Week  \\\n",
       "624421  2011  2011-01-11     Tuesday   \n",
       "624422  2011  2011-01-25     Tuesday   \n",
       "624423  2011  2011-01-25     Tuesday   \n",
       "624424  2011  2011-01-06    Thursday   \n",
       "624425  2011  2011-01-27    Thursday   \n",
       "\n",
       "        Did_Police_Officer_Attend_Scene_of_Accident  \\\n",
       "624421                                            1   \n",
       "624422                                            1   \n",
       "624423                                            1   \n",
       "624424                                            2   \n",
       "624425                                            1   \n",
       "\n",
       "                    Junction_Control                      Junction_Detail  \\\n",
       "624421      Give way or uncontrolled              T or staggered junction   \n",
       "624422      Give way or uncontrolled                      Mini-roundabout   \n",
       "624423      Give way or uncontrolled                      Mini-roundabout   \n",
       "624424  Data missing or out of range  Not at junction or within 20 metres   \n",
       "624425      Give way or uncontrolled                           Crossroads   \n",
       "\n",
       "        ...                             Junction_Location              make  \\\n",
       "624421  ...  Mid Junction - on roundabout or on main road             HONDA   \n",
       "624422  ...  Mid Junction - on roundabout or on main road  LONDON TAXIS INT   \n",
       "624423  ...  Mid Junction - on roundabout or on main road               BMW   \n",
       "624424  ...        Not at or within 20 metres of junction        VOLKSWAGEN   \n",
       "624425  ...  Mid Junction - on roundabout or on main road        VOLKSWAGEN   \n",
       "\n",
       "                     model Propulsion_Code Sex_of_Driver  \\\n",
       "624421           ANF 126-6          Petrol          Male   \n",
       "624422    TXII BRONZE AUTO       Heavy oil          Male   \n",
       "624423        320I SE AUTO          Petrol          Male   \n",
       "624424  GOLF GTI (115 BHP)          Petrol          Male   \n",
       "624425  GOLF MATCH FSI 115          Petrol        Female   \n",
       "\n",
       "        Towing_and_Articulation    Vehicle_Manoeuvre  \\\n",
       "624421      No tow/articulation    Going ahead other   \n",
       "624422      No tow/articulation    Going ahead other   \n",
       "624423      No tow/articulation    Going ahead other   \n",
       "624424      No tow/articulation  Slowing or stopping   \n",
       "624425      No tow/articulation        Turning right   \n",
       "\n",
       "                      Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "624421  Motorcycle 125cc and under                          No   \n",
       "624422       Taxi/Private hire car                          No   \n",
       "624423                         Car                          No   \n",
       "624424                         Car                          No   \n",
       "624425                         Car                          No   \n",
       "\n",
       "       X1st_Point_of_Impact  \n",
       "624421             Nearside  \n",
       "624422             Nearside  \n",
       "624423                Front  \n",
       "624424                Front  \n",
       "624425              Offside  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make data frame for each year from 2010 to 2016\n",
    "df_2011 = newdf1.loc[newdf1[\"Year\"]==2011]\n",
    "df_2011.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "5dfac199",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>771813</th>\n",
       "      <td>201201BS70001</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>2012-01-19</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1</td>\n",
       "      <td>Auto traffic signal</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>VOLKSWAGEN</td>\n",
       "      <td>POLO S 80 AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Turning right</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771814</th>\n",
       "      <td>201201BS70003</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>2012-01-10</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>VOLKSWAGEN</td>\n",
       "      <td>GOLF S AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771815</th>\n",
       "      <td>201201BS70003</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>2012-01-10</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>PIAGGIO</td>\n",
       "      <td>FLY 125</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Motorcycle 50cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771816</th>\n",
       "      <td>201201BS70004</td>\n",
       "      <td>C</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>2012-01-18</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>MERCEDES</td>\n",
       "      <td>SPRINTER 313 CDI</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Moving off</td>\n",
       "      <td>Van / Goods 3.5 tonnes mgw or under</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>771817</th>\n",
       "      <td>201201BS70005</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2012</td>\n",
       "      <td>2012-01-17</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>LAND ROVER</td>\n",
       "      <td>FREELANDER HSE TD4 A</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "771813  201201BS70001              A            Slight                None   \n",
       "771814  201201BS70003              A            Slight                None   \n",
       "771815  201201BS70003              A            Slight                None   \n",
       "771816  201201BS70004              C            Slight                None   \n",
       "771817  201201BS70005              B            Slight                None   \n",
       "\n",
       "        Year        Date Day_of_Week  \\\n",
       "771813  2012  2012-01-19    Thursday   \n",
       "771814  2012  2012-01-10     Tuesday   \n",
       "771815  2012  2012-01-10     Tuesday   \n",
       "771816  2012  2012-01-18   Wednesday   \n",
       "771817  2012  2012-01-17     Tuesday   \n",
       "\n",
       "        Did_Police_Officer_Attend_Scene_of_Accident          Junction_Control  \\\n",
       "771813                                            1       Auto traffic signal   \n",
       "771814                                            1  Give way or uncontrolled   \n",
       "771815                                            1  Give way or uncontrolled   \n",
       "771816                                            1  Give way or uncontrolled   \n",
       "771817                                            1  Give way or uncontrolled   \n",
       "\n",
       "                Junction_Detail  ...  \\\n",
       "771813               Crossroads  ...   \n",
       "771814               Crossroads  ...   \n",
       "771815               Crossroads  ...   \n",
       "771816  T or staggered junction  ...   \n",
       "771817  T or staggered junction  ...   \n",
       "\n",
       "                                   Junction_Location        make  \\\n",
       "771813  Mid Junction - on roundabout or on main road  VOLKSWAGEN   \n",
       "771814  Mid Junction - on roundabout or on main road  VOLKSWAGEN   \n",
       "771815  Mid Junction - on roundabout or on main road     PIAGGIO   \n",
       "771816  Mid Junction - on roundabout or on main road    MERCEDES   \n",
       "771817  Mid Junction - on roundabout or on main road  LAND ROVER   \n",
       "\n",
       "                       model Propulsion_Code Sex_of_Driver  \\\n",
       "771813        POLO S 80 AUTO          Petrol        Female   \n",
       "771814           GOLF S AUTO          Petrol        Female   \n",
       "771815               FLY 125          Petrol          Male   \n",
       "771816      SPRINTER 313 CDI       Heavy oil          Male   \n",
       "771817  FREELANDER HSE TD4 A       Heavy oil        Female   \n",
       "\n",
       "        Towing_and_Articulation  Vehicle_Manoeuvre  \\\n",
       "771813      No tow/articulation      Turning right   \n",
       "771814      No tow/articulation  Going ahead other   \n",
       "771815      No tow/articulation  Going ahead other   \n",
       "771816      No tow/articulation         Moving off   \n",
       "771817      No tow/articulation  Going ahead other   \n",
       "\n",
       "                               Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "771813                                  Car                          No   \n",
       "771814                                  Car                          No   \n",
       "771815            Motorcycle 50cc and under                          No   \n",
       "771816  Van / Goods 3.5 tonnes mgw or under                          No   \n",
       "771817                                  Car                          No   \n",
       "\n",
       "       X1st_Point_of_Impact  \n",
       "771813             Nearside  \n",
       "771814                Front  \n",
       "771815                Front  \n",
       "771816       Did not impact  \n",
       "771817                Front  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make data frame for each year from 2010 to 2016\n",
    "df_2012 = newdf1.loc[newdf1[\"Year\"]==2012]\n",
    "df_2012.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "d87f9ccd",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>914355</th>\n",
       "      <td>201301BS70003</td>\n",
       "      <td>A</td>\n",
       "      <td>Serious</td>\n",
       "      <td>None</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-01-02</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Cleared junction or waiting/parked at junction...</td>\n",
       "      <td>LONDON TAXIS INT</td>\n",
       "      <td>TXII SILVER AUTO</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>U-turn</td>\n",
       "      <td>Taxi/Private hire car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914356</th>\n",
       "      <td>201301BS70005</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Auto traffic signal</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Approaching junction or waiting/parked at junc...</td>\n",
       "      <td>PIAGGIO</td>\n",
       "      <td>VESPA LX 125</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Motorcycle 125cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914357</th>\n",
       "      <td>201301BS70007</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1</td>\n",
       "      <td>Auto traffic signal</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>PIAGGIO</td>\n",
       "      <td>VESPA LX 125</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Slowing or stopping</td>\n",
       "      <td>Motorcycle 125cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914358</th>\n",
       "      <td>201301BS70007</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-01-10</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1</td>\n",
       "      <td>Auto traffic signal</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>SAAB</td>\n",
       "      <td>9-3 SE TURBO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>914359</th>\n",
       "      <td>201301BS70009</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2013</td>\n",
       "      <td>2013-01-04</td>\n",
       "      <td>Friday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>BMW</td>\n",
       "      <td>525I SE AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Overtaking static vehicle - offside</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Back</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "914355  201301BS70003              A           Serious                None   \n",
       "914356  201301BS70005              A            Slight                None   \n",
       "914357  201301BS70007              B            Slight                None   \n",
       "914358  201301BS70007              B            Slight                None   \n",
       "914359  201301BS70009              A            Slight                None   \n",
       "\n",
       "        Year        Date Day_of_Week  \\\n",
       "914355  2013  2013-01-02   Wednesday   \n",
       "914356  2013  2013-01-04      Friday   \n",
       "914357  2013  2013-01-10    Thursday   \n",
       "914358  2013  2013-01-10    Thursday   \n",
       "914359  2013  2013-01-04      Friday   \n",
       "\n",
       "        Did_Police_Officer_Attend_Scene_of_Accident          Junction_Control  \\\n",
       "914355                                            1  Give way or uncontrolled   \n",
       "914356                                            1       Auto traffic signal   \n",
       "914357                                            1       Auto traffic signal   \n",
       "914358                                            1       Auto traffic signal   \n",
       "914359                                            1  Give way or uncontrolled   \n",
       "\n",
       "                Junction_Detail  ...  \\\n",
       "914355  T or staggered junction  ...   \n",
       "914356               Crossroads  ...   \n",
       "914357               Crossroads  ...   \n",
       "914358               Crossroads  ...   \n",
       "914359  T or staggered junction  ...   \n",
       "\n",
       "                                        Junction_Location              make  \\\n",
       "914355  Cleared junction or waiting/parked at junction...  LONDON TAXIS INT   \n",
       "914356  Approaching junction or waiting/parked at junc...           PIAGGIO   \n",
       "914357       Mid Junction - on roundabout or on main road           PIAGGIO   \n",
       "914358       Mid Junction - on roundabout or on main road              SAAB   \n",
       "914359       Mid Junction - on roundabout or on main road               BMW   \n",
       "\n",
       "                   model Propulsion_Code Sex_of_Driver  \\\n",
       "914355  TXII SILVER AUTO       Heavy oil          Male   \n",
       "914356      VESPA LX 125          Petrol        Female   \n",
       "914357      VESPA LX 125          Petrol          Male   \n",
       "914358      9-3 SE TURBO          Petrol          Male   \n",
       "914359      525I SE AUTO          Petrol          Male   \n",
       "\n",
       "        Towing_and_Articulation                    Vehicle_Manoeuvre  \\\n",
       "914355      No tow/articulation                               U-turn   \n",
       "914356      No tow/articulation                    Going ahead other   \n",
       "914357      No tow/articulation                  Slowing or stopping   \n",
       "914358      No tow/articulation                    Going ahead other   \n",
       "914359      No tow/articulation  Overtaking static vehicle - offside   \n",
       "\n",
       "                      Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "914355       Taxi/Private hire car                          No   \n",
       "914356  Motorcycle 125cc and under                          No   \n",
       "914357  Motorcycle 125cc and under                          No   \n",
       "914358                         Car                          No   \n",
       "914359                         Car                          No   \n",
       "\n",
       "       X1st_Point_of_Impact  \n",
       "914355                Front  \n",
       "914356                Front  \n",
       "914357             Nearside  \n",
       "914358       Did not impact  \n",
       "914359                 Back  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make data frame for each year from 2010 to 2016\n",
    "df_2013 = newdf1.loc[newdf1[\"Year\"]==2013]\n",
    "df_2013.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "03d415a7",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1056142</th>\n",
       "      <td>201401BS70001</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014-01-09</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>2</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>FORD</td>\n",
       "      <td>GALAXY ZETEC TDCI AUTO</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Taxi/Private hire car</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056143</th>\n",
       "      <td>201401BS70002</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014-01-20</td>\n",
       "      <td>Monday</td>\n",
       "      <td>2</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Slip road</td>\n",
       "      <td>...</td>\n",
       "      <td>Approaching junction or waiting/parked at junc...</td>\n",
       "      <td>BENTLEY</td>\n",
       "      <td>ARNAGE T AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Parked</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Offside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056144</th>\n",
       "      <td>201401BS70003</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014-01-21</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Leaving main road</td>\n",
       "      <td>MINI</td>\n",
       "      <td>FIRST</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Turning right</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Offside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056145</th>\n",
       "      <td>201401BS70003</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014-01-21</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>HONDA</td>\n",
       "      <td>CBR 1000 RR-C</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Overtaking moving vehicle - offside</td>\n",
       "      <td>Motorcycle 125cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1056146</th>\n",
       "      <td>201401BS70004</td>\n",
       "      <td>C</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2014</td>\n",
       "      <td>2014-01-15</td>\n",
       "      <td>Wednesday</td>\n",
       "      <td>2</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Approaching junction or waiting/parked at junc...</td>\n",
       "      <td>NISSAN</td>\n",
       "      <td>ALMERA TINO SE CVT</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Slowing or stopping</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "1056142  201401BS70001              A            Slight                None   \n",
       "1056143  201401BS70002              A            Slight                None   \n",
       "1056144  201401BS70003              A            Slight                None   \n",
       "1056145  201401BS70003              A            Slight                None   \n",
       "1056146  201401BS70004              C            Slight                None   \n",
       "\n",
       "         Year        Date Day_of_Week  \\\n",
       "1056142  2014  2014-01-09    Thursday   \n",
       "1056143  2014  2014-01-20      Monday   \n",
       "1056144  2014  2014-01-21     Tuesday   \n",
       "1056145  2014  2014-01-21     Tuesday   \n",
       "1056146  2014  2014-01-15   Wednesday   \n",
       "\n",
       "         Did_Police_Officer_Attend_Scene_of_Accident  \\\n",
       "1056142                                            2   \n",
       "1056143                                            2   \n",
       "1056144                                            1   \n",
       "1056145                                            1   \n",
       "1056146                                            2   \n",
       "\n",
       "                     Junction_Control                      Junction_Detail  \\\n",
       "1056142  Data missing or out of range  Not at junction or within 20 metres   \n",
       "1056143      Give way or uncontrolled                            Slip road   \n",
       "1056144      Give way or uncontrolled              T or staggered junction   \n",
       "1056145      Give way or uncontrolled              T or staggered junction   \n",
       "1056146      Give way or uncontrolled              T or staggered junction   \n",
       "\n",
       "         ...                                  Junction_Location     make  \\\n",
       "1056142  ...             Not at or within 20 metres of junction     FORD   \n",
       "1056143  ...  Approaching junction or waiting/parked at junc...  BENTLEY   \n",
       "1056144  ...                                  Leaving main road     MINI   \n",
       "1056145  ...       Mid Junction - on roundabout or on main road    HONDA   \n",
       "1056146  ...  Approaching junction or waiting/parked at junc...   NISSAN   \n",
       "\n",
       "                          model Propulsion_Code Sex_of_Driver  \\\n",
       "1056142  GALAXY ZETEC TDCI AUTO       Heavy oil          Male   \n",
       "1056143           ARNAGE T AUTO          Petrol          Male   \n",
       "1056144                   FIRST          Petrol          Male   \n",
       "1056145           CBR 1000 RR-C          Petrol          Male   \n",
       "1056146      ALMERA TINO SE CVT          Petrol          Male   \n",
       "\n",
       "         Towing_and_Articulation                    Vehicle_Manoeuvre  \\\n",
       "1056142      No tow/articulation                    Going ahead other   \n",
       "1056143      No tow/articulation                               Parked   \n",
       "1056144      No tow/articulation                        Turning right   \n",
       "1056145      No tow/articulation  Overtaking moving vehicle - offside   \n",
       "1056146      No tow/articulation                  Slowing or stopping   \n",
       "\n",
       "                       Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "1056142       Taxi/Private hire car                          No   \n",
       "1056143                         Car                          No   \n",
       "1056144                         Car                          No   \n",
       "1056145  Motorcycle 125cc and under                          No   \n",
       "1056146                         Car                          No   \n",
       "\n",
       "        X1st_Point_of_Impact  \n",
       "1056142             Nearside  \n",
       "1056143              Offside  \n",
       "1056144              Offside  \n",
       "1056145                Front  \n",
       "1056146                Front  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make data frame for each year from 2010 to 2016\n",
    "df_2014 = newdf1.loc[newdf1[\"Year\"]==2014]\n",
    "df_2014.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "e5e380df",
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1207324</th>\n",
       "      <td>201501BS70001</td>\n",
       "      <td>C</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-01-12</td>\n",
       "      <td>Monday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>MERCEDES</td>\n",
       "      <td>SPRINTER 310 CDI</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Turning right</td>\n",
       "      <td>Van / Goods 3.5 tonnes mgw or under</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1207325</th>\n",
       "      <td>201501BS70002</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-01-12</td>\n",
       "      <td>Monday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>BMW</td>\n",
       "      <td>118I SE TURBO AUTO</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Turning right</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1207326</th>\n",
       "      <td>201501BS70004</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-01-12</td>\n",
       "      <td>Monday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Mini-roundabout</td>\n",
       "      <td>...</td>\n",
       "      <td>Cleared junction or waiting/parked at junction...</td>\n",
       "      <td>VAUXHALL</td>\n",
       "      <td>ASTRA CLUB CDTI</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Turning right</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1207327</th>\n",
       "      <td>201501BS70009</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-01-15</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>YAMAHA</td>\n",
       "      <td>NXC 125 CYGNUS</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Motorcycle 125cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1207328</th>\n",
       "      <td>201501BS70009</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2015</td>\n",
       "      <td>2015-01-15</td>\n",
       "      <td>Thursday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>FORD</td>\n",
       "      <td>TRANSIT 115 T330S RWD</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>U-turn</td>\n",
       "      <td>Van / Goods 3.5 tonnes mgw or under</td>\n",
       "      <td>No</td>\n",
       "      <td>Offside</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "1207324  201501BS70001              C            Slight                None   \n",
       "1207325  201501BS70002   Unclassified            Slight                None   \n",
       "1207326  201501BS70004              B            Slight                None   \n",
       "1207327  201501BS70009              A            Slight                None   \n",
       "1207328  201501BS70009              A            Slight                None   \n",
       "\n",
       "         Year        Date Day_of_Week  \\\n",
       "1207324  2015  2015-01-12      Monday   \n",
       "1207325  2015  2015-01-12      Monday   \n",
       "1207326  2015  2015-01-12      Monday   \n",
       "1207327  2015  2015-01-15    Thursday   \n",
       "1207328  2015  2015-01-15    Thursday   \n",
       "\n",
       "         Did_Police_Officer_Attend_Scene_of_Accident  \\\n",
       "1207324                                            1   \n",
       "1207325                                            1   \n",
       "1207326                                            1   \n",
       "1207327                                            1   \n",
       "1207328                                            1   \n",
       "\n",
       "                 Junction_Control          Junction_Detail  ...  \\\n",
       "1207324  Give way or uncontrolled  T or staggered junction  ...   \n",
       "1207325  Give way or uncontrolled  T or staggered junction  ...   \n",
       "1207326  Give way or uncontrolled          Mini-roundabout  ...   \n",
       "1207327  Give way or uncontrolled  T or staggered junction  ...   \n",
       "1207328  Give way or uncontrolled  T or staggered junction  ...   \n",
       "\n",
       "                                         Junction_Location      make  \\\n",
       "1207324       Mid Junction - on roundabout or on main road  MERCEDES   \n",
       "1207325       Mid Junction - on roundabout or on main road       BMW   \n",
       "1207326  Cleared junction or waiting/parked at junction...  VAUXHALL   \n",
       "1207327       Mid Junction - on roundabout or on main road    YAMAHA   \n",
       "1207328       Mid Junction - on roundabout or on main road      FORD   \n",
       "\n",
       "                         model Propulsion_Code Sex_of_Driver  \\\n",
       "1207324       SPRINTER 310 CDI       Heavy oil          Male   \n",
       "1207325     118I SE TURBO AUTO          Petrol          Male   \n",
       "1207326        ASTRA CLUB CDTI       Heavy oil          Male   \n",
       "1207327         NXC 125 CYGNUS          Petrol          Male   \n",
       "1207328  TRANSIT 115 T330S RWD       Heavy oil          Male   \n",
       "\n",
       "         Towing_and_Articulation  Vehicle_Manoeuvre  \\\n",
       "1207324      No tow/articulation      Turning right   \n",
       "1207325      No tow/articulation      Turning right   \n",
       "1207326      No tow/articulation      Turning right   \n",
       "1207327      No tow/articulation  Going ahead other   \n",
       "1207328      No tow/articulation             U-turn   \n",
       "\n",
       "                                Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "1207324  Van / Goods 3.5 tonnes mgw or under                          No   \n",
       "1207325                                  Car                          No   \n",
       "1207326                                  Car                          No   \n",
       "1207327           Motorcycle 125cc and under                          No   \n",
       "1207328  Van / Goods 3.5 tonnes mgw or under                          No   \n",
       "\n",
       "        X1st_Point_of_Impact  \n",
       "1207324                Front  \n",
       "1207325                Front  \n",
       "1207326                Front  \n",
       "1207327                Front  \n",
       "1207328              Offside  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make data frame for each year from 2010 to 2016\n",
    "df_2015 = newdf1.loc[newdf1[\"Year\"]==2015]\n",
    "df_2015.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "b4b6ec60",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1372440</th>\n",
       "      <td>2016010000005</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>YAMAHA</td>\n",
       "      <td>HW 125 XENTER</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Motorcycle 50cc and under</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1372441</th>\n",
       "      <td>2016010000006</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Other junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Cleared junction or waiting/parked at junction...</td>\n",
       "      <td>MERCEDES</td>\n",
       "      <td>A180 BLUEEFFICIENCY SPORT CDI</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1372442</th>\n",
       "      <td>2016010000008</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Roundabout</td>\n",
       "      <td>...</td>\n",
       "      <td>Entering roundabout</td>\n",
       "      <td>VOLKSWAGEN</td>\n",
       "      <td>SCIROCCO TSI</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1372443</th>\n",
       "      <td>2016010000016</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Auto traffic signal</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Approaching junction or waiting/parked at junc...</td>\n",
       "      <td>OTHER BRITISH</td>\n",
       "      <td>MISSING</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Bus or coach (17 or more pass seats)</td>\n",
       "      <td>No</td>\n",
       "      <td>Did not impact</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1372444</th>\n",
       "      <td>2016010000018</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2016</td>\n",
       "      <td>2016-11-01</td>\n",
       "      <td>Tuesday</td>\n",
       "      <td>1</td>\n",
       "      <td>Data missing or out of range</td>\n",
       "      <td>Not at junction or within 20 metres</td>\n",
       "      <td>...</td>\n",
       "      <td>Not at or within 20 metres of junction</td>\n",
       "      <td>BMW</td>\n",
       "      <td>116I</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Changing lane to right</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "1372440  2016010000005              A            Slight                None   \n",
       "1372441  2016010000006              A            Slight                None   \n",
       "1372442  2016010000008              A            Slight                None   \n",
       "1372443  2016010000016              A            Slight                None   \n",
       "1372444  2016010000018              A            Slight                None   \n",
       "\n",
       "         Year        Date Day_of_Week  \\\n",
       "1372440  2016  2016-11-01     Tuesday   \n",
       "1372441  2016  2016-11-01     Tuesday   \n",
       "1372442  2016  2016-11-01     Tuesday   \n",
       "1372443  2016  2016-11-01     Tuesday   \n",
       "1372444  2016  2016-11-01     Tuesday   \n",
       "\n",
       "         Did_Police_Officer_Attend_Scene_of_Accident  \\\n",
       "1372440                                            1   \n",
       "1372441                                            1   \n",
       "1372442                                            1   \n",
       "1372443                                            1   \n",
       "1372444                                            1   \n",
       "\n",
       "                     Junction_Control                      Junction_Detail  \\\n",
       "1372440  Data missing or out of range  Not at junction or within 20 metres   \n",
       "1372441      Give way or uncontrolled                       Other junction   \n",
       "1372442      Give way or uncontrolled                           Roundabout   \n",
       "1372443           Auto traffic signal              T or staggered junction   \n",
       "1372444  Data missing or out of range  Not at junction or within 20 metres   \n",
       "\n",
       "         ...                                  Junction_Location  \\\n",
       "1372440  ...             Not at or within 20 metres of junction   \n",
       "1372441  ...  Cleared junction or waiting/parked at junction...   \n",
       "1372442  ...                                Entering roundabout   \n",
       "1372443  ...  Approaching junction or waiting/parked at junc...   \n",
       "1372444  ...             Not at or within 20 metres of junction   \n",
       "\n",
       "                  make                          model Propulsion_Code  \\\n",
       "1372440         YAMAHA                  HW 125 XENTER          Petrol   \n",
       "1372441       MERCEDES  A180 BLUEEFFICIENCY SPORT CDI       Heavy oil   \n",
       "1372442     VOLKSWAGEN                   SCIROCCO TSI          Petrol   \n",
       "1372443  OTHER BRITISH                        MISSING       Heavy oil   \n",
       "1372444            BMW                           116I          Petrol   \n",
       "\n",
       "        Sex_of_Driver  Towing_and_Articulation       Vehicle_Manoeuvre  \\\n",
       "1372440          Male      No tow/articulation       Going ahead other   \n",
       "1372441        Female      No tow/articulation       Going ahead other   \n",
       "1372442          Male      No tow/articulation       Going ahead other   \n",
       "1372443          Male      No tow/articulation       Going ahead other   \n",
       "1372444          Male      No tow/articulation  Changing lane to right   \n",
       "\n",
       "                                 Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "1372440             Motorcycle 50cc and under                          No   \n",
       "1372441                                   Car                          No   \n",
       "1372442                                   Car                          No   \n",
       "1372443  Bus or coach (17 or more pass seats)                          No   \n",
       "1372444                                   Car                          No   \n",
       "\n",
       "        X1st_Point_of_Impact  \n",
       "1372440                Front  \n",
       "1372441             Nearside  \n",
       "1372442                Front  \n",
       "1372443       Did not impact  \n",
       "1372444                Front  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make data frame for each year from 2010 to 2016\n",
    "df_2016 = newdf1.loc[newdf1[\"Year\"]==2016]\n",
    "df_2016.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "102497e8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Accident_Index</th>\n",
       "      <th>1st_Road_Class</th>\n",
       "      <th>Accident_Severity</th>\n",
       "      <th>Carriageway_Hazards</th>\n",
       "      <th>Year</th>\n",
       "      <th>Date</th>\n",
       "      <th>Day_of_Week</th>\n",
       "      <th>Did_Police_Officer_Attend_Scene_of_Accident</th>\n",
       "      <th>Junction_Control</th>\n",
       "      <th>Junction_Detail</th>\n",
       "      <th>...</th>\n",
       "      <th>Junction_Location</th>\n",
       "      <th>make</th>\n",
       "      <th>model</th>\n",
       "      <th>Propulsion_Code</th>\n",
       "      <th>Sex_of_Driver</th>\n",
       "      <th>Towing_and_Articulation</th>\n",
       "      <th>Vehicle_Manoeuvre</th>\n",
       "      <th>Vehicle_Type</th>\n",
       "      <th>Was_Vehicle_Left_Hand_Drive</th>\n",
       "      <th>X1st_Point_of_Impact</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>478587</th>\n",
       "      <td>201001BS70003</td>\n",
       "      <td>B</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2010</td>\n",
       "      <td>2010-01-11</td>\n",
       "      <td>Monday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>CITROEN</td>\n",
       "      <td>BERLINGO FIRST 600</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Turning right</td>\n",
       "      <td>Van / Goods 3.5 tonnes mgw or under</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478588</th>\n",
       "      <td>201001BS70004</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2010</td>\n",
       "      <td>2010-01-11</td>\n",
       "      <td>Monday</td>\n",
       "      <td>1</td>\n",
       "      <td>Auto traffic signal</td>\n",
       "      <td>T or staggered junction</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>RENAULT</td>\n",
       "      <td>SCENIC DYN DCI 130</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478589</th>\n",
       "      <td>201001BS70007</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2010</td>\n",
       "      <td>2010-01-02</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Mini-roundabout</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>NISSAN</td>\n",
       "      <td>PRIMERA SVE CVT</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead right-hand bend</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478590</th>\n",
       "      <td>201001BS70007</td>\n",
       "      <td>Unclassified</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2010</td>\n",
       "      <td>2010-01-02</td>\n",
       "      <td>Saturday</td>\n",
       "      <td>1</td>\n",
       "      <td>Give way or uncontrolled</td>\n",
       "      <td>Mini-roundabout</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>MERCEDES</td>\n",
       "      <td>A140 ELEGANCE</td>\n",
       "      <td>Petrol</td>\n",
       "      <td>Female</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Going ahead other</td>\n",
       "      <td>Car</td>\n",
       "      <td>No</td>\n",
       "      <td>Front</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>478591</th>\n",
       "      <td>201001BS70008</td>\n",
       "      <td>A</td>\n",
       "      <td>Slight</td>\n",
       "      <td>None</td>\n",
       "      <td>2010</td>\n",
       "      <td>2010-01-04</td>\n",
       "      <td>Monday</td>\n",
       "      <td>1</td>\n",
       "      <td>Auto traffic signal</td>\n",
       "      <td>Crossroads</td>\n",
       "      <td>...</td>\n",
       "      <td>Mid Junction - on roundabout or on main road</td>\n",
       "      <td>VAUXHALL</td>\n",
       "      <td>ZAFIRA ELEGANCE DTI</td>\n",
       "      <td>Heavy oil</td>\n",
       "      <td>Male</td>\n",
       "      <td>No tow/articulation</td>\n",
       "      <td>Turning right</td>\n",
       "      <td>Taxi/Private hire car</td>\n",
       "      <td>No</td>\n",
       "      <td>Nearside</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 42 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Accident_Index 1st_Road_Class Accident_Severity Carriageway_Hazards  \\\n",
       "478587  201001BS70003              B            Slight                None   \n",
       "478588  201001BS70004              A            Slight                None   \n",
       "478589  201001BS70007   Unclassified            Slight                None   \n",
       "478590  201001BS70007   Unclassified            Slight                None   \n",
       "478591  201001BS70008              A            Slight                None   \n",
       "\n",
       "        Year        Date Day_of_Week  \\\n",
       "478587  2010  2010-01-11      Monday   \n",
       "478588  2010  2010-01-11      Monday   \n",
       "478589  2010  2010-01-02    Saturday   \n",
       "478590  2010  2010-01-02    Saturday   \n",
       "478591  2010  2010-01-04      Monday   \n",
       "\n",
       "        Did_Police_Officer_Attend_Scene_of_Accident          Junction_Control  \\\n",
       "478587                                            1  Give way or uncontrolled   \n",
       "478588                                            1       Auto traffic signal   \n",
       "478589                                            1  Give way or uncontrolled   \n",
       "478590                                            1  Give way or uncontrolled   \n",
       "478591                                            1       Auto traffic signal   \n",
       "\n",
       "                Junction_Detail  ...  \\\n",
       "478587  T or staggered junction  ...   \n",
       "478588  T or staggered junction  ...   \n",
       "478589          Mini-roundabout  ...   \n",
       "478590          Mini-roundabout  ...   \n",
       "478591               Crossroads  ...   \n",
       "\n",
       "                                   Junction_Location      make  \\\n",
       "478587  Mid Junction - on roundabout or on main road   CITROEN   \n",
       "478588  Mid Junction - on roundabout or on main road   RENAULT   \n",
       "478589  Mid Junction - on roundabout or on main road    NISSAN   \n",
       "478590  Mid Junction - on roundabout or on main road  MERCEDES   \n",
       "478591  Mid Junction - on roundabout or on main road  VAUXHALL   \n",
       "\n",
       "                      model Propulsion_Code Sex_of_Driver  \\\n",
       "478587   BERLINGO FIRST 600          Petrol        Female   \n",
       "478588   SCENIC DYN DCI 130       Heavy oil          Male   \n",
       "478589      PRIMERA SVE CVT          Petrol        Female   \n",
       "478590        A140 ELEGANCE          Petrol        Female   \n",
       "478591  ZAFIRA ELEGANCE DTI       Heavy oil          Male   \n",
       "\n",
       "        Towing_and_Articulation            Vehicle_Manoeuvre  \\\n",
       "478587      No tow/articulation                Turning right   \n",
       "478588      No tow/articulation            Going ahead other   \n",
       "478589      No tow/articulation  Going ahead right-hand bend   \n",
       "478590      No tow/articulation            Going ahead other   \n",
       "478591      No tow/articulation                Turning right   \n",
       "\n",
       "                               Vehicle_Type Was_Vehicle_Left_Hand_Drive  \\\n",
       "478587  Van / Goods 3.5 tonnes mgw or under                          No   \n",
       "478588                                  Car                          No   \n",
       "478589                                  Car                          No   \n",
       "478590                                  Car                          No   \n",
       "478591                Taxi/Private hire car                          No   \n",
       "\n",
       "       X1st_Point_of_Impact  \n",
       "478587                Front  \n",
       "478588                Front  \n",
       "478589             Nearside  \n",
       "478590                Front  \n",
       "478591             Nearside  \n",
       "\n",
       "[5 rows x 42 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# make data frame for each year from 2010 to 2016\n",
    "df_all = newdf1.loc[newdf1[\"Year\"]>=2010]\n",
    "df_all.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "d5e16b64",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "2016    183800\n",
       "2015    165116\n",
       "2014    151182\n",
       "2011    147392\n",
       "2010    145834\n",
       "2012    142542\n",
       "2013    141787\n",
       "Name: Year, dtype: int64"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_all['Year'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "982a804f",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}