twitterSenti.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>Time</th>\n",
       "      <th>user</th>\n",
       "      <th>text</th>\n",
       "      <th>latitude</th>\n",
       "      <th>longitude</th>\n",
       "      <th>Location</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>27730062</td>\n",
       "      <td>Sat Nov 17 05:51:28 +0000 2018</td>\n",
       "      <td>ibp3000</td>\n",
       "      <td>b'Driving around Chicago. Listening to their h...</td>\n",
       "      <td>41.921692</td>\n",
       "      <td>-87.668659</td>\n",
       "      <td>(41.92169189,-87.66865874)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>114648155</td>\n",
       "      <td>Sat Nov 17 05:50:49 +0000 2018</td>\n",
       "      <td>southlowe</td>\n",
       "      <td>b'I couldn?t decide. #snapseed #chicago @ Chic...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>91243723</td>\n",
       "      <td>Sat Nov 17 05:49:43 +0000 2018</td>\n",
       "      <td>JonathanSWest</td>\n",
       "      <td>b\"Why do I @choosechicago? Tonight's 105th ann...</td>\n",
       "      <td>41.883333</td>\n",
       "      <td>-87.633333</td>\n",
       "      <td>(41.88333333,-87.63333333)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>24905463</td>\n",
       "      <td>Sat Nov 17 05:49:39 +0000 2018</td>\n",
       "      <td>ChefJoeJo</td>\n",
       "      <td>b'Just posted a photo @ Malcolm X College http...</td>\n",
       "      <td>41.877853</td>\n",
       "      <td>-87.675490</td>\n",
       "      <td>(41.87785329,-87.67549038)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>592430543</td>\n",
       "      <td>Sat Nov 17 05:48:55 +0000 2018</td>\n",
       "      <td>rmuench22</td>\n",
       "      <td>b'8 years later and I still can?t shake these ...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>37494340</td>\n",
       "      <td>Sat Nov 17 05:48:03 +0000 2018</td>\n",
       "      <td>ChiraqQua</td>\n",
       "      <td>b'Rock wit us. #RvRRadioShow #ChiraqQua #ChiCi...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>111993437</td>\n",
       "      <td>Sat Nov 17 05:48:02 +0000 2018</td>\n",
       "      <td>syntax72</td>\n",
       "      <td>b'Hail Satan 666 - Drinking a Logsdon Table Br...</td>\n",
       "      <td>41.921700</td>\n",
       "      <td>-87.656200</td>\n",
       "      <td>(41.9217,-87.6562)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>431136327</td>\n",
       "      <td>Sat Nov 17 05:47:11 +0000 2018</td>\n",
       "      <td>SeanTierney66</td>\n",
       "      <td>b'KINGS WIN!!! #KingsWin #KINGSvsCHI #LAKvsCHI...</td>\n",
       "      <td>41.880599</td>\n",
       "      <td>-87.673998</td>\n",
       "      <td>(41.88059904,-87.67399833)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>18954317</td>\n",
       "      <td>Sat Nov 17 05:42:52 +0000 2018</td>\n",
       "      <td>theultimatetv</td>\n",
       "      <td>b'May The Force is with You! #Chitag2018 @ Chi...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>2458242680</td>\n",
       "      <td>Sat Nov 17 05:42:00 +0000 2018</td>\n",
       "      <td>TheBrewLife402</td>\n",
       "      <td>b'#FOBAB - Drinking a Daisy Cutter Pale Ale by...</td>\n",
       "      <td>41.880900</td>\n",
       "      <td>-87.647000</td>\n",
       "      <td>(41.8809,-87.647)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>373038991</td>\n",
       "      <td>Sat Nov 17 05:38:02 +0000 2018</td>\n",
       "      <td>JanzenHanz</td>\n",
       "      <td>b'It?s ? out there so I remind you to protect ...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>317998471</td>\n",
       "      <td>Sat Nov 17 05:37:56 +0000 2018</td>\n",
       "      <td>SeanCTheBrand</td>\n",
       "      <td>b'It?s a wrap? #SetLife Living a #Dream #MrBro...</td>\n",
       "      <td>41.885534</td>\n",
       "      <td>-87.627322</td>\n",
       "      <td>(41.88553413,-87.62732172)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>42632503</td>\n",
       "      <td>Sat Nov 17 05:37:20 +0000 2018</td>\n",
       "      <td>GreenEggsNSamm</td>\n",
       "      <td>b'Rhinos make good pillows for pibbles.\\n#pitb...</td>\n",
       "      <td>41.899722</td>\n",
       "      <td>-87.650000</td>\n",
       "      <td>(41.89972222,-87.65)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>17188482</td>\n",
       "      <td>Sat Nov 17 05:37:11 +0000 2018</td>\n",
       "      <td>Radha824</td>\n",
       "      <td>b'Good friends, good wine, good fun. So thankf...</td>\n",
       "      <td>41.939580</td>\n",
       "      <td>-87.663420</td>\n",
       "      <td>(41.93958,-87.66342)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>18954317</td>\n",
       "      <td>Sat Nov 17 05:37:09 +0000 2018</td>\n",
       "      <td>theultimatetv</td>\n",
       "      <td>b'See you there!! #Chitag2018 @ Navy Pier http...</td>\n",
       "      <td>41.891690</td>\n",
       "      <td>-87.608340</td>\n",
       "      <td>(41.891690000000004,-87.60834)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>51271349</td>\n",
       "      <td>Sat Nov 17 05:36:25 +0000 2018</td>\n",
       "      <td>Angelinthepits</td>\n",
       "      <td>b'rezz @ Official Aragon Ballroom https://t.co...</td>\n",
       "      <td>41.969303</td>\n",
       "      <td>-87.658037</td>\n",
       "      <td>(41.96930347,-87.65803652)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>176642704</td>\n",
       "      <td>Sat Nov 17 05:31:06 +0000 2018</td>\n",
       "      <td>SotomayorJade</td>\n",
       "      <td>b\"Showtime at Big Jims in 15 mins. Come thru n...</td>\n",
       "      <td>41.945691</td>\n",
       "      <td>-87.649250</td>\n",
       "      <td>(41.945691100000005,-87.6492505)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>362588867</td>\n",
       "      <td>Sat Nov 17 05:30:53 +0000 2018</td>\n",
       "      <td>gmingay</td>\n",
       "      <td>b\"Hyped. #TurtleRacing #Chicago @ Big Joe's 2 ...</td>\n",
       "      <td>41.976222</td>\n",
       "      <td>-87.675538</td>\n",
       "      <td>(41.976222,-87.675538)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>4549162582</td>\n",
       "      <td>Sat Nov 17 05:30:08 +0000 2018</td>\n",
       "      <td>everylotchicago</td>\n",
       "      <td>b'4451 North Springfield Avenue https://t.co/V...</td>\n",
       "      <td>41.962510</td>\n",
       "      <td>-87.725070</td>\n",
       "      <td>(41.962509999999995,-87.72507)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>20652816</td>\n",
       "      <td>Sat Nov 17 05:26:33 +0000 2018</td>\n",
       "      <td>lilgayafg</td>\n",
       "      <td>b'Lmao I?m so awkward why do I go out in public'</td>\n",
       "      <td>41.973328</td>\n",
       "      <td>-87.668013</td>\n",
       "      <td>(41.97332764,-87.66801333)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>794160156</td>\n",
       "      <td>Sat Nov 17 05:19:27 +0000 2018</td>\n",
       "      <td>bluecoconut16</td>\n",
       "      <td>b'The study-at-the-bar experiment lasted for a...</td>\n",
       "      <td>41.944660</td>\n",
       "      <td>-87.654104</td>\n",
       "      <td>(41.94466,-87.6541041)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>902523643</td>\n",
       "      <td>Sat Nov 17 05:15:54 +0000 2018</td>\n",
       "      <td>krosschicago</td>\n",
       "      <td>b'TAO taochicago Friday night........#Chicago ...</td>\n",
       "      <td>41.893449</td>\n",
       "      <td>-87.629995</td>\n",
       "      <td>(41.89344867,-87.62999475)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>20450591</td>\n",
       "      <td>Sat Nov 17 05:11:20 +0000 2018</td>\n",
       "      <td>emoleechen</td>\n",
       "      <td>b\"I'm at The James Chicago-Magnificent Mile - ...</td>\n",
       "      <td>41.893133</td>\n",
       "      <td>-87.625733</td>\n",
       "      <td>(41.89313254,-87.62573272)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>882122462640656384</td>\n",
       "      <td>Sat Nov 17 05:11:15 +0000 2018</td>\n",
       "      <td>KaitstheName</td>\n",
       "      <td>b'Mom got a new bed frame ... we got a new han...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>4549162582</td>\n",
       "      <td>Sat Nov 17 05:10:08 +0000 2018</td>\n",
       "      <td>everylotchicago</td>\n",
       "      <td>b'4459 North Springfield Avenue https://t.co/K...</td>\n",
       "      <td>41.962740</td>\n",
       "      <td>-87.725080</td>\n",
       "      <td>(41.962740000000004,-87.72508)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>111993437</td>\n",
       "      <td>Sat Nov 17 05:10:00 +0000 2018</td>\n",
       "      <td>syntax72</td>\n",
       "      <td>b'Hail Satan. - Drinking a Rohrwerker by @Pipe...</td>\n",
       "      <td>41.921700</td>\n",
       "      <td>-87.656200</td>\n",
       "      <td>(41.9217,-87.6562)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>69174353</td>\n",
       "      <td>Sat Nov 17 05:09:30 +0000 2018</td>\n",
       "      <td>FRANKROB107</td>\n",
       "      <td>b'LESS THAN AN HOUR AWAY UNTIL @windycitylive ...</td>\n",
       "      <td>41.885442</td>\n",
       "      <td>-87.628050</td>\n",
       "      <td>(41.88544236,-87.62805026)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>362588867</td>\n",
       "      <td>Sat Nov 17 05:06:59 +0000 2018</td>\n",
       "      <td>gmingay</td>\n",
       "      <td>b\"These two. A rare sighting seeing them hangi...</td>\n",
       "      <td>41.976222</td>\n",
       "      <td>-87.675538</td>\n",
       "      <td>(41.976222,-87.675538)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>2762115149</td>\n",
       "      <td>Sat Nov 17 05:05:53 +0000 2018</td>\n",
       "      <td>jangles308</td>\n",
       "      <td>b'#datenight. I have an original and first @Ma...</td>\n",
       "      <td>41.956493</td>\n",
       "      <td>-87.723677</td>\n",
       "      <td>(41.95649348,-87.72367709999999)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>259756781</td>\n",
       "      <td>Sat Nov 17 05:05:49 +0000 2018</td>\n",
       "      <td>shawnamphotog</td>\n",
       "      <td>b\"Working on a few Chicago pics this weekend. ...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>14665382</td>\n",
       "      <td>Sat Nov 17 02:36:12 +0000 2018</td>\n",
       "      <td>larryodean</td>\n",
       "      <td>b'Welcome back to the Folk You! stage, Tom Hen...</td>\n",
       "      <td>41.954430</td>\n",
       "      <td>-87.676530</td>\n",
       "      <td>(41.95443,-87.67653)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>1116311</td>\n",
       "      <td>Sat Nov 17 02:36:01 +0000 2018</td>\n",
       "      <td>bcbeatty</td>\n",
       "      <td>b'#fobab - Drinking a Swimming In the Mangrove...</td>\n",
       "      <td>41.866900</td>\n",
       "      <td>-87.646500</td>\n",
       "      <td>(41.8669,-87.6465)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>145469568</td>\n",
       "      <td>Sat Nov 17 02:34:24 +0000 2018</td>\n",
       "      <td>fee4three</td>\n",
       "      <td>b'Right now ! Pull up bourbonondivision #heart...</td>\n",
       "      <td>41.903470</td>\n",
       "      <td>-87.679230</td>\n",
       "      <td>(41.90347,-87.67923)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>260309337</td>\n",
       "      <td>Sat Nov 17 02:34:06 +0000 2018</td>\n",
       "      <td>timdalliday</td>\n",
       "      <td>b'Go Hawks Go! @ United Center https://t.co/9L...</td>\n",
       "      <td>41.880599</td>\n",
       "      <td>-87.673998</td>\n",
       "      <td>(41.88059904,-87.67399833)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>17039396</td>\n",
       "      <td>Sat Nov 17 02:34:06 +0000 2018</td>\n",
       "      <td>JustinAAronson</td>\n",
       "      <td>b'Drinking an Off-Black by @HopewellBrewing @ ...</td>\n",
       "      <td>41.923800</td>\n",
       "      <td>-87.698500</td>\n",
       "      <td>(41.9238,-87.6985)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>249012572</td>\n",
       "      <td>Sat Nov 17 02:34:03 +0000 2018</td>\n",
       "      <td>Sandeezy88</td>\n",
       "      <td>b'Drinking a Willettized Coffee Stout by @lagu...</td>\n",
       "      <td>41.866900</td>\n",
       "      <td>-87.646500</td>\n",
       "      <td>(41.8669,-87.6465)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>970342743397617664</td>\n",
       "      <td>Sat Nov 17 02:32:20 +0000 2018</td>\n",
       "      <td>BrevonDarksteel</td>\n",
       "      <td>b'Our beautiful  view of Chicago , getting rea...</td>\n",
       "      <td>41.892000</td>\n",
       "      <td>-87.627500</td>\n",
       "      <td>(41.891999999999996,-87.6275)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>1975824030</td>\n",
       "      <td>Sat Nov 17 02:32:14 +0000 2018</td>\n",
       "      <td>Jennandherjugs</td>\n",
       "      <td>b'\"Let me just say: peace to you if you\\'re wi...</td>\n",
       "      <td>41.945029</td>\n",
       "      <td>-87.690758</td>\n",
       "      <td>(41.94502912,-87.69075804)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>443783189</td>\n",
       "      <td>Sat Nov 17 02:31:52 +0000 2018</td>\n",
       "      <td>TFEBOSS</td>\n",
       "      <td>b\"Tonight's Cook Up ?? #StillWorking #PowerCir...</td>\n",
       "      <td>41.966384</td>\n",
       "      <td>-87.639212</td>\n",
       "      <td>(41.96638353,-87.63921222)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>34136263</td>\n",
       "      <td>Sat Nov 17 02:31:05 +0000 2018</td>\n",
       "      <td>brainsc</td>\n",
       "      <td>b'I like your style. #FOBAB - Drinking a Blend...</td>\n",
       "      <td>41.866900</td>\n",
       "      <td>-87.646500</td>\n",
       "      <td>(41.8669,-87.6465)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>249012572</td>\n",
       "      <td>Sat Nov 17 02:31:02 +0000 2018</td>\n",
       "      <td>Sandeezy88</td>\n",
       "      <td>b'Drinking a Mind FK by @MaplewoodBeer @ FoBAB...</td>\n",
       "      <td>41.866900</td>\n",
       "      <td>-87.646500</td>\n",
       "      <td>(41.8669,-87.6465)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>2440034389</td>\n",
       "      <td>Sat Nov 17 02:30:13 +0000 2018</td>\n",
       "      <td>eleria_j</td>\n",
       "      <td>b'the windy city @ Chicago, Illinois https://t...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>4549162582</td>\n",
       "      <td>Sat Nov 17 02:30:07 +0000 2018</td>\n",
       "      <td>everylotchicago</td>\n",
       "      <td>b'3908 West Montrose Avenue https://t.co/xIaKp...</td>\n",
       "      <td>41.961250</td>\n",
       "      <td>-87.725850</td>\n",
       "      <td>(41.96125,-87.72585)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>201144866</td>\n",
       "      <td>Sat Nov 17 02:29:41 +0000 2018</td>\n",
       "      <td>BoDiDeederRMG</td>\n",
       "      <td>b'#linkinbio #trapfever ?? @ South Side, Chica...</td>\n",
       "      <td>41.867100</td>\n",
       "      <td>-87.621600</td>\n",
       "      <td>(41.8671,-87.6216)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>2994194153</td>\n",
       "      <td>Sat Nov 17 02:27:23 +0000 2018</td>\n",
       "      <td>jason_pettus</td>\n",
       "      <td>b'Intermission at #mst3klive here in Chicago t...</td>\n",
       "      <td>41.935453</td>\n",
       "      <td>-87.663984</td>\n",
       "      <td>(41.93545345,-87.66398415)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>27296789</td>\n",
       "      <td>Sat Nov 17 02:26:32 +0000 2018</td>\n",
       "      <td>BreezyAllDay</td>\n",
       "      <td>b'All of this is currently at the Gala except ...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>29231959</td>\n",
       "      <td>Sat Nov 17 02:26:27 +0000 2018</td>\n",
       "      <td>iamderrickstwtr</td>\n",
       "      <td>b'#PurpleSkyline @ Chicago Riverwalk https://t...</td>\n",
       "      <td>41.888400</td>\n",
       "      <td>-87.618971</td>\n",
       "      <td>(41.88840017,-87.61897076)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>122204506</td>\n",
       "      <td>Sat Nov 17 02:26:05 +0000 2018</td>\n",
       "      <td>PrincezzAmira</td>\n",
       "      <td>b'Just posted a photo @ Chicago, Illinois http...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>103</th>\n",
       "      <td>114878796</td>\n",
       "      <td>Sat Nov 17 02:25:29 +0000 2018</td>\n",
       "      <td>PIXSiGHT</td>\n",
       "      <td>b'Getting ready is aways fun with some #mimosa...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>104</th>\n",
       "      <td>31753577</td>\n",
       "      <td>Sat Nov 17 02:25:12 +0000 2018</td>\n",
       "      <td>gfloreso</td>\n",
       "      <td>b\"I'm at @Pequods Pizzeria in Chicago, IL http...</td>\n",
       "      <td>41.921890</td>\n",
       "      <td>-87.664520</td>\n",
       "      <td>(41.921890000000005,-87.66452)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>105</th>\n",
       "      <td>456463630</td>\n",
       "      <td>Sat Nov 17 02:24:29 +0000 2018</td>\n",
       "      <td>Pjdaisy13</td>\n",
       "      <td>b'Back when you were one of my people awnasha ...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>106</th>\n",
       "      <td>15950511</td>\n",
       "      <td>Sat Nov 17 02:24:02 +0000 2018</td>\n",
       "      <td>pmgarcia</td>\n",
       "      <td>b\"#conceptmapping causes of fetal death #nearp...</td>\n",
       "      <td>41.895911</td>\n",
       "      <td>-87.620652</td>\n",
       "      <td>(41.8959115,-87.6206521)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>107</th>\n",
       "      <td>580439637</td>\n",
       "      <td>Sat Nov 17 02:23:28 +0000 2018</td>\n",
       "      <td>leemaris129</td>\n",
       "      <td>b'Wish my phone camera could capture how prett...</td>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "      <td>(41.883221999999996,-87.632496)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>108</th>\n",
       "      <td>100376054</td>\n",
       "      <td>Sat Nov 17 02:23:20 +0000 2018</td>\n",
       "      <td>geraldmbailey</td>\n",
       "      <td>b'Playing a live set with brownbabyjesus on dr...</td>\n",
       "      <td>41.887170</td>\n",
       "      <td>-87.651840</td>\n",
       "      <td>(41.887170000000005,-87.65184)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>109</th>\n",
       "      <td>33880035</td>\n",
       "      <td>Sat Nov 17 02:22:55 +0000 2018</td>\n",
       "      <td>jamiefranz</td>\n",
       "      <td>b'This class act to my ?? turned 40! Happy Bir...</td>\n",
       "      <td>41.930470</td>\n",
       "      <td>-87.688230</td>\n",
       "      <td>(41.93047,-87.68823)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>110</th>\n",
       "      <td>2797920078</td>\n",
       "      <td>Sat Nov 17 02:21:55 +0000 2018</td>\n",
       "      <td>CiderSoms</td>\n",
       "      <td>b'We?ve arrived at the rightbeecider take over...</td>\n",
       "      <td>41.932870</td>\n",
       "      <td>-87.655040</td>\n",
       "      <td>(41.93287,-87.65504)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>111</th>\n",
       "      <td>20450591</td>\n",
       "      <td>Sat Nov 17 02:21:42 +0000 2018</td>\n",
       "      <td>emoleechen</td>\n",
       "      <td>b\"I'm at Homeslice in Chicago, IL https://t.co...</td>\n",
       "      <td>41.921867</td>\n",
       "      <td>-87.652453</td>\n",
       "      <td>(41.92186675,-87.65245276)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>112</th>\n",
       "      <td>249012572</td>\n",
       "      <td>Sat Nov 17 02:19:58 +0000 2018</td>\n",
       "      <td>Sandeezy88</td>\n",
       "      <td>b'Drinking a Bourbon County Brand Coffee Barle...</td>\n",
       "      <td>41.866900</td>\n",
       "      <td>-87.646500</td>\n",
       "      <td>(41.8669,-87.6465)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>113</th>\n",
       "      <td>925744053223800832</td>\n",
       "      <td>Sat Nov 17 02:19:37 +0000 2018</td>\n",
       "      <td>JobsAtInsight</td>\n",
       "      <td>b\"Want to work at Insight? We're #hiring in #C...</td>\n",
       "      <td>41.878114</td>\n",
       "      <td>-87.629798</td>\n",
       "      <td>(41.8781136,-87.62979820000001)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>114</th>\n",
       "      <td>28103557</td>\n",
       "      <td>Sat Nov 17 02:18:42 +0000 2018</td>\n",
       "      <td>philliprabie</td>\n",
       "      <td>b'Wine, Dine, and everythings Fine...\\n#friend...</td>\n",
       "      <td>41.898150</td>\n",
       "      <td>-87.637329</td>\n",
       "      <td>(41.89815,-87.63732857)</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>115 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                     id                            Time             user  \\\n",
       "0              27730062  Sat Nov 17 05:51:28 +0000 2018          ibp3000   \n",
       "1             114648155  Sat Nov 17 05:50:49 +0000 2018        southlowe   \n",
       "2              91243723  Sat Nov 17 05:49:43 +0000 2018    JonathanSWest   \n",
       "3              24905463  Sat Nov 17 05:49:39 +0000 2018        ChefJoeJo   \n",
       "4             592430543  Sat Nov 17 05:48:55 +0000 2018        rmuench22   \n",
       "5              37494340  Sat Nov 17 05:48:03 +0000 2018        ChiraqQua   \n",
       "6             111993437  Sat Nov 17 05:48:02 +0000 2018         syntax72   \n",
       "7             431136327  Sat Nov 17 05:47:11 +0000 2018    SeanTierney66   \n",
       "8              18954317  Sat Nov 17 05:42:52 +0000 2018    theultimatetv   \n",
       "9            2458242680  Sat Nov 17 05:42:00 +0000 2018   TheBrewLife402   \n",
       "10            373038991  Sat Nov 17 05:38:02 +0000 2018       JanzenHanz   \n",
       "11            317998471  Sat Nov 17 05:37:56 +0000 2018    SeanCTheBrand   \n",
       "12             42632503  Sat Nov 17 05:37:20 +0000 2018   GreenEggsNSamm   \n",
       "13             17188482  Sat Nov 17 05:37:11 +0000 2018         Radha824   \n",
       "14             18954317  Sat Nov 17 05:37:09 +0000 2018    theultimatetv   \n",
       "15             51271349  Sat Nov 17 05:36:25 +0000 2018   Angelinthepits   \n",
       "16            176642704  Sat Nov 17 05:31:06 +0000 2018    SotomayorJade   \n",
       "17            362588867  Sat Nov 17 05:30:53 +0000 2018          gmingay   \n",
       "18           4549162582  Sat Nov 17 05:30:08 +0000 2018  everylotchicago   \n",
       "19             20652816  Sat Nov 17 05:26:33 +0000 2018        lilgayafg   \n",
       "20            794160156  Sat Nov 17 05:19:27 +0000 2018    bluecoconut16   \n",
       "21            902523643  Sat Nov 17 05:15:54 +0000 2018     krosschicago   \n",
       "22             20450591  Sat Nov 17 05:11:20 +0000 2018       emoleechen   \n",
       "23   882122462640656384  Sat Nov 17 05:11:15 +0000 2018     KaitstheName   \n",
       "24           4549162582  Sat Nov 17 05:10:08 +0000 2018  everylotchicago   \n",
       "25            111993437  Sat Nov 17 05:10:00 +0000 2018         syntax72   \n",
       "26             69174353  Sat Nov 17 05:09:30 +0000 2018      FRANKROB107   \n",
       "27            362588867  Sat Nov 17 05:06:59 +0000 2018          gmingay   \n",
       "28           2762115149  Sat Nov 17 05:05:53 +0000 2018       jangles308   \n",
       "29            259756781  Sat Nov 17 05:05:49 +0000 2018    shawnamphotog   \n",
       "..                  ...                             ...              ...   \n",
       "85             14665382  Sat Nov 17 02:36:12 +0000 2018       larryodean   \n",
       "86              1116311  Sat Nov 17 02:36:01 +0000 2018         bcbeatty   \n",
       "87            145469568  Sat Nov 17 02:34:24 +0000 2018        fee4three   \n",
       "88            260309337  Sat Nov 17 02:34:06 +0000 2018      timdalliday   \n",
       "89             17039396  Sat Nov 17 02:34:06 +0000 2018   JustinAAronson   \n",
       "90            249012572  Sat Nov 17 02:34:03 +0000 2018       Sandeezy88   \n",
       "91   970342743397617664  Sat Nov 17 02:32:20 +0000 2018  BrevonDarksteel   \n",
       "92           1975824030  Sat Nov 17 02:32:14 +0000 2018   Jennandherjugs   \n",
       "93            443783189  Sat Nov 17 02:31:52 +0000 2018          TFEBOSS   \n",
       "94             34136263  Sat Nov 17 02:31:05 +0000 2018          brainsc   \n",
       "95            249012572  Sat Nov 17 02:31:02 +0000 2018       Sandeezy88   \n",
       "96           2440034389  Sat Nov 17 02:30:13 +0000 2018         eleria_j   \n",
       "97           4549162582  Sat Nov 17 02:30:07 +0000 2018  everylotchicago   \n",
       "98            201144866  Sat Nov 17 02:29:41 +0000 2018    BoDiDeederRMG   \n",
       "99           2994194153  Sat Nov 17 02:27:23 +0000 2018     jason_pettus   \n",
       "100            27296789  Sat Nov 17 02:26:32 +0000 2018     BreezyAllDay   \n",
       "101            29231959  Sat Nov 17 02:26:27 +0000 2018  iamderrickstwtr   \n",
       "102           122204506  Sat Nov 17 02:26:05 +0000 2018    PrincezzAmira   \n",
       "103           114878796  Sat Nov 17 02:25:29 +0000 2018         PIXSiGHT   \n",
       "104            31753577  Sat Nov 17 02:25:12 +0000 2018         gfloreso   \n",
       "105           456463630  Sat Nov 17 02:24:29 +0000 2018        Pjdaisy13   \n",
       "106            15950511  Sat Nov 17 02:24:02 +0000 2018         pmgarcia   \n",
       "107           580439637  Sat Nov 17 02:23:28 +0000 2018      leemaris129   \n",
       "108           100376054  Sat Nov 17 02:23:20 +0000 2018    geraldmbailey   \n",
       "109            33880035  Sat Nov 17 02:22:55 +0000 2018       jamiefranz   \n",
       "110          2797920078  Sat Nov 17 02:21:55 +0000 2018        CiderSoms   \n",
       "111            20450591  Sat Nov 17 02:21:42 +0000 2018       emoleechen   \n",
       "112           249012572  Sat Nov 17 02:19:58 +0000 2018       Sandeezy88   \n",
       "113  925744053223800832  Sat Nov 17 02:19:37 +0000 2018    JobsAtInsight   \n",
       "114            28103557  Sat Nov 17 02:18:42 +0000 2018     philliprabie   \n",
       "\n",
       "                                                  text   latitude  longitude  \\\n",
       "0    b'Driving around Chicago. Listening to their h...  41.921692 -87.668659   \n",
       "1    b'I couldn?t decide. #snapseed #chicago @ Chic...  41.883222 -87.632496   \n",
       "2    b\"Why do I @choosechicago? Tonight's 105th ann...  41.883333 -87.633333   \n",
       "3    b'Just posted a photo @ Malcolm X College http...  41.877853 -87.675490   \n",
       "4    b'8 years later and I still can?t shake these ...  41.883222 -87.632496   \n",
       "5    b'Rock wit us. #RvRRadioShow #ChiraqQua #ChiCi...  41.883222 -87.632496   \n",
       "6    b'Hail Satan 666 - Drinking a Logsdon Table Br...  41.921700 -87.656200   \n",
       "7    b'KINGS WIN!!! #KingsWin #KINGSvsCHI #LAKvsCHI...  41.880599 -87.673998   \n",
       "8    b'May The Force is with You! #Chitag2018 @ Chi...  41.883222 -87.632496   \n",
       "9    b'#FOBAB - Drinking a Daisy Cutter Pale Ale by...  41.880900 -87.647000   \n",
       "10   b'It?s ? out there so I remind you to protect ...  41.883222 -87.632496   \n",
       "11   b'It?s a wrap? #SetLife Living a #Dream #MrBro...  41.885534 -87.627322   \n",
       "12   b'Rhinos make good pillows for pibbles.\\n#pitb...  41.899722 -87.650000   \n",
       "13   b'Good friends, good wine, good fun. So thankf...  41.939580 -87.663420   \n",
       "14   b'See you there!! #Chitag2018 @ Navy Pier http...  41.891690 -87.608340   \n",
       "15   b'rezz @ Official Aragon Ballroom https://t.co...  41.969303 -87.658037   \n",
       "16   b\"Showtime at Big Jims in 15 mins. Come thru n...  41.945691 -87.649250   \n",
       "17   b\"Hyped. #TurtleRacing #Chicago @ Big Joe's 2 ...  41.976222 -87.675538   \n",
       "18   b'4451 North Springfield Avenue https://t.co/V...  41.962510 -87.725070   \n",
       "19    b'Lmao I?m so awkward why do I go out in public'  41.973328 -87.668013   \n",
       "20   b'The study-at-the-bar experiment lasted for a...  41.944660 -87.654104   \n",
       "21   b'TAO taochicago Friday night........#Chicago ...  41.893449 -87.629995   \n",
       "22   b\"I'm at The James Chicago-Magnificent Mile - ...  41.893133 -87.625733   \n",
       "23   b'Mom got a new bed frame ... we got a new han...  41.883222 -87.632496   \n",
       "24   b'4459 North Springfield Avenue https://t.co/K...  41.962740 -87.725080   \n",
       "25   b'Hail Satan. - Drinking a Rohrwerker by @Pipe...  41.921700 -87.656200   \n",
       "26   b'LESS THAN AN HOUR AWAY UNTIL @windycitylive ...  41.885442 -87.628050   \n",
       "27   b\"These two. A rare sighting seeing them hangi...  41.976222 -87.675538   \n",
       "28   b'#datenight. I have an original and first @Ma...  41.956493 -87.723677   \n",
       "29   b\"Working on a few Chicago pics this weekend. ...  41.883222 -87.632496   \n",
       "..                                                 ...        ...        ...   \n",
       "85   b'Welcome back to the Folk You! stage, Tom Hen...  41.954430 -87.676530   \n",
       "86   b'#fobab - Drinking a Swimming In the Mangrove...  41.866900 -87.646500   \n",
       "87   b'Right now ! Pull up bourbonondivision #heart...  41.903470 -87.679230   \n",
       "88   b'Go Hawks Go! @ United Center https://t.co/9L...  41.880599 -87.673998   \n",
       "89   b'Drinking an Off-Black by @HopewellBrewing @ ...  41.923800 -87.698500   \n",
       "90   b'Drinking a Willettized Coffee Stout by @lagu...  41.866900 -87.646500   \n",
       "91   b'Our beautiful  view of Chicago , getting rea...  41.892000 -87.627500   \n",
       "92   b'\"Let me just say: peace to you if you\\'re wi...  41.945029 -87.690758   \n",
       "93   b\"Tonight's Cook Up ?? #StillWorking #PowerCir...  41.966384 -87.639212   \n",
       "94   b'I like your style. #FOBAB - Drinking a Blend...  41.866900 -87.646500   \n",
       "95   b'Drinking a Mind FK by @MaplewoodBeer @ FoBAB...  41.866900 -87.646500   \n",
       "96   b'the windy city @ Chicago, Illinois https://t...  41.883222 -87.632496   \n",
       "97   b'3908 West Montrose Avenue https://t.co/xIaKp...  41.961250 -87.725850   \n",
       "98   b'#linkinbio #trapfever ?? @ South Side, Chica...  41.867100 -87.621600   \n",
       "99   b'Intermission at #mst3klive here in Chicago t...  41.935453 -87.663984   \n",
       "100  b'All of this is currently at the Gala except ...  41.883222 -87.632496   \n",
       "101  b'#PurpleSkyline @ Chicago Riverwalk https://t...  41.888400 -87.618971   \n",
       "102  b'Just posted a photo @ Chicago, Illinois http...  41.883222 -87.632496   \n",
       "103  b'Getting ready is aways fun with some #mimosa...  41.883222 -87.632496   \n",
       "104  b\"I'm at @Pequods Pizzeria in Chicago, IL http...  41.921890 -87.664520   \n",
       "105  b'Back when you were one of my people awnasha ...  41.883222 -87.632496   \n",
       "106  b\"#conceptmapping causes of fetal death #nearp...  41.895911 -87.620652   \n",
       "107  b'Wish my phone camera could capture how prett...  41.883222 -87.632496   \n",
       "108  b'Playing a live set with brownbabyjesus on dr...  41.887170 -87.651840   \n",
       "109  b'This class act to my ?? turned 40! Happy Bir...  41.930470 -87.688230   \n",
       "110  b'We?ve arrived at the rightbeecider take over...  41.932870 -87.655040   \n",
       "111  b\"I'm at Homeslice in Chicago, IL https://t.co...  41.921867 -87.652453   \n",
       "112  b'Drinking a Bourbon County Brand Coffee Barle...  41.866900 -87.646500   \n",
       "113  b\"Want to work at Insight? We're #hiring in #C...  41.878114 -87.629798   \n",
       "114  b'Wine, Dine, and everythings Fine...\\n#friend...  41.898150 -87.637329   \n",
       "\n",
       "                             Location  \n",
       "0          (41.92169189,-87.66865874)  \n",
       "1     (41.883221999999996,-87.632496)  \n",
       "2          (41.88333333,-87.63333333)  \n",
       "3          (41.87785329,-87.67549038)  \n",
       "4     (41.883221999999996,-87.632496)  \n",
       "5     (41.883221999999996,-87.632496)  \n",
       "6                  (41.9217,-87.6562)  \n",
       "7          (41.88059904,-87.67399833)  \n",
       "8     (41.883221999999996,-87.632496)  \n",
       "9                   (41.8809,-87.647)  \n",
       "10    (41.883221999999996,-87.632496)  \n",
       "11         (41.88553413,-87.62732172)  \n",
       "12               (41.89972222,-87.65)  \n",
       "13               (41.93958,-87.66342)  \n",
       "14     (41.891690000000004,-87.60834)  \n",
       "15         (41.96930347,-87.65803652)  \n",
       "16   (41.945691100000005,-87.6492505)  \n",
       "17             (41.976222,-87.675538)  \n",
       "18     (41.962509999999995,-87.72507)  \n",
       "19         (41.97332764,-87.66801333)  \n",
       "20             (41.94466,-87.6541041)  \n",
       "21         (41.89344867,-87.62999475)  \n",
       "22         (41.89313254,-87.62573272)  \n",
       "23    (41.883221999999996,-87.632496)  \n",
       "24     (41.962740000000004,-87.72508)  \n",
       "25                 (41.9217,-87.6562)  \n",
       "26         (41.88544236,-87.62805026)  \n",
       "27             (41.976222,-87.675538)  \n",
       "28   (41.95649348,-87.72367709999999)  \n",
       "29    (41.883221999999996,-87.632496)  \n",
       "..                                ...  \n",
       "85               (41.95443,-87.67653)  \n",
       "86                 (41.8669,-87.6465)  \n",
       "87               (41.90347,-87.67923)  \n",
       "88         (41.88059904,-87.67399833)  \n",
       "89                 (41.9238,-87.6985)  \n",
       "90                 (41.8669,-87.6465)  \n",
       "91      (41.891999999999996,-87.6275)  \n",
       "92         (41.94502912,-87.69075804)  \n",
       "93         (41.96638353,-87.63921222)  \n",
       "94                 (41.8669,-87.6465)  \n",
       "95                 (41.8669,-87.6465)  \n",
       "96    (41.883221999999996,-87.632496)  \n",
       "97               (41.96125,-87.72585)  \n",
       "98                 (41.8671,-87.6216)  \n",
       "99         (41.93545345,-87.66398415)  \n",
       "100   (41.883221999999996,-87.632496)  \n",
       "101        (41.88840017,-87.61897076)  \n",
       "102   (41.883221999999996,-87.632496)  \n",
       "103   (41.883221999999996,-87.632496)  \n",
       "104    (41.921890000000005,-87.66452)  \n",
       "105   (41.883221999999996,-87.632496)  \n",
       "106          (41.8959115,-87.6206521)  \n",
       "107   (41.883221999999996,-87.632496)  \n",
       "108    (41.887170000000005,-87.65184)  \n",
       "109              (41.93047,-87.68823)  \n",
       "110              (41.93287,-87.65504)  \n",
       "111        (41.92186675,-87.65245276)  \n",
       "112                (41.8669,-87.6465)  \n",
       "113   (41.8781136,-87.62979820000001)  \n",
       "114           (41.89815,-87.63732857)  \n",
       "\n",
       "[115 rows x 7 columns]"
      ]
     },
     "execution_count": 1,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import pandas as pd\n",
    "df = pd.read_csv(\"outfile2.csv\")\n",
    "li = []\n",
    "for index,row in df.iterrows():\n",
    "    lat = \"(\"+str(row['latitude'])\n",
    "    long = str(row['longitude'])+\")\"\n",
    "    location = lat+\",\"+long\n",
    "    li.append(location)\n",
    "li\n",
    "se = pd.Series(li)\n",
    "df['Location'] = se.values\n",
    "df\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from textblob import TextBlob\n",
    "li = []\n",
    "for i in df[\"text\"]:\n",
    "    analysis = TextBlob(i)\n",
    "    if analysis.sentiment.polarity > 0:\n",
    "        li.append(1)\n",
    "    elif analysis.sentiment.polarity < 0:\n",
    "        li.append(-1)\n",
    "    else:\n",
    "        li.append(0)\n",
    "se = pd.Series(li)\n",
    "df['Sentiment'] = se.values\n",
    "df = df.sort_values(['Sentiment'], ascending=1)\n"
   ]
  },
  {
   "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>latitude</th>\n",
       "      <th>longitude</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>41.880599</td>\n",
       "      <td>-87.673998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>41.887615</td>\n",
       "      <td>-87.623646</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>41.916925</td>\n",
       "      <td>-87.675103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>41.866900</td>\n",
       "      <td>-87.646500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>41.885442</td>\n",
       "      <td>-87.628050</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>41.968090</td>\n",
       "      <td>-87.758674</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>41.880599</td>\n",
       "      <td>-87.673998</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>41.880900</td>\n",
       "      <td>-87.647000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>41.932870</td>\n",
       "      <td>-87.655040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>41.910162</td>\n",
       "      <td>-87.678815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>41.932870</td>\n",
       "      <td>-87.655040</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>41.921867</td>\n",
       "      <td>-87.652453</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>41.878114</td>\n",
       "      <td>-87.629798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>41.924976</td>\n",
       "      <td>-87.697321</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>41.939323</td>\n",
       "      <td>-87.721277</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>42.041141</td>\n",
       "      <td>-87.690059</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>41.954430</td>\n",
       "      <td>-87.676530</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>41.961580</td>\n",
       "      <td>-87.678789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>41.866900</td>\n",
       "      <td>-87.646500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>41.910162</td>\n",
       "      <td>-87.678815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>41.895911</td>\n",
       "      <td>-87.620652</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>41.867100</td>\n",
       "      <td>-87.621600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>41.921890</td>\n",
       "      <td>-87.664520</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>41.888400</td>\n",
       "      <td>-87.618971</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>41.898150</td>\n",
       "      <td>-87.637329</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>41.962740</td>\n",
       "      <td>-87.725080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>41.893133</td>\n",
       "      <td>-87.625733</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>41.973328</td>\n",
       "      <td>-87.668013</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50</th>\n",
       "      <td>41.921700</td>\n",
       "      <td>-87.656200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>41.962510</td>\n",
       "      <td>-87.725070</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>52</th>\n",
       "      <td>41.976222</td>\n",
       "      <td>-87.675538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>41.945691</td>\n",
       "      <td>-87.649250</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>54</th>\n",
       "      <td>41.898188</td>\n",
       "      <td>-87.632446</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>55</th>\n",
       "      <td>41.969303</td>\n",
       "      <td>-87.658037</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>41.891690</td>\n",
       "      <td>-87.608340</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>41.885534</td>\n",
       "      <td>-87.627322</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>58</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>59</th>\n",
       "      <td>41.893449</td>\n",
       "      <td>-87.629995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>60</th>\n",
       "      <td>41.965300</td>\n",
       "      <td>-87.700900</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>42.047290</td>\n",
       "      <td>-87.681560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>41.957834</td>\n",
       "      <td>-87.652295</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>63</th>\n",
       "      <td>42.009063</td>\n",
       "      <td>-87.661687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>64</th>\n",
       "      <td>41.921700</td>\n",
       "      <td>-87.656200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>66</th>\n",
       "      <td>41.962230</td>\n",
       "      <td>-87.725780</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>67</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>68</th>\n",
       "      <td>41.883333</td>\n",
       "      <td>-87.633333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>69</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>41.877853</td>\n",
       "      <td>-87.675490</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>41.883222</td>\n",
       "      <td>-87.632496</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>42.047100</td>\n",
       "      <td>-87.681600</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>73 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     latitude  longitude\n",
       "0   41.883222 -87.632496\n",
       "1   41.880599 -87.673998\n",
       "2   41.887615 -87.623646\n",
       "3   41.916925 -87.675103\n",
       "4   41.866900 -87.646500\n",
       "5   41.885442 -87.628050\n",
       "6   41.968090 -87.758674\n",
       "7   41.880599 -87.673998\n",
       "8   41.880900 -87.647000\n",
       "9   41.932870 -87.655040\n",
       "10  41.883222 -87.632496\n",
       "11  41.910162 -87.678815\n",
       "12  41.932870 -87.655040\n",
       "13  41.921867 -87.652453\n",
       "14  41.883222 -87.632496\n",
       "15  41.883222 -87.632496\n",
       "16  41.883222 -87.632496\n",
       "17  41.883222 -87.632496\n",
       "18  41.883222 -87.632496\n",
       "19  41.878114 -87.629798\n",
       "20  41.924976 -87.697321\n",
       "21  41.939323 -87.721277\n",
       "22  42.041141 -87.690059\n",
       "23  41.954430 -87.676530\n",
       "24  41.961580 -87.678789\n",
       "25  41.866900 -87.646500\n",
       "26  41.910162 -87.678815\n",
       "27  41.895911 -87.620652\n",
       "28  41.883222 -87.632496\n",
       "29  41.867100 -87.621600\n",
       "..        ...        ...\n",
       "43  41.921890 -87.664520\n",
       "44  41.888400 -87.618971\n",
       "45  41.883222 -87.632496\n",
       "46  41.898150 -87.637329\n",
       "47  41.962740 -87.725080\n",
       "48  41.893133 -87.625733\n",
       "49  41.973328 -87.668013\n",
       "50  41.921700 -87.656200\n",
       "51  41.962510 -87.725070\n",
       "52  41.976222 -87.675538\n",
       "53  41.945691 -87.649250\n",
       "54  41.898188 -87.632446\n",
       "55  41.969303 -87.658037\n",
       "56  41.891690 -87.608340\n",
       "57  41.885534 -87.627322\n",
       "58  41.883222 -87.632496\n",
       "59  41.893449 -87.629995\n",
       "60  41.965300 -87.700900\n",
       "61  42.047290 -87.681560\n",
       "62  41.957834 -87.652295\n",
       "63  42.009063 -87.661687\n",
       "64  41.921700 -87.656200\n",
       "65  41.883222 -87.632496\n",
       "66  41.962230 -87.725780\n",
       "67  41.883222 -87.632496\n",
       "68  41.883333 -87.633333\n",
       "69  41.883222 -87.632496\n",
       "70  41.877853 -87.675490\n",
       "71  41.883222 -87.632496\n",
       "72  42.047100 -87.681600\n",
       "\n",
       "[73 rows x 2 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df1 = pd.DataFrame()\n",
    "\n",
    "li = []\n",
    "li1 = []\n",
    "for index,row in df.iterrows():\n",
    "    if row['Sentiment'] < 0.05:\n",
    "        li.append(row['latitude'])\n",
    "        li1.append(row['longitude'])\n",
    "df1 = pd.DataFrame({'latitude':li,'longitude':li1})\n",
    "df1"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "df1.to_csv('people.csv', sep=',' , index=None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "df2 = pd.read_csv('final_file.csv')\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Text(0.5,0,'Latitude')\n",
      "Text(0,0.5,'Longitude')\n"
     ]
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAZ8AAAEKCAYAAADNSVhkAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4yLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvhp/UCwAAIABJREFUeJzt3X94ZVV97/H3NyeIBGWAYbyVGXLirVgdqh1kRKvUmTLjLyqX4k/wqFAKeUyureK9eC9NrxZ741Xx1uK9z4xGfgjmiDxIBcVR6UwFGSrWIFOB8Sr0McmMY+WngxBoSfK9f+x1Zk6SfZLzc+99cj6v59lPzll7r73XSnLyzVp77bXM3REREUlSV9oFEBGRzqPgIyIiiVPwERGRxCn4iIhI4hR8REQkcQo+IiKSOAUfERFJnIKPiIgkTsFHREQS1512AbLgmGOO8b6+vrSLISLSVu66666H3X1VPXkVfIC+vj7GxsbSLoaISFsxs4l686rbTUREEqfgIyIiiVPwERGRxCn4iIhI4hR8REQkcQo+IiKSOAUfERFJnIKPiIgkTsFHREQSp+AjIiKJSyX4mNk6M7vTzHaZ2ZiZnRzSLwppu8zsXjObMbOjY/KbmQ2b2c/M7Cdm9udl6Z81swfM7Mdm9vKk6yYiIktLa263TwGXuPu3zOy08H6ju18KXApgZqcDF7r7ozH5zwWOA17s7rNm9ryQ/ibg+LC9EtgavoqISIakFXwcOCK8XgHsiznmbODaCvkHgHe5+yyAuz8Y0s8ArnF3B+40syPN7Pnu/svmFV1ERBqV1j2fDwKXmtke4NPAxeU7zawHeCNwQ4X8vw28M3TZfcvMjg/pq4E9ZcftDWkLmFl/yD/20EMPNVAVERGpVcuCj5ltD/dt5m9nELVcLnT344ALgSvmZT8duKNClxvAocDT7r4e+AJwZemyMcd63AncfcTd17v7+lWr6lqOQkRE6tSybjd331xpn5ldA3wgvL0euHzeIWdRucsNohZNqVX0NeCqsvTjyo5bQ3yXnoiIpCitbrd9wIbw+lTg/tIOM1sR9t20SP4bQz7CsT8Lr78OvDeMensVsF/3e0REsietAQcXAJeZWTfwNNBftu9M4BZ3f7I8g5ltA853933AJ4CimV0IPAGcHw7bBpwGPABMAX/S0lqIiEhdLBoY1tnWr1/vWkZ7oeLgToZG+picOZbe3D6G+8cpbDkl7WKJSEaY2V3h3nvN0mr5SMYVB3fSv/VEpjgcgImZNfRvPQrYqQAkIg3T9DoSa2ik70DgKZnicIZG+tIpkIgsKwo+Emty5tia0kVEaqHgI7F6c/Ej1Culi4jUQsFHYg33j9PDnAGH9PAkw/3j6RRIRJYVBR+JVdhyCiMDd5PP7cWYJZ/by8jA3RpsICJNoaHWaKi1iEg9GhlqrZaPiIgkTsFHDigO7qSvey9dNktf916KgzvTLpKILFN6yFQAPVQqIslSy0eA2h4qVQtJRBql4NMGkvhjX+1DpaUW0sTMGpyu0EI6UQFIRGqi4JNxSf2xr/ahUk27IyLNoOCTcUn9sT/tdx7AmJ2TFvdQqabdEZFmUPDJuCT+2BcHd3L17lfgZb8OxiznrP3hgsEGmnZHRJpBwSfjkvhjH9e6crrY9tMXAnPvOT0xexiH8PScYzXtjojUSsEn41o9x1pxcCcTM6tj903OHEtx85Vz7jk94isxjJU8oml3RKRues4n46I/6q1ZUbQ4uJPztr4CsNj9vV2/YGjHqQtaRf/OoTwn9xAPT68E1oRNRKR6avm0gcKWUxifXsOsdzE+vabqwLPUEO0PfO4l/DuHxubt4UmGD/trJumN3a8BBiLSCAWfJBSL0NcHXV3R12Kx9ZesYoj2I350hdwedaVNXU4vk7FHaICBiDRCwafVikXo74eJCXCPvvb3tzwANTpEu7DlFOjt5TRuBubPfO6c9jsPNKWcItKZFHxabWgIpqbmpk1NRenNUKFVtdgQbbNZzCovpbGSR6MXw8Ns480svCdkbPvpCzXNjojUTev50OL1fLq6ohbPfGYwO7swvRalVlV5cOvpgZER+s7ZwMRM3ECAWaJgEj/I4BCe5qqBsQP3lbpsds7zP+Xn6eGpOa2rHp7UyDeRDqL1fLKsN/6GfcX0WizSqqo0RLty4HHyub1zAg9UvreTY7Y5My+kcD9MRNKn4NNqw8NRa6RcT0+U3qjJ+MEATE5WXAZ7MXEj6SoFsZkKvzo1jYJL6X6YiGSAu3f8dtJJJ3lLjY665/PuZtHX0dHmnDefd4/+bM/d8vmKWWA2NgvMVi7+wO2ez+1xY8bzuT0H3sdeOrenpeUXkewAxrzOv7tq+SShUIDx8egez/h49L4ZWtmqKhP3nFE02q3BUXCLtNxEZHlT8GlnhQKMjEA+Hw1gyOej94sEt9GBO4gLGlF69aJ53+JHwVWtlffD2lBx85X02UQ0etAmKG6+Mu0iibROvU2m5bS1vNstY+K60WplzMT2mBkzNRRk1L2nZ+4Jenqa1y3ZRkY3XeE9PDH3W8ETPrrpirSLJlIRDXS7aag1LR5qvUz1de+NHcqdz+1lfLqGud6KxWjU3uRk1OIZHm5et2Qb6bMJJsgvSM8zwbgvTBfJAg21lsQ1bbbtVt0PazOTHFdTuki7U/CRulQayq0HTOvTy56a0kXanYKP1K3e2bYzK8UHXoc37YhvSW7akVgZRJKk4NMOBgehuzsa0dbdHb2X5kr5gdfC9vMY2XQdeSailiQTjGy6jsL28xK5vkjSFHyybnCQo7Zegs08gzGLzTzDUVsvqTkAaRLQJbR6AtgqFLafx7jno5ak5xV4ZFnTaDeyPdrtKHuIX3MMc5+pcY7kYR7zVVWdo7S2jyYBXUQrJ4AVWababrSbma0zszvNbJeZjZnZySH9opC2y8zuNbMZM1uw4plFhs3sZ2b2EzP785C+0cz2l53jI0nXrdkWBh4AC+nVaXRtn46wxAOvajmKNFda3W6fAi5x93XAR8J73P1Sd18X0i8GbnP3R2PynwscB7zY3V8CfKVs3+2lc7j7x1paizax2No+TbEcZqZeZKqialaFFZHapBV8HDgivF4BxM3bfzZwbYX8A8DH3H0WwN0fbHoJl5FKyyLMSa83gCyXmakXmapILUeRFqh3aoRGNuAlwCSwB/gFkJ+3vwd4FDi6Qv5HgCFgDPgWcHxI3xj2/XNIP6Ga8mR5ep0jeShmJupZP5KHqj7H6MDt8VO3lKbVaWSam4Rnpm7G1EC1anQqoTTKLJIEGphep5UBZjtwb8x2BvBZ4K3huHcA2+flfSfwjUXO/QTwX8LrtxB1tUHUmnpOeH0acP8i5+gPwWust7e3iT+O5jsYgGZrDjwli/4BbCSAmMXnNau5jNXUYdEg2iL5rsm6l49Iq8wiSchk8Fn0orCfgyPtDHh83v6vAe9aJP//A/rK8u+vcNw4cMxS5clyyycRjQSQBFs+jawhNLD2u57jGYdZz/GMD6z9bnUXHR310dx76g4gTVn3SCSjGgk+ad3z2QdsCK9PBe4v7TCzFWHfTYvkvzHkIxz7s5D3t8zMwuuTie5pPdLUki9HjSxtkNCaQlD/wInBE25l6+4NzNANGDN0s3X3BgZPuHXpiw4NUZj5EiNcQJ7x8ADoOCOHX1jVMPWWD/YQaVf1Rq1GNuAU4C6iezM/AE4q23cu8JWYPNuAY8PrI4FvAvcA3wd+L6S/H7gvnPdO4NXVlKfjWz613vOZvzLrwEBrVmqd53D2x7YiDmf/ovmiFs/CfDmeWfqilVqFpdbdEnVVy0eWM9qt2y1rW8cHH/fql/pOcQ2eLqZj/5B3Mb1ovnqWDj+gUrdilXVv5J6PBipI1in4KPgkJ+HRbeXqDSINtXzigm2Nda8niGR6oMLAgHsuF76Juei9dKRGgo+m1yHb0+tkTorT0HTbdLhvM1eOaaZ9YXpJ6Z7P/CmKBtbexpb7Ni594dKCdxMT8ftbUPemLdbXbIODsHXrwvSBAdiyJfnySKrabnodaWONDE5oUP/ancD8wOchvbIt921kYO1t5JgGnBzT1QceOLjgXT4fv78Fdc/sQIWRkZrSNS2RVFRvk2k5bep2q0GK93zcGxgy3QwJ1j2zAxUW636cJ9Ndh9IU6J6Pgk+iqh2ckFWjo+4rVx78i7hyZfUj9hKqe2b/cJfu9Sy4gZZbcGhmA6g0jYKPgk9HaWgU2Oio+yGHxP8BTak1V7GoWRztNjAQ//2KGXTQ6LREkn2NBB8NOEADDtpJw2sT9fVVHjgwXz4f3euRuQYHo3s8MzOQy0UTycYMNsjsoAlpGg04kI7R8AzTk5PVX6yWYzvJli0wPR01ZKanK45yG+4fp4cn56T18CTD/eMJFFKyTsFH2krDo8BqGZnW6hF8dSxj0U6jxwpbTmFk4G7yub3RtES5vVo9Vw6qt79uOW2659M+Gplh2t2zc8+njpFzmR2EIB2LNpxYVKR2xSLDNtRYV06hAFddBStXHkxbuTJ6SDJmIbmWGRqCqam5aVNTUXqlLFrUTpYRDThAAw7aRhgsUORshvg4k/TSyyTDh3+cwhMVHn7MqjpmiuiyWeL+XzRmmXX9HynJ04AD6QxhAECBaxnnBcySY5wXUJi6POWC1aGOmSKqWg5dpE0o+Ej7SHFqn6arYx0kjR6T5UTBp0MMrr6RbpvGzOm2aQZX35h2kWqX4MJ1LVcoRPeVarjPpNFjsqzUO1JhOW3LcbRb+dPxz+HxmOUIZn3g2K+lXcyKKj7d3+5T+zTR6KYrPM949D1i3Ec3XZF2kaTDoOl1FHzKxQ3JrXs9mxS0+5Di0bXDnufnISj83EfXDjf/GpuuiP8eKQBJghoJPhrtxvIb7VZpWpOFHHdb+rCEtfO0LMUTPk7/7g8snP5n7WUU7vuLpl2nzyaYYOESD3kmGPcKSz+INJlGu8kc1T7tn2OmdYVY4un9wRNunXsP6oRbD+zL7Fo2VRja/a74Z3F2v+vA+2bMUjDJcTWli2SNgs8yVN3QW6f/2JtbU4BiMZpscmIi6hGamIjehwBUWlk0WpXUmKGbrbs3HAhA7TykeJL4kXel9NLEqBMza3C6mJhZQ//WE2sOQL3sqSldJGuqDj5mljezzeH1YWb23NYVSxoRNyS3m2cwZjiwkuexN7HlF3/cmgIs8fT+yO5TmLukNYCF9PYeUtxL/GSkpfRmzVIwvGlH/Pdo046aziOVLdY6lyao5sYQcAHwQ+BfwvvjgR313mjK2rbcBhy4p7wWjFn8CAczd/eYkXelbTYb5W/A6Nrh+IEAYdBBM9e40Wi31hlY+934EaJJrpzbBmj1gAMz2wWcDPzA3U8Mafe4+0tbFBMTtdwGHKSu0po5YX2cbpsOXW5z5Zhm2hemt5VikeK5tzA0fcnB6X/WfvnAYIN2HkzRSZb172gTJTHg4N/c/d/LLtgNaJicxFviYdD+tTtZ+OvjIb2NhXtdhelrDk7/03MChb84OPqsnbsUO8kMuZrSpXbVBp/bzOwvgMPM7HXA9cA3WlcsaWtLPL2/5b6NDKy9jRzTHLgHtfY2tty3MdViN6zSva4PfODAyL/Ctnczsuk6zVKQcZVGgrZ0hGiHqbbbrQv4U+D1RHeKvwNc7tVkbgPqdpOmqDRT9Xw9Pa1fskEaUhqROXdgjC+Pf5KaqOXdbu4+6+5fcPe3u/vbwutlEXhkGatjpdCGVDvB6RLr9kj6lm3rPEMWbfmY2T0scm/H3V/WikIlTS2fZaj0rFF5N1irWxxx16xkkXV7RNpFK1s+bwZOB74dtkLYtgFfreeCIomoY6XQhsXd6ypfMbVcOy4DscwUN19Jn01EM03YBMXNV6ZdpI6yaPBx9wl3nwBe4+4fdvd7wvbfgTckU0SROkzGP+xZMX0xtXTfFQowPh61asbH4bLLls8yEMtIcfOV9O94JxPko5kmyNO/453tFYCS7lZutmoeBgJ2AaeUvX81sKveh4uyti3Hh0w7Xj4f/6BrPl/beUZH3Xt65p6jp6e2pRy0DETm5BmP//VgPO2iVacZv5dNQAIPmZ4EXAmsCEm/Bs5z9x+1IiAmTfd8qlcc3MnQSB+TM8fSm9vHcP94NocJN+uezxIPzEp76rJZPKbjx5hl1ttgysuM/F42cs+nqkd13f0u4PfM7AiiQQr767mYtLfSpJilucmiSTGPAnZmLwCVAszQUNTV1tsbdXXVOtigmd13khm97IldkiKamLUNlqRYBr+X1bZ8PhKX7u4fa3qJUqCWT3U6cmqYjPyHKc1VuuezYN2lTddR2H5eiiWrUkZ+L5OYXufJsm0GeBPQV88FpX218zo7dVtiqiBpT4Xt50UzTTARzTTBRPsEHlgev5f13CgCDgW+U++NpqxtGnBQnXxuT/xN2tye1MqUyOzXGjAgWZSB30uSXkbbzI4C/sndj29uKEyHut2qM/+eD4SuipTmJhs84VY+t/u1c24cp1kekU7T8m43M7vHzH4ctvuAnwKfreeC4XzrzOxOM9tlZmNmdnJIvyik7TKze81sxsyOjsl/e9lx+8zsxpBuZvZZM3sglPXl9ZZRFipsOYWRgbszMSlmcXDngsAD9S3MJiLJq3bAQfnwj2ngV+4+XfdFzW4BPuPu3zKz04APu/vGececDlzo7qcuca4bgJvc/Zpwrj8DTgNeCVzm7q9cqjxq+bSfvtweJmaPi93XNsNly7TNEHaRMkkMOPifHmY7cPdfuPu0mX2pngsGDhwRXq8A9sUcczZw7WInCUt5nwrcGJLOAK4J3ZF3Akea2fMbKKdk1OTs6or7enNxv07ZVerOnJhZEz1tP7OG/q0nUhxs8/WNRBZRbfA5ofxNWEzupAau+0HgUjPbA3wauHje+XuANwI3LHGeM4mW8348vF8N7CnbvzekLWBm/aHLb+yhhx6qowqSpl7in2cwZttuYbahkb4599FA3Yey/C0afMzsYjP7DfAyM3s8bL8BfgXctETe7eG+zfztDGCAqEvtOOBC4Ip52U8H7nD3R5co//zWkcUcE9uv6O4j7r7e3devWrVqictI1gwf/vEFK4Ias7wv94W2667qyCHs0vGWmlj0f7n7c4FL3f2IsD3X3Ve6+8VL5N3s7r8bs90EnAP8XTj0euDkednPYukut5Uh3zfLkvcC5TcC1hDfpSdtrvD5DYzkBsgzHp7TGOdLuXPZcvVz0i5azSp1E7Zb96FILZZq+bw4vLzezF4+f2vguvuADeH1qcD9ZddcEfYt2rIC3g7c7O5Pl6V9HXhvGPX2KmC/u/+ygXJKVhUKFK5+A+P5jcxaN+P5jRSufkNbrg463D++oBXXw5Nt130oUoul5nb7ENAP/O+YfU4UOOpxAXBZuHf0dLhGyZnALe4+59NoZtuA89299O/gWcAn5p13G9FItweAKeBP6iyftINCoS2DzXxRN6FGu0lnqesh0+VGQ63bVLHY+MShIlK3ls9qbWZviUneD9zj7g/Wc2GRhsxfMmFiInoPCkAibaDah0y/Cfw+8N2QtBG4E3gR8DF3b+SZn9Sp5dOGMjKrr0gna3nLB5gFXuLuvwoX/A/AVqJZBL4HtHXwkTa0DNYzEelk1T5k2lcKPMGDwIvCczjPNL9YIkvo7a0tXUQypdrgc7uZ3Wxm55jZOUTDoL9nZocTLaktkqzlsJ6JSAerttvtPwNvBV5DNIvANcANYT2HP2xR2UQqa9Yy2SKSCg21RgMORETqkcR6Pm8xs/vNbH9pfjcze3zpnCIiIgtV2+32KeB0d/9JKwsjIiKdodoBB79S4BERkWaptuUzZmbXES3a9m+lRHf/u8pZRERE4lXb8jmCaKLO1xOttXM68OZWFUokacXBnfR176XLZunr3qtVREVarKqWj7trdmhZtkrLWJdWE42WsT4K2KmZpUVapNrRbmvM7Gtm9qCZ/crMbjCzNa0unEgSWraMdbEYzUHX1RV9LRYbO5/IMlJtt9tVRAu1HQusBr4R0kTaXkuWsS7Nuj0xAe4HZ90uC0CDJ9xKt01j5nTbNIMn3Fr/9UTaTLXBZ5W7X+Xu02H7IrCqheUSSUxLlrEeGjq43EPJ1BQMDbH5qB9i5mzdvYEZugFjhm627t6gACQdo9rg87CZvdvMcmF7N/BIKwsmkpSWLGNdYXbtzROfZ8ev1xPNUmXz9hoju3WPSTpDtcHnPOAdwL8CvwTehpaolmWisOUURgbuJp/bizFLPreXkYG7GxtsUGF27R28noVB56AZcvVfU6SN1D23m5l90N3/tsnlSYXmdpOmm7/SKkBPDzb1BIsFnxzTTHu1j9+JpKvlc7tV8KEG8oosb4UCjIxEK6uaRV9HRpbI5PSv1fNF0hkaCT6V/30TkSgAjY/D7Gz0tVBg05FjQFxvg7PpyDG23Lcx0SKKpKWR4KO1GERqtP2xV5QFoGh7Nk8xOnAH2x97RcqlE0nOop3LZvYb4oOMAYe1pEQiy9zCIHMYoFFu0lkWDT7u/tykCiIiIp2jkW43ERGRuij4iIhI4hR8REQkcQo+IiKSOAUfERFJnIKPiIgkTsFHREQSp+AjIiKJU/AREZHEKfiIiEjiFHxERCRxCj4iIpK4VIKPma0zszvNbJeZjZnZySH9opC2y8zuNbMZMzs6Jv/tZcftM7MbQ/pGM9tftu8jSddNRESWltZ6vZ8CLnH3b5nZaeH9Rne/FLgUwMxOBy5090fnZ3b3Pyi9NrMbgJvKdt/u7m9uaelFRKQhaXW7OXBEeL0C2BdzzNnAtYudxMyeC5wK3NjU0omISEul1fL5IPAdM/s0UQB8dflOM+sB3gi8f4nznAnscPfHy9J+38z+mSig/Vd3v695xRYRkWZoWfAxs+3Ab8XsGgI2EXWp3WBm7wCuADaXHXM6cEdcl9s8ZwOXl73/EZB39ydCd96NwPEVytcP9AP09vZWUSMREWkWc49bJbvFFzXbDxzp7m5mBux39yPK9n8NuN7dv7zIOVYCPwNWu/vTFY4ZB9a7+8OLlWf9+vU+NjZWR01ERDqXmd3l7uvryZvWPZ99wIbw+lTg/tIOM1sR9t0Uk6/c24GbywOPmf1WCGaEEXRdwCNNLLeIiDRBWvd8LgAuM7Nu4GlC91dwJnCLuz9ZnsHMtgHnu3tpcMJZwCfmnfdtwICZTQNPAWd5Gk07ERFZVCrdblmjbjcRkdq1Y7ebiFRQHNxJX/deumyWvu69FAd3pl0kkaZT8BHJkOLgTvq3nsjEzBqcLiZm1tC/9UQFIKlOsQh9fdDVFX0tFtMuUUUKPiIZMjTSxxSHz0mb4nCGRvrSKZC0j2IR+vthYgLco6/9/ZkNQAo+IhkyOXNsTekiBwwNwdTU3LSpqSg9gxR8RDKkNxc301TldJEDJidrS0+Zgo9Ihgz3j9PDnKcM6OFJhvvH0ymQtI9KM7VkdAYXBR+RDClsOYWRgbvJ5/ZizJLP7WVk4G4KW05Ju2iSdcPD0NMzN62nJ0rPID3ng57zEZFloliM7vFMTkYtnuFhKBRadrlGnvNJa4YDERFptkKhpcGmmdTtJiIiiVPwERGRxCn4iIhI4hR8REQkcQo+IiKSOAUfERFJnIKPiIgkTsFHREQSp+AjIiKJU/AREZHEKfiIiEjiFHxERCRxCj4iIpI4BR8REUmcgo+IiCROwUdERBKn4CMiIolT8BERkcQp+IiISOIUfEREJHEKPiIikjgFHxERSZyCj4iIJE7BR0REEqfgIyIiiVPwERGRxCn4iIi0q2IR+vqgqyv6WiymXaKqdaddABERqUOxCP39MDUVvZ+YiN4DFArplatKqbV8zGydmd1pZrvMbMzMTg7pF4W0XWZ2r5nNmNnRMfk3mdmPwnE7zeyFIf1QM7vOzB4wsx+YWV+yNRMRScDQ0MHAUzI1FaW3gTS73T4FXOLu64CPhPe4+6Xuvi6kXwzc5u6PxuTfChTCcV8G/jKk/ynwmLu/EPgM8MkW10NEJHmTk7WlZ0yawceBI8LrFcC+mGPOBq6tMf8ZwNXh9VeBTWZmDZdWRCRLentrS8+YNO/5fBD4jpl9migIvrp8p5n1AG8E3l8h//nANjN7CngceFVIXw3sAXD3aTPbD6wEHp53/n6gH6C3TX5YIiIHDA/PvecD0NMTpbeBlrZ8zGx7uG8zfzsDGAAudPfjgAuBK+ZlPx24o0KXGyHPae6+BrgK+JvSZWOO9QUJ7iPuvt7d169ataqe6omIpKdQgJERyOfBLPo6MtIWgw0AzH3B3+VkLhy1SI50dw/dYvvd/Yiy/V8Drnf3L8fkXQXc6e6/Hd73At9297Vm9h3gr9z9+2bWDfwrsMoXqej69et9bGysuRUUEVnmzOwud19fT9407/nsAzaE16cC95d2mNmKsO+mCnkfA1aY2YvC+9cBPwmvvw6cE16/DfiHxQKPiIgkL817PhcAl4XWydOE+y/BmcAt7v5keQYz2wac7+77zOwC4AYzmyUKRueFw64AvmRmDwCPAme1uB4iIlKj1LrdskTdbiIitWvXbjcREelQCj4iIpI4BR8REUmcgo+IiCROwUdERBKn4CMiIolT8BERkcQp+IiISOIUfEREJHEKPiIikjgFHxERSZyCj4iIJE7BR0REEqfgIyIiiVPwERGRxGk9H8DMHgImmnzaY4CHm3zOdtCJ9e7EOkNn1rsT6wyV651391X1nFDBp0XMbKzeRZbaWSfWuxPrDJ1Z706sM7Sm3up2ExGRxCn4iIhI4hR8Wmck7QKkpBPr3Yl1hs6sdyfWGVpQb93zERGRxKnlIyIiiVPwqZKZ5czsbjO7Obx/v5k9YGZuZscsku9TZnafmf3EzD5rZhbSbzWzn5rZrrA9L6m61KKBen/SzO4N2zvL0l9gZj8ws/vN7Doze1YS9ahFC+r8RTP7ednPel0S9ahVTL2L4Xf0XjO70swOqZDvnPDzvN/MzilLP8nM7gnfuwO/+1nTgnpn/rPdQJ2/bWa/LuUrS6/5c63gU70PAD8pe38HsJlFng8ys1cDrwFeBvwu8ApgQ9khBXdfF7YHm1/kpqin3n8EvBxYB7wSuMjMjgi7Pwl8xt2PBx4D/rTBFALTAAAFaElEQVQVhW5Qs+sMcFHZz3pXC8rcDPPrXQReDLwUOAw4f34GMzsa+ChRnU8GPmpmR4XdW4F+4PiwvbFlJW9Ms+sN2f9s11zn4FLgPTHpNX+uFXyqYGZrgD8CLi+lufvd7j6+RFYHng08CzgUOAT4VYuK2XQN1HstcJu7T7v7k8A/A28M//meCnw1HHc18MdNL3gDml3nlhW0ySrUe5sHwD8Ba2KyvgH4e3d/1N0fA/6e6Gf9fOAId/9+yH8NGftZQ/PrnUSZG9VAnXH3HcBv5p2vrs+1gk91/hb4MDBbSyZ3/z7wXeCXYfuOu5f/t3FVaJb/j4x2SdRVb6I/vG8ys57QTfWHwHHASuDX7j4djtsLrG5WYZuk2XUuGTazH5vZZ8zs0CaVtZkq1jt0wbwH+HZMvtXAnrL3pZ/p6vB6fnrWNLveJVn+bNdb50rq+lwr+CzBzN4MPOjud9WR94XAS4j+i1gNnGpmrw27C+7+UuAPwhbXlE1NI/V291uAbcA/AtcC3wemgbgPYWaGW7aozgAXE3VpvAI4GvhvTSlwk1RR7y3A99z99rjsMWm+SHpmtKjekOHPdoN1rnjamLQlf9YKPkt7DfCfzGwc+ApRABmtMu+ZwJ3u/oS7PwF8C3gVgLv/Inz9DfBlon7jLGmk3rj7cOjvfh3RL+f9RHNDHWlm3eGwNcC+5ha7Ia2oM+7+y9Cj8W/AVbTRz9rMPgqsAj5UIe9e5rbwSj/TvcztusnazxpaU++sf7YbqXMl9X2u3V1blRuwEbh5Xto4cEyF498JbAe6ie737ABOD++PCcccQtRX+r6069fEeueAleH1y4B7ge7w/nrgrPD6c8Bg2vVLoM7PD1+NqMvjE2nXr5p6E910/kfgsEWOPxr4OXBU2H4OHB32/ZDony0j+sfrtLTr1+p6t9Nnu9Y6x+UrS6v5c536N6Cdtnk/rD8n+u9nmijKXx7S15e9zgGfJxpVshv4m5B+OHAX8GPgPuAyIJd2/ZpY72eH+u4G7gTWlZ3rPxLd0Hwg/MIemnb9EqjzPwD3EAWkUeA5adevynpPA/8C7ArbR+bXO7w/L/w8HwD+pCx9fajzvwD/l/BQexa3ZtW7nT7bddb5duAh4KnwmXhDSK/5c60ZDkREJHG65yMiIolT8BERkcQp+IiISOIUfEREJHEKPiIikjgFH5EmM7Mnajh2Y5iAtvT+fWb23vD6XDM7to7rj9sis2+LZEH30oeISAttBJ4gesAPd/9c2b5ziZ6TydrMACINU/ARSYCZnQ78JdEM548ABaKp698HzJjZu4E/AzYRBaNxogf8imb2FPD7RA8rr3f3h81sPfBpd99oZiuJ5pNbRfSgn5Vd991ED8k+C/gB0ZPnM62vscji1O0mkoydwKvc/USiObU+7NEyDZ8jWgdlnZdN5ujuXwXGOLguzFOLnPujwM5w7q8DvQBm9hKiKZ5e4+7rgBmioCeSOrV8RJKxBrgurHPzLKK5wJrltcBbANz9m2b2WEjfBJwE/DDM6n8YkMWFzaQDKfiIJOP/EM3t93Uz2wj8VR3nmOZgb8Wz5+2LmyfLgKvd/eI6riXSUup2E0nGCuAX4fU5Zem/AZ5bIc/8feNELRmAt5alf4/QnWZmbyKaZRmiWdTfZmbPC/uONrN8neUXaSoFH5Hm6zGzvWXbh4haOteb2e1E65+UfAM4M6x6+QfzzvNF4HNh32HAJcBl4RzlgwYuAV5rZj8CXg9MArj7bqJBDreY2Y+Jlnp+frMrK1IPzWotIiKJU8tHREQSp+AjIiKJU/AREZHEKfiIiEjiFHxERCRxCj4iIpI4BR8REUmcgo+IiCTu/wPq3y0eWFQhRgAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "%matplotlib inline\n",
    "import matplotlib.pyplot as plt\n",
    "df2 = df1 \n",
    "plt.scatter(df['latitude'],df['longitude'],color='red',marker = 'o')\n",
    "plt.scatter(df2['latitude'],df2['longitude'],color='blue',marker = 'o')\n",
    "print(plt.xlabel('Latitude'))\n",
    "print(plt.ylabel('Longitude'))"
   ]
  },
  {
   "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>Unnamed: 0</th>\n",
       "      <th>Location</th>\n",
       "      <th>Frequency</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2746</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>(41.883500187, -87.627876698)</td>\n",
       "      <td>536</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>(41.897895128, -87.624096605)</td>\n",
       "      <td>290</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>(41.754592961, -87.741528537)</td>\n",
       "      <td>261</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>(41.868180939, -87.709271389)</td>\n",
       "      <td>258</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>(41.976290414, -87.905227221)</td>\n",
       "      <td>241</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>(41.868541914, -87.639235361)</td>\n",
       "      <td>223</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>(41.742710224, -87.634088181)</td>\n",
       "      <td>221</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>(41.979006297, -87.906463155)</td>\n",
       "      <td>180</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>(41.88171846, -87.627760426)</td>\n",
       "      <td>179</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>(41.899410159, -87.624131266)</td>\n",
       "      <td>160</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>(41.891694878, -87.626155832)</td>\n",
       "      <td>157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>(41.882394062, -87.627844798)</td>\n",
       "      <td>154</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>(41.695982095, -87.596653142)</td>\n",
       "      <td>152</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>(41.937227668, -87.644305471)</td>\n",
       "      <td>143</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>(41.909664252, -87.742728815)</td>\n",
       "      <td>142</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>(41.788987036, -87.74147999)</td>\n",
       "      <td>139</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>(41.976851852, -87.654999693)</td>\n",
       "      <td>138</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>(41.824675709, -87.617013434)</td>\n",
       "      <td>130</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>(41.976762981, -87.900983721)</td>\n",
       "      <td>128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>(41.885741029, -87.631711749)</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>(41.883475491, -87.627876969)</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>(41.891990384, -87.611461502)</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>(41.884335468, -87.619164088)</td>\n",
       "      <td>120</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>(41.929743818, -87.684273777)</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>(41.86821682, -87.6304532)</td>\n",
       "      <td>113</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>(41.892753031, -87.624193896)</td>\n",
       "      <td>112</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>(41.884650262, -87.627915459)</td>\n",
       "      <td>110</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>(41.884333364, -87.619266937)</td>\n",
       "      <td>109</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>(41.980826277, -87.883611316)</td>\n",
       "      <td>107</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129223</th>\n",
       "      <td>129223</td>\n",
       "      <td>(41.773111034, -87.607451038)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129224</th>\n",
       "      <td>129224</td>\n",
       "      <td>(41.775013446, -87.761603364)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129225</th>\n",
       "      <td>129225</td>\n",
       "      <td>(41.769223543, -87.582861004)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129226</th>\n",
       "      <td>129226</td>\n",
       "      <td>(41.771092147, -87.569909743)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129227</th>\n",
       "      <td>129227</td>\n",
       "      <td>(41.758441235, -87.613312008)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129228</th>\n",
       "      <td>129228</td>\n",
       "      <td>(41.942492987, -87.745848004)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129229</th>\n",
       "      <td>129229</td>\n",
       "      <td>(41.779362257, -87.61439057)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129230</th>\n",
       "      <td>129230</td>\n",
       "      <td>(41.770549883, -87.582570607)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129231</th>\n",
       "      <td>129231</td>\n",
       "      <td>(41.827928858, -87.676435023)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129232</th>\n",
       "      <td>129232</td>\n",
       "      <td>(41.761749861, -87.700293697)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129233</th>\n",
       "      <td>129233</td>\n",
       "      <td>(41.823417338, -87.689043285)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129234</th>\n",
       "      <td>129234</td>\n",
       "      <td>(41.709606459, -87.67849436)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129235</th>\n",
       "      <td>129235</td>\n",
       "      <td>(41.935545106, -87.642875527)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129236</th>\n",
       "      <td>129236</td>\n",
       "      <td>(41.739524419, -87.603689014)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129237</th>\n",
       "      <td>129237</td>\n",
       "      <td>(41.900752442, -87.68452338)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129238</th>\n",
       "      <td>129238</td>\n",
       "      <td>(41.894993332, -87.746970358)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129239</th>\n",
       "      <td>129239</td>\n",
       "      <td>(41.950717641, -87.72017548)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129240</th>\n",
       "      <td>129240</td>\n",
       "      <td>(41.880166187, -87.666973419)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129241</th>\n",
       "      <td>129241</td>\n",
       "      <td>(41.936699071, -87.810363045)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129242</th>\n",
       "      <td>129242</td>\n",
       "      <td>(41.729076385, -87.622000053)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129243</th>\n",
       "      <td>129243</td>\n",
       "      <td>(41.769307976, -87.687040964)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129244</th>\n",
       "      <td>129244</td>\n",
       "      <td>(41.921649365, -87.802512328)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129245</th>\n",
       "      <td>129245</td>\n",
       "      <td>(41.891349924, -87.670456473)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129246</th>\n",
       "      <td>129246</td>\n",
       "      <td>(41.918948924, -87.658251434)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129247</th>\n",
       "      <td>129247</td>\n",
       "      <td>(41.880141346, -87.668369073)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129248</th>\n",
       "      <td>129248</td>\n",
       "      <td>(41.855110114, -87.694312046)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129249</th>\n",
       "      <td>129249</td>\n",
       "      <td>(41.658302788, -87.596720432)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129250</th>\n",
       "      <td>129250</td>\n",
       "      <td>(41.907128554, -87.722785931)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129251</th>\n",
       "      <td>129251</td>\n",
       "      <td>(41.816537551, -87.68955246)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>129252</th>\n",
       "      <td>129252</td>\n",
       "      <td>(41.750240011, -87.610054152)</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>129253 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "        Unnamed: 0                       Location  Frequency\n",
       "0                0                            NaN       2746\n",
       "1                1  (41.883500187, -87.627876698)        536\n",
       "2                2  (41.897895128, -87.624096605)        290\n",
       "3                3  (41.754592961, -87.741528537)        261\n",
       "4                4  (41.868180939, -87.709271389)        258\n",
       "5                5  (41.976290414, -87.905227221)        241\n",
       "6                6  (41.868541914, -87.639235361)        223\n",
       "7                7  (41.742710224, -87.634088181)        221\n",
       "8                8  (41.979006297, -87.906463155)        180\n",
       "9                9   (41.88171846, -87.627760426)        179\n",
       "10              10  (41.899410159, -87.624131266)        160\n",
       "11              11  (41.891694878, -87.626155832)        157\n",
       "12              12  (41.882394062, -87.627844798)        154\n",
       "13              13  (41.695982095, -87.596653142)        152\n",
       "14              14  (41.937227668, -87.644305471)        143\n",
       "15              15  (41.909664252, -87.742728815)        142\n",
       "16              16   (41.788987036, -87.74147999)        139\n",
       "17              17  (41.976851852, -87.654999693)        138\n",
       "18              18  (41.824675709, -87.617013434)        130\n",
       "19              19  (41.976762981, -87.900983721)        128\n",
       "20              20  (41.885741029, -87.631711749)        120\n",
       "21              21  (41.883475491, -87.627876969)        120\n",
       "22              22  (41.891990384, -87.611461502)        120\n",
       "23              23  (41.884335468, -87.619164088)        120\n",
       "24              24  (41.929743818, -87.684273777)        113\n",
       "25              25     (41.86821682, -87.6304532)        113\n",
       "26              26  (41.892753031, -87.624193896)        112\n",
       "27              27  (41.884650262, -87.627915459)        110\n",
       "28              28  (41.884333364, -87.619266937)        109\n",
       "29              29  (41.980826277, -87.883611316)        107\n",
       "...            ...                            ...        ...\n",
       "129223      129223  (41.773111034, -87.607451038)          1\n",
       "129224      129224  (41.775013446, -87.761603364)          1\n",
       "129225      129225  (41.769223543, -87.582861004)          1\n",
       "129226      129226  (41.771092147, -87.569909743)          1\n",
       "129227      129227  (41.758441235, -87.613312008)          1\n",
       "129228      129228  (41.942492987, -87.745848004)          1\n",
       "129229      129229   (41.779362257, -87.61439057)          1\n",
       "129230      129230  (41.770549883, -87.582570607)          1\n",
       "129231      129231  (41.827928858, -87.676435023)          1\n",
       "129232      129232  (41.761749861, -87.700293697)          1\n",
       "129233      129233  (41.823417338, -87.689043285)          1\n",
       "129234      129234   (41.709606459, -87.67849436)          1\n",
       "129235      129235  (41.935545106, -87.642875527)          1\n",
       "129236      129236  (41.739524419, -87.603689014)          1\n",
       "129237      129237   (41.900752442, -87.68452338)          1\n",
       "129238      129238  (41.894993332, -87.746970358)          1\n",
       "129239      129239   (41.950717641, -87.72017548)          1\n",
       "129240      129240  (41.880166187, -87.666973419)          1\n",
       "129241      129241  (41.936699071, -87.810363045)          1\n",
       "129242      129242  (41.729076385, -87.622000053)          1\n",
       "129243      129243  (41.769307976, -87.687040964)          1\n",
       "129244      129244  (41.921649365, -87.802512328)          1\n",
       "129245      129245  (41.891349924, -87.670456473)          1\n",
       "129246      129246  (41.918948924, -87.658251434)          1\n",
       "129247      129247  (41.880141346, -87.668369073)          1\n",
       "129248      129248  (41.855110114, -87.694312046)          1\n",
       "129249      129249  (41.658302788, -87.596720432)          1\n",
       "129250      129250  (41.907128554, -87.722785931)          1\n",
       "129251      129251   (41.816537551, -87.68955246)          1\n",
       "129252      129252  (41.750240011, -87.610054152)          1\n",
       "\n",
       "[129253 rows x 3 columns]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dataa = pd.read_csv(\"final_file.csv\")\n",
    "dataa"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "439\n",
      "5329\n"
     ]
    }
   ],
   "source": [
    "ct = 0 \n",
    "tot = 0\n",
    "for a, b in df1.itertuples(index=False):\n",
    "    for c ,d  in df2.itertuples(index=False):\n",
    "        tot = tot+1\n",
    "        if(abs(a-c)<0.001 and abs(b-d)<0.001):\n",
    "            ct=ct+1\n",
    "print(ct)\n",
    "print(tot)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "\n",
    "result = pd.concat([df1, df2], axis=1, join='inner')\n",
    "result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "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.6.5"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}