Untitled7_git.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import tweepy\n",
    "import re, datetime,json, pandas as pd\n",
    "consumer_key = ''\n",
    "consumer_secret = ''\n",
    "access_token = '-'\n",
    "access_token_secret = ''\n",
    "auth = tweepy.OAuthHandler(consumer_key, consumer_secret)\n",
    "auth.set_access_token(access_token, access_token_secret)\n",
    "api = tweepy.API(auth)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Twitter Api kullanılarak Hillary Clinton kişisinin tweet bilgisinin alınması"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Twitter'dan çekilen tweet bilgisini otomatik okumak için gerekli şablonu içinde barındıran class yapısıdır."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#TweetMiner function from Nisanur Bulut\n",
    "\n",
    "class TweetMiner(object):\n",
    "\n",
    "    \n",
    "    def __init__(self, api, result_limit = 20):\n",
    "        \n",
    "        self.api = api        \n",
    "        self.result_limit = result_limit\n",
    "        \n",
    "\n",
    "    def mine_user_tweets(self, user=\"HillaryClinton\", mine_retweets=False, max_pages=20):\n",
    "\n",
    "        data           =  []\n",
    "        last_tweet_id  =  False\n",
    "        page           =  1\n",
    "        \n",
    "        while page <= max_pages:\n",
    "            \n",
    "            if last_tweet_id:\n",
    "                statuses   =   self.api.user_timeline(screen_name=user, count=self.result_limit, max_id=last_tweet_id - 1, include_rts=mine_retweets)                               \n",
    "                          \n",
    "            else:\n",
    "                statuses   =   self.api.user_timeline(screen_name=user, count=self.result_limit, include_rts=mine_retweets)\n",
    "               \n",
    "               \n",
    "            \n",
    "            for item in statuses:                              \n",
    "                item1=json.loads(json.dumps(item._json)) \n",
    "\n",
    "                # try except alanı\n",
    "                # retweet alanı sıfır ise go to except \n",
    "                try:\n",
    "                   \n",
    "                    mined = {\n",
    "                        'tweet_id':        item1['id'],\n",
    "                        'handle':          item1['user']['screen_name'],\n",
    "                        'retweet_count':   item1['retweet_count'],\n",
    "                        'text':            item1['text'],\n",
    "                        'mined_at':        datetime.datetime.now(),\n",
    "                        'created_at':      item1['created_at'],\n",
    "                    }\n",
    "                \n",
    "                except:\n",
    "                        mined = {\n",
    "                        'tweet_id':        item1['id'],\n",
    "                        'handle':          item1['user']['screen_name'],\n",
    "                        'retweet_count':   0,\n",
    "                        'text':            item1['text'],\n",
    "                        'mined_at':        datetime.datetime.now(),\n",
    "                        'created_at':      item1['created_at'],\n",
    "                    }\n",
    "                \n",
    "                last_tweet_id = item1['id']\n",
    "                data.append(mined)\n",
    "                \n",
    "            page += 1\n",
    "            \n",
    "        return data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Veri çekimi\n",
    "miner = TweetMiner(api, result_limit=2)\n",
    "hillary = miner.mine_user_tweets(user=\"HillaryClinton\")\n",
    "donald = miner.mine_user_tweets(user=\"realDonaldTrump\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>created_at</th>\n",
       "      <th>handle</th>\n",
       "      <th>mined_at</th>\n",
       "      <th>retweet_count</th>\n",
       "      <th>text</th>\n",
       "      <th>tweet_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fri Dec 21 18:05:19 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:47.140097</td>\n",
       "      <td>749</td>\n",
       "      <td>As we finalize our plans for 2019 and beyond, ...</td>\n",
       "      <td>1076176803826421761</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:47.140097</td>\n",
       "      <td>684</td>\n",
       "      <td>There was a 10-point increase in youth turnout...</td>\n",
       "      <td>1076176803126001665</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:47.704714</td>\n",
       "      <td>276</td>\n",
       "      <td>Five @EmergeAmerica alumni are headed to Congr...</td>\n",
       "      <td>1076176802387759104</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:47.705213</td>\n",
       "      <td>306</td>\n",
       "      <td>For many campaigns, @SwingLeft was the wave. O...</td>\n",
       "      <td>1076176801674772483</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:48.283572</td>\n",
       "      <td>251</td>\n",
       "      <td>In 2018, @LatinoVictoryUS increased their endo...</td>\n",
       "      <td>1076176800676569088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:48.283572</td>\n",
       "      <td>333</td>\n",
       "      <td>In two years, @RunforSomething has recruited 2...</td>\n",
       "      <td>1076176799883816965</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:48.872070</td>\n",
       "      <td>229</td>\n",
       "      <td>.@ArenaSummit supported 54 candidates in the 2...</td>\n",
       "      <td>1076176798872948742</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:48.872567</td>\n",
       "      <td>272</td>\n",
       "      <td>.@VotoLatino registered thousands of voters th...</td>\n",
       "      <td>1076176798159912961</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:49.473044</td>\n",
       "      <td>251</td>\n",
       "      <td>.@ColorOfChange PAC’s #VotingWhileBlack progra...</td>\n",
       "      <td>1076176797413330944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:49.473044</td>\n",
       "      <td>241</td>\n",
       "      <td>Three candidates that @iVoteFund supported for...</td>\n",
       "      <td>1076176796658401281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:50.058268</td>\n",
       "      <td>248</td>\n",
       "      <td>.@CollectivePAC helped elect over 54 African A...</td>\n",
       "      <td>1076176795916034049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:50.058767</td>\n",
       "      <td>273</td>\n",
       "      <td>Nine @IndivisibleTeam-endorsed candidates won....</td>\n",
       "      <td>1076176795160989696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Fri Dec 21 18:05:16 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:50.956745</td>\n",
       "      <td>1648</td>\n",
       "      <td>This year, @OnwardTogether was able to give mo...</td>\n",
       "      <td>1076176794393415680</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fri Dec 21 14:53:42 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:50.956745</td>\n",
       "      <td>31598</td>\n",
       "      <td>Actions have consequences, and whether we’re i...</td>\n",
       "      <td>1076128583419088896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Thu Dec 20 16:51:43 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:51.699510</td>\n",
       "      <td>4204</td>\n",
       "      <td>Winning back the House was a pipe dream a year...</td>\n",
       "      <td>1075795895713701888</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Wed Dec 19 22:29:22 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:51.700009</td>\n",
       "      <td>905</td>\n",
       "      <td>.@ArenaSummit, an @OnwardTogether partner, is ...</td>\n",
       "      <td>1075518480173228032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Wed Dec 19 15:51:23 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:52.345958</td>\n",
       "      <td>11213</td>\n",
       "      <td>Nevada just became the first state in the coun...</td>\n",
       "      <td>1075418325335883776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Tue Dec 18 14:35:52 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:52.944727</td>\n",
       "      <td>6806</td>\n",
       "      <td>Spread the word: Some states have extended Aff...</td>\n",
       "      <td>1075036934198714369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Mon Dec 17 21:14:49 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:52.944727</td>\n",
       "      <td>1826</td>\n",
       "      <td>This little girl's priceless face makes me smi...</td>\n",
       "      <td>1074774942925942789</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Mon Dec 17 19:47:51 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:53.631125</td>\n",
       "      <td>18231</td>\n",
       "      <td>We should all bear witness to the humanitarian...</td>\n",
       "      <td>1074753057387360257</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Mon Dec 17 18:26:14 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:53.631125</td>\n",
       "      <td>11085</td>\n",
       "      <td>A Russian disinformation campaign “used every ...</td>\n",
       "      <td>1074732519596134405</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sun Dec 16 15:45:06 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:54.284014</td>\n",
       "      <td>21702</td>\n",
       "      <td>There’s new CDC data out about gun deaths in A...</td>\n",
       "      <td>1074329577932111873</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Sat Dec 15 21:19:57 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:54.284513</td>\n",
       "      <td>1532</td>\n",
       "      <td>The theater adaptation of Network, @NetworkBwa...</td>\n",
       "      <td>1074051461020073984</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Fri Dec 14 18:15:05 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:54.872409</td>\n",
       "      <td>1646</td>\n",
       "      <td>One of my personal heroes is Ela Bhatt, who ha...</td>\n",
       "      <td>1073642549452115968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Fri Dec 14 16:49:40 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:54.872907</td>\n",
       "      <td>12316</td>\n",
       "      <td>No child should have to fear violence in their...</td>\n",
       "      <td>1073621053748858881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Fri Dec 14 14:53:08 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:55.419041</td>\n",
       "      <td>19005</td>\n",
       "      <td>There are no words to capture the horror of a ...</td>\n",
       "      <td>1073591724646285313</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Fri Dec 14 14:09:22 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:55.419041</td>\n",
       "      <td>13113</td>\n",
       "      <td>Do you or someone in your life need affordable...</td>\n",
       "      <td>1073580712056508416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Tue Dec 11 14:45:06 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:55.987618</td>\n",
       "      <td>2662</td>\n",
       "      <td>Throw your hat in the ring—and support @Onward...</td>\n",
       "      <td>1072502542075088896</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Mon Dec 10 22:59:44 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:55.987618</td>\n",
       "      <td>2519</td>\n",
       "      <td>An inspiring number of first-time candidates r...</td>\n",
       "      <td>1072264629424930818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Fri Dec 07 17:22:55 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:56.562688</td>\n",
       "      <td>1424</td>\n",
       "      <td>Bill, Chelsea, and I loved seeing @hbrikin's b...</td>\n",
       "      <td>1071092706682826752</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Fri Dec 07 14:23:33 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:56.562688</td>\n",
       "      <td>14088</td>\n",
       "      <td>On this day, we don't remember the destruction...</td>\n",
       "      <td>1071047564630392835</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Thu Dec 06 15:52:50 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:57.172196</td>\n",
       "      <td>3017</td>\n",
       "      <td>This is not in line with American values, and ...</td>\n",
       "      <td>1070707649073831936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Thu Dec 06 15:52:50 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:57.172196</td>\n",
       "      <td>2426</td>\n",
       "      <td>In Michigan, voters chose Democrats to be gove...</td>\n",
       "      <td>1070707647899467776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Thu Dec 06 15:52:50 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:57.874286</td>\n",
       "      <td>1392</td>\n",
       "      <td>Over the last few days, Republicans in Wiscons...</td>\n",
       "      <td>1070707646720827392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Thu Dec 06 15:52:50 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:57.874286</td>\n",
       "      <td>16495</td>\n",
       "      <td>Republicans in Michigan and Wisconsin lost ele...</td>\n",
       "      <td>1070707645730963457</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Tue Dec 04 19:04:05 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:58.454974</td>\n",
       "      <td>2703</td>\n",
       "      <td>Russia's actions brazenly violate a treaty all...</td>\n",
       "      <td>1070031001727000578</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Tue Dec 04 19:04:05 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:58.455473</td>\n",
       "      <td>4619</td>\n",
       "      <td>Russia’s seizure last week of three Ukrainian ...</td>\n",
       "      <td>1070031000862896128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Tue Dec 04 14:59:41 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:59.106021</td>\n",
       "      <td>4778</td>\n",
       "      <td>Georgia, it's Election Day. Bring a friend wit...</td>\n",
       "      <td>1069969493600976902</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Mon Dec 03 20:45:01 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 22:22:59.106021</td>\n",
       "      <td>2358</td>\n",
       "      <td>Bill and I will be traveling to Washington to ...</td>\n",
       "      <td>1069694013043867649</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        created_at          handle                   mined_at  \\\n",
       "0   Fri Dec 21 18:05:19 +0000 2018  HillaryClinton 2018-12-24 22:22:47.140097   \n",
       "1   Fri Dec 21 18:05:18 +0000 2018  HillaryClinton 2018-12-24 22:22:47.140097   \n",
       "2   Fri Dec 21 18:05:18 +0000 2018  HillaryClinton 2018-12-24 22:22:47.704714   \n",
       "3   Fri Dec 21 18:05:18 +0000 2018  HillaryClinton 2018-12-24 22:22:47.705213   \n",
       "4   Fri Dec 21 18:05:18 +0000 2018  HillaryClinton 2018-12-24 22:22:48.283572   \n",
       "5   Fri Dec 21 18:05:18 +0000 2018  HillaryClinton 2018-12-24 22:22:48.283572   \n",
       "6   Fri Dec 21 18:05:17 +0000 2018  HillaryClinton 2018-12-24 22:22:48.872070   \n",
       "7   Fri Dec 21 18:05:17 +0000 2018  HillaryClinton 2018-12-24 22:22:48.872567   \n",
       "8   Fri Dec 21 18:05:17 +0000 2018  HillaryClinton 2018-12-24 22:22:49.473044   \n",
       "9   Fri Dec 21 18:05:17 +0000 2018  HillaryClinton 2018-12-24 22:22:49.473044   \n",
       "10  Fri Dec 21 18:05:17 +0000 2018  HillaryClinton 2018-12-24 22:22:50.058268   \n",
       "11  Fri Dec 21 18:05:17 +0000 2018  HillaryClinton 2018-12-24 22:22:50.058767   \n",
       "12  Fri Dec 21 18:05:16 +0000 2018  HillaryClinton 2018-12-24 22:22:50.956745   \n",
       "13  Fri Dec 21 14:53:42 +0000 2018  HillaryClinton 2018-12-24 22:22:50.956745   \n",
       "14  Thu Dec 20 16:51:43 +0000 2018  HillaryClinton 2018-12-24 22:22:51.699510   \n",
       "15  Wed Dec 19 22:29:22 +0000 2018  HillaryClinton 2018-12-24 22:22:51.700009   \n",
       "16  Wed Dec 19 15:51:23 +0000 2018  HillaryClinton 2018-12-24 22:22:52.345958   \n",
       "17  Tue Dec 18 14:35:52 +0000 2018  HillaryClinton 2018-12-24 22:22:52.944727   \n",
       "18  Mon Dec 17 21:14:49 +0000 2018  HillaryClinton 2018-12-24 22:22:52.944727   \n",
       "19  Mon Dec 17 19:47:51 +0000 2018  HillaryClinton 2018-12-24 22:22:53.631125   \n",
       "20  Mon Dec 17 18:26:14 +0000 2018  HillaryClinton 2018-12-24 22:22:53.631125   \n",
       "21  Sun Dec 16 15:45:06 +0000 2018  HillaryClinton 2018-12-24 22:22:54.284014   \n",
       "22  Sat Dec 15 21:19:57 +0000 2018  HillaryClinton 2018-12-24 22:22:54.284513   \n",
       "23  Fri Dec 14 18:15:05 +0000 2018  HillaryClinton 2018-12-24 22:22:54.872409   \n",
       "24  Fri Dec 14 16:49:40 +0000 2018  HillaryClinton 2018-12-24 22:22:54.872907   \n",
       "25  Fri Dec 14 14:53:08 +0000 2018  HillaryClinton 2018-12-24 22:22:55.419041   \n",
       "26  Fri Dec 14 14:09:22 +0000 2018  HillaryClinton 2018-12-24 22:22:55.419041   \n",
       "27  Tue Dec 11 14:45:06 +0000 2018  HillaryClinton 2018-12-24 22:22:55.987618   \n",
       "28  Mon Dec 10 22:59:44 +0000 2018  HillaryClinton 2018-12-24 22:22:55.987618   \n",
       "29  Fri Dec 07 17:22:55 +0000 2018  HillaryClinton 2018-12-24 22:22:56.562688   \n",
       "30  Fri Dec 07 14:23:33 +0000 2018  HillaryClinton 2018-12-24 22:22:56.562688   \n",
       "31  Thu Dec 06 15:52:50 +0000 2018  HillaryClinton 2018-12-24 22:22:57.172196   \n",
       "32  Thu Dec 06 15:52:50 +0000 2018  HillaryClinton 2018-12-24 22:22:57.172196   \n",
       "33  Thu Dec 06 15:52:50 +0000 2018  HillaryClinton 2018-12-24 22:22:57.874286   \n",
       "34  Thu Dec 06 15:52:50 +0000 2018  HillaryClinton 2018-12-24 22:22:57.874286   \n",
       "35  Tue Dec 04 19:04:05 +0000 2018  HillaryClinton 2018-12-24 22:22:58.454974   \n",
       "36  Tue Dec 04 19:04:05 +0000 2018  HillaryClinton 2018-12-24 22:22:58.455473   \n",
       "37  Tue Dec 04 14:59:41 +0000 2018  HillaryClinton 2018-12-24 22:22:59.106021   \n",
       "38  Mon Dec 03 20:45:01 +0000 2018  HillaryClinton 2018-12-24 22:22:59.106021   \n",
       "\n",
       "    retweet_count                                               text  \\\n",
       "0             749  As we finalize our plans for 2019 and beyond, ...   \n",
       "1             684  There was a 10-point increase in youth turnout...   \n",
       "2             276  Five @EmergeAmerica alumni are headed to Congr...   \n",
       "3             306  For many campaigns, @SwingLeft was the wave. O...   \n",
       "4             251  In 2018, @LatinoVictoryUS increased their endo...   \n",
       "5             333  In two years, @RunforSomething has recruited 2...   \n",
       "6             229  .@ArenaSummit supported 54 candidates in the 2...   \n",
       "7             272  .@VotoLatino registered thousands of voters th...   \n",
       "8             251  .@ColorOfChange PAC’s #VotingWhileBlack progra...   \n",
       "9             241  Three candidates that @iVoteFund supported for...   \n",
       "10            248  .@CollectivePAC helped elect over 54 African A...   \n",
       "11            273  Nine @IndivisibleTeam-endorsed candidates won....   \n",
       "12           1648  This year, @OnwardTogether was able to give mo...   \n",
       "13          31598  Actions have consequences, and whether we’re i...   \n",
       "14           4204  Winning back the House was a pipe dream a year...   \n",
       "15            905  .@ArenaSummit, an @OnwardTogether partner, is ...   \n",
       "16          11213  Nevada just became the first state in the coun...   \n",
       "17           6806  Spread the word: Some states have extended Aff...   \n",
       "18           1826  This little girl's priceless face makes me smi...   \n",
       "19          18231  We should all bear witness to the humanitarian...   \n",
       "20          11085  A Russian disinformation campaign “used every ...   \n",
       "21          21702  There’s new CDC data out about gun deaths in A...   \n",
       "22           1532  The theater adaptation of Network, @NetworkBwa...   \n",
       "23           1646  One of my personal heroes is Ela Bhatt, who ha...   \n",
       "24          12316  No child should have to fear violence in their...   \n",
       "25          19005  There are no words to capture the horror of a ...   \n",
       "26          13113  Do you or someone in your life need affordable...   \n",
       "27           2662  Throw your hat in the ring—and support @Onward...   \n",
       "28           2519  An inspiring number of first-time candidates r...   \n",
       "29           1424  Bill, Chelsea, and I loved seeing @hbrikin's b...   \n",
       "30          14088  On this day, we don't remember the destruction...   \n",
       "31           3017  This is not in line with American values, and ...   \n",
       "32           2426  In Michigan, voters chose Democrats to be gove...   \n",
       "33           1392  Over the last few days, Republicans in Wiscons...   \n",
       "34          16495  Republicans in Michigan and Wisconsin lost ele...   \n",
       "35           2703  Russia's actions brazenly violate a treaty all...   \n",
       "36           4619  Russia’s seizure last week of three Ukrainian ...   \n",
       "37           4778  Georgia, it's Election Day. Bring a friend wit...   \n",
       "38           2358  Bill and I will be traveling to Washington to ...   \n",
       "\n",
       "               tweet_id  \n",
       "0   1076176803826421761  \n",
       "1   1076176803126001665  \n",
       "2   1076176802387759104  \n",
       "3   1076176801674772483  \n",
       "4   1076176800676569088  \n",
       "5   1076176799883816965  \n",
       "6   1076176798872948742  \n",
       "7   1076176798159912961  \n",
       "8   1076176797413330944  \n",
       "9   1076176796658401281  \n",
       "10  1076176795916034049  \n",
       "11  1076176795160989696  \n",
       "12  1076176794393415680  \n",
       "13  1076128583419088896  \n",
       "14  1075795895713701888  \n",
       "15  1075518480173228032  \n",
       "16  1075418325335883776  \n",
       "17  1075036934198714369  \n",
       "18  1074774942925942789  \n",
       "19  1074753057387360257  \n",
       "20  1074732519596134405  \n",
       "21  1074329577932111873  \n",
       "22  1074051461020073984  \n",
       "23  1073642549452115968  \n",
       "24  1073621053748858881  \n",
       "25  1073591724646285313  \n",
       "26  1073580712056508416  \n",
       "27  1072502542075088896  \n",
       "28  1072264629424930818  \n",
       "29  1071092706682826752  \n",
       "30  1071047564630392835  \n",
       "31  1070707649073831936  \n",
       "32  1070707647899467776  \n",
       "33  1070707646720827392  \n",
       "34  1070707645730963457  \n",
       "35  1070031001727000578  \n",
       "36  1070031000862896128  \n",
       "37  1069969493600976902  \n",
       "38  1069694013043867649  "
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#rablo gösterimi\n",
    "pd.DataFrame(hillary)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>created_at</th>\n",
       "      <th>handle</th>\n",
       "      <th>mined_at</th>\n",
       "      <th>retweet_count</th>\n",
       "      <th>text</th>\n",
       "      <th>tweet_id</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mon Dec 24 17:32:44 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:00.336168</td>\n",
       "      <td>14471</td>\n",
       "      <td>I am all alone (poor me) in the White House wa...</td>\n",
       "      <td>1077255770725601280</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mon Dec 24 17:23:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:00.336168</td>\n",
       "      <td>13530</td>\n",
       "      <td>Saudi Arabia has now agreed to spend the neces...</td>\n",
       "      <td>1077253411358326785</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mon Dec 24 17:10:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:01.151365</td>\n",
       "      <td>9734</td>\n",
       "      <td>The Wall is different than the 25 Billion Doll...</td>\n",
       "      <td>1077250139503452162</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mon Dec 24 16:55:32 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:01.151865</td>\n",
       "      <td>8549</td>\n",
       "      <td>I never “lashed out” at the Acting Attorney Ge...</td>\n",
       "      <td>1077246407554281472</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mon Dec 24 15:55:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:02.627515</td>\n",
       "      <td>15156</td>\n",
       "      <td>The only problem our economy has is the Fed. T...</td>\n",
       "      <td>1077231267559755776</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Mon Dec 24 15:33:41 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:02.627515</td>\n",
       "      <td>14507</td>\n",
       "      <td>AMERICA IS RESPECTED AGAIN!</td>\n",
       "      <td>1077225810329825281</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mon Dec 24 15:23:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:03.409030</td>\n",
       "      <td>15075</td>\n",
       "      <td>For all of the sympathizers out there of Brett...</td>\n",
       "      <td>1077223213598429185</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mon Dec 24 14:59:23 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:03.409030</td>\n",
       "      <td>14342</td>\n",
       "      <td>....We are substantially subsidizing the Milit...</td>\n",
       "      <td>1077217178322194432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Mon Dec 24 14:41:02 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:05.186651</td>\n",
       "      <td>13875</td>\n",
       "      <td>To those few Senators who think I don’t like o...</td>\n",
       "      <td>1077212559604924416</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mon Dec 24 14:31:50 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:05.186651</td>\n",
       "      <td>15710</td>\n",
       "      <td>Virtually every Democrat we are dealing with t...</td>\n",
       "      <td>1077210242574942208</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Mon Dec 24 04:54:00 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:05.968665</td>\n",
       "      <td>17577</td>\n",
       "      <td>President @RT_Erdogan of Turkey has very stron...</td>\n",
       "      <td>1077064829825966081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Mon Dec 24 04:26:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:05.968665</td>\n",
       "      <td>13258</td>\n",
       "      <td>“The President has been remarkable. I do not d...</td>\n",
       "      <td>1077057874235400194</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Mon Dec 24 04:05:26 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:06.728221</td>\n",
       "      <td>19877</td>\n",
       "      <td>The most important way to stop gangs, drugs, h...</td>\n",
       "      <td>1077052604499353600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Mon Dec 24 03:47:21 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:06.728221</td>\n",
       "      <td>21632</td>\n",
       "      <td>Mitch McConnell just told a group of people, a...</td>\n",
       "      <td>1077048054862278656</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Mon Dec 24 03:32:49 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:11.289053</td>\n",
       "      <td>17037</td>\n",
       "      <td>“It should not be the job of America to replac...</td>\n",
       "      <td>1077044397504692227</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Sun Dec 23 21:18:49 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:11.289053</td>\n",
       "      <td>22664</td>\n",
       "      <td>Thanks @RandPaul  “I am very proud of the Pres...</td>\n",
       "      <td>1076950276958027779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Sun Dec 23 20:20:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:12.469808</td>\n",
       "      <td>19661</td>\n",
       "      <td>.....Bob Corker was responsible for giving us ...</td>\n",
       "      <td>1076935567760338944</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Sun Dec 23 19:56:37 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:12.469808</td>\n",
       "      <td>14952</td>\n",
       "      <td>Senator Bob Corker just stated that, “I’m so p...</td>\n",
       "      <td>1076929590050897920</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Sun Dec 23 19:45:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:16.566523</td>\n",
       "      <td>20786</td>\n",
       "      <td>We signed two pieces of major legislation this...</td>\n",
       "      <td>1076926760829243392</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Sun Dec 23 17:13:27 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:16.566523</td>\n",
       "      <td>14840</td>\n",
       "      <td>Unthinkable devastation from the tsunami disas...</td>\n",
       "      <td>1076888530276810753</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Sun Dec 23 16:59:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:17.354026</td>\n",
       "      <td>16733</td>\n",
       "      <td>I just had a long and productive call with Pre...</td>\n",
       "      <td>1076884984873607169</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Sun Dec 23 16:46:47 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:17.354026</td>\n",
       "      <td>17359</td>\n",
       "      <td>I am pleased to announce that our very talente...</td>\n",
       "      <td>1076881816462737408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Sun Dec 23 14:17:54 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:18.123065</td>\n",
       "      <td>30561</td>\n",
       "      <td>The only way to stop drugs, gangs, human traff...</td>\n",
       "      <td>1076844349860823042</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Sun Dec 23 02:20:32 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:18.123065</td>\n",
       "      <td>24610</td>\n",
       "      <td>When President Obama ingloriously fired Jim Ma...</td>\n",
       "      <td>1076663817831153664</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>Sun Dec 23 01:59:29 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:28.022670</td>\n",
       "      <td>32615</td>\n",
       "      <td>If anybody but your favorite President, Donald...</td>\n",
       "      <td>1076658521926656000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Sun Dec 23 01:48:23 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:28.022670</td>\n",
       "      <td>18320</td>\n",
       "      <td>Brett McGurk, who I do not know, was appointed...</td>\n",
       "      <td>1076655729820471296</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Sat Dec 22 23:58:43 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:28.948185</td>\n",
       "      <td>23381</td>\n",
       "      <td>I will not be going to Florida because of the ...</td>\n",
       "      <td>1076628127525294080</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Sat Dec 22 21:12:02 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:28.948185</td>\n",
       "      <td>13872</td>\n",
       "      <td>Senate adjourns until December 27th.</td>\n",
       "      <td>1076586181897474048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Sat Dec 22 20:28:21 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:32.839447</td>\n",
       "      <td>38854</td>\n",
       "      <td>I won an election, said to be one of the great...</td>\n",
       "      <td>1076575190899929088</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Sat Dec 22 20:03:58 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:32.839945</td>\n",
       "      <td>24068</td>\n",
       "      <td>The crisis of illegal activity at our Southern...</td>\n",
       "      <td>1076569051768516608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>Sat Dec 22 17:02:37 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:36.403429</td>\n",
       "      <td>16951</td>\n",
       "      <td>Will be having lunch in White House residence ...</td>\n",
       "      <td>1076523416516263936</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>Sat Dec 22 16:30:35 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:36.403429</td>\n",
       "      <td>24955</td>\n",
       "      <td>....going to be there for three months, and th...</td>\n",
       "      <td>1076515352249597954</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>Sat Dec 22 16:18:11 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:36.992153</td>\n",
       "      <td>20471</td>\n",
       "      <td>I am in the White House, working hard. News re...</td>\n",
       "      <td>1076512233897771010</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>Sat Dec 22 02:49:05 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:36.992655</td>\n",
       "      <td>37336</td>\n",
       "      <td>OUR GREAT COUNTRY MUST HAVE BORDER SECURITY! h...</td>\n",
       "      <td>1076308614372048897</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>Sat Dec 22 00:16:55 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:37.602422</td>\n",
       "      <td>15852</td>\n",
       "      <td>Wishing Supreme Court Justice Ruth Bader Ginsb...</td>\n",
       "      <td>1076270321861312512</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>Fri Dec 21 23:23:27 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:37.602422</td>\n",
       "      <td>22213</td>\n",
       "      <td>Some of the many Bills that I am signing in th...</td>\n",
       "      <td>1076256868190834689</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>Fri Dec 21 22:14:14 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:38.224681</td>\n",
       "      <td>32798</td>\n",
       "      <td>A design of our Steel Slat Barrier which is to...</td>\n",
       "      <td>1076239448461987841</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>Fri Dec 21 19:56:05 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:38.225180</td>\n",
       "      <td>11061</td>\n",
       "      <td>Today, it was my honor to sign into law H.R. 7...</td>\n",
       "      <td>1076204680202670081</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>Fri Dec 21 19:28:13 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:38.825407</td>\n",
       "      <td>13453</td>\n",
       "      <td>Today, it was my great honor to sign the #Firs...</td>\n",
       "      <td>1076197669968728065</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>Fri Dec 21 15:31:41 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 22:23:38.825906</td>\n",
       "      <td>21323</td>\n",
       "      <td>I’ve done more damage to ISIS than all recent ...</td>\n",
       "      <td>1076138140795064320</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                        created_at           handle  \\\n",
       "0   Mon Dec 24 17:32:44 +0000 2018  realDonaldTrump   \n",
       "1   Mon Dec 24 17:23:22 +0000 2018  realDonaldTrump   \n",
       "2   Mon Dec 24 17:10:22 +0000 2018  realDonaldTrump   \n",
       "3   Mon Dec 24 16:55:32 +0000 2018  realDonaldTrump   \n",
       "4   Mon Dec 24 15:55:22 +0000 2018  realDonaldTrump   \n",
       "5   Mon Dec 24 15:33:41 +0000 2018  realDonaldTrump   \n",
       "6   Mon Dec 24 15:23:22 +0000 2018  realDonaldTrump   \n",
       "7   Mon Dec 24 14:59:23 +0000 2018  realDonaldTrump   \n",
       "8   Mon Dec 24 14:41:02 +0000 2018  realDonaldTrump   \n",
       "9   Mon Dec 24 14:31:50 +0000 2018  realDonaldTrump   \n",
       "10  Mon Dec 24 04:54:00 +0000 2018  realDonaldTrump   \n",
       "11  Mon Dec 24 04:26:22 +0000 2018  realDonaldTrump   \n",
       "12  Mon Dec 24 04:05:26 +0000 2018  realDonaldTrump   \n",
       "13  Mon Dec 24 03:47:21 +0000 2018  realDonaldTrump   \n",
       "14  Mon Dec 24 03:32:49 +0000 2018  realDonaldTrump   \n",
       "15  Sun Dec 23 21:18:49 +0000 2018  realDonaldTrump   \n",
       "16  Sun Dec 23 20:20:22 +0000 2018  realDonaldTrump   \n",
       "17  Sun Dec 23 19:56:37 +0000 2018  realDonaldTrump   \n",
       "18  Sun Dec 23 19:45:22 +0000 2018  realDonaldTrump   \n",
       "19  Sun Dec 23 17:13:27 +0000 2018  realDonaldTrump   \n",
       "20  Sun Dec 23 16:59:22 +0000 2018  realDonaldTrump   \n",
       "21  Sun Dec 23 16:46:47 +0000 2018  realDonaldTrump   \n",
       "22  Sun Dec 23 14:17:54 +0000 2018  realDonaldTrump   \n",
       "23  Sun Dec 23 02:20:32 +0000 2018  realDonaldTrump   \n",
       "24  Sun Dec 23 01:59:29 +0000 2018  realDonaldTrump   \n",
       "25  Sun Dec 23 01:48:23 +0000 2018  realDonaldTrump   \n",
       "26  Sat Dec 22 23:58:43 +0000 2018  realDonaldTrump   \n",
       "27  Sat Dec 22 21:12:02 +0000 2018  realDonaldTrump   \n",
       "28  Sat Dec 22 20:28:21 +0000 2018  realDonaldTrump   \n",
       "29  Sat Dec 22 20:03:58 +0000 2018  realDonaldTrump   \n",
       "30  Sat Dec 22 17:02:37 +0000 2018  realDonaldTrump   \n",
       "31  Sat Dec 22 16:30:35 +0000 2018  realDonaldTrump   \n",
       "32  Sat Dec 22 16:18:11 +0000 2018  realDonaldTrump   \n",
       "33  Sat Dec 22 02:49:05 +0000 2018  realDonaldTrump   \n",
       "34  Sat Dec 22 00:16:55 +0000 2018  realDonaldTrump   \n",
       "35  Fri Dec 21 23:23:27 +0000 2018  realDonaldTrump   \n",
       "36  Fri Dec 21 22:14:14 +0000 2018  realDonaldTrump   \n",
       "37  Fri Dec 21 19:56:05 +0000 2018  realDonaldTrump   \n",
       "38  Fri Dec 21 19:28:13 +0000 2018  realDonaldTrump   \n",
       "39  Fri Dec 21 15:31:41 +0000 2018  realDonaldTrump   \n",
       "\n",
       "                     mined_at  retweet_count  \\\n",
       "0  2018-12-24 22:23:00.336168          14471   \n",
       "1  2018-12-24 22:23:00.336168          13530   \n",
       "2  2018-12-24 22:23:01.151365           9734   \n",
       "3  2018-12-24 22:23:01.151865           8549   \n",
       "4  2018-12-24 22:23:02.627515          15156   \n",
       "5  2018-12-24 22:23:02.627515          14507   \n",
       "6  2018-12-24 22:23:03.409030          15075   \n",
       "7  2018-12-24 22:23:03.409030          14342   \n",
       "8  2018-12-24 22:23:05.186651          13875   \n",
       "9  2018-12-24 22:23:05.186651          15710   \n",
       "10 2018-12-24 22:23:05.968665          17577   \n",
       "11 2018-12-24 22:23:05.968665          13258   \n",
       "12 2018-12-24 22:23:06.728221          19877   \n",
       "13 2018-12-24 22:23:06.728221          21632   \n",
       "14 2018-12-24 22:23:11.289053          17037   \n",
       "15 2018-12-24 22:23:11.289053          22664   \n",
       "16 2018-12-24 22:23:12.469808          19661   \n",
       "17 2018-12-24 22:23:12.469808          14952   \n",
       "18 2018-12-24 22:23:16.566523          20786   \n",
       "19 2018-12-24 22:23:16.566523          14840   \n",
       "20 2018-12-24 22:23:17.354026          16733   \n",
       "21 2018-12-24 22:23:17.354026          17359   \n",
       "22 2018-12-24 22:23:18.123065          30561   \n",
       "23 2018-12-24 22:23:18.123065          24610   \n",
       "24 2018-12-24 22:23:28.022670          32615   \n",
       "25 2018-12-24 22:23:28.022670          18320   \n",
       "26 2018-12-24 22:23:28.948185          23381   \n",
       "27 2018-12-24 22:23:28.948185          13872   \n",
       "28 2018-12-24 22:23:32.839447          38854   \n",
       "29 2018-12-24 22:23:32.839945          24068   \n",
       "30 2018-12-24 22:23:36.403429          16951   \n",
       "31 2018-12-24 22:23:36.403429          24955   \n",
       "32 2018-12-24 22:23:36.992153          20471   \n",
       "33 2018-12-24 22:23:36.992655          37336   \n",
       "34 2018-12-24 22:23:37.602422          15852   \n",
       "35 2018-12-24 22:23:37.602422          22213   \n",
       "36 2018-12-24 22:23:38.224681          32798   \n",
       "37 2018-12-24 22:23:38.225180          11061   \n",
       "38 2018-12-24 22:23:38.825407          13453   \n",
       "39 2018-12-24 22:23:38.825906          21323   \n",
       "\n",
       "                                                 text             tweet_id  \n",
       "0   I am all alone (poor me) in the White House wa...  1077255770725601280  \n",
       "1   Saudi Arabia has now agreed to spend the neces...  1077253411358326785  \n",
       "2   The Wall is different than the 25 Billion Doll...  1077250139503452162  \n",
       "3   I never “lashed out” at the Acting Attorney Ge...  1077246407554281472  \n",
       "4   The only problem our economy has is the Fed. T...  1077231267559755776  \n",
       "5                         AMERICA IS RESPECTED AGAIN!  1077225810329825281  \n",
       "6   For all of the sympathizers out there of Brett...  1077223213598429185  \n",
       "7   ....We are substantially subsidizing the Milit...  1077217178322194432  \n",
       "8   To those few Senators who think I don’t like o...  1077212559604924416  \n",
       "9   Virtually every Democrat we are dealing with t...  1077210242574942208  \n",
       "10  President @RT_Erdogan of Turkey has very stron...  1077064829825966081  \n",
       "11  “The President has been remarkable. I do not d...  1077057874235400194  \n",
       "12  The most important way to stop gangs, drugs, h...  1077052604499353600  \n",
       "13  Mitch McConnell just told a group of people, a...  1077048054862278656  \n",
       "14  “It should not be the job of America to replac...  1077044397504692227  \n",
       "15  Thanks @RandPaul  “I am very proud of the Pres...  1076950276958027779  \n",
       "16  .....Bob Corker was responsible for giving us ...  1076935567760338944  \n",
       "17  Senator Bob Corker just stated that, “I’m so p...  1076929590050897920  \n",
       "18  We signed two pieces of major legislation this...  1076926760829243392  \n",
       "19  Unthinkable devastation from the tsunami disas...  1076888530276810753  \n",
       "20  I just had a long and productive call with Pre...  1076884984873607169  \n",
       "21  I am pleased to announce that our very talente...  1076881816462737408  \n",
       "22  The only way to stop drugs, gangs, human traff...  1076844349860823042  \n",
       "23  When President Obama ingloriously fired Jim Ma...  1076663817831153664  \n",
       "24  If anybody but your favorite President, Donald...  1076658521926656000  \n",
       "25  Brett McGurk, who I do not know, was appointed...  1076655729820471296  \n",
       "26  I will not be going to Florida because of the ...  1076628127525294080  \n",
       "27               Senate adjourns until December 27th.  1076586181897474048  \n",
       "28  I won an election, said to be one of the great...  1076575190899929088  \n",
       "29  The crisis of illegal activity at our Southern...  1076569051768516608  \n",
       "30  Will be having lunch in White House residence ...  1076523416516263936  \n",
       "31  ....going to be there for three months, and th...  1076515352249597954  \n",
       "32  I am in the White House, working hard. News re...  1076512233897771010  \n",
       "33  OUR GREAT COUNTRY MUST HAVE BORDER SECURITY! h...  1076308614372048897  \n",
       "34  Wishing Supreme Court Justice Ruth Bader Ginsb...  1076270321861312512  \n",
       "35  Some of the many Bills that I am signing in th...  1076256868190834689  \n",
       "36  A design of our Steel Slat Barrier which is to...  1076239448461987841  \n",
       "37  Today, it was my honor to sign into law H.R. 7...  1076204680202670081  \n",
       "38  Today, it was my great honor to sign the #Firs...  1076197669968728065  \n",
       "39  I’ve done more damage to ISIS than all recent ...  1076138140795064320  "
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.DataFrame(donald)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "# Veri çekimi için constructor değerleri verilir\n",
    "miner = TweetMiner(api, result_limit=200)\n",
    "trump_tweets = miner.mine_user_tweets(\"realDonaldTrump\", max_pages=14)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(2388, 6)"
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "trump_df = pd.DataFrame(trump_tweets)\n",
    "trump_df.shape #boyutunu gösterir"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(2572, 6)\n"
     ]
    }
   ],
   "source": [
    "hillary_tweets = miner.mine_user_tweets('HillaryClinton')\n",
    "hillary_df = pd.DataFrame(hillary_tweets)\n",
    "print (hillary_df.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(4960, 6)"
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets = pd.concat([trump_df, hillary_df], axis=0)\n",
    "tweets.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('united states', 67),\n",
       " ('fake news', 64),\n",
       " ('white house', 51),\n",
       " ('witch hunt', 47),\n",
       " ('great honor', 41),\n",
       " ('north korea', 39),\n",
       " ('new york', 37),\n",
       " ('news media', 35),\n",
       " ('fake news media', 34),\n",
       " ('great state', 29),\n",
       " ('maga https', 29),\n",
       " ('great job', 27),\n",
       " ('america great', 27),\n",
       " ('border security', 26),\n",
       " ('donald trump', 26),\n",
       " ('president trump', 24),\n",
       " ('th https', 24),\n",
       " ('great https', 22),\n",
       " ('nancy pelosi', 21),\n",
       " ('james comey', 21)]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.feature_extraction.text import TfidfVectorizer\n",
    "from collections import Counter\n",
    "\n",
    "# We can use the TfidfVectorizer to find ngrams for us\n",
    "vect = TfidfVectorizer(ngram_range=(2,5), stop_words='english')\n",
    "\n",
    "# Pulls all of trumps tweet text's into one giant string\n",
    "summaries = \"\".join(trump_df['text'])\n",
    "ngrams_summaries = vect.build_analyzer()(summaries)\n",
    "\n",
    "Counter(ngrams_summaries).most_common(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {
    "scrolled": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('donald trump', 166),\n",
       " ('hillary https', 75),\n",
       " ('https ttgeqxnqym', 70),\n",
       " ('vote https', 60),\n",
       " ('make sure', 57),\n",
       " ('hillary clinton', 41),\n",
       " ('debatenight https', 38),\n",
       " ('trump https', 37),\n",
       " ('https 3tkj4h68kz', 36),\n",
       " ('potus https', 32),\n",
       " ('president https', 32),\n",
       " ('ttgeqxnqym https', 32),\n",
       " ('https ttgeqxnqym https', 32),\n",
       " ('ve got', 27),\n",
       " ('flotus https', 25),\n",
       " ('election day', 24),\n",
       " ('3tkj4h68kz https', 24),\n",
       " ('debate https', 24),\n",
       " ('https 3tkj4h68kz https', 24),\n",
       " ('health care', 22)]"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vect = TfidfVectorizer(ngram_range=(2,5), stop_words='english')\n",
    "\n",
    "summaries = \"\".join(hillary_df['text'])\n",
    "ngrams_summaries = vect.build_analyzer()(summaries)\n",
    "\n",
    "Counter(ngrams_summaries).most_common(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('donald trump', 166),\n",
       " ('hillary https', 75),\n",
       " ('https ttgeqxnqym', 70),\n",
       " ('vote https', 60),\n",
       " ('make sure', 57),\n",
       " ('hillary clinton', 41),\n",
       " ('debatenight https', 38),\n",
       " ('trump https', 37),\n",
       " ('https 3tkj4h68kz', 36),\n",
       " ('potus https', 32),\n",
       " ('president https', 32),\n",
       " ('ttgeqxnqym https', 32),\n",
       " ('https ttgeqxnqym https', 32),\n",
       " ('ve got', 27),\n",
       " ('flotus https', 25),\n",
       " ('election day', 24),\n",
       " ('3tkj4h68kz https', 24),\n",
       " ('debate https', 24),\n",
       " ('https 3tkj4h68kz https', 24),\n",
       " ('health care', 22)]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vect = TfidfVectorizer(ngram_range=(2,5), stop_words='english')\n",
    "\n",
    "summaries = \"\".join(hillary_df['text'])\n",
    "ngrams_summaries = vect.build_analyzer()(summaries)\n",
    "Counter(ngrams_summaries).most_common(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "#cleaning text data using textacy\n",
    "from textacy.preprocess import preprocess_text\n",
    "\n",
    "tweet_text = tweets['text'].values\n",
    "clean_text = [preprocess_text(x, fix_unicode=True, lowercase=True, no_urls=True, no_emails=True, no_phone_numbers=True, no_currency_symbols=True,\n",
    "                              no_punct=True, no_accents=True)\n",
    "              for x in tweet_text]\n",
    "               "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['Saudi Arabia has now agreed to spend the necessary money needed to help rebuild Syria, instead of the United States… https://t.co/ySHwB9b8Fn'\n",
      " 'The Wall is different than the 25 Billion Dollars in Border Security. The complete Wall will be built with the Shut… https://t.co/k8DTw3trKu'\n",
      " 'I never “lashed out” at the Acting Attorney General of the U.S., a man for whom I have great respect. This is a mad… https://t.co/IUyS1p7z6E'\n",
      " 'The only problem our economy has is the Fed. They don’t have a feel for the Market, they don’t understand necessary… https://t.co/g0dYAlEqmD'\n",
      " 'AMERICA IS RESPECTED AGAIN!'\n",
      " 'For all of the sympathizers out there of Brett McGurk remember, he was the Obama appointee who was responsible for… https://t.co/YT4ZsN1lKq'\n",
      " '....We are substantially subsidizing the Militaries of many VERY rich countries all over the world, while at the sa… https://t.co/MZ8zKbLQFp']\n"
     ]
    }
   ],
   "source": [
    "print (tweet_text[1:8])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['saudi arabia has now agreed to spend the necessary money needed to help rebuild syria instead of the united states url', 'the wall is different than the 25 billion dollars in border security the complete wall will be built with the shut url', 'i never lashed out at the acting attorney general of the u s a man for whom i have great respect this is a mad url', 'the only problem our economy has is the fed they don t have a feel for the market they don t understand necessary url', 'america is respected again', 'for all of the sympathizers out there of brett mcgurk remember he was the obama appointee who was responsible for url', 'we are substantially subsidizing the militaries of many very rich countries all over the world while at the sa url']\n"
     ]
    }
   ],
   "source": [
    "print (clean_text[1:8])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "  (0, 7673)\t1\n",
      "  (0, 2081)\t1\n",
      "  (0, 5097)\t1\n",
      "  (0, 1914)\t1\n",
      "  (0, 4463)\t1\n",
      "  (0, 502)\t1\n",
      "  (0, 750)\t1\n",
      "  (0, 1527)\t1\n",
      "  (0, 7358)\t1\n",
      "  (0, 2025)\t1\n",
      "  (0, 2961)\t1\n",
      "  (0, 7859)\t1\n",
      "  (0, 3550)\t1\n",
      "  (0, 7994)\t1\n",
      "  (0, 7253)\t2\n",
      "  (0, 3673)\t1\n",
      "  (0, 4569)\t1\n",
      "  (0, 5512)\t1\n",
      "  (0, 455)\t1\n",
      "  (0, 440)\t1\n",
      "  (0, 471)\t1\n",
      "  (1, 6886)\t1\n",
      "  (1, 7617)\t1\n",
      "  (1, 5055)\t1\n",
      "  (1, 3786)\t1\n",
      "  :\t:\n",
      "  (4958, 3870)\t1\n",
      "  (4958, 2260)\t1\n",
      "  (4958, 3375)\t4\n",
      "  (4958, 3868)\t1\n",
      "  (4958, 3349)\t1\n",
      "  (4958, 7358)\t1\n",
      "  (4958, 7253)\t1\n",
      "  (4959, 1474)\t1\n",
      "  (4959, 4076)\t1\n",
      "  (4959, 1844)\t1\n",
      "  (4959, 5736)\t2\n",
      "  (4959, 8083)\t1\n",
      "  (4959, 7286)\t1\n",
      "  (4959, 1232)\t1\n",
      "  (4959, 1378)\t1\n",
      "  (4959, 5317)\t1\n",
      "  (4959, 648)\t1\n",
      "  (4959, 6353)\t1\n",
      "  (4959, 5889)\t1\n",
      "  (4959, 8157)\t2\n",
      "  (4959, 7499)\t1\n",
      "  (4959, 4983)\t1\n",
      "  (4959, 3868)\t1\n",
      "  (4959, 2961)\t2\n",
      "  (4959, 7253)\t1\n"
     ]
    }
   ],
   "source": [
    "from sklearn.feature_extraction.text import CountVectorizer\n",
    "BoW_Vector = CountVectorizer(min_df = 0., max_df = 1.)\n",
    "BoW_Matrix = BoW_Vector.fit_transform(clean_text)\n",
    "print (BoW_Matrix)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0    0.518548\n",
      "1    0.481452\n",
      "dtype: float64\n",
      "0.5185483870967742\n"
     ]
    }
   ],
   "source": [
    "#hedefin oluşturulmasu\n",
    "y = tweets['handle'].map(lambda x: 1 if x == 'realDonaldTrump' else 0).values\n",
    "#max olan olasılık alınır\n",
    "print(pd.Series(y).value_counts(normalize=True))\n",
    "print(max(pd.Series(y).value_counts(normalize=True)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(4960, 2000)\n"
     ]
    }
   ],
   "source": [
    "from sklearn.linear_model import LogisticRegression\n",
    "from sklearn.neighbors import KNeighborsClassifier\n",
    "from sklearn.tree import DecisionTreeClassifier\n",
    "from sklearn.svm import SVC\n",
    "\n",
    "#Vektörleme  with TF-IDF Vectorizer ve x matrix oluşturulması\n",
    "tfv = TfidfVectorizer(ngram_range=(2,4), max_features=2000)\n",
    "X = tfv.fit_transform(clean_text).todense()\n",
    "print (X.shape)#boyut gösterimi"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Fitting 10 folds for each of 200 candidates, totalling 2000 fits\n"
     ]
    },
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "[Parallel(n_jobs=1)]: Done 2000 out of 2000 | elapsed:  4.5min finished\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "GridSearchCV(cv=10, error_score='raise',\n",
       "       estimator=LogisticRegression(C=1.0, class_weight=None, dual=False, fit_intercept=True,\n",
       "          intercept_scaling=1, max_iter=100, multi_class='ovr', n_jobs=1,\n",
       "          penalty='l2', random_state=None, solver='liblinear', tol=0.0001,\n",
       "          verbose=0, warm_start=False),\n",
       "       fit_params=None, iid=True, n_jobs=1,\n",
       "       param_grid={'penalty': ['l1', 'l2'], 'C': array([1.00000e-05, 1.12332e-05, ..., 8.90215e-01, 1.00000e+00])},\n",
       "       pre_dispatch='2*n_jobs', refit=True, return_train_score='warn',\n",
       "       scoring=None, verbose=1)"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "from sklearn.model_selection import GridSearchCV\n",
    "\n",
    "#parametre ayarı yaparak başarının yükselmesi amacıyla GridSearchCV kullanılmıştır\n",
    "\n",
    "lr = LogisticRegression()\n",
    "params = {'penalty': ['l1', 'l2'], 'C':np.logspace(-5,0,100)}\n",
    "#Grid searching to find optimal parameters for Logistic Regression\n",
    "gs = GridSearchCV(lr, param_grid=params, cv=10, verbose=1)\n",
    "gs.fit(X, y)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'C': 0.7054802310718645, 'penalty': 'l2'}\n",
      "0.814366424535916\n"
     ]
    }
   ],
   "source": [
    "print (gs.best_params_)\n",
    "print (gs.best_score_)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "0.8107999061491791\n",
      "0.5189669087974172\n"
     ]
    }
   ],
   "source": [
    "from sklearn.model_selection import cross_val_score\n",
    "accuracies = cross_val_score(LogisticRegression(), X, y, cv=10)\n",
    "\n",
    "print (accuracies.mean())\n",
    "print (1-y.mean())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Proba_Hillary</th>\n",
       "      <th>Proba_Trump</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.510373</td>\n",
       "      <td>0.489627</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.510373</td>\n",
       "      <td>0.489627</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Proba_Hillary  Proba_Trump\n",
       "0       0.510373     0.489627\n",
       "1       0.510373     0.489627"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "estimator = LogisticRegression(penalty='l2',C=1.0)\n",
    "estimator.fit(X,y)\n",
    "\n",
    "# Kaynağın TfIdf vector olarak ayarlanması\n",
    "source_test = [\n",
    "    \"The presidency doesn’t change who you are—it reveals who you are. And we’ve seen all we need to of Donald Trump.\",\n",
    "    \"Crooked Hillary is spending tremendous amounts of Wall Street money on false ads against me. She is a very dishonest person!\"\n",
    "]\n",
    "\n",
    "Xtest = tfv.transform(source_test)\n",
    "pd.DataFrame(estimator.predict_proba(Xtest), columns=[\"Proba_Hillary\", \"Proba_Trump\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([[0.29307605, 0.70692395],\n",
       "       [0.2761489 , 0.7238511 ],\n",
       "       [0.43175818, 0.56824182],\n",
       "       ...,\n",
       "       [0.92514531, 0.07485469],\n",
       "       [0.70992997, 0.29007003],\n",
       "       [0.77825371, 0.22174629]])"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "estimator.predict_proba(X)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "Probas_x = pd.DataFrame(estimator.predict_proba(X), columns=[\"Proba_Hillary\", \"Proba_Donald\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [],
   "source": [
    "joined_x = pd.merge(tweets, Probas_x, left_index=True, right_index=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>created_at</th>\n",
       "      <th>handle</th>\n",
       "      <th>mined_at</th>\n",
       "      <th>retweet_count</th>\n",
       "      <th>text</th>\n",
       "      <th>tweet_id</th>\n",
       "      <th>Proba_Hillary</th>\n",
       "      <th>Proba_Donald</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Mon Dec 24 15:55:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.714021</td>\n",
       "      <td>7771</td>\n",
       "      <td>The only problem our economy has is the Fed. T...</td>\n",
       "      <td>1077231267559755776</td>\n",
       "      <td>0.293076</td>\n",
       "      <td>0.706924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>Fri Dec 21 18:05:19 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.412145</td>\n",
       "      <td>745</td>\n",
       "      <td>As we finalize our plans for 2019 and beyond, ...</td>\n",
       "      <td>1076176803826421761</td>\n",
       "      <td>0.293076</td>\n",
       "      <td>0.706924</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Mon Dec 24 15:33:41 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.714520</td>\n",
       "      <td>8738</td>\n",
       "      <td>AMERICA IS RESPECTED AGAIN!</td>\n",
       "      <td>1077225810329825281</td>\n",
       "      <td>0.276149</td>\n",
       "      <td>0.723851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.412145</td>\n",
       "      <td>679</td>\n",
       "      <td>There was a 10-point increase in youth turnout...</td>\n",
       "      <td>1076176803126001665</td>\n",
       "      <td>0.276149</td>\n",
       "      <td>0.723851</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Mon Dec 24 15:23:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.714520</td>\n",
       "      <td>9682</td>\n",
       "      <td>For all of the sympathizers out there of Brett...</td>\n",
       "      <td>1077223213598429185</td>\n",
       "      <td>0.431758</td>\n",
       "      <td>0.568242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.412645</td>\n",
       "      <td>275</td>\n",
       "      <td>Five @EmergeAmerica alumni are headed to Congr...</td>\n",
       "      <td>1076176802387759104</td>\n",
       "      <td>0.431758</td>\n",
       "      <td>0.568242</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Mon Dec 24 14:59:23 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.714520</td>\n",
       "      <td>10225</td>\n",
       "      <td>....We are substantially subsidizing the Milit...</td>\n",
       "      <td>1077217178322194432</td>\n",
       "      <td>0.272501</td>\n",
       "      <td>0.727499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.412645</td>\n",
       "      <td>306</td>\n",
       "      <td>For many campaigns, @SwingLeft was the wave. O...</td>\n",
       "      <td>1076176801674772483</td>\n",
       "      <td>0.272501</td>\n",
       "      <td>0.727499</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Mon Dec 24 14:41:02 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.715020</td>\n",
       "      <td>10444</td>\n",
       "      <td>To those few Senators who think I don’t like o...</td>\n",
       "      <td>1077212559604924416</td>\n",
       "      <td>0.320071</td>\n",
       "      <td>0.679929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.412645</td>\n",
       "      <td>251</td>\n",
       "      <td>In 2018, @LatinoVictoryUS increased their endo...</td>\n",
       "      <td>1076176800676569088</td>\n",
       "      <td>0.320071</td>\n",
       "      <td>0.679929</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Mon Dec 24 14:31:50 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.715020</td>\n",
       "      <td>11922</td>\n",
       "      <td>Virtually every Democrat we are dealing with t...</td>\n",
       "      <td>1077210242574942208</td>\n",
       "      <td>0.301271</td>\n",
       "      <td>0.698729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Fri Dec 21 18:05:18 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.413143</td>\n",
       "      <td>332</td>\n",
       "      <td>In two years, @RunforSomething has recruited 2...</td>\n",
       "      <td>1076176799883816965</td>\n",
       "      <td>0.301271</td>\n",
       "      <td>0.698729</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Mon Dec 24 04:54:00 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.715020</td>\n",
       "      <td>16233</td>\n",
       "      <td>President @RT_Erdogan of Turkey has very stron...</td>\n",
       "      <td>1077064829825966081</td>\n",
       "      <td>0.189379</td>\n",
       "      <td>0.810621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.413143</td>\n",
       "      <td>228</td>\n",
       "      <td>.@ArenaSummit supported 54 candidates in the 2...</td>\n",
       "      <td>1076176798872948742</td>\n",
       "      <td>0.189379</td>\n",
       "      <td>0.810621</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Mon Dec 24 04:26:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.715020</td>\n",
       "      <td>12358</td>\n",
       "      <td>“The President has been remarkable. I do not d...</td>\n",
       "      <td>1077057874235400194</td>\n",
       "      <td>0.127427</td>\n",
       "      <td>0.872573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.413143</td>\n",
       "      <td>271</td>\n",
       "      <td>.@VotoLatino registered thousands of voters th...</td>\n",
       "      <td>1076176798159912961</td>\n",
       "      <td>0.127427</td>\n",
       "      <td>0.872573</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Mon Dec 24 04:05:26 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.715518</td>\n",
       "      <td>18592</td>\n",
       "      <td>The most important way to stop gangs, drugs, h...</td>\n",
       "      <td>1077052604499353600</td>\n",
       "      <td>0.331050</td>\n",
       "      <td>0.668950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.413143</td>\n",
       "      <td>249</td>\n",
       "      <td>.@ColorOfChange PAC’s #VotingWhileBlack progra...</td>\n",
       "      <td>1076176797413330944</td>\n",
       "      <td>0.331050</td>\n",
       "      <td>0.668950</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Mon Dec 24 03:47:21 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.715518</td>\n",
       "      <td>20261</td>\n",
       "      <td>Mitch McConnell just told a group of people, a...</td>\n",
       "      <td>1077048054862278656</td>\n",
       "      <td>0.195484</td>\n",
       "      <td>0.804516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.413642</td>\n",
       "      <td>240</td>\n",
       "      <td>Three candidates that @iVoteFund supported for...</td>\n",
       "      <td>1076176796658401281</td>\n",
       "      <td>0.195484</td>\n",
       "      <td>0.804516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Mon Dec 24 03:32:49 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.715518</td>\n",
       "      <td>15860</td>\n",
       "      <td>“It should not be the job of America to replac...</td>\n",
       "      <td>1077044397504692227</td>\n",
       "      <td>0.618644</td>\n",
       "      <td>0.381356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.413642</td>\n",
       "      <td>247</td>\n",
       "      <td>.@CollectivePAC helped elect over 54 African A...</td>\n",
       "      <td>1076176795916034049</td>\n",
       "      <td>0.618644</td>\n",
       "      <td>0.381356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Sun Dec 23 21:18:49 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.715518</td>\n",
       "      <td>22019</td>\n",
       "      <td>Thanks @RandPaul  “I am very proud of the Pres...</td>\n",
       "      <td>1076950276958027779</td>\n",
       "      <td>0.285903</td>\n",
       "      <td>0.714097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Fri Dec 21 18:05:17 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.413642</td>\n",
       "      <td>273</td>\n",
       "      <td>Nine @IndivisibleTeam-endorsed candidates won....</td>\n",
       "      <td>1076176795160989696</td>\n",
       "      <td>0.285903</td>\n",
       "      <td>0.714097</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Sun Dec 23 20:20:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.716017</td>\n",
       "      <td>19166</td>\n",
       "      <td>.....Bob Corker was responsible for giving us ...</td>\n",
       "      <td>1076935567760338944</td>\n",
       "      <td>0.365008</td>\n",
       "      <td>0.634992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>Fri Dec 21 18:05:16 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.413642</td>\n",
       "      <td>1646</td>\n",
       "      <td>This year, @OnwardTogether was able to give mo...</td>\n",
       "      <td>1076176794393415680</td>\n",
       "      <td>0.365008</td>\n",
       "      <td>0.634992</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Sun Dec 23 19:56:37 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.716017</td>\n",
       "      <td>14552</td>\n",
       "      <td>Senator Bob Corker just stated that, “I’m so p...</td>\n",
       "      <td>1076929590050897920</td>\n",
       "      <td>0.203172</td>\n",
       "      <td>0.796828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>Fri Dec 21 14:53:42 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.414142</td>\n",
       "      <td>31560</td>\n",
       "      <td>Actions have consequences, and whether we’re i...</td>\n",
       "      <td>1076128583419088896</td>\n",
       "      <td>0.203172</td>\n",
       "      <td>0.796828</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Sun Dec 23 19:45:22 +0000 2018</td>\n",
       "      <td>realDonaldTrump</td>\n",
       "      <td>2018-12-24 19:43:19.716017</td>\n",
       "      <td>20264</td>\n",
       "      <td>We signed two pieces of major legislation this...</td>\n",
       "      <td>1076926760829243392</td>\n",
       "      <td>0.428835</td>\n",
       "      <td>0.571165</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Thu Dec 20 16:51:43 +0000 2018</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:43:57.414142</td>\n",
       "      <td>4201</td>\n",
       "      <td>Winning back the House was a pipe dream a year...</td>\n",
       "      <td>1075795895713701888</td>\n",
       "      <td>0.428835</td>\n",
       "      <td>0.571165</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2542</th>\n",
       "      <td>Tue Aug 16 19:08:14 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616244</td>\n",
       "      <td>2176</td>\n",
       "      <td>Last night, @allysonfelix won her 7th Olympic ...</td>\n",
       "      <td>765626239679946752</td>\n",
       "      <td>0.910770</td>\n",
       "      <td>0.089230</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2543</th>\n",
       "      <td>Tue Aug 16 18:00:56 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616244</td>\n",
       "      <td>3879</td>\n",
       "      <td>It’s not just that Trump doesn’t know what he’...</td>\n",
       "      <td>765609303017451520</td>\n",
       "      <td>0.920136</td>\n",
       "      <td>0.079864</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2544</th>\n",
       "      <td>Tue Aug 16 17:49:20 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616244</td>\n",
       "      <td>1607</td>\n",
       "      <td>Be a part of this: Get registered to vote, and...</td>\n",
       "      <td>765606382271918080</td>\n",
       "      <td>0.872683</td>\n",
       "      <td>0.127317</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2545</th>\n",
       "      <td>Tue Aug 16 17:42:55 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616244</td>\n",
       "      <td>650</td>\n",
       "      <td>“@TeamUSA is showing the world what this count...</td>\n",
       "      <td>765604769310400516</td>\n",
       "      <td>0.230086</td>\n",
       "      <td>0.769914</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2546</th>\n",
       "      <td>Tue Aug 16 16:01:16 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616743</td>\n",
       "      <td>3001</td>\n",
       "      <td>You should be able to learn a skill, practice ...</td>\n",
       "      <td>765579185582698497</td>\n",
       "      <td>0.563342</td>\n",
       "      <td>0.436658</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2547</th>\n",
       "      <td>Tue Aug 16 14:24:13 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616743</td>\n",
       "      <td>2728</td>\n",
       "      <td>Trump's top adviser was designated $12.7 milli...</td>\n",
       "      <td>765554761231892480</td>\n",
       "      <td>0.650879</td>\n",
       "      <td>0.349121</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2548</th>\n",
       "      <td>Tue Aug 16 12:14:50 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616743</td>\n",
       "      <td>4586</td>\n",
       "      <td>Donald Trump says he'll create a new test for ...</td>\n",
       "      <td>765522203563536384</td>\n",
       "      <td>0.527284</td>\n",
       "      <td>0.472716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2549</th>\n",
       "      <td>Tue Aug 16 01:56:34 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616743</td>\n",
       "      <td>844</td>\n",
       "      <td>Both candidates have laid out economic plans. ...</td>\n",
       "      <td>765366612786577408</td>\n",
       "      <td>0.509982</td>\n",
       "      <td>0.490018</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2550</th>\n",
       "      <td>Tue Aug 16 01:01:58 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.616743</td>\n",
       "      <td>945</td>\n",
       "      <td>Vice President @JoeBiden had the keys to our I...</td>\n",
       "      <td>765352872016023552</td>\n",
       "      <td>0.705440</td>\n",
       "      <td>0.294560</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2551</th>\n",
       "      <td>Tue Aug 16 00:13:04 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.617242</td>\n",
       "      <td>1182</td>\n",
       "      <td>\"The place of your birth should never be a bar...</td>\n",
       "      <td>765340564569161728</td>\n",
       "      <td>0.980626</td>\n",
       "      <td>0.019374</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2552</th>\n",
       "      <td>Mon Aug 15 22:27:53 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.617242</td>\n",
       "      <td>955</td>\n",
       "      <td>The story of the Rodhams and the Bidens isn't ...</td>\n",
       "      <td>765314093473341441</td>\n",
       "      <td>0.793355</td>\n",
       "      <td>0.206645</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2553</th>\n",
       "      <td>Mon Aug 15 20:45:36 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.617242</td>\n",
       "      <td>3398</td>\n",
       "      <td>We have some questions about Donald Trump's co...</td>\n",
       "      <td>765288353419890688</td>\n",
       "      <td>0.602656</td>\n",
       "      <td>0.397344</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2554</th>\n",
       "      <td>Mon Aug 15 19:59:25 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.617242</td>\n",
       "      <td>1270</td>\n",
       "      <td>Whenever you hear Trump talk about foreign pol...</td>\n",
       "      <td>765276731406184448</td>\n",
       "      <td>0.818240</td>\n",
       "      <td>0.181760</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2555</th>\n",
       "      <td>Mon Aug 15 19:36:26 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:27.617242</td>\n",
       "      <td>4668</td>\n",
       "      <td>You oppose reproductive rights, support \"conve...</td>\n",
       "      <td>765270946693382145</td>\n",
       "      <td>0.642019</td>\n",
       "      <td>0.357981</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2556</th>\n",
       "      <td>Mon Aug 15 18:34:01 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.438703</td>\n",
       "      <td>2871</td>\n",
       "      <td>Trump's candidacy alone is undermining our nat...</td>\n",
       "      <td>765255239356260353</td>\n",
       "      <td>0.798099</td>\n",
       "      <td>0.201901</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2557</th>\n",
       "      <td>Mon Aug 15 18:03:24 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.439202</td>\n",
       "      <td>1413</td>\n",
       "      <td>“She’s strong. She’s respected. She’s admired....</td>\n",
       "      <td>765247533727834112</td>\n",
       "      <td>0.694193</td>\n",
       "      <td>0.305807</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2558</th>\n",
       "      <td>Mon Aug 15 18:00:07 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.439202</td>\n",
       "      <td>737</td>\n",
       "      <td>\"It’s a recipe for playing into the hands of t...</td>\n",
       "      <td>765246708548771840</td>\n",
       "      <td>0.664107</td>\n",
       "      <td>0.335893</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2559</th>\n",
       "      <td>Mon Aug 15 17:58:50 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.439701</td>\n",
       "      <td>696</td>\n",
       "      <td>\"Trump’s ideas are not only profoundly wrong, ...</td>\n",
       "      <td>765246387319664640</td>\n",
       "      <td>0.673615</td>\n",
       "      <td>0.326385</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2560</th>\n",
       "      <td>Mon Aug 15 17:51:18 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.439701</td>\n",
       "      <td>1027</td>\n",
       "      <td>\"Donald Trump has no clue what it takes to lea...</td>\n",
       "      <td>765244489120219136</td>\n",
       "      <td>0.541402</td>\n",
       "      <td>0.458598</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2561</th>\n",
       "      <td>Mon Aug 15 17:50:31 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.440200</td>\n",
       "      <td>1053</td>\n",
       "      <td>“This guy doesn’t care about the middle class....</td>\n",
       "      <td>765244292638056448</td>\n",
       "      <td>0.583644</td>\n",
       "      <td>0.416356</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2562</th>\n",
       "      <td>Mon Aug 15 17:46:47 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.440200</td>\n",
       "      <td>703</td>\n",
       "      <td>“There’s only one person in this election who ...</td>\n",
       "      <td>765243353520828416</td>\n",
       "      <td>0.667498</td>\n",
       "      <td>0.332502</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2563</th>\n",
       "      <td>Mon Aug 15 17:39:34 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.440699</td>\n",
       "      <td>822</td>\n",
       "      <td>\"What Hillary’s all about is making sure every...</td>\n",
       "      <td>765241534908334080</td>\n",
       "      <td>0.687994</td>\n",
       "      <td>0.312006</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2564</th>\n",
       "      <td>Mon Aug 15 17:36:43 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.440699</td>\n",
       "      <td>622</td>\n",
       "      <td>“No one is more worthy than you, and everyone ...</td>\n",
       "      <td>765240818848391168</td>\n",
       "      <td>0.763202</td>\n",
       "      <td>0.236798</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2565</th>\n",
       "      <td>Mon Aug 15 17:36:04 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.441197</td>\n",
       "      <td>625</td>\n",
       "      <td>\"Home is where your character is stamped, wher...</td>\n",
       "      <td>765240654855303169</td>\n",
       "      <td>0.446125</td>\n",
       "      <td>0.553875</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2566</th>\n",
       "      <td>Mon Aug 15 17:32:48 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.441197</td>\n",
       "      <td>506</td>\n",
       "      <td>“As Scranton has always had my back, we—all of...</td>\n",
       "      <td>765239834457800705</td>\n",
       "      <td>0.821638</td>\n",
       "      <td>0.178362</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2567</th>\n",
       "      <td>Mon Aug 15 17:29:06 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.441696</td>\n",
       "      <td>523</td>\n",
       "      <td>Take out your phone and text JOIN to 47246.\\n\\...</td>\n",
       "      <td>765238901950808065</td>\n",
       "      <td>0.620221</td>\n",
       "      <td>0.379779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2568</th>\n",
       "      <td>Mon Aug 15 17:28:30 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.441696</td>\n",
       "      <td>2002</td>\n",
       "      <td>There’s no doubt about it—Donald Trump is temp...</td>\n",
       "      <td>765238753225048064</td>\n",
       "      <td>0.358764</td>\n",
       "      <td>0.641236</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2569</th>\n",
       "      <td>Mon Aug 15 17:27:55 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.441696</td>\n",
       "      <td>3347</td>\n",
       "      <td>\"A man you can bait with a tweet is not a man ...</td>\n",
       "      <td>765238605837111300</td>\n",
       "      <td>0.497200</td>\n",
       "      <td>0.502800</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2570</th>\n",
       "      <td>Mon Aug 15 17:27:08 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.442195</td>\n",
       "      <td>3336</td>\n",
       "      <td>Trump says he won’t tell anyone what he’ll do ...</td>\n",
       "      <td>765238409669537792</td>\n",
       "      <td>0.778312</td>\n",
       "      <td>0.221688</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2571</th>\n",
       "      <td>Mon Aug 15 17:23:01 +0000 2016</td>\n",
       "      <td>HillaryClinton</td>\n",
       "      <td>2018-12-24 19:44:28.442195</td>\n",
       "      <td>949</td>\n",
       "      <td>Providing a “Trump Kids Club” for your paying ...</td>\n",
       "      <td>765237372644646914</td>\n",
       "      <td>0.721594</td>\n",
       "      <td>0.278406</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4956 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                          created_at           handle  \\\n",
       "0     Mon Dec 24 15:55:22 +0000 2018  realDonaldTrump   \n",
       "0     Fri Dec 21 18:05:19 +0000 2018   HillaryClinton   \n",
       "1     Mon Dec 24 15:33:41 +0000 2018  realDonaldTrump   \n",
       "1     Fri Dec 21 18:05:18 +0000 2018   HillaryClinton   \n",
       "2     Mon Dec 24 15:23:22 +0000 2018  realDonaldTrump   \n",
       "2     Fri Dec 21 18:05:18 +0000 2018   HillaryClinton   \n",
       "3     Mon Dec 24 14:59:23 +0000 2018  realDonaldTrump   \n",
       "3     Fri Dec 21 18:05:18 +0000 2018   HillaryClinton   \n",
       "4     Mon Dec 24 14:41:02 +0000 2018  realDonaldTrump   \n",
       "4     Fri Dec 21 18:05:18 +0000 2018   HillaryClinton   \n",
       "5     Mon Dec 24 14:31:50 +0000 2018  realDonaldTrump   \n",
       "5     Fri Dec 21 18:05:18 +0000 2018   HillaryClinton   \n",
       "6     Mon Dec 24 04:54:00 +0000 2018  realDonaldTrump   \n",
       "6     Fri Dec 21 18:05:17 +0000 2018   HillaryClinton   \n",
       "7     Mon Dec 24 04:26:22 +0000 2018  realDonaldTrump   \n",
       "7     Fri Dec 21 18:05:17 +0000 2018   HillaryClinton   \n",
       "8     Mon Dec 24 04:05:26 +0000 2018  realDonaldTrump   \n",
       "8     Fri Dec 21 18:05:17 +0000 2018   HillaryClinton   \n",
       "9     Mon Dec 24 03:47:21 +0000 2018  realDonaldTrump   \n",
       "9     Fri Dec 21 18:05:17 +0000 2018   HillaryClinton   \n",
       "10    Mon Dec 24 03:32:49 +0000 2018  realDonaldTrump   \n",
       "10    Fri Dec 21 18:05:17 +0000 2018   HillaryClinton   \n",
       "11    Sun Dec 23 21:18:49 +0000 2018  realDonaldTrump   \n",
       "11    Fri Dec 21 18:05:17 +0000 2018   HillaryClinton   \n",
       "12    Sun Dec 23 20:20:22 +0000 2018  realDonaldTrump   \n",
       "12    Fri Dec 21 18:05:16 +0000 2018   HillaryClinton   \n",
       "13    Sun Dec 23 19:56:37 +0000 2018  realDonaldTrump   \n",
       "13    Fri Dec 21 14:53:42 +0000 2018   HillaryClinton   \n",
       "14    Sun Dec 23 19:45:22 +0000 2018  realDonaldTrump   \n",
       "14    Thu Dec 20 16:51:43 +0000 2018   HillaryClinton   \n",
       "...                              ...              ...   \n",
       "2542  Tue Aug 16 19:08:14 +0000 2016   HillaryClinton   \n",
       "2543  Tue Aug 16 18:00:56 +0000 2016   HillaryClinton   \n",
       "2544  Tue Aug 16 17:49:20 +0000 2016   HillaryClinton   \n",
       "2545  Tue Aug 16 17:42:55 +0000 2016   HillaryClinton   \n",
       "2546  Tue Aug 16 16:01:16 +0000 2016   HillaryClinton   \n",
       "2547  Tue Aug 16 14:24:13 +0000 2016   HillaryClinton   \n",
       "2548  Tue Aug 16 12:14:50 +0000 2016   HillaryClinton   \n",
       "2549  Tue Aug 16 01:56:34 +0000 2016   HillaryClinton   \n",
       "2550  Tue Aug 16 01:01:58 +0000 2016   HillaryClinton   \n",
       "2551  Tue Aug 16 00:13:04 +0000 2016   HillaryClinton   \n",
       "2552  Mon Aug 15 22:27:53 +0000 2016   HillaryClinton   \n",
       "2553  Mon Aug 15 20:45:36 +0000 2016   HillaryClinton   \n",
       "2554  Mon Aug 15 19:59:25 +0000 2016   HillaryClinton   \n",
       "2555  Mon Aug 15 19:36:26 +0000 2016   HillaryClinton   \n",
       "2556  Mon Aug 15 18:34:01 +0000 2016   HillaryClinton   \n",
       "2557  Mon Aug 15 18:03:24 +0000 2016   HillaryClinton   \n",
       "2558  Mon Aug 15 18:00:07 +0000 2016   HillaryClinton   \n",
       "2559  Mon Aug 15 17:58:50 +0000 2016   HillaryClinton   \n",
       "2560  Mon Aug 15 17:51:18 +0000 2016   HillaryClinton   \n",
       "2561  Mon Aug 15 17:50:31 +0000 2016   HillaryClinton   \n",
       "2562  Mon Aug 15 17:46:47 +0000 2016   HillaryClinton   \n",
       "2563  Mon Aug 15 17:39:34 +0000 2016   HillaryClinton   \n",
       "2564  Mon Aug 15 17:36:43 +0000 2016   HillaryClinton   \n",
       "2565  Mon Aug 15 17:36:04 +0000 2016   HillaryClinton   \n",
       "2566  Mon Aug 15 17:32:48 +0000 2016   HillaryClinton   \n",
       "2567  Mon Aug 15 17:29:06 +0000 2016   HillaryClinton   \n",
       "2568  Mon Aug 15 17:28:30 +0000 2016   HillaryClinton   \n",
       "2569  Mon Aug 15 17:27:55 +0000 2016   HillaryClinton   \n",
       "2570  Mon Aug 15 17:27:08 +0000 2016   HillaryClinton   \n",
       "2571  Mon Aug 15 17:23:01 +0000 2016   HillaryClinton   \n",
       "\n",
       "                       mined_at  retweet_count  \\\n",
       "0    2018-12-24 19:43:19.714021           7771   \n",
       "0    2018-12-24 19:43:57.412145            745   \n",
       "1    2018-12-24 19:43:19.714520           8738   \n",
       "1    2018-12-24 19:43:57.412145            679   \n",
       "2    2018-12-24 19:43:19.714520           9682   \n",
       "2    2018-12-24 19:43:57.412645            275   \n",
       "3    2018-12-24 19:43:19.714520          10225   \n",
       "3    2018-12-24 19:43:57.412645            306   \n",
       "4    2018-12-24 19:43:19.715020          10444   \n",
       "4    2018-12-24 19:43:57.412645            251   \n",
       "5    2018-12-24 19:43:19.715020          11922   \n",
       "5    2018-12-24 19:43:57.413143            332   \n",
       "6    2018-12-24 19:43:19.715020          16233   \n",
       "6    2018-12-24 19:43:57.413143            228   \n",
       "7    2018-12-24 19:43:19.715020          12358   \n",
       "7    2018-12-24 19:43:57.413143            271   \n",
       "8    2018-12-24 19:43:19.715518          18592   \n",
       "8    2018-12-24 19:43:57.413143            249   \n",
       "9    2018-12-24 19:43:19.715518          20261   \n",
       "9    2018-12-24 19:43:57.413642            240   \n",
       "10   2018-12-24 19:43:19.715518          15860   \n",
       "10   2018-12-24 19:43:57.413642            247   \n",
       "11   2018-12-24 19:43:19.715518          22019   \n",
       "11   2018-12-24 19:43:57.413642            273   \n",
       "12   2018-12-24 19:43:19.716017          19166   \n",
       "12   2018-12-24 19:43:57.413642           1646   \n",
       "13   2018-12-24 19:43:19.716017          14552   \n",
       "13   2018-12-24 19:43:57.414142          31560   \n",
       "14   2018-12-24 19:43:19.716017          20264   \n",
       "14   2018-12-24 19:43:57.414142           4201   \n",
       "...                         ...            ...   \n",
       "2542 2018-12-24 19:44:27.616244           2176   \n",
       "2543 2018-12-24 19:44:27.616244           3879   \n",
       "2544 2018-12-24 19:44:27.616244           1607   \n",
       "2545 2018-12-24 19:44:27.616244            650   \n",
       "2546 2018-12-24 19:44:27.616743           3001   \n",
       "2547 2018-12-24 19:44:27.616743           2728   \n",
       "2548 2018-12-24 19:44:27.616743           4586   \n",
       "2549 2018-12-24 19:44:27.616743            844   \n",
       "2550 2018-12-24 19:44:27.616743            945   \n",
       "2551 2018-12-24 19:44:27.617242           1182   \n",
       "2552 2018-12-24 19:44:27.617242            955   \n",
       "2553 2018-12-24 19:44:27.617242           3398   \n",
       "2554 2018-12-24 19:44:27.617242           1270   \n",
       "2555 2018-12-24 19:44:27.617242           4668   \n",
       "2556 2018-12-24 19:44:28.438703           2871   \n",
       "2557 2018-12-24 19:44:28.439202           1413   \n",
       "2558 2018-12-24 19:44:28.439202            737   \n",
       "2559 2018-12-24 19:44:28.439701            696   \n",
       "2560 2018-12-24 19:44:28.439701           1027   \n",
       "2561 2018-12-24 19:44:28.440200           1053   \n",
       "2562 2018-12-24 19:44:28.440200            703   \n",
       "2563 2018-12-24 19:44:28.440699            822   \n",
       "2564 2018-12-24 19:44:28.440699            622   \n",
       "2565 2018-12-24 19:44:28.441197            625   \n",
       "2566 2018-12-24 19:44:28.441197            506   \n",
       "2567 2018-12-24 19:44:28.441696            523   \n",
       "2568 2018-12-24 19:44:28.441696           2002   \n",
       "2569 2018-12-24 19:44:28.441696           3347   \n",
       "2570 2018-12-24 19:44:28.442195           3336   \n",
       "2571 2018-12-24 19:44:28.442195            949   \n",
       "\n",
       "                                                   text             tweet_id  \\\n",
       "0     The only problem our economy has is the Fed. T...  1077231267559755776   \n",
       "0     As we finalize our plans for 2019 and beyond, ...  1076176803826421761   \n",
       "1                           AMERICA IS RESPECTED AGAIN!  1077225810329825281   \n",
       "1     There was a 10-point increase in youth turnout...  1076176803126001665   \n",
       "2     For all of the sympathizers out there of Brett...  1077223213598429185   \n",
       "2     Five @EmergeAmerica alumni are headed to Congr...  1076176802387759104   \n",
       "3     ....We are substantially subsidizing the Milit...  1077217178322194432   \n",
       "3     For many campaigns, @SwingLeft was the wave. O...  1076176801674772483   \n",
       "4     To those few Senators who think I don’t like o...  1077212559604924416   \n",
       "4     In 2018, @LatinoVictoryUS increased their endo...  1076176800676569088   \n",
       "5     Virtually every Democrat we are dealing with t...  1077210242574942208   \n",
       "5     In two years, @RunforSomething has recruited 2...  1076176799883816965   \n",
       "6     President @RT_Erdogan of Turkey has very stron...  1077064829825966081   \n",
       "6     .@ArenaSummit supported 54 candidates in the 2...  1076176798872948742   \n",
       "7     “The President has been remarkable. I do not d...  1077057874235400194   \n",
       "7     .@VotoLatino registered thousands of voters th...  1076176798159912961   \n",
       "8     The most important way to stop gangs, drugs, h...  1077052604499353600   \n",
       "8     .@ColorOfChange PAC’s #VotingWhileBlack progra...  1076176797413330944   \n",
       "9     Mitch McConnell just told a group of people, a...  1077048054862278656   \n",
       "9     Three candidates that @iVoteFund supported for...  1076176796658401281   \n",
       "10    “It should not be the job of America to replac...  1077044397504692227   \n",
       "10    .@CollectivePAC helped elect over 54 African A...  1076176795916034049   \n",
       "11    Thanks @RandPaul  “I am very proud of the Pres...  1076950276958027779   \n",
       "11    Nine @IndivisibleTeam-endorsed candidates won....  1076176795160989696   \n",
       "12    .....Bob Corker was responsible for giving us ...  1076935567760338944   \n",
       "12    This year, @OnwardTogether was able to give mo...  1076176794393415680   \n",
       "13    Senator Bob Corker just stated that, “I’m so p...  1076929590050897920   \n",
       "13    Actions have consequences, and whether we’re i...  1076128583419088896   \n",
       "14    We signed two pieces of major legislation this...  1076926760829243392   \n",
       "14    Winning back the House was a pipe dream a year...  1075795895713701888   \n",
       "...                                                 ...                  ...   \n",
       "2542  Last night, @allysonfelix won her 7th Olympic ...   765626239679946752   \n",
       "2543  It’s not just that Trump doesn’t know what he’...   765609303017451520   \n",
       "2544  Be a part of this: Get registered to vote, and...   765606382271918080   \n",
       "2545  “@TeamUSA is showing the world what this count...   765604769310400516   \n",
       "2546  You should be able to learn a skill, practice ...   765579185582698497   \n",
       "2547  Trump's top adviser was designated $12.7 milli...   765554761231892480   \n",
       "2548  Donald Trump says he'll create a new test for ...   765522203563536384   \n",
       "2549  Both candidates have laid out economic plans. ...   765366612786577408   \n",
       "2550  Vice President @JoeBiden had the keys to our I...   765352872016023552   \n",
       "2551  \"The place of your birth should never be a bar...   765340564569161728   \n",
       "2552  The story of the Rodhams and the Bidens isn't ...   765314093473341441   \n",
       "2553  We have some questions about Donald Trump's co...   765288353419890688   \n",
       "2554  Whenever you hear Trump talk about foreign pol...   765276731406184448   \n",
       "2555  You oppose reproductive rights, support \"conve...   765270946693382145   \n",
       "2556  Trump's candidacy alone is undermining our nat...   765255239356260353   \n",
       "2557  “She’s strong. She’s respected. She’s admired....   765247533727834112   \n",
       "2558  \"It’s a recipe for playing into the hands of t...   765246708548771840   \n",
       "2559  \"Trump’s ideas are not only profoundly wrong, ...   765246387319664640   \n",
       "2560  \"Donald Trump has no clue what it takes to lea...   765244489120219136   \n",
       "2561  “This guy doesn’t care about the middle class....   765244292638056448   \n",
       "2562  “There’s only one person in this election who ...   765243353520828416   \n",
       "2563  \"What Hillary’s all about is making sure every...   765241534908334080   \n",
       "2564  “No one is more worthy than you, and everyone ...   765240818848391168   \n",
       "2565  \"Home is where your character is stamped, wher...   765240654855303169   \n",
       "2566  “As Scranton has always had my back, we—all of...   765239834457800705   \n",
       "2567  Take out your phone and text JOIN to 47246.\\n\\...   765238901950808065   \n",
       "2568  There’s no doubt about it—Donald Trump is temp...   765238753225048064   \n",
       "2569  \"A man you can bait with a tweet is not a man ...   765238605837111300   \n",
       "2570  Trump says he won’t tell anyone what he’ll do ...   765238409669537792   \n",
       "2571  Providing a “Trump Kids Club” for your paying ...   765237372644646914   \n",
       "\n",
       "      Proba_Hillary  Proba_Donald  \n",
       "0          0.293076      0.706924  \n",
       "0          0.293076      0.706924  \n",
       "1          0.276149      0.723851  \n",
       "1          0.276149      0.723851  \n",
       "2          0.431758      0.568242  \n",
       "2          0.431758      0.568242  \n",
       "3          0.272501      0.727499  \n",
       "3          0.272501      0.727499  \n",
       "4          0.320071      0.679929  \n",
       "4          0.320071      0.679929  \n",
       "5          0.301271      0.698729  \n",
       "5          0.301271      0.698729  \n",
       "6          0.189379      0.810621  \n",
       "6          0.189379      0.810621  \n",
       "7          0.127427      0.872573  \n",
       "7          0.127427      0.872573  \n",
       "8          0.331050      0.668950  \n",
       "8          0.331050      0.668950  \n",
       "9          0.195484      0.804516  \n",
       "9          0.195484      0.804516  \n",
       "10         0.618644      0.381356  \n",
       "10         0.618644      0.381356  \n",
       "11         0.285903      0.714097  \n",
       "11         0.285903      0.714097  \n",
       "12         0.365008      0.634992  \n",
       "12         0.365008      0.634992  \n",
       "13         0.203172      0.796828  \n",
       "13         0.203172      0.796828  \n",
       "14         0.428835      0.571165  \n",
       "14         0.428835      0.571165  \n",
       "...             ...           ...  \n",
       "2542       0.910770      0.089230  \n",
       "2543       0.920136      0.079864  \n",
       "2544       0.872683      0.127317  \n",
       "2545       0.230086      0.769914  \n",
       "2546       0.563342      0.436658  \n",
       "2547       0.650879      0.349121  \n",
       "2548       0.527284      0.472716  \n",
       "2549       0.509982      0.490018  \n",
       "2550       0.705440      0.294560  \n",
       "2551       0.980626      0.019374  \n",
       "2552       0.793355      0.206645  \n",
       "2553       0.602656      0.397344  \n",
       "2554       0.818240      0.181760  \n",
       "2555       0.642019      0.357981  \n",
       "2556       0.798099      0.201901  \n",
       "2557       0.694193      0.305807  \n",
       "2558       0.664107      0.335893  \n",
       "2559       0.673615      0.326385  \n",
       "2560       0.541402      0.458598  \n",
       "2561       0.583644      0.416356  \n",
       "2562       0.667498      0.332502  \n",
       "2563       0.687994      0.312006  \n",
       "2564       0.763202      0.236798  \n",
       "2565       0.446125      0.553875  \n",
       "2566       0.821638      0.178362  \n",
       "2567       0.620221      0.379779  \n",
       "2568       0.358764      0.641236  \n",
       "2569       0.497200      0.502800  \n",
       "2570       0.778312      0.221688  \n",
       "2571       0.721594      0.278406  \n",
       "\n",
       "[4956 rows x 8 columns]"
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "joined_x"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\"The place of your birth should never be a barrier.\" A letter to young undocumented people on DACA's anniversary: https://t.co/4dDrLvefeM\n"
     ]
    }
   ],
   "source": [
    "#hillary clinton'a ait olabilecek en güçlü aday tweet metni\n",
    "joined_hillary = joined_x[joined_x['handle']==\"HillaryClinton\"]\n",
    "for el in joined_hillary[joined_hillary['Proba_Hillary']==max(joined_hillary['Proba_Hillary'])]['text']:\n",
    "    print (el)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\"He thinks we should be afraid of our Muslim brothers and sisters—because he has no idea who they really are.\" —@FLOTUS on Trump\n"
     ]
    }
   ],
   "source": [
    "#hillary clinton'a ait olabilecek en düşük olasılıklı aday tweet metni\n",
    "for el in joined_hillary[joined_hillary['Proba_Hillary']==min(joined_hillary['Proba_Hillary'])]['text']:\n",
    "    print (el)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "THE FAKE NEWS MEDIA IS THE OPPOSITION PARTY. It is very bad for our Great Country....BUT WE ARE WINNING!\n"
     ]
    }
   ],
   "source": [
    "#DonaldTrump'a ait olabilecek en güçlü aday tweet metni\n",
    "joined_donald = joined_x[joined_x['handle']==\"realDonaldTrump\"]\n",
    "for el in joined_donald[joined_donald['Proba_Donald']==max(joined_donald['Proba_Donald'])]['text']:\n",
    "    print (el)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Statement on National Strategy for Counterterrorism: https://t.co/ajFBg9Elsj https://t.co/Qr56ycjMAV\n",
      "“USMCA Wins Praise as a Victory for American Industries and Workers”➡️https://t.co/UWhPhNXiiL https://t.co/eBVv0nXXRT\n",
      "#HurricaneFlorence \n",
      "https://t.co/mP7icn0Yzl https://t.co/jOdKT02rbH\n",
      "#500Days of American Greatness: https://t.co/qQEEPqmaax https://t.co/1VCeoTk1cI\n"
     ]
    }
   ],
   "source": [
    "#DonaldTrump'a ait olabilecek en düşük olasılıklı aday tweet metni\n",
    "for el in joined_donald[joined_donald['Proba_Donald']==min(joined_donald['Proba_Donald'])]['text']:\n",
    "    print (el)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Proba_Hillary</th>\n",
       "      <th>Proba_Trump</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.742282</td>\n",
       "      <td>0.257718</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.850053</td>\n",
       "      <td>0.149947</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Proba_Hillary  Proba_Trump\n",
       "0       0.742282     0.257718\n",
       "1       0.850053     0.149947"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Kaynağın TfIdf vector olarak ayarlanması\n",
    "source_test = [\n",
    "   \"To all the little girls watching...never doubt that you are valuable and powerful & deserving of every chance & opportunity in the world.\",\n",
    "   \"Nevada just became the first state in the country to have a legislature that's majority women. Let's make it the first of many.\"\n",
    "]\n",
    "\n",
    "Xtest = tfv.transform(source_test)\n",
    "pd.DataFrame(estimator.predict_proba(Xtest), columns=[\"Proba_Hillary\", \"Proba_Trump\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Proba_Hillary</th>\n",
       "      <th>Proba_Trump</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.074154</td>\n",
       "      <td>0.925846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.288556</td>\n",
       "      <td>0.711444</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Proba_Hillary  Proba_Trump\n",
       "0       0.074154     0.925846\n",
       "1       0.288556     0.711444"
      ]
     },
     "execution_count": 35,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Kaynağın TfIdf vector olarak ayarlanması\n",
    "source_test = [\n",
    "   \"I am all alone (poor me) in the White House waiting for the Democrats to come back and make a deal on desperately needed Border Security. At some point the Democrats not wanting to make a deal will cost our Country more money than the Border Wall we are all talking about. Crazy!\",\n",
    "   \"Saudi Arabia has now agreed to spend the necessary money needed to help rebuild Syria, instead of the United States. See? Isn’t it nice when immensely wealthy countries help rebuild their neighbors rather than a Great Country, the U.S., that is 5000 miles away. Thanks to Saudi A!\"\n",
    "]\n",
    "\n",
    "Xtest = tfv.transform(source_test)\n",
    "pd.DataFrame(estimator.predict_proba(Xtest), columns=[\"Proba_Hillary\", \"Proba_Trump\"])\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 37,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Proba_Hillary</th>\n",
       "      <th>Proba_Trump</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0.055058</td>\n",
       "      <td>0.944942</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>0.726158</td>\n",
       "      <td>0.273842</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   Proba_Hillary  Proba_Trump\n",
       "0       0.055058     0.944942\n",
       "1       0.726158     0.273842"
      ]
     },
     "execution_count": 37,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Kaynağın TfIdf vector olarak ayarlanması\n",
    "source_test = [\n",
    "   \"The Wall is different than the 25 Billion Dollars in Border Security. The complete Wall will be built with the Shutdown money plus funds already in hand. The reporting has been inaccurate on the point. The problem is, without the Wall, much of the rest of Dollars are wasted!\",\n",
    "   \"There’s new CDC data out about gun deaths in America. Last year saw the most gun deaths in 40 years, nearly 40,000 people. What is wrong with us? This is not a problem we should have at all, let alone one that’s getting worse.\"\n",
    "]\n",
    "\n",
    "Xtest = tfv.transform(source_test)\n",
    "pd.DataFrame(estimator.predict_proba(Xtest), columns=[\"Proba_Hillary\", \"Proba_Trump\"])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}