all-scraping.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "from bs4 import BeautifulSoup\n",
    "import requests\n",
    "import lxml"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Done -----------Page 1\n",
      "Done -----------Page 2\n",
      "Done -----------Page 3\n",
      "Done -----------Page 4\n",
      "Done -----------Page 5\n",
      "Done -----------Page 6\n",
      "Done -----------Page 7\n",
      "Done -----------Page 8\n",
      "Done -----------Page 9\n",
      "Done -----------Page 10\n",
      "Done -----------Page 11\n",
      "Done -----------Page 12\n",
      "Done -----------Page 13\n",
      "Done -----------Page 14\n",
      "Done -----------Page 15\n",
      "Done -----------Page 16\n",
      "Done -----------Page 17\n",
      "Done -----------Page 18\n",
      "Done -----------Page 19\n",
      "Done -----------Page 20\n",
      "Done -----------Page 21\n",
      "Done -----------Page 22\n",
      "Done -----------Page 23\n",
      "Done -----------Page 24\n",
      "Done -----------Page 25\n",
      "Done -----------Page 26\n",
      "Done -----------Page 27\n",
      "Done -----------Page 28\n",
      "Done -----------Page 29\n",
      "Done -----------Page 30\n",
      "Done -----------Page 31\n",
      "Done -----------Page 32\n",
      "Done -----------Page 33\n",
      "Done -----------Page 34\n",
      "Done -----------Page 35\n",
      "Done -----------Page 36\n",
      "Done -----------Page 37\n",
      "Done -----------Page 38\n",
      "Done -----------Page 39\n",
      "Done -----------Page 40\n",
      "Done -----------Page 41\n",
      "Done -----------Page 42\n",
      "Done -----------Page 43\n",
      "Done -----------Page 44\n",
      "Done -----------Page 45\n",
      "Done -----------Page 46\n",
      "Done -----------Page 47\n",
      "Done -----------Page 48\n",
      "Done -----------Page 49\n",
      "Done -----------Page 50\n",
      "Done -----------Page 51\n",
      "Done -----------Page 52\n",
      "Done -----------Page 53\n",
      "Done -----------Page 54\n",
      "Done -----------Page 55\n",
      "Done -----------Page 56\n",
      "Done -----------Page 57\n",
      "Done -----------Page 58\n",
      "Done -----------Page 59\n",
      "Done -----------Page 60\n",
      "Done -----------Page 61\n",
      "Done -----------Page 62\n",
      "Done -----------Page 63\n",
      "Done -----------Page 64\n",
      "Done -----------Page 65\n",
      "Done -----------Page 66\n",
      "Done -----------Page 67\n",
      "Done -----------Page 68\n",
      "Done -----------Page 69\n",
      "Done -----------Page 70\n",
      "Done -----------Page 71\n",
      "Done -----------Page 72\n",
      "Done -----------Page 73\n",
      "Done -----------Page 74\n",
      "Done -----------Page 75\n",
      "Done -----------Page 76\n",
      "Done -----------Page 77\n",
      "Done -----------Page 78\n",
      "Done -----------Page 79\n",
      "Done -----------Page 80\n",
      "Done -----------Page 81\n",
      "Done -----------Page 82\n",
      "Done -----------Page 83\n",
      "Done -----------Page 84\n",
      "Done -----------Page 85\n",
      "Done -----------Page 86\n",
      "Done -----------Page 87\n",
      "Done -----------Page 88\n",
      "Done -----------Page 89\n",
      "Done -----------Page 90\n",
      "Done -----------Page 91\n",
      "Done -----------Page 92\n",
      "Done -----------Page 93\n",
      "Done -----------Page 94\n",
      "Done -----------Page 95\n",
      "Done -----------Page 96\n",
      "Done -----------Page 97\n",
      "Done -----------Page 98\n",
      "Done -----------Page 99\n",
      "Done -----------Page 100\n",
      "Done -----------Page 101\n",
      "Done -----------Page 102\n",
      "Done -----------Page 103\n",
      "Done -----------Page 104\n",
      "Done -----------Page 105\n",
      "Done -----------Page 106\n",
      "Done -----------Page 107\n",
      "Done -----------Page 108\n",
      "Done -----------Page 109\n",
      "Done -----------Page 110\n",
      "Done -----------Page 111\n",
      "Done -----------Page 112\n",
      "Done -----------Page 113\n",
      "Done -----------Page 114\n",
      "Done -----------Page 115\n",
      "Done -----------Page 116\n",
      "Done -----------Page 117\n",
      "Done -----------Page 118\n",
      "Done -----------Page 119\n",
      "Done -----------Page 120\n",
      "Done -----------Page 121\n",
      "Done -----------Page 122\n",
      "Done -----------Page 123\n",
      "Done -----------Page 124\n",
      "Done -----------Page 125\n",
      "Done -----------Page 126\n",
      "Done -----------Page 127\n",
      "Done -----------Page 128\n",
      "Done -----------Page 129\n",
      "Done -----------Page 130\n",
      "Done -----------Page 131\n",
      "Done -----------Page 132\n",
      "Done -----------Page 133\n",
      "Done -----------Page 134\n",
      "Done -----------Page 135\n",
      "Done -----------Page 136\n",
      "Done -----------Page 137\n",
      "Done -----------Page 138\n",
      "Done -----------Page 139\n",
      "Done -----------Page 140\n",
      "Done -----------Page 141\n",
      "Done -----------Page 142\n",
      "Done -----------Page 143\n",
      "Done -----------Page 144\n",
      "Done -----------Page 145\n",
      "Done -----------Page 146\n",
      "Done -----------Page 147\n",
      "Done -----------Page 148\n",
      "Done -----------Page 149\n",
      "Done -----------Page 150\n",
      "Done -----------Page 151\n",
      "Done -----------Page 152\n",
      "Done -----------Page 153\n",
      "Done -----------Page 154\n",
      "Done -----------Page 155\n",
      "Done -----------Page 156\n",
      "Done -----------Page 157\n",
      "Done -----------Page 158\n",
      "Done -----------Page 159\n",
      "Done -----------Page 160\n",
      "Done -----------Page 161\n",
      "Done -----------Page 162\n",
      "Done -----------Page 163\n",
      "Done -----------Page 164\n",
      "Done -----------Page 165\n",
      "Done -----------Page 166\n",
      "Done -----------Page 167\n",
      "Done -----------Page 168\n",
      "Done -----------Page 169\n",
      "Done -----------Page 170\n",
      "Done -----------Page 171\n",
      "Done -----------Page 172\n",
      "Done -----------Page 173\n",
      "Done -----------Page 174\n",
      "Done -----------Page 175\n",
      "Done -----------Page 176\n",
      "Done -----------Page 177\n",
      "Done -----------Page 178\n",
      "Done -----------Page 179\n",
      "Done -----------Page 180\n",
      "Done -----------Page 181\n",
      "Done -----------Page 182\n",
      "Done -----------Page 183\n",
      "Done -----------Page 184\n",
      "Done -----------Page 185\n",
      "Done -----------Page 186\n",
      "Done -----------Page 187\n",
      "Done -----------Page 188\n",
      "Done -----------Page 189\n",
      "Done -----------Page 190\n",
      "Done -----------Page 191\n",
      "Done -----------Page 192\n",
      "Done -----------Page 193\n",
      "Done -----------Page 194\n",
      "Done -----------Page 195\n",
      "Done -----------Page 196\n",
      "Done -----------Page 197\n",
      "Done -----------Page 198\n",
      "Done -----------Page 199\n",
      "Done -----------Page 200\n",
      "Done -----------Page 201\n",
      "Done -----------Page 202\n",
      "Done -----------Page 203\n",
      "Done -----------Page 204\n",
      "Done -----------Page 205\n",
      "Done -----------Page 206\n",
      "Done -----------Page 207\n",
      "Done -----------Page 208\n",
      "Done -----------Page 209\n",
      "Done -----------Page 210\n",
      "Done -----------Page 211\n",
      "Done -----------Page 212\n",
      "Done -----------Page 213\n",
      "Done -----------Page 214\n",
      "Done -----------Page 215\n",
      "Done -----------Page 216\n",
      "Done -----------Page 217\n",
      "Done -----------Page 218\n",
      "Done -----------Page 219\n",
      "Done -----------Page 220\n",
      "Done -----------Page 221\n",
      "Done -----------Page 222\n",
      "Done -----------Page 223\n",
      "Done -----------Page 224\n",
      "Done -----------Page 225\n",
      "Done -----------Page 226\n",
      "Done -----------Page 227\n",
      "Done -----------Page 228\n",
      "Done -----------Page 229\n",
      "Done -----------Page 230\n",
      "Done -----------Page 231\n",
      "Done -----------Page 232\n",
      "Done -----------Page 233\n",
      "Done -----------Page 234\n",
      "Done -----------Page 235\n",
      "Done -----------Page 236\n",
      "Done -----------Page 237\n",
      "Done -----------Page 238\n",
      "Done -----------Page 239\n",
      "Done -----------Page 240\n",
      "Done -----------Page 241\n",
      "Done -----------Page 242\n",
      "Done -----------Page 243\n",
      "Done -----------Page 244\n",
      "Done -----------Page 245\n",
      "Done -----------Page 246\n",
      "Done -----------Page 247\n",
      "Done -----------Page 248\n",
      "Done -----------Page 249\n",
      "Done -----------Page 250\n",
      "Done -----------Page 251\n",
      "Done -----------Page 252\n",
      "Done -----------Page 253\n",
      "Done -----------Page 254\n",
      "Done -----------Page 255\n",
      "Done -----------Page 256\n",
      "Done -----------Page 257\n",
      "Done -----------Page 258\n",
      "Done -----------Page 259\n",
      "Done -----------Page 260\n",
      "Done -----------Page 261\n",
      "Done -----------Page 262\n",
      "Done -----------Page 263\n",
      "Done -----------Page 264\n",
      "Done -----------Page 265\n",
      "Done -----------Page 266\n",
      "Done -----------Page 267\n",
      "Done -----------Page 268\n",
      "Done -----------Page 269\n",
      "Done -----------Page 270\n",
      "Done -----------Page 271\n",
      "Done -----------Page 272\n",
      "Done -----------Page 273\n",
      "Done -----------Page 274\n",
      "Done -----------Page 275\n",
      "Done -----------Page 276\n",
      "Done -----------Page 277\n",
      "Done -----------Page 278\n",
      "Done -----------Page 279\n",
      "Done -----------Page 280\n",
      "Done -----------Page 281\n",
      "Done -----------Page 282\n",
      "Done -----------Page 283\n",
      "Done -----------Page 284\n",
      "Done -----------Page 285\n",
      "Done -----------Page 286\n",
      "Done -----------Page 287\n",
      "Done -----------Page 288\n",
      "Done -----------Page 289\n",
      "Done -----------Page 290\n",
      "Done -----------Page 291\n",
      "Done -----------Page 292\n",
      "Done -----------Page 293\n",
      "Done -----------Page 294\n",
      "Done -----------Page 295\n",
      "Done -----------Page 296\n",
      "Done -----------Page 297\n",
      "Done -----------Page 298\n",
      "Done -----------Page 299\n",
      "Done -----------Page 300\n",
      "Done -----------Page 301\n",
      "Done -----------Page 302\n",
      "Done -----------Page 303\n",
      "Done -----------Page 304\n",
      "Done -----------Page 305\n",
      "Done -----------Page 306\n",
      "Done -----------Page 307\n",
      "Done -----------Page 308\n",
      "Done -----------Page 309\n",
      "Done -----------Page 310\n",
      "Done -----------Page 311\n",
      "Done -----------Page 312\n",
      "Done -----------Page 313\n",
      "Done -----------Page 314\n",
      "Done -----------Page 315\n",
      "Done -----------Page 316\n",
      "Done -----------Page 317\n",
      "Done -----------Page 318\n",
      "Done -----------Page 319\n",
      "Done -----------Page 320\n",
      "Done -----------Page 321\n",
      "Done -----------Page 322\n",
      "Done -----------Page 323\n",
      "Done -----------Page 324\n",
      "Done -----------Page 325\n",
      "Done -----------Page 326\n",
      "Done -----------Page 327\n",
      "Done -----------Page 328\n",
      "Done -----------Page 329\n",
      "Done -----------Page 330\n",
      "Done -----------Page 331\n",
      "Done -----------Page 332\n",
      "Done -----------Page 333\n",
      "Done -----------Page 334\n",
      "Done -----------Page 335\n",
      "Done -----------Page 336\n",
      "Done -----------Page 337\n",
      "Done -----------Page 338\n",
      "Done -----------Page 339\n",
      "Done -----------Page 340\n",
      "Done -----------Page 341\n",
      "Done -----------Page 342\n",
      "Done -----------Page 343\n",
      "Done -----------Page 344\n",
      "Done -----------Page 345\n",
      "Done -----------Page 346\n",
      "Done -----------Page 347\n",
      "Done -----------Page 348\n",
      "Done -----------Page 349\n",
      "Done -----------Page 350\n",
      "Done -----------Page 351\n",
      "Done -----------Page 352\n",
      "Done -----------Page 353\n",
      "Done -----------Page 354\n",
      "Done -----------Page 355\n",
      "Done -----------Page 356\n",
      "Done -----------Page 357\n",
      "Done -----------Page 358\n",
      "Done -----------Page 359\n",
      "Done -----------Page 360\n",
      "Done -----------Page 361\n",
      "Done -----------Page 362\n",
      "Done -----------Page 363\n",
      "Done -----------Page 364\n",
      "Done -----------Page 365\n",
      "Done -----------Page 366\n",
      "Done -----------Page 367\n",
      "Done -----------Page 368\n",
      "Done -----------Page 369\n",
      "Done -----------Page 370\n",
      "Done -----------Page 371\n",
      "Done -----------Page 372\n",
      "Done -----------Page 373\n",
      "Done -----------Page 374\n",
      "Done -----------Page 375\n",
      "Done -----------Page 376\n",
      "Done -----------Page 377\n",
      "Done -----------Page 378\n",
      "Done -----------Page 379\n",
      "Done -----------Page 380\n",
      "Done -----------Page 381\n",
      "Done -----------Page 382\n",
      "Done -----------Page 383\n",
      "Done -----------Page 384\n",
      "Done -----------Page 385\n",
      "Done -----------Page 386\n",
      "Done -----------Page 387\n",
      "Done -----------Page 388\n",
      "Done -----------Page 389\n",
      "Done -----------Page 390\n",
      "Done -----------Page 391\n",
      "Done -----------Page 392\n",
      "Done -----------Page 393\n",
      "Done -----------Page 394\n",
      "Done -----------Page 395\n",
      "Done -----------Page 396\n",
      "Done -----------Page 397\n",
      "Done -----------Page 398\n",
      "Done -----------Page 399\n",
      "Done -----------Page 400\n",
      "Done -----------Page 401\n",
      "Done -----------Page 402\n",
      "Done -----------Page 403\n",
      "Done -----------Page 404\n",
      "Done -----------Page 405\n",
      "Done -----------Page 406\n",
      "Done -----------Page 407\n",
      "Done -----------Page 408\n",
      "Done -----------Page 409\n",
      "Done -----------Page 410\n",
      "Done -----------Page 411\n",
      "Done -----------Page 412\n",
      "Done -----------Page 413\n",
      "Done -----------Page 414\n",
      "Done -----------Page 415\n",
      "Done -----------Page 416\n",
      "Done -----------Page 417\n",
      "Done -----------Page 418\n",
      "Done -----------Page 419\n",
      "Done -----------Page 420\n",
      "Done -----------Page 421\n",
      "Done -----------Page 422\n",
      "Done -----------Page 423\n",
      "Done -----------Page 424\n",
      "Done -----------Page 425\n",
      "Done -----------Page 426\n",
      "Done -----------Page 427\n",
      "Done -----------Page 428\n",
      "Done -----------Page 429\n",
      "Done -----------Page 430\n",
      "Done -----------Page 431\n",
      "Done -----------Page 432\n",
      "Done -----------Page 433\n",
      "Done -----------Page 434\n",
      "Done -----------Page 435\n",
      "Done -----------Page 436\n",
      "Done -----------Page 437\n",
      "Done -----------Page 438\n",
      "Done -----------Page 439\n",
      "Done -----------Page 440\n",
      "Done -----------Page 441\n",
      "Done -----------Page 442\n",
      "Done -----------Page 443\n",
      "Done -----------Page 444\n",
      "Done -----------Page 445\n",
      "Done -----------Page 446\n",
      "Done -----------Page 447\n",
      "Done -----------Page 448\n",
      "Done -----------Page 449\n",
      "Done -----------Page 450\n",
      "Done -----------Page 451\n",
      "Done -----------Page 452\n",
      "Done -----------Page 453\n",
      "Done -----------Page 454\n",
      "Done -----------Page 455\n",
      "Done -----------Page 456\n",
      "Done -----------Page 457\n",
      "Done -----------Page 458\n",
      "Done -----------Page 459\n",
      "Done -----------Page 460\n",
      "Done -----------Page 461\n",
      "Done -----------Page 462\n",
      "Done -----------Page 463\n",
      "Done -----------Page 464\n",
      "Done -----------Page 465\n",
      "Done -----------Page 466\n",
      "Done -----------Page 467\n",
      "Done -----------Page 468\n",
      "Done -----------Page 469\n",
      "Done -----------Page 470\n",
      "Done -----------Page 471\n",
      "Done -----------Page 472\n",
      "Done -----------Page 473\n",
      "Done -----------Page 474\n",
      "Done -----------Page 475\n",
      "Done -----------Page 476\n",
      "Done -----------Page 477\n",
      "Done -----------Page 478\n",
      "Done -----------Page 479\n",
      "Done -----------Page 480\n",
      "Done -----------Page 481\n",
      "Done -----------Page 482\n",
      "Done -----------Page 483\n",
      "Done -----------Page 484\n",
      "Done -----------Page 485\n",
      "Done -----------Page 486\n",
      "Done -----------Page 487\n",
      "Done -----------Page 488\n",
      "Done -----------Page 489\n",
      "Done -----------Page 490\n",
      "Done -----------Page 491\n",
      "Done -----------Page 492\n",
      "Done -----------Page 493\n",
      "Done -----------Page 494\n",
      "Done -----------Page 495\n",
      "Done -----------Page 496\n",
      "Done -----------Page 497\n",
      "Done -----------Page 498\n",
      "Done -----------Page 499\n",
      "Done -----------Page 500\n",
      "Done -----------Page 501\n",
      "Done -----------Page 502\n",
      "Done -----------Page 503\n",
      "Done -----------Page 504\n",
      "Done -----------Page 505\n",
      "Done -----------Page 506\n",
      "Done -----------Page 507\n",
      "Done -----------Page 508\n",
      "Done -----------Page 509\n",
      "Done -----------Page 510\n",
      "Done -----------Page 511\n",
      "Done -----------Page 512\n",
      "Done -----------Page 513\n",
      "Done -----------Page 514\n",
      "Done -----------Page 515\n",
      "Done -----------Page 516\n",
      "Done -----------Page 517\n",
      "Done -----------Page 518\n",
      "Done -----------Page 519\n",
      "Done -----------Page 520\n",
      "Done -----------Page 521\n",
      "Done -----------Page 522\n",
      "Done -----------Page 523\n",
      "Done -----------Page 524\n",
      "Done -----------Page 525\n",
      "Done -----------Page 526\n",
      "Done -----------Page 527\n",
      "Done -----------Page 528\n",
      "Done -----------Page 529\n",
      "Done -----------Page 530\n",
      "Done -----------Page 531\n",
      "Done -----------Page 532\n",
      "Done -----------Page 533\n",
      "Done -----------Page 534\n",
      "Done -----------Page 535\n",
      "Done -----------Page 536\n",
      "Done -----------Page 537\n",
      "Done -----------Page 538\n",
      "Done -----------Page 539\n",
      "Done -----------Page 540\n",
      "Done -----------Page 541\n",
      "Done -----------Page 542\n",
      "Done -----------Page 543\n",
      "Done -----------Page 544\n",
      "Done -----------Page 545\n",
      "Done -----------Page 546\n",
      "Done -----------Page 547\n",
      "Done -----------Page 548\n",
      "Done -----------Page 549\n",
      "Done -----------Page 550\n",
      "Done -----------Page 551\n",
      "Done -----------Page 552\n",
      "Done -----------Page 553\n",
      "Done -----------Page 554\n",
      "Done -----------Page 555\n",
      "Done -----------Page 556\n",
      "Done -----------Page 557\n",
      "Done -----------Page 558\n",
      "Done -----------Page 559\n",
      "Done -----------Page 560\n",
      "Done -----------Page 561\n",
      "Done -----------Page 562\n",
      "Done -----------Page 563\n",
      "Done -----------Page 564\n",
      "Done -----------Page 565\n",
      "Done -----------Page 566\n",
      "Done -----------Page 567\n",
      "Done -----------Page 568\n",
      "Done -----------Page 569\n",
      "Done -----------Page 570\n",
      "Done -----------Page 571\n",
      "Done -----------Page 572\n",
      "Done -----------Page 573\n",
      "Done -----------Page 574\n",
      "Done -----------Page 575\n",
      "Done -----------Page 576\n",
      "Done -----------Page 577\n",
      "Done -----------Page 578\n",
      "Done -----------Page 579\n",
      "Done -----------Page 580\n",
      "Done -----------Page 581\n",
      "Done -----------Page 582\n",
      "Done -----------Page 583\n",
      "Done -----------Page 584\n",
      "Done -----------Page 585\n",
      "Done -----------Page 586\n",
      "Done -----------Page 587\n",
      "Done -----------Page 588\n",
      "Done -----------Page 589\n",
      "Done -----------Page 590\n",
      "Done -----------Page 591\n",
      "Done -----------Page 592\n",
      "Done -----------Page 593\n",
      "Done -----------Page 594\n",
      "Done -----------Page 595\n",
      "Done -----------Page 596\n",
      "Done -----------Page 597\n",
      "Done -----------Page 598\n",
      "Done -----------Page 599\n",
      "Done -----------Page 600\n",
      "Done -----------Page 601\n",
      "Done -----------Page 602\n",
      "Done -----------Page 603\n",
      "Done -----------Page 604\n",
      "Done -----------Page 605\n",
      "Done -----------Page 606\n",
      "Done -----------Page 607\n",
      "Done -----------Page 608\n",
      "Done -----------Page 609\n",
      "Done -----------Page 610\n",
      "Done -----------Page 611\n",
      "Done -----------Page 612\n",
      "Done -----------Page 613\n",
      "Done -----------Page 614\n",
      "Done -----------Page 615\n",
      "Done -----------Page 616\n",
      "Done -----------Page 617\n",
      "Done -----------Page 618\n",
      "Done -----------Page 619\n",
      "Done -----------Page 620\n",
      "Done -----------Page 621\n",
      "Done -----------Page 622\n",
      "Done -----------Page 623\n",
      "Done -----------Page 624\n",
      "Done -----------Page 625\n",
      "Done -----------Page 626\n",
      "Done -----------Page 627\n",
      "Done -----------Page 628\n",
      "Done -----------Page 629\n",
      "Done -----------Page 630\n",
      "Done -----------Page 631\n",
      "Done -----------Page 632\n",
      "Done -----------Page 633\n",
      "Done -----------Page 634\n",
      "Done -----------Page 635\n",
      "Done -----------Page 636\n",
      "Done -----------Page 637\n",
      "Done -----------Page 638\n",
      "Done -----------Page 639\n",
      "Done -----------Page 640\n",
      "Done -----------Page 641\n",
      "Done -----------Page 642\n",
      "Done -----------Page 643\n",
      "Done -----------Page 644\n",
      "Done -----------Page 645\n",
      "Done -----------Page 646\n",
      "Done -----------Page 647\n",
      "Done -----------Page 648\n",
      "Done -----------Page 649\n",
      "Done -----------Page 650\n",
      "Done -----------Page 651\n",
      "Done -----------Page 652\n",
      "Done -----------Page 653\n",
      "Done -----------Page 654\n",
      "Done -----------Page 655\n",
      "Done -----------Page 656\n",
      "Done -----------Page 657\n",
      "Done -----------Page 658\n",
      "Done -----------Page 659\n",
      "Done -----------Page 660\n",
      "Done -----------Page 661\n",
      "Done -----------Page 662\n",
      "Done -----------Page 663\n",
      "Done -----------Page 664\n",
      "Done -----------Page 665\n",
      "Done -----------Page 666\n",
      "Done -----------Page 667\n",
      "Done -----------Page 668\n",
      "Done -----------Page 669\n",
      "Done -----------Page 670\n",
      "Done -----------Page 671\n",
      "Done -----------Page 672\n",
      "Done -----------Page 673\n",
      "Done -----------Page 674\n",
      "Done -----------Page 675\n",
      "Done -----------Page 676\n",
      "Done -----------Page 677\n",
      "Done -----------Page 678\n",
      "Done -----------Page 679\n",
      "Done -----------Page 680\n",
      "Done -----------Page 681\n",
      "Done -----------Page 682\n",
      "Done -----------Page 683\n",
      "Done -----------Page 684\n",
      "Done -----------Page 685\n",
      "Done -----------Page 686\n",
      "Done -----------Page 687\n",
      "Done -----------Page 688\n",
      "Done -----------Page 689\n",
      "Done -----------Page 690\n",
      "Done -----------Page 691\n",
      "Done -----------Page 692\n",
      "Done -----------Page 693\n",
      "Done -----------Page 694\n",
      "Done -----------Page 695\n",
      "Done -----------Page 696\n",
      "Done -----------Page 697\n",
      "Done -----------Page 698\n",
      "Done -----------Page 699\n",
      "Done -----------Page 700\n",
      "Done -----------Page 701\n",
      "Done -----------Page 702\n",
      "Done -----------Page 703\n",
      "Done -----------Page 704\n",
      "Done -----------Page 705\n",
      "Done -----------Page 706\n",
      "Done -----------Page 707\n",
      "Done -----------Page 708\n",
      "Done -----------Page 709\n",
      "Done -----------Page 710\n",
      "Done -----------Page 711\n",
      "Done -----------Page 712\n",
      "Done -----------Page 713\n",
      "Done -----------Page 714\n",
      "Done -----------Page 715\n",
      "Done -----------Page 716\n",
      "Done -----------Page 717\n",
      "Done -----------Page 718\n",
      "Done -----------Page 719\n",
      "Done -----------Page 720\n",
      "Done -----------Page 721\n",
      "Done -----------Page 722\n",
      "Done -----------Page 723\n",
      "Done -----------Page 724\n",
      "Done -----------Page 725\n",
      "Done -----------Page 726\n",
      "Done -----------Page 727\n",
      "Done -----------Page 728\n",
      "Done -----------Page 729\n",
      "Done -----------Page 730\n",
      "Done -----------Page 731\n",
      "Done -----------Page 732\n",
      "Done -----------Page 733\n",
      "Done -----------Page 734\n",
      "Done -----------Page 735\n",
      "Done -----------Page 736\n",
      "Done -----------Page 737\n",
      "Done -----------Page 738\n",
      "Done -----------Page 739\n",
      "Done -----------Page 740\n",
      "Done -----------Page 741\n",
      "Done -----------Page 742\n",
      "Done -----------Page 743\n",
      "Done -----------Page 744\n",
      "Done -----------Page 745\n",
      "Done -----------Page 746\n",
      "Done -----------Page 747\n",
      "Done -----------Page 748\n",
      "Done -----------Page 749\n",
      "Done -----------Page 750\n",
      "Done -----------Page 751\n",
      "Done -----------Page 752\n",
      "Done -----------Page 753\n",
      "Done -----------Page 754\n",
      "Done -----------Page 755\n",
      "Done -----------Page 756\n",
      "Done -----------Page 757\n",
      "Done -----------Page 758\n",
      "Done -----------Page 759\n",
      "Done -----------Page 760\n",
      "Done -----------Page 761\n",
      "Done -----------Page 762\n",
      "Done -----------Page 763\n",
      "Done -----------Page 764\n",
      "Done -----------Page 765\n",
      "Done -----------Page 766\n",
      "Done -----------Page 767\n",
      "Done -----------Page 768\n",
      "Done -----------Page 769\n",
      "Done -----------Page 770\n",
      "Done -----------Page 771\n",
      "Done -----------Page 772\n",
      "Done -----------Page 773\n",
      "Done -----------Page 774\n",
      "Done -----------Page 775\n",
      "Done -----------Page 776\n",
      "Done -----------Page 777\n",
      "Done -----------Page 778\n",
      "Done -----------Page 779\n"
     ]
    }
   ],
   "source": [
    "property_names = []\n",
    "prices = []\n",
    "bedrooms = []\n",
    "bathrooms=[]\n",
    "sq_yard_area=[]\n",
    "urls=[]\n",
    "for page in range(1,780):\n",
    "    url = f\"https://www.zameen.com/Homes/Karachi-2-{page}.html\"\n",
    "    webpage = requests.get(url)\n",
    "    soup = BeautifulSoup(webpage.content,\"lxml\")\n",
    "    data=soup.find_all(\"div\",class_=\"_732aff15 c7b81b5c\")  \n",
    "    print(\"Done -----------Page\",page)  \n",
    "    for house in data:\n",
    "        urls.append(url)\n",
    "        prices.append(house.find_all(\"span\",class_=\"f343d9ce\")[0].text)\n",
    "        property_names.append(house.find_all(\"div\",class_=\"_162e6469\")[0].text) \n",
    "        for details in house.find_all(\"div\",class_=\"_27f6c93d\"):\n",
    "            bedrooms.append(details.find_all(\"span\",class_=\"b133f61d\")[0].find_all(\"span\",class_=\"_984949e5\")[0].text)\n",
    "            try:\n",
    "                bathrooms.append(details.find_all(\"span\",class_=\"b133f61d\")[1].find_all(\"span\",class_=\"_984949e5\")[0].text)\n",
    "            except:\n",
    "                bathrooms.append(0)\n",
    "            try:\n",
    "                sq_yard_area.append(details.find_all(\"span\",class_=\"b133f61d\")[2].find_all(\"span\",class_=\"_984949e5\")[0].text)\n",
    "            except:\n",
    "                sq_yard_area.append(0)\n",
    "df = pd.DataFrame({\"Property_Name\":property_names,\n",
    "              \"Price\":prices,\n",
    "               \"NoOfBedrooms\":bedrooms,\n",
    "                \"NoOfBathrooms\":bathrooms,\n",
    "                 \"AreaSqYards\":sq_yard_area,\n",
    "                  \"WebURL\":urls })"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "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>Property_Name</th>\n",
       "      <th>Price</th>\n",
       "      <th>NoOfBedrooms</th>\n",
       "      <th>NoOfBathrooms</th>\n",
       "      <th>AreaSqYards</th>\n",
       "      <th>WebURL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>Bahria Town - Precinct 31, Bahria Town Karachi</td>\n",
       "      <td>1.4 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>235 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>Bahria Town - Precinct 27, Bahria Town Karachi</td>\n",
       "      <td>1.6 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>235 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>Bahria Apartments, Bahria Town Karachi</td>\n",
       "      <td>50.35 Lakh</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>59 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>Bahria Town - Precinct 19, Bahria Town Karachi</td>\n",
       "      <td>90 Lakh</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>106 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>Bahria Town Karachi, Karachi</td>\n",
       "      <td>1.48 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>125 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>DHA Phase 6, DHA Defence</td>\n",
       "      <td>9.85 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>600 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>DHA Phase 8 - Zone A, DHA Phase 8</td>\n",
       "      <td>21 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>500 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>Bahria Town - Ali Block, Bahria Town - Precinc...</td>\n",
       "      <td>1.4 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>125 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>Malir Cantonment, Cantt</td>\n",
       "      <td>98 Lakh</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>102 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>Gulshan-e-Iqbal - Block 4, Gulshan-e-Iqbal</td>\n",
       "      <td>2.4 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>178 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>6.41 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>375 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>6.42 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>375 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>DHA Phase 5, DHA Defence</td>\n",
       "      <td>7.25 Crore</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>500 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>North Karachi - Sector 11A, North Karachi</td>\n",
       "      <td>1.1 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>160 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>North Karachi - Sector 11-C/2, North Karachi</td>\n",
       "      <td>2.65 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>120 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>North Karachi - Sector 11A, North Karachi</td>\n",
       "      <td>3.25 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>288 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>North Karachi - Sector 10, North Karachi</td>\n",
       "      <td>1.78 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>120 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>Gulistan-e-Jauhar - Block 15, Gulistan-e-Jauhar</td>\n",
       "      <td>2.1 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>167 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>North Nazimabad - Block M, North Nazimabad</td>\n",
       "      <td>1.05 Crore</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>128 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>Federal B Area - Block 10, Federal B Area</td>\n",
       "      <td>10.6 Crore</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>400 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>Rafi Premier Residency, Scheme 33</td>\n",
       "      <td>1.72 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>194 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>Gulistan-e-Jauhar - Block 14, Gulistan-e-Jauhar</td>\n",
       "      <td>1.65 Crore</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>122 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>Bukhari Commercial Area, DHA Phase 6</td>\n",
       "      <td>1.7 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>128 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>DHA Phase 8, DHA Defence</td>\n",
       "      <td>3.75 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>100 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>DHA Phase 6, DHA Defence</td>\n",
       "      <td>11.5 Crore</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>500 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-3.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Bahria Town - Precinct 35, Bahria Sports City</td>\n",
       "      <td>2 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>350 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>Bahria Town - Precinct 19, Bahria Town Karachi</td>\n",
       "      <td>90 Lakh</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>106 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Bahria Town - Jinnah Avenue, Bahria Town Karachi</td>\n",
       "      <td>85 Lakh</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>120 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>7.1 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>375 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>6.75 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>375 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>6.95 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>375 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>DHA Phase 6, DHA Defence</td>\n",
       "      <td>1.4 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>133 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>Bahria Town - Precinct 12, Bahria Town Karachi</td>\n",
       "      <td>1.65 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>125 Sq. Yd.</td>\n",
       "      <td>0</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>Gulistan-e-Jauhar - Block 2, Gulistan-e-Jauhar</td>\n",
       "      <td>2.5 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>240 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>KDA Employees Society - Sector 31-C2, KDA Empl...</td>\n",
       "      <td>40 Lakh</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>89 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>6.44 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>375 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>6.43 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>375 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>North Karachi - Sector 9, North Karachi</td>\n",
       "      <td>1.62 Crore</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>120 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>Clifton - Block 7, Clifton</td>\n",
       "      <td>4.25 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>189 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>Clifton, Karachi</td>\n",
       "      <td>5.9 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>467 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>Civil Lines, Karachi</td>\n",
       "      <td>9.28 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>294 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>Clifton, Karachi</td>\n",
       "      <td>8.93 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>6</td>\n",
       "      <td>667 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>DHA Phase 7 Extension, DHA Defence</td>\n",
       "      <td>4.6 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>100 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>DHA Phase 7 Extension, DHA Defence</td>\n",
       "      <td>5.5 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>150 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>DHA Phase 7 Extension, DHA Defence</td>\n",
       "      <td>12.5 Crore</td>\n",
       "      <td>6</td>\n",
       "      <td>6</td>\n",
       "      <td>500 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>Clifton - Block 5, Clifton</td>\n",
       "      <td>4.75 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>222 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>DHA Phase 7 Extension, DHA Defence</td>\n",
       "      <td>3.85 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>100 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>DHA Phase 8, DHA Defence</td>\n",
       "      <td>5.5 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>120 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>Bahria Town - Precinct 11-A, Bahria Town - Pre...</td>\n",
       "      <td>1.7 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>152 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>Bahria Town - Precinct 10-A, Bahria Town Karachi</td>\n",
       "      <td>1.95 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>200 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-4.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>6.85 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>428 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>3.85 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>300 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>Askari 5 - Sector H, Askari 5</td>\n",
       "      <td>8.1 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>427 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>6.5 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "      <td>375 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>3.75 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>289 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>Bahria Town Karachi, Karachi</td>\n",
       "      <td>1.3 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>125 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>Bahria Apartments, Bahria Town Karachi</td>\n",
       "      <td>96 Lakh</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>109 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>Bahria Town - Ali Block, Bahria Town - Precinc...</td>\n",
       "      <td>1.55 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>125 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>Bahria Town - Precinct 27, Bahria Town Karachi</td>\n",
       "      <td>1.7 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>235 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>Bahria Town Karachi, Karachi</td>\n",
       "      <td>66 Lakh</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>91 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-5.html</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                         Property_Name       Price  \\\n",
       "50      Bahria Town - Precinct 31, Bahria Town Karachi   1.4 Crore   \n",
       "51      Bahria Town - Precinct 27, Bahria Town Karachi   1.6 Crore   \n",
       "52              Bahria Apartments, Bahria Town Karachi  50.35 Lakh   \n",
       "53      Bahria Town - Precinct 19, Bahria Town Karachi     90 Lakh   \n",
       "54                        Bahria Town Karachi, Karachi  1.48 Crore   \n",
       "55                            DHA Phase 6, DHA Defence  9.85 Crore   \n",
       "56                   DHA Phase 8 - Zone A, DHA Phase 8    21 Crore   \n",
       "57   Bahria Town - Ali Block, Bahria Town - Precinc...   1.4 Crore   \n",
       "58                             Malir Cantonment, Cantt     98 Lakh   \n",
       "59          Gulshan-e-Iqbal - Block 4, Gulshan-e-Iqbal   2.4 Crore   \n",
       "60                       Askari 5 - Sector J, Askari 5  6.41 Crore   \n",
       "61                       Askari 5 - Sector J, Askari 5  6.42 Crore   \n",
       "62                            DHA Phase 5, DHA Defence  7.25 Crore   \n",
       "63           North Karachi - Sector 11A, North Karachi   1.1 Crore   \n",
       "64        North Karachi - Sector 11-C/2, North Karachi  2.65 Crore   \n",
       "65           North Karachi - Sector 11A, North Karachi  3.25 Crore   \n",
       "66            North Karachi - Sector 10, North Karachi  1.78 Crore   \n",
       "67     Gulistan-e-Jauhar - Block 15, Gulistan-e-Jauhar   2.1 Crore   \n",
       "68          North Nazimabad - Block M, North Nazimabad  1.05 Crore   \n",
       "69           Federal B Area - Block 10, Federal B Area  10.6 Crore   \n",
       "70                   Rafi Premier Residency, Scheme 33  1.72 Crore   \n",
       "71     Gulistan-e-Jauhar - Block 14, Gulistan-e-Jauhar  1.65 Crore   \n",
       "72                Bukhari Commercial Area, DHA Phase 6   1.7 Crore   \n",
       "73                            DHA Phase 8, DHA Defence  3.75 Crore   \n",
       "74                            DHA Phase 6, DHA Defence  11.5 Crore   \n",
       "75       Bahria Town - Precinct 35, Bahria Sports City     2 Crore   \n",
       "76      Bahria Town - Precinct 19, Bahria Town Karachi     90 Lakh   \n",
       "77    Bahria Town - Jinnah Avenue, Bahria Town Karachi     85 Lakh   \n",
       "78                       Askari 5 - Sector J, Askari 5   7.1 Crore   \n",
       "79                       Askari 5 - Sector J, Askari 5  6.75 Crore   \n",
       "80                       Askari 5 - Sector J, Askari 5  6.95 Crore   \n",
       "81                            DHA Phase 6, DHA Defence   1.4 Crore   \n",
       "82      Bahria Town - Precinct 12, Bahria Town Karachi  1.65 Crore   \n",
       "83      Gulistan-e-Jauhar - Block 2, Gulistan-e-Jauhar   2.5 Crore   \n",
       "84   KDA Employees Society - Sector 31-C2, KDA Empl...     40 Lakh   \n",
       "85                       Askari 5 - Sector J, Askari 5  6.44 Crore   \n",
       "86                       Askari 5 - Sector J, Askari 5  6.43 Crore   \n",
       "87             North Karachi - Sector 9, North Karachi  1.62 Crore   \n",
       "88                          Clifton - Block 7, Clifton  4.25 Crore   \n",
       "89                                    Clifton, Karachi   5.9 Crore   \n",
       "90                                Civil Lines, Karachi  9.28 Crore   \n",
       "91                                    Clifton, Karachi  8.93 Crore   \n",
       "92                  DHA Phase 7 Extension, DHA Defence   4.6 Crore   \n",
       "93                  DHA Phase 7 Extension, DHA Defence   5.5 Crore   \n",
       "94                  DHA Phase 7 Extension, DHA Defence  12.5 Crore   \n",
       "95                          Clifton - Block 5, Clifton  4.75 Crore   \n",
       "96                  DHA Phase 7 Extension, DHA Defence  3.85 Crore   \n",
       "97                            DHA Phase 8, DHA Defence   5.5 Crore   \n",
       "98   Bahria Town - Precinct 11-A, Bahria Town - Pre...   1.7 Crore   \n",
       "99    Bahria Town - Precinct 10-A, Bahria Town Karachi  1.95 Crore   \n",
       "100                      Askari 5 - Sector J, Askari 5  6.85 Crore   \n",
       "101                      Askari 5 - Sector J, Askari 5  3.85 Crore   \n",
       "102                      Askari 5 - Sector H, Askari 5   8.1 Crore   \n",
       "103                      Askari 5 - Sector J, Askari 5   6.5 Crore   \n",
       "104                      Askari 5 - Sector J, Askari 5  3.75 Crore   \n",
       "105                       Bahria Town Karachi, Karachi   1.3 Crore   \n",
       "106             Bahria Apartments, Bahria Town Karachi     96 Lakh   \n",
       "107  Bahria Town - Ali Block, Bahria Town - Precinc...  1.55 Crore   \n",
       "108     Bahria Town - Precinct 27, Bahria Town Karachi   1.7 Crore   \n",
       "109                       Bahria Town Karachi, Karachi     66 Lakh   \n",
       "\n",
       "    NoOfBedrooms NoOfBathrooms  AreaSqYards  \\\n",
       "50             3             3  235 Sq. Yd.   \n",
       "51             3             3  235 Sq. Yd.   \n",
       "52             1             1   59 Sq. Yd.   \n",
       "53             2             2  106 Sq. Yd.   \n",
       "54             3             3  125 Sq. Yd.   \n",
       "55             5             6  600 Sq. Yd.   \n",
       "56             5             6  500 Sq. Yd.   \n",
       "57             3             3  125 Sq. Yd.   \n",
       "58             2             2  102 Sq. Yd.   \n",
       "59             3             3  178 Sq. Yd.   \n",
       "60             5             5  375 Sq. Yd.   \n",
       "61             5             5  375 Sq. Yd.   \n",
       "62             6             6  500 Sq. Yd.   \n",
       "63             3             3  160 Sq. Yd.   \n",
       "64             4             5  120 Sq. Yd.   \n",
       "65             3             3  288 Sq. Yd.   \n",
       "66             4             4  120 Sq. Yd.   \n",
       "67             3             3  167 Sq. Yd.   \n",
       "68             2             2  128 Sq. Yd.   \n",
       "69             6             6  400 Sq. Yd.   \n",
       "70             3             3  194 Sq. Yd.   \n",
       "71             2             2  122 Sq. Yd.   \n",
       "72             3             3  128 Sq. Yd.   \n",
       "73             4             5  100 Sq. Yd.   \n",
       "74             6             6  500 Sq. Yd.   \n",
       "75             4             4  350 Sq. Yd.   \n",
       "76             2             2  106 Sq. Yd.   \n",
       "77             2             2  120 Sq. Yd.   \n",
       "78             5             5  375 Sq. Yd.   \n",
       "79             5             5  375 Sq. Yd.   \n",
       "80             5             5  375 Sq. Yd.   \n",
       "81             3             4  133 Sq. Yd.   \n",
       "82             3   125 Sq. Yd.            0   \n",
       "83             3             3  240 Sq. Yd.   \n",
       "84             2             2   89 Sq. Yd.   \n",
       "85             5             5  375 Sq. Yd.   \n",
       "86             5             5  375 Sq. Yd.   \n",
       "87             2             2  120 Sq. Yd.   \n",
       "88             3             4  189 Sq. Yd.   \n",
       "89             4             6  467 Sq. Yd.   \n",
       "90             3             5  294 Sq. Yd.   \n",
       "91             4             6  667 Sq. Yd.   \n",
       "92             3             3  100 Sq. Yd.   \n",
       "93             4             4  150 Sq. Yd.   \n",
       "94             6             6  500 Sq. Yd.   \n",
       "95             3             3  222 Sq. Yd.   \n",
       "96             4             4  100 Sq. Yd.   \n",
       "97             4             4  120 Sq. Yd.   \n",
       "98             3             3  152 Sq. Yd.   \n",
       "99             3             3  200 Sq. Yd.   \n",
       "100            5             5  428 Sq. Yd.   \n",
       "101            3             3  300 Sq. Yd.   \n",
       "102            5             5  427 Sq. Yd.   \n",
       "103            5             6  375 Sq. Yd.   \n",
       "104            3             4  289 Sq. Yd.   \n",
       "105            3             3  125 Sq. Yd.   \n",
       "106            2             2  109 Sq. Yd.   \n",
       "107            4             4  125 Sq. Yd.   \n",
       "108            3             3  235 Sq. Yd.   \n",
       "109            2             2   91 Sq. Yd.   \n",
       "\n",
       "                                            WebURL  \n",
       "50   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "51   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "52   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "53   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "54   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "55   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "56   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "57   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "58   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "59   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "60   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "61   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "62   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "63   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "64   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "65   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "66   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "67   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "68   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "69   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "70   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "71   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "72   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "73   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "74   https://www.zameen.com/Homes/Karachi-2-3.html  \n",
       "75   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "76   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "77   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "78   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "79   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "80   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "81   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "82   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "83   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "84   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "85   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "86   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "87   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "88   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "89   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "90   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "91   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "92   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "93   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "94   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "95   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "96   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "97   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "98   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "99   https://www.zameen.com/Homes/Karachi-2-4.html  \n",
       "100  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "101  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "102  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "103  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "104  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "105  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "106  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "107  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "108  https://www.zameen.com/Homes/Karachi-2-5.html  \n",
       "109  https://www.zameen.com/Homes/Karachi-2-5.html  "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.iloc[50:110,:]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.rename(columns={\"Property_Name\":\"Address\"},inplace=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>Address</th>\n",
       "      <th>Price</th>\n",
       "      <th>NoOfBedrooms</th>\n",
       "      <th>NoOfBathrooms</th>\n",
       "      <th>AreaSqYards</th>\n",
       "      <th>WebURL</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bahria Town Karachi, Karachi</td>\n",
       "      <td>42 Lakh</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>60 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-1.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Bahria Town - Precinct 17, Bahria Town Karachi</td>\n",
       "      <td>59 Lakh</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>161 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-1.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Bahria Paradise, Bahria Town Karachi</td>\n",
       "      <td>4.2 Crore</td>\n",
       "      <td>5</td>\n",
       "      <td>5</td>\n",
       "      <td>500 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-1.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Askari 5 - Sector J, Askari 5</td>\n",
       "      <td>3.75 Crore</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>300 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-1.html</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Bahria Town - Precinct 35, Bahria Sports City</td>\n",
       "      <td>2.1 Crore</td>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>350 Sq. Yd.</td>\n",
       "      <td>https://www.zameen.com/Homes/Karachi-2-1.html</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          Address       Price NoOfBedrooms  \\\n",
       "0                    Bahria Town Karachi, Karachi     42 Lakh            1   \n",
       "1  Bahria Town - Precinct 17, Bahria Town Karachi     59 Lakh            2   \n",
       "2            Bahria Paradise, Bahria Town Karachi   4.2 Crore            5   \n",
       "3                   Askari 5 - Sector J, Askari 5  3.75 Crore            3   \n",
       "4   Bahria Town - Precinct 35, Bahria Sports City   2.1 Crore            4   \n",
       "\n",
       "  NoOfBathrooms  AreaSqYards                                         WebURL  \n",
       "0             1   60 Sq. Yd.  https://www.zameen.com/Homes/Karachi-2-1.html  \n",
       "1             2  161 Sq. Yd.  https://www.zameen.com/Homes/Karachi-2-1.html  \n",
       "2             5  500 Sq. Yd.  https://www.zameen.com/Homes/Karachi-2-1.html  \n",
       "3             3  300 Sq. Yd.  https://www.zameen.com/Homes/Karachi-2-1.html  \n",
       "4             4  350 Sq. Yd.  https://www.zameen.com/Homes/Karachi-2-1.html  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"karachi_house_prices.csv\")"
   ]
  }
 ],
 "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.11.1"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}