C02.5-practica-airbnb.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# La agencia de viajes\n",
    "\n",
    "Supongamos que somos un agente de Airbnb localizado en CDMX, y tenemos que atender peticiones de varios clientes. Tenemos un archivo llamado airbnb_cdmx.csv donde tenemos información de todos los alojamientos de Airbnb en CDMX"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "En concreto el dataset tiene las siguientes variables:\n",
    "\n",
    "* id: el identificador de la propiedad\n",
    "* host_id: el identificador del dueño de la propiedad\n",
    "* neighborhood_cleansed: alcaldía en CDMX\n",
    "* property_type: tipo de propiedad \n",
    "* room_type: tipo de habitación\n",
    "* accommodates: El numero de personas que se pueden alojar en la propiedad\n",
    "* price: precio (en pesos mexicanos)\n",
    "* minimum_nights, maximum_nights: mínimo y máximo de noches\n",
    "* bedrooms: El número de habitaciones\n",
    "* beds: número de camas\n",
    "* cancellation_policy: política de cancelación\n",
    "* number_of_reviews: El numero de opiniones\n",
    "* review_scores_accuracy: Puntuacion media del apartamento"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>neighbourhood_cleansed</th>\n",
       "      <th>property_type</th>\n",
       "      <th>room_type</th>\n",
       "      <th>accommodates</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>maximum_nights</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>beds</th>\n",
       "      <th>cancellation_policy</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>review_scores_accuracy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>35797</td>\n",
       "      <td>153786</td>\n",
       "      <td>Cuajimalpa de Morelos</td>\n",
       "      <td>Villa</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>4500</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>56074</td>\n",
       "      <td>265650</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Condominium</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3</td>\n",
       "      <td>843</td>\n",
       "      <td>4</td>\n",
       "      <td>150</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>60</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>61792</td>\n",
       "      <td>299558</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>1359</td>\n",
       "      <td>2</td>\n",
       "      <td>21</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>52</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>70644</td>\n",
       "      <td>212109</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>1245</td>\n",
       "      <td>6</td>\n",
       "      <td>180</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>102</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>107078</td>\n",
       "      <td>540705</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>4868</td>\n",
       "      <td>4</td>\n",
       "      <td>365</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>10</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       id  host_id neighbourhood_cleansed property_type        room_type  \\\n",
       "0   35797   153786  Cuajimalpa de Morelos         Villa  Entire home/apt   \n",
       "1   56074   265650             Cuauhtemoc   Condominium  Entire home/apt   \n",
       "2   61792   299558             Cuauhtemoc         House     Private room   \n",
       "3   70644   212109               Coyoacan     Apartment  Entire home/apt   \n",
       "4  107078   540705         Miguel Hidalgo          Loft  Entire home/apt   \n",
       "\n",
       "   accommodates  price  minimum_nights  maximum_nights  bedrooms  beds  \\\n",
       "0             2   4500               1               7       1.0   1.0   \n",
       "1             3    843               4             150       1.0   2.0   \n",
       "2             2   1359               2              21       1.0   1.0   \n",
       "3             2   1245               6             180       1.0   1.0   \n",
       "4             2   4868               4             365       1.0   1.0   \n",
       "\n",
       "           cancellation_policy  number_of_reviews  review_scores_accuracy  \n",
       "0                     flexible                  0                     NaN  \n",
       "1                     moderate                 60                    10.0  \n",
       "2                     moderate                 52                    10.0  \n",
       "3                     moderate                102                    10.0  \n",
       "4  strict_14_with_grace_period                 10                    10.0  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "airbnb = pd.read_csv(\"airbnb_cdmx.csv\")\n",
    "airbnb.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Alicia y su familia\n",
    "\n",
    "Alicia va a ir a CDMX durante una semana con su marido y sus 2 hijos. Están buscando un apartamento con habitaciones separadas para los padres y los hijos. No les importa donde alojarse o el precio, simplemente quieren tener una experiencia agradable. Esto significa que solo aceptan lugares con más de 10 críticas con una puntuación mayor de 4. Cuando seleccionemos habitaciones para Alicia, tenemos que asegurarnos de ordenar las habitaciones de mejor a peor puntuación. Para aquellas habitaciones que tienen la misma puntuación, debemos mostrar antes aquellas con más críticas. Debemos a lo más la tercera parte del total de posibilidades."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>neighbourhood_cleansed</th>\n",
       "      <th>property_type</th>\n",
       "      <th>room_type</th>\n",
       "      <th>accommodates</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>maximum_nights</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>beds</th>\n",
       "      <th>cancellation_policy</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>review_scores_accuracy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>165772</td>\n",
       "      <td>790208</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>House</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>14</td>\n",
       "      <td>1245</td>\n",
       "      <td>2</td>\n",
       "      <td>365</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>266</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>187030</td>\n",
       "      <td>899360</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6</td>\n",
       "      <td>1314</td>\n",
       "      <td>3</td>\n",
       "      <td>365</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>97</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>198778</td>\n",
       "      <td>970609</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>1087</td>\n",
       "      <td>2</td>\n",
       "      <td>365</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>169</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>246057</td>\n",
       "      <td>1288063</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5</td>\n",
       "      <td>1699</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>247</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>256555</td>\n",
       "      <td>790208</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>House</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>14</td>\n",
       "      <td>1245</td>\n",
       "      <td>2</td>\n",
       "      <td>365</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>264</td>\n",
       "      <td>10.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",
       "      <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>19714</th>\n",
       "      <td>42202314</td>\n",
       "      <td>132484396</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5</td>\n",
       "      <td>725</td>\n",
       "      <td>2</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>12</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19741</th>\n",
       "      <td>42224748</td>\n",
       "      <td>335393886</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Condominium</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>2332</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>21</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19771</th>\n",
       "      <td>42249246</td>\n",
       "      <td>332120390</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5</td>\n",
       "      <td>1200</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>13</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19800</th>\n",
       "      <td>42272228</td>\n",
       "      <td>335393886</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Condominium</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>2255</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>15</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19908</th>\n",
       "      <td>42360548</td>\n",
       "      <td>136203553</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>957</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>14</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2972 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             id    host_id neighbourhood_cleansed property_type  \\\n",
       "6        165772     790208         Miguel Hidalgo         House   \n",
       "9        187030     899360             Cuauhtemoc     Apartment   \n",
       "12       198778     970609             Cuauhtemoc     Apartment   \n",
       "15       246057    1288063             Cuauhtemoc     Apartment   \n",
       "19       256555     790208         Miguel Hidalgo         House   \n",
       "...         ...        ...                    ...           ...   \n",
       "19714  42202314  132484396          Benito Juarez     Apartment   \n",
       "19741  42224748  335393886         Miguel Hidalgo   Condominium   \n",
       "19771  42249246  332120390          Benito Juarez     Apartment   \n",
       "19800  42272228  335393886         Miguel Hidalgo   Condominium   \n",
       "19908  42360548  136203553               Coyoacan     Apartment   \n",
       "\n",
       "             room_type  accommodates  price  minimum_nights  maximum_nights  \\\n",
       "6      Entire home/apt            14   1245               2             365   \n",
       "9      Entire home/apt             6   1314               3             365   \n",
       "12     Entire home/apt             4   1087               2             365   \n",
       "15     Entire home/apt             5   1699               1              30   \n",
       "19     Entire home/apt            14   1245               2             365   \n",
       "...                ...           ...    ...             ...             ...   \n",
       "19714  Entire home/apt             5    725               2            1125   \n",
       "19741  Entire home/apt             4   2332               1              30   \n",
       "19771  Entire home/apt             5   1200               1            1125   \n",
       "19800  Entire home/apt             4   2255               1              30   \n",
       "19908  Entire home/apt             4    957               1            1125   \n",
       "\n",
       "       bedrooms  beds          cancellation_policy  number_of_reviews  \\\n",
       "6           4.0  10.0  strict_14_with_grace_period                266   \n",
       "9           2.0   3.0                     moderate                 97   \n",
       "12          2.0   4.0  strict_14_with_grace_period                169   \n",
       "15          2.0   4.0                     flexible                247   \n",
       "19          4.0  10.0  strict_14_with_grace_period                264   \n",
       "...         ...   ...                          ...                ...   \n",
       "19714       2.0   3.0  strict_14_with_grace_period                 12   \n",
       "19741       2.0   2.0                     moderate                 21   \n",
       "19771       2.0   3.0                     flexible                 13   \n",
       "19800       2.0   2.0                     moderate                 15   \n",
       "19908       2.0   3.0                     moderate                 14   \n",
       "\n",
       "       review_scores_accuracy  \n",
       "6                        10.0  \n",
       "9                        10.0  \n",
       "12                        9.0  \n",
       "15                       10.0  \n",
       "19                       10.0  \n",
       "...                       ...  \n",
       "19714                    10.0  \n",
       "19741                    10.0  \n",
       "19771                    10.0  \n",
       "19800                    10.0  \n",
       "19908                    10.0  \n",
       "\n",
       "[2972 rows x 14 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\" \n",
    "Filtrar:\n",
    " noches_estancia = 6\n",
    " habitaciones >= 2\n",
    " num_criticas > 10\n",
    " puntuacion > 4\n",
    "Ordenar descendente por puntuación\n",
    "Misma puntuación, ordenar por num_críticas descendente\n",
    "Mostrar solo 1/3 de los resultados\n",
    "\"\"\"\n",
    "\n",
    "# Noches:\n",
    "# Se quiere quedar exactamente 6 noches.\n",
    "# Las propiedades que le sirven son aquellas que:\n",
    "# - no pidan un mínimo mayor a 6 y\n",
    "# - no tengan un máximo menor a 6.\n",
    "f1 = airbnb[\"maximum_nights\"] >= 6\n",
    "f2 = airbnb[\"minimum_nights\"] <= 6\n",
    "# Habitaciones separadas para papás e hijos\n",
    "f3 = airbnb[\"bedrooms\"] >= 2\n",
    "# Mínimo 4 personas\n",
    "f4 = airbnb[\"accommodates\"] >= 4\n",
    "# Mínimo 10 críticas\n",
    "f5 = airbnb[\"number_of_reviews\"] > 10\n",
    "# Puntuación mínima de 4\n",
    "f6 = airbnb[\"review_scores_accuracy\"] > 4\n",
    "# Combinar filtros\n",
    "opciones = airbnb[f1 & f2 & f3 & f4 & f5 & f6]\n",
    "opciones"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Ordenar\n",
    "opciones = opciones.sort_values(by=[\"review_scores_accuracy\", \"number_of_reviews\"],\n",
    "                     ascending=[False, False])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>neighbourhood_cleansed</th>\n",
       "      <th>property_type</th>\n",
       "      <th>room_type</th>\n",
       "      <th>accommodates</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>maximum_nights</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>beds</th>\n",
       "      <th>cancellation_policy</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>review_scores_accuracy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2800</th>\n",
       "      <td>14150131</td>\n",
       "      <td>10644799</td>\n",
       "      <td>Venustiano Carranza</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>473</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>506</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6024</th>\n",
       "      <td>21052296</td>\n",
       "      <td>151657679</td>\n",
       "      <td>Iztacalco</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>540</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>424</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>581</th>\n",
       "      <td>4801896</td>\n",
       "      <td>20440301</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>1993</td>\n",
       "      <td>1</td>\n",
       "      <td>150</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>365</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2520</th>\n",
       "      <td>13398036</td>\n",
       "      <td>70937648</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>1200</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>342</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>137</th>\n",
       "      <td>997247</td>\n",
       "      <td>5479592</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>1812</td>\n",
       "      <td>2</td>\n",
       "      <td>1000</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>333</td>\n",
       "      <td>10.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",
       "      <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>8739</th>\n",
       "      <td>25973891</td>\n",
       "      <td>100844511</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>900</td>\n",
       "      <td>2</td>\n",
       "      <td>180</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>52</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9875</th>\n",
       "      <td>28409727</td>\n",
       "      <td>39346393</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6</td>\n",
       "      <td>1449</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>52</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10751</th>\n",
       "      <td>30009282</td>\n",
       "      <td>202890617</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>5</td>\n",
       "      <td>1993</td>\n",
       "      <td>2</td>\n",
       "      <td>30</td>\n",
       "      <td>3.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>52</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11278</th>\n",
       "      <td>30979411</td>\n",
       "      <td>82121841</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>7</td>\n",
       "      <td>1948</td>\n",
       "      <td>2</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>52</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11921</th>\n",
       "      <td>31982929</td>\n",
       "      <td>239786492</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>6</td>\n",
       "      <td>1699</td>\n",
       "      <td>2</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>52</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>990 rows × 14 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "             id    host_id neighbourhood_cleansed property_type  \\\n",
       "2800   14150131   10644799    Venustiano Carranza          Loft   \n",
       "6024   21052296  151657679              Iztacalco     Apartment   \n",
       "581     4801896   20440301             Cuauhtemoc     Apartment   \n",
       "2520   13398036   70937648             Cuauhtemoc     Apartment   \n",
       "137      997247    5479592             Cuauhtemoc     Apartment   \n",
       "...         ...        ...                    ...           ...   \n",
       "8739   25973891  100844511               Coyoacan     Apartment   \n",
       "9875   28409727   39346393         Miguel Hidalgo     Apartment   \n",
       "10751  30009282  202890617             Cuauhtemoc     Apartment   \n",
       "11278  30979411   82121841             Cuauhtemoc     Apartment   \n",
       "11921  31982929  239786492             Cuauhtemoc     Apartment   \n",
       "\n",
       "             room_type  accommodates  price  minimum_nights  maximum_nights  \\\n",
       "2800   Entire home/apt             4    473               1            1125   \n",
       "6024   Entire home/apt             4    540               1            1125   \n",
       "581    Entire home/apt             4   1993               1             150   \n",
       "2520   Entire home/apt             4   1200               1            1125   \n",
       "137    Entire home/apt             4   1812               2            1000   \n",
       "...                ...           ...    ...             ...             ...   \n",
       "8739   Entire home/apt             4    900               2             180   \n",
       "9875   Entire home/apt             6   1449               1            1125   \n",
       "10751  Entire home/apt             5   1993               2              30   \n",
       "11278  Entire home/apt             7   1948               2            1125   \n",
       "11921  Entire home/apt             6   1699               2            1125   \n",
       "\n",
       "       bedrooms  beds          cancellation_policy  number_of_reviews  \\\n",
       "2800        2.0   3.0                     flexible                506   \n",
       "6024        2.0   2.0                     flexible                424   \n",
       "581         2.0   2.0                     flexible                365   \n",
       "2520        2.0   2.0                     moderate                342   \n",
       "137         2.0   2.0  strict_14_with_grace_period                333   \n",
       "...         ...   ...                          ...                ...   \n",
       "8739        2.0   3.0                     flexible                 52   \n",
       "9875        2.0   3.0  strict_14_with_grace_period                 52   \n",
       "10751       3.0   3.0                     moderate                 52   \n",
       "11278       2.0   4.0                     moderate                 52   \n",
       "11921       2.0   3.0                     moderate                 52   \n",
       "\n",
       "       review_scores_accuracy  \n",
       "2800                     10.0  \n",
       "6024                     10.0  \n",
       "581                      10.0  \n",
       "2520                     10.0  \n",
       "137                      10.0  \n",
       "...                       ...  \n",
       "8739                     10.0  \n",
       "9875                     10.0  \n",
       "10751                    10.0  \n",
       "11278                    10.0  \n",
       "11921                    10.0  \n",
       "\n",
       "[990 rows x 14 columns]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Limitar solo a la tercera parte\n",
    "num_opciones = opciones.shape[0] // 3\n",
    "opciones = opciones.head(num_opciones)\n",
    "opciones"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Roberto contra su hermana\n",
    "\n",
    "Roberto es un casero que tiene una casa en Airbnb. De vez en cuando nos llama preguntando sobre cuales son las críticas de su alojamiento. Hoy está particularmente molesto, ya que su hermana Valentina ha puesto una casa en Airbnb y Roberto quiere asegurarse de que su casa tiene más críticas que las de Valentina. Tenemos que crear un dataframe con las propiedades de ambos. Las id de las casas de Roberto y Valentina son 43856289 y 107078 respectivamente. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "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>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>neighbourhood_cleansed</th>\n",
       "      <th>property_type</th>\n",
       "      <th>room_type</th>\n",
       "      <th>accommodates</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>maximum_nights</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>beds</th>\n",
       "      <th>cancellation_policy</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>review_scores_accuracy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>107078</td>\n",
       "      <td>540705</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>4868</td>\n",
       "      <td>4</td>\n",
       "      <td>365</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>10</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21819</th>\n",
       "      <td>43856289</td>\n",
       "      <td>63979434</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>4</td>\n",
       "      <td>996</td>\n",
       "      <td>1</td>\n",
       "      <td>15</td>\n",
       "      <td>1.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             id   host_id neighbourhood_cleansed property_type  \\\n",
       "4        107078    540705         Miguel Hidalgo          Loft   \n",
       "21819  43856289  63979434             Cuauhtemoc         House   \n",
       "\n",
       "             room_type  accommodates  price  minimum_nights  maximum_nights  \\\n",
       "4      Entire home/apt             2   4868               4             365   \n",
       "21819     Private room             4    996               1              15   \n",
       "\n",
       "       bedrooms  beds          cancellation_policy  number_of_reviews  \\\n",
       "4           1.0   1.0  strict_14_with_grace_period                 10   \n",
       "21819       1.0   3.0                     flexible                  0   \n",
       "\n",
       "       review_scores_accuracy  \n",
       "4                        10.0  \n",
       "21819                     NaN  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Crear filtros\n",
    "casa_roberto = airbnb[\"id\"] == 43856289\n",
    "casa_valentina = airbnb[\"id\"] == 107078\n",
    "# Aplicar filtros\n",
    "airbnb[casa_roberto | casa_valentina]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Diana \"la mochilera\"\n",
    "\n",
    "Diana va a CDMX a pasar 3 noches y quiere conocer a gente nueva. Tiene un presupuesto de 1,250 pesos mexicanos para su alojamiento. Debemos buscarle las 10 propiedades más baratas, dandole preferencia a aquellas que sean habitaciones compartidas, y para aquellas viviendas compartidas debemos elegir aquellas con mejor puntuación."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array(['Entire home/apt', 'Private room', 'Hotel room', 'Shared room'],\n",
       "      dtype=object)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Tipos de habitaciones\n",
    "airbnb[\"room_type\"].unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [],
   "source": [
    "# Datos\n",
    "presupuesto = 1250\n",
    "noches = 3\n",
    "\n",
    "# Filtros\n",
    "# Presupuesto\n",
    "fp = airbnb[\"price\"] <= presupuesto/noches\n",
    "# Noches\n",
    "fn = (airbnb[\"minimum_nights\"] <= 3) & (airbnb[\"maximum_nights\"] >= 3)\n",
    "# Cuartos compartidos\n",
    "fc = airbnb[\"room_type\"] == \"Shared room\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>neighbourhood_cleansed</th>\n",
       "      <th>property_type</th>\n",
       "      <th>room_type</th>\n",
       "      <th>accommodates</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>maximum_nights</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>beds</th>\n",
       "      <th>cancellation_policy</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>review_scores_accuracy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>7728</th>\n",
       "      <td>23877762</td>\n",
       "      <td>179398369</td>\n",
       "      <td>Tlalpan</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>159</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19417</th>\n",
       "      <td>41917043</td>\n",
       "      <td>321717003</td>\n",
       "      <td>Iztapalapa</td>\n",
       "      <td>Condominium</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>3</td>\n",
       "      <td>179</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12068</th>\n",
       "      <td>32197684</td>\n",
       "      <td>229856606</td>\n",
       "      <td>Tlalpan</td>\n",
       "      <td>House</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>180</td>\n",
       "      <td>3</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11666</th>\n",
       "      <td>31588864</td>\n",
       "      <td>124718595</td>\n",
       "      <td>Tlahuac</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>180</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>3</td>\n",
       "      <td>9.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9676</th>\n",
       "      <td>28008247</td>\n",
       "      <td>211537057</td>\n",
       "      <td>Tlalpan</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>180</td>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6345</th>\n",
       "      <td>21596500</td>\n",
       "      <td>2269083</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>181</td>\n",
       "      <td>3</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>2</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7377</th>\n",
       "      <td>23255186</td>\n",
       "      <td>94336357</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>181</td>\n",
       "      <td>2</td>\n",
       "      <td>20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>3</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12186</th>\n",
       "      <td>32381892</td>\n",
       "      <td>238972976</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Hostel</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>16</td>\n",
       "      <td>181</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>9</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16977</th>\n",
       "      <td>39228937</td>\n",
       "      <td>224496196</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>181</td>\n",
       "      <td>1</td>\n",
       "      <td>90</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>9</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17643</th>\n",
       "      <td>39997048</td>\n",
       "      <td>305453762</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Hostel</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>8</td>\n",
       "      <td>181</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>1.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>8</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             id    host_id neighbourhood_cleansed property_type    room_type  \\\n",
       "7728   23877762  179398369                Tlalpan          Loft  Shared room   \n",
       "19417  41917043  321717003             Iztapalapa   Condominium  Shared room   \n",
       "12068  32197684  229856606                Tlalpan         House  Shared room   \n",
       "11666  31588864  124718595                Tlahuac     Apartment  Shared room   \n",
       "9676   28008247  211537057                Tlalpan     Apartment  Shared room   \n",
       "6345   21596500    2269083         Miguel Hidalgo     Apartment  Shared room   \n",
       "7377   23255186   94336357          Benito Juarez     Apartment  Shared room   \n",
       "12186  32381892  238972976             Cuauhtemoc        Hostel  Shared room   \n",
       "16977  39228937  224496196             Cuauhtemoc     Apartment  Shared room   \n",
       "17643  39997048  305453762             Cuauhtemoc        Hostel  Shared room   \n",
       "\n",
       "       accommodates  price  minimum_nights  maximum_nights  bedrooms  beds  \\\n",
       "7728              1    159               1            1125       1.0   1.0   \n",
       "19417             3    179               1             365       1.0   0.0   \n",
       "12068             1    180               3            1125       1.0   1.0   \n",
       "11666             1    180               1            1125       1.0   1.0   \n",
       "9676              1    180               2              31       1.0   1.0   \n",
       "6345              1    181               3            1125       1.0   1.0   \n",
       "7377              1    181               2              20       1.0   2.0   \n",
       "12186            16    181               1            1125       1.0  18.0   \n",
       "16977             1    181               1              90       1.0   1.0   \n",
       "17643             8    181               1             365       1.0   8.0   \n",
       "\n",
       "               cancellation_policy  number_of_reviews  review_scores_accuracy  \n",
       "7728                      flexible                  0                     NaN  \n",
       "19417                     flexible                  0                     NaN  \n",
       "12068                     moderate                  1                    10.0  \n",
       "11666                     flexible                  3                     9.0  \n",
       "9676                      moderate                  0                     NaN  \n",
       "6345                      flexible                  2                    10.0  \n",
       "7377                      flexible                  3                    10.0  \n",
       "12186  strict_14_with_grace_period                  9                    10.0  \n",
       "16977  strict_14_with_grace_period                  9                    10.0  \n",
       "17643                     moderate                  8                    10.0  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Aplicar filtros\n",
    "diana = airbnb[fp & fn & fc]\n",
    "\n",
    "# Ordenar\n",
    "# 1. Precio\n",
    "# 2. Que sea habitación compartida\n",
    "# 3. Mejor puntuación\n",
    "diana = diana.sort_values(by=[\"price\", \"review_scores_accuracy\"], ascending=[True, False])\n",
    "# Sólo las mejores 10\n",
    "diana = diana.head(10)\n",
    "diana"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\JorgeZaldivar\\anaconda3\\lib\\site-packages\\ipykernel_launcher.py:9: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  if __name__ == '__main__':\n"
     ]
    },
    {
     "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>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>neighbourhood_cleansed</th>\n",
       "      <th>property_type</th>\n",
       "      <th>room_type</th>\n",
       "      <th>accommodates</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>maximum_nights</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>beds</th>\n",
       "      <th>cancellation_policy</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>review_scores_accuracy</th>\n",
       "      <th>shared</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6113</th>\n",
       "      <td>21212741</td>\n",
       "      <td>48001186</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>29</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6138</th>\n",
       "      <td>21266125</td>\n",
       "      <td>30026600</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>400</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5653</th>\n",
       "      <td>20435525</td>\n",
       "      <td>64371831</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>30</td>\n",
       "      <td>3.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>strict_14_with_grace_period</td>\n",
       "      <td>105</td>\n",
       "      <td>9.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5602</th>\n",
       "      <td>20277868</td>\n",
       "      <td>134853067</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>Hostel</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>1</td>\n",
       "      <td>6.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4738</th>\n",
       "      <td>18570933</td>\n",
       "      <td>76376610</td>\n",
       "      <td>Miguel Hidalgo</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20122</th>\n",
       "      <td>42534951</td>\n",
       "      <td>113550322</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Hotel</td>\n",
       "      <td>Hotel room</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20123</th>\n",
       "      <td>42534965</td>\n",
       "      <td>307295793</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Boutique hotel</td>\n",
       "      <td>Hotel room</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20124</th>\n",
       "      <td>42534993</td>\n",
       "      <td>307292215</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Hotel</td>\n",
       "      <td>Hotel room</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20187</th>\n",
       "      <td>42583200</td>\n",
       "      <td>305545617</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>Hotel</td>\n",
       "      <td>Hotel room</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>365</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17593</th>\n",
       "      <td>39948133</td>\n",
       "      <td>126456380</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>4</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             id    host_id neighbourhood_cleansed   property_type  \\\n",
       "6113   21212741   48001186         Miguel Hidalgo       Apartment   \n",
       "6138   21266125   30026600         Miguel Hidalgo            Loft   \n",
       "5653   20435525   64371831             Cuauhtemoc       Apartment   \n",
       "5602   20277868  134853067               Coyoacan          Hostel   \n",
       "4738   18570933   76376610         Miguel Hidalgo            Loft   \n",
       "20122  42534951  113550322             Cuauhtemoc           Hotel   \n",
       "20123  42534965  307295793             Cuauhtemoc  Boutique hotel   \n",
       "20124  42534993  307292215             Cuauhtemoc           Hotel   \n",
       "20187  42583200  305545617             Cuauhtemoc           Hotel   \n",
       "17593  39948133  126456380               Coyoacan           House   \n",
       "\n",
       "             room_type  accommodates  price  minimum_nights  maximum_nights  \\\n",
       "6113      Private room             2      0               1              30   \n",
       "6138   Entire home/apt             3      0               3             400   \n",
       "5653   Entire home/apt             7      0               1              30   \n",
       "5602      Private room             2      0               1            1125   \n",
       "4738   Entire home/apt             2      0               1            1125   \n",
       "20122       Hotel room             2      0               1             365   \n",
       "20123       Hotel room             2      0               1             365   \n",
       "20124       Hotel room             2      0               1             365   \n",
       "20187       Hotel room             2      0               1             365   \n",
       "17593     Private room             4     23               1            1125   \n",
       "\n",
       "       bedrooms  beds          cancellation_policy  number_of_reviews  \\\n",
       "6113        1.0   1.0  strict_14_with_grace_period                 29   \n",
       "6138        0.0   2.0                     flexible                  1   \n",
       "5653        3.0   4.0  strict_14_with_grace_period                105   \n",
       "5602        1.0   1.0                     moderate                  1   \n",
       "4738        1.0   1.0                     flexible                  0   \n",
       "20122       NaN   NaN                     moderate                  0   \n",
       "20123       NaN   NaN                     moderate                  0   \n",
       "20124       NaN   NaN                     moderate                  0   \n",
       "20187       NaN   NaN                     moderate                  0   \n",
       "17593       1.0   2.0                     moderate                  5   \n",
       "\n",
       "       review_scores_accuracy  shared  \n",
       "6113                     10.0   False  \n",
       "6138                     10.0   False  \n",
       "5653                      9.0   False  \n",
       "5602                      6.0   False  \n",
       "4738                      NaN   False  \n",
       "20122                     NaN   False  \n",
       "20123                     NaN   False  \n",
       "20124                     NaN   False  \n",
       "20187                     NaN   False  \n",
       "17593                    10.0   False  "
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "\"\"\" \n",
    "Al mencionar que se quiere ordenar dándole preferencia a aquellas que sean compartidas,\n",
    "se implica que también pueden ser habitaciones no compartidas, entonces, hay que desechar\n",
    "uno de los filtros para permitir habitaciones no compartidas.\n",
    "\"\"\"\n",
    "diana = airbnb[fp & fn]\n",
    "\n",
    "# Agregamos columna auxiliar para ordenar por habitación compartida:\n",
    "diana[\"shared\"] = diana[\"room_type\"] == \"Shared room\"\n",
    "# Y, ahora sí, ordenar:\n",
    "diana = diana.sort_values(by=[\"price\", \"shared\", \"review_scores_accuracy\"], ascending=[True, False, False])\n",
    "diana = diana.head(10)\n",
    "diana"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Obtuvimos propiedades con precio 0,\n",
    "# algo parece estar mal con los registros.\n",
    "\n",
    "# Vamos a eliminar esos registros modificando el filtro de precios.\n",
    "fp = (airbnb[\"price\"] <= presupuesto/noches) & (airbnb[\"price\"] > 0)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "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>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>neighbourhood_cleansed</th>\n",
       "      <th>property_type</th>\n",
       "      <th>room_type</th>\n",
       "      <th>accommodates</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>maximum_nights</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>beds</th>\n",
       "      <th>cancellation_policy</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>review_scores_accuracy</th>\n",
       "      <th>shared</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17593</th>\n",
       "      <td>39948133</td>\n",
       "      <td>126456380</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>4</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19399</th>\n",
       "      <td>41909745</td>\n",
       "      <td>78891216</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5713</th>\n",
       "      <td>20557042</td>\n",
       "      <td>64225887</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>8</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18657</th>\n",
       "      <td>41113140</td>\n",
       "      <td>320683349</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>1125</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>7</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19701</th>\n",
       "      <td>42193723</td>\n",
       "      <td>218080886</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Guest suite</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>1125</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>2</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5675</th>\n",
       "      <td>20476924</td>\n",
       "      <td>136277876</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19147</th>\n",
       "      <td>41642951</td>\n",
       "      <td>160469905</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>46</td>\n",
       "      <td>3</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9428</th>\n",
       "      <td>27552465</td>\n",
       "      <td>163628660</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Private room</td>\n",
       "      <td>1</td>\n",
       "      <td>91</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7728</th>\n",
       "      <td>23877762</td>\n",
       "      <td>179398369</td>\n",
       "      <td>Tlalpan</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>159</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19674</th>\n",
       "      <td>42151081</td>\n",
       "      <td>257679722</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>159</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             id    host_id neighbourhood_cleansed property_type  \\\n",
       "17593  39948133  126456380               Coyoacan         House   \n",
       "19399  41909745   78891216          Benito Juarez         House   \n",
       "5713   20557042   64225887          Benito Juarez     Apartment   \n",
       "18657  41113140  320683349               Coyoacan          Loft   \n",
       "19701  42193723  218080886          Benito Juarez   Guest suite   \n",
       "5675   20476924  136277876             Cuauhtemoc         House   \n",
       "19147  41642951  160469905          Benito Juarez     Apartment   \n",
       "9428   27552465  163628660          Benito Juarez     Apartment   \n",
       "7728   23877762  179398369                Tlalpan          Loft   \n",
       "19674  42151081  257679722               Coyoacan     Apartment   \n",
       "\n",
       "             room_type  accommodates  price  minimum_nights  maximum_nights  \\\n",
       "17593     Private room             4     23               1            1125   \n",
       "19399     Private room             1     23               1              20   \n",
       "5713      Private room             2     45               1               5   \n",
       "18657  Entire home/apt             2     45               2            1125   \n",
       "19701  Entire home/apt             2     45               2            1125   \n",
       "5675      Private room             2     45               1            1125   \n",
       "19147  Entire home/apt             4     46               3            1125   \n",
       "9428      Private room             1     91               1               7   \n",
       "7728       Shared room             1    159               1            1125   \n",
       "19674     Private room             2    159               1            1125   \n",
       "\n",
       "       bedrooms  beds cancellation_policy  number_of_reviews  \\\n",
       "17593       1.0   2.0            moderate                  5   \n",
       "19399       1.0   1.0            moderate                  0   \n",
       "5713        1.0   1.0            flexible                  8   \n",
       "18657       0.0   2.0            moderate                  7   \n",
       "19701       0.0   1.0            flexible                  2   \n",
       "5675        1.0   1.0            flexible                  0   \n",
       "19147       2.0   2.0            flexible                  1   \n",
       "9428        1.0   1.0            flexible                  5   \n",
       "7728        1.0   1.0            flexible                  0   \n",
       "19674       1.0   1.0            flexible                  6   \n",
       "\n",
       "       review_scores_accuracy  shared  \n",
       "17593                    10.0   False  \n",
       "19399                     NaN   False  \n",
       "5713                     10.0   False  \n",
       "18657                    10.0   False  \n",
       "19701                    10.0   False  \n",
       "5675                      NaN   False  \n",
       "19147                    10.0   False  \n",
       "9428                     10.0   False  \n",
       "7728                      NaN    True  \n",
       "19674                    10.0   False  "
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Y repetimos todo lo anterior\n",
    "# Filtrar\n",
    "diana = airbnb[fp & fn].copy()  # <-- Y de una vez nos quitamos el _warning_ de arriba con el copy()\n",
    "# Agregar columna\n",
    "diana[\"shared\"] = diana[\"room_type\"] == \"Shared room\"\n",
    "# Y, ahora sí, ordenar:\n",
    "diana = diana.sort_values(by=[\"price\", \"shared\", \"review_scores_accuracy\"], ascending=[True, False, False])\n",
    "diana = diana.head(10)\n",
    "diana"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Vamos a intentar hacerlo ahora sin agregar la columna extra al DataFrame\n",
    "# (haciendo los cálculos implícitos)\n",
    "\n",
    "# Filtrar\n",
    "diana = airbnb[fp & fn]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>id</th>\n",
       "      <th>host_id</th>\n",
       "      <th>neighbourhood_cleansed</th>\n",
       "      <th>property_type</th>\n",
       "      <th>room_type</th>\n",
       "      <th>accommodates</th>\n",
       "      <th>price</th>\n",
       "      <th>minimum_nights</th>\n",
       "      <th>maximum_nights</th>\n",
       "      <th>bedrooms</th>\n",
       "      <th>beds</th>\n",
       "      <th>cancellation_policy</th>\n",
       "      <th>number_of_reviews</th>\n",
       "      <th>review_scores_accuracy</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>17593</th>\n",
       "      <td>39948133</td>\n",
       "      <td>126456380</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>4</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19399</th>\n",
       "      <td>41909745</td>\n",
       "      <td>78891216</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>1</td>\n",
       "      <td>20</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5713</th>\n",
       "      <td>20557042</td>\n",
       "      <td>64225887</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>8</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18657</th>\n",
       "      <td>41113140</td>\n",
       "      <td>320683349</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>1125</td>\n",
       "      <td>0.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>moderate</td>\n",
       "      <td>7</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19701</th>\n",
       "      <td>42193723</td>\n",
       "      <td>218080886</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Guest suite</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>2</td>\n",
       "      <td>1125</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>2</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5675</th>\n",
       "      <td>20476924</td>\n",
       "      <td>136277876</td>\n",
       "      <td>Cuauhtemoc</td>\n",
       "      <td>House</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>45</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19147</th>\n",
       "      <td>41642951</td>\n",
       "      <td>160469905</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Entire home/apt</td>\n",
       "      <td>4</td>\n",
       "      <td>46</td>\n",
       "      <td>3</td>\n",
       "      <td>1125</td>\n",
       "      <td>2.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>1</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9428</th>\n",
       "      <td>27552465</td>\n",
       "      <td>163628660</td>\n",
       "      <td>Benito Juarez</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Private room</td>\n",
       "      <td>1</td>\n",
       "      <td>91</td>\n",
       "      <td>1</td>\n",
       "      <td>7</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>5</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7728</th>\n",
       "      <td>23877762</td>\n",
       "      <td>179398369</td>\n",
       "      <td>Tlalpan</td>\n",
       "      <td>Loft</td>\n",
       "      <td>Shared room</td>\n",
       "      <td>1</td>\n",
       "      <td>159</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19674</th>\n",
       "      <td>42151081</td>\n",
       "      <td>257679722</td>\n",
       "      <td>Coyoacan</td>\n",
       "      <td>Apartment</td>\n",
       "      <td>Private room</td>\n",
       "      <td>2</td>\n",
       "      <td>159</td>\n",
       "      <td>1</td>\n",
       "      <td>1125</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>flexible</td>\n",
       "      <td>6</td>\n",
       "      <td>10.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             id    host_id neighbourhood_cleansed property_type  \\\n",
       "17593  39948133  126456380               Coyoacan         House   \n",
       "19399  41909745   78891216          Benito Juarez         House   \n",
       "5713   20557042   64225887          Benito Juarez     Apartment   \n",
       "18657  41113140  320683349               Coyoacan          Loft   \n",
       "19701  42193723  218080886          Benito Juarez   Guest suite   \n",
       "5675   20476924  136277876             Cuauhtemoc         House   \n",
       "19147  41642951  160469905          Benito Juarez     Apartment   \n",
       "9428   27552465  163628660          Benito Juarez     Apartment   \n",
       "7728   23877762  179398369                Tlalpan          Loft   \n",
       "19674  42151081  257679722               Coyoacan     Apartment   \n",
       "\n",
       "             room_type  accommodates  price  minimum_nights  maximum_nights  \\\n",
       "17593     Private room             4     23               1            1125   \n",
       "19399     Private room             1     23               1              20   \n",
       "5713      Private room             2     45               1               5   \n",
       "18657  Entire home/apt             2     45               2            1125   \n",
       "19701  Entire home/apt             2     45               2            1125   \n",
       "5675      Private room             2     45               1            1125   \n",
       "19147  Entire home/apt             4     46               3            1125   \n",
       "9428      Private room             1     91               1               7   \n",
       "7728       Shared room             1    159               1            1125   \n",
       "19674     Private room             2    159               1            1125   \n",
       "\n",
       "       bedrooms  beds cancellation_policy  number_of_reviews  \\\n",
       "17593       1.0   2.0            moderate                  5   \n",
       "19399       1.0   1.0            moderate                  0   \n",
       "5713        1.0   1.0            flexible                  8   \n",
       "18657       0.0   2.0            moderate                  7   \n",
       "19701       0.0   1.0            flexible                  2   \n",
       "5675        1.0   1.0            flexible                  0   \n",
       "19147       2.0   2.0            flexible                  1   \n",
       "9428        1.0   1.0            flexible                  5   \n",
       "7728        1.0   1.0            flexible                  0   \n",
       "19674       1.0   1.0            flexible                  6   \n",
       "\n",
       "       review_scores_accuracy  \n",
       "17593                    10.0  \n",
       "19399                     NaN  \n",
       "5713                     10.0  \n",
       "18657                    10.0  \n",
       "19701                    10.0  \n",
       "5675                      NaN  \n",
       "19147                    10.0  \n",
       "9428                     10.0  \n",
       "7728                      NaN  \n",
       "19674                    10.0  "
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Construir un DataFrame auxiliar con las columnas de ordenación\n",
    "df_p = diana[\"price\"]\n",
    "df_r = diana[\"room_type\"].where(diana[\"room_type\"]==\"Shared room\", other=\"ZZZ\")\n",
    "df_s = diana[\"review_scores_accuracy\"]\n",
    "orden = pd.concat([df_p, df_r, df_s], axis=1)\n",
    "orden.columns = [\"price\", \"room\", \"score\"]\n",
    "# Ordenar el DataFrame auxiliar\n",
    "orden = orden.sort_values(by=[\"price\", \"room\", \"score\"], ascending=[True, True, False])\n",
    "# Usar los índices del DataFrame auxiliar para ordenar\n",
    "diana = diana.loc[orden.index]\n",
    "# Solo las primeras 10 opciones\n",
    "diana = diana.head(10)\n",
    "diana"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Sí se pudo ordenar sin agregar la columna auxiliar. Sin embargo, el proceso de crear el DataFrame auxiliar es mucho más complejo que crear la columna auxiliar. Si se hubiera hecho como se pretendía (haciendo los cálculos implícitos), el código hubiera quedado aún más complicado."
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}