F1_data_processor.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "pycharm": {
     "is_executing": false
    }
   },
   "outputs": [],
   "source": [
    "import os\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "\n",
    "df_circuits = pd.read_csv('F1_data/circuits.csv', encoding='latin-1')\n",
    "df_constructors = pd.read_csv('F1_data/constructors.csv', encoding='latin-1')\n",
    "df_constructorResults = pd.read_csv('F1_data/constructorResults.csv', encoding='latin-1')\n",
    "df_constructorStandings = pd.read_csv('F1_data/constructorStandings.csv', encoding='latin-1')\n",
    "df_drivers = pd.read_csv('F1_data/drivers.csv', encoding='latin-1')\n",
    "df_driverStandings = pd.read_csv('F1_data/driverStandings.csv', encoding='latin-1')\n",
    "df_lapTimes = pd.read_csv('F1_data/lapTimes.csv', encoding='latin-1')\n",
    "df_pitStops = pd.read_csv('F1_data/pitStops.csv', encoding='latin-1')\n",
    "df_qualifying = pd.read_csv('F1_data/qualifying.csv', encoding='latin-1')\n",
    "df_races = pd.read_csv('F1_data/races.csv', encoding='latin-1')\n",
    "df_results = pd.read_csv('F1_data/results.csv', encoding='latin-1')\n",
    "df_seasons = pd.read_csv('F1_data/seasons.csv', encoding='latin-1')\n",
    "df_status =  pd.read_csv('F1_data/status.csv', encoding='latin-1')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>raceId</th>\n",
       "      <th>year</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",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>860</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>Australian Grand Prix</td>\n",
       "      <td>18/03/2012</td>\n",
       "      <td>06:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Australian_G...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>861</td>\n",
       "      <td>2012</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>Malaysian Grand Prix</td>\n",
       "      <td>25/03/2012</td>\n",
       "      <td>08:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Malaysian_Gr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>862</td>\n",
       "      <td>2012</td>\n",
       "      <td>3</td>\n",
       "      <td>17</td>\n",
       "      <td>Chinese Grand Prix</td>\n",
       "      <td>15/04/2012</td>\n",
       "      <td>07:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Chinese_Gran...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>863</td>\n",
       "      <td>2012</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>Bahrain Grand Prix</td>\n",
       "      <td>22/04/2012</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Bahrain_Gran...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>864</td>\n",
       "      <td>2012</td>\n",
       "      <td>5</td>\n",
       "      <td>4</td>\n",
       "      <td>Spanish Grand Prix</td>\n",
       "      <td>13/05/2012</td>\n",
       "      <td>12:00:00</td>\n",
       "      <td>http://en.wikipedia.org/wiki/2012_Spanish_Gran...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   raceId  year  round  circuitId                   name        date  \\\n",
       "0     860  2012      1          1  Australian Grand Prix  18/03/2012   \n",
       "1     861  2012      2          2   Malaysian Grand Prix  25/03/2012   \n",
       "2     862  2012      3         17     Chinese Grand Prix  15/04/2012   \n",
       "3     863  2012      4          3     Bahrain Grand Prix  22/04/2012   \n",
       "4     864  2012      5          4     Spanish Grand Prix  13/05/2012   \n",
       "\n",
       "       time                                                url  \n",
       "0  06:00:00  http://en.wikipedia.org/wiki/2012_Australian_G...  \n",
       "1  08:00:00  http://en.wikipedia.org/wiki/2012_Malaysian_Gr...  \n",
       "2  07:00:00  http://en.wikipedia.org/wiki/2012_Chinese_Gran...  \n",
       "3  12:00:00  http://en.wikipedia.org/wiki/2012_Bahrain_Gran...  \n",
       "4  12:00:00  http://en.wikipedia.org/wiki/2012_Spanish_Gran...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_races.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>resultId</th>\n",
       "      <th>raceId</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>21232</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>58</td>\n",
       "      <td>34:09.6</td>\n",
       "      <td>5649565.0</td>\n",
       "      <td>56.0</td>\n",
       "      <td>1</td>\n",
       "      <td>01:29.2</td>\n",
       "      <td>214.053</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>21233</td>\n",
       "      <td>860</td>\n",
       "      <td>20</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>18</td>\n",
       "      <td>58</td>\n",
       "      <td>2.139</td>\n",
       "      <td>5651704.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>2</td>\n",
       "      <td>01:29.4</td>\n",
       "      <td>213.503</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>21234</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>15</td>\n",
       "      <td>58</td>\n",
       "      <td>4.075</td>\n",
       "      <td>5653640.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>4</td>\n",
       "      <td>01:29.5</td>\n",
       "      <td>213.214</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>21235</td>\n",
       "      <td>860</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>12</td>\n",
       "      <td>58</td>\n",
       "      <td>4.547</td>\n",
       "      <td>5654112.0</td>\n",
       "      <td>57.0</td>\n",
       "      <td>3</td>\n",
       "      <td>01:29.4</td>\n",
       "      <td>213.452</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>21236</td>\n",
       "      <td>860</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>5</td>\n",
       "      <td>12</td>\n",
       "      <td>5.0</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>10</td>\n",
       "      <td>58</td>\n",
       "      <td>21.565</td>\n",
       "      <td>5671130.0</td>\n",
       "      <td>52.0</td>\n",
       "      <td>7</td>\n",
       "      <td>01:30.3</td>\n",
       "      <td>211.469</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   resultId  raceId  driverId  constructorId  number  grid  position  \\\n",
       "0     21232     860        18              1       3     2       1.0   \n",
       "1     21233     860        20              9       1     6       2.0   \n",
       "2     21234     860         1              1       4     1       3.0   \n",
       "3     21235     860        17              9       2     5       4.0   \n",
       "4     21236     860         4              6       5    12       5.0   \n",
       "\n",
       "  positionText  positionOrder  points  laps     time  milliseconds  \\\n",
       "0            1              1      25    58  34:09.6     5649565.0   \n",
       "1            2              2      18    58    2.139     5651704.0   \n",
       "2            3              3      15    58    4.075     5653640.0   \n",
       "3            4              4      12    58    4.547     5654112.0   \n",
       "4            5              5      10    58   21.565     5671130.0   \n",
       "\n",
       "   fastestLap  rank fastestLapTime fastestLapSpeed  statusId  \n",
       "0        56.0     1        01:29.2         214.053         1  \n",
       "1        57.0     2        01:29.4         213.503         1  \n",
       "2        57.0     4        01:29.5         213.214         1  \n",
       "3        57.0     3        01:29.4         213.452         1  \n",
       "4        52.0     7        01:30.3         211.469         1  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_results.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "circuitId       int64\n",
       "circuitRef     object\n",
       "name           object\n",
       "location       object\n",
       "country        object\n",
       "lat           float64\n",
       "lng           float64\n",
       "alt           float64\n",
       "url            object\n",
       "dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_circuits.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>circuitId</th>\n",
       "      <th>circuitRef</th>\n",
       "      <th>name</th>\n",
       "      <th>location</th>\n",
       "      <th>country</th>\n",
       "      <th>lat</th>\n",
       "      <th>lng</th>\n",
       "      <th>alt</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</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.84970</td>\n",
       "      <td>144.968000</td>\n",
       "      <td>10.0</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Melbourne_Grand_P...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>sepang</td>\n",
       "      <td>Sepang International Circuit</td>\n",
       "      <td>Kuala Lumpur</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>2.76083</td>\n",
       "      <td>101.738000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Sepang_Internatio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>bahrain</td>\n",
       "      <td>Bahrain International Circuit</td>\n",
       "      <td>Sakhir</td>\n",
       "      <td>Bahrain</td>\n",
       "      <td>26.03250</td>\n",
       "      <td>50.510600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Bahrain_Internati...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>catalunya</td>\n",
       "      <td>Circuit de Barcelona-Catalunya</td>\n",
       "      <td>Montmeló</td>\n",
       "      <td>Spain</td>\n",
       "      <td>41.57000</td>\n",
       "      <td>2.261110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Circuit_de_Barcel...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>6</td>\n",
       "      <td>monaco</td>\n",
       "      <td>Circuit de Monaco</td>\n",
       "      <td>Monte-Carlo</td>\n",
       "      <td>Monaco</td>\n",
       "      <td>43.73470</td>\n",
       "      <td>7.420560</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Circuit_de_Monaco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>7</td>\n",
       "      <td>villeneuve</td>\n",
       "      <td>Circuit Gilles Villeneuve</td>\n",
       "      <td>Montreal</td>\n",
       "      <td>Canada</td>\n",
       "      <td>45.50000</td>\n",
       "      <td>-73.522800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Circuit_Gilles_Vi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>9</td>\n",
       "      <td>silverstone</td>\n",
       "      <td>Silverstone Circuit</td>\n",
       "      <td>Silverstone</td>\n",
       "      <td>UK</td>\n",
       "      <td>52.07860</td>\n",
       "      <td>-1.016940</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Silverstone_Circuit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>10</td>\n",
       "      <td>hockenheimring</td>\n",
       "      <td>Hockenheimring</td>\n",
       "      <td>Hockenheim</td>\n",
       "      <td>Germany</td>\n",
       "      <td>49.32780</td>\n",
       "      <td>8.565830</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Hockenheimring</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>11</td>\n",
       "      <td>hungaroring</td>\n",
       "      <td>Hungaroring</td>\n",
       "      <td>Budapest</td>\n",
       "      <td>Hungary</td>\n",
       "      <td>47.57890</td>\n",
       "      <td>19.248600</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Hungaroring</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>12</td>\n",
       "      <td>valencia</td>\n",
       "      <td>Valencia Street Circuit</td>\n",
       "      <td>Valencia</td>\n",
       "      <td>Spain</td>\n",
       "      <td>39.45890</td>\n",
       "      <td>-0.331667</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Valencia_Street_C...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>13</td>\n",
       "      <td>spa</td>\n",
       "      <td>Circuit de Spa-Francorchamps</td>\n",
       "      <td>Spa</td>\n",
       "      <td>Belgium</td>\n",
       "      <td>50.43720</td>\n",
       "      <td>5.971390</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Circuit_de_Spa-Fr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>14</td>\n",
       "      <td>monza</td>\n",
       "      <td>Autodromo Nazionale di Monza</td>\n",
       "      <td>Monza</td>\n",
       "      <td>Italy</td>\n",
       "      <td>45.61560</td>\n",
       "      <td>9.281110</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Autodromo_Naziona...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>15</td>\n",
       "      <td>marina_bay</td>\n",
       "      <td>Marina Bay Street Circuit</td>\n",
       "      <td>Marina Bay</td>\n",
       "      <td>Singapore</td>\n",
       "      <td>1.29140</td>\n",
       "      <td>103.864000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Marina_Bay_Street...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>17</td>\n",
       "      <td>shanghai</td>\n",
       "      <td>Shanghai International Circuit</td>\n",
       "      <td>Shanghai</td>\n",
       "      <td>China</td>\n",
       "      <td>31.33890</td>\n",
       "      <td>121.220000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Shanghai_Internat...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>18</td>\n",
       "      <td>interlagos</td>\n",
       "      <td>AutÌ_dromo JosÌ© Carlos Pace</td>\n",
       "      <td>SÌ£o Paulo</td>\n",
       "      <td>Brazil</td>\n",
       "      <td>-23.70360</td>\n",
       "      <td>-46.699700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Aut%C3%B3dromo_Jo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>20</td>\n",
       "      <td>nurburgring</td>\n",
       "      <td>NÌ_rburgring</td>\n",
       "      <td>NÌ_rburg</td>\n",
       "      <td>Germany</td>\n",
       "      <td>50.33560</td>\n",
       "      <td>6.947500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/N%C3%BCrburgring</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>22</td>\n",
       "      <td>suzuka</td>\n",
       "      <td>Suzuka Circuit</td>\n",
       "      <td>Suzuka</td>\n",
       "      <td>Japan</td>\n",
       "      <td>34.84310</td>\n",
       "      <td>136.541000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Suzuka_Circuit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>24</td>\n",
       "      <td>yas_marina</td>\n",
       "      <td>Yas Marina Circuit</td>\n",
       "      <td>Abu Dhabi</td>\n",
       "      <td>UAE</td>\n",
       "      <td>24.46720</td>\n",
       "      <td>54.603100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Yas_Marina_Circuit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>32</td>\n",
       "      <td>rodriguez</td>\n",
       "      <td>AutÌ_dromo Hermanos RodrÌ_guez</td>\n",
       "      <td>Mexico City</td>\n",
       "      <td>Mexico</td>\n",
       "      <td>19.40420</td>\n",
       "      <td>-99.090700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Aut%C3%B3dromo_He...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>35</td>\n",
       "      <td>yeongam</td>\n",
       "      <td>Korean International Circuit</td>\n",
       "      <td>Yeongam County</td>\n",
       "      <td>Korea</td>\n",
       "      <td>34.73330</td>\n",
       "      <td>126.417000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Korean_Internatio...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>68</td>\n",
       "      <td>buddh</td>\n",
       "      <td>Buddh International Circuit</td>\n",
       "      <td>Uttar Pradesh</td>\n",
       "      <td>India</td>\n",
       "      <td>28.34870</td>\n",
       "      <td>77.533100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Buddh_Internation...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>69</td>\n",
       "      <td>americas</td>\n",
       "      <td>Circuit of the Americas</td>\n",
       "      <td>Austin</td>\n",
       "      <td>USA</td>\n",
       "      <td>30.13280</td>\n",
       "      <td>-97.641100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Circuit_of_the_Am...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>70</td>\n",
       "      <td>red_bull_ring</td>\n",
       "      <td>Red Bull Ring</td>\n",
       "      <td>Spielburg</td>\n",
       "      <td>Austria</td>\n",
       "      <td>47.21970</td>\n",
       "      <td>14.764700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Red_Bull_Ring</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>71</td>\n",
       "      <td>sochi</td>\n",
       "      <td>Sochi Autodrom</td>\n",
       "      <td>Sochi</td>\n",
       "      <td>Russia</td>\n",
       "      <td>43.40570</td>\n",
       "      <td>39.957800</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Sochi_Autodrom</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>73</td>\n",
       "      <td>BAK</td>\n",
       "      <td>Baku City Circuit</td>\n",
       "      <td>Baku</td>\n",
       "      <td>Azerbaijan</td>\n",
       "      <td>40.37250</td>\n",
       "      <td>49.853300</td>\n",
       "      <td>NaN</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Baku_City_Circuit</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    circuitId      circuitRef                            name        location  \\\n",
       "0           1     albert_park  Albert Park Grand Prix Circuit       Melbourne   \n",
       "1           2          sepang    Sepang International Circuit    Kuala Lumpur   \n",
       "2           3         bahrain   Bahrain International Circuit          Sakhir   \n",
       "3           4       catalunya  Circuit de Barcelona-Catalunya        Montmeló   \n",
       "4           6          monaco               Circuit de Monaco     Monte-Carlo   \n",
       "5           7      villeneuve       Circuit Gilles Villeneuve        Montreal   \n",
       "6           9     silverstone             Silverstone Circuit     Silverstone   \n",
       "7          10  hockenheimring                  Hockenheimring      Hockenheim   \n",
       "8          11     hungaroring                     Hungaroring        Budapest   \n",
       "9          12        valencia         Valencia Street Circuit        Valencia   \n",
       "10         13             spa    Circuit de Spa-Francorchamps             Spa   \n",
       "11         14           monza    Autodromo Nazionale di Monza           Monza   \n",
       "12         15      marina_bay       Marina Bay Street Circuit      Marina Bay   \n",
       "13         17        shanghai  Shanghai International Circuit        Shanghai   \n",
       "14         18      interlagos    AutÌ_dromo JosÌ© Carlos Pace      SÌ£o Paulo   \n",
       "15         20     nurburgring                    NÌ_rburgring        NÌ_rburg   \n",
       "16         22          suzuka                  Suzuka Circuit          Suzuka   \n",
       "17         24      yas_marina              Yas Marina Circuit       Abu Dhabi   \n",
       "18         32       rodriguez  AutÌ_dromo Hermanos RodrÌ_guez     Mexico City   \n",
       "19         35         yeongam    Korean International Circuit  Yeongam County   \n",
       "20         68           buddh     Buddh International Circuit   Uttar Pradesh   \n",
       "21         69        americas         Circuit of the Americas          Austin   \n",
       "22         70   red_bull_ring                   Red Bull Ring       Spielburg   \n",
       "23         71           sochi                  Sochi Autodrom           Sochi   \n",
       "24         73             BAK               Baku City Circuit            Baku   \n",
       "\n",
       "       country       lat         lng   alt  \\\n",
       "0    Australia -37.84970  144.968000  10.0   \n",
       "1     Malaysia   2.76083  101.738000   NaN   \n",
       "2      Bahrain  26.03250   50.510600   NaN   \n",
       "3        Spain  41.57000    2.261110   NaN   \n",
       "4       Monaco  43.73470    7.420560   NaN   \n",
       "5       Canada  45.50000  -73.522800   NaN   \n",
       "6           UK  52.07860   -1.016940   NaN   \n",
       "7      Germany  49.32780    8.565830   NaN   \n",
       "8      Hungary  47.57890   19.248600   NaN   \n",
       "9        Spain  39.45890   -0.331667   NaN   \n",
       "10     Belgium  50.43720    5.971390   NaN   \n",
       "11       Italy  45.61560    9.281110   NaN   \n",
       "12   Singapore   1.29140  103.864000   NaN   \n",
       "13       China  31.33890  121.220000   NaN   \n",
       "14      Brazil -23.70360  -46.699700   NaN   \n",
       "15     Germany  50.33560    6.947500   NaN   \n",
       "16       Japan  34.84310  136.541000   NaN   \n",
       "17         UAE  24.46720   54.603100   NaN   \n",
       "18      Mexico  19.40420  -99.090700   NaN   \n",
       "19       Korea  34.73330  126.417000   NaN   \n",
       "20       India  28.34870   77.533100   NaN   \n",
       "21         USA  30.13280  -97.641100   NaN   \n",
       "22     Austria  47.21970   14.764700   NaN   \n",
       "23      Russia  43.40570   39.957800   NaN   \n",
       "24  Azerbaijan  40.37250   49.853300   NaN   \n",
       "\n",
       "                                                  url  \n",
       "0   http://en.wikipedia.org/wiki/Melbourne_Grand_P...  \n",
       "1   http://en.wikipedia.org/wiki/Sepang_Internatio...  \n",
       "2   http://en.wikipedia.org/wiki/Bahrain_Internati...  \n",
       "3   http://en.wikipedia.org/wiki/Circuit_de_Barcel...  \n",
       "4      http://en.wikipedia.org/wiki/Circuit_de_Monaco  \n",
       "5   http://en.wikipedia.org/wiki/Circuit_Gilles_Vi...  \n",
       "6    http://en.wikipedia.org/wiki/Silverstone_Circuit  \n",
       "7         http://en.wikipedia.org/wiki/Hockenheimring  \n",
       "8            http://en.wikipedia.org/wiki/Hungaroring  \n",
       "9   http://en.wikipedia.org/wiki/Valencia_Street_C...  \n",
       "10  http://en.wikipedia.org/wiki/Circuit_de_Spa-Fr...  \n",
       "11  http://en.wikipedia.org/wiki/Autodromo_Naziona...  \n",
       "12  http://en.wikipedia.org/wiki/Marina_Bay_Street...  \n",
       "13  http://en.wikipedia.org/wiki/Shanghai_Internat...  \n",
       "14  http://en.wikipedia.org/wiki/Aut%C3%B3dromo_Jo...  \n",
       "15      http://en.wikipedia.org/wiki/N%C3%BCrburgring  \n",
       "16        http://en.wikipedia.org/wiki/Suzuka_Circuit  \n",
       "17    http://en.wikipedia.org/wiki/Yas_Marina_Circuit  \n",
       "18  http://en.wikipedia.org/wiki/Aut%C3%B3dromo_He...  \n",
       "19  http://en.wikipedia.org/wiki/Korean_Internatio...  \n",
       "20  http://en.wikipedia.org/wiki/Buddh_Internation...  \n",
       "21  http://en.wikipedia.org/wiki/Circuit_of_the_Am...  \n",
       "22         http://en.wikipedia.org/wiki/Red_Bull_Ring  \n",
       "23        http://en.wikipedia.org/wiki/Sochi_Autodrom  \n",
       "24     http://en.wikipedia.org/wiki/Baku_City_Circuit  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_circuits"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "constructorId      int64\n",
       "constructorRef    object\n",
       "name              object\n",
       "nationality       object\n",
       "url               object\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_constructors.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "constructorResultsId    int64\n",
       "raceId                  int64\n",
       "constructorId           int64\n",
       "points                  int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_constructorResults.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "constructorStandingsId    int64\n",
       "raceId                    int64\n",
       "constructorId             int64\n",
       "points                    int64\n",
       "position                  int64\n",
       "positionText              int64\n",
       "wins                      int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_constructorStandings.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>driverId</th>\n",
       "      <th>driverRef</th>\n",
       "      <th>number</th>\n",
       "      <th>code</th>\n",
       "      <th>forename</th>\n",
       "      <th>surname</th>\n",
       "      <th>dob</th>\n",
       "      <th>nationality</th>\n",
       "      <th>url</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>hamilton</td>\n",
       "      <td>44</td>\n",
       "      <td>HAM</td>\n",
       "      <td>Lewis</td>\n",
       "      <td>Hamilton</td>\n",
       "      <td>07/01/1985</td>\n",
       "      <td>British</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Lewis_Hamilton</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>18</td>\n",
       "      <td>button</td>\n",
       "      <td>22</td>\n",
       "      <td>BUT</td>\n",
       "      <td>Jenson</td>\n",
       "      <td>Button</td>\n",
       "      <td>19/01/1980</td>\n",
       "      <td>British</td>\n",
       "      <td>http://en.wikipedia.org/wiki/Jenson_Button</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   driverId driverRef  number code forename   surname         dob nationality  \\\n",
       "0         1  hamilton      44  HAM    Lewis  Hamilton  07/01/1985     British   \n",
       "1        18    button      22  BUT   Jenson    Button  19/01/1980     British   \n",
       "\n",
       "                                           url  \n",
       "0  http://en.wikipedia.org/wiki/Lewis_Hamilton  \n",
       "1   http://en.wikipedia.org/wiki/Jenson_Button  "
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_drivers"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "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>driverStandingsId</th>\n",
       "      <th>raceId</th>\n",
       "      <th>driverId</th>\n",
       "      <th>points</th>\n",
       "      <th>position</th>\n",
       "      <th>positionText</th>\n",
       "      <th>wins</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>64999</td>\n",
       "      <td>860</td>\n",
       "      <td>39</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>64997</td>\n",
       "      <td>860</td>\n",
       "      <td>807</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>64995</td>\n",
       "      <td>860</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>64993</td>\n",
       "      <td>860</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>64991</td>\n",
       "      <td>860</td>\n",
       "      <td>811</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>64989</td>\n",
       "      <td>860</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>64987</td>\n",
       "      <td>860</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>64998</td>\n",
       "      <td>860</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>64996</td>\n",
       "      <td>860</td>\n",
       "      <td>154</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>64994</td>\n",
       "      <td>860</td>\n",
       "      <td>808</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>64992</td>\n",
       "      <td>860</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>64990</td>\n",
       "      <td>860</td>\n",
       "      <td>819</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>64988</td>\n",
       "      <td>860</td>\n",
       "      <td>813</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>64986</td>\n",
       "      <td>860</td>\n",
       "      <td>818</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>64985</td>\n",
       "      <td>860</td>\n",
       "      <td>814</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>64984</td>\n",
       "      <td>860</td>\n",
       "      <td>817</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>64983</td>\n",
       "      <td>860</td>\n",
       "      <td>815</td>\n",
       "      <td>4</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>64982</td>\n",
       "      <td>860</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>64981</td>\n",
       "      <td>860</td>\n",
       "      <td>155</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>64980</td>\n",
       "      <td>860</td>\n",
       "      <td>4</td>\n",
       "      <td>10</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>64979</td>\n",
       "      <td>860</td>\n",
       "      <td>17</td>\n",
       "      <td>12</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>64978</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>64977</td>\n",
       "      <td>860</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>64976</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>64928</td>\n",
       "      <td>861</td>\n",
       "      <td>18</td>\n",
       "      <td>25</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>64929</td>\n",
       "      <td>861</td>\n",
       "      <td>20</td>\n",
       "      <td>18</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>64930</td>\n",
       "      <td>861</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>64931</td>\n",
       "      <td>861</td>\n",
       "      <td>17</td>\n",
       "      <td>24</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>64932</td>\n",
       "      <td>861</td>\n",
       "      <td>4</td>\n",
       "      <td>35</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>64933</td>\n",
       "      <td>861</td>\n",
       "      <td>155</td>\n",
       "      <td>8</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2652</th>\n",
       "      <td>68579</td>\n",
       "      <td>987</td>\n",
       "      <td>836</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2653</th>\n",
       "      <td>68580</td>\n",
       "      <td>987</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2654</th>\n",
       "      <td>68581</td>\n",
       "      <td>987</td>\n",
       "      <td>814</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2655</th>\n",
       "      <td>68582</td>\n",
       "      <td>987</td>\n",
       "      <td>842</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2656</th>\n",
       "      <td>68583</td>\n",
       "      <td>987</td>\n",
       "      <td>843</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2657</th>\n",
       "      <td>68584</td>\n",
       "      <td>988</td>\n",
       "      <td>20</td>\n",
       "      <td>317</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2658</th>\n",
       "      <td>68585</td>\n",
       "      <td>988</td>\n",
       "      <td>1</td>\n",
       "      <td>363</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2659</th>\n",
       "      <td>68586</td>\n",
       "      <td>988</td>\n",
       "      <td>822</td>\n",
       "      <td>305</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2660</th>\n",
       "      <td>68587</td>\n",
       "      <td>988</td>\n",
       "      <td>8</td>\n",
       "      <td>205</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2661</th>\n",
       "      <td>68588</td>\n",
       "      <td>988</td>\n",
       "      <td>830</td>\n",
       "      <td>168</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2662</th>\n",
       "      <td>68589</td>\n",
       "      <td>988</td>\n",
       "      <td>13</td>\n",
       "      <td>43</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2663</th>\n",
       "      <td>68590</td>\n",
       "      <td>988</td>\n",
       "      <td>815</td>\n",
       "      <td>100</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2664</th>\n",
       "      <td>68591</td>\n",
       "      <td>988</td>\n",
       "      <td>832</td>\n",
       "      <td>54</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2665</th>\n",
       "      <td>68592</td>\n",
       "      <td>988</td>\n",
       "      <td>826</td>\n",
       "      <td>5</td>\n",
       "      <td>19</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2666</th>\n",
       "      <td>68593</td>\n",
       "      <td>988</td>\n",
       "      <td>839</td>\n",
       "      <td>87</td>\n",
       "      <td>8</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2667</th>\n",
       "      <td>68594</td>\n",
       "      <td>988</td>\n",
       "      <td>807</td>\n",
       "      <td>43</td>\n",
       "      <td>10</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2668</th>\n",
       "      <td>68595</td>\n",
       "      <td>988</td>\n",
       "      <td>841</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2669</th>\n",
       "      <td>68596</td>\n",
       "      <td>988</td>\n",
       "      <td>838</td>\n",
       "      <td>13</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2670</th>\n",
       "      <td>68597</td>\n",
       "      <td>988</td>\n",
       "      <td>4</td>\n",
       "      <td>17</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2671</th>\n",
       "      <td>68598</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>19</td>\n",
       "      <td>14</td>\n",
       "      <td>14</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2672</th>\n",
       "      <td>68599</td>\n",
       "      <td>988</td>\n",
       "      <td>840</td>\n",
       "      <td>40</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2673</th>\n",
       "      <td>68600</td>\n",
       "      <td>988</td>\n",
       "      <td>817</td>\n",
       "      <td>200</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2674</th>\n",
       "      <td>68601</td>\n",
       "      <td>988</td>\n",
       "      <td>828</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2675</th>\n",
       "      <td>68602</td>\n",
       "      <td>988</td>\n",
       "      <td>835</td>\n",
       "      <td>8</td>\n",
       "      <td>17</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2676</th>\n",
       "      <td>68603</td>\n",
       "      <td>988</td>\n",
       "      <td>154</td>\n",
       "      <td>28</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2677</th>\n",
       "      <td>68604</td>\n",
       "      <td>988</td>\n",
       "      <td>836</td>\n",
       "      <td>5</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2678</th>\n",
       "      <td>68605</td>\n",
       "      <td>988</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2679</th>\n",
       "      <td>68606</td>\n",
       "      <td>988</td>\n",
       "      <td>814</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2680</th>\n",
       "      <td>68607</td>\n",
       "      <td>988</td>\n",
       "      <td>842</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2681</th>\n",
       "      <td>68608</td>\n",
       "      <td>988</td>\n",
       "      <td>843</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2682 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      driverStandingsId  raceId  driverId  points  position  positionText  \\\n",
       "0                 64999     860        39       0        24            24   \n",
       "1                 64997     860       807       0        22            22   \n",
       "2                 64995     860        30       0        20            20   \n",
       "3                 64993     860         5       0        18            18   \n",
       "4                 64991     860       811       0        16            16   \n",
       "5                 64989     860        10       0        14            14   \n",
       "6                 64987     860         3       0        12            12   \n",
       "7                 64998     860        37       0        23            23   \n",
       "8                 64996     860       154       0        21            21   \n",
       "9                 64994     860       808       0        19            19   \n",
       "10                64992     860        13       0        17            17   \n",
       "11                64990     860       819       0        15            15   \n",
       "12                64988     860       813       0        13            13   \n",
       "13                64986     860       818       0        11            11   \n",
       "14                64985     860       814       1        10            10   \n",
       "15                64984     860       817       2         9             9   \n",
       "16                64983     860       815       4         8             8   \n",
       "17                64982     860         8       6         7             7   \n",
       "18                64981     860       155       8         6             6   \n",
       "19                64980     860         4      10         5             5   \n",
       "20                64979     860        17      12         4             4   \n",
       "21                64978     860         1      15         3             3   \n",
       "22                64977     860        20      18         2             2   \n",
       "23                64976     860        18      25         1             1   \n",
       "24                64928     861        18      25         3             3   \n",
       "25                64929     861        20      18         6             6   \n",
       "26                64930     861         1      30         2             2   \n",
       "27                64931     861        17      24         4             4   \n",
       "28                64932     861         4      35         1             1   \n",
       "29                64933     861       155       8         9             9   \n",
       "...                 ...     ...       ...     ...       ...           ...   \n",
       "2652              68579     987       836       5        18            18   \n",
       "2653              68580     987        18       0        24            24   \n",
       "2654              68581     987       814       0        25            25   \n",
       "2655              68582     987       842       0        21            21   \n",
       "2656              68583     987       843       0        23            23   \n",
       "2657              68584     988        20     317         2             2   \n",
       "2658              68585     988         1     363         1             1   \n",
       "2659              68586     988       822     305         3             3   \n",
       "2660              68587     988         8     205         4             4   \n",
       "2661              68588     988       830     168         6             6   \n",
       "2662              68589     988        13      43        11            11   \n",
       "2663              68590     988       815     100         7             7   \n",
       "2664              68591     988       832      54         9             9   \n",
       "2665              68592     988       826       5        19            19   \n",
       "2666              68593     988       839      87         8             8   \n",
       "2667              68594     988       807      43        10            10   \n",
       "2668              68595     988       841       0        22            22   \n",
       "2669              68596     988       838      13        16            16   \n",
       "2670              68597     988         4      17        15            15   \n",
       "2671              68598     988       825      19        14            14   \n",
       "2672              68599     988       840      40        12            12   \n",
       "2673              68600     988       817     200         5             5   \n",
       "2674              68601     988       828       0        20            20   \n",
       "2675              68602     988       835       8        17            17   \n",
       "2676              68603     988       154      28        13            13   \n",
       "2677              68604     988       836       5        18            18   \n",
       "2678              68605     988        18       0        24            24   \n",
       "2679              68606     988       814       0        25            25   \n",
       "2680              68607     988       842       0        21            21   \n",
       "2681              68608     988       843       0        23            23   \n",
       "\n",
       "      wins  \n",
       "0        0  \n",
       "1        0  \n",
       "2        0  \n",
       "3        0  \n",
       "4        0  \n",
       "5        0  \n",
       "6        0  \n",
       "7        0  \n",
       "8        0  \n",
       "9        0  \n",
       "10       0  \n",
       "11       0  \n",
       "12       0  \n",
       "13       0  \n",
       "14       0  \n",
       "15       0  \n",
       "16       0  \n",
       "17       0  \n",
       "18       0  \n",
       "19       0  \n",
       "20       0  \n",
       "21       0  \n",
       "22       0  \n",
       "23       1  \n",
       "24       1  \n",
       "25       0  \n",
       "26       0  \n",
       "27       0  \n",
       "28       1  \n",
       "29       0  \n",
       "...    ...  \n",
       "2652     0  \n",
       "2653     0  \n",
       "2654     0  \n",
       "2655     0  \n",
       "2656     0  \n",
       "2657     5  \n",
       "2658     9  \n",
       "2659     3  \n",
       "2660     0  \n",
       "2661     2  \n",
       "2662     0  \n",
       "2663     0  \n",
       "2664     0  \n",
       "2665     0  \n",
       "2666     0  \n",
       "2667     0  \n",
       "2668     0  \n",
       "2669     0  \n",
       "2670     0  \n",
       "2671     0  \n",
       "2672     0  \n",
       "2673     1  \n",
       "2674     0  \n",
       "2675     0  \n",
       "2676     0  \n",
       "2677     0  \n",
       "2678     0  \n",
       "2679     0  \n",
       "2680     0  \n",
       "2681     0  \n",
       "\n",
       "[2682 rows x 7 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_driverStandings"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>lapTimeId</th>\n",
       "      <th>raceId</th>\n",
       "      <th>driverId</th>\n",
       "      <th>lap</th>\n",
       "      <th>position</th>\n",
       "      <th>time</th>\n",
       "      <th>milliseconds</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>99264</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>93414</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>93350</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>93131</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>92984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "      <td>93117</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>93244</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>8</td>\n",
       "      <td>1</td>\n",
       "      <td>8</td>\n",
       "      <td>93124</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>9</td>\n",
       "      <td>1</td>\n",
       "      <td>9</td>\n",
       "      <td>93394</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>93767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>11</td>\n",
       "      <td>1</td>\n",
       "      <td>11</td>\n",
       "      <td>93985</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>12</td>\n",
       "      <td>93628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>13</td>\n",
       "      <td>1</td>\n",
       "      <td>13</td>\n",
       "      <td>93970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>14</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>94164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>15</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>94645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>16</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>114021</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>99358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>18</td>\n",
       "      <td>93348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>93300</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>92880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>21</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>92903</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>22</td>\n",
       "      <td>93141</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>92840</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>24</td>\n",
       "      <td>1</td>\n",
       "      <td>24</td>\n",
       "      <td>92701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>25</td>\n",
       "      <td>1</td>\n",
       "      <td>25</td>\n",
       "      <td>92760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>26</td>\n",
       "      <td>1</td>\n",
       "      <td>26</td>\n",
       "      <td>92152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>27</td>\n",
       "      <td>1</td>\n",
       "      <td>27</td>\n",
       "      <td>91943</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>28</td>\n",
       "      <td>1</td>\n",
       "      <td>28</td>\n",
       "      <td>91788</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>29</td>\n",
       "      <td>1</td>\n",
       "      <td>29</td>\n",
       "      <td>91813</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>30</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>91812</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133788</th>\n",
       "      <td>133789</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>25</td>\n",
       "      <td>19</td>\n",
       "      <td>133789</td>\n",
       "      <td>104785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133789</th>\n",
       "      <td>133790</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>26</td>\n",
       "      <td>19</td>\n",
       "      <td>133790</td>\n",
       "      <td>104990</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133790</th>\n",
       "      <td>133791</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>27</td>\n",
       "      <td>18</td>\n",
       "      <td>133791</td>\n",
       "      <td>104948</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133791</th>\n",
       "      <td>133792</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>28</td>\n",
       "      <td>18</td>\n",
       "      <td>133792</td>\n",
       "      <td>107108</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133792</th>\n",
       "      <td>133793</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>29</td>\n",
       "      <td>17</td>\n",
       "      <td>133793</td>\n",
       "      <td>105242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133793</th>\n",
       "      <td>133794</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>30</td>\n",
       "      <td>16</td>\n",
       "      <td>133794</td>\n",
       "      <td>104898</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133794</th>\n",
       "      <td>133795</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>31</td>\n",
       "      <td>14</td>\n",
       "      <td>133795</td>\n",
       "      <td>105060</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133795</th>\n",
       "      <td>133796</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>32</td>\n",
       "      <td>13</td>\n",
       "      <td>133796</td>\n",
       "      <td>104541</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133796</th>\n",
       "      <td>133797</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>33</td>\n",
       "      <td>13</td>\n",
       "      <td>133797</td>\n",
       "      <td>104706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133797</th>\n",
       "      <td>133798</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>34</td>\n",
       "      <td>13</td>\n",
       "      <td>133798</td>\n",
       "      <td>107157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133798</th>\n",
       "      <td>133799</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>35</td>\n",
       "      <td>13</td>\n",
       "      <td>133799</td>\n",
       "      <td>104641</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133799</th>\n",
       "      <td>133800</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>36</td>\n",
       "      <td>13</td>\n",
       "      <td>133800</td>\n",
       "      <td>104755</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133800</th>\n",
       "      <td>133801</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>37</td>\n",
       "      <td>13</td>\n",
       "      <td>133801</td>\n",
       "      <td>104395</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133801</th>\n",
       "      <td>133802</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>38</td>\n",
       "      <td>13</td>\n",
       "      <td>133802</td>\n",
       "      <td>104497</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133802</th>\n",
       "      <td>133803</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>39</td>\n",
       "      <td>13</td>\n",
       "      <td>133803</td>\n",
       "      <td>106834</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133803</th>\n",
       "      <td>133804</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>40</td>\n",
       "      <td>13</td>\n",
       "      <td>133804</td>\n",
       "      <td>107053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133804</th>\n",
       "      <td>133805</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>41</td>\n",
       "      <td>13</td>\n",
       "      <td>133805</td>\n",
       "      <td>104368</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133805</th>\n",
       "      <td>133806</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>42</td>\n",
       "      <td>13</td>\n",
       "      <td>133806</td>\n",
       "      <td>104266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133806</th>\n",
       "      <td>133807</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>43</td>\n",
       "      <td>13</td>\n",
       "      <td>133807</td>\n",
       "      <td>104196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133807</th>\n",
       "      <td>133808</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>44</td>\n",
       "      <td>13</td>\n",
       "      <td>133808</td>\n",
       "      <td>104280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133808</th>\n",
       "      <td>133809</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>45</td>\n",
       "      <td>13</td>\n",
       "      <td>133809</td>\n",
       "      <td>104781</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133809</th>\n",
       "      <td>133810</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>46</td>\n",
       "      <td>13</td>\n",
       "      <td>133810</td>\n",
       "      <td>104348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133810</th>\n",
       "      <td>133811</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>47</td>\n",
       "      <td>13</td>\n",
       "      <td>133811</td>\n",
       "      <td>104038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133811</th>\n",
       "      <td>133812</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>48</td>\n",
       "      <td>13</td>\n",
       "      <td>133812</td>\n",
       "      <td>104303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133812</th>\n",
       "      <td>133813</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>49</td>\n",
       "      <td>13</td>\n",
       "      <td>133813</td>\n",
       "      <td>104171</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133813</th>\n",
       "      <td>133814</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>50</td>\n",
       "      <td>13</td>\n",
       "      <td>133814</td>\n",
       "      <td>103928</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133814</th>\n",
       "      <td>133815</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>51</td>\n",
       "      <td>13</td>\n",
       "      <td>133815</td>\n",
       "      <td>104138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133815</th>\n",
       "      <td>133816</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>52</td>\n",
       "      <td>13</td>\n",
       "      <td>133816</td>\n",
       "      <td>103934</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133816</th>\n",
       "      <td>133817</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>53</td>\n",
       "      <td>13</td>\n",
       "      <td>133817</td>\n",
       "      <td>104164</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133817</th>\n",
       "      <td>133818</td>\n",
       "      <td>988</td>\n",
       "      <td>825</td>\n",
       "      <td>54</td>\n",
       "      <td>13</td>\n",
       "      <td>133818</td>\n",
       "      <td>104285</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>133818 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        lapTimeId  raceId  driverId  lap  position    time  milliseconds\n",
       "0               1     860        18    1         1       1         99264\n",
       "1               2     860        18    2         1       2         93414\n",
       "2               3     860        18    3         1       3         93350\n",
       "3               4     860        18    4         1       4         93131\n",
       "4               5     860        18    5         1       5         92984\n",
       "5               6     860        18    6         1       6         93117\n",
       "6               7     860        18    7         1       7         93244\n",
       "7               8     860        18    8         1       8         93124\n",
       "8               9     860        18    9         1       9         93394\n",
       "9              10     860        18   10         1      10         93767\n",
       "10             11     860        18   11         1      11         93985\n",
       "11             12     860        18   12         1      12         93628\n",
       "12             13     860        18   13         1      13         93970\n",
       "13             14     860        18   14         1      14         94164\n",
       "14             15     860        18   15         1      15         94645\n",
       "15             16     860        18   16         2      16        114021\n",
       "16             17     860        18   17         1      17         99358\n",
       "17             18     860        18   18         1      18         93348\n",
       "18             19     860        18   19         1      19         93300\n",
       "19             20     860        18   20         1      20         92880\n",
       "20             21     860        18   21         1      21         92903\n",
       "21             22     860        18   22         1      22         93141\n",
       "22             23     860        18   23         1      23         92840\n",
       "23             24     860        18   24         1      24         92701\n",
       "24             25     860        18   25         1      25         92760\n",
       "25             26     860        18   26         1      26         92152\n",
       "26             27     860        18   27         1      27         91943\n",
       "27             28     860        18   28         1      28         91788\n",
       "28             29     860        18   29         1      29         91813\n",
       "29             30     860        18   30         1      30         91812\n",
       "...           ...     ...       ...  ...       ...     ...           ...\n",
       "133788     133789     988       825   25        19  133789        104785\n",
       "133789     133790     988       825   26        19  133790        104990\n",
       "133790     133791     988       825   27        18  133791        104948\n",
       "133791     133792     988       825   28        18  133792        107108\n",
       "133792     133793     988       825   29        17  133793        105242\n",
       "133793     133794     988       825   30        16  133794        104898\n",
       "133794     133795     988       825   31        14  133795        105060\n",
       "133795     133796     988       825   32        13  133796        104541\n",
       "133796     133797     988       825   33        13  133797        104706\n",
       "133797     133798     988       825   34        13  133798        107157\n",
       "133798     133799     988       825   35        13  133799        104641\n",
       "133799     133800     988       825   36        13  133800        104755\n",
       "133800     133801     988       825   37        13  133801        104395\n",
       "133801     133802     988       825   38        13  133802        104497\n",
       "133802     133803     988       825   39        13  133803        106834\n",
       "133803     133804     988       825   40        13  133804        107053\n",
       "133804     133805     988       825   41        13  133805        104368\n",
       "133805     133806     988       825   42        13  133806        104266\n",
       "133806     133807     988       825   43        13  133807        104196\n",
       "133807     133808     988       825   44        13  133808        104280\n",
       "133808     133809     988       825   45        13  133809        104781\n",
       "133809     133810     988       825   46        13  133810        104348\n",
       "133810     133811     988       825   47        13  133811        104038\n",
       "133811     133812     988       825   48        13  133812        104303\n",
       "133812     133813     988       825   49        13  133813        104171\n",
       "133813     133814     988       825   50        13  133814        103928\n",
       "133814     133815     988       825   51        13  133815        104138\n",
       "133815     133816     988       825   52        13  133816        103934\n",
       "133816     133817     988       825   53        13  133817        104164\n",
       "133817     133818     988       825   54        13  133818        104285\n",
       "\n",
       "[133818 rows x 7 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_lapTimes['time'] = df_lapTimes\n",
    "df_lapTimes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "pitStopId         int64\n",
       "raceId            int64\n",
       "driverId          int64\n",
       "stop              int64\n",
       "lap               int64\n",
       "time             object\n",
       "duration        float64\n",
       "milliseconds      int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pitStops.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>pitStopId</th>\n",
       "      <th>raceId</th>\n",
       "      <th>driverId</th>\n",
       "      <th>stop</th>\n",
       "      <th>lap</th>\n",
       "      <th>time</th>\n",
       "      <th>duration</th>\n",
       "      <th>milliseconds</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>10</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>17:28:30</td>\n",
       "      <td>23.275</td>\n",
       "      <td>23275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>13</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>17:30:12</td>\n",
       "      <td>22.862</td>\n",
       "      <td>22862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>27</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>17:59:44</td>\n",
       "      <td>22.837</td>\n",
       "      <td>22837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>28</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>17:59:54</td>\n",
       "      <td>23.464</td>\n",
       "      <td>23464</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   pitStopId  raceId  driverId  stop  lap      time  duration  milliseconds\n",
       "0         10     860        18     1   16  17:28:30    23.275         23275\n",
       "1         13     860         1     1   17  17:30:12    22.862         22862\n",
       "2         27     860        18     2   36  17:59:44    22.837         22837\n",
       "3         28     860         1     2   36  17:59:54    23.464         23464"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_pitStops"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "qualifyId         int64\n",
       "raceId            int64\n",
       "driverId          int64\n",
       "constructorId     int64\n",
       "number            int64\n",
       "position          int64\n",
       "q1               object\n",
       "q2               object\n",
       "q3               object\n",
       "dtype: object"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_qualifying.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>qualifyId</th>\n",
       "      <th>raceId</th>\n",
       "      <th>driverId</th>\n",
       "      <th>constructorId</th>\n",
       "      <th>number</th>\n",
       "      <th>position</th>\n",
       "      <th>q1</th>\n",
       "      <th>q2</th>\n",
       "      <th>q3</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4966</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1</td>\n",
       "      <td>01:26.8</td>\n",
       "      <td>01:25.6</td>\n",
       "      <td>01:24.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4967</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>01:26.8</td>\n",
       "      <td>01:25.7</td>\n",
       "      <td>01:25.1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   qualifyId  raceId  driverId  constructorId  number  position       q1  \\\n",
       "0       4966     860         1              1       4         1  01:26.8   \n",
       "1       4967     860        18              1       3         2  01:26.8   \n",
       "\n",
       "        q2       q3  \n",
       "0  01:25.6  01:24.9  \n",
       "1  01:25.7  01:25.1  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_qualifying"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "raceId        int64\n",
       "year          int64\n",
       "round         int64\n",
       "circuitId     int64\n",
       "name         object\n",
       "date         object\n",
       "time         object\n",
       "url          object\n",
       "dtype: object"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_races.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "resultId             int64\n",
       "raceId               int64\n",
       "driverId             int64\n",
       "constructorId        int64\n",
       "number               int64\n",
       "grid                 int64\n",
       "position             int64\n",
       "positionText         int64\n",
       "positionOrder        int64\n",
       "points               int64\n",
       "laps                 int64\n",
       "time                object\n",
       "milliseconds         int64\n",
       "fastestLap           int64\n",
       "rank                 int64\n",
       "fastestLapTime      object\n",
       "fastestLapSpeed    float64\n",
       "statusId             int64\n",
       "dtype: object"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_results.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "year     int64\n",
       "url     object\n",
       "dtype: object"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_seasons.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>statusId</th>\n",
       "      <th>status</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>Finished</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>Disqualified</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>Accident</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>Collision</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>5</td>\n",
       "      <td>Engine</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>6</td>\n",
       "      <td>Gearbox</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>7</td>\n",
       "      <td>Transmission</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>8</td>\n",
       "      <td>Clutch</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>9</td>\n",
       "      <td>Hydraulics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>10</td>\n",
       "      <td>Electrical</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>11</td>\n",
       "      <td>+1 Lap</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>12</td>\n",
       "      <td>+2 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>13</td>\n",
       "      <td>+3 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>14</td>\n",
       "      <td>+4 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>15</td>\n",
       "      <td>+5 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>16</td>\n",
       "      <td>+6 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>17</td>\n",
       "      <td>+7 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>18</td>\n",
       "      <td>+8 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>19</td>\n",
       "      <td>+9 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20</td>\n",
       "      <td>Spun off</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>21</td>\n",
       "      <td>Radiator</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>22</td>\n",
       "      <td>Suspension</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>23</td>\n",
       "      <td>Brakes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>24</td>\n",
       "      <td>Differential</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>25</td>\n",
       "      <td>Overheating</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>26</td>\n",
       "      <td>Mechanical</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>27</td>\n",
       "      <td>Tyre</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>28</td>\n",
       "      <td>Driver Seat</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>29</td>\n",
       "      <td>Puncture</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>30</td>\n",
       "      <td>Driveshaft</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>105</td>\n",
       "      <td>Spark plugs</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>106</td>\n",
       "      <td>Fuel pipe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>107</td>\n",
       "      <td>Eye injury</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>108</td>\n",
       "      <td>Oil pipe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>109</td>\n",
       "      <td>Axle</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>110</td>\n",
       "      <td>Water pipe</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>111</td>\n",
       "      <td>+14 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>112</td>\n",
       "      <td>+15 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>113</td>\n",
       "      <td>+25 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>114</td>\n",
       "      <td>+18 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>115</td>\n",
       "      <td>+22 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>115</th>\n",
       "      <td>116</td>\n",
       "      <td>+16 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>116</th>\n",
       "      <td>117</td>\n",
       "      <td>+24 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>117</th>\n",
       "      <td>118</td>\n",
       "      <td>+29 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>118</th>\n",
       "      <td>119</td>\n",
       "      <td>+23 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>119</th>\n",
       "      <td>120</td>\n",
       "      <td>+21 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>120</th>\n",
       "      <td>121</td>\n",
       "      <td>Magneto</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>121</th>\n",
       "      <td>122</td>\n",
       "      <td>+44 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>122</th>\n",
       "      <td>123</td>\n",
       "      <td>+30 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>123</th>\n",
       "      <td>124</td>\n",
       "      <td>+19 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>124</th>\n",
       "      <td>125</td>\n",
       "      <td>+46 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>125</th>\n",
       "      <td>126</td>\n",
       "      <td>Supercharger</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>126</th>\n",
       "      <td>127</td>\n",
       "      <td>+20 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>127</th>\n",
       "      <td>130</td>\n",
       "      <td>Collision damage</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>128</th>\n",
       "      <td>131</td>\n",
       "      <td>Power Unit</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129</th>\n",
       "      <td>132</td>\n",
       "      <td>ERS</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>130</th>\n",
       "      <td>133</td>\n",
       "      <td>+49 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>131</th>\n",
       "      <td>134</td>\n",
       "      <td>+38 Laps</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>132</th>\n",
       "      <td>135</td>\n",
       "      <td>Brake duct</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>133</th>\n",
       "      <td>136</td>\n",
       "      <td>Seat</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>134 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     statusId            status\n",
       "0           1          Finished\n",
       "1           2      Disqualified\n",
       "2           3          Accident\n",
       "3           4         Collision\n",
       "4           5            Engine\n",
       "5           6           Gearbox\n",
       "6           7      Transmission\n",
       "7           8            Clutch\n",
       "8           9        Hydraulics\n",
       "9          10        Electrical\n",
       "10         11            +1 Lap\n",
       "11         12           +2 Laps\n",
       "12         13           +3 Laps\n",
       "13         14           +4 Laps\n",
       "14         15           +5 Laps\n",
       "15         16           +6 Laps\n",
       "16         17           +7 Laps\n",
       "17         18           +8 Laps\n",
       "18         19           +9 Laps\n",
       "19         20          Spun off\n",
       "20         21          Radiator\n",
       "21         22        Suspension\n",
       "22         23            Brakes\n",
       "23         24      Differential\n",
       "24         25       Overheating\n",
       "25         26        Mechanical\n",
       "26         27              Tyre\n",
       "27         28       Driver Seat\n",
       "28         29          Puncture\n",
       "29         30        Driveshaft\n",
       "..        ...               ...\n",
       "104       105       Spark plugs\n",
       "105       106         Fuel pipe\n",
       "106       107        Eye injury\n",
       "107       108          Oil pipe\n",
       "108       109              Axle\n",
       "109       110        Water pipe\n",
       "110       111          +14 Laps\n",
       "111       112          +15 Laps\n",
       "112       113          +25 Laps\n",
       "113       114          +18 Laps\n",
       "114       115          +22 Laps\n",
       "115       116          +16 Laps\n",
       "116       117          +24 Laps\n",
       "117       118          +29 Laps\n",
       "118       119          +23 Laps\n",
       "119       120          +21 Laps\n",
       "120       121           Magneto\n",
       "121       122          +44 Laps\n",
       "122       123          +30 Laps\n",
       "123       124          +19 Laps\n",
       "124       125          +46 Laps\n",
       "125       126      Supercharger\n",
       "126       127          +20 Laps\n",
       "127       130  Collision damage\n",
       "128       131        Power Unit\n",
       "129       132               ERS\n",
       "130       133          +49 Laps\n",
       "131       134          +38 Laps\n",
       "132       135        Brake duct\n",
       "133       136              Seat\n",
       "\n",
       "[134 rows x 2 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_status"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "pycharm": {
     "is_executing": false,
     "name": "#%%\n"
    }
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "raceId\n",
      "driverId\n",
      "lap\n",
      "position\n",
      "time\n",
      "milliseconds\n"
     ]
    }
   ],
   "source": [
    "# Checking uniques\n",
    "# df_lapTimes\n",
    "# df_pitStops\n",
    "df = df_lapTimes\n",
    "cols = list(df.columns)\n",
    "for c in cols:\n",
    "    if len(df[c].unique()) != len(df[c]):\n",
    "        print(c)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": true,
    "pycharm": {
     "is_executing": false,
     "name": "#%%\n"
    }
   },
   "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>pitStopId</th>\n",
       "      <th>raceId</th>\n",
       "      <th>driverId</th>\n",
       "      <th>stop</th>\n",
       "      <th>lap</th>\n",
       "      <th>time</th>\n",
       "      <th>duration</th>\n",
       "      <th>milliseconds</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>1</td>\n",
       "      <td>16</td>\n",
       "      <td>17:28:30</td>\n",
       "      <td>23.275</td>\n",
       "      <td>23275</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>17:30:12</td>\n",
       "      <td>22.862</td>\n",
       "      <td>22862</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>3</td>\n",
       "      <td>860</td>\n",
       "      <td>18</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>17:59:44</td>\n",
       "      <td>22.837</td>\n",
       "      <td>22837</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4</td>\n",
       "      <td>860</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>36</td>\n",
       "      <td>17:59:54</td>\n",
       "      <td>23.464</td>\n",
       "      <td>23464</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   pitStopId  raceId  driverId  stop  lap      time  duration  milliseconds\n",
       "0          1     860        18     1   16  17:28:30    23.275         23275\n",
       "1          2     860         1     1   17  17:30:12    22.862         22862\n",
       "2          3     860        18     2   36  17:59:44    22.837         22837\n",
       "3          4     860         1     2   36  17:59:54    23.464         23464"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Adding unique columns\n",
    "df_name = \"pitStops\"\n",
    "col = f\"{df_name[:-1]}Id\"\n",
    "df = locals()[f\"df_{df_name}\"]\n",
    "\n",
    "df[col] = np.arange(start=1, stop=len(df)+1)\n",
    "\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {
    "pycharm": {
     "is_executing": false,
     "name": "#%%\n"
    }
   },
   "outputs": [],
   "source": [
    "# Saving DataFrames\n",
    "df.to_csv(f\"F1_data/{df_name}.csv\", index=False)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  },
  "pycharm": {
   "stem_cell": {
    "cell_type": "raw",
    "metadata": {
     "collapsed": false
    },
    "source": []
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}