DataExtractionProcessing.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# Gnip Data Processing"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Populating the interactive namespace from numpy and matplotlib\n"
     ]
    }
   ],
   "source": [
    "%pylab inline\n",
    "import pandas as pd\n",
    "import json\n",
    "import matplotlib.pyplot as plt\n",
    "import matplotlib.image as mpimg\n",
    "import urllib2\n",
    "import numpy as np\n",
    "import os\n",
    "import os.path\n",
    "from scipy import misc\n",
    "from time import strftime,strptime\n",
    "import re\n",
    "import math\n",
    "import pymysql\n",
    "import MySQLdb\n",
    "import os,sys\n",
    "import gzip, json\n",
    "from dateutil import parser"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Note 1: We can use the Classes instead of reimplementing the functions.\n",
    "##### Note 2: You can use SQLAlchemy instead of generating MySQL queries from a dataframe to insert data into a database."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "def getimage(url, full_name):\n",
    "    \"\"\"\n",
    "    Downloads the image and returns and object of that image.\n",
    "    url: image url.\n",
    "    full_name: path with file name to save the image.\n",
    "    \"\"\"\n",
    "    if os.path.isfile(full_name):\n",
    "        return mpimg.imread(full_name)\n",
    "    \n",
    "    try:\n",
    "        f = urllib2.urlopen(url)\n",
    "    except:\n",
    "        return None\n",
    "    \n",
    "    data = f.read()\n",
    "    with open(full_name, \"wb\") as code:\n",
    "        code.write(data)\n",
    "    return mpimg.imread(full_name)\n",
    "\n",
    "def getallimages(panda_name, column_name):\n",
    "    \"\"\"\n",
    "    Downloads a group of images from a panda dataframe.\n",
    "    panda_name: dataframe object.\n",
    "    column_name: column containing the url.\n",
    "    \"\"\"\n",
    "    downloaded_images = []\n",
    "    for row in panda_name.loc[panda_name[column_name].notnull(),column_name]:\n",
    "        for image in row:\n",
    "            img = getimage(image[column_name],image[column_name].split('/')[-1])\n",
    "            if not(img is None):\n",
    "                downloaded_images.append(img)\n",
    "    return downloaded_images\n",
    "\n",
    "def klout_getId(screen_name):\n",
    "    \"\"\"\n",
    "    Gets user's klout id if exists.\n",
    "    screenname: user\n",
    "    \"\"\"\n",
    "    url = 'http://api.klout.com/v2/identity.json/twitter?screenName={0}&key=memp3ncn4qvp6c8guzjcc8dp'.format(screen_name)    \n",
    "    try:\n",
    "        return json.load(urllib2.urlopen(url))\n",
    "    except:\n",
    "        return None\n",
    "    \n",
    "def klout_getScore(klout_id):\n",
    "    \"\"\"\n",
    "    Gets user's klout score if exists.\n",
    "    \n",
    "    klout_id: user's klout id.\n",
    "    \"\"\"\n",
    "    url = 'http://api.klout.com/v2/user.json/{0}/score?key=memp3ncn4qvp6c8guzjcc8dp'.format(kloutId)\n",
    "    try:\n",
    "        return json.load(urllib2.urlopen(url))\n",
    "    except:\n",
    "        return None\n",
    "    \n",
    "def extractImageUrl(cell):\n",
    "    \"\"\"\n",
    "    Gets user's klout id if exists.\n",
    "    cell: extracts tweets image url out of media object.\n",
    "    \"\"\"\n",
    "    if cell is None:\n",
    "        return None\n",
    "    return cell[0]['media_url']\n",
    "\n",
    "def convertDTToDB(cell):\n",
    "    \"\"\"\n",
    "    Converts the time to a MySQL-friendly url.\n",
    "    cell: datetime string.\n",
    "    \"\"\"\n",
    "    return strftime('%Y-%m-%d %H:%M:%S', strptime(cell,'%Y-%m-%dT%H:%M:%S.000Z'))\n",
    "def getOldId(cell):\n",
    "    \"\"\"\n",
    "    Get's the ID of tweet or user from gnip format.\n",
    "    cell: string contatining id.\n",
    "    \"\"\"\n",
    "    return cell.split(':')[2]\n",
    "\n",
    "def normalizeTweetText(text):\n",
    "    \"\"\"\n",
    "    Normalize tweet text to a MySQL-friendly format.\n",
    "    text: text string.\n",
    "    \"\"\"\n",
    "    if text is None or type(text) is float:\n",
    "        return None\n",
    "    return re.sub(r'[^\\w#:@/\\.\\-\\,]', ' ', text)\n",
    "\n",
    "## Note that if we may put NULL for any of the attributes\n",
    "## we should remove the single quotation marks from around them.\n",
    "def ensureDBNull(cell):\n",
    "    return 'NULL' if cell is None else (\"'\" + cell + \"'\")\n",
    "\n",
    "def getTweetsInsertQuery(tweets):\n",
    "    \"\"\"\n",
    "    Generate insert queries for tweet objects.\n",
    "    tweets: tweets dataframe.\n",
    "    \"\"\"\n",
    "    query = \"\"\n",
    "    for tweet in tweets:\n",
    "        temp = \"REPLACE INTO tweet VALUES('{0}', '{1}', '{2}', '{3}', {4}, '{5}', {6}, {7}, {8});\\n\".format(tweet[0],\n",
    "                                     tweet[1],\n",
    "                                     tweet[2],\n",
    "                                     tweet[3],\n",
    "                                     ensureDBNull(tweet[4]),\n",
    "                                     tweet[5],\n",
    "                                     ensureDBNull(tweet[6]),\n",
    "                                     ensureDBNull(tweet[7]),\n",
    "                                     ensureDBNull(tweet[8]))\n",
    "        \n",
    "        query = \"{0}{1}\".format(query, temp)                         \n",
    "    return query\n",
    "\n",
    "def getUsersInsertQuery(users):\n",
    "    \"\"\"\n",
    "    Generate insert queries for user objects.\n",
    "    users: users dataframe.\n",
    "    \"\"\"\n",
    "    query = \"\"\n",
    "    for user in users:\n",
    "        temp = \"REPLACE INTO user VALUES('{0}', '{1}', {2}, {3}, \\\n",
    "          '{4}', '{5}', '{6}', {7}, '{8}');\\n\".format(user[0],\n",
    "                                                   user[1],\n",
    "                                                   ensureDBNull(user[2]),\n",
    "                                                   user[3],\n",
    "                                                   user[4],\n",
    "                                                   user[5],\n",
    "                                                   user[6],\n",
    "                                                   ensureDBNull(user[7]),\n",
    "                                                   user[8])\n",
    "\n",
    "        query = \"{0}{1}\".format(query, temp)                \n",
    "    return query\n",
    "\n",
    "def getPlacesInsertQuery(places):\n",
    "    \"\"\"\n",
    "    Generate insert queries for place objects.\n",
    "    places: tweets dataframe.\n",
    "    \"\"\"\n",
    "    query = \"\"\n",
    "    for place in places:\n",
    "        temp = \"REPLACE INTO place VALUES ('{0}', '{1}', '{2}', '{3}');\\n\".format(place[0],\n",
    "                                                     place[1],\n",
    "                                                     place[2],\n",
    "                                                     place[3])\n",
    "\n",
    "        query = \"{0}{1}\".format(query, temp)\n",
    "    return query\n",
    "\n",
    "\n",
    "def convertNanToNone(text):\n",
    "    \"\"\"\n",
    "    Change any 'nan' string to None.\n",
    "    text: text string.\n",
    "    \"\"\"\n",
    "    try:\n",
    "        if str(text) == 'nan':\n",
    "            return None\n",
    "    except:\n",
    "        pass\n",
    "    return text\n",
    "\n",
    "def listToStr(cell):\n",
    "    \"\"\"\n",
    "    Convert a list of strings to one string holds all of them.\n",
    "    cell: list of strings.\n",
    "    \"\"\"\n",
    "    if cell is None:\n",
    "        return None\n",
    "    mystr = \"\";\n",
    "    for i in cell:\n",
    "        try:\n",
    "            mystr = mystr + \",\" + str(i)\n",
    "        except:\n",
    "            print i\n",
    "    mystr = \"[{0}]\".format(mystr[1:])\n",
    "    return mystr\n",
    "def getDBInstance(host, user, password, db):\n",
    "    \"\"\"\n",
    "    Returns a mysql db object.\n",
    "    Parameters are obvious.\n",
    "    \"\"\"\n",
    "    return MySQLdb.connect(host,\n",
    "                         user,\n",
    "                         password,\n",
    "                         db)\n",
    "def extractHashTags(hashTags):\n",
    "    \"\"\"\n",
    "    Extract hashtags out of hashtag objects list.\n",
    "    hashTags: hashtags list.\n",
    "    \"\"\"\n",
    "    if hashTags is None or hashTags == []:\n",
    "        return None\n",
    "    mylist = ''\n",
    "    for hashtag in hashTags:\n",
    "        mylist = mylist + ',' + hashtag['text']\n",
    "    return mylist[1:]"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## This class is written by Dr. Mohanty"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "class GnipDataProcessor(object):\n",
    "\n",
    "    def __init__(self, i_path, collection, chunk_size=50):\n",
    "        self.path = i_path\n",
    "        self.chunk = []\n",
    "        self.chunk_size = chunk_size\n",
    "        self.collection = collection\n",
    "        self.total_inserts = 0\n",
    "\n",
    "    def all_files(self):\n",
    "        for path, dirs, files in os.walk(self.path):\n",
    "            for f in files:\n",
    "                yield os.path.join(path, f)\n",
    "    def iter_files(self):\n",
    "        file_generator = self.all_files()\n",
    "\n",
    "        for f in file_generator:\n",
    "            try:\n",
    "                gfile = gzip.open(f)\n",
    "                for line in gfile:\n",
    "                    self.process_line(line)\n",
    "                gfile.close()\n",
    "            except Exception as e:\n",
    "                # print e\n",
    "                pass\n",
    "            if self.chunk != []:\n",
    "                yield self.chunk\n",
    "        \n",
    "        \n",
    "\n",
    "    def process_line(self, line):\n",
    "        try:\n",
    "            if len(self.chunk) > self.chunk_size:\n",
    "                self.process_chunk()\n",
    "                self.chunk = []\n",
    "            if line.strip() != \"\":\n",
    "                data = json.loads(line)\n",
    "                if 'id' in data:\n",
    "                    # data['postedTime_mongo'] = parser.parse(data['postedTime'])\n",
    "                    self.chunk.append(line)\n",
    "\n",
    "        except Exception as e:\n",
    "            # print \"error storing chunk \\n\"\n",
    "            # print line, e.msg()\n",
    "            raise\n",
    "\n",
    "    def process_chunk(self):\n",
    "        #for item in self.chunk:\n",
    "        try:\n",
    "            #print self.chunk\n",
    "            self.total_inserts += len(self.chunk)\n",
    "            # print \"Inserted: %d number of docs\" % self.total_inserts\n",
    "        except:\n",
    "            # print \"issue inserting\"\n",
    "            pass"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# This code is used to process the json files and extract the needed attributes to get it into the format we need"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "insrt = GnipDataProcessor(\"IRMA Data\",\"\", chunk_size=1000)\n",
    "result = []\n",
    "mygen = insrt.iter_files()\n",
    "for i in mygen:\n",
    "    result.append(i)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "## Get the data and put it in a panda dataframe\n",
    "myjson = []\n",
    "for i in result[400:500]:\n",
    "    for j in i:\n",
    "        try:\n",
    "            myjson.append(json.loads(j))\n",
    "        except:\n",
    "            print j\n",
    "mypanda = pd.io.json.json_normalize(myjson)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### To eliminate unneccesary columns and modify the needed columns to a suitable format for MySQL."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "mydata = mypanda.copy()\n",
    "mydata = mydata.drop_duplicates(subset = ['id'])\n",
    "mydata = mydata[['id','postedTime','body','geo.coordinates', 'location.name',\n",
    "                  'twitter_entities.media','twitter_lang', 'twitter_entities.hashtags','actor.id','actor.preferredUsername',\n",
    "                  'actor.location.displayName','actor.verified','actor.followersCount','actor.friendsCount',\n",
    "                  'actor.statusesCount','actor.postedTime', 'location.displayName',\n",
    "                  'location.twitter_country_code','location.geo.coordinates']]\n",
    "mydata = mydata.dropna(axis = 0, how = 'all')\n",
    "mydata = mydata.loc[mydata['id'].notnull()]\n",
    "mydata = mydata.reset_index(drop = True)\n",
    "mydata = mydata.rename(index=str, columns={'id' : 'tweet.id', 'geo.coordinates' : 'tweet.coordinates',\n",
    "                                  'postedTime' : 'tweet.created_at', 'body' : 'tweet.text', 'twitter_lang' : 'tweet.lang',\n",
    "                                  'twitter_entities.media' : 'tweet.media', 'actor.id' : 'user.id',\n",
    "                                  'actor.preferredUsername' : 'user.screen_name', 'actor.location.displayName' : 'user.location',\n",
    "                                  'actor.verified' : 'user.verified', 'actor.followersCount': 'user.followers_count',\n",
    "                                  'actor.friendsCount' : 'user.friends_count', 'actor.statusesCount' : 'user.statuses_count',\n",
    "                                  'actor.postedTime' : 'user.created_at', 'twitter_entities.hashtags' : 'tweet.hashtags'})\n",
    "\n",
    "\n",
    "mydata = mydata.applymap(convertNanToNone)\n",
    "mydata['tweet.created_at'] = mydata['tweet.created_at'].apply(convertDTToDB)\n",
    "mydata['user.created_at'] = mydata['user.created_at'].apply(convertDTToDB)\n",
    "mydata['tweet.coordinates'] = mydata['tweet.coordinates'].apply(convertNanToNone)\n",
    "mydata['tweet.coordinates'] = mydata['tweet.coordinates'].apply(listToStr)\n",
    "mydata['tweet.text'] = mydata['tweet.text'].apply(normalizeTweetText)\n",
    "mydata['user.location'] = mydata['user.location'].apply(normalizeTweetText)\n",
    "mydata['location.name'] = mydata['location.name'].apply(normalizeTweetText)\n",
    "mydata['tweet.media'] = mydata['tweet.media'].apply(extractImageUrl)\n",
    "mydata['tweet.id'] = mydata['tweet.id'].apply(getOldId)\n",
    "mydata['user.id'] = mydata['user.id'].apply(getOldId)\n",
    "mydata['tweet.hashtags'] = mydata['tweet.hashtags'].apply(extractHashTags)\n",
    "mydata['tweet.hashtags'] = mydata['tweet.hashtags'].apply(normalizeTweetText)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Take needed columns for each type of objects to form tables later on."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "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>tweet.id</th>\n",
       "      <th>tweet.created_at</th>\n",
       "      <th>tweet.text</th>\n",
       "      <th>user.id</th>\n",
       "      <th>tweet.coordinates</th>\n",
       "      <th>location.name</th>\n",
       "      <th>tweet.media</th>\n",
       "      <th>tweet.lang</th>\n",
       "      <th>tweet.hashtags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>916979419482345472</td>\n",
       "      <td>2017-10-08 10:51:44</td>\n",
       "      <td>@birchbox I only received 4 things on my box t...</td>\n",
       "      <td>771830969934438401</td>\n",
       "      <td>None</td>\n",
       "      <td>Bayonet Point</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>916979495156019200</td>\n",
       "      <td>2017-10-08 10:52:02</td>\n",
       "      <td>#roadtrip #throughthewindshield #palmtrees #sk...</td>\n",
       "      <td>757948847184240646</td>\n",
       "      <td>[27.9736,-82.7643]</td>\n",
       "      <td>Clearwater</td>\n",
       "      <td>None</td>\n",
       "      <td>und</td>\n",
       "      <td>roadtrip,throughthewindshield,palmtrees,sky,ro...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>916979920915521536</td>\n",
       "      <td>2017-10-08 10:53:44</td>\n",
       "      <td>Call #TeamChais  813  928-4308 for all your #T...</td>\n",
       "      <td>24633648</td>\n",
       "      <td>[27.7625,-82.54583333]</td>\n",
       "      <td>Florida</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>TeamChais,TampaBay,RealEstate</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>916980269848113152</td>\n",
       "      <td>2017-10-08 10:55:07</td>\n",
       "      <td>@Antiloquy How does that make any fucking sense</td>\n",
       "      <td>815777993733898240</td>\n",
       "      <td>None</td>\n",
       "      <td>Ridge Wood Heights</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>916980733616549889</td>\n",
       "      <td>2017-10-08 10:56:58</td>\n",
       "      <td>News Channel 8 Today is on right now @WFLAEd @...</td>\n",
       "      <td>71023584</td>\n",
       "      <td>None</td>\n",
       "      <td>The NewsCenter  TBO.com, Tampa Tribune, News C...</td>\n",
       "      <td>http://pbs.twimg.com/ext_tw_video_thumb/916980...</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>916981310165569536</td>\n",
       "      <td>2017-10-08 10:59:15</td>\n",
       "      <td>Come see our newest Bikini Barista    Jessy Ju...</td>\n",
       "      <td>2284127615</td>\n",
       "      <td>[26.96755,-82.07943]</td>\n",
       "      <td>Charlotte Harbor</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>relaxfulsunday</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>916981304415178753</td>\n",
       "      <td>2017-10-08 10:59:14</td>\n",
       "      <td>Is it me u missing,just wondering</td>\n",
       "      <td>2876810176</td>\n",
       "      <td>None</td>\n",
       "      <td>Temple Terrace</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>916969566881943552</td>\n",
       "      <td>2017-10-08 10:12:35</td>\n",
       "      <td>I m never going to the casino again</td>\n",
       "      <td>4833325693</td>\n",
       "      <td>None</td>\n",
       "      <td>East Lake-Orient Park</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>916969658431033345</td>\n",
       "      <td>2017-10-08 10:12:57</td>\n",
       "      <td>And who really cares about him anyway  #GoodRi...</td>\n",
       "      <td>773983063936294913</td>\n",
       "      <td>None</td>\n",
       "      <td>Tallevast</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>GoodRiddanceJamesWoods</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>916970214474113024</td>\n",
       "      <td>2017-10-08 10:15:10</td>\n",
       "      <td>Officially a tattoo apprentice</td>\n",
       "      <td>4833325693</td>\n",
       "      <td>None</td>\n",
       "      <td>East Lake-Orient Park</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>916970429922734081</td>\n",
       "      <td>2017-10-08 10:16:01</td>\n",
       "      <td>few clouds - gt  scattered clouds wind 7mph - ...</td>\n",
       "      <td>123717228</td>\n",
       "      <td>[29.19,-82.14]</td>\n",
       "      <td>Ocala</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>916970535531069440</td>\n",
       "      <td>2017-10-08 10:16:26</td>\n",
       "      <td>Bro. Kevin works driving truck n in pain walki...</td>\n",
       "      <td>3353600338</td>\n",
       "      <td>[27.19,-82.37]</td>\n",
       "      <td>Florida</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>arthritis</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>916971421473169409</td>\n",
       "      <td>2017-10-08 10:19:58</td>\n",
       "      <td>I ve begun meditating before bed and in the mo...</td>\n",
       "      <td>43561421</td>\n",
       "      <td>[27.93643886,-82.29177654]</td>\n",
       "      <td>Florida</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>916977380811558913</td>\n",
       "      <td>2017-10-08 10:43:38</td>\n",
       "      <td>Draft legal Nationals went well. Good race. Lo...</td>\n",
       "      <td>41288447</td>\n",
       "      <td>[27.37315975,-82.45501344]</td>\n",
       "      <td>Florida</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>916977485673312256</td>\n",
       "      <td>2017-10-08 10:44:03</td>\n",
       "      <td>I voted #TWICE - Knock Knock in the #SBSPopAsi...</td>\n",
       "      <td>915344447122153472</td>\n",
       "      <td>None</td>\n",
       "      <td>East Lake-Orient Park</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>TWICE,SBSPopAsia,SBSPopAsiaTWICE</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>916978406549544960</td>\n",
       "      <td>2017-10-08 10:47:43</td>\n",
       "      <td>La NASA muestra im genes  nicas del sat lite m...</td>\n",
       "      <td>77657562</td>\n",
       "      <td>None</td>\n",
       "      <td>Cortez</td>\n",
       "      <td>None</td>\n",
       "      <td>es</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>916978639757029376</td>\n",
       "      <td>2017-10-08 10:48:39</td>\n",
       "      <td>Up to 57  Off Hair Services from Amy Knight at...</td>\n",
       "      <td>599549147</td>\n",
       "      <td>[26.5486,-81.913]</td>\n",
       "      <td>Cypress Lake</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>916974218817961984</td>\n",
       "      <td>2017-10-08 10:31:04</td>\n",
       "      <td>NOW SHOWING      At The Movies has come to @my...</td>\n",
       "      <td>518684416</td>\n",
       "      <td>[27.3251305,-82.5276031]</td>\n",
       "      <td>Sarasota</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>916974466349101056</td>\n",
       "      <td>2017-10-08 10:32:03</td>\n",
       "      <td>#i #must #motivate #find #select #edit #write ...</td>\n",
       "      <td>15939104</td>\n",
       "      <td>[28.00553087,-82.6861446]</td>\n",
       "      <td>Safety Harbor</td>\n",
       "      <td>None</td>\n",
       "      <td>und</td>\n",
       "      <td>i,must,motivate,find,select,edit,write,post,sp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>916975424130945024</td>\n",
       "      <td>2017-10-08 10:35:52</td>\n",
       "      <td>Good times with the guys   #internationalbeerg...</td>\n",
       "      <td>78102678</td>\n",
       "      <td>[28.1394,-82.462]</td>\n",
       "      <td>Lutz</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>internationalbeergarten</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>916975312122138624</td>\n",
       "      <td>2017-10-08 10:35:25</td>\n",
       "      <td>Alert: STRUCTURE FIRE @ 2201 26 AV S Tac: E Se...</td>\n",
       "      <td>71052378</td>\n",
       "      <td>[27.74505421,-82.66314484]</td>\n",
       "      <td>St Petersburg</td>\n",
       "      <td>None</td>\n",
       "      <td>fr</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>917117581592530944</td>\n",
       "      <td>2017-10-08 20:00:45</td>\n",
       "      <td>K https://t.co/quVDge9gU9</td>\n",
       "      <td>763062400820051968</td>\n",
       "      <td>None</td>\n",
       "      <td>Apollo Beach</td>\n",
       "      <td>None</td>\n",
       "      <td>und</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>917117508716548097</td>\n",
       "      <td>2017-10-08 20:00:27</td>\n",
       "      <td>SAT OCT 14TH...THE OFFICIAL FAMU HOMECOMING 2K...</td>\n",
       "      <td>65845929</td>\n",
       "      <td>[30.4517,-84.2685]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>917117442610139137</td>\n",
       "      <td>2017-10-08 20:00:12</td>\n",
       "      <td>15:52 Temp. 89.2 F, Hum. 80 , Dewp. 80.8 F, Ba...</td>\n",
       "      <td>19511251</td>\n",
       "      <td>[27.86977674,-82.80524377]</td>\n",
       "      <td>Seminole</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>917117562349113344</td>\n",
       "      <td>2017-10-08 20:00:40</td>\n",
       "      <td>ABBREDARIS</td>\n",
       "      <td>165857230</td>\n",
       "      <td>None</td>\n",
       "      <td>Temple Terrace</td>\n",
       "      <td>None</td>\n",
       "      <td>in</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>917117414239887360</td>\n",
       "      <td>2017-10-08 20:00:05</td>\n",
       "      <td>Winning games is too easy when you have the 2 ...</td>\n",
       "      <td>1703452406</td>\n",
       "      <td>None</td>\n",
       "      <td>Elfers</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>917117847645585408</td>\n",
       "      <td>2017-10-08 20:01:48</td>\n",
       "      <td>Found peace in knowing</td>\n",
       "      <td>709195136866111488</td>\n",
       "      <td>None</td>\n",
       "      <td>Bear Creek</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>917117834395779073</td>\n",
       "      <td>2017-10-08 20:01:45</td>\n",
       "      <td>We are seeking 10 vegans/vegetarians/non-dairy...</td>\n",
       "      <td>2194752920</td>\n",
       "      <td>[30.44031,-84.3204]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>917117878461190146</td>\n",
       "      <td>2017-10-08 20:01:56</td>\n",
       "      <td>Pourin  one out for the Noles #Rip @ Florida S...</td>\n",
       "      <td>1317266774</td>\n",
       "      <td>[30.44205964,-84.29744983]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>Rip</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>917117688316559362</td>\n",
       "      <td>2017-10-08 20:01:10</td>\n",
       "      <td>Sunday football with the boys @ Island Wing Co...</td>\n",
       "      <td>2954433508</td>\n",
       "      <td>[30.50627006,-84.25380382]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3974</th>\n",
       "      <td>916807931034849280</td>\n",
       "      <td>2017-10-07 23:30:18</td>\n",
       "      <td>We re behind you @JTBrown23  https://t.co/OxYd...</td>\n",
       "      <td>3371654080</td>\n",
       "      <td>None</td>\n",
       "      <td>Egypt Lake-Leto</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3975</th>\n",
       "      <td>916807927641575424</td>\n",
       "      <td>2017-10-07 23:30:18</td>\n",
       "      <td>Sunset    https://t.co/jp2ZEIzThD</td>\n",
       "      <td>1493092015</td>\n",
       "      <td>None</td>\n",
       "      <td>Lido Beach</td>\n",
       "      <td>http://pbs.twimg.com/media/DLkn8AfWkAAdSLj.jpg</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3976</th>\n",
       "      <td>916808294676779008</td>\n",
       "      <td>2017-10-07 23:31:45</td>\n",
       "      <td>This Kucherov and Stamkos line is so</td>\n",
       "      <td>403111685</td>\n",
       "      <td>None</td>\n",
       "      <td>Lealman</td>\n",
       "      <td>None</td>\n",
       "      <td>de</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3977</th>\n",
       "      <td>916808312196403200</td>\n",
       "      <td>2017-10-07 23:31:49</td>\n",
       "      <td>@CampagnoloKatie Beautiful https://t.co/jLbpTs...</td>\n",
       "      <td>166348853</td>\n",
       "      <td>None</td>\n",
       "      <td>Greater Northdale</td>\n",
       "      <td>http://pbs.twimg.com/tweet_video_thumb/DLkoSqd...</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3978</th>\n",
       "      <td>916808385672118272</td>\n",
       "      <td>2017-10-07 23:32:07</td>\n",
       "      <td>I saw Grim and Mandy    Childhood dream came t...</td>\n",
       "      <td>2568233375</td>\n",
       "      <td>[27.94182251,-82.45591237]</td>\n",
       "      <td>Tampa</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3979</th>\n",
       "      <td>916808415254597632</td>\n",
       "      <td>2017-10-07 23:32:14</td>\n",
       "      <td>https://t.co/odsalLmwn5</td>\n",
       "      <td>311168240</td>\n",
       "      <td>None</td>\n",
       "      <td>Doak Campbell Stadium</td>\n",
       "      <td>http://pbs.twimg.com/media/DLkoWniX0AAzcfS.jpg</td>\n",
       "      <td>und</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3980</th>\n",
       "      <td>916808414889598977</td>\n",
       "      <td>2017-10-07 23:32:14</td>\n",
       "      <td>guess she brought Mizzou s bad luck down to Fl...</td>\n",
       "      <td>163352168</td>\n",
       "      <td>[29.65091,-82.3486999]</td>\n",
       "      <td>Gainesville</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3981</th>\n",
       "      <td>916808565691682816</td>\n",
       "      <td>2017-10-07 23:32:50</td>\n",
       "      <td>Been ready fa ya ugly ah        #MIAvsFSU #The...</td>\n",
       "      <td>739653746095980548</td>\n",
       "      <td>None</td>\n",
       "      <td>Temple Terrace</td>\n",
       "      <td>http://pbs.twimg.com/media/DLkohV-UIAACA54.jpg</td>\n",
       "      <td>en</td>\n",
       "      <td>MIAvsFSU,TheU,Canes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3982</th>\n",
       "      <td>916808508095516673</td>\n",
       "      <td>2017-10-07 23:32:36</td>\n",
       "      <td>Icha is our little green alien   #didntgetszec...</td>\n",
       "      <td>2758857807</td>\n",
       "      <td>[27.96033554,-82.44054364]</td>\n",
       "      <td>Tampa</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>didntgetszechuansauce,beenugly</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3983</th>\n",
       "      <td>916808497546788864</td>\n",
       "      <td>2017-10-07 23:32:33</td>\n",
       "      <td>LOL https://t.co/z6I3MLKcCr</td>\n",
       "      <td>2284651774</td>\n",
       "      <td>None</td>\n",
       "      <td>Temple Terrace</td>\n",
       "      <td>None</td>\n",
       "      <td>und</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3984</th>\n",
       "      <td>916808488747184129</td>\n",
       "      <td>2017-10-07 23:32:31</td>\n",
       "      <td>@NEVRLANDSBand      https://t.co/tLCWnurpGG</td>\n",
       "      <td>323227071</td>\n",
       "      <td>None</td>\n",
       "      <td>Oldsmar</td>\n",
       "      <td>None</td>\n",
       "      <td>und</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3985</th>\n",
       "      <td>916808554216030209</td>\n",
       "      <td>2017-10-07 23:32:47</td>\n",
       "      <td>Who makes a canvas page for a  unbook study  s...</td>\n",
       "      <td>1540171088</td>\n",
       "      <td>None</td>\n",
       "      <td>Holiday</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>empowerPasco</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3986</th>\n",
       "      <td>916808690191056896</td>\n",
       "      <td>2017-10-07 23:33:19</td>\n",
       "      <td>Juri Ide flying over the clouds to win the #sa...</td>\n",
       "      <td>3400456365</td>\n",
       "      <td>[27.37315975,-82.45501344]</td>\n",
       "      <td>Florida</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>sarasotawc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3987</th>\n",
       "      <td>916808840770871296</td>\n",
       "      <td>2017-10-07 23:33:55</td>\n",
       "      <td>#Canes are undefeated and the #Noles Suck Agai...</td>\n",
       "      <td>55712090</td>\n",
       "      <td>[30.43782455,-84.3036184]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>Canes,Noles,BeatFSU</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3988</th>\n",
       "      <td>916808642422288385</td>\n",
       "      <td>2017-10-07 23:33:08</td>\n",
       "      <td>@CoachKellyFSU I don t want to see you in a Fl...</td>\n",
       "      <td>2410269635</td>\n",
       "      <td>None</td>\n",
       "      <td>Fish Hawk</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3989</th>\n",
       "      <td>916808808604880898</td>\n",
       "      <td>2017-10-07 23:33:48</td>\n",
       "      <td>The Your Life Designed and Organized Series is...</td>\n",
       "      <td>116056938</td>\n",
       "      <td>[27.9709,-82.4646]</td>\n",
       "      <td>Tampa</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3990</th>\n",
       "      <td>916808648004820992</td>\n",
       "      <td>2017-10-07 23:33:09</td>\n",
       "      <td>Miami Hurricanes break the 7 year long losing ...</td>\n",
       "      <td>2156572433</td>\n",
       "      <td>[30.43782455,-84.3036184]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3991</th>\n",
       "      <td>916808855958454273</td>\n",
       "      <td>2017-10-07 23:33:59</td>\n",
       "      <td>Checking it out  @ The Pink Piano in Lakeland,...</td>\n",
       "      <td>37548551</td>\n",
       "      <td>[28.03069864,-81.95727192]</td>\n",
       "      <td>Lakeland</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3992</th>\n",
       "      <td>916808874757382144</td>\n",
       "      <td>2017-10-07 23:34:03</td>\n",
       "      <td>@alex18marshall @HNYNUT_BERRIOS Glad he s a se...</td>\n",
       "      <td>2410269635</td>\n",
       "      <td>None</td>\n",
       "      <td>Fish Hawk</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3993</th>\n",
       "      <td>916808934408753152</td>\n",
       "      <td>2017-10-07 23:34:18</td>\n",
       "      <td>If i could pick up FSU and move it somewhere c...</td>\n",
       "      <td>454469390</td>\n",
       "      <td>[30.44205964,-84.29744983]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>gonoles</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3994</th>\n",
       "      <td>916808913525399553</td>\n",
       "      <td>2017-10-07 23:34:13</td>\n",
       "      <td>that liquor got me tripping can i have you girl</td>\n",
       "      <td>3041584536</td>\n",
       "      <td>None</td>\n",
       "      <td>Rubonia</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3995</th>\n",
       "      <td>916808890708385792</td>\n",
       "      <td>2017-10-07 23:34:07</td>\n",
       "      <td>1st UM v. FSU game and my little cane heart is...</td>\n",
       "      <td>817595230186864644</td>\n",
       "      <td>[30.43782455,-84.3036184]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3996</th>\n",
       "      <td>916808939215388672</td>\n",
       "      <td>2017-10-07 23:34:19</td>\n",
       "      <td>Yummy  @ Bamboozle Cafe https://t.co/j1kmfRhzDA</td>\n",
       "      <td>33220637</td>\n",
       "      <td>[27.9485649,-82.4594604]</td>\n",
       "      <td>Tampa</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3997</th>\n",
       "      <td>916809010355032064</td>\n",
       "      <td>2017-10-07 23:34:36</td>\n",
       "      <td>Easy to drink not hoppy or bitter - Drinking a...</td>\n",
       "      <td>2203807681</td>\n",
       "      <td>[27.4968,-82.5326]</td>\n",
       "      <td>Bradenton</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>photo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3998</th>\n",
       "      <td>916809097022005255</td>\n",
       "      <td>2017-10-07 23:34:56</td>\n",
       "      <td>Survived @ Doak S. Campbell Stadium https://t....</td>\n",
       "      <td>35590604</td>\n",
       "      <td>[30.43782455,-84.3036184]</td>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3999</th>\n",
       "      <td>916809216823889922</td>\n",
       "      <td>2017-10-07 23:35:25</td>\n",
       "      <td>Happy #Canes fans leaving Doak https://t.co/c2...</td>\n",
       "      <td>37228652</td>\n",
       "      <td>None</td>\n",
       "      <td>Doak Campbell Stadium</td>\n",
       "      <td>http://pbs.twimg.com/ext_tw_video_thumb/916808...</td>\n",
       "      <td>en</td>\n",
       "      <td>Canes</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4000</th>\n",
       "      <td>916809392992997378</td>\n",
       "      <td>2017-10-07 23:36:07</td>\n",
       "      <td>If Neil Diamond isn t singing in heaven, then ...</td>\n",
       "      <td>1332445068</td>\n",
       "      <td>None</td>\n",
       "      <td>Sugarmill Woods</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4001</th>\n",
       "      <td>916809463092346880</td>\n",
       "      <td>2017-10-07 23:36:24</td>\n",
       "      <td>I am officially Jerked out #JerkFest #2017 #pu...</td>\n",
       "      <td>480713820</td>\n",
       "      <td>[26.9386463,-82.05419243]</td>\n",
       "      <td>Punta Gorda</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>JerkFest,puntagorda</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4002</th>\n",
       "      <td>916809580067409921</td>\n",
       "      <td>2017-10-07 23:36:52</td>\n",
       "      <td>Damn this match got real tight. #NintendoWorld...</td>\n",
       "      <td>22808420</td>\n",
       "      <td>None</td>\n",
       "      <td>Oldsmar</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>NintendoWorldChampionships</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4003</th>\n",
       "      <td>916809363452555265</td>\n",
       "      <td>2017-10-07 23:36:00</td>\n",
       "      <td>If Miami beating us means CK is fired... I m h...</td>\n",
       "      <td>2410269635</td>\n",
       "      <td>None</td>\n",
       "      <td>Fish Hawk</td>\n",
       "      <td>None</td>\n",
       "      <td>en</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4004 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                tweet.id     tweet.created_at  \\\n",
       "0     916979419482345472  2017-10-08 10:51:44   \n",
       "1     916979495156019200  2017-10-08 10:52:02   \n",
       "2     916979920915521536  2017-10-08 10:53:44   \n",
       "3     916980269848113152  2017-10-08 10:55:07   \n",
       "4     916980733616549889  2017-10-08 10:56:58   \n",
       "5     916981310165569536  2017-10-08 10:59:15   \n",
       "6     916981304415178753  2017-10-08 10:59:14   \n",
       "7     916969566881943552  2017-10-08 10:12:35   \n",
       "8     916969658431033345  2017-10-08 10:12:57   \n",
       "9     916970214474113024  2017-10-08 10:15:10   \n",
       "10    916970429922734081  2017-10-08 10:16:01   \n",
       "11    916970535531069440  2017-10-08 10:16:26   \n",
       "12    916971421473169409  2017-10-08 10:19:58   \n",
       "13    916977380811558913  2017-10-08 10:43:38   \n",
       "14    916977485673312256  2017-10-08 10:44:03   \n",
       "15    916978406549544960  2017-10-08 10:47:43   \n",
       "16    916978639757029376  2017-10-08 10:48:39   \n",
       "17    916974218817961984  2017-10-08 10:31:04   \n",
       "18    916974466349101056  2017-10-08 10:32:03   \n",
       "19    916975424130945024  2017-10-08 10:35:52   \n",
       "20    916975312122138624  2017-10-08 10:35:25   \n",
       "21    917117581592530944  2017-10-08 20:00:45   \n",
       "22    917117508716548097  2017-10-08 20:00:27   \n",
       "23    917117442610139137  2017-10-08 20:00:12   \n",
       "24    917117562349113344  2017-10-08 20:00:40   \n",
       "25    917117414239887360  2017-10-08 20:00:05   \n",
       "26    917117847645585408  2017-10-08 20:01:48   \n",
       "27    917117834395779073  2017-10-08 20:01:45   \n",
       "28    917117878461190146  2017-10-08 20:01:56   \n",
       "29    917117688316559362  2017-10-08 20:01:10   \n",
       "...                  ...                  ...   \n",
       "3974  916807931034849280  2017-10-07 23:30:18   \n",
       "3975  916807927641575424  2017-10-07 23:30:18   \n",
       "3976  916808294676779008  2017-10-07 23:31:45   \n",
       "3977  916808312196403200  2017-10-07 23:31:49   \n",
       "3978  916808385672118272  2017-10-07 23:32:07   \n",
       "3979  916808415254597632  2017-10-07 23:32:14   \n",
       "3980  916808414889598977  2017-10-07 23:32:14   \n",
       "3981  916808565691682816  2017-10-07 23:32:50   \n",
       "3982  916808508095516673  2017-10-07 23:32:36   \n",
       "3983  916808497546788864  2017-10-07 23:32:33   \n",
       "3984  916808488747184129  2017-10-07 23:32:31   \n",
       "3985  916808554216030209  2017-10-07 23:32:47   \n",
       "3986  916808690191056896  2017-10-07 23:33:19   \n",
       "3987  916808840770871296  2017-10-07 23:33:55   \n",
       "3988  916808642422288385  2017-10-07 23:33:08   \n",
       "3989  916808808604880898  2017-10-07 23:33:48   \n",
       "3990  916808648004820992  2017-10-07 23:33:09   \n",
       "3991  916808855958454273  2017-10-07 23:33:59   \n",
       "3992  916808874757382144  2017-10-07 23:34:03   \n",
       "3993  916808934408753152  2017-10-07 23:34:18   \n",
       "3994  916808913525399553  2017-10-07 23:34:13   \n",
       "3995  916808890708385792  2017-10-07 23:34:07   \n",
       "3996  916808939215388672  2017-10-07 23:34:19   \n",
       "3997  916809010355032064  2017-10-07 23:34:36   \n",
       "3998  916809097022005255  2017-10-07 23:34:56   \n",
       "3999  916809216823889922  2017-10-07 23:35:25   \n",
       "4000  916809392992997378  2017-10-07 23:36:07   \n",
       "4001  916809463092346880  2017-10-07 23:36:24   \n",
       "4002  916809580067409921  2017-10-07 23:36:52   \n",
       "4003  916809363452555265  2017-10-07 23:36:00   \n",
       "\n",
       "                                             tweet.text             user.id  \\\n",
       "0     @birchbox I only received 4 things on my box t...  771830969934438401   \n",
       "1     #roadtrip #throughthewindshield #palmtrees #sk...  757948847184240646   \n",
       "2     Call #TeamChais  813  928-4308 for all your #T...            24633648   \n",
       "3      @Antiloquy How does that make any fucking sense   815777993733898240   \n",
       "4     News Channel 8 Today is on right now @WFLAEd @...            71023584   \n",
       "5     Come see our newest Bikini Barista    Jessy Ju...          2284127615   \n",
       "6                    Is it me u missing,just wondering           2876810176   \n",
       "7                   I m never going to the casino again          4833325693   \n",
       "8     And who really cares about him anyway  #GoodRi...  773983063936294913   \n",
       "9                      Officially a tattoo apprentice            4833325693   \n",
       "10    few clouds - gt  scattered clouds wind 7mph - ...           123717228   \n",
       "11    Bro. Kevin works driving truck n in pain walki...          3353600338   \n",
       "12    I ve begun meditating before bed and in the mo...            43561421   \n",
       "13    Draft legal Nationals went well. Good race. Lo...            41288447   \n",
       "14    I voted #TWICE - Knock Knock in the #SBSPopAsi...  915344447122153472   \n",
       "15    La NASA muestra im genes  nicas del sat lite m...            77657562   \n",
       "16    Up to 57  Off Hair Services from Amy Knight at...           599549147   \n",
       "17    NOW SHOWING      At The Movies has come to @my...           518684416   \n",
       "18    #i #must #motivate #find #select #edit #write ...            15939104   \n",
       "19    Good times with the guys   #internationalbeerg...            78102678   \n",
       "20    Alert: STRUCTURE FIRE @ 2201 26 AV S Tac: E Se...            71052378   \n",
       "21                            K https://t.co/quVDge9gU9  763062400820051968   \n",
       "22    SAT OCT 14TH...THE OFFICIAL FAMU HOMECOMING 2K...            65845929   \n",
       "23    15:52 Temp. 89.2 F, Hum. 80 , Dewp. 80.8 F, Ba...            19511251   \n",
       "24                                         ABBREDARIS             165857230   \n",
       "25    Winning games is too easy when you have the 2 ...          1703452406   \n",
       "26                               Found peace in knowing  709195136866111488   \n",
       "27    We are seeking 10 vegans/vegetarians/non-dairy...          2194752920   \n",
       "28    Pourin  one out for the Noles #Rip @ Florida S...          1317266774   \n",
       "29    Sunday football with the boys @ Island Wing Co...          2954433508   \n",
       "...                                                 ...                 ...   \n",
       "3974  We re behind you @JTBrown23  https://t.co/OxYd...          3371654080   \n",
       "3975                  Sunset    https://t.co/jp2ZEIzThD          1493092015   \n",
       "3976            This Kucherov and Stamkos line is so              403111685   \n",
       "3977  @CampagnoloKatie Beautiful https://t.co/jLbpTs...           166348853   \n",
       "3978  I saw Grim and Mandy    Childhood dream came t...          2568233375   \n",
       "3979                            https://t.co/odsalLmwn5           311168240   \n",
       "3980  guess she brought Mizzou s bad luck down to Fl...           163352168   \n",
       "3981  Been ready fa ya ugly ah        #MIAvsFSU #The...  739653746095980548   \n",
       "3982  Icha is our little green alien   #didntgetszec...          2758857807   \n",
       "3983                        LOL https://t.co/z6I3MLKcCr          2284651774   \n",
       "3984        @NEVRLANDSBand      https://t.co/tLCWnurpGG           323227071   \n",
       "3985  Who makes a canvas page for a  unbook study  s...          1540171088   \n",
       "3986  Juri Ide flying over the clouds to win the #sa...          3400456365   \n",
       "3987  #Canes are undefeated and the #Noles Suck Agai...            55712090   \n",
       "3988  @CoachKellyFSU I don t want to see you in a Fl...          2410269635   \n",
       "3989  The Your Life Designed and Organized Series is...           116056938   \n",
       "3990  Miami Hurricanes break the 7 year long losing ...          2156572433   \n",
       "3991  Checking it out  @ The Pink Piano in Lakeland,...            37548551   \n",
       "3992  @alex18marshall @HNYNUT_BERRIOS Glad he s a se...          2410269635   \n",
       "3993  If i could pick up FSU and move it somewhere c...           454469390   \n",
       "3994  that liquor got me tripping can i have you girl            3041584536   \n",
       "3995  1st UM v. FSU game and my little cane heart is...  817595230186864644   \n",
       "3996    Yummy  @ Bamboozle Cafe https://t.co/j1kmfRhzDA            33220637   \n",
       "3997  Easy to drink not hoppy or bitter - Drinking a...          2203807681   \n",
       "3998  Survived @ Doak S. Campbell Stadium https://t....            35590604   \n",
       "3999  Happy #Canes fans leaving Doak https://t.co/c2...            37228652   \n",
       "4000  If Neil Diamond isn t singing in heaven, then ...          1332445068   \n",
       "4001  I am officially Jerked out #JerkFest #2017 #pu...           480713820   \n",
       "4002  Damn this match got real tight. #NintendoWorld...            22808420   \n",
       "4003  If Miami beating us means CK is fired... I m h...          2410269635   \n",
       "\n",
       "               tweet.coordinates  \\\n",
       "0                           None   \n",
       "1             [27.9736,-82.7643]   \n",
       "2         [27.7625,-82.54583333]   \n",
       "3                           None   \n",
       "4                           None   \n",
       "5           [26.96755,-82.07943]   \n",
       "6                           None   \n",
       "7                           None   \n",
       "8                           None   \n",
       "9                           None   \n",
       "10                [29.19,-82.14]   \n",
       "11                [27.19,-82.37]   \n",
       "12    [27.93643886,-82.29177654]   \n",
       "13    [27.37315975,-82.45501344]   \n",
       "14                          None   \n",
       "15                          None   \n",
       "16             [26.5486,-81.913]   \n",
       "17      [27.3251305,-82.5276031]   \n",
       "18     [28.00553087,-82.6861446]   \n",
       "19             [28.1394,-82.462]   \n",
       "20    [27.74505421,-82.66314484]   \n",
       "21                          None   \n",
       "22            [30.4517,-84.2685]   \n",
       "23    [27.86977674,-82.80524377]   \n",
       "24                          None   \n",
       "25                          None   \n",
       "26                          None   \n",
       "27           [30.44031,-84.3204]   \n",
       "28    [30.44205964,-84.29744983]   \n",
       "29    [30.50627006,-84.25380382]   \n",
       "...                          ...   \n",
       "3974                        None   \n",
       "3975                        None   \n",
       "3976                        None   \n",
       "3977                        None   \n",
       "3978  [27.94182251,-82.45591237]   \n",
       "3979                        None   \n",
       "3980      [29.65091,-82.3486999]   \n",
       "3981                        None   \n",
       "3982  [27.96033554,-82.44054364]   \n",
       "3983                        None   \n",
       "3984                        None   \n",
       "3985                        None   \n",
       "3986  [27.37315975,-82.45501344]   \n",
       "3987   [30.43782455,-84.3036184]   \n",
       "3988                        None   \n",
       "3989          [27.9709,-82.4646]   \n",
       "3990   [30.43782455,-84.3036184]   \n",
       "3991  [28.03069864,-81.95727192]   \n",
       "3992                        None   \n",
       "3993  [30.44205964,-84.29744983]   \n",
       "3994                        None   \n",
       "3995   [30.43782455,-84.3036184]   \n",
       "3996    [27.9485649,-82.4594604]   \n",
       "3997          [27.4968,-82.5326]   \n",
       "3998   [30.43782455,-84.3036184]   \n",
       "3999                        None   \n",
       "4000                        None   \n",
       "4001   [26.9386463,-82.05419243]   \n",
       "4002                        None   \n",
       "4003                        None   \n",
       "\n",
       "                                          location.name  \\\n",
       "0                                         Bayonet Point   \n",
       "1                                            Clearwater   \n",
       "2                                               Florida   \n",
       "3                                    Ridge Wood Heights   \n",
       "4     The NewsCenter  TBO.com, Tampa Tribune, News C...   \n",
       "5                                      Charlotte Harbor   \n",
       "6                                        Temple Terrace   \n",
       "7                                 East Lake-Orient Park   \n",
       "8                                             Tallevast   \n",
       "9                                 East Lake-Orient Park   \n",
       "10                                                Ocala   \n",
       "11                                              Florida   \n",
       "12                                              Florida   \n",
       "13                                              Florida   \n",
       "14                                East Lake-Orient Park   \n",
       "15                                               Cortez   \n",
       "16                                         Cypress Lake   \n",
       "17                                             Sarasota   \n",
       "18                                        Safety Harbor   \n",
       "19                                                 Lutz   \n",
       "20                                        St Petersburg   \n",
       "21                                         Apollo Beach   \n",
       "22                                          Tallahassee   \n",
       "23                                             Seminole   \n",
       "24                                       Temple Terrace   \n",
       "25                                               Elfers   \n",
       "26                                           Bear Creek   \n",
       "27                                          Tallahassee   \n",
       "28                                          Tallahassee   \n",
       "29                                          Tallahassee   \n",
       "...                                                 ...   \n",
       "3974                                    Egypt Lake-Leto   \n",
       "3975                                         Lido Beach   \n",
       "3976                                            Lealman   \n",
       "3977                                  Greater Northdale   \n",
       "3978                                              Tampa   \n",
       "3979                              Doak Campbell Stadium   \n",
       "3980                                        Gainesville   \n",
       "3981                                     Temple Terrace   \n",
       "3982                                              Tampa   \n",
       "3983                                     Temple Terrace   \n",
       "3984                                            Oldsmar   \n",
       "3985                                            Holiday   \n",
       "3986                                            Florida   \n",
       "3987                                        Tallahassee   \n",
       "3988                                          Fish Hawk   \n",
       "3989                                              Tampa   \n",
       "3990                                        Tallahassee   \n",
       "3991                                           Lakeland   \n",
       "3992                                          Fish Hawk   \n",
       "3993                                        Tallahassee   \n",
       "3994                                            Rubonia   \n",
       "3995                                        Tallahassee   \n",
       "3996                                              Tampa   \n",
       "3997                                          Bradenton   \n",
       "3998                                        Tallahassee   \n",
       "3999                              Doak Campbell Stadium   \n",
       "4000                                    Sugarmill Woods   \n",
       "4001                                        Punta Gorda   \n",
       "4002                                            Oldsmar   \n",
       "4003                                          Fish Hawk   \n",
       "\n",
       "                                            tweet.media tweet.lang  \\\n",
       "0                                                  None         en   \n",
       "1                                                  None        und   \n",
       "2                                                  None         en   \n",
       "3                                                  None         en   \n",
       "4     http://pbs.twimg.com/ext_tw_video_thumb/916980...         en   \n",
       "5                                                  None         en   \n",
       "6                                                  None         en   \n",
       "7                                                  None         en   \n",
       "8                                                  None         en   \n",
       "9                                                  None         en   \n",
       "10                                                 None         en   \n",
       "11                                                 None         en   \n",
       "12                                                 None         en   \n",
       "13                                                 None         en   \n",
       "14                                                 None         en   \n",
       "15                                                 None         es   \n",
       "16                                                 None         en   \n",
       "17                                                 None         en   \n",
       "18                                                 None        und   \n",
       "19                                                 None         en   \n",
       "20                                                 None         fr   \n",
       "21                                                 None        und   \n",
       "22                                                 None         en   \n",
       "23                                                 None         en   \n",
       "24                                                 None         in   \n",
       "25                                                 None         en   \n",
       "26                                                 None         en   \n",
       "27                                                 None         en   \n",
       "28                                                 None         en   \n",
       "29                                                 None         en   \n",
       "...                                                 ...        ...   \n",
       "3974                                               None         en   \n",
       "3975     http://pbs.twimg.com/media/DLkn8AfWkAAdSLj.jpg         en   \n",
       "3976                                               None         de   \n",
       "3977  http://pbs.twimg.com/tweet_video_thumb/DLkoSqd...         en   \n",
       "3978                                               None         en   \n",
       "3979     http://pbs.twimg.com/media/DLkoWniX0AAzcfS.jpg        und   \n",
       "3980                                               None         en   \n",
       "3981     http://pbs.twimg.com/media/DLkohV-UIAACA54.jpg         en   \n",
       "3982                                               None         en   \n",
       "3983                                               None        und   \n",
       "3984                                               None        und   \n",
       "3985                                               None         en   \n",
       "3986                                               None         en   \n",
       "3987                                               None         en   \n",
       "3988                                               None         en   \n",
       "3989                                               None         en   \n",
       "3990                                               None         en   \n",
       "3991                                               None         en   \n",
       "3992                                               None         en   \n",
       "3993                                               None         en   \n",
       "3994                                               None         en   \n",
       "3995                                               None         en   \n",
       "3996                                               None         en   \n",
       "3997                                               None         en   \n",
       "3998                                               None         en   \n",
       "3999  http://pbs.twimg.com/ext_tw_video_thumb/916808...         en   \n",
       "4000                                               None         en   \n",
       "4001                                               None         en   \n",
       "4002                                               None         en   \n",
       "4003                                               None         en   \n",
       "\n",
       "                                         tweet.hashtags  \n",
       "0                                                  None  \n",
       "1     roadtrip,throughthewindshield,palmtrees,sky,ro...  \n",
       "2                         TeamChais,TampaBay,RealEstate  \n",
       "3                                                  None  \n",
       "4                                                  None  \n",
       "5                                        relaxfulsunday  \n",
       "6                                                  None  \n",
       "7                                                  None  \n",
       "8                                GoodRiddanceJamesWoods  \n",
       "9                                                  None  \n",
       "10                                                 None  \n",
       "11                                            arthritis  \n",
       "12                                                 None  \n",
       "13                                                 None  \n",
       "14                     TWICE,SBSPopAsia,SBSPopAsiaTWICE  \n",
       "15                                                 None  \n",
       "16                                                 None  \n",
       "17                                                 None  \n",
       "18    i,must,motivate,find,select,edit,write,post,sp...  \n",
       "19                              internationalbeergarten  \n",
       "20                                                 None  \n",
       "21                                                 None  \n",
       "22                                                 None  \n",
       "23                                                 None  \n",
       "24                                                 None  \n",
       "25                                                 None  \n",
       "26                                                 None  \n",
       "27                                                 None  \n",
       "28                                                  Rip  \n",
       "29                                                 None  \n",
       "...                                                 ...  \n",
       "3974                                               None  \n",
       "3975                                               None  \n",
       "3976                                               None  \n",
       "3977                                               None  \n",
       "3978                                               None  \n",
       "3979                                               None  \n",
       "3980                                               None  \n",
       "3981                                MIAvsFSU,TheU,Canes  \n",
       "3982                     didntgetszechuansauce,beenugly  \n",
       "3983                                               None  \n",
       "3984                                               None  \n",
       "3985                                       empowerPasco  \n",
       "3986                                         sarasotawc  \n",
       "3987                                Canes,Noles,BeatFSU  \n",
       "3988                                               None  \n",
       "3989                                               None  \n",
       "3990                                               None  \n",
       "3991                                               None  \n",
       "3992                                               None  \n",
       "3993                                            gonoles  \n",
       "3994                                               None  \n",
       "3995                                               None  \n",
       "3996                                               None  \n",
       "3997                                              photo  \n",
       "3998                                               None  \n",
       "3999                                              Canes  \n",
       "4000                                               None  \n",
       "4001                                JerkFest,puntagorda  \n",
       "4002                         NintendoWorldChampionships  \n",
       "4003                                               None  \n",
       "\n",
       "[4004 rows x 9 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets = mydata[['tweet.id','tweet.created_at','tweet.text','user.id','tweet.coordinates','location.name','tweet.media','tweet.lang', 'tweet.hashtags']]\n",
    "tweets"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {
    "scrolled": true
   },
   "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>user.id</th>\n",
       "      <th>user.screen_name</th>\n",
       "      <th>user.location</th>\n",
       "      <th>user.verified</th>\n",
       "      <th>user.followers_count</th>\n",
       "      <th>user.friends_count</th>\n",
       "      <th>user.statuses_count</th>\n",
       "      <th>user.created_at</th>\n",
       "      <th>klout_score</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>771830969934438401</td>\n",
       "      <td>SPNGIRL420</td>\n",
       "      <td>New Port Richey, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>21</td>\n",
       "      <td>95</td>\n",
       "      <td>242</td>\n",
       "      <td>2016-09-02 22:03:38</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>757948847184240646</td>\n",
       "      <td>techno_nomadic</td>\n",
       "      <td>Bushnell, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>35</td>\n",
       "      <td>112</td>\n",
       "      <td>1061</td>\n",
       "      <td>2016-07-26 14:41:01</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>24633648</td>\n",
       "      <td>TeamChais</td>\n",
       "      <td>Tampa, Florida</td>\n",
       "      <td>False</td>\n",
       "      <td>3714</td>\n",
       "      <td>3712</td>\n",
       "      <td>18395</td>\n",
       "      <td>2009-03-16 02:23:05</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>815777993733898240</td>\n",
       "      <td>thescarybeary</td>\n",
       "      <td>Earth</td>\n",
       "      <td>False</td>\n",
       "      <td>36</td>\n",
       "      <td>172</td>\n",
       "      <td>1207</td>\n",
       "      <td>2017-01-02 04:33:24</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>71023584</td>\n",
       "      <td>WFLAPaulM</td>\n",
       "      <td>Tampa Bay, FL</td>\n",
       "      <td>True</td>\n",
       "      <td>2992</td>\n",
       "      <td>457</td>\n",
       "      <td>28814</td>\n",
       "      <td>2009-09-02 17:36:44</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>2284127615</td>\n",
       "      <td>cabaristas</td>\n",
       "      <td>Port Charlotte, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>1441</td>\n",
       "      <td>150</td>\n",
       "      <td>3293</td>\n",
       "      <td>2014-01-15 16:34:34</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>2876810176</td>\n",
       "      <td>JoannGuimares</td>\n",
       "      <td>Tampa, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>24</td>\n",
       "      <td>49</td>\n",
       "      <td>561</td>\n",
       "      <td>2014-11-14 18:35:50</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>4833325693</td>\n",
       "      <td>alexis_renee18</td>\n",
       "      <td>California    Florida</td>\n",
       "      <td>False</td>\n",
       "      <td>206</td>\n",
       "      <td>189</td>\n",
       "      <td>4990</td>\n",
       "      <td>2016-01-30 03:54:30</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>773983063936294913</td>\n",
       "      <td>geribaby1947</td>\n",
       "      <td>North Sarasota, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>1190</td>\n",
       "      <td>1684</td>\n",
       "      <td>13374</td>\n",
       "      <td>2016-09-08 20:35:17</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>123717228</td>\n",
       "      <td>_OcalaFL</td>\n",
       "      <td>Ocala, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>294</td>\n",
       "      <td>4</td>\n",
       "      <td>31591</td>\n",
       "      <td>2010-03-17 01:04:59</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>3353600338</td>\n",
       "      <td>TinaSuePatters2</td>\n",
       "      <td>Sarasota Florida</td>\n",
       "      <td>False</td>\n",
       "      <td>741</td>\n",
       "      <td>895</td>\n",
       "      <td>11871</td>\n",
       "      <td>2015-07-01 17:56:15</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>43561421</td>\n",
       "      <td>JenniCoolWhip</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>885</td>\n",
       "      <td>803</td>\n",
       "      <td>12915</td>\n",
       "      <td>2009-05-30 17:33:41</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>41288447</td>\n",
       "      <td>jaybjackson</td>\n",
       "      <td>Murfreesboro, TN</td>\n",
       "      <td>False</td>\n",
       "      <td>397</td>\n",
       "      <td>1560</td>\n",
       "      <td>3747</td>\n",
       "      <td>2009-05-20 03:37:46</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>915344447122153472</td>\n",
       "      <td>RobSherouse</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>96</td>\n",
       "      <td>17</td>\n",
       "      <td>2017-10-03 22:34:57</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>77657562</td>\n",
       "      <td>albarocuevas</td>\n",
       "      <td>Ciudadano Universal.</td>\n",
       "      <td>False</td>\n",
       "      <td>743</td>\n",
       "      <td>636</td>\n",
       "      <td>48487</td>\n",
       "      <td>2009-09-27 04:15:00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>599549147</td>\n",
       "      <td>SBCFortMyers</td>\n",
       "      <td>Fort Myers, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>4661</td>\n",
       "      <td>2012-06-04 20:45:36</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>518684416</td>\n",
       "      <td>jtalbritton</td>\n",
       "      <td>West Bradenton, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>266</td>\n",
       "      <td>287</td>\n",
       "      <td>1167</td>\n",
       "      <td>2012-03-08 17:12:30</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>15939104</td>\n",
       "      <td>willchenus</td>\n",
       "      <td>Tampa, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>906</td>\n",
       "      <td>1065</td>\n",
       "      <td>3418</td>\n",
       "      <td>2008-08-22 00:37:16</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>78102678</td>\n",
       "      <td>MikeKoop</td>\n",
       "      <td>Clearwater,FL</td>\n",
       "      <td>False</td>\n",
       "      <td>446</td>\n",
       "      <td>1327</td>\n",
       "      <td>1742</td>\n",
       "      <td>2009-09-28 19:42:29</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>71052378</td>\n",
       "      <td>PinellasCo911</td>\n",
       "      <td>Pinellas County, Florida</td>\n",
       "      <td>False</td>\n",
       "      <td>5589</td>\n",
       "      <td>0</td>\n",
       "      <td>145681</td>\n",
       "      <td>2009-09-02 19:30:43</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>763062400820051968</td>\n",
       "      <td>PoolPyro</td>\n",
       "      <td>Florida, USA</td>\n",
       "      <td>False</td>\n",
       "      <td>343</td>\n",
       "      <td>229</td>\n",
       "      <td>8599</td>\n",
       "      <td>2016-08-09 17:20:28</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>65845929</td>\n",
       "      <td>DJGHOST954</td>\n",
       "      <td>World Wide</td>\n",
       "      <td>False</td>\n",
       "      <td>2631</td>\n",
       "      <td>2209</td>\n",
       "      <td>25909</td>\n",
       "      <td>2009-08-15 06:39:21</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>19511251</td>\n",
       "      <td>BOHICAR6</td>\n",
       "      <td>sundial, downtown st pete</td>\n",
       "      <td>False</td>\n",
       "      <td>19</td>\n",
       "      <td>39</td>\n",
       "      <td>2910</td>\n",
       "      <td>2009-01-25 23:44:45</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>165857230</td>\n",
       "      <td>Stovall_Special</td>\n",
       "      <td>Tampa, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>997</td>\n",
       "      <td>1396</td>\n",
       "      <td>55076</td>\n",
       "      <td>2010-07-12 18:32:43</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1703452406</td>\n",
       "      <td>dgallo_10</td>\n",
       "      <td>cfa</td>\n",
       "      <td>False</td>\n",
       "      <td>681</td>\n",
       "      <td>660</td>\n",
       "      <td>16086</td>\n",
       "      <td>2013-08-27 01:47:12</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>709195136866111488</td>\n",
       "      <td>daaniellevin</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>589</td>\n",
       "      <td>137</td>\n",
       "      <td>2085</td>\n",
       "      <td>2016-03-14 01:51:11</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2194752920</td>\n",
       "      <td>EnjoyDivaPops</td>\n",
       "      <td>Tallahassee, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>280</td>\n",
       "      <td>270</td>\n",
       "      <td>693</td>\n",
       "      <td>2013-11-14 19:35:25</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1317266774</td>\n",
       "      <td>Dopepanda97</td>\n",
       "      <td>Florida, USA</td>\n",
       "      <td>False</td>\n",
       "      <td>580</td>\n",
       "      <td>185</td>\n",
       "      <td>17552</td>\n",
       "      <td>2013-03-30 22:08:29</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>2954433508</td>\n",
       "      <td>PanCubano11</td>\n",
       "      <td>Miami, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>24</td>\n",
       "      <td>24</td>\n",
       "      <td>106</td>\n",
       "      <td>2015-01-01 07:15:57</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>235198054</td>\n",
       "      <td>MoyerM5</td>\n",
       "      <td>Earth</td>\n",
       "      <td>False</td>\n",
       "      <td>725</td>\n",
       "      <td>924</td>\n",
       "      <td>68463</td>\n",
       "      <td>2011-01-07 16:07:45</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3935</th>\n",
       "      <td>68394581</td>\n",
       "      <td>Forzaken73</td>\n",
       "      <td>Puerto Rico, USA</td>\n",
       "      <td>False</td>\n",
       "      <td>389</td>\n",
       "      <td>1463</td>\n",
       "      <td>15601</td>\n",
       "      <td>2009-08-24 12:23:34</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3936</th>\n",
       "      <td>24449033</td>\n",
       "      <td>Fashion_Yogini</td>\n",
       "      <td>Tampa Bay, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>479</td>\n",
       "      <td>232</td>\n",
       "      <td>1800</td>\n",
       "      <td>2009-03-14 23:24:15</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3939</th>\n",
       "      <td>2669338852</td>\n",
       "      <td>mrwilliams430</td>\n",
       "      <td>St Petersburg, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>476</td>\n",
       "      <td>706</td>\n",
       "      <td>1089</td>\n",
       "      <td>2014-07-03 21:26:11</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3941</th>\n",
       "      <td>19829398</td>\n",
       "      <td>eflow1906</td>\n",
       "      <td>sunny miami florida</td>\n",
       "      <td>False</td>\n",
       "      <td>1151</td>\n",
       "      <td>541</td>\n",
       "      <td>2131</td>\n",
       "      <td>2009-01-31 20:15:00</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3944</th>\n",
       "      <td>281324688</td>\n",
       "      <td>bshowdaz52</td>\n",
       "      <td>Evansville, IN</td>\n",
       "      <td>False</td>\n",
       "      <td>273</td>\n",
       "      <td>424</td>\n",
       "      <td>368</td>\n",
       "      <td>2011-04-13 02:28:32</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3947</th>\n",
       "      <td>81987203</td>\n",
       "      <td>Cfrost3</td>\n",
       "      <td>Orlando, Fl</td>\n",
       "      <td>False</td>\n",
       "      <td>33</td>\n",
       "      <td>274</td>\n",
       "      <td>1638</td>\n",
       "      <td>2009-10-13 02:09:26</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3950</th>\n",
       "      <td>1222796156</td>\n",
       "      <td>LSUCheer</td>\n",
       "      <td>Baton Rouge, La.</td>\n",
       "      <td>False</td>\n",
       "      <td>4881</td>\n",
       "      <td>132</td>\n",
       "      <td>1201</td>\n",
       "      <td>2013-02-26 19:31:55</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3951</th>\n",
       "      <td>281360505</td>\n",
       "      <td>FrontProofMedia</td>\n",
       "      <td>St Petersburg, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>4580</td>\n",
       "      <td>1112</td>\n",
       "      <td>14331</td>\n",
       "      <td>2011-04-13 04:17:50</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3952</th>\n",
       "      <td>2225458604</td>\n",
       "      <td>mellmaree</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>535</td>\n",
       "      <td>321</td>\n",
       "      <td>1896</td>\n",
       "      <td>2013-12-01 19:17:41</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3954</th>\n",
       "      <td>154912082</td>\n",
       "      <td>JamesNassar</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>170</td>\n",
       "      <td>126</td>\n",
       "      <td>2861</td>\n",
       "      <td>2010-06-12 15:22:55</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3956</th>\n",
       "      <td>564133410</td>\n",
       "      <td>JRFromTheSouth</td>\n",
       "      <td>Macon, GA</td>\n",
       "      <td>False</td>\n",
       "      <td>466</td>\n",
       "      <td>446</td>\n",
       "      <td>5225</td>\n",
       "      <td>2012-04-26 21:24:07</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3957</th>\n",
       "      <td>43004374</td>\n",
       "      <td>k_elso_</td>\n",
       "      <td>Orlando, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>60</td>\n",
       "      <td>56</td>\n",
       "      <td>11302</td>\n",
       "      <td>2009-05-28 00:23:32</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3958</th>\n",
       "      <td>37681267</td>\n",
       "      <td>pabel_martin</td>\n",
       "      <td>Washington, DC</td>\n",
       "      <td>False</td>\n",
       "      <td>295</td>\n",
       "      <td>351</td>\n",
       "      <td>3039</td>\n",
       "      <td>2009-05-04 15:22:04</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3964</th>\n",
       "      <td>182042595</td>\n",
       "      <td>preachabrown</td>\n",
       "      <td>Polk/Lakeland, Fl</td>\n",
       "      <td>False</td>\n",
       "      <td>414</td>\n",
       "      <td>339</td>\n",
       "      <td>3350</td>\n",
       "      <td>2010-08-23 17:57:51</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3965</th>\n",
       "      <td>2586787231</td>\n",
       "      <td>toricarnahan</td>\n",
       "      <td>Bastrop, TX</td>\n",
       "      <td>False</td>\n",
       "      <td>757</td>\n",
       "      <td>221</td>\n",
       "      <td>31867</td>\n",
       "      <td>2014-06-25 03:20:46</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3969</th>\n",
       "      <td>417593537</td>\n",
       "      <td>kosor_mia</td>\n",
       "      <td>Miami</td>\n",
       "      <td>False</td>\n",
       "      <td>1194</td>\n",
       "      <td>848</td>\n",
       "      <td>3749</td>\n",
       "      <td>2011-11-21 04:20:53</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3970</th>\n",
       "      <td>1924990184</td>\n",
       "      <td>elenaginamariex</td>\n",
       "      <td>Florida, USA</td>\n",
       "      <td>False</td>\n",
       "      <td>229</td>\n",
       "      <td>625</td>\n",
       "      <td>6111</td>\n",
       "      <td>2013-10-01 23:38:37</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3971</th>\n",
       "      <td>325032297</td>\n",
       "      <td>TKFSU</td>\n",
       "      <td>Boca Raton, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>629</td>\n",
       "      <td>1293</td>\n",
       "      <td>15236</td>\n",
       "      <td>2011-06-27 16:39:57</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3975</th>\n",
       "      <td>1493092015</td>\n",
       "      <td>Britchy2003Meg</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>177</td>\n",
       "      <td>115</td>\n",
       "      <td>1196</td>\n",
       "      <td>2013-06-08 14:34:05</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3979</th>\n",
       "      <td>311168240</td>\n",
       "      <td>KennyP_757</td>\n",
       "      <td>Portsmouth, Va</td>\n",
       "      <td>False</td>\n",
       "      <td>487</td>\n",
       "      <td>514</td>\n",
       "      <td>102273</td>\n",
       "      <td>2011-06-05 00:48:07</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3980</th>\n",
       "      <td>163352168</td>\n",
       "      <td>not_2DAYY</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>960</td>\n",
       "      <td>397</td>\n",
       "      <td>11092</td>\n",
       "      <td>2010-07-06 05:30:18</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3982</th>\n",
       "      <td>2758857807</td>\n",
       "      <td>asvp_leak_</td>\n",
       "      <td>None</td>\n",
       "      <td>False</td>\n",
       "      <td>307</td>\n",
       "      <td>570</td>\n",
       "      <td>6192</td>\n",
       "      <td>2014-09-02 02:07:49</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3987</th>\n",
       "      <td>55712090</td>\n",
       "      <td>BigMoneyRog</td>\n",
       "      <td>Miami, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>151</td>\n",
       "      <td>439</td>\n",
       "      <td>7017</td>\n",
       "      <td>2009-07-11 00:40:37</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3989</th>\n",
       "      <td>116056938</td>\n",
       "      <td>lindaleubanks</td>\n",
       "      <td>Tampa, FL   Worldwde</td>\n",
       "      <td>False</td>\n",
       "      <td>809</td>\n",
       "      <td>648</td>\n",
       "      <td>5868</td>\n",
       "      <td>2010-02-21 00:47:24</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3990</th>\n",
       "      <td>2156572433</td>\n",
       "      <td>southbchripped</td>\n",
       "      <td>South Florida</td>\n",
       "      <td>False</td>\n",
       "      <td>137</td>\n",
       "      <td>531</td>\n",
       "      <td>5502</td>\n",
       "      <td>2013-10-28 02:10:12</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3993</th>\n",
       "      <td>454469390</td>\n",
       "      <td>ElizabethScinta</td>\n",
       "      <td>KCD  18</td>\n",
       "      <td>False</td>\n",
       "      <td>431</td>\n",
       "      <td>482</td>\n",
       "      <td>2606</td>\n",
       "      <td>2012-01-04 01:21:12</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3994</th>\n",
       "      <td>3041584536</td>\n",
       "      <td>nene_smarr</td>\n",
       "      <td>FAMU</td>\n",
       "      <td>False</td>\n",
       "      <td>2334</td>\n",
       "      <td>1843</td>\n",
       "      <td>13635</td>\n",
       "      <td>2015-02-25 17:15:30</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3995</th>\n",
       "      <td>817595230186864644</td>\n",
       "      <td>dwilliams2992</td>\n",
       "      <td>Atlanta, GA</td>\n",
       "      <td>False</td>\n",
       "      <td>89</td>\n",
       "      <td>177</td>\n",
       "      <td>594</td>\n",
       "      <td>2017-01-07 04:54:27</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3996</th>\n",
       "      <td>33220637</td>\n",
       "      <td>TheRealMrSteel</td>\n",
       "      <td>Wesley Chapel, FL</td>\n",
       "      <td>False</td>\n",
       "      <td>88</td>\n",
       "      <td>190</td>\n",
       "      <td>217</td>\n",
       "      <td>2009-04-19 15:10:46</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4000</th>\n",
       "      <td>1332445068</td>\n",
       "      <td>kshaferus</td>\n",
       "      <td>Homosassa FL</td>\n",
       "      <td>False</td>\n",
       "      <td>247</td>\n",
       "      <td>367</td>\n",
       "      <td>695</td>\n",
       "      <td>2013-04-06 20:45:35</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2092 rows × 9 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 user.id user.screen_name              user.location  \\\n",
       "0     771830969934438401       SPNGIRL420        New Port Richey, FL   \n",
       "1     757948847184240646   techno_nomadic               Bushnell, FL   \n",
       "2               24633648        TeamChais             Tampa, Florida   \n",
       "3     815777993733898240    thescarybeary                      Earth   \n",
       "4               71023584        WFLAPaulM              Tampa Bay, FL   \n",
       "5             2284127615       cabaristas         Port Charlotte, FL   \n",
       "6             2876810176    JoannGuimares                  Tampa, FL   \n",
       "7             4833325693   alexis_renee18      California    Florida   \n",
       "8     773983063936294913     geribaby1947         North Sarasota, FL   \n",
       "10             123717228         _OcalaFL                  Ocala, FL   \n",
       "11            3353600338  TinaSuePatters2           Sarasota Florida   \n",
       "12              43561421    JenniCoolWhip                       None   \n",
       "13              41288447      jaybjackson           Murfreesboro, TN   \n",
       "14    915344447122153472      RobSherouse                       None   \n",
       "15              77657562     albarocuevas       Ciudadano Universal.   \n",
       "16             599549147     SBCFortMyers             Fort Myers, FL   \n",
       "17             518684416      jtalbritton         West Bradenton, FL   \n",
       "18              15939104       willchenus                  Tampa, FL   \n",
       "19              78102678         MikeKoop              Clearwater,FL   \n",
       "20              71052378    PinellasCo911   Pinellas County, Florida   \n",
       "21    763062400820051968         PoolPyro               Florida, USA   \n",
       "22              65845929       DJGHOST954                 World Wide   \n",
       "23              19511251         BOHICAR6  sundial, downtown st pete   \n",
       "24             165857230  Stovall_Special                  Tampa, FL   \n",
       "25            1703452406        dgallo_10                        cfa   \n",
       "26    709195136866111488     daaniellevin                       None   \n",
       "27            2194752920    EnjoyDivaPops            Tallahassee, FL   \n",
       "28            1317266774      Dopepanda97               Florida, USA   \n",
       "29            2954433508      PanCubano11                  Miami, FL   \n",
       "30             235198054          MoyerM5                      Earth   \n",
       "...                  ...              ...                        ...   \n",
       "3935            68394581       Forzaken73           Puerto Rico, USA   \n",
       "3936            24449033   Fashion_Yogini              Tampa Bay, FL   \n",
       "3939          2669338852    mrwilliams430          St Petersburg, FL   \n",
       "3941            19829398        eflow1906        sunny miami florida   \n",
       "3944           281324688       bshowdaz52             Evansville, IN   \n",
       "3947            81987203          Cfrost3                Orlando, Fl   \n",
       "3950          1222796156         LSUCheer           Baton Rouge, La.   \n",
       "3951           281360505  FrontProofMedia          St Petersburg, FL   \n",
       "3952          2225458604        mellmaree                       None   \n",
       "3954           154912082      JamesNassar                       None   \n",
       "3956           564133410   JRFromTheSouth                  Macon, GA   \n",
       "3957            43004374          k_elso_                Orlando, FL   \n",
       "3958            37681267     pabel_martin             Washington, DC   \n",
       "3964           182042595     preachabrown          Polk/Lakeland, Fl   \n",
       "3965          2586787231     toricarnahan                Bastrop, TX   \n",
       "3969           417593537        kosor_mia                      Miami   \n",
       "3970          1924990184  elenaginamariex               Florida, USA   \n",
       "3971           325032297            TKFSU             Boca Raton, FL   \n",
       "3975          1493092015   Britchy2003Meg                       None   \n",
       "3979           311168240       KennyP_757             Portsmouth, Va   \n",
       "3980           163352168        not_2DAYY                       None   \n",
       "3982          2758857807       asvp_leak_                       None   \n",
       "3987            55712090      BigMoneyRog                  Miami, FL   \n",
       "3989           116056938    lindaleubanks       Tampa, FL   Worldwde   \n",
       "3990          2156572433   southbchripped              South Florida   \n",
       "3993           454469390  ElizabethScinta                    KCD  18   \n",
       "3994          3041584536       nene_smarr                      FAMU    \n",
       "3995  817595230186864644    dwilliams2992                Atlanta, GA   \n",
       "3996            33220637   TheRealMrSteel          Wesley Chapel, FL   \n",
       "4000          1332445068        kshaferus               Homosassa FL   \n",
       "\n",
       "      user.verified  user.followers_count  user.friends_count  \\\n",
       "0             False                    21                  95   \n",
       "1             False                    35                 112   \n",
       "2             False                  3714                3712   \n",
       "3             False                    36                 172   \n",
       "4              True                  2992                 457   \n",
       "5             False                  1441                 150   \n",
       "6             False                    24                  49   \n",
       "7             False                   206                 189   \n",
       "8             False                  1190                1684   \n",
       "10            False                   294                   4   \n",
       "11            False                   741                 895   \n",
       "12            False                   885                 803   \n",
       "13            False                   397                1560   \n",
       "14            False                     2                  96   \n",
       "15            False                   743                 636   \n",
       "16            False                    17                   1   \n",
       "17            False                   266                 287   \n",
       "18            False                   906                1065   \n",
       "19            False                   446                1327   \n",
       "20            False                  5589                   0   \n",
       "21            False                   343                 229   \n",
       "22            False                  2631                2209   \n",
       "23            False                    19                  39   \n",
       "24            False                   997                1396   \n",
       "25            False                   681                 660   \n",
       "26            False                   589                 137   \n",
       "27            False                   280                 270   \n",
       "28            False                   580                 185   \n",
       "29            False                    24                  24   \n",
       "30            False                   725                 924   \n",
       "...             ...                   ...                 ...   \n",
       "3935          False                   389                1463   \n",
       "3936          False                   479                 232   \n",
       "3939          False                   476                 706   \n",
       "3941          False                  1151                 541   \n",
       "3944          False                   273                 424   \n",
       "3947          False                    33                 274   \n",
       "3950          False                  4881                 132   \n",
       "3951          False                  4580                1112   \n",
       "3952          False                   535                 321   \n",
       "3954          False                   170                 126   \n",
       "3956          False                   466                 446   \n",
       "3957          False                    60                  56   \n",
       "3958          False                   295                 351   \n",
       "3964          False                   414                 339   \n",
       "3965          False                   757                 221   \n",
       "3969          False                  1194                 848   \n",
       "3970          False                   229                 625   \n",
       "3971          False                   629                1293   \n",
       "3975          False                   177                 115   \n",
       "3979          False                   487                 514   \n",
       "3980          False                   960                 397   \n",
       "3982          False                   307                 570   \n",
       "3987          False                   151                 439   \n",
       "3989          False                   809                 648   \n",
       "3990          False                   137                 531   \n",
       "3993          False                   431                 482   \n",
       "3994          False                  2334                1843   \n",
       "3995          False                    89                 177   \n",
       "3996          False                    88                 190   \n",
       "4000          False                   247                 367   \n",
       "\n",
       "      user.statuses_count      user.created_at  klout_score  \n",
       "0                     242  2016-09-02 22:03:38          0.0  \n",
       "1                    1061  2016-07-26 14:41:01          0.0  \n",
       "2                   18395  2009-03-16 02:23:05          0.0  \n",
       "3                    1207  2017-01-02 04:33:24          0.0  \n",
       "4                   28814  2009-09-02 17:36:44          0.0  \n",
       "5                    3293  2014-01-15 16:34:34          0.0  \n",
       "6                     561  2014-11-14 18:35:50          0.0  \n",
       "7                    4990  2016-01-30 03:54:30          0.0  \n",
       "8                   13374  2016-09-08 20:35:17          0.0  \n",
       "10                  31591  2010-03-17 01:04:59          0.0  \n",
       "11                  11871  2015-07-01 17:56:15          0.0  \n",
       "12                  12915  2009-05-30 17:33:41          0.0  \n",
       "13                   3747  2009-05-20 03:37:46          0.0  \n",
       "14                     17  2017-10-03 22:34:57          0.0  \n",
       "15                  48487  2009-09-27 04:15:00          0.0  \n",
       "16                   4661  2012-06-04 20:45:36          0.0  \n",
       "17                   1167  2012-03-08 17:12:30          0.0  \n",
       "18                   3418  2008-08-22 00:37:16          0.0  \n",
       "19                   1742  2009-09-28 19:42:29          0.0  \n",
       "20                 145681  2009-09-02 19:30:43          0.0  \n",
       "21                   8599  2016-08-09 17:20:28          0.0  \n",
       "22                  25909  2009-08-15 06:39:21          0.0  \n",
       "23                   2910  2009-01-25 23:44:45          0.0  \n",
       "24                  55076  2010-07-12 18:32:43          0.0  \n",
       "25                  16086  2013-08-27 01:47:12          0.0  \n",
       "26                   2085  2016-03-14 01:51:11          0.0  \n",
       "27                    693  2013-11-14 19:35:25          0.0  \n",
       "28                  17552  2013-03-30 22:08:29          0.0  \n",
       "29                    106  2015-01-01 07:15:57          0.0  \n",
       "30                  68463  2011-01-07 16:07:45          0.0  \n",
       "...                   ...                  ...          ...  \n",
       "3935                15601  2009-08-24 12:23:34          0.0  \n",
       "3936                 1800  2009-03-14 23:24:15          0.0  \n",
       "3939                 1089  2014-07-03 21:26:11          0.0  \n",
       "3941                 2131  2009-01-31 20:15:00          0.0  \n",
       "3944                  368  2011-04-13 02:28:32          0.0  \n",
       "3947                 1638  2009-10-13 02:09:26          0.0  \n",
       "3950                 1201  2013-02-26 19:31:55          0.0  \n",
       "3951                14331  2011-04-13 04:17:50          0.0  \n",
       "3952                 1896  2013-12-01 19:17:41          0.0  \n",
       "3954                 2861  2010-06-12 15:22:55          0.0  \n",
       "3956                 5225  2012-04-26 21:24:07          0.0  \n",
       "3957                11302  2009-05-28 00:23:32          0.0  \n",
       "3958                 3039  2009-05-04 15:22:04          0.0  \n",
       "3964                 3350  2010-08-23 17:57:51          0.0  \n",
       "3965                31867  2014-06-25 03:20:46          0.0  \n",
       "3969                 3749  2011-11-21 04:20:53          0.0  \n",
       "3970                 6111  2013-10-01 23:38:37          0.0  \n",
       "3971                15236  2011-06-27 16:39:57          0.0  \n",
       "3975                 1196  2013-06-08 14:34:05          0.0  \n",
       "3979               102273  2011-06-05 00:48:07          0.0  \n",
       "3980                11092  2010-07-06 05:30:18          0.0  \n",
       "3982                 6192  2014-09-02 02:07:49          0.0  \n",
       "3987                 7017  2009-07-11 00:40:37          0.0  \n",
       "3989                 5868  2010-02-21 00:47:24          0.0  \n",
       "3990                 5502  2013-10-28 02:10:12          0.0  \n",
       "3993                 2606  2012-01-04 01:21:12          0.0  \n",
       "3994                13635  2015-02-25 17:15:30          0.0  \n",
       "3995                  594  2017-01-07 04:54:27          0.0  \n",
       "3996                  217  2009-04-19 15:10:46          0.0  \n",
       "4000                  695  2013-04-06 20:45:35          0.0  \n",
       "\n",
       "[2092 rows x 9 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "users = mydata[['user.id','user.screen_name','user.location','user.verified','user.followers_count','user.friends_count','user.statuses_count','user.created_at']]\n",
    "users = users.drop_duplicates(subset = ['user.id'])\n",
    "users['klout_score'] = [0.0] * len(users)\n",
    "users"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {
    "scrolled": true
   },
   "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>location.name</th>\n",
       "      <th>location.displayName</th>\n",
       "      <th>location.twitter_country_code</th>\n",
       "      <th>location.geo.coordinates</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Bayonet Point</td>\n",
       "      <td>Bayonet Point, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.733975, 28.299909], [-82.733975, 28.350...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Clearwater</td>\n",
       "      <td>Clearwater, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.831674, 27.935178], [-82.831674, 28.050...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Florida</td>\n",
       "      <td>Florida, USA</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-87.634643, 24.396308], [-87.634643, 31.001...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Ridge Wood Heights</td>\n",
       "      <td>Ridge Wood Heights, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.523307, 27.276661], [-82.523307, 27.298...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>The NewsCenter  TBO.com, Tampa Tribune, News C...</td>\n",
       "      <td>The NewsCenter (TBO.com, Tampa Tribune, News C...</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.460589, 27.944825], [-82.460589, 27.944...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Charlotte Harbor</td>\n",
       "      <td>Charlotte Harbor, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.084626, 26.946308], [-82.084626, 26.975...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Temple Terrace</td>\n",
       "      <td>Temple Terrace, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.40189, 28.011287], [-82.40189, 28.07369...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>East Lake-Orient Park</td>\n",
       "      <td>East Lake-Orient Park, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.410125, 27.965019], [-82.410125, 28.031...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Tallevast</td>\n",
       "      <td>Tallevast, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.563644, 27.388731], [-82.563644, 27.429...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Ocala</td>\n",
       "      <td>Ocala, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.293902, 28.962902], [-82.293902, 29.277...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Cortez</td>\n",
       "      <td>Cortez, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.692316, 27.450643], [-82.692316, 27.478...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Cypress Lake</td>\n",
       "      <td>Cypress Lake, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-81.918368, 26.520458], [-81.918368, 26.557...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sarasota</td>\n",
       "      <td>Sarasota, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.588866, 27.293114], [-82.588866, 27.389...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Safety Harbor</td>\n",
       "      <td>Safety Harbor, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.712772, 27.977811], [-82.712772, 28.049...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Lutz</td>\n",
       "      <td>Lutz, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.502573, 28.090958], [-82.502573, 28.172...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>St Petersburg</td>\n",
       "      <td>St Petersburg, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.758209, 27.694323], [-82.758209, 27.897...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Apollo Beach</td>\n",
       "      <td>Apollo Beach, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.437901, 27.735035], [-82.437901, 27.793...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Tallahassee</td>\n",
       "      <td>Tallahassee, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-84.386548, 30.365093], [-84.386548, 30.587...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Seminole</td>\n",
       "      <td>Seminole, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.81611, 27.80979], [-82.81611, 27.884351...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Elfers</td>\n",
       "      <td>Elfers, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.739856, 28.193916], [-82.739856, 28.233...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Bear Creek</td>\n",
       "      <td>Bear Creek, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.732594, 27.74548], [-82.732594, 27.7630...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Holmes Beach</td>\n",
       "      <td>Holmes Beach, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.731197, 27.484796], [-82.731197, 27.527...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Dade City</td>\n",
       "      <td>Dade City, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.239194, 28.324759], [-82.239194, 28.408...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Iona</td>\n",
       "      <td>Iona, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-81.99359, 26.491867], [-81.99359, 26.54318...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Treasure Island</td>\n",
       "      <td>Treasure Island, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.783299, 27.738608], [-82.783299, 27.786...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Lakeland</td>\n",
       "      <td>Lakeland, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.042715, 27.968692], [-82.042715, 28.130...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Holiday</td>\n",
       "      <td>Holiday, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.78516, 28.17275], [-82.78516, 28.204041...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>Gulf Gate Estates</td>\n",
       "      <td>Gulf Gate Estates, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.522638, 27.233261], [-82.522638, 27.276...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>Egypt Lake-Leto</td>\n",
       "      <td>Egypt Lake-Leto, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.527472, 27.996725], [-82.527472, 28.037...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>Victory Field</td>\n",
       "      <td>Victory Field</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-81.91801, 28.027215], [-81.91801, 28.02721...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3221</th>\n",
       "      <td>GrassLands Brewing Company</td>\n",
       "      <td>GrassLands Brewing Company</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-84.290688, 30.435336], [-84.290688, 30.435...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3235</th>\n",
       "      <td>Boca Grande Swing Bridge</td>\n",
       "      <td>Boca Grande Swing Bridge</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.270134, 26.827154], [-82.270134, 26.827...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3268</th>\n",
       "      <td>Sugarmill Woods</td>\n",
       "      <td>Sugarmill Woods, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.55312, 28.694598], [-82.55312, 28.76403...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3328</th>\n",
       "      <td>Ava Restaurant</td>\n",
       "      <td>Ava Restaurant</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.483068, 27.93622], [-82.483068, 27.9362...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3338</th>\n",
       "      <td>All Peoples Life Center</td>\n",
       "      <td>All Peoples Life Center</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.38749, 28.009696], [-82.38749, 28.00969...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3355</th>\n",
       "      <td>East Bay High School</td>\n",
       "      <td>East Bay High School</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.362914, 27.792959], [-82.362914, 27.792...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3367</th>\n",
       "      <td>Vertigo Burger And Fries</td>\n",
       "      <td>Vertigo Burger And Fries</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-84.254155, 30.505944], [-84.254155, 30.505...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3371</th>\n",
       "      <td>Dot Ice - Artisan Rolled Ice Cream</td>\n",
       "      <td>Dot Ice - Artisan Rolled Ice Cream</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.633841, 27.773814], [-82.633841, 27.773...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3373</th>\n",
       "      <td>Florida Hospital Center Ice</td>\n",
       "      <td>Florida Hospital Center Ice</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.380623, 28.195892], [-82.380623, 28.195...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3385</th>\n",
       "      <td>Dulcet Restaurant   Lounge</td>\n",
       "      <td>Dulcet Restaurant &amp; Lounge</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.719541, 28.249258], [-82.719541, 28.249...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3417</th>\n",
       "      <td>The Alley at SouthShore</td>\n",
       "      <td>The Alley at SouthShore</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.341313, 27.79004], [-82.341313, 27.7900...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3439</th>\n",
       "      <td>Planet Fitness - Holiday, FL</td>\n",
       "      <td>Planet Fitness - Holiday, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.738726, 28.198945], [-82.738726, 28.198...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3452</th>\n",
       "      <td>Hornblasters Truck</td>\n",
       "      <td>Hornblasters Truck!</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.556043, 27.938858], [-82.556043, 27.938...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3456</th>\n",
       "      <td>Bare Assets Holiday</td>\n",
       "      <td>Bare Assets Holiday</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.740166, 28.179396], [-82.740166, 28.179...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3532</th>\n",
       "      <td>Seven Springs Middle School</td>\n",
       "      <td>Seven Springs Middle School</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.670371, 28.19511], [-82.670371, 28.1951...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3570</th>\n",
       "      <td>Gulf of Mexico</td>\n",
       "      <td>Gulf of Mexico</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.685794, 27.436235], [-82.685794, 27.436...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3610</th>\n",
       "      <td>Gainsville, FL</td>\n",
       "      <td>Gainsville, FL</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.394654, 29.728046], [-82.394654, 29.728...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3625</th>\n",
       "      <td>Howard Frankland Bridge</td>\n",
       "      <td>Howard Frankland Bridge</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.589453, 27.92698], [-82.589453, 27.9269...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3629</th>\n",
       "      <td>Howl-O-Scream</td>\n",
       "      <td>Howl-O-Scream</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.417268, 28.034482], [-82.417268, 28.034...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3639</th>\n",
       "      <td>St. George Island Bridge</td>\n",
       "      <td>St. George Island Bridge</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-84.888016, 29.717084], [-84.888016, 29.717...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3643</th>\n",
       "      <td>AJA</td>\n",
       "      <td>AJA</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.448795, 27.943984], [-82.448795, 27.943...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3645</th>\n",
       "      <td>Waffle House</td>\n",
       "      <td>Waffle House</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.150149, 28.025746], [-82.150149, 28.025...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3682</th>\n",
       "      <td>David A. Straz, Jr. Center for the Performing ...</td>\n",
       "      <td>David A. Straz, Jr. Center for the Performing ...</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.464001, 27.951762], [-82.464001, 27.951...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3687</th>\n",
       "      <td>Seffner Christian Academy</td>\n",
       "      <td>Seffner Christian Academy</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.303376, 28.000762], [-82.303376, 28.000...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3688</th>\n",
       "      <td>Pepin Hospitality Center</td>\n",
       "      <td>Pepin Hospitality Center</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.399509, 27.982382], [-82.399509, 27.982...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3751</th>\n",
       "      <td>Dunedin Causeway</td>\n",
       "      <td>Dunedin Causeway</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.799664, 28.050943], [-82.799664, 28.050...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3864</th>\n",
       "      <td>Fresh Rags</td>\n",
       "      <td>Fresh Rags</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.701076, 27.841554], [-82.701076, 27.841...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3914</th>\n",
       "      <td>TECO Line Streetcar - Centennial Park Station</td>\n",
       "      <td>TECO Line Streetcar - Centennial Park Station</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.437241, 27.960999], [-82.437241, 27.960...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3944</th>\n",
       "      <td>Venezia</td>\n",
       "      <td>Venezia</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.577816, 27.318869], [-82.577816, 27.318...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3975</th>\n",
       "      <td>Lido Beach</td>\n",
       "      <td>Lido Beach</td>\n",
       "      <td>US</td>\n",
       "      <td>[[[-82.576869, 27.310955], [-82.576869, 27.310...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>350 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                          location.name  \\\n",
       "0                                         Bayonet Point   \n",
       "1                                            Clearwater   \n",
       "2                                               Florida   \n",
       "3                                    Ridge Wood Heights   \n",
       "4     The NewsCenter  TBO.com, Tampa Tribune, News C...   \n",
       "5                                      Charlotte Harbor   \n",
       "6                                        Temple Terrace   \n",
       "7                                 East Lake-Orient Park   \n",
       "8                                             Tallevast   \n",
       "10                                                Ocala   \n",
       "15                                               Cortez   \n",
       "16                                         Cypress Lake   \n",
       "17                                             Sarasota   \n",
       "18                                        Safety Harbor   \n",
       "19                                                 Lutz   \n",
       "20                                        St Petersburg   \n",
       "21                                         Apollo Beach   \n",
       "22                                          Tallahassee   \n",
       "23                                             Seminole   \n",
       "25                                               Elfers   \n",
       "26                                           Bear Creek   \n",
       "30                                         Holmes Beach   \n",
       "31                                            Dade City   \n",
       "32                                                 Iona   \n",
       "33                                      Treasure Island   \n",
       "34                                             Lakeland   \n",
       "36                                              Holiday   \n",
       "40                                    Gulf Gate Estates   \n",
       "41                                      Egypt Lake-Leto   \n",
       "42                                        Victory Field   \n",
       "...                                                 ...   \n",
       "3221                         GrassLands Brewing Company   \n",
       "3235                           Boca Grande Swing Bridge   \n",
       "3268                                    Sugarmill Woods   \n",
       "3328                                     Ava Restaurant   \n",
       "3338                            All Peoples Life Center   \n",
       "3355                               East Bay High School   \n",
       "3367                           Vertigo Burger And Fries   \n",
       "3371                 Dot Ice - Artisan Rolled Ice Cream   \n",
       "3373                        Florida Hospital Center Ice   \n",
       "3385                         Dulcet Restaurant   Lounge   \n",
       "3417                            The Alley at SouthShore   \n",
       "3439                       Planet Fitness - Holiday, FL   \n",
       "3452                                Hornblasters Truck    \n",
       "3456                                Bare Assets Holiday   \n",
       "3532                        Seven Springs Middle School   \n",
       "3570                                     Gulf of Mexico   \n",
       "3610                                     Gainsville, FL   \n",
       "3625                            Howard Frankland Bridge   \n",
       "3629                                      Howl-O-Scream   \n",
       "3639                           St. George Island Bridge   \n",
       "3643                                                AJA   \n",
       "3645                                       Waffle House   \n",
       "3682  David A. Straz, Jr. Center for the Performing ...   \n",
       "3687                          Seffner Christian Academy   \n",
       "3688                           Pepin Hospitality Center   \n",
       "3751                                   Dunedin Causeway   \n",
       "3864                                         Fresh Rags   \n",
       "3914      TECO Line Streetcar - Centennial Park Station   \n",
       "3944                                            Venezia   \n",
       "3975                                         Lido Beach   \n",
       "\n",
       "                                   location.displayName  \\\n",
       "0                                     Bayonet Point, FL   \n",
       "1                                        Clearwater, FL   \n",
       "2                                          Florida, USA   \n",
       "3                                Ridge Wood Heights, FL   \n",
       "4     The NewsCenter (TBO.com, Tampa Tribune, News C...   \n",
       "5                                  Charlotte Harbor, FL   \n",
       "6                                    Temple Terrace, FL   \n",
       "7                             East Lake-Orient Park, FL   \n",
       "8                                         Tallevast, FL   \n",
       "10                                            Ocala, FL   \n",
       "15                                           Cortez, FL   \n",
       "16                                     Cypress Lake, FL   \n",
       "17                                         Sarasota, FL   \n",
       "18                                    Safety Harbor, FL   \n",
       "19                                             Lutz, FL   \n",
       "20                                    St Petersburg, FL   \n",
       "21                                     Apollo Beach, FL   \n",
       "22                                      Tallahassee, FL   \n",
       "23                                         Seminole, FL   \n",
       "25                                           Elfers, FL   \n",
       "26                                       Bear Creek, FL   \n",
       "30                                     Holmes Beach, FL   \n",
       "31                                        Dade City, FL   \n",
       "32                                             Iona, FL   \n",
       "33                                  Treasure Island, FL   \n",
       "34                                         Lakeland, FL   \n",
       "36                                          Holiday, FL   \n",
       "40                                Gulf Gate Estates, FL   \n",
       "41                                  Egypt Lake-Leto, FL   \n",
       "42                                        Victory Field   \n",
       "...                                                 ...   \n",
       "3221                         GrassLands Brewing Company   \n",
       "3235                           Boca Grande Swing Bridge   \n",
       "3268                                Sugarmill Woods, FL   \n",
       "3328                                     Ava Restaurant   \n",
       "3338                            All Peoples Life Center   \n",
       "3355                               East Bay High School   \n",
       "3367                           Vertigo Burger And Fries   \n",
       "3371                 Dot Ice - Artisan Rolled Ice Cream   \n",
       "3373                        Florida Hospital Center Ice   \n",
       "3385                         Dulcet Restaurant & Lounge   \n",
       "3417                            The Alley at SouthShore   \n",
       "3439                       Planet Fitness - Holiday, FL   \n",
       "3452                                Hornblasters Truck!   \n",
       "3456                                Bare Assets Holiday   \n",
       "3532                        Seven Springs Middle School   \n",
       "3570                                     Gulf of Mexico   \n",
       "3610                                     Gainsville, FL   \n",
       "3625                            Howard Frankland Bridge   \n",
       "3629                                      Howl-O-Scream   \n",
       "3639                           St. George Island Bridge   \n",
       "3643                                                AJA   \n",
       "3645                                       Waffle House   \n",
       "3682  David A. Straz, Jr. Center for the Performing ...   \n",
       "3687                          Seffner Christian Academy   \n",
       "3688                           Pepin Hospitality Center   \n",
       "3751                                   Dunedin Causeway   \n",
       "3864                                         Fresh Rags   \n",
       "3914      TECO Line Streetcar - Centennial Park Station   \n",
       "3944                                            Venezia   \n",
       "3975                                         Lido Beach   \n",
       "\n",
       "     location.twitter_country_code  \\\n",
       "0                               US   \n",
       "1                               US   \n",
       "2                               US   \n",
       "3                               US   \n",
       "4                               US   \n",
       "5                               US   \n",
       "6                               US   \n",
       "7                               US   \n",
       "8                               US   \n",
       "10                              US   \n",
       "15                              US   \n",
       "16                              US   \n",
       "17                              US   \n",
       "18                              US   \n",
       "19                              US   \n",
       "20                              US   \n",
       "21                              US   \n",
       "22                              US   \n",
       "23                              US   \n",
       "25                              US   \n",
       "26                              US   \n",
       "30                              US   \n",
       "31                              US   \n",
       "32                              US   \n",
       "33                              US   \n",
       "34                              US   \n",
       "36                              US   \n",
       "40                              US   \n",
       "41                              US   \n",
       "42                              US   \n",
       "...                            ...   \n",
       "3221                            US   \n",
       "3235                            US   \n",
       "3268                            US   \n",
       "3328                            US   \n",
       "3338                            US   \n",
       "3355                            US   \n",
       "3367                            US   \n",
       "3371                            US   \n",
       "3373                            US   \n",
       "3385                            US   \n",
       "3417                            US   \n",
       "3439                            US   \n",
       "3452                            US   \n",
       "3456                            US   \n",
       "3532                            US   \n",
       "3570                            US   \n",
       "3610                            US   \n",
       "3625                            US   \n",
       "3629                            US   \n",
       "3639                            US   \n",
       "3643                            US   \n",
       "3645                            US   \n",
       "3682                            US   \n",
       "3687                            US   \n",
       "3688                            US   \n",
       "3751                            US   \n",
       "3864                            US   \n",
       "3914                            US   \n",
       "3944                            US   \n",
       "3975                            US   \n",
       "\n",
       "                               location.geo.coordinates  \n",
       "0     [[[-82.733975, 28.299909], [-82.733975, 28.350...  \n",
       "1     [[[-82.831674, 27.935178], [-82.831674, 28.050...  \n",
       "2     [[[-87.634643, 24.396308], [-87.634643, 31.001...  \n",
       "3     [[[-82.523307, 27.276661], [-82.523307, 27.298...  \n",
       "4     [[[-82.460589, 27.944825], [-82.460589, 27.944...  \n",
       "5     [[[-82.084626, 26.946308], [-82.084626, 26.975...  \n",
       "6     [[[-82.40189, 28.011287], [-82.40189, 28.07369...  \n",
       "7     [[[-82.410125, 27.965019], [-82.410125, 28.031...  \n",
       "8     [[[-82.563644, 27.388731], [-82.563644, 27.429...  \n",
       "10    [[[-82.293902, 28.962902], [-82.293902, 29.277...  \n",
       "15    [[[-82.692316, 27.450643], [-82.692316, 27.478...  \n",
       "16    [[[-81.918368, 26.520458], [-81.918368, 26.557...  \n",
       "17    [[[-82.588866, 27.293114], [-82.588866, 27.389...  \n",
       "18    [[[-82.712772, 27.977811], [-82.712772, 28.049...  \n",
       "19    [[[-82.502573, 28.090958], [-82.502573, 28.172...  \n",
       "20    [[[-82.758209, 27.694323], [-82.758209, 27.897...  \n",
       "21    [[[-82.437901, 27.735035], [-82.437901, 27.793...  \n",
       "22    [[[-84.386548, 30.365093], [-84.386548, 30.587...  \n",
       "23    [[[-82.81611, 27.80979], [-82.81611, 27.884351...  \n",
       "25    [[[-82.739856, 28.193916], [-82.739856, 28.233...  \n",
       "26    [[[-82.732594, 27.74548], [-82.732594, 27.7630...  \n",
       "30    [[[-82.731197, 27.484796], [-82.731197, 27.527...  \n",
       "31    [[[-82.239194, 28.324759], [-82.239194, 28.408...  \n",
       "32    [[[-81.99359, 26.491867], [-81.99359, 26.54318...  \n",
       "33    [[[-82.783299, 27.738608], [-82.783299, 27.786...  \n",
       "34    [[[-82.042715, 27.968692], [-82.042715, 28.130...  \n",
       "36    [[[-82.78516, 28.17275], [-82.78516, 28.204041...  \n",
       "40    [[[-82.522638, 27.233261], [-82.522638, 27.276...  \n",
       "41    [[[-82.527472, 27.996725], [-82.527472, 28.037...  \n",
       "42    [[[-81.91801, 28.027215], [-81.91801, 28.02721...  \n",
       "...                                                 ...  \n",
       "3221  [[[-84.290688, 30.435336], [-84.290688, 30.435...  \n",
       "3235  [[[-82.270134, 26.827154], [-82.270134, 26.827...  \n",
       "3268  [[[-82.55312, 28.694598], [-82.55312, 28.76403...  \n",
       "3328  [[[-82.483068, 27.93622], [-82.483068, 27.9362...  \n",
       "3338  [[[-82.38749, 28.009696], [-82.38749, 28.00969...  \n",
       "3355  [[[-82.362914, 27.792959], [-82.362914, 27.792...  \n",
       "3367  [[[-84.254155, 30.505944], [-84.254155, 30.505...  \n",
       "3371  [[[-82.633841, 27.773814], [-82.633841, 27.773...  \n",
       "3373  [[[-82.380623, 28.195892], [-82.380623, 28.195...  \n",
       "3385  [[[-82.719541, 28.249258], [-82.719541, 28.249...  \n",
       "3417  [[[-82.341313, 27.79004], [-82.341313, 27.7900...  \n",
       "3439  [[[-82.738726, 28.198945], [-82.738726, 28.198...  \n",
       "3452  [[[-82.556043, 27.938858], [-82.556043, 27.938...  \n",
       "3456  [[[-82.740166, 28.179396], [-82.740166, 28.179...  \n",
       "3532  [[[-82.670371, 28.19511], [-82.670371, 28.1951...  \n",
       "3570  [[[-82.685794, 27.436235], [-82.685794, 27.436...  \n",
       "3610  [[[-82.394654, 29.728046], [-82.394654, 29.728...  \n",
       "3625  [[[-82.589453, 27.92698], [-82.589453, 27.9269...  \n",
       "3629  [[[-82.417268, 28.034482], [-82.417268, 28.034...  \n",
       "3639  [[[-84.888016, 29.717084], [-84.888016, 29.717...  \n",
       "3643  [[[-82.448795, 27.943984], [-82.448795, 27.943...  \n",
       "3645  [[[-82.150149, 28.025746], [-82.150149, 28.025...  \n",
       "3682  [[[-82.464001, 27.951762], [-82.464001, 27.951...  \n",
       "3687  [[[-82.303376, 28.000762], [-82.303376, 28.000...  \n",
       "3688  [[[-82.399509, 27.982382], [-82.399509, 27.982...  \n",
       "3751  [[[-82.799664, 28.050943], [-82.799664, 28.050...  \n",
       "3864  [[[-82.701076, 27.841554], [-82.701076, 27.841...  \n",
       "3914  [[[-82.437241, 27.960999], [-82.437241, 27.960...  \n",
       "3944  [[[-82.577816, 27.318869], [-82.577816, 27.318...  \n",
       "3975  [[[-82.576869, 27.310955], [-82.576869, 27.310...  \n",
       "\n",
       "[350 rows x 4 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "places = mydata[['location.name','location.displayName','location.twitter_country_code','location.geo.coordinates']]\n",
    "places = places.drop_duplicates(subset = ['location.name'])\n",
    "# places['location.displayName'] = places['location.displayName'].apply(normalizeTweetText)\n",
    "places.reset_index(drop = True)\n",
    "places"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.14"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}