merging_flo.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "# importing\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# read in data csv/frames\n",
    "\n",
    "circuits_df = pd.read_csv(\"data/circuits.csv\")\n",
    "constructor_results_df = pd.read_csv(\"data/constructor_results.csv\")\n",
    "constructors_df = pd.read_csv(\"data/constructors.csv\")\n",
    "driver_standings_df = pd.read_csv(\"data/driver_standings.csv\")\n",
    "drivers_df = pd.read_csv(\"data/drivers.csv\")\n",
    "lap_times_df = pd.read_csv(\"data/lap_times.csv\")\n",
    "pit_stops_df = pd.read_csv(\"data/pit_stops.csv\")\n",
    "qualifying_df = pd.read_csv(\"data/qualifying.csv\")\n",
    "races_df = pd.read_csv(\"data/races.csv\")\n",
    "results_df = pd.read_csv(\"data/results.csv\")\n",
    "seasons_df = pd.read_csv(\"data/seasons.csv\")\n",
    "sprint_res_df = pd.read_csv(\"data/sprint_results.csv\")\n",
    "status_df = pd.read_csv(\"data/status.csv\")\n",
    "tyre_data_df = pd.read_csv(\"data/tyre_data.csv\")\n",
    "races_with_weather_df = pd.read_csv(\"data/races_with_weather.csv\")\n",
    "races_with_dummies_df = pd.read_csv(\"data/races_with_dummies.csv\")\n",
    "tyre_data_new_df = pd.read_csv(\"data/tyre_data_new.csv\")"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Merging the different data frames to get one data frame for the machine learning model.\n",
    "\n",
    "- make a list to find the most interesting/important ones\n",
    "- merge\n",
    "\n",
    "- only extract data from 2012-2022 -> we got tyre data for this time frame\n",
    "- Drop unnecessary columns, duplicates and one of the dummies if created (weather data)\n",
    "4. "
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "List of dfs needed:\n",
    "\n",
    "1. tyre_data_new_df x\n",
    "2. circuits_df x\n",
    "3. drivers_df x\n",
    "4. lap_times_df\n",
    "5. pit_stops_df x\n",
    "6. races_with_dummies (included weather data in dummie variables) x\n",
    "7. results_df x\n",
    "\n",
    "Optional:\n",
    "\n",
    "1. constructor_results_df\n",
    "2. constructors_df\n",
    "3. status_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "# merging \n",
    "\n",
    "part_1 = pd.merge(tyre_data_new_df, races_with_dummies_df, on=\"raceId\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "part_2 = pd.merge(part_1, circuits_df, on=\"circuitId\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Unnamed: 0.1</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Driver</th>\n",
       "      <th>GP</th>\n",
       "      <th>Tyres</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>#Laps</th>\n",
       "      <th>year_x</th>\n",
       "      <th>location_x</th>\n",
       "      <th>raceId</th>\n",
       "      <th>year_y</th>\n",
       "      <th>round</th>\n",
       "      <th>circuitId</th>\n",
       "      <th>name_x</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>url_x</th>\n",
       "      <th>fp1_date</th>\n",
       "      <th>fp1_time</th>\n",
       "      <th>fp2_date</th>\n",
       "      <th>fp2_time</th>\n",
       "      <th>fp3_date</th>\n",
       "      <th>fp3_time</th>\n",
       "      <th>quali_date</th>\n",
       "      <th>quali_time</th>\n",
       "      <th>sprint_date</th>\n",
       "      <th>sprint_time</th>\n",
       "      <th>weather_category</th>\n",
       "      <th>weather_cloudy</th>\n",
       "      <th>weather_cold</th>\n",
       "      <th>weather_dry</th>\n",
       "      <th>weather_unknown</th>\n",
       "      <th>weather_warm</th>\n",
       "      <th>weather_wet</th>\n",
       "      <th>circuitRef</th>\n",
       "      <th>name_y</th>\n",
       "      <th>location_y</th>\n",
       "      <th>country</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>alt</th>\n",
       "      <th>url_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>17</td>\n",
       "      <td>36</td>\n",
       "      <td>20</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>37</td>\n",
       "      <td>58</td>\n",
       "      <td>22</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>Sebastian Vettel</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>Sebastian Vettel</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>17</td>\n",
       "      <td>37</td>\n",
       "      <td>21</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0.1  Unnamed: 0            Driver         GP       Tyres  From   \n",
       "0             0           0     Jenson Button  Australia   Soft Used     1  \\\n",
       "1             1           1     Jenson Button  Australia  Medium New    17   \n",
       "2             2           2     Jenson Button  Australia  Medium New    37   \n",
       "3             3           3  Sebastian Vettel  Australia   Soft Used     1   \n",
       "4             4           4  Sebastian Vettel  Australia   Soft Used    17   \n",
       "\n",
       "   To  #Laps  year_x location_x  raceId  year_y  round  circuitId   \n",
       "0  16     16    2012   Adelaide     860    2012      1          1  \\\n",
       "1  36     20    2012   Adelaide     860    2012      1          1   \n",
       "2  58     22    2012   Adelaide     860    2012      1          1   \n",
       "3  16     16    2012   Adelaide     860    2012      1          1   \n",
       "4  37     21    2012   Adelaide     860    2012      1          1   \n",
       "\n",
       "                  name_x        date      time   \n",
       "0  Australian Grand Prix  2012-03-18  06:00:00  \\\n",
       "1  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "2  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "3  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "4  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "\n",
       "                                               url_x fp1_date fp1_time   \n",
       "0  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N  \\\n",
       "1  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "2  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "3  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "4  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "\n",
       "  fp2_date fp2_time fp3_date fp3_time quali_date quali_time sprint_date   \n",
       "0       \\N       \\N       \\N       \\N         \\N         \\N          \\N  \\\n",
       "1       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "2       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "3       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "4       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "\n",
       "  sprint_time weather_category  weather_cloudy  weather_cold  weather_dry   \n",
       "0          \\N     weather_warm           False         False        False  \\\n",
       "1          \\N     weather_warm           False         False        False   \n",
       "2          \\N     weather_warm           False         False        False   \n",
       "3          \\N     weather_warm           False         False        False   \n",
       "4          \\N     weather_warm           False         False        False   \n",
       "\n",
       "   weather_unknown  weather_warm  weather_wet   circuitRef   \n",
       "0            False          True        False  albert_park  \\\n",
       "1            False          True        False  albert_park   \n",
       "2            False          True        False  albert_park   \n",
       "3            False          True        False  albert_park   \n",
       "4            False          True        False  albert_park   \n",
       "\n",
       "                           name_y location_y    country      lat      lng alt   \n",
       "0  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10  \\\n",
       "1  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "2  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "3  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "4  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "\n",
       "                                               url_y  \n",
       "0  http://en.wikipedia.org/wiki/Melbourne_Grand_P...  \n",
       "1  http://en.wikipedia.org/wiki/Melbourne_Grand_P...  \n",
       "2  http://en.wikipedia.org/wiki/Melbourne_Grand_P...  \n",
       "3  http://en.wikipedia.org/wiki/Melbourne_Grand_P...  \n",
       "4  http://en.wikipedia.org/wiki/Melbourne_Grand_P...  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "part_2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "part_3 = pd.merge(part_2, results_df, on=\"raceId\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>Unnamed: 0.1</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Driver</th>\n",
       "      <th>GP</th>\n",
       "      <th>Tyres</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>#Laps</th>\n",
       "      <th>year_x</th>\n",
       "      <th>location_x</th>\n",
       "      <th>raceId</th>\n",
       "      <th>year_y</th>\n",
       "      <th>round</th>\n",
       "      <th>circuitId</th>\n",
       "      <th>name_x</th>\n",
       "      <th>date</th>\n",
       "      <th>time_x</th>\n",
       "      <th>url_x</th>\n",
       "      <th>fp1_date</th>\n",
       "      <th>fp1_time</th>\n",
       "      <th>fp2_date</th>\n",
       "      <th>fp2_time</th>\n",
       "      <th>fp3_date</th>\n",
       "      <th>fp3_time</th>\n",
       "      <th>quali_date</th>\n",
       "      <th>quali_time</th>\n",
       "      <th>sprint_date</th>\n",
       "      <th>sprint_time</th>\n",
       "      <th>weather_category</th>\n",
       "      <th>weather_cloudy</th>\n",
       "      <th>weather_cold</th>\n",
       "      <th>weather_dry</th>\n",
       "      <th>weather_unknown</th>\n",
       "      <th>weather_warm</th>\n",
       "      <th>weather_wet</th>\n",
       "      <th>circuitRef</th>\n",
       "      <th>name_y</th>\n",
       "      <th>location_y</th>\n",
       "      <th>country</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>alt</th>\n",
       "      <th>url_y</th>\n",
       "      <th>resultId</th>\n",
       "      <th>driverId</th>\n",
       "      <th>constructorId</th>\n",
       "      <th>number</th>\n",
       "      <th>grid</th>\n",
       "      <th>position</th>\n",
       "      <th>positionText</th>\n",
       "      <th>positionOrder</th>\n",
       "      <th>points</th>\n",
       "      <th>laps</th>\n",
       "      <th>time_y</th>\n",
       "      <th>milliseconds</th>\n",
       "      <th>fastestLap</th>\n",
       "      <th>rank</th>\n",
       "      <th>fastestLapTime</th>\n",
       "      <th>fastestLapSpeed</th>\n",
       "      <th>statusId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21232</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>58</td>\n",
       "      <td>1:34:09.565</td>\n",
       "      <td>5649565</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>1:29.187</td>\n",
       "      <td>214.053</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21233</td>\n",
       "      <td>20</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>18.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+2.139</td>\n",
       "      <td>5651704</td>\n",
       "      <td>57</td>\n",
       "      <td>2</td>\n",
       "      <td>1:29.417</td>\n",
       "      <td>213.503</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21234</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>15.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+4.075</td>\n",
       "      <td>5653640</td>\n",
       "      <td>57</td>\n",
       "      <td>4</td>\n",
       "      <td>1:29.538</td>\n",
       "      <td>213.214</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21235</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>12.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+4.547</td>\n",
       "      <td>5654112</td>\n",
       "      <td>57</td>\n",
       "      <td>3</td>\n",
       "      <td>1:29.438</td>\n",
       "      <td>213.452</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21236</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+21.565</td>\n",
       "      <td>5671130</td>\n",
       "      <td>52</td>\n",
       "      <td>7</td>\n",
       "      <td>1:30.277</td>\n",
       "      <td>211.469</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0.1  Unnamed: 0         Driver         GP      Tyres  From  To   \n",
       "0             0           0  Jenson Button  Australia  Soft Used     1  16  \\\n",
       "1             0           0  Jenson Button  Australia  Soft Used     1  16   \n",
       "2             0           0  Jenson Button  Australia  Soft Used     1  16   \n",
       "3             0           0  Jenson Button  Australia  Soft Used     1  16   \n",
       "4             0           0  Jenson Button  Australia  Soft Used     1  16   \n",
       "\n",
       "   #Laps  year_x location_x  raceId  year_y  round  circuitId   \n",
       "0     16    2012   Adelaide     860    2012      1          1  \\\n",
       "1     16    2012   Adelaide     860    2012      1          1   \n",
       "2     16    2012   Adelaide     860    2012      1          1   \n",
       "3     16    2012   Adelaide     860    2012      1          1   \n",
       "4     16    2012   Adelaide     860    2012      1          1   \n",
       "\n",
       "                  name_x        date    time_x   \n",
       "0  Australian Grand Prix  2012-03-18  06:00:00  \\\n",
       "1  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "2  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "3  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "4  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "\n",
       "                                               url_x fp1_date fp1_time   \n",
       "0  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N  \\\n",
       "1  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "2  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "3  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "4  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "\n",
       "  fp2_date fp2_time fp3_date fp3_time quali_date quali_time sprint_date   \n",
       "0       \\N       \\N       \\N       \\N         \\N         \\N          \\N  \\\n",
       "1       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "2       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "3       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "4       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "\n",
       "  sprint_time weather_category  weather_cloudy  weather_cold  weather_dry   \n",
       "0          \\N     weather_warm           False         False        False  \\\n",
       "1          \\N     weather_warm           False         False        False   \n",
       "2          \\N     weather_warm           False         False        False   \n",
       "3          \\N     weather_warm           False         False        False   \n",
       "4          \\N     weather_warm           False         False        False   \n",
       "\n",
       "   weather_unknown  weather_warm  weather_wet   circuitRef   \n",
       "0            False          True        False  albert_park  \\\n",
       "1            False          True        False  albert_park   \n",
       "2            False          True        False  albert_park   \n",
       "3            False          True        False  albert_park   \n",
       "4            False          True        False  albert_park   \n",
       "\n",
       "                           name_y location_y    country      lat      lng alt   \n",
       "0  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10  \\\n",
       "1  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "2  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "3  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "4  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "\n",
       "                                               url_y  resultId  driverId   \n",
       "0  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21232        18  \\\n",
       "1  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21233        20   \n",
       "2  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21234         1   \n",
       "3  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21235        17   \n",
       "4  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21236         4   \n",
       "\n",
       "   constructorId number  grid position positionText  positionOrder  points   \n",
       "0              1      3     2        1            1              1    25.0  \\\n",
       "1              9      1     6        2            2              2    18.0   \n",
       "2              1      4     1        3            3              3    15.0   \n",
       "3              9      2     5        4            4              4    12.0   \n",
       "4              6      5    12        5            5              5    10.0   \n",
       "\n",
       "   laps       time_y milliseconds fastestLap rank fastestLapTime   \n",
       "0    58  1:34:09.565      5649565         56    1       1:29.187  \\\n",
       "1    58       +2.139      5651704         57    2       1:29.417   \n",
       "2    58       +4.075      5653640         57    4       1:29.538   \n",
       "3    58       +4.547      5654112         57    3       1:29.438   \n",
       "4    58      +21.565      5671130         52    7       1:30.277   \n",
       "\n",
       "  fastestLapSpeed  statusId  \n",
       "0         214.053         1  \n",
       "1         213.503         1  \n",
       "2         213.214         1  \n",
       "3         213.452         1  \n",
       "4         211.469         1  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "part_3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "part_4 = pd.merge(part_3, drivers_df, on=\"driverId\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "part_5 = pd.merge(part_4, pit_stops_df, on=\"raceId\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "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>Unnamed: 0.1</th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>Driver</th>\n",
       "      <th>GP</th>\n",
       "      <th>Tyres</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>#Laps</th>\n",
       "      <th>year_x</th>\n",
       "      <th>location_x</th>\n",
       "      <th>raceId</th>\n",
       "      <th>year_y</th>\n",
       "      <th>round</th>\n",
       "      <th>circuitId</th>\n",
       "      <th>name_x</th>\n",
       "      <th>date</th>\n",
       "      <th>time_x</th>\n",
       "      <th>url_x</th>\n",
       "      <th>fp1_date</th>\n",
       "      <th>fp1_time</th>\n",
       "      <th>fp2_date</th>\n",
       "      <th>fp2_time</th>\n",
       "      <th>fp3_date</th>\n",
       "      <th>fp3_time</th>\n",
       "      <th>quali_date</th>\n",
       "      <th>quali_time</th>\n",
       "      <th>sprint_date</th>\n",
       "      <th>sprint_time</th>\n",
       "      <th>weather_category</th>\n",
       "      <th>weather_cloudy</th>\n",
       "      <th>weather_cold</th>\n",
       "      <th>weather_dry</th>\n",
       "      <th>weather_unknown</th>\n",
       "      <th>weather_warm</th>\n",
       "      <th>weather_wet</th>\n",
       "      <th>circuitRef</th>\n",
       "      <th>name_y</th>\n",
       "      <th>location_y</th>\n",
       "      <th>country</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>alt</th>\n",
       "      <th>url_y</th>\n",
       "      <th>resultId</th>\n",
       "      <th>driverId_x</th>\n",
       "      <th>constructorId</th>\n",
       "      <th>number_x</th>\n",
       "      <th>grid</th>\n",
       "      <th>position</th>\n",
       "      <th>positionText</th>\n",
       "      <th>positionOrder</th>\n",
       "      <th>points</th>\n",
       "      <th>laps</th>\n",
       "      <th>time_y</th>\n",
       "      <th>milliseconds_x</th>\n",
       "      <th>fastestLap</th>\n",
       "      <th>rank</th>\n",
       "      <th>fastestLapTime</th>\n",
       "      <th>fastestLapSpeed</th>\n",
       "      <th>statusId</th>\n",
       "      <th>driverRef</th>\n",
       "      <th>number_y</th>\n",
       "      <th>code</th>\n",
       "      <th>forename</th>\n",
       "      <th>surname</th>\n",
       "      <th>dob</th>\n",
       "      <th>nationality</th>\n",
       "      <th>url</th>\n",
       "      <th>driverId_y</th>\n",
       "      <th>stop</th>\n",
       "      <th>lap</th>\n",
       "      <th>time</th>\n",
       "      <th>duration</th>\n",
       "      <th>milliseconds_y</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21232</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>58</td>\n",
       "      <td>1:34:09.565</td>\n",
       "      <td>5649565</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>1:29.187</td>\n",
       "      <td>214.053</td>\n",
       "      <td>1</td>\n",
       "      <td>button</td>\n",
       "      <td>22</td>\n",
       "      <td>BUT</td>\n",
       "      <td>Jenson</td>\n",
       "      <td>Button</td>\n",
       "      <td>1980-01-19</td>\n",
       "      <td>British</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Jenson_Button</td>\n",
       "      <td>811</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17:05:23</td>\n",
       "      <td>24.599</td>\n",
       "      <td>24599</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21232</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>58</td>\n",
       "      <td>1:34:09.565</td>\n",
       "      <td>5649565</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>1:29.187</td>\n",
       "      <td>214.053</td>\n",
       "      <td>1</td>\n",
       "      <td>button</td>\n",
       "      <td>22</td>\n",
       "      <td>BUT</td>\n",
       "      <td>Jenson</td>\n",
       "      <td>Button</td>\n",
       "      <td>1980-01-19</td>\n",
       "      <td>British</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Jenson_Button</td>\n",
       "      <td>817</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17:05:35</td>\n",
       "      <td>32.319</td>\n",
       "      <td>32319</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21232</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>58</td>\n",
       "      <td>1:34:09.565</td>\n",
       "      <td>5649565</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>1:29.187</td>\n",
       "      <td>214.053</td>\n",
       "      <td>1</td>\n",
       "      <td>button</td>\n",
       "      <td>22</td>\n",
       "      <td>BUT</td>\n",
       "      <td>Jenson</td>\n",
       "      <td>Button</td>\n",
       "      <td>1980-01-19</td>\n",
       "      <td>British</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Jenson_Button</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>17:21:08</td>\n",
       "      <td>22.313</td>\n",
       "      <td>22313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21232</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>58</td>\n",
       "      <td>1:34:09.565</td>\n",
       "      <td>5649565</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>1:29.187</td>\n",
       "      <td>214.053</td>\n",
       "      <td>1</td>\n",
       "      <td>button</td>\n",
       "      <td>22</td>\n",
       "      <td>BUT</td>\n",
       "      <td>Jenson</td>\n",
       "      <td>Button</td>\n",
       "      <td>1980-01-19</td>\n",
       "      <td>British</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Jenson_Button</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>17:22:31</td>\n",
       "      <td>23.203</td>\n",
       "      <td>23203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Jenson Button</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>2012</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>2012-03-18</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>weather_warm</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "      <td>albert_park</td>\n",
       "      <td>Albert Park Grand Prix Circuit</td>\n",
       "      <td>Melbourne</td>\n",
       "      <td>Australia</td>\n",
       "      <td>-37.8497</td>\n",
       "      <td>144.968</td>\n",
       "      <td>10</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "      <td>21232</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25.0</td>\n",
       "      <td>58</td>\n",
       "      <td>1:34:09.565</td>\n",
       "      <td>5649565</td>\n",
       "      <td>56</td>\n",
       "      <td>1</td>\n",
       "      <td>1:29.187</td>\n",
       "      <td>214.053</td>\n",
       "      <td>1</td>\n",
       "      <td>button</td>\n",
       "      <td>22</td>\n",
       "      <td>BUT</td>\n",
       "      <td>Jenson</td>\n",
       "      <td>Button</td>\n",
       "      <td>1980-01-19</td>\n",
       "      <td>British</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Jenson_Button</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>17:24:04</td>\n",
       "      <td>22.035</td>\n",
       "      <td>22035</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Unnamed: 0.1  Unnamed: 0         Driver         GP      Tyres  From  To   \n",
       "0             0           0  Jenson Button  Australia  Soft Used     1  16  \\\n",
       "1             0           0  Jenson Button  Australia  Soft Used     1  16   \n",
       "2             0           0  Jenson Button  Australia  Soft Used     1  16   \n",
       "3             0           0  Jenson Button  Australia  Soft Used     1  16   \n",
       "4             0           0  Jenson Button  Australia  Soft Used     1  16   \n",
       "\n",
       "   #Laps  year_x location_x  raceId  year_y  round  circuitId   \n",
       "0     16    2012   Adelaide     860    2012      1          1  \\\n",
       "1     16    2012   Adelaide     860    2012      1          1   \n",
       "2     16    2012   Adelaide     860    2012      1          1   \n",
       "3     16    2012   Adelaide     860    2012      1          1   \n",
       "4     16    2012   Adelaide     860    2012      1          1   \n",
       "\n",
       "                  name_x        date    time_x   \n",
       "0  Australian Grand Prix  2012-03-18  06:00:00  \\\n",
       "1  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "2  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "3  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "4  Australian Grand Prix  2012-03-18  06:00:00   \n",
       "\n",
       "                                               url_x fp1_date fp1_time   \n",
       "0  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N  \\\n",
       "1  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "2  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "3  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "4  http://en.wikipedia.org/wiki/2012_Australian_G...       \\N       \\N   \n",
       "\n",
       "  fp2_date fp2_time fp3_date fp3_time quali_date quali_time sprint_date   \n",
       "0       \\N       \\N       \\N       \\N         \\N         \\N          \\N  \\\n",
       "1       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "2       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "3       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "4       \\N       \\N       \\N       \\N         \\N         \\N          \\N   \n",
       "\n",
       "  sprint_time weather_category  weather_cloudy  weather_cold  weather_dry   \n",
       "0          \\N     weather_warm           False         False        False  \\\n",
       "1          \\N     weather_warm           False         False        False   \n",
       "2          \\N     weather_warm           False         False        False   \n",
       "3          \\N     weather_warm           False         False        False   \n",
       "4          \\N     weather_warm           False         False        False   \n",
       "\n",
       "   weather_unknown  weather_warm  weather_wet   circuitRef   \n",
       "0            False          True        False  albert_park  \\\n",
       "1            False          True        False  albert_park   \n",
       "2            False          True        False  albert_park   \n",
       "3            False          True        False  albert_park   \n",
       "4            False          True        False  albert_park   \n",
       "\n",
       "                           name_y location_y    country      lat      lng alt   \n",
       "0  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10  \\\n",
       "1  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "2  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "3  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "4  Albert Park Grand Prix Circuit  Melbourne  Australia -37.8497  144.968  10   \n",
       "\n",
       "                                               url_y  resultId  driverId_x   \n",
       "0  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21232          18  \\\n",
       "1  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21232          18   \n",
       "2  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21232          18   \n",
       "3  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21232          18   \n",
       "4  http://en.wikipedia.org/wiki/Melbourne_Grand_P...     21232          18   \n",
       "\n",
       "   constructorId number_x  grid position positionText  positionOrder  points   \n",
       "0              1        3     2        1            1              1    25.0  \\\n",
       "1              1        3     2        1            1              1    25.0   \n",
       "2              1        3     2        1            1              1    25.0   \n",
       "3              1        3     2        1            1              1    25.0   \n",
       "4              1        3     2        1            1              1    25.0   \n",
       "\n",
       "   laps       time_y milliseconds_x fastestLap rank fastestLapTime   \n",
       "0    58  1:34:09.565        5649565         56    1       1:29.187  \\\n",
       "1    58  1:34:09.565        5649565         56    1       1:29.187   \n",
       "2    58  1:34:09.565        5649565         56    1       1:29.187   \n",
       "3    58  1:34:09.565        5649565         56    1       1:29.187   \n",
       "4    58  1:34:09.565        5649565         56    1       1:29.187   \n",
       "\n",
       "  fastestLapSpeed  statusId driverRef number_y code forename surname   \n",
       "0         214.053         1    button       22  BUT   Jenson  Button  \\\n",
       "1         214.053         1    button       22  BUT   Jenson  Button   \n",
       "2         214.053         1    button       22  BUT   Jenson  Button   \n",
       "3         214.053         1    button       22  BUT   Jenson  Button   \n",
       "4         214.053         1    button       22  BUT   Jenson  Button   \n",
       "\n",
       "          dob nationality                                         url   \n",
       "0  1980-01-19     British  http://en.wikipedia.org/wiki/Jenson_Button  \\\n",
       "1  1980-01-19     British  http://en.wikipedia.org/wiki/Jenson_Button   \n",
       "2  1980-01-19     British  http://en.wikipedia.org/wiki/Jenson_Button   \n",
       "3  1980-01-19     British  http://en.wikipedia.org/wiki/Jenson_Button   \n",
       "4  1980-01-19     British  http://en.wikipedia.org/wiki/Jenson_Button   \n",
       "\n",
       "   driverId_y  stop  lap      time duration  milliseconds_y  \n",
       "0         811     1    1  17:05:23   24.599           24599  \n",
       "1         817     1    1  17:05:35   32.319           32319  \n",
       "2          13     1   11  17:21:08   22.313           22313  \n",
       "3           3     1   12  17:22:31   23.203           23203  \n",
       "4           4     1   13  17:24:04   22.035           22035  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.set_option('display.max_columns', None)\n",
    "part_5.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Unnamed: 0.1', 'Unnamed: 0', 'Driver', 'GP', 'Tyres', 'From', 'To',\n",
       "       '#Laps', 'year_x', 'location_x', 'raceId', 'year_y', 'round',\n",
       "       'circuitId', 'name_x', 'date', 'time_x', 'url_x', 'fp1_date',\n",
       "       'fp1_time', 'fp2_date', 'fp2_time', 'fp3_date', 'fp3_time',\n",
       "       'quali_date', 'quali_time', 'sprint_date', 'sprint_time',\n",
       "       'weather_category', 'weather_cloudy', 'weather_cold', 'weather_dry',\n",
       "       'weather_unknown', 'weather_warm', 'weather_wet', 'circuitRef',\n",
       "       'name_y', 'location_y', 'country', 'lat', 'lng', 'alt', 'url_y',\n",
       "       'resultId', 'driverId_x', 'constructorId', 'number_x', 'grid',\n",
       "       'position', 'positionText', 'positionOrder', 'points', 'laps', 'time_y',\n",
       "       'milliseconds_x', 'fastestLap', 'rank', 'fastestLapTime',\n",
       "       'fastestLapSpeed', 'statusId', 'driverRef', 'number_y', 'code',\n",
       "       'forename', 'surname', 'dob', 'nationality', 'url', 'driverId_y',\n",
       "       'stop', 'lap', 'time', 'duration', 'milliseconds_y'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "part_5.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Drop duplicates and unnecessary columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [],
   "source": [
    "columns_to_drop = ['Unnamed: 0.1','Unnamed: 0','fp1_date',\n",
    "       'fp1_time', 'fp2_date', 'fp2_time', 'fp3_date', 'fp3_time',\n",
    "       'quali_date', 'quali_time', 'sprint_date', 'sprint_time', \"name_y\",\"url_x\", \"url_y\",\"year_y\",\"location_x\",\"driverId_y\",\"Driver\",\"code\",\"forename\",\"url\",\"nationality\",\"number_y\",\"positionText\",\"GP\",\"location_y\",\"country\",\"lat\",\"lng\",\"alt\",\"circuitRef\",\"driverRef\",\"dob\",\"weather_category\",\"weather_unknown\" ]\n",
    "\n",
    "part_5_tiny_df = part_5.drop(columns=columns_to_drop)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "\n",
    "time_x -> starting time\n",
    "time_y -> race duration"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 11107982 entries, 0 to 11107981\n",
      "Data columns (total 38 columns):\n",
      " #   Column           Dtype  \n",
      "---  ------           -----  \n",
      " 0   Tyres            object \n",
      " 1   From             int64  \n",
      " 2   To               int64  \n",
      " 3   #Laps            int64  \n",
      " 4   year_x           int64  \n",
      " 5   raceId           int64  \n",
      " 6   round            int64  \n",
      " 7   circuitId        int64  \n",
      " 8   name_x           object \n",
      " 9   date             object \n",
      " 10  time_x           object \n",
      " 11  weather_cloudy   bool   \n",
      " 12  weather_cold     bool   \n",
      " 13  weather_dry      bool   \n",
      " 14  weather_warm     bool   \n",
      " 15  weather_wet      bool   \n",
      " 16  resultId         int64  \n",
      " 17  driverId_x       int64  \n",
      " 18  constructorId    int64  \n",
      " 19  number_x         object \n",
      " 20  grid             int64  \n",
      " 21  position         object \n",
      " 22  positionOrder    int64  \n",
      " 23  points           float64\n",
      " 24  laps             int64  \n",
      " 25  time_y           object \n",
      " 26  milliseconds_x   object \n",
      " 27  fastestLap       object \n",
      " 28  rank             object \n",
      " 29  fastestLapTime   object \n",
      " 30  fastestLapSpeed  object \n",
      " 31  statusId         int64  \n",
      " 32  surname          object \n",
      " 33  stop             int64  \n",
      " 34  lap              int64  \n",
      " 35  time             object \n",
      " 36  duration         object \n",
      " 37  milliseconds_y   int64  \n",
      "dtypes: bool(5), float64(1), int64(17), object(15)\n",
      "memory usage: 2.8+ GB\n"
     ]
    }
   ],
   "source": [
    "part_5_tiny_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['Tyres', 'From', 'To', '#Laps', 'year_x', 'raceId', 'round',\n",
       "       'circuitId', 'name_x', 'date', 'time_x', 'weather_cloudy',\n",
       "       'weather_cold', 'weather_dry', 'weather_warm', 'weather_wet',\n",
       "       'resultId', 'driverId_x', 'constructorId', 'number_x', 'grid',\n",
       "       'position', 'positionOrder', 'points', 'laps', 'time_y',\n",
       "       'milliseconds_x', 'fastestLap', 'rank', 'fastestLapTime',\n",
       "       'fastestLapSpeed', 'statusId', 'surname', 'stop', 'lap', 'time',\n",
       "       'duration', 'milliseconds_y'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "part_5_tiny_df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Soft Used', 'Medium New', 'Soft New', 'Medium Used',\n",
       "       'Supersoft Used', 'Supersoft New', 'Ultrasoft Used',\n",
       "       'Ultrasoft New', 'Intermediate New', 'Wet New', 'Hard New',\n",
       "       'Intermediate Used', 'Lluvia Extrema Usado', 'Hard Used',\n",
       "       'Hiper Blando Usado', 'Hiper Blando Nuevo'], dtype=object)"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "part_5_tiny_df.Tyres.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method Series.unique of 0           2012\n",
       "1           2012\n",
       "2           2012\n",
       "3           2012\n",
       "4           2012\n",
       "            ... \n",
       "11107977    2022\n",
       "11107978    2022\n",
       "11107979    2022\n",
       "11107980    2022\n",
       "11107981    2022\n",
       "Name: year_x, Length: 11107982, dtype: int64>"
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\n",
    "part_5_tiny_df[\"year_x\"].unique"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 11107982 entries, 0 to 11107981\n",
      "Data columns (total 39 columns):\n",
      " #   Column           Dtype  \n",
      "---  ------           -----  \n",
      " 0   Driver           object \n",
      " 1   Tyres            object \n",
      " 2   From             int64  \n",
      " 3   To               int64  \n",
      " 4   #Laps            int64  \n",
      " 5   year_x           int64  \n",
      " 6   raceId           int64  \n",
      " 7   round            int64  \n",
      " 8   circuitId        int64  \n",
      " 9   name_x           object \n",
      " 10  date             object \n",
      " 11  time_x           object \n",
      " 12  weather_cloudy   bool   \n",
      " 13  weather_cold     bool   \n",
      " 14  weather_dry      bool   \n",
      " 15  weather_warm     bool   \n",
      " 16  weather_wet      bool   \n",
      " 17  resultId         int64  \n",
      " 18  driverId_x       int64  \n",
      " 19  constructorId    int64  \n",
      " 20  number_x         object \n",
      " 21  grid             int64  \n",
      " 22  position         object \n",
      " 23  positionOrder    int64  \n",
      " 24  points           float64\n",
      " 25  laps             int64  \n",
      " 26  time_y           object \n",
      " 27  milliseconds_x   object \n",
      " 28  fastestLap       object \n",
      " 29  rank             object \n",
      " 30  fastestLapTime   object \n",
      " 31  fastestLapSpeed  object \n",
      " 32  statusId         int64  \n",
      " 33  surname          object \n",
      " 34  stop             int64  \n",
      " 35  lap              int64  \n",
      " 36  time             object \n",
      " 37  duration         object \n",
      " 38  milliseconds_y   int64  \n",
      "dtypes: bool(5), float64(1), int64(17), object(16)\n",
      "memory usage: 2.9+ GB\n"
     ]
    }
   ],
   "source": [
    "part_5_tiny_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "\"['url'] not found in axis\"",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0m                                  Traceback (most recent call last)",
      "Cell \u001b[0;32mIn[24], line 1\u001b[0m\n\u001b[0;32m----> 1\u001b[0m constructors_df \u001b[39m=\u001b[39m constructors_df\u001b[39m.\u001b[39;49mdrop(\u001b[39m'\u001b[39;49m\u001b[39murl\u001b[39;49m\u001b[39m'\u001b[39;49m, axis\u001b[39m=\u001b[39;49m\u001b[39m1\u001b[39;49m)\n",
      "File \u001b[0;32m~/neuefische/Formula-1-Project/.venv/lib/python3.9/site-packages/pandas/core/frame.py:5268\u001b[0m, in \u001b[0;36mDataFrame.drop\u001b[0;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[1;32m   5120\u001b[0m \u001b[39mdef\u001b[39;00m \u001b[39mdrop\u001b[39m(\n\u001b[1;32m   5121\u001b[0m     \u001b[39mself\u001b[39m,\n\u001b[1;32m   5122\u001b[0m     labels: IndexLabel \u001b[39m=\u001b[39m \u001b[39mNone\u001b[39;00m,\n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   5129\u001b[0m     errors: IgnoreRaise \u001b[39m=\u001b[39m \u001b[39m\"\u001b[39m\u001b[39mraise\u001b[39m\u001b[39m\"\u001b[39m,\n\u001b[1;32m   5130\u001b[0m ) \u001b[39m-\u001b[39m\u001b[39m>\u001b[39m DataFrame \u001b[39m|\u001b[39m \u001b[39mNone\u001b[39;00m:\n\u001b[1;32m   5131\u001b[0m \u001b[39m    \u001b[39m\u001b[39m\"\"\"\u001b[39;00m\n\u001b[1;32m   5132\u001b[0m \u001b[39m    Drop specified labels from rows or columns.\u001b[39;00m\n\u001b[1;32m   5133\u001b[0m \n\u001b[0;32m   (...)\u001b[0m\n\u001b[1;32m   5266\u001b[0m \u001b[39m            weight  1.0     0.8\u001b[39;00m\n\u001b[1;32m   5267\u001b[0m \u001b[39m    \"\"\"\u001b[39;00m\n\u001b[0;32m-> 5268\u001b[0m     \u001b[39mreturn\u001b[39;00m \u001b[39msuper\u001b[39;49m()\u001b[39m.\u001b[39;49mdrop(\n\u001b[1;32m   5269\u001b[0m         labels\u001b[39m=\u001b[39;49mlabels,\n\u001b[1;32m   5270\u001b[0m         axis\u001b[39m=\u001b[39;49maxis,\n\u001b[1;32m   5271\u001b[0m         index\u001b[39m=\u001b[39;49mindex,\n\u001b[1;32m   5272\u001b[0m         columns\u001b[39m=\u001b[39;49mcolumns,\n\u001b[1;32m   5273\u001b[0m         level\u001b[39m=\u001b[39;49mlevel,\n\u001b[1;32m   5274\u001b[0m         inplace\u001b[39m=\u001b[39;49minplace,\n\u001b[1;32m   5275\u001b[0m         errors\u001b[39m=\u001b[39;49merrors,\n\u001b[1;32m   5276\u001b[0m     )\n",
      "File \u001b[0;32m~/neuefische/Formula-1-Project/.venv/lib/python3.9/site-packages/pandas/core/generic.py:4549\u001b[0m, in \u001b[0;36mNDFrame.drop\u001b[0;34m(self, labels, axis, index, columns, level, inplace, errors)\u001b[0m\n\u001b[1;32m   4547\u001b[0m \u001b[39mfor\u001b[39;00m axis, labels \u001b[39min\u001b[39;00m axes\u001b[39m.\u001b[39mitems():\n\u001b[1;32m   4548\u001b[0m     \u001b[39mif\u001b[39;00m labels \u001b[39mis\u001b[39;00m \u001b[39mnot\u001b[39;00m \u001b[39mNone\u001b[39;00m:\n\u001b[0;32m-> 4549\u001b[0m         obj \u001b[39m=\u001b[39m obj\u001b[39m.\u001b[39;49m_drop_axis(labels, axis, level\u001b[39m=\u001b[39;49mlevel, errors\u001b[39m=\u001b[39;49merrors)\n\u001b[1;32m   4551\u001b[0m \u001b[39mif\u001b[39;00m inplace:\n\u001b[1;32m   4552\u001b[0m     \u001b[39mself\u001b[39m\u001b[39m.\u001b[39m_update_inplace(obj)\n",
      "File \u001b[0;32m~/neuefische/Formula-1-Project/.venv/lib/python3.9/site-packages/pandas/core/generic.py:4591\u001b[0m, in \u001b[0;36mNDFrame._drop_axis\u001b[0;34m(self, labels, axis, level, errors, only_slice)\u001b[0m\n\u001b[1;32m   4589\u001b[0m         new_axis \u001b[39m=\u001b[39m axis\u001b[39m.\u001b[39mdrop(labels, level\u001b[39m=\u001b[39mlevel, errors\u001b[39m=\u001b[39merrors)\n\u001b[1;32m   4590\u001b[0m     \u001b[39melse\u001b[39;00m:\n\u001b[0;32m-> 4591\u001b[0m         new_axis \u001b[39m=\u001b[39m axis\u001b[39m.\u001b[39;49mdrop(labels, errors\u001b[39m=\u001b[39;49merrors)\n\u001b[1;32m   4592\u001b[0m     indexer \u001b[39m=\u001b[39m axis\u001b[39m.\u001b[39mget_indexer(new_axis)\n\u001b[1;32m   4594\u001b[0m \u001b[39m# Case for non-unique axis\u001b[39;00m\n\u001b[1;32m   4595\u001b[0m \u001b[39melse\u001b[39;00m:\n",
      "File \u001b[0;32m~/neuefische/Formula-1-Project/.venv/lib/python3.9/site-packages/pandas/core/indexes/base.py:6696\u001b[0m, in \u001b[0;36mIndex.drop\u001b[0;34m(self, labels, errors)\u001b[0m\n\u001b[1;32m   6694\u001b[0m \u001b[39mif\u001b[39;00m mask\u001b[39m.\u001b[39many():\n\u001b[1;32m   6695\u001b[0m     \u001b[39mif\u001b[39;00m errors \u001b[39m!=\u001b[39m \u001b[39m\"\u001b[39m\u001b[39mignore\u001b[39m\u001b[39m\"\u001b[39m:\n\u001b[0;32m-> 6696\u001b[0m         \u001b[39mraise\u001b[39;00m \u001b[39mKeyError\u001b[39;00m(\u001b[39mf\u001b[39m\u001b[39m\"\u001b[39m\u001b[39m{\u001b[39;00m\u001b[39mlist\u001b[39m(labels[mask])\u001b[39m}\u001b[39;00m\u001b[39m not found in axis\u001b[39m\u001b[39m\"\u001b[39m)\n\u001b[1;32m   6697\u001b[0m     indexer \u001b[39m=\u001b[39m indexer[\u001b[39m~\u001b[39mmask]\n\u001b[1;32m   6698\u001b[0m \u001b[39mreturn\u001b[39;00m \u001b[39mself\u001b[39m\u001b[39m.\u001b[39mdelete(indexer)\n",
      "\u001b[0;31mKeyError\u001b[0m: \"['url'] not found in axis\""
     ]
    }
   ],
   "source": [
    "constructors_df = constructors_df.drop('url', axis=1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "part_6 = pd.merge(part_5_tiny_df, constructors_df, on=\"constructorId\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "complete_ml_df = part_6"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Tyres              0\n",
       "From               0\n",
       "To                 0\n",
       "#Laps              0\n",
       "year_x             0\n",
       "raceId             0\n",
       "round              0\n",
       "circuitId          0\n",
       "name_x             0\n",
       "date               0\n",
       "time_x             0\n",
       "weather_cloudy     0\n",
       "weather_cold       0\n",
       "weather_dry        0\n",
       "weather_warm       0\n",
       "weather_wet        0\n",
       "resultId           0\n",
       "driverId_x         0\n",
       "constructorId      0\n",
       "number_x           0\n",
       "grid               0\n",
       "position           0\n",
       "positionOrder      0\n",
       "points             0\n",
       "laps               0\n",
       "time_y             0\n",
       "milliseconds_x     0\n",
       "fastestLap         0\n",
       "rank               0\n",
       "fastestLapTime     0\n",
       "fastestLapSpeed    0\n",
       "statusId           0\n",
       "surname            0\n",
       "stop               0\n",
       "lap                0\n",
       "time               0\n",
       "duration           0\n",
       "milliseconds_y     0\n",
       "constructorRef     0\n",
       "name               0\n",
       "nationality        0\n",
       "dtype: int64"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "complete_ml_df.isna().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<class 'pandas.core.frame.DataFrame'>\n",
      "RangeIndex: 11107982 entries, 0 to 11107981\n",
      "Data columns (total 42 columns):\n",
      " #   Column           Dtype  \n",
      "---  ------           -----  \n",
      " 0   Driver           object \n",
      " 1   Tyres            object \n",
      " 2   From             int64  \n",
      " 3   To               int64  \n",
      " 4   #Laps            int64  \n",
      " 5   year_x           int64  \n",
      " 6   raceId           int64  \n",
      " 7   round            int64  \n",
      " 8   circuitId        int64  \n",
      " 9   name_x           object \n",
      " 10  date             object \n",
      " 11  time_x           object \n",
      " 12  weather_cloudy   bool   \n",
      " 13  weather_cold     bool   \n",
      " 14  weather_dry      bool   \n",
      " 15  weather_warm     bool   \n",
      " 16  weather_wet      bool   \n",
      " 17  resultId         int64  \n",
      " 18  driverId_x       int64  \n",
      " 19  constructorId    int64  \n",
      " 20  number_x         object \n",
      " 21  grid             int64  \n",
      " 22  position         object \n",
      " 23  positionOrder    int64  \n",
      " 24  points           float64\n",
      " 25  laps             int64  \n",
      " 26  time_y           object \n",
      " 27  milliseconds_x   object \n",
      " 28  fastestLap       object \n",
      " 29  rank             object \n",
      " 30  fastestLapTime   object \n",
      " 31  fastestLapSpeed  object \n",
      " 32  statusId         int64  \n",
      " 33  surname          object \n",
      " 34  stop             int64  \n",
      " 35  lap              int64  \n",
      " 36  time             object \n",
      " 37  duration         object \n",
      " 38  milliseconds_y   int64  \n",
      " 39  constructorRef   object \n",
      " 40  name             object \n",
      " 41  nationality      object \n",
      "dtypes: bool(5), float64(1), int64(17), object(19)\n",
      "memory usage: 3.1+ GB\n"
     ]
    }
   ],
   "source": [
    "complete_ml_df.info()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": ".venv",
   "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.11.3"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}