Gurugram_flats_sprint_1.ipynb

{"cells":[{"cell_type":"code","execution_count":2,"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":573},"executionInfo":{"elapsed":377,"status":"ok","timestamp":1702336135289,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"Gxtzs67uuf3t","outputId":"2988a516-ca86-40fb-a3ad-55f68b56acd4"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>property_name</th>\n","      <th>society</th>\n","      <th>price</th>\n","      <th>area</th>\n","      <th>areaWithType</th>\n","      <th>bedRoom</th>\n","      <th>bathroom</th>\n","      <th>balcony</th>\n","      <th>additionalRoom</th>\n","      <th>address</th>\n","      <th>floorNum</th>\n","      <th>facing</th>\n","      <th>agePossession</th>\n","      <th>nearbyLocations</th>\n","      <th>description</th>\n","      <th>furnishDetails</th>\n","      <th>features</th>\n","      <th>rating</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2 BHK Flat in Krishna Colony</td>\n","      <td>maa bhagwati residency</td>\n","      <td>45 Lac</td>\n","      <td>₹ 5,000/sq.ft.</td>\n","      <td>Carpet area: 900 (83.61 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>1 Balcony</td>\n","      <td>NaN</td>\n","      <td>Krishna Colony, Gurgaon, Haryana</td>\n","      <td>4th   of 4 Floors</td>\n","      <td>West</td>\n","      <td>1 to 5 Year Old</td>\n","      <td>['Chintapurni Mandir', 'State bank ATM', 'Pear...</td>\n","      <td>So with lift.Maa bhagwati residency is one of ...</td>\n","      <td>['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...</td>\n","      <td>['Feng Shui / Vaastu Compliant', 'Security / F...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2 BHK Flat in Ashok Vihar</td>\n","      <td>Apna Enclave</td>\n","      <td>50 Lac</td>\n","      <td>₹ 7,692/sq.ft.</td>\n","      <td>Carpet area: 650 (60.39 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>1 Balcony</td>\n","      <td>NaN</td>\n","      <td>46b, Ashok Vihar, Gurgaon, Haryana</td>\n","      <td>1st   of 3 Floors</td>\n","      <td>West</td>\n","      <td>10+ Year Old</td>\n","      <td>['Chintapurni Mandir', 'Sheetla Mata Mandir', ...</td>\n","      <td>Property situated on main road, railway statio...</td>\n","      <td>['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...</td>\n","      <td>['Security / Fire Alarm', 'Maintenance Staff',...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2 BHK Flat in Sohna</td>\n","      <td>Tulsiani Easy in Homes</td>\n","      <td>40 Lac</td>\n","      <td>₹ 6,722/sq.ft.</td>\n","      <td>Carpet area: 595 (55.28 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>3 Balconies</td>\n","      <td>NaN</td>\n","      <td>Sohna, Gurgaon, Haryana</td>\n","      <td>12nd   of 14 Floors</td>\n","      <td>NaN</td>\n","      <td>0 to 1 Year Old</td>\n","      <td>['Huda City Metro', 'Golf Course extn road', '...</td>\n","      <td>This property is 15 km away from badshapur, gu...</td>\n","      <td>NaN</td>\n","      <td>['Power Back-up', 'Feng Shui / Vaastu Complian...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2 BHK Flat in Sector 61 Gurgaon</td>\n","      <td>Smart World Orchard</td>\n","      <td>1.47 Crore</td>\n","      <td>₹ 12,250/sq.ft.</td>\n","      <td>Carpet area: 1200 (111.48 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>2 Balconies</td>\n","      <td>Study Room</td>\n","      <td>Sector 61 Gurgaon, Gurgaon, Haryana</td>\n","      <td>2nd   of 4 Floors</td>\n","      <td>NaN</td>\n","      <td>Dec-23</td>\n","      <td>['Sector 55-56 Metro station', 'Bestech Centra...</td>\n","      <td>Near to metro station of sector 56 and opposit...</td>\n","      <td>NaN</td>\n","      <td>['Security / Fire Alarm', 'Private Garden / Te...</td>\n","      <td>NaN</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2 BHK Flat in Sector 92 Gurgaon</td>\n","      <td>Parkwood Westend</td>\n","      <td>70 Lac</td>\n","      <td>₹ 5,204/sq.ft.</td>\n","      <td>Super Built up area 1345(124.95 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>3 Balconies</td>\n","      <td>Study Room</td>\n","      <td>Sector 92 Gurgaon, Gurgaon, Haryana</td>\n","      <td>5th   of 8 Floors</td>\n","      <td>NaN</td>\n","      <td>Under Construction</td>\n","      <td>['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...</td>\n","      <td>We are the proud owners of this 2 bhk alongwit...</td>\n","      <td>[]</td>\n","      <td>NaN</td>\n","      <td>['Environment5 out of 5', 'Safety3 out of 5', ...</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                     property_name                 society       price  \\\n","0     2 BHK Flat in Krishna Colony  maa bhagwati residency      45 Lac   \n","1        2 BHK Flat in Ashok Vihar            Apna Enclave      50 Lac   \n","2              2 BHK Flat in Sohna  Tulsiani Easy in Homes      40 Lac   \n","3  2 BHK Flat in Sector 61 Gurgaon     Smart World Orchard  1.47 Crore   \n","4  2 BHK Flat in Sector 92 Gurgaon        Parkwood Westend      70 Lac   \n","\n","              area                            areaWithType     bedRoom  \\\n","0   ₹ 5,000/sq.ft.          Carpet area: 900 (83.61 sq.m.)  2 Bedrooms   \n","1   ₹ 7,692/sq.ft.          Carpet area: 650 (60.39 sq.m.)  2 Bedrooms   \n","2   ₹ 6,722/sq.ft.          Carpet area: 595 (55.28 sq.m.)  2 Bedrooms   \n","3  ₹ 12,250/sq.ft.        Carpet area: 1200 (111.48 sq.m.)  2 Bedrooms   \n","4   ₹ 5,204/sq.ft.  Super Built up area 1345(124.95 sq.m.)  2 Bedrooms   \n","\n","      bathroom      balcony additionalRoom  \\\n","0  2 Bathrooms    1 Balcony            NaN   \n","1  2 Bathrooms    1 Balcony            NaN   \n","2  2 Bathrooms  3 Balconies            NaN   \n","3  2 Bathrooms  2 Balconies     Study Room   \n","4  2 Bathrooms  3 Balconies     Study Room   \n","\n","                               address             floorNum facing  \\\n","0     Krishna Colony, Gurgaon, Haryana    4th   of 4 Floors   West   \n","1   46b, Ashok Vihar, Gurgaon, Haryana    1st   of 3 Floors   West   \n","2              Sohna, Gurgaon, Haryana  12nd   of 14 Floors    NaN   \n","3  Sector 61 Gurgaon, Gurgaon, Haryana    2nd   of 4 Floors    NaN   \n","4  Sector 92 Gurgaon, Gurgaon, Haryana    5th   of 8 Floors    NaN   \n","\n","        agePossession                                    nearbyLocations  \\\n","0     1 to 5 Year Old  ['Chintapurni Mandir', 'State bank ATM', 'Pear...   \n","1        10+ Year Old  ['Chintapurni Mandir', 'Sheetla Mata Mandir', ...   \n","2     0 to 1 Year Old  ['Huda City Metro', 'Golf Course extn road', '...   \n","3              Dec-23  ['Sector 55-56 Metro station', 'Bestech Centra...   \n","4  Under Construction  ['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...   \n","\n","                                         description  \\\n","0  So with lift.Maa bhagwati residency is one of ...   \n","1  Property situated on main road, railway statio...   \n","2  This property is 15 km away from badshapur, gu...   \n","3  Near to metro station of sector 56 and opposit...   \n","4  We are the proud owners of this 2 bhk alongwit...   \n","\n","                                      furnishDetails  \\\n","0  ['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...   \n","1  ['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...   \n","2                                                NaN   \n","3                                                NaN   \n","4                                                 []   \n","\n","                                            features  \\\n","0  ['Feng Shui / Vaastu Compliant', 'Security / F...   \n","1  ['Security / Fire Alarm', 'Maintenance Staff',...   \n","2  ['Power Back-up', 'Feng Shui / Vaastu Complian...   \n","3  ['Security / Fire Alarm', 'Private Garden / Te...   \n","4                                                NaN   \n","\n","                                              rating  \n","0  ['Environment4 out of 5', 'Safety4 out of 5', ...  \n","1  ['Environment4 out of 5', 'Safety4 out of 5', ...  \n","2  ['Environment4 out of 5', 'Safety4 out of 5', ...  \n","3                                                NaN  \n","4  ['Environment5 out of 5', 'Safety3 out of 5', ...  "]},"execution_count":2,"metadata":{},"output_type":"execute_result"}],"source":["import pandas as pd\n","flats_df=pd.read_csv(\"flats.csv\")\n","flats_df.head()\n","## dropping link and propertyid\n","flats_df.drop(columns={'link','property_id'},axis=0,inplace=True )\n","flats_df\n","flats_df.head()"]},{"cell_type":"code","execution_count":3,"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":372},"executionInfo":{"elapsed":163,"status":"ok","timestamp":1702336147541,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"a8HPX4lr50tm","outputId":"41a202b4-6dff-48b2-9bf2-d21c096cfb62"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>property_name</th>\n","      <th>property_type</th>\n","      <th>society</th>\n","      <th>price</th>\n","      <th>area</th>\n","      <th>areaWithType</th>\n","      <th>bedRoom</th>\n","      <th>bathroom</th>\n","      <th>balcony</th>\n","      <th>additionalRoom</th>\n","      <th>address</th>\n","      <th>floorNum</th>\n","      <th>facing</th>\n","      <th>agePossession</th>\n","      <th>nearbyLocations</th>\n","      <th>description</th>\n","      <th>furnishDetails</th>\n","      <th>features</th>\n","      <th>rating</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2 BHK Flat in Krishna Colony</td>\n","      <td>2 BHK</td>\n","      <td>maa bhagwati residency</td>\n","      <td>45 Lac</td>\n","      <td>₹ 5,000/sq.ft.</td>\n","      <td>Carpet area: 900 (83.61 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>1 Balcony</td>\n","      <td>NaN</td>\n","      <td>Krishna Colony, Gurgaon, Haryana</td>\n","      <td>4th   of 4 Floors</td>\n","      <td>West</td>\n","      <td>1 to 5 Year Old</td>\n","      <td>['Chintapurni Mandir', 'State bank ATM', 'Pear...</td>\n","      <td>So with lift.Maa bhagwati residency is one of ...</td>\n","      <td>['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...</td>\n","      <td>['Feng Shui / Vaastu Compliant', 'Security / F...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2 BHK Flat in Ashok Vihar</td>\n","      <td>2 BHK</td>\n","      <td>Apna Enclave</td>\n","      <td>50 Lac</td>\n","      <td>₹ 7,692/sq.ft.</td>\n","      <td>Carpet area: 650 (60.39 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>1 Balcony</td>\n","      <td>NaN</td>\n","      <td>46b, Ashok Vihar, Gurgaon, Haryana</td>\n","      <td>1st   of 3 Floors</td>\n","      <td>West</td>\n","      <td>10+ Year Old</td>\n","      <td>['Chintapurni Mandir', 'Sheetla Mata Mandir', ...</td>\n","      <td>Property situated on main road, railway statio...</td>\n","      <td>['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...</td>\n","      <td>['Security / Fire Alarm', 'Maintenance Staff',...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2 BHK Flat in Sohna</td>\n","      <td>2 BHK</td>\n","      <td>Tulsiani Easy in Homes</td>\n","      <td>40 Lac</td>\n","      <td>₹ 6,722/sq.ft.</td>\n","      <td>Carpet area: 595 (55.28 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>3 Balconies</td>\n","      <td>NaN</td>\n","      <td>Sohna, Gurgaon, Haryana</td>\n","      <td>12nd   of 14 Floors</td>\n","      <td>NaN</td>\n","      <td>0 to 1 Year Old</td>\n","      <td>['Huda City Metro', 'Golf Course extn road', '...</td>\n","      <td>This property is 15 km away from badshapur, gu...</td>\n","      <td>NaN</td>\n","      <td>['Power Back-up', 'Feng Shui / Vaastu Complian...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                  property_name property_type                 society   price  \\\n","0  2 BHK Flat in Krishna Colony         2 BHK  maa bhagwati residency  45 Lac   \n","1     2 BHK Flat in Ashok Vihar         2 BHK            Apna Enclave  50 Lac   \n","2           2 BHK Flat in Sohna         2 BHK  Tulsiani Easy in Homes  40 Lac   \n","\n","             area                    areaWithType     bedRoom     bathroom  \\\n","0  ₹ 5,000/sq.ft.  Carpet area: 900 (83.61 sq.m.)  2 Bedrooms  2 Bathrooms   \n","1  ₹ 7,692/sq.ft.  Carpet area: 650 (60.39 sq.m.)  2 Bedrooms  2 Bathrooms   \n","2  ₹ 6,722/sq.ft.  Carpet area: 595 (55.28 sq.m.)  2 Bedrooms  2 Bathrooms   \n","\n","       balcony additionalRoom                             address  \\\n","0    1 Balcony            NaN    Krishna Colony, Gurgaon, Haryana   \n","1    1 Balcony            NaN  46b, Ashok Vihar, Gurgaon, Haryana   \n","2  3 Balconies            NaN             Sohna, Gurgaon, Haryana   \n","\n","              floorNum facing    agePossession  \\\n","0    4th   of 4 Floors   West  1 to 5 Year Old   \n","1    1st   of 3 Floors   West     10+ Year Old   \n","2  12nd   of 14 Floors    NaN  0 to 1 Year Old   \n","\n","                                     nearbyLocations  \\\n","0  ['Chintapurni Mandir', 'State bank ATM', 'Pear...   \n","1  ['Chintapurni Mandir', 'Sheetla Mata Mandir', ...   \n","2  ['Huda City Metro', 'Golf Course extn road', '...   \n","\n","                                         description  \\\n","0  So with lift.Maa bhagwati residency is one of ...   \n","1  Property situated on main road, railway statio...   \n","2  This property is 15 km away from badshapur, gu...   \n","\n","                                      furnishDetails  \\\n","0  ['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...   \n","1  ['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...   \n","2                                                NaN   \n","\n","                                            features  \\\n","0  ['Feng Shui / Vaastu Compliant', 'Security / F...   \n","1  ['Security / Fire Alarm', 'Maintenance Staff',...   \n","2  ['Power Back-up', 'Feng Shui / Vaastu Complian...   \n","\n","                                              rating  \n","0  ['Environment4 out of 5', 'Safety4 out of 5', ...  \n","1  ['Environment4 out of 5', 'Safety4 out of 5', ...  \n","2  ['Environment4 out of 5', 'Safety4 out of 5', ...  "]},"execution_count":3,"metadata":{},"output_type":"execute_result"}],"source":["## extracting type of BHK from property_name\n","flats_df['property_name'].unique()\n","flats_df['property_type']=flats_df['property_name'].apply(lambda x:x.split(\" \")[0:2])\n","flats_df['property_type']=flats_df['property_type'].apply(lambda x: str(x).replace(\"'\",\"\"))\n","flats_df['property_type']=flats_df['property_type'].apply(lambda x: str(x).replace(\"[\",\"\"))\n","flats_df['property_type']=flats_df['property_type'].apply(lambda x: str(x).replace(\"]\",\"\"))\n","flats_df['property_type']=flats_df['property_type'].apply(lambda x: str(x).replace(\", \",\" \"))\n","##rearranging column positions\n","flats_df=flats_df[['property_name','property_type','society','price','area','areaWithType','bedRoom','bathroom','balcony','additionalRoom',\n","'address','floorNum','facing','agePossession','nearbyLocations','description','furnishDetails','features','rating']]\n","flats_df.head(3)"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"WcMIcVjvPL0P"},"outputs":[],"source":[]},{"cell_type":"code","execution_count":4,"metadata":{"executionInfo":{"elapsed":154,"status":"ok","timestamp":1702336304155,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"BVaUOqJGSJ91"},"outputs":[],"source":["flats_df[flats_df['price'].isnull()]\n","flats_df.drop(index=18,axis=0,inplace=True)"]},{"cell_type":"code","execution_count":5,"metadata":{"executionInfo":{"elapsed":139,"status":"ok","timestamp":1702336307943,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"RfZakhZ7Sy-P"},"outputs":[],"source":["flats_df['value'] = flats_df['price'].apply(lambda x: str(x).split()[0])\n","flats_df['currency'] = flats_df['price'].apply(lambda x: str(x).split()[1:2])\n","flats_df['currency'] = flats_df['currency'].apply(lambda x: str(x).replace(\"[\", \"\"))\n","flats_df['currency'] = flats_df['currency'].apply(lambda x: str(x).replace(\"]\", \"\"))\n","flats_df['currency'] = flats_df['currency'].apply(lambda x: str(x).replace(\"'\", \"\"))\n"]},{"cell_type":"code","execution_count":6,"metadata":{"executionInfo":{"elapsed":4,"status":"ok","timestamp":1702336311478,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"pAshk-Ls09N-"},"outputs":[],"source":["flats_df=flats_df[~(flats_df['price']=='Price on Request')]\n","flats_df=flats_df[~(flats_df['price']=='Price on Request')]\n"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"NOI0n83f9WsJ"},"outputs":[],"source":[]},{"cell_type":"code","execution_count":7,"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":99},"executionInfo":{"elapsed":144,"status":"ok","timestamp":1702336314914,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"yqSHex3z8nWN","outputId":"c16005ea-a519-41bc-e562-c3dc452f95ea"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>property_name</th>\n","      <th>property_type</th>\n","      <th>society</th>\n","      <th>price</th>\n","      <th>area</th>\n","      <th>areaWithType</th>\n","      <th>bedRoom</th>\n","      <th>bathroom</th>\n","      <th>balcony</th>\n","      <th>additionalRoom</th>\n","      <th>...</th>\n","      <th>floorNum</th>\n","      <th>facing</th>\n","      <th>agePossession</th>\n","      <th>nearbyLocations</th>\n","      <th>description</th>\n","      <th>furnishDetails</th>\n","      <th>features</th>\n","      <th>rating</th>\n","      <th>value</th>\n","      <th>currency</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","  </tbody>\n","</table>\n","<p>0 rows × 21 columns</p>\n","</div>"],"text/plain":["Empty DataFrame\n","Columns: [property_name, property_type, society, price, area, areaWithType, bedRoom, bathroom, balcony, additionalRoom, address, floorNum, facing, agePossession, nearbyLocations, description, furnishDetails, features, rating, value, currency]\n","Index: []\n","\n","[0 rows x 21 columns]"]},"execution_count":7,"metadata":{},"output_type":"execute_result"}],"source":["flats_df[flats_df['price']==\"Price on Request \"]"]},{"cell_type":"code","execution_count":8,"metadata":{"executionInfo":{"elapsed":138,"status":"ok","timestamp":1702336318608,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"RN1_UzJm4-EC"},"outputs":[],"source":["import re\n","flats_df['society'] = flats_df['society'].apply(lambda name: re.sub(r'\\d+(\\.\\d+)?\\s?★', '', str(name)).strip()).str.lower()"]},{"cell_type":"code","execution_count":9,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":168,"status":"ok","timestamp":1702336321161,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"PwdtTthr6jk_","outputId":"16939a20-f743-4ca7-b3fe-2d7a3607c7ec"},"outputs":[{"data":{"text/plain":["0         45 Lac\n","1         50 Lac\n","2         40 Lac\n","3     1.47 Crore\n","4         70 Lac\n","5         41 Lac\n","6        2 Crore\n","7      1.8 Crore\n","8      1.1 Crore\n","9     4.75 Crore\n","10        96 Lac\n","11        29 Lac\n","12    1.35 Crore\n","13        95 Lac\n","14        70 Lac\n","15    3.95 Crore\n","16        90 Lac\n","17    1.05 Crore\n","19     2.2 Crore\n","20    1.01 Crore\n","21    1.85 Crore\n","22        86 Lac\n","23    1.85 Crore\n","24    2.85 Crore\n","26        42 Lac\n","27    6.15 Crore\n","Name: price, dtype: object"]},"execution_count":9,"metadata":{},"output_type":"execute_result"}],"source":["flats_df['price']=flats_df['price'].str.replace(\"'\",\"\")\n","flats_df['price']=flats_df['price'].str.replace(\"'\",\"\")\n","flats_df['price'].head(26)"]},{"cell_type":"code","execution_count":10,"metadata":{"executionInfo":{"elapsed":149,"status":"ok","timestamp":1702336324758,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"JHyb-JSMEBuG"},"outputs":[],"source":["\n","def get_price(x):\n","  if x.split()[1]==\"Lac\":\n","    return round(float(x.split()[0])/100,2)\n","  else:\n","    return float(x.split()[0])\n","\n","flats_df['price']=flats_df['price'].apply(get_price)\n","\n","\n","\n","\n"]},{"cell_type":"code","execution_count":null,"metadata":{"id":"l_xrrIcy6ZQB"},"outputs":[],"source":[]},{"cell_type":"code","execution_count":11,"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":602},"executionInfo":{"elapsed":145,"status":"ok","timestamp":1702336332384,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"bWRTpgT_3Eiy","outputId":"64fa82be-f7ed-413c-d72a-b1f31ad49da7"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>property_name</th>\n","      <th>property_type</th>\n","      <th>society</th>\n","      <th>price</th>\n","      <th>price_per_sqft</th>\n","      <th>areaWithType</th>\n","      <th>bedRoom</th>\n","      <th>bathroom</th>\n","      <th>balcony</th>\n","      <th>additionalRoom</th>\n","      <th>...</th>\n","      <th>floorNum</th>\n","      <th>facing</th>\n","      <th>agePossession</th>\n","      <th>nearbyLocations</th>\n","      <th>description</th>\n","      <th>furnishDetails</th>\n","      <th>features</th>\n","      <th>rating</th>\n","      <th>value</th>\n","      <th>currency</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2 BHK Flat in Krishna Colony</td>\n","      <td>2 BHK</td>\n","      <td>maa bhagwati residency</td>\n","      <td>0.45</td>\n","      <td>₹ 5,000/sq.ft.</td>\n","      <td>Carpet area: 900 (83.61 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>1 Balcony</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>4th   of 4 Floors</td>\n","      <td>West</td>\n","      <td>1 to 5 Year Old</td>\n","      <td>['Chintapurni Mandir', 'State bank ATM', 'Pear...</td>\n","      <td>So with lift.Maa bhagwati residency is one of ...</td>\n","      <td>['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...</td>\n","      <td>['Feng Shui / Vaastu Compliant', 'Security / F...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>45</td>\n","      <td>Lac</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2 BHK Flat in Ashok Vihar</td>\n","      <td>2 BHK</td>\n","      <td>apna enclave</td>\n","      <td>0.50</td>\n","      <td>₹ 7,692/sq.ft.</td>\n","      <td>Carpet area: 650 (60.39 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>1 Balcony</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>1st   of 3 Floors</td>\n","      <td>West</td>\n","      <td>10+ Year Old</td>\n","      <td>['Chintapurni Mandir', 'Sheetla Mata Mandir', ...</td>\n","      <td>Property situated on main road, railway statio...</td>\n","      <td>['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...</td>\n","      <td>['Security / Fire Alarm', 'Maintenance Staff',...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>50</td>\n","      <td>Lac</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2 BHK Flat in Sohna</td>\n","      <td>2 BHK</td>\n","      <td>tulsiani easy in homes</td>\n","      <td>0.40</td>\n","      <td>₹ 6,722/sq.ft.</td>\n","      <td>Carpet area: 595 (55.28 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>3 Balconies</td>\n","      <td>NaN</td>\n","      <td>...</td>\n","      <td>12nd   of 14 Floors</td>\n","      <td>NaN</td>\n","      <td>0 to 1 Year Old</td>\n","      <td>['Huda City Metro', 'Golf Course extn road', '...</td>\n","      <td>This property is 15 km away from badshapur, gu...</td>\n","      <td>NaN</td>\n","      <td>['Power Back-up', 'Feng Shui / Vaastu Complian...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>40</td>\n","      <td>Lac</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2 BHK Flat in Sector 61 Gurgaon</td>\n","      <td>2 BHK</td>\n","      <td>smart world orchard</td>\n","      <td>1.47</td>\n","      <td>₹ 12,250/sq.ft.</td>\n","      <td>Carpet area: 1200 (111.48 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>2 Balconies</td>\n","      <td>Study Room</td>\n","      <td>...</td>\n","      <td>2nd   of 4 Floors</td>\n","      <td>NaN</td>\n","      <td>Dec-23</td>\n","      <td>['Sector 55-56 Metro station', 'Bestech Centra...</td>\n","      <td>Near to metro station of sector 56 and opposit...</td>\n","      <td>NaN</td>\n","      <td>['Security / Fire Alarm', 'Private Garden / Te...</td>\n","      <td>NaN</td>\n","      <td>1.47</td>\n","      <td>Crore</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2 BHK Flat in Sector 92 Gurgaon</td>\n","      <td>2 BHK</td>\n","      <td>parkwood westend</td>\n","      <td>0.70</td>\n","      <td>₹ 5,204/sq.ft.</td>\n","      <td>Super Built up area 1345(124.95 sq.m.)</td>\n","      <td>2 Bedrooms</td>\n","      <td>2 Bathrooms</td>\n","      <td>3 Balconies</td>\n","      <td>Study Room</td>\n","      <td>...</td>\n","      <td>5th   of 8 Floors</td>\n","      <td>NaN</td>\n","      <td>Under Construction</td>\n","      <td>['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...</td>\n","      <td>We are the proud owners of this 2 bhk alongwit...</td>\n","      <td>[]</td>\n","      <td>NaN</td>\n","      <td>['Environment5 out of 5', 'Safety3 out of 5', ...</td>\n","      <td>70</td>\n","      <td>Lac</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>5 rows × 21 columns</p>\n","</div>"],"text/plain":["                     property_name property_type                 society  \\\n","0     2 BHK Flat in Krishna Colony         2 BHK  maa bhagwati residency   \n","1        2 BHK Flat in Ashok Vihar         2 BHK            apna enclave   \n","2              2 BHK Flat in Sohna         2 BHK  tulsiani easy in homes   \n","3  2 BHK Flat in Sector 61 Gurgaon         2 BHK     smart world orchard   \n","4  2 BHK Flat in Sector 92 Gurgaon         2 BHK        parkwood westend   \n","\n","   price   price_per_sqft                            areaWithType     bedRoom  \\\n","0   0.45   ₹ 5,000/sq.ft.          Carpet area: 900 (83.61 sq.m.)  2 Bedrooms   \n","1   0.50   ₹ 7,692/sq.ft.          Carpet area: 650 (60.39 sq.m.)  2 Bedrooms   \n","2   0.40   ₹ 6,722/sq.ft.          Carpet area: 595 (55.28 sq.m.)  2 Bedrooms   \n","3   1.47  ₹ 12,250/sq.ft.        Carpet area: 1200 (111.48 sq.m.)  2 Bedrooms   \n","4   0.70   ₹ 5,204/sq.ft.  Super Built up area 1345(124.95 sq.m.)  2 Bedrooms   \n","\n","      bathroom      balcony additionalRoom  ...             floorNum facing  \\\n","0  2 Bathrooms    1 Balcony            NaN  ...    4th   of 4 Floors   West   \n","1  2 Bathrooms    1 Balcony            NaN  ...    1st   of 3 Floors   West   \n","2  2 Bathrooms  3 Balconies            NaN  ...  12nd   of 14 Floors    NaN   \n","3  2 Bathrooms  2 Balconies     Study Room  ...    2nd   of 4 Floors    NaN   \n","4  2 Bathrooms  3 Balconies     Study Room  ...    5th   of 8 Floors    NaN   \n","\n","        agePossession                                    nearbyLocations  \\\n","0     1 to 5 Year Old  ['Chintapurni Mandir', 'State bank ATM', 'Pear...   \n","1        10+ Year Old  ['Chintapurni Mandir', 'Sheetla Mata Mandir', ...   \n","2     0 to 1 Year Old  ['Huda City Metro', 'Golf Course extn road', '...   \n","3              Dec-23  ['Sector 55-56 Metro station', 'Bestech Centra...   \n","4  Under Construction  ['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...   \n","\n","                                         description  \\\n","0  So with lift.Maa bhagwati residency is one of ...   \n","1  Property situated on main road, railway statio...   \n","2  This property is 15 km away from badshapur, gu...   \n","3  Near to metro station of sector 56 and opposit...   \n","4  We are the proud owners of this 2 bhk alongwit...   \n","\n","                                      furnishDetails  \\\n","0  ['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...   \n","1  ['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...   \n","2                                                NaN   \n","3                                                NaN   \n","4                                                 []   \n","\n","                                            features  \\\n","0  ['Feng Shui / Vaastu Compliant', 'Security / F...   \n","1  ['Security / Fire Alarm', 'Maintenance Staff',...   \n","2  ['Power Back-up', 'Feng Shui / Vaastu Complian...   \n","3  ['Security / Fire Alarm', 'Private Garden / Te...   \n","4                                                NaN   \n","\n","                                              rating value currency  \n","0  ['Environment4 out of 5', 'Safety4 out of 5', ...    45      Lac  \n","1  ['Environment4 out of 5', 'Safety4 out of 5', ...    50      Lac  \n","2  ['Environment4 out of 5', 'Safety4 out of 5', ...    40      Lac  \n","3                                                NaN  1.47    Crore  \n","4  ['Environment5 out of 5', 'Safety3 out of 5', ...    70      Lac  \n","\n","[5 rows x 21 columns]"]},"execution_count":11,"metadata":{},"output_type":"execute_result"}],"source":["flats_df.head()\n","# rename columns\n","flats_df.rename(columns={'area':'price_per_sqft'},inplace=True)\n","flats_df.head()"]},{"cell_type":"code","execution_count":12,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":142,"status":"ok","timestamp":1702336339696,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"qCFrpD683vCu","outputId":"fbbfbfd6-b126-4423-a4fd-169b0f5292b8"},"outputs":[{"data":{"text/plain":["price_per_sqft\n","₹ 10,000/sq.ft.    19\n","₹ 8,000/sq.ft.     16\n","₹ 12,500/sq.ft.    16\n","₹ 6,666/sq.ft.     13\n","₹ 5,000/sq.ft.     13\n","                   ..\n","₹ 20,602/sq.ft.     1\n","₹ 12,401/sq.ft.     1\n","₹ 6,224/sq.ft.      1\n","₹ 8,179/sq.ft.      1\n","₹ 35,222/sq.ft.     1\n","Name: count, Length: 2128, dtype: int64"]},"execution_count":12,"metadata":{},"output_type":"execute_result"}],"source":["flats_df['price_per_sqft'].value_counts()"]},{"cell_type":"code","execution_count":13,"metadata":{"executionInfo":{"elapsed":157,"status":"ok","timestamp":1702336343274,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"g4xiJd5u4Ryd"},"outputs":[],"source":["flats_df['price_per_sqft'] = flats_df['price_per_sqft'].str.split('/').str.get(0).str.replace('₹','').str.replace(',','').str.strip().astype(float)"]},{"cell_type":"code","execution_count":14,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":130,"status":"ok","timestamp":1702336345875,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"p_t9MrKm4Y16","outputId":"117f4a19-c7bc-46c3-a2c4-605a017e08fb"},"outputs":[{"name":"stdout","output_type":"stream","text":["<class 'pandas.core.frame.DataFrame'>\n","Index: 2996 entries, 0 to 3007\n","Data columns (total 21 columns):\n"," #   Column           Non-Null Count  Dtype  \n","---  ------           --------------  -----  \n"," 0   property_name    2996 non-null   object \n"," 1   property_type    2996 non-null   object \n"," 2   society          2996 non-null   object \n"," 3   price            2996 non-null   float64\n"," 4   price_per_sqft   2996 non-null   float64\n"," 5   areaWithType     2996 non-null   object \n"," 6   bedRoom          2996 non-null   object \n"," 7   bathroom         2996 non-null   object \n"," 8   balcony          2996 non-null   object \n"," 9   additionalRoom   1692 non-null   object \n"," 10  address          2990 non-null   object \n"," 11  floorNum         2994 non-null   object \n"," 12  facing           2122 non-null   object \n"," 13  agePossession    2995 non-null   object \n"," 14  nearbyLocations  2905 non-null   object \n"," 15  description      2996 non-null   object \n"," 16  furnishDetails   2200 non-null   object \n"," 17  features         2589 non-null   object \n"," 18  rating           2668 non-null   object \n"," 19  value            2996 non-null   object \n"," 20  currency         2996 non-null   object \n","dtypes: float64(2), object(19)\n","memory usage: 514.9+ KB\n"]}],"source":["#flats_df['price']=flats_df['price'].astype(float)\n","flats_df.info()"]},{"cell_type":"code","execution_count":15,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":139,"status":"ok","timestamp":1702336349535,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"cpIeG3vZ-SpI","outputId":"cc9f9d98-7855-4e3a-a364-43df0675eaec"},"outputs":[{"data":{"text/plain":["bedRoom\n","3 Bedrooms    1437\n","2 Bedrooms     943\n","4 Bedrooms     478\n","1 Bedroom      104\n","5 Bedrooms      31\n","6 Bedrooms       3\n","Name: count, dtype: int64"]},"execution_count":15,"metadata":{},"output_type":"execute_result"}],"source":["# bedrooms\n","flats_df['bedRoom'].value_counts()"]},{"cell_type":"code","execution_count":16,"metadata":{"executionInfo":{"elapsed":137,"status":"ok","timestamp":1702336359336,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"_ejgUxTu-cOg"},"outputs":[],"source":["flats_df[flats_df['bedRoom'].isnull()]\n","flats_df['bedRoom'] = flats_df['bedRoom'].str.split(' ').str.get(0).astype('int')"]},{"cell_type":"code","execution_count":17,"metadata":{"executionInfo":{"elapsed":143,"status":"ok","timestamp":1702336370477,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"pMXQn-gi-5mK"},"outputs":[],"source":["# bathroom\n","flats_df['bathroom'].value_counts()\n","flats_df['bathroom'] = flats_df['bathroom'].str.split(' ').str.get(0).astype('int')"]},{"cell_type":"code","execution_count":18,"metadata":{"executionInfo":{"elapsed":157,"status":"ok","timestamp":1702336376095,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"L-WFXdFU_Bpi"},"outputs":[],"source":["# balcony\n","flats_df['balcony'].value_counts()\n","flats_df['balcony'] = flats_df['balcony'].str.split(' ').str.get(0).str.replace('No','0')"]},{"cell_type":"code","execution_count":19,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":170,"status":"ok","timestamp":1702336378142,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"Bd57-4Qa_XC2","outputId":"04a8b7ae-fd70-4a8c-b7e6-123699f60f89"},"outputs":[{"data":{"text/plain":["balcony\n","3     973\n","3+    862\n","2     749\n","1     315\n","0      97\n","Name: count, dtype: int64"]},"execution_count":19,"metadata":{},"output_type":"execute_result"}],"source":["flats_df['balcony'].value_counts()"]},{"cell_type":"code","execution_count":20,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":151,"status":"ok","timestamp":1702336381579,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"G8thw9c-_mb0","outputId":"de3705f1-3b86-461b-e743-ac73d1ede1df"},"outputs":[{"data":{"text/plain":["additionalRoom\n","Servant Room                                     629\n","Study Room                                       232\n","Others                                           179\n","Pooja Room                                       132\n","Study Room,Servant Room                           81\n","Store Room                                        76\n","Pooja Room,Servant Room                           60\n","Servant Room,Others                               52\n","Servant Room,Pooja Room                           30\n","Study Room,Others                                 27\n","Pooja Room,Study Room,Servant Room,Others         25\n","Pooja Room,Study Room,Servant Room                24\n","Servant Room,Store Room                           19\n","Pooja Room,Study Room                             13\n","Pooja Room,Study Room,Servant Room,Store Room     12\n","Study Room,Pooja Room                              8\n","Servant Room,Study Room                            8\n","Study Room,Servant Room,Store Room                 7\n","Pooja Room,Store Room                              6\n","Pooja Room,Others                                  6\n","Others,Servant Room                                6\n","Servant Room,Study Room,Pooja Room,Store Room      6\n","Pooja Room,Servant Room,Others                     6\n","Study Room,Servant Room,Others                     5\n","Pooja Room,Store Room,Study Room,Servant Room      4\n","Pooja Room,Study Room,Store Room                   4\n","Servant Room,Pooja Room,Study Room,Store Room      3\n","Study Room,Pooja Room,Store Room                   3\n","Store Room,Servant Room                            3\n","Servant Room,Study Room,Store Room                 2\n","Pooja Room,Study Room,Others                       2\n","Study Room,Pooja Room,Servant Room                 2\n","Servant Room,Others,Store Room,Pooja Room          2\n","Servant Room,Others,Pooja Room                     2\n","Study Room,Servant Room,Pooja Room,Store Room      2\n","Others,Study Room                                  1\n","Servant Room,Study Room,Others                     1\n","Servant Room,Pooja Room,Study Room                 1\n","Servant Room,Study Room,Pooja Room                 1\n","Store Room,Pooja Room,Servant Room                 1\n","Servant Room,Pooja Room,Store Room,Study Room      1\n","Study Room,Store Room                              1\n","Store Room,Study Room                              1\n","Servant Room,Pooja Room,Store Room                 1\n","Study Room,Servant Room,Store Room,Pooja Room      1\n","Study Room,Servant Room,Pooja Room                 1\n","Pooja Room,Servant Room,Study Room,Store Room      1\n","Pooja Room,Study Room,Store Room,Servant Room      1\n","Store Room,Pooja Room                              1\n","Name: count, dtype: int64"]},"execution_count":20,"metadata":{},"output_type":"execute_result"}],"source":["# additionalRoom\n","flats_df['additionalRoom'].value_counts()"]},{"cell_type":"code","execution_count":21,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":150,"status":"ok","timestamp":1702336385730,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"iYl1fhjy_peI","outputId":"f8d51682-95dc-4ec8-c369-2dd0f7f7d44c"},"outputs":[{"data":{"text/plain":["2996"]},"execution_count":21,"metadata":{},"output_type":"execute_result"}],"source":["flats_df['additionalRoom'].fillna('not available',inplace=True)\n","flats_df['additionalRoom'] = flats_df['additionalRoom'].str.lower()\n","flats_df.shape[0]"]},{"cell_type":"code","execution_count":22,"metadata":{"executionInfo":{"elapsed":149,"status":"ok","timestamp":1702336388423,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"HbEtjGTzB3xf"},"outputs":[],"source":["flats_df['floorNum']=flats_df['floorNum'].str.strip(\" \")\n"]},{"cell_type":"code","execution_count":23,"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"executionInfo":{"elapsed":191,"status":"ok","timestamp":1702336390195,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"6Zx-0IB2ALkv","outputId":"c9711cbf-e58f-4e7b-86d6-566223d8bf05"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>property_name</th>\n","      <th>property_type</th>\n","      <th>society</th>\n","      <th>price</th>\n","      <th>price_per_sqft</th>\n","      <th>areaWithType</th>\n","      <th>bedRoom</th>\n","      <th>bathroom</th>\n","      <th>balcony</th>\n","      <th>additionalRoom</th>\n","      <th>...</th>\n","      <th>floorNum</th>\n","      <th>facing</th>\n","      <th>agePossession</th>\n","      <th>nearbyLocations</th>\n","      <th>description</th>\n","      <th>furnishDetails</th>\n","      <th>features</th>\n","      <th>rating</th>\n","      <th>value</th>\n","      <th>currency</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2 BHK Flat in Krishna Colony</td>\n","      <td>2 BHK</td>\n","      <td>maa bhagwati residency</td>\n","      <td>0.45</td>\n","      <td>5000.0</td>\n","      <td>Carpet area: 900 (83.61 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>not available</td>\n","      <td>...</td>\n","      <td>4th   of 4 Floors</td>\n","      <td>West</td>\n","      <td>1 to 5 Year Old</td>\n","      <td>['Chintapurni Mandir', 'State bank ATM', 'Pear...</td>\n","      <td>So with lift.Maa bhagwati residency is one of ...</td>\n","      <td>['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...</td>\n","      <td>['Feng Shui / Vaastu Compliant', 'Security / F...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>45</td>\n","      <td>Lac</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2 BHK Flat in Ashok Vihar</td>\n","      <td>2 BHK</td>\n","      <td>apna enclave</td>\n","      <td>0.50</td>\n","      <td>7692.0</td>\n","      <td>Carpet area: 650 (60.39 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>not available</td>\n","      <td>...</td>\n","      <td>1st   of 3 Floors</td>\n","      <td>West</td>\n","      <td>10+ Year Old</td>\n","      <td>['Chintapurni Mandir', 'Sheetla Mata Mandir', ...</td>\n","      <td>Property situated on main road, railway statio...</td>\n","      <td>['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...</td>\n","      <td>['Security / Fire Alarm', 'Maintenance Staff',...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>50</td>\n","      <td>Lac</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2 BHK Flat in Sohna</td>\n","      <td>2 BHK</td>\n","      <td>tulsiani easy in homes</td>\n","      <td>0.40</td>\n","      <td>6722.0</td>\n","      <td>Carpet area: 595 (55.28 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>3</td>\n","      <td>not available</td>\n","      <td>...</td>\n","      <td>12nd   of 14 Floors</td>\n","      <td>NaN</td>\n","      <td>0 to 1 Year Old</td>\n","      <td>['Huda City Metro', 'Golf Course extn road', '...</td>\n","      <td>This property is 15 km away from badshapur, gu...</td>\n","      <td>NaN</td>\n","      <td>['Power Back-up', 'Feng Shui / Vaastu Complian...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>40</td>\n","      <td>Lac</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2 BHK Flat in Sector 61 Gurgaon</td>\n","      <td>2 BHK</td>\n","      <td>smart world orchard</td>\n","      <td>1.47</td>\n","      <td>12250.0</td>\n","      <td>Carpet area: 1200 (111.48 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>study room</td>\n","      <td>...</td>\n","      <td>2nd   of 4 Floors</td>\n","      <td>NaN</td>\n","      <td>Dec-23</td>\n","      <td>['Sector 55-56 Metro station', 'Bestech Centra...</td>\n","      <td>Near to metro station of sector 56 and opposit...</td>\n","      <td>NaN</td>\n","      <td>['Security / Fire Alarm', 'Private Garden / Te...</td>\n","      <td>NaN</td>\n","      <td>1.47</td>\n","      <td>Crore</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2 BHK Flat in Sector 92 Gurgaon</td>\n","      <td>2 BHK</td>\n","      <td>parkwood westend</td>\n","      <td>0.70</td>\n","      <td>5204.0</td>\n","      <td>Super Built up area 1345(124.95 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>3</td>\n","      <td>study room</td>\n","      <td>...</td>\n","      <td>5th   of 8 Floors</td>\n","      <td>NaN</td>\n","      <td>Under Construction</td>\n","      <td>['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...</td>\n","      <td>We are the proud owners of this 2 bhk alongwit...</td>\n","      <td>[]</td>\n","      <td>NaN</td>\n","      <td>['Environment5 out of 5', 'Safety3 out of 5', ...</td>\n","      <td>70</td>\n","      <td>Lac</td>\n","    </tr>\n","    <tr>\n","      <th>...</th>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","      <td>...</td>\n","    </tr>\n","    <tr>\n","      <th>3003</th>\n","      <td>3 BHK Flat in Sector 86 Gurgaon</td>\n","      <td>3 BHK</td>\n","      <td>ansal heights 86</td>\n","      <td>1.05</td>\n","      <td>5541.0</td>\n","      <td>Super Built up area 1895(176.05 sq.m.)</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>servant room</td>\n","      <td>...</td>\n","      <td>9th   of 13 Floors</td>\n","      <td>North-East</td>\n","      <td>Under Construction</td>\n","      <td>['IRIS Broadway Mall', 'Delhi Jaipur Expresswa...</td>\n","      <td>Residential apartment for sell.Located in sect...</td>\n","      <td>[]</td>\n","      <td>NaN</td>\n","      <td>['Safety4.5 out of 5', 'Lifestyle5 out of 5', ...</td>\n","      <td>1.05</td>\n","      <td>Crore</td>\n","    </tr>\n","    <tr>\n","      <th>3004</th>\n","      <td>5 BHK Flat in Sector 48 Gurgaon</td>\n","      <td>5 BHK</td>\n","      <td>parsvnath green ville</td>\n","      <td>3.30</td>\n","      <td>9984.0</td>\n","      <td>Super Built up area 3905(362.79 sq.m.)Built Up...</td>\n","      <td>5</td>\n","      <td>5</td>\n","      <td>3+</td>\n","      <td>servant room</td>\n","      <td>...</td>\n","      <td>4th   of 5 Floors</td>\n","      <td>NaN</td>\n","      <td>10+ Year Old</td>\n","      <td>['Sri Radhe Krishna Temple', 'Icici bank ATM',...</td>\n","      <td>5 bhk duplex penthouse in low rise building.Av...</td>\n","      <td>NaN</td>\n","      <td>['Security / Fire Alarm', 'Private Garden / Te...</td>\n","      <td>['Management4 out of 5', 'Green Area4 out of 5...</td>\n","      <td>3.3</td>\n","      <td>Crore</td>\n","    </tr>\n","    <tr>\n","      <th>3005</th>\n","      <td>3 BHK Flat in Sector 108 Gurgaon</td>\n","      <td>3 BHK</td>\n","      <td>raheja vedaanta</td>\n","      <td>0.95</td>\n","      <td>5214.0</td>\n","      <td>Super Built up area 1822(169.27 sq.m.)</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>others</td>\n","      <td>...</td>\n","      <td>3rd   of 22 Floors</td>\n","      <td>NaN</td>\n","      <td>1 to 5 Year Old</td>\n","      <td>NaN</td>\n","      <td>3 bedroom flat with full woodwork. Ready to mo...</td>\n","      <td>[]</td>\n","      <td>['Security / Fire Alarm', 'Feng Shui / Vaastu ...</td>\n","      <td>['Management3 out of 5', 'Green Area4 out of 5...</td>\n","      <td>95</td>\n","      <td>Lac</td>\n","    </tr>\n","    <tr>\n","      <th>3006</th>\n","      <td>3 BHK Flat in DLF Phase 3</td>\n","      <td>3 BHK</td>\n","      <td>ambience lagoon</td>\n","      <td>5.80</td>\n","      <td>12500.0</td>\n","      <td>Built Up area: 3700 (343.74 sq.m.)</td>\n","      <td>3</td>\n","      <td>4</td>\n","      <td>3+</td>\n","      <td>pooja room,study room,servant room,others</td>\n","      <td>...</td>\n","      <td>9th   of 9 Floors</td>\n","      <td>North-East</td>\n","      <td>10+ Year Old</td>\n","      <td>['Micromax moulsari avenue metro station', 'In...</td>\n","      <td>Luxury condominium complex located on delhi gu...</td>\n","      <td>['1 Water Purifier', '10 Fan', '1 Fridge', '1 ...</td>\n","      <td>['Security / Fire Alarm', 'Private Garden / Te...</td>\n","      <td>['Management5 out of 5', 'Green Area5 out of 5...</td>\n","      <td>5.8</td>\n","      <td>Crore</td>\n","    </tr>\n","    <tr>\n","      <th>3007</th>\n","      <td>4 BHK Flat in Sector 54 Gurgaon</td>\n","      <td>4 BHK</td>\n","      <td>dlf the crest</td>\n","      <td>11.00</td>\n","      <td>35222.0</td>\n","      <td>Super Built up area 3123(290.14 sq.m.)</td>\n","      <td>4</td>\n","      <td>6</td>\n","      <td>3</td>\n","      <td>servant room</td>\n","      <td>...</td>\n","      <td>7th   of 36 Floors</td>\n","      <td>NaN</td>\n","      <td>1 to 5 Year Old</td>\n","      <td>['Sector 53-54 Metro Station', 'Ardee Mall', '...</td>\n","      <td>Club &amp; pool facing\\nVrv air conditioning</td>\n","      <td>['6 Fan', '1 Fridge', '1 Exhaust Fan', '5 Geys...</td>\n","      <td>['Security / Fire Alarm', 'Power Back-up', 'In...</td>\n","      <td>['Management4 out of 5', 'Green Area4 out of 5...</td>\n","      <td>11</td>\n","      <td>Crore</td>\n","    </tr>\n","  </tbody>\n","</table>\n","<p>2994 rows × 21 columns</p>\n","</div>"],"text/plain":["                         property_name property_type                 society  \\\n","0         2 BHK Flat in Krishna Colony         2 BHK  maa bhagwati residency   \n","1            2 BHK Flat in Ashok Vihar         2 BHK            apna enclave   \n","2                  2 BHK Flat in Sohna         2 BHK  tulsiani easy in homes   \n","3      2 BHK Flat in Sector 61 Gurgaon         2 BHK     smart world orchard   \n","4      2 BHK Flat in Sector 92 Gurgaon         2 BHK        parkwood westend   \n","...                                ...           ...                     ...   \n","3003   3 BHK Flat in Sector 86 Gurgaon         3 BHK        ansal heights 86   \n","3004   5 BHK Flat in Sector 48 Gurgaon         5 BHK   parsvnath green ville   \n","3005  3 BHK Flat in Sector 108 Gurgaon         3 BHK         raheja vedaanta   \n","3006         3 BHK Flat in DLF Phase 3         3 BHK         ambience lagoon   \n","3007   4 BHK Flat in Sector 54 Gurgaon         4 BHK           dlf the crest   \n","\n","      price  price_per_sqft  \\\n","0      0.45          5000.0   \n","1      0.50          7692.0   \n","2      0.40          6722.0   \n","3      1.47         12250.0   \n","4      0.70          5204.0   \n","...     ...             ...   \n","3003   1.05          5541.0   \n","3004   3.30          9984.0   \n","3005   0.95          5214.0   \n","3006   5.80         12500.0   \n","3007  11.00         35222.0   \n","\n","                                           areaWithType  bedRoom  bathroom  \\\n","0                        Carpet area: 900 (83.61 sq.m.)        2         2   \n","1                        Carpet area: 650 (60.39 sq.m.)        2         2   \n","2                        Carpet area: 595 (55.28 sq.m.)        2         2   \n","3                      Carpet area: 1200 (111.48 sq.m.)        2         2   \n","4                Super Built up area 1345(124.95 sq.m.)        2         2   \n","...                                                 ...      ...       ...   \n","3003             Super Built up area 1895(176.05 sq.m.)        3         3   \n","3004  Super Built up area 3905(362.79 sq.m.)Built Up...        5         5   \n","3005             Super Built up area 1822(169.27 sq.m.)        3         3   \n","3006                 Built Up area: 3700 (343.74 sq.m.)        3         4   \n","3007             Super Built up area 3123(290.14 sq.m.)        4         6   \n","\n","     balcony                             additionalRoom  ...  \\\n","0          1                              not available  ...   \n","1          1                              not available  ...   \n","2          3                              not available  ...   \n","3          2                                 study room  ...   \n","4          3                                 study room  ...   \n","...      ...                                        ...  ...   \n","3003       3                               servant room  ...   \n","3004      3+                               servant room  ...   \n","3005       3                                     others  ...   \n","3006      3+  pooja room,study room,servant room,others  ...   \n","3007       3                               servant room  ...   \n","\n","                 floorNum      facing       agePossession  \\\n","0       4th   of 4 Floors        West     1 to 5 Year Old   \n","1       1st   of 3 Floors        West        10+ Year Old   \n","2     12nd   of 14 Floors         NaN     0 to 1 Year Old   \n","3       2nd   of 4 Floors         NaN              Dec-23   \n","4       5th   of 8 Floors         NaN  Under Construction   \n","...                   ...         ...                 ...   \n","3003   9th   of 13 Floors  North-East  Under Construction   \n","3004    4th   of 5 Floors         NaN        10+ Year Old   \n","3005   3rd   of 22 Floors         NaN     1 to 5 Year Old   \n","3006    9th   of 9 Floors  North-East        10+ Year Old   \n","3007   7th   of 36 Floors         NaN     1 to 5 Year Old   \n","\n","                                        nearbyLocations  \\\n","0     ['Chintapurni Mandir', 'State bank ATM', 'Pear...   \n","1     ['Chintapurni Mandir', 'Sheetla Mata Mandir', ...   \n","2     ['Huda City Metro', 'Golf Course extn road', '...   \n","3     ['Sector 55-56 Metro station', 'Bestech Centra...   \n","4     ['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...   \n","...                                                 ...   \n","3003  ['IRIS Broadway Mall', 'Delhi Jaipur Expresswa...   \n","3004  ['Sri Radhe Krishna Temple', 'Icici bank ATM',...   \n","3005                                                NaN   \n","3006  ['Micromax moulsari avenue metro station', 'In...   \n","3007  ['Sector 53-54 Metro Station', 'Ardee Mall', '...   \n","\n","                                            description  \\\n","0     So with lift.Maa bhagwati residency is one of ...   \n","1     Property situated on main road, railway statio...   \n","2     This property is 15 km away from badshapur, gu...   \n","3     Near to metro station of sector 56 and opposit...   \n","4     We are the proud owners of this 2 bhk alongwit...   \n","...                                                 ...   \n","3003  Residential apartment for sell.Located in sect...   \n","3004  5 bhk duplex penthouse in low rise building.Av...   \n","3005  3 bedroom flat with full woodwork. Ready to mo...   \n","3006  Luxury condominium complex located on delhi gu...   \n","3007           Club & pool facing\\nVrv air conditioning   \n","\n","                                         furnishDetails  \\\n","0     ['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...   \n","1     ['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...   \n","2                                                   NaN   \n","3                                                   NaN   \n","4                                                    []   \n","...                                                 ...   \n","3003                                                 []   \n","3004                                                NaN   \n","3005                                                 []   \n","3006  ['1 Water Purifier', '10 Fan', '1 Fridge', '1 ...   \n","3007  ['6 Fan', '1 Fridge', '1 Exhaust Fan', '5 Geys...   \n","\n","                                               features  \\\n","0     ['Feng Shui / Vaastu Compliant', 'Security / F...   \n","1     ['Security / Fire Alarm', 'Maintenance Staff',...   \n","2     ['Power Back-up', 'Feng Shui / Vaastu Complian...   \n","3     ['Security / Fire Alarm', 'Private Garden / Te...   \n","4                                                   NaN   \n","...                                                 ...   \n","3003                                                NaN   \n","3004  ['Security / Fire Alarm', 'Private Garden / Te...   \n","3005  ['Security / Fire Alarm', 'Feng Shui / Vaastu ...   \n","3006  ['Security / Fire Alarm', 'Private Garden / Te...   \n","3007  ['Security / Fire Alarm', 'Power Back-up', 'In...   \n","\n","                                                 rating value currency  \n","0     ['Environment4 out of 5', 'Safety4 out of 5', ...    45      Lac  \n","1     ['Environment4 out of 5', 'Safety4 out of 5', ...    50      Lac  \n","2     ['Environment4 out of 5', 'Safety4 out of 5', ...    40      Lac  \n","3                                                   NaN  1.47    Crore  \n","4     ['Environment5 out of 5', 'Safety3 out of 5', ...    70      Lac  \n","...                                                 ...   ...      ...  \n","3003  ['Safety4.5 out of 5', 'Lifestyle5 out of 5', ...  1.05    Crore  \n","3004  ['Management4 out of 5', 'Green Area4 out of 5...   3.3    Crore  \n","3005  ['Management3 out of 5', 'Green Area4 out of 5...    95      Lac  \n","3006  ['Management5 out of 5', 'Green Area5 out of 5...   5.8    Crore  \n","3007  ['Management4 out of 5', 'Green Area4 out of 5...    11    Crore  \n","\n","[2994 rows x 21 columns]"]},"execution_count":23,"metadata":{},"output_type":"execute_result"}],"source":["flats_df[~flats_df['floorNum'].isnull()]"]},{"cell_type":"code","execution_count":24,"metadata":{"executionInfo":{"elapsed":158,"status":"ok","timestamp":1702336394039,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"gPOHO4edATuJ"},"outputs":[],"source":["flats_df['floor_Num'] = flats_df['floorNum'].str.split(' ').str.get(0).replace('Ground','0').str.replace('Basement','-1').str.replace('Lower','0').str.extract(r'(\\d+)')\n","flats_df['total_floors']=flats_df['floorNum'].str.extract(r'of (\\d+)')"]},{"cell_type":"code","execution_count":25,"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":1000},"executionInfo":{"elapsed":164,"status":"ok","timestamp":1702336395811,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"G4t63PbCBBi8","outputId":"4ab66e11-e6d2-4073-ebbd-c2690ba5c58f"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>property_name</th>\n","      <th>property_type</th>\n","      <th>society</th>\n","      <th>price</th>\n","      <th>price_per_sqft</th>\n","      <th>areaWithType</th>\n","      <th>bedRoom</th>\n","      <th>bathroom</th>\n","      <th>balcony</th>\n","      <th>additionalRoom</th>\n","      <th>address</th>\n","      <th>floorNum</th>\n","      <th>facing</th>\n","      <th>agePossession</th>\n","      <th>nearbyLocations</th>\n","      <th>description</th>\n","      <th>furnishDetails</th>\n","      <th>features</th>\n","      <th>rating</th>\n","      <th>value</th>\n","      <th>currency</th>\n","      <th>floor_Num</th>\n","      <th>total_floors</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2 BHK Flat in Krishna Colony</td>\n","      <td>2 BHK</td>\n","      <td>maa bhagwati residency</td>\n","      <td>0.45</td>\n","      <td>5000.0</td>\n","      <td>Carpet area: 900 (83.61 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>not available</td>\n","      <td>Krishna Colony, Gurgaon, Haryana</td>\n","      <td>4th   of 4 Floors</td>\n","      <td>West</td>\n","      <td>1 to 5 Year Old</td>\n","      <td>['Chintapurni Mandir', 'State bank ATM', 'Pear...</td>\n","      <td>So with lift.Maa bhagwati residency is one of ...</td>\n","      <td>['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...</td>\n","      <td>['Feng Shui / Vaastu Compliant', 'Security / F...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>45</td>\n","      <td>Lac</td>\n","      <td>4</td>\n","      <td>4</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2 BHK Flat in Ashok Vihar</td>\n","      <td>2 BHK</td>\n","      <td>apna enclave</td>\n","      <td>0.50</td>\n","      <td>7692.0</td>\n","      <td>Carpet area: 650 (60.39 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>not available</td>\n","      <td>46b, Ashok Vihar, Gurgaon, Haryana</td>\n","      <td>1st   of 3 Floors</td>\n","      <td>West</td>\n","      <td>10+ Year Old</td>\n","      <td>['Chintapurni Mandir', 'Sheetla Mata Mandir', ...</td>\n","      <td>Property situated on main road, railway statio...</td>\n","      <td>['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...</td>\n","      <td>['Security / Fire Alarm', 'Maintenance Staff',...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>50</td>\n","      <td>Lac</td>\n","      <td>1</td>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2 BHK Flat in Sohna</td>\n","      <td>2 BHK</td>\n","      <td>tulsiani easy in homes</td>\n","      <td>0.40</td>\n","      <td>6722.0</td>\n","      <td>Carpet area: 595 (55.28 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>3</td>\n","      <td>not available</td>\n","      <td>Sohna, Gurgaon, Haryana</td>\n","      <td>12nd   of 14 Floors</td>\n","      <td>NaN</td>\n","      <td>0 to 1 Year Old</td>\n","      <td>['Huda City Metro', 'Golf Course extn road', '...</td>\n","      <td>This property is 15 km away from badshapur, gu...</td>\n","      <td>NaN</td>\n","      <td>['Power Back-up', 'Feng Shui / Vaastu Complian...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>40</td>\n","      <td>Lac</td>\n","      <td>12</td>\n","      <td>14</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2 BHK Flat in Sector 61 Gurgaon</td>\n","      <td>2 BHK</td>\n","      <td>smart world orchard</td>\n","      <td>1.47</td>\n","      <td>12250.0</td>\n","      <td>Carpet area: 1200 (111.48 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>study room</td>\n","      <td>Sector 61 Gurgaon, Gurgaon, Haryana</td>\n","      <td>2nd   of 4 Floors</td>\n","      <td>NaN</td>\n","      <td>Dec-23</td>\n","      <td>['Sector 55-56 Metro station', 'Bestech Centra...</td>\n","      <td>Near to metro station of sector 56 and opposit...</td>\n","      <td>NaN</td>\n","      <td>['Security / Fire Alarm', 'Private Garden / Te...</td>\n","      <td>NaN</td>\n","      <td>1.47</td>\n","      <td>Crore</td>\n","      <td>2</td>\n","      <td>4</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2 BHK Flat in Sector 92 Gurgaon</td>\n","      <td>2 BHK</td>\n","      <td>parkwood westend</td>\n","      <td>0.70</td>\n","      <td>5204.0</td>\n","      <td>Super Built up area 1345(124.95 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>3</td>\n","      <td>study room</td>\n","      <td>Sector 92 Gurgaon, Gurgaon, Haryana</td>\n","      <td>5th   of 8 Floors</td>\n","      <td>NaN</td>\n","      <td>Under Construction</td>\n","      <td>['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...</td>\n","      <td>We are the proud owners of this 2 bhk alongwit...</td>\n","      <td>[]</td>\n","      <td>NaN</td>\n","      <td>['Environment5 out of 5', 'Safety3 out of 5', ...</td>\n","      <td>70</td>\n","      <td>Lac</td>\n","      <td>5</td>\n","      <td>8</td>\n","    </tr>\n","    <tr>\n","      <th>5</th>\n","      <td>2 BHK Flat in Sector 36 Gurgaon</td>\n","      <td>2 BHK</td>\n","      <td>signature global infinity mall</td>\n","      <td>0.41</td>\n","      <td>6269.0</td>\n","      <td>Built Up area: 654 (60.76 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>3</td>\n","      <td>not available</td>\n","      <td>Sohna Sector 36, Sector 36 Gurgaon, Gurgaon, H...</td>\n","      <td>3rd   of 3 Floors</td>\n","      <td>NaN</td>\n","      <td>undefined</td>\n","      <td>NaN</td>\n","      <td>Best in class property available at sector 36 ...</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>41</td>\n","      <td>Lac</td>\n","      <td>3</td>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>6</th>\n","      <td>3 BHK Flat in Dwarka Expressway Gurgaon</td>\n","      <td>3 BHK</td>\n","      <td>the cocoon</td>\n","      <td>2.00</td>\n","      <td>13333.0</td>\n","      <td>Super Built up area 1500(139.35 sq.m.)</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>not available</td>\n","      <td>Dwarka Expressway Gurgaon, Gurgaon, Haryana</td>\n","      <td>5th   of 25 Floors</td>\n","      <td>NaN</td>\n","      <td>0 to 1 Year Old</td>\n","      <td>['Shri Multispeciality Hospital', 'Esic Hospit...</td>\n","      <td>Residential apartment for sell.The property co...</td>\n","      <td>[]</td>\n","      <td>NaN</td>\n","      <td>NaN</td>\n","      <td>2</td>\n","      <td>Crore</td>\n","      <td>5</td>\n","      <td>25</td>\n","    </tr>\n","    <tr>\n","      <th>7</th>\n","      <td>3 BHK Flat in Sector 104 Gurgaon</td>\n","      <td>3 BHK</td>\n","      <td>ats triumph</td>\n","      <td>1.80</td>\n","      <td>7860.0</td>\n","      <td>Carpet area: 2290 (212.75 sq.m.)</td>\n","      <td>3</td>\n","      <td>4</td>\n","      <td>3</td>\n","      <td>not available</td>\n","      <td>Sector 104 Gurgaon, Gurgaon, Haryana</td>\n","      <td>14th   of 27 Floors</td>\n","      <td>NaN</td>\n","      <td>0 to 1 Year Old</td>\n","      <td>['IFFCO Chowk Metro Station', 'The Esplanade M...</td>\n","      <td>Ats triumph is one of gurgaon's most sought af...</td>\n","      <td>[]</td>\n","      <td>['Power Back-up', 'Intercom Facility', 'Lift(s...</td>\n","      <td>['Green Area4 out of 5', 'Amenities4.5 out of ...</td>\n","      <td>1.8</td>\n","      <td>Crore</td>\n","      <td>14</td>\n","      <td>27</td>\n","    </tr>\n","    <tr>\n","      <th>8</th>\n","      <td>2 BHK Flat in Sector 88B Gurgaon</td>\n","      <td>2 BHK</td>\n","      <td>vatika xpressions</td>\n","      <td>1.10</td>\n","      <td>8148.0</td>\n","      <td>Built Up area: 1350 (125.42 sq.m.)Carpet area:...</td>\n","      <td>2</td>\n","      <td>4</td>\n","      <td>3+</td>\n","      <td>study room</td>\n","      <td>H 23, Sector 88B Gurgaon, Gurgaon, Haryana</td>\n","      <td>2nd   of 3 Floors</td>\n","      <td>North-East</td>\n","      <td>Under Construction</td>\n","      <td>['Dwarka Expressway', 'Adarsh public school,Ga...</td>\n","      <td>We are the proud owners of this 2 bhk apartmen...</td>\n","      <td>NaN</td>\n","      <td>['Feng Shui / Vaastu Compliant', 'Intercom Fac...</td>\n","      <td>NaN</td>\n","      <td>1.1</td>\n","      <td>Crore</td>\n","      <td>2</td>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>9</th>\n","      <td>3 BHK Flat in Sector 78 Gurgaon</td>\n","      <td>3 BHK</td>\n","      <td>raheja revanta</td>\n","      <td>4.75</td>\n","      <td>16885.0</td>\n","      <td>Built Up area: 2813 (261.34 sq.m.)</td>\n","      <td>3</td>\n","      <td>3</td>\n","      <td>2</td>\n","      <td>servant room</td>\n","      <td>Sector 78 Gurgaon, Gurgaon, Haryana</td>\n","      <td>31st   of 40 Floors</td>\n","      <td>NaN</td>\n","      <td>Dec-23</td>\n","      <td>['Sapphire 83 Mall', 'NH-8', 'Bal Bharti Publi...</td>\n","      <td>This 3 bhk flat is located in raheja revanta, ...</td>\n","      <td>NaN</td>\n","      <td>['Security / Fire Alarm', 'Intercom Facility',...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>4.75</td>\n","      <td>Crore</td>\n","      <td>31</td>\n","      <td>40</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                             property_name property_type  \\\n","0             2 BHK Flat in Krishna Colony         2 BHK   \n","1                2 BHK Flat in Ashok Vihar         2 BHK   \n","2                      2 BHK Flat in Sohna         2 BHK   \n","3          2 BHK Flat in Sector 61 Gurgaon         2 BHK   \n","4          2 BHK Flat in Sector 92 Gurgaon         2 BHK   \n","5          2 BHK Flat in Sector 36 Gurgaon         2 BHK   \n","6  3 BHK Flat in Dwarka Expressway Gurgaon         3 BHK   \n","7         3 BHK Flat in Sector 104 Gurgaon         3 BHK   \n","8         2 BHK Flat in Sector 88B Gurgaon         2 BHK   \n","9          3 BHK Flat in Sector 78 Gurgaon         3 BHK   \n","\n","                          society  price  price_per_sqft  \\\n","0          maa bhagwati residency   0.45          5000.0   \n","1                    apna enclave   0.50          7692.0   \n","2          tulsiani easy in homes   0.40          6722.0   \n","3             smart world orchard   1.47         12250.0   \n","4                parkwood westend   0.70          5204.0   \n","5  signature global infinity mall   0.41          6269.0   \n","6                      the cocoon   2.00         13333.0   \n","7                     ats triumph   1.80          7860.0   \n","8               vatika xpressions   1.10          8148.0   \n","9                  raheja revanta   4.75         16885.0   \n","\n","                                        areaWithType  bedRoom  bathroom  \\\n","0                     Carpet area: 900 (83.61 sq.m.)        2         2   \n","1                     Carpet area: 650 (60.39 sq.m.)        2         2   \n","2                     Carpet area: 595 (55.28 sq.m.)        2         2   \n","3                   Carpet area: 1200 (111.48 sq.m.)        2         2   \n","4             Super Built up area 1345(124.95 sq.m.)        2         2   \n","5                   Built Up area: 654 (60.76 sq.m.)        2         2   \n","6             Super Built up area 1500(139.35 sq.m.)        3         3   \n","7                   Carpet area: 2290 (212.75 sq.m.)        3         4   \n","8  Built Up area: 1350 (125.42 sq.m.)Carpet area:...        2         4   \n","9                 Built Up area: 2813 (261.34 sq.m.)        3         3   \n","\n","  balcony additionalRoom                                            address  \\\n","0       1  not available                   Krishna Colony, Gurgaon, Haryana   \n","1       1  not available                 46b, Ashok Vihar, Gurgaon, Haryana   \n","2       3  not available                            Sohna, Gurgaon, Haryana   \n","3       2     study room                Sector 61 Gurgaon, Gurgaon, Haryana   \n","4       3     study room                Sector 92 Gurgaon, Gurgaon, Haryana   \n","5       3  not available  Sohna Sector 36, Sector 36 Gurgaon, Gurgaon, H...   \n","6       3  not available        Dwarka Expressway Gurgaon, Gurgaon, Haryana   \n","7       3  not available               Sector 104 Gurgaon, Gurgaon, Haryana   \n","8      3+     study room         H 23, Sector 88B Gurgaon, Gurgaon, Haryana   \n","9       2   servant room                Sector 78 Gurgaon, Gurgaon, Haryana   \n","\n","              floorNum      facing       agePossession  \\\n","0    4th   of 4 Floors        West     1 to 5 Year Old   \n","1    1st   of 3 Floors        West        10+ Year Old   \n","2  12nd   of 14 Floors         NaN     0 to 1 Year Old   \n","3    2nd   of 4 Floors         NaN              Dec-23   \n","4    5th   of 8 Floors         NaN  Under Construction   \n","5    3rd   of 3 Floors         NaN           undefined   \n","6   5th   of 25 Floors         NaN     0 to 1 Year Old   \n","7  14th   of 27 Floors         NaN     0 to 1 Year Old   \n","8    2nd   of 3 Floors  North-East  Under Construction   \n","9  31st   of 40 Floors         NaN              Dec-23   \n","\n","                                     nearbyLocations  \\\n","0  ['Chintapurni Mandir', 'State bank ATM', 'Pear...   \n","1  ['Chintapurni Mandir', 'Sheetla Mata Mandir', ...   \n","2  ['Huda City Metro', 'Golf Course extn road', '...   \n","3  ['Sector 55-56 Metro station', 'Bestech Centra...   \n","4  ['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...   \n","5                                                NaN   \n","6  ['Shri Multispeciality Hospital', 'Esic Hospit...   \n","7  ['IFFCO Chowk Metro Station', 'The Esplanade M...   \n","8  ['Dwarka Expressway', 'Adarsh public school,Ga...   \n","9  ['Sapphire 83 Mall', 'NH-8', 'Bal Bharti Publi...   \n","\n","                                         description  \\\n","0  So with lift.Maa bhagwati residency is one of ...   \n","1  Property situated on main road, railway statio...   \n","2  This property is 15 km away from badshapur, gu...   \n","3  Near to metro station of sector 56 and opposit...   \n","4  We are the proud owners of this 2 bhk alongwit...   \n","5  Best in class property available at sector 36 ...   \n","6  Residential apartment for sell.The property co...   \n","7  Ats triumph is one of gurgaon's most sought af...   \n","8  We are the proud owners of this 2 bhk apartmen...   \n","9  This 3 bhk flat is located in raheja revanta, ...   \n","\n","                                      furnishDetails  \\\n","0  ['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...   \n","1  ['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...   \n","2                                                NaN   \n","3                                                NaN   \n","4                                                 []   \n","5                                                NaN   \n","6                                                 []   \n","7                                                 []   \n","8                                                NaN   \n","9                                                NaN   \n","\n","                                            features  \\\n","0  ['Feng Shui / Vaastu Compliant', 'Security / F...   \n","1  ['Security / Fire Alarm', 'Maintenance Staff',...   \n","2  ['Power Back-up', 'Feng Shui / Vaastu Complian...   \n","3  ['Security / Fire Alarm', 'Private Garden / Te...   \n","4                                                NaN   \n","5                                                NaN   \n","6                                                NaN   \n","7  ['Power Back-up', 'Intercom Facility', 'Lift(s...   \n","8  ['Feng Shui / Vaastu Compliant', 'Intercom Fac...   \n","9  ['Security / Fire Alarm', 'Intercom Facility',...   \n","\n","                                              rating value currency floor_Num  \\\n","0  ['Environment4 out of 5', 'Safety4 out of 5', ...    45      Lac         4   \n","1  ['Environment4 out of 5', 'Safety4 out of 5', ...    50      Lac         1   \n","2  ['Environment4 out of 5', 'Safety4 out of 5', ...    40      Lac        12   \n","3                                                NaN  1.47    Crore         2   \n","4  ['Environment5 out of 5', 'Safety3 out of 5', ...    70      Lac         5   \n","5                                                NaN    41      Lac         3   \n","6                                                NaN     2    Crore         5   \n","7  ['Green Area4 out of 5', 'Amenities4.5 out of ...   1.8    Crore        14   \n","8                                                NaN   1.1    Crore         2   \n","9  ['Environment4 out of 5', 'Safety4 out of 5', ...  4.75    Crore        31   \n","\n","  total_floors  \n","0            4  \n","1            3  \n","2           14  \n","3            4  \n","4            8  \n","5            3  \n","6           25  \n","7           27  \n","8            3  \n","9           40  "]},"execution_count":25,"metadata":{},"output_type":"execute_result"}],"source":["pd.set_option('display.max_columns', None)\n","flats_df.head(10)"]},{"cell_type":"code","execution_count":26,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":154,"status":"ok","timestamp":1702336399919,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"9Zq3W_msG_QG","outputId":"1f37ac4c-0094-481e-c696-a10dd068d89d"},"outputs":[{"data":{"text/plain":["facing\n","North-East    505\n","East          489\n","North         301\n","South         203\n","West          183\n","North-West    162\n","South-East    144\n","South-West    135\n","Name: count, dtype: int64"]},"execution_count":26,"metadata":{},"output_type":"execute_result"}],"source":["# facing\n","flats_df['facing'].value_counts()"]},{"cell_type":"code","execution_count":27,"metadata":{"executionInfo":{"elapsed":162,"status":"ok","timestamp":1702336402890,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"F8UiaGRYHC-z"},"outputs":[],"source":["flats_df['facing'].fillna('NA',inplace=True)"]},{"cell_type":"code","execution_count":28,"metadata":{"colab":{"base_uri":"https://localhost:8080/"},"executionInfo":{"elapsed":175,"status":"ok","timestamp":1702336404742,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"ufTvOFVBHHnf","outputId":"6297ca6a-2fc2-4d47-d8d2-806d6135bbce"},"outputs":[{"data":{"text/plain":["facing\n","NA            874\n","North-East    505\n","East          489\n","North         301\n","South         203\n","West          183\n","North-West    162\n","South-East    144\n","South-West    135\n","Name: count, dtype: int64"]},"execution_count":28,"metadata":{},"output_type":"execute_result"}],"source":["flats_df['facing'].value_counts()"]},{"cell_type":"code","execution_count":29,"metadata":{"id":"jrWOfEzHHXsZ"},"outputs":[],"source":["flats_df.insert(loc=4,column='area',value=round((flats_df['price']*10000000)/flats_df['price_per_sqft']))\n"]},{"cell_type":"code","execution_count":30,"metadata":{"colab":{"base_uri":"https://localhost:8080/","height":573},"executionInfo":{"elapsed":298,"status":"ok","timestamp":1702336573435,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"qebPEo_CHhAZ","outputId":"775d6d01-2de5-495c-a626-5689d8be0192"},"outputs":[{"data":{"text/html":["<div>\n","<style scoped>\n","    .dataframe tbody tr th:only-of-type {\n","        vertical-align: middle;\n","    }\n","\n","    .dataframe tbody tr th {\n","        vertical-align: top;\n","    }\n","\n","    .dataframe thead th {\n","        text-align: right;\n","    }\n","</style>\n","<table border=\"1\" class=\"dataframe\">\n","  <thead>\n","    <tr style=\"text-align: right;\">\n","      <th></th>\n","      <th>property_name</th>\n","      <th>Property_type</th>\n","      <th>property_type</th>\n","      <th>society</th>\n","      <th>price</th>\n","      <th>area</th>\n","      <th>price_per_sqft</th>\n","      <th>areaWithType</th>\n","      <th>bedRoom</th>\n","      <th>bathroom</th>\n","      <th>balcony</th>\n","      <th>additionalRoom</th>\n","      <th>address</th>\n","      <th>floorNum</th>\n","      <th>facing</th>\n","      <th>agePossession</th>\n","      <th>nearbyLocations</th>\n","      <th>description</th>\n","      <th>furnishDetails</th>\n","      <th>features</th>\n","      <th>rating</th>\n","      <th>value</th>\n","      <th>currency</th>\n","      <th>floor_Num</th>\n","      <th>total_floors</th>\n","    </tr>\n","  </thead>\n","  <tbody>\n","    <tr>\n","      <th>0</th>\n","      <td>2 BHK Flat in Krishna Colony</td>\n","      <td>flat</td>\n","      <td>2 BHK</td>\n","      <td>maa bhagwati residency</td>\n","      <td>0.45</td>\n","      <td>900.0</td>\n","      <td>5000.0</td>\n","      <td>Carpet area: 900 (83.61 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>not available</td>\n","      <td>Krishna Colony, Gurgaon, Haryana</td>\n","      <td>4th   of 4 Floors</td>\n","      <td>West</td>\n","      <td>1 to 5 Year Old</td>\n","      <td>['Chintapurni Mandir', 'State bank ATM', 'Pear...</td>\n","      <td>So with lift.Maa bhagwati residency is one of ...</td>\n","      <td>['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...</td>\n","      <td>['Feng Shui / Vaastu Compliant', 'Security / F...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>45</td>\n","      <td>Lac</td>\n","      <td>4</td>\n","      <td>4</td>\n","    </tr>\n","    <tr>\n","      <th>1</th>\n","      <td>2 BHK Flat in Ashok Vihar</td>\n","      <td>flat</td>\n","      <td>2 BHK</td>\n","      <td>apna enclave</td>\n","      <td>0.50</td>\n","      <td>650.0</td>\n","      <td>7692.0</td>\n","      <td>Carpet area: 650 (60.39 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>1</td>\n","      <td>not available</td>\n","      <td>46b, Ashok Vihar, Gurgaon, Haryana</td>\n","      <td>1st   of 3 Floors</td>\n","      <td>West</td>\n","      <td>10+ Year Old</td>\n","      <td>['Chintapurni Mandir', 'Sheetla Mata Mandir', ...</td>\n","      <td>Property situated on main road, railway statio...</td>\n","      <td>['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...</td>\n","      <td>['Security / Fire Alarm', 'Maintenance Staff',...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>50</td>\n","      <td>Lac</td>\n","      <td>1</td>\n","      <td>3</td>\n","    </tr>\n","    <tr>\n","      <th>2</th>\n","      <td>2 BHK Flat in Sohna</td>\n","      <td>flat</td>\n","      <td>2 BHK</td>\n","      <td>tulsiani easy in homes</td>\n","      <td>0.40</td>\n","      <td>595.0</td>\n","      <td>6722.0</td>\n","      <td>Carpet area: 595 (55.28 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>3</td>\n","      <td>not available</td>\n","      <td>Sohna, Gurgaon, Haryana</td>\n","      <td>12nd   of 14 Floors</td>\n","      <td>NA</td>\n","      <td>0 to 1 Year Old</td>\n","      <td>['Huda City Metro', 'Golf Course extn road', '...</td>\n","      <td>This property is 15 km away from badshapur, gu...</td>\n","      <td>NaN</td>\n","      <td>['Power Back-up', 'Feng Shui / Vaastu Complian...</td>\n","      <td>['Environment4 out of 5', 'Safety4 out of 5', ...</td>\n","      <td>40</td>\n","      <td>Lac</td>\n","      <td>12</td>\n","      <td>14</td>\n","    </tr>\n","    <tr>\n","      <th>3</th>\n","      <td>2 BHK Flat in Sector 61 Gurgaon</td>\n","      <td>flat</td>\n","      <td>2 BHK</td>\n","      <td>smart world orchard</td>\n","      <td>1.47</td>\n","      <td>1200.0</td>\n","      <td>12250.0</td>\n","      <td>Carpet area: 1200 (111.48 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>study room</td>\n","      <td>Sector 61 Gurgaon, Gurgaon, Haryana</td>\n","      <td>2nd   of 4 Floors</td>\n","      <td>NA</td>\n","      <td>Dec-23</td>\n","      <td>['Sector 55-56 Metro station', 'Bestech Centra...</td>\n","      <td>Near to metro station of sector 56 and opposit...</td>\n","      <td>NaN</td>\n","      <td>['Security / Fire Alarm', 'Private Garden / Te...</td>\n","      <td>NaN</td>\n","      <td>1.47</td>\n","      <td>Crore</td>\n","      <td>2</td>\n","      <td>4</td>\n","    </tr>\n","    <tr>\n","      <th>4</th>\n","      <td>2 BHK Flat in Sector 92 Gurgaon</td>\n","      <td>flat</td>\n","      <td>2 BHK</td>\n","      <td>parkwood westend</td>\n","      <td>0.70</td>\n","      <td>1345.0</td>\n","      <td>5204.0</td>\n","      <td>Super Built up area 1345(124.95 sq.m.)</td>\n","      <td>2</td>\n","      <td>2</td>\n","      <td>3</td>\n","      <td>study room</td>\n","      <td>Sector 92 Gurgaon, Gurgaon, Haryana</td>\n","      <td>5th   of 8 Floors</td>\n","      <td>NA</td>\n","      <td>Under Construction</td>\n","      <td>['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...</td>\n","      <td>We are the proud owners of this 2 bhk alongwit...</td>\n","      <td>[]</td>\n","      <td>NaN</td>\n","      <td>['Environment5 out of 5', 'Safety3 out of 5', ...</td>\n","      <td>70</td>\n","      <td>Lac</td>\n","      <td>5</td>\n","      <td>8</td>\n","    </tr>\n","  </tbody>\n","</table>\n","</div>"],"text/plain":["                     property_name Property_type property_type  \\\n","0     2 BHK Flat in Krishna Colony          flat         2 BHK   \n","1        2 BHK Flat in Ashok Vihar          flat         2 BHK   \n","2              2 BHK Flat in Sohna          flat         2 BHK   \n","3  2 BHK Flat in Sector 61 Gurgaon          flat         2 BHK   \n","4  2 BHK Flat in Sector 92 Gurgaon          flat         2 BHK   \n","\n","                  society  price    area  price_per_sqft  \\\n","0  maa bhagwati residency   0.45   900.0          5000.0   \n","1            apna enclave   0.50   650.0          7692.0   \n","2  tulsiani easy in homes   0.40   595.0          6722.0   \n","3     smart world orchard   1.47  1200.0         12250.0   \n","4        parkwood westend   0.70  1345.0          5204.0   \n","\n","                             areaWithType  bedRoom  bathroom balcony  \\\n","0          Carpet area: 900 (83.61 sq.m.)        2         2       1   \n","1          Carpet area: 650 (60.39 sq.m.)        2         2       1   \n","2          Carpet area: 595 (55.28 sq.m.)        2         2       3   \n","3        Carpet area: 1200 (111.48 sq.m.)        2         2       2   \n","4  Super Built up area 1345(124.95 sq.m.)        2         2       3   \n","\n","  additionalRoom                              address             floorNum  \\\n","0  not available     Krishna Colony, Gurgaon, Haryana    4th   of 4 Floors   \n","1  not available   46b, Ashok Vihar, Gurgaon, Haryana    1st   of 3 Floors   \n","2  not available              Sohna, Gurgaon, Haryana  12nd   of 14 Floors   \n","3     study room  Sector 61 Gurgaon, Gurgaon, Haryana    2nd   of 4 Floors   \n","4     study room  Sector 92 Gurgaon, Gurgaon, Haryana    5th   of 8 Floors   \n","\n","  facing       agePossession  \\\n","0   West     1 to 5 Year Old   \n","1   West        10+ Year Old   \n","2     NA     0 to 1 Year Old   \n","3     NA              Dec-23   \n","4     NA  Under Construction   \n","\n","                                     nearbyLocations  \\\n","0  ['Chintapurni Mandir', 'State bank ATM', 'Pear...   \n","1  ['Chintapurni Mandir', 'Sheetla Mata Mandir', ...   \n","2  ['Huda City Metro', 'Golf Course extn road', '...   \n","3  ['Sector 55-56 Metro station', 'Bestech Centra...   \n","4  ['Yadav Clinic', 'Bangali Clinic', 'Dr. J. S. ...   \n","\n","                                         description  \\\n","0  So with lift.Maa bhagwati residency is one of ...   \n","1  Property situated on main road, railway statio...   \n","2  This property is 15 km away from badshapur, gu...   \n","3  Near to metro station of sector 56 and opposit...   \n","4  We are the proud owners of this 2 bhk alongwit...   \n","\n","                                      furnishDetails  \\\n","0  ['3 Fan', '4 Light', '1 Wardrobe', 'No AC', 'N...   \n","1  ['3 Wardrobe', '4 Fan', '1 Exhaust Fan', '1 Ge...   \n","2                                                NaN   \n","3                                                NaN   \n","4                                                 []   \n","\n","                                            features  \\\n","0  ['Feng Shui / Vaastu Compliant', 'Security / F...   \n","1  ['Security / Fire Alarm', 'Maintenance Staff',...   \n","2  ['Power Back-up', 'Feng Shui / Vaastu Complian...   \n","3  ['Security / Fire Alarm', 'Private Garden / Te...   \n","4                                                NaN   \n","\n","                                              rating value currency floor_Num  \\\n","0  ['Environment4 out of 5', 'Safety4 out of 5', ...    45      Lac         4   \n","1  ['Environment4 out of 5', 'Safety4 out of 5', ...    50      Lac         1   \n","2  ['Environment4 out of 5', 'Safety4 out of 5', ...    40      Lac        12   \n","3                                                NaN  1.47    Crore         2   \n","4  ['Environment5 out of 5', 'Safety3 out of 5', ...    70      Lac         5   \n","\n","  total_floors  \n","0            4  \n","1            3  \n","2           14  \n","3            4  \n","4            8  "]},"execution_count":30,"metadata":{},"output_type":"execute_result"}],"source":["flats_df.insert(loc=1,column='Property_type',value='flat')\n","flats_df.head()"]},{"cell_type":"code","execution_count":31,"metadata":{"executionInfo":{"elapsed":278,"status":"ok","timestamp":1702336579534,"user":{"displayName":"ruturaj desai","userId":"01241831163993792083"},"user_tz":300},"id":"mzzFSjZsHvBe"},"outputs":[],"source":["## First level of cleaning done\n","flats_df.to_csv('flats_cleanes.csv',index=False)"]}],"metadata":{"colab":{"authorship_tag":"ABX9TyNBxVpxENosqNlt1edL2p9p","provenance":[]},"kernelspec":{"display_name":"Python 3","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.9.13"}},"nbformat":4,"nbformat_minor":0}