Twitter Sentiment of a Stock Name.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied (use --upgrade to upgrade): twitter in c:\\users\\shraddha somani\\anaconda3\\lib\\site-packages\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "You are using pip version 8.1.2, however version 9.0.1 is available.\n",
      "You should consider upgrading via the 'python -m pip install --upgrade pip' command.\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied (use --upgrade to upgrade): textblob in c:\\users\\shraddha somani\\anaconda3\\lib\\site-packages\n",
      "Requirement already satisfied (use --upgrade to upgrade): nltk>=3.1 in c:\\users\\shraddha somani\\anaconda3\\lib\\site-packages (from textblob)\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "You are using pip version 8.1.2, however version 9.0.1 is available.\n",
      "You should consider upgrading via the 'python -m pip install --upgrade pip' command.\n"
     ]
    }
   ],
   "source": [
    "import pip\n",
    "pip.main([\"install\",\"twitter\"])\n",
    "pip.main([\"install\",\"textblob\"])\n",
    "from textblob import TextBlob\n",
    "import nltk\n",
    "import numpy as np\n",
    "import pandas as pd\n",
    "import json\n",
    "import twitter\n",
    "from twitter import Twitter \n",
    "from twitter import OAuth \n",
    "from twitter import TwitterHTTPError \n",
    "from twitter import TwitterStream\n",
    "from pandas.io.json import json_normalize\n",
    "from collections import Counter"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Authenticate\n",
    "ACCESS_TOKEN = '3151548164-KGXKM6vZipCfBfIA16bUxBaNhIcg7CmfiYb6iWU'\n",
    "ACCESS_SECRET = '8qKGbi5JRnrZb3yKcKijbYxVHVZ4lFonuQDsN3dWonzao'\n",
    "consumer_key = 'nqn05e7YWcj57FBzJhu2vJpQU'\n",
    "consumer_secret = 'a3Y1S2DXVkbRoGaO3NMgstbGm4LSAyRnKSeShseZFrFqWmTwJo'\n",
    "oauth = OAuth(ACCESS_TOKEN, ACCESS_SECRET, consumer_key, consumer_secret)\n",
    "twitter = Twitter(auth=oauth)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "0     RT @teslarians: @Bar2lucci @elonmusk so riddle...\n",
       "1     Robert W. Baird Reiterates “Outperform” Rating...\n",
       "2     RT @businessinsider: Here's what Tesla's large...\n",
       "3     $TSLA I have to admit was skeptical after the ...\n",
       "4     RT @BAMMERPICS: NNSR #reverseMergers #mjstocks...\n",
       "5     $TSLA I have to admit was skeptical after the ...\n",
       "6     Tesla, Inc. (NasdaqGS:TSLA) Valuation &amp; Te...\n",
       "7                   米国株の安心感はなんだろう。SQもTSLAもMSFTも上場来高値更新。\n",
       "8     TSLA: $305.6 - Market Cap: $50.17B 4/21/2017, ...\n",
       "9                                          時間が経つのははやいなあ\n",
       "10    @Bar2lucci @elonmusk so riddle me this, why wa...\n",
       "11    Next time you call @elonmusk a genius, just re...\n",
       "12    RT @FoxBusiness: Tesla to recall 53,000 cars o...\n",
       "13    @MONSTERstacks Haven't heard one good bullish ...\n",
       "14    This is just to much.  Short $tsla⚡️ “Elon Mus...\n",
       "15    Why Buzz Aldrin favors Bezos over Musk in spac...\n",
       "16    RT @BAMMERPICS: NNSR #reverseMergers #mjstocks...\n",
       "17    RT @Louie_SFO: Tax cuts promises were a mirage...\n",
       "18    RT @NaviAvatar1: Dow Down 30, $AAPL $AMZN $TSL...\n",
       "19    Account established April 2017, 7 tweets, Foll...\n",
       "20    Tax cuts promises were a mirage. We've been co...\n",
       "21    Word's getting around. $TSLA #VeryShortable ht...\n",
       "22    RT @_David_Keith: $TSLA @TeslaMotors's archite...\n",
       "23    TSLA: $305.6 - Market Cap: $49.78B 4/21/2017, ...\n",
       "24                                         アルゴよ、それは恋じゃ。\n",
       "25    Ugh. Is this a march for climate or a march fo...\n",
       "26    RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...\n",
       "27    Equity Update &amp; Outlook on Tesla Motors, I...\n",
       "28    RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...\n",
       "29    Dow Down 30, $AAPL $AMZN $TSLA $NVDA $FB $BABA...\n",
       "                            ...                        \n",
       "70    RT @myhedghog: A little bit weary of an actual...\n",
       "71    RT @ProVesting: $AMZN $AAPL $GOOGL $TSLA:\\n\\nA...\n",
       "72    #ThankYou for following us. #yourethebest. #Af...\n",
       "73    RT @MarkYusko: Shorting is like playing Chess ...\n",
       "74    RT @MarkYusko: Shorting is like playing Chess ...\n",
       "75    Exploiting Earnings Volatility by Brian Johnso...\n",
       "76    Tesla could add billions in revenue from semi ...\n",
       "77    Tesla Admits SolarCity Is Undergoing A 'Financ...\n",
       "78    Folks who'v never owned $TSLA --car/stock--spe...\n",
       "79    Tesla Inc (TSLA) Stock Little Affected By Park...\n",
       "80    A little bit weary of an actual tax reform ann...\n",
       "81    RT @KoloMediaGroup: As our thanks, you can als...\n",
       "82    RT @KoloMediaGroup: As our thanks, you can als...\n",
       "83    TSLA: $305.6 - Market Cap: $49.78B 4/21/2017, ...\n",
       "84    As our thanks, you can also choose one of thes...\n",
       "85    As our thanks, you can also choose one of thes...\n",
       "86    As our thanks, you can also choose one of thes...\n",
       "87    As our thanks, you can also choose one of thes...\n",
       "88    As our thanks, you can also choose one of thes...\n",
       "89                イードのおっぱいには夢と希望は詰まっている。私には詰まってない。死にたい。\n",
       "90    Tesla Sued For 'Defective' Autopilot 2 https:/...\n",
       "91    As our thanks, you can also choose one of thes...\n",
       "92    RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...\n",
       "93    RT @CNBCFastMoney: Tesla today resembles Amazo...\n",
       "94    RT @KopeeDunt: Commented on Tesla Selling Mode...\n",
       "95    RT @MarkYusko: Shorting is like playing Chess ...\n",
       "96    RT @jennajenovich: When you pull up to take pr...\n",
       "97    Commented on Tesla Selling Model 3 Test Cars: ...\n",
       "98    RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...\n",
       "99    $AMZN $AAPL $GOOGL $TSLA:\\n\\nAmazon, Apple, an...\n",
       "Name: text, dtype: object"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Take a ticker for any stock (example: tsla) and search all the tweets about it\n",
    "search_results = twitter.search.tweets(q = 'tsla', count = 100)\n",
    "statuses = search_results['statuses']\n",
    "df = json_normalize(search_results, 'statuses')\n",
    "status_texts = df[\"text\"]\n",
    "status_texts"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "100"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Calculate polarity of tweets\n",
    "polarity = []\n",
    "for x in status_texts:\n",
    "    polarity.append(TextBlob(x).sentiment.polarity)\n",
    "polarity\n",
    "len(polarity)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[-0.13333333333333333,\n",
       " 0.0,\n",
       " 0.0,\n",
       " -0.022222222222222237,\n",
       " 0.0,\n",
       " -0.022222222222222237,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " -0.13333333333333333,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.35,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " -0.15555555555555559,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " -0.15555555555555559,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " -0.05,\n",
       " -0.6,\n",
       " -0.25,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.43333333333333335,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.2,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.14545454545454542,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " -0.5,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.20000000000000004,\n",
       " -0.1,\n",
       " -0.125,\n",
       " 0.0,\n",
       " 0.2,\n",
       " 0.5,\n",
       " 0.22499999999999998,\n",
       " 0.11603174603174601,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.03125,\n",
       " 0.221875,\n",
       " -0.25,\n",
       " -0.0625,\n",
       " -0.0625,\n",
       " 0.25,\n",
       " 0.0,\n",
       " -0.35,\n",
       " -0.35,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.4,\n",
       " -0.1875,\n",
       " -0.0625,\n",
       " 0.30000000000000004,\n",
       " 0.30000000000000004,\n",
       " 0.0,\n",
       " 0.30000000000000004,\n",
       " 0.30000000000000004,\n",
       " 0.30000000000000004,\n",
       " 0.30000000000000004,\n",
       " 0.30000000000000004,\n",
       " 0.0,\n",
       " 0.08,\n",
       " 0.30000000000000004,\n",
       " 0.0,\n",
       " 0.25,\n",
       " 0.0,\n",
       " -0.35,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.0,\n",
       " 0.25]"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "polarity"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Swake183',\n",
       " 'dailymailtimes',\n",
       " 'mexautomotive',\n",
       " 'giveawayboyya',\n",
       " 'manzuray18mo',\n",
       " 'BonanzaTrade',\n",
       " 'JeffJSchopp',\n",
       " 'chubchubkun',\n",
       " 'TSLA_Bot',\n",
       " 'tsla_',\n",
       " 'teslarians',\n",
       " 'Bar2lucci',\n",
       " 'IamJohnBurnett',\n",
       " 'DStevems',\n",
       " 'DStevems',\n",
       " 'markbspiegel',\n",
       " 'snezhanadyachk4',\n",
       " 'diggingplatinum',\n",
       " 'MuRk_MoNsT3R',\n",
       " 'jakscholes',\n",
       " 'Louie_SFO',\n",
       " 'jakscholes',\n",
       " 'tarheel_mel',\n",
       " 'TSLA_Bot',\n",
       " 'tsla_',\n",
       " 'apoorv_bh89',\n",
       " 'JellyIntoAJam',\n",
       " 'krishdtech',\n",
       " 'LSValue',\n",
       " 'NaviAvatar1',\n",
       " 'NaviAvatar1',\n",
       " 'moneybusiness15',\n",
       " 'thaynes1993',\n",
       " 'y4ShSRihf0LB9Og',\n",
       " 'Bar2lucci',\n",
       " 'KopeeDunt',\n",
       " 'Investing_Books',\n",
       " 'StakepoolCom',\n",
       " 'theRLDL',\n",
       " 'AmyDaniel212',\n",
       " 'TSOH_Investing',\n",
       " 'TSLA_Bot',\n",
       " 'CannyFuturist',\n",
       " 'tsla_',\n",
       " 'kenr0966',\n",
       " 'TSLAto500',\n",
       " 'KilaniBadr',\n",
       " 'LukeBrueggemann',\n",
       " 'ClassyLady4DJT',\n",
       " 'Investing_Books',\n",
       " 'Other_Side_News',\n",
       " 'jakscholes',\n",
       " 'DowdEdward',\n",
       " 'Bar2lucci',\n",
       " 'jakscholes',\n",
       " 'CJBrigham',\n",
       " 'ChinaStories',\n",
       " 'Bubba_00070',\n",
       " 'AntonDeyes',\n",
       " 'TSLA_Bot',\n",
       " 'jakscholes',\n",
       " 'markbspiegel',\n",
       " 'JFDI',\n",
       " 'SFCDR',\n",
       " 'KopeeDunt',\n",
       " 'KopeeDunt',\n",
       " 'isidrolo80',\n",
       " 'jaywhitcraft',\n",
       " 'lilmike_2013',\n",
       " 'jakscholes',\n",
       " 'diggingplatinum',\n",
       " 'diggingplatinum',\n",
       " 'AmyDaniel212',\n",
       " 'SLurko',\n",
       " 'anthonyunplug',\n",
       " 'Investing_Books',\n",
       " 'jjjinvesting',\n",
       " 'zackhoward',\n",
       " 'RaviRomo',\n",
       " 'biteszHQNews',\n",
       " 'myhedghog',\n",
       " 'OptionAlarm',\n",
       " 'optionalarmchat',\n",
       " 'TSLA_Bot',\n",
       " 'PennyStockPlan',\n",
       " 'ExactOptionPick',\n",
       " 'PennyStockRally',\n",
       " 'ExactStockPicks',\n",
       " 'KoloMediaGroup',\n",
       " 'tsla_',\n",
       " 'jjjinvesting',\n",
       " 'PennyStockPlan',\n",
       " 'AlexanderLevit',\n",
       " 'DoubleCohort',\n",
       " 'AnythingKendall',\n",
       " 'MONSTERstacks',\n",
       " 'MongfeFong',\n",
       " 'KopeeDunt',\n",
       " 'jenhoge',\n",
       " 'ProVesting']"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Get Screen Names\n",
    "screen_names = [status['user']['screen_name']\n",
    "               for status in statuses]\n",
    "screen_names"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# Identify all the screen names that are positive (.7 or greaters) and negative (-.7 and less)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[]"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Polarity 0.7 or greater\n",
    "screen_names_high = [status['user']['screen_name']\n",
    "               for status in statuses\n",
    "                    if TextBlob(status['text']).sentiment.polarity >= 0.7]\n",
    "screen_names_high"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['Swake183',\n",
       " 'dailymailtimes',\n",
       " 'mexautomotive',\n",
       " 'giveawayboyya',\n",
       " 'manzuray18mo',\n",
       " 'BonanzaTrade',\n",
       " 'JeffJSchopp',\n",
       " 'chubchubkun',\n",
       " 'TSLA_Bot',\n",
       " 'tsla_',\n",
       " 'teslarians',\n",
       " 'Bar2lucci',\n",
       " 'IamJohnBurnett',\n",
       " 'DStevems',\n",
       " 'DStevems',\n",
       " 'markbspiegel',\n",
       " 'snezhanadyachk4',\n",
       " 'diggingplatinum',\n",
       " 'MuRk_MoNsT3R',\n",
       " 'jakscholes',\n",
       " 'Louie_SFO',\n",
       " 'jakscholes',\n",
       " 'tarheel_mel',\n",
       " 'TSLA_Bot',\n",
       " 'tsla_',\n",
       " 'apoorv_bh89',\n",
       " 'JellyIntoAJam',\n",
       " 'krishdtech',\n",
       " 'LSValue',\n",
       " 'NaviAvatar1',\n",
       " 'NaviAvatar1',\n",
       " 'moneybusiness15',\n",
       " 'thaynes1993',\n",
       " 'y4ShSRihf0LB9Og',\n",
       " 'Bar2lucci',\n",
       " 'KopeeDunt',\n",
       " 'Investing_Books',\n",
       " 'StakepoolCom',\n",
       " 'theRLDL',\n",
       " 'AmyDaniel212',\n",
       " 'TSOH_Investing',\n",
       " 'TSLA_Bot',\n",
       " 'CannyFuturist',\n",
       " 'tsla_',\n",
       " 'kenr0966',\n",
       " 'TSLAto500',\n",
       " 'KilaniBadr',\n",
       " 'LukeBrueggemann',\n",
       " 'ClassyLady4DJT',\n",
       " 'Investing_Books',\n",
       " 'Other_Side_News',\n",
       " 'jakscholes',\n",
       " 'DowdEdward',\n",
       " 'Bar2lucci',\n",
       " 'jakscholes',\n",
       " 'CJBrigham',\n",
       " 'ChinaStories',\n",
       " 'Bubba_00070',\n",
       " 'AntonDeyes',\n",
       " 'TSLA_Bot',\n",
       " 'jakscholes',\n",
       " 'markbspiegel',\n",
       " 'JFDI',\n",
       " 'SFCDR',\n",
       " 'KopeeDunt',\n",
       " 'KopeeDunt',\n",
       " 'isidrolo80',\n",
       " 'jaywhitcraft',\n",
       " 'lilmike_2013',\n",
       " 'jakscholes',\n",
       " 'diggingplatinum',\n",
       " 'diggingplatinum',\n",
       " 'AmyDaniel212',\n",
       " 'SLurko',\n",
       " 'anthonyunplug',\n",
       " 'Investing_Books',\n",
       " 'jjjinvesting',\n",
       " 'zackhoward',\n",
       " 'RaviRomo',\n",
       " 'biteszHQNews',\n",
       " 'myhedghog',\n",
       " 'OptionAlarm',\n",
       " 'optionalarmchat',\n",
       " 'TSLA_Bot',\n",
       " 'PennyStockPlan',\n",
       " 'ExactOptionPick',\n",
       " 'PennyStockRally',\n",
       " 'ExactStockPicks',\n",
       " 'KoloMediaGroup',\n",
       " 'tsla_',\n",
       " 'jjjinvesting',\n",
       " 'PennyStockPlan',\n",
       " 'AlexanderLevit',\n",
       " 'DoubleCohort',\n",
       " 'AnythingKendall',\n",
       " 'MONSTERstacks',\n",
       " 'MongfeFong',\n",
       " 'KopeeDunt',\n",
       " 'jenhoge',\n",
       " 'ProVesting']"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Polarity -0.7 or lower\n",
    "screen_names_low = [status['user']['screen_name']\n",
    "               for status in statuses\n",
    "                    if TextBlob(status['text']).sentiment.polarity >= -0.7]                    \n",
    "screen_names_low"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Polarity</th>\n",
       "      <th>Screen Name</th>\n",
       "      <th>Tweets</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>-0.133333</td>\n",
       "      <td>Swake183</td>\n",
       "      <td>RT @teslarians: @Bar2lucci @elonmusk so riddle...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>dailymailtimes</td>\n",
       "      <td>Robert W. Baird Reiterates “Outperform” Rating...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>mexautomotive</td>\n",
       "      <td>RT @businessinsider: Here's what Tesla's large...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>-0.022222</td>\n",
       "      <td>giveawayboyya</td>\n",
       "      <td>$TSLA I have to admit was skeptical after the ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>manzuray18mo</td>\n",
       "      <td>RT @BAMMERPICS: NNSR #reverseMergers #mjstocks...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>-0.022222</td>\n",
       "      <td>BonanzaTrade</td>\n",
       "      <td>$TSLA I have to admit was skeptical after the ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>JeffJSchopp</td>\n",
       "      <td>Tesla, Inc. (NasdaqGS:TSLA) Valuation &amp;amp; Te...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>chubchubkun</td>\n",
       "      <td>米国株の安心感はなんだろう。SQもTSLAもMSFTも上場来高値更新。</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>TSLA_Bot</td>\n",
       "      <td>TSLA: $305.6 - Market Cap: $50.17B 4/21/2017, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>tsla_</td>\n",
       "      <td>時間が経つのははやいなあ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>-0.133333</td>\n",
       "      <td>teslarians</td>\n",
       "      <td>@Bar2lucci @elonmusk so riddle me this, why wa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>Bar2lucci</td>\n",
       "      <td>Next time you call @elonmusk a genius, just re...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>IamJohnBurnett</td>\n",
       "      <td>RT @FoxBusiness: Tesla to recall 53,000 cars o...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>0.350000</td>\n",
       "      <td>DStevems</td>\n",
       "      <td>@MONSTERstacks Haven't heard one good bullish ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>DStevems</td>\n",
       "      <td>This is just to much.  Short $tsla⚡️ “Elon Mus...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>markbspiegel</td>\n",
       "      <td>Why Buzz Aldrin favors Bezos over Musk in spac...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>snezhanadyachk4</td>\n",
       "      <td>RT @BAMMERPICS: NNSR #reverseMergers #mjstocks...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>diggingplatinum</td>\n",
       "      <td>RT @Louie_SFO: Tax cuts promises were a mirage...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>-0.155556</td>\n",
       "      <td>MuRk_MoNsT3R</td>\n",
       "      <td>RT @NaviAvatar1: Dow Down 30, $AAPL $AMZN $TSL...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>jakscholes</td>\n",
       "      <td>Account established April 2017, 7 tweets, Foll...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>Louie_SFO</td>\n",
       "      <td>Tax cuts promises were a mirage. We've been co...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>jakscholes</td>\n",
       "      <td>Word's getting around. $TSLA #VeryShortable ht...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>tarheel_mel</td>\n",
       "      <td>RT @_David_Keith: $TSLA @TeslaMotors's archite...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>TSLA_Bot</td>\n",
       "      <td>TSLA: $305.6 - Market Cap: $49.78B 4/21/2017, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>tsla_</td>\n",
       "      <td>アルゴよ、それは恋じゃ。</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>apoorv_bh89</td>\n",
       "      <td>Ugh. Is this a march for climate or a march fo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>JellyIntoAJam</td>\n",
       "      <td>RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>krishdtech</td>\n",
       "      <td>Equity Update &amp;amp; Outlook on Tesla Motors, I...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>LSValue</td>\n",
       "      <td>RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>-0.155556</td>\n",
       "      <td>NaviAvatar1</td>\n",
       "      <td>Dow Down 30, $AAPL $AMZN $TSLA $NVDA $FB $BABA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>70</th>\n",
       "      <td>-0.062500</td>\n",
       "      <td>diggingplatinum</td>\n",
       "      <td>RT @myhedghog: A little bit weary of an actual...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>71</th>\n",
       "      <td>0.250000</td>\n",
       "      <td>diggingplatinum</td>\n",
       "      <td>RT @ProVesting: $AMZN $AAPL $GOOGL $TSLA:\\n\\nA...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>72</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>AmyDaniel212</td>\n",
       "      <td>#ThankYou for following us. #yourethebest. #Af...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>73</th>\n",
       "      <td>-0.350000</td>\n",
       "      <td>SLurko</td>\n",
       "      <td>RT @MarkYusko: Shorting is like playing Chess ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>74</th>\n",
       "      <td>-0.350000</td>\n",
       "      <td>anthonyunplug</td>\n",
       "      <td>RT @MarkYusko: Shorting is like playing Chess ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>Investing_Books</td>\n",
       "      <td>Exploiting Earnings Volatility by Brian Johnso...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>jjjinvesting</td>\n",
       "      <td>Tesla could add billions in revenue from semi ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>77</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>zackhoward</td>\n",
       "      <td>Tesla Admits SolarCity Is Undergoing A 'Financ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>78</th>\n",
       "      <td>0.400000</td>\n",
       "      <td>RaviRomo</td>\n",
       "      <td>Folks who'v never owned $TSLA --car/stock--spe...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>79</th>\n",
       "      <td>-0.187500</td>\n",
       "      <td>biteszHQNews</td>\n",
       "      <td>Tesla Inc (TSLA) Stock Little Affected By Park...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>80</th>\n",
       "      <td>-0.062500</td>\n",
       "      <td>myhedghog</td>\n",
       "      <td>A little bit weary of an actual tax reform ann...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>81</th>\n",
       "      <td>0.300000</td>\n",
       "      <td>OptionAlarm</td>\n",
       "      <td>RT @KoloMediaGroup: As our thanks, you can als...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>82</th>\n",
       "      <td>0.300000</td>\n",
       "      <td>optionalarmchat</td>\n",
       "      <td>RT @KoloMediaGroup: As our thanks, you can als...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>83</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>TSLA_Bot</td>\n",
       "      <td>TSLA: $305.6 - Market Cap: $49.78B 4/21/2017, ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>84</th>\n",
       "      <td>0.300000</td>\n",
       "      <td>PennyStockPlan</td>\n",
       "      <td>As our thanks, you can also choose one of thes...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>85</th>\n",
       "      <td>0.300000</td>\n",
       "      <td>ExactOptionPick</td>\n",
       "      <td>As our thanks, you can also choose one of thes...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>86</th>\n",
       "      <td>0.300000</td>\n",
       "      <td>PennyStockRally</td>\n",
       "      <td>As our thanks, you can also choose one of thes...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>87</th>\n",
       "      <td>0.300000</td>\n",
       "      <td>ExactStockPicks</td>\n",
       "      <td>As our thanks, you can also choose one of thes...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>88</th>\n",
       "      <td>0.300000</td>\n",
       "      <td>KoloMediaGroup</td>\n",
       "      <td>As our thanks, you can also choose one of thes...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>tsla_</td>\n",
       "      <td>イードのおっぱいには夢と希望は詰まっている。私には詰まってない。死にたい。</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>90</th>\n",
       "      <td>0.080000</td>\n",
       "      <td>jjjinvesting</td>\n",
       "      <td>Tesla Sued For 'Defective' Autopilot 2 https:/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>91</th>\n",
       "      <td>0.300000</td>\n",
       "      <td>PennyStockPlan</td>\n",
       "      <td>As our thanks, you can also choose one of thes...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>AlexanderLevit</td>\n",
       "      <td>RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>93</th>\n",
       "      <td>0.250000</td>\n",
       "      <td>DoubleCohort</td>\n",
       "      <td>RT @CNBCFastMoney: Tesla today resembles Amazo...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>94</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>AnythingKendall</td>\n",
       "      <td>RT @KopeeDunt: Commented on Tesla Selling Mode...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>95</th>\n",
       "      <td>-0.350000</td>\n",
       "      <td>MONSTERstacks</td>\n",
       "      <td>RT @MarkYusko: Shorting is like playing Chess ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>96</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>MongfeFong</td>\n",
       "      <td>RT @jennajenovich: When you pull up to take pr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>97</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>KopeeDunt</td>\n",
       "      <td>Commented on Tesla Selling Model 3 Test Cars: ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>0.000000</td>\n",
       "      <td>jenhoge</td>\n",
       "      <td>RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>0.250000</td>\n",
       "      <td>ProVesting</td>\n",
       "      <td>$AMZN $AAPL $GOOGL $TSLA:\\n\\nAmazon, Apple, an...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>100 rows × 3 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "    Polarity      Screen Name  \\\n",
       "0  -0.133333         Swake183   \n",
       "1   0.000000   dailymailtimes   \n",
       "2   0.000000    mexautomotive   \n",
       "3  -0.022222    giveawayboyya   \n",
       "4   0.000000     manzuray18mo   \n",
       "5  -0.022222     BonanzaTrade   \n",
       "6   0.000000      JeffJSchopp   \n",
       "7   0.000000      chubchubkun   \n",
       "8   0.000000         TSLA_Bot   \n",
       "9   0.000000            tsla_   \n",
       "10 -0.133333       teslarians   \n",
       "11  0.000000        Bar2lucci   \n",
       "12  0.000000   IamJohnBurnett   \n",
       "13  0.350000         DStevems   \n",
       "14  0.000000         DStevems   \n",
       "15  0.000000     markbspiegel   \n",
       "16  0.000000  snezhanadyachk4   \n",
       "17  0.000000  diggingplatinum   \n",
       "18 -0.155556     MuRk_MoNsT3R   \n",
       "19  0.000000       jakscholes   \n",
       "20  0.000000        Louie_SFO   \n",
       "21  0.000000       jakscholes   \n",
       "22  0.000000      tarheel_mel   \n",
       "23  0.000000         TSLA_Bot   \n",
       "24  0.000000            tsla_   \n",
       "25  0.000000      apoorv_bh89   \n",
       "26  0.000000    JellyIntoAJam   \n",
       "27  0.000000       krishdtech   \n",
       "28  0.000000          LSValue   \n",
       "29 -0.155556      NaviAvatar1   \n",
       "..       ...              ...   \n",
       "70 -0.062500  diggingplatinum   \n",
       "71  0.250000  diggingplatinum   \n",
       "72  0.000000     AmyDaniel212   \n",
       "73 -0.350000           SLurko   \n",
       "74 -0.350000    anthonyunplug   \n",
       "75  0.000000  Investing_Books   \n",
       "76  0.000000     jjjinvesting   \n",
       "77  0.000000       zackhoward   \n",
       "78  0.400000         RaviRomo   \n",
       "79 -0.187500     biteszHQNews   \n",
       "80 -0.062500        myhedghog   \n",
       "81  0.300000      OptionAlarm   \n",
       "82  0.300000  optionalarmchat   \n",
       "83  0.000000         TSLA_Bot   \n",
       "84  0.300000   PennyStockPlan   \n",
       "85  0.300000  ExactOptionPick   \n",
       "86  0.300000  PennyStockRally   \n",
       "87  0.300000  ExactStockPicks   \n",
       "88  0.300000   KoloMediaGroup   \n",
       "89  0.000000            tsla_   \n",
       "90  0.080000     jjjinvesting   \n",
       "91  0.300000   PennyStockPlan   \n",
       "92  0.000000   AlexanderLevit   \n",
       "93  0.250000     DoubleCohort   \n",
       "94  0.000000  AnythingKendall   \n",
       "95 -0.350000    MONSTERstacks   \n",
       "96  0.000000       MongfeFong   \n",
       "97  0.000000        KopeeDunt   \n",
       "98  0.000000          jenhoge   \n",
       "99  0.250000       ProVesting   \n",
       "\n",
       "                                               Tweets  \n",
       "0   RT @teslarians: @Bar2lucci @elonmusk so riddle...  \n",
       "1   Robert W. Baird Reiterates “Outperform” Rating...  \n",
       "2   RT @businessinsider: Here's what Tesla's large...  \n",
       "3   $TSLA I have to admit was skeptical after the ...  \n",
       "4   RT @BAMMERPICS: NNSR #reverseMergers #mjstocks...  \n",
       "5   $TSLA I have to admit was skeptical after the ...  \n",
       "6   Tesla, Inc. (NasdaqGS:TSLA) Valuation &amp; Te...  \n",
       "7                 米国株の安心感はなんだろう。SQもTSLAもMSFTも上場来高値更新。  \n",
       "8   TSLA: $305.6 - Market Cap: $50.17B 4/21/2017, ...  \n",
       "9                                        時間が経つのははやいなあ  \n",
       "10  @Bar2lucci @elonmusk so riddle me this, why wa...  \n",
       "11  Next time you call @elonmusk a genius, just re...  \n",
       "12  RT @FoxBusiness: Tesla to recall 53,000 cars o...  \n",
       "13  @MONSTERstacks Haven't heard one good bullish ...  \n",
       "14  This is just to much.  Short $tsla⚡️ “Elon Mus...  \n",
       "15  Why Buzz Aldrin favors Bezos over Musk in spac...  \n",
       "16  RT @BAMMERPICS: NNSR #reverseMergers #mjstocks...  \n",
       "17  RT @Louie_SFO: Tax cuts promises were a mirage...  \n",
       "18  RT @NaviAvatar1: Dow Down 30, $AAPL $AMZN $TSL...  \n",
       "19  Account established April 2017, 7 tweets, Foll...  \n",
       "20  Tax cuts promises were a mirage. We've been co...  \n",
       "21  Word's getting around. $TSLA #VeryShortable ht...  \n",
       "22  RT @_David_Keith: $TSLA @TeslaMotors's archite...  \n",
       "23  TSLA: $305.6 - Market Cap: $49.78B 4/21/2017, ...  \n",
       "24                                       アルゴよ、それは恋じゃ。  \n",
       "25  Ugh. Is this a march for climate or a march fo...  \n",
       "26  RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...  \n",
       "27  Equity Update &amp; Outlook on Tesla Motors, I...  \n",
       "28  RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...  \n",
       "29  Dow Down 30, $AAPL $AMZN $TSLA $NVDA $FB $BABA...  \n",
       "..                                                ...  \n",
       "70  RT @myhedghog: A little bit weary of an actual...  \n",
       "71  RT @ProVesting: $AMZN $AAPL $GOOGL $TSLA:\\n\\nA...  \n",
       "72  #ThankYou for following us. #yourethebest. #Af...  \n",
       "73  RT @MarkYusko: Shorting is like playing Chess ...  \n",
       "74  RT @MarkYusko: Shorting is like playing Chess ...  \n",
       "75  Exploiting Earnings Volatility by Brian Johnso...  \n",
       "76  Tesla could add billions in revenue from semi ...  \n",
       "77  Tesla Admits SolarCity Is Undergoing A 'Financ...  \n",
       "78  Folks who'v never owned $TSLA --car/stock--spe...  \n",
       "79  Tesla Inc (TSLA) Stock Little Affected By Park...  \n",
       "80  A little bit weary of an actual tax reform ann...  \n",
       "81  RT @KoloMediaGroup: As our thanks, you can als...  \n",
       "82  RT @KoloMediaGroup: As our thanks, you can als...  \n",
       "83  TSLA: $305.6 - Market Cap: $49.78B 4/21/2017, ...  \n",
       "84  As our thanks, you can also choose one of thes...  \n",
       "85  As our thanks, you can also choose one of thes...  \n",
       "86  As our thanks, you can also choose one of thes...  \n",
       "87  As our thanks, you can also choose one of thes...  \n",
       "88  As our thanks, you can also choose one of thes...  \n",
       "89              イードのおっぱいには夢と希望は詰まっている。私には詰まってない。死にたい。  \n",
       "90  Tesla Sued For 'Defective' Autopilot 2 https:/...  \n",
       "91  As our thanks, you can also choose one of thes...  \n",
       "92  RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...  \n",
       "93  RT @CNBCFastMoney: Tesla today resembles Amazo...  \n",
       "94  RT @KopeeDunt: Commented on Tesla Selling Mode...  \n",
       "95  RT @MarkYusko: Shorting is like playing Chess ...  \n",
       "96  RT @jennajenovich: When you pull up to take pr...  \n",
       "97  Commented on Tesla Selling Model 3 Test Cars: ...  \n",
       "98  RT @MelissaLeeCNBC: $TSLA recalls 53k vehicles...  \n",
       "99  $AMZN $AAPL $GOOGL $TSLA:\\n\\nAmazon, Apple, an...  \n",
       "\n",
       "[100 rows x 3 columns]"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Create a new data frame of Ploarity, Screen Names and Tweets\n",
    "df_final = pd.DataFrame({\"Polarity\" : polarity, \"Screen Name\" : screen_names, \"Tweets\" : status_texts})\n",
    "df_final"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'markbspiegel'"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Identify highest and lowest user based on polarity\n",
    "user_highest = df_final.loc[df_final[\"Polarity\"].idxmax()][\"Screen Name\"]\n",
    "user_highest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "'Bar2lucci'"
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "user_lowest = df_final.loc[df_final[\"Polarity\"].idxmin()][\"Screen Name\"]\n",
    "user_lowest"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [default]",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}