vader_analys.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Requirement already satisfied: vaderSentiment in c:\\users\\lukas\\anaconda3\\lib\\site-packages (3.2.1)\n"
     ]
    }
   ],
   "source": [
    "!pip install vaderSentiment"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "import csv\n",
    "from sqlalchemy import create_engine\n",
    "from sqlalchemy.orm import sessionmaker\n",
    "import pandas as pd\n",
    "import os.path"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [],
   "source": [
    "# configure Session class with desired options\n",
    "Session = sessionmaker()\n",
    "engine = create_engine('sqlite:///twitter.db')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['hashtag', 'retweet', 'tweet', 'user', 'vader']"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "engine.table_names()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(17596, 2)\n"
     ]
    }
   ],
   "source": [
    "#VADER\n",
    "from vaderSentiment.vaderSentiment import SentimentIntensityAnalyzer\n",
    "analyser = SentimentIntensityAnalyzer()\n",
    "\n",
    "allTweets = pd.read_sql_query('SELECT tweet_id as id, tweet_text as text FROM tweet', engine)\n",
    "print(allTweets.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(79436, 2)\n"
     ]
    }
   ],
   "source": [
    "allRetweets =  pd.read_sql_query('SELECT retweet_id as id, retweet_text as text FROM retweet', engine)\n",
    "print(allRetweets.shape)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(92406, 2)"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vaderData = allTweets.append([allRetweets])\n",
    "vaderData.drop_duplicates(inplace=True)\n",
    "# vaderData = vaderData[:60000]\n",
    "vaderData.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "(92404, 1)\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "(92406, 1)"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "vaderIDs = pd.read_sql_query('SELECT id FROM vader', engine)\n",
    "solo = vaderIDs.drop_duplicates()\n",
    "print(solo.shape)\n",
    "vaderIDs.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "newVaders = pd.DataFrame(columns=['id', 'negative','neutral','positive','compound'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>negative</th>\n",
       "      <th>neutral</th>\n",
       "      <th>positive</th>\n",
       "      <th>compound</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.056095e+18</td>\n",
       "      <td>0.181</td>\n",
       "      <td>0.733</td>\n",
       "      <td>0.086</td>\n",
       "      <td>-0.4939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.848</td>\n",
       "      <td>0.152</td>\n",
       "      <td>0.3612</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.179</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.5719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1.056139e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.863</td>\n",
       "      <td>0.137</td>\n",
       "      <td>0.4019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1.056153e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.851</td>\n",
       "      <td>0.149</td>\n",
       "      <td>0.4215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.056154e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.056165e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1.056175e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.863</td>\n",
       "      <td>0.137</td>\n",
       "      <td>0.4019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.056199e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.832</td>\n",
       "      <td>0.168</td>\n",
       "      <td>0.4995</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1.056206e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1.056210e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.856</td>\n",
       "      <td>0.144</td>\n",
       "      <td>0.4019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1.056210e+18</td>\n",
       "      <td>0.179</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.5719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1.056212e+18</td>\n",
       "      <td>0.171</td>\n",
       "      <td>0.829</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1.056216e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.892</td>\n",
       "      <td>0.108</td>\n",
       "      <td>0.4404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1.056217e+18</td>\n",
       "      <td>0.259</td>\n",
       "      <td>0.741</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.6369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1.056221e+18</td>\n",
       "      <td>0.117</td>\n",
       "      <td>0.778</td>\n",
       "      <td>0.105</td>\n",
       "      <td>-0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1.056222e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.872</td>\n",
       "      <td>0.128</td>\n",
       "      <td>0.4215</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1.056222e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.909</td>\n",
       "      <td>0.091</td>\n",
       "      <td>0.2716</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1.056232e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1.056257e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1.056259e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1.056263e+18</td>\n",
       "      <td>0.202</td>\n",
       "      <td>0.798</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.5859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1.056267e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1.056268e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1.056276e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1.056278e+18</td>\n",
       "      <td>0.285</td>\n",
       "      <td>0.625</td>\n",
       "      <td>0.090</td>\n",
       "      <td>-0.7184</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1.056314e+18</td>\n",
       "      <td>0.259</td>\n",
       "      <td>0.741</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.6369</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92376</th>\n",
       "      <td>1.057414e+18</td>\n",
       "      <td>0.151</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.259</td>\n",
       "      <td>0.3749</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92377</th>\n",
       "      <td>1.057414e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92378</th>\n",
       "      <td>1.057415e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92379</th>\n",
       "      <td>1.057415e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92380</th>\n",
       "      <td>1.057415e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92381</th>\n",
       "      <td>1.057415e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92382</th>\n",
       "      <td>1.057417e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92383</th>\n",
       "      <td>1.057417e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92384</th>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.933</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92385</th>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.093</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.086</td>\n",
       "      <td>-0.0408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92386</th>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.140</td>\n",
       "      <td>0.860</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92387</th>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.261</td>\n",
       "      <td>0.739</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.6486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92388</th>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92389</th>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92390</th>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92391</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.261</td>\n",
       "      <td>0.739</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.6486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92392</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.140</td>\n",
       "      <td>0.860</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92393</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.305</td>\n",
       "      <td>0.695</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4724</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92394</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.093</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.086</td>\n",
       "      <td>-0.0408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92395</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92396</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.933</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92397</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92398</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.140</td>\n",
       "      <td>0.860</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92399</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.933</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92400</th>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92401</th>\n",
       "      <td>1.057420e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92402</th>\n",
       "      <td>1.057420e+18</td>\n",
       "      <td>0.093</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.086</td>\n",
       "      <td>-0.0408</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92403</th>\n",
       "      <td>1.057420e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92404</th>\n",
       "      <td>1.057421e+18</td>\n",
       "      <td>0.138</td>\n",
       "      <td>0.704</td>\n",
       "      <td>0.158</td>\n",
       "      <td>0.1779</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92405</th>\n",
       "      <td>1.057422e+18</td>\n",
       "      <td>0.305</td>\n",
       "      <td>0.695</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4724</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>92406 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 id  negative  neutral  positive  compound\n",
       "0      1.056095e+18     0.181    0.733     0.086   -0.4939\n",
       "1      1.056126e+18     0.000    1.000     0.000    0.0000\n",
       "2      1.056126e+18     0.000    0.848     0.152    0.3612\n",
       "3      1.056126e+18     0.000    1.000     0.000    0.0000\n",
       "4      1.056126e+18     0.000    1.000     0.000    0.0000\n",
       "5      1.056126e+18     0.179    0.821     0.000   -0.5719\n",
       "6      1.056139e+18     0.000    0.863     0.137    0.4019\n",
       "7      1.056153e+18     0.000    0.851     0.149    0.4215\n",
       "8      1.056154e+18     0.000    1.000     0.000    0.0000\n",
       "9      1.056165e+18     0.000    1.000     0.000    0.0000\n",
       "10     1.056175e+18     0.000    0.863     0.137    0.4019\n",
       "11     1.056199e+18     0.000    0.832     0.168    0.4995\n",
       "12     1.056206e+18     0.000    1.000     0.000    0.0000\n",
       "13     1.056210e+18     0.000    0.856     0.144    0.4019\n",
       "14     1.056210e+18     0.179    0.821     0.000   -0.5719\n",
       "15     1.056212e+18     0.171    0.829     0.000   -0.4767\n",
       "16     1.056216e+18     0.000    0.892     0.108    0.4404\n",
       "17     1.056217e+18     0.259    0.741     0.000   -0.6369\n",
       "18     1.056221e+18     0.117    0.778     0.105   -0.0772\n",
       "19     1.056222e+18     0.000    0.872     0.128    0.4215\n",
       "20     1.056222e+18     0.000    0.909     0.091    0.2716\n",
       "21     1.056232e+18     0.000    1.000     0.000    0.0000\n",
       "22     1.056257e+18     0.000    1.000     0.000    0.0000\n",
       "23     1.056259e+18     0.000    1.000     0.000    0.0000\n",
       "24     1.056263e+18     0.202    0.798     0.000   -0.5859\n",
       "25     1.056267e+18     0.000    1.000     0.000    0.0000\n",
       "26     1.056268e+18     0.000    1.000     0.000    0.0000\n",
       "27     1.056276e+18     0.000    1.000     0.000    0.0000\n",
       "28     1.056278e+18     0.285    0.625     0.090   -0.7184\n",
       "29     1.056314e+18     0.259    0.741     0.000   -0.6369\n",
       "...             ...       ...      ...       ...       ...\n",
       "92376  1.057414e+18     0.151    0.589     0.259    0.3749\n",
       "92377  1.057414e+18     0.000    0.857     0.143    0.2500\n",
       "92378  1.057415e+18     0.000    0.857     0.143    0.2500\n",
       "92379  1.057415e+18     0.000    1.000     0.000    0.0000\n",
       "92380  1.057415e+18     0.000    0.857     0.143    0.2500\n",
       "92381  1.057415e+18     0.000    1.000     0.000    0.0000\n",
       "92382  1.057417e+18     0.000    1.000     0.000    0.0000\n",
       "92383  1.057417e+18     0.000    1.000     0.000    0.0000\n",
       "92384  1.057418e+18     0.067    0.933     0.000   -0.0772\n",
       "92385  1.057418e+18     0.093    0.821     0.086   -0.0408\n",
       "92386  1.057418e+18     0.140    0.860     0.000   -0.4767\n",
       "92387  1.057418e+18     0.261    0.739     0.000   -0.6486\n",
       "92388  1.057418e+18     0.000    0.857     0.143    0.2500\n",
       "92389  1.057418e+18     0.000    1.000     0.000    0.0000\n",
       "92390  1.057418e+18     0.000    1.000     0.000    0.0000\n",
       "92391  1.057419e+18     0.261    0.739     0.000   -0.6486\n",
       "92392  1.057419e+18     0.140    0.860     0.000   -0.4767\n",
       "92393  1.057419e+18     0.305    0.695     0.000   -0.4724\n",
       "92394  1.057419e+18     0.093    0.821     0.086   -0.0408\n",
       "92395  1.057419e+18     0.000    1.000     0.000    0.0000\n",
       "92396  1.057419e+18     0.067    0.933     0.000   -0.0772\n",
       "92397  1.057419e+18     0.000    1.000     0.000    0.0000\n",
       "92398  1.057419e+18     0.140    0.860     0.000   -0.4767\n",
       "92399  1.057419e+18     0.067    0.933     0.000   -0.0772\n",
       "92400  1.057419e+18     0.000    0.857     0.143    0.2500\n",
       "92401  1.057420e+18     0.000    1.000     0.000    0.0000\n",
       "92402  1.057420e+18     0.093    0.821     0.086   -0.0408\n",
       "92403  1.057420e+18     0.000    0.857     0.143    0.2500\n",
       "92404  1.057421e+18     0.138    0.704     0.158    0.1779\n",
       "92405  1.057422e+18     0.305    0.695     0.000   -0.4724\n",
       "\n",
       "[92406 rows x 5 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for index, row in vaderData.iterrows():\n",
    "      if(not vaderIDs['id'].isin([row['id']]).any()):\n",
    "        snt = analyser.polarity_scores(row['text'])\n",
    "        newVaders = newVaders.append({'id': row['id'],\n",
    "                                     'negative': snt['neg'],\n",
    "                                     'neutral': snt['neu'],\n",
    "                                     'positive': snt['pos'],\n",
    "                                     'compound': snt['compound']}, ignore_index=True)\n",
    "newVaders"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "newVaders.to_sql('vader', engine, if_exists='append')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "# from sqlalchemy import MetaData, Table\n",
    "# meta = MetaData()\n",
    "# vader_tab = Table('vader', meta)\n",
    "# vader_tab.drop(engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(92406, 6)"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#Analyse\n",
    "analyse_df = pd.read_sql_query('SELECT * FROM vader', engine)\n",
    "analyse_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "for index, row in analyse_df.iterrows():\n",
    "    final_score = round(row[\"compound\"],2) * 50 + 50\n",
    "    analyse_df.at[index,'percent'] = final_score\n",
    "    if(final_score<34):\n",
    "        analyse_df.at[index,'mood'] = \"Bad\"\n",
    "    elif(final_score<67):\n",
    "        analyse_df.at[index,'mood'] = \"Neutral\"\n",
    "    else:\n",
    "        analyse_df.at[index,'mood'] = \"Good\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "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>index</th>\n",
       "      <th>id</th>\n",
       "      <th>negative</th>\n",
       "      <th>neutral</th>\n",
       "      <th>positive</th>\n",
       "      <th>compound</th>\n",
       "      <th>percent</th>\n",
       "      <th>mood</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1.056095e+18</td>\n",
       "      <td>0.181</td>\n",
       "      <td>0.733</td>\n",
       "      <td>0.086</td>\n",
       "      <td>-0.4939</td>\n",
       "      <td>25.5</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.848</td>\n",
       "      <td>0.152</td>\n",
       "      <td>0.3612</td>\n",
       "      <td>68.0</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>1.056126e+18</td>\n",
       "      <td>0.179</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.5719</td>\n",
       "      <td>21.5</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>1.056139e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.863</td>\n",
       "      <td>0.137</td>\n",
       "      <td>0.4019</td>\n",
       "      <td>70.0</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>1.056153e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.851</td>\n",
       "      <td>0.149</td>\n",
       "      <td>0.4215</td>\n",
       "      <td>71.0</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>1.056154e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>1.056165e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>1.056175e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.863</td>\n",
       "      <td>0.137</td>\n",
       "      <td>0.4019</td>\n",
       "      <td>70.0</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>1.056199e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.832</td>\n",
       "      <td>0.168</td>\n",
       "      <td>0.4995</td>\n",
       "      <td>75.0</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>1.056206e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>1.056210e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.856</td>\n",
       "      <td>0.144</td>\n",
       "      <td>0.4019</td>\n",
       "      <td>70.0</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>1.056210e+18</td>\n",
       "      <td>0.179</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.5719</td>\n",
       "      <td>21.5</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>1.056212e+18</td>\n",
       "      <td>0.171</td>\n",
       "      <td>0.829</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4767</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>1.056216e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.892</td>\n",
       "      <td>0.108</td>\n",
       "      <td>0.4404</td>\n",
       "      <td>72.0</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>1.056217e+18</td>\n",
       "      <td>0.259</td>\n",
       "      <td>0.741</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.6369</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>1.056221e+18</td>\n",
       "      <td>0.117</td>\n",
       "      <td>0.778</td>\n",
       "      <td>0.105</td>\n",
       "      <td>-0.0772</td>\n",
       "      <td>46.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>1.056222e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.872</td>\n",
       "      <td>0.128</td>\n",
       "      <td>0.4215</td>\n",
       "      <td>71.0</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>1.056222e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.909</td>\n",
       "      <td>0.091</td>\n",
       "      <td>0.2716</td>\n",
       "      <td>63.5</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>1.056232e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>1.056257e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>1.056259e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>1.056263e+18</td>\n",
       "      <td>0.202</td>\n",
       "      <td>0.798</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.5859</td>\n",
       "      <td>20.5</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>1.056267e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>1.056268e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>1.056276e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>1.056278e+18</td>\n",
       "      <td>0.285</td>\n",
       "      <td>0.625</td>\n",
       "      <td>0.090</td>\n",
       "      <td>-0.7184</td>\n",
       "      <td>14.0</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>1.056314e+18</td>\n",
       "      <td>0.259</td>\n",
       "      <td>0.741</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.6369</td>\n",
       "      <td>18.0</td>\n",
       "      <td>Bad</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>92376</th>\n",
       "      <td>92376</td>\n",
       "      <td>1.057414e+18</td>\n",
       "      <td>0.151</td>\n",
       "      <td>0.589</td>\n",
       "      <td>0.259</td>\n",
       "      <td>0.3749</td>\n",
       "      <td>68.5</td>\n",
       "      <td>Good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92377</th>\n",
       "      <td>92377</td>\n",
       "      <td>1.057414e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>62.5</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92378</th>\n",
       "      <td>92378</td>\n",
       "      <td>1.057415e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>62.5</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92379</th>\n",
       "      <td>92379</td>\n",
       "      <td>1.057415e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92380</th>\n",
       "      <td>92380</td>\n",
       "      <td>1.057415e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>62.5</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92381</th>\n",
       "      <td>92381</td>\n",
       "      <td>1.057415e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92382</th>\n",
       "      <td>92382</td>\n",
       "      <td>1.057417e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92383</th>\n",
       "      <td>92383</td>\n",
       "      <td>1.057417e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92384</th>\n",
       "      <td>92384</td>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.933</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.0772</td>\n",
       "      <td>46.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92385</th>\n",
       "      <td>92385</td>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.093</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.086</td>\n",
       "      <td>-0.0408</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92386</th>\n",
       "      <td>92386</td>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.140</td>\n",
       "      <td>0.860</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4767</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92387</th>\n",
       "      <td>92387</td>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.261</td>\n",
       "      <td>0.739</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.6486</td>\n",
       "      <td>17.5</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92388</th>\n",
       "      <td>92388</td>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>62.5</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92389</th>\n",
       "      <td>92389</td>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92390</th>\n",
       "      <td>92390</td>\n",
       "      <td>1.057418e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92391</th>\n",
       "      <td>92391</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.261</td>\n",
       "      <td>0.739</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.6486</td>\n",
       "      <td>17.5</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92392</th>\n",
       "      <td>92392</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.140</td>\n",
       "      <td>0.860</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4767</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92393</th>\n",
       "      <td>92393</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.305</td>\n",
       "      <td>0.695</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4724</td>\n",
       "      <td>26.5</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92394</th>\n",
       "      <td>92394</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.093</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.086</td>\n",
       "      <td>-0.0408</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92395</th>\n",
       "      <td>92395</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92396</th>\n",
       "      <td>92396</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.933</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.0772</td>\n",
       "      <td>46.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92397</th>\n",
       "      <td>92397</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92398</th>\n",
       "      <td>92398</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.140</td>\n",
       "      <td>0.860</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4767</td>\n",
       "      <td>26.0</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92399</th>\n",
       "      <td>92399</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.067</td>\n",
       "      <td>0.933</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.0772</td>\n",
       "      <td>46.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92400</th>\n",
       "      <td>92400</td>\n",
       "      <td>1.057419e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>62.5</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92401</th>\n",
       "      <td>92401</td>\n",
       "      <td>1.057420e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>1.000</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.0000</td>\n",
       "      <td>50.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92402</th>\n",
       "      <td>92402</td>\n",
       "      <td>1.057420e+18</td>\n",
       "      <td>0.093</td>\n",
       "      <td>0.821</td>\n",
       "      <td>0.086</td>\n",
       "      <td>-0.0408</td>\n",
       "      <td>48.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92403</th>\n",
       "      <td>92403</td>\n",
       "      <td>1.057420e+18</td>\n",
       "      <td>0.000</td>\n",
       "      <td>0.857</td>\n",
       "      <td>0.143</td>\n",
       "      <td>0.2500</td>\n",
       "      <td>62.5</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92404</th>\n",
       "      <td>92404</td>\n",
       "      <td>1.057421e+18</td>\n",
       "      <td>0.138</td>\n",
       "      <td>0.704</td>\n",
       "      <td>0.158</td>\n",
       "      <td>0.1779</td>\n",
       "      <td>59.0</td>\n",
       "      <td>Neutral</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92405</th>\n",
       "      <td>92405</td>\n",
       "      <td>1.057422e+18</td>\n",
       "      <td>0.305</td>\n",
       "      <td>0.695</td>\n",
       "      <td>0.000</td>\n",
       "      <td>-0.4724</td>\n",
       "      <td>26.5</td>\n",
       "      <td>Bad</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>92406 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       index            id  negative  neutral  positive  compound  percent  \\\n",
       "0          0  1.056095e+18     0.181    0.733     0.086   -0.4939     25.5   \n",
       "1          1  1.056126e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "2          2  1.056126e+18     0.000    0.848     0.152    0.3612     68.0   \n",
       "3          3  1.056126e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "4          4  1.056126e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "5          5  1.056126e+18     0.179    0.821     0.000   -0.5719     21.5   \n",
       "6          6  1.056139e+18     0.000    0.863     0.137    0.4019     70.0   \n",
       "7          7  1.056153e+18     0.000    0.851     0.149    0.4215     71.0   \n",
       "8          8  1.056154e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "9          9  1.056165e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "10        10  1.056175e+18     0.000    0.863     0.137    0.4019     70.0   \n",
       "11        11  1.056199e+18     0.000    0.832     0.168    0.4995     75.0   \n",
       "12        12  1.056206e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "13        13  1.056210e+18     0.000    0.856     0.144    0.4019     70.0   \n",
       "14        14  1.056210e+18     0.179    0.821     0.000   -0.5719     21.5   \n",
       "15        15  1.056212e+18     0.171    0.829     0.000   -0.4767     26.0   \n",
       "16        16  1.056216e+18     0.000    0.892     0.108    0.4404     72.0   \n",
       "17        17  1.056217e+18     0.259    0.741     0.000   -0.6369     18.0   \n",
       "18        18  1.056221e+18     0.117    0.778     0.105   -0.0772     46.0   \n",
       "19        19  1.056222e+18     0.000    0.872     0.128    0.4215     71.0   \n",
       "20        20  1.056222e+18     0.000    0.909     0.091    0.2716     63.5   \n",
       "21        21  1.056232e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "22        22  1.056257e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "23        23  1.056259e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "24        24  1.056263e+18     0.202    0.798     0.000   -0.5859     20.5   \n",
       "25        25  1.056267e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "26        26  1.056268e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "27        27  1.056276e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "28        28  1.056278e+18     0.285    0.625     0.090   -0.7184     14.0   \n",
       "29        29  1.056314e+18     0.259    0.741     0.000   -0.6369     18.0   \n",
       "...      ...           ...       ...      ...       ...       ...      ...   \n",
       "92376  92376  1.057414e+18     0.151    0.589     0.259    0.3749     68.5   \n",
       "92377  92377  1.057414e+18     0.000    0.857     0.143    0.2500     62.5   \n",
       "92378  92378  1.057415e+18     0.000    0.857     0.143    0.2500     62.5   \n",
       "92379  92379  1.057415e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92380  92380  1.057415e+18     0.000    0.857     0.143    0.2500     62.5   \n",
       "92381  92381  1.057415e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92382  92382  1.057417e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92383  92383  1.057417e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92384  92384  1.057418e+18     0.067    0.933     0.000   -0.0772     46.0   \n",
       "92385  92385  1.057418e+18     0.093    0.821     0.086   -0.0408     48.0   \n",
       "92386  92386  1.057418e+18     0.140    0.860     0.000   -0.4767     26.0   \n",
       "92387  92387  1.057418e+18     0.261    0.739     0.000   -0.6486     17.5   \n",
       "92388  92388  1.057418e+18     0.000    0.857     0.143    0.2500     62.5   \n",
       "92389  92389  1.057418e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92390  92390  1.057418e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92391  92391  1.057419e+18     0.261    0.739     0.000   -0.6486     17.5   \n",
       "92392  92392  1.057419e+18     0.140    0.860     0.000   -0.4767     26.0   \n",
       "92393  92393  1.057419e+18     0.305    0.695     0.000   -0.4724     26.5   \n",
       "92394  92394  1.057419e+18     0.093    0.821     0.086   -0.0408     48.0   \n",
       "92395  92395  1.057419e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92396  92396  1.057419e+18     0.067    0.933     0.000   -0.0772     46.0   \n",
       "92397  92397  1.057419e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92398  92398  1.057419e+18     0.140    0.860     0.000   -0.4767     26.0   \n",
       "92399  92399  1.057419e+18     0.067    0.933     0.000   -0.0772     46.0   \n",
       "92400  92400  1.057419e+18     0.000    0.857     0.143    0.2500     62.5   \n",
       "92401  92401  1.057420e+18     0.000    1.000     0.000    0.0000     50.0   \n",
       "92402  92402  1.057420e+18     0.093    0.821     0.086   -0.0408     48.0   \n",
       "92403  92403  1.057420e+18     0.000    0.857     0.143    0.2500     62.5   \n",
       "92404  92404  1.057421e+18     0.138    0.704     0.158    0.1779     59.0   \n",
       "92405  92405  1.057422e+18     0.305    0.695     0.000   -0.4724     26.5   \n",
       "\n",
       "          mood  \n",
       "0          Bad  \n",
       "1      Neutral  \n",
       "2         Good  \n",
       "3      Neutral  \n",
       "4      Neutral  \n",
       "5          Bad  \n",
       "6         Good  \n",
       "7         Good  \n",
       "8      Neutral  \n",
       "9      Neutral  \n",
       "10        Good  \n",
       "11        Good  \n",
       "12     Neutral  \n",
       "13        Good  \n",
       "14         Bad  \n",
       "15         Bad  \n",
       "16        Good  \n",
       "17         Bad  \n",
       "18     Neutral  \n",
       "19        Good  \n",
       "20     Neutral  \n",
       "21     Neutral  \n",
       "22     Neutral  \n",
       "23     Neutral  \n",
       "24         Bad  \n",
       "25     Neutral  \n",
       "26     Neutral  \n",
       "27     Neutral  \n",
       "28         Bad  \n",
       "29         Bad  \n",
       "...        ...  \n",
       "92376     Good  \n",
       "92377  Neutral  \n",
       "92378  Neutral  \n",
       "92379  Neutral  \n",
       "92380  Neutral  \n",
       "92381  Neutral  \n",
       "92382  Neutral  \n",
       "92383  Neutral  \n",
       "92384  Neutral  \n",
       "92385  Neutral  \n",
       "92386      Bad  \n",
       "92387      Bad  \n",
       "92388  Neutral  \n",
       "92389  Neutral  \n",
       "92390  Neutral  \n",
       "92391      Bad  \n",
       "92392      Bad  \n",
       "92393      Bad  \n",
       "92394  Neutral  \n",
       "92395  Neutral  \n",
       "92396  Neutral  \n",
       "92397  Neutral  \n",
       "92398      Bad  \n",
       "92399  Neutral  \n",
       "92400  Neutral  \n",
       "92401  Neutral  \n",
       "92402  Neutral  \n",
       "92403  Neutral  \n",
       "92404  Neutral  \n",
       "92405      Bad  \n",
       "\n",
       "[92406 rows x 8 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "analyse_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "%matplotlib inline"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x22b60ad77b8>"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAW4AAAD7CAYAAABKfn7LAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3Xt8FPW9//HXZ2dDEiCsIgiIyCIQMMmKiJdaPa1tvbRS2lqPrVe2tVZsrdbiLdUeu6e2NXj59bS1p9Vq26i1thYvB6P10nq3WlGEAUSUGgUNEiABQiAk2e/vj5nogiHZhN18d3Y/z8djH+x19r1A3pn9zsx3xBiDUkqp4AjZDqCUUqpvtLiVUipgtLiVUipgtLiVUipgtLiVUipgtLiVUipgtLhV3hCRA0SkRUQc21n6SkROFpHVfv7ptvOo3KbFneNEpF5Etvk/0O+LyO9FZKjtXKn8jMfZfl9jzDvGmKHGmE4LWYyITNqDRdwAfMfPvygLy+8zEfmDiPx4IN9TpUeLOxhmGWOGAocChwM/6OsCRCSc8VQqk8YDy2yHUMGgxR0gxph3gYeBKgARiYjIbSLSICLvisiPu4YJRORrIvKciPxMRDYCCf/+b4rIayKyRUSWi8ih/v37ich8EWkUkbdE5KKu9xWRhIj8RURu91+3TEQO8x+7AzgAWOB/K7h819wiMkJEHhSRZhHZKCLPiEgo0+8rIlF/zTTsP+dJ/+/kef85C0RkHxH5o4hsFpGXRCSa8n5TReQxP+PrIvKVlMf+ICK/EpE6P8uLIjLRf+xp/2mL/ff5ajd/ByER+YGIvC0i6/zPFBGRYhFpARz/9au6ee1Hli8iT4nIKf7jx/if+yT/9nEi8mrK68/x/82bROQRERnf22cWkfOAM4HLu/7u/Puv8P+vbfGf/5ld86oBYIzRSw5fgHrgOP/6OLy1smv82/cDNwNDgH2BfwFz/Me+BnQAFwJhoBQ4FXgXb61dgEl4a3oh4GXgamAQcCDwb+BEf1kJYDtwEl7BXAu80F3G3XyGa4HfAEX+5T/898/o+wJRwABh//aTwJvARCACLAdWAsf5fye3A7/3nzsEWA183X/sUGA9UOk//gdgI3CE//gfgbtT3tsAk3r4OzjHz3IgMBS4F7ijD6/f6XHgR8Av/etXAquAeSmP/dy//iX/fQ/yc/8AeL4Pn/nHKe85xX/+fil/3xNt/4wU4sV6AL308g/klVML0Ay8DfwvXgmPAtqA0pTnng484V//GvDOLst6BPhuN+9xZDfP/X5KqSWAx1MeqwC27ZKxp+L+EfDArsWU6fel++K+KuXxG4GHU27PAl71r38VeGaXLDcDP/Sv/wG4NeWxk4AVKbd7K96/A99OuT0FaE/J2tfi/gywxL/+N+Bc/F9qwFPAl/3rDwPfSHldCGjF+4WdzmdOLe5JwDq8X3xFtn82Cvmi457B8CVjzOOpd4hIDG/ttUFEuu4O4a0RdUm9Dt4a+0e+iuP9EO8nIs0p9znAMym316ZcbwVKRCRsjOlII//1eCX8qJ/1FmNMzQC8L8D7Kde3dXO7a0PveODIXbKEgTt6yNKXjcT74f3i7fK2v/xReN+C+uqfQLmIjAIOAb4A/LeIjMD7VtA1vDIe+LmI3JjyWgHGkt5n/oAx5k0RuRjv37JSRB4B5hpj3utHfrUHtLiDazXeGveIHkps16kfV+MNG3S3rLeMMZP7maXHKSaNMVuAS4BLRKQSeEJEXsr2+/bRauApY8zxGVxmqvfwirLLAXhDWe93//SeGWNaReRl4LvAUmPMDhF5HpgLrDLGrPefuhr4iTHmj7suwx/r7ukzf+Tv1xhzF3CXiAzDWzufB5zdn8+g+k83TgaUMaYBeBS4UUSG+Ru/JorIJ3t42a3ApSIyQzyT/B/efwGb/Q1PpSLiiEiViByeZpz38cZuuyUin/ffS4DNQKd/yer79tGDeGuwZ4tIkX85XEQOylCWPwHfE5EJ4u3O+VPgz3385rDr8p8CvuP/Cd7QUOpt8LYtfN//hdm1QftU/7HePvNO7ykiU0Tk0yJSjLftYRvev6MaYFrcwTYbb6PecqAJ+CswZndPNsbcA/wEuAvYgrdxc7jx9nuehfeV+y28DVS34m3QS8e1wA/E22vk0m4enww8jjdW/0/gf40xTw7A+6bN/1ZwAnAa3trxWry1yeI0F5EAav0sX+nm8d/hDUE8jfdZt+NtOE5Xd8t/Cijjw2GRXW9jjLnP/xx3i8hmYCnwOf+x3j7zbUCF/573+/fX4P07rcXbIH5lHz6DyhDxNzoopZQKCF3jVkqpgNHiVkqpgNHiVkqpgNHiVkqpgNHiVkqpgNHiVkqpgNHiVkqpgNHiVkqpgNHiVkqpgNHiVkqpgNHZAZVSGffyyy/vGw6Hb8U7W5OuIO4sCSzt6Og4d8aMGev6swAtbqVUxoXD4VtHjx590MiRI5tCoZBOiJQimUxKY2Njxdq1a2/Fm0e9z/Q3oVIqG6pGjhy5WUv7o0KhkBk5cuQm/HPH9msZGcyjlFJdQlrau+f/3fS7f7W4lVJ5yXGcGVOnTq2YMmVKRUVFxUGPPfbYkL68fu7cuftdffXVo7KVb0/oGLdSKuui1XUzMrm8+pqZL/f2nOLi4uSKFSuWA8yfP3/YlVdeuf/xxx//eiZz2KJr3EqpvLdp0yYnEol0+NdDRx11VHlFRcVB5eXlFXfeeedeXc+74oorRkej0aqPf/zj5W+88Ua6Zz8acLrGrZTKS21tbaGpU6dWtLW1yfr164seeuihlQCDBw9O1tXVvTl8+PBkQ0ND+Mgjj5x6xhlnND/33HOD77vvvuGu6y5vb2/nkEMOqZg+fXqr7c/RHS1upVReSh0qefzxx4d8/etfn7By5cplyWRSLr744v1feOGFoaFQiHXr1g1as2ZN+Iknnhh60kknNZeVlSUBTjjhhGa7n2D3tLiVUnnvuOOO29rU1BRuaGgIz58/P7Jhw4aw67qvFRcXm7Fjx8a2bdsWAhAR21HTomPcSqm8t2jRopJkMsmoUaM6Nm3a5IwYMaK9uLjYLFiwoOy9994bBPDpT3+6pa6ubq+WlhZpamoKPfbYY3v1tlxbdI1bKZWXusa4AYwx/PrXv64Ph8Oce+65Gz/3uc9NqqqqOqiysrJ1woQJ2wGOOeaY1pNPPnljVVVV5dixY9uOOOKIFrufYPfEGN1HXimVWYsXL66fNm3aets5ctnixYtHTJs2Ldqf1+pQiVJKBYwWt1JKBYwWt1JKBYxunFSBFq2uc4ARwL5AGeD4l5B/Sfd6B7AJaAaauv6sr5nZNoAfR6m0aHGrnOIX8ciUy767ud51e28gazvfRqvrtpNS5P6fzbvctx54G3gLWFNfM7MzW3mUAi1uZUG0um4QcCBQDkxO+XMyMJYsFnE/lABj/Es6OqLVdavxSrze//MN4HVgZX3NzJw8hFoFixa3yp5EZBAwFW/C+EqgqsWU7AW/OxpveCIfhYEJ/mVXxi/111MuLrCwvmbm1oGLWBhWr14d/va3vz1u0aJFQyORSEdRUZGZO3fu2tmzZ+/RoexHHHHElBtuuGH1Jz7xCWu/hLW4VWYkIoK35nwU8HHgY8BB7PJ/bKhs52OhZctfSFZWDHxI6wQ4wL8cn3J/Z7S6binwQsrl9fqamflzkEUiktFpXUls6nFa12QyyaxZsyadccYZGxYsWPAWwMqVKwfdc889OXs0ZF9ocav+SUTKgCPwivoovKIens5LLwv/Zf0pO/47i+ECxwGm+Zc5/n1N0eq6F/mwyF+sr5mZs5Me5ZoFCxaUFRUVmcsvv7yx677y8vIdV1111brW1laZPXv2+CVLlgx2HIfrrrtu9axZs7bs7v6WlhY57bTTJqxcubJk8uTJ27dv3259KE+LW6UnERmFt5Z4NF5RV9HP4Y5D5Y1pxezY3sagkgwmzDd7A5/1L+ANs7zOh0X+XH3NzKW2wuU613VLDz744G6HMubNm7cvwMqVK5cvWrSo5KSTTpq8atWqpbu7/4Ybbti3tLQ0uXLlyuUvvvhi6dFHH23926IWt+qeN/RxODATOAmYQYY2GooQOct5/PnbOk/6eCaWVyAEb3vBVOBrANHquneABcD/AU/U18xst5Yux5199tkH/Otf/xpaVFRkxowZs+PCCy9cBzB9+vTt++233w7XdUuef/75od3d/+yzzw696KKL1gEceeSR28rLy61vYNbiVh9KRPYCTsQr6s/i7W6XFXPCC4pv6zwpW4svFAcAF/iXzdHqukfwSryuvmZmk9VkKRYuXDjjsAF+z1gstu2BBx7Yu+v2HXfc8U5DQ0P4sMMOO2j06NE7untNT/M25dp0r3rkZKFLRCpJRKpJRJ4GGoG7gdlksbQBRrJp+lgaG7L5HgVmGHAqcAewLlpd92S0um5utLpuouVchEKh5EC/56xZs7a0tbXJvHnzRnbd19LSEgI45phjWu68887hAEuWLCluaGgYdPDBB29P5/6XXnqpZOXKlYMH+vPsSte4C1EiMgY4EzgbONhGBBFClxTd8/rc9m+nu3+0Sl8Y+KR/uTFaXfca8ADe2viL9TUzB7xIB1ooFGLBggWrLrjggnG/+MUvRg8fPrxj8ODBnYlEYs2ZZ57ZfPbZZ48vLy+vcByHm2++ub60tNRcfvnl67q7/9JLL1132mmnTSgvL6+orKxsjcVi1nfd1GldC0UiMgQ4Ga+sP0MO7Ee9w4Try9tuj9rOUWBWA7cBt9XXzFyTrTdJndZ14cKFM0pKSrYlk0np6Ogomjx58sqysrLWZDJJMpkMhcPhZHt7e/i1116bGovFlra0tAyur6+PVlRUrDDGsHz58op99tmncezYse9nK68NezKtq65x57NEJIRX0mcDXwaG2A20s0HSEf1EaPGSp5PTrKz1F6hxQAL4r2h13cPALcBD2TxMPxQKJauqqpYDbN68eUh9ff2EqqqqZYCsXr16/5aWlqEiQnt7+6D29vbwli1bhkYikWbHcZIAw4YN090gd6HFnY8SkcnAecAZwH6W0/TosvCfNz29Y5rtGIXIAT7vX1ZHq+t+B9yazbVwgGHDhm3t6OgIt7e3h5uamiIdHR3hysrK10KhkFm8eHEsmUzqdrc0aHHnk0TkWGAu3i58gfgBqJL6Q0ppa91GsfUNPgVsHPBD4AfZXgtvbW0tASgqKuro7Ox0wuFweygUMs3NzWXt7e2DAMrKylrq6+ujnZ2dDcYY2bx581777LNPY89LLixa3EGXiBQBpwHfA6ZbTtNnIpSd4zz83K86v3S07Sxqp7XwNSlr4av3ZKHJZDK0dOnSDw5aGT9+fL2IMHLkyI0rV66ctHTp0oNKS0tbi4uLtwOUlZW17r333huXLVtWOWjQoLYhQ4bk7LkfbdGNk0GViAzHOzz6O+T4cEhvNpiyRTPabg7cL50C0QncD1xTXzNzcbov0nNO9k7POVlIEpHJJCL/i7d3wE8JeGkDDGfLIVFp2KO1OpU1DnAKsChaXfdAtLpuoI+lUd3Q4g6KRGQCicidwArgW0DejAmLIJeF//Jv2zlUjwT4AvBStLru4Wh13VG2A/VGRGZ885vf3L/r9tVXXz1q7ty5/VrRWb9+vVNTUzOy92d+1NixY2MNDQ0ZHZbWMe5cl4jsC/wAb1hkkOU0WXNCaOFEMAZy7Nhi1Z3PAp+NVtc9Cny/vmbmK729IFYby+i0rm7c7XFaV4BBgwaZhx56aO+Ghoa1Y8aM6diT99uwYYNz22237VtdXf2RjaQdHR2EwwNbpbrGnasSkTISkf8GVgEXkselDVAknfufEFr4qu0cqk9OABZGq+v+Eq2uK7cdZleO45jZs2c3/vSnPx2162Pvvfde+MQTT5xYVVV1UFVV1UGPPvroEIC5c+fud/XVV3/w/MmTJ1e+/vrrgy655JL9V69eXTx16tSKOXPm7P/ggw+WHXnkkeWzZs2aMGXKlEqA4447bmJlZeVBkyZNqrzhhhtGZPOzaXHnmkRkEInId/EK+2pgqOVEA+aS8D3WZ11TfSZ4c6Qsi1bX/TZaXTfWdqBUl1122bp77713+IYNG3Y6UnjOnDnj5s6d+/7SpUtfu++++1adf/750Z6Wc+ONN64ZN25c24oVK5bffPPNawCWLFky5Prrr3931apVywD++Mc/1i9btuy1V199dfnNN988au3atVk7OlmHSnKFd5TjmcCPgKjdMHaUy5rpQ9i2ZSulZbazqD4LA+cCZ0Wr6+Y9cPr+OTHkNXz48OSpp566oaamZt/S0tIP5mh57rnnhr3xxhulXbdbWlqcpqamPq3IHnzwwVunTp36wUyD8+bNG1VXV7cXwNq1a4uWLVtWMnr06KzMa6LFnQsSkUrgVryzyBQsEQafF37wmZ91nPoftrOofisBfrhxW2f7lu3trWUlRdYnZPr+97///qGHHlpx2mmnfbB7ojGGhQsXvjZ06NCd9ocOh8MmmfxwDq62trbd/gIaPHjwB0988MEHy5566qmyhQsXrigrK0seccQRU7Zt25a1EQ0dKrEpESkmEfkRsIgCL+0uX3MeidjOoPZcR5Kit9Zvnbp6Y+sBnUljtWdGjRrVOWvWrKa77rrrg3HnY445ZnPXGW8Ann/++VKAaDTa9uqrrw4BePbZZwe/++67xQCRSKRz69atu/0czc3NTiQS6SwrK0suWrSoZPHixVmdF0iL25ZE5BjgVeC/gCLLaXJGRFoPLpfVb9nOoTKjqXXHyNfXbqmyneOqq65a29zc/MEIwy233LL6lVdeGVJeXl4xceLEyptuumkkwOzZs5uampqcqVOnVtx0000jx48fvx1g9OjRnTNmzGiZPHly5Zw5c/bfdfmnnHLKpo6ODikvL6+48sor95s2bVpWv2nokZMDLREZBszD270vJ8YBc83jnYc+dW77pZ+0nUP132+/MIZRBxy4031lJUVNY/cqfWdQOLRHu+blCz1yMigSkS8Ay4Dz0dLerWNDr5YLybyf7L/QbNnevvcb72+pWr+lbR/bWYIuUMUtIqNE5C4R+beIvCwi/xSRkzOw3CdFJHuH8iYiERKRu/HOQvKRr1lqZ2FJjvl86IVeD+pQwdNpjPPepm3RN9e1lG9v7yy2nSeoAlPc4p2t837gaWPMgcaYGXiz4uV2ESYi04CFwFdtRwmSi8Pz9Yzleax1R0fZG+taKja0tA23nSWIAlPcwKeBHcaY33TdYYx52xjzSxEpEZHfi4grIotE5FMAPdxfKiJ3i8gSEfkzUNr9W+6hROQc4AVgUlaWn8cOlIbpw2jZZDuH6h+D6fGs6QDGmNC7zdsmrN7YOq7QtrUlk0kB+j0cGKTirgR29/X5AgBjTAw4HagVkZIe7v8W0GqMORj4CZDReRRIREpJRH6Hd26/kowuu0CIUHJB+IG0pxFVueXt5nY6Wjf3Wt4ATa079l3VuLW8vTNp/TyoAyGZTEpjY2MEWNrfZQT2ABwR+RVwDLADWAP8EsAYs0JE3gbK/ce7u/8TwC/8+5eIyJKMBUtEJgF/BfR8XHvoTOfvI67tONN2DNUPv3yxiQuB8XutR9LbDl/2ziqqIiWhxnBIdvT+9EBLAks7OjrO7e8CglTcy/DmBQbAGHOBiIzAGz9+dzev6el/TOa/myUiJwO/B/QgkgwYKtsrKuWtN5eZCTrUFDCb25L85OkNfX1ZGO9n5xv1NTPvznyq/BGkoZJ/ACUi8q2U+7rmpH4ab54PRKQcOAB4Pc37q4A9O8t4IiIkItcC96KlnVFXhO/e3S9llZ8GA3+KVtddF62uC1I/DahAHYAjImOAnwFHAo3AVuA3eLvZ/QZvrLoDmGuMecIfz+7u/lK8NeMKvKMXJwEXGWMW9jmUd87H3wFn7dmnU93pNNJY3nb73p04Qfp2qDLjEeD0+pqZTbaD5JpAFXfOSUSG4q1lH287Sj67rP28l+7pPPZw2zmUFauAL9bXzFxmO0gu0a8i/ZWIjASeREs76y507u+0nUFZMxF4KlpdF7MdJJdocfdHIrIf8BSZ3o1QdWucrJsxnE193tKl8sY+wOPR6rqDbAfJFVrcfZWIRIFnAP1PNEBEKPpu+L5+7/Oq8sK+wD9y8RRpNmhx90UiMhlvj5QDe3uqyqxTnSfH2M6grBuNV94TbQexTYs7XYnIGOAxYJztKIVosOwony5vvG47h7JuLPBEtLpugu0gNmlxpyMRKQMeBsbbjlLIrii6e63tDConjMNb8z7AdhBbtLh74+2nPR89hN26I2RFrIiOfD8cWqUnilfeOXVW+YGixd27W9Fd/nJCSMzw05wndJ5u1WUiXnkX3PYPLe6eJCI/AWbbjqE+9K3wA/p/VqUqBx6OVtdlZ2rmHKU/BLuTiJwPXGk7htrZGDbOGMXGdbZzqJwyDbjFdoiBpMXdnUTkJOAm2zHUR4ngfC88/zXbOVTOOStaXfcd2yEGis5VsivvqMgleEdrqRy03RStmtpWW/D78qqPaAc+VV8z8znbQbJN17hTJSIC1KKlndNKpH3ix0LLdNIhtasi4J5odd0o20GyTYt7Z98DjrMdQvXu8vCfde4S1Z0xwO3R6rq0TrsTVFrcXbyzsf/UdgyVnuny5rRidmy3nUPlpBOAS22HyCYtbvBO7gt3AcW2o6j0iBA5y3lc9+lWu3NNtLpuqu0Q2aLF7bke72w4KkDmhBfoL1q1O8XAb/N1yESLOxH5LHCB7Riq70ayafpYGhts51A56xjgW70+K4AKu7i9eUh+YTuG6h8RQpcU3aMzBqqe1ESr6/JuRs/CLm6YA0y2HUL13+dDL0RtZ1A5rQz4ue0QmVa4xZ2IDAOuth1D7ZlB0hE9NvTqEts5VE47OVpdd7TtEJlUuMUNVwAjbYdQe+7S8F82286gct51tgNkUmEWdyIyFu9gG5UHKqV+WiltrbZzqJz28Wh13cm2Q2RKYRY3XAMU1DSQ+UyEsnOch3WfbtWba6PVdWHbITKh8Io7EYkBcdsxVGZ9I/zwUNsZVM6bAnzFdohMKLzihmoK83Pntb3ZMi0qDatt51A5b67tAJlQWAWWiOwDnGI7hso8EeSy8F9W2c6hct6MaHXdJ22H2FOFVdzeEIkeJp2nTggtnAQ6wbzq1SW2A+ypQivub9oOoLKnSDr3PzG0cLHtHCrnfT5aXRfoA+8Kp7gTkU8AeTtbmPLMDd+z1XYGlfOEgJ8EvHCKG86zHUBlX7msmT6UVj0gR/XmDNsB9kRhFHciMhzdKFkQRBg8J/ygDpeo3hwYra47ynaI/iqM4obTgRLbIdTAmO08upftDCoQzrQdoL8KpbhPtB1ADZyItMbKZfVbtnOonHdqUE+0kP/FnYg4wCdsx1AD6/Lw3W/bzqBy3r7AIbZD9Ef+FzccCkRsh1AD61OhxVOEZNJ2DpXzPmM7QH8UQnF/ynYANfAcSY75fOgFnXhK9eY42wH6Q4tb5a3vhefvsJ1B5bz/iFbXDbIdoq/yu7i9c0oeYzuGsmOCNMyI0NJsO4fKaYOBGbZD9FVaxS0if0/nvhx0OKDTfRYoEYovCD+gpzVTvTnYdoC+6rG4RaRERIYDI0RkbxEZ7l+iwH4DEXAPHWE7gLLrDOfvI2xnUDkvZjtAX/V2Nog5wMV4Jf0y3jH+AJuBX2UxV6aMtx1A2TVUtldUyltvLjMTJtnOonJW4Iq7xzVuY8zPjTETgEuNMQcaYyb4l2nGmJsGKOOeGGc7gLKvOnz3u7YzqJwWuOIWk+b0xSLycSBKylq6Meb27MTKkETkX3jj3KqAdRppLG+7fe9OnLw436DKipH1NTPX2w6RrnQ3Tt4B3IC3h8bh/uWwLObKFF3jVjhiRn7ZeUb36VY9GWU7QF+kuwZyGFBh0l09zwWJyCAC9o+hsudC577kPZ3H2o6hcte+wDLbIdKV7n7cS4HR2QySBfvz4cZUVeDGSeOM4WzaYDuHyln72g7QF+kW9whguYg8IiL/13XJZrAM0GES9QERir4bvm+p7RwqZwXq23m6QyWJbIbIEj3wRu3kVOfJ0T/s+JrtGCo3BWoiurSK2xjzVLaDZIHOU6F2Mlh2TDlUVq54xZTruUfVrhzbAfoireIWkS1A14bJQUARsNUYMyxbwTJAi7uAJSG5ORTatNEJbVnvOC3rHae10XF2DHXubSrurFpnO5/KLaZz8GaYaTtG2tJd4y5LvS0iXyL3DyfX4s4D20S2NYdCzRu6yjcc2t7ohNvXOU7nBidkNjqOs8kJhVskNGhbSAbvEBnS4X3tHYbI3sDeOy+xmUE8a+OjqNz2D9sB+qJfByQYY+4XkepMh8kwLe4ckYTkplBoU5MT2rzecbY2Os62Rsdpaww7HY2OYzY6Dk2hUHizEypqFSnZLqEhHUJZEiKIlAKltj+DyntttgP0RbpDJV9OuRnC26871/fp1uLOsG0irU2h0OYNjrNlQ9jZus5x2hodZ0ej4yTXh0M0hRzZ5ISKWkKh4m0ipTtEhvprv2Xdr/0qlTMC1RfprnHPSrneAdQDX8x4mswK1D/EQOmEzl3GfretCzs7Gh2nY73jJDc4jjSHQs5mJzSoVaR0u4QGp6z9Dsabvzho+/Qr1Zv8W+M2xnw920GyIFD/EH3VKtLa7IQ2bQg5LevDTqs//NCxLuyP/Yb8sV9v7Xdw+4djv2V4U/UOt/0ZlMohq20H6It0h0r2B34JHI03RPIs8F1jzJosZttT7+NlzdmjJzuh8yNjv2GnrdFxOj8Y+3VC4S2h0KCtEipuExnSIQzbZe1XKbXnVtoO0BdpzQ4oIo8BdwF3+HedBZxpjDk+i9n2XCKyBhib7bdpFdna5Hhjv/5uZ97Yb9hJrvc2vHWN/ZZsEynZIVLWCcPw1n5z9heLUgWiEyh142677SDpSneMe6Qx5vcpt/8gIhdnI1CGvUmaxe2v/TZvdJwt653Q1m7GfkPNTii0JRQq3iqhkjaRwSlrv0OAIcCYrH4apVQ21AeptCH94l4vImcBf/Jvnw7k/IQ9/ywpefGdonDxOsfpaAw7nRscx2z0NryF/bXf0h0iQ1PWfvcB9rGdWyk1oN6wHaBIKuTEAAAKGUlEQVSv0i3uc4CbgJ/hjRs/D+T8Bsvzxuz7HvAx2zmUUjktUOPbkH5xXwPEjTFNAP4JhG/AK/Rc9qrtAEqpnBe44k53WteDu0obwBizEZienUgZpcWtlOpN3hZ3SLwj34AP1rhz/vx9btzdBLxlO4dSKmd1AC/ZDtFX6ZbvjcDzIvJXvDHurwA/yVqqzHoc+KbtEEqpnPScG3ebbYfoq7TWuP2zuZ+Cd1BLI/BlY8wdPb8qZ9xvO4BSKmc9aDtAf6Q93GGMWQ4sz2KWbPk7sAUo6+2JSqmCE8jiTneMO7DcuNsGPGw7h1Iq57zpxt0VtkP0R94Xt+8+2wGUUjmnznaA/iqU4n4IneZVKbWzQA6TQIEUtxt3NwNP2M6hlMoZW4AgngQdKJDi9ulwiVKqy5+DNrFUqkIq7j/j/ZZVShU2g3dsSmAVTHH7O9nfbDuHUsq6h4K6N0mXgilu3/8jz09pppTq1Q22A+ypgipuN+42ALfbzqGUsuZlN+4+aTvEniqo4vZdByRth1BKWRHose0uBVfcbtx9E5hvO4dSasC9A9xjO0QmFFxx+661HUApNeB+7sbdDtshMqEgi9uNu4uAR2znUEoNmLeAX9sOkSkFWdy+S4HA7oCvlOqTC924u812iEwp2OJ24+5SvA2VSqn8dp8bdwM7oVR3Cra4fdcQwPPNKaXS1gJcZDtEphV0cftzdc+xnUMplTUJN+6usR0i0wq6uAH8nfF/ZzuHUirjXODntkNkQ8EXt+9SYJ3tEEqpjDHA+fmy+9+utLgBN+42ARfbzqGUyphb3Lj7vO0Q2aLF7XPj7p/QM8IrlQ9eIc9XxLS4dxYHAj3do1IFbj3wZTfubrcdJJu0uFP4pzj7ItBsO4tSqs86gdPduPu27SDZpsW9CzfurgROR2cQVCpornLj7uO2QwwELe5uuHH3b8D3bedQSqXtr27cnWc7xEDR4t4NN+5eB9xlO4dSqlfLga/bDjGQtLh7di7wsu0QSqnd2gyc7MbdFttBBpIWdw/82cROBtbazqKU+ogW4CR/u1RB0eLuhRt3VwOfQstbqVzSCsx04+5ztoPYoMWdBjfurgCOBRosR1FKwTZglht3n7YdxBYt7jS5cfd1vPJ+z3IUpQrZduCLbtz9h+0gNmlx94E/lnYs8K7lKEoVoja8oyIfsx3ENi3uPnLj7ht45Z13c/wqlcN2AP/pxt2HbQfJBVrc/eDG3TfR8lZqoLQDX3Xj7oO2g+QKLe5+cuPuKrzyfstyFKXy2XrgODfu6sydKbS494Bf3ocDBb2hRKksWQYcUch7j+yOFvcecuPuBuBE4Je2syiVR+qAo9y4q99ouyHGGNsZ8kasNnYO8GtgkO0sSgXYDcAVbtzVGTp3Q4s7w2K1saOAe4HRtrMoFTA7gDlu3P2D7SC5Tos7C2K1sbHAfXjj30qp3jXiTRZVkIew95WOcWeBG3ffBT4B3GE7i1IB8AJwuJZ2+nSNO8titbGvAf8DRCxHUSrXdALXAD92426n7TBBosU9AGK1sf2B3wKftZ1FqRyxCjjLjbsv2A4SRFrcAyhWGzsXuBEYZjuLUhbdCnyv0E5+kEla3AMsVhsbB9wGHG87i1ID7B3gm27cfdR2kKDT4rYkVhs7D29/1TLbWZQaALcAl7pxd4vtIPlAi9uiWG1sPN7a92dsZ1EqS5YDF7lx9++2g+QTLe4cEKuNnQHUAONsZ1EqQ9YDVwO36B4jmafFnSNitbHBwGXA5cBgy3GU6q8dwC/wdvHbZDtMvtLizjH+roM1wBmAWI6jVF/MBy534+6/bQfJd1rcOSpWG5sOXIs386BSuexlvN37nrEdpFBocee4WG3sU8A8dN4TlXvWAFcBd7hxV4tkAGlxB0SsNnYKUA0cZjuLKngrgOuBO924u8N2mEKkxR0wsdrYscClwEnoGLgaWC/gfft7QNew7dLiDqhYbawCuAQ4Eyi2HEflt4eAeXoKsdyhxR1wsdrYaOAi4Hxgb8txVP7oAO4GrnPjrms7jNqZFneeiNXGhgLfAC4GonbTqABrAm4HfubG3bdth1Hd0+LOM7HamAPMBOLA59HzX6redQKPAb/HG79us5xH9UKLO4/FamPDga8Cs4GPWY6jcs/rwB/wdud713IW1Qda3AUiVhsrxyvws4DxluMoezYDfwZ+78bdf9oOo/pHi7vAxGpjAnwSr8T/E51WthB0AE8AtcC9btzdZjmP2kNa3AXMn9jqc3hj4p8DRttNpDJoI/AwsAD4m074lF+0uBXwwZr4oXgH9szEO8Q+ZDWU6qvXgAfxyvp5nU41f2lxq27FamMj8E5uPBNvoivdRzz3tAPP4BX1AjfurrKcRw0QLW7VK38Xw6PwhlP+A5iBzhluw3ZgIfA88BzwlA6BFCYtbtVnsdpYGDgYr8w/5l8mWQ2Vn97HK+iuon5FJ3VSoMWtMsQfWukq8aPwxsh1j5X0deKdn/GDotYTEqjd0eJWWRGrjYWACqASmAJM9f8sB4ZajGZbG7ASb0Picv/P14CVesSiSpcWtxpw/unZprBzoU8BDiB/pqptBt5g53J+Dfi37u2h9pQWt8oZsdpYKd6Z7kelcbGxcTSJd/byhh4ua4EGPchFZZMWtwqkWG2sDK/ARwKleHOSFwMlKdd3vXQ95uDtSteGd1byrksb0Aq0AFv9S9f1jcA6N+52DMgHVKoHWtxKKRUwemScUkoFjBa3UkoFjBa3UrsQESMiN6bcvlREEv1c1l4i8u1+vrZeREb057Uqv2lxK/VRbcCXM1SaewHdFreIOBlYvipAWtxKfVQHcAvwvV0fEJGRIjJfRF7yL0f79ydE5NKU5y0VkShQA0wUkVdF5HoROVZEnhCRuwDXf+79IvKyiCwTkfMG4POpgAvbDqBUjvoVsERErtvl/p8DPzPGPCsiBwCPAAf1sJxqoMoYcwiAiBwLHOHf95b/nHOMMRtFpBR4SUTmG2M2ZPLDqPyixa1UN4wxm0XkduAiIPVgmuOACpEPDvAcJiJ9nZPlXymlDXCRiJzsXx8HTAa0uNVuaXErtXv/A7yCd/bzLiHgKGPMTkdGikgHOw89lvSw3K0przsW75fBUcaYVhF5spfXKqVj3ErtjjFmI/AX4Bspdz8KfKfrhogc4l+txzuDECJyKDDBv38LPc+SGAGa/NKeije7olI90uJWqmc3Aql7l1wEHCYiS0RkOXC+f/98YLiIvAp8C28GQPyx6uf8jZXXd7P8vwFhEVkCXAO8kKXPofKIHvKulFIBo2vcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMFrcSikVMP8fPkHQc5XPWXgAAAAASUVORK5CYII=\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {},
     "output_type": "display_data"
    }
   ],
   "source": [
    "figure = analyse_df[['id', 'mood']].groupby(['mood']).agg(['count']).rename(columns={'id': 'amount'})\n",
    "figure.plot.pie(\"amount\", title=\"Percent sentiment of tweets\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<matplotlib.axes._subplots.AxesSubplot at 0x22b60543320>"
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAYcAAAEWCAYAAACNJFuYAAAABHNCSVQICAgIfAhkiAAAAAlwSFlzAAALEgAACxIB0t1+/AAAADl0RVh0U29mdHdhcmUAbWF0cGxvdGxpYiB2ZXJzaW9uIDIuMi4zLCBodHRwOi8vbWF0cGxvdGxpYi5vcmcvIxREBQAAIABJREFUeJzt3Xuc1XW97/HX2wHEa1x1I4MOGae8PBR1QlJPqRiCdcS9H1h4CkYzabf1qPu0K6x9tmVy0t1OPbTLokShYyGZJsdwEyl0cSsCiiiiMSrKBAk6XujiBfucP37f0Z/zW8OsWXNZwLyfj8d6zG99ft/b77fWrM/6Xdbvp4jAzMwsb49qD8DMzHY+Tg5mZlbg5GBmZgVODmZmVuDkYGZmBU4OZmZW4ORguy1lbpT0oqQHqj2eXZ2kgyX9UVJNtcdi3c/JoReTtCx9cO5Z7bGUIulcSb/tRBMnAR8GaiNiTBcNq8dJ2iDptGr3GxHPRsS+EfFmFcYSkt7T0/32Zk4OvZSkOuC/AgGcWdXBdJ9DgA0R8afu7khSn+7uw6xHRYQfvfAB/AtwL3ANcGereTcB3wHuAv6Yyv0NcB3wIvA4cEyu/GHAMuAlYC1wZm7eMuDTuefnAr/NPQ/g74H1qe1vA0ptvgq8mcbwUhvLcRCwEGgGGoELUvz8VvW/WqLuuWnZvgW8nJZrXG7+u4AbgM3A74ErgZpWda9NfV+Z4hcA64BtwGPAsblx/hTYCjwNXJzr5yvAAmBeqrcWqE/zfgj8FfhLWo4vlFiOIcCdaf03A78B9ujqfoG69Hr1yb22VwL/mcr8P2AwcDPwCrACqMv19z5gSRrjE8DHWr3nvg38PI1lOXBomvfr1O+fUj8fr/b/T294VH0AflTphc8+SP8BOA54AzgwN+8m4Pk0rz9wT/pgmQbUpA+Epals39TWl4B+wKnpn/u9af4y2k8OdwIDgIPTh9iEUmXbWI5fkSWy/sDoVH9cOfXT/O3AP6bl+DhZkhiU5v8M+B6wD3AA8ADwmVZ1/wfQB9gLOJssibyfLMG9h2zrZQ9gFVlC7ge8G3gKOD219RWyRHZGWr9fB+7PjXMDcNoOluPrwHfTMvQl2yJUV/dL6eTQCBxKlkgfA34HnJbWyTzgxlR2H2AjcF6adyzZe+yI3HuuGRiT5t8MzG/1PnlPtf9vetPDu5V6IUknkX1oLYiIVcCTwH9vVez2iFgVEa8CtwOvRsS8yPY33wIck8qNBfYFroqI1yPiHrIP+3M6MKSrIuKliHgWWEr2IV/OcowgO67wxYh4NSJWAz8Apnag7y3AdRHxRkTcQvaN9iOSDgQmApdGxJ8iYgvZVsKUXN1NEfGtiNgeEX8BPg38a0SsiExjRDxDliyGRsQVaR09BXy/VVu/jYhFaf3+EDi6A8vwBjAMOCQtx28i+0Tt7n4h+/B/MiJeJtvSfDIifhkR24Gf8Pb75KNku/huTOvrQbItmsm5tm6LiAdS3Zsp831g3cP7SXunBuAXEfF8ev6jFLs2V+a53PRfSjzfN00fBGyMiL/m5j8DDO/AeP6Qm/5zru32HAQ0R8S2Vn3Xd6Dv36cP0nz9g8iSZ19gs6SWeXuQffttkZ8GGEGWaFs7BDhI0ku5WA3Z7p8WrddBf0l90gdle75BthXwizTW2RFxVQ/0C+W/Tw4Bjm81lj5kCamtsZT7PrBu4OTQy0jaC/gYUCOp5Z9xT2CApKMj4uEONrkJGCFpj1yCOJhs9wJk+4n3zpX/mw603d4lgzcBgyTtl0sQB5Pt2inXcEnKJYiDyY5hbAReA4bs4IOy9fg2ku1iaW0j8HREjOrAuHbUzztnZsv+OeBzko4Alkpa0d39dtBG4FcR8eEubNO6kXcr9T5nkR2kPZxss3002cHf35AdU+io5WQJ4AuS+ko6GfhvwPw0fzXwd5L2Tqcint+Btp8DaiX1KzUzIjaSHQz9uqT+ko5K7d/cgT4OAC5OYz+bbF0siojNwC+Ab0raX9Iekg6V9KEdtPUD4J8kHZd+Y/EeSYeQHat4RdIXJe0lqUbSkZLeX+YYnyM7XlCSpI+mvkR2IPjN9OjWfjvoTuC/SJqa1nVfSe+XdFgVxmJlcHLofRrI9hM/GxF/aHkA/w58oqOnZEbE62Snwk4kO8D4HWBaRDyeilwLvE72zz2Xjn1w30N2Bs0fJD3fRplzyA6UbiI7NnJ5RCzpQB/LgVFp7DOByRHxQpo3jexA7mNkZ1LdSrZvv6SI+Elq40dkB+V/RnZw+02yhDma7MD+82SJ5F1ljvHrwD9LeknSP5WYPwr4JdmZPPcB34mIZT3Qb9nS1s14suMdm8h2IV1NttVajq8Ac9NYPtaZsVh59M7drWa9h6Rzyc6kOqnaYzHb2XjLwczMCpwczMyswLuVzMyswFsOZmZWsMv+zmHIkCFRV1dX7WGYme1SVq1a9XxEDG2v3C6bHOrq6li5cmW1h2FmtkuR9Ew55bxbyczMCpwczMyswMnBzMwKdtljDmZmO/LGG2/Q1NTEq6++Wu2hVEX//v2pra2lb9++FdVvNzlI6k92J6Y9U/lbI+JySTcBHyK7OQrAuRGxOl386/+Q3UDkzyn+YGqrAfjnVP7KiJib4seR3exjL2ARcEn4Bxhm1glNTU3st99+1NXVkbvseq8QEbzwwgs0NTUxcuTIitooZ7fSa8CpEXE02QW8Jkgam+Z9PiJGp8fqFJtIdiGwUcB04HoASYOAy4Hjye72dLmkganO9alsS70JFS2NmVny6quvMnjw4F6XGAAkMXjw4E5tNbWbHNIdrf6YnrbchnBH3+onAfNSvfvJ7hMwDDgdWBIRzRHxItm9ZCekeftHxH1pa2Ee2WWlzcw6pTcmhhadXfayDkin68CvJrul4pKIWJ5mzZS0RtK1klouvTucd94hqynFdhRvKhEvNY7pklZKWrl169Zyhm5mZhUo64B0ui78aEkDgNslHQlcRnZN9n7AbOCLwBVkNzYvNFFBvNQ4Zqe+qK+v9zEJMytb3Yyfd2l7G676SJe2V4nrrruO6dOns/fee7dfuIM6emOXlyQtAyZExL+l8GuSbgRabgbSRHYv3Ra1ZDf3aAJObhVfluK1Jcqb7ZQ6+yGzM3yo2O7huuuu45Of/GS3JId2dytJGpq2GFruP3wa8Hg6VkA6O+ks4NFUZSEwLd0mcSzwcrrl4mJgvKSB6UD0eGBxmrdN0tjU1jTgjq5dTDOz6pg3bx5HHXUURx99NFOnTuWZZ55h3LhxHHXUUYwbN45nn30WgHPPPZdbb731rXr77rsvAMuWLePkk09m8uTJvO997+MTn/gEEcGsWbPYtGkTp5xyCqecckqXj7ucLYdhZLfnqyFLJgsi4k5J90gaSrZbaDXw96n8IrLTWBvJTmU9DyAimiV9DViRyl0REc1p+rO8fSrrXelhZrZLW7t2LTNnzuTee+9lyJAhNDc309DQwLRp02hoaGDOnDlcfPHF/OxnP9thOw899BBr167loIMO4sQTT+Tee+/l4osv5pprrmHp0qUMGTKky8febnKIiDXAMSXip7ZRPoAL25g3B5hTIr4SOLK9sZiZ7UruueceJk+e/NaH96BBg7jvvvu47bbbAJg6dSpf+MIX2m1nzJgx1NZme99Hjx7Nhg0bOOmk7r27rS+fYWbWTSKi3VNKW+b36dOHv/71r2/Ve/31198qs+eee741XVNTw/bt27thtO/k5GBm1k3GjRvHggULeOGFFwBobm7mhBNOYP78+QDcfPPNb20B1NXVsWrVKgDuuOMO3njjjXbb32+//di2bVu3jN3XVjKzXqEaZ4kdccQRfPnLX+ZDH/oQNTU1HHPMMcyaNYtPfepTfOMb32Do0KHceOONAFxwwQVMmjSJMWPGMG7cOPbZZ592258+fToTJ05k2LBhLF26tEvHvsveQ7q+vj58sx+rBp/KumtYt24dhx12WLWHUVWl1oGkVRFR315d71YyM7MCJwczMytwcjCz3dauutu8K3R22Z0czGy31L9/f1544YVemSBa7ufQv3//itvw2Upmtluqra2lqamJ3noF55Y7wVXKycHMdkt9+/at+C5o5t1KZmZWgpODmZkVODmYmVmBk4OZmRU4OZiZWYGTg5mZFTg5mJlZgZODmZkVODmYmVmBk4OZmRW0mxwk9Zf0gKSHJa2V9NUUHylpuaT1km6R1C/F90zPG9P8ulxbl6X4E5JOz8UnpFijpBldv5hmZtYR5Ww5vAacGhFHA6OBCZLGAlcD10bEKOBF4PxU/nzgxYh4D3BtKoekw4EpwBHABOA7kmok1QDfBiYChwPnpLJmZlYl7SaHyPwxPe2bHgGcCtya4nOBs9L0pPScNH+cJKX4/Ih4LSKeBhqBMenRGBFPRcTrwPxU1szMqqSsYw7pG/5qYAuwBHgSeCkitqciTcDwND0c2AiQ5r8MDM7HW9VpK25mZlVSVnKIiDcjYjRQS/ZNv9Rdu1vuqKE25nU0XiBpuqSVklb21mu0m5n1hA6drRQRLwHLgLHAAEkt94OoBTal6SZgBECa/y6gOR9vVaeteKn+Z0dEfUTUDx06tCNDNzOzDijnbKWhkgak6b2A04B1wFJgcirWANyRphem56T590R2n76FwJR0NtNIYBTwALACGJXOfupHdtB6YVcsnJmZVaacO8ENA+ams4r2ABZExJ2SHgPmS7oSeAi4IZW/AfihpEayLYYpABGxVtIC4DFgO3BhRLwJIOkiYDFQA8yJiLVdtoRmZtZh7SaHiFgDHFMi/hTZ8YfW8VeBs9toayYws0R8EbCojPGamVkP8C+kzcyswMnBzMwKnBzMzKzAycHMzAqcHMzMrMDJwczMCpwczMyswMnBzMwKnBzMzKzAycHMzAqcHMzMrMDJwczMCpwczMyswMnBzMwKnBzMzKzAycHMzAqcHMzMrMDJwczMCpwczMyswMnBzMwKnBzMzKyg3eQgaYSkpZLWSVor6ZIU/4qk30tanR5n5OpcJqlR0hOSTs/FJ6RYo6QZufhIScslrZd0i6R+Xb2gZmZWvnK2HLYDn4uIw4CxwIWSDk/zro2I0emxCCDNmwIcAUwAviOpRlIN8G1gInA4cE6unatTW6OAF4Hzu2j5zMysAu0mh4jYHBEPpultwDpg+A6qTALmR8RrEfE00AiMSY/GiHgqIl4H5gOTJAk4Fbg11Z8LnFXpApmZWed16JiDpDrgGGB5Cl0kaY2kOZIGpthwYGOuWlOKtRUfDLwUEdtbxUv1P13SSkkrt27d2pGhm5lZB5SdHCTtC/wUuDQiXgGuBw4FRgObgW+2FC1RPSqIF4MRsyOiPiLqhw4dWu7Qzcysg/qUU0hSX7LEcHNE3AYQEc/l5n8fuDM9bQJG5KrXApvSdKn488AASX3S1kO+vJmZVUE5ZysJuAFYFxHX5OLDcsX+Fng0TS8EpkjaU9JIYBTwALACGJXOTOpHdtB6YUQEsBSYnOo3AHd0brHMzKwzytlyOBGYCjwiaXWKfYnsbKPRZLuANgCfAYiItZIWAI+Rnel0YUS8CSDpImAxUAPMiYi1qb0vAvMlXQk8RJaMzMysStpNDhHxW0ofF1i0gzozgZkl4otK1YuIp8jOZjIzs52AfyFtZmYFTg5mZlbg5GBmZgVODmZmVuDkYGZmBU4OZmZW4ORgZmYFTg5mZlbg5GBmZgVODmZmVuDkYGZmBU4OZmZW4ORgZmYFTg5mZlbg5GBmZgVODmZmVuDkYGZmBU4OZmZW4ORgZmYFTg5mZlbg5GBmZgXtJgdJIyQtlbRO0lpJl6T4IElLJK1PfwemuCTNktQoaY2kY3NtNaTy6yU15OLHSXok1ZklSd2xsGZmVp5ythy2A5+LiMOAscCFkg4HZgB3R8Qo4O70HGAiMCo9pgPXQ5ZMgMuB44ExwOUtCSWVmZ6rN6Hzi2ZmZpVqNzlExOaIeDBNbwPWAcOBScDcVGwucFaangTMi8z9wABJw4DTgSUR0RwRLwJLgAlp3v4RcV9EBDAv15aZmVVBh445SKoDjgGWAwdGxGbIEghwQCo2HNiYq9aUYjuKN5WIl+p/uqSVklZu3bq1I0M3M7MOKDs5SNoX+ClwaUS8sqOiJWJRQbwYjJgdEfURUT906ND2hmxmZhUqKzlI6kuWGG6OiNtS+Lm0S4j0d0uKNwEjctVrgU3txGtLxM3MrErKOVtJwA3Auoi4JjdrIdByxlEDcEcuPi2dtTQWeDntdloMjJc0MB2IHg8sTvO2SRqb+pqWa8vMzKqgTxllTgSmAo9IWp1iXwKuAhZIOh94Fjg7zVsEnAE0An8GzgOIiGZJXwNWpHJXRERzmv4scBOwF3BXepiZWZW0mxwi4reUPi4AMK5E+QAubKOtOcCcEvGVwJHtjcXMzHqGfyFtZmYFTg5mZlbg5GBmZgVODmZmVuDkYGZmBU4OZmZW4ORgZmYFTg5mZlbg5GBmZgVODmZmVuDkYGZmBU4OZmZW4ORgZmYFTg5mZlbg5GBmZgVODmZmVuDkYGZmBU4OZmZW4ORgZmYFTg5mZlbg5GBmZgXtJgdJcyRtkfRoLvYVSb+XtDo9zsjNu0xSo6QnJJ2ei09IsUZJM3LxkZKWS1ov6RZJ/bpyAc3MrOPK2XK4CZhQIn5tRIxOj0UAkg4HpgBHpDrfkVQjqQb4NjAROBw4J5UFuDq1NQp4ETi/MwtkZmad125yiIhfA81ltjcJmB8Rr0XE00AjMCY9GiPiqYh4HZgPTJIk4FTg1lR/LnBWB5fBzMy6WGeOOVwkaU3a7TQwxYYDG3NlmlKsrfhg4KWI2N4qXpKk6ZJWSlq5devWTgzdzMx2pNLkcD1wKDAa2Ax8M8VVomxUEC8pImZHRH1E1A8dOrRjIzYzs7L1qaRSRDzXMi3p+8Cd6WkTMCJXtBbYlKZLxZ8HBkjqk7Ye8uXNzKxKKtpykDQs9/RvgZYzmRYCUyTtKWkkMAp4AFgBjEpnJvUjO2i9MCICWApMTvUbgDsqGZOZmXWddrccJP0YOBkYIqkJuBw4WdJosl1AG4DPAETEWkkLgMeA7cCFEfFmauciYDFQA8yJiLWpiy8C8yVdCTwE3NBlS2dmZhVpNzlExDklwm1+gEfETGBmifgiYFGJ+FNkZzOZmdlOwr+QNjOzAicHMzMrcHIwM7MCJwczMytwcjAzswInBzMzK3ByMDOzAicHMzMrcHIwM7MCJwczMytwcjAzswInBzMzK6jofg5meXUzfl5x3Q1XfaQLR2JmXcVbDmZmVuDkYGZmBU4OZmZW4ORgZmYFTg5mZlbg5GBmZgVODmZmVuDkYGZmBe0mB0lzJG2R9GguNkjSEknr09+BKS5JsyQ1Sloj6dhcnYZUfr2khlz8OEmPpDqzJKmrF9LMzDqmnC2Hm4AJrWIzgLsjYhRwd3oOMBEYlR7TgeshSybA5cDxwBjg8paEkspMz9Vr3ZeZmfWwdpNDRPwaaG4VngTMTdNzgbNy8XmRuR8YIGkYcDqwJCKaI+JFYAkwIc3bPyLui4gA5uXaMjOzKqn0mMOBEbEZIP09IMWHAxtz5ZpSbEfxphLxkiRNl7RS0sqtW7dWOHQzM2tPV194r9TxgqggXlJEzAZmA9TX17dZzsx2H76wY3VUmhyekzQsIjanXUNbUrwJGJErVwtsSvGTW8WXpXhtifK7LL+RzWx3UOlupYVAyxlHDcAdufi0dNbSWODltNtpMTBe0sB0IHo8sDjN2yZpbDpLaVquLTMzq5J2txwk/ZjsW/8QSU1kZx1dBSyQdD7wLHB2Kr4IOANoBP4MnAcQEc2SvgasSOWuiIiWg9yfJTsjai/grvQws51IZ7aIwVvFu6J2k0NEnNPGrHElygZwYRvtzAHmlIivBI5sbxxmZtZz/AtpMzMrcHIwM7MCJwczMytwcjAzswInBzMzK3ByMDOzAicHMzMrcHIwM7MCJwczMytwcjAzswInBzMzK3ByMDOzAicHMzMrcHIwM7MCJwczMytwcjAzswInBzMzK3ByMDOzAicHMzMrcHIwM7MCJwczMyvoVHKQtEHSI5JWS1qZYoMkLZG0Pv0dmOKSNEtSo6Q1ko7NtdOQyq+X1NC5RTIzs87q0wVtnBIRz+eezwDujoirJM1Iz78ITARGpcfxwPXA8ZIGAZcD9UAAqyQtjIgXu2BsvUbdjJ9XXHfDVR/pwpGY2e6gO3YrTQLmpum5wFm5+LzI3A8MkDQMOB1YEhHNKSEsASZ0w7jMzKxMnU0OAfxC0ipJ01PswIjYDJD+HpDiw4GNubpNKdZWvEDSdEkrJa3cunVrJ4duZmZt6exupRMjYpOkA4Alkh7fQVmViMUO4sVgxGxgNkB9fX3JMmZm1nmd2nKIiE3p7xbgdmAM8FzaXUT6uyUVbwJG5KrXApt2EDczsyqpODlI2kfSfi3TwHjgUWAh0HLGUQNwR5peCExLZy2NBV5Ou50WA+MlDUxnNo1PMTMzq5LO7FY6ELhdUks7P4qI/5C0Algg6XzgWeDsVH4RcAbQCPwZOA8gIpolfQ1YkcpdERHNnRiX9RI+Q8us+1ScHCLiKeDoEvEXgHEl4gFc2EZbc4A5lY7FzMy6ln8hbWZmBV3xIzgz6yHelWY9xVsOZmZW4ORgZmYFTg5mZlbg5GBmZgU+IG1mVkJvP/jvLQczMytwcjAzswInBzMzK3ByMDOzAicHMzMrcHIwM7MCJwczMytwcjAzswInBzMzK3ByMDOzAicHMzMrcHIwM7MCJwczMytwcjAzs4KdJjlImiDpCUmNkmZUezxmZr3ZTnE/B0k1wLeBDwNNwApJCyPisUra68x12GH3uBa7mVln7BTJARgDNEbEUwCS5gOTgIqSg5nZrmxnuNGQIqJLGurUIKTJwISI+HR6PhU4PiIualVuOjA9PX0v8ESFXQ4Bnq+wbmdUq99q9u1l7h1997Z+q9l3Z/s9JCKGtldoZ9lyUIlYIWtFxGxgdqc7k1ZGRH1n29lV+q1m317m3tF3b+u3mn33VL87ywHpJmBE7nktsKlKYzEz6/V2luSwAhglaaSkfsAUYGGVx2Rm1mvtFLuVImK7pIuAxUANMCci1nZjl53eNbWL9VvNvr3MvaPv3tZvNfvukX53igPSZma2c9lZdiuZmdlOxMnBzMwKduvk0N4lOSTtKemWNH+5pLoK+5kjaYukR3OxQZKWSFqf/g5so25DKrNeUkMH+x0haamkdZLWSrqkB/vuL+kBSQ+nvr+a4iPTulyf1m2/Nupfltb7E5JO70jfqX6NpIck3dnD/W6Q9Iik1ZJWplhPrO8Bkm6V9Hh6vT/QQ/2+Ny1ry+MVSZf2UN//mN5bj0r6cXrPdfvrLOmS1OdaSZemWLcsb0c+O5SZlZZrjaRj22jzuPQebUzlS/1UoH0RsVs+yA5sPwm8G+gHPAwc3qrMPwDfTdNTgFsq7OuDwLHAo7nYvwIz0vQM4OoS9QYBT6W/A9P0wA70Oww4Nk3vB/wOOLyH+hawb5ruCywHxgILgCkp/l3gsyXqHp5ejz2Bkel1qungOv+fwI+AO9Pznup3AzCkVawn1vdc4NNpuh8woCf6LfE/9QfgkO7uGxgOPA3slXt9z+3u1xk4EngU2JvshJ1fAqO6a3npwGcHcAZwF9n/3lhgeRttPgB8IJW7C5hY0etdSaVd4ZFWzuLc88uAy1qVWQx8IE33IfvVoSrsr67VC/wEMCxNDwOeKFHnHOB7ueffA87pxDLfQXZ9qh7tO/0jPQgcn9Zhn1KvQVuvRf51KLO/WuBu4FTgzvRP0O39pjobKCaHbl3fwP5kH5TqyX5LtDUeuLeHlnk4sJHsg7ZPep1P7+7XGTgb+EHu+f8CvtCdy0uZnx2t28uXy8WGAY+3NaaOPHbn3Uotb64WTSlWskxEbAdeBgZ3Uf8HRsTm1PZm4IAKx1gWZbvEjiH7Bt8jfaddO6uBLcASsm9oL6V1uaM2O9v3dWT/sH9Nzwf3UL+Q/XL/F5JWKbucC3T/+n43sBW4Me1K+4GkfXqg39amAD9O093ad0T8Hvg34FlgM9n/5iq6/3V+FPigpMGS9ib7tj6Cnl3XbfVV7mdaUxeMYbdODuVckqOsy3Z0oy7pX9K+wE+BSyPilZ7qOyLejIjRZN/kxwCHldlmxX1L+iiwJSJWVdBeV6zvEyPiWGAicKGkD5ZZrzN99yHb9XB9RBwD/Ilsd0N39/t2I9m+/TOBn3SkWqV9p/3sk8h2Cx0E7EO2zstpr+J+I2IdcDXZl53/INs9tX2Hlbqg3y5sv8vGsDsnh3IuyfFWGUl9gHcBzV3U/3OShqW2h5F9u65kjDskqS9ZYrg5Im7ryb5bRMRLwDKy/aAD0rrcUZud6ftE4ExJG4D5ZLuWruuBfgGIiE3p7xbgdrKk2N3ruwloiojl6fmtZMmiJ1/nicCDEfFcet7dfZ8GPB0RWyPiDeA24AR64HWOiBsi4tiI+CDZ58F6enZdt9VXuZ9ptV0wht06OZRzSY6FQMsZBZOBeyLtqOsC+bYbyI4HtLYYGC9pYPqmND7FypLOQrgBWBcR1/Rw30MlDUjTe5H9M68DlpKtyx31vRCYouxssZFkB/weKKffiLgsImojoo7sNb0nIj7R3f0CSNpH0n4t02Tr7FG6eX1HxB+AjZLem0LjyC5n3+2vc845vL1LiR7o+1lgrKS90/u8ZZl74nU+IP09GPg7suXuyXXdVl8LgWnprKWxwMstu59apOfbJI1N621aG2NtXyUHKnaVB9n+wt+R7Qv/copdAZyZpvuTbSY3kr153l1hPz8m2y/6BlnmPp9sP/jdZN867gYGpbL1vPOA16dS/43AeR3s9ySyTcY1wOr0OKOH+j4KeCj1/SjwLyn+7rQuG9O63TPFzwSuyNX/cnpdnqDSsyngZN4+W6nb+019PJwea3PvqZ5Y36OBlWl9/4zsbJhu7zfV3xt4AXhXLtYTy/xV4PH0/voh2dlHPfE6/4YsET0MjOvO5aVjnx0iuynak8AjQH2undW56fq0zp4E/p0KT7Lx5TPMzKxgd96tZGZmFXJyMDOzAicHMzMrcHIwM7NHR4rZAAAB80lEQVQCJwczMytwcjDbyUg6S9Lh1R6H9W5ODmZdIPer3a5wFtmVRc2qxsnBLJFUp+x+CXPT9fJvTb/QPU7Sr9LF9hbnLm2wTNL/lvQr4BJJB0q6Xdk9Lh6WdEIq90ll975YLel7kmpS/I+SZqay96f6J5D9oOsbqfyhVVsh1qs5OZi903uB2RFxFPAKcCHwLWByRBwHzAFm5soPiIgPRcQ3gVnAryLiaLJrH62VdBjwcbIL9o0G3gQ+keruA9yfyv8auCAi/pPsMgmfj4jREfFkdy+wWSlduSlstjvYGBH3pun/C3yJ7AYwS9INtWrILnfQ4pbc9Klk17IhIt4EXpY0FTgOWJHq78XbF1J7new+BZBdjvrDXb0wZpVycjB7p9bXk9kGrI2ID7RR/k/ttCdgbkRcVmLeG/H29WvexP+PthPxbiWzdzpYUksiOAe4HxjaEpPUV9IRbdS9G/hsKlcjaf8Um5y70ucgSYe0M4ZtZLd9NasaJwezd1oHNEhaQ3aLym+RXSL6akkPk1359oQ26l4CnCLpEbLdREdExGPAP5PdPW4N2U1khrUzhvnA59Nd33xA2qrCV2U1S5TdavXOiDiyykMxqzpvOZiZWYG3HMzMrMBbDmZmVuDkYGZmBU4OZmZW4ORgZmYFTg5mZlbw/wH+n1t0fJtX6AAAAABJRU5ErkJggg==\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "\n",
    "figure2 = analyse_df[['id', 'percent']].round({\"percent\": -1}).groupby(['percent']).agg(['count']).rename(columns={'id': 'amount'})\n",
    "figure2.plot.bar( y='amount', rot=0, title=\"Amount of percent sentiment\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 38,
   "metadata": {},
   "outputs": [],
   "source": [
    "### Get Vader for this users\n",
    "def count_mood_for_clique(users):\n",
    "    users_moods = pd.DataFrame(columns=[\"user_id\", \"user_name\", \"ID\", \"MOOD\"])\n",
    "    for index, row in users.iterrows():\n",
    "        users_moods = users_moods.append(pd.read_sql_query('SELECT user.user_id, user_name, tweet.tweet_id as ID, vader.compound as MOOD \\\n",
    "    FROM user \\\n",
    "    JOIN tweet ON tweet.user_id = user.user_id \\\n",
    "    JOIN vader ON tweet.tweet_id = vader.id \\\n",
    "    WHERE user.user_id = \"' + str(row[\"user_id\"]) + '\" \\\n",
    "    UNION \\\n",
    "    SELECT user.user_id, user_name, retweet.retweet_id as ID, vader.compound as MOOD \\\n",
    "    FROM user \\\n",
    "    JOIN vader ON retweet.retweet_id = vader.id \\\n",
    "    JOIN retweet ON retweet.user_id = user.user_id \\\n",
    "    WHERE user.user_id = \"' + str(row[\"user_id\"]) + '\"', engine))\n",
    "    return users_moods"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 91,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10, 1)"
      ]
     },
     "execution_count": 91,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_sufix=\"clique/clique_\"\n",
    "i=6\n",
    "clique = pd.read_csv(data_sufix+str(i)+'.csv', \n",
    "                            usecols=['user_id'])\n",
    "clique.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "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>user_id</th>\n",
       "      <th>user_name</th>\n",
       "      <th>ID</th>\n",
       "      <th>MOOD</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>719662077934243840</td>\n",
       "      <td>RW 😡</td>\n",
       "      <td>1056999526995640320</td>\n",
       "      <td>-0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>719662077934243840</td>\n",
       "      <td>RW 😡</td>\n",
       "      <td>1057017666085433344</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>719662077934243840</td>\n",
       "      <td>RW 😡</td>\n",
       "      <td>1057019158045454336</td>\n",
       "      <td>0.5267</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>719662077934243840</td>\n",
       "      <td>RW 😡</td>\n",
       "      <td>1057019194833756160</td>\n",
       "      <td>-0.4019</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>719662077934243840</td>\n",
       "      <td>RW 😡</td>\n",
       "      <td>1057024357866688512</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>719662077934243840</td>\n",
       "      <td>RW 😡</td>\n",
       "      <td>1057029275885293568</td>\n",
       "      <td>-0.4767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>719662077934243840</td>\n",
       "      <td>RW 😡</td>\n",
       "      <td>1057102294221697024</td>\n",
       "      <td>0.2144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>719662077934243840</td>\n",
       "      <td>RW 😡</td>\n",
       "      <td>1057122160219570176</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1056231465187450880</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1056315087122776064</td>\n",
       "      <td>-0.3400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1056540012630687744</td>\n",
       "      <td>0.5106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1056606370974326784</td>\n",
       "      <td>0.5622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1056698836251488256</td>\n",
       "      <td>-0.5423</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1056838022073933824</td>\n",
       "      <td>-0.3089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1056948201075499008</td>\n",
       "      <td>0.2144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1057001152104054784</td>\n",
       "      <td>0.3451</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1057002057180368896</td>\n",
       "      <td>0.4968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1057077981854777344</td>\n",
       "      <td>0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1057334988016893952</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1057354147681439744</td>\n",
       "      <td>0.7284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1057354550032715776</td>\n",
       "      <td>0.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1057370517718663168</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>885512012561870849</td>\n",
       "      <td>Chris  🇺🇸 Let Freedom Ring</td>\n",
       "      <td>1057400883145830400</td>\n",
       "      <td>-0.5707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>49162880</td>\n",
       "      <td>⚖️JennyVotesRed⚖️</td>\n",
       "      <td>1056122242701148160</td>\n",
       "      <td>0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>49162880</td>\n",
       "      <td>⚖️JennyVotesRed⚖️</td>\n",
       "      <td>1056122651561877504</td>\n",
       "      <td>0.5106</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>49162880</td>\n",
       "      <td>⚖️JennyVotesRed⚖️</td>\n",
       "      <td>1056134789458284544</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>49162880</td>\n",
       "      <td>⚖️JennyVotesRed⚖️</td>\n",
       "      <td>1056703515219898368</td>\n",
       "      <td>-0.6739</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>49162880</td>\n",
       "      <td>⚖️JennyVotesRed⚖️</td>\n",
       "      <td>1056707524160823296</td>\n",
       "      <td>0.5622</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>49162880</td>\n",
       "      <td>⚖️JennyVotesRed⚖️</td>\n",
       "      <td>1056710036750299136</td>\n",
       "      <td>-0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>49162880</td>\n",
       "      <td>⚖️JennyVotesRed⚖️</td>\n",
       "      <td>1056928475704115200</td>\n",
       "      <td>-0.2500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056351439985856512</td>\n",
       "      <td>0.3818</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056352013817044992</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056377508675837952</td>\n",
       "      <td>-0.3348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056390695194288128</td>\n",
       "      <td>0.6114</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056596668844396544</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056603486144618496</td>\n",
       "      <td>0.3182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056603535201038336</td>\n",
       "      <td>-0.0923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056723192650166272</td>\n",
       "      <td>-0.3089</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056963002300170240</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056984170889601024</td>\n",
       "      <td>0.1511</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056985399925518336</td>\n",
       "      <td>-0.8038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056985604565565440</td>\n",
       "      <td>0.4404</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056988484747948032</td>\n",
       "      <td>0.2144</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056988646350278656</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1056988929147101184</td>\n",
       "      <td>0.4968</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057026003946549248</td>\n",
       "      <td>-0.4939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057088447536488448</td>\n",
       "      <td>0.0772</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057100997212823552</td>\n",
       "      <td>-0.9036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057235518369390592</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057236825041817600</td>\n",
       "      <td>0.3400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057347662293291008</td>\n",
       "      <td>0.5859</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057348312741756928</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057355055756533760</td>\n",
       "      <td>-0.7734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057355077696929792</td>\n",
       "      <td>0.7284</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057355692095365120</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057355850400944128</td>\n",
       "      <td>-0.3182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057358573246668800</td>\n",
       "      <td>-0.5719</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057375318418178048</td>\n",
       "      <td>0.0000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057417621555970048</td>\n",
       "      <td>-0.5707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>36175156</td>\n",
       "      <td>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</td>\n",
       "      <td>1057417914536488960</td>\n",
       "      <td>-0.4588</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>167 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "               user_id                   user_name                   ID  \\\n",
       "0   719662077934243840                        RW 😡  1056999526995640320   \n",
       "1   719662077934243840                        RW 😡  1057017666085433344   \n",
       "2   719662077934243840                        RW 😡  1057019158045454336   \n",
       "3   719662077934243840                        RW 😡  1057019194833756160   \n",
       "4   719662077934243840                        RW 😡  1057024357866688512   \n",
       "5   719662077934243840                        RW 😡  1057029275885293568   \n",
       "6   719662077934243840                        RW 😡  1057102294221697024   \n",
       "7   719662077934243840                        RW 😡  1057122160219570176   \n",
       "0   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1056231465187450880   \n",
       "1   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1056315087122776064   \n",
       "2   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1056540012630687744   \n",
       "3   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1056606370974326784   \n",
       "4   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1056698836251488256   \n",
       "5   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1056838022073933824   \n",
       "6   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1056948201075499008   \n",
       "7   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1057001152104054784   \n",
       "8   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1057002057180368896   \n",
       "9   885512012561870849  Chris  🇺🇸 Let Freedom Ring  1057077981854777344   \n",
       "10  885512012561870849  Chris  🇺🇸 Let Freedom Ring  1057334988016893952   \n",
       "11  885512012561870849  Chris  🇺🇸 Let Freedom Ring  1057354147681439744   \n",
       "12  885512012561870849  Chris  🇺🇸 Let Freedom Ring  1057354550032715776   \n",
       "13  885512012561870849  Chris  🇺🇸 Let Freedom Ring  1057370517718663168   \n",
       "14  885512012561870849  Chris  🇺🇸 Let Freedom Ring  1057400883145830400   \n",
       "0             49162880           ⚖️JennyVotesRed⚖️  1056122242701148160   \n",
       "1             49162880           ⚖️JennyVotesRed⚖️  1056122651561877504   \n",
       "2             49162880           ⚖️JennyVotesRed⚖️  1056134789458284544   \n",
       "3             49162880           ⚖️JennyVotesRed⚖️  1056703515219898368   \n",
       "4             49162880           ⚖️JennyVotesRed⚖️  1056707524160823296   \n",
       "5             49162880           ⚖️JennyVotesRed⚖️  1056710036750299136   \n",
       "6             49162880           ⚖️JennyVotesRed⚖️  1056928475704115200   \n",
       "..                 ...                         ...                  ...   \n",
       "3             36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056351439985856512   \n",
       "4             36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056352013817044992   \n",
       "5             36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056377508675837952   \n",
       "6             36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056390695194288128   \n",
       "7             36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056596668844396544   \n",
       "8             36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056603486144618496   \n",
       "9             36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056603535201038336   \n",
       "10            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056723192650166272   \n",
       "11            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056963002300170240   \n",
       "12            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056984170889601024   \n",
       "13            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056985399925518336   \n",
       "14            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056985604565565440   \n",
       "15            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056988484747948032   \n",
       "16            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056988646350278656   \n",
       "17            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1056988929147101184   \n",
       "18            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057026003946549248   \n",
       "19            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057088447536488448   \n",
       "20            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057100997212823552   \n",
       "21            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057235518369390592   \n",
       "22            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057236825041817600   \n",
       "23            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057347662293291008   \n",
       "24            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057348312741756928   \n",
       "25            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057355055756533760   \n",
       "26            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057355077696929792   \n",
       "27            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057355692095365120   \n",
       "28            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057355850400944128   \n",
       "29            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057358573246668800   \n",
       "30            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057375318418178048   \n",
       "31            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057417621555970048   \n",
       "32            36175156    Jo4Trump {⭐️} (K) ⭐️⭐️⭐️  1057417914536488960   \n",
       "\n",
       "      MOOD  \n",
       "0  -0.0772  \n",
       "1   0.0000  \n",
       "2   0.5267  \n",
       "3  -0.4019  \n",
       "4   0.0000  \n",
       "5  -0.4767  \n",
       "6   0.2144  \n",
       "7   0.0000  \n",
       "0   0.0000  \n",
       "1  -0.3400  \n",
       "2   0.5106  \n",
       "3   0.5622  \n",
       "4  -0.5423  \n",
       "5  -0.3089  \n",
       "6   0.2144  \n",
       "7   0.3451  \n",
       "8   0.4968  \n",
       "9   0.0772  \n",
       "10  0.0000  \n",
       "11  0.7284  \n",
       "12  0.2500  \n",
       "13  0.0000  \n",
       "14 -0.5707  \n",
       "0   0.0772  \n",
       "1   0.5106  \n",
       "2   0.0000  \n",
       "3  -0.6739  \n",
       "4   0.5622  \n",
       "5  -0.0772  \n",
       "6  -0.2500  \n",
       "..     ...  \n",
       "3   0.3818  \n",
       "4   0.0000  \n",
       "5  -0.3348  \n",
       "6   0.6114  \n",
       "7   0.0000  \n",
       "8   0.3182  \n",
       "9  -0.0923  \n",
       "10 -0.3089  \n",
       "11  0.0000  \n",
       "12  0.1511  \n",
       "13 -0.8038  \n",
       "14  0.4404  \n",
       "15  0.2144  \n",
       "16  0.0000  \n",
       "17  0.4968  \n",
       "18 -0.4939  \n",
       "19  0.0772  \n",
       "20 -0.9036  \n",
       "21  0.0000  \n",
       "22  0.3400  \n",
       "23  0.5859  \n",
       "24  0.0000  \n",
       "25 -0.7734  \n",
       "26  0.7284  \n",
       "27  0.0000  \n",
       "28 -0.3182  \n",
       "29 -0.5719  \n",
       "30  0.0000  \n",
       "31 -0.5707  \n",
       "32 -0.4588  \n",
       "\n",
       "[167 rows x 4 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "clique_mood = count_mood_for_clique(clique)\n",
    "clique_mood"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">MOOD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>mean</th>\n",
       "      <th>max</th>\n",
       "      <th>min</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>@gary[WontBackDown]</th>\n",
       "      <td>-0.026196</td>\n",
       "      <td>0.8176</td>\n",
       "      <td>-0.7712</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Bluestar</th>\n",
       "      <td>0.100000</td>\n",
       "      <td>0.8402</td>\n",
       "      <td>-0.8038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Chris  🇺🇸 Let Freedom Ring</th>\n",
       "      <td>0.094853</td>\n",
       "      <td>0.7284</td>\n",
       "      <td>-0.5707</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Jo4Trump {⭐️} (K) ⭐️⭐️⭐️</th>\n",
       "      <td>-0.023939</td>\n",
       "      <td>0.7284</td>\n",
       "      <td>-0.9036</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Matthew</th>\n",
       "      <td>0.006644</td>\n",
       "      <td>0.7284</td>\n",
       "      <td>-0.7506</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Nationalist🇺🇸T🇺🇸</th>\n",
       "      <td>-0.036186</td>\n",
       "      <td>0.7783</td>\n",
       "      <td>-0.8038</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>Patriot Gary</th>\n",
       "      <td>-0.030954</td>\n",
       "      <td>0.5859</td>\n",
       "      <td>-0.7906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>RW 😡</th>\n",
       "      <td>-0.026838</td>\n",
       "      <td>0.5267</td>\n",
       "      <td>-0.4767</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>giarca</th>\n",
       "      <td>0.282850</td>\n",
       "      <td>0.6696</td>\n",
       "      <td>-0.5927</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>⚖️JennyVotesRed⚖️</th>\n",
       "      <td>0.000157</td>\n",
       "      <td>0.7284</td>\n",
       "      <td>-0.7734</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                MOOD                \n",
       "                                mean     max     min\n",
       "user_name                                           \n",
       "@gary[WontBackDown]        -0.026196  0.8176 -0.7712\n",
       "Bluestar                    0.100000  0.8402 -0.8038\n",
       "Chris  🇺🇸 Let Freedom Ring  0.094853  0.7284 -0.5707\n",
       "Jo4Trump {⭐️} (K) ⭐️⭐️⭐️   -0.023939  0.7284 -0.9036\n",
       "Matthew                     0.006644  0.7284 -0.7506\n",
       "Nationalist🇺🇸T🇺🇸           -0.036186  0.7783 -0.8038\n",
       "Patriot Gary               -0.030954  0.5859 -0.7906\n",
       "RW 😡                       -0.026838  0.5267 -0.4767\n",
       "giarca                      0.282850  0.6696 -0.5927\n",
       "⚖️JennyVotesRed⚖️           0.000157  0.7284 -0.7734"
      ]
     },
     "execution_count": 93,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "average_user = clique_mood[['user_name', 'MOOD']].groupby(['user_name']).agg(['mean','max', 'min'])\n",
    "average_user"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 94,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "MOOD  mean    0.034039\n",
      "      max     0.713190\n",
      "      min    -0.723710\n",
      "dtype: float64\n"
     ]
    },
    {
     "data": {
      "text/plain": [
       "MOOD  mean    0.100943\n",
       "      max     0.097228\n",
       "      min     0.131951\n",
       "dtype: float64"
      ]
     },
     "execution_count": 94,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "average_clique = average_user[['MOOD']].mean()\n",
    "print(average_clique)\n",
    "average_user[['MOOD']].std()\n",
    "# average_user.dtypes.index"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 95,
   "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 tr th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe thead tr:last-of-type th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th colspan=\"3\" halign=\"left\">MOOD</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th></th>\n",
       "      <th>mean</th>\n",
       "      <th>max</th>\n",
       "      <th>min</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>user_name</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>Patriot Gary</th>\n",
       "      <td>-0.030954</td>\n",
       "      <td>0.5859</td>\n",
       "      <td>-0.7906</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                  MOOD                \n",
       "                  mean     max     min\n",
       "user_name                             \n",
       "Patriot Gary -0.030954  0.5859 -0.7906"
      ]
     },
     "execution_count": 95,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "best_user = [817382752731463680, 950061320652509184, 959285851875196928,\n",
    "             838114538868342787, 1661561491, 3268675369, 838114538868342787, 30]\n",
    "besti = pd.read_sql_query('SELECT user_name \\\n",
    "    FROM user \\\n",
    "    WHERE user.user_id = \"' + str(best_user[i]) + '\"', engine)\n",
    "average_user.loc[besti['user_name']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "# associate it with our custom Session class\n",
    "Session.configure(bind=engine)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}