MashvisorTopMarkets.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 59,
   "id": "japanese-universe",
   "metadata": {},
   "outputs": [],
   "source": [
    "import requests\n",
    "r_mia_fl = requests.get(\"https://api.mashvisor.com/v1.1/client/airbnb-property/market-summary?state=FL&city=Miami\", headers={'x-api-key':'5725594e-0d74-42f4-b436-1c822771152b'})\n",
    "r_orl_fl = requests.get(\"https://api.mashvisor.com/v1.1/client/airbnb-property/market-summary?state=FL&city=Orlando\", headers={'x-api-key':'5725594e-0d74-42f4-b436-1c822771152b'})\n",
    "r_tpa_fl = requests.get(\"https://api.mashvisor.com/v1.1/client/airbnb-property/market-summary?state=FL&city=Tampa\", headers={'x-api-key':'5725594e-0d74-42f4-b436-1c822771152b'})\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 86,
   "id": "complicated-arctic",
   "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>Property Type</th>\n",
       "      <th>Yearly Occupancy</th>\n",
       "      <th>nightly rate</th>\n",
       "      <th>Monthly Rental Income</th>\n",
       "      <th>Listing_ID</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>'House',</td>\n",
       "      <td>34,</td>\n",
       "      <td>321,</td>\n",
       "      <td>3317,</td>\n",
       "      <td>10000216',</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>43,</td>\n",
       "      <td>81,</td>\n",
       "      <td>1077,</td>\n",
       "      <td>10387018',</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>House',</td>\n",
       "      <td>49,</td>\n",
       "      <td>168,</td>\n",
       "      <td>2503,</td>\n",
       "      <td>1048614',</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>56,</td>\n",
       "      <td>93,</td>\n",
       "      <td>1573,</td>\n",
       "      <td>10730815',</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Loft',</td>\n",
       "      <td>78,</td>\n",
       "      <td>312,</td>\n",
       "      <td>7410,</td>\n",
       "      <td>11014976',</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>995</th>\n",
       "      <td>House',</td>\n",
       "      <td>75,</td>\n",
       "      <td>110,</td>\n",
       "      <td>2493,</td>\n",
       "      <td>7272204',</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Guesthouse',</td>\n",
       "      <td>64,</td>\n",
       "      <td>53,</td>\n",
       "      <td>1042,</td>\n",
       "      <td>7396280',</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>0,</td>\n",
       "      <td>255,</td>\n",
       "      <td>0,</td>\n",
       "      <td>773911',</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Guesthouse',</td>\n",
       "      <td>67,</td>\n",
       "      <td>95,</td>\n",
       "      <td>1924,</td>\n",
       "      <td>775360',</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Guesthouse',</td>\n",
       "      <td>62,</td>\n",
       "      <td>122,</td>\n",
       "      <td>2288,</td>\n",
       "      <td>7837157',</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Property Type Yearly Occupancy nightly rate Monthly Rental Income  \\\n",
       "0        'House',              34,         321,                 3317,   \n",
       "1     Apartment',              43,          81,                 1077,   \n",
       "2         House',              49,         168,                 2503,   \n",
       "3     Apartment',              56,          93,                 1573,   \n",
       "4          Loft',              78,         312,                 7410,   \n",
       "..            ...              ...          ...                   ...   \n",
       "995       House',              75,         110,                 2493,   \n",
       "996  Guesthouse',              64,          53,                 1042,   \n",
       "997   Apartment',               0,         255,                    0,   \n",
       "998  Guesthouse',              67,          95,                 1924,   \n",
       "999  Guesthouse',              62,         122,                 2288,   \n",
       "\n",
       "     Listing_ID  \n",
       "0    10000216',  \n",
       "1    10387018',  \n",
       "2     1048614',  \n",
       "3    10730815',  \n",
       "4    11014976',  \n",
       "..          ...  \n",
       "995   7272204',  \n",
       "996   7396280',  \n",
       "997    773911',  \n",
       "998    775360',  \n",
       "999   7837157',  \n",
       "\n",
       "[1000 rows x 5 columns]"
      ]
     },
     "execution_count": 86,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "r_abnb_mia = pd.read_csv('miami_airbnb.csv', index_col=False)\n",
    "r_abnb_mia"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "id": "quantitative-audience",
   "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>Property Type</th>\n",
       "      <th>Listing_ID</th>\n",
       "      <th>Yearly Occupancy</th>\n",
       "      <th>nightly rate</th>\n",
       "      <th>Monthly Rental Income</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>'House',</td>\n",
       "      <td>10000216',</td>\n",
       "      <td>34,</td>\n",
       "      <td>321,</td>\n",
       "      <td>3317,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>10387018',</td>\n",
       "      <td>43,</td>\n",
       "      <td>81,</td>\n",
       "      <td>1077,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>House',</td>\n",
       "      <td>1048614',</td>\n",
       "      <td>49,</td>\n",
       "      <td>168,</td>\n",
       "      <td>2503,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>10730815',</td>\n",
       "      <td>56,</td>\n",
       "      <td>93,</td>\n",
       "      <td>1573,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Loft',</td>\n",
       "      <td>11014976',</td>\n",
       "      <td>78,</td>\n",
       "      <td>312,</td>\n",
       "      <td>7410,</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>995</th>\n",
       "      <td>House',</td>\n",
       "      <td>7272204',</td>\n",
       "      <td>75,</td>\n",
       "      <td>110,</td>\n",
       "      <td>2493,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>Guesthouse',</td>\n",
       "      <td>7396280',</td>\n",
       "      <td>64,</td>\n",
       "      <td>53,</td>\n",
       "      <td>1042,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>773911',</td>\n",
       "      <td>0,</td>\n",
       "      <td>255,</td>\n",
       "      <td>0,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>Guesthouse',</td>\n",
       "      <td>775360',</td>\n",
       "      <td>67,</td>\n",
       "      <td>95,</td>\n",
       "      <td>1924,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>Guesthouse',</td>\n",
       "      <td>7837157',</td>\n",
       "      <td>62,</td>\n",
       "      <td>122,</td>\n",
       "      <td>2288,</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Property Type  Listing_ID Yearly Occupancy nightly rate  \\\n",
       "0        'House',  10000216',              34,         321,   \n",
       "1     Apartment',  10387018',              43,          81,   \n",
       "2         House',   1048614',              49,         168,   \n",
       "3     Apartment',  10730815',              56,          93,   \n",
       "4          Loft',  11014976',              78,         312,   \n",
       "..            ...         ...              ...          ...   \n",
       "995       House',   7272204',              75,         110,   \n",
       "996  Guesthouse',   7396280',              64,          53,   \n",
       "997   Apartment',    773911',               0,         255,   \n",
       "998  Guesthouse',    775360',              67,          95,   \n",
       "999  Guesthouse',   7837157',              62,         122,   \n",
       "\n",
       "    Monthly Rental Income  \n",
       "0                   3317,  \n",
       "1                   1077,  \n",
       "2                   2503,  \n",
       "3                   1573,  \n",
       "4                   7410,  \n",
       "..                    ...  \n",
       "995                 2493,  \n",
       "996                 1042,  \n",
       "997                    0,  \n",
       "998                 1924,  \n",
       "999                 2288,  \n",
       "\n",
       "[1000 rows x 5 columns]"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_abnb_miafl = r_abnb_mia[['Property Type', 'Listing_ID', 'Yearly Occupancy', 'nightly rate', 'Monthly Rental Income']]\n",
    "r_abnb_miafl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 88,
   "id": "bacterial-indication",
   "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>Property Type</th>\n",
       "      <th>Listing_ID</th>\n",
       "      <th>Yearly Occupancy</th>\n",
       "      <th>nightly rate</th>\n",
       "      <th>Monthly Rental Income</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>'House',</td>\n",
       "      <td>10000216',</td>\n",
       "      <td>34,</td>\n",
       "      <td>321,</td>\n",
       "      <td>3317,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>679</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>43441692',</td>\n",
       "      <td>58,</td>\n",
       "      <td>162,</td>\n",
       "      <td>2851,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>680</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>43442892',</td>\n",
       "      <td>43,</td>\n",
       "      <td>309,</td>\n",
       "      <td>4079,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>684</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>43473010',</td>\n",
       "      <td>16,</td>\n",
       "      <td>199,</td>\n",
       "      <td>945,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>686</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>43484722',</td>\n",
       "      <td>60,</td>\n",
       "      <td>118,</td>\n",
       "      <td>2085,</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>952</th>\n",
       "      <td>Villa',</td>\n",
       "      <td>47884705',</td>\n",
       "      <td>84,</td>\n",
       "      <td>2696,</td>\n",
       "      <td>67400,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Villa',</td>\n",
       "      <td>13154644',</td>\n",
       "      <td>50,</td>\n",
       "      <td>1936,</td>\n",
       "      <td>29685,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>657</th>\n",
       "      <td>Villa',</td>\n",
       "      <td>42995144',</td>\n",
       "      <td>47,</td>\n",
       "      <td>587,</td>\n",
       "      <td>8316,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>751</th>\n",
       "      <td>Villa',</td>\n",
       "      <td>44647556',</td>\n",
       "      <td>14,</td>\n",
       "      <td>3250,</td>\n",
       "      <td>13464,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>930</th>\n",
       "      <td>Villa',</td>\n",
       "      <td>47378127',</td>\n",
       "      <td>49,</td>\n",
       "      <td>556,</td>\n",
       "      <td>8155,</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Property Type  Listing_ID Yearly Occupancy nightly rate  \\\n",
       "0        'House',  10000216',              34,         321,   \n",
       "679   Apartment',  43441692',              58,         162,   \n",
       "680   Apartment',  43442892',              43,         309,   \n",
       "684   Apartment',  43473010',              16,         199,   \n",
       "686   Apartment',  43484722',              60,         118,   \n",
       "..            ...         ...              ...          ...   \n",
       "952       Villa',  47884705',              84,        2696,   \n",
       "31        Villa',  13154644',              50,        1936,   \n",
       "657       Villa',  42995144',              47,         587,   \n",
       "751       Villa',  44647556',              14,        3250,   \n",
       "930       Villa',  47378127',              49,         556,   \n",
       "\n",
       "    Monthly Rental Income  \n",
       "0                   3317,  \n",
       "679                 2851,  \n",
       "680                 4079,  \n",
       "684                  945,  \n",
       "686                 2085,  \n",
       "..                    ...  \n",
       "952                67400,  \n",
       "31                 29685,  \n",
       "657                 8316,  \n",
       "751                13464,  \n",
       "930                 8155,  \n",
       "\n",
       "[1000 rows x 5 columns]"
      ]
     },
     "execution_count": 88,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_abnb_miafl.sort_values(\"Property Type\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "id": "conventional-acquisition",
   "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>Property Type</th>\n",
       "      <th>Listing IDs</th>\n",
       "      <th>Occupancy</th>\n",
       "      <th>Nightly Rate</th>\n",
       "      <th>Monthly Income</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'10660163',</td>\n",
       "      <td>86,</td>\n",
       "      <td>58,</td>\n",
       "      <td>1513,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'1225005',</td>\n",
       "      <td>52,</td>\n",
       "      <td>88,</td>\n",
       "      <td>1393,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'13299876',</td>\n",
       "      <td>53,</td>\n",
       "      <td>136,</td>\n",
       "      <td>2210,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'13625502',</td>\n",
       "      <td>85,</td>\n",
       "      <td>57,</td>\n",
       "      <td>1477,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'14666499',</td>\n",
       "      <td>36,</td>\n",
       "      <td>80,</td>\n",
       "      <td>860,</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>550</th>\n",
       "      <td>'Townhouse',</td>\n",
       "      <td>'47069109',</td>\n",
       "      <td>89,</td>\n",
       "      <td>75,</td>\n",
       "      <td>2006,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>551</th>\n",
       "      <td>'Townhouse',</td>\n",
       "      <td>'48282384',</td>\n",
       "      <td>90,</td>\n",
       "      <td>96,</td>\n",
       "      <td>2640,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552</th>\n",
       "      <td>'Villa',</td>\n",
       "      <td>'39504775',</td>\n",
       "      <td>68,</td>\n",
       "      <td>106,</td>\n",
       "      <td>2191,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>553</th>\n",
       "      <td>'Villa',</td>\n",
       "      <td>'47817690',</td>\n",
       "      <td>41,</td>\n",
       "      <td>104,</td>\n",
       "      <td>1274,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>554</th>\n",
       "      <td>Apartment',</td>\n",
       "      <td>'10117384',</td>\n",
       "      <td>25,</td>\n",
       "      <td>101,</td>\n",
       "      <td>766,</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>555 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Property Type     Listing IDs Occupancy Nightly Rate Monthly Income\n",
       "0        'Apartment',     '10660163',       86,          58,          1513,\n",
       "1        'Apartment',      '1225005',       52,          88,          1393,\n",
       "2        'Apartment',     '13299876',       53,         136,          2210,\n",
       "3        'Apartment',     '13625502',       85,          57,          1477,\n",
       "4        'Apartment',     '14666499',       36,          80,           860,\n",
       "..                ...             ...       ...          ...            ...\n",
       "550      'Townhouse',     '47069109',       89,          75,          2006,\n",
       "551      'Townhouse',     '48282384',       90,          96,          2640,\n",
       "552          'Villa',     '39504775',       68,         106,          2191,\n",
       "553          'Villa',     '47817690',       41,         104,          1274,\n",
       "554       Apartment',     '10117384',       25,         101,           766,\n",
       "\n",
       "[555 rows x 5 columns]"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_abnb_orl = pd.read_csv('orlando_airbnb.csv', index_col=False)\n",
    "r_abnb_orl"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 90,
   "id": "played-great",
   "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>Property Type</th>\n",
       "      <th>Listing Ids</th>\n",
       "      <th>Occupancy</th>\n",
       "      <th>Nightly Rate</th>\n",
       "      <th>Monthly Rental Income</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>'Apartment'</td>\n",
       "      <td>'9653554'</td>\n",
       "      <td>87</td>\n",
       "      <td>52</td>\n",
       "      <td>1376</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'10811316',</td>\n",
       "      <td>93,</td>\n",
       "      <td>59,</td>\n",
       "      <td>1677,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'11047853',</td>\n",
       "      <td>22,</td>\n",
       "      <td>134,</td>\n",
       "      <td>884,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'11161764',</td>\n",
       "      <td>30,</td>\n",
       "      <td>103,</td>\n",
       "      <td>936,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>'Apartment',</td>\n",
       "      <td>'12157281',</td>\n",
       "      <td>87,</td>\n",
       "      <td>50,</td>\n",
       "      <td>1321,</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>763</th>\n",
       "      <td>'Villa',</td>\n",
       "      <td>'43148625',</td>\n",
       "      <td>41,</td>\n",
       "      <td>1118,</td>\n",
       "      <td>13975,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>764</th>\n",
       "      <td>'Villa',</td>\n",
       "      <td>'43676838',</td>\n",
       "      <td>71,</td>\n",
       "      <td>75,</td>\n",
       "      <td>1625,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>765</th>\n",
       "      <td>'Villa',</td>\n",
       "      <td>'44341318',</td>\n",
       "      <td>70,</td>\n",
       "      <td>111,</td>\n",
       "      <td>2387,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>766</th>\n",
       "      <td>'Villa',</td>\n",
       "      <td>'47788136',</td>\n",
       "      <td>90,</td>\n",
       "      <td>350,</td>\n",
       "      <td>9625,</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>767</th>\n",
       "      <td>'House',</td>\n",
       "      <td>'10193097',</td>\n",
       "      <td>35,</td>\n",
       "      <td>160,</td>\n",
       "      <td>1696,</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>768 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Property Type     Listing Ids Occupancy Nightly Rate  \\\n",
       "0         'Apartment'       '9653554'        87           52   \n",
       "1        'Apartment',     '10811316',       93,          59,   \n",
       "2        'Apartment',     '11047853',       22,         134,   \n",
       "3        'Apartment',     '11161764',       30,         103,   \n",
       "4        'Apartment',     '12157281',       87,          50,   \n",
       "..                ...             ...       ...          ...   \n",
       "763          'Villa',     '43148625',       41,        1118,   \n",
       "764          'Villa',     '43676838',       71,          75,   \n",
       "765          'Villa',     '44341318',       70,         111,   \n",
       "766          'Villa',     '47788136',       90,         350,   \n",
       "767          'House',     '10193097',       35,         160,   \n",
       "\n",
       "    Monthly Rental Income  \n",
       "0                    1376  \n",
       "1                   1677,  \n",
       "2                    884,  \n",
       "3                    936,  \n",
       "4                   1321,  \n",
       "..                    ...  \n",
       "763                13975,  \n",
       "764                 1625,  \n",
       "765                 2387,  \n",
       "766                 9625,  \n",
       "767                 1696,  \n",
       "\n",
       "[768 rows x 5 columns]"
      ]
     },
     "execution_count": 90,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_abnb_tpa = pd.read_csv('tampa_airbnb.csv', index_col=False)\n",
    "r_abnb_tpa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "id": "adjusted-murray",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method Response.json of <Response [401]>>"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "rinv_mia = requests.get(\"https://api.mashvisor.com/v1.1/client/property/43148625/investment?state=FL&payment_type=loan&interest_rate=0.5&loan_type=1&down_payment=100\", headers={'x-api-key':'5725594e-0d74-42f4-b436-1c822771152b'})\n",
    "rinv_mia.json"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "id": "collectible-recovery",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': 'success',\n",
       " 'content': {'median_price': 270000,\n",
       "  'sqft': 1626.08,\n",
       "  'investment_properties': 591,\n",
       "  'airbnb_properties': 2865,\n",
       "  'traditional_properties': 2702,\n",
       "  'occupancy': 55,\n",
       "  'traditional_coc': 3.00441,\n",
       "  'airbnb_coc': 1.02023,\n",
       "  'traditional_rental': 1569.38,\n",
       "  'airbnb_rental': 1520.83,\n",
       "  'airbnb_rental_rates': {'zeroBedRoomHomeValue': 1045.93,\n",
       "   'oneBedRoomHomeValue': 1102.14,\n",
       "   'twoBedRoomsHomeValue': 1258.97,\n",
       "   'threeBedRoomsHomeValue': 1968.06,\n",
       "   'fourBedRoomsHomeValue': 3273.24},\n",
       "  'traditional_rental_rates': {'zeroBedRoomHomeValue': 1095.74,\n",
       "   'oneBedRoomHomeValue': 1066.39,\n",
       "   'twoBedRoomsHomeValue': 1271.45,\n",
       "   'threeBedRoomsHomeValue': 1606.48,\n",
       "   'fourBedRoomsHomeValue': 2047.15}},\n",
       " 'message': 'City Overview fetched successfully'}"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_orl_fl = requests.get(\"https://api.mashvisor.com/v1.1/client/city/investment/FL/Orlando\", headers={'x-api-key':'7b9581e3-5b45-4fbc-8f59-d3379db49449'})\n",
    "orlando=r_orl_fl.json()\n",
    "orlando"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 108,
   "id": "hydraulic-clerk",
   "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>median_price</th>\n",
       "      <th>sqft</th>\n",
       "      <th>investment_properties</th>\n",
       "      <th>airbnb_properties</th>\n",
       "      <th>traditional_properties</th>\n",
       "      <th>occupancy</th>\n",
       "      <th>traditional_coc</th>\n",
       "      <th>airbnb_coc</th>\n",
       "      <th>traditional_rental</th>\n",
       "      <th>airbnb_rental</th>\n",
       "      <th>airbnb_rental_rates</th>\n",
       "      <th>traditional_rental_rates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zeroBedRoomHomeValue</th>\n",
       "      <td>270000</td>\n",
       "      <td>1626.08</td>\n",
       "      <td>591</td>\n",
       "      <td>2865</td>\n",
       "      <td>2702</td>\n",
       "      <td>55</td>\n",
       "      <td>3.00441</td>\n",
       "      <td>1.02023</td>\n",
       "      <td>1569.38</td>\n",
       "      <td>1520.83</td>\n",
       "      <td>1045.93</td>\n",
       "      <td>1095.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oneBedRoomHomeValue</th>\n",
       "      <td>270000</td>\n",
       "      <td>1626.08</td>\n",
       "      <td>591</td>\n",
       "      <td>2865</td>\n",
       "      <td>2702</td>\n",
       "      <td>55</td>\n",
       "      <td>3.00441</td>\n",
       "      <td>1.02023</td>\n",
       "      <td>1569.38</td>\n",
       "      <td>1520.83</td>\n",
       "      <td>1102.14</td>\n",
       "      <td>1066.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>twoBedRoomsHomeValue</th>\n",
       "      <td>270000</td>\n",
       "      <td>1626.08</td>\n",
       "      <td>591</td>\n",
       "      <td>2865</td>\n",
       "      <td>2702</td>\n",
       "      <td>55</td>\n",
       "      <td>3.00441</td>\n",
       "      <td>1.02023</td>\n",
       "      <td>1569.38</td>\n",
       "      <td>1520.83</td>\n",
       "      <td>1258.97</td>\n",
       "      <td>1271.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>threeBedRoomsHomeValue</th>\n",
       "      <td>270000</td>\n",
       "      <td>1626.08</td>\n",
       "      <td>591</td>\n",
       "      <td>2865</td>\n",
       "      <td>2702</td>\n",
       "      <td>55</td>\n",
       "      <td>3.00441</td>\n",
       "      <td>1.02023</td>\n",
       "      <td>1569.38</td>\n",
       "      <td>1520.83</td>\n",
       "      <td>1968.06</td>\n",
       "      <td>1606.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fourBedRoomsHomeValue</th>\n",
       "      <td>270000</td>\n",
       "      <td>1626.08</td>\n",
       "      <td>591</td>\n",
       "      <td>2865</td>\n",
       "      <td>2702</td>\n",
       "      <td>55</td>\n",
       "      <td>3.00441</td>\n",
       "      <td>1.02023</td>\n",
       "      <td>1569.38</td>\n",
       "      <td>1520.83</td>\n",
       "      <td>3273.24</td>\n",
       "      <td>2047.15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        median_price     sqft  investment_properties  \\\n",
       "zeroBedRoomHomeValue          270000  1626.08                    591   \n",
       "oneBedRoomHomeValue           270000  1626.08                    591   \n",
       "twoBedRoomsHomeValue          270000  1626.08                    591   \n",
       "threeBedRoomsHomeValue        270000  1626.08                    591   \n",
       "fourBedRoomsHomeValue         270000  1626.08                    591   \n",
       "\n",
       "                        airbnb_properties  traditional_properties  occupancy  \\\n",
       "zeroBedRoomHomeValue                 2865                    2702         55   \n",
       "oneBedRoomHomeValue                  2865                    2702         55   \n",
       "twoBedRoomsHomeValue                 2865                    2702         55   \n",
       "threeBedRoomsHomeValue               2865                    2702         55   \n",
       "fourBedRoomsHomeValue                2865                    2702         55   \n",
       "\n",
       "                        traditional_coc  airbnb_coc  traditional_rental  \\\n",
       "zeroBedRoomHomeValue            3.00441     1.02023             1569.38   \n",
       "oneBedRoomHomeValue             3.00441     1.02023             1569.38   \n",
       "twoBedRoomsHomeValue            3.00441     1.02023             1569.38   \n",
       "threeBedRoomsHomeValue          3.00441     1.02023             1569.38   \n",
       "fourBedRoomsHomeValue           3.00441     1.02023             1569.38   \n",
       "\n",
       "                        airbnb_rental  airbnb_rental_rates  \\\n",
       "zeroBedRoomHomeValue          1520.83              1045.93   \n",
       "oneBedRoomHomeValue           1520.83              1102.14   \n",
       "twoBedRoomsHomeValue          1520.83              1258.97   \n",
       "threeBedRoomsHomeValue        1520.83              1968.06   \n",
       "fourBedRoomsHomeValue         1520.83              3273.24   \n",
       "\n",
       "                        traditional_rental_rates  \n",
       "zeroBedRoomHomeValue                     1095.74  \n",
       "oneBedRoomHomeValue                      1066.39  \n",
       "twoBedRoomsHomeValue                     1271.45  \n",
       "threeBedRoomsHomeValue                   1606.48  \n",
       "fourBedRoomsHomeValue                    2047.15  "
      ]
     },
     "execution_count": 108,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orl_df = pd.DataFrame.from_dict(orlando['content'])\n",
    "orl_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 115,
   "id": "classified-volume",
   "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>airbnb_properties</th>\n",
       "      <th>airbnb_rental_rates</th>\n",
       "      <th>traditional_properties</th>\n",
       "      <th>traditional_rental_rates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zeroBedRoomHomeValue</th>\n",
       "      <td>2865</td>\n",
       "      <td>1045.93</td>\n",
       "      <td>2702</td>\n",
       "      <td>1095.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oneBedRoomHomeValue</th>\n",
       "      <td>2865</td>\n",
       "      <td>1102.14</td>\n",
       "      <td>2702</td>\n",
       "      <td>1066.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>twoBedRoomsHomeValue</th>\n",
       "      <td>2865</td>\n",
       "      <td>1258.97</td>\n",
       "      <td>2702</td>\n",
       "      <td>1271.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>threeBedRoomsHomeValue</th>\n",
       "      <td>2865</td>\n",
       "      <td>1968.06</td>\n",
       "      <td>2702</td>\n",
       "      <td>1606.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fourBedRoomsHomeValue</th>\n",
       "      <td>2865</td>\n",
       "      <td>3273.24</td>\n",
       "      <td>2702</td>\n",
       "      <td>2047.15</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        airbnb_properties  airbnb_rental_rates  \\\n",
       "zeroBedRoomHomeValue                 2865              1045.93   \n",
       "oneBedRoomHomeValue                  2865              1102.14   \n",
       "twoBedRoomsHomeValue                 2865              1258.97   \n",
       "threeBedRoomsHomeValue               2865              1968.06   \n",
       "fourBedRoomsHomeValue                2865              3273.24   \n",
       "\n",
       "                        traditional_properties  traditional_rental_rates  \n",
       "zeroBedRoomHomeValue                      2702                   1095.74  \n",
       "oneBedRoomHomeValue                       2702                   1066.39  \n",
       "twoBedRoomsHomeValue                      2702                   1271.45  \n",
       "threeBedRoomsHomeValue                    2702                   1606.48  \n",
       "fourBedRoomsHomeValue                     2702                   2047.15  "
      ]
     },
     "execution_count": 115,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "orl_df_drop = orl_df.drop(columns=['median_price', 'sqft','investment_properties', 'occupancy', 'traditional_coc', 'airbnb_coc', 'traditional_rental', 'airbnb_rental'])\n",
    "orl_df_columns = orl_df_drop[['airbnb_properties','airbnb_rental_rates','traditional_properties','traditional_rental_rates']]\n",
    "orl_df_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "id": "understood-vatican",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': 'success',\n",
       " 'content': {'median_price': 450000,\n",
       "  'sqft': 1512.72,\n",
       "  'investment_properties': 2988,\n",
       "  'airbnb_properties': 1884,\n",
       "  'traditional_properties': 10590,\n",
       "  'occupancy': 57,\n",
       "  'traditional_coc': 1.9147,\n",
       "  'airbnb_coc': 1.04562,\n",
       "  'traditional_rental': 2139,\n",
       "  'airbnb_rental': 2955.59,\n",
       "  'airbnb_rental_rates': {'zeroBedRoomHomeValue': 1259.78,\n",
       "   'oneBedRoomHomeValue': 1281.78,\n",
       "   'twoBedRoomsHomeValue': 2068.41,\n",
       "   'threeBedRoomsHomeValue': 3719.14,\n",
       "   'fourBedRoomsHomeValue': 6054.51},\n",
       "  'traditional_rental_rates': {'zeroBedRoomHomeValue': 1170.23,\n",
       "   'oneBedRoomHomeValue': 1443.92,\n",
       "   'twoBedRoomsHomeValue': 2103.53,\n",
       "   'threeBedRoomsHomeValue': 3028.03,\n",
       "   'fourBedRoomsHomeValue': 5215.58}},\n",
       " 'message': 'City Overview fetched successfully'}"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_mia_fl = requests.get(\"https://api.mashvisor.com/v1.1/client/city/investment/FL/Miami\", headers={'x-api-key':'7b9581e3-5b45-4fbc-8f59-d3379db49449'}) \n",
    "miami = r_mia_fl.json()\n",
    "miami"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "id": "voluntary-suffering",
   "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>median_price</th>\n",
       "      <th>sqft</th>\n",
       "      <th>investment_properties</th>\n",
       "      <th>airbnb_properties</th>\n",
       "      <th>traditional_properties</th>\n",
       "      <th>occupancy</th>\n",
       "      <th>traditional_coc</th>\n",
       "      <th>airbnb_coc</th>\n",
       "      <th>traditional_rental</th>\n",
       "      <th>airbnb_rental</th>\n",
       "      <th>airbnb_rental_rates</th>\n",
       "      <th>traditional_rental_rates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zeroBedRoomHomeValue</th>\n",
       "      <td>450000</td>\n",
       "      <td>1512.72</td>\n",
       "      <td>2988</td>\n",
       "      <td>1884</td>\n",
       "      <td>10590</td>\n",
       "      <td>57</td>\n",
       "      <td>1.9147</td>\n",
       "      <td>1.04562</td>\n",
       "      <td>2139</td>\n",
       "      <td>2955.59</td>\n",
       "      <td>1259.78</td>\n",
       "      <td>1170.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oneBedRoomHomeValue</th>\n",
       "      <td>450000</td>\n",
       "      <td>1512.72</td>\n",
       "      <td>2988</td>\n",
       "      <td>1884</td>\n",
       "      <td>10590</td>\n",
       "      <td>57</td>\n",
       "      <td>1.9147</td>\n",
       "      <td>1.04562</td>\n",
       "      <td>2139</td>\n",
       "      <td>2955.59</td>\n",
       "      <td>1281.78</td>\n",
       "      <td>1443.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>twoBedRoomsHomeValue</th>\n",
       "      <td>450000</td>\n",
       "      <td>1512.72</td>\n",
       "      <td>2988</td>\n",
       "      <td>1884</td>\n",
       "      <td>10590</td>\n",
       "      <td>57</td>\n",
       "      <td>1.9147</td>\n",
       "      <td>1.04562</td>\n",
       "      <td>2139</td>\n",
       "      <td>2955.59</td>\n",
       "      <td>2068.41</td>\n",
       "      <td>2103.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>threeBedRoomsHomeValue</th>\n",
       "      <td>450000</td>\n",
       "      <td>1512.72</td>\n",
       "      <td>2988</td>\n",
       "      <td>1884</td>\n",
       "      <td>10590</td>\n",
       "      <td>57</td>\n",
       "      <td>1.9147</td>\n",
       "      <td>1.04562</td>\n",
       "      <td>2139</td>\n",
       "      <td>2955.59</td>\n",
       "      <td>3719.14</td>\n",
       "      <td>3028.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fourBedRoomsHomeValue</th>\n",
       "      <td>450000</td>\n",
       "      <td>1512.72</td>\n",
       "      <td>2988</td>\n",
       "      <td>1884</td>\n",
       "      <td>10590</td>\n",
       "      <td>57</td>\n",
       "      <td>1.9147</td>\n",
       "      <td>1.04562</td>\n",
       "      <td>2139</td>\n",
       "      <td>2955.59</td>\n",
       "      <td>6054.51</td>\n",
       "      <td>5215.58</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        median_price     sqft  investment_properties  \\\n",
       "zeroBedRoomHomeValue          450000  1512.72                   2988   \n",
       "oneBedRoomHomeValue           450000  1512.72                   2988   \n",
       "twoBedRoomsHomeValue          450000  1512.72                   2988   \n",
       "threeBedRoomsHomeValue        450000  1512.72                   2988   \n",
       "fourBedRoomsHomeValue         450000  1512.72                   2988   \n",
       "\n",
       "                        airbnb_properties  traditional_properties  occupancy  \\\n",
       "zeroBedRoomHomeValue                 1884                   10590         57   \n",
       "oneBedRoomHomeValue                  1884                   10590         57   \n",
       "twoBedRoomsHomeValue                 1884                   10590         57   \n",
       "threeBedRoomsHomeValue               1884                   10590         57   \n",
       "fourBedRoomsHomeValue                1884                   10590         57   \n",
       "\n",
       "                        traditional_coc  airbnb_coc  traditional_rental  \\\n",
       "zeroBedRoomHomeValue             1.9147     1.04562                2139   \n",
       "oneBedRoomHomeValue              1.9147     1.04562                2139   \n",
       "twoBedRoomsHomeValue             1.9147     1.04562                2139   \n",
       "threeBedRoomsHomeValue           1.9147     1.04562                2139   \n",
       "fourBedRoomsHomeValue            1.9147     1.04562                2139   \n",
       "\n",
       "                        airbnb_rental  airbnb_rental_rates  \\\n",
       "zeroBedRoomHomeValue          2955.59              1259.78   \n",
       "oneBedRoomHomeValue           2955.59              1281.78   \n",
       "twoBedRoomsHomeValue          2955.59              2068.41   \n",
       "threeBedRoomsHomeValue        2955.59              3719.14   \n",
       "fourBedRoomsHomeValue         2955.59              6054.51   \n",
       "\n",
       "                        traditional_rental_rates  \n",
       "zeroBedRoomHomeValue                     1170.23  \n",
       "oneBedRoomHomeValue                      1443.92  \n",
       "twoBedRoomsHomeValue                     2103.53  \n",
       "threeBedRoomsHomeValue                   3028.03  \n",
       "fourBedRoomsHomeValue                    5215.58  "
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "miami_df = pd.DataFrame.from_dict(miami['content'])\n",
    "miami_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "civic-valuation",
   "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>airbnb_properties</th>\n",
       "      <th>airbnb_rental_rates</th>\n",
       "      <th>traditional_properties</th>\n",
       "      <th>traditional_rental_rates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zeroBedRoomHomeValue</th>\n",
       "      <td>1884</td>\n",
       "      <td>1259.78</td>\n",
       "      <td>10590</td>\n",
       "      <td>1170.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oneBedRoomHomeValue</th>\n",
       "      <td>1884</td>\n",
       "      <td>1281.78</td>\n",
       "      <td>10590</td>\n",
       "      <td>1443.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>twoBedRoomsHomeValue</th>\n",
       "      <td>1884</td>\n",
       "      <td>2068.41</td>\n",
       "      <td>10590</td>\n",
       "      <td>2103.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>threeBedRoomsHomeValue</th>\n",
       "      <td>1884</td>\n",
       "      <td>3719.14</td>\n",
       "      <td>10590</td>\n",
       "      <td>3028.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fourBedRoomsHomeValue</th>\n",
       "      <td>1884</td>\n",
       "      <td>6054.51</td>\n",
       "      <td>10590</td>\n",
       "      <td>5215.58</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        airbnb_properties  airbnb_rental_rates  \\\n",
       "zeroBedRoomHomeValue                 1884              1259.78   \n",
       "oneBedRoomHomeValue                  1884              1281.78   \n",
       "twoBedRoomsHomeValue                 1884              2068.41   \n",
       "threeBedRoomsHomeValue               1884              3719.14   \n",
       "fourBedRoomsHomeValue                1884              6054.51   \n",
       "\n",
       "                        traditional_properties  traditional_rental_rates  \n",
       "zeroBedRoomHomeValue                     10590                   1170.23  \n",
       "oneBedRoomHomeValue                      10590                   1443.92  \n",
       "twoBedRoomsHomeValue                     10590                   2103.53  \n",
       "threeBedRoomsHomeValue                   10590                   3028.03  \n",
       "fourBedRoomsHomeValue                    10590                   5215.58  "
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "miami_df_drop = miami_df.drop(columns=['median_price', 'sqft','investment_properties', 'occupancy', 'traditional_coc', 'airbnb_coc', 'traditional_rental', 'airbnb_rental'])\n",
    "miami_df_columns = miami_df_drop[['airbnb_properties','airbnb_rental_rates','traditional_properties','traditional_rental_rates']]\n",
    "miami_df_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 111,
   "id": "relative-search",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'status': 'success',\n",
       " 'content': {'median_price': 325000,\n",
       "  'sqft': 1775.04,\n",
       "  'investment_properties': 465,\n",
       "  'airbnb_properties': 2571,\n",
       "  'traditional_properties': 2001,\n",
       "  'occupancy': 53,\n",
       "  'traditional_coc': 3.06768,\n",
       "  'airbnb_coc': 2.80085,\n",
       "  'traditional_rental': 1674,\n",
       "  'airbnb_rental': 2278.36,\n",
       "  'airbnb_rental_rates': {'zeroBedRoomHomeValue': 1068.66,\n",
       "   'oneBedRoomHomeValue': 1187.08,\n",
       "   'twoBedRoomsHomeValue': 1491.54,\n",
       "   'threeBedRoomsHomeValue': 2493.34,\n",
       "   'fourBedRoomsHomeValue': 3740.01},\n",
       "  'traditional_rental_rates': {'zeroBedRoomHomeValue': 1064.83,\n",
       "   'oneBedRoomHomeValue': 1052.79,\n",
       "   'twoBedRoomsHomeValue': 1314.7,\n",
       "   'threeBedRoomsHomeValue': 1932.26,\n",
       "   'fourBedRoomsHomeValue': 2650.66}},\n",
       " 'message': 'City Overview fetched successfully'}"
      ]
     },
     "execution_count": 111,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "r_tpa_fl = requests.get(\"https://api.mashvisor.com/v1.1/client/city/investment/FL/Tampa\", headers={'x-api-key':'7b9581e3-5b45-4fbc-8f59-d3379db49449'}) \n",
    "tampa= r_tpa_fl.json()\n",
    "tampa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 112,
   "id": "enhanced-hungarian",
   "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>median_price</th>\n",
       "      <th>sqft</th>\n",
       "      <th>investment_properties</th>\n",
       "      <th>airbnb_properties</th>\n",
       "      <th>traditional_properties</th>\n",
       "      <th>occupancy</th>\n",
       "      <th>traditional_coc</th>\n",
       "      <th>airbnb_coc</th>\n",
       "      <th>traditional_rental</th>\n",
       "      <th>airbnb_rental</th>\n",
       "      <th>airbnb_rental_rates</th>\n",
       "      <th>traditional_rental_rates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zeroBedRoomHomeValue</th>\n",
       "      <td>325000</td>\n",
       "      <td>1775.04</td>\n",
       "      <td>465</td>\n",
       "      <td>2571</td>\n",
       "      <td>2001</td>\n",
       "      <td>53</td>\n",
       "      <td>3.06768</td>\n",
       "      <td>2.80085</td>\n",
       "      <td>1674</td>\n",
       "      <td>2278.36</td>\n",
       "      <td>1068.66</td>\n",
       "      <td>1064.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oneBedRoomHomeValue</th>\n",
       "      <td>325000</td>\n",
       "      <td>1775.04</td>\n",
       "      <td>465</td>\n",
       "      <td>2571</td>\n",
       "      <td>2001</td>\n",
       "      <td>53</td>\n",
       "      <td>3.06768</td>\n",
       "      <td>2.80085</td>\n",
       "      <td>1674</td>\n",
       "      <td>2278.36</td>\n",
       "      <td>1187.08</td>\n",
       "      <td>1052.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>twoBedRoomsHomeValue</th>\n",
       "      <td>325000</td>\n",
       "      <td>1775.04</td>\n",
       "      <td>465</td>\n",
       "      <td>2571</td>\n",
       "      <td>2001</td>\n",
       "      <td>53</td>\n",
       "      <td>3.06768</td>\n",
       "      <td>2.80085</td>\n",
       "      <td>1674</td>\n",
       "      <td>2278.36</td>\n",
       "      <td>1491.54</td>\n",
       "      <td>1314.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>threeBedRoomsHomeValue</th>\n",
       "      <td>325000</td>\n",
       "      <td>1775.04</td>\n",
       "      <td>465</td>\n",
       "      <td>2571</td>\n",
       "      <td>2001</td>\n",
       "      <td>53</td>\n",
       "      <td>3.06768</td>\n",
       "      <td>2.80085</td>\n",
       "      <td>1674</td>\n",
       "      <td>2278.36</td>\n",
       "      <td>2493.34</td>\n",
       "      <td>1932.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fourBedRoomsHomeValue</th>\n",
       "      <td>325000</td>\n",
       "      <td>1775.04</td>\n",
       "      <td>465</td>\n",
       "      <td>2571</td>\n",
       "      <td>2001</td>\n",
       "      <td>53</td>\n",
       "      <td>3.06768</td>\n",
       "      <td>2.80085</td>\n",
       "      <td>1674</td>\n",
       "      <td>2278.36</td>\n",
       "      <td>3740.01</td>\n",
       "      <td>2650.66</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        median_price     sqft  investment_properties  \\\n",
       "zeroBedRoomHomeValue          325000  1775.04                    465   \n",
       "oneBedRoomHomeValue           325000  1775.04                    465   \n",
       "twoBedRoomsHomeValue          325000  1775.04                    465   \n",
       "threeBedRoomsHomeValue        325000  1775.04                    465   \n",
       "fourBedRoomsHomeValue         325000  1775.04                    465   \n",
       "\n",
       "                        airbnb_properties  traditional_properties  occupancy  \\\n",
       "zeroBedRoomHomeValue                 2571                    2001         53   \n",
       "oneBedRoomHomeValue                  2571                    2001         53   \n",
       "twoBedRoomsHomeValue                 2571                    2001         53   \n",
       "threeBedRoomsHomeValue               2571                    2001         53   \n",
       "fourBedRoomsHomeValue                2571                    2001         53   \n",
       "\n",
       "                        traditional_coc  airbnb_coc  traditional_rental  \\\n",
       "zeroBedRoomHomeValue            3.06768     2.80085                1674   \n",
       "oneBedRoomHomeValue             3.06768     2.80085                1674   \n",
       "twoBedRoomsHomeValue            3.06768     2.80085                1674   \n",
       "threeBedRoomsHomeValue          3.06768     2.80085                1674   \n",
       "fourBedRoomsHomeValue           3.06768     2.80085                1674   \n",
       "\n",
       "                        airbnb_rental  airbnb_rental_rates  \\\n",
       "zeroBedRoomHomeValue          2278.36              1068.66   \n",
       "oneBedRoomHomeValue           2278.36              1187.08   \n",
       "twoBedRoomsHomeValue          2278.36              1491.54   \n",
       "threeBedRoomsHomeValue        2278.36              2493.34   \n",
       "fourBedRoomsHomeValue         2278.36              3740.01   \n",
       "\n",
       "                        traditional_rental_rates  \n",
       "zeroBedRoomHomeValue                     1064.83  \n",
       "oneBedRoomHomeValue                      1052.79  \n",
       "twoBedRoomsHomeValue                     1314.70  \n",
       "threeBedRoomsHomeValue                   1932.26  \n",
       "fourBedRoomsHomeValue                    2650.66  "
      ]
     },
     "execution_count": 112,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tpa_df = pd.DataFrame.from_dict(tampa['content'])\n",
    "tpa_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 117,
   "id": "abstract-samuel",
   "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>airbnb_properties</th>\n",
       "      <th>airbnb_rental_rates</th>\n",
       "      <th>traditional_properties</th>\n",
       "      <th>traditional_rental_rates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>zeroBedRoomHomeValue</th>\n",
       "      <td>2571</td>\n",
       "      <td>1068.66</td>\n",
       "      <td>2001</td>\n",
       "      <td>1064.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>oneBedRoomHomeValue</th>\n",
       "      <td>2571</td>\n",
       "      <td>1187.08</td>\n",
       "      <td>2001</td>\n",
       "      <td>1052.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>twoBedRoomsHomeValue</th>\n",
       "      <td>2571</td>\n",
       "      <td>1491.54</td>\n",
       "      <td>2001</td>\n",
       "      <td>1314.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>threeBedRoomsHomeValue</th>\n",
       "      <td>2571</td>\n",
       "      <td>2493.34</td>\n",
       "      <td>2001</td>\n",
       "      <td>1932.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>fourBedRoomsHomeValue</th>\n",
       "      <td>2571</td>\n",
       "      <td>3740.01</td>\n",
       "      <td>2001</td>\n",
       "      <td>2650.66</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        airbnb_properties  airbnb_rental_rates  \\\n",
       "zeroBedRoomHomeValue                 2571              1068.66   \n",
       "oneBedRoomHomeValue                  2571              1187.08   \n",
       "twoBedRoomsHomeValue                 2571              1491.54   \n",
       "threeBedRoomsHomeValue               2571              2493.34   \n",
       "fourBedRoomsHomeValue                2571              3740.01   \n",
       "\n",
       "                        traditional_properties  traditional_rental_rates  \n",
       "zeroBedRoomHomeValue                      2001                   1064.83  \n",
       "oneBedRoomHomeValue                       2001                   1052.79  \n",
       "twoBedRoomsHomeValue                      2001                   1314.70  \n",
       "threeBedRoomsHomeValue                    2001                   1932.26  \n",
       "fourBedRoomsHomeValue                     2001                   2650.66  "
      ]
     },
     "execution_count": 117,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tpa_df_drop = tpa_df.drop(columns=['median_price', 'sqft','investment_properties', 'occupancy', 'traditional_coc', 'airbnb_coc', 'traditional_rental', 'airbnb_rental'])\n",
    "tpa_df_columns = tpa_df_drop[['airbnb_properties','airbnb_rental_rates','traditional_properties','traditional_rental_rates']]\n",
    "tpa_df_columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "wanted-athletics",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}