Melbourne.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "53d7c0af-7f7e-4384-9b5c-9d0d0f106e88",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import re"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "e394f2fb-ce10-4d53-8ef7-74894b04b4cc",
   "metadata": {},
   "outputs": [],
   "source": [
    "df = pd.read_csv(\"DataSet/house.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "3b17cf68-c3af-4a62-8404-ebdd820aee95",
   "metadata": {},
   "outputs": [],
   "source": [
    "df1 = df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "d2a3d5eb-80cb-4290-8acf-6fac52c10d2f",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>49 Lithgow St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1490000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>59A Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1220000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>119B Yarra St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1420000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Nelson</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aberfeldie</td>\n",
       "      <td>68 Vida St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1515000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3040</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1543</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Airport West</td>\n",
       "      <td>1/26 Highridge Cr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>715000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Nelson</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3042</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>3464</td>\n",
       "      <td>10.4</td>\n",
       "      <td>Moonee Valley City Council</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63017</th>\n",
       "      <td>Preston</td>\n",
       "      <td>229 Murray Rd</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>808000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>RW</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3072</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>14577</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Darebin City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63018</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>3 Carr Pl</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>566000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63019</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>9 Parker Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63020</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>5 Parkinson Wy</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63021</th>\n",
       "      <td>Thomastown</td>\n",
       "      <td>3/1 Travers St</td>\n",
       "      <td>3</td>\n",
       "      <td>u</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PI</td>\n",
       "      <td>Barry</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3074</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>7955</td>\n",
       "      <td>15.3</td>\n",
       "      <td>Whittlesea City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>27950 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Suburb            Address  Rooms Type      Price Method  \\\n",
       "0         Abbotsford      49 Lithgow St      3    h  1490000.0      S   \n",
       "1         Abbotsford      59A Turner St      3    h  1220000.0      S   \n",
       "2         Abbotsford      119B Yarra St      3    h  1420000.0      S   \n",
       "3         Aberfeldie         68 Vida St      3    h  1515000.0      S   \n",
       "7       Airport West  1/26 Highridge Cr      3    h   715000.0     SP   \n",
       "...              ...                ...    ...  ...        ...    ...   \n",
       "63017        Preston      229 Murray Rd      3    h   808000.0      S   \n",
       "63018  Roxburgh Park          3 Carr Pl      3    h   566000.0      S   \n",
       "63019  Roxburgh Park        9 Parker Ct      3    h   500000.0      S   \n",
       "63020  Roxburgh Park     5 Parkinson Wy      3    h   545000.0      S   \n",
       "63021     Thomastown     3/1 Travers St      3    u        NaN     PI   \n",
       "\n",
       "        SellerG        Date  Postcode             Regionname  Propertycount  \\\n",
       "0        Jellis   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "1      Marshall   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "2        Nelson   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "3         Barry   1/04/2017      3040   Western Metropolitan           1543   \n",
       "7        Nelson   1/04/2017      3042   Western Metropolitan           3464   \n",
       "...         ...         ...       ...                    ...            ...   \n",
       "63017        RW  31/03/2018      3072  Northern Metropolitan          14577   \n",
       "63018     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63019     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63020     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63021     Barry  31/03/2018      3074  Northern Metropolitan           7955   \n",
       "\n",
       "       Distance                 CouncilArea  \n",
       "0           3.0          Yarra City Council  \n",
       "1           3.0          Yarra City Council  \n",
       "2           3.0          Yarra City Council  \n",
       "3           7.5  Moonee Valley City Council  \n",
       "7          10.4  Moonee Valley City Council  \n",
       "...         ...                         ...  \n",
       "63017       8.4        Darebin City Council  \n",
       "63018      20.6           Hume City Council  \n",
       "63019      20.6           Hume City Council  \n",
       "63020      20.6           Hume City Council  \n",
       "63021      15.3     Whittlesea City Council  \n",
       "\n",
       "[27950 rows x 13 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter1 = df.loc[df[\"Rooms\"] == 3]\n",
    "filter1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "4fb64eb5-3a64-4c0b-bca9-9632a9dfd894",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>49 Lithgow St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1490000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>59A Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1220000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>119B Yarra St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1420000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Nelson</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aberfeldie</td>\n",
       "      <td>68 Vida St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1515000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3040</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1543</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Airport West</td>\n",
       "      <td>1/26 Highridge Cr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>715000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Nelson</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3042</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>3464</td>\n",
       "      <td>10.4</td>\n",
       "      <td>Moonee Valley City Council</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63011</th>\n",
       "      <td>Doveton</td>\n",
       "      <td>12 Scarlet Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>595000.0</td>\n",
       "      <td>PI</td>\n",
       "      <td>REMAX</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3177</td>\n",
       "      <td>South-Eastern Metropolitan</td>\n",
       "      <td>3533</td>\n",
       "      <td>28.8</td>\n",
       "      <td>Casey City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63017</th>\n",
       "      <td>Preston</td>\n",
       "      <td>229 Murray Rd</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>808000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>RW</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3072</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>14577</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Darebin City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63018</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>3 Carr Pl</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>566000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63019</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>9 Parker Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63020</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>5 Parkinson Wy</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>22017 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Suburb            Address  Rooms Type      Price Method  \\\n",
       "0         Abbotsford      49 Lithgow St      3    h  1490000.0      S   \n",
       "1         Abbotsford      59A Turner St      3    h  1220000.0      S   \n",
       "2         Abbotsford      119B Yarra St      3    h  1420000.0      S   \n",
       "3         Aberfeldie         68 Vida St      3    h  1515000.0      S   \n",
       "7       Airport West  1/26 Highridge Cr      3    h   715000.0     SP   \n",
       "...              ...                ...    ...  ...        ...    ...   \n",
       "63011        Doveton      12 Scarlet Dr      3    h   595000.0     PI   \n",
       "63017        Preston      229 Murray Rd      3    h   808000.0      S   \n",
       "63018  Roxburgh Park          3 Carr Pl      3    h   566000.0      S   \n",
       "63019  Roxburgh Park        9 Parker Ct      3    h   500000.0      S   \n",
       "63020  Roxburgh Park     5 Parkinson Wy      3    h   545000.0      S   \n",
       "\n",
       "        SellerG        Date  Postcode                  Regionname  \\\n",
       "0        Jellis   1/04/2017      3067       Northern Metropolitan   \n",
       "1      Marshall   1/04/2017      3067       Northern Metropolitan   \n",
       "2        Nelson   1/04/2017      3067       Northern Metropolitan   \n",
       "3         Barry   1/04/2017      3040        Western Metropolitan   \n",
       "7        Nelson   1/04/2017      3042        Western Metropolitan   \n",
       "...         ...         ...       ...                         ...   \n",
       "63011     REMAX  31/03/2018      3177  South-Eastern Metropolitan   \n",
       "63017        RW  31/03/2018      3072       Northern Metropolitan   \n",
       "63018     Raine  31/03/2018      3064       Northern Metropolitan   \n",
       "63019     Raine  31/03/2018      3064       Northern Metropolitan   \n",
       "63020     Raine  31/03/2018      3064       Northern Metropolitan   \n",
       "\n",
       "       Propertycount  Distance                 CouncilArea  \n",
       "0               4019       3.0          Yarra City Council  \n",
       "1               4019       3.0          Yarra City Council  \n",
       "2               4019       3.0          Yarra City Council  \n",
       "3               1543       7.5  Moonee Valley City Council  \n",
       "7               3464      10.4  Moonee Valley City Council  \n",
       "...              ...       ...                         ...  \n",
       "63011           3533      28.8          Casey City Council  \n",
       "63017          14577       8.4        Darebin City Council  \n",
       "63018           5833      20.6           Hume City Council  \n",
       "63019           5833      20.6           Hume City Council  \n",
       "63020           5833      20.6           Hume City Council  \n",
       "\n",
       "[22017 rows x 13 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter1 = df.loc[(df[\"Rooms\"] == 3) & (df['Type'] == 'h')]\n",
    "filter1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "064987fe-f748-4400-af14-f724e6f0abd7",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>Broadmeadows</td>\n",
       "      <td>145 Graham St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>457000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>YPA</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3047</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4294</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>Craigieburn</td>\n",
       "      <td>7A Amstel St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>356500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jason</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>15510</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>Cranbourne North</td>\n",
       "      <td>22 Horsfield St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>475000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>LJ</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3977</td>\n",
       "      <td>South-Eastern Metropolitan</td>\n",
       "      <td>6464</td>\n",
       "      <td>34.7</td>\n",
       "      <td>Casey City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>Dallas</td>\n",
       "      <td>31 Phillip St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>455500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3047</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>2246</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>Delahey</td>\n",
       "      <td>1/25 Yeats Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>335000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Ray</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3037</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>2898</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Brimbank City Council</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62977</th>\n",
       "      <td>Werribee</td>\n",
       "      <td>4 Mekong Cl</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>420000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>30/12/2017</td>\n",
       "      <td>3030</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>16166</td>\n",
       "      <td>14.7</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62997</th>\n",
       "      <td>Wyndham Vale</td>\n",
       "      <td>5 Chatswood Pl</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>410000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>hockingstuart</td>\n",
       "      <td>30/12/2017</td>\n",
       "      <td>3024</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>5262</td>\n",
       "      <td>27.2</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62998</th>\n",
       "      <td>Wyndham Vale</td>\n",
       "      <td>21 Mermaid Cr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>400000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Barry</td>\n",
       "      <td>30/12/2017</td>\n",
       "      <td>3024</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>5262</td>\n",
       "      <td>27.2</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63000</th>\n",
       "      <td>Wyndham Vale</td>\n",
       "      <td>8 Opala Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>416000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Sweeney</td>\n",
       "      <td>30/12/2017</td>\n",
       "      <td>3024</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>5262</td>\n",
       "      <td>27.2</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63019</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>9 Parker Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1581 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Suburb          Address  Rooms Type     Price Method  \\\n",
       "92         Broadmeadows    145 Graham St      3    h  457000.0      S   \n",
       "170         Craigieburn     7A Amstel St      3    h  356500.0      S   \n",
       "177    Cranbourne North  22 Horsfield St      3    h  475000.0      S   \n",
       "183              Dallas    31 Phillip St      3    h  455500.0      S   \n",
       "192             Delahey    1/25 Yeats Dr      3    h  335000.0      S   \n",
       "...                 ...              ...    ...  ...       ...    ...   \n",
       "62977          Werribee      4 Mekong Cl      3    h  420000.0      S   \n",
       "62997      Wyndham Vale   5 Chatswood Pl      3    h  410000.0      S   \n",
       "62998      Wyndham Vale    21 Mermaid Cr      3    h  400000.0     SP   \n",
       "63000      Wyndham Vale       8 Opala Ct      3    h  416000.0      S   \n",
       "63019     Roxburgh Park      9 Parker Ct      3    h  500000.0      S   \n",
       "\n",
       "             SellerG        Date  Postcode                  Regionname  \\\n",
       "92               YPA   1/04/2017      3047       Northern Metropolitan   \n",
       "170            Jason   1/04/2017      3064       Northern Metropolitan   \n",
       "177               LJ   1/04/2017      3977  South-Eastern Metropolitan   \n",
       "183            Barry   1/04/2017      3047       Northern Metropolitan   \n",
       "192              Ray   1/04/2017      3037        Western Metropolitan   \n",
       "...              ...         ...       ...                         ...   \n",
       "62977          Barry  30/12/2017      3030        Western Metropolitan   \n",
       "62997  hockingstuart  30/12/2017      3024        Western Metropolitan   \n",
       "62998          Barry  30/12/2017      3024        Western Metropolitan   \n",
       "63000        Sweeney  30/12/2017      3024        Western Metropolitan   \n",
       "63019          Raine  31/03/2018      3064       Northern Metropolitan   \n",
       "\n",
       "       Propertycount  Distance            CouncilArea  \n",
       "92              4294      14.0      Hume City Council  \n",
       "170            15510      20.6      Hume City Council  \n",
       "177             6464      34.7     Casey City Council  \n",
       "183             2246      14.0      Hume City Council  \n",
       "192             2898      18.0  Brimbank City Council  \n",
       "...              ...       ...                    ...  \n",
       "62977          16166      14.7   Wyndham City Council  \n",
       "62997           5262      27.2   Wyndham City Council  \n",
       "62998           5262      27.2   Wyndham City Council  \n",
       "63000           5262      27.2   Wyndham City Council  \n",
       "63019           5833      20.6      Hume City Council  \n",
       "\n",
       "[1581 rows x 13 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter1 = df.loc[(df[\"Rooms\"] == 3) & (df['Type'] == 'h') & (df['Price'] <= 500000)]\n",
    "filter1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "986b7047-c942-4f99-a45e-f2c57e44085b",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>59A Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1220000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2859</th>\n",
       "      <td>Malvern East</td>\n",
       "      <td>24 Turner St</td>\n",
       "      <td>6</td>\n",
       "      <td>h</td>\n",
       "      <td>4700000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>RT</td>\n",
       "      <td>3/03/2018</td>\n",
       "      <td>3145</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>8801</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Stonnington City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4723</th>\n",
       "      <td>Highett</td>\n",
       "      <td>48 Turner Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>832000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Buxton</td>\n",
       "      <td>3/09/2017</td>\n",
       "      <td>3190</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4794</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Bayside City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4987</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>85 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>1480000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Biggin</td>\n",
       "      <td>3/12/2016</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7501</th>\n",
       "      <td>Highett</td>\n",
       "      <td>28 Turner Rd</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PI</td>\n",
       "      <td>Nick</td>\n",
       "      <td>4/08/2018</td>\n",
       "      <td>3190</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4794</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Bayside City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9647</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>53 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>Biggin</td>\n",
       "      <td>6/08/2016</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9648</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>99 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>Collins</td>\n",
       "      <td>6/08/2016</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14012</th>\n",
       "      <td>Berwick</td>\n",
       "      <td>4 Turner St</td>\n",
       "      <td>5</td>\n",
       "      <td>h</td>\n",
       "      <td>536000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>O'Brien</td>\n",
       "      <td>8/04/2017</td>\n",
       "      <td>3806</td>\n",
       "      <td>Eastern Victoria</td>\n",
       "      <td>17093</td>\n",
       "      <td>35.2</td>\n",
       "      <td>Casey City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14745</th>\n",
       "      <td>Westmeadows</td>\n",
       "      <td>16 Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SN</td>\n",
       "      <td>Stockdale</td>\n",
       "      <td>8/04/2017</td>\n",
       "      <td>3049</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>2474</td>\n",
       "      <td>16.5</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18960</th>\n",
       "      <td>Moonee Ponds</td>\n",
       "      <td>3/16 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>550000.0</td>\n",
       "      <td>VB</td>\n",
       "      <td>Woodards</td>\n",
       "      <td>10/09/2016</td>\n",
       "      <td>3039</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>6232</td>\n",
       "      <td>6.2</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19148</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>106/119 Turner St</td>\n",
       "      <td>1</td>\n",
       "      <td>u</td>\n",
       "      <td>481000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Purplebricks</td>\n",
       "      <td>10/12/2016</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19609</th>\n",
       "      <td>Highett</td>\n",
       "      <td>2/20 Turner Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>730000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Buxton</td>\n",
       "      <td>10/12/2016</td>\n",
       "      <td>3190</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4794</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Bayside City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20043</th>\n",
       "      <td>Westmeadows</td>\n",
       "      <td>14 Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>586000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Stockdale</td>\n",
       "      <td>10/12/2016</td>\n",
       "      <td>3049</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>2474</td>\n",
       "      <td>16.5</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20717</th>\n",
       "      <td>Langwarrin</td>\n",
       "      <td>49 Turner Rd</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PI</td>\n",
       "      <td>UFirst</td>\n",
       "      <td>11/08/2018</td>\n",
       "      <td>3910</td>\n",
       "      <td>Eastern Victoria</td>\n",
       "      <td>8743</td>\n",
       "      <td>41.0</td>\n",
       "      <td>Frankston City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25081</th>\n",
       "      <td>Moonee Ponds</td>\n",
       "      <td>15/3 Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>t</td>\n",
       "      <td>732000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Nelson</td>\n",
       "      <td>13/10/2018</td>\n",
       "      <td>3039</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>6232</td>\n",
       "      <td>6.2</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26305</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>2 Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1620000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Biggin</td>\n",
       "      <td>14/07/2018</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29650</th>\n",
       "      <td>Briar Hill</td>\n",
       "      <td>10 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>812000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Darren</td>\n",
       "      <td>16/06/2018</td>\n",
       "      <td>3088</td>\n",
       "      <td>Eastern Metropolitan</td>\n",
       "      <td>1390</td>\n",
       "      <td>16.1</td>\n",
       "      <td>Banyule City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36217</th>\n",
       "      <td>Westmeadows</td>\n",
       "      <td>25 Turner St</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>685000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jason</td>\n",
       "      <td>18/06/2016</td>\n",
       "      <td>3049</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>2474</td>\n",
       "      <td>16.5</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39873</th>\n",
       "      <td>Highett</td>\n",
       "      <td>3/6 Turner Rd</td>\n",
       "      <td>3</td>\n",
       "      <td>u</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PI</td>\n",
       "      <td>Buxton</td>\n",
       "      <td>20/05/2017</td>\n",
       "      <td>3190</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4794</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Bayside City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41985</th>\n",
       "      <td>Highett</td>\n",
       "      <td>1/6 Turner Rd</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>921000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Buxton</td>\n",
       "      <td>22/04/2017</td>\n",
       "      <td>3190</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4794</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Bayside City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42537</th>\n",
       "      <td>Malvern East</td>\n",
       "      <td>16 Turner St</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>22/05/2016</td>\n",
       "      <td>3145</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>8801</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Stonnington City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45597</th>\n",
       "      <td>Highett</td>\n",
       "      <td>3/15 Turner Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>770000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>McGrath</td>\n",
       "      <td>23/09/2017</td>\n",
       "      <td>3190</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4794</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Bayside City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47333</th>\n",
       "      <td>Malvern East</td>\n",
       "      <td>27 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>1040000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>24/02/2018</td>\n",
       "      <td>3145</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>8801</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Stonnington City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47843</th>\n",
       "      <td>Berwick</td>\n",
       "      <td>6 Turner St</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>1400000.0</td>\n",
       "      <td>VB</td>\n",
       "      <td>Peake</td>\n",
       "      <td>24/03/2018</td>\n",
       "      <td>3806</td>\n",
       "      <td>Eastern Victoria</td>\n",
       "      <td>17093</td>\n",
       "      <td>35.2</td>\n",
       "      <td>Casey City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49480</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>31 Turner St</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>1542000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Collins</td>\n",
       "      <td>24/09/2016</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49890</th>\n",
       "      <td>Moonee Ponds</td>\n",
       "      <td>4/6 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>600000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Woodards</td>\n",
       "      <td>24/09/2016</td>\n",
       "      <td>3039</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>6232</td>\n",
       "      <td>6.2</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50254</th>\n",
       "      <td>Briar Hill</td>\n",
       "      <td>7 Turner St</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>1100000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>25/02/2017</td>\n",
       "      <td>3088</td>\n",
       "      <td>Eastern Metropolitan</td>\n",
       "      <td>1390</td>\n",
       "      <td>16.1</td>\n",
       "      <td>Banyule City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51364</th>\n",
       "      <td>Malvern East</td>\n",
       "      <td>29 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>1010000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>25/08/2018</td>\n",
       "      <td>3145</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>8801</td>\n",
       "      <td>8.4</td>\n",
       "      <td>Stonnington City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53753</th>\n",
       "      <td>Highett</td>\n",
       "      <td>2/4 Turner Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>680500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Ray</td>\n",
       "      <td>26/08/2017</td>\n",
       "      <td>3190</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4794</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Bayside City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57940</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>210/125 Turner St</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>760000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Nelson</td>\n",
       "      <td>28/07/2018</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57978</th>\n",
       "      <td>Berwick</td>\n",
       "      <td>5 Turner St</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>940000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Ray</td>\n",
       "      <td>28/07/2018</td>\n",
       "      <td>3806</td>\n",
       "      <td>Eastern Victoria</td>\n",
       "      <td>17093</td>\n",
       "      <td>35.2</td>\n",
       "      <td>Casey City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58707</th>\n",
       "      <td>Highett</td>\n",
       "      <td>22 Turner Rd</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1150000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Buxton</td>\n",
       "      <td>28/08/2016</td>\n",
       "      <td>3190</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4794</td>\n",
       "      <td>16.0</td>\n",
       "      <td>Bayside City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             Suburb            Address  Rooms Type      Price Method  \\\n",
       "1        Abbotsford      59A Turner St      3    h  1220000.0      S   \n",
       "2859   Malvern East       24 Turner St      6    h  4700000.0      S   \n",
       "4723        Highett       48 Turner Rd      2    h   832000.0      S   \n",
       "4987     Abbotsford       85 Turner St      2    h  1480000.0      S   \n",
       "7501        Highett       28 Turner Rd      3    h        NaN     PI   \n",
       "9647     Abbotsford       53 Turner St      2    h        NaN      S   \n",
       "9648     Abbotsford       99 Turner St      2    h        NaN      S   \n",
       "14012       Berwick        4 Turner St      5    h   536000.0      S   \n",
       "14745   Westmeadows       16 Turner St      3    h        NaN     SN   \n",
       "18960  Moonee Ponds     3/16 Turner St      2    u   550000.0     VB   \n",
       "19148    Abbotsford  106/119 Turner St      1    u   481000.0     SP   \n",
       "19609       Highett     2/20 Turner Rd      2    u   730000.0     SP   \n",
       "20043   Westmeadows       14 Turner St      3    h   586000.0      S   \n",
       "20717    Langwarrin       49 Turner Rd      4    h        NaN     PI   \n",
       "25081  Moonee Ponds     15/3 Turner St      3    t   732000.0      S   \n",
       "26305    Abbotsford        2 Turner St      3    h  1620000.0      S   \n",
       "29650    Briar Hill       10 Turner St      2    h   812000.0      S   \n",
       "36217   Westmeadows       25 Turner St      4    h   685000.0      S   \n",
       "39873       Highett      3/6 Turner Rd      3    u        NaN     PI   \n",
       "41985       Highett      1/6 Turner Rd      4    h   921000.0      S   \n",
       "42537  Malvern East       16 Turner St      4    h        NaN      S   \n",
       "45597       Highett     3/15 Turner Rd      2    u   770000.0      S   \n",
       "47333  Malvern East       27 Turner St      2    h  1040000.0      S   \n",
       "47843       Berwick        6 Turner St      4    h  1400000.0     VB   \n",
       "49480    Abbotsford       31 Turner St      4    h  1542000.0      S   \n",
       "49890  Moonee Ponds      4/6 Turner St      2    u   600000.0      S   \n",
       "50254    Briar Hill        7 Turner St      4    h  1100000.0      S   \n",
       "51364  Malvern East       29 Turner St      2    h  1010000.0     SP   \n",
       "53753       Highett      2/4 Turner Rd      2    u   680500.0      S   \n",
       "57940    Abbotsford  210/125 Turner St      2    u   760000.0      S   \n",
       "57978       Berwick        5 Turner St      4    h   940000.0     SP   \n",
       "58707       Highett       22 Turner Rd      3    h  1150000.0     SP   \n",
       "\n",
       "            SellerG        Date  Postcode             Regionname  \\\n",
       "1          Marshall   1/04/2017      3067  Northern Metropolitan   \n",
       "2859             RT   3/03/2018      3145  Southern Metropolitan   \n",
       "4723         Buxton   3/09/2017      3190  Southern Metropolitan   \n",
       "4987         Biggin   3/12/2016      3067  Northern Metropolitan   \n",
       "7501           Nick   4/08/2018      3190  Southern Metropolitan   \n",
       "9647         Biggin   6/08/2016      3067  Northern Metropolitan   \n",
       "9648        Collins   6/08/2016      3067  Northern Metropolitan   \n",
       "14012       O'Brien   8/04/2017      3806       Eastern Victoria   \n",
       "14745     Stockdale   8/04/2017      3049  Northern Metropolitan   \n",
       "18960      Woodards  10/09/2016      3039   Western Metropolitan   \n",
       "19148  Purplebricks  10/12/2016      3067  Northern Metropolitan   \n",
       "19609        Buxton  10/12/2016      3190  Southern Metropolitan   \n",
       "20043     Stockdale  10/12/2016      3049  Northern Metropolitan   \n",
       "20717        UFirst  11/08/2018      3910       Eastern Victoria   \n",
       "25081        Nelson  13/10/2018      3039   Western Metropolitan   \n",
       "26305        Biggin  14/07/2018      3067  Northern Metropolitan   \n",
       "29650        Darren  16/06/2018      3088   Eastern Metropolitan   \n",
       "36217         Jason  18/06/2016      3049  Northern Metropolitan   \n",
       "39873        Buxton  20/05/2017      3190  Southern Metropolitan   \n",
       "41985        Buxton  22/04/2017      3190  Southern Metropolitan   \n",
       "42537      Marshall  22/05/2016      3145  Southern Metropolitan   \n",
       "45597       McGrath  23/09/2017      3190  Southern Metropolitan   \n",
       "47333        Jellis  24/02/2018      3145  Southern Metropolitan   \n",
       "47843         Peake  24/03/2018      3806       Eastern Victoria   \n",
       "49480       Collins  24/09/2016      3067  Northern Metropolitan   \n",
       "49890      Woodards  24/09/2016      3039   Western Metropolitan   \n",
       "50254        Jellis  25/02/2017      3088   Eastern Metropolitan   \n",
       "51364        Jellis  25/08/2018      3145  Southern Metropolitan   \n",
       "53753           Ray  26/08/2017      3190  Southern Metropolitan   \n",
       "57940        Nelson  28/07/2018      3067  Northern Metropolitan   \n",
       "57978           Ray  28/07/2018      3806       Eastern Victoria   \n",
       "58707        Buxton  28/08/2016      3190  Southern Metropolitan   \n",
       "\n",
       "       Propertycount  Distance                 CouncilArea  \n",
       "1               4019       3.0          Yarra City Council  \n",
       "2859            8801       8.4    Stonnington City Council  \n",
       "4723            4794      16.0        Bayside City Council  \n",
       "4987            4019       3.0          Yarra City Council  \n",
       "7501            4794      16.0        Bayside City Council  \n",
       "9647            4019       3.0          Yarra City Council  \n",
       "9648            4019       3.0          Yarra City Council  \n",
       "14012          17093      35.2          Casey City Council  \n",
       "14745           2474      16.5           Hume City Council  \n",
       "18960           6232       6.2  Moonee Valley City Council  \n",
       "19148           4019       3.0          Yarra City Council  \n",
       "19609           4794      16.0        Bayside City Council  \n",
       "20043           2474      16.5           Hume City Council  \n",
       "20717           8743      41.0      Frankston City Council  \n",
       "25081           6232       6.2  Moonee Valley City Council  \n",
       "26305           4019       3.0          Yarra City Council  \n",
       "29650           1390      16.1        Banyule City Council  \n",
       "36217           2474      16.5           Hume City Council  \n",
       "39873           4794      16.0        Bayside City Council  \n",
       "41985           4794      16.0        Bayside City Council  \n",
       "42537           8801       8.4    Stonnington City Council  \n",
       "45597           4794      16.0        Bayside City Council  \n",
       "47333           8801       8.4    Stonnington City Council  \n",
       "47843          17093      35.2          Casey City Council  \n",
       "49480           4019       3.0          Yarra City Council  \n",
       "49890           6232       6.2  Moonee Valley City Council  \n",
       "50254           1390      16.1        Banyule City Council  \n",
       "51364           8801       8.4    Stonnington City Council  \n",
       "53753           4794      16.0        Bayside City Council  \n",
       "57940           4019       3.0          Yarra City Council  \n",
       "57978          17093      35.2          Casey City Council  \n",
       "58707           4794      16.0        Bayside City Council  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter2 = df.loc[df['Address'].str.contains('turner St|turner Rd', flags=re.I)]\n",
    "filter2"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "ff9c92bd-35b7-4f3b-807a-2036c3e20504",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2220</th>\n",
       "      <td>Wallan</td>\n",
       "      <td>59 William St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>424000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Ruralco</td>\n",
       "      <td>2/06/2018</td>\n",
       "      <td>3756</td>\n",
       "      <td>Northern Victoria</td>\n",
       "      <td>3988</td>\n",
       "      <td>44.2</td>\n",
       "      <td>Mitchell Shire Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9096</th>\n",
       "      <td>Sunbury</td>\n",
       "      <td>59 Davenport Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>499500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>6/01/2018</td>\n",
       "      <td>3429</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>14092</td>\n",
       "      <td>31.7</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13089</th>\n",
       "      <td>Sunshine West</td>\n",
       "      <td>59 Felstead Av</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>465000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Bells</td>\n",
       "      <td>7/11/2016</td>\n",
       "      <td>3020</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>6763</td>\n",
       "      <td>10.5</td>\n",
       "      <td>Brimbank City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13840</th>\n",
       "      <td>Sunbury</td>\n",
       "      <td>59 Davenport Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>499500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>8/01/2018</td>\n",
       "      <td>3429</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>14092</td>\n",
       "      <td>31.7</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19616</th>\n",
       "      <td>Hoppers Crossing</td>\n",
       "      <td>59 Aitken Av</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>421600.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Barry</td>\n",
       "      <td>10/12/2016</td>\n",
       "      <td>3029</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>13830</td>\n",
       "      <td>18.4</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19623</th>\n",
       "      <td>Hoppers Crossing</td>\n",
       "      <td>59 Mossfiel Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>453000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Triwest</td>\n",
       "      <td>10/12/2016</td>\n",
       "      <td>3029</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>13830</td>\n",
       "      <td>18.4</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30441</th>\n",
       "      <td>Thomastown</td>\n",
       "      <td>59 Darebin Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>478500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>hockingstuart</td>\n",
       "      <td>16/07/2016</td>\n",
       "      <td>3074</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>7955</td>\n",
       "      <td>15.3</td>\n",
       "      <td>Whittlesea City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31889</th>\n",
       "      <td>Sunbury</td>\n",
       "      <td>59 Davenport Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>499500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>16/12/2017</td>\n",
       "      <td>3429</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>14092</td>\n",
       "      <td>31.7</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46682</th>\n",
       "      <td>Sunbury</td>\n",
       "      <td>59 Davenport Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>499500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>23/12/2017</td>\n",
       "      <td>3429</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>14092</td>\n",
       "      <td>31.7</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62903</th>\n",
       "      <td>Sunbury</td>\n",
       "      <td>59 Davenport Dr</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>499500.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>30/12/2017</td>\n",
       "      <td>3429</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>14092</td>\n",
       "      <td>31.7</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Suburb          Address  Rooms Type     Price Method  \\\n",
       "2220             Wallan    59 William St      3    h  424000.0      S   \n",
       "9096            Sunbury  59 Davenport Dr      3    h  499500.0      S   \n",
       "13089     Sunshine West   59 Felstead Av      3    h  465000.0      S   \n",
       "13840           Sunbury  59 Davenport Dr      3    h  499500.0      S   \n",
       "19616  Hoppers Crossing     59 Aitken Av      3    h  421600.0     SP   \n",
       "19623  Hoppers Crossing   59 Mossfiel Dr      3    h  453000.0      S   \n",
       "30441        Thomastown    59 Darebin Dr      3    h  478500.0      S   \n",
       "31889           Sunbury  59 Davenport Dr      3    h  499500.0      S   \n",
       "46682           Sunbury  59 Davenport Dr      3    h  499500.0      S   \n",
       "62903           Sunbury  59 Davenport Dr      3    h  499500.0      S   \n",
       "\n",
       "             SellerG        Date  Postcode             Regionname  \\\n",
       "2220         Ruralco   2/06/2018      3756      Northern Victoria   \n",
       "9096           Barry   6/01/2018      3429   Western Metropolitan   \n",
       "13089          Bells   7/11/2016      3020   Western Metropolitan   \n",
       "13840          Barry   8/01/2018      3429   Western Metropolitan   \n",
       "19616          Barry  10/12/2016      3029   Western Metropolitan   \n",
       "19623        Triwest  10/12/2016      3029   Western Metropolitan   \n",
       "30441  hockingstuart  16/07/2016      3074  Northern Metropolitan   \n",
       "31889          Barry  16/12/2017      3429   Western Metropolitan   \n",
       "46682          Barry  23/12/2017      3429   Western Metropolitan   \n",
       "62903          Barry  30/12/2017      3429   Western Metropolitan   \n",
       "\n",
       "       Propertycount  Distance              CouncilArea  \n",
       "2220            3988      44.2   Mitchell Shire Council  \n",
       "9096           14092      31.7        Hume City Council  \n",
       "13089           6763      10.5    Brimbank City Council  \n",
       "13840          14092      31.7        Hume City Council  \n",
       "19616          13830      18.4     Wyndham City Council  \n",
       "19623          13830      18.4     Wyndham City Council  \n",
       "30441           7955      15.3  Whittlesea City Council  \n",
       "31889          14092      31.7        Hume City Council  \n",
       "46682          14092      31.7        Hume City Council  \n",
       "62903          14092      31.7        Hume City Council  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter3 =  df.loc[df['Address'].str.contains('^59', flags=re.I) & (df['Price'] <= 500000)]\n",
    "filter3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "a55e7c4e-124b-48a5-a94a-da61ac734917",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>59A Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1220000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Armadale</td>\n",
       "      <td>6/38 Wattletree Rd</td>\n",
       "      <td>1</td>\n",
       "      <td>u</td>\n",
       "      <td>355000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>hockingstuart</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3143</td>\n",
       "      <td>Southern Metropolitan</td>\n",
       "      <td>4836</td>\n",
       "      <td>6.3</td>\n",
       "      <td>Stonnington City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>Box Hill</td>\n",
       "      <td>12/20 Ashted Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>420000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Noel</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3128</td>\n",
       "      <td>Eastern Metropolitan</td>\n",
       "      <td>4605</td>\n",
       "      <td>10.9</td>\n",
       "      <td>Whitehorse City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>Braybrook</td>\n",
       "      <td>30 Cremorne St</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>490000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Boran</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3019</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>3589</td>\n",
       "      <td>8.6</td>\n",
       "      <td>Maribyrnong City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>Braybrook</td>\n",
       "      <td>2/1 Hancock Cr</td>\n",
       "      <td>2</td>\n",
       "      <td>t</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Jas</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3019</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>3589</td>\n",
       "      <td>8.6</td>\n",
       "      <td>Maribyrnong City Council</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63012</th>\n",
       "      <td>Frankston</td>\n",
       "      <td>5/33 Dandenong East Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>375000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Aquire</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3199</td>\n",
       "      <td>South-Eastern Metropolitan</td>\n",
       "      <td>17055</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Frankston City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63014</th>\n",
       "      <td>Frankston</td>\n",
       "      <td>1/34 Petrie St</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>345000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Aquire</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3199</td>\n",
       "      <td>South-Eastern Metropolitan</td>\n",
       "      <td>17055</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Frankston City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63015</th>\n",
       "      <td>Frankston</td>\n",
       "      <td>3/34 Petrie St</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>340000.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Aquire</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3199</td>\n",
       "      <td>South-Eastern Metropolitan</td>\n",
       "      <td>17055</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Frankston City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63016</th>\n",
       "      <td>Frankston</td>\n",
       "      <td>4/34 Petrie St</td>\n",
       "      <td>2</td>\n",
       "      <td>u</td>\n",
       "      <td>347700.0</td>\n",
       "      <td>SP</td>\n",
       "      <td>Aquire</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3199</td>\n",
       "      <td>South-Eastern Metropolitan</td>\n",
       "      <td>17055</td>\n",
       "      <td>38.0</td>\n",
       "      <td>Frankston City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63019</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>9 Parker Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5955 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "              Suburb                 Address  Rooms Type      Price Method  \\\n",
       "1         Abbotsford           59A Turner St      3    h  1220000.0      S   \n",
       "21          Armadale      6/38 Wattletree Rd      1    u   355000.0      S   \n",
       "75          Box Hill         12/20 Ashted Rd      2    u   420000.0     SP   \n",
       "77         Braybrook          30 Cremorne St      2    h   490000.0      S   \n",
       "78         Braybrook          2/1 Hancock Cr      2    t   500000.0     SP   \n",
       "...              ...                     ...    ...  ...        ...    ...   \n",
       "63012      Frankston  5/33 Dandenong East Rd      2    u   375000.0     SP   \n",
       "63014      Frankston          1/34 Petrie St      2    u   345000.0     SP   \n",
       "63015      Frankston          3/34 Petrie St      2    u   340000.0     SP   \n",
       "63016      Frankston          4/34 Petrie St      2    u   347700.0     SP   \n",
       "63019  Roxburgh Park             9 Parker Ct      3    h   500000.0      S   \n",
       "\n",
       "             SellerG        Date  Postcode                  Regionname  \\\n",
       "1           Marshall   1/04/2017      3067       Northern Metropolitan   \n",
       "21     hockingstuart   1/04/2017      3143       Southern Metropolitan   \n",
       "75              Noel   1/04/2017      3128        Eastern Metropolitan   \n",
       "77             Boran   1/04/2017      3019        Western Metropolitan   \n",
       "78               Jas   1/04/2017      3019        Western Metropolitan   \n",
       "...              ...         ...       ...                         ...   \n",
       "63012         Aquire  31/03/2018      3199  South-Eastern Metropolitan   \n",
       "63014         Aquire  31/03/2018      3199  South-Eastern Metropolitan   \n",
       "63015         Aquire  31/03/2018      3199  South-Eastern Metropolitan   \n",
       "63016         Aquire  31/03/2018      3199  South-Eastern Metropolitan   \n",
       "63019          Raine  31/03/2018      3064       Northern Metropolitan   \n",
       "\n",
       "       Propertycount  Distance               CouncilArea  \n",
       "1               4019       3.0        Yarra City Council  \n",
       "21              4836       6.3  Stonnington City Council  \n",
       "75              4605      10.9   Whitehorse City Council  \n",
       "77              3589       8.6  Maribyrnong City Council  \n",
       "78              3589       8.6  Maribyrnong City Council  \n",
       "...              ...       ...                       ...  \n",
       "63012          17055      38.0    Frankston City Council  \n",
       "63014          17055      38.0    Frankston City Council  \n",
       "63015          17055      38.0    Frankston City Council  \n",
       "63016          17055      38.0    Frankston City Council  \n",
       "63019           5833      20.6         Hume City Council  \n",
       "\n",
       "[5955 rows x 13 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "filter4 =  df.loc[df['Address'].str.contains('^59', flags=re.I) | (df['Price'] <= 500000)]\n",
    "filter4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "a27e5812-68bc-4c2e-8bb2-c9e3ee44ca70",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>49 Lithgow St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1490000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>59A Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1220000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>119B Yarra St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1420000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Nelson</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aberfeldie</td>\n",
       "      <td>68 Vida St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1515000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3040</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1543</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Airport West</td>\n",
       "      <td>92 Clydesdale Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>670000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Nelson</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3042</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>3464</td>\n",
       "      <td>10.4</td>\n",
       "      <td>Moonee Valley City Council</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63018</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>3 Carr Pl</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>566000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63019</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>9 Parker Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63020</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>5 Parkinson Wy</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63021</th>\n",
       "      <td>Thomastown</td>\n",
       "      <td>3/1 Travers St</td>\n",
       "      <td>3</td>\n",
       "      <td>u</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PI</td>\n",
       "      <td>Barry</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3074</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>7955</td>\n",
       "      <td>15.3</td>\n",
       "      <td>Whittlesea City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63022</th>\n",
       "      <td>Williams Landing</td>\n",
       "      <td>1 Diadem Wy</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SP</td>\n",
       "      <td>Aussie</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3027</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1999</td>\n",
       "      <td>17.6</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63023 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Suburb           Address  Rooms Type      Price Method  \\\n",
       "0            Abbotsford     49 Lithgow St      3    h  1490000.0      S   \n",
       "1            Abbotsford     59A Turner St      3    h  1220000.0      S   \n",
       "2            Abbotsford     119B Yarra St      3    h  1420000.0      S   \n",
       "3            Aberfeldie        68 Vida St      3    h  1515000.0      S   \n",
       "4          Airport West  92 Clydesdale Rd      2    h   670000.0      S   \n",
       "...                 ...               ...    ...  ...        ...    ...   \n",
       "63018     Roxburgh Park         3 Carr Pl      3    h   566000.0      S   \n",
       "63019     Roxburgh Park       9 Parker Ct      3    h   500000.0      S   \n",
       "63020     Roxburgh Park    5 Parkinson Wy      3    h   545000.0      S   \n",
       "63021        Thomastown    3/1 Travers St      3    u        NaN     PI   \n",
       "63022  Williams Landing       1 Diadem Wy      4    h        NaN     SP   \n",
       "\n",
       "        SellerG        Date  Postcode             Regionname  Propertycount  \\\n",
       "0        Jellis   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "1      Marshall   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "2        Nelson   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "3         Barry   1/04/2017      3040   Western Metropolitan           1543   \n",
       "4        Nelson   1/04/2017      3042   Western Metropolitan           3464   \n",
       "...         ...         ...       ...                    ...            ...   \n",
       "63018     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63019     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63020     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63021     Barry  31/03/2018      3074  Northern Metropolitan           7955   \n",
       "63022    Aussie  31/03/2018      3027   Western Metropolitan           1999   \n",
       "\n",
       "       Distance                 CouncilArea  \n",
       "0           3.0          Yarra City Council  \n",
       "1           3.0          Yarra City Council  \n",
       "2           3.0          Yarra City Council  \n",
       "3           7.5  Moonee Valley City Council  \n",
       "4          10.4  Moonee Valley City Council  \n",
       "...         ...                         ...  \n",
       "63018      20.6           Hume City Council  \n",
       "63019      20.6           Hume City Council  \n",
       "63020      20.6           Hume City Council  \n",
       "63021      15.3     Whittlesea City Council  \n",
       "63022      17.6        Wyndham City Council  \n",
       "\n",
       "[63023 rows x 13 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "f9c89063-9a7e-47f0-85fe-1f940158308e",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>49 Lithgow St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1490000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>59A Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1220000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>119B Yarra St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1420000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aberfeldie</td>\n",
       "      <td>68 Vida St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1515000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3040</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1543</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Airport West</td>\n",
       "      <td>92 Clydesdale Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>670000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3042</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>3464</td>\n",
       "      <td>10.4</td>\n",
       "      <td>Moonee Valley City Council</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63018</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>3 Carr Pl</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>566000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63019</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>9 Parker Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63020</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>5 Parkinson Wy</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63021</th>\n",
       "      <td>Thomastown</td>\n",
       "      <td>3/1 Travers St</td>\n",
       "      <td>3</td>\n",
       "      <td>u</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PI</td>\n",
       "      <td>Barry</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3074</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>7955</td>\n",
       "      <td>15.3</td>\n",
       "      <td>Whittlesea City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63022</th>\n",
       "      <td>Williams Landing</td>\n",
       "      <td>1 Diadem Wy</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SP</td>\n",
       "      <td>Aussie</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3027</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1999</td>\n",
       "      <td>17.6</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63023 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Suburb           Address  Rooms Type      Price Method  \\\n",
       "0            Abbotsford     49 Lithgow St      3    h  1490000.0      S   \n",
       "1            Abbotsford     59A Turner St      3    h  1220000.0      S   \n",
       "2            Abbotsford     119B Yarra St      3    h  1420000.0      S   \n",
       "3            Aberfeldie        68 Vida St      3    h  1515000.0      S   \n",
       "4          Airport West  92 Clydesdale Rd      2    h   670000.0      S   \n",
       "...                 ...               ...    ...  ...        ...    ...   \n",
       "63018     Roxburgh Park         3 Carr Pl      3    h   566000.0      S   \n",
       "63019     Roxburgh Park       9 Parker Ct      3    h   500000.0      S   \n",
       "63020     Roxburgh Park    5 Parkinson Wy      3    h   545000.0      S   \n",
       "63021        Thomastown    3/1 Travers St      3    u        NaN     PI   \n",
       "63022  Williams Landing       1 Diadem Wy      4    h        NaN     SP   \n",
       "\n",
       "        SellerG        Date  Postcode             Regionname  Propertycount  \\\n",
       "0        Jellis   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "1      Marshall   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "2        Ronald   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "3         Barry   1/04/2017      3040   Western Metropolitan           1543   \n",
       "4        Ronald   1/04/2017      3042   Western Metropolitan           3464   \n",
       "...         ...         ...       ...                    ...            ...   \n",
       "63018     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63019     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63020     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63021     Barry  31/03/2018      3074  Northern Metropolitan           7955   \n",
       "63022    Aussie  31/03/2018      3027   Western Metropolitan           1999   \n",
       "\n",
       "       Distance                 CouncilArea  \n",
       "0           3.0          Yarra City Council  \n",
       "1           3.0          Yarra City Council  \n",
       "2           3.0          Yarra City Council  \n",
       "3           7.5  Moonee Valley City Council  \n",
       "4          10.4  Moonee Valley City Council  \n",
       "...         ...                         ...  \n",
       "63018      20.6           Hume City Council  \n",
       "63019      20.6           Hume City Council  \n",
       "63020      20.6           Hume City Council  \n",
       "63021      15.3     Whittlesea City Council  \n",
       "63022      17.6        Wyndham City Council  \n",
       "\n",
       "[63023 rows x 13 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['SellerG'] == 'Nelson', 'SellerG'] = 'Ronald'\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "b17ccb77-a6e7-46fc-9bfe-e008c6d72ee6",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>49 Lithgow St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1490000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>59A Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1220000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>119B Yarra St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1420000.0</td>\n",
       "      <td>Pending</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aberfeldie</td>\n",
       "      <td>68 Vida St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1515000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3040</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1543</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Airport West</td>\n",
       "      <td>92 Clydesdale Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>h</td>\n",
       "      <td>670000.0</td>\n",
       "      <td>Pending</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3042</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>3464</td>\n",
       "      <td>10.4</td>\n",
       "      <td>Moonee Valley City Council</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63018</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>3 Carr Pl</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>566000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63019</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>9 Parker Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63020</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>5 Parkinson Wy</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63021</th>\n",
       "      <td>Thomastown</td>\n",
       "      <td>3/1 Travers St</td>\n",
       "      <td>3</td>\n",
       "      <td>u</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PI</td>\n",
       "      <td>Barry</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3074</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>7955</td>\n",
       "      <td>15.3</td>\n",
       "      <td>Whittlesea City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63022</th>\n",
       "      <td>Williams Landing</td>\n",
       "      <td>1 Diadem Wy</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SP</td>\n",
       "      <td>Aussie</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3027</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1999</td>\n",
       "      <td>17.6</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63023 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Suburb           Address  Rooms Type      Price   Method  \\\n",
       "0            Abbotsford     49 Lithgow St      3    h  1490000.0        S   \n",
       "1            Abbotsford     59A Turner St      3    h  1220000.0        S   \n",
       "2            Abbotsford     119B Yarra St      3    h  1420000.0  Pending   \n",
       "3            Aberfeldie        68 Vida St      3    h  1515000.0        S   \n",
       "4          Airport West  92 Clydesdale Rd      2    h   670000.0  Pending   \n",
       "...                 ...               ...    ...  ...        ...      ...   \n",
       "63018     Roxburgh Park         3 Carr Pl      3    h   566000.0        S   \n",
       "63019     Roxburgh Park       9 Parker Ct      3    h   500000.0        S   \n",
       "63020     Roxburgh Park    5 Parkinson Wy      3    h   545000.0        S   \n",
       "63021        Thomastown    3/1 Travers St      3    u        NaN       PI   \n",
       "63022  Williams Landing       1 Diadem Wy      4    h        NaN       SP   \n",
       "\n",
       "        SellerG        Date  Postcode             Regionname  Propertycount  \\\n",
       "0        Jellis   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "1      Marshall   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "2        Ronald   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "3         Barry   1/04/2017      3040   Western Metropolitan           1543   \n",
       "4        Ronald   1/04/2017      3042   Western Metropolitan           3464   \n",
       "...         ...         ...       ...                    ...            ...   \n",
       "63018     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63019     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63020     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63021     Barry  31/03/2018      3074  Northern Metropolitan           7955   \n",
       "63022    Aussie  31/03/2018      3027   Western Metropolitan           1999   \n",
       "\n",
       "       Distance                 CouncilArea  \n",
       "0           3.0          Yarra City Council  \n",
       "1           3.0          Yarra City Council  \n",
       "2           3.0          Yarra City Council  \n",
       "3           7.5  Moonee Valley City Council  \n",
       "4          10.4  Moonee Valley City Council  \n",
       "...         ...                         ...  \n",
       "63018      20.6           Hume City Council  \n",
       "63019      20.6           Hume City Council  \n",
       "63020      20.6           Hume City Council  \n",
       "63021      15.3     Whittlesea City Council  \n",
       "63022      17.6        Wyndham City Council  \n",
       "\n",
       "[63023 rows x 13 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['SellerG'] == 'Ronald', 'Method'] = 'Pending'\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "dac3c1d2-6b43-47b6-99e3-e9b5130a4675",
   "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>Suburb</th>\n",
       "      <th>Address</th>\n",
       "      <th>Rooms</th>\n",
       "      <th>Type</th>\n",
       "      <th>Price</th>\n",
       "      <th>Method</th>\n",
       "      <th>SellerG</th>\n",
       "      <th>Date</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Regionname</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "      <th>CouncilArea</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>49 Lithgow St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1490000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Jellis</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>59A Turner St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1220000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Marshall</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Abbotsford</td>\n",
       "      <td>119B Yarra St</td>\n",
       "      <td>3</td>\n",
       "      <td>Pending</td>\n",
       "      <td>1420000.0</td>\n",
       "      <td>Pending</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3067</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>4019</td>\n",
       "      <td>3.0</td>\n",
       "      <td>Yarra City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Aberfeldie</td>\n",
       "      <td>68 Vida St</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>1515000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Barry</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3040</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1543</td>\n",
       "      <td>7.5</td>\n",
       "      <td>Moonee Valley City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Airport West</td>\n",
       "      <td>92 Clydesdale Rd</td>\n",
       "      <td>2</td>\n",
       "      <td>Pending</td>\n",
       "      <td>670000.0</td>\n",
       "      <td>Pending</td>\n",
       "      <td>Ronald</td>\n",
       "      <td>1/04/2017</td>\n",
       "      <td>3042</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>3464</td>\n",
       "      <td>10.4</td>\n",
       "      <td>Moonee Valley City Council</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63018</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>3 Carr Pl</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>566000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63019</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>9 Parker Ct</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>500000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63020</th>\n",
       "      <td>Roxburgh Park</td>\n",
       "      <td>5 Parkinson Wy</td>\n",
       "      <td>3</td>\n",
       "      <td>h</td>\n",
       "      <td>545000.0</td>\n",
       "      <td>S</td>\n",
       "      <td>Raine</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3064</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>5833</td>\n",
       "      <td>20.6</td>\n",
       "      <td>Hume City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63021</th>\n",
       "      <td>Thomastown</td>\n",
       "      <td>3/1 Travers St</td>\n",
       "      <td>3</td>\n",
       "      <td>u</td>\n",
       "      <td>NaN</td>\n",
       "      <td>PI</td>\n",
       "      <td>Barry</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3074</td>\n",
       "      <td>Northern Metropolitan</td>\n",
       "      <td>7955</td>\n",
       "      <td>15.3</td>\n",
       "      <td>Whittlesea City Council</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63022</th>\n",
       "      <td>Williams Landing</td>\n",
       "      <td>1 Diadem Wy</td>\n",
       "      <td>4</td>\n",
       "      <td>h</td>\n",
       "      <td>NaN</td>\n",
       "      <td>SP</td>\n",
       "      <td>Aussie</td>\n",
       "      <td>31/03/2018</td>\n",
       "      <td>3027</td>\n",
       "      <td>Western Metropolitan</td>\n",
       "      <td>1999</td>\n",
       "      <td>17.6</td>\n",
       "      <td>Wyndham City Council</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>63023 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 Suburb           Address  Rooms     Type      Price   Method  \\\n",
       "0            Abbotsford     49 Lithgow St      3        h  1490000.0        S   \n",
       "1            Abbotsford     59A Turner St      3        h  1220000.0        S   \n",
       "2            Abbotsford     119B Yarra St      3  Pending  1420000.0  Pending   \n",
       "3            Aberfeldie        68 Vida St      3        h  1515000.0        S   \n",
       "4          Airport West  92 Clydesdale Rd      2  Pending   670000.0  Pending   \n",
       "...                 ...               ...    ...      ...        ...      ...   \n",
       "63018     Roxburgh Park         3 Carr Pl      3        h   566000.0        S   \n",
       "63019     Roxburgh Park       9 Parker Ct      3        h   500000.0        S   \n",
       "63020     Roxburgh Park    5 Parkinson Wy      3        h   545000.0        S   \n",
       "63021        Thomastown    3/1 Travers St      3        u        NaN       PI   \n",
       "63022  Williams Landing       1 Diadem Wy      4        h        NaN       SP   \n",
       "\n",
       "        SellerG        Date  Postcode             Regionname  Propertycount  \\\n",
       "0        Jellis   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "1      Marshall   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "2        Ronald   1/04/2017      3067  Northern Metropolitan           4019   \n",
       "3         Barry   1/04/2017      3040   Western Metropolitan           1543   \n",
       "4        Ronald   1/04/2017      3042   Western Metropolitan           3464   \n",
       "...         ...         ...       ...                    ...            ...   \n",
       "63018     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63019     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63020     Raine  31/03/2018      3064  Northern Metropolitan           5833   \n",
       "63021     Barry  31/03/2018      3074  Northern Metropolitan           7955   \n",
       "63022    Aussie  31/03/2018      3027   Western Metropolitan           1999   \n",
       "\n",
       "       Distance                 CouncilArea  \n",
       "0           3.0          Yarra City Council  \n",
       "1           3.0          Yarra City Council  \n",
       "2           3.0          Yarra City Council  \n",
       "3           7.5  Moonee Valley City Council  \n",
       "4          10.4  Moonee Valley City Council  \n",
       "...         ...                         ...  \n",
       "63018      20.6           Hume City Council  \n",
       "63019      20.6           Hume City Council  \n",
       "63020      20.6           Hume City Council  \n",
       "63021      15.3     Whittlesea City Council  \n",
       "63022      17.6        Wyndham City Council  \n",
       "\n",
       "[63023 rows x 13 columns]"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.loc[df['SellerG'] == 'Ronald', ['Method', 'Type']] = 'Pending'\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "9cf0848f-6014-445a-a687-d04d68dce820",
   "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>Rooms</th>\n",
       "      <th>Price</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SellerG</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Jellis</th>\n",
       "      <td>16948</td>\n",
       "      <td>5.301902e+09</td>\n",
       "      <td>17116422</td>\n",
       "      <td>42958979</td>\n",
       "      <td>47832.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ronald</th>\n",
       "      <td>13808</td>\n",
       "      <td>4.089097e+09</td>\n",
       "      <td>14489179</td>\n",
       "      <td>35455466</td>\n",
       "      <td>34410.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Barry</th>\n",
       "      <td>22919</td>\n",
       "      <td>4.022899e+09</td>\n",
       "      <td>21405391</td>\n",
       "      <td>54662639</td>\n",
       "      <td>108662.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marshall</th>\n",
       "      <td>9437</td>\n",
       "      <td>3.337732e+09</td>\n",
       "      <td>8949613</td>\n",
       "      <td>22270034</td>\n",
       "      <td>20141.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hockingstuart</th>\n",
       "      <td>12635</td>\n",
       "      <td>3.174822e+09</td>\n",
       "      <td>13571171</td>\n",
       "      <td>36291698</td>\n",
       "      <td>53918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harcourts/YPA</th>\n",
       "      <td>3</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3075</td>\n",
       "      <td>8279</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sahara</th>\n",
       "      <td>8</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6058</td>\n",
       "      <td>23990</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Royston</th>\n",
       "      <td>3</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6362</td>\n",
       "      <td>15434</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hill</th>\n",
       "      <td>7</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6359</td>\n",
       "      <td>5155</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Living</th>\n",
       "      <td>4</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3030</td>\n",
       "      <td>15542</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>476 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Rooms         Price  Postcode  Propertycount  Distance\n",
       "SellerG                                                              \n",
       "Jellis         16948  5.301902e+09  17116422       42958979   47832.0\n",
       "Ronald         13808  4.089097e+09  14489179       35455466   34410.0\n",
       "Barry          22919  4.022899e+09  21405391       54662639  108662.0\n",
       "Marshall        9437  3.337732e+09   8949613       22270034   20141.0\n",
       "hockingstuart  12635  3.174822e+09  13571171       36291698   53918.0\n",
       "...              ...           ...       ...            ...       ...\n",
       "Harcourts/YPA      3  0.000000e+00      3075           8279      16.0\n",
       "Sahara             8  0.000000e+00      6058          23990      37.0\n",
       "Royston            3  0.000000e+00      6362          15434       9.0\n",
       "Hill               7  0.000000e+00      6359           5155      46.0\n",
       "Living             4  0.000000e+00      3030          15542      15.0\n",
       "\n",
       "[476 rows x 5 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.groupby([\"SellerG\"]).sum().round().sort_values('Price', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "160de71a-8ca5-489c-9d76-e26cd02c42bd",
   "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>Rooms</th>\n",
       "      <th>Price</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SellerG</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>For</th>\n",
       "      <td>4.0</td>\n",
       "      <td>3780000.0</td>\n",
       "      <td>3186.0</td>\n",
       "      <td>10579.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sotheby's</th>\n",
       "      <td>3.0</td>\n",
       "      <td>2706346.0</td>\n",
       "      <td>3124.0</td>\n",
       "      <td>8721.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Weast</th>\n",
       "      <td>4.0</td>\n",
       "      <td>2360000.0</td>\n",
       "      <td>3156.0</td>\n",
       "      <td>7929.0</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Buxton/Marshall</th>\n",
       "      <td>4.0</td>\n",
       "      <td>2218333.0</td>\n",
       "      <td>3145.0</td>\n",
       "      <td>4827.0</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>North</th>\n",
       "      <td>3.0</td>\n",
       "      <td>2200000.0</td>\n",
       "      <td>3103.0</td>\n",
       "      <td>5682.0</td>\n",
       "      <td>8.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>We</th>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3174.0</td>\n",
       "      <td>11806.0</td>\n",
       "      <td>23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>WeSell</th>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3171.0</td>\n",
       "      <td>7412.0</td>\n",
       "      <td>21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hockingstuart/Cayzer</th>\n",
       "      <td>1.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3181.0</td>\n",
       "      <td>7717.0</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hockingstuart/HAR</th>\n",
       "      <td>4.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3188.0</td>\n",
       "      <td>5454.0</td>\n",
       "      <td>14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hockingstuart/Purplebricks</th>\n",
       "      <td>3.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>3076.0</td>\n",
       "      <td>10926.0</td>\n",
       "      <td>20.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>476 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                            Rooms      Price  Postcode  Propertycount  \\\n",
       "SellerG                                                                 \n",
       "For                           4.0  3780000.0    3186.0        10579.0   \n",
       "Sotheby's                     3.0  2706346.0    3124.0         8721.0   \n",
       "Weast                         4.0  2360000.0    3156.0         7929.0   \n",
       "Buxton/Marshall               4.0  2218333.0    3145.0         4827.0   \n",
       "North                         3.0  2200000.0    3103.0         5682.0   \n",
       "...                           ...        ...       ...            ...   \n",
       "We                            3.0        NaN    3174.0        11806.0   \n",
       "WeSell                        4.0        NaN    3171.0         7412.0   \n",
       "hockingstuart/Cayzer          1.0        NaN    3181.0         7717.0   \n",
       "hockingstuart/HAR             4.0        NaN    3188.0         5454.0   \n",
       "hockingstuart/Purplebricks    3.0        NaN    3076.0        10926.0   \n",
       "\n",
       "                            Distance  \n",
       "SellerG                               \n",
       "For                             10.0  \n",
       "Sotheby's                        5.0  \n",
       "Weast                            9.0  \n",
       "Buxton/Marshall                 10.0  \n",
       "North                            8.0  \n",
       "...                              ...  \n",
       "We                              23.0  \n",
       "WeSell                          21.0  \n",
       "hockingstuart/Cayzer             5.0  \n",
       "hockingstuart/HAR               14.0  \n",
       "hockingstuart/Purplebricks      20.0  \n",
       "\n",
       "[476 rows x 5 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.groupby([\"SellerG\"]).mean().round().sort_values('Price', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "a4dcb2e0-dc76-45b0-852a-04bc7dd5802a",
   "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>Rooms</th>\n",
       "      <th>Price</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SellerG</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Barry</th>\n",
       "      <td>22919</td>\n",
       "      <td>4.022899e+09</td>\n",
       "      <td>21405391</td>\n",
       "      <td>54662639</td>\n",
       "      <td>108662.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jellis</th>\n",
       "      <td>16948</td>\n",
       "      <td>5.301902e+09</td>\n",
       "      <td>17116422</td>\n",
       "      <td>42958979</td>\n",
       "      <td>47832.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ray</th>\n",
       "      <td>14961</td>\n",
       "      <td>2.953669e+09</td>\n",
       "      <td>14329293</td>\n",
       "      <td>41191735</td>\n",
       "      <td>76239.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ronald</th>\n",
       "      <td>13808</td>\n",
       "      <td>4.089097e+09</td>\n",
       "      <td>14489179</td>\n",
       "      <td>35455466</td>\n",
       "      <td>34410.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hockingstuart</th>\n",
       "      <td>12635</td>\n",
       "      <td>3.174822e+09</td>\n",
       "      <td>13571171</td>\n",
       "      <td>36291698</td>\n",
       "      <td>53918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harcourts/Barry</th>\n",
       "      <td>2</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3046</td>\n",
       "      <td>2651</td>\n",
       "      <td>11.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Finders</th>\n",
       "      <td>2</td>\n",
       "      <td>1.320000e+06</td>\n",
       "      <td>3000</td>\n",
       "      <td>17496</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Batty</th>\n",
       "      <td>2</td>\n",
       "      <td>4.450000e+05</td>\n",
       "      <td>3019</td>\n",
       "      <td>3589</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jamie</th>\n",
       "      <td>1</td>\n",
       "      <td>3.250000e+05</td>\n",
       "      <td>3071</td>\n",
       "      <td>8870</td>\n",
       "      <td>7.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hockingstuart/Cayzer</th>\n",
       "      <td>1</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3181</td>\n",
       "      <td>7717</td>\n",
       "      <td>5.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>476 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                      Rooms         Price  Postcode  Propertycount  Distance\n",
       "SellerG                                                                     \n",
       "Barry                 22919  4.022899e+09  21405391       54662639  108662.0\n",
       "Jellis                16948  5.301902e+09  17116422       42958979   47832.0\n",
       "Ray                   14961  2.953669e+09  14329293       41191735   76239.0\n",
       "Ronald                13808  4.089097e+09  14489179       35455466   34410.0\n",
       "hockingstuart         12635  3.174822e+09  13571171       36291698   53918.0\n",
       "...                     ...           ...       ...            ...       ...\n",
       "Harcourts/Barry           2  0.000000e+00      3046           2651      11.0\n",
       "Finders                   2  1.320000e+06      3000          17496       0.0\n",
       "Batty                     2  4.450000e+05      3019           3589       9.0\n",
       "Jamie                     1  3.250000e+05      3071           8870       7.0\n",
       "hockingstuart/Cayzer      1  0.000000e+00      3181           7717       5.0\n",
       "\n",
       "[476 rows x 5 columns]"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.groupby([\"SellerG\"]).sum().round().sort_values('Rooms', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "fc93c5d6-bae9-4eb7-a946-988f60ca6503",
   "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>Rooms</th>\n",
       "      <th>Price</th>\n",
       "      <th>Postcode</th>\n",
       "      <th>Propertycount</th>\n",
       "      <th>Distance</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>SellerG</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Jellis</th>\n",
       "      <td>16948</td>\n",
       "      <td>5.301902e+09</td>\n",
       "      <td>17116422</td>\n",
       "      <td>42958979</td>\n",
       "      <td>47832.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Ronald</th>\n",
       "      <td>13808</td>\n",
       "      <td>4.089097e+09</td>\n",
       "      <td>14489179</td>\n",
       "      <td>35455466</td>\n",
       "      <td>34410.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Barry</th>\n",
       "      <td>22919</td>\n",
       "      <td>4.022899e+09</td>\n",
       "      <td>21405391</td>\n",
       "      <td>54662639</td>\n",
       "      <td>108662.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Marshall</th>\n",
       "      <td>9437</td>\n",
       "      <td>3.337732e+09</td>\n",
       "      <td>8949613</td>\n",
       "      <td>22270034</td>\n",
       "      <td>20141.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>hockingstuart</th>\n",
       "      <td>12635</td>\n",
       "      <td>3.174822e+09</td>\n",
       "      <td>13571171</td>\n",
       "      <td>36291698</td>\n",
       "      <td>53918.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Harcourts/YPA</th>\n",
       "      <td>3</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3075</td>\n",
       "      <td>8279</td>\n",
       "      <td>16.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Sahara</th>\n",
       "      <td>8</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6058</td>\n",
       "      <td>23990</td>\n",
       "      <td>37.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Royston</th>\n",
       "      <td>3</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6362</td>\n",
       "      <td>15434</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Hill</th>\n",
       "      <td>7</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>6359</td>\n",
       "      <td>5155</td>\n",
       "      <td>46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Living</th>\n",
       "      <td>4</td>\n",
       "      <td>0.000000e+00</td>\n",
       "      <td>3030</td>\n",
       "      <td>15542</td>\n",
       "      <td>15.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>476 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               Rooms         Price  Postcode  Propertycount  Distance\n",
       "SellerG                                                              \n",
       "Jellis         16948  5.301902e+09  17116422       42958979   47832.0\n",
       "Ronald         13808  4.089097e+09  14489179       35455466   34410.0\n",
       "Barry          22919  4.022899e+09  21405391       54662639  108662.0\n",
       "Marshall        9437  3.337732e+09   8949613       22270034   20141.0\n",
       "hockingstuart  12635  3.174822e+09  13571171       36291698   53918.0\n",
       "...              ...           ...       ...            ...       ...\n",
       "Harcourts/YPA      3  0.000000e+00      3075           8279      16.0\n",
       "Sahara             8  0.000000e+00      6058          23990      37.0\n",
       "Royston            3  0.000000e+00      6362          15434       9.0\n",
       "Hill               7  0.000000e+00      6359           5155      46.0\n",
       "Living             4  0.000000e+00      3030          15542      15.0\n",
       "\n",
       "[476 rows x 5 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1.groupby([\"SellerG\"]).sum().round().sort_values('Price', ascending=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "58649713-c4dd-4af3-8b7b-de0ac1f88d4b",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}