json_files_to_pd_dataframes.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 1: Import packages"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json\n",
    "import os"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 2: Load the JSON file containing the scraped data from the Polish website"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(file=os.path.join(os.getcwd(), \"product_page.json\"), mode=\"r\") as f:\n",
    "    df = json.load(f)\n",
    "    df = pd.DataFrame(df)\n",
    "    f.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>bike_name</th>\n",
       "      <th>bike_url</th>\n",
       "      <th>image_link</th>\n",
       "      <th>year_of_production</th>\n",
       "      <th>km_driven</th>\n",
       "      <th>cc</th>\n",
       "      <th>horsepower</th>\n",
       "      <th>price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Honda CB</td>\n",
       "      <td>https://www.otomoto.pl/oferta/honda-cb-honda-c...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2004</td>\n",
       "      <td>42000.0</td>\n",
       "      <td>599.0</td>\n",
       "      <td>9656.0</td>\n",
       "      <td>10500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-r-1250-gs-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2023</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>107630</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BMW Adventure</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-adventure-r-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2023</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>112902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-bmw-r-18-b...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2021</td>\n",
       "      <td>6135.0</td>\n",
       "      <td>1802.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>129900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BMW GS</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-gs-f-850-gs-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2023</td>\n",
       "      <td>1.0</td>\n",
       "      <td>850.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>68230</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       bike_name                                           bike_url  \\\n",
       "0       Honda CB  https://www.otomoto.pl/oferta/honda-cb-honda-c...   \n",
       "1          BMW R  https://www.otomoto.pl/oferta/bmw-r-r-1250-gs-...   \n",
       "2  BMW Adventure  https://www.otomoto.pl/oferta/bmw-adventure-r-...   \n",
       "3          BMW R  https://www.otomoto.pl/oferta/bmw-r-bmw-r-18-b...   \n",
       "4         BMW GS  https://www.otomoto.pl/oferta/bmw-gs-f-850-gs-...   \n",
       "\n",
       "                                          image_link  year_of_production  \\\n",
       "0  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2004   \n",
       "1  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2023   \n",
       "2  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2023   \n",
       "3  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2021   \n",
       "4  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2023   \n",
       "\n",
       "   km_driven      cc  horsepower   price  \n",
       "0    42000.0   599.0      9656.0   10500  \n",
       "1        1.0  1250.0       136.0  107630  \n",
       "2        1.0  1250.0       136.0  112902  \n",
       "3     6135.0  1802.0        91.0  129900  \n",
       "4        1.0   850.0        95.0   68230  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(df.head())"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Step 3: Load the JSON file containing the final dataset"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open(file=os.path.join(os.getcwd(), \"final_dataset.json\"), mode=\"r\") as f:\n",
    "    df_final = json.load(f)\n",
    "    df_final = pd.DataFrame(df_final)\n",
    "    f.close()"
   ]
  },
  {
   "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>bike_name</th>\n",
       "      <th>bike_url</th>\n",
       "      <th>image_link</th>\n",
       "      <th>year_of_production</th>\n",
       "      <th>km_driven</th>\n",
       "      <th>cc</th>\n",
       "      <th>horsepower</th>\n",
       "      <th>price</th>\n",
       "      <th>calculated_price</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Honda CB</td>\n",
       "      <td>https://www.otomoto.pl/oferta/honda-cb-honda-c...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2004</td>\n",
       "      <td>42000.0</td>\n",
       "      <td>599.0</td>\n",
       "      <td>9656.0</td>\n",
       "      <td>10500</td>\n",
       "      <td>68787</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-r-1250-gs-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2023</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>107630</td>\n",
       "      <td>364917</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>BMW Adventure</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-adventure-r-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2023</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>112902</td>\n",
       "      <td>379396</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-bmw-r-18-b...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2021</td>\n",
       "      <td>6135.0</td>\n",
       "      <td>1802.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>129900</td>\n",
       "      <td>443126</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>BMW GS</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-gs-f-850-gs-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2023</td>\n",
       "      <td>1.0</td>\n",
       "      <td>850.0</td>\n",
       "      <td>95.0</td>\n",
       "      <td>68230</td>\n",
       "      <td>222356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Honda GL</td>\n",
       "      <td>https://www.otomoto.pl/oferta/honda-gl-honda-g...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2010</td>\n",
       "      <td>80000.0</td>\n",
       "      <td>1832.0</td>\n",
       "      <td>118.0</td>\n",
       "      <td>65190</td>\n",
       "      <td>188855</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>BMW GS</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-gs-r1200-201...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2018</td>\n",
       "      <td>24000.0</td>\n",
       "      <td>1200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>65999</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>BMW GS</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-gs-r-1250-gs...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2023</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1250.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>103630</td>\n",
       "      <td>353932</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>CF Moto</td>\n",
       "      <td>https://www.otomoto.pl/oferta/cf-moto-c-force-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1000.0</td>\n",
       "      <td>80.0</td>\n",
       "      <td>58789</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Suzuki Bandit</td>\n",
       "      <td>https://www.otomoto.pl/oferta/suzuki-bandit-gs...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2002</td>\n",
       "      <td>22500.0</td>\n",
       "      <td>600.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>6800</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Triumph Tiger</td>\n",
       "      <td>https://www.otomoto.pl/oferta/triumph-tiger-tr...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2016</td>\n",
       "      <td>32000.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>94.0</td>\n",
       "      <td>35200</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>BMW C1</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-c1-400-gt-ju...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>350.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>43390</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-1250-gs-ju...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1254.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>108712</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Yamaha WR</td>\n",
       "      <td>https://www.otomoto.pl/oferta/yamaha-wr-wr125x...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2016</td>\n",
       "      <td>30000.0</td>\n",
       "      <td>125.0</td>\n",
       "      <td>15.0</td>\n",
       "      <td>14250</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-1250-gs-ju...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1254.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>108282</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-bmw-r-1250...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1254.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>109562</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-1250-rt-ju...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1254.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>126462</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>CF Moto</td>\n",
       "      <td>https://www.otomoto.pl/oferta/cf-moto-520-l-4x...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2021</td>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43.0</td>\n",
       "      <td>30899</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Benyco</td>\n",
       "      <td>https://www.otomoto.pl/oferta/benyco-quad-odes...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2021</td>\n",
       "      <td>1.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>43990</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Yamaha FZ</td>\n",
       "      <td>https://www.otomoto.pl/oferta/yamaha-fz-piekna...</td>\n",
       "      <td>//img.youtube.com/vi/BIdShjjfkqw/1.jpg</td>\n",
       "      <td>2014</td>\n",
       "      <td>5684.0</td>\n",
       "      <td>800.0</td>\n",
       "      <td>107.0</td>\n",
       "      <td>26900</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-1250-gs-do...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1254.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>111672</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>BMW F</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-f-900-r-dost...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>895.0</td>\n",
       "      <td>105.0</td>\n",
       "      <td>56340</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-1250-gs-do...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1254.0</td>\n",
       "      <td>136.0</td>\n",
       "      <td>111712</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Ducati Multistrada</td>\n",
       "      <td>https://www.otomoto.pl/oferta/ducati-multistra...</td>\n",
       "      <td>//img.youtube.com/vi/CbPdCYuBgVI/1.jpg</td>\n",
       "      <td>2022</td>\n",
       "      <td>1.0</td>\n",
       "      <td>937.0</td>\n",
       "      <td>110.0</td>\n",
       "      <td>81900</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>BMW G</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-g-310-r-dost...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>NaN</td>\n",
       "      <td>313.0</td>\n",
       "      <td>34.0</td>\n",
       "      <td>24690</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>TGB Blade</td>\n",
       "      <td>https://www.otomoto.pl/oferta/tgb-blade-tgb-bl...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2018</td>\n",
       "      <td>13200.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>42.0</td>\n",
       "      <td>20500</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>BMW R</td>\n",
       "      <td>https://www.otomoto.pl/oferta/bmw-r-bmw-r18-de...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2021</td>\n",
       "      <td>1380.0</td>\n",
       "      <td>1802.0</td>\n",
       "      <td>91.0</td>\n",
       "      <td>104000</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Can-Am Renegade</td>\n",
       "      <td>https://www.otomoto.pl/oferta/can-am-renegade-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2017</td>\n",
       "      <td>4190.0</td>\n",
       "      <td>976.0</td>\n",
       "      <td>90.0</td>\n",
       "      <td>66900</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>CF Moto</td>\n",
       "      <td>https://www.otomoto.pl/oferta/cf-moto-c-force-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2021</td>\n",
       "      <td>1.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>30889</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>CF Moto C-Force</td>\n",
       "      <td>https://www.otomoto.pl/oferta/cf-moto-c-force-...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>2.0</td>\n",
       "      <td>500.0</td>\n",
       "      <td>40.0</td>\n",
       "      <td>30900</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Ducati Streetfighter V4</td>\n",
       "      <td>https://www.otomoto.pl/oferta/ducati-streetfig...</td>\n",
       "      <td>https://ireland.apollo.olxcdn.com/v1/files/eyJ...</td>\n",
       "      <td>2022</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1103.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>112900</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  bike_name  \\\n",
       "0                  Honda CB   \n",
       "1                     BMW R   \n",
       "2             BMW Adventure   \n",
       "3                     BMW R   \n",
       "4                    BMW GS   \n",
       "5                  Honda GL   \n",
       "6                    BMW GS   \n",
       "7                    BMW GS   \n",
       "8                   CF Moto   \n",
       "9             Suzuki Bandit   \n",
       "10            Triumph Tiger   \n",
       "11                   BMW C1   \n",
       "12                    BMW R   \n",
       "13                Yamaha WR   \n",
       "14                    BMW R   \n",
       "15                    BMW R   \n",
       "16                    BMW R   \n",
       "17                  CF Moto   \n",
       "18                   Benyco   \n",
       "19                Yamaha FZ   \n",
       "20                    BMW R   \n",
       "21                    BMW F   \n",
       "22                    BMW R   \n",
       "23       Ducati Multistrada   \n",
       "24                    BMW G   \n",
       "25                TGB Blade   \n",
       "26                    BMW R   \n",
       "27          Can-Am Renegade   \n",
       "28                  CF Moto   \n",
       "29          CF Moto C-Force   \n",
       "30  Ducati Streetfighter V4   \n",
       "\n",
       "                                             bike_url  \\\n",
       "0   https://www.otomoto.pl/oferta/honda-cb-honda-c...   \n",
       "1   https://www.otomoto.pl/oferta/bmw-r-r-1250-gs-...   \n",
       "2   https://www.otomoto.pl/oferta/bmw-adventure-r-...   \n",
       "3   https://www.otomoto.pl/oferta/bmw-r-bmw-r-18-b...   \n",
       "4   https://www.otomoto.pl/oferta/bmw-gs-f-850-gs-...   \n",
       "5   https://www.otomoto.pl/oferta/honda-gl-honda-g...   \n",
       "6   https://www.otomoto.pl/oferta/bmw-gs-r1200-201...   \n",
       "7   https://www.otomoto.pl/oferta/bmw-gs-r-1250-gs...   \n",
       "8   https://www.otomoto.pl/oferta/cf-moto-c-force-...   \n",
       "9   https://www.otomoto.pl/oferta/suzuki-bandit-gs...   \n",
       "10  https://www.otomoto.pl/oferta/triumph-tiger-tr...   \n",
       "11  https://www.otomoto.pl/oferta/bmw-c1-400-gt-ju...   \n",
       "12  https://www.otomoto.pl/oferta/bmw-r-1250-gs-ju...   \n",
       "13  https://www.otomoto.pl/oferta/yamaha-wr-wr125x...   \n",
       "14  https://www.otomoto.pl/oferta/bmw-r-1250-gs-ju...   \n",
       "15  https://www.otomoto.pl/oferta/bmw-r-bmw-r-1250...   \n",
       "16  https://www.otomoto.pl/oferta/bmw-r-1250-rt-ju...   \n",
       "17  https://www.otomoto.pl/oferta/cf-moto-520-l-4x...   \n",
       "18  https://www.otomoto.pl/oferta/benyco-quad-odes...   \n",
       "19  https://www.otomoto.pl/oferta/yamaha-fz-piekna...   \n",
       "20  https://www.otomoto.pl/oferta/bmw-r-1250-gs-do...   \n",
       "21  https://www.otomoto.pl/oferta/bmw-f-900-r-dost...   \n",
       "22  https://www.otomoto.pl/oferta/bmw-r-1250-gs-do...   \n",
       "23  https://www.otomoto.pl/oferta/ducati-multistra...   \n",
       "24  https://www.otomoto.pl/oferta/bmw-g-310-r-dost...   \n",
       "25  https://www.otomoto.pl/oferta/tgb-blade-tgb-bl...   \n",
       "26  https://www.otomoto.pl/oferta/bmw-r-bmw-r18-de...   \n",
       "27  https://www.otomoto.pl/oferta/can-am-renegade-...   \n",
       "28  https://www.otomoto.pl/oferta/cf-moto-c-force-...   \n",
       "29  https://www.otomoto.pl/oferta/cf-moto-c-force-...   \n",
       "30  https://www.otomoto.pl/oferta/ducati-streetfig...   \n",
       "\n",
       "                                           image_link  year_of_production  \\\n",
       "0   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2004   \n",
       "1   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2023   \n",
       "2   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2023   \n",
       "3   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2021   \n",
       "4   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2023   \n",
       "5   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2010   \n",
       "6   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2018   \n",
       "7   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2023   \n",
       "8   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "9   https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2002   \n",
       "10  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2016   \n",
       "11  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "12  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "13  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2016   \n",
       "14  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "15  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "16  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "17  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2021   \n",
       "18  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2021   \n",
       "19             //img.youtube.com/vi/BIdShjjfkqw/1.jpg                2014   \n",
       "20  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "21  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "22  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "23             //img.youtube.com/vi/CbPdCYuBgVI/1.jpg                2022   \n",
       "24  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "25  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2018   \n",
       "26  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2021   \n",
       "27  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2017   \n",
       "28  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2021   \n",
       "29  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "30  https://ireland.apollo.olxcdn.com/v1/files/eyJ...                2022   \n",
       "\n",
       "    km_driven      cc  horsepower   price calculated_price  \n",
       "0     42000.0   599.0      9656.0   10500            68787  \n",
       "1         1.0  1250.0       136.0  107630           364917  \n",
       "2         1.0  1250.0       136.0  112902           379396  \n",
       "3      6135.0  1802.0        91.0  129900           443126  \n",
       "4         1.0   850.0        95.0   68230           222356  \n",
       "5     80000.0  1832.0       118.0   65190           188855  \n",
       "6     24000.0  1200.0         NaN   65999             None  \n",
       "7         1.0  1250.0       136.0  103630           353932  \n",
       "8         1.0  1000.0        80.0   58789              NaN  \n",
       "9     22500.0   600.0         NaN    6800              NaN  \n",
       "10    32000.0   800.0        94.0   35200              NaN  \n",
       "11        NaN   350.0        34.0   43390              NaN  \n",
       "12        NaN  1254.0       136.0  108712              NaN  \n",
       "13    30000.0   125.0        15.0   14250              NaN  \n",
       "14        NaN  1254.0       136.0  108282              NaN  \n",
       "15        NaN  1254.0       136.0  109562              NaN  \n",
       "16        NaN  1254.0       136.0  126462              NaN  \n",
       "17        1.0     NaN        43.0   30899              NaN  \n",
       "18        1.0   800.0         NaN   43990              NaN  \n",
       "19     5684.0   800.0       107.0   26900              NaN  \n",
       "20        NaN  1254.0       136.0  111672              NaN  \n",
       "21        NaN   895.0       105.0   56340              NaN  \n",
       "22        NaN  1254.0       136.0  111712              NaN  \n",
       "23        1.0   937.0       110.0   81900              NaN  \n",
       "24        NaN   313.0        34.0   24690              NaN  \n",
       "25    13200.0     NaN        42.0   20500              NaN  \n",
       "26     1380.0  1802.0        91.0  104000              NaN  \n",
       "27     4190.0   976.0        90.0   66900              NaN  \n",
       "28        1.0   500.0        40.0   30889              NaN  \n",
       "29        2.0   500.0        40.0   30900              NaN  \n",
       "30        1.0  1103.0       208.0  112900              NaN  "
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "display(df_final)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3.10.7 ('venv_scraping')",
   "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.10.7"
  },
  "orig_nbformat": 4,
  "vscode": {
   "interpreter": {
    "hash": "7c5a224ee8d70e0c2c09da925d09fa4cfc21ad72f8239495770bf94d17e52cd6"
   }
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}