Working Codes Only.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n",
      "C:\\Users\\jaida\\AppData\\Local\\Temp\\ipykernel_17400\\2751871522.py:51: FutureWarning: The frame.append method is deprecated and will be removed from pandas in a future version. Use pandas.concat instead.\n",
      "  df = df.append({\"price\": price, \"distance\": distance,\n"
     ]
    }
   ],
   "source": [
    "# Web Scrapping OYO Working Code\n",
    "import requests\n",
    "from bs4 import BeautifulSoup as Soup\n",
    "import pandas as pd\n",
    "\n",
    "\n",
    "def delhi():\n",
    "    df = pd.DataFrame()\n",
    "    headers = {\n",
    "        'User-Agent': 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/111.0.0.0 Safari/537.36'}\n",
    "    for pages in range(1, 6):\n",
    "        req = requests.get(\n",
    "            f\"https://www.oyorooms.com/hotels-in-delhi/?page={pages}\", headers=headers).text\n",
    "        soup = Soup(req, 'html.parser')\n",
    "        apts = soup.find_all(\n",
    "            \"div\", {\"class\": \"oyo-row oyo-row--no-spacing listingHotelDescription\"})\n",
    "        l = []\n",
    "        obj = {}\n",
    "        apts1 = soup.find_all(itemprop='url')\n",
    "        for a in range(0, len(apts)):\n",
    "            try:\n",
    "                obj[\"pricing\"] = apts[a].find(\n",
    "                    \"span\", {\"class\": \"listingPrice__finalPrice\"}).text\n",
    "            except:\n",
    "                obj[\"pricing\"] = None\n",
    "            try:\n",
    "                obj[\"Distance\"] = apts[a].find(\n",
    "                    \"span\", {\"class\": \"listingHotelDescription__distanceText\"}).text\n",
    "            except:\n",
    "                obj[\"Distance\"] = None\n",
    "            try:\n",
    "                link = apts1[a].get('content')\n",
    "                req1 = requests.get(link, headers=headers).text\n",
    "                soup2 = Soup(req1, 'html.parser')\n",
    "                obj[\"amneties\"] = soup2.find(\"div\", {\"class\": \"c-2cojj\"}).text\n",
    "            except:\n",
    "                obj[\"amneties\"] = None\n",
    "            try:\n",
    "                obj[\"ratings\"] = apts[a].find(\n",
    "                    \"div\", {\"class\": \"hotelRating\"}).text\n",
    "            except:\n",
    "                obj[\"ratings\"] = None\n",
    "\n",
    "            l.append(obj)\n",
    "            obj = {}\n",
    "        for i in l:\n",
    "            price = i[\"pricing\"]\n",
    "            distance = i[\"Distance\"]\n",
    "            amneties = i[\"amneties\"]\n",
    "            ratings = i[\"ratings\"]\n",
    "            df = df.append({\"price\": price, \"distance\": distance,\n",
    "                           \"amneties\": amneties, \"ratings\": ratings}, ignore_index=True)\n",
    "# dataCleaning\n",
    "    df[\"price\"] = df[\"price\"].str.replace(r\"₹\", \"\")\n",
    "    df[\"ratings\"] = df[\"ratings\"].str.replace(r\"₹\", \"\")\n",
    "    df['price'] = pd.to_numeric(df['price'])\n",
    "    df['distance'] = df['distance'].str.replace(r\"km\", \"\")\n",
    "    df['distance'] = pd.to_numeric(df['distance'])\n",
    "    df[['ratings', 'last_name', 'y', 'x']\n",
    "       ] = df['ratings'].str.split(' ', expand=True)\n",
    "    df = df.drop(columns=['last_name', 'y', 'x'], axis=1)\n",
    "    df['ratings'] = pd.to_numeric(df['ratings'], errors='coerce')\n",
    "    df['ratings'] = df['ratings'].fillna(df['ratings'].mean())\n",
    "    return df\n",
    "\n",
    "\n",
    "df = delhi()\n",
    "df\n",
    "\n",
    "df = pd.read_csv('newdelhi.csv')\n",
    "num_null = df[\"price\"].isnull().sum()\n",
    "df['price'] = df['price'].fillna(df['price'].mean())\n",
    "df\n",
    "\n",
    "df.to_csv('test1.csv')\n"
   ]
  }
 ],
 "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.10.0"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}