numbeo.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Making your next move using [Numbeo](https://www.numbeo.com)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "pd.set_option('display.max_rows', 300)\n",
    "\n",
    "current_city = \"Stockholm, Sweden\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def get_numbeo_dataframe(url, metric_column, current_city, lower_is_better = True, table_index = 2):\n",
    "    df = pd.read_html(url)[table_index]\n",
    "    df = df[[\"City\", metric_column]]    \n",
    "\n",
    "    df_current = df[df.City == current_city].iloc[0]\n",
    "\n",
    "    if lower_is_better:\n",
    "        df = df[df[metric_column] < df_current[metric_column]]\n",
    "    else:\n",
    "        df = df[df[metric_column] > df_current[metric_column]]\n",
    "        \n",
    "    df = df.sort_values(metric_column, ascending = lower_is_better).reset_index(drop=True)\n",
    "    \n",
    "    return df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Purchasing Power"
   ]
  },
  {
   "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>City</th>\n",
       "      <th>Local Purchasing Power Index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Dallas, TX, United States</td>\n",
       "      <td>166.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Raleigh, NC, United States</td>\n",
       "      <td>148.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Austin, TX, United States</td>\n",
       "      <td>146.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Houston, TX, United States</td>\n",
       "      <td>144.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Newcastle, Australia</td>\n",
       "      <td>142.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>Seattle, WA, United States</td>\n",
       "      <td>140.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>Atlanta, GA, United States</td>\n",
       "      <td>140.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>San Francisco, CA, United States</td>\n",
       "      <td>139.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>Bern, Switzerland</td>\n",
       "      <td>136.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>Calgary, Canada</td>\n",
       "      <td>136.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>San Diego, CA, United States</td>\n",
       "      <td>134.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>Columbus, OH, United States</td>\n",
       "      <td>133.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>Washington, DC, United States</td>\n",
       "      <td>133.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>Phoenix, AZ, United States</td>\n",
       "      <td>132.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>Charlotte, NC, United States</td>\n",
       "      <td>132.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>Las Vegas, NV, United States</td>\n",
       "      <td>132.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>Little Rock, AR, United States</td>\n",
       "      <td>132.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>Denver, CO, United States</td>\n",
       "      <td>131.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>Zurich, Switzerland</td>\n",
       "      <td>131.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>Basel, Switzerland</td>\n",
       "      <td>130.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>Salt Lake City, UT, United States</td>\n",
       "      <td>129.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>Nashville, TN, United States</td>\n",
       "      <td>129.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>Karlsruhe, Germany</td>\n",
       "      <td>128.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>Saint Louis, MO, United States</td>\n",
       "      <td>127.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>Madison, WI, United States</td>\n",
       "      <td>126.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>Ottawa, Canada</td>\n",
       "      <td>125.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>Canberra, Australia</td>\n",
       "      <td>125.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>Adelaide, Australia</td>\n",
       "      <td>125.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>Brisbane, Australia</td>\n",
       "      <td>124.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>Hanover, Germany</td>\n",
       "      <td>124.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>Minneapolis, MN, United States</td>\n",
       "      <td>123.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>Kansas City, MO, United States</td>\n",
       "      <td>123.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>Aachen, Germany</td>\n",
       "      <td>123.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>33</td>\n",
       "      <td>Anchorage, AK, United States</td>\n",
       "      <td>122.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>34</td>\n",
       "      <td>Chicago, IL, United States</td>\n",
       "      <td>120.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>35</td>\n",
       "      <td>San Antonio, TX, United States</td>\n",
       "      <td>120.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>36</td>\n",
       "      <td>Aalborg, Denmark</td>\n",
       "      <td>120.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>37</td>\n",
       "      <td>Baltimore, MD, United States</td>\n",
       "      <td>120.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>38</td>\n",
       "      <td>Sacramento, CA, United States</td>\n",
       "      <td>119.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>39</td>\n",
       "      <td>Derby, United Kingdom</td>\n",
       "      <td>119.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>40</td>\n",
       "      <td>Portland, OR, United States</td>\n",
       "      <td>118.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41</td>\n",
       "      <td>Tampa, FL, United States</td>\n",
       "      <td>118.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>42</td>\n",
       "      <td>Colorado Springs, CO, United States</td>\n",
       "      <td>118.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>43</td>\n",
       "      <td>Lausanne, Switzerland</td>\n",
       "      <td>117.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44</td>\n",
       "      <td>Edmonton, Canada</td>\n",
       "      <td>116.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>45</td>\n",
       "      <td>Los Angeles, CA, United States</td>\n",
       "      <td>116.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>46</td>\n",
       "      <td>Boston, MA, United States</td>\n",
       "      <td>115.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>47</td>\n",
       "      <td>Louisville, KY, United States</td>\n",
       "      <td>115.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>48</td>\n",
       "      <td>Hobart, Australia</td>\n",
       "      <td>114.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>49</td>\n",
       "      <td>Indianapolis, IN, United States</td>\n",
       "      <td>112.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50</td>\n",
       "      <td>Eindhoven, Netherlands</td>\n",
       "      <td>111.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>51</td>\n",
       "      <td>Perth, Australia</td>\n",
       "      <td>111.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>52</td>\n",
       "      <td>Melbourne, Australia</td>\n",
       "      <td>110.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53</td>\n",
       "      <td>Boise, ID, United States</td>\n",
       "      <td>110.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>54</td>\n",
       "      <td>Geneva, Switzerland</td>\n",
       "      <td>110.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>55</td>\n",
       "      <td>Southampton, United Kingdom</td>\n",
       "      <td>109.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>56</td>\n",
       "      <td>Ad Dammam, Saudi Arabia</td>\n",
       "      <td>109.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>57</td>\n",
       "      <td>Dresden, Germany</td>\n",
       "      <td>109.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>58</td>\n",
       "      <td>Doha, Qatar</td>\n",
       "      <td>109.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>59</td>\n",
       "      <td>Al Khobar, Saudi Arabia</td>\n",
       "      <td>108.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>60</td>\n",
       "      <td>Leeds, United Kingdom</td>\n",
       "      <td>108.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61</td>\n",
       "      <td>Mannheim, Germany</td>\n",
       "      <td>108.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>62</td>\n",
       "      <td>Hamburg, Germany</td>\n",
       "      <td>108.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63</td>\n",
       "      <td>Pittsburgh, PA, United States</td>\n",
       "      <td>107.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>64</td>\n",
       "      <td>Navi Mumbai, India</td>\n",
       "      <td>107.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>65</td>\n",
       "      <td>Stuttgart, Germany</td>\n",
       "      <td>107.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>66</td>\n",
       "      <td>Frankfurt, Germany</td>\n",
       "      <td>106.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>67</td>\n",
       "      <td>London, Canada</td>\n",
       "      <td>106.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>68</td>\n",
       "      <td>Dusseldorf, Germany</td>\n",
       "      <td>105.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>69</td>\n",
       "      <td>Liverpool, United Kingdom</td>\n",
       "      <td>105.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>70</td>\n",
       "      <td>Tampere, Finland</td>\n",
       "      <td>105.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71</td>\n",
       "      <td>Winnipeg, Canada</td>\n",
       "      <td>105.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>72</td>\n",
       "      <td>Albany, NY, United States</td>\n",
       "      <td>104.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>73</td>\n",
       "      <td>Montreal, Canada</td>\n",
       "      <td>104.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>74</td>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>104.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75</td>\n",
       "      <td>Cologne, Germany</td>\n",
       "      <td>104.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>76</td>\n",
       "      <td>Gold Coast, Australia</td>\n",
       "      <td>104.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>77</td>\n",
       "      <td>Heidelberg, Germany</td>\n",
       "      <td>104.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>78</td>\n",
       "      <td>Luxembourg, Luxembourg</td>\n",
       "      <td>103.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>79</td>\n",
       "      <td>Bonn, Germany</td>\n",
       "      <td>103.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>80</td>\n",
       "      <td>Sydney, Australia</td>\n",
       "      <td>103.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>81</td>\n",
       "      <td>Nuremberg, Germany</td>\n",
       "      <td>103.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>82</td>\n",
       "      <td>Munich, Germany</td>\n",
       "      <td>103.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>83</td>\n",
       "      <td>Arhus, Denmark</td>\n",
       "      <td>102.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>84</td>\n",
       "      <td>Buffalo, NY, United States</td>\n",
       "      <td>102.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>85</td>\n",
       "      <td>Gurgaon, India</td>\n",
       "      <td>101.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>86</td>\n",
       "      <td>Christchurch, New Zealand</td>\n",
       "      <td>101.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>87</td>\n",
       "      <td>Sheffield, United Kingdom</td>\n",
       "      <td>101.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>88</td>\n",
       "      <td>Abu Dhabi, United Arab Emirates</td>\n",
       "      <td>101.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>89</td>\n",
       "      <td>Berlin, Germany</td>\n",
       "      <td>100.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>90</td>\n",
       "      <td>Cardiff, United Kingdom</td>\n",
       "      <td>100.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>91</td>\n",
       "      <td>New York, NY, United States</td>\n",
       "      <td>100.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>92</td>\n",
       "      <td>Glasgow, United Kingdom</td>\n",
       "      <td>99.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>93</td>\n",
       "      <td>Philadelphia, PA, United States</td>\n",
       "      <td>99.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>94</td>\n",
       "      <td>Miami, FL, United States</td>\n",
       "      <td>98.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>95</td>\n",
       "      <td>Bergen, Norway</td>\n",
       "      <td>98.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>96</td>\n",
       "      <td>Toulouse, France</td>\n",
       "      <td>97.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>97</td>\n",
       "      <td>Dubai, United Arab Emirates</td>\n",
       "      <td>97.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>98</td>\n",
       "      <td>Helsinki, Finland</td>\n",
       "      <td>97.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>99</td>\n",
       "      <td>Riyadh, Saudi Arabia</td>\n",
       "      <td>97.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>100</td>\n",
       "      <td>Belfast, United Kingdom</td>\n",
       "      <td>97.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>101</td>\n",
       "      <td>Rotterdam, Netherlands</td>\n",
       "      <td>96.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>102</td>\n",
       "      <td>Jeddah (Jiddah), Saudi Arabia</td>\n",
       "      <td>96.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>103</td>\n",
       "      <td>Leicester, United Kingdom</td>\n",
       "      <td>96.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>104</td>\n",
       "      <td>Copenhagen, Denmark</td>\n",
       "      <td>96.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>105</td>\n",
       "      <td>Milwaukee, WI, United States</td>\n",
       "      <td>96.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>106</td>\n",
       "      <td>Birmingham, United Kingdom</td>\n",
       "      <td>95.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>107</td>\n",
       "      <td>The Hague (Den Haag), Netherlands</td>\n",
       "      <td>95.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>108</td>\n",
       "      <td>Brussels, Belgium</td>\n",
       "      <td>95.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>109</td>\n",
       "      <td>Trondheim, Norway</td>\n",
       "      <td>94.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>110</td>\n",
       "      <td>Dundee, United Kingdom</td>\n",
       "      <td>94.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111</td>\n",
       "      <td>Gothenburg, Sweden</td>\n",
       "      <td>94.49</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    City  Local Purchasing Power Index\n",
       "0              Dallas, TX, United States                        166.84\n",
       "1             Raleigh, NC, United States                        148.77\n",
       "2              Austin, TX, United States                        146.27\n",
       "3             Houston, TX, United States                        144.17\n",
       "4                   Newcastle, Australia                        142.34\n",
       "5             Seattle, WA, United States                        140.35\n",
       "6             Atlanta, GA, United States                        140.03\n",
       "7       San Francisco, CA, United States                        139.50\n",
       "8                      Bern, Switzerland                        136.69\n",
       "9                        Calgary, Canada                        136.13\n",
       "10          San Diego, CA, United States                        134.56\n",
       "11           Columbus, OH, United States                        133.75\n",
       "12         Washington, DC, United States                        133.56\n",
       "13            Phoenix, AZ, United States                        132.71\n",
       "14          Charlotte, NC, United States                        132.57\n",
       "15          Las Vegas, NV, United States                        132.22\n",
       "16        Little Rock, AR, United States                        132.17\n",
       "17             Denver, CO, United States                        131.79\n",
       "18                   Zurich, Switzerland                        131.34\n",
       "19                    Basel, Switzerland                        130.22\n",
       "20     Salt Lake City, UT, United States                        129.38\n",
       "21          Nashville, TN, United States                        129.10\n",
       "22                    Karlsruhe, Germany                        128.09\n",
       "23        Saint Louis, MO, United States                        127.63\n",
       "24            Madison, WI, United States                        126.09\n",
       "25                        Ottawa, Canada                        125.95\n",
       "26                   Canberra, Australia                        125.83\n",
       "27                   Adelaide, Australia                        125.75\n",
       "28                   Brisbane, Australia                        124.97\n",
       "29                      Hanover, Germany                        124.22\n",
       "30        Minneapolis, MN, United States                        123.80\n",
       "31        Kansas City, MO, United States                        123.58\n",
       "32                       Aachen, Germany                        123.34\n",
       "33          Anchorage, AK, United States                        122.22\n",
       "34            Chicago, IL, United States                        120.49\n",
       "35        San Antonio, TX, United States                        120.41\n",
       "36                      Aalborg, Denmark                        120.25\n",
       "37          Baltimore, MD, United States                        120.00\n",
       "38         Sacramento, CA, United States                        119.78\n",
       "39                 Derby, United Kingdom                        119.62\n",
       "40           Portland, OR, United States                        118.72\n",
       "41              Tampa, FL, United States                        118.62\n",
       "42   Colorado Springs, CO, United States                        118.58\n",
       "43                 Lausanne, Switzerland                        117.50\n",
       "44                      Edmonton, Canada                        116.93\n",
       "45        Los Angeles, CA, United States                        116.67\n",
       "46             Boston, MA, United States                        115.52\n",
       "47         Louisville, KY, United States                        115.47\n",
       "48                     Hobart, Australia                        114.95\n",
       "49       Indianapolis, IN, United States                        112.43\n",
       "50                Eindhoven, Netherlands                        111.89\n",
       "51                      Perth, Australia                        111.57\n",
       "52                  Melbourne, Australia                        110.92\n",
       "53              Boise, ID, United States                        110.36\n",
       "54                   Geneva, Switzerland                        110.14\n",
       "55           Southampton, United Kingdom                        109.87\n",
       "56               Ad Dammam, Saudi Arabia                        109.54\n",
       "57                      Dresden, Germany                        109.51\n",
       "58                           Doha, Qatar                        109.04\n",
       "59               Al Khobar, Saudi Arabia                        108.90\n",
       "60                 Leeds, United Kingdom                        108.88\n",
       "61                     Mannheim, Germany                        108.69\n",
       "62                      Hamburg, Germany                        108.07\n",
       "63         Pittsburgh, PA, United States                        107.90\n",
       "64                    Navi Mumbai, India                        107.75\n",
       "65                    Stuttgart, Germany                        107.50\n",
       "66                    Frankfurt, Germany                        106.32\n",
       "67                        London, Canada                        106.14\n",
       "68                   Dusseldorf, Germany                        105.63\n",
       "69             Liverpool, United Kingdom                        105.19\n",
       "70                      Tampere, Finland                        105.14\n",
       "71                      Winnipeg, Canada                        105.10\n",
       "72             Albany, NY, United States                        104.73\n",
       "73                      Montreal, Canada                        104.72\n",
       "74               Wellington, New Zealand                        104.71\n",
       "75                      Cologne, Germany                        104.12\n",
       "76                 Gold Coast, Australia                        104.07\n",
       "77                   Heidelberg, Germany                        104.04\n",
       "78                Luxembourg, Luxembourg                        103.96\n",
       "79                         Bonn, Germany                        103.91\n",
       "80                     Sydney, Australia                        103.86\n",
       "81                    Nuremberg, Germany                        103.18\n",
       "82                       Munich, Germany                        103.09\n",
       "83                        Arhus, Denmark                        102.69\n",
       "84            Buffalo, NY, United States                        102.47\n",
       "85                        Gurgaon, India                        101.99\n",
       "86             Christchurch, New Zealand                        101.80\n",
       "87             Sheffield, United Kingdom                        101.78\n",
       "88       Abu Dhabi, United Arab Emirates                        101.47\n",
       "89                       Berlin, Germany                        100.31\n",
       "90               Cardiff, United Kingdom                        100.30\n",
       "91           New York, NY, United States                        100.00\n",
       "92               Glasgow, United Kingdom                         99.71\n",
       "93       Philadelphia, PA, United States                         99.02\n",
       "94              Miami, FL, United States                         98.04\n",
       "95                        Bergen, Norway                         98.01\n",
       "96                      Toulouse, France                         97.80\n",
       "97           Dubai, United Arab Emirates                         97.67\n",
       "98                     Helsinki, Finland                         97.47\n",
       "99                  Riyadh, Saudi Arabia                         97.36\n",
       "100              Belfast, United Kingdom                         97.25\n",
       "101               Rotterdam, Netherlands                         96.93\n",
       "102        Jeddah (Jiddah), Saudi Arabia                         96.49\n",
       "103            Leicester, United Kingdom                         96.35\n",
       "104                  Copenhagen, Denmark                         96.22\n",
       "105         Milwaukee, WI, United States                         96.01\n",
       "106           Birmingham, United Kingdom                         95.96\n",
       "107    The Hague (Den Haag), Netherlands                         95.52\n",
       "108                    Brussels, Belgium                         95.41\n",
       "109                    Trondheim, Norway                         94.71\n",
       "110               Dundee, United Kingdom                         94.65\n",
       "111                   Gothenburg, Sweden                         94.49"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "purchasing_power = get_numbeo_dataframe(\"https://www.numbeo.com/cost-of-living/rankings_current.jsp\", \n",
    "                                        \"Local Purchasing Power Index\", \n",
    "                                        current_city, \n",
    "                                        lower_is_better = False)\n",
    "\n",
    "purchasing_power"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Property Prices"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>City</th>\n",
       "      <th>Price To Income Ratio</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Toledo, OH, United States</td>\n",
       "      <td>1.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Syracuse, NY, United States</td>\n",
       "      <td>1.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Huntsville, AL, United States</td>\n",
       "      <td>1.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Detroit, MI, United States</td>\n",
       "      <td>1.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Tulsa, OK, United States</td>\n",
       "      <td>1.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>Saint Louis, MO, United States</td>\n",
       "      <td>1.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>Little Rock, AR, United States</td>\n",
       "      <td>2.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>Lubbock, TX, United States</td>\n",
       "      <td>2.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>Buffalo, NY, United States</td>\n",
       "      <td>2.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>Kansas City, MO, United States</td>\n",
       "      <td>2.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>Columbus, OH, United States</td>\n",
       "      <td>2.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>Fort Worth, TX, United States</td>\n",
       "      <td>2.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>Dayton, OH, United States</td>\n",
       "      <td>2.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>Rochester, NY, United States</td>\n",
       "      <td>2.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>Chattanooga, TN, United States</td>\n",
       "      <td>2.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>Jacksonville, FL, United States</td>\n",
       "      <td>2.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>Pittsburgh, PA, United States</td>\n",
       "      <td>2.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>Dallas, TX, United States</td>\n",
       "      <td>2.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>Houston, TX, United States</td>\n",
       "      <td>2.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>Indianapolis, IN, United States</td>\n",
       "      <td>2.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>San Antonio, TX, United States</td>\n",
       "      <td>2.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>Hartford, CT, United States</td>\n",
       "      <td>2.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>Louisville, KY, United States</td>\n",
       "      <td>2.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>Pretoria, South Africa</td>\n",
       "      <td>2.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>Bakersfield, CA, United States</td>\n",
       "      <td>2.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>Cincinnati, OH, United States</td>\n",
       "      <td>2.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>Oklahoma City, OK, United States</td>\n",
       "      <td>2.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>Grand Rapids, MI, United States</td>\n",
       "      <td>2.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>Charlotte, NC, United States</td>\n",
       "      <td>2.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>Baltimore, MD, United States</td>\n",
       "      <td>2.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>Anchorage, AK, United States</td>\n",
       "      <td>2.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>Omaha, NE, United States</td>\n",
       "      <td>2.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>Raleigh, NC, United States</td>\n",
       "      <td>2.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>33</td>\n",
       "      <td>Lexington, KY, United States</td>\n",
       "      <td>2.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>34</td>\n",
       "      <td>Las Vegas, NV, United States</td>\n",
       "      <td>2.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>35</td>\n",
       "      <td>Baton Rouge, LA, United States</td>\n",
       "      <td>2.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>36</td>\n",
       "      <td>Birmingham, AL, United States</td>\n",
       "      <td>2.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>37</td>\n",
       "      <td>Milwaukee, WI, United States</td>\n",
       "      <td>2.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>38</td>\n",
       "      <td>Durham, NC, United States</td>\n",
       "      <td>2.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>39</td>\n",
       "      <td>Phoenix, AZ, United States</td>\n",
       "      <td>2.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>40</td>\n",
       "      <td>Atlanta, GA, United States</td>\n",
       "      <td>2.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41</td>\n",
       "      <td>Nashville, TN, United States</td>\n",
       "      <td>2.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>42</td>\n",
       "      <td>Jeddah (Jiddah), Saudi Arabia</td>\n",
       "      <td>2.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>43</td>\n",
       "      <td>Tucson, AZ, United States</td>\n",
       "      <td>2.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44</td>\n",
       "      <td>Knoxville, TN, United States</td>\n",
       "      <td>2.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>45</td>\n",
       "      <td>Tampa, FL, United States</td>\n",
       "      <td>3.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>46</td>\n",
       "      <td>Albuquerque, NM, United States</td>\n",
       "      <td>3.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>47</td>\n",
       "      <td>Richmond, VA, United States</td>\n",
       "      <td>3.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>48</td>\n",
       "      <td>Minneapolis, MN, United States</td>\n",
       "      <td>3.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>49</td>\n",
       "      <td>Colorado Springs, CO, United States</td>\n",
       "      <td>3.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50</td>\n",
       "      <td>Madison, WI, United States</td>\n",
       "      <td>3.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>51</td>\n",
       "      <td>Spokane, WA, United States</td>\n",
       "      <td>3.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>52</td>\n",
       "      <td>Orlando, FL, United States</td>\n",
       "      <td>3.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53</td>\n",
       "      <td>Reno, NV, United States</td>\n",
       "      <td>3.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>54</td>\n",
       "      <td>West Palm Beach, FL, United States</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>55</td>\n",
       "      <td>Johannesburg, South Africa</td>\n",
       "      <td>3.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>56</td>\n",
       "      <td>Vancouver, WA, United States</td>\n",
       "      <td>3.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>57</td>\n",
       "      <td>Salem, OR, United States</td>\n",
       "      <td>3.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>58</td>\n",
       "      <td>Chicago, IL, United States</td>\n",
       "      <td>3.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>59</td>\n",
       "      <td>Riyadh, Saudi Arabia</td>\n",
       "      <td>3.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>60</td>\n",
       "      <td>Durban, South Africa</td>\n",
       "      <td>3.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61</td>\n",
       "      <td>Sacramento, CA, United States</td>\n",
       "      <td>3.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>62</td>\n",
       "      <td>Tacoma, WA, United States</td>\n",
       "      <td>3.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63</td>\n",
       "      <td>Austin, TX, United States</td>\n",
       "      <td>3.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>64</td>\n",
       "      <td>Philadelphia, PA, United States</td>\n",
       "      <td>3.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>65</td>\n",
       "      <td>Edmonton, Canada</td>\n",
       "      <td>3.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>66</td>\n",
       "      <td>Salt Lake City, UT, United States</td>\n",
       "      <td>3.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>67</td>\n",
       "      <td>Fort Lauderdale, FL, United States</td>\n",
       "      <td>4.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>68</td>\n",
       "      <td>Boise, ID, United States</td>\n",
       "      <td>4.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>69</td>\n",
       "      <td>Washington, DC, United States</td>\n",
       "      <td>4.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>70</td>\n",
       "      <td>Denver, CO, United States</td>\n",
       "      <td>4.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71</td>\n",
       "      <td>Portland, ME, United States</td>\n",
       "      <td>4.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>72</td>\n",
       "      <td>Eugene, OR, United States</td>\n",
       "      <td>4.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>73</td>\n",
       "      <td>Adelaide, Australia</td>\n",
       "      <td>4.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>74</td>\n",
       "      <td>Portland, OR, United States</td>\n",
       "      <td>4.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75</td>\n",
       "      <td>Bellevue, WA, United States</td>\n",
       "      <td>4.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>76</td>\n",
       "      <td>Calgary, Canada</td>\n",
       "      <td>4.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>77</td>\n",
       "      <td>New Orleans, LA, United States</td>\n",
       "      <td>4.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>78</td>\n",
       "      <td>Ottawa, Canada</td>\n",
       "      <td>4.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>79</td>\n",
       "      <td>Dubai, United Arab Emirates</td>\n",
       "      <td>4.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>80</td>\n",
       "      <td>Miami, FL, United States</td>\n",
       "      <td>4.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>81</td>\n",
       "      <td>Winnipeg, Canada</td>\n",
       "      <td>4.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>82</td>\n",
       "      <td>Eindhoven, Netherlands</td>\n",
       "      <td>5.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>83</td>\n",
       "      <td>Antalya, Turkey</td>\n",
       "      <td>5.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>84</td>\n",
       "      <td>Irvine, CA, United States</td>\n",
       "      <td>5.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>85</td>\n",
       "      <td>San Diego, CA, United States</td>\n",
       "      <td>5.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>86</td>\n",
       "      <td>Bellingham, WA, United States</td>\n",
       "      <td>5.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>87</td>\n",
       "      <td>Charleston, SC, United States</td>\n",
       "      <td>5.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>88</td>\n",
       "      <td>Seattle, WA, United States</td>\n",
       "      <td>5.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>89</td>\n",
       "      <td>Maribor, Slovenia</td>\n",
       "      <td>5.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>90</td>\n",
       "      <td>Abu Dhabi, United Arab Emirates</td>\n",
       "      <td>5.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>91</td>\n",
       "      <td>Brisbane, Australia</td>\n",
       "      <td>5.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>92</td>\n",
       "      <td>Cork, Ireland</td>\n",
       "      <td>5.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>93</td>\n",
       "      <td>San Jose, CA, United States</td>\n",
       "      <td>5.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>94</td>\n",
       "      <td>Kelowna, Canada</td>\n",
       "      <td>5.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>95</td>\n",
       "      <td>Jersey City, NJ, United States</td>\n",
       "      <td>5.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>96</td>\n",
       "      <td>Antwerp, Belgium</td>\n",
       "      <td>5.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>97</td>\n",
       "      <td>Bursa, Turkey</td>\n",
       "      <td>5.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>98</td>\n",
       "      <td>Doha, Qatar</td>\n",
       "      <td>5.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>99</td>\n",
       "      <td>The Hague (Den Haag), Netherlands</td>\n",
       "      <td>6.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>100</td>\n",
       "      <td>Trieste, Italy</td>\n",
       "      <td>6.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>101</td>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>6.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>102</td>\n",
       "      <td>Brussels, Belgium</td>\n",
       "      <td>6.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>103</td>\n",
       "      <td>Ankara, Turkey</td>\n",
       "      <td>6.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>104</td>\n",
       "      <td>Long Beach, CA, United States</td>\n",
       "      <td>6.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>105</td>\n",
       "      <td>Reykjavik, Iceland</td>\n",
       "      <td>6.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>106</td>\n",
       "      <td>Oakland, CA, United States</td>\n",
       "      <td>6.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>107</td>\n",
       "      <td>Malmo, Sweden</td>\n",
       "      <td>6.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>108</td>\n",
       "      <td>Perth, Australia</td>\n",
       "      <td>6.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>109</td>\n",
       "      <td>Gurgaon, India</td>\n",
       "      <td>6.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>110</td>\n",
       "      <td>Rotterdam, Netherlands</td>\n",
       "      <td>6.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111</td>\n",
       "      <td>Montreal, Canada</td>\n",
       "      <td>6.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>112</td>\n",
       "      <td>Arlington, VA, United States</td>\n",
       "      <td>6.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>113</td>\n",
       "      <td>Noida, India</td>\n",
       "      <td>6.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>114</td>\n",
       "      <td>Nicosia, Cyprus</td>\n",
       "      <td>7.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>115</td>\n",
       "      <td>Seville (Sevilla), Spain</td>\n",
       "      <td>7.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>116</td>\n",
       "      <td>Bhubaneswar, India</td>\n",
       "      <td>7.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>117</td>\n",
       "      <td>Tampere, Finland</td>\n",
       "      <td>7.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>118</td>\n",
       "      <td>Monterrey, Mexico</td>\n",
       "      <td>7.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>119</td>\n",
       "      <td>Boulder, CO, United States</td>\n",
       "      <td>7.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>120</td>\n",
       "      <td>Los Angeles, CA, United States</td>\n",
       "      <td>7.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>121</td>\n",
       "      <td>Vadodara, India</td>\n",
       "      <td>7.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>122</td>\n",
       "      <td>Berkeley, CA, United States</td>\n",
       "      <td>7.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>123</td>\n",
       "      <td>Valencia, Spain</td>\n",
       "      <td>7.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>124</td>\n",
       "      <td>Plovdiv, Bulgaria</td>\n",
       "      <td>7.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>125</td>\n",
       "      <td>Chelyabinsk, Russia</td>\n",
       "      <td>7.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>126</td>\n",
       "      <td>San Jose, Costa Rica</td>\n",
       "      <td>7.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>127</td>\n",
       "      <td>Toulouse, France</td>\n",
       "      <td>7.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>128</td>\n",
       "      <td>Bergen, Norway</td>\n",
       "      <td>7.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>129</td>\n",
       "      <td>San Francisco, CA, United States</td>\n",
       "      <td>7.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>130</td>\n",
       "      <td>Victoria, Canada</td>\n",
       "      <td>7.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>131</td>\n",
       "      <td>Limassol, Cyprus</td>\n",
       "      <td>7.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>132</td>\n",
       "      <td>Genoa, Italy</td>\n",
       "      <td>8.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>133</td>\n",
       "      <td>Osijek, Croatia</td>\n",
       "      <td>8.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>134</td>\n",
       "      <td>Tartu, Estonia</td>\n",
       "      <td>8.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>135</td>\n",
       "      <td>Cape Town, South Africa</td>\n",
       "      <td>8.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>136</td>\n",
       "      <td>Utrecht, Netherlands</td>\n",
       "      <td>8.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>137</td>\n",
       "      <td>Katowice, Poland</td>\n",
       "      <td>8.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>138</td>\n",
       "      <td>Boston, MA, United States</td>\n",
       "      <td>8.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>139</td>\n",
       "      <td>Stavanger, Norway</td>\n",
       "      <td>8.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>140</td>\n",
       "      <td>Tyumen, Russia</td>\n",
       "      <td>8.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>141</td>\n",
       "      <td>Zurich, Switzerland</td>\n",
       "      <td>8.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>142</td>\n",
       "      <td>Kochi, India</td>\n",
       "      <td>8.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>143</td>\n",
       "      <td>Mississauga, Canada</td>\n",
       "      <td>8.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>144</td>\n",
       "      <td>Ahmedabad, India</td>\n",
       "      <td>8.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>145</td>\n",
       "      <td>Graz, Austria</td>\n",
       "      <td>8.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>146</td>\n",
       "      <td>Edinburgh, United Kingdom</td>\n",
       "      <td>8.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>147</td>\n",
       "      <td>Lucknow (Lakhnau), India</td>\n",
       "      <td>8.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>148</td>\n",
       "      <td>Varna, Bulgaria</td>\n",
       "      <td>8.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>149</td>\n",
       "      <td>Bangalore, India</td>\n",
       "      <td>8.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>150</td>\n",
       "      <td>Haifa, Israel</td>\n",
       "      <td>8.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>151</td>\n",
       "      <td>Lodz, Poland</td>\n",
       "      <td>8.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>152</td>\n",
       "      <td>Linz, Austria</td>\n",
       "      <td>8.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>153</td>\n",
       "      <td>Sofia, Bulgaria</td>\n",
       "      <td>8.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>154</td>\n",
       "      <td>Astana, Kazakhstan</td>\n",
       "      <td>9.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>155</td>\n",
       "      <td>Izmir, Turkey</td>\n",
       "      <td>9.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>156</td>\n",
       "      <td>Navi Mumbai, India</td>\n",
       "      <td>9.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>157</td>\n",
       "      <td>Saratov, Russia</td>\n",
       "      <td>9.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>158</td>\n",
       "      <td>Bristol, United Kingdom</td>\n",
       "      <td>9.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>159</td>\n",
       "      <td>Riga, Latvia</td>\n",
       "      <td>9.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>160</td>\n",
       "      <td>Lugano, Switzerland</td>\n",
       "      <td>9.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>161</td>\n",
       "      <td>Hyderabad, India</td>\n",
       "      <td>9.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>162</td>\n",
       "      <td>Voronezh, Russia</td>\n",
       "      <td>9.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>163</td>\n",
       "      <td>Honolulu, HI, United States</td>\n",
       "      <td>9.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>164</td>\n",
       "      <td>Amman, Jordan</td>\n",
       "      <td>9.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>165</td>\n",
       "      <td>Tallinn, Estonia</td>\n",
       "      <td>9.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>166</td>\n",
       "      <td>Hamburg, Germany</td>\n",
       "      <td>9.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>167</td>\n",
       "      <td>Copenhagen, Denmark</td>\n",
       "      <td>9.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>168</td>\n",
       "      <td>Perm, Russia</td>\n",
       "      <td>9.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>169</td>\n",
       "      <td>Melbourne, Australia</td>\n",
       "      <td>9.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>170</td>\n",
       "      <td>Rostov-na-donu, Russia</td>\n",
       "      <td>9.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>171</td>\n",
       "      <td>Nuremberg, Germany</td>\n",
       "      <td>9.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>172</td>\n",
       "      <td>Dublin, Ireland</td>\n",
       "      <td>9.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>173</td>\n",
       "      <td>Krasnoyarsk, Russia</td>\n",
       "      <td>9.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>174</td>\n",
       "      <td>Brasov, Romania</td>\n",
       "      <td>9.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>175</td>\n",
       "      <td>Kaliningrad, Russia</td>\n",
       "      <td>9.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>176</td>\n",
       "      <td>Turin, Italy</td>\n",
       "      <td>9.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>177</td>\n",
       "      <td>Izhevsk, Russia</td>\n",
       "      <td>9.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>178</td>\n",
       "      <td>Tomsk, Russia</td>\n",
       "      <td>9.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>179</td>\n",
       "      <td>Lyon, France</td>\n",
       "      <td>9.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>180</td>\n",
       "      <td>Krasnodar, Russia</td>\n",
       "      <td>9.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>181</td>\n",
       "      <td>Thiruvananthapuram, India</td>\n",
       "      <td>9.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>182</td>\n",
       "      <td>Bhopal, India</td>\n",
       "      <td>9.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>183</td>\n",
       "      <td>Visakhapatnam, India</td>\n",
       "      <td>9.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>184</td>\n",
       "      <td>Dnipro, Ukraine</td>\n",
       "      <td>9.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>185</td>\n",
       "      <td>Malaga, Spain</td>\n",
       "      <td>9.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>186</td>\n",
       "      <td>Pristina, Kosovo (Disputed Territory)</td>\n",
       "      <td>10.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>187</td>\n",
       "      <td>Iasi, Romania</td>\n",
       "      <td>10.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>188</td>\n",
       "      <td>Jaipur, India</td>\n",
       "      <td>10.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>189</td>\n",
       "      <td>New York, NY, United States</td>\n",
       "      <td>10.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>190</td>\n",
       "      <td>Bologna, Italy</td>\n",
       "      <td>10.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>191</td>\n",
       "      <td>Cologne, Germany</td>\n",
       "      <td>10.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>192</td>\n",
       "      <td>Debrecen, Hungary</td>\n",
       "      <td>10.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>193</td>\n",
       "      <td>Guatemala City, Guatemala</td>\n",
       "      <td>10.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>194</td>\n",
       "      <td>Kaunas, Lithuania</td>\n",
       "      <td>10.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>195</td>\n",
       "      <td>Quito, Ecuador</td>\n",
       "      <td>10.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>196</td>\n",
       "      <td>Szeged, Hungary</td>\n",
       "      <td>10.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>197</td>\n",
       "      <td>Vijayawada, India</td>\n",
       "      <td>10.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>198</td>\n",
       "      <td>Geneva, Switzerland</td>\n",
       "      <td>10.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>199</td>\n",
       "      <td>Frankfurt, Germany</td>\n",
       "      <td>10.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>200</td>\n",
       "      <td>Muscat, Oman</td>\n",
       "      <td>10.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>201</td>\n",
       "      <td>Rijeka, Croatia</td>\n",
       "      <td>10.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>202</td>\n",
       "      <td>Oradea, Romania</td>\n",
       "      <td>10.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>203</td>\n",
       "      <td>Gothenburg, Sweden</td>\n",
       "      <td>10.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>204</td>\n",
       "      <td>Stuttgart, Germany</td>\n",
       "      <td>10.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>205</td>\n",
       "      <td>Poznan, Poland</td>\n",
       "      <td>10.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>206</td>\n",
       "      <td>Kosice, Slovakia</td>\n",
       "      <td>10.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>207</td>\n",
       "      <td>Guadalajara, Mexico</td>\n",
       "      <td>10.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>208</td>\n",
       "      <td>Thessaloniki, Greece</td>\n",
       "      <td>10.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>209</td>\n",
       "      <td>Athens, Greece</td>\n",
       "      <td>10.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>210</td>\n",
       "      <td>Wroclaw, Poland</td>\n",
       "      <td>10.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>211</td>\n",
       "      <td>Samara, Russia</td>\n",
       "      <td>11.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>212</td>\n",
       "      <td>Pune, India</td>\n",
       "      <td>11.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>213</td>\n",
       "      <td>Bucharest, Romania</td>\n",
       "      <td>11.05</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>214</td>\n",
       "      <td>Berlin, Germany</td>\n",
       "      <td>11.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>215</td>\n",
       "      <td>Sydney, Australia</td>\n",
       "      <td>11.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>216</td>\n",
       "      <td>Kuala Lumpur, Malaysia</td>\n",
       "      <td>11.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>217</td>\n",
       "      <td>Tunis, Tunisia</td>\n",
       "      <td>11.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>218</td>\n",
       "      <td>Timisoara, Romania</td>\n",
       "      <td>11.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>219</td>\n",
       "      <td>Nizhny Novgorod, Russia</td>\n",
       "      <td>11.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>220</td>\n",
       "      <td>Brno, Czech Republic</td>\n",
       "      <td>11.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>221</td>\n",
       "      <td>Novosibirsk, Russia</td>\n",
       "      <td>11.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>222</td>\n",
       "      <td>Istanbul, Turkey</td>\n",
       "      <td>11.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>223</td>\n",
       "      <td>Indore, India</td>\n",
       "      <td>11.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>224</td>\n",
       "      <td>Yekaterinburg, Russia</td>\n",
       "      <td>11.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>225</td>\n",
       "      <td>Kolkata, India</td>\n",
       "      <td>11.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>226</td>\n",
       "      <td>Constanta, Romania</td>\n",
       "      <td>11.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>227</td>\n",
       "      <td>Luxembourg, Luxembourg</td>\n",
       "      <td>11.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>228</td>\n",
       "      <td>Brasilia, Brazil</td>\n",
       "      <td>11.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>229</td>\n",
       "      <td>Oslo, Norway</td>\n",
       "      <td>11.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>230</td>\n",
       "      <td>Panama City, Panama</td>\n",
       "      <td>11.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>231</td>\n",
       "      <td>Auckland, New Zealand</td>\n",
       "      <td>11.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>232</td>\n",
       "      <td>Asuncion, Paraguay</td>\n",
       "      <td>11.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>233</td>\n",
       "      <td>Madrid, Spain</td>\n",
       "      <td>11.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>234</td>\n",
       "      <td>Kharkiv, Ukraine</td>\n",
       "      <td>12.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>235</td>\n",
       "      <td>Helsinki, Finland</td>\n",
       "      <td>12.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>236</td>\n",
       "      <td>Craiova, Romania</td>\n",
       "      <td>12.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>237</td>\n",
       "      <td>Sarajevo, Bosnia And Herzegovina</td>\n",
       "      <td>12.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>238</td>\n",
       "      <td>Vilnius, Lithuania</td>\n",
       "      <td>12.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>239</td>\n",
       "      <td>Zagreb, Croatia</td>\n",
       "      <td>12.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>240</td>\n",
       "      <td>Gdansk, Poland</td>\n",
       "      <td>12.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>241</td>\n",
       "      <td>Podgorica, Montenegro</td>\n",
       "      <td>12.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>242</td>\n",
       "      <td>Campinas, Brazil</td>\n",
       "      <td>12.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>243</td>\n",
       "      <td>Krakow (Cracow), Poland</td>\n",
       "      <td>12.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>244</td>\n",
       "      <td>Bratislava, Slovakia</td>\n",
       "      <td>12.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>245</td>\n",
       "      <td>Almaty, Kazakhstan</td>\n",
       "      <td>12.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>246</td>\n",
       "      <td>Cairo, Egypt</td>\n",
       "      <td>12.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>247</td>\n",
       "      <td>Amsterdam, Netherlands</td>\n",
       "      <td>12.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>248</td>\n",
       "      <td>Cluj-Napoca, Romania</td>\n",
       "      <td>12.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>249</td>\n",
       "      <td>Ufa, Russia</td>\n",
       "      <td>12.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>250</td>\n",
       "      <td>Porto Alegre, Brazil</td>\n",
       "      <td>12.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>251</td>\n",
       "      <td>Coimbatore, India</td>\n",
       "      <td>12.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>252</td>\n",
       "      <td>Islamabad, Pakistan</td>\n",
       "      <td>12.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>253</td>\n",
       "      <td>Kazan, Russia</td>\n",
       "      <td>12.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>254</td>\n",
       "      <td>Porto, Portugal</td>\n",
       "      <td>12.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>255</td>\n",
       "      <td>Chandigarh, India</td>\n",
       "      <td>13.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>256</td>\n",
       "      <td>Kiev, Ukraine</td>\n",
       "      <td>13.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>257</td>\n",
       "      <td>Chisinau, Moldova</td>\n",
       "      <td>13.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>258</td>\n",
       "      <td>Dhaka, Bangladesh</td>\n",
       "      <td>13.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>259</td>\n",
       "      <td>Curitiba, Brazil</td>\n",
       "      <td>13.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>260</td>\n",
       "      <td>Naples, Italy</td>\n",
       "      <td>13.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>261</td>\n",
       "      <td>Cambridge, United Kingdom</td>\n",
       "      <td>13.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>262</td>\n",
       "      <td>Tokyo, Japan</td>\n",
       "      <td>13.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>263</td>\n",
       "      <td>Warsaw, Poland</td>\n",
       "      <td>13.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>264</td>\n",
       "      <td>Barcelona, Spain</td>\n",
       "      <td>13.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>265</td>\n",
       "      <td>Delhi, India</td>\n",
       "      <td>13.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>266</td>\n",
       "      <td>Odessa, Ukraine</td>\n",
       "      <td>13.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>267</td>\n",
       "      <td>Ljubljana, Slovenia</td>\n",
       "      <td>13.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>268</td>\n",
       "      <td>Banja Luka, Bosnia And Herzegovina</td>\n",
       "      <td>13.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>269</td>\n",
       "      <td>Lviv, Ukraine</td>\n",
       "      <td>13.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>270</td>\n",
       "      <td>Ulaanbaatar, Mongolia</td>\n",
       "      <td>13.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>271</td>\n",
       "      <td>Vienna, Austria</td>\n",
       "      <td>13.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>272</td>\n",
       "      <td>Skopje, Macedonia</td>\n",
       "      <td>13.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>273</td>\n",
       "      <td>Karachi, Pakistan</td>\n",
       "      <td>13.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>274</td>\n",
       "      <td>Cali, Colombia</td>\n",
       "      <td>13.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>275</td>\n",
       "      <td>Toronto, Canada</td>\n",
       "      <td>14.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>276</td>\n",
       "      <td>Tbilisi, Georgia</td>\n",
       "      <td>14.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>277</td>\n",
       "      <td>Chennai, India</td>\n",
       "      <td>14.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>278</td>\n",
       "      <td>Guayaquil, Ecuador</td>\n",
       "      <td>14.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>279</td>\n",
       "      <td>Beirut, Lebanon</td>\n",
       "      <td>14.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>280</td>\n",
       "      <td>Kuwait City, Kuwait</td>\n",
       "      <td>14.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>281</td>\n",
       "      <td>Santiago, Chile</td>\n",
       "      <td>14.49</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                      City  Price To Income Ratio\n",
       "0                Toledo, OH, United States                   1.45\n",
       "1              Syracuse, NY, United States                   1.58\n",
       "2            Huntsville, AL, United States                   1.62\n",
       "3               Detroit, MI, United States                   1.67\n",
       "4                 Tulsa, OK, United States                   1.74\n",
       "5           Saint Louis, MO, United States                   1.95\n",
       "6           Little Rock, AR, United States                   2.02\n",
       "7               Lubbock, TX, United States                   2.03\n",
       "8               Buffalo, NY, United States                   2.03\n",
       "9           Kansas City, MO, United States                   2.05\n",
       "10             Columbus, OH, United States                   2.06\n",
       "11           Fort Worth, TX, United States                   2.07\n",
       "12               Dayton, OH, United States                   2.14\n",
       "13            Rochester, NY, United States                   2.15\n",
       "14          Chattanooga, TN, United States                   2.16\n",
       "15         Jacksonville, FL, United States                   2.16\n",
       "16           Pittsburgh, PA, United States                   2.18\n",
       "17               Dallas, TX, United States                   2.19\n",
       "18              Houston, TX, United States                   2.19\n",
       "19         Indianapolis, IN, United States                   2.26\n",
       "20          San Antonio, TX, United States                   2.28\n",
       "21             Hartford, CT, United States                   2.39\n",
       "22           Louisville, KY, United States                   2.39\n",
       "23                  Pretoria, South Africa                   2.39\n",
       "24          Bakersfield, CA, United States                   2.40\n",
       "25           Cincinnati, OH, United States                   2.42\n",
       "26        Oklahoma City, OK, United States                   2.48\n",
       "27         Grand Rapids, MI, United States                   2.52\n",
       "28            Charlotte, NC, United States                   2.58\n",
       "29            Baltimore, MD, United States                   2.61\n",
       "30            Anchorage, AK, United States                   2.61\n",
       "31                Omaha, NE, United States                   2.61\n",
       "32              Raleigh, NC, United States                   2.62\n",
       "33            Lexington, KY, United States                   2.64\n",
       "34            Las Vegas, NV, United States                   2.69\n",
       "35          Baton Rouge, LA, United States                   2.72\n",
       "36           Birmingham, AL, United States                   2.74\n",
       "37            Milwaukee, WI, United States                   2.82\n",
       "38               Durham, NC, United States                   2.83\n",
       "39              Phoenix, AZ, United States                   2.85\n",
       "40              Atlanta, GA, United States                   2.90\n",
       "41            Nashville, TN, United States                   2.93\n",
       "42           Jeddah (Jiddah), Saudi Arabia                   2.93\n",
       "43               Tucson, AZ, United States                   2.96\n",
       "44            Knoxville, TN, United States                   2.99\n",
       "45                Tampa, FL, United States                   3.00\n",
       "46          Albuquerque, NM, United States                   3.10\n",
       "47             Richmond, VA, United States                   3.14\n",
       "48          Minneapolis, MN, United States                   3.14\n",
       "49     Colorado Springs, CO, United States                   3.29\n",
       "50              Madison, WI, United States                   3.30\n",
       "51              Spokane, WA, United States                   3.31\n",
       "52              Orlando, FL, United States                   3.46\n",
       "53                 Reno, NV, United States                   3.51\n",
       "54      West Palm Beach, FL, United States                   3.52\n",
       "55              Johannesburg, South Africa                   3.52\n",
       "56            Vancouver, WA, United States                   3.54\n",
       "57                Salem, OR, United States                   3.55\n",
       "58              Chicago, IL, United States                   3.56\n",
       "59                    Riyadh, Saudi Arabia                   3.58\n",
       "60                    Durban, South Africa                   3.59\n",
       "61           Sacramento, CA, United States                   3.61\n",
       "62               Tacoma, WA, United States                   3.81\n",
       "63               Austin, TX, United States                   3.81\n",
       "64         Philadelphia, PA, United States                   3.86\n",
       "65                        Edmonton, Canada                   3.93\n",
       "66       Salt Lake City, UT, United States                   3.98\n",
       "67      Fort Lauderdale, FL, United States                   4.22\n",
       "68                Boise, ID, United States                   4.30\n",
       "69           Washington, DC, United States                   4.34\n",
       "70               Denver, CO, United States                   4.34\n",
       "71             Portland, ME, United States                   4.35\n",
       "72               Eugene, OR, United States                   4.46\n",
       "73                     Adelaide, Australia                   4.47\n",
       "74             Portland, OR, United States                   4.52\n",
       "75             Bellevue, WA, United States                   4.54\n",
       "76                         Calgary, Canada                   4.59\n",
       "77          New Orleans, LA, United States                   4.59\n",
       "78                          Ottawa, Canada                   4.67\n",
       "79             Dubai, United Arab Emirates                   4.78\n",
       "80                Miami, FL, United States                   4.97\n",
       "81                        Winnipeg, Canada                   4.99\n",
       "82                  Eindhoven, Netherlands                   5.04\n",
       "83                         Antalya, Turkey                   5.12\n",
       "84               Irvine, CA, United States                   5.20\n",
       "85            San Diego, CA, United States                   5.34\n",
       "86           Bellingham, WA, United States                   5.34\n",
       "87           Charleston, SC, United States                   5.39\n",
       "88              Seattle, WA, United States                   5.54\n",
       "89                       Maribor, Slovenia                   5.58\n",
       "90         Abu Dhabi, United Arab Emirates                   5.60\n",
       "91                     Brisbane, Australia                   5.71\n",
       "92                           Cork, Ireland                   5.72\n",
       "93             San Jose, CA, United States                   5.75\n",
       "94                         Kelowna, Canada                   5.78\n",
       "95          Jersey City, NJ, United States                   5.80\n",
       "96                        Antwerp, Belgium                   5.84\n",
       "97                           Bursa, Turkey                   5.88\n",
       "98                             Doha, Qatar                   5.97\n",
       "99       The Hague (Den Haag), Netherlands                   6.30\n",
       "100                         Trieste, Italy                   6.38\n",
       "101                Wellington, New Zealand                   6.41\n",
       "102                      Brussels, Belgium                   6.50\n",
       "103                         Ankara, Turkey                   6.50\n",
       "104          Long Beach, CA, United States                   6.52\n",
       "105                     Reykjavik, Iceland                   6.54\n",
       "106             Oakland, CA, United States                   6.58\n",
       "107                          Malmo, Sweden                   6.79\n",
       "108                       Perth, Australia                   6.81\n",
       "109                         Gurgaon, India                   6.82\n",
       "110                 Rotterdam, Netherlands                   6.85\n",
       "111                       Montreal, Canada                   6.87\n",
       "112           Arlington, VA, United States                   6.87\n",
       "113                           Noida, India                   6.93\n",
       "114                        Nicosia, Cyprus                   7.16\n",
       "115               Seville (Sevilla), Spain                   7.19\n",
       "116                     Bhubaneswar, India                   7.25\n",
       "117                       Tampere, Finland                   7.29\n",
       "118                      Monterrey, Mexico                   7.32\n",
       "119             Boulder, CO, United States                   7.39\n",
       "120         Los Angeles, CA, United States                   7.40\n",
       "121                        Vadodara, India                   7.41\n",
       "122            Berkeley, CA, United States                   7.49\n",
       "123                        Valencia, Spain                   7.67\n",
       "124                      Plovdiv, Bulgaria                   7.70\n",
       "125                    Chelyabinsk, Russia                   7.76\n",
       "126                   San Jose, Costa Rica                   7.78\n",
       "127                       Toulouse, France                   7.80\n",
       "128                         Bergen, Norway                   7.89\n",
       "129       San Francisco, CA, United States                   7.91\n",
       "130                       Victoria, Canada                   7.94\n",
       "131                       Limassol, Cyprus                   7.98\n",
       "132                           Genoa, Italy                   8.00\n",
       "133                        Osijek, Croatia                   8.03\n",
       "134                         Tartu, Estonia                   8.06\n",
       "135                Cape Town, South Africa                   8.10\n",
       "136                   Utrecht, Netherlands                   8.10\n",
       "137                       Katowice, Poland                   8.12\n",
       "138              Boston, MA, United States                   8.17\n",
       "139                      Stavanger, Norway                   8.19\n",
       "140                         Tyumen, Russia                   8.39\n",
       "141                    Zurich, Switzerland                   8.47\n",
       "142                           Kochi, India                   8.50\n",
       "143                    Mississauga, Canada                   8.55\n",
       "144                       Ahmedabad, India                   8.63\n",
       "145                          Graz, Austria                   8.71\n",
       "146              Edinburgh, United Kingdom                   8.72\n",
       "147               Lucknow (Lakhnau), India                   8.73\n",
       "148                        Varna, Bulgaria                   8.75\n",
       "149                       Bangalore, India                   8.76\n",
       "150                          Haifa, Israel                   8.88\n",
       "151                           Lodz, Poland                   8.89\n",
       "152                          Linz, Austria                   8.90\n",
       "153                        Sofia, Bulgaria                   8.99\n",
       "154                     Astana, Kazakhstan                   9.05\n",
       "155                          Izmir, Turkey                   9.06\n",
       "156                     Navi Mumbai, India                   9.10\n",
       "157                        Saratov, Russia                   9.10\n",
       "158                Bristol, United Kingdom                   9.11\n",
       "159                           Riga, Latvia                   9.12\n",
       "160                    Lugano, Switzerland                   9.18\n",
       "161                       Hyderabad, India                   9.22\n",
       "162                       Voronezh, Russia                   9.27\n",
       "163            Honolulu, HI, United States                   9.31\n",
       "164                          Amman, Jordan                   9.34\n",
       "165                       Tallinn, Estonia                   9.37\n",
       "166                       Hamburg, Germany                   9.39\n",
       "167                    Copenhagen, Denmark                   9.46\n",
       "168                           Perm, Russia                   9.48\n",
       "169                   Melbourne, Australia                   9.49\n",
       "170                 Rostov-na-donu, Russia                   9.50\n",
       "171                     Nuremberg, Germany                   9.52\n",
       "172                        Dublin, Ireland                   9.52\n",
       "173                    Krasnoyarsk, Russia                   9.56\n",
       "174                        Brasov, Romania                   9.56\n",
       "175                    Kaliningrad, Russia                   9.57\n",
       "176                           Turin, Italy                   9.58\n",
       "177                        Izhevsk, Russia                   9.67\n",
       "178                          Tomsk, Russia                   9.69\n",
       "179                           Lyon, France                   9.78\n",
       "180                      Krasnodar, Russia                   9.80\n",
       "181              Thiruvananthapuram, India                   9.85\n",
       "182                          Bhopal, India                   9.88\n",
       "183                   Visakhapatnam, India                   9.91\n",
       "184                        Dnipro, Ukraine                   9.98\n",
       "185                          Malaga, Spain                   9.99\n",
       "186  Pristina, Kosovo (Disputed Territory)                  10.04\n",
       "187                          Iasi, Romania                  10.19\n",
       "188                          Jaipur, India                  10.24\n",
       "189            New York, NY, United States                  10.32\n",
       "190                         Bologna, Italy                  10.33\n",
       "191                       Cologne, Germany                  10.37\n",
       "192                      Debrecen, Hungary                  10.37\n",
       "193              Guatemala City, Guatemala                  10.42\n",
       "194                      Kaunas, Lithuania                  10.46\n",
       "195                         Quito, Ecuador                  10.49\n",
       "196                        Szeged, Hungary                  10.53\n",
       "197                      Vijayawada, India                  10.55\n",
       "198                    Geneva, Switzerland                  10.57\n",
       "199                     Frankfurt, Germany                  10.59\n",
       "200                           Muscat, Oman                  10.59\n",
       "201                        Rijeka, Croatia                  10.60\n",
       "202                        Oradea, Romania                  10.61\n",
       "203                     Gothenburg, Sweden                  10.62\n",
       "204                     Stuttgart, Germany                  10.81\n",
       "205                         Poznan, Poland                  10.81\n",
       "206                       Kosice, Slovakia                  10.89\n",
       "207                    Guadalajara, Mexico                  10.89\n",
       "208                   Thessaloniki, Greece                  10.94\n",
       "209                         Athens, Greece                  10.98\n",
       "210                        Wroclaw, Poland                  10.99\n",
       "211                         Samara, Russia                  11.01\n",
       "212                            Pune, India                  11.03\n",
       "213                     Bucharest, Romania                  11.05\n",
       "214                        Berlin, Germany                  11.10\n",
       "215                      Sydney, Australia                  11.34\n",
       "216                 Kuala Lumpur, Malaysia                  11.34\n",
       "217                         Tunis, Tunisia                  11.35\n",
       "218                     Timisoara, Romania                  11.36\n",
       "219                Nizhny Novgorod, Russia                  11.41\n",
       "220                   Brno, Czech Republic                  11.45\n",
       "221                    Novosibirsk, Russia                  11.45\n",
       "222                       Istanbul, Turkey                  11.46\n",
       "223                          Indore, India                  11.51\n",
       "224                  Yekaterinburg, Russia                  11.53\n",
       "225                         Kolkata, India                  11.59\n",
       "226                     Constanta, Romania                  11.68\n",
       "227                 Luxembourg, Luxembourg                  11.71\n",
       "228                       Brasilia, Brazil                  11.73\n",
       "229                           Oslo, Norway                  11.81\n",
       "230                    Panama City, Panama                  11.88\n",
       "231                  Auckland, New Zealand                  11.90\n",
       "232                     Asuncion, Paraguay                  11.91\n",
       "233                          Madrid, Spain                  11.99\n",
       "234                       Kharkiv, Ukraine                  12.00\n",
       "235                      Helsinki, Finland                  12.09\n",
       "236                       Craiova, Romania                  12.10\n",
       "237       Sarajevo, Bosnia And Herzegovina                  12.21\n",
       "238                     Vilnius, Lithuania                  12.25\n",
       "239                        Zagreb, Croatia                  12.27\n",
       "240                         Gdansk, Poland                  12.29\n",
       "241                  Podgorica, Montenegro                  12.39\n",
       "242                       Campinas, Brazil                  12.42\n",
       "243                Krakow (Cracow), Poland                  12.44\n",
       "244                   Bratislava, Slovakia                  12.49\n",
       "245                     Almaty, Kazakhstan                  12.49\n",
       "246                           Cairo, Egypt                  12.52\n",
       "247                 Amsterdam, Netherlands                  12.52\n",
       "248                   Cluj-Napoca, Romania                  12.53\n",
       "249                            Ufa, Russia                  12.56\n",
       "250                   Porto Alegre, Brazil                  12.61\n",
       "251                      Coimbatore, India                  12.62\n",
       "252                    Islamabad, Pakistan                  12.89\n",
       "253                          Kazan, Russia                  12.96\n",
       "254                        Porto, Portugal                  12.99\n",
       "255                      Chandigarh, India                  13.02\n",
       "256                          Kiev, Ukraine                  13.10\n",
       "257                      Chisinau, Moldova                  13.15\n",
       "258                      Dhaka, Bangladesh                  13.15\n",
       "259                       Curitiba, Brazil                  13.16\n",
       "260                          Naples, Italy                  13.18\n",
       "261              Cambridge, United Kingdom                  13.29\n",
       "262                           Tokyo, Japan                  13.33\n",
       "263                         Warsaw, Poland                  13.40\n",
       "264                       Barcelona, Spain                  13.43\n",
       "265                           Delhi, India                  13.45\n",
       "266                        Odessa, Ukraine                  13.52\n",
       "267                    Ljubljana, Slovenia                  13.55\n",
       "268     Banja Luka, Bosnia And Herzegovina                  13.59\n",
       "269                          Lviv, Ukraine                  13.69\n",
       "270                  Ulaanbaatar, Mongolia                  13.74\n",
       "271                        Vienna, Austria                  13.76\n",
       "272                      Skopje, Macedonia                  13.90\n",
       "273                      Karachi, Pakistan                  13.97\n",
       "274                         Cali, Colombia                  13.99\n",
       "275                        Toronto, Canada                  14.04\n",
       "276                       Tbilisi, Georgia                  14.08\n",
       "277                         Chennai, India                  14.30\n",
       "278                     Guayaquil, Ecuador                  14.34\n",
       "279                        Beirut, Lebanon                  14.38\n",
       "280                    Kuwait City, Kuwait                  14.47\n",
       "281                        Santiago, Chile                  14.49"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "property_prices = get_numbeo_dataframe(\"https://www.numbeo.com/property-investment/rankings_current.jsp\", \n",
    "                                        \"Price To Income Ratio\", current_city)\n",
    "\n",
    "property_prices"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Crime"
   ]
  },
  {
   "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>City</th>\n",
       "      <th>Crime Index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Abu Dhabi, United Arab Emirates</td>\n",
       "      <td>11.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Doha, Qatar</td>\n",
       "      <td>11.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Quebec City, Canada</td>\n",
       "      <td>14.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Taipei, Taiwan</td>\n",
       "      <td>15.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Sharjah, United Arab Emirates</td>\n",
       "      <td>15.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>Dubai, United Arab Emirates</td>\n",
       "      <td>16.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>Munich, Germany</td>\n",
       "      <td>16.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>Bern, Switzerland</td>\n",
       "      <td>17.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>Zurich, Switzerland</td>\n",
       "      <td>17.32</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>Eskisehir, Turkey</td>\n",
       "      <td>17.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>Hong Kong, Hong Kong</td>\n",
       "      <td>18.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>Basel, Switzerland</td>\n",
       "      <td>19.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>Cluj-Napoca, Romania</td>\n",
       "      <td>19.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>Canberra, Australia</td>\n",
       "      <td>19.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>Tartu, Estonia</td>\n",
       "      <td>19.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>Tokyo, Japan</td>\n",
       "      <td>20.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>Rijeka, Croatia</td>\n",
       "      <td>20.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>Markham, Canada</td>\n",
       "      <td>20.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>Tbilisi, Georgia</td>\n",
       "      <td>20.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>Trondheim, Norway</td>\n",
       "      <td>20.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>Tallinn, Estonia</td>\n",
       "      <td>21.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>Chiang Mai, Thailand</td>\n",
       "      <td>21.60</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>Tampere, Finland</td>\n",
       "      <td>21.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>Yerevan, Armenia</td>\n",
       "      <td>21.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>Brasov, Romania</td>\n",
       "      <td>21.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>Ljubljana, Slovenia</td>\n",
       "      <td>21.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>Helsinki, Finland</td>\n",
       "      <td>22.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>Reykjavik, Iceland</td>\n",
       "      <td>22.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>Zagreb, Croatia</td>\n",
       "      <td>22.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>Muscat, Oman</td>\n",
       "      <td>22.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>Merida, Mexico</td>\n",
       "      <td>22.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>Copenhagen, Denmark</td>\n",
       "      <td>22.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>Osaka, Japan</td>\n",
       "      <td>23.17</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>33</td>\n",
       "      <td>Vienna, Austria</td>\n",
       "      <td>23.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>34</td>\n",
       "      <td>Minsk, Belarus</td>\n",
       "      <td>23.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>35</td>\n",
       "      <td>Stavanger, Norway</td>\n",
       "      <td>24.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>36</td>\n",
       "      <td>Oakville, Canada</td>\n",
       "      <td>24.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>37</td>\n",
       "      <td>Mangalore, India</td>\n",
       "      <td>24.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>38</td>\n",
       "      <td>Bursa, Turkey</td>\n",
       "      <td>24.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>39</td>\n",
       "      <td>Ottawa, Canada</td>\n",
       "      <td>24.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>40</td>\n",
       "      <td>Timisoara, Romania</td>\n",
       "      <td>24.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41</td>\n",
       "      <td>Aalborg, Denmark</td>\n",
       "      <td>24.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>42</td>\n",
       "      <td>Prague, Czech Republic</td>\n",
       "      <td>24.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>43</td>\n",
       "      <td>Gent, Belgium</td>\n",
       "      <td>25.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44</td>\n",
       "      <td>Manama, Bahrain</td>\n",
       "      <td>25.39</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>45</td>\n",
       "      <td>Malaga, Spain</td>\n",
       "      <td>25.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>46</td>\n",
       "      <td>Eindhoven, Netherlands</td>\n",
       "      <td>25.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>47</td>\n",
       "      <td>Waterloo, Canada</td>\n",
       "      <td>25.94</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>48</td>\n",
       "      <td>Valencia, Spain</td>\n",
       "      <td>26.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>49</td>\n",
       "      <td>The Hague (Den Haag), Netherlands</td>\n",
       "      <td>26.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50</td>\n",
       "      <td>Brno, Czech Republic</td>\n",
       "      <td>26.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>51</td>\n",
       "      <td>Izmir, Turkey</td>\n",
       "      <td>26.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>52</td>\n",
       "      <td>Stuttgart, Germany</td>\n",
       "      <td>26.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53</td>\n",
       "      <td>Iasi, Romania</td>\n",
       "      <td>26.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>54</td>\n",
       "      <td>Oulu, Finland</td>\n",
       "      <td>27.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>55</td>\n",
       "      <td>Dusseldorf, Germany</td>\n",
       "      <td>27.53</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>56</td>\n",
       "      <td>Davao, Philippines</td>\n",
       "      <td>27.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>57</td>\n",
       "      <td>Bergen, Norway</td>\n",
       "      <td>27.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>58</td>\n",
       "      <td>Bucharest, Romania</td>\n",
       "      <td>27.85</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>59</td>\n",
       "      <td>Warsaw, Poland</td>\n",
       "      <td>27.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>60</td>\n",
       "      <td>Vilnius, Lithuania</td>\n",
       "      <td>28.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61</td>\n",
       "      <td>Lisbon, Portugal</td>\n",
       "      <td>28.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>62</td>\n",
       "      <td>Tel Aviv-Yafo, Israel</td>\n",
       "      <td>28.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63</td>\n",
       "      <td>Islamabad, Pakistan</td>\n",
       "      <td>28.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>64</td>\n",
       "      <td>Riyadh, Saudi Arabia</td>\n",
       "      <td>28.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>65</td>\n",
       "      <td>Seoul, South Korea</td>\n",
       "      <td>28.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>66</td>\n",
       "      <td>Geneva, Switzerland</td>\n",
       "      <td>28.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>67</td>\n",
       "      <td>Salt Lake City, UT, United States</td>\n",
       "      <td>28.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>68</td>\n",
       "      <td>Nizhny Novgorod, Russia</td>\n",
       "      <td>28.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>69</td>\n",
       "      <td>Luxembourg, Luxembourg</td>\n",
       "      <td>28.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>70</td>\n",
       "      <td>Lausanne, Switzerland</td>\n",
       "      <td>28.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71</td>\n",
       "      <td>Madison, WI, United States</td>\n",
       "      <td>29.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>72</td>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>29.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>73</td>\n",
       "      <td>Montreal, Canada</td>\n",
       "      <td>29.57</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>74</td>\n",
       "      <td>Galway, Ireland</td>\n",
       "      <td>29.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75</td>\n",
       "      <td>Vadodara, India</td>\n",
       "      <td>29.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>76</td>\n",
       "      <td>Bratislava, Slovakia</td>\n",
       "      <td>29.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>77</td>\n",
       "      <td>Haifa, Israel</td>\n",
       "      <td>29.91</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>78</td>\n",
       "      <td>Singapore, Singapore</td>\n",
       "      <td>30.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>79</td>\n",
       "      <td>Seville (Sevilla), Spain</td>\n",
       "      <td>30.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>80</td>\n",
       "      <td>Nicosia, Cyprus</td>\n",
       "      <td>30.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>81</td>\n",
       "      <td>Krakow (Cracow), Poland</td>\n",
       "      <td>30.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>82</td>\n",
       "      <td>Baku, Azerbaijan</td>\n",
       "      <td>30.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>83</td>\n",
       "      <td>Madrid, Spain</td>\n",
       "      <td>30.96</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>84</td>\n",
       "      <td>Edinburgh, United Kingdom</td>\n",
       "      <td>30.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>85</td>\n",
       "      <td>Victoria, Canada</td>\n",
       "      <td>30.98</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>86</td>\n",
       "      <td>Wroclaw, Poland</td>\n",
       "      <td>31.30</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>87</td>\n",
       "      <td>Adelaide, Australia</td>\n",
       "      <td>31.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>88</td>\n",
       "      <td>Puerto Vallarta, Mexico</td>\n",
       "      <td>31.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>89</td>\n",
       "      <td>Raleigh, NC, United States</td>\n",
       "      <td>31.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>90</td>\n",
       "      <td>Calgary, Canada</td>\n",
       "      <td>32.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>91</td>\n",
       "      <td>Cork, Ireland</td>\n",
       "      <td>32.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>92</td>\n",
       "      <td>Ahmedabad, India</td>\n",
       "      <td>32.24</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>93</td>\n",
       "      <td>Incheon, South Korea</td>\n",
       "      <td>32.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>94</td>\n",
       "      <td>Amsterdam, Netherlands</td>\n",
       "      <td>32.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>95</td>\n",
       "      <td>Limassol, Cyprus</td>\n",
       "      <td>33.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>96</td>\n",
       "      <td>Thiruvananthapuram, India</td>\n",
       "      <td>33.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>97</td>\n",
       "      <td>Jeddah (Jiddah), Saudi Arabia</td>\n",
       "      <td>33.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>98</td>\n",
       "      <td>Coimbatore, India</td>\n",
       "      <td>33.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>99</td>\n",
       "      <td>Hobart, Australia</td>\n",
       "      <td>33.87</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>100</td>\n",
       "      <td>Antwerp, Belgium</td>\n",
       "      <td>34.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>101</td>\n",
       "      <td>Poznan, Poland</td>\n",
       "      <td>34.00</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>102</td>\n",
       "      <td>Kuwait City, Kuwait</td>\n",
       "      <td>34.02</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>103</td>\n",
       "      <td>Brisbane, Australia</td>\n",
       "      <td>34.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>104</td>\n",
       "      <td>Surat, India</td>\n",
       "      <td>34.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>105</td>\n",
       "      <td>Split, Croatia</td>\n",
       "      <td>34.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>106</td>\n",
       "      <td>Boise, ID, United States</td>\n",
       "      <td>34.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>107</td>\n",
       "      <td>Navi Mumbai, India</td>\n",
       "      <td>34.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>108</td>\n",
       "      <td>Boston, MA, United States</td>\n",
       "      <td>34.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>109</td>\n",
       "      <td>Ad Dammam, Saudi Arabia</td>\n",
       "      <td>34.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>110</td>\n",
       "      <td>Nuremberg, Germany</td>\n",
       "      <td>34.71</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111</td>\n",
       "      <td>Kathmandu, Nepal</td>\n",
       "      <td>34.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>112</td>\n",
       "      <td>Lund, Sweden</td>\n",
       "      <td>34.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>113</td>\n",
       "      <td>Austin, TX, United States</td>\n",
       "      <td>35.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>114</td>\n",
       "      <td>Queretaro, Mexico</td>\n",
       "      <td>35.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>115</td>\n",
       "      <td>Kochi, India</td>\n",
       "      <td>35.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>116</td>\n",
       "      <td>Cuenca, Ecuador</td>\n",
       "      <td>35.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>117</td>\n",
       "      <td>Riverside, CA, United States</td>\n",
       "      <td>35.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>118</td>\n",
       "      <td>Sydney, Australia</td>\n",
       "      <td>35.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>119</td>\n",
       "      <td>Cardiff, United Kingdom</td>\n",
       "      <td>35.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>120</td>\n",
       "      <td>Banja Luka, Bosnia And Herzegovina</td>\n",
       "      <td>35.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>121</td>\n",
       "      <td>Brighton, United Kingdom</td>\n",
       "      <td>35.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>122</td>\n",
       "      <td>Rotterdam, Netherlands</td>\n",
       "      <td>35.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>123</td>\n",
       "      <td>Pittsburgh, PA, United States</td>\n",
       "      <td>36.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>124</td>\n",
       "      <td>Vancouver, Canada</td>\n",
       "      <td>36.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>125</td>\n",
       "      <td>San Diego, CA, United States</td>\n",
       "      <td>36.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>126</td>\n",
       "      <td>Thessaloniki, Greece</td>\n",
       "      <td>36.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>127</td>\n",
       "      <td>Hyderabad, India</td>\n",
       "      <td>36.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>128</td>\n",
       "      <td>Budapest, Hungary</td>\n",
       "      <td>36.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>129</td>\n",
       "      <td>Pune, India</td>\n",
       "      <td>37.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>130</td>\n",
       "      <td>Aberdeen, United Kingdom</td>\n",
       "      <td>37.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>131</td>\n",
       "      <td>Jerusalem, Israel</td>\n",
       "      <td>37.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>132</td>\n",
       "      <td>Lahore, Pakistan</td>\n",
       "      <td>37.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>133</td>\n",
       "      <td>Oslo, Norway</td>\n",
       "      <td>37.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>134</td>\n",
       "      <td>Belgrade, Serbia</td>\n",
       "      <td>37.64</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>135</td>\n",
       "      <td>Florence, Italy</td>\n",
       "      <td>37.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>136</td>\n",
       "      <td>Toronto, Canada</td>\n",
       "      <td>37.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>137</td>\n",
       "      <td>Riga, Latvia</td>\n",
       "      <td>37.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>138</td>\n",
       "      <td>Katowice, Poland</td>\n",
       "      <td>38.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>139</td>\n",
       "      <td>Chandigarh, India</td>\n",
       "      <td>38.55</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>140</td>\n",
       "      <td>Newcastle upon Tyne, United Kingdom</td>\n",
       "      <td>38.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>141</td>\n",
       "      <td>Saint Petersburg, Russia</td>\n",
       "      <td>38.82</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>142</td>\n",
       "      <td>Porto, Portugal</td>\n",
       "      <td>38.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>143</td>\n",
       "      <td>Christchurch, New Zealand</td>\n",
       "      <td>39.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>144</td>\n",
       "      <td>Gdansk, Poland</td>\n",
       "      <td>39.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>145</td>\n",
       "      <td>Kaunas, Lithuania</td>\n",
       "      <td>39.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>146</td>\n",
       "      <td>Kitchener, Canada</td>\n",
       "      <td>39.34</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>147</td>\n",
       "      <td>Makati, Philippines</td>\n",
       "      <td>39.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>148</td>\n",
       "      <td>Colombo, Sri Lanka</td>\n",
       "      <td>39.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>149</td>\n",
       "      <td>Bristol, United Kingdom</td>\n",
       "      <td>39.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>150</td>\n",
       "      <td>Alexandria, Egypt</td>\n",
       "      <td>39.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>151</td>\n",
       "      <td>Amman, Jordan</td>\n",
       "      <td>39.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>152</td>\n",
       "      <td>Shanghai, China</td>\n",
       "      <td>39.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>153</td>\n",
       "      <td>Chennai, India</td>\n",
       "      <td>40.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>154</td>\n",
       "      <td>Ankara, Turkey</td>\n",
       "      <td>40.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>155</td>\n",
       "      <td>Hanoi, Vietnam</td>\n",
       "      <td>40.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>156</td>\n",
       "      <td>Berlin, Germany</td>\n",
       "      <td>40.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>157</td>\n",
       "      <td>Tirana, Albania</td>\n",
       "      <td>40.49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>158</td>\n",
       "      <td>Denver, CO, United States</td>\n",
       "      <td>40.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>159</td>\n",
       "      <td>Penang, Malaysia</td>\n",
       "      <td>40.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>160</td>\n",
       "      <td>Frankfurt, Germany</td>\n",
       "      <td>40.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>161</td>\n",
       "      <td>Lviv, Ukraine</td>\n",
       "      <td>40.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>162</td>\n",
       "      <td>Shenzhen, China</td>\n",
       "      <td>41.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>163</td>\n",
       "      <td>Moscow, Russia</td>\n",
       "      <td>41.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>164</td>\n",
       "      <td>Beijing, China</td>\n",
       "      <td>41.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>165</td>\n",
       "      <td>Sheffield, United Kingdom</td>\n",
       "      <td>41.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>166</td>\n",
       "      <td>Bangkok, Thailand</td>\n",
       "      <td>41.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>167</td>\n",
       "      <td>Columbus, OH, United States</td>\n",
       "      <td>41.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>168</td>\n",
       "      <td>Nanaimo, BC, Canada</td>\n",
       "      <td>41.66</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>169</td>\n",
       "      <td>Gold Coast, Australia</td>\n",
       "      <td>41.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>170</td>\n",
       "      <td>San Jose, CA, United States</td>\n",
       "      <td>42.09</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>171</td>\n",
       "      <td>Mumbai, India</td>\n",
       "      <td>42.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>172</td>\n",
       "      <td>Lyon, France</td>\n",
       "      <td>42.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>173</td>\n",
       "      <td>Belfast, United Kingdom</td>\n",
       "      <td>42.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>174</td>\n",
       "      <td>Halifax, Canada</td>\n",
       "      <td>42.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>175</td>\n",
       "      <td>Sofia, Bulgaria</td>\n",
       "      <td>42.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>176</td>\n",
       "      <td>Charlotte, NC, United States</td>\n",
       "      <td>42.68</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>177</td>\n",
       "      <td>Edmonton, Canada</td>\n",
       "      <td>42.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>178</td>\n",
       "      <td>Honolulu, HI, United States</td>\n",
       "      <td>42.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>179</td>\n",
       "      <td>Los Angeles, CA, United States</td>\n",
       "      <td>42.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>180</td>\n",
       "      <td>Mississauga, Canada</td>\n",
       "      <td>43.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>181</td>\n",
       "      <td>Cologne, Germany</td>\n",
       "      <td>43.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>182</td>\n",
       "      <td>Novi Sad, Serbia</td>\n",
       "      <td>43.38</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>183</td>\n",
       "      <td>Milan, Italy</td>\n",
       "      <td>43.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>184</td>\n",
       "      <td>New York, NY, United States</td>\n",
       "      <td>43.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>185</td>\n",
       "      <td>Iloilo, Philippines</td>\n",
       "      <td>43.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>186</td>\n",
       "      <td>Perth, Australia</td>\n",
       "      <td>43.76</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>187</td>\n",
       "      <td>Richmond, VA, United States</td>\n",
       "      <td>43.88</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>188</td>\n",
       "      <td>Beirut, Lebanon</td>\n",
       "      <td>43.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>189</td>\n",
       "      <td>Lodz, Poland</td>\n",
       "      <td>44.12</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                    City  Crime Index\n",
       "0        Abu Dhabi, United Arab Emirates        11.07\n",
       "1                            Doha, Qatar        11.33\n",
       "2                    Quebec City, Canada        14.36\n",
       "3                         Taipei, Taiwan        15.13\n",
       "4          Sharjah, United Arab Emirates        15.16\n",
       "5            Dubai, United Arab Emirates        16.52\n",
       "6                        Munich, Germany        16.75\n",
       "7                      Bern, Switzerland        17.11\n",
       "8                    Zurich, Switzerland        17.32\n",
       "9                      Eskisehir, Turkey        17.33\n",
       "10                  Hong Kong, Hong Kong        18.62\n",
       "11                    Basel, Switzerland        19.26\n",
       "12                  Cluj-Napoca, Romania        19.46\n",
       "13                   Canberra, Australia        19.52\n",
       "14                        Tartu, Estonia        19.65\n",
       "15                          Tokyo, Japan        20.10\n",
       "16                       Rijeka, Croatia        20.33\n",
       "17                       Markham, Canada        20.50\n",
       "18                      Tbilisi, Georgia        20.55\n",
       "19                     Trondheim, Norway        20.66\n",
       "20                      Tallinn, Estonia        21.26\n",
       "21                  Chiang Mai, Thailand        21.60\n",
       "22                      Tampere, Finland        21.61\n",
       "23                      Yerevan, Armenia        21.70\n",
       "24                       Brasov, Romania        21.83\n",
       "25                   Ljubljana, Slovenia        21.87\n",
       "26                     Helsinki, Finland        22.01\n",
       "27                    Reykjavik, Iceland        22.14\n",
       "28                       Zagreb, Croatia        22.17\n",
       "29                          Muscat, Oman        22.61\n",
       "30                        Merida, Mexico        22.78\n",
       "31                   Copenhagen, Denmark        22.89\n",
       "32                          Osaka, Japan        23.17\n",
       "33                       Vienna, Austria        23.51\n",
       "34                        Minsk, Belarus        23.87\n",
       "35                     Stavanger, Norway        24.13\n",
       "36                      Oakville, Canada        24.15\n",
       "37                      Mangalore, India        24.27\n",
       "38                         Bursa, Turkey        24.52\n",
       "39                        Ottawa, Canada        24.64\n",
       "40                    Timisoara, Romania        24.64\n",
       "41                      Aalborg, Denmark        24.91\n",
       "42                Prague, Czech Republic        24.91\n",
       "43                         Gent, Belgium        25.07\n",
       "44                       Manama, Bahrain        25.39\n",
       "45                         Malaga, Spain        25.56\n",
       "46                Eindhoven, Netherlands        25.83\n",
       "47                      Waterloo, Canada        25.94\n",
       "48                       Valencia, Spain        26.00\n",
       "49     The Hague (Den Haag), Netherlands        26.23\n",
       "50                  Brno, Czech Republic        26.52\n",
       "51                         Izmir, Turkey        26.75\n",
       "52                    Stuttgart, Germany        26.93\n",
       "53                         Iasi, Romania        26.96\n",
       "54                         Oulu, Finland        27.22\n",
       "55                   Dusseldorf, Germany        27.53\n",
       "56                    Davao, Philippines        27.63\n",
       "57                        Bergen, Norway        27.72\n",
       "58                    Bucharest, Romania        27.85\n",
       "59                        Warsaw, Poland        27.93\n",
       "60                    Vilnius, Lithuania        28.00\n",
       "61                      Lisbon, Portugal        28.11\n",
       "62                 Tel Aviv-Yafo, Israel        28.12\n",
       "63                   Islamabad, Pakistan        28.18\n",
       "64                  Riyadh, Saudi Arabia        28.50\n",
       "65                    Seoul, South Korea        28.52\n",
       "66                   Geneva, Switzerland        28.68\n",
       "67     Salt Lake City, UT, United States        28.75\n",
       "68               Nizhny Novgorod, Russia        28.87\n",
       "69                Luxembourg, Luxembourg        28.95\n",
       "70                 Lausanne, Switzerland        28.97\n",
       "71            Madison, WI, United States        29.12\n",
       "72               Wellington, New Zealand        29.35\n",
       "73                      Montreal, Canada        29.57\n",
       "74                       Galway, Ireland        29.69\n",
       "75                       Vadodara, India        29.89\n",
       "76                  Bratislava, Slovakia        29.90\n",
       "77                         Haifa, Israel        29.91\n",
       "78                  Singapore, Singapore        30.00\n",
       "79              Seville (Sevilla), Spain        30.02\n",
       "80                       Nicosia, Cyprus        30.06\n",
       "81               Krakow (Cracow), Poland        30.14\n",
       "82                      Baku, Azerbaijan        30.71\n",
       "83                         Madrid, Spain        30.96\n",
       "84             Edinburgh, United Kingdom        30.97\n",
       "85                      Victoria, Canada        30.98\n",
       "86                       Wroclaw, Poland        31.30\n",
       "87                   Adelaide, Australia        31.40\n",
       "88               Puerto Vallarta, Mexico        31.72\n",
       "89            Raleigh, NC, United States        31.76\n",
       "90                       Calgary, Canada        32.19\n",
       "91                         Cork, Ireland        32.20\n",
       "92                      Ahmedabad, India        32.24\n",
       "93                  Incheon, South Korea        32.75\n",
       "94                Amsterdam, Netherlands        32.88\n",
       "95                      Limassol, Cyprus        33.29\n",
       "96             Thiruvananthapuram, India        33.51\n",
       "97         Jeddah (Jiddah), Saudi Arabia        33.81\n",
       "98                     Coimbatore, India        33.83\n",
       "99                     Hobart, Australia        33.87\n",
       "100                     Antwerp, Belgium        34.00\n",
       "101                       Poznan, Poland        34.00\n",
       "102                  Kuwait City, Kuwait        34.02\n",
       "103                  Brisbane, Australia        34.03\n",
       "104                         Surat, India        34.15\n",
       "105                       Split, Croatia        34.31\n",
       "106             Boise, ID, United States        34.36\n",
       "107                   Navi Mumbai, India        34.43\n",
       "108            Boston, MA, United States        34.46\n",
       "109              Ad Dammam, Saudi Arabia        34.71\n",
       "110                   Nuremberg, Germany        34.71\n",
       "111                     Kathmandu, Nepal        34.80\n",
       "112                         Lund, Sweden        34.93\n",
       "113            Austin, TX, United States        35.37\n",
       "114                    Queretaro, Mexico        35.46\n",
       "115                         Kochi, India        35.46\n",
       "116                      Cuenca, Ecuador        35.52\n",
       "117         Riverside, CA, United States        35.52\n",
       "118                    Sydney, Australia        35.55\n",
       "119              Cardiff, United Kingdom        35.62\n",
       "120   Banja Luka, Bosnia And Herzegovina        35.79\n",
       "121             Brighton, United Kingdom        35.88\n",
       "122               Rotterdam, Netherlands        35.92\n",
       "123        Pittsburgh, PA, United States        36.09\n",
       "124                    Vancouver, Canada        36.26\n",
       "125         San Diego, CA, United States        36.45\n",
       "126                 Thessaloniki, Greece        36.58\n",
       "127                     Hyderabad, India        36.64\n",
       "128                    Budapest, Hungary        36.66\n",
       "129                          Pune, India        37.21\n",
       "130             Aberdeen, United Kingdom        37.34\n",
       "131                    Jerusalem, Israel        37.45\n",
       "132                     Lahore, Pakistan        37.50\n",
       "133                         Oslo, Norway        37.63\n",
       "134                     Belgrade, Serbia        37.64\n",
       "135                      Florence, Italy        37.70\n",
       "136                      Toronto, Canada        37.80\n",
       "137                         Riga, Latvia        37.81\n",
       "138                     Katowice, Poland        38.42\n",
       "139                    Chandigarh, India        38.55\n",
       "140  Newcastle upon Tyne, United Kingdom        38.78\n",
       "141             Saint Petersburg, Russia        38.82\n",
       "142                      Porto, Portugal        38.97\n",
       "143            Christchurch, New Zealand        39.09\n",
       "144                       Gdansk, Poland        39.10\n",
       "145                    Kaunas, Lithuania        39.15\n",
       "146                    Kitchener, Canada        39.34\n",
       "147                  Makati, Philippines        39.58\n",
       "148                   Colombo, Sri Lanka        39.63\n",
       "149              Bristol, United Kingdom        39.69\n",
       "150                    Alexandria, Egypt        39.73\n",
       "151                        Amman, Jordan        39.86\n",
       "152                      Shanghai, China        39.89\n",
       "153                       Chennai, India        40.01\n",
       "154                       Ankara, Turkey        40.16\n",
       "155                       Hanoi, Vietnam        40.45\n",
       "156                      Berlin, Germany        40.48\n",
       "157                      Tirana, Albania        40.49\n",
       "158            Denver, CO, United States        40.61\n",
       "159                     Penang, Malaysia        40.74\n",
       "160                   Frankfurt, Germany        40.92\n",
       "161                        Lviv, Ukraine        40.92\n",
       "162                      Shenzhen, China        41.04\n",
       "163                       Moscow, Russia        41.06\n",
       "164                       Beijing, China        41.21\n",
       "165            Sheffield, United Kingdom        41.28\n",
       "166                    Bangkok, Thailand        41.43\n",
       "167          Columbus, OH, United States        41.51\n",
       "168                  Nanaimo, BC, Canada        41.66\n",
       "169                Gold Coast, Australia        41.86\n",
       "170          San Jose, CA, United States        42.09\n",
       "171                        Mumbai, India        42.11\n",
       "172                         Lyon, France        42.22\n",
       "173              Belfast, United Kingdom        42.33\n",
       "174                      Halifax, Canada        42.46\n",
       "175                      Sofia, Bulgaria        42.62\n",
       "176         Charlotte, NC, United States        42.68\n",
       "177                     Edmonton, Canada        42.79\n",
       "178          Honolulu, HI, United States        42.83\n",
       "179       Los Angeles, CA, United States        42.86\n",
       "180                  Mississauga, Canada        43.16\n",
       "181                     Cologne, Germany        43.27\n",
       "182                     Novi Sad, Serbia        43.38\n",
       "183                         Milan, Italy        43.40\n",
       "184          New York, NY, United States        43.41\n",
       "185                  Iloilo, Philippines        43.51\n",
       "186                     Perth, Australia        43.76\n",
       "187          Richmond, VA, United States        43.88\n",
       "188                      Beirut, Lebanon        43.97\n",
       "189                         Lodz, Poland        44.12"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "crime = get_numbeo_dataframe(\"https://www.numbeo.com/crime/rankings_current.jsp\", \"Crime Index\", current_city)\n",
    "crime"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Health Care"
   ]
  },
  {
   "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>City</th>\n",
       "      <th>Health Care Index</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Taipei, Taiwan</td>\n",
       "      <td>86.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Chiang Mai, Thailand</td>\n",
       "      <td>84.56</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Seoul, South Korea</td>\n",
       "      <td>83.06</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Brisbane, Australia</td>\n",
       "      <td>82.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Cuenca, Ecuador</td>\n",
       "      <td>82.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>Hamilton, Canada</td>\n",
       "      <td>82.28</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>Canberra, Australia</td>\n",
       "      <td>82.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>Tokyo, Japan</td>\n",
       "      <td>81.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>Mangalore, India</td>\n",
       "      <td>80.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>Antwerp, Belgium</td>\n",
       "      <td>80.03</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>Vienna, Austria</td>\n",
       "      <td>79.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>Minneapolis, MN, United States</td>\n",
       "      <td>79.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>Madrid, Spain</td>\n",
       "      <td>78.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>Valencia, Spain</td>\n",
       "      <td>78.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>Glasgow, United Kingdom</td>\n",
       "      <td>78.58</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>Edmonton, Canada</td>\n",
       "      <td>78.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>Madison, WI, United States</td>\n",
       "      <td>78.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>Munich, Germany</td>\n",
       "      <td>78.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>Edinburgh, United Kingdom</td>\n",
       "      <td>78.50</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>Perth, Australia</td>\n",
       "      <td>78.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>The Hague (Den Haag), Netherlands</td>\n",
       "      <td>78.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>Sydney, Australia</td>\n",
       "      <td>78.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>Bursa, Turkey</td>\n",
       "      <td>78.22</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>Nizhny Novgorod, Russia</td>\n",
       "      <td>78.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>Guadalajara, Mexico</td>\n",
       "      <td>77.90</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>Copenhagen, Denmark</td>\n",
       "      <td>77.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>Leeds, United Kingdom</td>\n",
       "      <td>77.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>Bangkok, Thailand</td>\n",
       "      <td>77.59</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>Barcelona, Spain</td>\n",
       "      <td>77.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>Manchester, United Kingdom</td>\n",
       "      <td>77.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>Paris, France</td>\n",
       "      <td>77.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>31</td>\n",
       "      <td>Antalya, Turkey</td>\n",
       "      <td>76.74</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>32</td>\n",
       "      <td>Helsinki, Finland</td>\n",
       "      <td>76.70</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>33</td>\n",
       "      <td>Medellin, Colombia</td>\n",
       "      <td>76.65</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>34</td>\n",
       "      <td>Calgary, Canada</td>\n",
       "      <td>76.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>35</td>\n",
       "      <td>Brussels, Belgium</td>\n",
       "      <td>75.75</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>36</td>\n",
       "      <td>Adelaide, Australia</td>\n",
       "      <td>75.69</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>37</td>\n",
       "      <td>Gent, Belgium</td>\n",
       "      <td>75.48</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>38</td>\n",
       "      <td>Toronto, Canada</td>\n",
       "      <td>75.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>39</td>\n",
       "      <td>Brno, Czech Republic</td>\n",
       "      <td>75.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>40</td>\n",
       "      <td>Porto, Portugal</td>\n",
       "      <td>75.19</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41</td>\n",
       "      <td>Pattaya, Thailand</td>\n",
       "      <td>75.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>42</td>\n",
       "      <td>Melbourne, Australia</td>\n",
       "      <td>75.07</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>43</td>\n",
       "      <td>Raleigh, NC, United States</td>\n",
       "      <td>75.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>44</td>\n",
       "      <td>Eindhoven, Netherlands</td>\n",
       "      <td>74.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>45</td>\n",
       "      <td>Ottawa, Canada</td>\n",
       "      <td>74.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>46</td>\n",
       "      <td>Malaga, Spain</td>\n",
       "      <td>74.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>47</td>\n",
       "      <td>Vancouver, Canada</td>\n",
       "      <td>74.62</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>48</td>\n",
       "      <td>Boston, MA, United States</td>\n",
       "      <td>74.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>49</td>\n",
       "      <td>Oslo, Norway</td>\n",
       "      <td>74.46</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>50</td>\n",
       "      <td>Hamburg, Germany</td>\n",
       "      <td>74.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>51</td>\n",
       "      <td>Bergen, Norway</td>\n",
       "      <td>74.41</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>52</td>\n",
       "      <td>Cologne, Germany</td>\n",
       "      <td>74.37</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>53</td>\n",
       "      <td>Birmingham, United Kingdom</td>\n",
       "      <td>74.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>54</td>\n",
       "      <td>Luxembourg, Luxembourg</td>\n",
       "      <td>74.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>55</td>\n",
       "      <td>Charlotte, NC, United States</td>\n",
       "      <td>74.14</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>56</td>\n",
       "      <td>Haifa, Israel</td>\n",
       "      <td>74.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>57</td>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>74.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>58</td>\n",
       "      <td>Pittsburgh, PA, United States</td>\n",
       "      <td>73.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>59</td>\n",
       "      <td>Tel Aviv-Yafo, Israel</td>\n",
       "      <td>73.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>60</td>\n",
       "      <td>Zurich, Switzerland</td>\n",
       "      <td>73.52</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>61</td>\n",
       "      <td>Bristol, United Kingdom</td>\n",
       "      <td>73.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>62</td>\n",
       "      <td>Frankfurt, Germany</td>\n",
       "      <td>73.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>63</td>\n",
       "      <td>Kaunas, Lithuania</td>\n",
       "      <td>73.33</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>64</td>\n",
       "      <td>Prague, Czech Republic</td>\n",
       "      <td>73.25</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>65</td>\n",
       "      <td>Auckland, New Zealand</td>\n",
       "      <td>73.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>66</td>\n",
       "      <td>Seattle, WA, United States</td>\n",
       "      <td>73.04</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>67</td>\n",
       "      <td>Columbus, OH, United States</td>\n",
       "      <td>72.93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>68</td>\n",
       "      <td>Doha, Qatar</td>\n",
       "      <td>72.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>69</td>\n",
       "      <td>San Antonio, TX, United States</td>\n",
       "      <td>72.73</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>70</td>\n",
       "      <td>Portland, OR, United States</td>\n",
       "      <td>72.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>71</td>\n",
       "      <td>Gurgaon, India</td>\n",
       "      <td>72.44</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>72</td>\n",
       "      <td>Davao, Philippines</td>\n",
       "      <td>72.21</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>73</td>\n",
       "      <td>Colombo, Sri Lanka</td>\n",
       "      <td>71.95</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>74</td>\n",
       "      <td>Kochi, India</td>\n",
       "      <td>71.67</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>75</td>\n",
       "      <td>Izmir, Turkey</td>\n",
       "      <td>71.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>76</td>\n",
       "      <td>Houston, TX, United States</td>\n",
       "      <td>71.45</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>77</td>\n",
       "      <td>Lisbon, Portugal</td>\n",
       "      <td>71.36</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>78</td>\n",
       "      <td>Singapore, Singapore</td>\n",
       "      <td>71.35</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>79</td>\n",
       "      <td>Chennai, India</td>\n",
       "      <td>71.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>80</td>\n",
       "      <td>Coimbatore, India</td>\n",
       "      <td>71.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>81</td>\n",
       "      <td>Halifax, Canada</td>\n",
       "      <td>71.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>82</td>\n",
       "      <td>Victoria, Canada</td>\n",
       "      <td>71.12</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>83</td>\n",
       "      <td>Austin, TX, United States</td>\n",
       "      <td>70.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>84</td>\n",
       "      <td>Cape Town, South Africa</td>\n",
       "      <td>70.89</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>85</td>\n",
       "      <td>Stuttgart, Germany</td>\n",
       "      <td>70.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>86</td>\n",
       "      <td>Ahmedabad, India</td>\n",
       "      <td>70.84</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>87</td>\n",
       "      <td>San Diego, CA, United States</td>\n",
       "      <td>70.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>88</td>\n",
       "      <td>Salt Lake City, UT, United States</td>\n",
       "      <td>70.79</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>89</td>\n",
       "      <td>Malmo, Sweden</td>\n",
       "      <td>70.72</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>90</td>\n",
       "      <td>Philadelphia, PA, United States</td>\n",
       "      <td>70.47</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>91</td>\n",
       "      <td>Milan, Italy</td>\n",
       "      <td>70.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>92</td>\n",
       "      <td>Honolulu, HI, United States</td>\n",
       "      <td>70.26</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>93</td>\n",
       "      <td>Washington, DC, United States</td>\n",
       "      <td>70.23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>94</td>\n",
       "      <td>Amsterdam, Netherlands</td>\n",
       "      <td>70.08</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>95</td>\n",
       "      <td>Denver, CO, United States</td>\n",
       "      <td>69.83</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>96</td>\n",
       "      <td>Tallinn, Estonia</td>\n",
       "      <td>69.81</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>97</td>\n",
       "      <td>Belfast, United Kingdom</td>\n",
       "      <td>69.63</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>98</td>\n",
       "      <td>Buenos Aires, Argentina</td>\n",
       "      <td>69.61</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>99</td>\n",
       "      <td>Jerusalem, Israel</td>\n",
       "      <td>69.54</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>100</td>\n",
       "      <td>Indianapolis, IN, United States</td>\n",
       "      <td>69.40</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>101</td>\n",
       "      <td>Quito, Ecuador</td>\n",
       "      <td>69.29</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>102</td>\n",
       "      <td>San Francisco, CA, United States</td>\n",
       "      <td>69.13</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>103</td>\n",
       "      <td>Abu Dhabi, United Arab Emirates</td>\n",
       "      <td>69.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>104</td>\n",
       "      <td>San Jose, CA, United States</td>\n",
       "      <td>69.01</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>105</td>\n",
       "      <td>Berlin, Germany</td>\n",
       "      <td>68.97</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>106</td>\n",
       "      <td>Vilnius, Lithuania</td>\n",
       "      <td>68.78</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>107</td>\n",
       "      <td>London, United Kingdom</td>\n",
       "      <td>68.51</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>108</td>\n",
       "      <td>Winnipeg, Canada</td>\n",
       "      <td>68.43</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>109</td>\n",
       "      <td>Quebec City, Canada</td>\n",
       "      <td>68.42</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>110</td>\n",
       "      <td>Turin, Italy</td>\n",
       "      <td>68.31</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>111</td>\n",
       "      <td>Sacramento, CA, United States</td>\n",
       "      <td>68.27</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>112</td>\n",
       "      <td>Timisoara, Romania</td>\n",
       "      <td>68.20</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>113</td>\n",
       "      <td>Bangalore, India</td>\n",
       "      <td>68.18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>114</td>\n",
       "      <td>Istanbul, Turkey</td>\n",
       "      <td>68.16</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>115</td>\n",
       "      <td>Mumbai, India</td>\n",
       "      <td>68.15</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>116</td>\n",
       "      <td>Ankara, Turkey</td>\n",
       "      <td>68.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>117</td>\n",
       "      <td>Mississauga, Canada</td>\n",
       "      <td>68.11</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>118</td>\n",
       "      <td>Gothenburg, Sweden</td>\n",
       "      <td>68.10</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>119</td>\n",
       "      <td>Chicago, IL, United States</td>\n",
       "      <td>67.99</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>120</td>\n",
       "      <td>Fort Lauderdale, FL, United States</td>\n",
       "      <td>67.92</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>121</td>\n",
       "      <td>Regina, Canada</td>\n",
       "      <td>67.86</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>122</td>\n",
       "      <td>Albuquerque, NM, United States</td>\n",
       "      <td>67.80</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>123</td>\n",
       "      <td>Hyderabad, India</td>\n",
       "      <td>67.77</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>124</td>\n",
       "      <td>Pretoria, South Africa</td>\n",
       "      <td>67.43</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                   City  Health Care Index\n",
       "0                        Taipei, Taiwan              86.74\n",
       "1                  Chiang Mai, Thailand              84.56\n",
       "2                    Seoul, South Korea              83.06\n",
       "3                   Brisbane, Australia              82.48\n",
       "4                       Cuenca, Ecuador              82.44\n",
       "5                      Hamilton, Canada              82.28\n",
       "6                   Canberra, Australia              82.23\n",
       "7                          Tokyo, Japan              81.19\n",
       "8                      Mangalore, India              80.25\n",
       "9                      Antwerp, Belgium              80.03\n",
       "10                      Vienna, Austria              79.75\n",
       "11       Minneapolis, MN, United States              79.01\n",
       "12                        Madrid, Spain              78.81\n",
       "13                      Valencia, Spain              78.62\n",
       "14              Glasgow, United Kingdom              78.58\n",
       "15                     Edmonton, Canada              78.52\n",
       "16           Madison, WI, United States              78.51\n",
       "17                      Munich, Germany              78.50\n",
       "18            Edinburgh, United Kingdom              78.50\n",
       "19                     Perth, Australia              78.41\n",
       "20    The Hague (Den Haag), Netherlands              78.36\n",
       "21                    Sydney, Australia              78.27\n",
       "22                        Bursa, Turkey              78.22\n",
       "23              Nizhny Novgorod, Russia              78.13\n",
       "24                  Guadalajara, Mexico              77.90\n",
       "25                  Copenhagen, Denmark              77.81\n",
       "26                Leeds, United Kingdom              77.80\n",
       "27                    Bangkok, Thailand              77.59\n",
       "28                     Barcelona, Spain              77.52\n",
       "29           Manchester, United Kingdom              77.47\n",
       "30                        Paris, France              77.21\n",
       "31                      Antalya, Turkey              76.74\n",
       "32                    Helsinki, Finland              76.70\n",
       "33                   Medellin, Colombia              76.65\n",
       "34                      Calgary, Canada              76.47\n",
       "35                    Brussels, Belgium              75.75\n",
       "36                  Adelaide, Australia              75.69\n",
       "37                        Gent, Belgium              75.48\n",
       "38                      Toronto, Canada              75.47\n",
       "39                 Brno, Czech Republic              75.26\n",
       "40                      Porto, Portugal              75.19\n",
       "41                    Pattaya, Thailand              75.16\n",
       "42                 Melbourne, Australia              75.07\n",
       "43           Raleigh, NC, United States              75.01\n",
       "44               Eindhoven, Netherlands              74.89\n",
       "45                       Ottawa, Canada              74.79\n",
       "46                        Malaga, Spain              74.67\n",
       "47                    Vancouver, Canada              74.62\n",
       "48            Boston, MA, United States              74.54\n",
       "49                         Oslo, Norway              74.46\n",
       "50                     Hamburg, Germany              74.42\n",
       "51                       Bergen, Norway              74.41\n",
       "52                     Cologne, Germany              74.37\n",
       "53           Birmingham, United Kingdom              74.16\n",
       "54               Luxembourg, Luxembourg              74.14\n",
       "55         Charlotte, NC, United States              74.14\n",
       "56                        Haifa, Israel              74.12\n",
       "57              Wellington, New Zealand              74.12\n",
       "58        Pittsburgh, PA, United States              73.93\n",
       "59                Tel Aviv-Yafo, Israel              73.89\n",
       "60                  Zurich, Switzerland              73.52\n",
       "61              Bristol, United Kingdom              73.40\n",
       "62                   Frankfurt, Germany              73.35\n",
       "63                    Kaunas, Lithuania              73.33\n",
       "64               Prague, Czech Republic              73.25\n",
       "65                Auckland, New Zealand              73.21\n",
       "66           Seattle, WA, United States              73.04\n",
       "67          Columbus, OH, United States              72.93\n",
       "68                          Doha, Qatar              72.81\n",
       "69       San Antonio, TX, United States              72.73\n",
       "70          Portland, OR, United States              72.63\n",
       "71                       Gurgaon, India              72.44\n",
       "72                   Davao, Philippines              72.21\n",
       "73                   Colombo, Sri Lanka              71.95\n",
       "74                         Kochi, India              71.67\n",
       "75                        Izmir, Turkey              71.54\n",
       "76           Houston, TX, United States              71.45\n",
       "77                     Lisbon, Portugal              71.36\n",
       "78                 Singapore, Singapore              71.35\n",
       "79                       Chennai, India              71.27\n",
       "80                    Coimbatore, India              71.26\n",
       "81                      Halifax, Canada              71.26\n",
       "82                     Victoria, Canada              71.12\n",
       "83            Austin, TX, United States              70.92\n",
       "84              Cape Town, South Africa              70.89\n",
       "85                   Stuttgart, Germany              70.86\n",
       "86                     Ahmedabad, India              70.84\n",
       "87         San Diego, CA, United States              70.83\n",
       "88    Salt Lake City, UT, United States              70.79\n",
       "89                        Malmo, Sweden              70.72\n",
       "90      Philadelphia, PA, United States              70.47\n",
       "91                         Milan, Italy              70.43\n",
       "92          Honolulu, HI, United States              70.26\n",
       "93        Washington, DC, United States              70.23\n",
       "94               Amsterdam, Netherlands              70.08\n",
       "95            Denver, CO, United States              69.83\n",
       "96                     Tallinn, Estonia              69.81\n",
       "97              Belfast, United Kingdom              69.63\n",
       "98              Buenos Aires, Argentina              69.61\n",
       "99                    Jerusalem, Israel              69.54\n",
       "100     Indianapolis, IN, United States              69.40\n",
       "101                      Quito, Ecuador              69.29\n",
       "102    San Francisco, CA, United States              69.13\n",
       "103     Abu Dhabi, United Arab Emirates              69.01\n",
       "104         San Jose, CA, United States              69.01\n",
       "105                     Berlin, Germany              68.97\n",
       "106                  Vilnius, Lithuania              68.78\n",
       "107              London, United Kingdom              68.51\n",
       "108                    Winnipeg, Canada              68.43\n",
       "109                 Quebec City, Canada              68.42\n",
       "110                        Turin, Italy              68.31\n",
       "111       Sacramento, CA, United States              68.27\n",
       "112                  Timisoara, Romania              68.20\n",
       "113                    Bangalore, India              68.18\n",
       "114                    Istanbul, Turkey              68.16\n",
       "115                       Mumbai, India              68.15\n",
       "116                      Ankara, Turkey              68.11\n",
       "117                 Mississauga, Canada              68.11\n",
       "118                  Gothenburg, Sweden              68.10\n",
       "119          Chicago, IL, United States              67.99\n",
       "120  Fort Lauderdale, FL, United States              67.92\n",
       "121                      Regina, Canada              67.86\n",
       "122      Albuquerque, NM, United States              67.80\n",
       "123                    Hyderabad, India              67.77\n",
       "124              Pretoria, South Africa              67.43"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "health_care = get_numbeo_dataframe(\"https://www.numbeo.com/health-care/rankings_current.jsp\", \n",
    "                                   \"Health Care Index\", current_city, lower_is_better = False)\n",
    "\n",
    "health_care"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Combined Result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "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>City</th>\n",
       "      <th>Local Purchasing Power Index</th>\n",
       "      <th>Price To Income Ratio</th>\n",
       "      <th>Crime Index</th>\n",
       "      <th>Health Care Index</th>\n",
       "      <th>Country</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>Columbus, OH, United States</td>\n",
       "      <td>133.75</td>\n",
       "      <td>2.06</td>\n",
       "      <td>41.51</td>\n",
       "      <td>72.93</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>Pittsburgh, PA, United States</td>\n",
       "      <td>107.90</td>\n",
       "      <td>2.18</td>\n",
       "      <td>36.09</td>\n",
       "      <td>73.93</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>Charlotte, NC, United States</td>\n",
       "      <td>132.57</td>\n",
       "      <td>2.58</td>\n",
       "      <td>42.68</td>\n",
       "      <td>74.14</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>Raleigh, NC, United States</td>\n",
       "      <td>148.77</td>\n",
       "      <td>2.62</td>\n",
       "      <td>31.76</td>\n",
       "      <td>75.01</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>Madison, WI, United States</td>\n",
       "      <td>126.09</td>\n",
       "      <td>3.30</td>\n",
       "      <td>29.12</td>\n",
       "      <td>78.51</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>5</td>\n",
       "      <td>Austin, TX, United States</td>\n",
       "      <td>146.27</td>\n",
       "      <td>3.81</td>\n",
       "      <td>35.37</td>\n",
       "      <td>70.92</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>6</td>\n",
       "      <td>Edmonton, Canada</td>\n",
       "      <td>116.93</td>\n",
       "      <td>3.93</td>\n",
       "      <td>42.79</td>\n",
       "      <td>78.52</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>7</td>\n",
       "      <td>Salt Lake City, UT, United States</td>\n",
       "      <td>129.38</td>\n",
       "      <td>3.98</td>\n",
       "      <td>28.75</td>\n",
       "      <td>70.79</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>8</td>\n",
       "      <td>Denver, CO, United States</td>\n",
       "      <td>131.79</td>\n",
       "      <td>4.34</td>\n",
       "      <td>40.61</td>\n",
       "      <td>69.83</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>9</td>\n",
       "      <td>Adelaide, Australia</td>\n",
       "      <td>125.75</td>\n",
       "      <td>4.47</td>\n",
       "      <td>31.40</td>\n",
       "      <td>75.69</td>\n",
       "      <td>Australia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>10</td>\n",
       "      <td>Calgary, Canada</td>\n",
       "      <td>136.13</td>\n",
       "      <td>4.59</td>\n",
       "      <td>32.19</td>\n",
       "      <td>76.47</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>11</td>\n",
       "      <td>Ottawa, Canada</td>\n",
       "      <td>125.95</td>\n",
       "      <td>4.67</td>\n",
       "      <td>24.64</td>\n",
       "      <td>74.79</td>\n",
       "      <td>Canada</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>12</td>\n",
       "      <td>Eindhoven, Netherlands</td>\n",
       "      <td>111.89</td>\n",
       "      <td>5.04</td>\n",
       "      <td>25.83</td>\n",
       "      <td>74.89</td>\n",
       "      <td>Netherlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>13</td>\n",
       "      <td>San Diego, CA, United States</td>\n",
       "      <td>134.56</td>\n",
       "      <td>5.34</td>\n",
       "      <td>36.45</td>\n",
       "      <td>70.83</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>14</td>\n",
       "      <td>Abu Dhabi, United Arab Emirates</td>\n",
       "      <td>101.47</td>\n",
       "      <td>5.60</td>\n",
       "      <td>11.07</td>\n",
       "      <td>69.01</td>\n",
       "      <td>United Arab Emirates</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>15</td>\n",
       "      <td>Brisbane, Australia</td>\n",
       "      <td>124.97</td>\n",
       "      <td>5.71</td>\n",
       "      <td>34.03</td>\n",
       "      <td>82.48</td>\n",
       "      <td>Australia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>16</td>\n",
       "      <td>Doha, Qatar</td>\n",
       "      <td>109.04</td>\n",
       "      <td>5.97</td>\n",
       "      <td>11.33</td>\n",
       "      <td>72.81</td>\n",
       "      <td>Qatar</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>17</td>\n",
       "      <td>The Hague (Den Haag), Netherlands</td>\n",
       "      <td>95.52</td>\n",
       "      <td>6.30</td>\n",
       "      <td>26.23</td>\n",
       "      <td>78.36</td>\n",
       "      <td>Netherlands</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>18</td>\n",
       "      <td>Wellington, New Zealand</td>\n",
       "      <td>104.71</td>\n",
       "      <td>6.41</td>\n",
       "      <td>29.35</td>\n",
       "      <td>74.12</td>\n",
       "      <td>New Zealand</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>19</td>\n",
       "      <td>Perth, Australia</td>\n",
       "      <td>111.57</td>\n",
       "      <td>6.81</td>\n",
       "      <td>43.76</td>\n",
       "      <td>78.41</td>\n",
       "      <td>Australia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>20</td>\n",
       "      <td>Bergen, Norway</td>\n",
       "      <td>98.01</td>\n",
       "      <td>7.89</td>\n",
       "      <td>27.72</td>\n",
       "      <td>74.41</td>\n",
       "      <td>Norway</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>21</td>\n",
       "      <td>Boston, MA, United States</td>\n",
       "      <td>115.52</td>\n",
       "      <td>8.17</td>\n",
       "      <td>34.46</td>\n",
       "      <td>74.54</td>\n",
       "      <td>United States</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>22</td>\n",
       "      <td>Zurich, Switzerland</td>\n",
       "      <td>131.34</td>\n",
       "      <td>8.47</td>\n",
       "      <td>17.32</td>\n",
       "      <td>73.52</td>\n",
       "      <td>Switzerland</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>23</td>\n",
       "      <td>Copenhagen, Denmark</td>\n",
       "      <td>96.22</td>\n",
       "      <td>9.46</td>\n",
       "      <td>22.89</td>\n",
       "      <td>77.81</td>\n",
       "      <td>Denmark</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>24</td>\n",
       "      <td>Cologne, Germany</td>\n",
       "      <td>104.12</td>\n",
       "      <td>10.37</td>\n",
       "      <td>43.27</td>\n",
       "      <td>74.37</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>25</td>\n",
       "      <td>Frankfurt, Germany</td>\n",
       "      <td>106.32</td>\n",
       "      <td>10.59</td>\n",
       "      <td>40.92</td>\n",
       "      <td>73.35</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>26</td>\n",
       "      <td>Stuttgart, Germany</td>\n",
       "      <td>107.50</td>\n",
       "      <td>10.81</td>\n",
       "      <td>26.93</td>\n",
       "      <td>70.86</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>27</td>\n",
       "      <td>Berlin, Germany</td>\n",
       "      <td>100.31</td>\n",
       "      <td>11.10</td>\n",
       "      <td>40.48</td>\n",
       "      <td>68.97</td>\n",
       "      <td>Germany</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>28</td>\n",
       "      <td>Sydney, Australia</td>\n",
       "      <td>103.86</td>\n",
       "      <td>11.34</td>\n",
       "      <td>35.55</td>\n",
       "      <td>78.27</td>\n",
       "      <td>Australia</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>29</td>\n",
       "      <td>Luxembourg, Luxembourg</td>\n",
       "      <td>103.96</td>\n",
       "      <td>11.71</td>\n",
       "      <td>28.95</td>\n",
       "      <td>74.14</td>\n",
       "      <td>Luxembourg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>30</td>\n",
       "      <td>Helsinki, Finland</td>\n",
       "      <td>97.47</td>\n",
       "      <td>12.09</td>\n",
       "      <td>22.01</td>\n",
       "      <td>76.70</td>\n",
       "      <td>Finland</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                 City  Local Purchasing Power Index  \\\n",
       "0         Columbus, OH, United States                        133.75   \n",
       "1       Pittsburgh, PA, United States                        107.90   \n",
       "2        Charlotte, NC, United States                        132.57   \n",
       "3          Raleigh, NC, United States                        148.77   \n",
       "4          Madison, WI, United States                        126.09   \n",
       "5           Austin, TX, United States                        146.27   \n",
       "6                    Edmonton, Canada                        116.93   \n",
       "7   Salt Lake City, UT, United States                        129.38   \n",
       "8           Denver, CO, United States                        131.79   \n",
       "9                 Adelaide, Australia                        125.75   \n",
       "10                    Calgary, Canada                        136.13   \n",
       "11                     Ottawa, Canada                        125.95   \n",
       "12             Eindhoven, Netherlands                        111.89   \n",
       "13       San Diego, CA, United States                        134.56   \n",
       "14    Abu Dhabi, United Arab Emirates                        101.47   \n",
       "15                Brisbane, Australia                        124.97   \n",
       "16                        Doha, Qatar                        109.04   \n",
       "17  The Hague (Den Haag), Netherlands                         95.52   \n",
       "18            Wellington, New Zealand                        104.71   \n",
       "19                   Perth, Australia                        111.57   \n",
       "20                     Bergen, Norway                         98.01   \n",
       "21          Boston, MA, United States                        115.52   \n",
       "22                Zurich, Switzerland                        131.34   \n",
       "23                Copenhagen, Denmark                         96.22   \n",
       "24                   Cologne, Germany                        104.12   \n",
       "25                 Frankfurt, Germany                        106.32   \n",
       "26                 Stuttgart, Germany                        107.50   \n",
       "27                    Berlin, Germany                        100.31   \n",
       "28                  Sydney, Australia                        103.86   \n",
       "29             Luxembourg, Luxembourg                        103.96   \n",
       "30                  Helsinki, Finland                         97.47   \n",
       "\n",
       "    Price To Income Ratio  Crime Index  Health Care Index  \\\n",
       "0                    2.06        41.51              72.93   \n",
       "1                    2.18        36.09              73.93   \n",
       "2                    2.58        42.68              74.14   \n",
       "3                    2.62        31.76              75.01   \n",
       "4                    3.30        29.12              78.51   \n",
       "5                    3.81        35.37              70.92   \n",
       "6                    3.93        42.79              78.52   \n",
       "7                    3.98        28.75              70.79   \n",
       "8                    4.34        40.61              69.83   \n",
       "9                    4.47        31.40              75.69   \n",
       "10                   4.59        32.19              76.47   \n",
       "11                   4.67        24.64              74.79   \n",
       "12                   5.04        25.83              74.89   \n",
       "13                   5.34        36.45              70.83   \n",
       "14                   5.60        11.07              69.01   \n",
       "15                   5.71        34.03              82.48   \n",
       "16                   5.97        11.33              72.81   \n",
       "17                   6.30        26.23              78.36   \n",
       "18                   6.41        29.35              74.12   \n",
       "19                   6.81        43.76              78.41   \n",
       "20                   7.89        27.72              74.41   \n",
       "21                   8.17        34.46              74.54   \n",
       "22                   8.47        17.32              73.52   \n",
       "23                   9.46        22.89              77.81   \n",
       "24                  10.37        43.27              74.37   \n",
       "25                  10.59        40.92              73.35   \n",
       "26                  10.81        26.93              70.86   \n",
       "27                  11.10        40.48              68.97   \n",
       "28                  11.34        35.55              78.27   \n",
       "29                  11.71        28.95              74.14   \n",
       "30                  12.09        22.01              76.70   \n",
       "\n",
       "                 Country  \n",
       "0          United States  \n",
       "1          United States  \n",
       "2          United States  \n",
       "3          United States  \n",
       "4          United States  \n",
       "5          United States  \n",
       "6                 Canada  \n",
       "7          United States  \n",
       "8          United States  \n",
       "9              Australia  \n",
       "10                Canada  \n",
       "11                Canada  \n",
       "12           Netherlands  \n",
       "13         United States  \n",
       "14  United Arab Emirates  \n",
       "15             Australia  \n",
       "16                 Qatar  \n",
       "17           Netherlands  \n",
       "18           New Zealand  \n",
       "19             Australia  \n",
       "20                Norway  \n",
       "21         United States  \n",
       "22           Switzerland  \n",
       "23               Denmark  \n",
       "24               Germany  \n",
       "25               Germany  \n",
       "26               Germany  \n",
       "27               Germany  \n",
       "28             Australia  \n",
       "29            Luxembourg  \n",
       "30               Finland  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from functools import reduce\n",
    "\n",
    "dfs = [purchasing_power, property_prices, crime, health_care]\n",
    "df_combined = reduce(lambda left, right: pd.merge(left, right, on = \"City\"), dfs)\n",
    "\n",
    "df_combined[\"Country\"] = df_combined.City.str.split(\", \").str[-1]\n",
    "countries_interested = [\"United States\", \"Canada\", \"Australia\", \"United Kingdom\", \"Ireland\", \"South Africa\", \"New Zealand\", \"Singapore\"]\n",
    "#df_combined = df_combined[df_combined.Country.isin(countries_interested)]\n",
    "\n",
    "df_combined.sort_values(\"Price To Income Ratio\", ascending = True).reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}