LA Github.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "import matplotlib.pyplot as plt\n",
    "import seaborn as sns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>beds</th>\n",
       "      <th>baths</th>\n",
       "      <th>sqft</th>\n",
       "      <th>date</th>\n",
       "      <th>price</th>\n",
       "      <th>city</th>\n",
       "      <th>type</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1005 Benedict Canyon Dr</td>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10379.0</td>\n",
       "      <td>03/08/2014Hilton &amp; HylandFeatured</td>\n",
       "      <td>18000000.0</td>\n",
       "      <td>Beverly Hills</td>\n",
       "      <td>sfh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>10084 Westwanda Dr</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>12/11/2013Coldwell Banker Residential Brokerag...</td>\n",
       "      <td>950000.0</td>\n",
       "      <td>Beverly Hills</td>\n",
       "      <td>sfh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1009 N Beverly Dr</td>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3476.0</td>\n",
       "      <td>03/18/2014Hilton &amp; Hyland</td>\n",
       "      <td>9750000.0</td>\n",
       "      <td>Beverly Hills</td>\n",
       "      <td>sfh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1010 N Rexford Dr</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>7718.0</td>\n",
       "      <td>03/01/2014John Aaroe Group</td>\n",
       "      <td>16500000.0</td>\n",
       "      <td>Beverly Hills</td>\n",
       "      <td>sfh</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>10101 Angelo View Dr</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>03/24/2014Rodeo Realty Inc.</td>\n",
       "      <td>24250000.0</td>\n",
       "      <td>Beverly Hills</td>\n",
       "      <td>sfh</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>3640 Cardiff Ave Apt 201</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>676.0</td>\n",
       "      <td>03/25/2014The Agency</td>\n",
       "      <td>299000.0</td>\n",
       "      <td>Palms</td>\n",
       "      <td>condo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>3701 Glendon Ave Apt 9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1419.0</td>\n",
       "      <td>03/24/2014Coldwell Banker Residential Brokerag...</td>\n",
       "      <td>524000.0</td>\n",
       "      <td>Palms</td>\n",
       "      <td>condo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>9313 National Blvd Apt 101</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>692.0</td>\n",
       "      <td>03/24/2014Rodeo Realty Inc.</td>\n",
       "      <td>349000.0</td>\n",
       "      <td>Palms</td>\n",
       "      <td>condo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>9313 National Blvd Apt 203</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>824.0</td>\n",
       "      <td>03/18/2014Keller WilliamsFeatured</td>\n",
       "      <td>399000.0</td>\n",
       "      <td>Palms</td>\n",
       "      <td>condo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>3300 S Sepulveda Blvd Apt G9</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1224.0</td>\n",
       "      <td>03/24/2014Keller Williams Realty Santa MonicaF...</td>\n",
       "      <td>399000.0</td>\n",
       "      <td>Palms</td>\n",
       "      <td>condo</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>255 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                           address  beds  baths     sqft  \\\n",
       "0          1005 Benedict Canyon Dr   8.0   11.0  10379.0   \n",
       "1               10084 Westwanda Dr   2.0    3.0   2013.0   \n",
       "2                1009 N Beverly Dr   4.0    5.0   3476.0   \n",
       "3                1010 N Rexford Dr   5.0    6.5   7718.0   \n",
       "4             10101 Angelo View Dr   3.0    1.5   4000.0   \n",
       "..                             ...   ...    ...      ...   \n",
       "250       3640 Cardiff Ave Apt 201   1.0    1.0    676.0   \n",
       "251         3701 Glendon Ave Apt 9   2.0    3.0   1419.0   \n",
       "252     9313 National Blvd Apt 101   1.0    1.0    692.0   \n",
       "253     9313 National Blvd Apt 203   2.0    2.0    824.0   \n",
       "254   3300 S Sepulveda Blvd Apt G9   2.0    2.0   1224.0   \n",
       "\n",
       "                                                  date       price  \\\n",
       "0                   03/08/2014Hilton & HylandFeatured   18000000.0   \n",
       "1    12/11/2013Coldwell Banker Residential Brokerag...    950000.0   \n",
       "2                           03/18/2014Hilton & Hyland    9750000.0   \n",
       "3                          03/01/2014John Aaroe Group   16500000.0   \n",
       "4                         03/24/2014Rodeo Realty Inc.   24250000.0   \n",
       "..                                                 ...         ...   \n",
       "250                              03/25/2014The Agency     299000.0   \n",
       "251  03/24/2014Coldwell Banker Residential Brokerag...    524000.0   \n",
       "252                       03/24/2014Rodeo Realty Inc.     349000.0   \n",
       "253                 03/18/2014Keller WilliamsFeatured     399000.0   \n",
       "254  03/24/2014Keller Williams Realty Santa MonicaF...    399000.0   \n",
       "\n",
       "              city   type  \n",
       "0    Beverly Hills    sfh  \n",
       "1    Beverly Hills    sfh  \n",
       "2    Beverly Hills    sfh  \n",
       "3    Beverly Hills    sfh  \n",
       "4    Beverly Hills    sfh  \n",
       "..             ...    ...  \n",
       "250          Palms  condo  \n",
       "251          Palms  condo  \n",
       "252          Palms  condo  \n",
       "253          Palms  condo  \n",
       "254          Palms  condo  \n",
       "\n",
       "[255 rows x 8 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv(\"LArealestate.csv\")\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "#df.isna().sum()/df.shape[0]*100\n",
    "\n",
    "df.dropna(inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"agency\"] = df.date.apply(lambda x : x[10:])\n",
    "df[\"date\"] = df.date.apply(lambda x : x[:10])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"street\"] = df.address.apply(lambda x : \" \".join(x.strip().split(\" \")[1:]))\n",
    "df[\"postal_code\"] = df.address.apply(lambda x : (x.strip().split(\" \")[0]))\n",
    "\n",
    "df.drop(\"address\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "df[\"year\"] = df.date.apply(lambda x : x.split(\"/\")[-1])\n",
    "df[\"month\"] = df.date.apply(lambda x : x.split(\"/\")[1])\n",
    "df[\"day\"] = df.date.apply(lambda x : x.split(\"/\")[0])\n",
    "\n",
    "df.drop(\"date\", axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Alex wins\n"
     ]
    }
   ],
   "source": [
    "print('Alex wins')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Beverly Hills    147\n",
       "Palms             48\n",
       "culver city       30\n",
       "Culver City       28\n",
       "Name: city, dtype: int64"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.city.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.city = df.city.apply(lambda i: 'Culver City' if i=='culver city' else i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Beverly Hills    147\n",
       "Culver City       58\n",
       "Palms             48\n",
       "Name: city, dtype: int64"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.city.value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "city_dict= {'Beverly Hills': 0.0, 'Culver City': 1.0, 'Palms': 2.0}"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.replace({'city': city_dict}, inplace= True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>beds</th>\n",
       "      <th>baths</th>\n",
       "      <th>sqft</th>\n",
       "      <th>price</th>\n",
       "      <th>city</th>\n",
       "      <th>type</th>\n",
       "      <th>agency</th>\n",
       "      <th>street</th>\n",
       "      <th>postal_code</th>\n",
       "      <th>year</th>\n",
       "      <th>month</th>\n",
       "      <th>day</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>8.0</td>\n",
       "      <td>11.0</td>\n",
       "      <td>10379.0</td>\n",
       "      <td>18000000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>sfh</td>\n",
       "      <td>Hilton &amp; HylandFeatured</td>\n",
       "      <td>Benedict Canyon Dr</td>\n",
       "      <td>1005</td>\n",
       "      <td>2014</td>\n",
       "      <td>08</td>\n",
       "      <td>03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>2013.0</td>\n",
       "      <td>950000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>sfh</td>\n",
       "      <td>Coldwell Banker Residential Brokerage - Sherma...</td>\n",
       "      <td>Westwanda Dr</td>\n",
       "      <td>10084</td>\n",
       "      <td>2013</td>\n",
       "      <td>11</td>\n",
       "      <td>12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>3476.0</td>\n",
       "      <td>9750000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>sfh</td>\n",
       "      <td>Hilton &amp; Hyland</td>\n",
       "      <td>N Beverly Dr</td>\n",
       "      <td>1009</td>\n",
       "      <td>2014</td>\n",
       "      <td>18</td>\n",
       "      <td>03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.0</td>\n",
       "      <td>6.5</td>\n",
       "      <td>7718.0</td>\n",
       "      <td>16500000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>sfh</td>\n",
       "      <td>John Aaroe Group</td>\n",
       "      <td>N Rexford Dr</td>\n",
       "      <td>1010</td>\n",
       "      <td>2014</td>\n",
       "      <td>01</td>\n",
       "      <td>03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3.0</td>\n",
       "      <td>1.5</td>\n",
       "      <td>4000.0</td>\n",
       "      <td>24250000.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>sfh</td>\n",
       "      <td>Rodeo Realty Inc.</td>\n",
       "      <td>Angelo View Dr</td>\n",
       "      <td>10101</td>\n",
       "      <td>2014</td>\n",
       "      <td>24</td>\n",
       "      <td>03</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>676.0</td>\n",
       "      <td>299000.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>condo</td>\n",
       "      <td>The Agency</td>\n",
       "      <td>Cardiff Ave Apt 201</td>\n",
       "      <td>3640</td>\n",
       "      <td>2014</td>\n",
       "      <td>25</td>\n",
       "      <td>03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1419.0</td>\n",
       "      <td>524000.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>condo</td>\n",
       "      <td>Coldwell Banker Residential Brokerage - Santa ...</td>\n",
       "      <td>Glendon Ave Apt 9</td>\n",
       "      <td>3701</td>\n",
       "      <td>2014</td>\n",
       "      <td>24</td>\n",
       "      <td>03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>692.0</td>\n",
       "      <td>349000.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>condo</td>\n",
       "      <td>Rodeo Realty Inc.</td>\n",
       "      <td>National Blvd Apt 101</td>\n",
       "      <td>9313</td>\n",
       "      <td>2014</td>\n",
       "      <td>24</td>\n",
       "      <td>03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>824.0</td>\n",
       "      <td>399000.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>condo</td>\n",
       "      <td>Keller WilliamsFeatured</td>\n",
       "      <td>National Blvd Apt 203</td>\n",
       "      <td>9313</td>\n",
       "      <td>2014</td>\n",
       "      <td>18</td>\n",
       "      <td>03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1224.0</td>\n",
       "      <td>399000.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>condo</td>\n",
       "      <td>Keller Williams Realty Santa MonicaFeatured</td>\n",
       "      <td>S Sepulveda Blvd Apt G9</td>\n",
       "      <td>3300</td>\n",
       "      <td>2014</td>\n",
       "      <td>24</td>\n",
       "      <td>03</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>253 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     beds  baths     sqft       price  city   type  \\\n",
       "0     8.0   11.0  10379.0  18000000.0   0.0    sfh   \n",
       "1     2.0    3.0   2013.0    950000.0   0.0    sfh   \n",
       "2     4.0    5.0   3476.0   9750000.0   0.0    sfh   \n",
       "3     5.0    6.5   7718.0  16500000.0   0.0    sfh   \n",
       "4     3.0    1.5   4000.0  24250000.0   0.0    sfh   \n",
       "..    ...    ...      ...         ...   ...    ...   \n",
       "250   1.0    1.0    676.0    299000.0   2.0  condo   \n",
       "251   2.0    3.0   1419.0    524000.0   2.0  condo   \n",
       "252   1.0    1.0    692.0    349000.0   2.0  condo   \n",
       "253   2.0    2.0    824.0    399000.0   2.0  condo   \n",
       "254   2.0    2.0   1224.0    399000.0   2.0  condo   \n",
       "\n",
       "                                                agency  \\\n",
       "0                             Hilton & HylandFeatured    \n",
       "1    Coldwell Banker Residential Brokerage - Sherma...   \n",
       "2                                     Hilton & Hyland    \n",
       "3                                    John Aaroe Group    \n",
       "4                                   Rodeo Realty Inc.    \n",
       "..                                                 ...   \n",
       "250                                        The Agency    \n",
       "251  Coldwell Banker Residential Brokerage - Santa ...   \n",
       "252                                 Rodeo Realty Inc.    \n",
       "253                           Keller WilliamsFeatured    \n",
       "254       Keller Williams Realty Santa MonicaFeatured    \n",
       "\n",
       "                      street postal_code  year month day  \n",
       "0         Benedict Canyon Dr        1005  2014    08  03  \n",
       "1               Westwanda Dr       10084  2013    11  12  \n",
       "2               N Beverly Dr        1009  2014    18  03  \n",
       "3               N Rexford Dr        1010  2014    01  03  \n",
       "4             Angelo View Dr       10101  2014    24  03  \n",
       "..                       ...         ...   ...   ...  ..  \n",
       "250      Cardiff Ave Apt 201        3640  2014    25  03  \n",
       "251        Glendon Ave Apt 9        3701  2014    24  03  \n",
       "252    National Blvd Apt 101        9313  2014    24  03  \n",
       "253    National Blvd Apt 203        9313  2014    18  03  \n",
       "254  S Sepulveda Blvd Apt G9        3300  2014    24  03  \n",
       "\n",
       "[253 rows x 12 columns]"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}