v2-ML Model-bangalore_house_price_prediction.ipynb

{"nbformat":4,"nbformat_minor":0,"metadata":{"colab":{"name":"Copy of ML2 Model-bangalore_house_price_prediction.ipynb","provenance":[],"collapsed_sections":["Oh43OeUnfZAq"],"mount_file_id":"1IRlN0K3-yqqkzos3SUKgVyiHjJOBxQtG","authorship_tag":"ABX9TyOIYud2QNDIWB2Xh7v9T1ww"},"kernelspec":{"name":"python3","display_name":"Python 3"}},"cells":[{"cell_type":"markdown","metadata":{"id":"IpL5v1Sf3RWI","colab_type":"text"},"source":["# Bangalore House Price Prediction - Outlier Detection"]},{"cell_type":"markdown","metadata":{"id":"PVLMn1d8k7He","colab_type":"text"},"source":["This notebook only train ML model on different ml algorithms"]},{"cell_type":"code","metadata":{"id":"gOSX3Cyj3MMb","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":71},"executionInfo":{"status":"ok","timestamp":1593078487795,"user_tz":-330,"elapsed":2175,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"ce9f956d-30df-4c35-d70e-a9bc664bb2a8"},"source":["import numpy as np\n","import pandas as pd\n","import matplotlib.pyplot as plt\n","import seaborn as sns"],"execution_count":1,"outputs":[{"output_type":"stream","text":["/usr/local/lib/python3.6/dist-packages/statsmodels/tools/_testing.py:19: FutureWarning: pandas.util.testing is deprecated. Use the functions in the public API at pandas.testing instead.\n","  import pandas.util.testing as tm\n"],"name":"stderr"}]},{"cell_type":"code","metadata":{"id":"xRx0SRBGC54j","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1593078489034,"user_tz":-330,"elapsed":3393,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}}},"source":["pd.set_option(\"display.max_columns\", None)\n","pd.set_option(\"display.max_rows\", None)"],"execution_count":2,"outputs":[]},{"cell_type":"code","metadata":{"id":"bZyJo0ya2OVT","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078489036,"user_tz":-330,"elapsed":3360,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"78d9accb-2a46-4585-c954-7a134482dd0f"},"source":["\"\"\"from google.colab import files\n","files=files.upload()\n","df = pd.read_csv('oh_encoded_data.csv')\"\"\""],"execution_count":3,"outputs":[{"output_type":"execute_result","data":{"text/plain":["\"from google.colab import files\\nfiles=files.upload()\\ndf = pd.read_csv('oh_encoded_data.csv')\""]},"metadata":{"tags":[]},"execution_count":3}]},{"cell_type":"code","metadata":{"id":"Gp8WO-ZhNc6w","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078489647,"user_tz":-330,"elapsed":3934,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"54b49402-f5e1-4e5c-83d7-024916a9cca0"},"source":["# Get clean data\n","path = r\"https://drive.google.com/uc?export=download&id=1P49POlAk27uRzWKXoR2WaEfb1lyyfiRJ\" # oh_encoded_data.csv from drive\n","\n","# This file contain [area_type\tavailability\tlocation\tbath\tbalcony\tprice\ttotal_sqft_int\tbhk\tprice_per_sqft]\n","# and ['area_type','availability','location'] this are cat var\n","# We encoded few classes from above car var in OHE \n","\n","df = pd.read_csv(path)\n","df.shape"],"execution_count":4,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(7120, 109)"]},"metadata":{"tags":[]},"execution_count":4}]},{"cell_type":"code","metadata":{"id":"WP8pY6-IlxRJ","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078489650,"user_tz":-330,"elapsed":3899,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"4e9069ef-1af5-4e89-9f04-0df4d66a73b9"},"source":["df.shape"],"execution_count":5,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(7120, 109)"]},"metadata":{"tags":[]},"execution_count":5}]},{"cell_type":"code","metadata":{"id":"VFKjUlZtPQgS","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":258},"executionInfo":{"status":"ok","timestamp":1593078489653,"user_tz":-330,"elapsed":3862,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"0637f216-2a21-491b-f28d-fa5a70755b7c"},"source":["df.head()"],"execution_count":6,"outputs":[{"output_type":"execute_result","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>Unnamed: 0</th>\n","      <th>bath</th>\n","      <th>balcony</th>\n","      <th>price</th>\n","      <th>total_sqft_int</th>\n","      <th>bhk</th>\n","      <th>price_per_sqft</th>\n","      <th>area_typeSuper built-up  Area</th>\n","      <th>area_typeBuilt-up  Area</th>\n","      <th>area_typePlot  Area</th>\n","      <th>availability_Ready To Move</th>\n","      <th>location_Whitefield</th>\n","      <th>location_Sarjapur  Road</th>\n","      <th>location_Electronic City</th>\n","      <th>location_Raja Rajeshwari Nagar</th>\n","      <th>location_Marathahalli</th>\n","      <th>location_Haralur Road</th>\n","      <th>location_Hennur Road</th>\n","      <th>location_Bannerghatta Road</th>\n","      <th>location_Uttarahalli</th>\n","      <th>location_Thanisandra</th>\n","      <th>location_Electronic City Phase II</th>\n","      <th>location_Hebbal</th>\n","      <th>location_Yelahanka</th>\n","      <th>location_7th Phase JP Nagar</th>\n","      <th>location_Kanakpura Road</th>\n","      <th>location_KR Puram</th>\n","      <th>location_Sarjapur</th>\n","      <th>location_Rajaji Nagar</th>\n","      <th>location_Bellandur</th>\n","      <th>location_Kasavanhalli</th>\n","      <th>location_Begur Road</th>\n","      <th>location_Kothanur</th>\n","      <th>location_Banashankari</th>\n","      <th>location_Hormavu</th>\n","      <th>location_Harlur</th>\n","      <th>location_Akshaya Nagar</th>\n","      <th>location_Jakkur</th>\n","      <th>location_Electronics City Phase 1</th>\n","      <th>location_Varthur</th>\n","      <th>location_HSR Layout</th>\n","      <th>location_Chandapura</th>\n","      <th>location_Ramamurthy Nagar</th>\n","      <th>location_Hennur</th>\n","      <th>location_Kundalahalli</th>\n","      <th>location_Ramagondanahalli</th>\n","      <th>location_Kaggadasapura</th>\n","      <th>location_Koramangala</th>\n","      <th>location_Hulimavu</th>\n","      <th>location_Budigere</th>\n","      <th>location_Hoodi</th>\n","      <th>location_Malleshwaram</th>\n","      <th>location_JP Nagar</th>\n","      <th>location_Hegde Nagar</th>\n","      <th>location_Yeshwanthpur</th>\n","      <th>location_8th Phase JP Nagar</th>\n","      <th>location_Gottigere</th>\n","      <th>location_Channasandra</th>\n","      <th>location_Bisuvanahalli</th>\n","      <th>location_Vittasandra</th>\n","      <th>location_Indira Nagar</th>\n","      <th>location_Brookefield</th>\n","      <th>location_Vijayanagar</th>\n","      <th>location_Old Airport Road</th>\n","      <th>location_Sahakara Nagar</th>\n","      <th>location_Hosa Road</th>\n","      <th>location_Kengeri</th>\n","      <th>location_Bommasandra</th>\n","      <th>location_Green Glen Layout</th>\n","      <th>location_Balagere</th>\n","      <th>location_Old Madras Road</th>\n","      <th>location_Kudlu Gate</th>\n","      <th>location_Panathur</th>\n","      <th>location_Rachenahalli</th>\n","      <th>location_Yelahanka New Town</th>\n","      <th>location_Jigani</th>\n","      <th>location_Kadugodi</th>\n","      <th>location_Talaghattapura</th>\n","      <th>location_Thigalarapalya</th>\n","      <th>location_Mysore Road</th>\n","      <th>location_Ambedkar Nagar</th>\n","      <th>location_Frazer Town</th>\n","      <th>location_Dodda Nekkundi</th>\n","      <th>location_Attibele</th>\n","      <th>location_Kanakapura</th>\n","      <th>location_Devanahalli</th>\n","      <th>location_Nagarbhavi</th>\n","      <th>location_TC Palaya</th>\n","      <th>location_Lakshminarayana Pura</th>\n","      <th>location_5th Phase JP Nagar</th>\n","      <th>location_Anekal</th>\n","      <th>location_Ananth Nagar</th>\n","      <th>location_Jalahalli</th>\n","      <th>location_CV Raman Nagar</th>\n","      <th>location_Kengeri Satellite Town</th>\n","      <th>location_Kudlu</th>\n","      <th>location_Bhoganhalli</th>\n","      <th>location_Doddathoguru</th>\n","      <th>location_Subramanyapura</th>\n","      <th>location_Kalena Agrahara</th>\n","      <th>location_Horamavu Agara</th>\n","      <th>location_Hosur Road</th>\n","      <th>location_Vidyaranyapura</th>\n","      <th>location_Hebbal Kempapura</th>\n","      <th>location_BTM 2nd Stage</th>\n","      <th>location_Mahadevpura</th>\n","      <th>location_Horamavu Banaswadi</th>\n","      <th>location_Domlur</th>\n","      <th>location_Tumkur Road</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>0</td>\n","      <td>3.0</td>\n","      <td>2.0</td>\n","      <td>150.0</td>\n","      <td>1672.0</td>\n","      <td>3</td>\n","      <td>8971.291866</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>1</td>\n","      <td>3.0</td>\n","      <td>3.0</td>\n","      <td>149.0</td>\n","      <td>1750.0</td>\n","      <td>3</td>\n","      <td>8514.285714</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2</td>\n","      <td>3.0</td>\n","      <td>2.0</td>\n","      <td>150.0</td>\n","      <td>1750.0</td>\n","      <td>3</td>\n","      <td>8571.428571</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>4</td>\n","      <td>2.0</td>\n","      <td>2.0</td>\n","      <td>40.0</td>\n","      <td>1250.0</td>\n","      <td>2</td>\n","      <td>3200.000000</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>5</td>\n","      <td>2.0</td>\n","      <td>2.0</td>\n","      <td>83.0</td>\n","      <td>1200.0</td>\n","      <td>2</td>\n","      <td>6916.666667</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   Unnamed: 0  bath  balcony  price  total_sqft_int  bhk  price_per_sqft  \\\n","0           0   3.0      2.0  150.0          1672.0    3     8971.291866   \n","1           1   3.0      3.0  149.0          1750.0    3     8514.285714   \n","2           2   3.0      2.0  150.0          1750.0    3     8571.428571   \n","3           4   2.0      2.0   40.0          1250.0    2     3200.000000   \n","4           5   2.0      2.0   83.0          1200.0    2     6916.666667   \n","\n","   area_typeSuper built-up  Area  area_typeBuilt-up  Area  \\\n","0                              1                        0   \n","1                              0                        1   \n","2                              1                        0   \n","3                              1                        0   \n","4                              0                        0   \n","\n","   area_typePlot  Area  availability_Ready To Move  location_Whitefield  \\\n","0                    0                           1                    0   \n","1                    0                           1                    0   \n","2                    0                           1                    0   \n","3                    0                           1                    0   \n","4                    1                           1                    0   \n","\n","   location_Sarjapur  Road  location_Electronic City  \\\n","0                        0                         0   \n","1                        0                         0   \n","2                        0                         0   \n","3                        0                         0   \n","4                        0                         0   \n","\n","   location_Raja Rajeshwari Nagar  location_Marathahalli  \\\n","0                               0                      0   \n","1                               0                      0   \n","2                               0                      0   \n","3                               0                      0   \n","4                               0                      0   \n","\n","   location_Haralur Road  location_Hennur Road  location_Bannerghatta Road  \\\n","0                      0                     0                           0   \n","1                      0                     0                           0   \n","2                      0                     0                           0   \n","3                      0                     0                           0   \n","4                      0                     0                           0   \n","\n","   location_Uttarahalli  location_Thanisandra  \\\n","0                     0                     0   \n","1                     0                     0   \n","2                     0                     0   \n","3                     0                     0   \n","4                     0                     0   \n","\n","   location_Electronic City Phase II  location_Hebbal  location_Yelahanka  \\\n","0                                  0                0                   0   \n","1                                  0                0                   0   \n","2                                  0                0                   0   \n","3                                  0                0                   0   \n","4                                  0                0                   0   \n","\n","   location_7th Phase JP Nagar  location_Kanakpura Road  location_KR Puram  \\\n","0                            0                        0                  0   \n","1                            0                        0                  0   \n","2                            0                        0                  0   \n","3                            0                        0                  0   \n","4                            0                        0                  0   \n","\n","   location_Sarjapur  location_Rajaji Nagar  location_Bellandur  \\\n","0                  0                      0                   0   \n","1                  0                      0                   0   \n","2                  0                      0                   0   \n","3                  0                      0                   0   \n","4                  0                      0                   0   \n","\n","   location_Kasavanhalli  location_Begur Road  location_Kothanur  \\\n","0                      0                    0                  0   \n","1                      0                    0                  0   \n","2                      0                    0                  0   \n","3                      0                    0                  0   \n","4                      0                    0                  0   \n","\n","   location_Banashankari  location_Hormavu  location_Harlur  \\\n","0                      0                 0                0   \n","1                      0                 0                0   \n","2                      0                 0                0   \n","3                      0                 0                0   \n","4                      0                 0                0   \n","\n","   location_Akshaya Nagar  location_Jakkur  location_Electronics City Phase 1  \\\n","0                       0                0                                  0   \n","1                       0                0                                  0   \n","2                       0                0                                  0   \n","3                       0                0                                  0   \n","4                       0                0                                  0   \n","\n","   location_Varthur  location_HSR Layout  location_Chandapura  \\\n","0                 0                    0                    0   \n","1                 0                    0                    0   \n","2                 0                    0                    0   \n","3                 0                    0                    0   \n","4                 0                    0                    0   \n","\n","   location_Ramamurthy Nagar  location_Hennur  location_Kundalahalli  \\\n","0                          0                0                      0   \n","1                          0                0                      0   \n","2                          0                0                      0   \n","3                          0                0                      0   \n","4                          0                0                      0   \n","\n","   location_Ramagondanahalli  location_Kaggadasapura  location_Koramangala  \\\n","0                          0                       0                     0   \n","1                          0                       0                     0   \n","2                          0                       0                     0   \n","3                          0                       0                     0   \n","4                          0                       0                     0   \n","\n","   location_Hulimavu  location_Budigere  location_Hoodi  \\\n","0                  0                  0               0   \n","1                  0                  0               0   \n","2                  0                  0               0   \n","3                  0                  0               0   \n","4                  0                  0               0   \n","\n","   location_Malleshwaram  location_JP Nagar  location_Hegde Nagar  \\\n","0                      0                  0                     0   \n","1                      0                  0                     0   \n","2                      0                  0                     0   \n","3                      0                  0                     0   \n","4                      0                  0                     0   \n","\n","   location_Yeshwanthpur  location_8th Phase JP Nagar  location_Gottigere  \\\n","0                      0                            0                   0   \n","1                      0                            0                   0   \n","2                      0                            0                   0   \n","3                      0                            0                   0   \n","4                      0                            0                   0   \n","\n","   location_Channasandra  location_Bisuvanahalli  location_Vittasandra  \\\n","0                      0                       0                     0   \n","1                      0                       0                     0   \n","2                      0                       0                     0   \n","3                      0                       0                     0   \n","4                      0                       0                     0   \n","\n","   location_Indira Nagar  location_Brookefield  location_Vijayanagar  \\\n","0                      0                     0                     0   \n","1                      0                     0                     0   \n","2                      0                     0                     0   \n","3                      0                     0                     0   \n","4                      0                     0                     0   \n","\n","   location_Old Airport Road  location_Sahakara Nagar  location_Hosa Road  \\\n","0                          0                        0                   0   \n","1                          0                        0                   0   \n","2                          0                        0                   0   \n","3                          0                        0                   0   \n","4                          0                        0                   0   \n","\n","   location_Kengeri  location_Bommasandra  location_Green Glen Layout  \\\n","0                 0                     0                           0   \n","1                 0                     0                           0   \n","2                 0                     0                           0   \n","3                 0                     0                           0   \n","4                 0                     0                           0   \n","\n","   location_Balagere  location_Old Madras Road  location_Kudlu Gate  \\\n","0                  0                         0                    0   \n","1                  0                         0                    0   \n","2                  0                         0                    0   \n","3                  0                         0                    0   \n","4                  0                         0                    0   \n","\n","   location_Panathur  location_Rachenahalli  location_Yelahanka New Town  \\\n","0                  0                      0                            0   \n","1                  0                      0                            0   \n","2                  0                      0                            0   \n","3                  0                      0                            0   \n","4                  0                      0                            0   \n","\n","   location_Jigani  location_Kadugodi  location_Talaghattapura  \\\n","0                0                  0                        0   \n","1                0                  0                        0   \n","2                0                  0                        0   \n","3                0                  0                        0   \n","4                0                  0                        0   \n","\n","   location_Thigalarapalya  location_Mysore Road  location_Ambedkar Nagar  \\\n","0                        0                     0                        0   \n","1                        0                     0                        0   \n","2                        0                     0                        0   \n","3                        0                     0                        0   \n","4                        0                     0                        0   \n","\n","   location_Frazer Town  location_Dodda Nekkundi  location_Attibele  \\\n","0                     0                        0                  0   \n","1                     0                        0                  0   \n","2                     0                        0                  0   \n","3                     0                        0                  0   \n","4                     0                        0                  0   \n","\n","   location_Kanakapura  location_Devanahalli  location_Nagarbhavi  \\\n","0                    0                     0                    0   \n","1                    0                     0                    0   \n","2                    0                     0                    0   \n","3                    0                     0                    0   \n","4                    0                     0                    0   \n","\n","   location_TC Palaya  location_Lakshminarayana Pura  \\\n","0                   0                              0   \n","1                   0                              0   \n","2                   0                              0   \n","3                   0                              0   \n","4                   0                              0   \n","\n","   location_5th Phase JP Nagar  location_Anekal  location_Ananth Nagar  \\\n","0                            0                0                      0   \n","1                            0                0                      0   \n","2                            0                0                      0   \n","3                            0                0                      0   \n","4                            0                0                      0   \n","\n","   location_Jalahalli  location_CV Raman Nagar  \\\n","0                   0                        0   \n","1                   0                        0   \n","2                   0                        0   \n","3                   0                        0   \n","4                   0                        0   \n","\n","   location_Kengeri Satellite Town  location_Kudlu  location_Bhoganhalli  \\\n","0                                0               0                     0   \n","1                                0               0                     0   \n","2                                0               0                     0   \n","3                                0               0                     0   \n","4                                0               0                     0   \n","\n","   location_Doddathoguru  location_Subramanyapura  location_Kalena Agrahara  \\\n","0                      0                        0                         0   \n","1                      0                        0                         0   \n","2                      0                        0                         0   \n","3                      0                        0                         0   \n","4                      0                        0                         0   \n","\n","   location_Horamavu Agara  location_Hosur Road  location_Vidyaranyapura  \\\n","0                        0                    0                        0   \n","1                        0                    0                        0   \n","2                        0                    0                        0   \n","3                        0                    0                        0   \n","4                        0                    0                        0   \n","\n","   location_Hebbal Kempapura  location_BTM 2nd Stage  location_Mahadevpura  \\\n","0                          0                       0                     0   \n","1                          0                       0                     0   \n","2                          0                       0                     0   \n","3                          0                       0                     0   \n","4                          0                       0                     0   \n","\n","   location_Horamavu Banaswadi  location_Domlur  location_Tumkur Road  \n","0                            0                0                     0  \n","1                            0                0                     0  \n","2                            0                0                     0  \n","3                            0                0                     0  \n","4                            0                0                     0  "]},"metadata":{"tags":[]},"execution_count":6}]},{"cell_type":"code","metadata":{"id":"ye85e6KVQg55","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":258},"executionInfo":{"status":"ok","timestamp":1593078489654,"user_tz":-330,"elapsed":3822,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"5264f298-b814-4821-dcea-fc89a4c7d31d"},"source":["df = df.drop(['Unnamed: 0'], axis=1)\n","df.head()"],"execution_count":7,"outputs":[{"output_type":"execute_result","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>bath</th>\n","      <th>balcony</th>\n","      <th>price</th>\n","      <th>total_sqft_int</th>\n","      <th>bhk</th>\n","      <th>price_per_sqft</th>\n","      <th>area_typeSuper built-up  Area</th>\n","      <th>area_typeBuilt-up  Area</th>\n","      <th>area_typePlot  Area</th>\n","      <th>availability_Ready To Move</th>\n","      <th>location_Whitefield</th>\n","      <th>location_Sarjapur  Road</th>\n","      <th>location_Electronic City</th>\n","      <th>location_Raja Rajeshwari Nagar</th>\n","      <th>location_Marathahalli</th>\n","      <th>location_Haralur Road</th>\n","      <th>location_Hennur Road</th>\n","      <th>location_Bannerghatta Road</th>\n","      <th>location_Uttarahalli</th>\n","      <th>location_Thanisandra</th>\n","      <th>location_Electronic City Phase II</th>\n","      <th>location_Hebbal</th>\n","      <th>location_Yelahanka</th>\n","      <th>location_7th Phase JP Nagar</th>\n","      <th>location_Kanakpura Road</th>\n","      <th>location_KR Puram</th>\n","      <th>location_Sarjapur</th>\n","      <th>location_Rajaji Nagar</th>\n","      <th>location_Bellandur</th>\n","      <th>location_Kasavanhalli</th>\n","      <th>location_Begur Road</th>\n","      <th>location_Kothanur</th>\n","      <th>location_Banashankari</th>\n","      <th>location_Hormavu</th>\n","      <th>location_Harlur</th>\n","      <th>location_Akshaya Nagar</th>\n","      <th>location_Jakkur</th>\n","      <th>location_Electronics City Phase 1</th>\n","      <th>location_Varthur</th>\n","      <th>location_HSR Layout</th>\n","      <th>location_Chandapura</th>\n","      <th>location_Ramamurthy Nagar</th>\n","      <th>location_Hennur</th>\n","      <th>location_Kundalahalli</th>\n","      <th>location_Ramagondanahalli</th>\n","      <th>location_Kaggadasapura</th>\n","      <th>location_Koramangala</th>\n","      <th>location_Hulimavu</th>\n","      <th>location_Budigere</th>\n","      <th>location_Hoodi</th>\n","      <th>location_Malleshwaram</th>\n","      <th>location_JP Nagar</th>\n","      <th>location_Hegde Nagar</th>\n","      <th>location_Yeshwanthpur</th>\n","      <th>location_8th Phase JP Nagar</th>\n","      <th>location_Gottigere</th>\n","      <th>location_Channasandra</th>\n","      <th>location_Bisuvanahalli</th>\n","      <th>location_Vittasandra</th>\n","      <th>location_Indira Nagar</th>\n","      <th>location_Brookefield</th>\n","      <th>location_Vijayanagar</th>\n","      <th>location_Old Airport Road</th>\n","      <th>location_Sahakara Nagar</th>\n","      <th>location_Hosa Road</th>\n","      <th>location_Kengeri</th>\n","      <th>location_Bommasandra</th>\n","      <th>location_Green Glen Layout</th>\n","      <th>location_Balagere</th>\n","      <th>location_Old Madras Road</th>\n","      <th>location_Kudlu Gate</th>\n","      <th>location_Panathur</th>\n","      <th>location_Rachenahalli</th>\n","      <th>location_Yelahanka New Town</th>\n","      <th>location_Jigani</th>\n","      <th>location_Kadugodi</th>\n","      <th>location_Talaghattapura</th>\n","      <th>location_Thigalarapalya</th>\n","      <th>location_Mysore Road</th>\n","      <th>location_Ambedkar Nagar</th>\n","      <th>location_Frazer Town</th>\n","      <th>location_Dodda Nekkundi</th>\n","      <th>location_Attibele</th>\n","      <th>location_Kanakapura</th>\n","      <th>location_Devanahalli</th>\n","      <th>location_Nagarbhavi</th>\n","      <th>location_TC Palaya</th>\n","      <th>location_Lakshminarayana Pura</th>\n","      <th>location_5th Phase JP Nagar</th>\n","      <th>location_Anekal</th>\n","      <th>location_Ananth Nagar</th>\n","      <th>location_Jalahalli</th>\n","      <th>location_CV Raman Nagar</th>\n","      <th>location_Kengeri Satellite Town</th>\n","      <th>location_Kudlu</th>\n","      <th>location_Bhoganhalli</th>\n","      <th>location_Doddathoguru</th>\n","      <th>location_Subramanyapura</th>\n","      <th>location_Kalena Agrahara</th>\n","      <th>location_Horamavu Agara</th>\n","      <th>location_Hosur Road</th>\n","      <th>location_Vidyaranyapura</th>\n","      <th>location_Hebbal Kempapura</th>\n","      <th>location_BTM 2nd Stage</th>\n","      <th>location_Mahadevpura</th>\n","      <th>location_Horamavu Banaswadi</th>\n","      <th>location_Domlur</th>\n","      <th>location_Tumkur Road</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>3.0</td>\n","      <td>2.0</td>\n","      <td>150.0</td>\n","      <td>1672.0</td>\n","      <td>3</td>\n","      <td>8971.291866</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>3.0</td>\n","      <td>3.0</td>\n","      <td>149.0</td>\n","      <td>1750.0</td>\n","      <td>3</td>\n","      <td>8514.285714</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>3.0</td>\n","      <td>2.0</td>\n","      <td>150.0</td>\n","      <td>1750.0</td>\n","      <td>3</td>\n","      <td>8571.428571</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2.0</td>\n","      <td>2.0</td>\n","      <td>40.0</td>\n","      <td>1250.0</td>\n","      <td>2</td>\n","      <td>3200.000000</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2.0</td>\n","      <td>2.0</td>\n","      <td>83.0</td>\n","      <td>1200.0</td>\n","      <td>2</td>\n","      <td>6916.666667</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>1</td>\n","      <td>1</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","      <td>0</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["   bath  balcony  price  total_sqft_int  bhk  price_per_sqft  \\\n","0   3.0      2.0  150.0          1672.0    3     8971.291866   \n","1   3.0      3.0  149.0          1750.0    3     8514.285714   \n","2   3.0      2.0  150.0          1750.0    3     8571.428571   \n","3   2.0      2.0   40.0          1250.0    2     3200.000000   \n","4   2.0      2.0   83.0          1200.0    2     6916.666667   \n","\n","   area_typeSuper built-up  Area  area_typeBuilt-up  Area  \\\n","0                              1                        0   \n","1                              0                        1   \n","2                              1                        0   \n","3                              1                        0   \n","4                              0                        0   \n","\n","   area_typePlot  Area  availability_Ready To Move  location_Whitefield  \\\n","0                    0                           1                    0   \n","1                    0                           1                    0   \n","2                    0                           1                    0   \n","3                    0                           1                    0   \n","4                    1                           1                    0   \n","\n","   location_Sarjapur  Road  location_Electronic City  \\\n","0                        0                         0   \n","1                        0                         0   \n","2                        0                         0   \n","3                        0                         0   \n","4                        0                         0   \n","\n","   location_Raja Rajeshwari Nagar  location_Marathahalli  \\\n","0                               0                      0   \n","1                               0                      0   \n","2                               0                      0   \n","3                               0                      0   \n","4                               0                      0   \n","\n","   location_Haralur Road  location_Hennur Road  location_Bannerghatta Road  \\\n","0                      0                     0                           0   \n","1                      0                     0                           0   \n","2                      0                     0                           0   \n","3                      0                     0                           0   \n","4                      0                     0                           0   \n","\n","   location_Uttarahalli  location_Thanisandra  \\\n","0                     0                     0   \n","1                     0                     0   \n","2                     0                     0   \n","3                     0                     0   \n","4                     0                     0   \n","\n","   location_Electronic City Phase II  location_Hebbal  location_Yelahanka  \\\n","0                                  0                0                   0   \n","1                                  0                0                   0   \n","2                                  0                0                   0   \n","3                                  0                0                   0   \n","4                                  0                0                   0   \n","\n","   location_7th Phase JP Nagar  location_Kanakpura Road  location_KR Puram  \\\n","0                            0                        0                  0   \n","1                            0                        0                  0   \n","2                            0                        0                  0   \n","3                            0                        0                  0   \n","4                            0                        0                  0   \n","\n","   location_Sarjapur  location_Rajaji Nagar  location_Bellandur  \\\n","0                  0                      0                   0   \n","1                  0                      0                   0   \n","2                  0                      0                   0   \n","3                  0                      0                   0   \n","4                  0                      0                   0   \n","\n","   location_Kasavanhalli  location_Begur Road  location_Kothanur  \\\n","0                      0                    0                  0   \n","1                      0                    0                  0   \n","2                      0                    0                  0   \n","3                      0                    0                  0   \n","4                      0                    0                  0   \n","\n","   location_Banashankari  location_Hormavu  location_Harlur  \\\n","0                      0                 0                0   \n","1                      0                 0                0   \n","2                      0                 0                0   \n","3                      0                 0                0   \n","4                      0                 0                0   \n","\n","   location_Akshaya Nagar  location_Jakkur  location_Electronics City Phase 1  \\\n","0                       0                0                                  0   \n","1                       0                0                                  0   \n","2                       0                0                                  0   \n","3                       0                0                                  0   \n","4                       0                0                                  0   \n","\n","   location_Varthur  location_HSR Layout  location_Chandapura  \\\n","0                 0                    0                    0   \n","1                 0                    0                    0   \n","2                 0                    0                    0   \n","3                 0                    0                    0   \n","4                 0                    0                    0   \n","\n","   location_Ramamurthy Nagar  location_Hennur  location_Kundalahalli  \\\n","0                          0                0                      0   \n","1                          0                0                      0   \n","2                          0                0                      0   \n","3                          0                0                      0   \n","4                          0                0                      0   \n","\n","   location_Ramagondanahalli  location_Kaggadasapura  location_Koramangala  \\\n","0                          0                       0                     0   \n","1                          0                       0                     0   \n","2                          0                       0                     0   \n","3                          0                       0                     0   \n","4                          0                       0                     0   \n","\n","   location_Hulimavu  location_Budigere  location_Hoodi  \\\n","0                  0                  0               0   \n","1                  0                  0               0   \n","2                  0                  0               0   \n","3                  0                  0               0   \n","4                  0                  0               0   \n","\n","   location_Malleshwaram  location_JP Nagar  location_Hegde Nagar  \\\n","0                      0                  0                     0   \n","1                      0                  0                     0   \n","2                      0                  0                     0   \n","3                      0                  0                     0   \n","4                      0                  0                     0   \n","\n","   location_Yeshwanthpur  location_8th Phase JP Nagar  location_Gottigere  \\\n","0                      0                            0                   0   \n","1                      0                            0                   0   \n","2                      0                            0                   0   \n","3                      0                            0                   0   \n","4                      0                            0                   0   \n","\n","   location_Channasandra  location_Bisuvanahalli  location_Vittasandra  \\\n","0                      0                       0                     0   \n","1                      0                       0                     0   \n","2                      0                       0                     0   \n","3                      0                       0                     0   \n","4                      0                       0                     0   \n","\n","   location_Indira Nagar  location_Brookefield  location_Vijayanagar  \\\n","0                      0                     0                     0   \n","1                      0                     0                     0   \n","2                      0                     0                     0   \n","3                      0                     0                     0   \n","4                      0                     0                     0   \n","\n","   location_Old Airport Road  location_Sahakara Nagar  location_Hosa Road  \\\n","0                          0                        0                   0   \n","1                          0                        0                   0   \n","2                          0                        0                   0   \n","3                          0                        0                   0   \n","4                          0                        0                   0   \n","\n","   location_Kengeri  location_Bommasandra  location_Green Glen Layout  \\\n","0                 0                     0                           0   \n","1                 0                     0                           0   \n","2                 0                     0                           0   \n","3                 0                     0                           0   \n","4                 0                     0                           0   \n","\n","   location_Balagere  location_Old Madras Road  location_Kudlu Gate  \\\n","0                  0                         0                    0   \n","1                  0                         0                    0   \n","2                  0                         0                    0   \n","3                  0                         0                    0   \n","4                  0                         0                    0   \n","\n","   location_Panathur  location_Rachenahalli  location_Yelahanka New Town  \\\n","0                  0                      0                            0   \n","1                  0                      0                            0   \n","2                  0                      0                            0   \n","3                  0                      0                            0   \n","4                  0                      0                            0   \n","\n","   location_Jigani  location_Kadugodi  location_Talaghattapura  \\\n","0                0                  0                        0   \n","1                0                  0                        0   \n","2                0                  0                        0   \n","3                0                  0                        0   \n","4                0                  0                        0   \n","\n","   location_Thigalarapalya  location_Mysore Road  location_Ambedkar Nagar  \\\n","0                        0                     0                        0   \n","1                        0                     0                        0   \n","2                        0                     0                        0   \n","3                        0                     0                        0   \n","4                        0                     0                        0   \n","\n","   location_Frazer Town  location_Dodda Nekkundi  location_Attibele  \\\n","0                     0                        0                  0   \n","1                     0                        0                  0   \n","2                     0                        0                  0   \n","3                     0                        0                  0   \n","4                     0                        0                  0   \n","\n","   location_Kanakapura  location_Devanahalli  location_Nagarbhavi  \\\n","0                    0                     0                    0   \n","1                    0                     0                    0   \n","2                    0                     0                    0   \n","3                    0                     0                    0   \n","4                    0                     0                    0   \n","\n","   location_TC Palaya  location_Lakshminarayana Pura  \\\n","0                   0                              0   \n","1                   0                              0   \n","2                   0                              0   \n","3                   0                              0   \n","4                   0                              0   \n","\n","   location_5th Phase JP Nagar  location_Anekal  location_Ananth Nagar  \\\n","0                            0                0                      0   \n","1                            0                0                      0   \n","2                            0                0                      0   \n","3                            0                0                      0   \n","4                            0                0                      0   \n","\n","   location_Jalahalli  location_CV Raman Nagar  \\\n","0                   0                        0   \n","1                   0                        0   \n","2                   0                        0   \n","3                   0                        0   \n","4                   0                        0   \n","\n","   location_Kengeri Satellite Town  location_Kudlu  location_Bhoganhalli  \\\n","0                                0               0                     0   \n","1                                0               0                     0   \n","2                                0               0                     0   \n","3                                0               0                     0   \n","4                                0               0                     0   \n","\n","   location_Doddathoguru  location_Subramanyapura  location_Kalena Agrahara  \\\n","0                      0                        0                         0   \n","1                      0                        0                         0   \n","2                      0                        0                         0   \n","3                      0                        0                         0   \n","4                      0                        0                         0   \n","\n","   location_Horamavu Agara  location_Hosur Road  location_Vidyaranyapura  \\\n","0                        0                    0                        0   \n","1                        0                    0                        0   \n","2                        0                    0                        0   \n","3                        0                    0                        0   \n","4                        0                    0                        0   \n","\n","   location_Hebbal Kempapura  location_BTM 2nd Stage  location_Mahadevpura  \\\n","0                          0                       0                     0   \n","1                          0                       0                     0   \n","2                          0                       0                     0   \n","3                          0                       0                     0   \n","4                          0                       0                     0   \n","\n","   location_Horamavu Banaswadi  location_Domlur  location_Tumkur Road  \n","0                            0                0                     0  \n","1                            0                0                     0  \n","2                            0                0                     0  \n","3                            0                0                     0  \n","4                            0                0                     0  "]},"metadata":{"tags":[]},"execution_count":7}]},{"cell_type":"code","metadata":{"id":"y7UEhvYVSK4J","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078489655,"user_tz":-330,"elapsed":3778,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"deeea3d6-db97-4f54-89eb-aa75064f7a59"},"source":["df.shape"],"execution_count":8,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(7120, 108)"]},"metadata":{"tags":[]},"execution_count":8}]},{"cell_type":"markdown","metadata":{"id":"axowdsatcJaQ","colab_type":"text"},"source":["## Split Dataset in train and test"]},{"cell_type":"code","metadata":{"id":"PU_DeM90b7As","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":51},"executionInfo":{"status":"ok","timestamp":1593078489656,"user_tz":-330,"elapsed":3736,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"bab4699a-6418-4af5-bfbe-69424bb17b8b"},"source":["X = df.drop(\"price\", axis=1)\n","y = df['price']\n","print('Shape of X = ', X.shape)\n","print('Shape of y = ', y.shape)"],"execution_count":9,"outputs":[{"output_type":"stream","text":["Shape of X =  (7120, 107)\n","Shape of y =  (7120,)\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"aNVLPL-rcNwa","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":85},"executionInfo":{"status":"ok","timestamp":1593078489657,"user_tz":-330,"elapsed":3693,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"b24989dd-d514-407f-eae1-4f982084621a"},"source":["from sklearn.model_selection import train_test_split\n","X_train, X_test, y_train, y_test = train_test_split(X, y, test_size = 0.2, random_state = 51)\n","print('Shape of X_train = ', X_train.shape)\n","print('Shape of y_train = ', y_train.shape)\n","print('Shape of X_test = ', X_test.shape)\n","print('Shape of y_test = ', y_test.shape)"],"execution_count":10,"outputs":[{"output_type":"stream","text":["Shape of X_train =  (5696, 107)\n","Shape of y_train =  (5696,)\n","Shape of X_test =  (1424, 107)\n","Shape of y_test =  (1424,)\n"],"name":"stdout"}]},{"cell_type":"markdown","metadata":{"id":"k65LC4_qcYpm","colab_type":"text"},"source":["## Feature Scaling"]},{"cell_type":"code","metadata":{"id":"D1BCc8gAcUi6","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1593078490090,"user_tz":-330,"elapsed":4112,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}}},"source":["from sklearn.preprocessing import StandardScaler\n","sc = StandardScaler()\n","sc.fit(X_train)\n","X_train= sc.transform(X_train)\n","X_test = sc.transform(X_test)"],"execution_count":11,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"Oh43OeUnfZAq","colab_type":"text"},"source":["## Machine Learning Model Training"]},{"cell_type":"markdown","metadata":{"id":"d9-YKvESfcmd","colab_type":"text"},"source":["## Linear Regression"]},{"cell_type":"code","metadata":{"id":"GfPL9vJLcfXr","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1593078490092,"user_tz":-330,"elapsed":4105,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}}},"source":["from sklearn.linear_model import LinearRegression\n","from sklearn.linear_model import Lasso\n","from sklearn.linear_model import Ridge\n","from sklearn.metrics import mean_squared_error\n","lr = LinearRegression()\n","lr_lasso = Lasso()\n","lr_ridge = Ridge()"],"execution_count":12,"outputs":[]},{"cell_type":"code","metadata":{"id":"pG9byhg5YWGR","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1593078490094,"user_tz":-330,"elapsed":4100,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}}},"source":["def rmse(y_test, y_pred):\n","  return np.sqrt(mean_squared_error(y_test, y_pred))"],"execution_count":13,"outputs":[]},{"cell_type":"code","metadata":{"id":"WYm8ArSoff1p","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078490095,"user_tz":-330,"elapsed":4027,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"b315cac3-9809-467c-87f6-fb54f1e5918c"},"source":["lr.fit(X_train, y_train)\n","lr_score = lr.score(X_test, y_test) # with all num var 0.7842744111909903\n","lr_rmse = rmse(y_test, lr.predict(X_test))\n","lr_score, lr_rmse"],"execution_count":14,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(0.7903837092682254, 64.89843531105606)"]},"metadata":{"tags":[]},"execution_count":14}]},{"cell_type":"code","metadata":{"id":"sEhTsgE6fnXp","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078490096,"user_tz":-330,"elapsed":3988,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"6170272d-4954-4045-e93f-49339b531559"},"source":["# Lasso \n","lr_lasso.fit(X_train, y_train)\n","lr_lasso_score=lr_lasso.score(X_test, y_test) # with balcony 0.5162364637824872\n","lr_lasso_rmse = rmse(y_test, lr_lasso.predict(X_test))\n","lr_lasso_score, lr_lasso_rmse"],"execution_count":15,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(0.803637294021051, 62.81324273988926)"]},"metadata":{"tags":[]},"execution_count":15}]},{"cell_type":"markdown","metadata":{"id":"73sB16uxfwRm","colab_type":"text"},"source":["## Support Vector Machine"]},{"cell_type":"code","metadata":{"id":"aep38HxxfsbA","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078501154,"user_tz":-330,"elapsed":15003,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"ecb5b52f-8743-46a6-ecfb-b69cd5e9d06f"},"source":["from sklearn.svm import SVR\n","svr = SVR()\n","svr.fit(X_train,y_train)\n","svr_score=svr.score(X_test,y_test) # with 0.2630802200711362\n","svr_rmse = rmse(y_test, svr.predict(X_test))\n","svr_score, svr_rmse"],"execution_count":16,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(0.20638035840828173, 126.27806378079055)"]},"metadata":{"tags":[]},"execution_count":16}]},{"cell_type":"markdown","metadata":{"id":"w9-nexcsf5G3","colab_type":"text"},"source":["## Random Forest Regressor"]},{"cell_type":"code","metadata":{"id":"ArlNrxFJf1ey","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078504362,"user_tz":-330,"elapsed":18171,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"90487329-8ad6-4625-a01e-f915975ba241"},"source":["from sklearn.ensemble import RandomForestRegressor\n","rfr = RandomForestRegressor()\n","rfr.fit(X_train,y_train)\n","rfr_score=rfr.score(X_test,y_test) # with 0.8863376025408044\n","rfr_rmse = rmse(y_test, rfr.predict(X_test))\n","rfr_score, rfr_rmse"],"execution_count":17,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(0.8896232895502098, 47.09344200463701)"]},"metadata":{"tags":[]},"execution_count":17}]},{"cell_type":"markdown","metadata":{"id":"JjxIDyROgFj4","colab_type":"text"},"source":["## XGBoost"]},{"cell_type":"code","metadata":{"id":"GefSOPbqf-4d","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":51},"executionInfo":{"status":"ok","timestamp":1593078505494,"user_tz":-330,"elapsed":19264,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"6f6f8cfe-28fa-452e-aebb-468109b3944c"},"source":["import xgboost\n","xgb_reg = xgboost.XGBRegressor()\n","xgb_reg.fit(X_train,y_train)\n","xgb_reg_score=xgb_reg.score(X_test,y_test) # with 0.8838865742273464\n","xgb_reg_rmse = rmse(y_test, xgb_reg.predict(X_test))\n","xgb_reg_score, xgb_reg_rmse"],"execution_count":18,"outputs":[{"output_type":"stream","text":["[09:48:22] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n"],"name":"stdout"},{"output_type":"execute_result","data":{"text/plain":["(0.8759391907485039, 49.92740744112327)"]},"metadata":{"tags":[]},"execution_count":18}]},{"cell_type":"code","metadata":{"id":"SjqSFnK4atAI","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":119},"executionInfo":{"status":"ok","timestamp":1593078505496,"user_tz":-330,"elapsed":19225,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"dcf267cc-98f4-426b-d51d-f2e9d7e324c4"},"source":["print(pd.DataFrame([{'Model': 'Linear Regression','Score':lr_score, \"RMSE\":lr_rmse},\n","              {'Model': 'Lasso','Score':lr_lasso_score, \"RMSE\":lr_lasso_rmse},\n","              {'Model': 'Support Vector Machine','Score':svr_score, \"RMSE\":svr_rmse},\n","              {'Model': 'Random Forest','Score':rfr_score, \"RMSE\":rfr_rmse},\n","              {'Model': 'XGBoost','Score':xgb_reg_score, \"RMSE\":xgb_reg_rmse}],\n","             columns=['Model','Score','RMSE']))"],"execution_count":19,"outputs":[{"output_type":"stream","text":["                    Model     Score        RMSE\n","0       Linear Regression  0.790384   64.898435\n","1                   Lasso  0.803637   62.813243\n","2  Support Vector Machine  0.206380  126.278064\n","3           Random Forest  0.889623   47.093442\n","4                 XGBoost  0.875939   49.927407\n"],"name":"stdout"}]},{"cell_type":"markdown","metadata":{"id":"wb6hBVBvgSP4","colab_type":"text"},"source":["## Cross Validation"]},{"cell_type":"code","metadata":{"id":"9X2-jzL8gJJJ","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078505498,"user_tz":-330,"elapsed":19189,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"517a17f1-4b0d-45c6-fffa-cc4c94988cd4"},"source":["'''from sklearn.model_selection import KFold,cross_val_score\n","cvs = cross_val_score(xgb_reg, X_train,y_train, cv = 10)\n","cvs, cvs.mean() # 0.9845963377450353)'''"],"execution_count":20,"outputs":[{"output_type":"execute_result","data":{"text/plain":["'from sklearn.model_selection import KFold,cross_val_score\\ncvs = cross_val_score(xgb_reg, X_train,y_train, cv = 10)\\ncvs, cvs.mean() # 0.9845963377450353)'"]},"metadata":{"tags":[]},"execution_count":20}]},{"cell_type":"code","metadata":{"id":"3SRukRf9gWc3","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078505499,"user_tz":-330,"elapsed":19157,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"f32a045f-04ef-4c2e-ccd2-2dc6aa931b36"},"source":["'''cvs_rfr = cross_val_score(rfr, X_train,y_train, cv = 10)\n","cvs_rfr, cvs_rfr.mean() # 0.9652425691235843)'''"],"execution_count":21,"outputs":[{"output_type":"execute_result","data":{"text/plain":["'cvs_rfr = cross_val_score(rfr, X_train,y_train, cv = 10)\\ncvs_rfr, cvs_rfr.mean() # 0.9652425691235843)'"]},"metadata":{"tags":[]},"execution_count":21}]},{"cell_type":"code","metadata":{"id":"fOE4aTNGUyTP","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":68},"executionInfo":{"status":"ok","timestamp":1593078534792,"user_tz":-330,"elapsed":48418,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"d034f0cd-627a-4e8c-d3fc-15807f2bdfac"},"source":["from sklearn.model_selection import cross_val_score\n","cvs_rfr2 = cross_val_score(RandomForestRegressor(), X_train,y_train, cv = 10)\n","cvs_rfr2, cvs_rfr2.mean() # 0.9652425691235843)'''"],"execution_count":22,"outputs":[{"output_type":"execute_result","data":{"text/plain":["(array([0.99494408, 0.96682912, 0.99720454, 0.96433211, 0.96151867,\n","        0.94774651, 0.94212832, 0.91069009, 0.99610078, 0.98860838]),\n"," 0.9670102612461828)"]},"metadata":{"tags":[]},"execution_count":22}]},{"cell_type":"markdown","metadata":{"id":"9r5gSFsWgwsF","colab_type":"text"},"source":["# Hyper Parmeter Tuning"]},{"cell_type":"code","metadata":{"id":"Trmslcv4h6ll","colab_type":"code","cellView":"both","colab":{"base_uri":"https://localhost:8080/","height":54},"executionInfo":{"status":"ok","timestamp":1593078534796,"user_tz":-330,"elapsed":48381,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"7385acf6-e182-4c61-e148-53814d028d48"},"source":["from sklearn.model_selection import GridSearchCV\n","from xgboost.sklearn import XGBRegressor\n","'''\n","# Various hyper-parameters to tune\n","xgb1 = XGBRegressor()\n","parameters = {'learning_rate': [0.1,0.03, 0.05, 0.07], #so called `eta` value, # [default=0.3] Analogous to learning rate in GBM\n","              'min_child_weight': [1,3,5], #[default=1] Defines the minimum sum of weights of all observations required in a child.\n","              'max_depth': [4, 6, 8], #[default=6] The maximum depth of a tree,\n","              'gamma':[0,0.1,0.001,0.2], #Gamma specifies the minimum loss reduction required to make a split.\n","              'subsample': [0.7,1,1.5], #Denotes the fraction of observations to be randomly samples for each tree.\n","              'colsample_bytree': [0.7,1,1.5], #Denotes the fraction of columns to be randomly samples for each tree.\n","              'objective':['reg:linear'], #This defines the loss function to be minimized.\n","\n","              'n_estimators': [100,300,500]}\n","\n","xgb_grid = GridSearchCV(xgb1,\n","                        parameters,\n","                        cv = 2,\n","                        n_jobs = -1,\n","                        verbose=True)\n","\n","xgb_grid.fit(X_train, y_train)\n","\n","print(xgb_grid.best_score_) # 0.9397345161940295\n","print(xgb_grid.best_params_)'''"],"execution_count":23,"outputs":[{"output_type":"execute_result","data":{"text/plain":["\"\\n# Various hyper-parameters to tune\\nxgb1 = XGBRegressor()\\nparameters = {'learning_rate': [0.1,0.03, 0.05, 0.07], #so called `eta` value, # [default=0.3] Analogous to learning rate in GBM\\n              'min_child_weight': [1,3,5], #[default=1] Defines the minimum sum of weights of all observations required in a child.\\n              'max_depth': [4, 6, 8], #[default=6] The maximum depth of a tree,\\n              'gamma':[0,0.1,0.001,0.2], #Gamma specifies the minimum loss reduction required to make a split.\\n              'subsample': [0.7,1,1.5], #Denotes the fraction of observations to be randomly samples for each tree.\\n              'colsample_bytree': [0.7,1,1.5], #Denotes the fraction of columns to be randomly samples for each tree.\\n              'objective':['reg:linear'], #This defines the loss function to be minimized.\\n\\n              'n_estimators': [100,300,500]}\\n\\nxgb_grid = GridSearchCV(xgb1,\\n                        parameters,\\n                        cv = 2,\\n                        n_jobs = -1,\\n                        verbose=True)\\n\\nxgb_grid.fit(X_train, y_train)\\n\\nprint(xgb_grid.best_score_) # 0.9397345161940295\\nprint(xgb_grid.best_params_)\""]},"metadata":{"tags":[]},"execution_count":23}]},{"cell_type":"code","metadata":{"id":"yJkArgKqj4y_","colab_type":"code","cellView":"both","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078534797,"user_tz":-330,"elapsed":48340,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"4b9703ff-3f4a-40b0-ccfa-50b3fb7da614"},"source":["'''xgb_tune = xgb_grid.estimator\n","\n","xgb_tune.fit(X_train,y_train) # 0.9117591385438816\n","xgb_tune.score(X_test,y_test)'''"],"execution_count":24,"outputs":[{"output_type":"execute_result","data":{"text/plain":["'xgb_tune = xgb_grid.estimator\\n\\nxgb_tune.fit(X_train,y_train) # 0.9117591385438816\\nxgb_tune.score(X_test,y_test)'"]},"metadata":{"tags":[]},"execution_count":24}]},{"cell_type":"code","metadata":{"id":"wNCK-W4SkMAh","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078534798,"user_tz":-330,"elapsed":48310,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"79075545-215e-4798-a599-df1487ed75ef"},"source":["'''cvs = cross_val_score(xgb_tune, X_train,y_train, cv = 10)\n","cvs, cvs.mean() #  0.9645582338461773)'''"],"execution_count":25,"outputs":[{"output_type":"execute_result","data":{"text/plain":["'cvs = cross_val_score(xgb_tune, X_train,y_train, cv = 10)\\ncvs, cvs.mean() #  0.9645582338461773)'"]},"metadata":{"tags":[]},"execution_count":25}]},{"cell_type":"code","metadata":{"id":"lyexCvMKs8gW","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1593078534799,"user_tz":-330,"elapsed":48302,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}}},"source":["#[i/10.0 for i in range(1,6)]"],"execution_count":26,"outputs":[]},{"cell_type":"code","metadata":{"id":"PMn_MFhis9HR","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1593078534801,"user_tz":-330,"elapsed":48297,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}}},"source":["#xgb_grid.estimator\n"],"execution_count":27,"outputs":[]},{"cell_type":"code","metadata":{"id":"fCtoITd4eaci","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":51},"executionInfo":{"status":"ok","timestamp":1593078539232,"user_tz":-330,"elapsed":52687,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"028938c4-ad99-4fbf-9e8c-5f8c10099d32"},"source":["xgb_tune2 =  XGBRegressor(base_score=0.5, booster='gbtree', colsample_bylevel=1,\n","             colsample_bynode=0.6, colsample_bytree=1, gamma=0,\n","             importance_type='gain', learning_rate=0.25, max_delta_step=0,\n","             max_depth=4, min_child_weight=1, missing=None, n_estimators=400,\n","             n_jobs=1, nthread=None, objective='reg:linear', random_state=0,\n","             reg_alpha=0, reg_lambda=1, scale_pos_weight=1, seed=None,\n","             silent=None, subsample=1, verbosity=1)\n","xgb_tune2.fit(X_train,y_train) # 0.9412851220926807\n","xgb_tune2.score(X_test,y_test)"],"execution_count":28,"outputs":[{"output_type":"stream","text":["[09:48:53] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n"],"name":"stdout"},{"output_type":"execute_result","data":{"text/plain":["0.8945812461922704"]},"metadata":{"tags":[]},"execution_count":28}]},{"cell_type":"code","metadata":{"id":"66kzeVolaEUk","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":51},"executionInfo":{"status":"ok","timestamp":1593078540827,"user_tz":-330,"elapsed":54241,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"74761529-0e24-494c-92f7-47dce447e5a7"},"source":["'''parameters = {'learning_rate': [0.1,0.03, 0.05, 0.07], #so called `eta` value, # [default=0.3] Analogous to learning rate in GBM\n","              'min_child_weight': [1,3,5], #[default=1] Defines the minimum sum of weights of all observations required in a child.\n","              'max_depth': [4, 6, 8], #[default=6] The maximum depth of a tree,\n","              'gamma':[0,0.1,0.001,0.2], #Gamma specifies the minimum loss reduction required to make a split.\n","              'subsample': [0.7,1,1.5], #Denotes the fraction of observations to be randomly samples for each tree.\n","              'colsample_bytree': [0.7,1,1.5], #Denotes the fraction of columns to be randomly samples for each tree.\n","              'objective':['reg:linear'], #This defines the loss function to be minimized.\n","              'n_estimators': [100,300,500]}'''\n","\n","xgb_tune2 =  XGBRegressor(base_score=0.5, booster='gbtree', colsample_bylevel=1,\n","             colsample_bynode=0.9, colsample_bytree=1, gamma=0,\n","             importance_type='gain', learning_rate=0.05, max_delta_step=0,\n","             max_depth=4, min_child_weight=5, missing=None, n_estimators=100,\n","             n_jobs=1, nthread=None, objective='reg:linear', random_state=0,\n","             reg_alpha=0, reg_lambda=1, scale_pos_weight=1, seed=None,\n","             silent=None, subsample=1, verbosity=1)\n","xgb_tune2.fit(X_train,y_train) # 0.9412851220926807\n","xgb_tune2.score(X_test,y_test)"],"execution_count":29,"outputs":[{"output_type":"stream","text":["[09:48:57] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n"],"name":"stdout"},{"output_type":"execute_result","data":{"text/plain":["0.8840983866988691"]},"metadata":{"tags":[]},"execution_count":29}]},{"cell_type":"code","metadata":{"id":"6FU4x7iBfMPH","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":136},"executionInfo":{"status":"ok","timestamp":1593078546856,"user_tz":-330,"elapsed":60233,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"abfeda40-a5f1-4e5c-d5c5-21e701fcdfcd"},"source":["cvs = cross_val_score(xgb_tune2, X_train,y_train, cv = 5)\n","cvs, cvs.mean() #  0.9706000326331659'''"],"execution_count":30,"outputs":[{"output_type":"stream","text":["[09:48:59] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n","[09:49:00] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n","[09:49:01] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n","[09:49:02] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n","[09:49:04] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n"],"name":"stdout"},{"output_type":"execute_result","data":{"text/plain":["(array([0.97924577, 0.98376376, 0.97530216, 0.90127522, 0.96273069]),\n"," 0.9604635172361338)"]},"metadata":{"tags":[]},"execution_count":30}]},{"cell_type":"code","metadata":{"id":"WhZks478fQvN","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078546859,"user_tz":-330,"elapsed":60205,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"4b99e2ff-93ac-4575-8505-aa8f07669e01"},"source":["np.sqrt(mean_squared_error(y_test, xgb_tune2.predict(X_test)))"],"execution_count":31,"outputs":[{"output_type":"execute_result","data":{"text/plain":["48.25768129834004"]},"metadata":{"tags":[]},"execution_count":31}]},{"cell_type":"code","metadata":{"id":"BvXZVKM4j5q_","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1593078546861,"user_tz":-330,"elapsed":60198,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}}},"source":[""],"execution_count":31,"outputs":[]},{"cell_type":"markdown","metadata":{"id":"HMfJzdNkimif","colab_type":"text"},"source":["## Test Model"]},{"cell_type":"code","metadata":{"id":"ppJWFinaiovG","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":1000},"executionInfo":{"status":"ok","timestamp":1593078546862,"user_tz":-330,"elapsed":60169,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"fbb3d745-36c2-4ab9-d10a-d0dd3e0daf7a"},"source":["list(X.columns)"],"execution_count":32,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['bath',\n"," 'balcony',\n"," 'total_sqft_int',\n"," 'bhk',\n"," 'price_per_sqft',\n"," 'area_typeSuper built-up  Area',\n"," 'area_typeBuilt-up  Area',\n"," 'area_typePlot  Area',\n"," 'availability_Ready To Move',\n"," 'location_Whitefield',\n"," 'location_Sarjapur  Road',\n"," 'location_Electronic City',\n"," 'location_Raja Rajeshwari Nagar',\n"," 'location_Marathahalli',\n"," 'location_Haralur Road',\n"," 'location_Hennur Road',\n"," 'location_Bannerghatta Road',\n"," 'location_Uttarahalli',\n"," 'location_Thanisandra',\n"," 'location_Electronic City Phase II',\n"," 'location_Hebbal',\n"," 'location_Yelahanka',\n"," 'location_7th Phase JP Nagar',\n"," 'location_Kanakpura Road',\n"," 'location_KR Puram',\n"," 'location_Sarjapur',\n"," 'location_Rajaji Nagar',\n"," 'location_Bellandur',\n"," 'location_Kasavanhalli',\n"," 'location_Begur Road',\n"," 'location_Kothanur',\n"," 'location_Banashankari',\n"," 'location_Hormavu',\n"," 'location_Harlur',\n"," 'location_Akshaya Nagar',\n"," 'location_Jakkur',\n"," 'location_Electronics City Phase 1',\n"," 'location_Varthur',\n"," 'location_HSR Layout',\n"," 'location_Chandapura',\n"," 'location_Ramamurthy Nagar',\n"," 'location_Hennur',\n"," 'location_Kundalahalli',\n"," 'location_Ramagondanahalli',\n"," 'location_Kaggadasapura',\n"," 'location_Koramangala',\n"," 'location_Hulimavu',\n"," 'location_Budigere',\n"," 'location_Hoodi',\n"," 'location_Malleshwaram',\n"," 'location_JP Nagar',\n"," 'location_Hegde Nagar',\n"," 'location_Yeshwanthpur',\n"," 'location_8th Phase JP Nagar',\n"," 'location_Gottigere',\n"," 'location_Channasandra',\n"," 'location_Bisuvanahalli',\n"," 'location_Vittasandra',\n"," 'location_Indira Nagar',\n"," 'location_Brookefield',\n"," 'location_Vijayanagar',\n"," 'location_Old Airport Road',\n"," 'location_Sahakara Nagar',\n"," 'location_Hosa Road',\n"," 'location_Kengeri',\n"," 'location_Bommasandra',\n"," 'location_Green Glen Layout',\n"," 'location_Balagere',\n"," 'location_Old Madras Road',\n"," 'location_Kudlu Gate',\n"," 'location_Panathur',\n"," 'location_Rachenahalli',\n"," 'location_Yelahanka New Town',\n"," 'location_Jigani',\n"," 'location_Kadugodi',\n"," 'location_Talaghattapura',\n"," 'location_Thigalarapalya',\n"," 'location_Mysore Road',\n"," 'location_Ambedkar Nagar',\n"," 'location_Frazer Town',\n"," 'location_Dodda Nekkundi',\n"," 'location_Attibele',\n"," 'location_Kanakapura',\n"," 'location_Devanahalli',\n"," 'location_Nagarbhavi',\n"," 'location_TC Palaya',\n"," 'location_Lakshminarayana Pura',\n"," 'location_5th Phase JP Nagar',\n"," 'location_Anekal',\n"," 'location_Ananth Nagar',\n"," 'location_Jalahalli',\n"," 'location_CV Raman Nagar',\n"," 'location_Kengeri Satellite Town',\n"," 'location_Kudlu',\n"," 'location_Bhoganhalli',\n"," 'location_Doddathoguru',\n"," 'location_Subramanyapura',\n"," 'location_Kalena Agrahara',\n"," 'location_Horamavu Agara',\n"," 'location_Hosur Road',\n"," 'location_Vidyaranyapura',\n"," 'location_Hebbal Kempapura',\n"," 'location_BTM 2nd Stage',\n"," 'location_Mahadevpura',\n"," 'location_Horamavu Banaswadi',\n"," 'location_Domlur',\n"," 'location_Tumkur Road']"]},"metadata":{"tags":[]},"execution_count":32}]},{"cell_type":"code","metadata":{"id":"udzrDV2fisfs","colab_type":"code","colab":{},"executionInfo":{"status":"ok","timestamp":1593078546863,"user_tz":-330,"elapsed":60159,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}}},"source":["# it help to get predicted value of hosue  by providing features value \n","def predict_house_price(model,bath,balcony,total_sqft_int,bhk,price_per_sqft,area_type,availability,location):\n","\n","  x =np.zeros(len(X.columns)) # create zero numpy array, len = 107 as input value for model\n","\n","  # adding feature's value accorind to their column index\n","  x[0]=bath\n","  x[1]=balcony\n","  x[2]=total_sqft_int\n","  x[3]=bhk\n","  x[4]=price_per_sqft\n","\n","  if \"availability\"==\"Ready To Move\":\n","    x[8]=1\n","\n","  if 'area_type'+area_type in X.columns:\n","    area_type_index = np.where(X.columns==\"area_type\"+area_type)[0][0]\n","    x[area_type_index] =1\n","\n","    #print(area_type_index)\n","\n","  if 'location_'+location in X.columns:\n","    loc_index = np.where(X.columns==\"location_\"+location)[0][0]\n","    x[loc_index] =1\n","\n","    #print(loc_index)\n","\n","  #print(x)\n","\n","  # feature scaling\n","  x = sc.transform([x])[0] # give 2d np array for feature scaling and get 1d scaled np array\n","  #print(x)\n","\n","  return model.predict([x])[0] # return the predicted value by train XGBoost model"],"execution_count":33,"outputs":[]},{"cell_type":"code","metadata":{"id":"cP2-LZ41GVd2","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078546864,"user_tz":-330,"elapsed":60119,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"72f70f40-5466-4fe8-a27f-7d240df93a6f"},"source":["predict_house_price(model=xgb_tune2, bath=3,balcony=2,total_sqft_int=1672,bhk=3,price_per_sqft=8971.291866,area_type=\"Plot  Area\",availability=\"Ready To Move\",location=\"Devarabeesana Halli\")"],"execution_count":34,"outputs":[{"output_type":"execute_result","data":{"text/plain":["145.91656"]},"metadata":{"tags":[]},"execution_count":34}]},{"cell_type":"code","metadata":{"id":"FT6oIIPlHRmx","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078546865,"user_tz":-330,"elapsed":60083,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"17191715-4f18-44d5-82fe-4d26df101715"},"source":["##test sample\n","#area_type\tavailability\tlocation\tbath\tbalcony\tprice\ttotal_sqft_int\tbhk\tprice_per_sqft\n","#2\tSuper built-up Area\tReady To Move\tDevarabeesana Halli\t3.0\t2.0\t150.0\t1750.0\t3\t8571.428571\n","\n","predict_house_price(model=xgb_tune2, bath=3,balcony=2,total_sqft_int=1750,bhk=3,price_per_sqft=8571.428571,area_type=\"Super built-up\",availability=\"Ready To Move\",location=\"Devarabeesana Halli\")"],"execution_count":35,"outputs":[{"output_type":"execute_result","data":{"text/plain":["143.71669"]},"metadata":{"tags":[]},"execution_count":35}]},{"cell_type":"code","metadata":{"id":"TXG6GFOxGw6w","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078546866,"user_tz":-330,"elapsed":60050,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"1920210b-706b-4f61-8597-1ac5712413f1"},"source":["##test sample\n","#area_type\tavailability\tlocation\tbath\tbalcony\tprice\ttotal_sqft_int\tbhk\tprice_per_sqft\n","#1\tBuilt-up Area\tReady To Move\tDevarabeesana Halli\t3.0\t3.0\t149.0\t1750.0\t3\t8514.285714\n","predict_house_price(model=xgb_tune2,bath=3,balcony=3,total_sqft_int=1750,bhk=3,price_per_sqft=8514.285714,area_type=\"Built-up Area\",availability=\"Ready To Move\",location=\"Devarabeesana Halli\")"],"execution_count":36,"outputs":[{"output_type":"execute_result","data":{"text/plain":["143.71669"]},"metadata":{"tags":[]},"execution_count":36}]},{"cell_type":"markdown","metadata":{"id":"oC0mBkarKUzw","colab_type":"text"},"source":["# Save model & load model"]},{"cell_type":"code","metadata":{"id":"0FepBAKJHHuf","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593079039699,"user_tz":-330,"elapsed":1014,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"780ec6c9-2652-414e-ad32-ba887248ed26"},"source":["import joblib\n","# save model\n","joblib.dump(xgb_tune2, 'bangalore_house_price_prediction_model.pkl')\n","joblib.dump(rfr, 'bangalore_house_price_prediction_rfr_model.pkl')"],"execution_count":44,"outputs":[{"output_type":"execute_result","data":{"text/plain":["['bangalore_house_price_prediction_rfr_model.pkl']"]},"metadata":{"tags":[]},"execution_count":44}]},{"cell_type":"code","metadata":{"id":"y9pzeYYLKm6E","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078546870,"user_tz":-330,"elapsed":59992,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"7e1c2640-ac7b-406b-eadc-d1c0c32c3a91"},"source":["# load model\n","bangalore_house_price_prediction_model = joblib.load(\"bangalore_house_price_prediction_model.pkl\")"],"execution_count":38,"outputs":[{"output_type":"stream","text":["[09:49:05] WARNING: /workspace/src/objective/regression_obj.cu:152: reg:linear is now deprecated in favor of reg:squarederror.\n"],"name":"stdout"}]},{"cell_type":"code","metadata":{"id":"Z24uQ9PjK2H0","colab_type":"code","colab":{"base_uri":"https://localhost:8080/","height":34},"executionInfo":{"status":"ok","timestamp":1593078546871,"user_tz":-330,"elapsed":59958,"user":{"displayName":"indian ai production","photoUrl":"","userId":"05336710603640792650"}},"outputId":"d60dda4c-4677-4ecd-8e13-03e642ff7286"},"source":["# predict house price\n","predict_house_price(bangalore_house_price_prediction_model,bath=3,balcony=3,total_sqft_int=150,bhk=3,price_per_sqft=8514.285714,area_type=\"Built-up Area\",availability=\"Ready To Move\",location=\"Devarabeesana Halli\")"],"execution_count":39,"outputs":[{"output_type":"execute_result","data":{"text/plain":["65.78738"]},"metadata":{"tags":[]},"execution_count":39}]}]}