Top10Trending.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 113,
   "id": "434fd821",
   "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>name</th>\n",
       "      <th>stars</th>\n",
       "      <th>review_count</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Cheers Cafe</td>\n",
       "      <td>5.0</td>\n",
       "      <td>6</td>\n",
       "      <td>39.986842</td>\n",
       "      <td>-75.101025</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Gayle</td>\n",
       "      <td>4.5</td>\n",
       "      <td>18</td>\n",
       "      <td>39.940934</td>\n",
       "      <td>-75.147618</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Yummy Diner</td>\n",
       "      <td>4.5</td>\n",
       "      <td>6</td>\n",
       "      <td>39.961100</td>\n",
       "      <td>-75.224897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Shank &amp; Evelyn's Frankies At Night Eclipse Cafe</td>\n",
       "      <td>4.5</td>\n",
       "      <td>5</td>\n",
       "      <td>39.938326</td>\n",
       "      <td>-75.159773</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Saute</td>\n",
       "      <td>4.0</td>\n",
       "      <td>25</td>\n",
       "      <td>39.937879</td>\n",
       "      <td>-75.144534</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Bistro Juliana</td>\n",
       "      <td>4.0</td>\n",
       "      <td>14</td>\n",
       "      <td>39.975071</td>\n",
       "      <td>-75.118352</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Roselena's</td>\n",
       "      <td>4.0</td>\n",
       "      <td>10</td>\n",
       "      <td>39.929374</td>\n",
       "      <td>-75.163843</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Astral Plane</td>\n",
       "      <td>4.0</td>\n",
       "      <td>9</td>\n",
       "      <td>39.945161</td>\n",
       "      <td>-75.170498</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>El Provocon Restaurant II</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7</td>\n",
       "      <td>40.022009</td>\n",
       "      <td>-75.126147</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Aspen</td>\n",
       "      <td>4.0</td>\n",
       "      <td>7</td>\n",
       "      <td>39.968780</td>\n",
       "      <td>-75.178154</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                              name  stars  review_count  \\\n",
       "0                                      Cheers Cafe    5.0             6   \n",
       "1                                            Gayle    4.5            18   \n",
       "2                                      Yummy Diner    4.5             6   \n",
       "3  Shank & Evelyn's Frankies At Night Eclipse Cafe    4.5             5   \n",
       "4                                            Saute    4.0            25   \n",
       "5                                   Bistro Juliana    4.0            14   \n",
       "6                                       Roselena's    4.0            10   \n",
       "7                                     Astral Plane    4.0             9   \n",
       "8                        El Provocon Restaurant II    4.0             7   \n",
       "9                                            Aspen    4.0             7   \n",
       "\n",
       "    latitude  longitude  \n",
       "0  39.986842 -75.101025  \n",
       "1  39.940934 -75.147618  \n",
       "2  39.961100 -75.224897  \n",
       "3  39.938326 -75.159773  \n",
       "4  39.937879 -75.144534  \n",
       "5  39.975071 -75.118352  \n",
       "6  39.929374 -75.163843  \n",
       "7  39.945161 -75.170498  \n",
       "8  40.022009 -75.126147  \n",
       "9  39.968780 -75.178154  "
      ]
     },
     "execution_count": 113,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pymongo\n",
    "from pymongo import MongoClient, GEO2D\n",
    "from bson.son import SON\n",
    "client = MongoClient('mongodb://localhost:27017/')\n",
    "db = client.restaurants\n",
    "business = db.business\n",
    "business.find_one()\n",
    "business.aggregate([{ \"$addFields\": { \"geolocation\": [\"$longitude\", \"$latitude\" ] }},{ \"$out\": \"business\" }])\n",
    "business.find_one()\n",
    "business.create_index([(\"geolocation\", GEO2D)])\n",
    "result = db.business.find({ \"$and\":[{ \"city\": \"Philadelphia\" },{\"categories\":\"Restaurants\"},{\"geolocation\":SON([(\"$near\", [-75.0447831, 40.0261449]),(\"$maxDistance\", 0.2)])}]}).sort([{\"stars\",pymongo.DESCENDING},{\"review_count\",pymongo.DESCENDING}]).limit(10)\n",
    "query = list(result)\n",
    "df = pd.DataFrame(query)\n",
    "keyword_df = df.get(['name', 'stars', 'review_count', 'latitude', 'longitude'])\n",
    "keyword_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 114,
   "id": "1cbcd8c2",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div style=\"width:100%;\"><div style=\"position:relative;width:100%;height:0;padding-bottom:60%;\"><span style=\"color:#565656\">Make this Notebook Trusted to load map: File -> Trust Notebook</span><iframe srcdoc=\"&lt;!DOCTYPE html&gt;\n",
       "&lt;head&gt;    \n",
       "    &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=UTF-8&quot; /&gt;\n",
       "    \n",
       "        &lt;script&gt;\n",
       "            L_NO_TOUCH = false;\n",
       "            L_DISABLE_3D = false;\n",
       "        &lt;/script&gt;\n",
       "    \n",
       "    &lt;style&gt;html, body {width: 100%;height: 100%;margin: 0;padding: 0;}&lt;/style&gt;\n",
       "    &lt;style&gt;#map {position:absolute;top:0;bottom:0;right:0;left:0;}&lt;/style&gt;\n",
       "    &lt;script src=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.6.0/dist/leaflet.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://code.jquery.com/jquery-1.12.4.min.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/js/bootstrap.min.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;script src=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.js&quot;&gt;&lt;/script&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/npm/leaflet@1.6.0/dist/leaflet.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/bootstrap/3.2.0/css/bootstrap-theme.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://maxcdn.bootstrapcdn.com/font-awesome/4.6.3/css/font-awesome.min.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdnjs.cloudflare.com/ajax/libs/Leaflet.awesome-markers/2.0.2/leaflet.awesome-markers.css&quot;/&gt;\n",
       "    &lt;link rel=&quot;stylesheet&quot; href=&quot;https://cdn.jsdelivr.net/gh/python-visualization/folium/folium/templates/leaflet.awesome.rotate.min.css&quot;/&gt;\n",
       "    \n",
       "            &lt;meta name=&quot;viewport&quot; content=&quot;width=device-width,\n",
       "                initial-scale=1.0, maximum-scale=1.0, user-scalable=no&quot; /&gt;\n",
       "            &lt;style&gt;\n",
       "                #map_f650809267438dce5b2446b0dafbee25 {\n",
       "                    position: relative;\n",
       "                    width: 100.0%;\n",
       "                    height: 100.0%;\n",
       "                    left: 0.0%;\n",
       "                    top: 0.0%;\n",
       "                }\n",
       "            &lt;/style&gt;\n",
       "        \n",
       "&lt;/head&gt;\n",
       "&lt;body&gt;    \n",
       "    \n",
       "            &lt;div class=&quot;folium-map&quot; id=&quot;map_f650809267438dce5b2446b0dafbee25&quot; &gt;&lt;/div&gt;\n",
       "        \n",
       "&lt;/body&gt;\n",
       "&lt;script&gt;    \n",
       "    \n",
       "            var map_f650809267438dce5b2446b0dafbee25 = L.map(\n",
       "                &quot;map_f650809267438dce5b2446b0dafbee25&quot;,\n",
       "                {\n",
       "                    center: [39.9525839, -75.1652215],\n",
       "                    crs: L.CRS.EPSG3857,\n",
       "                    zoom: 12,\n",
       "                    zoomControl: true,\n",
       "                    preferCanvas: false,\n",
       "                }\n",
       "            );\n",
       "\n",
       "            \n",
       "\n",
       "        \n",
       "    \n",
       "            var tile_layer_e5c60774179dde67a24d1bb360773b49 = L.tileLayer(\n",
       "                &quot;https://{s}.tile.openstreetmap.org/{z}/{x}/{y}.png&quot;,\n",
       "                {&quot;attribution&quot;: &quot;Data by \\u0026copy; \\u003ca href=\\&quot;http://openstreetmap.org\\&quot;\\u003eOpenStreetMap\\u003c/a\\u003e, under \\u003ca href=\\&quot;http://www.openstreetmap.org/copyright\\&quot;\\u003eODbL\\u003c/a\\u003e.&quot;, &quot;detectRetina&quot;: false, &quot;maxNativeZoom&quot;: 18, &quot;maxZoom&quot;: 18, &quot;minZoom&quot;: 0, &quot;noWrap&quot;: false, &quot;opacity&quot;: 1, &quot;subdomains&quot;: &quot;abc&quot;, &quot;tms&quot;: false}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var marker_86c5003224ed5837be86060ff53f8695 = L.marker(\n",
       "                [39.9868416, -75.1010248],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_1d8ec96701785eb5458b04cddf57e584 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_86c5003224ed5837be86060ff53f8695.setIcon(icon_1d8ec96701785eb5458b04cddf57e584);\n",
       "        \n",
       "    \n",
       "        var popup_a15614000795271fa7451c2d9c7101f4 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_896b38c611c577c2a1cb1dcf7d6e5de9 = $(`&lt;div id=&quot;html_896b38c611c577c2a1cb1dcf7d6e5de9&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Cheers Cafe Rating: 5.0 Reviews: 6&lt;/div&gt;`)[0];\n",
       "            popup_a15614000795271fa7451c2d9c7101f4.setContent(html_896b38c611c577c2a1cb1dcf7d6e5de9);\n",
       "        \n",
       "\n",
       "        marker_86c5003224ed5837be86060ff53f8695.bindPopup(popup_a15614000795271fa7451c2d9c7101f4)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_d6d9a9a80c0aea5ddd4476e3719fcc77 = L.marker(\n",
       "                [39.9409344, -75.1476183],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_73329a02057cec7fb2784bde88cde7a2 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_d6d9a9a80c0aea5ddd4476e3719fcc77.setIcon(icon_73329a02057cec7fb2784bde88cde7a2);\n",
       "        \n",
       "    \n",
       "        var popup_10efd7c796ffb1313421cbd6b6a8a999 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_9f29f5cb3e5f034505d02c5df8c31d16 = $(`&lt;div id=&quot;html_9f29f5cb3e5f034505d02c5df8c31d16&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Gayle Rating: 4.5 Reviews: 18&lt;/div&gt;`)[0];\n",
       "            popup_10efd7c796ffb1313421cbd6b6a8a999.setContent(html_9f29f5cb3e5f034505d02c5df8c31d16);\n",
       "        \n",
       "\n",
       "        marker_d6d9a9a80c0aea5ddd4476e3719fcc77.bindPopup(popup_10efd7c796ffb1313421cbd6b6a8a999)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_b167687a69a16a0a40378b056832c2e8 = L.marker(\n",
       "                [39.9611001, -75.2248974],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_66cbd0ff4762138917f0c8c8fc03a4ce = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_b167687a69a16a0a40378b056832c2e8.setIcon(icon_66cbd0ff4762138917f0c8c8fc03a4ce);\n",
       "        \n",
       "    \n",
       "        var popup_2f77423b0883e5e1539ee92c7f239d19 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_f849e60e903de1dd2dc8789bfe7464e7 = $(`&lt;div id=&quot;html_f849e60e903de1dd2dc8789bfe7464e7&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Yummy Diner Rating: 4.5 Reviews: 6&lt;/div&gt;`)[0];\n",
       "            popup_2f77423b0883e5e1539ee92c7f239d19.setContent(html_f849e60e903de1dd2dc8789bfe7464e7);\n",
       "        \n",
       "\n",
       "        marker_b167687a69a16a0a40378b056832c2e8.bindPopup(popup_2f77423b0883e5e1539ee92c7f239d19)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_51de5c48d007b5b3eaaf998422444dde = L.marker(\n",
       "                [39.938326, -75.1597731],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_a4cf44d4455484bdb63cb9c2efd73d7f = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_51de5c48d007b5b3eaaf998422444dde.setIcon(icon_a4cf44d4455484bdb63cb9c2efd73d7f);\n",
       "        \n",
       "    \n",
       "        var popup_b972848bf8e1cb7cc9ec38e3756cebec = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_46b45c1ae80fe96dfbd4e88a3daa193d = $(`&lt;div id=&quot;html_46b45c1ae80fe96dfbd4e88a3daa193d&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Shank &amp; Evelyn&#x27;s Frankies At Night Eclipse Cafe Rating: 4.5 Reviews: 5&lt;/div&gt;`)[0];\n",
       "            popup_b972848bf8e1cb7cc9ec38e3756cebec.setContent(html_46b45c1ae80fe96dfbd4e88a3daa193d);\n",
       "        \n",
       "\n",
       "        marker_51de5c48d007b5b3eaaf998422444dde.bindPopup(popup_b972848bf8e1cb7cc9ec38e3756cebec)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_358bc0fdd9465dd296588a46fbbcc366 = L.marker(\n",
       "                [39.937879, -75.1445339],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_5da55acabda837b7dcde1da07c7a8023 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_358bc0fdd9465dd296588a46fbbcc366.setIcon(icon_5da55acabda837b7dcde1da07c7a8023);\n",
       "        \n",
       "    \n",
       "        var popup_2a5945fd7b9e7a49f6c94aa450424697 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_59db9d04529597bb78345650b8376d20 = $(`&lt;div id=&quot;html_59db9d04529597bb78345650b8376d20&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Saute Rating: 4.0 Reviews: 25&lt;/div&gt;`)[0];\n",
       "            popup_2a5945fd7b9e7a49f6c94aa450424697.setContent(html_59db9d04529597bb78345650b8376d20);\n",
       "        \n",
       "\n",
       "        marker_358bc0fdd9465dd296588a46fbbcc366.bindPopup(popup_2a5945fd7b9e7a49f6c94aa450424697)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_a54d3f3b60b70f859699b24db9f67718 = L.marker(\n",
       "                [39.975071, -75.118352],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_3cb6abbc2eb121c83c9a0dc3efe425ce = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_a54d3f3b60b70f859699b24db9f67718.setIcon(icon_3cb6abbc2eb121c83c9a0dc3efe425ce);\n",
       "        \n",
       "    \n",
       "        var popup_a50c50a5c10d51e0e79655753674d2c9 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_4cae42ed2824130cd5f373d369329f31 = $(`&lt;div id=&quot;html_4cae42ed2824130cd5f373d369329f31&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Bistro Juliana Rating: 4.0 Reviews: 14&lt;/div&gt;`)[0];\n",
       "            popup_a50c50a5c10d51e0e79655753674d2c9.setContent(html_4cae42ed2824130cd5f373d369329f31);\n",
       "        \n",
       "\n",
       "        marker_a54d3f3b60b70f859699b24db9f67718.bindPopup(popup_a50c50a5c10d51e0e79655753674d2c9)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_1755e92e06c670653511aa815656ebfe = L.marker(\n",
       "                [39.929374, -75.1638426],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_b68a7ef128ef134e080363be79931414 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_1755e92e06c670653511aa815656ebfe.setIcon(icon_b68a7ef128ef134e080363be79931414);\n",
       "        \n",
       "    \n",
       "        var popup_0562f7a7d220820a912047ce90c7c63a = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_ab1c4821f2d63fbd6a301b80a0a3508c = $(`&lt;div id=&quot;html_ab1c4821f2d63fbd6a301b80a0a3508c&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Roselena&#x27;s Rating: 4.0 Reviews: 10&lt;/div&gt;`)[0];\n",
       "            popup_0562f7a7d220820a912047ce90c7c63a.setContent(html_ab1c4821f2d63fbd6a301b80a0a3508c);\n",
       "        \n",
       "\n",
       "        marker_1755e92e06c670653511aa815656ebfe.bindPopup(popup_0562f7a7d220820a912047ce90c7c63a)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_98b177b19a8d36d2f4ad54c61abf56aa = L.marker(\n",
       "                [39.9451614, -75.170498],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_28ff4a0ac9c2d380dd9d640f9237ffef = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_98b177b19a8d36d2f4ad54c61abf56aa.setIcon(icon_28ff4a0ac9c2d380dd9d640f9237ffef);\n",
       "        \n",
       "    \n",
       "        var popup_d4ca12c4eb1cb6a2bd2c9dbf043bc04c = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_4a949f805b903c86918587ef74e7cd50 = $(`&lt;div id=&quot;html_4a949f805b903c86918587ef74e7cd50&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Astral Plane Rating: 4.0 Reviews: 9&lt;/div&gt;`)[0];\n",
       "            popup_d4ca12c4eb1cb6a2bd2c9dbf043bc04c.setContent(html_4a949f805b903c86918587ef74e7cd50);\n",
       "        \n",
       "\n",
       "        marker_98b177b19a8d36d2f4ad54c61abf56aa.bindPopup(popup_d4ca12c4eb1cb6a2bd2c9dbf043bc04c)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_06aa86bcad2979e067e738bd4c6777de = L.marker(\n",
       "                [40.0220092, -75.1261474],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_8934aa7e6594c28d02a5155fb98decc4 = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_06aa86bcad2979e067e738bd4c6777de.setIcon(icon_8934aa7e6594c28d02a5155fb98decc4);\n",
       "        \n",
       "    \n",
       "        var popup_089fcc5ff2953d9dacacbb5f8d806b4b = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_b487f4afcb1c9f1dd0752545bd9ab399 = $(`&lt;div id=&quot;html_b487f4afcb1c9f1dd0752545bd9ab399&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;El Provocon Restaurant II Rating: 4.0 Reviews: 7&lt;/div&gt;`)[0];\n",
       "            popup_089fcc5ff2953d9dacacbb5f8d806b4b.setContent(html_b487f4afcb1c9f1dd0752545bd9ab399);\n",
       "        \n",
       "\n",
       "        marker_06aa86bcad2979e067e738bd4c6777de.bindPopup(popup_089fcc5ff2953d9dacacbb5f8d806b4b)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "    \n",
       "            var marker_7a89a347989abc8863a1f6ba2767cdd8 = L.marker(\n",
       "                [39.9687798, -75.1781543],\n",
       "                {}\n",
       "            ).addTo(map_f650809267438dce5b2446b0dafbee25);\n",
       "        \n",
       "    \n",
       "            var icon_67afb27bdeffaa485c4d5cd3a2ba868a = L.AwesomeMarkers.icon(\n",
       "                {&quot;extraClasses&quot;: &quot;fa-rotate-0&quot;, &quot;icon&quot;: &quot;info-sign&quot;, &quot;iconColor&quot;: &quot;white&quot;, &quot;markerColor&quot;: &quot;red&quot;, &quot;prefix&quot;: &quot;glyphicon&quot;}\n",
       "            );\n",
       "            marker_7a89a347989abc8863a1f6ba2767cdd8.setIcon(icon_67afb27bdeffaa485c4d5cd3a2ba868a);\n",
       "        \n",
       "    \n",
       "        var popup_b5a784b2c49fa17961313c9451660c68 = L.popup({&quot;maxWidth&quot;: &quot;100%&quot;});\n",
       "\n",
       "        \n",
       "            var html_b7c3b24e96f9403f0af5a02869089512 = $(`&lt;div id=&quot;html_b7c3b24e96f9403f0af5a02869089512&quot; style=&quot;width: 100.0%; height: 100.0%;&quot;&gt;Aspen Rating: 4.0 Reviews: 7&lt;/div&gt;`)[0];\n",
       "            popup_b5a784b2c49fa17961313c9451660c68.setContent(html_b7c3b24e96f9403f0af5a02869089512);\n",
       "        \n",
       "\n",
       "        marker_7a89a347989abc8863a1f6ba2767cdd8.bindPopup(popup_b5a784b2c49fa17961313c9451660c68)\n",
       "        ;\n",
       "\n",
       "        \n",
       "    \n",
       "&lt;/script&gt;\" style=\"position:absolute;width:100%;height:100%;left:0;top:0;border:none !important;\" allowfullscreen webkitallowfullscreen mozallowfullscreen></iframe></div></div>"
      ],
      "text/plain": [
       "<folium.folium.Map at 0x202353e09d0>"
      ]
     },
     "execution_count": 114,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import folium\n",
    "import pandas as pd     \n",
    "from IPython.display import display\n",
    "PA_coordinates = [39.9525839, -75.1652215]\n",
    "restaurant_map = folium.Map(location = PA_coordinates, zoom_start = 12) \n",
    "for i in range(0,len(keyword_df)):\n",
    "    folium.Marker(location=[keyword_df.iloc[i]['latitude'], keyword_df.iloc[i]['longitude']],\n",
    "                  popup=keyword_df.iloc[i]['name'] + '\\n' + \\\n",
    "                        'Rating: ' + str(keyword_df.iloc[i]['stars']) + '\\n' + \\\n",
    "                        'Reviews: ' + str(keyword_df.iloc[i]['review_count']), \\\n",
    "                  icon=folium.Icon(color='red')).add_to(restaurant_map)\n",
    "restaurant_map"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "030d3a4e",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}