weather_pit.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "# importing required libraries \n",
    "\n",
    "import pandas as pd\n",
    "import seaborn as sns\n",
    "import matplotlib.pyplot as plt \n",
    "import numpy as np\n",
    "from sklearn.model_selection import train_test_split\n",
    "import warnings\n",
    "import plotly.express as px\n",
    "import plotly.graph_objects as go\n",
    "\n",
    "warnings.simplefilter(\"ignore\")\n",
    "\n",
    "pd.set_option('display.max_columns', None)\n",
    "pd.set_option('display.max_rows', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "circuits_df = pd.read_csv(\"data/circuits.csv\")\n",
    "constructor_results_df = pd.read_csv(\"data/constructor_results.csv\")\n",
    "constructor_standings_df = pd.read_csv(\"data/constructor_standings.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",
    "complete_f1_df = pd.read_csv(\"data/complete_f1.csv\")\n",
    "tyre_data_new_df = pd.read_csv(\"data/tyre_data_new.csv\")\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [],
   "source": [
    "part_1 = pd.merge(tyre_data_new_df, races_with_dummies_df, on=\"raceId\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "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</th>\n",
       "      <th>raceId</th>\n",
       "      <th>year_y</th>\n",
       "      <th>round</th>\n",
       "      <th>circuitId</th>\n",
       "      <th>name</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>url</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",
       "    </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",
       "    </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",
       "    </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",
       "    </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",
       "    </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",
       "    </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  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        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 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  \n",
       "0            False          True        False  \n",
       "1            False          True        False  \n",
       "2            False          True        False  \n",
       "3            False          True        False  \n",
       "4            False          True        False  "
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "part_1.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [],
   "source": [
    "part_2 = pd.merge(part_1, circuits_df, on=\"circuitId\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "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": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "part_2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "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>GP</th>\n",
       "      <th>Tyres</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>#Laps</th>\n",
       "      <th>location_x</th>\n",
       "      <th>raceId</th>\n",
       "      <th>circuitId</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>17</td>\n",
       "      <td>36</td>\n",
       "      <td>20</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>37</td>\n",
       "      <td>58</td>\n",
       "      <td>22</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>17</td>\n",
       "      <td>37</td>\n",
       "      <td>21</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>38</td>\n",
       "      <td>58</td>\n",
       "      <td>21</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>18</td>\n",
       "      <td>36</td>\n",
       "      <td>19</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>37</td>\n",
       "      <td>58</td>\n",
       "      <td>22</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>15</td>\n",
       "      <td>37</td>\n",
       "      <td>23</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>38</td>\n",
       "      <td>58</td>\n",
       "      <td>21</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>14</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>34</td>\n",
       "      <td>58</td>\n",
       "      <td>25</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>14</td>\n",
       "      <td>36</td>\n",
       "      <td>23</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>37</td>\n",
       "      <td>58</td>\n",
       "      <td>22</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>20</td>\n",
       "      <td>37</td>\n",
       "      <td>18</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>38</td>\n",
       "      <td>58</td>\n",
       "      <td>21</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium Used</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>25</td>\n",
       "      <td>58</td>\n",
       "      <td>34</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>2</td>\n",
       "      <td>22</td>\n",
       "      <td>21</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>23</td>\n",
       "      <td>38</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>39</td>\n",
       "      <td>58</td>\n",
       "      <td>20</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>14</td>\n",
       "      <td>33</td>\n",
       "      <td>20</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>34</td>\n",
       "      <td>58</td>\n",
       "      <td>25</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           GP        Tyres  From  To  #Laps location_x  raceId  circuitId\n",
       "0   Australia    Soft Used     1  16     16   Adelaide     860          1\n",
       "1   Australia   Medium New    17  36     20   Adelaide     860          1\n",
       "2   Australia   Medium New    37  58     22   Adelaide     860          1\n",
       "3   Australia    Soft Used     1  16     16   Adelaide     860          1\n",
       "4   Australia    Soft Used    17  37     21   Adelaide     860          1\n",
       "5   Australia   Medium New    38  58     21   Adelaide     860          1\n",
       "6   Australia    Soft Used     1  17     17   Adelaide     860          1\n",
       "7   Australia   Medium New    18  36     19   Adelaide     860          1\n",
       "8   Australia   Medium New    37  58     22   Adelaide     860          1\n",
       "9   Australia    Soft Used     1  14     14   Adelaide     860          1\n",
       "10  Australia   Medium New    15  37     23   Adelaide     860          1\n",
       "11  Australia   Medium New    38  58     21   Adelaide     860          1\n",
       "12  Australia   Medium New    14  33     20   Adelaide     860          1\n",
       "13  Australia   Medium New    34  58     25   Adelaide     860          1\n",
       "14  Australia    Soft Used     1  13     13   Adelaide     860          1\n",
       "15  Australia     Soft New    14  36     23   Adelaide     860          1\n",
       "16  Australia   Medium New    37  58     22   Adelaide     860          1\n",
       "17  Australia    Soft Used     1  13     13   Adelaide     860          1\n",
       "18  Australia     Soft New     1  19     19   Adelaide     860          1\n",
       "19  Australia     Soft New    20  37     18   Adelaide     860          1\n",
       "20  Australia   Medium New    38  58     21   Adelaide     860          1\n",
       "21  Australia  Medium Used     1  24     24   Adelaide     860          1\n",
       "22  Australia     Soft New    25  58     34   Adelaide     860          1\n",
       "23  Australia    Soft Used     1   1      1   Adelaide     860          1\n",
       "24  Australia   Medium New     2  22     21   Adelaide     860          1\n",
       "25  Australia     Soft New    23  38     16   Adelaide     860          1\n",
       "26  Australia    Soft Used    39  58     20   Adelaide     860          1\n",
       "27  Australia    Soft Used     1  13     13   Adelaide     860          1\n",
       "28  Australia     Soft New    14  33     20   Adelaide     860          1\n",
       "29  Australia   Medium New    34  58     25   Adelaide     860          1"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "columns_to_keep_circuits = ['GP', 'Tyres', 'From',\t'To', '#Laps', 'location_x', 'raceId', 'circuitId']\n",
    "\n",
    "new_circuit_df = part_2[columns_to_keep_circuits].copy()\n",
    "\n",
    "new_circuit_df.head(30)\n",
    "\n",
    "\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>GP</th>\n",
       "      <th>Tyres</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>#Laps</th>\n",
       "      <th>location_x</th>\n",
       "      <th>raceId</th>\n",
       "      <th>circuitId</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</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>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</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>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</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>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</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>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</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>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</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",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21237</td>\n",
       "      <td>155</td>\n",
       "      <td>15</td>\n",
       "      <td>14</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>8.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+36.766</td>\n",
       "      <td>5686331</td>\n",
       "      <td>55</td>\n",
       "      <td>10</td>\n",
       "      <td>1:30.620</td>\n",
       "      <td>210.668</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21238</td>\n",
       "      <td>8</td>\n",
       "      <td>208</td>\n",
       "      <td>9</td>\n",
       "      <td>17</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>6.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+38.014</td>\n",
       "      <td>5687579</td>\n",
       "      <td>50</td>\n",
       "      <td>11</td>\n",
       "      <td>1:30.759</td>\n",
       "      <td>210.346</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21239</td>\n",
       "      <td>815</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>22</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>4.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+39.458</td>\n",
       "      <td>5689023</td>\n",
       "      <td>46</td>\n",
       "      <td>12</td>\n",
       "      <td>1:30.843</td>\n",
       "      <td>210.151</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21240</td>\n",
       "      <td>817</td>\n",
       "      <td>5</td>\n",
       "      <td>16</td>\n",
       "      <td>10</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+39.556</td>\n",
       "      <td>5689121</td>\n",
       "      <td>53</td>\n",
       "      <td>8</td>\n",
       "      <td>1:30.592</td>\n",
       "      <td>210.733</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21241</td>\n",
       "      <td>814</td>\n",
       "      <td>10</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>1.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+39.737</td>\n",
       "      <td>5689302</td>\n",
       "      <td>57</td>\n",
       "      <td>9</td>\n",
       "      <td>1:30.605</td>\n",
       "      <td>210.703</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21242</td>\n",
       "      <td>818</td>\n",
       "      <td>5</td>\n",
       "      <td>17</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+39.848</td>\n",
       "      <td>5689413</td>\n",
       "      <td>52</td>\n",
       "      <td>6</td>\n",
       "      <td>1:30.274</td>\n",
       "      <td>211.476</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21243</td>\n",
       "      <td>3</td>\n",
       "      <td>131</td>\n",
       "      <td>8</td>\n",
       "      <td>7</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0.0</td>\n",
       "      <td>58</td>\n",
       "      <td>+57.642</td>\n",
       "      <td>5707207</td>\n",
       "      <td>53</td>\n",
       "      <td>14</td>\n",
       "      <td>1:30.931</td>\n",
       "      <td>209.948</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21244</td>\n",
       "      <td>813</td>\n",
       "      <td>3</td>\n",
       "      <td>18</td>\n",
       "      <td>8</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>53</td>\n",
       "      <td>5</td>\n",
       "      <td>1:30.254</td>\n",
       "      <td>211.523</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21245</td>\n",
       "      <td>10</td>\n",
       "      <td>206</td>\n",
       "      <td>24</td>\n",
       "      <td>20</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>0.0</td>\n",
       "      <td>57</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>43</td>\n",
       "      <td>19</td>\n",
       "      <td>1:34.253</td>\n",
       "      <td>202.548</td>\n",
       "      <td>11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21246</td>\n",
       "      <td>819</td>\n",
       "      <td>206</td>\n",
       "      <td>25</td>\n",
       "      <td>21</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0.0</td>\n",
       "      <td>53</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>45</td>\n",
       "      <td>20</td>\n",
       "      <td>1:35.011</td>\n",
       "      <td>200.932</td>\n",
       "      <td>15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21247</td>\n",
       "      <td>811</td>\n",
       "      <td>3</td>\n",
       "      <td>19</td>\n",
       "      <td>14</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0.0</td>\n",
       "      <td>52</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>49</td>\n",
       "      <td>13</td>\n",
       "      <td>1:30.855</td>\n",
       "      <td>210.123</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21248</td>\n",
       "      <td>13</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>16</td>\n",
       "      <td>\\N</td>\n",
       "      <td>R</td>\n",
       "      <td>17</td>\n",
       "      <td>0.0</td>\n",
       "      <td>46</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>46</td>\n",
       "      <td>15</td>\n",
       "      <td>1:31.940</td>\n",
       "      <td>207.644</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21249</td>\n",
       "      <td>5</td>\n",
       "      <td>207</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>\\N</td>\n",
       "      <td>R</td>\n",
       "      <td>18</td>\n",
       "      <td>0.0</td>\n",
       "      <td>38</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>26</td>\n",
       "      <td>17</td>\n",
       "      <td>1:33.693</td>\n",
       "      <td>203.759</td>\n",
       "      <td>22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21250</td>\n",
       "      <td>808</td>\n",
       "      <td>207</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>\\N</td>\n",
       "      <td>R</td>\n",
       "      <td>19</td>\n",
       "      <td>0.0</td>\n",
       "      <td>34</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>27</td>\n",
       "      <td>16</td>\n",
       "      <td>1:33.214</td>\n",
       "      <td>204.806</td>\n",
       "      <td>38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Australia</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>Adelaide</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>21251</td>\n",
       "      <td>30</td>\n",
       "      <td>131</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>\\N</td>\n",
       "      <td>R</td>\n",
       "      <td>20</td>\n",
       "      <td>0.0</td>\n",
       "      <td>10</td>\n",
       "      <td>\\N</td>\n",
       "      <td>\\N</td>\n",
       "      <td>4</td>\n",
       "      <td>18</td>\n",
       "      <td>1:34.021</td>\n",
       "      <td>203.048</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           GP      Tyres  From  To  #Laps location_x  raceId  circuitId   \n",
       "0   Australia  Soft Used     1  16     16   Adelaide     860          1  \\\n",
       "1   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "2   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "3   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "4   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "5   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "6   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "7   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "8   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "9   Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "10  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "11  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "12  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "13  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "14  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "15  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "16  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "17  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "18  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "19  Australia  Soft Used     1  16     16   Adelaide     860          1   \n",
       "\n",
       "    resultId  driverId  constructorId number  grid position positionText   \n",
       "0      21232        18              1      3     2        1            1  \\\n",
       "1      21233        20              9      1     6        2            2   \n",
       "2      21234         1              1      4     1        3            3   \n",
       "3      21235        17              9      2     5        4            4   \n",
       "4      21236         4              6      5    12        5            5   \n",
       "5      21237       155             15     14    13        6            6   \n",
       "6      21238         8            208      9    17        7            7   \n",
       "7      21239       815             15     15    22        8            8   \n",
       "8      21240       817              5     16    10        9            9   \n",
       "9      21241       814             10     11    15       10           10   \n",
       "10     21242       818              5     17    11       11           11   \n",
       "11     21243         3            131      8     7       12           12   \n",
       "12     21244       813              3     18     8       13           13   \n",
       "13     21245        10            206     24    20       14           14   \n",
       "14     21246       819            206     25    21       15           15   \n",
       "15     21247       811              3     19    14       16           16   \n",
       "16     21248        13              6      6    16       \\N            R   \n",
       "17     21249         5            207     20    18       \\N            R   \n",
       "18     21250       808            207     21    19       \\N            R   \n",
       "19     21251        30            131      7     4       \\N            R   \n",
       "\n",
       "    positionOrder  points  laps         time milliseconds fastestLap rank   \n",
       "0               1    25.0    58  1:34:09.565      5649565         56    1  \\\n",
       "1               2    18.0    58       +2.139      5651704         57    2   \n",
       "2               3    15.0    58       +4.075      5653640         57    4   \n",
       "3               4    12.0    58       +4.547      5654112         57    3   \n",
       "4               5    10.0    58      +21.565      5671130         52    7   \n",
       "5               6     8.0    58      +36.766      5686331         55   10   \n",
       "6               7     6.0    58      +38.014      5687579         50   11   \n",
       "7               8     4.0    58      +39.458      5689023         46   12   \n",
       "8               9     2.0    58      +39.556      5689121         53    8   \n",
       "9              10     1.0    58      +39.737      5689302         57    9   \n",
       "10             11     0.0    58      +39.848      5689413         52    6   \n",
       "11             12     0.0    58      +57.642      5707207         53   14   \n",
       "12             13     0.0    57           \\N           \\N         53    5   \n",
       "13             14     0.0    57           \\N           \\N         43   19   \n",
       "14             15     0.0    53           \\N           \\N         45   20   \n",
       "15             16     0.0    52           \\N           \\N         49   13   \n",
       "16             17     0.0    46           \\N           \\N         46   15   \n",
       "17             18     0.0    38           \\N           \\N         26   17   \n",
       "18             19     0.0    34           \\N           \\N         27   16   \n",
       "19             20     0.0    10           \\N           \\N          4   18   \n",
       "\n",
       "   fastestLapTime fastestLapSpeed  statusId  \n",
       "0        1:29.187         214.053         1  \n",
       "1        1:29.417         213.503         1  \n",
       "2        1:29.538         213.214         1  \n",
       "3        1:29.438         213.452         1  \n",
       "4        1:30.277         211.469         1  \n",
       "5        1:30.620         210.668         1  \n",
       "6        1:30.759         210.346         1  \n",
       "7        1:30.843         210.151         1  \n",
       "8        1:30.592         210.733         1  \n",
       "9        1:30.605         210.703         1  \n",
       "10       1:30.274         211.476         1  \n",
       "11       1:30.931         209.948         1  \n",
       "12       1:30.254         211.523         3  \n",
       "13       1:34.253         202.548        11  \n",
       "14       1:35.011         200.932        15  \n",
       "15       1:30.855         210.123         4  \n",
       "16       1:31.940         207.644         4  \n",
       "17       1:33.693         203.759        22  \n",
       "18       1:33.214         204.806        38  \n",
       "19       1:34.021         203.048         6  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "merged_df = pd.merge(new_circuit_df, results_df, on='raceId', how='inner')\n",
    "\n",
    "\n",
    "merged_df.head(20)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 43,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Tyres            Driver             GP  From  To  #Laps  Hard New  Hard Used   \n",
      "0                     0        Austria     1  14     14         0          0  \\\n",
      "1                     0        Austria    15  41     27  Hard New          0   \n",
      "2                     0        Austria    42  71     30  Hard New          0   \n",
      "3       Alexander Albon      Australia     1   6      6         0          0   \n",
      "4       Alexander Albon        Austria     1  14     14         0          0   \n",
      "5       Alexander Albon        Austria    15  41     27  Hard New          0   \n",
      "6       Alexander Albon        Austria    42  71     30  Hard New          0   \n",
      "7       Alexander Albon     Azerbaijan     1   7      7         0          0   \n",
      "8       Alexander Albon     Azerbaijan     8  51     44  Hard New          0   \n",
      "9       Alexander Albon        Bahrain     1  11     11         0          0   \n",
      "10      Alexander Albon        Bahrain    12  26     15         0          0   \n",
      "11      Alexander Albon        Bahrain    27  40     14  Hard New          0   \n",
      "12      Alexander Albon        Bahrain    41  57     17         0          0   \n",
      "13      Alexander Albon        Belgium     1   7      7         0          0   \n",
      "14      Alexander Albon        Belgium     8  23     16         0          0   \n",
      "15      Alexander Albon        Belgium    24  33     10         0          0   \n",
      "16      Alexander Albon        Belgium    34  44     11         0          0   \n",
      "17      Alexander Albon         Canada     1  12     12         0          0   \n",
      "18      Alexander Albon         Canada    13  70     58  Hard New          0   \n",
      "19      Alexander Albon  Great Britain     1  32     32         0          0   \n",
      "20      Alexander Albon  Great Britain    33  52     20         0          0   \n",
      "21      Alexander Albon        Hungary     1   8      8         0          0   \n",
      "22      Alexander Albon        Hungary     9  31     23         0  Hard Used   \n",
      "23      Alexander Albon        Hungary    32  69     38  Hard New          0   \n",
      "24      Alexander Albon          Miami     1  22     22         0          0   \n",
      "25      Alexander Albon          Miami    23  57     35  Hard New          0   \n",
      "26      Alexander Albon         Monaco     1  18     18         0          0   \n",
      "27      Alexander Albon         Monaco    19  52     34  Hard New          0   \n",
      "28      Alexander Albon         Monaco    53  77     25         0          0   \n",
      "29      Alexander Albon   Saudi Arabia     1  17     17         0          0   \n",
      "30      Alexander Albon   Saudi Arabia    18  27     10  Hard New          0   \n",
      "31      Alexander Albon          Spain     1  16     16         0          0   \n",
      "32      Alexander Albon          Spain    17  37     21  Hard New          0   \n",
      "33      Alexander Albon          Spain    38  65     28         0          0   \n",
      "34         Carlos Sainz      Australia     1   7      7         0          0   \n",
      "35         Carlos Sainz      Australia     8  55     48  Hard New          0   \n",
      "36         Carlos Sainz      Australia    56  57      2         0          0   \n",
      "37         Carlos Sainz      Australia    58  58      1         0          0   \n",
      "38         Carlos Sainz        Austria     1  15     15         0          0   \n",
      "39         Carlos Sainz        Austria    16  45     30         0          0   \n",
      "40         Carlos Sainz        Austria    46  71     26  Hard New          0   \n",
      "41         Carlos Sainz     Azerbaijan     1  11     11         0          0   \n",
      "42         Carlos Sainz     Azerbaijan    12  51     40  Hard New          0   \n",
      "43         Carlos Sainz        Bahrain     1  13     13         0          0   \n",
      "44         Carlos Sainz        Bahrain    14  31     18  Hard New          0   \n",
      "45         Carlos Sainz        Bahrain    32  57     26  Hard New          0   \n",
      "46         Carlos Sainz        Belgium     1   7      7         0          0   \n",
      "47         Carlos Sainz        Belgium     8  23     16         0          0   \n",
      "48         Carlos Sainz         Canada     1  38     38         0          0   \n",
      "49         Carlos Sainz         Canada    39  70     32  Hard New          0   \n",
      "50         Carlos Sainz  Great Britain     1  26     26         0          0   \n",
      "51         Carlos Sainz  Great Britain    27  52     26  Hard New          0   \n",
      "52         Carlos Sainz        Hungary     1  15     15         0          0   \n",
      "53         Carlos Sainz        Hungary    16  44     29  Hard New          0   \n",
      "54         Carlos Sainz        Hungary    45  70     26         0  Hard Used   \n",
      "55         Carlos Sainz          Miami     1  18     18         0          0   \n",
      "56         Carlos Sainz          Miami    19  57     39  Hard New          0   \n",
      "57         Carlos Sainz         Monaco     1  33     33  Hard New          0   \n",
      "58         Carlos Sainz         Monaco    34  55     22         0          0   \n",
      "59         Carlos Sainz         Monaco    56  78     23         0          0   \n",
      "60         Carlos Sainz   Saudi Arabia     1  15     15         0          0   \n",
      "61         Carlos Sainz   Saudi Arabia    16  50     35  Hard New          0   \n",
      "62         Carlos Sainz          Spain     1  15     15         0          0   \n",
      "63         Carlos Sainz          Spain    16  41     26         0          0   \n",
      "64         Carlos Sainz          Spain    42  66     25  Hard New          0   \n",
      "65      Charles Leclerc      Australia     1   1      1         0          0   \n",
      "66      Charles Leclerc        Austria     1  14     14         0          0   \n",
      "67      Charles Leclerc        Austria    15  47     33         0          0   \n",
      "68      Charles Leclerc        Austria    48  71     24  Hard New          0   \n",
      "69      Charles Leclerc     Azerbaijan     1  11     11         0          0   \n",
      "70      Charles Leclerc     Azerbaijan    12  51     40  Hard New          0   \n",
      "71      Charles Leclerc        Bahrain     1  13     13         0          0   \n",
      "72      Charles Leclerc        Bahrain    14  33     20  Hard New          0   \n",
      "73      Charles Leclerc        Bahrain    34  39      6  Hard New          0   \n",
      "74      Charles Leclerc        Belgium     1  13     13         0          0   \n",
      "75      Charles Leclerc        Belgium    14  28     15         0          0   \n",
      "76      Charles Leclerc        Belgium    29  44     16         0          0   \n",
      "77      Charles Leclerc         Canada     1  39     39         0          0   \n",
      "78      Charles Leclerc         Canada    40  70     31  Hard New          0   \n",
      "79      Charles Leclerc  Great Britain     1  18     18         0          0   \n",
      "80      Charles Leclerc  Great Britain    19  32     14  Hard New          0   \n",
      "81      Charles Leclerc  Great Britain    33  52     20         0          0   \n",
      "82      Charles Leclerc        Hungary     1  17     17         0          0   \n",
      "83      Charles Leclerc        Hungary    18  43     26  Hard New          0   \n",
      "84      Charles Leclerc        Hungary    44  70     27         0  Hard Used   \n",
      "85      Charles Leclerc          Miami     1  17     17         0          0   \n",
      "86      Charles Leclerc          Miami    18  57     40  Hard New          0   \n",
      "87      Charles Leclerc         Monaco     1  44     44  Hard New          0   \n",
      "88      Charles Leclerc         Monaco    45  55     11         0          0   \n",
      "89      Charles Leclerc         Monaco    56  78     23         0          0   \n",
      "90      Charles Leclerc   Saudi Arabia     1  16     16         0          0   \n",
      "91      Charles Leclerc   Saudi Arabia    17  50     34  Hard New          0   \n",
      "92      Charles Leclerc          Spain     1  16     16  Hard New          0   \n",
      "93      Charles Leclerc          Spain    17  41     25         0          0   \n",
      "94      Charles Leclerc          Spain    42  66     25  Hard New          0   \n",
      "95     Daniel Ricciardo        Belgium     1   5      5         0          0   \n",
      "96     Daniel Ricciardo        Belgium     6  22     17         0          0   \n",
      "97     Daniel Ricciardo        Belgium    23  44     22         0          0   \n",
      "98     Daniel Ricciardo        Hungary     1  18     18         0          0   \n",
      "99     Daniel Ricciardo        Hungary    19  29     11         0  Hard Used   \n",
      "100    Daniel Ricciardo        Hungary    30  69     40         0          0   \n",
      "101        Esteban Ocon      Australia     1   1      1         0          0   \n",
      "102        Esteban Ocon      Australia     2  55     54  Hard New          0   \n",
      "103        Esteban Ocon      Australia    56  56      1         0          0   \n",
      "104        Esteban Ocon        Austria     1  14     14         0          0   \n",
      "105        Esteban Ocon        Austria    15  40     26  Hard New          0   \n",
      "106        Esteban Ocon        Austria    41  70     30  Hard New          0   \n",
      "107        Esteban Ocon     Azerbaijan     1  50     50  Hard New          0   \n",
      "108        Esteban Ocon     Azerbaijan    51  51      1         0          0   \n",
      "109        Esteban Ocon        Bahrain     1  12     12         0          0   \n",
      "110        Esteban Ocon        Bahrain    13  32     20  Hard New          0   \n",
      "111        Esteban Ocon        Bahrain    33  41      9  Hard New          0   \n",
      "112        Esteban Ocon        Belgium     1   6      6         0          0   \n",
      "113        Esteban Ocon        Belgium     7  25     19         0          0   \n",
      "114        Esteban Ocon        Belgium    26  44     19         0          0   \n",
      "115        Esteban Ocon         Canada     1  12     12         0          0   \n",
      "116        Esteban Ocon         Canada    13  36     24  Hard New          0   \n",
      "117        Esteban Ocon         Canada    37  70     34  Hard New          0   \n",
      "118        Esteban Ocon  Great Britain     1   9      9         0          0   \n",
      "119        Esteban Ocon        Hungary     1   2      2         0          0   \n",
      "120        Esteban Ocon          Miami     1  39     39  Hard New          0   \n",
      "121        Esteban Ocon          Miami    40  57     18         0          0   \n",
      "122        Esteban Ocon         Monaco     1  32     32         0          0   \n",
      "123        Esteban Ocon         Monaco    33  54     22  Hard New          0   \n",
      "124        Esteban Ocon         Monaco    55  78     24         0          0   \n",
      "125        Esteban Ocon   Saudi Arabia     1  16     16         0          0   \n",
      "126        Esteban Ocon   Saudi Arabia    17  50     34  Hard New          0   \n",
      "127        Esteban Ocon          Spain     1  13     13         0          0   \n",
      "128        Esteban Ocon          Spain    14  35     22         0          0   \n",
      "129        Esteban Ocon          Spain    36  66     31  Hard New          0   \n",
      "130     Fernando Alonso      Australia     1   8      8         0          0   \n",
      "131     Fernando Alonso      Australia     9  55     47  Hard New          0   \n",
      "132     Fernando Alonso      Australia    56  57      2         0          0   \n",
      "133     Fernando Alonso      Australia    58  58      1         0          0   \n",
      "134     Fernando Alonso        Austria     1  15     15  Hard New          0   \n",
      "135     Fernando Alonso        Austria    16  44     29         0          0   \n",
      "136     Fernando Alonso        Austria    45  71     27         0          0   \n",
      "137     Fernando Alonso     Azerbaijan     1  11     11         0          0   \n",
      "138     Fernando Alonso     Azerbaijan    12  51     40         0  Hard Used   \n",
      "139     Fernando Alonso        Bahrain     1  14     14         0          0   \n",
      "140     Fernando Alonso        Bahrain    15  34     20  Hard New          0   \n",
      "141     Fernando Alonso        Bahrain    35  57     23  Hard New          0   \n",
      "142     Fernando Alonso        Belgium     1  10     10         0          0   \n",
      "143     Fernando Alonso        Belgium    11  29     19         0          0   \n",
      "144     Fernando Alonso        Belgium    30  44     15         0          0   \n",
      "145     Fernando Alonso         Canada     1  12     12         0          0   \n",
      "146     Fernando Alonso         Canada    13  41     29  Hard New          0   \n",
      "147     Fernando Alonso         Canada    42  70     29  Hard New          0   \n",
      "148     Fernando Alonso  Great Britain     1  33     33         0          0   \n",
      "149     Fernando Alonso  Great Britain    34  52     19         0          0   \n",
      "150     Fernando Alonso        Hungary     1  20     20         0          0   \n",
      "151     Fernando Alonso        Hungary    21  43     23  Hard New          0   \n",
      "152     Fernando Alonso        Hungary    44  70     27         0  Hard Used   \n",
      "153     Fernando Alonso          Miami     1  24     24         0          0   \n",
      "154     Fernando Alonso          Miami    25  57     33         0  Hard Used   \n",
      "155     Fernando Alonso         Monaco     1  54     54         0  Hard Used   \n",
      "156     Fernando Alonso         Monaco    55  55      1         0          0   \n",
      "157     Fernando Alonso         Monaco    56  78     23         0          0   \n",
      "158     Fernando Alonso   Saudi Arabia     1  18     18         0          0   \n",
      "159     Fernando Alonso   Saudi Arabia    19  50     32         0  Hard Used   \n",
      "160     Fernando Alonso          Spain     1  19     19         0          0   \n",
      "161     Fernando Alonso          Spain    20  44     25         0          0   \n",
      "162     Fernando Alonso          Spain    45  66     22         0  Hard Used   \n",
      "163      George Russell      Australia     1   7      7         0          0   \n",
      "164      George Russell      Australia     8  17     10  Hard New          0   \n",
      "165      George Russell        Austria     1  14     14         0          0   \n",
      "166      George Russell        Austria    15  41     27  Hard New          0   \n",
      "167      George Russell        Austria    42  71     30         0          0   \n",
      "168      George Russell     Azerbaijan     1  11     11         0          0   \n",
      "169      George Russell     Azerbaijan    12  49     38  Hard New          0   \n",
      "170      George Russell     Azerbaijan    50  51      2         0          0   \n",
      "171      George Russell        Bahrain     1  13     13         0          0   \n",
      "172      George Russell        Bahrain    14  31     18  Hard New          0   \n",
      "173      George Russell        Bahrain    32  57     26  Hard New          0   \n",
      "174      George Russell        Belgium     1  22     22         0          0   \n",
      "175      George Russell        Belgium    23  44     22         0          0   \n",
      "176      George Russell         Canada     1  12     12         0          0   \n",
      "177      George Russell         Canada    13  53     41  Hard New          0   \n",
      "178      George Russell  Great Britain     1  28     28         0          0   \n",
      "179      George Russell  Great Britain    29  52     24         0          0   \n",
      "180      George Russell        Hungary     1  28     28  Hard New          0   \n",
      "181      George Russell        Hungary    29  46     18         0          0   \n",
      "182      George Russell        Hungary    47  70     24         0          0   \n",
      "183      George Russell          Miami     1  17     17         0          0   \n",
      "184      George Russell          Miami    18  57     40  Hard New          0   \n",
      "185      George Russell         Monaco     1  54     54  Hard New          0   \n",
      "186      George Russell         Monaco    55  78     24         0          0   \n",
      "187      George Russell   Saudi Arabia     1  18     18         0          0   \n",
      "188      George Russell   Saudi Arabia    19  50     32  Hard New          0   \n",
      "189      George Russell          Spain     1  25     25         0          0   \n",
      "190      George Russell          Spain    26  45     20         0          0   \n",
      "191      George Russell          Spain    46  66     21         0          0   \n",
      "192     Kevin Magnussen      Australia     1   7      7         0          0   \n",
      "193     Kevin Magnussen      Australia     8  52     45  Hard New          0   \n",
      "194     Kevin Magnussen        Austria     1   1      1  Hard New          0   \n",
      "195     Kevin Magnussen        Austria     2   2      1         0          0   \n",
      "196     Kevin Magnussen        Austria     3  34     32  Hard New          0   \n",
      "197     Kevin Magnussen        Austria    35  70     36         0  Hard Used   \n",
      "198     Kevin Magnussen     Azerbaijan     1  10     10         0          0   \n",
      "199     Kevin Magnussen     Azerbaijan    11  51     41  Hard New          0   \n",
      "200     Kevin Magnussen        Bahrain     1  15     15  Hard New          0   \n",
      "201     Kevin Magnussen        Bahrain    16  29     14  Hard New          0   \n",
      "202     Kevin Magnussen        Bahrain    30  40     11         0          0   \n",
      "203     Kevin Magnussen        Bahrain    41  56     16         0          0   \n",
      "204     Kevin Magnussen        Belgium     1   5      5         0          0   \n",
      "205     Kevin Magnussen        Belgium     6  25     20         0          0   \n",
      "206     Kevin Magnussen        Belgium    26  44     19         0          0   \n",
      "207     Kevin Magnussen         Canada     1  35     35  Hard New          0   \n",
      "208     Kevin Magnussen         Canada    36  53     18         0          0   \n",
      "209     Kevin Magnussen         Canada    54  69     16         0          0   \n",
      "210     Kevin Magnussen  Great Britain     1  31     31         0          0   \n",
      "211     Kevin Magnussen        Hungary     1  14     14         0          0   \n",
      "212     Kevin Magnussen        Hungary    15  41     27         0  Hard Used   \n",
      "213     Kevin Magnussen        Hungary    42  69     28         0  Hard Used   \n",
      "214     Kevin Magnussen          Miami     1  14     14         0          0   \n",
      "215     Kevin Magnussen          Miami    15  57     43  Hard New          0   \n",
      "216     Kevin Magnussen         Monaco     1  56     56  Hard New          0   \n",
      "217     Kevin Magnussen         Monaco    57  70     14         0          0   \n",
      "218     Kevin Magnussen   Saudi Arabia     1   8      8         0          0   \n",
      "219     Kevin Magnussen   Saudi Arabia     9  50     42  Hard New          0   \n",
      "220     Kevin Magnussen          Spain     1  10     10         0          0   \n",
      "221     Kevin Magnussen          Spain    11  24     14         0          0   \n",
      "222     Kevin Magnussen          Spain    25  42     18  Hard New          0   \n",
      "223     Kevin Magnussen          Spain    43  65     23         0          0   \n",
      "224        Lance Stroll      Australia     1   8      8         0          0   \n",
      "225        Lance Stroll      Australia     9  55     47  Hard New          0   \n",
      "226        Lance Stroll      Australia    56  57      2         0          0   \n",
      "227        Lance Stroll      Australia    58  58      1         0          0   \n",
      "228        Lance Stroll        Austria     1  15     15         0          0   \n",
      "229        Lance Stroll        Austria    16  36     21         0  Hard Used   \n",
      "230        Lance Stroll        Austria    37  54     18  Hard New          0   \n",
      "231        Lance Stroll        Austria    55  71     17         0          0   \n",
      "232        Lance Stroll     Azerbaijan     1  11     11         0          0   \n",
      "233        Lance Stroll     Azerbaijan    12  51     40         0  Hard Used   \n",
      "234        Lance Stroll        Bahrain     1  13     13         0          0   \n",
      "235        Lance Stroll        Bahrain    14  30     17  Hard New          0   \n",
      "236        Lance Stroll        Bahrain    31  57     27  Hard New          0   \n",
      "237        Lance Stroll        Belgium     1  20     20         0          0   \n",
      "238        Lance Stroll        Belgium    21  44     24         0          0   \n",
      "239        Lance Stroll         Canada     1  11     11         0          0   \n",
      "240        Lance Stroll         Canada    12  27     16         0  Hard Used   \n",
      "241        Lance Stroll         Canada    28  70     43  Hard New          0   \n",
      "242        Lance Stroll  Great Britain     1  31     31         0          0   \n",
      "243        Lance Stroll  Great Britain    32  52     21         0          0   \n",
      "244        Lance Stroll        Hungary     1   9      9         0          0   \n",
      "245        Lance Stroll        Hungary    10  34     25         0  Hard Used   \n",
      "246        Lance Stroll        Hungary    35  69     35         0  Hard Used   \n",
      "247        Lance Stroll          Miami     1  42     42         0  Hard Used   \n",
      "248        Lance Stroll          Miami    43  57     15         0          0   \n",
      "249        Lance Stroll         Monaco     1  51     51         0  Hard Used   \n",
      "250        Lance Stroll         Monaco    52  53      2         0          0   \n",
      "251        Lance Stroll   Saudi Arabia     1  13     13         0          0   \n",
      "252        Lance Stroll   Saudi Arabia    14  16      3         0  Hard Used   \n",
      "253        Lance Stroll          Spain     1  14     14         0          0   \n",
      "254        Lance Stroll          Spain    15  34     20         0          0   \n",
      "255        Lance Stroll          Spain    35  66     32         0  Hard Used   \n",
      "256        Lando Norris      Australia     1   8      8         0          0   \n",
      "257        Lando Norris      Australia     9  55     47  Hard New          0   \n",
      "258        Lando Norris      Australia    56  57      2         0          0   \n",
      "259        Lando Norris      Australia    58  58      1         0          0   \n",
      "260        Lando Norris        Austria     1  14     14         0          0   \n",
      "261        Lando Norris        Austria    15  41     27  Hard New          0   \n",
      "262        Lando Norris        Austria    42  71     30  Hard New          0   \n",
      "263        Lando Norris     Azerbaijan     1   8      8         0          0   \n",
      "264        Lando Norris     Azerbaijan     9  51     43  Hard New          0   \n",
      "265        Lando Norris        Bahrain     1  10     10         0          0   \n",
      "266        Lando Norris        Bahrain    11  17      7  Hard New          0   \n",
      "267        Lando Norris        Bahrain    18  27     10         0          0   \n",
      "268        Lando Norris        Bahrain    28  37     10         0          0   \n",
      "269        Lando Norris        Bahrain    38  47     10  Hard New          0   \n",
      "270        Lando Norris        Bahrain    48  55      8         0          0   \n",
      "271        Lando Norris        Belgium     1   5      5         0          0   \n",
      "272        Lando Norris        Belgium     6  17     12  Hard New          0   \n",
      "273        Lando Norris        Belgium    18  44     27         0          0   \n",
      "274        Lando Norris         Canada     1  12     12         0          0   \n",
      "275        Lando Norris         Canada    13  35     23  Hard New          0   \n",
      "276        Lando Norris         Canada    36  70     35         0  Hard Used   \n",
      "277        Lando Norris  Great Britain     1  33     33         0          0   \n",
      "278        Lando Norris  Great Britain    34  52     19  Hard New          0   \n",
      "279        Lando Norris        Hungary     1  17     17         0          0   \n",
      "280        Lando Norris        Hungary    18  44     27  Hard New          0   \n",
      "281        Lando Norris        Hungary    45  70     26         0          0   \n",
      "282        Lando Norris          Miami     1   4      4         0          0   \n",
      "283        Lando Norris          Miami     5  57     53  Hard New          0   \n",
      "284        Lando Norris         Monaco     1  50     50         0          0   \n",
      "285        Lando Norris         Monaco    51  54      4  Hard New          0   \n",
      "286        Lando Norris         Monaco    55  77     23         0          0   \n",
      "287        Lando Norris   Saudi Arabia     1   2      2         0          0   \n",
      "288        Lando Norris   Saudi Arabia     3  19     17  Hard New          0   \n",
      "289        Lando Norris   Saudi Arabia    20  50     31         0          0   \n",
      "290        Lando Norris          Spain     1   1      1         0          0   \n",
      "291        Lando Norris          Spain     2  22     21  Hard New          0   \n",
      "292        Lando Norris          Spain    23  50     28         0          0   \n",
      "293        Lando Norris          Spain    51  65     15         0          0   \n",
      "294      Lewis Hamilton      Australia     1   8      8         0          0   \n",
      "295      Lewis Hamilton      Australia     9  55     47  Hard New          0   \n",
      "296      Lewis Hamilton      Australia    56  57      2         0          0   \n",
      "297      Lewis Hamilton      Australia    58  58      1         0          0   \n",
      "298      Lewis Hamilton        Austria     1  14     14         0          0   \n",
      "299      Lewis Hamilton        Austria    15  42     28  Hard New          0   \n",
      "300      Lewis Hamilton        Austria    43  71     29         0          0   \n",
      "301      Lewis Hamilton     Azerbaijan     1   9      9         0          0   \n",
      "302      Lewis Hamilton     Azerbaijan    10  51     42  Hard New          0   \n",
      "303      Lewis Hamilton        Bahrain     1  12     12         0          0   \n",
      "304      Lewis Hamilton        Bahrain    13  30     18  Hard New          0   \n",
      "305      Lewis Hamilton        Bahrain    31  57     27  Hard New          0   \n",
      "306      Lewis Hamilton        Belgium     1  12     12         0          0   \n",
      "307      Lewis Hamilton        Belgium    13  27     15         0          0   \n",
      "308      Lewis Hamilton        Belgium    28  42     15         0          0   \n",
      "309      Lewis Hamilton        Belgium    43  44      2         0          0   \n",
      "310      Lewis Hamilton         Canada     1  12     12         0          0   \n",
      "311      Lewis Hamilton         Canada    13  40     28  Hard New          0   \n",
      "312      Lewis Hamilton         Canada    41  70     30         0          0   \n",
      "313      Lewis Hamilton  Great Britain     1  33     33         0          0   \n",
      "314      Lewis Hamilton  Great Britain    34  52     19         0          0   \n",
      "315      Lewis Hamilton        Hungary     1  16     16         0          0   \n",
      "316      Lewis Hamilton        Hungary    17  49     33  Hard New          0   \n",
      "317      Lewis Hamilton        Hungary    50  70     21         0          0   \n",
      "318      Lewis Hamilton          Miami     1  37     37         0  Hard Used   \n",
      "319      Lewis Hamilton          Miami    38  57     20         0          0   \n",
      "320      Lewis Hamilton         Monaco     1  31     31         0          0   \n",
      "321      Lewis Hamilton         Monaco    32  54     23  Hard New          0   \n",
      "322      Lewis Hamilton         Monaco    55  78     24         0          0   \n",
      "323      Lewis Hamilton   Saudi Arabia     1  18     18  Hard New          0   \n",
      "324      Lewis Hamilton   Saudi Arabia    19  50     32         0          0   \n",
      "325      Lewis Hamilton          Spain     1  24     24         0          0   \n",
      "326      Lewis Hamilton          Spain    25  50     26         0          0   \n",
      "327      Lewis Hamilton          Spain    51  65     15         0          0   \n",
      "328      Logan Sargeant      Australia     1   1      1  Hard New          0   \n",
      "329      Logan Sargeant      Australia     2   8      7         0  Hard Used   \n",
      "330      Logan Sargeant      Australia     9  36     28         0          0   \n",
      "331      Logan Sargeant      Australia    37  54     18         0  Hard Used   \n",
      "332      Logan Sargeant      Australia    55  56      2         0          0   \n",
      "333      Logan Sargeant        Austria     1  14     14         0          0   \n",
      "334      Logan Sargeant        Austria    15  43     29  Hard New          0   \n",
      "335      Logan Sargeant        Austria    44  70     27  Hard New          0   \n",
      "336      Logan Sargeant     Azerbaijan     1   8      8         0          0   \n",
      "337      Logan Sargeant     Azerbaijan     9  51     43  Hard New          0   \n",
      "338      Logan Sargeant        Bahrain     1  12     12         0          0   \n",
      "339      Logan Sargeant        Bahrain    13  30     18         0          0   \n",
      "340      Logan Sargeant        Bahrain    31  40     10  Hard New          0   \n",
      "341      Logan Sargeant        Bahrain    41  56     16         0          0   \n",
      "342      Logan Sargeant        Belgium     1   8      8         0          0   \n",
      "343      Logan Sargeant        Belgium     9  24     16         0          0   \n",
      "344      Logan Sargeant        Belgium    25  34     10         0          0   \n",
      "345      Logan Sargeant        Belgium    35  44     10         0          0   \n",
      "346      Logan Sargeant         Canada     1   6      6         0          0   \n",
      "347      Logan Sargeant  Great Britain     1  29     29         0          0   \n",
      "348      Logan Sargeant  Great Britain    30  52     23         0          0   \n",
      "349      Logan Sargeant        Hungary     1  13     13         0          0   \n",
      "350      Logan Sargeant        Hungary    14  34     21         0  Hard Used   \n",
      "351      Logan Sargeant        Hungary    35  67     33  Hard New          0   \n",
      "352      Logan Sargeant          Miami     1   2      2         0          0   \n",
      "353      Logan Sargeant          Miami     3  56     54  Hard New          0   \n",
      "354      Logan Sargeant         Monaco     1  20     20         0          0   \n",
      "355      Logan Sargeant         Monaco    21  23      3  Hard New          0   \n",
      "356      Logan Sargeant         Monaco    24  52     29         0          0   \n",
      "357      Logan Sargeant         Monaco    53  76     24         0          0   \n",
      "358      Logan Sargeant   Saudi Arabia     1  18     18  Hard New          0   \n",
      "359      Logan Sargeant   Saudi Arabia    19  50     32         0          0   \n",
      "360      Logan Sargeant          Spain     1  17     17         0          0   \n",
      "361      Logan Sargeant          Spain    18  36     19  Hard New          0   \n",
      "362      Logan Sargeant          Spain    37  65     29  Hard New          0   \n",
      "363      Max Verstappen      Australia     1   8      8         0          0   \n",
      "364      Max Verstappen      Australia     9  55     47  Hard New          0   \n",
      "365      Max Verstappen      Australia    56  57      2         0          0   \n",
      "366      Max Verstappen      Australia    58  58      1         0          0   \n",
      "367      Max Verstappen        Austria     1  24     24         0          0   \n",
      "368      Max Verstappen        Austria    25  49     25  Hard New          0   \n",
      "369      Max Verstappen        Austria    50  69     20         0          0   \n",
      "370      Max Verstappen        Austria    70  71      2         0          0   \n",
      "371      Max Verstappen     Azerbaijan     1  10     10         0          0   \n",
      "372      Max Verstappen     Azerbaijan    11  51     41  Hard New          0   \n",
      "373      Max Verstappen        Bahrain     1  14     14         0          0   \n",
      "374      Max Verstappen        Bahrain    15  36     22         0          0   \n",
      "375      Max Verstappen        Bahrain    37  57     21  Hard New          0   \n",
      "376      Max Verstappen        Belgium     1  14     14         0          0   \n",
      "377      Max Verstappen        Belgium    15  30     16         0          0   \n",
      "378      Max Verstappen        Belgium    31  44     14         0          0   \n",
      "379      Max Verstappen         Canada     1  12     12         0          0   \n",
      "380      Max Verstappen         Canada    13  42     30  Hard New          0   \n",
      "381      Max Verstappen         Canada    43  70     28         0          0   \n",
      "382      Max Verstappen  Great Britain     1  33     33         0          0   \n",
      "383      Max Verstappen  Great Britain    34  52     19         0          0   \n",
      "384      Max Verstappen        Hungary     1  23     23         0          0   \n",
      "385      Max Verstappen        Hungary    24  51     28  Hard New          0   \n",
      "386      Max Verstappen        Hungary    52  70     19         0          0   \n",
      "387      Max Verstappen          Miami     1  45     45  Hard New          0   \n",
      "388      Max Verstappen          Miami    46  57     12         0          0   \n",
      "389      Max Verstappen         Monaco     1  55     55         0          0   \n",
      "390      Max Verstappen         Monaco    56  78     23         0          0   \n",
      "391      Max Verstappen   Saudi Arabia     1  18     18         0          0   \n",
      "392      Max Verstappen   Saudi Arabia    19  50     32  Hard New          0   \n",
      "393      Max Verstappen          Spain     1  26     26         0          0   \n",
      "394      Max Verstappen          Spain    27  52     26  Hard New          0   \n",
      "395      Max Verstappen          Spain    53  66     14         0          0   \n",
      "396     Nico Hulkenberg      Australia     1   8      8         0          0   \n",
      "397     Nico Hulkenberg      Australia     9  55     47  Hard New          0   \n",
      "398     Nico Hulkenberg      Australia    56  57      2         0          0   \n",
      "399     Nico Hulkenberg      Australia    58  58      1         0          0   \n",
      "400     Nico Hulkenberg        Austria     1  11     11         0          0   \n",
      "401     Nico Hulkenberg        Austria    12  12      1  Hard New          0   \n",
      "402     Nico Hulkenberg     Azerbaijan     1  49     49  Hard New          0   \n",
      "403     Nico Hulkenberg     Azerbaijan    50  50      1         0          0   \n",
      "404     Nico Hulkenberg        Bahrain     1  11     11         0          0   \n",
      "405     Nico Hulkenberg        Bahrain    12  26     15  Hard New          0   \n",
      "406     Nico Hulkenberg        Bahrain    27  40     14  Hard New          0   \n",
      "407     Nico Hulkenberg        Bahrain    41  56     16         0          0   \n",
      "408     Nico Hulkenberg        Belgium     1  12     12         0          0   \n",
      "409     Nico Hulkenberg        Belgium    13  24     12         0          0   \n",
      "410     Nico Hulkenberg        Belgium    25  44     20         0          0   \n",
      "411     Nico Hulkenberg         Canada     1   7      7         0          0   \n",
      "412     Nico Hulkenberg         Canada     8  31     24  Hard New          0   \n",
      "413     Nico Hulkenberg         Canada    32  69     38  Hard New          0   \n",
      "414     Nico Hulkenberg  Great Britain     1   7      7  Hard New          0   \n",
      "415     Nico Hulkenberg  Great Britain     8  32     25         0          0   \n",
      "416     Nico Hulkenberg  Great Britain    33  52     20         0          0   \n",
      "417     Nico Hulkenberg        Hungary     1  16     16         0          0   \n",
      "418     Nico Hulkenberg        Hungary    17  38     22         0  Hard Used   \n",
      "419     Nico Hulkenberg        Hungary    39  69     31         0  Hard Used   \n",
      "420     Nico Hulkenberg          Miami     1  33     33  Hard New          0   \n",
      "421     Nico Hulkenberg          Miami    34  57     24         0          0   \n",
      "422     Nico Hulkenberg         Monaco     1   1      1         0          0   \n",
      "423     Nico Hulkenberg         Monaco     2  54     53  Hard New          0   \n",
      "424     Nico Hulkenberg         Monaco    55  59      5         0          0   \n",
      "425     Nico Hulkenberg         Monaco    60  76     17         0          0   \n",
      "426     Nico Hulkenberg   Saudi Arabia     1  11     11         0          0   \n",
      "427     Nico Hulkenberg   Saudi Arabia    12  50     39  Hard New          0   \n",
      "428     Nico Hulkenberg          Spain     1   8      8         0          0   \n",
      "429     Nico Hulkenberg          Spain     9  26     18         0          0   \n",
      "430     Nico Hulkenberg          Spain    27  43     17  Hard New          0   \n",
      "431     Nico Hulkenberg          Spain    44  65     22         0          0   \n",
      "432       Nyck de Vries      Australia     1   8      8  Hard New          0   \n",
      "433       Nyck de Vries      Australia     9  45     37         0          0   \n",
      "434       Nyck de Vries      Australia    46  54      9         0          0   \n",
      "435       Nyck de Vries      Australia    55  56      2         0          0   \n",
      "436       Nyck de Vries        Austria     1  12     12         0          0   \n",
      "437       Nyck de Vries        Austria    13  37     25  Hard New          0   \n",
      "438       Nyck de Vries        Austria    38  70     33         0          0   \n",
      "439       Nyck de Vries     Azerbaijan     1   9      9         0  Hard Used   \n",
      "440       Nyck de Vries        Bahrain     1  11     11         0          0   \n",
      "441       Nyck de Vries        Bahrain    12  27     16  Hard New          0   \n",
      "442       Nyck de Vries        Bahrain    28  56     29  Hard New          0   \n",
      "443       Nyck de Vries         Canada     1  11     11         0          0   \n",
      "444       Nyck de Vries         Canada    12  50     39  Hard New          0   \n",
      "445       Nyck de Vries         Canada    51  69     19  Hard New          0   \n",
      "446       Nyck de Vries  Great Britain     1  27     27         0          0   \n",
      "447       Nyck de Vries  Great Britain    28  32      5         0          0   \n",
      "448       Nyck de Vries  Great Britain    33  52     20         0          0   \n",
      "449       Nyck de Vries          Miami     1  15     15         0          0   \n",
      "450       Nyck de Vries          Miami    16  57     42  Hard New          0   \n",
      "451       Nyck de Vries         Monaco     1  53     53         0          0   \n",
      "452       Nyck de Vries         Monaco    54  77     24         0          0   \n",
      "453       Nyck de Vries   Saudi Arabia     1  17     17         0          0   \n",
      "454       Nyck de Vries   Saudi Arabia    18  50     33  Hard New          0   \n",
      "455       Nyck de Vries          Spain     1   9      9         0          0   \n",
      "456       Nyck de Vries          Spain    10  38     29  Hard New          0   \n",
      "457       Nyck de Vries          Spain    39  65     27         0          0   \n",
      "458       Oscar Piastri      Australia     1   8      8         0          0   \n",
      "459       Oscar Piastri      Australia     9  55     47  Hard New          0   \n",
      "460       Oscar Piastri      Australia    56  57      2         0          0   \n",
      "461       Oscar Piastri      Australia    58  58      1         0          0   \n",
      "462       Oscar Piastri        Austria     1  14     14         0          0   \n",
      "463       Oscar Piastri        Austria    15  22      8  Hard New          0   \n",
      "464       Oscar Piastri        Austria    23  41     19  Hard New          0   \n",
      "465       Oscar Piastri        Austria    42  70     29         0          0   \n",
      "466       Oscar Piastri     Azerbaijan     1   8      8         0          0   \n",
      "467       Oscar Piastri     Azerbaijan     9  51     43  Hard New          0   \n",
      "468       Oscar Piastri        Bahrain     1  13     13         0          0   \n",
      "469       Oscar Piastri        Belgium     1   1      1         0          0   \n",
      "470       Oscar Piastri         Canada     1  12     12         0          0   \n",
      "471       Oscar Piastri         Canada    13  37     25  Hard New          0   \n",
      "472       Oscar Piastri         Canada    38  70     33         0  Hard Used   \n",
      "473       Oscar Piastri  Great Britain     1  29     29         0          0   \n",
      "474       Oscar Piastri  Great Britain    30  52     23  Hard New          0   \n",
      "475       Oscar Piastri        Hungary     1  18     18         0          0   \n",
      "476       Oscar Piastri        Hungary    19  42     24  Hard New          0   \n",
      "477       Oscar Piastri        Hungary    43  70     28         0          0   \n",
      "478       Oscar Piastri          Miami     1   5      5         0          0   \n",
      "479       Oscar Piastri          Miami     6  56     51  Hard New          0   \n",
      "480       Oscar Piastri         Monaco     1  54     54  Hard New          0   \n",
      "481       Oscar Piastri         Monaco    55  77     23         0          0   \n",
      "482       Oscar Piastri   Saudi Arabia     1   1      1         0          0   \n",
      "483       Oscar Piastri   Saudi Arabia     2  50     49  Hard New          0   \n",
      "484       Oscar Piastri          Spain     1  17     17         0          0   \n",
      "485       Oscar Piastri          Spain    18  39     22  Hard New          0   \n",
      "486       Oscar Piastri          Spain    40  66     27         0          0   \n",
      "487        Pierre Gasly      Australia     1   8      8         0          0   \n",
      "488        Pierre Gasly      Australia     9  55     47  Hard New          0   \n",
      "489        Pierre Gasly      Australia    56  56      1         0          0   \n",
      "490        Pierre Gasly        Austria     1  14     14         0          0   \n",
      "491        Pierre Gasly        Austria    15  44     30  Hard New          0   \n",
      "492        Pierre Gasly        Austria    45  71     27         0          0   \n",
      "493        Pierre Gasly     Azerbaijan     1   5      5         0          0   \n",
      "494        Pierre Gasly     Azerbaijan     6  23     18  Hard New          0   \n",
      "495        Pierre Gasly     Azerbaijan    24  51     28  Hard New          0   \n",
      "496        Pierre Gasly        Bahrain     1   9      9         0          0   \n",
      "497        Pierre Gasly        Bahrain    10  25     16  Hard New          0   \n",
      "498        Pierre Gasly        Bahrain    26  40     15  Hard New          0   \n",
      "499        Pierre Gasly        Bahrain    41  57     17         0          0   \n",
      "500        Pierre Gasly        Belgium     1  23     23         0          0   \n",
      "501        Pierre Gasly        Belgium    24  44     21         0          0   \n",
      "502        Pierre Gasly         Canada     1  10     10         0          0   \n",
      "503        Pierre Gasly         Canada    11  33     23         0  Hard Used   \n",
      "504        Pierre Gasly         Canada    34  70     37  Hard New          0   \n",
      "505        Pierre Gasly  Great Britain     1  31     31         0          0   \n",
      "506        Pierre Gasly  Great Britain    32  46     15         0          0   \n",
      "507        Pierre Gasly        Hungary     1   1      1         0          0   \n",
      "508        Pierre Gasly          Miami     1  15     15         0          0   \n",
      "509        Pierre Gasly          Miami    16  57     42  Hard New          0   \n",
      "510        Pierre Gasly         Monaco     1  47     47  Hard New          0   \n",
      "511        Pierre Gasly         Monaco    48  54      7         0          0   \n",
      "512        Pierre Gasly         Monaco    55  78     24         0          0   \n",
      "513        Pierre Gasly   Saudi Arabia     1  14     14         0          0   \n",
      "514        Pierre Gasly   Saudi Arabia    15  50     36  Hard New          0   \n",
      "515        Pierre Gasly          Spain     1  19     19         0          0   \n",
      "516        Pierre Gasly          Spain    20  39     20         0          0   \n",
      "517        Pierre Gasly          Spain    40  66     27  Hard New          0   \n",
      "518        Sergio Perez      Australia     1   1      1  Hard New          0   \n",
      "519        Sergio Perez      Australia     2   8      7  Hard New          0   \n",
      "520        Sergio Perez      Australia     9  55     47         0  Hard Used   \n",
      "521        Sergio Perez      Australia    56  57      2         0          0   \n",
      "522        Sergio Perez      Australia    58  58      1         0          0   \n",
      "523        Sergio Perez        Austria     1  25     25         0          0   \n",
      "524        Sergio Perez        Austria    26  50     25         0          0   \n",
      "525        Sergio Perez        Austria    51  71     21  Hard New          0   \n",
      "526        Sergio Perez     Azerbaijan     1  11     11         0          0   \n",
      "527        Sergio Perez     Azerbaijan    12  51     40  Hard New          0   \n",
      "528        Sergio Perez        Bahrain     1  17     17         0          0   \n",
      "529        Sergio Perez        Bahrain    18  34     17         0          0   \n",
      "530        Sergio Perez        Bahrain    35  57     23  Hard New          0   \n",
      "531        Sergio Perez        Belgium     1  13     13         0          0   \n",
      "532        Sergio Perez        Belgium    14  29     16         0          0   \n",
      "533        Sergio Perez        Belgium    30  44     15         0          0   \n",
      "534        Sergio Perez         Canada     1  37     37  Hard New          0   \n",
      "535        Sergio Perez         Canada    38  68     31         0          0   \n",
      "536        Sergio Perez         Canada    69  70      2         0          0   \n",
      "537        Sergio Perez  Great Britain     1  28     28         0          0   \n",
      "538        Sergio Perez  Great Britain    29  52     24         0          0   \n",
      "539        Sergio Perez        Hungary     1  24     24         0  Hard Used   \n",
      "540        Sergio Perez        Hungary    25  42     18         0          0   \n",
      "541        Sergio Perez        Hungary    43  70     28         0          0   \n",
      "542        Sergio Perez          Miami     1  20     20         0          0   \n",
      "543        Sergio Perez          Miami    21  57     37  Hard New          0   \n",
      "544        Sergio Perez         Monaco     1   1      1         0          0   \n",
      "545        Sergio Perez         Monaco     2  34     33  Hard New          0   \n",
      "546        Sergio Perez         Monaco    35  53     19         0          0   \n",
      "547        Sergio Perez         Monaco    54  57      4         0          0   \n",
      "548        Sergio Perez         Monaco    58  70     13         0          0   \n",
      "549        Sergio Perez         Monaco    71  76      6         0          0   \n",
      "550        Sergio Perez   Saudi Arabia     1  18     18         0          0   \n",
      "551        Sergio Perez   Saudi Arabia    19  50     32  Hard New          0   \n",
      "552        Sergio Perez          Spain     1  27     27         0          0   \n",
      "553        Sergio Perez          Spain    28  50     23  Hard New          0   \n",
      "554        Sergio Perez          Spain    51  66     16         0          0   \n",
      "555     Valtteri Bottas      Australia     1   1      1         0          0   \n",
      "556     Valtteri Bottas      Australia     2  53     52  Hard New          0   \n",
      "557     Valtteri Bottas      Australia    54  58      5         0          0   \n",
      "558     Valtteri Bottas        Austria     1  21     21  Hard New          0   \n",
      "559     Valtteri Bottas        Austria    22  39     18         0          0   \n",
      "560     Valtteri Bottas        Austria    40  70     31  Hard New          0   \n",
      "561     Valtteri Bottas     Azerbaijan     1   6      6         0          0   \n",
      "562     Valtteri Bottas     Azerbaijan     7  12      6  Hard New          0   \n",
      "563     Valtteri Bottas     Azerbaijan    13  34     22  Hard New          0   \n",
      "564     Valtteri Bottas     Azerbaijan    35  50     16         0          0   \n",
      "565     Valtteri Bottas        Bahrain     1  11     11         0          0   \n",
      "566     Valtteri Bottas        Bahrain    12  29     18  Hard New          0   \n",
      "567     Valtteri Bottas        Bahrain    30  57     28  Hard New          0   \n",
      "568     Valtteri Bottas        Belgium     1   6      6         0          0   \n",
      "569     Valtteri Bottas        Belgium     7  24     18         0          0   \n",
      "570     Valtteri Bottas        Belgium    25  44     20         0          0   \n",
      "571     Valtteri Bottas         Canada     1  36     36  Hard New          0   \n",
      "572     Valtteri Bottas         Canada    37  70     34         0          0   \n",
      "573     Valtteri Bottas  Great Britain     1  32     32  Hard New          0   \n",
      "574     Valtteri Bottas  Great Britain    33  52     20         0          0   \n",
      "575     Valtteri Bottas        Hungary     1   9      9         0          0   \n",
      "576     Valtteri Bottas        Hungary    10  40     31         0  Hard Used   \n",
      "577     Valtteri Bottas        Hungary    41  69     29         0  Hard Used   \n",
      "578     Valtteri Bottas          Miami     1  15     15         0          0   \n",
      "579     Valtteri Bottas          Miami    16  57     42  Hard New          0   \n",
      "580     Valtteri Bottas         Monaco     1  51     51  Hard New          0   \n",
      "581     Valtteri Bottas         Monaco    52  77     26         0          0   \n",
      "582     Valtteri Bottas   Saudi Arabia     1   9      9         0          0   \n",
      "583     Valtteri Bottas   Saudi Arabia    10  17      8  Hard New          0   \n",
      "584     Valtteri Bottas   Saudi Arabia    18  35     18         0          0   \n",
      "585     Valtteri Bottas   Saudi Arabia    36  49     14         0          0   \n",
      "586     Valtteri Bottas          Spain     1   5      5         0          0   \n",
      "587     Valtteri Bottas          Spain     6  39     34  Hard New          0   \n",
      "588     Valtteri Bottas          Spain    40  65     26  Hard New          0   \n",
      "589        Yuki Tsunoda      Australia     1   8      8         0          0   \n",
      "590        Yuki Tsunoda      Australia     9  55     47  Hard New          0   \n",
      "591        Yuki Tsunoda      Australia    56  57      2         0          0   \n",
      "592        Yuki Tsunoda      Australia    58  58      1         0          0   \n",
      "593        Yuki Tsunoda        Austria     1   1      1         0          0   \n",
      "594        Yuki Tsunoda        Austria     2  23     22  Hard New          0   \n",
      "595        Yuki Tsunoda        Austria    24  43     20  Hard New          0   \n",
      "596        Yuki Tsunoda        Austria    44  70     27         0          0   \n",
      "597        Yuki Tsunoda     Azerbaijan     1   8      8         0          0   \n",
      "598        Yuki Tsunoda     Azerbaijan     9  51     43         0  Hard Used   \n",
      "599        Yuki Tsunoda        Bahrain     1  10     10         0          0   \n",
      "600        Yuki Tsunoda        Bahrain    11  26     16  Hard New          0   \n",
      "601        Yuki Tsunoda        Bahrain    27  40     14  Hard New          0   \n",
      "602        Yuki Tsunoda        Bahrain    41  57     17         0          0   \n",
      "603        Yuki Tsunoda        Belgium     1   9      9         0          0   \n",
      "604        Yuki Tsunoda        Belgium    10  24     15         0          0   \n",
      "605        Yuki Tsunoda        Belgium    25  44     20         0          0   \n",
      "606        Yuki Tsunoda         Canada     1   1      1         0          0   \n",
      "607        Yuki Tsunoda         Canada     2  34     33  Hard New          0   \n",
      "608        Yuki Tsunoda         Canada    35  70     36  Hard New          0   \n",
      "609        Yuki Tsunoda  Great Britain     1  14     14         0          0   \n",
      "610        Yuki Tsunoda  Great Britain    15  32     18  Hard New          0   \n",
      "611        Yuki Tsunoda  Great Britain    33  52     20         0          0   \n",
      "612        Yuki Tsunoda        Hungary     1   9      9         0          0   \n",
      "613        Yuki Tsunoda        Hungary    10  44     35         0  Hard Used   \n",
      "614        Yuki Tsunoda        Hungary    45  69     25         0          0   \n",
      "615        Yuki Tsunoda          Miami     1  36     36  Hard New          0   \n",
      "616        Yuki Tsunoda          Miami    37  57     21         0          0   \n",
      "617        Yuki Tsunoda         Monaco     1  53     53         0          0   \n",
      "618        Yuki Tsunoda         Monaco    54  76     23         0          0   \n",
      "619        Yuki Tsunoda   Saudi Arabia     1  17     17         0          0   \n",
      "620        Yuki Tsunoda   Saudi Arabia    18  50     33  Hard New          0   \n",
      "621        Yuki Tsunoda          Spain     1   9      9         0          0   \n",
      "622        Yuki Tsunoda          Spain    10  36     27  Hard New          0   \n",
      "623        Yuki Tsunoda          Spain    37  66     30  Hard New          0   \n",
      "624         Zhou Guanyu      Australia     1   1      1         0          0   \n",
      "625         Zhou Guanyu      Australia     2  55     54  Hard New          0   \n",
      "626         Zhou Guanyu      Australia    56  58      3         0          0   \n",
      "627         Zhou Guanyu        Austria     1   8      8         0          0   \n",
      "628         Zhou Guanyu        Austria     9  38     30  Hard New          0   \n",
      "629         Zhou Guanyu        Austria    39  70     32  Hard New          0   \n",
      "630         Zhou Guanyu     Azerbaijan     1  11     11         0          0   \n",
      "631         Zhou Guanyu     Azerbaijan    12  36     25  Hard New          0   \n",
      "632         Zhou Guanyu        Bahrain     1  12     12         0          0   \n",
      "633         Zhou Guanyu        Bahrain    13  32     20  Hard New          0   \n",
      "634         Zhou Guanyu        Bahrain    33  54     22         0          0   \n",
      "635         Zhou Guanyu        Bahrain    55  56      2         0          0   \n",
      "636         Zhou Guanyu        Belgium     1   7      7         0          0   \n",
      "637         Zhou Guanyu        Belgium     8  25     18         0          0   \n",
      "638         Zhou Guanyu        Belgium    26  44     19         0          0   \n",
      "639         Zhou Guanyu         Canada     1  12     12         0          0   \n",
      "640         Zhou Guanyu         Canada    13  32     20  Hard New          0   \n",
      "641         Zhou Guanyu         Canada    33  69     37  Hard New          0   \n",
      "642         Zhou Guanyu  Great Britain     1  24     24         0          0   \n",
      "643         Zhou Guanyu  Great Britain    25  33      9  Hard New          0   \n",
      "644         Zhou Guanyu  Great Britain    34  52     19         0          0   \n",
      "645         Zhou Guanyu        Hungary     1  10     10         0          0   \n",
      "646         Zhou Guanyu        Hungary    11  38     28         0  Hard Used   \n",
      "647         Zhou Guanyu        Hungary    39  69     31         0  Hard Used   \n",
      "648         Zhou Guanyu          Miami     1  31     31  Hard New          0   \n",
      "649         Zhou Guanyu          Miami    32  57     26         0          0   \n",
      "650         Zhou Guanyu         Monaco     1   1      1         0          0   \n",
      "651         Zhou Guanyu         Monaco     2  52     51  Hard New          0   \n",
      "652         Zhou Guanyu         Monaco    53  77     25         0          0   \n",
      "653         Zhou Guanyu   Saudi Arabia     1  11     11         0          0   \n",
      "654         Zhou Guanyu   Saudi Arabia    12  18      7  Hard New          0   \n",
      "655         Zhou Guanyu   Saudi Arabia    19  50     32         0          0   \n",
      "656         Zhou Guanyu          Spain     1   9      9         0          0   \n",
      "657         Zhou Guanyu          Spain    10  36     27  Hard New          0   \n",
      "658         Zhou Guanyu          Spain    37  66     30  Hard New          0   \n",
      "\n",
      "Tyres  Intermediate New  Medium New  Medium Used  Soft New  Soft Used  Wet New  \n",
      "0                     0  Medium New            0         0          0        0  \n",
      "1                     0           0            0         0          0        0  \n",
      "2                     0           0            0         0          0        0  \n",
      "3                     0  Medium New            0         0          0        0  \n",
      "4                     0  Medium New            0         0          0        0  \n",
      "5                     0           0            0         0          0        0  \n",
      "6                     0           0            0         0          0        0  \n",
      "7                     0  Medium New            0         0          0        0  \n",
      "8                     0           0            0         0          0        0  \n",
      "9                     0           0            0  Soft New          0        0  \n",
      "10                    0           0            0  Soft New          0        0  \n",
      "11                    0           0            0         0          0        0  \n",
      "12                    0           0            0         0  Soft Used        0  \n",
      "13                    0           0            0  Soft New          0        0  \n",
      "14                    0  Medium New            0         0          0        0  \n",
      "15                    0  Medium New            0         0          0        0  \n",
      "16                    0           0            0  Soft New          0        0  \n",
      "17                    0           0  Medium Used         0          0        0  \n",
      "18                    0           0            0         0          0        0  \n",
      "19                    0  Medium New            0         0          0        0  \n",
      "20                    0           0            0         0  Soft Used        0  \n",
      "21                    0  Medium New            0         0          0        0  \n",
      "22                    0           0            0         0          0        0  \n",
      "23                    0           0            0         0          0        0  \n",
      "24                    0  Medium New            0         0          0        0  \n",
      "25                    0           0            0         0          0        0  \n",
      "26                    0  Medium New            0         0          0        0  \n",
      "27                    0           0            0         0          0        0  \n",
      "28     Intermediate New           0            0         0          0        0  \n",
      "29                    0  Medium New            0         0          0        0  \n",
      "30                    0           0            0         0          0        0  \n",
      "31                    0           0            0  Soft New          0        0  \n",
      "32                    0           0            0         0          0        0  \n",
      "33                    0  Medium New            0         0          0        0  \n",
      "34                    0           0  Medium Used         0          0        0  \n",
      "35                    0           0            0         0          0        0  \n",
      "36                    0           0            0         0  Soft Used        0  \n",
      "37                    0           0            0         0  Soft Used        0  \n",
      "38                    0  Medium New            0         0          0        0  \n",
      "39                    0  Medium New            0         0          0        0  \n",
      "40                    0           0            0         0          0        0  \n",
      "41                    0  Medium New            0         0          0        0  \n",
      "42                    0           0            0         0          0        0  \n",
      "43                    0           0            0         0  Soft Used        0  \n",
      "44                    0           0            0         0          0        0  \n",
      "45                    0           0            0         0          0        0  \n",
      "46                    0           0            0  Soft New          0        0  \n",
      "47                    0  Medium New            0         0          0        0  \n",
      "48                    0  Medium New            0         0          0        0  \n",
      "49                    0           0            0         0          0        0  \n",
      "50                    0  Medium New            0         0          0        0  \n",
      "51                    0           0            0         0          0        0  \n",
      "52                    0           0            0  Soft New          0        0  \n",
      "53                    0           0            0         0          0        0  \n",
      "54                    0           0            0         0          0        0  \n",
      "55                    0  Medium New            0         0          0        0  \n",
      "56                    0           0            0         0          0        0  \n",
      "57                    0           0            0         0          0        0  \n",
      "58                    0  Medium New            0         0          0        0  \n",
      "59     Intermediate New           0            0         0          0        0  \n",
      "60                    0  Medium New            0         0          0        0  \n",
      "61                    0           0            0         0          0        0  \n",
      "62                    0           0            0         0  Soft Used        0  \n",
      "63                    0  Medium New            0         0          0        0  \n",
      "64                    0           0            0         0          0        0  \n",
      "65                    0  Medium New            0         0          0        0  \n",
      "66                    0  Medium New            0         0          0        0  \n",
      "67                    0  Medium New            0         0          0        0  \n",
      "68                    0           0            0         0          0        0  \n",
      "69                    0  Medium New            0         0          0        0  \n",
      "70                    0           0            0         0          0        0  \n",
      "71                    0           0            0  Soft New          0        0  \n",
      "72                    0           0            0         0          0        0  \n",
      "73                    0           0            0         0          0        0  \n",
      "74                    0           0            0  Soft New          0        0  \n",
      "75                    0  Medium New            0         0          0        0  \n",
      "76                    0           0            0  Soft New          0        0  \n",
      "77                    0  Medium New            0         0          0        0  \n",
      "78                    0           0            0         0          0        0  \n",
      "79                    0  Medium New            0         0          0        0  \n",
      "80                    0           0            0         0          0        0  \n",
      "81                    0  Medium New            0         0          0        0  \n",
      "82                    0           0  Medium Used         0          0        0  \n",
      "83                    0           0            0         0          0        0  \n",
      "84                    0           0            0         0          0        0  \n",
      "85                    0  Medium New            0         0          0        0  \n",
      "86                    0           0            0         0          0        0  \n",
      "87                    0           0            0         0          0        0  \n",
      "88                    0  Medium New            0         0          0        0  \n",
      "89     Intermediate New           0            0         0          0        0  \n",
      "90                    0           0            0  Soft New          0        0  \n",
      "91                    0           0            0         0          0        0  \n",
      "92                    0           0            0         0          0        0  \n",
      "93                    0           0            0  Soft New          0        0  \n",
      "94                    0           0            0         0          0        0  \n",
      "95                    0           0            0  Soft New          0        0  \n",
      "96                    0  Medium New            0         0          0        0  \n",
      "97                    0  Medium New            0         0          0        0  \n",
      "98                    0           0  Medium Used         0          0        0  \n",
      "99                    0           0            0         0          0        0  \n",
      "100                   0           0  Medium Used         0          0        0  \n",
      "101                   0           0            0  Soft New          0        0  \n",
      "102                   0           0            0         0          0        0  \n",
      "103                   0           0            0  Soft New          0        0  \n",
      "104                   0  Medium New            0         0          0        0  \n",
      "105                   0           0            0         0          0        0  \n",
      "106                   0           0            0         0          0        0  \n",
      "107                   0           0            0         0          0        0  \n",
      "108                   0           0            0  Soft New          0        0  \n",
      "109                   0           0            0         0  Soft Used        0  \n",
      "110                   0           0            0         0          0        0  \n",
      "111                   0           0            0         0          0        0  \n",
      "112                   0           0            0  Soft New          0        0  \n",
      "113                   0  Medium New            0         0          0        0  \n",
      "114                   0           0            0  Soft New          0        0  \n",
      "115                   0  Medium New            0         0          0        0  \n",
      "116                   0           0            0         0          0        0  \n",
      "117                   0           0            0         0          0        0  \n",
      "118                   0           0            0  Soft New          0        0  \n",
      "119                   0           0  Medium Used         0          0        0  \n",
      "120                   0           0            0         0          0        0  \n",
      "121                   0  Medium New            0         0          0        0  \n",
      "122                   0  Medium New            0         0          0        0  \n",
      "123                   0           0            0         0          0        0  \n",
      "124    Intermediate New           0            0         0          0        0  \n",
      "125                   0  Medium New            0         0          0        0  \n",
      "126                   0           0            0         0          0        0  \n",
      "127                   0           0            0         0  Soft Used        0  \n",
      "128                   0  Medium New            0         0          0        0  \n",
      "129                   0           0            0         0          0        0  \n",
      "130                   0           0  Medium Used         0          0        0  \n",
      "131                   0           0            0         0          0        0  \n",
      "132                   0           0            0         0  Soft Used        0  \n",
      "133                   0           0            0         0  Soft Used        0  \n",
      "134                   0           0            0         0          0        0  \n",
      "135                   0           0  Medium Used         0          0        0  \n",
      "136                   0  Medium New            0         0          0        0  \n",
      "137                   0           0  Medium Used         0          0        0  \n",
      "138                   0           0            0         0          0        0  \n",
      "139                   0           0            0         0  Soft Used        0  \n",
      "140                   0           0            0         0          0        0  \n",
      "141                   0           0            0         0          0        0  \n",
      "142                   0  Medium New            0         0          0        0  \n",
      "143                   0  Medium New            0         0          0        0  \n",
      "144                   0           0            0  Soft New          0        0  \n",
      "145                   0  Medium New            0         0          0        0  \n",
      "146                   0           0            0         0          0        0  \n",
      "147                   0           0            0         0          0        0  \n",
      "148                   0           0  Medium Used         0          0        0  \n",
      "149                   0           0            0         0  Soft Used        0  \n",
      "150                   0           0  Medium Used         0          0        0  \n",
      "151                   0           0            0         0          0        0  \n",
      "152                   0           0            0         0          0        0  \n",
      "153                   0           0  Medium Used         0          0        0  \n",
      "154                   0           0            0         0          0        0  \n",
      "155                   0           0            0         0          0        0  \n",
      "156                   0  Medium New            0         0          0        0  \n",
      "157    Intermediate New           0            0         0          0        0  \n",
      "158                   0  Medium New            0         0          0        0  \n",
      "159                   0           0            0         0          0        0  \n",
      "160                   0           0            0         0  Soft Used        0  \n",
      "161                   0           0            0         0  Soft Used        0  \n",
      "162                   0           0            0         0          0        0  \n",
      "163                   0  Medium New            0         0          0        0  \n",
      "164                   0           0            0         0          0        0  \n",
      "165                   0  Medium New            0         0          0        0  \n",
      "166                   0           0            0         0          0        0  \n",
      "167                   0  Medium New            0         0          0        0  \n",
      "168                   0  Medium New            0         0          0        0  \n",
      "169                   0           0            0         0          0        0  \n",
      "170                   0           0            0  Soft New          0        0  \n",
      "171                   0           0            0         0  Soft Used        0  \n",
      "172                   0           0            0         0          0        0  \n",
      "173                   0           0            0         0          0        0  \n",
      "174                   0  Medium New            0         0          0        0  \n",
      "175                   0           0            0  Soft New          0        0  \n",
      "176                   0  Medium New            0         0          0        0  \n",
      "177                   0           0            0         0          0        0  \n",
      "178                   0           0            0         0  Soft Used        0  \n",
      "179                   0  Medium New            0         0          0        0  \n",
      "180                   0           0            0         0          0        0  \n",
      "181                   0  Medium New            0         0          0        0  \n",
      "182                   0  Medium New            0         0          0        0  \n",
      "183                   0  Medium New            0         0          0        0  \n",
      "184                   0           0            0         0          0        0  \n",
      "185                   0           0            0         0          0        0  \n",
      "186    Intermediate New           0            0         0          0        0  \n",
      "187                   0  Medium New            0         0          0        0  \n",
      "188                   0           0            0         0          0        0  \n",
      "189                   0           0            0  Soft New          0        0  \n",
      "190                   0  Medium New            0         0          0        0  \n",
      "191                   0           0            0         0  Soft Used        0  \n",
      "192                   0  Medium New            0         0          0        0  \n",
      "193                   0           0            0         0          0        0  \n",
      "194                   0           0            0         0          0        0  \n",
      "195                   0  Medium New            0         0          0        0  \n",
      "196                   0           0            0         0          0        0  \n",
      "197                   0           0            0         0          0        0  \n",
      "198                   0  Medium New            0         0          0        0  \n",
      "199                   0           0            0         0          0        0  \n",
      "200                   0           0            0         0          0        0  \n",
      "201                   0           0            0         0          0        0  \n",
      "202                   0           0            0  Soft New          0        0  \n",
      "203                   0           0            0  Soft New          0        0  \n",
      "204                   0           0            0  Soft New          0        0  \n",
      "205                   0  Medium New            0         0          0        0  \n",
      "206                   0  Medium New            0         0          0        0  \n",
      "207                   0           0            0         0          0        0  \n",
      "208                   0  Medium New            0         0          0        0  \n",
      "209                   0  Medium New            0         0          0        0  \n",
      "210                   0  Medium New            0         0          0        0  \n",
      "211                   0  Medium New            0         0          0        0  \n",
      "212                   0           0            0         0          0        0  \n",
      "213                   0           0            0         0          0        0  \n",
      "214                   0  Medium New            0         0          0        0  \n",
      "215                   0           0            0         0          0        0  \n",
      "216                   0           0            0         0          0        0  \n",
      "217                   0           0            0         0          0  Wet New  \n",
      "218                   0  Medium New            0         0          0        0  \n",
      "219                   0           0            0         0          0        0  \n",
      "220                   0           0            0  Soft New          0        0  \n",
      "221                   0  Medium New            0         0          0        0  \n",
      "222                   0           0            0         0          0        0  \n",
      "223                   0  Medium New            0         0          0        0  \n",
      "224                   0           0  Medium Used         0          0        0  \n",
      "225                   0           0            0         0          0        0  \n",
      "226                   0           0            0         0  Soft Used        0  \n",
      "227                   0           0            0         0  Soft Used        0  \n",
      "228                   0  Medium New            0         0          0        0  \n",
      "229                   0           0            0         0          0        0  \n",
      "230                   0           0            0         0          0        0  \n",
      "231                   0  Medium New            0         0          0        0  \n",
      "232                   0           0  Medium Used         0          0        0  \n",
      "233                   0           0            0         0          0        0  \n",
      "234                   0           0            0         0  Soft Used        0  \n",
      "235                   0           0            0         0          0        0  \n",
      "236                   0           0            0         0          0        0  \n",
      "237                   0  Medium New            0         0          0        0  \n",
      "238                   0           0            0  Soft New          0        0  \n",
      "239                   0  Medium New            0         0          0        0  \n",
      "240                   0           0            0         0          0        0  \n",
      "241                   0           0            0         0          0        0  \n",
      "242                   0           0  Medium Used         0          0        0  \n",
      "243                   0           0            0         0  Soft Used        0  \n",
      "244                   0           0            0  Soft New          0        0  \n",
      "245                   0           0            0         0          0        0  \n",
      "246                   0           0            0         0          0        0  \n",
      "247                   0           0            0         0          0        0  \n",
      "248                   0           0  Medium Used         0          0        0  \n",
      "249                   0           0            0         0          0        0  \n",
      "250    Intermediate New           0            0         0          0        0  \n",
      "251                   0  Medium New            0         0          0        0  \n",
      "252                   0           0            0         0          0        0  \n",
      "253                   0           0            0         0  Soft Used        0  \n",
      "254                   0           0            0         0  Soft Used        0  \n",
      "255                   0           0            0         0          0        0  \n",
      "256                   0  Medium New            0         0          0        0  \n",
      "257                   0           0            0         0          0        0  \n",
      "258                   0           0            0  Soft New          0        0  \n",
      "259                   0           0            0         0  Soft Used        0  \n",
      "260                   0  Medium New            0         0          0        0  \n",
      "261                   0           0            0         0          0        0  \n",
      "262                   0           0            0         0          0        0  \n",
      "263                   0  Medium New            0         0          0        0  \n",
      "264                   0           0            0         0          0        0  \n",
      "265                   0           0            0  Soft New          0        0  \n",
      "266                   0           0            0         0          0        0  \n",
      "267                   0           0            0         0  Soft Used        0  \n",
      "268                   0  Medium New            0         0          0        0  \n",
      "269                   0           0            0         0          0        0  \n",
      "270                   0           0            0         0  Soft Used        0  \n",
      "271                   0  Medium New            0         0          0        0  \n",
      "272                   0           0            0         0          0        0  \n",
      "273                   0           0            0  Soft New          0        0  \n",
      "274                   0  Medium New            0         0          0        0  \n",
      "275                   0           0            0         0          0        0  \n",
      "276                   0           0            0         0          0        0  \n",
      "277                   0  Medium New            0         0          0        0  \n",
      "278                   0           0            0         0          0        0  \n",
      "279                   0  Medium New            0         0          0        0  \n",
      "280                   0           0            0         0          0        0  \n",
      "281                   0           0  Medium Used         0          0        0  \n",
      "282                   0           0            0  Soft New          0        0  \n",
      "283                   0           0            0         0          0        0  \n",
      "284                   0  Medium New            0         0          0        0  \n",
      "285                   0           0            0         0          0        0  \n",
      "286    Intermediate New           0            0         0          0        0  \n",
      "287                   0           0            0  Soft New          0        0  \n",
      "288                   0           0            0         0          0        0  \n",
      "289                   0  Medium New            0         0          0        0  \n",
      "290                   0           0            0         0  Soft Used        0  \n",
      "291                   0           0            0         0          0        0  \n",
      "292                   0  Medium New            0         0          0        0  \n",
      "293                   0           0            0         0  Soft Used        0  \n",
      "294                   0  Medium New            0         0          0        0  \n",
      "295                   0           0            0         0          0        0  \n",
      "296                   0           0            0         0  Soft Used        0  \n",
      "297                   0           0            0         0  Soft Used        0  \n",
      "298                   0  Medium New            0         0          0        0  \n",
      "299                   0           0            0         0          0        0  \n",
      "300                   0  Medium New            0         0          0        0  \n",
      "301                   0  Medium New            0         0          0        0  \n",
      "302                   0           0            0         0          0        0  \n",
      "303                   0           0            0         0  Soft Used        0  \n",
      "304                   0           0            0         0          0        0  \n",
      "305                   0           0            0         0          0        0  \n",
      "306                   0           0            0  Soft New          0        0  \n",
      "307                   0  Medium New            0         0          0        0  \n",
      "308                   0           0            0  Soft New          0        0  \n",
      "309                   0  Medium New            0         0          0        0  \n",
      "310                   0  Medium New            0         0          0        0  \n",
      "311                   0           0            0         0          0        0  \n",
      "312                   0  Medium New            0         0          0        0  \n",
      "313                   0  Medium New            0         0          0        0  \n",
      "314                   0           0            0         0  Soft Used        0  \n",
      "315                   0           0  Medium Used         0          0        0  \n",
      "316                   0           0            0         0          0        0  \n",
      "317                   0           0  Medium Used         0          0        0  \n",
      "318                   0           0            0         0          0        0  \n",
      "319                   0  Medium New            0         0          0        0  \n",
      "320                   0  Medium New            0         0          0        0  \n",
      "321                   0           0            0         0          0        0  \n",
      "322    Intermediate New           0            0         0          0        0  \n",
      "323                   0           0            0         0          0        0  \n",
      "324                   0  Medium New            0         0          0        0  \n",
      "325                   0           0            0         0  Soft Used        0  \n",
      "326                   0  Medium New            0         0          0        0  \n",
      "327                   0           0            0         0  Soft Used        0  \n",
      "328                   0           0            0         0          0        0  \n",
      "329                   0           0            0         0          0        0  \n",
      "330                   0  Medium New            0         0          0        0  \n",
      "331                   0           0            0         0          0        0  \n",
      "332                   0           0            0  Soft New          0        0  \n",
      "333                   0  Medium New            0         0          0        0  \n",
      "334                   0           0            0         0          0        0  \n",
      "335                   0           0            0         0          0        0  \n",
      "336                   0  Medium New            0         0          0        0  \n",
      "337                   0           0            0         0          0        0  \n",
      "338                   0           0            0  Soft New          0        0  \n",
      "339                   0           0            0  Soft New          0        0  \n",
      "340                   0           0            0         0          0        0  \n",
      "341                   0           0            0  Soft New          0        0  \n",
      "342                   0           0            0  Soft New          0        0  \n",
      "343                   0  Medium New            0         0          0        0  \n",
      "344                   0  Medium New            0         0          0        0  \n",
      "345                   0           0            0  Soft New          0        0  \n",
      "346                   0  Medium New            0         0          0        0  \n",
      "347                   0  Medium New            0         0          0        0  \n",
      "348                   0           0            0  Soft New          0        0  \n",
      "349                   0  Medium New            0         0          0        0  \n",
      "350                   0           0            0         0          0        0  \n",
      "351                   0           0            0         0          0        0  \n",
      "352                   0  Medium New            0         0          0        0  \n",
      "353                   0           0            0         0          0        0  \n",
      "354                   0  Medium New            0         0          0        0  \n",
      "355                   0           0            0         0          0        0  \n",
      "356                   0           0            0  Soft New          0        0  \n",
      "357    Intermediate New           0            0         0          0        0  \n",
      "358                   0           0            0         0          0        0  \n",
      "359                   0  Medium New            0         0          0        0  \n",
      "360                   0  Medium New            0         0          0        0  \n",
      "361                   0           0            0         0          0        0  \n",
      "362                   0           0            0         0          0        0  \n",
      "363                   0  Medium New            0         0          0        0  \n",
      "364                   0           0            0         0          0        0  \n",
      "365                   0           0            0         0  Soft Used        0  \n",
      "366                   0           0            0         0  Soft Used        0  \n",
      "367                   0  Medium New            0         0          0        0  \n",
      "368                   0           0            0         0          0        0  \n",
      "369                   0  Medium New            0         0          0        0  \n",
      "370                   0           0            0         0  Soft Used        0  \n",
      "371                   0  Medium New            0         0          0        0  \n",
      "372                   0           0            0         0          0        0  \n",
      "373                   0           0            0         0  Soft Used        0  \n",
      "374                   0           0            0         0  Soft Used        0  \n",
      "375                   0           0            0         0          0        0  \n",
      "376                   0           0            0  Soft New          0        0  \n",
      "377                   0  Medium New            0         0          0        0  \n",
      "378                   0           0            0  Soft New          0        0  \n",
      "379                   0  Medium New            0         0          0        0  \n",
      "380                   0           0            0         0          0        0  \n",
      "381                   0  Medium New            0         0          0        0  \n",
      "382                   0  Medium New            0         0          0        0  \n",
      "383                   0           0            0         0  Soft Used        0  \n",
      "384                   0           0  Medium Used         0          0        0  \n",
      "385                   0           0            0         0          0        0  \n",
      "386                   0           0  Medium Used         0          0        0  \n",
      "387                   0           0            0         0          0        0  \n",
      "388                   0  Medium New            0         0          0        0  \n",
      "389                   0  Medium New            0         0          0        0  \n",
      "390    Intermediate New           0            0         0          0        0  \n",
      "391                   0  Medium New            0         0          0        0  \n",
      "392                   0           0            0         0          0        0  \n",
      "393                   0  Medium New            0         0          0        0  \n",
      "394                   0           0            0         0          0        0  \n",
      "395                   0           0            0         0  Soft Used        0  \n",
      "396                   0  Medium New            0         0          0        0  \n",
      "397                   0           0            0         0          0        0  \n",
      "398                   0           0            0         0  Soft Used        0  \n",
      "399                   0           0            0         0  Soft Used        0  \n",
      "400                   0           0  Medium Used         0          0        0  \n",
      "401                   0           0            0         0          0        0  \n",
      "402                   0           0            0         0          0        0  \n",
      "403                   0           0            0  Soft New          0        0  \n",
      "404                   0           0            0         0  Soft Used        0  \n",
      "405                   0           0            0         0          0        0  \n",
      "406                   0           0            0         0          0        0  \n",
      "407                   0           0            0         0  Soft Used        0  \n",
      "408                   0  Medium New            0         0          0        0  \n",
      "409                   0           0            0  Soft New          0        0  \n",
      "410                   0           0            0  Soft New          0        0  \n",
      "411                   0  Medium New            0         0          0        0  \n",
      "412                   0           0            0         0          0        0  \n",
      "413                   0           0            0         0          0        0  \n",
      "414                   0           0            0         0          0        0  \n",
      "415                   0  Medium New            0         0          0        0  \n",
      "416                   0           0            0  Soft New          0        0  \n",
      "417                   0           0  Medium Used         0          0        0  \n",
      "418                   0           0            0         0          0        0  \n",
      "419                   0           0            0         0          0        0  \n",
      "420                   0           0            0         0          0        0  \n",
      "421                   0  Medium New            0         0          0        0  \n",
      "422                   0  Medium New            0         0          0        0  \n",
      "423                   0           0            0         0          0        0  \n",
      "424    Intermediate New           0            0         0          0        0  \n",
      "425                   0           0            0         0          0  Wet New  \n",
      "426                   0  Medium New            0         0          0        0  \n",
      "427                   0           0            0         0          0        0  \n",
      "428                   0           0            0         0  Soft Used        0  \n",
      "429                   0  Medium New            0         0          0        0  \n",
      "430                   0           0            0         0          0        0  \n",
      "431                   0  Medium New            0         0          0        0  \n",
      "432                   0           0            0         0          0        0  \n",
      "433                   0  Medium New            0         0          0        0  \n",
      "434                   0           0            0  Soft New          0        0  \n",
      "435                   0           0            0         0  Soft Used        0  \n",
      "436                   0  Medium New            0         0          0        0  \n",
      "437                   0           0            0         0          0        0  \n",
      "438                   0  Medium New            0         0          0        0  \n",
      "439                   0           0            0         0          0        0  \n",
      "440                   0           0            0  Soft New          0        0  \n",
      "441                   0           0            0         0          0        0  \n",
      "442                   0           0            0         0          0        0  \n",
      "443                   0  Medium New            0         0          0        0  \n",
      "444                   0           0            0         0          0        0  \n",
      "445                   0           0            0         0          0        0  \n",
      "446                   0           0            0  Soft New          0        0  \n",
      "447                   0  Medium New            0         0          0        0  \n",
      "448                   0           0            0  Soft New          0        0  \n",
      "449                   0  Medium New            0         0          0        0  \n",
      "450                   0           0            0         0          0        0  \n",
      "451                   0  Medium New            0         0          0        0  \n",
      "452    Intermediate New           0            0         0          0        0  \n",
      "453                   0  Medium New            0         0          0        0  \n",
      "454                   0           0            0         0          0        0  \n",
      "455                   0           0            0  Soft New          0        0  \n",
      "456                   0           0            0         0          0        0  \n",
      "457                   0  Medium New            0         0          0        0  \n",
      "458                   0  Medium New            0         0          0        0  \n",
      "459                   0           0            0         0          0        0  \n",
      "460                   0           0            0  Soft New          0        0  \n",
      "461                   0           0            0  Soft New          0        0  \n",
      "462                   0  Medium New            0         0          0        0  \n",
      "463                   0           0            0         0          0        0  \n",
      "464                   0           0            0         0          0        0  \n",
      "465                   0  Medium New            0         0          0        0  \n",
      "466                   0  Medium New            0         0          0        0  \n",
      "467                   0           0            0         0          0        0  \n",
      "468                   0           0            0  Soft New          0        0  \n",
      "469                   0  Medium New            0         0          0        0  \n",
      "470                   0  Medium New            0         0          0        0  \n",
      "471                   0           0            0         0          0        0  \n",
      "472                   0           0            0         0          0        0  \n",
      "473                   0  Medium New            0         0          0        0  \n",
      "474                   0           0            0         0          0        0  \n",
      "475                   0           0  Medium Used         0          0        0  \n",
      "476                   0           0            0         0          0        0  \n",
      "477                   0           0  Medium Used         0          0        0  \n",
      "478                   0           0            0  Soft New          0        0  \n",
      "479                   0           0            0         0          0        0  \n",
      "480                   0           0            0         0          0        0  \n",
      "481    Intermediate New           0            0         0          0        0  \n",
      "482                   0  Medium New            0         0          0        0  \n",
      "483                   0           0            0         0          0        0  \n",
      "484                   0           0            0         0  Soft Used        0  \n",
      "485                   0           0            0         0          0        0  \n",
      "486                   0  Medium New            0         0          0        0  \n",
      "487                   0           0            0  Soft New          0        0  \n",
      "488                   0           0            0         0          0        0  \n",
      "489                   0           0            0         0  Soft Used        0  \n",
      "490                   0  Medium New            0         0          0        0  \n",
      "491                   0           0            0         0          0        0  \n",
      "492                   0  Medium New            0         0          0        0  \n",
      "493                   0  Medium New            0         0          0        0  \n",
      "494                   0           0            0         0          0        0  \n",
      "495                   0           0            0         0          0        0  \n",
      "496                   0           0            0  Soft New          0        0  \n",
      "497                   0           0            0         0          0        0  \n",
      "498                   0           0            0         0          0        0  \n",
      "499                   0           0            0  Soft New          0        0  \n",
      "500                   0           0            0  Soft New          0        0  \n",
      "501                   0  Medium New            0         0          0        0  \n",
      "502                   0           0            0  Soft New          0        0  \n",
      "503                   0           0            0         0          0        0  \n",
      "504                   0           0            0         0          0        0  \n",
      "505                   0  Medium New            0         0          0        0  \n",
      "506                   0           0            0         0  Soft Used        0  \n",
      "507                   0           0            0  Soft New          0        0  \n",
      "508                   0  Medium New            0         0          0        0  \n",
      "509                   0           0            0         0          0        0  \n",
      "510                   0           0            0         0          0        0  \n",
      "511                   0  Medium New            0         0          0        0  \n",
      "512    Intermediate New           0            0         0          0        0  \n",
      "513                   0  Medium New            0         0          0        0  \n",
      "514                   0           0            0         0          0        0  \n",
      "515                   0           0            0         0  Soft Used        0  \n",
      "516                   0  Medium New            0         0          0        0  \n",
      "517                   0           0            0         0          0        0  \n",
      "518                   0           0            0         0          0        0  \n",
      "519                   0           0            0         0          0        0  \n",
      "520                   0           0            0         0          0        0  \n",
      "521                   0           0            0  Soft New          0        0  \n",
      "522                   0           0            0  Soft New          0        0  \n",
      "523                   0  Medium New            0         0          0        0  \n",
      "524                   0  Medium New            0         0          0        0  \n",
      "525                   0           0            0         0          0        0  \n",
      "526                   0  Medium New            0         0          0        0  \n",
      "527                   0           0            0         0          0        0  \n",
      "528                   0           0            0         0  Soft Used        0  \n",
      "529                   0           0            0         0  Soft Used        0  \n",
      "530                   0           0            0         0          0        0  \n",
      "531                   0           0            0  Soft New          0        0  \n",
      "532                   0  Medium New            0         0          0        0  \n",
      "533                   0           0            0  Soft New          0        0  \n",
      "534                   0           0            0         0          0        0  \n",
      "535                   0  Medium New            0         0          0        0  \n",
      "536                   0           0            0  Soft New          0        0  \n",
      "537                   0  Medium New            0         0          0        0  \n",
      "538                   0           0            0  Soft New          0        0  \n",
      "539                   0           0            0         0          0        0  \n",
      "540                   0           0  Medium Used         0          0        0  \n",
      "541                   0           0  Medium Used         0          0        0  \n",
      "542                   0  Medium New            0         0          0        0  \n",
      "543                   0           0            0         0          0        0  \n",
      "544                   0  Medium New            0         0          0        0  \n",
      "545                   0           0            0         0          0        0  \n",
      "546                   0           0  Medium Used         0          0        0  \n",
      "547    Intermediate New           0            0         0          0        0  \n",
      "548                   0           0            0         0          0  Wet New  \n",
      "549    Intermediate New           0            0         0          0        0  \n",
      "550                   0  Medium New            0         0          0        0  \n",
      "551                   0           0            0         0          0        0  \n",
      "552                   0  Medium New            0         0          0        0  \n",
      "553                   0           0            0         0          0        0  \n",
      "554                   0           0            0  Soft New          0        0  \n",
      "555                   0           0            0  Soft New          0        0  \n",
      "556                   0           0            0         0          0        0  \n",
      "557                   0           0            0  Soft New          0        0  \n",
      "558                   0           0            0         0          0        0  \n",
      "559                   0  Medium New            0         0          0        0  \n",
      "560                   0           0            0         0          0        0  \n",
      "561                   0  Medium New            0         0          0        0  \n",
      "562                   0           0            0         0          0        0  \n",
      "563                   0           0            0         0          0        0  \n",
      "564                   0  Medium New            0         0          0        0  \n",
      "565                   0           0            0         0  Soft Used        0  \n",
      "566                   0           0            0         0          0        0  \n",
      "567                   0           0            0         0          0        0  \n",
      "568                   0           0            0  Soft New          0        0  \n",
      "569                   0  Medium New            0         0          0        0  \n",
      "570                   0  Medium New            0         0          0        0  \n",
      "571                   0           0            0         0          0        0  \n",
      "572                   0  Medium New            0         0          0        0  \n",
      "573                   0           0            0         0          0        0  \n",
      "574                   0           0            0  Soft New          0        0  \n",
      "575                   0           0  Medium Used         0          0        0  \n",
      "576                   0           0            0         0          0        0  \n",
      "577                   0           0            0         0          0        0  \n",
      "578                   0  Medium New            0         0          0        0  \n",
      "579                   0           0            0         0          0        0  \n",
      "580                   0           0            0         0          0        0  \n",
      "581    Intermediate New           0            0         0          0        0  \n",
      "582                   0  Medium New            0         0          0        0  \n",
      "583                   0           0            0         0          0        0  \n",
      "584                   0  Medium New            0         0          0        0  \n",
      "585                   0           0            0  Soft New          0        0  \n",
      "586                   0           0            0  Soft New          0        0  \n",
      "587                   0           0            0         0          0        0  \n",
      "588                   0           0            0         0          0        0  \n",
      "589                   0  Medium New            0         0          0        0  \n",
      "590                   0           0            0         0          0        0  \n",
      "591                   0           0            0         0  Soft Used        0  \n",
      "592                   0           0            0         0  Soft Used        0  \n",
      "593                   0  Medium New            0         0          0        0  \n",
      "594                   0           0            0         0          0        0  \n",
      "595                   0           0            0         0          0        0  \n",
      "596                   0  Medium New            0         0          0        0  \n",
      "597                   0  Medium New            0         0          0        0  \n",
      "598                   0           0            0         0          0        0  \n",
      "599                   0           0            0  Soft New          0        0  \n",
      "600                   0           0            0         0          0        0  \n",
      "601                   0           0            0         0          0        0  \n",
      "602                   0           0            0         0  Soft Used        0  \n",
      "603                   0  Medium New            0         0          0        0  \n",
      "604                   0  Medium New            0         0          0        0  \n",
      "605                   0           0            0  Soft New          0        0  \n",
      "606                   0  Medium New            0         0          0        0  \n",
      "607                   0           0            0         0          0        0  \n",
      "608                   0           0            0         0          0        0  \n",
      "609                   0           0            0  Soft New          0        0  \n",
      "610                   0           0            0         0          0        0  \n",
      "611                   0           0            0  Soft New          0        0  \n",
      "612                   0           0            0  Soft New          0        0  \n",
      "613                   0           0            0         0          0        0  \n",
      "614                   0  Medium New            0         0          0        0  \n",
      "615                   0           0            0         0          0        0  \n",
      "616                   0  Medium New            0         0          0        0  \n",
      "617                   0  Medium New            0         0          0        0  \n",
      "618    Intermediate New           0            0         0          0        0  \n",
      "619                   0  Medium New            0         0          0        0  \n",
      "620                   0           0            0         0          0        0  \n",
      "621                   0           0            0  Soft New          0        0  \n",
      "622                   0           0            0         0          0        0  \n",
      "623                   0           0            0         0          0        0  \n",
      "624                   0           0            0  Soft New          0        0  \n",
      "625                   0           0            0         0          0        0  \n",
      "626                   0           0            0  Soft New          0        0  \n",
      "627                   0  Medium New            0         0          0        0  \n",
      "628                   0           0            0         0          0        0  \n",
      "629                   0           0            0         0          0        0  \n",
      "630                   0  Medium New            0         0          0        0  \n",
      "631                   0           0            0         0          0        0  \n",
      "632                   0           0            0  Soft New          0        0  \n",
      "633                   0           0            0         0          0        0  \n",
      "634                   0           0            0         0  Soft Used        0  \n",
      "635                   0           0            0         0  Soft Used        0  \n",
      "636                   0           0            0  Soft New          0        0  \n",
      "637                   0  Medium New            0         0          0        0  \n",
      "638                   0           0            0  Soft New          0        0  \n",
      "639                   0  Medium New            0         0          0        0  \n",
      "640                   0           0            0         0          0        0  \n",
      "641                   0           0            0         0          0        0  \n",
      "642                   0  Medium New            0         0          0        0  \n",
      "643                   0           0            0         0          0        0  \n",
      "644                   0           0            0  Soft New          0        0  \n",
      "645                   0           0  Medium Used         0          0        0  \n",
      "646                   0           0            0         0          0        0  \n",
      "647                   0           0            0         0          0        0  \n",
      "648                   0           0            0         0          0        0  \n",
      "649                   0  Medium New            0         0          0        0  \n",
      "650                   0           0            0  Soft New          0        0  \n",
      "651                   0           0            0         0          0        0  \n",
      "652    Intermediate New           0            0         0          0        0  \n",
      "653                   0  Medium New            0         0          0        0  \n",
      "654                   0           0            0         0          0        0  \n",
      "655                   0  Medium New            0         0          0        0  \n",
      "656                   0           0            0  Soft New          0        0  \n",
      "657                   0           0            0         0          0        0  \n",
      "658                   0           0            0         0          0        0  \n"
     ]
    }
   ],
   "source": [
    "# Pivot the \"Tyres\" column\n",
    "pivot_df = tyre_data_df.pivot(index=['Driver', 'GP', 'From', 'To', '#Laps'], columns='Tyres', values='Tyres').reset_index()\n",
    "\n",
    "# Fill NaN values with 0 if needed\n",
    "pivot_df = pivot_df.fillna(0)\n",
    "\n",
    "print(pivot_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "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>Tyres</th>\n",
       "      <th>Driver</th>\n",
       "      <th>GP</th>\n",
       "      <th>From</th>\n",
       "      <th>To</th>\n",
       "      <th>#Laps</th>\n",
       "      <th>Hard New</th>\n",
       "      <th>Hard Used</th>\n",
       "      <th>Intermediate New</th>\n",
       "      <th>Medium New</th>\n",
       "      <th>Medium Used</th>\n",
       "      <th>Soft New</th>\n",
       "      <th>Soft Used</th>\n",
       "      <th>Wet New</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>Austria</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0</td>\n",
       "      <td>Austria</td>\n",
       "      <td>15</td>\n",
       "      <td>41</td>\n",
       "      <td>27</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0</td>\n",
       "      <td>Austria</td>\n",
       "      <td>42</td>\n",
       "      <td>71</td>\n",
       "      <td>30</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Australia</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Austria</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Austria</td>\n",
       "      <td>15</td>\n",
       "      <td>41</td>\n",
       "      <td>27</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Austria</td>\n",
       "      <td>42</td>\n",
       "      <td>71</td>\n",
       "      <td>30</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>8</td>\n",
       "      <td>51</td>\n",
       "      <td>44</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>12</td>\n",
       "      <td>26</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>27</td>\n",
       "      <td>40</td>\n",
       "      <td>14</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>41</td>\n",
       "      <td>57</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>8</td>\n",
       "      <td>23</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>24</td>\n",
       "      <td>33</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>34</td>\n",
       "      <td>44</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Soft New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Canada</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium Used</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Canada</td>\n",
       "      <td>13</td>\n",
       "      <td>70</td>\n",
       "      <td>58</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Great Britain</td>\n",
       "      <td>1</td>\n",
       "      <td>32</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Great Britain</td>\n",
       "      <td>33</td>\n",
       "      <td>52</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Soft Used</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>9</td>\n",
       "      <td>31</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>Hard Used</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>32</td>\n",
       "      <td>69</td>\n",
       "      <td>38</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Miami</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Miami</td>\n",
       "      <td>23</td>\n",
       "      <td>57</td>\n",
       "      <td>35</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Monaco</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Monaco</td>\n",
       "      <td>19</td>\n",
       "      <td>52</td>\n",
       "      <td>34</td>\n",
       "      <td>Hard New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Monaco</td>\n",
       "      <td>53</td>\n",
       "      <td>77</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Intermediate New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Alexander Albon</td>\n",
       "      <td>Saudi Arabia</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>Medium New</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Tyres           Driver             GP  From  To  #Laps  Hard New  Hard Used   \n",
       "0                    0        Austria     1  14     14         0          0  \\\n",
       "1                    0        Austria    15  41     27  Hard New          0   \n",
       "2                    0        Austria    42  71     30  Hard New          0   \n",
       "3      Alexander Albon      Australia     1   6      6         0          0   \n",
       "4      Alexander Albon        Austria     1  14     14         0          0   \n",
       "5      Alexander Albon        Austria    15  41     27  Hard New          0   \n",
       "6      Alexander Albon        Austria    42  71     30  Hard New          0   \n",
       "7      Alexander Albon     Azerbaijan     1   7      7         0          0   \n",
       "8      Alexander Albon     Azerbaijan     8  51     44  Hard New          0   \n",
       "9      Alexander Albon        Bahrain     1  11     11         0          0   \n",
       "10     Alexander Albon        Bahrain    12  26     15         0          0   \n",
       "11     Alexander Albon        Bahrain    27  40     14  Hard New          0   \n",
       "12     Alexander Albon        Bahrain    41  57     17         0          0   \n",
       "13     Alexander Albon        Belgium     1   7      7         0          0   \n",
       "14     Alexander Albon        Belgium     8  23     16         0          0   \n",
       "15     Alexander Albon        Belgium    24  33     10         0          0   \n",
       "16     Alexander Albon        Belgium    34  44     11         0          0   \n",
       "17     Alexander Albon         Canada     1  12     12         0          0   \n",
       "18     Alexander Albon         Canada    13  70     58  Hard New          0   \n",
       "19     Alexander Albon  Great Britain     1  32     32         0          0   \n",
       "20     Alexander Albon  Great Britain    33  52     20         0          0   \n",
       "21     Alexander Albon        Hungary     1   8      8         0          0   \n",
       "22     Alexander Albon        Hungary     9  31     23         0  Hard Used   \n",
       "23     Alexander Albon        Hungary    32  69     38  Hard New          0   \n",
       "24     Alexander Albon          Miami     1  22     22         0          0   \n",
       "25     Alexander Albon          Miami    23  57     35  Hard New          0   \n",
       "26     Alexander Albon         Monaco     1  18     18         0          0   \n",
       "27     Alexander Albon         Monaco    19  52     34  Hard New          0   \n",
       "28     Alexander Albon         Monaco    53  77     25         0          0   \n",
       "29     Alexander Albon   Saudi Arabia     1  17     17         0          0   \n",
       "\n",
       "Tyres  Intermediate New  Medium New  Medium Used  Soft New  Soft Used Wet New  \n",
       "0                     0  Medium New            0         0          0       0  \n",
       "1                     0           0            0         0          0       0  \n",
       "2                     0           0            0         0          0       0  \n",
       "3                     0  Medium New            0         0          0       0  \n",
       "4                     0  Medium New            0         0          0       0  \n",
       "5                     0           0            0         0          0       0  \n",
       "6                     0           0            0         0          0       0  \n",
       "7                     0  Medium New            0         0          0       0  \n",
       "8                     0           0            0         0          0       0  \n",
       "9                     0           0            0  Soft New          0       0  \n",
       "10                    0           0            0  Soft New          0       0  \n",
       "11                    0           0            0         0          0       0  \n",
       "12                    0           0            0         0  Soft Used       0  \n",
       "13                    0           0            0  Soft New          0       0  \n",
       "14                    0  Medium New            0         0          0       0  \n",
       "15                    0  Medium New            0         0          0       0  \n",
       "16                    0           0            0  Soft New          0       0  \n",
       "17                    0           0  Medium Used         0          0       0  \n",
       "18                    0           0            0         0          0       0  \n",
       "19                    0  Medium New            0         0          0       0  \n",
       "20                    0           0            0         0  Soft Used       0  \n",
       "21                    0  Medium New            0         0          0       0  \n",
       "22                    0           0            0         0          0       0  \n",
       "23                    0           0            0         0          0       0  \n",
       "24                    0  Medium New            0         0          0       0  \n",
       "25                    0           0            0         0          0       0  \n",
       "26                    0  Medium New            0         0          0       0  \n",
       "27                    0           0            0         0          0       0  \n",
       "28     Intermediate New           0            0         0          0       0  \n",
       "29                    0  Medium New            0         0          0       0  "
      ]
     },
     "execution_count": 45,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pivot_df.head(30)"
   ]
  }
 ],
 "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.9.8"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}