get_info.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Script to get the telemetry data of cars from Python Lib FastF1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "id": "QkQlyVcM8SAq",
    "tags": []
   },
   "outputs": [],
   "source": [
    "import fastf1 as ff1\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import warnings\n",
    "from datetime import timedelta\n",
    "\n",
    "warnings.filterwarnings('ignore')\n",
    "ff1.Cache.enable_cache('S:/Caching-FastF1/')\n",
    "ff1.logger.set_log_level('CRITICAL')"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "The data will be taken and processed usin the Python lib [FastF1](https://docs.fastf1.dev/) and the API [Ergast](https://ergast.com/mrd/)"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Demonstrating the use of the FastF1 library to get telemetry data from the F1 cars."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "tags": []
   },
   "outputs": [],
   "source": [
    "# First you get the session object passing the year, the round number or GP's name and the session type\n",
    "session = ff1.get_session(2022, 19, 'R')\n",
    "session.load()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "tags": []
   },
   "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>Time</th>\n",
       "      <th>Driver</th>\n",
       "      <th>DriverNumber</th>\n",
       "      <th>LapTime</th>\n",
       "      <th>LapNumber</th>\n",
       "      <th>Stint</th>\n",
       "      <th>PitOutTime</th>\n",
       "      <th>PitInTime</th>\n",
       "      <th>Sector1Time</th>\n",
       "      <th>Sector2Time</th>\n",
       "      <th>...</th>\n",
       "      <th>FreshTyre</th>\n",
       "      <th>Team</th>\n",
       "      <th>LapStartTime</th>\n",
       "      <th>LapStartDate</th>\n",
       "      <th>TrackStatus</th>\n",
       "      <th>Position</th>\n",
       "      <th>Deleted</th>\n",
       "      <th>DeletedReason</th>\n",
       "      <th>FastF1Generated</th>\n",
       "      <th>IsAccurate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0 days 01:04:21.784000</td>\n",
       "      <td>VER</td>\n",
       "      <td>1</td>\n",
       "      <td>0 days 00:01:41.343000</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0 days 00:26:15.778000</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:40.647000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Red Bull Racing</td>\n",
       "      <td>0 days 01:02:40.170000</td>\n",
       "      <td>2022-10-23 19:03:40.181</td>\n",
       "      <td>2</td>\n",
       "      <td>1.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0 days 01:06:03.480000</td>\n",
       "      <td>VER</td>\n",
       "      <td>1</td>\n",
       "      <td>0 days 00:01:41.696000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:27.804000</td>\n",
       "      <td>0 days 00:00:40.703000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Red Bull Racing</td>\n",
       "      <td>0 days 01:04:21.784000</td>\n",
       "      <td>2022-10-23 19:05:21.795</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0 days 01:07:45.373000</td>\n",
       "      <td>VER</td>\n",
       "      <td>1</td>\n",
       "      <td>0 days 00:01:41.893000</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:27.910000</td>\n",
       "      <td>0 days 00:00:40.636000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Red Bull Racing</td>\n",
       "      <td>0 days 01:06:03.480000</td>\n",
       "      <td>2022-10-23 19:07:03.491</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>0 days 01:09:27.954000</td>\n",
       "      <td>VER</td>\n",
       "      <td>1</td>\n",
       "      <td>0 days 00:01:42.581000</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:28.030000</td>\n",
       "      <td>0 days 00:00:40.805000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Red Bull Racing</td>\n",
       "      <td>0 days 01:07:45.373000</td>\n",
       "      <td>2022-10-23 19:08:45.384</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0 days 01:11:10.824000</td>\n",
       "      <td>VER</td>\n",
       "      <td>1</td>\n",
       "      <td>0 days 00:01:42.870000</td>\n",
       "      <td>5.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:28.203000</td>\n",
       "      <td>0 days 00:00:41.199000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Red Bull Racing</td>\n",
       "      <td>0 days 01:09:27.954000</td>\n",
       "      <td>2022-10-23 19:10:27.965</td>\n",
       "      <td>1</td>\n",
       "      <td>1.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>0 days 01:25:41.136000</td>\n",
       "      <td>BOT</td>\n",
       "      <td>77</td>\n",
       "      <td>0 days 00:01:44.238000</td>\n",
       "      <td>13.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:28.231000</td>\n",
       "      <td>0 days 00:00:41.673000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>0 days 01:23:56.898000</td>\n",
       "      <td>2022-10-23 19:24:56.909</td>\n",
       "      <td>1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>0 days 01:27:25.057000</td>\n",
       "      <td>BOT</td>\n",
       "      <td>77</td>\n",
       "      <td>0 days 00:01:43.921000</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:28.299000</td>\n",
       "      <td>0 days 00:00:41.714000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>0 days 01:25:41.136000</td>\n",
       "      <td>2022-10-23 19:26:41.147</td>\n",
       "      <td>1</td>\n",
       "      <td>14.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>0 days 01:29:08.960000</td>\n",
       "      <td>BOT</td>\n",
       "      <td>77</td>\n",
       "      <td>0 days 00:01:43.903000</td>\n",
       "      <td>15.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:28.186000</td>\n",
       "      <td>0 days 00:00:41.677000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>0 days 01:27:25.057000</td>\n",
       "      <td>2022-10-23 19:28:25.068</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>0 days 01:30:52.744000</td>\n",
       "      <td>BOT</td>\n",
       "      <td>77</td>\n",
       "      <td>0 days 00:01:43.784000</td>\n",
       "      <td>16.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>0 days 00:00:28.081000</td>\n",
       "      <td>0 days 00:00:41.513000</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>0 days 01:29:08.960000</td>\n",
       "      <td>2022-10-23 19:30:08.971</td>\n",
       "      <td>1</td>\n",
       "      <td>13.0</td>\n",
       "      <td>False</td>\n",
       "      <td></td>\n",
       "      <td>False</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>0 days 01:32:27.313000</td>\n",
       "      <td>BOT</td>\n",
       "      <td>77</td>\n",
       "      <td>NaT</td>\n",
       "      <td>17.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaT</td>\n",
       "      <td>...</td>\n",
       "      <td>True</td>\n",
       "      <td>Alfa Romeo</td>\n",
       "      <td>0 days 01:30:52.744000</td>\n",
       "      <td>NaT</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>992 rows × 31 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Time Driver DriverNumber                LapTime  \\\n",
       "0   0 days 01:04:21.784000    VER            1 0 days 00:01:41.343000   \n",
       "1   0 days 01:06:03.480000    VER            1 0 days 00:01:41.696000   \n",
       "2   0 days 01:07:45.373000    VER            1 0 days 00:01:41.893000   \n",
       "3   0 days 01:09:27.954000    VER            1 0 days 00:01:42.581000   \n",
       "4   0 days 01:11:10.824000    VER            1 0 days 00:01:42.870000   \n",
       "..                     ...    ...          ...                    ...   \n",
       "987 0 days 01:25:41.136000    BOT           77 0 days 00:01:44.238000   \n",
       "988 0 days 01:27:25.057000    BOT           77 0 days 00:01:43.921000   \n",
       "989 0 days 01:29:08.960000    BOT           77 0 days 00:01:43.903000   \n",
       "990 0 days 01:30:52.744000    BOT           77 0 days 00:01:43.784000   \n",
       "991 0 days 01:32:27.313000    BOT           77                    NaT   \n",
       "\n",
       "     LapNumber  Stint             PitOutTime PitInTime            Sector1Time  \\\n",
       "0          1.0    1.0 0 days 00:26:15.778000       NaT                    NaT   \n",
       "1          2.0    1.0                    NaT       NaT 0 days 00:00:27.804000   \n",
       "2          3.0    1.0                    NaT       NaT 0 days 00:00:27.910000   \n",
       "3          4.0    1.0                    NaT       NaT 0 days 00:00:28.030000   \n",
       "4          5.0    1.0                    NaT       NaT 0 days 00:00:28.203000   \n",
       "..         ...    ...                    ...       ...                    ...   \n",
       "987       13.0    2.0                    NaT       NaT 0 days 00:00:28.231000   \n",
       "988       14.0    2.0                    NaT       NaT 0 days 00:00:28.299000   \n",
       "989       15.0    2.0                    NaT       NaT 0 days 00:00:28.186000   \n",
       "990       16.0    2.0                    NaT       NaT 0 days 00:00:28.081000   \n",
       "991       17.0    2.0                    NaT       NaT                    NaT   \n",
       "\n",
       "               Sector2Time  ... FreshTyre             Team  \\\n",
       "0   0 days 00:00:40.647000  ...      True  Red Bull Racing   \n",
       "1   0 days 00:00:40.703000  ...      True  Red Bull Racing   \n",
       "2   0 days 00:00:40.636000  ...      True  Red Bull Racing   \n",
       "3   0 days 00:00:40.805000  ...      True  Red Bull Racing   \n",
       "4   0 days 00:00:41.199000  ...      True  Red Bull Racing   \n",
       "..                     ...  ...       ...              ...   \n",
       "987 0 days 00:00:41.673000  ...      True       Alfa Romeo   \n",
       "988 0 days 00:00:41.714000  ...      True       Alfa Romeo   \n",
       "989 0 days 00:00:41.677000  ...      True       Alfa Romeo   \n",
       "990 0 days 00:00:41.513000  ...      True       Alfa Romeo   \n",
       "991                    NaT  ...      True       Alfa Romeo   \n",
       "\n",
       "              LapStartTime            LapStartDate  TrackStatus  Position  \\\n",
       "0   0 days 01:02:40.170000 2022-10-23 19:03:40.181            2       1.0   \n",
       "1   0 days 01:04:21.784000 2022-10-23 19:05:21.795            1       1.0   \n",
       "2   0 days 01:06:03.480000 2022-10-23 19:07:03.491            1       1.0   \n",
       "3   0 days 01:07:45.373000 2022-10-23 19:08:45.384            1       1.0   \n",
       "4   0 days 01:09:27.954000 2022-10-23 19:10:27.965            1       1.0   \n",
       "..                     ...                     ...          ...       ...   \n",
       "987 0 days 01:23:56.898000 2022-10-23 19:24:56.909            1      14.0   \n",
       "988 0 days 01:25:41.136000 2022-10-23 19:26:41.147            1      14.0   \n",
       "989 0 days 01:27:25.057000 2022-10-23 19:28:25.068            1      13.0   \n",
       "990 0 days 01:29:08.960000 2022-10-23 19:30:08.971            1      13.0   \n",
       "991 0 days 01:30:52.744000                     NaT          NaN       NaN   \n",
       "\n",
       "     Deleted  DeletedReason FastF1Generated IsAccurate  \n",
       "0      False                          False      False  \n",
       "1      False                          False       True  \n",
       "2      False                          False       True  \n",
       "3      False                          False       True  \n",
       "4      False                          False       True  \n",
       "..       ...            ...             ...        ...  \n",
       "987    False                          False       True  \n",
       "988    False                          False       True  \n",
       "989    False                          False       True  \n",
       "990    False                          False       True  \n",
       "991    False            NaN            True      False  \n",
       "\n",
       "[992 rows x 31 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get the laps\n",
    "laps = session.laps\n",
    "laps"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "tags": []
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Time                      0 days 02:13:07.517000\n",
       "Driver                                       VER\n",
       "DriverNumber                                   1\n",
       "LapTime                   0 days 00:01:39.541000\n",
       "LapNumber                                   37.0\n",
       "Stint                                        3.0\n",
       "PitOutTime                                   NaT\n",
       "PitInTime                                    NaT\n",
       "Sector1Time               0 days 00:00:26.879000\n",
       "Sector2Time               0 days 00:00:39.756000\n",
       "Sector3Time               0 days 00:00:32.906000\n",
       "Sector1SessionTime        0 days 02:11:54.855000\n",
       "Sector2SessionTime        0 days 02:12:34.611000\n",
       "Sector3SessionTime        0 days 02:13:07.517000\n",
       "SpeedI1                                    205.0\n",
       "SpeedI2                                    184.0\n",
       "SpeedFL                                    204.0\n",
       "SpeedST                                    327.0\n",
       "IsPersonalBest                              True\n",
       "Compound                                  MEDIUM\n",
       "TyreLife                                     2.0\n",
       "FreshTyre                                   True\n",
       "Team                             Red Bull Racing\n",
       "LapStartTime              0 days 02:11:27.976000\n",
       "LapStartDate          2022-10-23 20:12:27.987000\n",
       "TrackStatus                                    1\n",
       "Position                                     5.0\n",
       "Deleted                                    False\n",
       "DeletedReason                                   \n",
       "FastF1Generated                            False\n",
       "IsAccurate                                  True\n",
       "Name: 36, dtype: object"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# From the laps, you pick a driver, and then you can get the fastest lap of that driver\n",
    "fastest = laps.pick_driver('VER').pick_fastest()\n",
    "fastest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "tags": []
   },
   "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>Date</th>\n",
       "      <th>SessionTime</th>\n",
       "      <th>DriverAhead</th>\n",
       "      <th>DistanceToDriverAhead</th>\n",
       "      <th>Time</th>\n",
       "      <th>RPM</th>\n",
       "      <th>Speed</th>\n",
       "      <th>nGear</th>\n",
       "      <th>Throttle</th>\n",
       "      <th>Brake</th>\n",
       "      <th>DRS</th>\n",
       "      <th>Source</th>\n",
       "      <th>Distance</th>\n",
       "      <th>RelativeDistance</th>\n",
       "      <th>Status</th>\n",
       "      <th>X</th>\n",
       "      <th>Y</th>\n",
       "      <th>Z</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2022-10-23 20:12:27.987</td>\n",
       "      <td>0 days 02:11:27.976000</td>\n",
       "      <td></td>\n",
       "      <td>49.156111</td>\n",
       "      <td>0 days 00:00:00</td>\n",
       "      <td>11107</td>\n",
       "      <td>210</td>\n",
       "      <td>4</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>interpolation</td>\n",
       "      <td>1.786978</td>\n",
       "      <td>0.000329</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1271</td>\n",
       "      <td>-444</td>\n",
       "      <td>1315</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>2022-10-23 20:12:28.047</td>\n",
       "      <td>0 days 02:11:28.036000</td>\n",
       "      <td></td>\n",
       "      <td>49.156111</td>\n",
       "      <td>0 days 00:00:00.060000</td>\n",
       "      <td>11214</td>\n",
       "      <td>213</td>\n",
       "      <td>4</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>pos</td>\n",
       "      <td>5.525338</td>\n",
       "      <td>0.001018</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1243</td>\n",
       "      <td>-460</td>\n",
       "      <td>1303</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>2022-10-23 20:12:28.051</td>\n",
       "      <td>0 days 02:11:28.040000</td>\n",
       "      <td></td>\n",
       "      <td>49.156111</td>\n",
       "      <td>0 days 00:00:00.064000</td>\n",
       "      <td>11427</td>\n",
       "      <td>218</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>car</td>\n",
       "      <td>5.775556</td>\n",
       "      <td>0.001064</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1241</td>\n",
       "      <td>-461</td>\n",
       "      <td>1302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2022-10-23 20:12:28.127</td>\n",
       "      <td>0 days 02:11:28.116000</td>\n",
       "      <td></td>\n",
       "      <td>49.156111</td>\n",
       "      <td>0 days 00:00:00.140000</td>\n",
       "      <td>11564</td>\n",
       "      <td>222</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>pos</td>\n",
       "      <td>10.553235</td>\n",
       "      <td>0.001944</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1204</td>\n",
       "      <td>-490</td>\n",
       "      <td>1302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2022-10-23 20:12:28.211</td>\n",
       "      <td>0 days 02:11:28.200000</td>\n",
       "      <td>16</td>\n",
       "      <td>49.156111</td>\n",
       "      <td>0 days 00:00:00.224000</td>\n",
       "      <td>11702</td>\n",
       "      <td>227</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>car</td>\n",
       "      <td>15.864444</td>\n",
       "      <td>0.002923</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1154</td>\n",
       "      <td>-527</td>\n",
       "      <td>1301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>761</th>\n",
       "      <td>2022-10-23 20:14:07.108</td>\n",
       "      <td>0 days 02:13:07.097000</td>\n",
       "      <td>16</td>\n",
       "      <td>53.857778</td>\n",
       "      <td>0 days 00:01:39.121000</td>\n",
       "      <td>11090</td>\n",
       "      <td>203</td>\n",
       "      <td>4</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>pos</td>\n",
       "      <td>5397.381362</td>\n",
       "      <td>0.994445</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1479</td>\n",
       "      <td>-277</td>\n",
       "      <td>1302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>762</th>\n",
       "      <td>2022-10-23 20:14:07.172</td>\n",
       "      <td>0 days 02:13:07.161000</td>\n",
       "      <td>16</td>\n",
       "      <td>54.163333</td>\n",
       "      <td>0 days 00:01:39.185000</td>\n",
       "      <td>10784</td>\n",
       "      <td>207</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>car</td>\n",
       "      <td>5401.096389</td>\n",
       "      <td>0.995130</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1450</td>\n",
       "      <td>-298</td>\n",
       "      <td>1302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>763</th>\n",
       "      <td>2022-10-23 20:14:07.308</td>\n",
       "      <td>0 days 02:13:07.297000</td>\n",
       "      <td>16</td>\n",
       "      <td>54.668889</td>\n",
       "      <td>0 days 00:01:39.321000</td>\n",
       "      <td>11033</td>\n",
       "      <td>210</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>pos</td>\n",
       "      <td>5409.058248</td>\n",
       "      <td>0.996597</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1379</td>\n",
       "      <td>-354</td>\n",
       "      <td>1302</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>2022-10-23 20:14:07.452</td>\n",
       "      <td>0 days 02:13:07.441000</td>\n",
       "      <td>16</td>\n",
       "      <td>55.174444</td>\n",
       "      <td>0 days 00:01:39.465000</td>\n",
       "      <td>11283</td>\n",
       "      <td>213</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>car</td>\n",
       "      <td>5417.663056</td>\n",
       "      <td>0.998182</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1306</td>\n",
       "      <td>-410</td>\n",
       "      <td>1301</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>2022-10-23 20:14:07.528</td>\n",
       "      <td>0 days 02:13:07.517000</td>\n",
       "      <td>16</td>\n",
       "      <td>55.174444</td>\n",
       "      <td>0 days 00:01:39.541000</td>\n",
       "      <td>11359</td>\n",
       "      <td>217</td>\n",
       "      <td>5</td>\n",
       "      <td>100</td>\n",
       "      <td>False</td>\n",
       "      <td>12</td>\n",
       "      <td>interpolation</td>\n",
       "      <td>5422.308729</td>\n",
       "      <td>0.999038</td>\n",
       "      <td>OnTrack</td>\n",
       "      <td>-1269</td>\n",
       "      <td>-437</td>\n",
       "      <td>1300</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>764 rows × 18 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                       Date            SessionTime DriverAhead  \\\n",
       "2   2022-10-23 20:12:27.987 0 days 02:11:27.976000               \n",
       "3   2022-10-23 20:12:28.047 0 days 02:11:28.036000               \n",
       "4   2022-10-23 20:12:28.051 0 days 02:11:28.040000               \n",
       "5   2022-10-23 20:12:28.127 0 days 02:11:28.116000               \n",
       "6   2022-10-23 20:12:28.211 0 days 02:11:28.200000          16   \n",
       "..                      ...                    ...         ...   \n",
       "761 2022-10-23 20:14:07.108 0 days 02:13:07.097000          16   \n",
       "762 2022-10-23 20:14:07.172 0 days 02:13:07.161000          16   \n",
       "763 2022-10-23 20:14:07.308 0 days 02:13:07.297000          16   \n",
       "764 2022-10-23 20:14:07.452 0 days 02:13:07.441000          16   \n",
       "765 2022-10-23 20:14:07.528 0 days 02:13:07.517000          16   \n",
       "\n",
       "     DistanceToDriverAhead                   Time    RPM  Speed  nGear  \\\n",
       "2                49.156111        0 days 00:00:00  11107    210      4   \n",
       "3                49.156111 0 days 00:00:00.060000  11214    213      4   \n",
       "4                49.156111 0 days 00:00:00.064000  11427    218      5   \n",
       "5                49.156111 0 days 00:00:00.140000  11564    222      5   \n",
       "6                49.156111 0 days 00:00:00.224000  11702    227      5   \n",
       "..                     ...                    ...    ...    ...    ...   \n",
       "761              53.857778 0 days 00:01:39.121000  11090    203      4   \n",
       "762              54.163333 0 days 00:01:39.185000  10784    207      5   \n",
       "763              54.668889 0 days 00:01:39.321000  11033    210      5   \n",
       "764              55.174444 0 days 00:01:39.465000  11283    213      5   \n",
       "765              55.174444 0 days 00:01:39.541000  11359    217      5   \n",
       "\n",
       "     Throttle  Brake  DRS         Source     Distance  RelativeDistance  \\\n",
       "2         100  False   12  interpolation     1.786978          0.000329   \n",
       "3         100  False   12            pos     5.525338          0.001018   \n",
       "4         100  False   12            car     5.775556          0.001064   \n",
       "5         100  False   12            pos    10.553235          0.001944   \n",
       "6         100  False   12            car    15.864444          0.002923   \n",
       "..        ...    ...  ...            ...          ...               ...   \n",
       "761       100  False   12            pos  5397.381362          0.994445   \n",
       "762       100  False   12            car  5401.096389          0.995130   \n",
       "763       100  False   12            pos  5409.058248          0.996597   \n",
       "764       100  False   12            car  5417.663056          0.998182   \n",
       "765       100  False   12  interpolation  5422.308729          0.999038   \n",
       "\n",
       "      Status     X    Y     Z  \n",
       "2    OnTrack -1271 -444  1315  \n",
       "3    OnTrack -1243 -460  1303  \n",
       "4    OnTrack -1241 -461  1302  \n",
       "5    OnTrack -1204 -490  1302  \n",
       "6    OnTrack -1154 -527  1301  \n",
       "..       ...   ...  ...   ...  \n",
       "761  OnTrack -1479 -277  1302  \n",
       "762  OnTrack -1450 -298  1302  \n",
       "763  OnTrack -1379 -354  1302  \n",
       "764  OnTrack -1306 -410  1301  \n",
       "765  OnTrack -1269 -437  1300  \n",
       "\n",
       "[764 rows x 18 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Then you get the telemetry of that lap\n",
    "fastest.get_telemetry()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "id": "AlV-0CCn8SA0",
    "tags": []
   },
   "outputs": [],
   "source": [
    "# Creating a list of lists that will receive the data to transform to a DataFrame\n",
    "# This info below will be the name of the columns\n",
    "information = [['Throttle_1', 'Throttle_2', 'Throttle_3', \n",
    "                'nGear_1', 'nGear_2', 'nGear_3',\n",
    "                'Track']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "executionInfo": {
     "elapsed": 7,
     "status": "ok",
     "timestamp": 1685108981757,
     "user": {
      "displayName": "Davi Ribeiro",
      "userId": "06812627091059740924"
     },
     "user_tz": 180
    },
    "id": "tw17NcLVEaWL",
    "outputId": "214eeae6-a932-470e-c86f-bbd082e82786",
    "tags": []
   },
   "outputs": [],
   "source": [
    "# Circuits by their most popular names and their countries\n",
    "# Country is required to make a verification of the request\n",
    "circuits = {\n",
    "            'Abu Dhabi': 'Abu Dhabi', \n",
    "            'Austin': 'United States',\n",
    "            'Australia': 'Australia',\n",
    "            'Austria': 'Austria',\n",
    "            'Bahrain': 'Bahrain',\n",
    "            'Baku': 'Azerbaijan',\n",
    "            'Brazil': 'Brazil',\n",
    "            'Canada': 'Canada',\n",
    "            'France': 'France',\n",
    "            'Hungary': 'Hungary',\n",
    "            'Japan': 'Japan',\n",
    "            'Mexico': 'Mexico',\n",
    "            'Monaco': 'Monaco',\n",
    "            'Monza': 'Italy',\n",
    "            'Saudi Arabia': 'Saudi Arabia',\n",
    "            'Silverstone': 'Great Britain',\n",
    "            'Spa-Francorchamps': 'Belgium',\n",
    "            'Spain': 'Spain',\n",
    "            }"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "colab": {
     "base_uri": "https://localhost:8080/"
    },
    "executionInfo": {
     "elapsed": 188116,
     "status": "ok",
     "timestamp": 1685109174998,
     "user": {
      "displayName": "Davi Ribeiro",
      "userId": "06812627091059740924"
     },
     "user_tz": 180
    },
    "id": "Xno7KuH38SA2",
    "outputId": "f5280952-f766-44ea-db6d-18712c3dcfe2",
    "scrolled": true,
    "tags": []
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "\n",
      "Hungary 2018 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2018\n",
      "\n",
      "Ended quali of 2018\n",
      "\n",
      "Started race of 2018\n",
      "LEC has no telemetry data\n",
      "\n",
      "Ended race of 2018\n",
      "\n",
      "\n",
      "Hungary 2019 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2019\n",
      "\n",
      "Ended quali of 2019\n",
      "\n",
      "Started race of 2019\n",
      "\n",
      "Ended race of 2019\n",
      "\n",
      "\n",
      "Hungary 2020 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2020\n",
      "\n",
      "Ended quali of 2020\n",
      "\n",
      "Started race of 2020\n",
      "\n",
      "Ended race of 2020\n",
      "\n",
      "\n",
      "Hungary 2021 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2021\n",
      "MSC has no telemetry data\n",
      "\n",
      "Ended quali of 2021\n",
      "\n",
      "Started race of 2021\n",
      "MAZ has no telemetry data\n",
      "NOR has no telemetry data\n",
      "BOT has no telemetry data\n",
      "PER has no telemetry data\n",
      "LEC has no telemetry data\n",
      "STR has no telemetry data\n",
      "\n",
      "Ended race of 2021\n",
      "\n",
      "\n",
      "Hungary 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "\n",
      "Japan 2018 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2018\n",
      "\n",
      "Ended quali of 2018\n",
      "\n",
      "Started race of 2018\n",
      "\n",
      "Ended race of 2018\n",
      "\n",
      "\n",
      "Japan 2019 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2019\n",
      "MAG has no telemetry data\n",
      "KUB has no telemetry data\n",
      "\n",
      "Ended quali of 2019\n",
      "\n",
      "Started race of 2019\n",
      "\n",
      "Ended race of 2019\n",
      "\n",
      "\n",
      "Japan 2020 started\n",
      "\n",
      "Japan 2020 race not found\n",
      "\n",
      "\n",
      "Japan 2021 started\n",
      "\n",
      "Japan 2021 race not found\n",
      "\n",
      "\n",
      "Japan 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "SAI has no telemetry data\n",
      "ALB has no telemetry data\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "\n",
      "Mexico 2018 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2018\n",
      "\n",
      "Ended quali of 2018\n",
      "\n",
      "Started race of 2018\n",
      "\n",
      "Ended race of 2018\n",
      "\n",
      "\n",
      "Mexico 2019 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2019\n",
      "\n",
      "Ended quali of 2019\n",
      "\n",
      "Started race of 2019\n",
      "\n",
      "Ended race of 2019\n",
      "\n",
      "\n",
      "Mexico 2020 started\n",
      "\n",
      "Mexico 2020 race not found\n",
      "\n",
      "\n",
      "Mexico 2021 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2021\n",
      "\n",
      "Ended quali of 2021\n",
      "\n",
      "Started race of 2021\n",
      "MSC has no telemetry data\n",
      "TSU has no telemetry data\n",
      "\n",
      "Ended race of 2021\n",
      "\n",
      "\n",
      "Mexico 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "\n",
      "Monaco 2018 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2018\n",
      "VER has no telemetry data\n",
      "\n",
      "Ended quali of 2018\n",
      "\n",
      "Started race of 2018\n",
      "\n",
      "Ended race of 2018\n",
      "\n",
      "\n",
      "Monaco 2019 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2019\n",
      "\n",
      "Ended quali of 2019\n",
      "\n",
      "Started race of 2019\n",
      "\n",
      "Ended race of 2019\n",
      "\n",
      "\n",
      "Monaco 2020 started\n",
      "\n",
      "Monaco 2020 race not found\n",
      "\n",
      "\n",
      "Monaco 2021 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2021\n",
      "MSC has no telemetry data\n",
      "\n",
      "Ended quali of 2021\n",
      "\n",
      "Started race of 2021\n",
      "LEC has no telemetry data\n",
      "\n",
      "Ended race of 2021\n",
      "\n",
      "\n",
      "Monaco 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "Monaco 2023 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2023\n",
      "\n",
      "Ended quali of 2023\n",
      "\n",
      "Started race of 2023\n",
      "\n",
      "Ended race of 2023\n",
      "\n",
      "\n",
      "\n",
      "Monza 2018 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2018\n",
      "\n",
      "Ended quali of 2018\n",
      "\n",
      "Started race of 2018\n",
      "HAR has no telemetry data\n",
      "\n",
      "Ended race of 2018\n",
      "\n",
      "\n",
      "Monza 2019 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2019\n",
      "VER has no telemetry data\n",
      "\n",
      "Ended quali of 2019\n",
      "\n",
      "Started race of 2019\n",
      "\n",
      "Ended race of 2019\n",
      "\n",
      "\n",
      "Monza 2020 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2020\n",
      "\n",
      "Ended quali of 2020\n",
      "\n",
      "Started race of 2020\n",
      "\n",
      "Ended race of 2020\n",
      "\n",
      "\n",
      "Monza 2021 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2021\n",
      "\n",
      "Ended quali of 2021\n",
      "\n",
      "Started race of 2021\n",
      "TSU has no telemetry data\n",
      "\n",
      "Ended race of 2021\n",
      "\n",
      "\n",
      "Monza 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "\n",
      "Saudi Arabia 2018 started\n",
      "\n",
      "Saudi Arabia 2018 race not found\n",
      "\n",
      "\n",
      "Saudi Arabia 2019 started\n",
      "\n",
      "Saudi Arabia 2019 race not found\n",
      "\n",
      "\n",
      "Saudi Arabia 2020 started\n",
      "\n",
      "Saudi Arabia 2020 race not found\n",
      "\n",
      "\n",
      "Saudi Arabia 2021 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2021\n",
      "\n",
      "Ended quali of 2021\n",
      "\n",
      "Started race of 2021\n",
      "\n",
      "Ended race of 2021\n",
      "\n",
      "\n",
      "Saudi Arabia 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "TSU has no telemetry data\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "TSU has no telemetry data\n",
      "nan has no telemetry data\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "Saudi Arabia 2023 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2023\n",
      "\n",
      "Ended quali of 2023\n",
      "\n",
      "Started race of 2023\n",
      "\n",
      "Ended race of 2023\n",
      "\n",
      "\n",
      "\n",
      "Silverstone 2018 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2018\n",
      "STR has no telemetry data\n",
      "HAR has no telemetry data\n",
      "\n",
      "Ended quali of 2018\n",
      "\n",
      "Started race of 2018\n",
      "HAR has no telemetry data\n",
      "\n",
      "Ended race of 2018\n",
      "\n",
      "\n",
      "Silverstone 2019 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2019\n",
      "\n",
      "Ended quali of 2019\n",
      "\n",
      "Started race of 2019\n",
      "\n",
      "Ended race of 2019\n",
      "\n",
      "\n",
      "Silverstone 2020 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2020\n",
      "\n",
      "Ended quali of 2020\n",
      "\n",
      "Started race of 2020\n",
      "MAG has no telemetry data\n",
      "HUL has no telemetry data\n",
      "\n",
      "Ended race of 2020\n",
      "\n",
      "\n",
      "Silverstone 2021 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2021\n",
      "\n",
      "Ended quali of 2021\n",
      "\n",
      "Started race of 2021\n",
      "VER has no telemetry data\n",
      "\n",
      "Ended race of 2021\n",
      "\n",
      "\n",
      "Silverstone 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "RUS has no telemetry data\n",
      "ZHO has no telemetry data\n",
      "ALB has no telemetry data\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "\n",
      "Spa-Francorchamps 2018 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2018\n",
      "\n",
      "Ended quali of 2018\n",
      "\n",
      "Started race of 2018\n",
      "LEC has no telemetry data\n",
      "ALO has no telemetry data\n",
      "HUL has no telemetry data\n",
      "\n",
      "Ended race of 2018\n",
      "\n",
      "\n",
      "Spa-Francorchamps 2019 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2019\n",
      "KUB has no telemetry data\n",
      "\n",
      "Ended quali of 2019\n",
      "\n",
      "Started race of 2019\n",
      "SAI has no telemetry data\n",
      "VER has no telemetry data\n",
      "\n",
      "Ended race of 2019\n",
      "\n",
      "\n",
      "Spa-Francorchamps 2020 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2020\n",
      "\n",
      "Ended quali of 2020\n",
      "\n",
      "Started race of 2020\n",
      "SAI has no telemetry data\n",
      "\n",
      "Ended race of 2020\n",
      "\n",
      "\n",
      "Spa-Francorchamps 2021 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2021\n",
      "\n",
      "Ended quali of 2021\n",
      "\n",
      "Started race of 2021\n",
      "VER has no telemetry data\n",
      "RUS has no telemetry data\n",
      "HAM has no telemetry data\n",
      "RIC has no telemetry data\n",
      "VET has no telemetry data\n",
      "GAS has no telemetry data\n",
      "OCO has no telemetry data\n",
      "LEC has no telemetry data\n",
      "LAT has no telemetry data\n",
      "SAI has no telemetry data\n",
      "ALO has no telemetry data\n",
      "BOT has no telemetry data\n",
      "GIO has no telemetry data\n",
      "NOR has no telemetry data\n",
      "TSU has no telemetry data\n",
      "MSC has no telemetry data\n",
      "MAZ has no telemetry data\n",
      "RAI has no telemetry data\n",
      "PER has no telemetry data\n",
      "STR has no telemetry data\n",
      "\n",
      "Ended race of 2021\n",
      "\n",
      "\n",
      "Spa-Francorchamps 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "BOT has no telemetry data\n",
      "HAM has no telemetry data\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "\n",
      "Spain 2018 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2018\n",
      "HAR has no telemetry data\n",
      "\n",
      "Ended quali of 2018\n",
      "\n",
      "Started race of 2018\n",
      "GRO has no telemetry data\n",
      "GAS has no telemetry data\n",
      "HUL has no telemetry data\n",
      "\n",
      "Ended race of 2018\n",
      "\n",
      "\n",
      "Spain 2019 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2019\n",
      "\n",
      "Ended quali of 2019\n",
      "\n",
      "Started race of 2019\n",
      "\n",
      "Ended race of 2019\n",
      "\n",
      "\n",
      "Spain 2020 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2020\n",
      "\n",
      "Ended quali of 2020\n",
      "\n",
      "Started race of 2020\n",
      "\n",
      "Ended race of 2020\n",
      "\n",
      "\n",
      "Spain 2021 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2021\n",
      "\n",
      "Ended quali of 2021\n",
      "\n",
      "Started race of 2021\n",
      "\n",
      "Ended race of 2021\n",
      "\n",
      "\n",
      "Spain 2022 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2022\n",
      "\n",
      "Ended quali of 2022\n",
      "\n",
      "Started race of 2022\n",
      "\n",
      "Ended race of 2022\n",
      "\n",
      "\n",
      "Spain 2023 started\n",
      "\n",
      "Quali and race loaded\n",
      "\n",
      "Started quali of 2023\n",
      "\n",
      "Ended quali of 2023\n",
      "\n",
      "Started race of 2023\n",
      "\n",
      "Ended race of 2023\n",
      "\n",
      "CPU times: total: 15min 44s\n",
      "Wall time: 17min 4s\n"
     ]
    }
   ],
   "source": [
    "%%time\n",
    "for circuit, country in circuits.items():\n",
    "    print()\n",
    "    for year in range(2018, 2024):\n",
    "        # Skip races that didn't happened\n",
    "        if year == 2023 and circuit not in ['Australia', 'Baku', 'Bahrain', 'Saudi Arabia', 'Monaco', 'Spain']:\n",
    "            continue\n",
    "        print(f\"\\n{circuit} {year} started\\n\")\n",
    "        \n",
    "        try:\n",
    "            quali = ff1.get_session(year, circuit, 'Q')\n",
    "            if quali.event.Country != country:\n",
    "                print(f\"{circuit} {year} race not found\\n\")\n",
    "                continue\n",
    "            quali.load()\n",
    "        except:\n",
    "            quali = None\n",
    "            print(f\"{circuit} {year} race not found\\n\")\n",
    "\n",
    "        try:\n",
    "            race = ff1.get_session(year, circuit, 'R')\n",
    "            if race.event.Country != country:\n",
    "                continue\n",
    "            race.load()\n",
    "        except:\n",
    "            race = None\n",
    "\n",
    "        if quali and race:\n",
    "            print('Quali and race loaded\\n')\n",
    "        \n",
    "        c = 0\n",
    "        for event in [quali, race]:\n",
    "            c+=1\n",
    "            if not quali:\n",
    "                continue\n",
    "            if not race:\n",
    "                continue\n",
    "\n",
    "            print(f\"Started {'quali' if c == 1 else 'race'} of {year}\")\n",
    "\n",
    "            try:\n",
    "                laps = event.laps\n",
    "            except:\n",
    "                print('Laps not loaded\\n')\n",
    "\n",
    "                continue\n",
    "            for driver in event.results['Abbreviation']:\n",
    "                lap = laps.pick_driver(driver).pick_fastest()\n",
    "                # Get the time of each sector\n",
    "                s1t = lap['Sector1Time']\n",
    "                s2t = lap['Sector2Time']\n",
    "                s3t = lap['Sector3Time']\n",
    "\n",
    "                try:\n",
    "                    tel = lap.get_telemetry()\n",
    "                except:\n",
    "                    print(f'{driver} has no telemetry data')\n",
    "                    continue\n",
    "                    \n",
    "                # Slicing the telemetry for each sector\n",
    "                s1 = tel[tel['Time'] <= s1t]\n",
    "                s2 = tel[(tel['Time'] > s1t) & (tel['Time'] <= s1t + s2t)]\n",
    "                s3 = tel[(tel['Time'] > s1t + s2t) & (tel['Time'] <= s1t + s2t + s3t)]\n",
    "\n",
    "                sectors = [s1, s2, s3]\n",
    "               \n",
    "                # Getting average of each of information in each sector\n",
    "                info = [sectors[i]['Throttle'].mean() for i in range(3)]\n",
    "                info.extend(sectors[i]['nGear'].mean() for i in range(3))\n",
    "                info.extend([circuit])\n",
    "                information.append(info)\n",
    "            print(f\"\\nEnded {'quali' if c == 1 else 'race'} of {year}\\n\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "id": "g9pfpFRM8SA8"
   },
   "outputs": [],
   "source": [
    "dataset = pd.DataFrame(information[1:], columns=information[0])\n",
    "dataset = dataset.dropna()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "dataset.to_csv('formula_data.csv', index=False)"
   ]
  }
 ],
 "metadata": {
  "colab": {
   "provenance": []
  },
  "kernelspec": {
   "display_name": "Formula1",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.11.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}