Sentiment_Translink.ipynb

{
 "metadata": {
  "name": "",
  "signature": "sha256:5477bf1e3767b5260aac37cfc1e5028360a8f74675dd480659be32bd506dc9f3"
 },
 "nbformat": 3,
 "nbformat_minor": 0,
 "worksheets": [
  {
   "cells": [
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import numpy as np\n",
      "import urllib\n",
      "import json"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 1
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "data = open('tweets.json').readlines()"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 2
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "counter = 0\n",
      "tweets = []\n",
      "for tweet in data:\n",
      "    try:\n",
      "        tweets.append(json.loads(tweet)['body'])\n",
      "    except:\n",
      "        counter += 1"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 8
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "counter"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 9,
       "text": [
        "10"
       ]
      }
     ],
     "prompt_number": 9
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# total tweets including retweet\n",
      "len(tweets)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 12,
       "text": [
        "1132"
       ]
      }
     ],
     "prompt_number": 12
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# unique tweets\n",
      "len(set(tweets))"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 11,
       "text": [
        "796"
       ]
      }
     ],
     "prompt_number": 11
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import pandas as pd"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 13
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df = pd.DataFrame()\n",
      "\n",
      "\n",
      "for item in data:\n",
      "    temp = item.strip('\\n')\n",
      "    try:\n",
      "        s = pd.DataFrame(json.loads(temp), index=[0])\n",
      "        s.name = len(df)\n",
      "        df = df.append(s)\n",
      "    except:\n",
      "        pass"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 21
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "df"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "html": [
        "<div style=\"max-height:1000px;max-width:1500px;overflow:auto;\">\n",
        "<table border=\"1\" class=\"dataframe\">\n",
        "  <thead>\n",
        "    <tr style=\"text-align: right;\">\n",
        "      <th></th>\n",
        "      <th>actor</th>\n",
        "      <th>body</th>\n",
        "      <th>favoritesCount</th>\n",
        "      <th>generator</th>\n",
        "      <th>geo</th>\n",
        "      <th>gnip</th>\n",
        "      <th>id</th>\n",
        "      <th>inReplyTo</th>\n",
        "      <th>link</th>\n",
        "      <th>location</th>\n",
        "      <th>object</th>\n",
        "      <th>objectType</th>\n",
        "      <th>postedTime</th>\n",
        "      <th>provider</th>\n",
        "      <th>retweetCount</th>\n",
        "      <th>twitter_entities</th>\n",
        "      <th>twitter_filter_level</th>\n",
        "      <th>twitter_lang</th>\n",
        "      <th>verb</th>\n",
        "    </tr>\n",
        "  </thead>\n",
        "  <tbody>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @KayelleDubya: I actually like to reach my ...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373440029310976</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/CloverdaleGal/statuses/4913...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:05:32.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @CDNtransport: #Translink News: SkyTrain se...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373449483268096</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/PSPilates/statuses/49137344...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:05:34.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> oy, translink. I guess this is going to be a r...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373452033404929</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/a_jonca/statuses/4913734520...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:05:34.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> For all the $ #translink takes in and it's nev...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373454344478720</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/1packerray/statuses/4913734...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:05:35.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @canadagraphs: HAHA, #Translink has 2nd maj...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373504739430401</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/CloverdaleGal/statuses/4913...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:05:47.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  2</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> Twice in a week-  a full shutdown. Complete jo...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373522447384577</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/talbott23/statuses/49137352...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:05:51.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @Karsonprince: @TransLink we pay 175+ in fi...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373535189680128</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/jakecaparas/statuses/491373...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:05:54.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @DylanChernick: Haha, great call. \"@Youngdr...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373543821570048</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/paolazuccaro/statuses/49137...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:05:56.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @jordanbateman: Maybe if TransLink didn't h...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373571067768832</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/PippoRotini/statuses/491373...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:03.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 31</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @SidiElazhari: Time for privatization?? WAK...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373590101491713</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/yaTanereS/statuses/49137359...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:07.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @LauraCoughlan: I love @TransLink #shitnobo...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373602021707776</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/kelseymakihara/statuses/491...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:10.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @kevinharding province knows TransLink has ade...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373603104256001</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/jordanbateman/statuses/4913...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:10.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @stephsia @TransLink best get in line for the ...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373632367505408</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/WaderMacD/statuses/49137363...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:17.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @610Mike: Thank Goodness Translink invested...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373635039277057</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/jakecaparas/statuses/491373...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:18.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @njellan: Lazy pundits will blame #Skytrain...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373664403599360</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/pqpolitics/statuses/4913736...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:25.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @canadagraphs @TransLink LOL, good one... is i...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373692635463681</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/CloverdaleGal/statuses/4913...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:32.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> SKYTRAIN UPDATE. Translink says Expo Line appe...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373702575951872</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/LiveatViceroy/statuses/4913...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:34.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @colourandcinema: @ianinadonne the next pol...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373699568631808</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/jakecaparas/statuses/491373...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:33.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td>      Translink: Making fat people walk since 2000</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373721614299136</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/BadTranslink/statuses/49137...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:39.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @TransLink @vixerminator That 'reply' took ove...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373723581038592</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/always_vote/statuses/491373...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:39.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @KayelleDubya: I actually like to reach my ...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373748478427136</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/jakecaparas/statuses/491373...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:45.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  2</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> Busses, busses everywhere, but not a spot to s...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373760578994177</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/itsmeichi/statuses/49137376...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:48.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @CloverdaleGal: @canadagraphs @TransLink LO...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373804543684608</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/jakecaparas/statuses/491373...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:06:58.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> Fantastic\"@Youngdriversbc: Are you stuck on a ...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373818699468800</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/paolazuccaro/statuses/49137...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:07:02.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> Translink: Making fat people walk since 2000 #...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373825058435072</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/BadTranslink/statuses/49137...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:07:03.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @TransLink omg! This will influence my voting ...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373852778184704</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/AskATruckDriver/statuses/49...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:07:10.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @wayfarying: \"@Youngdriversbc: Are you stuc...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373867076558848</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/CloverdaleGal/statuses/4913...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:07:13.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @CoffeeGeek: Vancouver PSA: The Expo Line S...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373876950355968</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/daka_x/statuses/49137387695...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:07:16.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @talbott23: Twice in a week-  a full shutdo...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373882817773568</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/jakecaparas/statuses/491373...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:07:17.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @TransLink hello, it is about one hour from th...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491373890384326658</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/aniairek/statuses/491373890...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T00:07:19.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</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",
        "      <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",
        "      <td>...</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @kathryn_stew @CKNW @350Stroker @TransLink I j...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491440544489291776</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/qdsworld/statuses/491440544...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:32:10.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @StephenHui: Anyone else wish they'd been o...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491440893006589952</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/DaRkDaN89/statuses/49144089...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:33:34.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 13</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @TGCTS  Vancouver has a sky train called trans...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491440973176512513</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/dispatcher880/statuses/4914...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:33:53.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @TransLink are trains running from dt to Burna...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491440987361669120</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/darinxyz/statuses/491440987...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:33:56.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> Everyone angry at Translink for the SkyTrain o...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491441506838798337</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/hi_its_kyle/statuses/491441...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:36:00.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> Doug Kelsey, COO of @TransLink, should be fire...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491441513281224704</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/Tax_MD/statuses/49144151328...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:36:01.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @grizlyatoms420: @TransLink *phew* good thi...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491441692294148096</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/fabsace/statuses/4914416922...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:36:44.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> SkyTrain breakdowns may erode public confidenc...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491441856673107968</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/iVancouverNews/statuses/491...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:37:23.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @CryingWolfe: #TransLink ad, #Vancouver 201...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491441978584748034</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/LeDesertFlower/statuses/491...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:37:52.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @EduCoello: The next station is Columbia #s...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442218020769792</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/pch4101/statuses/4914422180...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:38:50.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 49</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @Youngdriversbc: Are you stuck on a #skytra...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442263256363008</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/LeDesertFlower/statuses/491...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:39:00.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 69</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> It should be mandatory that all @TransLink exe...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442304062738432</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/Tax_MD/statuses/49144230406...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:39:10.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @CTVVancouver: UPDATED: #SkyTrain halted on...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442328767172608</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/pch4101/statuses/4914423287...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:39:16.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 21</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> If it's one thing this @TransLink #SkyTrain fa...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442466973708288</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/mtthwbyd/statuses/491442466...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:39:49.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @stevecbc: He's now giving directions to Su...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442611412955136</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/grandmasterc/statuses/49144...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:40:23.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  9</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> Everyone angry at Translink over the SkyTrain ...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442734171828224</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/hi_its_kyle/statuses/491442...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:40:53.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @TransLink has a new motto: \"why ride when you...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442757118857216</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/nad_imz/statuses/4914427571...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:40:58.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @IsSkytrainBroke: Nope. Still working. \\n\\n...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491442902363414528</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/eastvanhalen/statuses/49144...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:41:33.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  2</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @IsSkytrainBroke: Nope. Still working. \\n\\n...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491443012363243520</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/moebius_strip/statuses/4914...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:41:59.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  3</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @IsSkytrainBroke: Nope. Still working. \\n\\n...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491443025986338817</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/Stroppy_Girl/statuses/49144...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:42:02.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  4</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> @TransLink will you be reimbursing customers f...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491443304383275008</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/BahirAhmad94/statuses/49144...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:43:09.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td>         @TransLink So, is your CEO stepping down?</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491443715974508544</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/WhyNotL8er/statuses/4914437...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:44:47.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @wetcoastlife: I like @TransLink \"you're no...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491443907150880768</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/qdsworld/statuses/491443907...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:45:32.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  4</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @Youngdriversbc: Are you stuck on a #skytra...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491444053213315073</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/Studestinations/statuses/49...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:46:07.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 70</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @jordanbateman: Maybe if TransLink didn't h...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491444076835635200</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/MBazowski/statuses/49144407...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:46:13.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 49</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @PennyDaflos: UPDATE: @translink says failu...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491444449596039168</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/ianabailey/statuses/4914444...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:47:42.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  6</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @jordanbateman: Maybe if TransLink didn't h...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491444471058276354</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/abbyroadkill/statuses/49144...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:47:47.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td> 50</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @PennyDaflos: UPDATE: @translink says failu...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491444744023592961</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/moebius_strip/statuses/4914...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:48:52.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  7</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> So these Metro #Vancouver morons think @transl...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491444825355739136</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/stevenhuang/statuses/491444...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:49:11.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  0</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td>  post</td>\n",
        "    </tr>\n",
        "    <tr>\n",
        "      <th>0</th>\n",
        "      <td>NaN</td>\n",
        "      <td> RT @dacooster: @bizinvancouver @TransLink @Sto...</td>\n",
        "      <td> 0</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> tag:search.twitter.com,2005:491444848163962880</td>\n",
        "      <td>NaN</td>\n",
        "      <td> http://twitter.com/MarkShaw24/statuses/4914448...</td>\n",
        "      <td>NaN</td>\n",
        "      <td>NaN</td>\n",
        "      <td> activity</td>\n",
        "      <td> 2014-07-22T04:49:17.000Z</td>\n",
        "      <td>NaN</td>\n",
        "      <td>  1</td>\n",
        "      <td>NaN</td>\n",
        "      <td> medium</td>\n",
        "      <td> en</td>\n",
        "      <td> share</td>\n",
        "    </tr>\n",
        "  </tbody>\n",
        "</table>\n",
        "<p>1132 rows \u00d7 19 columns</p>\n",
        "</div>"
       ],
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 22,
       "text": [
        "    actor                                               body  favoritesCount  \\\n",
        "0     NaN  RT @KayelleDubya: I actually like to reach my ...               0   \n",
        "0     NaN  RT @CDNtransport: #Translink News: SkyTrain se...               0   \n",
        "0     NaN  oy, translink. I guess this is going to be a r...               0   \n",
        "0     NaN  For all the $ #translink takes in and it's nev...               0   \n",
        "0     NaN  RT @canadagraphs: HAHA, #Translink has 2nd maj...               0   \n",
        "0     NaN  Twice in a week-  a full shutdown. Complete jo...               0   \n",
        "0     NaN  RT @Karsonprince: @TransLink we pay 175+ in fi...               0   \n",
        "0     NaN  RT @DylanChernick: Haha, great call. \"@Youngdr...               0   \n",
        "0     NaN  RT @jordanbateman: Maybe if TransLink didn't h...               0   \n",
        "0     NaN  RT @SidiElazhari: Time for privatization?? WAK...               0   \n",
        "0     NaN  RT @LauraCoughlan: I love @TransLink #shitnobo...               0   \n",
        "0     NaN  @kevinharding province knows TransLink has ade...               0   \n",
        "0     NaN  @stephsia @TransLink best get in line for the ...               0   \n",
        "0     NaN  RT @610Mike: Thank Goodness Translink invested...               0   \n",
        "0     NaN  RT @njellan: Lazy pundits will blame #Skytrain...               0   \n",
        "0     NaN  @canadagraphs @TransLink LOL, good one... is i...               0   \n",
        "0     NaN  SKYTRAIN UPDATE. Translink says Expo Line appe...               0   \n",
        "0     NaN  RT @colourandcinema: @ianinadonne the next pol...               0   \n",
        "0     NaN       Translink: Making fat people walk since 2000               0   \n",
        "0     NaN  @TransLink @vixerminator That 'reply' took ove...               0   \n",
        "0     NaN  RT @KayelleDubya: I actually like to reach my ...               0   \n",
        "0     NaN  Busses, busses everywhere, but not a spot to s...               0   \n",
        "0     NaN  RT @CloverdaleGal: @canadagraphs @TransLink LO...               0   \n",
        "0     NaN  Fantastic\"@Youngdriversbc: Are you stuck on a ...               0   \n",
        "0     NaN  Translink: Making fat people walk since 2000 #...               0   \n",
        "0     NaN  @TransLink omg! This will influence my voting ...               0   \n",
        "0     NaN  RT @wayfarying: \"@Youngdriversbc: Are you stuc...               0   \n",
        "0     NaN  RT @CoffeeGeek: Vancouver PSA: The Expo Line S...               0   \n",
        "0     NaN  RT @talbott23: Twice in a week-  a full shutdo...               0   \n",
        "0     NaN  @TransLink hello, it is about one hour from th...               0   \n",
        "..    ...                                                ...             ...   \n",
        "0     NaN  @kathryn_stew @CKNW @350Stroker @TransLink I j...               0   \n",
        "0     NaN  RT @StephenHui: Anyone else wish they'd been o...               0   \n",
        "0     NaN  @TGCTS  Vancouver has a sky train called trans...               0   \n",
        "0     NaN  @TransLink are trains running from dt to Burna...               0   \n",
        "0     NaN  Everyone angry at Translink for the SkyTrain o...               0   \n",
        "0     NaN  Doug Kelsey, COO of @TransLink, should be fire...               0   \n",
        "0     NaN  RT @grizlyatoms420: @TransLink *phew* good thi...               0   \n",
        "0     NaN  SkyTrain breakdowns may erode public confidenc...               0   \n",
        "0     NaN  RT @CryingWolfe: #TransLink ad, #Vancouver 201...               0   \n",
        "0     NaN  RT @EduCoello: The next station is Columbia #s...               0   \n",
        "0     NaN  RT @Youngdriversbc: Are you stuck on a #skytra...               0   \n",
        "0     NaN  It should be mandatory that all @TransLink exe...               0   \n",
        "0     NaN  RT @CTVVancouver: UPDATED: #SkyTrain halted on...               0   \n",
        "0     NaN  If it's one thing this @TransLink #SkyTrain fa...               0   \n",
        "0     NaN  RT @stevecbc: He's now giving directions to Su...               0   \n",
        "0     NaN  Everyone angry at Translink over the SkyTrain ...               0   \n",
        "0     NaN  @TransLink has a new motto: \"why ride when you...               0   \n",
        "0     NaN  RT @IsSkytrainBroke: Nope. Still working. \\n\\n...               0   \n",
        "0     NaN  RT @IsSkytrainBroke: Nope. Still working. \\n\\n...               0   \n",
        "0     NaN  RT @IsSkytrainBroke: Nope. Still working. \\n\\n...               0   \n",
        "0     NaN  @TransLink will you be reimbursing customers f...               0   \n",
        "0     NaN          @TransLink So, is your CEO stepping down?               0   \n",
        "0     NaN  RT @wetcoastlife: I like @TransLink \"you're no...               0   \n",
        "0     NaN  RT @Youngdriversbc: Are you stuck on a #skytra...               0   \n",
        "0     NaN  RT @jordanbateman: Maybe if TransLink didn't h...               0   \n",
        "0     NaN  RT @PennyDaflos: UPDATE: @translink says failu...               0   \n",
        "0     NaN  RT @jordanbateman: Maybe if TransLink didn't h...               0   \n",
        "0     NaN  RT @PennyDaflos: UPDATE: @translink says failu...               0   \n",
        "0     NaN  So these Metro #Vancouver morons think @transl...               0   \n",
        "0     NaN  RT @dacooster: @bizinvancouver @TransLink @Sto...               0   \n",
        "\n",
        "    generator  geo  gnip                                              id  \\\n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373440029310976   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373449483268096   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373452033404929   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373454344478720   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373504739430401   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373522447384577   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373535189680128   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373543821570048   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373571067768832   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373590101491713   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373602021707776   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373603104256001   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373632367505408   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373635039277057   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373664403599360   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373692635463681   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373702575951872   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373699568631808   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373721614299136   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373723581038592   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373748478427136   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373760578994177   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373804543684608   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373818699468800   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373825058435072   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373852778184704   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373867076558848   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373876950355968   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373882817773568   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491373890384326658   \n",
        "..        ...  ...   ...                                             ...   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491440544489291776   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491440893006589952   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491440973176512513   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491440987361669120   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491441506838798337   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491441513281224704   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491441692294148096   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491441856673107968   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491441978584748034   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442218020769792   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442263256363008   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442304062738432   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442328767172608   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442466973708288   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442611412955136   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442734171828224   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442757118857216   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491442902363414528   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491443012363243520   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491443025986338817   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491443304383275008   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491443715974508544   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491443907150880768   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491444053213315073   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491444076835635200   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491444449596039168   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491444471058276354   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491444744023592961   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491444825355739136   \n",
        "0         NaN  NaN   NaN  tag:search.twitter.com,2005:491444848163962880   \n",
        "\n",
        "    inReplyTo                                               link  location  \\\n",
        "0         NaN  http://twitter.com/CloverdaleGal/statuses/4913...       NaN   \n",
        "0         NaN  http://twitter.com/PSPilates/statuses/49137344...       NaN   \n",
        "0         NaN  http://twitter.com/a_jonca/statuses/4913734520...       NaN   \n",
        "0         NaN  http://twitter.com/1packerray/statuses/4913734...       NaN   \n",
        "0         NaN  http://twitter.com/CloverdaleGal/statuses/4913...       NaN   \n",
        "0         NaN  http://twitter.com/talbott23/statuses/49137352...       NaN   \n",
        "0         NaN  http://twitter.com/jakecaparas/statuses/491373...       NaN   \n",
        "0         NaN  http://twitter.com/paolazuccaro/statuses/49137...       NaN   \n",
        "0         NaN  http://twitter.com/PippoRotini/statuses/491373...       NaN   \n",
        "0         NaN  http://twitter.com/yaTanereS/statuses/49137359...       NaN   \n",
        "0         NaN  http://twitter.com/kelseymakihara/statuses/491...       NaN   \n",
        "0         NaN  http://twitter.com/jordanbateman/statuses/4913...       NaN   \n",
        "0         NaN  http://twitter.com/WaderMacD/statuses/49137363...       NaN   \n",
        "0         NaN  http://twitter.com/jakecaparas/statuses/491373...       NaN   \n",
        "0         NaN  http://twitter.com/pqpolitics/statuses/4913736...       NaN   \n",
        "0         NaN  http://twitter.com/CloverdaleGal/statuses/4913...       NaN   \n",
        "0         NaN  http://twitter.com/LiveatViceroy/statuses/4913...       NaN   \n",
        "0         NaN  http://twitter.com/jakecaparas/statuses/491373...       NaN   \n",
        "0         NaN  http://twitter.com/BadTranslink/statuses/49137...       NaN   \n",
        "0         NaN  http://twitter.com/always_vote/statuses/491373...       NaN   \n",
        "0         NaN  http://twitter.com/jakecaparas/statuses/491373...       NaN   \n",
        "0         NaN  http://twitter.com/itsmeichi/statuses/49137376...       NaN   \n",
        "0         NaN  http://twitter.com/jakecaparas/statuses/491373...       NaN   \n",
        "0         NaN  http://twitter.com/paolazuccaro/statuses/49137...       NaN   \n",
        "0         NaN  http://twitter.com/BadTranslink/statuses/49137...       NaN   \n",
        "0         NaN  http://twitter.com/AskATruckDriver/statuses/49...       NaN   \n",
        "0         NaN  http://twitter.com/CloverdaleGal/statuses/4913...       NaN   \n",
        "0         NaN  http://twitter.com/daka_x/statuses/49137387695...       NaN   \n",
        "0         NaN  http://twitter.com/jakecaparas/statuses/491373...       NaN   \n",
        "0         NaN  http://twitter.com/aniairek/statuses/491373890...       NaN   \n",
        "..        ...                                                ...       ...   \n",
        "0         NaN  http://twitter.com/qdsworld/statuses/491440544...       NaN   \n",
        "0         NaN  http://twitter.com/DaRkDaN89/statuses/49144089...       NaN   \n",
        "0         NaN  http://twitter.com/dispatcher880/statuses/4914...       NaN   \n",
        "0         NaN  http://twitter.com/darinxyz/statuses/491440987...       NaN   \n",
        "0         NaN  http://twitter.com/hi_its_kyle/statuses/491441...       NaN   \n",
        "0         NaN  http://twitter.com/Tax_MD/statuses/49144151328...       NaN   \n",
        "0         NaN  http://twitter.com/fabsace/statuses/4914416922...       NaN   \n",
        "0         NaN  http://twitter.com/iVancouverNews/statuses/491...       NaN   \n",
        "0         NaN  http://twitter.com/LeDesertFlower/statuses/491...       NaN   \n",
        "0         NaN  http://twitter.com/pch4101/statuses/4914422180...       NaN   \n",
        "0         NaN  http://twitter.com/LeDesertFlower/statuses/491...       NaN   \n",
        "0         NaN  http://twitter.com/Tax_MD/statuses/49144230406...       NaN   \n",
        "0         NaN  http://twitter.com/pch4101/statuses/4914423287...       NaN   \n",
        "0         NaN  http://twitter.com/mtthwbyd/statuses/491442466...       NaN   \n",
        "0         NaN  http://twitter.com/grandmasterc/statuses/49144...       NaN   \n",
        "0         NaN  http://twitter.com/hi_its_kyle/statuses/491442...       NaN   \n",
        "0         NaN  http://twitter.com/nad_imz/statuses/4914427571...       NaN   \n",
        "0         NaN  http://twitter.com/eastvanhalen/statuses/49144...       NaN   \n",
        "0         NaN  http://twitter.com/moebius_strip/statuses/4914...       NaN   \n",
        "0         NaN  http://twitter.com/Stroppy_Girl/statuses/49144...       NaN   \n",
        "0         NaN  http://twitter.com/BahirAhmad94/statuses/49144...       NaN   \n",
        "0         NaN  http://twitter.com/WhyNotL8er/statuses/4914437...       NaN   \n",
        "0         NaN  http://twitter.com/qdsworld/statuses/491443907...       NaN   \n",
        "0         NaN  http://twitter.com/Studestinations/statuses/49...       NaN   \n",
        "0         NaN  http://twitter.com/MBazowski/statuses/49144407...       NaN   \n",
        "0         NaN  http://twitter.com/ianabailey/statuses/4914444...       NaN   \n",
        "0         NaN  http://twitter.com/abbyroadkill/statuses/49144...       NaN   \n",
        "0         NaN  http://twitter.com/moebius_strip/statuses/4914...       NaN   \n",
        "0         NaN  http://twitter.com/stevenhuang/statuses/491444...       NaN   \n",
        "0         NaN  http://twitter.com/MarkShaw24/statuses/4914448...       NaN   \n",
        "\n",
        "    object objectType                postedTime  provider  retweetCount  \\\n",
        "0      NaN   activity  2014-07-22T00:05:32.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:05:34.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:05:34.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:05:35.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:05:47.000Z       NaN             2   \n",
        "0      NaN   activity  2014-07-22T00:05:51.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:05:54.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:05:56.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:06:03.000Z       NaN            31   \n",
        "0      NaN   activity  2014-07-22T00:06:07.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:06:10.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:06:10.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:06:17.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:06:18.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:06:25.000Z       NaN             6   \n",
        "0      NaN   activity  2014-07-22T00:06:32.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:06:34.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:06:33.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:06:39.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:06:39.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:06:45.000Z       NaN             2   \n",
        "0      NaN   activity  2014-07-22T00:06:48.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:06:58.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:07:02.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:07:03.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:07:10.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T00:07:13.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:07:16.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:07:17.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T00:07:19.000Z       NaN             0   \n",
        "..     ...        ...                       ...       ...           ...   \n",
        "0      NaN   activity  2014-07-22T04:32:10.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:33:34.000Z       NaN            13   \n",
        "0      NaN   activity  2014-07-22T04:33:53.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:33:56.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:36:00.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:36:01.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:36:44.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T04:37:23.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:37:52.000Z       NaN             1   \n",
        "0      NaN   activity  2014-07-22T04:38:50.000Z       NaN            49   \n",
        "0      NaN   activity  2014-07-22T04:39:00.000Z       NaN            69   \n",
        "0      NaN   activity  2014-07-22T04:39:10.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:39:16.000Z       NaN            21   \n",
        "0      NaN   activity  2014-07-22T04:39:49.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:40:23.000Z       NaN             9   \n",
        "0      NaN   activity  2014-07-22T04:40:53.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:40:58.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:41:33.000Z       NaN             2   \n",
        "0      NaN   activity  2014-07-22T04:41:59.000Z       NaN             3   \n",
        "0      NaN   activity  2014-07-22T04:42:02.000Z       NaN             4   \n",
        "0      NaN   activity  2014-07-22T04:43:09.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:44:47.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:45:32.000Z       NaN             4   \n",
        "0      NaN   activity  2014-07-22T04:46:07.000Z       NaN            70   \n",
        "0      NaN   activity  2014-07-22T04:46:13.000Z       NaN            49   \n",
        "0      NaN   activity  2014-07-22T04:47:42.000Z       NaN             6   \n",
        "0      NaN   activity  2014-07-22T04:47:47.000Z       NaN            50   \n",
        "0      NaN   activity  2014-07-22T04:48:52.000Z       NaN             7   \n",
        "0      NaN   activity  2014-07-22T04:49:11.000Z       NaN             0   \n",
        "0      NaN   activity  2014-07-22T04:49:17.000Z       NaN             1   \n",
        "\n",
        "    twitter_entities twitter_filter_level twitter_lang   verb  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "..               ...                  ...          ...    ...  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en  share  \n",
        "0                NaN               medium           en   post  \n",
        "0                NaN               medium           en  share  \n",
        "\n",
        "[1132 rows x 19 columns]"
       ]
      }
     ],
     "prompt_number": 22
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "# build word:sentiment dictionary\n",
      "sentiment = {}\n",
      "with open('AFINN-111.txt', 'r') as f:\n",
      "    for line in f:\n",
      "        term, score = line.split('\\t')\n",
      "        sentiment[term] = int(score)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 17
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "words = [x.split() for x in sentiment]\n",
      "keylen = np.array([len(x) for x in words])"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 18
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "np.array(words)[keylen > 1]\n"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 19,
       "text": [
        "array([['cool', 'stuff'], ['green', 'wash'], ['messing', 'up'],\n",
        "       ['does', 'not', 'work'], [\"can't\", 'stand'], ['no', 'fun'],\n",
        "       ['not', 'working'], ['right', 'direction'], ['some', 'kind'],\n",
        "       ['cashing', 'in'], ['screwed', 'up'], ['dont', 'like'],\n",
        "       ['green', 'washing'], ['fed', 'up'], ['not', 'good']], dtype=object)"
       ]
      }
     ],
     "prompt_number": 19
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import string\n",
      "clean = string.punctuation"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 38
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import math\n",
      "import re\n",
      "import sys\n",
      "reload(sys)\n",
      "sys.setdefaultencoding('utf-8')\n",
      " \n",
      "filenameAFINN = 'AFINN-111.txt'\n",
      "afinn = dict(map(lambda (w, s): (w, int(s)), [ \n",
      "            ws.strip().split('\\t') for ws in open(filenameAFINN) ]))\n",
      " \n",
      "# Word splitter pattern\n",
      "pattern_split = re.compile(r\"\\W+\")"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 25
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "def sentiment(text):\n",
      "    \"\"\"\n",
      "    Returns a float for sentiment strength based on the input text.\n",
      "    Positive values are positive valence, negative value are negative valence. \n",
      "    \"\"\"\n",
      "    words = pattern_split.split(text.lower())\n",
      "    sentiments = map(lambda word: afinn.get(word, 0), words)\n",
      "    if sentiments:\n",
      "        # How should you weight the individual word sentiments? \n",
      "        # You could do N, sqrt(N) or 1 for example. Here I use sqrt(N)\n",
      "        sentiment = float(sum(sentiments))/math.sqrt(len(sentiments))\n",
      "        \n",
      "    else:\n",
      "        sentiment = 0\n",
      "    return sentiment"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 26
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [
      "import string\n",
      "clean_punctuation = lambda x:x not in clean\n",
      "\n",
      "sentiment_scores = []\n",
      "\n",
      "for text in tweets:\n",
      "    cleaned_tweet = filter(clean_punctuation, text)\n",
      "    scored_sentiment = sentiment(cleaned_tweet)\n",
      "    sentiment_scores.append(scored_sentiment)\n",
      "    \n",
      "zip(tweets, sentiment_scores)"
     ],
     "language": "python",
     "metadata": {},
     "outputs": [
      {
       "metadata": {},
       "output_type": "pyout",
       "prompt_number": 39,
       "text": [
        "[(u\"RT @KayelleDubya: I actually like to reach my destination on the same day I depart. This is one of many reasons I don't take #translink\",\n",
        "  0.6),\n",
        " (u'RT @CDNtransport: #Translink News: SkyTrain service halted on Expo and Millennium lines again - CTV News http://t.co/3FG4BBTI9P',\n",
        "  0.0),\n",
        " (u'oy, translink. I guess this is going to be a regular occurrence now...no room in the budget for a decrepit system that needs to be replaced',\n",
        "  0.0),\n",
        " (u\"For all the $ #translink takes in and it's never enough,skytrain is managed &amp; ran just as poor.\",\n",
        "  -0.48507125007266594),\n",
        " (u'RT @canadagraphs: HAHA, #Translink has 2nd major system collapse in a week.\\nApparently no one told @translink that the skytrain only runs w\\u2026',\n",
        "  0.0),\n",
        " (u\"Twice in a week-  a full shutdown. Complete joke of a transit system @TransLink. Even the mayor isn't sticking up for you now.\",\n",
        "  0.41702882811414954),\n",
        " (u\"RT @Karsonprince: @TransLink we pay 175+ in fines for not having a ticket. How many skytrain users will be refunded for today's problems ca\\u2026\",\n",
        "  -0.6),\n",
        " (u'RT @DylanChernick: Haha, great call. \"@Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you ho\\u2026',\n",
        "  0.8),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'RT @SidiElazhari: Time for privatization?? WAKE UP BC!!! #SkyTrain #ICBC #translinkfail #translink \\n\\nhttp://t.co/qFe6snXQJS',\n",
        "  0.0),\n",
        " (u'RT @LauraCoughlan: I love @TransLink #shitnobodysays', 1.2247448713915892),\n",
        " (u'@kevinharding province knows TransLink has adequate funding w/ in annual $1.4B revenue stream to make it work.',\n",
        "  0.24253562503633297),\n",
        " (u'@stephsia @TransLink best get in line for the bus sooner rather than later but best of luck for ya ;)',\n",
        "  2.0124611797498106),\n",
        " (u'RT @610Mike: Thank Goodness Translink invested all that money in the Compass Card!',\n",
        "  1.386750490563073),\n",
        " (u\"RT @njellan: Lazy pundits will blame #Skytrain problems on Translink mismanagement rather than pointing out Province's underfunding &amp; meddl\\u2026\",\n",
        "  -1.118033988749895),\n",
        " (u'@canadagraphs @TransLink LOL, good one... is it plugged in?  #Translink - glad I drive',\n",
        "  2.4961508830135313),\n",
        " (u'SKYTRAIN UPDATE. Translink says Expo Line appears to be fixed. Expo Line will launch in segments @ 5:05 pm with full service by 5:45 pm',\n",
        "  0.0),\n",
        " (u\"RT @colourandcinema: @ianinadonne the next political party to severely slash the Translink CEO's $400,000 salary gets mine!\",\n",
        "  -0.48507125007266594),\n",
        " (u'Translink: Making fat people walk since 2000', 0.0),\n",
        " (u\"@TransLink @vixerminator That 'reply' took over an hour for Victoria to get. @Lazin_Ryder\",\n",
        "  0.0),\n",
        " (u\"RT @KayelleDubya: I actually like to reach my destination on the same day I depart. This is one of many reasons I don't take #translink\",\n",
        "  0.6),\n",
        " (u'Busses, busses everywhere, but not a spot to stand. @TransLink, send more busses to Bridgeport please. #translink #toofulltoboard',\n",
        "  0.23570226039551587),\n",
        " (u'RT @CloverdaleGal: @canadagraphs @TransLink LOL, good one... is it plugged in?  #Translink - glad I drive',\n",
        "  2.32379000772445),\n",
        " (u'Fantastic\"@Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!\"',\n",
        "  -0.4364357804719848),\n",
        " (u'Translink: Making fat people walk since 2000 #Skytrain', 0.0),\n",
        " (u'@TransLink omg! This will influence my voting pattern in a few years! (After I walk home in July)',\n",
        "  0.0),\n",
        " (u'RT @wayfarying: \"@Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!\"\\nExcell\\u2026',\n",
        "  -0.4),\n",
        " (u'RT @CoffeeGeek: Vancouver PSA: The Expo Line Skytrain starting up again, Translink claims back to full service by 5:45pm. Feel bad for comm\\u2026',\n",
        "  -0.6123724356957946),\n",
        " (u\"RT @talbott23: Twice in a week-  a full shutdown. Complete joke of a transit system @TransLink. Even the mayor isn't sticking up for you no\\u2026\",\n",
        "  0.19611613513818404),\n",
        " (u'@TransLink hello, it is about one hour from the first post about Expo line. Do you have any updates?',\n",
        "  0.0),\n",
        " (u\"Huge respect for the brave souls behind .@TransLink who've quite a month to handle so far. Would love to buy you folks a beer or coffee!\",\n",
        "  1.1766968108291043),\n",
        " (u'RT @CTVVancouver: #Breaking: TransLink says Expo Line should start operating at 5:05, with full service returning by 5:45. http://t.co/Xct4\\u2026',\n",
        "  0.0),\n",
        " (u'RT @CTVVancouver: #Breaking: TransLink says Expo Line should start operating at 5:05, with full service returning by 5:45. http://t.co/Xct4\\u2026',\n",
        "  0.0),\n",
        " (u'Fuck you translink', -2.3094010767585034),\n",
        " (u'@Sangnooki @TransLink where\\u2019s our tax money going????? And wait they still wanna rise transit far next year!!!',\n",
        "  0.0),\n",
        " (u'RT @TransLink: @financ_advice M-Line is now running between VCC-Clark and Sapperton.\\nE- line is expected to open within the next hour^LA',\n",
        "  0.0),\n",
        " (u'@amyjudd @ChelseaRTucker who is \"Translink\" anyways..', 0.0),\n",
        " (u'According to a certain twitter egg  these frequent #translink meltdowns are acceptable due o lack of funding/rev vs area coverage #kidmenot',\n",
        "  -0.2182178902359924),\n",
        " (u'RT @CTVVancouver: #Breaking: TransLink says Expo Line should start operating at 5:05, with full service returning by 5:45. http://t.co/Xct4\\u2026',\n",
        "  0.0),\n",
        " (u'Even though I have often been infuriated w/ @translink and this collapse this week is an EPIC FAIL, its still better than what the TTC has.',\n",
        "  -0.7844645405527362),\n",
        " (u\"@TransLink we have been here over 30 minutes...you'll need 3 buses to accommodate everyone here!!!\",\n",
        "  0.0),\n",
        " (u'RT @wastedsundays: helpful tip for #translink decision makers: windows XP support ended 4-8-2014. Time to upgrade? #translinkfail',\n",
        "  0.9701425001453319),\n",
        " (u'@grizlyatoms420 We are experiencing heavy volumes on our site. try http://t.co/oROwajgaMs for trip planning^LA',\n",
        "  0.0),\n",
        " (u'#Translink is going to have to consider offering at least a \"free\" day as an apology to its customers.',\n",
        "  0.0),\n",
        " (u'Lmfao translink fucked up again', 0.0),\n",
        " (u'#translink my friend says that this is sabotage by a disgruntled employee my friend is high up in management at #translink',\n",
        "  -0.4364357804719848),\n",
        " (u'RT @Amexken: Time for heads to roll in Translink failures. Gross incompetence. #translink',\n",
        "  -1.6641005886756874),\n",
        " (u'RT @canadagraphs: HAHA, #Translink has 2nd major system collapse in a week.\\nApparently no one told @translink that the skytrain only runs w\\u2026',\n",
        "  0.0),\n",
        " (u'@TransLink is 301 even running?', 0.0),\n",
        " (u'@TransLink you keep increasing your fare rates yet we get this kind of service. You guys are embarrassing #translink #joke',\n",
        "  0.4472135954999579),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE  M-Line is now running between VCC-Clark and Sapperton.\\nE- line is expected to open within the next hour. ^\\u2026',\n",
        "  0.0),\n",
        " (u'@canadagraphs @TransLink we DID sent a memo...', 0.0),\n",
        " (u'RT @lizaCKNW980: Transit users walking on track to Main Street #skytrain after 30 min on stopped train. @TransLink http://t.co/Nllb0CXmdn',\n",
        "  -0.22941573387056174),\n",
        " (u'@CloverdaleGal @TransLink they should try turning it off &amp; back on. I hear that works.',\n",
        "  0.0),\n",
        " (u'Can anyone give me a ride from New West to Scott Road station? TransLink, as per usual, sucks.',\n",
        "  -0.7071067811865476),\n",
        " (u'@TEAM1040  Global BC 1 min \\xb7  SKYTRAIN UPDATE. Translink says Expo Line appears to be fixed. Safety sweep underway according to Translink,',\n",
        "  0.2182178902359924),\n",
        " (u'RT @BackpackerBooie: Maybe the skytrain system blew up because someone tried to use their Compass Card #translink',\n",
        "  0.0),\n",
        " (u\"You mean to tell me the Cavs were able to get the L-train LeBron James back but @TransLink can't get the skytrain running? I am disappointed\",\n",
        "  -0.3922322702763681),\n",
        " (u'@TransLink how can i get to Nanaimo Station or Joyce Station from Stadium Station',\n",
        "  0.0),\n",
        " (u'@lailayuile nor Portland http://t.co/eFaTQJpZGi nor Toronto http://t.co/fKtz80Sagw hope @TransLink sees this as a sign to become the first!',\n",
        "  0.47140452079103173),\n",
        " (u'Could erode or eroding?\\n\\u201c@bizinvancouver: Former chair says SkyTrain system could erode public confidence http://t.co/zhJ3bJyYq7 @TransLink\\u201d',\n",
        "  0.48507125007266594),\n",
        " (u'@lailayuile they blew all that money on swanky @TransLink offices. Have they offered media a tour yet?',\n",
        "  0.0),\n",
        " (u\"@TransLink since rush hour is a gong show will PM peak buses b xtended? Like 2 catch 391 down 116 street - doubt I'll make last sched trip.\",\n",
        "  -0.19245008972987526),\n",
        " (u'@TransLink free skytrain rides for the rest of July?? Sounds good to me.',\n",
        "  1.1094003924504583),\n",
        " (u'RT @browneandrew: @andrewtrevjones Are #TransLink execs really so terrible? Blame is easy, but we need people to run organization with $1.5\\u2026',\n",
        "  -0.8528028654224417),\n",
        " (u'RT @canadagraphs: @CloverdaleGal @TransLink they should try turning it off &amp; back on. I hear that works.',\n",
        "  0.0),\n",
        " (u'Who is making money out of #translink mismanagement? @CTVVancouver #baddays',\n",
        "  0.0),\n",
        " (u'#translink feel my internet scorn! a group of us have been waiting for a bus that should have arrived 30 minutes ago! bus and Skytrain fail!',\n",
        "  -0.7844645405527362),\n",
        " (u'Translink, you suck.', -1.7320508075688774),\n",
        " (u\"I'm at Bus Stop 50689 (19,22) - @translink w/ @hoowuu http://t.co/l53xYLNdGG\",\n",
        "  -0.31622776601683794),\n",
        " (u\"@CKNW @toddstonebc @TransLink Total joke. Provincial ministers need to grow a pair &amp; tell the taxpayers &amp; the affected this isn't acceptable\",\n",
        "  0.21320071635561041),\n",
        " (u'@canadagraphs @TransLink Maybe hire some people that know what is going on...lol  So glad that I drive to work. Transit in BC is terrible.',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain We are expecting to have the Expo line open within the next hour ^rw',\n",
        "  0.0),\n",
        " (u\"RT @njellan: Lazy pundits will blame #Skytrain problems on Translink mismanagement rather than pointing out Province's underfunding &amp; meddl\\u2026\",\n",
        "  -1.118033988749895),\n",
        " (u'need more buses at metrotown!! #translink #TransitAlert', 0.0),\n",
        " (u'@TransLink when are you going to explain what caused this?? We deserve to know',\n",
        "  0.0),\n",
        " (u'Going home via Richmond #translink', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line bus bridge from Surrey Cntrl to New West .Will service Gateway &amp; Scott Rd Stns Transfer to extra service at\\u2026',\n",
        "  0.0),\n",
        " (u'Translink is ruining my life. I just wanna go home omfg.',\n",
        "  -0.6030226891555273),\n",
        " (u'RT @wastedsundays: @MayorGregor Translink CEO makes more than the bloody PM. Perhaps more \"funding\" isn\\'t the issue.',\n",
        "  -0.7276068751089989),\n",
        " (u'@TransLink hi!! At what time the sytrain service will be back? I want to go to 29th avenue station and im in waterfront/burrard',\n",
        "  0.20851441405707477),\n",
        " (u'Passengers entering station at Broadway and Commercial #cbc @TransLink',\n",
        "  0.0),\n",
        " (u'@TransLink is waterfront to commercial working?', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE  M-Line is now running between VCC-Clark and Sapperton.\\nE- line is expected to open within the next hour. ^\\u2026',\n",
        "  0.0),\n",
        " (u'via CBC: \"Expo Line is expected to be up and running by 5:45 pm\" @Translink #SkyTrain',\n",
        "  0.0),\n",
        " (u'@TransLink *crickets*', 0.0),\n",
        " (u'RT @rfilippone: Passengers entering station at Broadway and Commercial #cbc @TransLink',\n",
        "  0.0),\n",
        " (u'@TransLink Stop blaming others but yourselves. if the skytrain worked properly, there would be no need to open the doors that caused damaged',\n",
        "  -0.8340576562282991),\n",
        " (u'RT @CoffeeGeek: Vancouver PSA: The Expo Line Skytrain starting up again, Translink claims back to full service by 5:45pm. Feel bad for comm\\u2026',\n",
        "  -0.6123724356957946),\n",
        " (u'RT @rfilippone: Passengers entering station at Broadway and Commercial #cbc @TransLink',\n",
        "  0.0),\n",
        " (u'TransLink says SkyTrain starting to resume service after technical issue http://t.co/cZuoQXByPp',\n",
        "  0.0),\n",
        " (u'@TransLink is the E-line running yet?', 0.0),\n",
        " (u\"I'll join @jonmccomb980 at 515pm for the latest on the @TransLink sky train melt down. @CKNW\",\n",
        "  -0.25),\n",
        " (u'@TransLink How do you not have a contingency plan in place in an event like this!? Second time in less than a week! Ridiculous!',\n",
        "  -0.20412414523193154),\n",
        " (u'RT @BarinderRasode: Going to be tough for all especially for parents who have to be on time to pick up kids from daycare  @WoodfordCKNW980 \\u2026',\n",
        "  0.0),\n",
        " (u'@translink What message are you broadcasting at Brentwood Station? The sound is garbled.',\n",
        "  0.0),\n",
        " (u\"@TransLink half full 190 didn't stop at Hastings and Cambie\",\n",
        "  -0.31622776601683794),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @EduCoello: The next station is Columbia #skytrainproblems #translink http://t.co/jczN0l0D1g',\n",
        "  0.0),\n",
        " (u\"@shanecossever @TransLink's site is about as efficient as the trains then\",\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @CTVVancouver: #Breaking: TransLink says Expo Line should start operating at 5:05, with full service returning by 5:45. http://t.co/Xct4\\u2026',\n",
        "  0.0),\n",
        " (u'RT @canadagraphs: @CloverdaleGal @TransLink they should try turning it off &amp; back on. I hear that works.',\n",
        "  0.0),\n",
        " (u'@TransLink Check out http://t.co/5H59JkgGWl, the best way to make an awesome resume!',\n",
        "  2.0207259421636903),\n",
        " (u'@TransLink its a good thing we spent all that $ on a useless compass system shoulda put that $ towards new software that has no glitches',\n",
        "  0.0),\n",
        " (u'@daka_x @TransLink  I would honestly like to see @translink take a huge hit on this and tell it like it is..&amp; move on, not holding breathe!',\n",
        "  0.9805806756909202),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @georgiastraight: TransLink says SkyTrain starting to resume service after technical issue http://t.co/cZuoQXByPp',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"RT @ShelbyThom980: I'll join @jonmccomb980 at 515pm for the latest on the @TransLink sky train melt down. @CKNW\",\n",
        "  -0.23570226039551587),\n",
        " (u'MT @miguelramostv: Just spoke with BC Trans Min -  refusing to comment re: skytrain shutdown because it\\'s @TransLink \"operational issue\"',\n",
        "  -0.4588314677411235),\n",
        " (u'MT @miguelramostv: Just spoke with BC Trans Min -  refusing to comment re: skytrain shutdown because it\\'s @TransLink \"operational issue\"',\n",
        "  -0.4588314677411235),\n",
        " (u'MT @miguelramostv: Just spoke with BC Trans Min -  refusing to comment re: skytrain shutdown because it\\'s @TransLink \"operational issue\"',\n",
        "  -0.4588314677411235),\n",
        " (u'@ConnieChoco @TransLink By 5.45pm was the last word', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@CloverdaleGal @TransLink Cant hire people, would cut into the Execs Rich Peoples Rainy Day Fund. Cant have that, they need their Yachts',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE  M-Line is now running between VCC-Clark and Sapperton.\\nE- line is expected to open within the next hour. ^\\u2026',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"I don't wanna hear about service returning. I wanna hear about @TransLink bosses resigning. #SkyTrain\",\n",
        "  -0.2581988897471611),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'If the train is broken down the least you can do is put more buses on the road, translink &gt;:(',\n",
        "  -0.22360679774997896),\n",
        " (u'I bet Bicycle Shop owners today along skytrain lines did record sales.\\nSee @translink stimulates the economy.',\n",
        "  0.24253562503633297),\n",
        " (u'RT @canadagraphs: @CloverdaleGal @TransLink they should try turning it off &amp; back on. I hear that works.',\n",
        "  0.0),\n",
        " (u'@DyNeil take canada line to Bridgeport, then 311 to Scottsdale. @TransLink',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'UPDATE: .@TransLink expects Expo Line service to resume within a few minutes. Stay with @News1130Radio for complete #skytrain coverage.',\n",
        "  0.0),\n",
        " (u\"Vancouver's #SkyTrain system is a complete joke! #translink step up your game. Wow.\",\n",
        "  1.6641005886756874),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"@TransLink what's happening with the SkyTrain?\", 0.0),\n",
        " (u'@translink is the 22 downtown ever going to show? Seen 2 nis already',\n",
        "  0.0),\n",
        " (u\"@Scotty_Evil @TransLink  To the swanky offices? Not that I have been invited too.. but that wouldn't surprise me if I were left out..:)\",\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink Any shuttle bus that goes from Gastown to VCC?', 0.0),\n",
        " (u'@TransLink now I hope I won\\u2019t be stuck on a train later\\u2026',\n",
        "  0.8017837257372732),\n",
        " (u'RT @AnthonyFloyd: This is fun/sad if true #skytrain #translink #commuterchaos #transitgeddon #trainpocalypse http://t.co/WuWB8sRCMh',\n",
        "  0.5547001962252291),\n",
        " (u'Brilliant! RT: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!',\n",
        "  0.42640143271122083),\n",
        " (u'@TransLink How to catch a bus from DT Vancouver to get to Surrey Central?',\n",
        "  0.0),\n",
        " (u'Good thing #Translink spent so much on the fancy compass card which doesnt work. \\nForget maintainence, who needs it?  #skytrainblues :-(',\n",
        "  0.4364357804719848),\n",
        " (u\"@simmeh_d: Vancouver's #SkyTrain system is a complete joke! @TransLink step up your game. Wow. #Translinkproblems\",\n",
        "  1.5491933384829668),\n",
        " (u'@TransLink Are trains to Waterfront still running?', 0.0),\n",
        " (u'RT @TransLink: @SkyTrain UPDATE Service between Sapperton and Columbia Stations is expected to resume within the next 30-45 minutes. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @georgiastraight: TransLink says SkyTrain starting to resume service after technical issue http://t.co/cZuoQXByPp',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@jonmccomb980 hey translink leadership! U r running multi billion $ organization. Vacation is over get back to work! That is accountability',\n",
        "  0.0),\n",
        " (u'RT @kathryn_stew: I just imagine @Translink staff sighing and flipping a \"Days Since Last #Skytrain shutdown\" sign back to 0.',\n",
        "  0.0),\n",
        " (u'Playing my new favourite game, @TransLink, it\\'s called \"how late is the 044?\" Current hi score is 34minutes. Today prob won\\'t beat that.',\n",
        "  0.0),\n",
        " (u\"@lailayuile @daka_x Stupid @Translink Rep on radio just sd 'a friend who was visiting me from Australia said it happens there all the time'\",\n",
        "  -0.4082482904638631),\n",
        " (u'@TransLink thanks, on board', 1.0),\n",
        " (u'Omfg when TransLink screws up, all the roads go to complete shit #gridlockhell',\n",
        "  -1.1094003924504583),\n",
        " (u'RT @TransLink: @SkyTrain UPDATE Service between Sapperton and Columbia Stations is expected to resume within the next 30-45 minutes. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TanyaNews1130: UPDATE: .@TransLink expects Expo Line service to resume within a few minutes. Stay with @News1130Radio for complete #sky\\u2026',\n",
        "  0.0),\n",
        " (u\"RT @always_vote: @lailayuile @daka_x Stupid @Translink Rep on radio just sd 'a friend who was visiting me from Australia said it happens th\\u2026\",\n",
        "  -0.4082482904638631),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Service between Sapperton and Columbia Stations is expected to resume within the next 30-45 minutes. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink hey thanks!', 1.1547005383792517),\n",
        " (u'@TransLink Is M Line back in service from Burrard station?', 0.0),\n",
        " (u\"@WoodfordCKNW980 all those high paid execs and spinmeisters at TransLink &amp; it's the police chief making service announcements?\",\n",
        "  0.0),\n",
        " (u\"@SamarSKhan Sorry bro I can't do that but I'll complain with you. #translink Horrible horrible horrible - at least it's sunny out.\",\n",
        "  -3.0550504633038935),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'#Commuter Traffic: #translink suffers-complete system failure on #expo and millennium lines in #vancouver.  http://t.co/kbTORYGriX',\n",
        "  -0.5345224838248488),\n",
        " (u\"Vancouver's #SkyTrain system is a complete joke! @TransLink step up your game. Wow. #Translinkproblems\",\n",
        "  1.6035674514745464),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"RT @jordanbateman: @WoodfordCKNW980 all those high paid execs and spinmeisters at TransLink &amp; it's the police chief making service announce\\u2026\",\n",
        "  0.0),\n",
        " (u'@kailenemurray just blame #translink for everything', -0.8164965809277261),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@Hassan_Haque your sympathy is more than enough, brotha.  Down with #Translink.',\n",
        "  0.6030226891555273),\n",
        " (u\"@TransLink Everyone's giving you the usual flack for the skytrain outage,  but I think you're doing a great job handling the situation :-D\",\n",
        "  0.6255432421712244),\n",
        " (u'@TransLink @GlobalBC Its hilarious how they say sorry when you feel like spitting in face. Assholes',\n",
        "  0.75),\n",
        " (u'@TransLink Commuting is believing.', 0.0),\n",
        " (u\"Transit in #Vancouver is total garbage. So glad I don't use it anymore &amp; instead get to cruise around in my Mustang GT. @translink\",\n",
        "  0.6123724356957946),\n",
        " (u'@TransLink all stations?', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Service between Sapperton and Columbia Stations is expected to resume within the next 30-45 minutes. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"Any1 else find it oxymoronic @TransLink execs get CAR allowance. Shouldn't they b using sys they manage? #bcpoli #skytrainproblems\",\n",
        "  0.0),\n",
        " (u'@TransitPolice @TransLink Someone snuck a large stinky dog on 99 8119 wb from Commercial. Right beside me.',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink is very skilled at  the blame game. Try owing up to your mistakes and maybe the public will lighten up on you a bit.',\n",
        "  -0.8),\n",
        " (u'@TransLink Would my friend be able to get to Commercial Broadway from Waterfront, Burrard, Granville or Stadium on the Skytrain?',\n",
        "  0.0),\n",
        " (u'RT @canadagraphs: @CloverdaleGal @TransLink they should try turning it off &amp; back on. I hear that works.',\n",
        "  0.0),\n",
        " (u'RT @CTVVancouver: UPDATED: #SkyTrain halted on Expo &amp; Millennium lines. #TransLink telling riders to make other arrangements. http://t.co/0\\u2026',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'biggest trolls of Burnaby = @TransLink', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink commend all the staff for their patience and trying to make this as painless as possible!',\n",
        "  0.48507125007266594),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @AbelBeraki: #TransLink not impressed...Seattle got better transit',\n",
        "  0.7071067811865475),\n",
        " (u'translink is fvcked up lol \\nskytrain problems every week\\U0001f602\\U0001f602 http://t.co/39wStNUE6u',\n",
        "  0.31622776601683794),\n",
        " (u'RT @News1130radio: @translink says M line could have started up earlier but doors were damaged by ppl who forced them open and walked on tr\\u2026',\n",
        "  -0.19611613513818404),\n",
        " (u'@Amexken @TransLink They\\'re \"out of town\" OR better known as \"at the lake for the summer\"',\n",
        "  0.5),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @AliGirard: Needless to say, an embarrassing day for the org on a technical front, but kudos to the @TransLink Twitter team for their gr\\u2026',\n",
        "  0.19611613513818404),\n",
        " (u\"I'm seeing trains moving on the Expo line now @CKNW #translink\", 0.0),\n",
        " (u\"RT @StephenHui: Anyone else wish they'd been on the #SkyTrain for the free guided track tour? #TransLink\",\n",
        "  0.48507125007266594),\n",
        " (u'RT @ursedated: I think #translink managers should commute via #skytrain today',\n",
        "  0.0),\n",
        " (u'@canadagraphs @TransLink LOL so true. http://t.co/OcvZIbaUIo All should be slashed!',\n",
        "  0.9486832980505138),\n",
        " (u'On the bright side, today everyone on my #SkyTrain has a seat @TransLink',\n",
        "  0.2773500981126146),\n",
        " (u'RT @georgiastraight: RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few min\\u2026',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'#NewWest Station, passengers waiting for the shuttle bus to #Surrey. #Translink http://t.co/Tk9GHp9ly9',\n",
        "  0.0),\n",
        " (u'RT @Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!',\n",
        "  -0.42640143271122083),\n",
        " (u'@TransLink train from Sapperton just arrived to Columbia and I was on it. Better check your \"update\"...before you tweet',\n",
        "  0.4588314677411235),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Service between Sapperton and Columbia Stations is expected to resume within the next 30-45 minutes. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @georgiastraight: TransLink says SkyTrain starting to resume service after technical issue http://t.co/cZuoQXByPp',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @BrentRein: Massive lines for busses at every corner of DT cuz of @TransLink skytrain issues http://t.co/X2LfyWs2H9',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'Guided #SkyTrain track tours could be a new revenue source for #TransLink.',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@translink will the expo line be running to KG or just waterfront??', 0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Service between Sapperton and Columbia Stations is expected to resume within the next 30-45 minutes. ^jkd',\n",
        "  0.0),\n",
        " (u\"@GlobalBC @MiguelRamosTV @TransLink Please ask if I can go to the garage soon. It's hot out here.\",\n",
        "  0.24253562503633297),\n",
        " (u'@CKNW @TransLink Hope the people are off the tracks before they start it up = #Translink is a joke.',\n",
        "  0.9428090415820635),\n",
        " (u'RT @CKNW: RT @TransLink: #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink Let me know if you want me to kick the #skytrain system with my non-commuter friendly shoes. http://t.co/0u4BNow2Da',\n",
        "  0.6882472016116852),\n",
        " (u'RT @TransLink: .@JennLo_ Canada Line is operating normally and is unaffected by the #Skytrain issue ^LA',\n",
        "  0.0),\n",
        " (u\"RT @TuneInChelsea: I'm seeing trains moving on the Expo line now @CKNW #translink\",\n",
        "  0.0),\n",
        " (u'IMO the best way into Surrey from Van is to catch the Canada Line into Richmond and bus into Surrey via the 301. @TransLink @SamarSKhan',\n",
        "  0.6),\n",
        " (u'RT @georgiastraight: RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few min\\u2026',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@toddstonebc u have veto power over @TransLink policy but r no comment during #skytrainproblems. Typical of ur \"Govern\"-ment.',\n",
        "  -0.23570226039551587),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink is waterfront station open?', 0.0),\n",
        " (u'@TransLink trains back up?', 0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"RT @jordanbateman: @WoodfordCKNW980 all those high paid execs and spinmeisters at TransLink &amp; it's the police chief making service announce\\u2026\",\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink #Translink - Did you make sure everyone is off the tracks before starting it up..................   @canadagraphs',\n",
        "  0.0),\n",
        " (u'@debb_li @TransLink just between VCC and Sapperton. NewWest or Surrey bound must bus or wait.',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"RT @torchwoodmlw: Why do we tolerate the bloated ineptitude of #translink? It's time for citizens to speak up and government step in. #tran\\u2026\",\n",
        "  0.0),\n",
        " (u'Shout out to all the #translink employees on the front lines who work hard to keep our city moving today and every day #vancouver',\n",
        "  -0.20412414523193154),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @AnthonyFloyd: This is fun/sad if true #skytrain #translink #commuterchaos #transitgeddon #trainpocalypse http://t.co/WuWB8sRCMh',\n",
        "  0.5547001962252291),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'Seriously glad I got a lift home from a coworker instead of bussing today....#yvr #translink #skytrainproblems',\n",
        "  0.75),\n",
        " (u'@TransLink finally I cannot spend $100 from downtown to surrey last time I end up with $50',\n",
        "  0.0),\n",
        " (u'does anyone know if @TransLink has a blacklist or something? ive sent four diff tweets to them in past 3 hours and received no response',\n",
        "  -0.2),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'Transit in Canada is incredible. They break down every week.  #transit #Translink #SkyTrain',\n",
        "  0.0),\n",
        " (u'RT @qdsworld: @translink This should work for any future outages on the #SkyTrain - Use it well, or all of the time if you prefer. http://t\\u2026',\n",
        "  0.0),\n",
        " (u\"@TransLink on one of the first trains for expo line. Screw you guys, I'm going home.\",\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @80sRockerChick: @TransLink Let me know if you want me to kick the #skytrain system with my non-commuter friendly shoes. http://t.co/0u4\\u2026',\n",
        "  0.6396021490668313),\n",
        " (u'@TransLink Thank you for your quick reply!', 0.7559289460184544),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @jordanbateman: TransLink execs are in a shiny new, pricy building, but SkyTrain riders are walking the rails during breakdowns. http://\\u2026',\n",
        "  0.0),\n",
        " (u'@TransLink Is the next bus texting thing dead too? Cuz it seems to be dead. I just need to know when the next bus is coming to 52075.',\n",
        "  -1.1338934190276817),\n",
        " (u'@TransLink got a bus from in front of hospital to new westminster station',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'Yay! RT @TransLink: #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Service between Sapperton and Columbia Stations is expected to resume within the next 30-45 minutes. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink all stations including braid and edmonds?', 0.0),\n",
        " (u'\\u201c@Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!\\u201d &lt;== \\U0001f602',\n",
        "  -0.4082482904638631),\n",
        " (u\"RT @negreiff: @TransLink on one of the first trains for expo line. Screw you guys, I'm going home.\",\n",
        "  0.0),\n",
        " (u\"RT @Korrax: Transit in #Vancouver is total garbage. So glad I don't use it anymore &amp; instead get to cruise around in my Mustang GT. @transl\\u2026\",\n",
        "  0.5773502691896257),\n",
        " (u'@TransLink Respect! Nothing you can do about the system, but good work on the damage control from the Social Media end.',\n",
        "  0.0),\n",
        " (u'Why is @TransLink telling @cknw that no comment avail by Execs as they r ALL out of town. Who approved THAT vacay schedule?',\n",
        "  0.20851441405707477),\n",
        " (u\"RT @gsbizzle: @TransLink why aren't people given refunds whenever skytrain has a meltdown? If a pay for a service and it doesn't work I wan\\u2026\",\n",
        "  -0.19611613513818404),\n",
        " (u'@TransLink you fail. #SkyTrain', -1.0),\n",
        " (u'There should be a free transit day for all this fail @TransLink',\n",
        "  -0.2886751345948129),\n",
        " (u\"i realize with the skytrain down they're receiving a high volume and will have a slow response but 3 hours seems too excessive @TransLink\",\n",
        "  0.0),\n",
        " (u'RT @CloverdaleGal: @TransLink #Translink - Did you make sure everyone is off the tracks before starting it up..................   @canadagr\\u2026',\n",
        "  0.0),\n",
        " (u'RT @liagarcia411: #Commuter Traffic: #translink suffers-complete system failure on #expo and millennium lines in #vancouver.  http://t.co/k\\u2026',\n",
        "  -0.48507125007266594),\n",
        " (u'@CityofVancouver @FabFrugalVan @VancouverPD might want to work with @TransLink  since they caused this mess',\n",
        "  -0.2672612419124244),\n",
        " (u'@canadagraphs @TransLink and also Young Drivers of Canada...lol', 0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'I have to use the Skytrain Thursday. I wonder if should just avoid using it until Translink fixes their computer problem.',\n",
        "  -0.6546536707079772),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@canadagraphs @TransLink I think we have the old Go Train once owned by Toronto, now in BC...lol',\n",
        "  0.0),\n",
        " (u'@TransLink The gate was open.', 0.0),\n",
        " (u\"@TransLink Waited 20min at the front of line for 135SFU. Bus starts boarding behind the 135Kootney so I'm still waiting. What awful service.\",\n",
        "  -0.6255432421712244),\n",
        " (u'@natbajkov @TransLink  right get your money back...#translink', 0.0),\n",
        " (u\"On a separate note, no damn clue how I'm getting to school tomorrow morning. Best be up &amp; running by then @TransLink ! #translink\",\n",
        "  -0.41702882811414954),\n",
        " (u'RT @CKNW: RT @TransLink: #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@jordanbateman @WoodfordCKNW980 TransLink does have billion $ plan to upgrade the Expo Line. Firing CEO unlikely to prevent computer failure',\n",
        "  -1.1470786693528088),\n",
        " (u'As much as I hate translink, I admire all the staff that took the time to make sure everyone was calm &amp; helped redirect their travel routes.',\n",
        "  0.3849001794597505),\n",
        " (u\"@TransLink we haven't seen 301 in 45 mind...500+ people waiting\", 0.0),\n",
        " (u'RT @BCBerrie: \\u201c@Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!\\u201d &lt;== \\U0001f602',\n",
        "  -0.4),\n",
        " (u\"Due to today's problems, @translink has come put with our next generation, Eco-friendly train design. http://t.co/ZaWlU8lGkJ\",\n",
        "  -0.5),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"Despite all the technical issues today, I'm sure glad @TransLink has a twitter account with people who care about the service #youdabest\",\n",
        "  1.0660035817780522),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'Nice @TransLink time to fire people starting at the top!',\n",
        "  0.9486832980505138),\n",
        " (u'TransLink says SkyTrain starting to resume service after technical issue http://t.co/lyYqlVrZNF',\n",
        "  0.0),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'@TransLink thanks for all of your hard work! Finally got into the train from waterfront #almosthome',\n",
        "  0.25),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Service between Sapperton and Columbia Stations is expected to resume within the next 30-45 minutes. ^jkd',\n",
        "  0.0),\n",
        " (u\"Due to today's problems, @translink has come out with a next generation, Eco-friendly train design. http://t.co/2Brn3kidiH\",\n",
        "  -0.5),\n",
        " (u\"@GlobalBC so your crew can't make it to speak to @TransLink COO but can't you pick up a phone? I want to hear the excuse he has this time\",\n",
        "  0.0),\n",
        " (u'@TranBC @MainroadLM @TransLink Are you guys fixing the crap re-paving from last year? Or just doing more crappy re-paving again this year?',\n",
        "  -0.6396021490668313),\n",
        " (u'@TransLink buses are fun! Lol', 3.1304951684997055),\n",
        " (u'RT @GlobalBC: MT @miguelramostv: Just spoke with BC Trans Min -  refusing to comment re: skytrain shutdown because it\\'s @TransLink \"operati\\u2026',\n",
        "  -0.4364357804719848),\n",
        " (u'Fuck translink', -2.82842712474619),\n",
        " (u'Hate translink... Stuck at this bus stop listening to this guy switch from venting about the busses and telling me I should be a nurse \\U0001f64d',\n",
        "  -1.1766968108291043),\n",
        " (u'@TransLink driver in bus S8001 was amazing, made a terrible transit experience  great fun.',\n",
        "  2.138089935299395),\n",
        " (u'@TransLink are all stations open and operating again?', 0.0),\n",
        " (u'RT @belinda411: There should be a free transit day for all this fail @TransLink',\n",
        "  -0.2672612419124244),\n",
        " (u\"@girafficus @TransLink We are so spoiled and entitled here in Vancouver, that the second anything goes wrong, It's the worst thing ever!\",\n",
        "  -0.8528028654224417),\n",
        " (u'RT @jpchow: Meanwhile in @translink skytrain control...  http://t.co/Rkb3wPzSOH',\n",
        "  0.0),\n",
        " (u'RT @liagarcia411: #Commuter Traffic: #translink suffers-complete system failure on #expo and millennium lines in #vancouver.  http://t.co/k\\u2026',\n",
        "  -0.48507125007266594),\n",
        " (u'In these instances @TransLink needs to increase the # of 100-22nd Stn busses to accommodate the displaced Surrey travelers',\n",
        "  0.23570226039551587),\n",
        " (u'RT @TransLink: : #SkyTrain UPDATE Stations are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"@matthewlaird @TransitPolice @TransLink Little ones in cages/carry-bags aren't so bad. Feel sad for dogowners. 'Have dog, can't travel':(\",\n",
        "  -1.1785113019775793),\n",
        " (u'Does anyone from @TransLink deal with public transit? #vancouver #translink #skytrainproblems',\n",
        "  0.0),\n",
        " (u'#SkyTrain is now fully operational. Expect residual delays and long line ups. #TransLink #Alert #BackOn #ThankYou for your patience!',\n",
        "  -0.22941573387056174),\n",
        " (u\"40% success rate of @TransLink's #Skytrain in the last 5 days has me reconsidering not getting my helicopter pilot license. #GetToTheChoppah\",\n",
        "  0.4364357804719848),\n",
        " (u'RT @lauriephipps: Nice @TransLink time to fire people starting at the top!',\n",
        "  0.8660254037844387),\n",
        " (u'RT @CTVVancouver: #Breaking: TransLink says Expo Line should start operating at 5:05, with full service returning by 5:45. http://t.co/Xct4\\u2026',\n",
        "  0.0),\n",
        " (u'RT @lauriephipps: Nice @TransLink time to fire people starting at the top!',\n",
        "  0.8660254037844387),\n",
        " (u'I like the way a lot the media talk about transit but most drive to and from work. Just ask them.  #SkyTrain #translink',\n",
        "  0.41702882811414954),\n",
        " (u\"Yup. Great work! MT @ryanventura604: Although the system has been down for hours, I give props to @translink's social media department today\",\n",
        "  0.6396021490668313),\n",
        " (u'RT @bbcgregory: #SkyTrain is now fully operational. Expect residual delays and long line ups. #TransLink #Alert #BackOn #ThankYou for your \\u2026',\n",
        "  -0.2182178902359924),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@PeterMeiszner Probably waiting for the skytrain and someone lost it, thanks a lot translink!',\n",
        "  -0.2672612419124244),\n",
        " (u'@TransLink what will you offer to stranded passengers this time How about some free service for the remainder of the day #DontGetYourHopesUp',\n",
        "  0.21320071635561041),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'Thanks translink for being garbage. I really love having a man 3 times my size push me to get on the train. Then lean on me! Awesome.',\n",
        "  1.7320508075688772),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TanyaNews1130: UPDATE: .@TransLink expects Expo Line service to resume within a few minutes. Stay with @News1130Radio for complete #sky\\u2026',\n",
        "  0.0),\n",
        " (u'I\\'m thinking that tomorrow should be a \"FREE\" travel day for all transit users @TransLink',\n",
        "  0.2581988897471611),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@translink #SkyTrains are up and running in all directions .', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @EduCoello: The next station is Columbia #skytrainproblems #translink http://t.co/jczN0l0D1g',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@GlobalBC hahahahahahahahahaha refund???? @TransLink give refunds??!! They\\'re gonna want more money now to \"upgrade\"their shit computers',\n",
        "  -0.75),\n",
        " (u'RT @CTVVancouver: #Breaking: TransLink says Expo Line should start operating at 5:05, with full service returning by 5:45. http://t.co/Xct4\\u2026',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @News1130radio: @translink #SkyTrains are up and running in all directions .',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@VanCityVilla how about 2 days of free travel on Skytrain as a gesture of good will from Translink?',\n",
        "  0.9428090415820635),\n",
        " (u'@CityofVancouver are you or @TransLink covering the cost?', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@TransLink just dissapointed', 0.0),\n",
        " (u'RT @LauraCoughlan: I\\'m thinking that tomorrow should be a \"FREE\" travel day for all transit users @TransLink',\n",
        "  0.24253562503633297),\n",
        " (u'Maybe @TransLink should invest less $ in useless rent-a-cops &amp; more in the actual system. #glorifiedticketcheckers #poorresourceallocation',\n",
        "  -0.5),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'\\u201c@TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd\\u201d \\U0001f62d\\U0001f64f\\U0001f64f\\U0001f64f\\U0001f64f',\n",
        "  -0.22360679774997896),\n",
        " (u'@ChiefNeilDubord @TransitPolice I say free transit all day Saturday for the fireworks. To say your sorry @TransLink @TransLinkMedia @cknw',\n",
        "  0.0),\n",
        " (u'RT @News1130radio: @translink #SkyTrains are up and running in all directions .',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @lizaCKNW980: Transit users walking on track to Main Street #skytrain after 30 min on stopped train. @TransLink http://t.co/Nllb0CXmdn',\n",
        "  -0.22941573387056174),\n",
        " (u'2 skytrain failures highlight need for investment in #Translink - Lib Minister Stone silent except to say no to funding #transit #bcpoli',\n",
        "  -0.2182178902359924),\n",
        " (u'@GlobalBC @TransLink Did the anarchists try to hack into the system and create anarchy?',\n",
        "  0.0),\n",
        " (u'RT @GlobalBC: RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. \\u2026',\n",
        "  -0.2182178902359924),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@TransLink #fail', -1.414213562373095),\n",
        " (u'@GlobalBC @MiguelRamosTV @TransLink You could say he threw them under the bus on that one. No? #TooSoon',\n",
        "  -0.24253562503633297),\n",
        " (u'.@Lazin_Ryder @TransLink Fallout of an underfunded transit system?', 0.0),\n",
        " (u'@TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.23570226039551587),\n",
        " (u'MT @TransLink: #SkyTrain E-Line &amp; M-Line back to regular service. Thank you for your patience and sorry for the inconvenience',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @DanaKellyCBC: Crowded bus of ppl trying to get to downtown from New West. #cbc #SkyTrain @TransLink http://t.co/yFXhgVzRFr',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'SKYTRAIN: le service est maintenant compl\\xe8tement repris sur la ligne Expo et la ligne Millenium. Via @TransLink',\n",
        "  0.0),\n",
        " (u'RT @News1130radio: @translink #SkyTrains are up and running in all directions .',\n",
        "  0.0),\n",
        " (u'RT @VancouverPD: MT @TransLink: #SkyTrain E-Line &amp; M-Line back to regular service. Thank you for your patience and sorry for the inconvenie\\u2026',\n",
        "  0.20851441405707477),\n",
        " (u\"RT @BigNasty604: Yet again, I'm very thankful I don't use skytrain on my commute any more.Pathetic excuse for a public transportation syste\\u2026\",\n",
        "  0.20851441405707477),\n",
        " (u'\\u201c@TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd\\u201d',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u\"@schneidz @girafficus @TransLink Yeah, but Pavlov's dog, fool me once, dejavu, associative states, been there done that. I could go on.\",\n",
        "  -0.2182178902359924),\n",
        " (u'@TransLink No inconvenience at all! It was nice to have a siesta.', 0.0),\n",
        " (u'#Breaking: Expo and Millennium SkyTrain lines are back to regular service, TransLink says. http://t.co/7yZaUfBLMB',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u\"Shitty skytrain service paired with slow buses that are never clean.. That's #translink in vancouver\",\n",
        "  -0.2581988897471611),\n",
        " (u'#YVR Skytrain is back up and running again in both directions (full service)! Just in time 2 get u home. follow @TransLink for info!',\n",
        "  0.0),\n",
        " (u'@TransLink oh and free rides or your   F**ck ups? #NotAChance #ThanksIsNotEnough',\n",
        "  0.30151134457776363),\n",
        " (u\"Today is the day I'm thankful a migraine caused me to miss work so I didn't get stuck in the shitshow that is @TransLink's #skytrainproblems\",\n",
        "  -0.4),\n",
        " (u\"RT @MornaEGregory: #Translink's Help Wanted ad on Craigslist LOL (stolen from @kimli) #skytrain http://t.co/RhD0Ylhd81\",\n",
        "  0.8017837257372732),\n",
        " (u\"RT @TuneInChelsea: I'm seeing trains moving on the Expo line now @CKNW #translink\",\n",
        "  0.0),\n",
        " (u'RT @CTVVancouver: #Breaking: Expo and Millennium SkyTrain lines are back to regular service, TransLink says. http://t.co/7yZaUfBLMB',\n",
        "  0.0),\n",
        " (u'@News1130radio @TransLink As someone who pays for a 3 zone pass every month..THIS IS UNACCEPTABLE!!! #translink #SkyTrain #fail #GETITRIGHT',\n",
        "  -0.917662935482247),\n",
        " (u'UPDATE: From @Translink website: Skytrain is back to running normal service on both Expo and Millennium Lines.',\n",
        "  0.0),\n",
        " (u\"I was told that the outside of Translink buses is washed once a year.. Inside.. Don't even wanna know.. #translinkproblems\",\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @CTVVancouver: #Breaking: Expo and Millennium SkyTrain lines are back to regular service, TransLink says. http://t.co/7yZaUfBLMB',\n",
        "  0.0),\n",
        " (u'With all the @TransLink #skytrain problems, getting around #vancouver @SpokesVancouver #bike @deepcovekayak would be easier &amp; way more fun!',\n",
        "  0.4588314677411235),\n",
        " (u\"Translink called this morning to thank for submitting kudos to a worker during Thursday's SkyTrain outage so I guess I can overlook today's?\",\n",
        "  1.0425720702853738),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @translink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @translink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'.@Translink\\'s Doug Kelsey says #skytrain problem \"under investigation\" early indication is a possible short circuit on a board \"somewhere\"',\n",
        "  -0.4588314677411235),\n",
        " (u'.@Translink\\'s Doug Kelsey says #skytrain problem \"under investigation\" early indication is a possible short circuit on a board \"somewhere\"',\n",
        "  -0.4588314677411235),\n",
        " (u'@TransLink scratch my last q. Things are moving fine.',\n",
        "  0.6666666666666666),\n",
        " (u\"The #CanadaLine. Don't do it. #Translink #Vancouver\", 0.0),\n",
        " (u'RT @GeorgeHeyman: 2 skytrain failures highlight need for investment in #Translink - Lib Minister Stone silent except to say no to funding #\\u2026',\n",
        "  -0.21320071635561041),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @CTVVancouver: #Breaking: Expo and Millennium SkyTrain lines are back to regular service, TransLink says. http://t.co/7yZaUfBLMB',\n",
        "  0.0),\n",
        " (u\"@MsNWimby @Lazin_Ryder indeed, if Kevin Falcib hadn't force @TransLink to waste so much money on faregates...for near nonexistent evasion...\",\n",
        "  -0.22941573387056174),\n",
        " (u'@JDarwin @TransLink So how long was that #Skytrain shutdown? Three hours?',\n",
        "  0.0),\n",
        " (u'RT @CTVVancouver: #Breaking: TransLink says Expo Line should start operating at 5:05, with full service returning by 5:45. http://t.co/Xct4\\u2026',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'\\u201c@TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for inconvenience. ^jkd\\u201d - 5+ hours later.',\n",
        "  -0.2182178902359924),\n",
        " (u'@News1130radio @TransLink system failure?? Someone just tripped over the plug that was supposed to be duct taped to the carpet!!',\n",
        "  -0.4472135954999579),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @phoneyman: @djtripd @MayorGregor when I look at my Hydro bill, income tax, and other mandatory sources of #TransLink funding, it looks \\u2026',\n",
        "  -0.20851441405707477),\n",
        " (u'@always_vote @girafficus @TransLink HUH? Maybe I just didnt understand some referneces? But that tweet made absolutely ZERO sense to me! lol',\n",
        "  0.6546536707079772),\n",
        " (u'RT @Sia_Adjudani: @News1130radio @TransLink As someone who pays for a 3 zone pass every month..THIS IS UNACCEPTABLE!!! #translink #SkyTrain\\u2026',\n",
        "  -0.4472135954999579),\n",
        " (u\"@TransLink yay I can stop helping folks with directions, but if u r hiring it's a fun job :) and I'd apply :)\",\n",
        "  1.0660035817780522),\n",
        " (u'RT @TransLink: @WaderMacD #SkyTrain E-Line,M-Line back to regular service. ^jkd',\n",
        "  0.0),\n",
        " (u'@Lord_Bob the problem is more Translink IMO. They need to improve the redundancies in the system. Most websites have better computer uptime!',\n",
        "  0.42640143271122083),\n",
        " (u'Translink tweets thank you for your patience. LMAO. A sorry was enough.',\n",
        "  1.4433756729740645),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u\"Translink spends millions on useless tkt machines, can't keep skytrain running or provide reasonable shuttles @TransLink #firetranslinkboard\",\n",
        "  -0.48507125007266594),\n",
        " (u\"@CKNW @TransLink It's a little to the left.\", 0.0),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u\"@GlobalBC @TransLink We should all be ashamed for allowing  Translink's pathetic performance to continue. #breachofcontract\",\n",
        "  -1.0327955589886444),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: @WaderMacD #SkyTrain E-Line,M-Line back to regular service. ^jkd',\n",
        "  0.0),\n",
        " (u'RT @GlobalBC: RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. \\u2026',\n",
        "  -0.2182178902359924),\n",
        " (u\"Translink..... what's the deal? Do we get a rebate?\", 0.0),\n",
        " (u\"The next c9 bus says on the website that it's 27 minutes away... Say it isn't so @translink is there one sooner?\",\n",
        "  0.0),\n",
        " (u\"@CKNW @TransLink That's pretty fucking vague Doug. You gotta do better then that Doug. #translink\",\n",
        "  -0.7745966692414834),\n",
        " (u'RT @24604tv: With all the @TransLink #skytrain problems, getting around #vancouver @SpokesVancouver #bike @deepcovekayak would be easier &amp; \\u2026',\n",
        "  -0.4588314677411235),\n",
        " (u'RT @Sia_Adjudani: @News1130radio @TransLink As someone who pays for a 3 zone pass every month..THIS IS UNACCEPTABLE!!! #translink #SkyTrain\\u2026',\n",
        "  -0.4472135954999579),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'Hey All. Good news!!  Skytrain is back to regular service! Let give a round of applause to @TransLink for all their hard work :)',\n",
        "  0.8164965809277261),\n",
        " (u'\\u201c@TransLink: #SkyTrain E-Line,M-Line back to regular service.\\u201d NEVER BEEN SO STOKED TO HAVE LEFT VANCOUVER!',\n",
        "  0.0),\n",
        " (u'@rfilippone I have a feeling that #TransLink management has been taken over by aliens. Or, by Darth Vader. Disruptions too frequent. #CBC',\n",
        "  -0.21320071635561041),\n",
        " (u'Wonder what Translink is going to do to make it up to their customers for a week of fuck ups besides the obvious nothing',\n",
        "  -0.8164965809277261),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u\"Translink can't keep trains running and will shut down the only untolled bridge, Patullo, for an entire weekend. @TransLink #letthemhavecake\",\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'What is being done to address #SkyTrain failures? We ask the COO @Translink @GlobalBC coming up on News Hour',\n",
        "  -0.4588314677411235),\n",
        " (u'@translink #SkyTrain  Planning to commute tomorrow, Wednesday on E,M-lines. Any word on if further probs are expected or if glitch fixed???',\n",
        "  0.0),\n",
        " (u\"@TransLink Keep transit tickets as proof you were on transit today.  How many were  going to doctor's appt and missed specialists appts\",\n",
        "  -0.42640143271122083),\n",
        " (u'. @TransLink\\'s Doug Kelsey says \"two incidents doesn\\'t make a trend, 6-8 billion dollar system there is going to be technical glitches.\"',\n",
        "  0.0),\n",
        " (u'. @TransLink\\'s Doug Kelsey says \"two incidents doesn\\'t make a trend, 6-8 billion dollar system there is going to be technical glitches.\"',\n",
        "  0.0),\n",
        " (u'@TransLink because of the  skytrain. How many people actually needed to go to the washroom while  they were stuck on skytrain today.',\n",
        "  -0.42640143271122083),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@CKNW how is it that @TransLink has fixed the problem if they\\u2019re still don\\u2019t know what exactly the problem was?',\n",
        "  -0.8528028654224417),\n",
        " (u'@schneidz @girafficus Maybe @translink, @skytrainprez will understand it. Shorter: people are mad as hell.',\n",
        "  -1.8708286933869707),\n",
        " (u\"@TransLink @GlobalBC you pay for a service in the form of taxes then pay to use that service you've paid for.they fu&amp;@in u twice, no lube\",\n",
        "  -0.5883484054145521),\n",
        " (u'RT @CKNW: . @TransLink\\'s Doug Kelsey says \"two incidents doesn\\'t make a trend, 6-8 billion dollar system there is going to be technical gli\\u2026',\n",
        "  0.0),\n",
        " (u\"@TransLink How many people missed appts which  might cost you financially because of skytrain?  I'm just wondering  about the stories out\",\n",
        "  -0.4364357804719848),\n",
        " (u'RT @GeorgeHeyman: 2 skytrain failures highlight need for investment in #Translink - Lib Minister Stone silent except to say no to funding #\\u2026',\n",
        "  -0.21320071635561041),\n",
        " (u'Waiting for 44 bus at ubc to be told by a driver that buses have been pulled to be bus bridges and to expect delays @TransLink.',\n",
        "  0.0),\n",
        " (u'Translink on mission 2 punish poor with tolls and unreliable transit More focused on image @TransLink #firetranslinkboard #letthemhavecake',\n",
        "  -0.47140452079103173),\n",
        " (u'RT @michaelgeller: It takes a @TransLink crisis to bring some common sense to local taxi industry. @stevecbc reports Metro area taxis can p\\u2026',\n",
        "  -0.6123724356957946),\n",
        " (u'@TransLink   about the stories out there involving those affected by skytrain  disruption.',\n",
        "  -0.8660254037844387),\n",
        " (u\"@TransLink there's around 30 people waiting for the 100 22nd Street at #52140 and 3 full buses have gone by without letting anyone on :(\",\n",
        "  0.0),\n",
        " (u'Get yo act together Translink  \\u0ca0__\\u0ca0', 0.0),\n",
        " (u'@TransLink @CKNW can you bring more 100 buses for 22nd st to Marine Dr. station?',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u\"First #translink shuts down the #SkyTrain lines. Now I'm pouring water on a fire under the bridge at Commercial &amp; Broadway. #vancouver\",\n",
        "  -0.42640143271122083),\n",
        " (u'RT @ShelbyThom980: . @TransLink\\'s Doug Kelsey says \"two incidents doesn\\'t make a trend, 6-8 billion dollar system there is going to be tech\\u2026',\n",
        "  0.0),\n",
        " (u'fucking bullshit #skytrain service today @TransLink! get your fucking shit together, god damn gongshow!',\n",
        "  -5.077963596336064),\n",
        " (u'RT @CTVVancouver: #Breaking: Expo and Millennium SkyTrain lines are back to regular service, TransLink says. http://t.co/7yZaUfBLMB',\n",
        "  0.0),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'. @TransLink says \"we will have to earn our customers trust back\" after 4.5 hour system-wide sky train shut down. @cknw',\n",
        "  0.2182178902359924),\n",
        " (u'. @TransLink says \"we will have to earn our customers trust back\" after 4.5 hour system-wide sky train shut down. @cknw',\n",
        "  0.2182178902359924),\n",
        " (u\"@jasonbl13 @TransLink Keep transit tickets as proof you were on transit today.  How many were  going to doctor's appt and missed specialist.\",\n",
        "  -0.42640143271122083),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'@CKNW @TransLink so basically... \"shit happens\" #translink #SkyTrain',\n",
        "  -1.414213562373095),\n",
        " (u\"Good to hear both @TransLink's #Skytrain Expo / Millennium Lines have resumed normal service: https://t.co/YrJhOPa3FY\",\n",
        "  0.8017837257372732),\n",
        " (u'@translink is the north-bound #08 still happening?', 0.0),\n",
        " (u'RT @CKNW: . @TransLink says \"we will have to earn our customers trust back\" after 4.5 hour system-wide sky train shut down. @cknw',\n",
        "  0.21320071635561041),\n",
        " (u'@TransLink', 0.0),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'#Breaking: Expo and Millennium SkyTrain lines are back to regular service, TransLink says. #Translinkproblems #again',\n",
        "  0.0),\n",
        " (u'TransLink suffers another complete system failure on Expo and Millennium lines http://t.co/vltaqbN9Bm',\n",
        "  -1.1547005383792517),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @qdsworld: @translink This should work for any future outages on the #SkyTrain - Use it well, or all of the time if you prefer. http://t\\u2026',\n",
        "  0.0),\n",
        " (u'@CKNW @TransLink Understatement of the last century and a half', 0.0),\n",
        " (u'\"@CKNW: . @TransLink says \"we will have to earn our customers trust back\" after 4.5 hour system-wide sky train shut down. @cknw\"',\n",
        "  0.2182178902359924),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'@TransLink Doug Kelsey says \"two incidents doesn\\'t make a trend\", but 2 in 4 days makes the ridership Pee\\'d off! #DudeWheresMyCar',\n",
        "  0.0),\n",
        " (u\"Anyone braving #skytrain at Stadium who has eyes on what it's actually like out there? @TransLink\",\n",
        "  0.5),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u\"RT @KevinCawthra: If you're paying BILLIONS of dollars for a transit system, there better be no glitches at all.....@TransLink\",\n",
        "  0.22941573387056174),\n",
        " (u'Maybe #Fiji instead?! Might see them. RT @MikeMartignago: Found at TransLink offices... http://t.co/7V11XdeQXp',\n",
        "  0.0),\n",
        " (u'@TransLink is seriously making me so irritated lol', 0.0),\n",
        " (u'@MayorGregor transit was now privatized (thx for that). If you want funding and accountability, unprivatize it. #translink #bcpoli #vancity',\n",
        "  0.22941573387056174),\n",
        " (u\"RT @pieface2010: @jasonbl13 @TransLink Keep transit tickets as proof you were on transit today.  How many were  going to doctor's appt and \\u2026\",\n",
        "  0.0),\n",
        " (u'Inserting Facebook #translink complaint here..', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @VIAwesome: Are you there, @Uber_VAN? MT @VancouverPD: Taxi enforcement suspended until further notice to assist ppl with an other way h\\u2026',\n",
        "  -0.20851441405707477),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'\"@TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience\" Yay! Thanks for the updates :)',\n",
        "  0.9428090415820635),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @TransLink: @WaderMacD #SkyTrain E-Line,M-Line back to regular service. ^jkd',\n",
        "  0.0),\n",
        " (u\"@GWoloski84 @CKNW @TransLink That's basically same attitude @Lazin_Ryder got.\",\n",
        "  0.0),\n",
        " (u'Thanks for the delay @TransLink - great excuse to go to @SteamworksPub for dinner! http://t.co/W3He0xyOy1',\n",
        "  0.8017837257372732),\n",
        " (u'RT @lailayuile: Feeling( not-so)guilty we made pie with freshly picked blackberries while #translink ruined the world... #bcpoli http://t.c\\u2026',\n",
        "  -0.22941573387056174),\n",
        " (u\"@TransLink How many people were on skytrain and didn't bother paying for their fare?  You don't have a right to complain if you were steal.\",\n",
        "  -1.2),\n",
        " (u'RT @adam_theriault: Maybe #TransLink could try turning #SkyTrain off and then on again...',\n",
        "  0.0),\n",
        " (u'RT @WoodfordCKNW980: .@Translink\\'s Doug Kelsey says #skytrain problem \"under investigation\" early indication is a possible short circuit on\\u2026',\n",
        "  -0.4588314677411235),\n",
        " (u'.@ShelbyThom980 does SkyTrain going down once every 2.5 days make a trend? 3 x 45+ minute disruptions/month? http://t.co/2lL2Z7Hann',\n",
        "  0.0),\n",
        " (u'TRANSLINK ...epic fail...', -1.1547005383792517),\n",
        " (u'RT @VanCityVilla: Hey #Translink have you tried turning the SkyTrain system off and on again #ITCrowd http://t.co/jXwZ9iRFYD',\n",
        "  0.0),\n",
        " (u'@CKNW @TransLink what if the system was a million dollar system? Still glitches? Design is not relevant?',\n",
        "  0.0),\n",
        " (u\"@TransLink no, no more buses have come by since then. One lady says 3 buses hve already passed her b4 I got here so that's 5 for her :/\",\n",
        "  -0.3713906763541037),\n",
        " (u'. @Phanyxx @TransLink @ying778  Also try shutting everything down, wait 30 seconds &amp; restart. #TranslinkDown',\n",
        "  0.0),\n",
        " (u\"Hey @TransLink look how many people are waiting for the #301 bus. It's crazy! #Brighouse http://t.co/1U5CPH0czX\",\n",
        "  -0.5),\n",
        " (u'RT @kesrows: \"Come walk the elevated promenade and stay in one of our bungalows overlooking scenic Vancouver.\" -Tourism BC takes over Trans\\u2026',\n",
        "  0.0),\n",
        " (u'@TransLink No washrooms on the skytrain? what do you do if you are stuck?',\n",
        "  -0.8017837257372732),\n",
        " (u'@CKNW @TransLink Duh!!!', 0.0),\n",
        " (u'RT @CKNW: . @TransLink\\'s Doug Kelsey says \"two incidents doesn\\'t make a trend, 6-8 billion dollar system there is going to be technical gli\\u2026',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u\"@WaderMacD @TransLink I'd apply too, but I'd stir the pot too much and get fired.\",\n",
        "  -0.5163977794943222),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'Or protesting in front of @TransLink MT @CityofVancouver: As #SkyTrain comes back up consider delaying your commute 2 allow backlog 2 pass',\n",
        "  -0.21320071635561041),\n",
        " (u'.@transLink breakdowns may erode public confidence: former TransLink chair http://t.co/IbiSQcG9jp',\n",
        "  0.6324555320336759),\n",
        " (u'@cbcnewsbc @TransLink Thanks guys, now I can go home.',\n",
        "  0.6666666666666666),\n",
        " (u'#SkyTrain systemwide breakdown 2 frequent. Escalators break down almost daily. #TransLink executive pay needs to go up 2 solve the problem.',\n",
        "  -0.4364357804719848),\n",
        " (u'Thanks to friendly @TransLink bus drivers/commuters for helping people re-route &amp; giving up seats to others in need! #skytrain #translink',\n",
        "  1.3416407864998738),\n",
        " (u'RT @VancouverPD: MT @TransLink: #SkyTrain E-Line &amp; M-Line back to regular service. Thank you for your patience and sorry for the inconvenie\\u2026',\n",
        "  0.20851441405707477),\n",
        " (u'RT @lizaCKNW980: Transit users walking on track to Main Street #skytrain after 30 min on stopped train. @TransLink http://t.co/Nllb0CXmdn',\n",
        "  -0.22941573387056174),\n",
        " (u'Hahaha #translink is a joke and no one is laughing.', 1.5811388300841895),\n",
        " (u'Seeing the track record of @TransLink  the past 2 weeks. I expect another system failure or switch issue soon',\n",
        "  -0.4588314677411235),\n",
        " (u'Young asian mom has 6weeks2find stem cell/bone marrow to live. http://t.co/BcSuAP6YpY @VancityBuzz @TransLink @shaymitch help retweet plz',\n",
        "  0.48507125007266594),\n",
        " (u'@TahsisKen @lailayuile @flyfish4lyfe ~95% of power in TransLink is held by unelected board now.',\n",
        "  0.0),\n",
        " (u'RT @kathryn_stew: I just imagine @Translink staff sighing and flipping a \"Days Since Last #Skytrain shutdown\" sign back to 0.',\n",
        "  0.0),\n",
        " (u\"Or they're. #vancouver translink @ VCC\\u2013Clark Station http://t.co/vREpgqTGwT\",\n",
        "  0.0),\n",
        " (u'FUBAR the other 5% I guess \"@skytrainprez: #SkyTrain is on time 95% of the time.#WhatsTheLink http://t.co/6ght9yfr7j http://t.co/SGX7fHDdgm\"',\n",
        "  0.0),\n",
        " (u'@always_vote @lailayuile @daka_x @TransLink where in Australia? There is no one transit system there.',\n",
        "  -0.2672612419124244),\n",
        " (u\"Dear Taxi Companies,\\nYou're welcome.\\n\\nLove, TransLink\",\n",
        "  2.6457513110645903),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!',\n",
        "  -0.42640143271122083),\n",
        " (u'S/O to all @translink personnel during the shut down.', 0.0),\n",
        " (u'How are the trains looking now #vancouver @TransLink ? Should I delay taking the train back to Richmond at this point? #SkyTrain',\n",
        "  -0.2182178902359924),\n",
        " (u'#translink is this a plan to defund public transport &amp; make tax payers responsible for it, meaning paying for privatisation? Frustration!',\n",
        "  0.0),\n",
        " (u'@TransLink Know most employees could not help this but really we need to cut trans upper salaries and really go after fare evasion.',\n",
        "  0.20851441405707477),\n",
        " (u'RT @tlupick: Photos: #SkyTrain technical issues leave riders stranded on the tracks http://t.co/sKs9biBdKy Lots of @TransLink pics http://t\\u2026',\n",
        "  -0.22941573387056174),\n",
        " (u\"Ahhh, Translink. So many thoughts but I'll keep to myself.\",\n",
        "  -0.6324555320336759),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'Probably not a good time to highlight that the #eastside10k starts and finishes right at the Stadium #skytrain #translink station.',\n",
        "  1.118033988749895),\n",
        " (u'@ShelbyThom980 @TransLink I guess when you\\'re NOT stuck for hours, \"technical glitches\" is a good way to put it.',\n",
        "  0.22941573387056174),\n",
        " (u\"@TransLink why wouldn't you have added a bus bridge from dt van to commercial so those of us taking Mline could actually get there??\",\n",
        "  0.0),\n",
        " (u'RT @News1130radio: @translink says M line could have started up earlier but doors were damaged by ppl who forced them open and walked on tr\\u2026',\n",
        "  -0.19611613513818404),\n",
        " (u'#Skytrain is crowded but that doesn\\u2019t stop commuters from giving up seats to people in need. Stay awesome #vancouver #translink',\n",
        "  0.6546536707079772),\n",
        " (u'RT @Eastside10k: Probably not a good time to highlight that the #eastside10k starts and finishes right at the Stadium #skytrain #translink \\u2026',\n",
        "  1.0660035817780522),\n",
        " (u'@TransLink should record an apology and play it for the next couple of days on the speaker IMO',\n",
        "  -0.23570226039551587),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u'RT @Cas_Oli: \\u201c@TransLink: #SkyTrain E-Line,M-Line back to regular service.\\u201d NEVER BEEN SO STOKED TO HAVE LEFT VANCOUVER!',\n",
        "  0.0),\n",
        " (u'@CityofVancouver @GlobalBC #vancouver At last Happy Hour has a use! Tnk you Christi Clark and of course TransLink not! ;-)',\n",
        "  0.6708203932499369),\n",
        " (u'#translink the biggest disgrace in #vancouver BC http://t.co/so6D9Fitog',\n",
        "  -0.7071067811865475),\n",
        " (u'@lailayuile I have this feeling #TransLink executives are too underpaid to worry about these pesky problems. Who cares about poor commuters!',\n",
        "  -1.3093073414159544),\n",
        " (u'.@CKNW @TransLink So Doug Kelsey has just recently begun to count the incidents? #bettertransitnow',\n",
        "  0.0),\n",
        " (u'@Heatheranner I offered my skytrain computer kicking services to @TransLink. The train suddenly began to work. http://t.co/ZVIMXBI9W4',\n",
        "  0.0),\n",
        " (u'2nd major system collapse in a week. Are you kidding me?? @TransLink',\n",
        "  -0.5773502691896258),\n",
        " (u\"@lizaCKNW980 @ILiveInEastVan @TransLink or a week! I'm not even in Vancouver at the moment but I understand the frustration of commuters\",\n",
        "  -0.4364357804719848),\n",
        " (u'RT @hosea24hours: Thanks to Translink, these people are out enjoying the sun rather than stuck in a stuffy skytrain MT @Ufcvancouverbc: htt\\u2026',\n",
        "  0.41702882811414954),\n",
        " (u'RT @hosea24hours: \"Why ride when you can walk?\" Translink\\u2019s new motto. #skytrain',\n",
        "  0.0),\n",
        " (u\"@_Cuddlefish_ @lailayuile @daka_x @TransLink Well, that's what she said. Don't know woman's name @Lazin_Ryder interviewed on OntheCoast tho'\",\n",
        "  0.0),\n",
        " (u\"@TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\", 0.0),\n",
        " (u'@TransLink you guys gotta get ur sh** together. Second time in less than a week. Should be giving monthly pass refunds #dissapointed',\n",
        "  0.0),\n",
        " (u\"@TransLink driving EB next to the skytrain. Seeing no trains going EB within Surrey.  Not sure how that's full service\",\n",
        "  -0.22360679774997896),\n",
        " (u'When I see people react to a 4.5 hour #translink delay, I fear the chaos that will occur when our overdue natural disaster hits.',\n",
        "  -1.2247448713915892),\n",
        " (u'.@jordanbateman @ShelbyThom980 + how many are delayed each time? Surely several hundred thousand hrs lost each month. #translink',\n",
        "  -0.9701425001453319),\n",
        " (u'@80sRockerChick @TransLink yipee! My fingers are crossed for you! \\u270c\\ufe0f',\n",
        "  0.0),\n",
        " (u'@always_vote I\\u2019d love to know which city, because it is definitely not my experience. @lailayuile @daka_x @TransLink @Lazin_Ryder',\n",
        "  0.6882472016116852),\n",
        " (u'Tomorrow should be FREE travel day #skytrain @TransLink',\n",
        "  0.35355339059327373),\n",
        " (u\"RT @BigNasty604: @CKNW @TransLink That's pretty fucking vague Doug. You gotta do better then that Doug. #translink\",\n",
        "  -0.7276068751089989),\n",
        " (u'My son is in a fairly large, motorized wheelchair. Seeing people abandoning @TransLink Skytrain cars on the rails is not a comforting sight.',\n",
        "  0.41702882811414954),\n",
        " (u'the crooks at TransLink paint this as a technical issue, but they probably fired their technically skilled maint. staff years ago to save $$',\n",
        "  0.0),\n",
        " (u'@TransLink @MayorGregor can we please do something about this unconstitutional corrupt organization in vancouver @SenateCA @pmharper #plz',\n",
        "  0.24253562503633297),\n",
        " (u'sky train pain again... can you imagine translink running the New York system ??',\n",
        "  -0.5345224838248488),\n",
        " (u'@TroyFromWytRock @jordanbateman do a little research into how translink spends our money Troy. And look at the service for the price.',\n",
        "  0.0),\n",
        " (u\"Tired of all the whiners!  It's an inconvenience...yes!  Try living in the Middle East!  Suck it up you whiny Canadians!!!#translink #\",\n",
        "  -1.091089451179962),\n",
        " (u'@TransLink @MayorGregor @SenateCA @pmharper i want my 17.5 cent gas tax back from translink and have it canceled right away',\n",
        "  0.22360679774997896),\n",
        " (u'RT @toddsmithdesign: When I see people react to a 4.5 hour #translink delay, I fear the chaos that will occur when our overdue natural disa\\u2026',\n",
        "  -0.7844645405527362),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u'@TransLink @MayorGregor @SenateCA @pmharper fuckin joke fuckin system we are all fuckin sick of shit fuckin garbage translink',\n",
        "  -0.9428090415820635),\n",
        " (u\"@translink I'm pretty sure it wasn't the regular safety alert. Really, in a situation like this, you should be made aware of the broadcasts\",\n",
        "  0.6123724356957946),\n",
        " (u'RT @Mrs_Jamarkattel: @lailayuile I have this feeling #TransLink executives are too underpaid to worry about these pesky problems. Who cares\\u2026',\n",
        "  -0.8728715609439696),\n",
        " (u'RT @WoodfordCKNW980: .@Translink\\'s Doug Kelsey says #skytrain problem \"under investigation\" early indication is a possible short circuit on\\u2026',\n",
        "  -0.4588314677411235),\n",
        " (u\"Man bet Translink can't wait for this week to end #SkyTrain\", 0.0),\n",
        " (u'@Heatheranner @TransLink My legs are crossed. I hit #Starbucks before jumping on the skytrain.',\n",
        "  0.0),\n",
        " (u'Screw u, Translink', 0.0),\n",
        " (u'Oh no Translink down for the second time in a week. Lots of finger pointing!',\n",
        "  -0.2581988897471611),\n",
        " (u'Way to go #translink! Skills! \\U000feb9d\\U000feb9d\\U000feb9d\\U000feb9d\\U000feb9d\\U000feb9d\\U000feb9d\\U000feb9d\\U000feb9d\\U000feb9d',\n",
        "  0.0),\n",
        " (u'only translink', 0.0),\n",
        " (u'@_cuddlefish_ @always_vote @daka_x @lazin_ryder @translink Fess up @daka_x #bcpoli',\n",
        "  0.0),\n",
        " (u'Translink is a joke.fire the translink board.a bunch of white collar criminals.time to put these clowns in jail and throw away the key',\n",
        "  0.0),\n",
        " (u\"RT @lerico: @TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\",\n",
        "  0.0),\n",
        " (u'@TransLink kuddos to the cheerful driver on the 22 making the best of a stressful rush hour',\n",
        "  1.212678125181665),\n",
        " (u'Bombardier + SNC-Lavalin + Thales + TransLink #WhatsTheLink #ThatsTheLink @jordanbateman @kevinharding',\n",
        "  0.0),\n",
        " (u\"@CKNW @TransLink No, but 25 years of eyerolling equals most of us don't trust you as far as we can spit.\",\n",
        "  0.0),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't waste 100s of 1000s on public art like poodles on sticks, it could keep SkyTrain running. http\\u2026\",\n",
        "  0.20412414523193154),\n",
        " (u'@TransLink #DougKelsey stop patting yourself on the back for your emergency plan and offer the people that pay your salary some compensation',\n",
        "  -0.8528028654224417),\n",
        " (u'RT @Rod_MacBeth: @TransLink Doug Kelsey says \"two incidents doesn\\'t make a trend\", but 2 in 4 days makes the ridership Pee\\'d off! #DudeWher\\u2026',\n",
        "  0.0),\n",
        " (u\"@GlobalBC @TransLink I can't imagine being a person with mobility issues today. Glad I can drive to get around.\",\n",
        "  0.6882472016116852),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't waste 100s of 1000s on public art like poodles on sticks, it could keep SkyTrain running. http\\u2026\",\n",
        "  0.20412414523193154),\n",
        " (u'@profutbola Looks like #SkyTrain is up and running my friend. Still busy and backed up, but running. #translink',\n",
        "  0.7071067811865476),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@CTVVancouver news just totally threw @TransLink BC under the bus.  Unbalanced reporting #CTVFAIL #translinkfail',\n",
        "  0.0),\n",
        " (u'#Translink COO Doug Kelley just said on @GlobalBC that they were happy with how things were handled today. Not sure if everyone word agree.',\n",
        "  0.8164965809277261),\n",
        " (u'@TransLink ah,  no worries.  Trains make it all better.  Thank you so much.',\n",
        "  0.8320502943378437),\n",
        " (u\"RT @lerico: @TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\",\n",
        "  0.0),\n",
        " (u'@GlobalBC another ugly commute today. Had to go home via West Coast Express, and pay additional $4.50 for the pleasure! Shame on Translink!',\n",
        "  -0.6255432421712244),\n",
        " (u'Another delay, this time at renfrew. Intrusion alarm went off. And there it goes. Again. #translink #vancouver',\n",
        "  -0.7276068751089989),\n",
        " (u'RT @jplett: Another delay, this time at renfrew. Intrusion alarm went off. And there it goes. Again. #translink #vancouver',\n",
        "  -0.6882472016116852),\n",
        " (u'And again. #translink. Nearest attendant is at Rupert. Just #facepalm',\n",
        "  0.0),\n",
        " (u'Here is an idea, @TransLink .. when the train is stuck while actually AT a station, how about you open the doors so people can breathe?',\n",
        "  -0.4),\n",
        " (u'RT @Questionchris: #Translink COO Doug Kelley just said on @GlobalBC that they were happy with how things were handled today. Not sure if e\\u2026',\n",
        "  0.6),\n",
        " (u'@lerico @TransLink Yeah. That says it, alright. Lol. @lailayuile @Lazin_Ryder #bcpoli',\n",
        "  1.2060453783110545),\n",
        " (u'@BC1 boo hiss. Stupid #translink', -0.8944271909999159),\n",
        " (u'@CKNW @TransLink lucky for translink there are no other options 0_o',\n",
        "  0.6030226891555273),\n",
        " (u'So seems like @TransLink issues have been resolved and I can go home. Yay',\n",
        "  1.0690449676496976),\n",
        " (u\"And that's 4x. #translink\", 0.0),\n",
        " (u\"RT @lerico: @TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\",\n",
        "  0.0),\n",
        " (u'@GlobalBC @TransLink #SkyTrain .. Unacceptable.  Apology not accepted...#fail',\n",
        "  -1.1338934190276817),\n",
        " (u'Why does the 22 run off schedule all the damn time @translink? #45minwait #alittleridiculous #vancouver',\n",
        "  -1.0327955589886444),\n",
        " (u'Stuck in a train at Renfrew skytrain stop @TransLink more delays...common please fix it!',\n",
        "  -0.5345224838248488),\n",
        " (u'@simisara980   @billgood980 here u go @CKNW even @TransitPolice boss says 1 day free @TransLink to say sorry http://t.co/cizx0seTnp',\n",
        "  0.0),\n",
        " (u'RT @LinehaulDisptch: @News1130radio @TransLink system failure?? Someone just tripped over the plug that was supposed to be duct taped to th\\u2026',\n",
        "  -0.42640143271122083),\n",
        " (u'@TransitPolice @translink taxpayers money well spent eh? http://t.co/3pYQJsx6Qg',\n",
        "  0.0),\n",
        " (u\"Train has been stuck for several minutes due to intrusion alarm. With this kind of response time, I hope no one's hurt. #translink\",\n",
        "  -0.6255432421712244),\n",
        " (u'@TransLink Annual Meeting : \" trains aren\\'t moving\\U0001f62fsystem needs upgrade\\U0001f623let\\'s increase taxes\\U0001f61c SO Who\\'s ready for Bonus\\U0001f61d\\U0001f61d\" @news1130traffic',\n",
        "  0.23570226039551587),\n",
        " (u'@TroyFromWytRock @jordanbateman 1 you have no idea what I make. 2 I am accountable to my bosses. Something translink is criticized for.',\n",
        "  -0.6396021490668313),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u\"@News1130radio @TransLink Mad support translink. Stuff happens that cant be controlled. C'est la vie. #Translink\",\n",
        "  -0.2581988897471611),\n",
        " (u'RT @Heatheranner: @80sRockerChick @TransLink yipee! My fingers are crossed for you! \\u270c\\ufe0f',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@TransLink Never fails. At all.', -0.8944271909999159),\n",
        " (u'@Mrs_Jamarkattel @lailayuile #TransLink sorry but Premier and mayors council should have every vp and above on the carpet now.',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @80sRockerChick: @Heatheranner I offered my skytrain computer kicking services to @TransLink. The train suddenly began to work. http://t\\u2026',\n",
        "  0.0),\n",
        " (u'@CTVVancouver @TransLink can you smell another tax coming to update the skytrain system #whenindoubttaxit',\n",
        "  0.0),\n",
        " (u'RT @hosea24hours: \"Why ride when you can walk?\" Translink\\u2019s new motto. #skytrain',\n",
        "  0.0),\n",
        " (u\"Via @Meerakati, @TransLink says today's issues due to power failure in electrical panel. Completely different problem than last week. #cbc\",\n",
        "  -0.8944271909999159),\n",
        " (u\"@AgnieszkaWyka @TransLink @GlobalBC nothing they're all on management is on summer holidays. Kidding me nothing will change.\",\n",
        "  0.0),\n",
        " (u\"And we're off. I guess the alarm was just one of many skytrain malfunctions? They should get that fixed. #translink\",\n",
        "  -0.4472135954999579),\n",
        " (u'How 2solve the incompetence of @translink #skytrain ?They take all the money they want taxes+fares &amp; another big failure is 2much #Vancouver',\n",
        "  -0.42640143271122083),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u\"@GlobeBC @lifeofan_ashley @HuffPostBC @TransLink and if someone got hurt? I'd be on Translink's side!! #stupid\",\n",
        "  -1.0327955589886444),\n",
        " (u'@MayorGregor; I respectfully disagree with the additional funding part of your tweet. Already too much $$$ spent on Translink.',\n",
        "  0.0),\n",
        " (u'@TransLink if that was the idea- then apparently no @TransLink employees were told as I had to figure out my own way there',\n",
        "  -0.20851441405707477),\n",
        " (u\"@GlobalBC ... @TransLink. Sorry ??  Thankyou ??  No, #sizelargefail.  C'mon man, get it together.\",\n",
        "  -0.6030226891555273),\n",
        " (u\"@TransLink I'm on a bus now! Thx for the quick reply, your job must be uber stressful on days like today :( keep up the good work :)\",\n",
        "  0.9622504486493763),\n",
        " (u\"My year without a car may soon be over as @TransLink can't seem to get their transit right lately!\",\n",
        "  0.0),\n",
        " (u'RT @hosea24hours: \"Why ride when you can walk?\" Translink\\u2019s new motto. #skytrain',\n",
        "  0.0),\n",
        " (u\"@GlobalBC Translink was still charging for service today? Come on guys where's the customer service?\",\n",
        "  0.0),\n",
        " (u'Perhaps #translink haters might redirect some of this rage at idiots, who for a second time this week, forced doors open &amp; walked tracks.',\n",
        "  -1.2247448713915892),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u\"@TransitPolice @TransLink So who's the supervisor who parked illegally? http://t.co/3pYQJsx6Qg\",\n",
        "  0.0),\n",
        " (u'@TransLink @CKNW go fuck urself u white collar criminals',\n",
        "  -2.3333333333333335),\n",
        " (u'@TransLink I hear trains. Everything tickety-boo? http://t.co/8KzNyI3SwZ',\n",
        "  0.0),\n",
        " (u'@GlobalBC @miguelramostv @TransLink .. #chickenshitbastard... #facethepeople... #UFB',\n",
        "  0.0),\n",
        " (u'I do like the Orwellian announcements. \"Attention passengers. Translink loves you. You love Translink.\" #thedaythatwillneverend',\n",
        "  1.2909944487358056),\n",
        " (u'@CKNW @TransLink Hey Doug, maybe you need to upgrade your computers from Windows ME Edition to something more stable.',\n",
        "  0.4588314677411235),\n",
        " (u\"RT @lerico: @TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\",\n",
        "  0.0),\n",
        " (u\"#translink's Colleen Brennan says #skytrain went down due to power failure and damaged electrical panel #cbc http://t.co/1uLRzQmHvp\",\n",
        "  -0.48507125007266594),\n",
        " (u'@PennyDaflos @TransLink @CTVVancouver Looks normal to me.', 0.0),\n",
        " (u'RT @jfryers: Thanks for the delay @TransLink - great excuse to go to @SteamworksPub for dinner! http://t.co/W3He0xyOy1',\n",
        "  0.75),\n",
        " (u'Tk solace #Skytrain riders @TransitPolice  @TransLink bust Mercedes parked #bus stop #JoyceStn, give him a ticket&amp;tow http://t.co/7nWQgObSUN',\n",
        "  -0.24253562503633297),\n",
        " (u'RT @JillKrop: IF you are on #skytrain stay in the cars - the tracks are powered! Danger of electrocution if you walk on them. Translink wor\\u2026',\n",
        "  -0.3922322702763681),\n",
        " (u'Obviously a joke -and now removed from Craigslist - but Translink needs a Skytrain Computer Technician!  http://t.co/yA4shcWh93',\n",
        "  0.5),\n",
        " (u\"RT @lerico: @TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\",\n",
        "  0.0),\n",
        " (u'Oh translink,  this is why I love you... not. 3 skytrains just chill in back to back for 5 minutes.\\u2026 http://t.co/iDjem4VyC2',\n",
        "  0.6546536707079772),\n",
        " (u\"@kenpaquette Translink isn't subsidizing sports #offtopic @jordanbateman\",\n",
        "  0.0),\n",
        " (u'I thought my patients were annoying today, translink surpassed them by a fucking mile #translink #vancouver #annoyedasfuck',\n",
        "  -1.4552137502179978),\n",
        " (u\"RT @lerico: @TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\",\n",
        "  0.0),\n",
        " (u'RT @PennyDaflos: RT @lizaCKNW980: Transit users walking on track to Main Street #skytrain after 30 min on stopped train. @TransLink http://\\u2026',\n",
        "  -0.21320071635561041),\n",
        " (u\"RT @Meerakati: #translink's Colleen Brennan says #skytrain went down due to power failure and damaged electrical panel #cbc http://t.co/1uL\\u2026\",\n",
        "  -0.4472135954999579),\n",
        " (u\"@TransLink I'm billing you the tolls I'm getting charged for coming over the bridge\",\n",
        "  -0.8017837257372732),\n",
        " (u'RT @PeterMeiszner: Obviously a joke -and now removed from Craigslist - but Translink needs a Skytrain Computer Technician!  http://t.co/yA4\\u2026',\n",
        "  0.4588314677411235),\n",
        " (u'@TransLink there should be a free #skytrain day every week to make up for all the break downs during the week',\n",
        "  0.2182178902359924),\n",
        " (u\"@TransLink it's all good, least it was sunny today...lookin at the positives haha. Thanks for the help :)\",\n",
        "  2.3570226039551585),\n",
        " (u\"There better be none of this crap tomorrow. I swear i'm going to lose it if i miss my flight. #Skytrain #Translink\",\n",
        "  -1.0660035817780522),\n",
        " (u'RT @PeterMeiszner: Obviously a joke -and now removed from Craigslist - but Translink needs a Skytrain Computer Technician!  http://t.co/yA4\\u2026',\n",
        "  0.4588314677411235),\n",
        " (u'@TransLink there should be a free #skytrain day every week to make up for all the break downs during the week',\n",
        "  0.2182178902359924),\n",
        " (u\"@TransLink it's all good, least it was sunny today...lookin at the positives haha. Thanks for the help :)\",\n",
        "  2.3570226039551585),\n",
        " (u\"There better be none of this crap tomorrow. I swear i'm going to lose it if i miss my flight. #Skytrain #Translink\",\n",
        "  -1.0660035817780522),\n",
        " (u'RT @PeterMeiszner: Obviously a joke -and now removed from Craigslist - but Translink needs a Skytrain Computer Technician!  http://t.co/yA4\\u2026',\n",
        "  0.4588314677411235),\n",
        " (u'@TransLink there should be a free #skytrain day every week to make up for all the break downs during the week',\n",
        "  0.2182178902359924),\n",
        " (u\"@TransLink it's all good, least it was sunny today...lookin at the positives haha. Thanks for the help :)\",\n",
        "  2.3570226039551585),\n",
        " (u'RT @toddsmithdesign: When I see people react to a 4.5 hour #translink delay, I fear the chaos that will occur when our overdue natural disa\\u2026',\n",
        "  -0.7844645405527362),\n",
        " (u'@TransLink thanks for all your hard work in getting the skytrain fixed! My commute home has been painless so far :)',\n",
        "  0.2182178902359924),\n",
        " (u'@TransLink Yepp and keep up the good work managing the sky train crisis.',\n",
        "  0.0),\n",
        " (u'/raises champagne glass http://t.co/05Ibyd9e5Y', 0.0),\n",
        " (u'@TransLink is there any reason why all 240/246 buses are showing cancelled at stop 58254?',\n",
        "  -0.5163977794943222),\n",
        " (u\"@TransLink  you're trains go down more often than @SashaGrey #fixitalready\",\n",
        "  0.0),\n",
        " (u'@TransLink #terrible communication today. #new to @Vancouver transport and bus drivers on 41 &amp; 26 very #rude bus driver #8132 on 43 awesome',\n",
        "  0.20851441405707477),\n",
        " (u\"RT @lerico: @TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\",\n",
        "  0.0),\n",
        " (u'Translink needs to stop shutting down their skytrain  \\U0001f621',\n",
        "  -0.3333333333333333),\n",
        " (u'#Vancouver Service restored says #Translink on both #Expo and Millenium Lines. http://t.co/YqcoiDw8IG',\n",
        "  0.2886751345948129),\n",
        " (u'Unacceptable job by Translink  MT @News1130radio RT @myzrahi: #Skytrain users walk tracks to station. Photo by A.Amat http://t.co/JNmqOOqq1L',\n",
        "  -0.47140452079103173),\n",
        " (u\"@TransLink I hope so! It's not you guys or the drivers faults regarding the skytrain...no point in getting mad :)\",\n",
        "  -0.22360679774997896),\n",
        " (u\"Vancouver's SkyTrain reopens after unidentified computer problems: Metro Vancouver's TransLink shut d... http://t.co/CH1sY8uroI #NewsCBC\",\n",
        "  -0.5345224838248488),\n",
        " (u\"Vancouver's SkyTrain reopens after unidentified computer problems: Metro Vancouver's TransLink shut d... http://t.co/s69r7Wcqc1 #CBCNews\",\n",
        "  -0.5345224838248488),\n",
        " (u'Thank you translink skytrain for making me an hour late to work. :)',\n",
        "  0.5547001962252291),\n",
        " (u'RT @neil21: Skytrain shutdown provides a nice foreshadowing for @christyclarkbc @toddstonebc Translink vision. Less service. You should dri\\u2026',\n",
        "  0.917662935482247),\n",
        " (u\".@mtopy14 @TransLink @GlobalBC but that's not really a secret is it?\",\n",
        "  0.0),\n",
        " (u'@TransLink what bus would i take from rupert to the pne.... 16 arbutus? Im tryig to catch the 160',\n",
        "  0.0),\n",
        " (u\"Wouldn't be surprised if car sales have now risen in the Lower Mainland after this second @translink fiasco #vancouver #skytrainshutdown\",\n",
        "  -0.6708203932499369),\n",
        " (u'RT @wongers: #Skytrain is crowded but that doesn\\u2019t stop commuters from giving up seats to people in need. Stay awesome #vancouver #translink',\n",
        "  0.6255432421712244),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'#Surrey Service restored says #Translink on both #Expo and Millenium Lines. http://t.co/05bdQMt0wd',\n",
        "  0.2886751345948129),\n",
        " (u'@kenpaquette @mtnbvan many examples of TransLink waste - go to http://t.co/PmoNvQIBeY and put TransLink in the search bar.',\n",
        "  -0.24253562503633297),\n",
        " (u'@JAPANESEYAOIS just @  TransLink lol', 1.5),\n",
        " (u\"@lerico @TransLink They should hire someone to make sure their grammar is correct so there are fewer mistakes. I bet they're embarrassed.\",\n",
        "  -0.8528028654224417),\n",
        " (u'@TransLink how long will the train close??', 0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'@TransLink yet another a-hole driver refusing to pick up preferences l passengers at Broadway/Commercial. #9 again. 6\" from the fucking stop',\n",
        "  -1.5275252316519468),\n",
        " (u\"RT @stevecbc: He's now giving directions to Surrey. @translink give him a raise, and get staff to bway station here to help. #cbc http://t.\\u2026\",\n",
        "  0.4),\n",
        " (u'I doubt it will happen, but if there was ever a time for @Translink to offer free rides it is after two major #Skytrain outages in a week...',\n",
        "  0.0),\n",
        " (u'RT @MyVancouver: Travellers looking to get on #Skytrain should find alt routes; try Google Transit or call @Translink Customer Info at 604.\\u2026',\n",
        "  0.0),\n",
        " (u'RT @kathryn_stew: I just imagine @Translink staff sighing and flipping a \"Days Since Last #Skytrain shutdown\" sign back to 0.',\n",
        "  0.0),\n",
        " (u'RT @tnoble: I doubt it will happen, but if there was ever a time for @Translink to offer free rides it is after two major #Skytrain outages\\u2026',\n",
        "  0.0),\n",
        " (u\"@tnoble @TransLink they've been offering free rides since 1986 when they elected not to install fare gates\",\n",
        "  0.24253562503633297),\n",
        " (u'With rider safety put at risk for a second time in a week, we need a better accountability regime or new leadership for Translink #bcpoli',\n",
        "  0.2),\n",
        " (u'.@TransLink this kind of behavior by your drivers is *infuriating*: rude, petty, ignorant treatment of paying customers. Unbelievable.',\n",
        "  -0.7071067811865476),\n",
        " (u'@TheTonguKid @stevecbc @TransLink #NiceFace', 0.0),\n",
        " (u\"@samchan626 @TransLink Yea since you can't really put Uncle Ben's rice into your pits to rid of the foul stench\",\n",
        "  0.0),\n",
        " (u'#translink problems http://t.co/D1dCrirC1E', -1.1547005383792517),\n",
        " (u'.@TransLink you need to get your drivers to smarten the hell up. This is bullshit.',\n",
        "  -2.065591117977289),\n",
        " (u\"RT @stevecbc: He's now giving directions to Surrey. @translink give him a raise, and get staff to bway station here to help. #cbc http://t.\\u2026\",\n",
        "  0.4),\n",
        " (u'RT @Questionchris: #Translink COO Doug Kelley just said on @GlobalBC that they were happy with how things were handled today. Not sure if e\\u2026',\n",
        "  0.6),\n",
        " (u'RT @gartho: Apparently a backup computer system for @translink #SkyTrain system would be $20 million. Compass Card Program spills that kind\\u2026',\n",
        "  0.42640143271122083),\n",
        " (u'RT @doctorboss: Raised urban walking trails seem to be a new @Translink initiative. The price seems a bit steep though. #SkyTrain',\n",
        "  0.0),\n",
        " (u'#YVR Service restored says #Translink on both #Expo and Millenium Lines. http://t.co/K3ddfPH5zZ',\n",
        "  0.2886751345948129),\n",
        " (u'@FromTheBackline @JM3ndoza @TransLink @WhitecapsFC not sure if Camilo ever used the system but we could end up losing @OB_40 for sure.',\n",
        "  -0.6546536707079772),\n",
        " (u'RT @WoodfordCKNW980: Arrived @CKNW. Add a $30 parking bill to my transit expenses today. Again, I can look forward to getting 0 rebate from\\u2026',\n",
        "  0.0),\n",
        " (u'Translink not quite getting its shit together \"@lerico: @TransLink \\'they are\\' not \\'their\\' http://t.co/ztynvuRkeH\"',\n",
        "  -1.0690449676496976),\n",
        " (u'RT @PeterMeiszner: Obviously a joke -and now removed from Craigslist - but Translink needs a Skytrain Computer Technician!  http://t.co/yA4\\u2026',\n",
        "  0.4588314677411235),\n",
        " (u'.@TransLink your drivers have a policy of pulling just far enough away from a stop to be technically \"not at a stop\" so they can ignore us',\n",
        "  -0.5773502691896257),\n",
        " (u'@TransLink nope, thanks. The bus appeared shortly after. Never did get a text back though.',\n",
        "  0.5163977794943222),\n",
        " (u'RT @CTVVancouver: #Breaking: Expo and Millennium SkyTrain lines are back to regular service, TransLink says. http://t.co/7yZaUfBLMB',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @EComm911_info: RT @TransLink: #SkyTrain UPDATE  M-Line is now running between VCC-Clark and Sapperton. E-line is expected to open withi\\u2026',\n",
        "  0.0),\n",
        " (u'Apparently \"can I get a ride please?\" Is enough to get you onto @TransLink buses. I\\'m going to stop buying fare savers.',\n",
        "  0.0),\n",
        " (u\"So if you were stuck on #skytrain do you think it's a good idea #bcliberals gave #translink execs car allowances vs take #transit? #bcpoli\",\n",
        "  0.20412414523193154),\n",
        " (u'#translink says the #skytrain outage was due problem in electrical panel not related to bc hydro #cbc',\n",
        "  -0.48507125007266594),\n",
        " (u'*Infrastructure* redundancy is important, Translink, not *organizational* redundancy',\n",
        "  0.7071067811865475),\n",
        " (u\".@TransLink and then sit there pretending not to see us while they wait behind traffic at a red light. It's crap behavior. It's bullshit.\",\n",
        "  -1.6329931618554523),\n",
        " (u'RT @PeterMeiszner: Obviously a joke -and now removed from Craigslist - but Translink needs a Skytrain Computer Technician!  http://t.co/yA4\\u2026',\n",
        "  0.4588314677411235),\n",
        " (u\"RT @Meerakati: #translink's Colleen Brennan says #skytrain went down due to power failure and damaged electrical panel #cbc http://t.co/1uL\\u2026\",\n",
        "  -0.4472135954999579),\n",
        " (u'#Burnaby Service restored says #Translink on both #Expo and Millenium Lines. http://t.co/suieEMMDVZ',\n",
        "  0.2886751345948129),\n",
        " (u'SkyTrain is back to normal service. Delays can be expected. More info on the Translink website. http://t.co/M91dqAOubz ^sr',\n",
        "  0.0),\n",
        " (u'@michaeleckford @WoodfordCKNW980 #Translink has nothing on this Train Wreck',\n",
        "  -0.6666666666666666),\n",
        " (u'@CloverdaleGal @TransLink lol. future Translink press release \"after a small delay, we managed to get MOST of our passengers home safely\".',\n",
        "  0.6546536707079772),\n",
        " (u'RT @mitchjwilliams: @Mrs_Jamarkattel @lailayuile #TransLink sorry but Premier and mayors council should have every vp and above on the carp\\u2026',\n",
        "  -0.2182178902359924),\n",
        " (u'.@TransLink and your response of \"Goll-lee, sorry mister, complain at our crappy form (where we\\'ll ignore you some more)\" is also crap.',\n",
        "  -1.4924050144892729),\n",
        " (u\"RT @pqpolitics: So if you were stuck on #skytrain do you think it's a good idea #bcliberals gave #translink execs car allowances vs take #t\\u2026\",\n",
        "  0.19611613513818404),\n",
        " (u\"Only 1 thing worse then having to ride the #SkyTrain everyday,and that's having to ride the skytrain everyday. #translink #skytrainproblems\",\n",
        "  -0.6708203932499369),\n",
        " (u'@WoodfordCKNW980 @CKNW @Translink from them you can only get heart attack nothing else. Every day new problems and delays',\n",
        "  -0.6882472016116852),\n",
        " (u'RT @lizaCKNW980: Transit users walking on track to Main Street #skytrain after 30 min on stopped train. @TransLink http://t.co/Nllb0CXmdn',\n",
        "  -0.22941573387056174),\n",
        " (u'Haha! Win! #SkyTrain #translink #Translinkproblems http://t.co/KcuzCW6YhB',\n",
        "  2.8577380332470415),\n",
        " (u'RT @Lamarche: RT @khothis: Something is wrong with the #skytrain again! #transitproblems http://t.co/QkQioUpn2G #Vancouver #VanPoli #Transl\\u2026',\n",
        "  -0.48507125007266594),\n",
        " (u\"What's the bet that the Vancouver Skytrain was down today because noone at Translink's been deleting logfiles and they ran out of HDD space?\",\n",
        "  0.0),\n",
        " (u'Translink has no chill \\U0001f645', -0.4472135954999579),\n",
        " (u'RT @JadaArriola: I HATE TRANSLINK', -1.3416407864998738),\n",
        " (u'RT @bakedwind: Haha! Win! #SkyTrain #translink #Translinkproblems http://t.co/KcuzCW6YhB',\n",
        "  2.4748737341529163),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u\"@TransLink has the best customer service on twitter I've ever seen, even during breakdowns. Extremely helpful :)\",\n",
        "  1.212678125181665),\n",
        " (u\"RT @pqpolitics: So if you were stuck on #skytrain do you think it's a good idea #bcliberals gave #translink execs car allowances vs take #t\\u2026\",\n",
        "  0.19611613513818404),\n",
        " (u\"'Disappearing Palestine' bus ads in Vancouver accused of inciting hatred http://t.co/otZspntqWm via @canadadotcom\",\n",
        "  -0.5547001962252291),\n",
        " (u'#Coquitlam Service restored says #Translink on both #Expo and Millenium Lines. http://t.co/5b7gTVsooK',\n",
        "  0.2886751345948129),\n",
        " (u'RT @bakedwind: Haha! Win! #SkyTrain #translink #Translinkproblems http://t.co/KcuzCW6YhB',\n",
        "  2.4748737341529163),\n",
        " (u\"RT @pqpolitics: So if you were stuck on #skytrain do you think it's a good idea #bcliberals gave #translink execs car allowances vs take #t\\u2026\",\n",
        "  0.19611613513818404),\n",
        " (u\"@kerrikins I get that and understand completely but when translink keeps asking for money , it's a bit frustrating.\",\n",
        "  -0.47140452079103173),\n",
        " (u'UPDATED: Train Service for #Expo and #Millennium lines back up and running @TransLink http://t.co/zYXK1YpeT8',\n",
        "  0.0),\n",
        " (u'RT @TedDixon: With rider safety put at risk for a second time in a week, we need a better accountability regime or new leadership for Trans\\u2026',\n",
        "  0.19245008972987526),\n",
        " (u'RT @News1130radio: UPDATED: Train Service for #Expo and #Millennium lines back up and running @TransLink http://t.co/zYXK1YpeT8',\n",
        "  0.0),\n",
        " (u'\\u201c@News1130radio: UPDATED: Train Service for #Expo and #Millennium lines back up and running @TransLink http://t.co/25SqKiE7NZ\\u201d wow finally',\n",
        "  0.9428090415820635),\n",
        " (u'RT @News1130radio: UPDATED: Train Service for #Expo and #Millennium lines back up and running @TransLink http://t.co/zYXK1YpeT8',\n",
        "  0.0),\n",
        " (u\"Is the skytrain running again, @translink? Trying to get from New West to East Van. I have an alternate bus route planned if it's not..\",\n",
        "  0.0),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'RT @News1130radio: UPDATED: Train Service for #Expo and #Millennium lines back up and running @TransLink http://t.co/zYXK1YpeT8',\n",
        "  0.0),\n",
        " (u'@TransLink skytrains working yet?', 0.0),\n",
        " (u'RT @Kimli: This is both ouch and lol: http://t.co/q5rFMv8obs #skytrain #translink #vancouver',\n",
        "  0.8660254037844387),\n",
        " (u'@TransLink anytime guys. Just trying to help while I was at home. :)',\n",
        "  0.5547001962252291),\n",
        " (u'RT @WoodfordCKNW980: .@Translink\\'s Doug Kelsey says #skytrain problem \"under investigation\" early indication is a possible short circuit on\\u2026',\n",
        "  -0.4588314677411235),\n",
        " (u'RT @profecampos: @FromTheBackline @JM3ndoza @TransLink @WhitecapsFC not sure if Camilo ever used the system but we could end up losing @OB_\\u2026',\n",
        "  -0.6396021490668313),\n",
        " (u\"RT @Andrea_Yeung: Not sure which is a tougher job: managing @translink's Twitter account today or managing @BlackBerry's investor calls.\",\n",
        "  0.0),\n",
        " (u\"@TransLink I'm visiting BC from the UK. Transit staff didn't have a clue and didn't tell people when skytrain was up and running @ metrotown\",\n",
        "  0.0),\n",
        " (u'Amazed that Translink let people walk on the Skytrain tracks during the service interruption today. Are they not liable for an accident?',\n",
        "  -0.42640143271122083),\n",
        " (u'RT @Questionchris: #Translink COO Doug Kelley just said on @GlobalBC that they were happy with how things were handled today. Not sure if e\\u2026',\n",
        "  0.6),\n",
        " (u'#NorthShore Service restored says #Translink on both #Expo and Millenium Lines. http://t.co/bUbQ5R9z84',\n",
        "  0.2886751345948129),\n",
        " (u'Drunk on #3 bus keeps yanking on the cord. @Translink #Vancouver http://t.co/a2JVMFiE93',\n",
        "  -0.5773502691896258),\n",
        " (u'RT @Kimli: This is both ouch and lol: http://t.co/q5rFMv8obs #skytrain #translink #vancouver',\n",
        "  0.8660254037844387),\n",
        " (u'RT @TransLink: .@CKNW #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22360679774997896),\n",
        " (u\"RT @lerico: @TransLink 'they are' not 'their' http://t.co/0CebFbTbFt\",\n",
        "  0.0),\n",
        " (u'@TransLink CEO: http://t.co/rGOQP4hXUE', 0.0),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'MT\"@lizaCKNW980: Transit users on train track @TransLink http://t.co/llZmxU78y4\" Eerily similar to commuters riding on train roof in Mumbai.',\n",
        "  0.0),\n",
        " (u\"@jujuniper @TransLink yep. It's back and working.\", 0.0),\n",
        " (u'@TransLink Transit staff at Sapperton were very helpful with finding me a route to work this evening. Thanks guys!',\n",
        "  0.917662935482247),\n",
        " (u\"RT @wayneg9998: @TransitPolice @TransLink So who's the supervisor who parked illegally? http://t.co/3pYQJsx6Qg\",\n",
        "  0.0),\n",
        " (u'RT @News1130radio: UPDATED: Train Service for #Expo and #Millennium lines back up and running @TransLink http://t.co/zYXK1YpeT8',\n",
        "  0.0),\n",
        " (u'@amyjudd @ChelseaRTucker seriously tho, who is translink? Who is on their board and why? How high are their management salaries?',\n",
        "  0.0),\n",
        " (u'@TransLink hi Can You sent me the times for greyhound bus from Duncan bc to Campbell river and the cost thanks',\n",
        "  0.4364357804719848),\n",
        " (u'RT @LiveAyce: @TransLink you guys gotta get ur sh** together. Second time in less than a week. Should be giving monthly pass refunds #dissa\\u2026',\n",
        "  0.0),\n",
        " (u\"@TransLink Rush hour is a little hectic. As a business, efficiency is key, otherwise it's not an effective practice #needsimprovement\",\n",
        "  0.4472135954999579),\n",
        " (u'RT @tlupick: Photos: #SkyTrain technical issues leave riders stranded on the tracks http://t.co/sKs9biBdKy Lots of @TransLink pics http://t\\u2026',\n",
        "  -0.22941573387056174),\n",
        " (u'@iChinadian @TransLink kick him out... must be a long bus ride', 0.0),\n",
        " (u'RT @News1130radio: UPDATED: Train Service for #Expo and #Millennium lines back up and running @TransLink http://t.co/zYXK1YpeT8',\n",
        "  0.0),\n",
        " (u'Global news reports people were escorted off trains.  translink staff told us to get off there was no further help or instructions.pathetic!',\n",
        "  0.21320071635561041),\n",
        " (u\"@TransLink what's going on with 112's? First screwed around with #skytrain, now missing busses!?!\",\n",
        "  -1.0690449676496976),\n",
        " (u\"'The Shift' coming your way in a minute. Off the top we tackle the #skytrain meltdown &amp; hear from @Translink, @pricetags, &amp; @MayorWatts\",\n",
        "  0.41702882811414954),\n",
        " (u\"'The Shift' coming your way in a minute. Off the top we tackle the #skytrain meltdown &amp; hear from @Translink, @pricetags, &amp; @MayorWatts\",\n",
        "  0.41702882811414954),\n",
        " (u\"I'm so exhausted. Took me 3.5 hours to get home whereas it only takes me around 1. Thank you very much Translink.\",\n",
        "  0.0),\n",
        " (u'Really skytrain, did you have to break down today too? #translink', 0.0),\n",
        " (u'@TransLink @CKNW Finally...', 0.0),\n",
        " (u'1st no #skytrain. Now 2 missing busses in a row. @TransLink is the only company that can get away with such horrible customer service.',\n",
        "  -1.2247448713915892),\n",
        " (u'Unhappy over #SkyTrain problems? Give #bcliberals appointed #translink board your feedback http://t.co/JNUZgZXmlP #bcpoli #vanpoli',\n",
        "  -1.0690449676496976),\n",
        " (u'@TransLink sorry, I was talking westbound. Last 2 were not here.',\n",
        "  -0.30151134457776363),\n",
        " (u'I love how bus 2530 announces the bus goes to 41st and Victoria only, then tells everyone 34th will be the last stop thxs @TransLink driver',\n",
        "  0.3922322702763681),\n",
        " (u'RT @Questionchris: #Translink COO Doug Kelley just said on @GlobalBC that they were happy with how things were handled today. Not sure if e\\u2026',\n",
        "  0.6),\n",
        " (u'Some people have too much time on their hands!! Smh! #transitlife #translink #fakepolice #wtf #skytrain http://t.co/uqgIbUGwoM',\n",
        "  -1.0),\n",
        " (u'damn I hate translink', -3.5),\n",
        " (u\"@DordoDC @TransLink @CTVVancouver I agree.  make the bastards pay for everyone's day on a misery transit system.\",\n",
        "  -1.697749375254331),\n",
        " (u\"RT @StephenHui: Anyone else wish they'd been on the #SkyTrain for the free guided track tour? #TransLink\",\n",
        "  0.48507125007266594),\n",
        " (u\"RT @njellan: Lazy pundits will blame #Skytrain problems on Translink mismanagement rather than pointing out Province's underfunding &amp; meddl\\u2026\",\n",
        "  -1.118033988749895),\n",
        " (u'RT @bobmackin: 6 yrs ago this month, #TransLink was patting itself on the back for keeping #SkyTrain running during a power outage. http://\\u2026',\n",
        "  0.0),\n",
        " (u'ENTIRE @TransLink board needs 2 be fired IMEDIATELY before someone dies.This is the absolute WORST transit system in North America #Pittiful',\n",
        "  -1.091089451179962),\n",
        " (u'RT @baewallace: @TransLink fixed it http://t.co/rC1ZQA3y0P', 0.0),\n",
        " (u'RT @WoodfordCKNW980: .@Translink\\'s Doug Kelsey says #skytrain problem \"under investigation\" early indication is a possible short circuit on\\u2026',\n",
        "  -0.4588314677411235),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'@CKNW @TransLink @pricetags @MayorWatts .   If they had used a cheaper, more main stream technology this would not happen .  \\n.',\n",
        "  0.0),\n",
        " (u\"Yes I agree. should be mandatory RT @NDPCountry @pqpolitics I'd write compulsory transit into their contracts #bcpoli #translink #skytrain\",\n",
        "  0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain UPDATE Stns are now open &amp; E-Line is expected to resume service within the next few mins. ^jkd',\n",
        "  0.0),\n",
        " (u\"RT @WoodfordCKNW980: 'The Shift' coming your way in a minute. Off the top we tackle the #skytrain meltdown &amp; hear from @Translink, @priceta\\u2026\",\n",
        "  0.4082482904638631),\n",
        " (u'@TransLink The people are amazing. Not so much their transit system!',\n",
        "  1.2060453783110545),\n",
        " (u'RT @bobmackin: 6 yrs ago this month, #TransLink was patting itself on the back for keeping #SkyTrain running during a power outage. http://\\u2026',\n",
        "  0.0),\n",
        " (u\"RT @WoodfordCKNW980: 'The Shift' coming your way in a minute. Off the top we tackle the #skytrain meltdown &amp; hear from @Translink, @priceta\\u2026\",\n",
        "  0.4082482904638631),\n",
        " (u'@TransLink The people are amazing. Not so much their transit system!',\n",
        "  1.2060453783110545),\n",
        " (u'RT @bobmackin: 6 yrs ago this month, #TransLink was patting itself on the back for keeping #SkyTrain running during a power outage. http://\\u2026',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #TransitAlert 210 Upper Lynn Detour July 21-25 7am-3pm. Mountain Hwy &amp; Kirkstone, via Kirkstone, Lynn Valley, 27, Mountain H\\u2026',\n",
        "  0.0),\n",
        " (u\"RT @WoodfordCKNW980: 'The Shift' coming your way in a minute. Off the top we tackle the #skytrain meltdown &amp; hear from @Translink, @priceta\\u2026\",\n",
        "  0.4082482904638631),\n",
        " (u'@TransLink The people are amazing. Not so much their transit system!',\n",
        "  1.2060453783110545),\n",
        " (u'RT @bobmackin: 6 yrs ago this month, #TransLink was patting itself on the back for keeping #SkyTrain running during a power outage. http://\\u2026',\n",
        "  0.0),\n",
        " (u'@TransLink The people are amazing. Not so much their transit system!',\n",
        "  1.2060453783110545),\n",
        " (u'RT @bobmackin: 6 yrs ago this month, #TransLink was patting itself on the back for keeping #SkyTrain running during a power outage. http://\\u2026',\n",
        "  0.0),\n",
        " (u'@TransLink The people are amazing. Not so much their transit system!',\n",
        "  1.2060453783110545),\n",
        " (u'RT @bobmackin: 6 yrs ago this month, #TransLink was patting itself on the back for keeping #SkyTrain running during a power outage. http://\\u2026',\n",
        "  0.0),\n",
        " (u'@CKNW @TransLink @pricetags @MayorWatts  ask the complaining customers what they.pay in taxes. They are heavily.subsidized by non riders..',\n",
        "  0.0),\n",
        " (u'RT @lizaCKNW980: Transit users walking on track to Main Street #skytrain after 30 min on stopped train. @TransLink http://t.co/Nllb0CXmdn',\n",
        "  -0.22941573387056174),\n",
        " (u\"@TransLink I'm so relieved to hear the skytrain a are back to normal. You guys did good today, all the drivers and staff.\",\n",
        "  1.0425720702853738),\n",
        " (u\"RT @StephenHui: Anyone else wish they'd been on the #SkyTrain for the free guided track tour? #TransLink\",\n",
        "  0.48507125007266594),\n",
        " (u'Great advertising!! \\u201c@Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!\\u201d',\n",
        "  0.20412414523193154),\n",
        " (u'@GlobalBC @TransLink should boycott translink for 1 week. Take a cab or ride you bike, walk if you have to Maybe they will get it together',\n",
        "  -0.3922322702763681),\n",
        " (u\"@crackker019 @BC1 let's throw more money at it, that'll help. Tax payers got lots! *evil translink laugh!*\",\n",
        "  0.0),\n",
        " (u\"RT @BigNasty604: Only 1 thing worse then having to ride the #SkyTrain everyday,and that's having to ride the skytrain everyday. #translink \\u2026\",\n",
        "  -0.6396021490668313),\n",
        " (u\"RT @StephenHui: Anyone else wish they'd been on the #SkyTrain for the free guided track tour? #TransLink\",\n",
        "  0.48507125007266594),\n",
        " (u'@TransLink no a bus showed up 50 min late or 25 min late depending which one it is.',\n",
        "  -0.23570226039551587),\n",
        " (u\"Hey @TransLink you're fucking terrible. Good thing we have no choice.\",\n",
        "  -1.507556722888818),\n",
        " (u'TransLink Executives: http://t.co/ckAVbYwb0O http://t.co/pd6WuQCLIr', 0.0),\n",
        " (u'@theregoesCarly @TransLink On the train now! I read their tweet saying it was up AFTER I sent the tweet #OfCourse :)',\n",
        "  0.0),\n",
        " (u'RT @CTVVancouver: #Breaking: Expo and Millennium SkyTrain lines are back to regular service, TransLink says. http://t.co/7yZaUfBLMB',\n",
        "  0.0),\n",
        " (u'Jajajaja. lets the jokes begin, because that is what the guys who manage Translink are, a joke. http://t.co/kyhIfRpXEY',\n",
        "  0.9428090415820635),\n",
        " (u'RT @pqpolitics: Unhappy over #SkyTrain problems? Give #bcliberals appointed #translink board your feedback http://t.co/JNUZgZXmlP #bcpoli #\\u2026',\n",
        "  -1.0),\n",
        " (u'translink is the biggest joke tho lmfao', 2.2677868380553634),\n",
        " (u\"@otherMarkThomas @TransLink That's b/c the system has broken down 3 times in 30 years, and the IRA has never bombed it.\",\n",
        "  -0.2182178902359924),\n",
        " (u'@TransLink is down again this evening. #omg', 0.0),\n",
        " (u'RT @ursedated: TransLink Executives: http://t.co/ckAVbYwb0O http://t.co/pd6WuQCLIr',\n",
        "  0.0),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience and sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'British Colombia CAN Surrey http://t.co/iFxzqb3a2M #TransLink BREAKING NEWS 59 TransLink SkyTrain service returning after computer glitch s\\u2026',\n",
        "  0.0),\n",
        " (u'@lerico @lailayuile @TransLink Good catch. :)', 1.2247448713915892),\n",
        " (u'RT @vanisan24: British Colombia CAN Surrey http://t.co/iFxzqb3a2M #TransLink BREAKING NEWS 59 TransLink SkyTrain service returning after co\\u2026',\n",
        "  0.0),\n",
        " (u'RT @vanisan24: British Colombia CAN Surrey http://t.co/iFxzqb3a2M #TransLink BREAKING NEWS 59 TransLink SkyTrain service returning after co\\u2026',\n",
        "  0.0),\n",
        " (u'RT @bakedwind: Haha! Win! #SkyTrain #translink #Translinkproblems http://t.co/KcuzCW6YhB',\n",
        "  2.4748737341529163),\n",
        " (u'RT @VanMusic: Jajajaja. lets the jokes begin, because that is what the guys who manage Translink are, a joke. http://t.co/kyhIfRpXEY',\n",
        "  0.8944271909999159),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't waste 100s of 1000s on public art like poodles on sticks, it could keep SkyTrain running. http\\u2026\",\n",
        "  0.20412414523193154),\n",
        " (u'Fare evasion is the least of @TransLink they should look at working On getting people to their destinations before taking our money',\n",
        "  0.0),\n",
        " (u'@TransLink @MayorGregor @SenateCA @pmharper hello #vancouver back me up on this shit yo',\n",
        "  -1.1094003924504583),\n",
        " (u'Fare evasion is the least of @TransLink problems; they should focus on getting people to their destinations instead of taking out money',\n",
        "  -0.42640143271122083),\n",
        " (u'@TransLink No worries. I figured it out! :)', -0.35355339059327373),\n",
        " (u\"Translink  shut down most of the skytrain stations today so someone tell me why we're paying for it? #translinkfail #ineedmymoneyback\",\n",
        "  0.0),\n",
        " (u'@translink You guys do great work. But your bosses use you as human shields when things go wrong. Poor leadership.',\n",
        "  -0.22360679774997896),\n",
        " (u'TransLink consultant asked me, \"how long is it?\". Then I realised it was the secret question for my go card account LOL',\n",
        "  0.6396021490668313),\n",
        " (u'RT @Youngdriversbc: Are you stuck on a #skytrain and ready to give up on #translink? We can teach you how to drive!!!',\n",
        "  -0.42640143271122083),\n",
        " (u'Translink...I am so done with you.', 0.0),\n",
        " (u'Sky Train blues in Vancouver http://t.co/oUAULLqXej', 0.0),\n",
        " (u\"Blast from the past on @translink #transink #SkyTrain #bcpoli - at what point is Gov't going to step in? #surreybc  http://t.co/R7vlUV5yT8\",\n",
        "  0.0),\n",
        " (u'Bus seats and people over 6 feet are NOT a good combination #ouch #theseatsarecushionedthough #thatsaplus @TransLink http://t.co/jVyIXDfgHH',\n",
        "  0.7276068751089989),\n",
        " (u\"RT @lailayuile: Blast from the past on @translink #transink #SkyTrain #bcpoli - at what point is Gov't going to step in? #surreybc  http://\\u2026\",\n",
        "  0.0),\n",
        " (u'@TransLink no reply? Jeeze such good service.', 0.7559289460184544),\n",
        " (u'@TransLink thanks for the quick info today and a realistic estimate on delays I was able to plan my trip home before leaving work :)',\n",
        "  0.4),\n",
        " (u'Translink fleet to ferry athletes round at Commonwealth Games in Glasgow. #NorthernIreland http://t.co/hyhm8AVDcY',\n",
        "  0.0),\n",
        " (u\"RT @cheapbrunch: Flash mob at Translink offices singing the monorail song. Let's make this happen. I'll dress like Lyle Lanley\",\n",
        "  0.0),\n",
        " (u\"@cheapbrunch I don't believe there are Translink offices in Langley..but if there are perhaps they listened..8 cop cars sped towards Langley\",\n",
        "  0.0),\n",
        " (u\"Let's have a toast for the douchebags. Let's have a toast for the assholes.\\n#translink \\U0001f44f\\U0001f37b\",\n",
        "  0.0),\n",
        " (u'RT @VanMusic: Jajajaja. lets the jokes begin, because that is what the guys who manage Translink are, a joke. http://t.co/kyhIfRpXEY',\n",
        "  0.8944271909999159),\n",
        " (u'@TransLink #SkyTrain back in service - El servicio de SkyTrain ha sido restablecido. http://t.co/AMNBxbJ9Uw',\n",
        "  0.5547001962252291),\n",
        " (u'@TransLink Are these problems with SkyTrain likely to continue happening?',\n",
        "  -0.6324555320336759),\n",
        " (u'Translink fleet to ferry athletes round at Commonwealth Games in Glasgow. #Belfast http://t.co/Jjr5xzPwVq',\n",
        "  0.0),\n",
        " (u'Appears the Translink Board needs closer govt supervision if fiascos like today keep up. Exec salaries unchecked and operations too. #bcpoli',\n",
        "  0.4364357804719848),\n",
        " (u'RT @ianb: When can we talk about tearing down @TransLink and creating an org that actually serves a purpose, is accountable? http://t.co/lQ\\u2026',\n",
        "  0.0),\n",
        " (u'@TransLink your social media team did great today under pressure. #patontheback for managing your Twitter feed well.',\n",
        "  0.48507125007266594),\n",
        " (u'RT @TransLink: #SkyTrain #CanadaLine is not affected by the current problem on the Expo and M-Lines. ^ts',\n",
        "  -0.7276068751089989),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'RT @jordanbateman: TransLink execs are in a shiny new, pricy building, but SkyTrain riders are walking the rails during breakdowns. http://\\u2026',\n",
        "  0.0),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't waste 100s of 1000s on public art like poodles on sticks, it could keep SkyTrain running. http\\u2026\",\n",
        "  0.20412414523193154),\n",
        " (u'RT @lizaCKNW980: Transit users walking on track to Main Street #skytrain after 30 min on stopped train. @TransLink http://t.co/Nllb0CXmdn',\n",
        "  -0.22941573387056174),\n",
        " (u\".@lailayuile @TransLink Agreed! We need unbiased 'Lean Team' to assess everything ASAP! Reliable commutes needed more than they need art!\",\n",
        "  0.6708203932499369),\n",
        " (u'Cloud, open source power TransLink&amp;#039;s Web presence -  It was an aging bespoke application that drove... http://t.co/ktPhXPTsNE',\n",
        "  0.0),\n",
        " (u'RT @GeorgeHeyman: 2 skytrain failures highlight need for investment in #Translink - Lib Minister Stone silent except to say no to funding #\\u2026',\n",
        "  -0.21320071635561041),\n",
        " (u'@EastVanGrahn yeah, so I gather. Just saw that Translink employees were leading people down the tracks (not all trains though) and wondered',\n",
        "  0.21320071635561041),\n",
        " (u'RT @lizaCKNW980: Transit users walking on track to Main Street #skytrain after 30 min on stopped train. @TransLink http://t.co/Nllb0CXmdn',\n",
        "  -0.22941573387056174),\n",
        " (u'@kathryn_stew @CKNW @TransLink http://t.co/NwqH3lEBy9', 0.0),\n",
        " (u'Cloud, open source power TransLink&amp;#039;s Web presence -  It was an aging bespoke application that drove... http://t.co/ktPhXPTsNE',\n",
        "  0.0),\n",
        " (u'lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/pgOz9oTSUn',\n",
        "  1.6666666666666667),\n",
        " (u'lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.6666666666666667),\n",
        " (u\"@lailayuile @TransLink if a car broke down this often, I'd get a new 1. They need 2 care 4 commuters &amp; not misuse funds or consumer faith.\",\n",
        "  0.3849001794597505),\n",
        " (u'RT @WoodfordCKNW980: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/pgOz9oTSUn',\n",
        "  1.507556722888818),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'Cloud, open source power TransLink&amp;#039;s Web presence -  It was an aging bespoke application that drove... http://t.co/ktPhXPTsNE',\n",
        "  0.0),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/NwqH3lEBy9',\n",
        "  0.0),\n",
        " (u'#translink the most expensive transit system in North America with the most shittest service year round.\\nWhy do we continue to put with this',\n",
        "  0.0),\n",
        " (u\"no one can truly say they think translink is shit until they've tried to take a bus in poco #trustme\",\n",
        "  -1.118033988749895),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u\"RT @minuteinthelife: .@lailayuile @TransLink Agreed! We need unbiased 'Lean Team' to assess everything ASAP! Reliable commutes needed more \\u2026\",\n",
        "  0.6882472016116852),\n",
        " (u'Cloud, open source power TransLink&amp;#039;s Web presence -  It was an aging bespoke application that drove... http://t.co/ktPhXPTsNE',\n",
        "  0.0),\n",
        " (u'RT @bakedwind: Haha! Win! #SkyTrain #translink #Translinkproblems http://t.co/KcuzCW6YhB',\n",
        "  2.4748737341529163),\n",
        " (u\"RT @minuteinthelife: @lailayuile @TransLink if a car broke down this often, I'd get a new 1. They need 2 care 4 commuters &amp; not misuse fund\\u2026\",\n",
        "  0.19245008972987526),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'RT @TransLink: #SkyTrain E-Line Power Rail replacement tonight 8pm onwards.Please allow up to 5 mins additional travel time.http://t.co/FrL\\u2026',\n",
        "  0.22941573387056174),\n",
        " (u'@gourmetcetera @gracemlau Translink is a regional organization it answers to the provincial government.',\n",
        "  0.0),\n",
        " (u'Cloud, open source power TransLink&amp;#039;s Web presence -  It was an aging bespoke application that drove... http://t.co/ktPhXPTsNE',\n",
        "  0.0),\n",
        " (u'\\u201c@WoodfordCKNW980: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/B3TWfiw6IF\\u201d\\U0001f602\\U0001f602\\U0001f602\\U0001f602\\U0001f602\\U0001f602\\U0001f602\\U0001f602\\U0001f44d\\U0001f44d\\U0001f44d\\U0001f44d\\U0001f44d\\U0001f44d',\n",
        "  1.4433756729740645),\n",
        " (u'We got more than we paid for with @TransLink today: a behind the scenes track tour! http://t.co/AHKAmSMyzm',\n",
        "  0.0),\n",
        " (u'How often does @translink #skytrain go down? I took it daily for couple years back when was in school and found to be reliable for most part',\n",
        "  0.0),\n",
        " (u'I hope that for a full &amp; transparent post mortem on July 21 &amp; 17 @TransLink \\u201ctechnical issues\\u201d i.e. 5 whys etc!!!!! http://t.co/CaJ8IqSru8',\n",
        "  0.41702882811414954),\n",
        " (u'@TransLink well, at least some type of maintenance happens. Perhaps time to maintain the computer system.',\n",
        "  0.0),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't waste 100s of 1000s on public art like poodles on sticks, it could keep SkyTrain running. http\\u2026\",\n",
        "  0.20412414523193154),\n",
        " (u'Skytrain trouble diagnosed: \"Translink\".', -1.0),\n",
        " (u'RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/NwqH3lEBy9',\n",
        "  0.0),\n",
        " (u'@TransLink The skytrain is closed at night as well ?? When does it open?',\n",
        "  0.0),\n",
        " (u\"@350Stroker @CKNW @TransLink It's perfect!\", 1.3416407864998738),\n",
        " (u'@Scamcouver I\\u2019ve got a differential diagnosis: Provincial Government. Intervening and contributing: Translink.',\n",
        "  0.0),\n",
        " (u'RT @LauraCoughlan: I\\'m thinking that tomorrow should be a \"FREE\" travel day for all transit users @TransLink',\n",
        "  0.24253562503633297),\n",
        " (u'RT @Pinchy82: How often does @translink #skytrain go down? I took it daily for couple years back when was in school and found to be reliabl\\u2026',\n",
        "  0.0),\n",
        " (u\"RT @MarkSweeney: With Vancouver's Skytrain system down, translink website for buses crashing, real-life Purge will probably commence w/rush\\u2026\",\n",
        "  0.0),\n",
        " (u'@CKNW @350Stroker @kathryn_stew   @TransLink  As a supporter of public transit and expansion.... I hate to see others complaining',\n",
        "  -0.47140452079103173),\n",
        " (u'@Hewy_ Horseshoe bay ferry? Should be transit to get there. Airport &gt; Stanley Park/Seawall &gt; Grouse &gt; Ferry. http://t.co/lauXjG5Zhs',\n",
        "  0.0),\n",
        " (u'RT @hosea24hours: \"Why ride when you can walk?\" Translink\\u2019s new motto. #skytrain',\n",
        "  0.0),\n",
        " (u'Extremely disappointed with @fusionrockradio assumptions.The piercing noise was coming from @TransLink speakersHis anxiety was getting worse',\n",
        "  -1.75),\n",
        " (u'RT @bakedwind: Haha! Win! #SkyTrain #translink #Translinkproblems http://t.co/KcuzCW6YhB',\n",
        "  2.4748737341529163),\n",
        " (u'RT @TransLink: #SkyTrain E-Line,M-Line back to regular service. Thank you for your patience &amp; sorry for the inconvenience. ^jkd',\n",
        "  -0.22941573387056174),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'@TransLink yeehaw!', 0.0),\n",
        " (u'The bus driver looks like he\\u2019s 20. Some kid must have hijacked the bus. #translink',\n",
        "  0.5),\n",
        " (u'RT @WoodfordCKNW980: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/pgOz9oTSUn',\n",
        "  1.507556722888818),\n",
        " (u\"@minuteinthelife @lailayuile @TransLink Misuse of funds has been going on so long, the public is numb to it &amp; it's wrong, we need that fixed\",\n",
        "  -0.6),\n",
        " (u'@TransLink Does that mean you owe us *2* explanations? \"It\\'s our transit system too.\" Actually, it\\'s all ours since we pay for it.',\n",
        "  -0.20851441405707477),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'@TransLink Candid explanations would go a long way toward reestablishing goodwill.',\n",
        "  0.0),\n",
        " (u'Bus driver came late and when I pressed the stop button he completely drove past my stop for a good 2 blocks @TransLink #getyourshittogether',\n",
        "  0.0),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'RT @bessleung: Young asian mom has 6weeks2find stem cell/bone marrow to live. http://t.co/BcSuAP6YpY @VancityBuzz @TransLink @shaymitch hel\\u2026',\n",
        "  0.0),\n",
        " (u'RT @WoodfordCKNW980: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/pgOz9oTSUn',\n",
        "  1.507556722888818),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'TransLink \"You can\\'t get there from here\" http://t.co/Wl5NtwQDRc', 0.0),\n",
        " (u'Were you affected by #Skytrain delays? Tweet us your pics and story http://t.co/pKbNrr3Eg9',\n",
        "  -0.2773500981126146),\n",
        " (u\"RT @jordanbateman: Maybe if TransLink didn't have 393 employees making six figures, it could afford to keep SkyTrain running. http://t.co/f\\u2026\",\n",
        "  0.0),\n",
        " (u'RT @DogfoodSoup: Mayor Gregor has already offered to buy broken expo line from Translink. Wants to paint it green and call it a bike lane.',\n",
        "  -0.2),\n",
        " (u'RT @LauraCoughlan: I\\'m thinking that tomorrow should be a \"FREE\" travel day for all transit users @TransLink',\n",
        "  0.24253562503633297),\n",
        " (u'RT @TransLink: #SkyTrain E-Line Power Rail replacement tonight 8pm onwards.Please allow up to 5 mins additional travel time.http://t.co/Nbu\\u2026',\n",
        "  0.22941573387056174),\n",
        " (u'RT @TransLink: #SkyTrain E-Line Power Rail replacement tonight 8pm onwards.Please allow up to 5 mins additional travel time.http://t.co/Nbu\\u2026',\n",
        "  0.22941573387056174),\n",
        " (u'Nope. Still working. \\n\\nHeard Translink might install pedals tonight. Just in case.',\n",
        "  0.0),\n",
        " (u'RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/NwqH3lEBy9',\n",
        "  0.0),\n",
        " (u'RT @CKNW: lol Thanks Brad RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/326ONxzZef',\n",
        "  1.507556722888818),\n",
        " (u'@VanCity12 @minuteinthelife @TransLink Therein lies the biggest part of the problem: Public tolerance despite ongoing issues',\n",
        "  -0.5),\n",
        " (u'RT @TransLink: @robbiesebullen Please take a moment to pass on the details of your experience http://t.co/1nutoyceIi  ^jkd',\n",
        "  0.24253562503633297),\n",
        " (u'RT @350Stroker: @kathryn_stew @CKNW @TransLink http://t.co/NwqH3lEBy9',\n",
        "  0.0),\n",
        " (u'@CKNW @350Stroker @kathryn_stew @TransLink Glad to see the graphic that I created is bringing laughter to so many. :-)',\n",
        "  0.6882472016116852),\n",
        " ...]"
       ]
      }
     ],
     "prompt_number": 39
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 39
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": [],
     "prompt_number": 39
    },
    {
     "cell_type": "code",
     "collapsed": false,
     "input": [],
     "language": "python",
     "metadata": {},
     "outputs": []
    }
   ],
   "metadata": {}
  }
 ]
}