01_data_cleaning.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "\n",
    "import pandas as pd  \n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "plt.style.use('fivethirtyeight')\n",
    "\n",
    "%matplotlib inline\n",
    "%config InlineBackend.figure_format = 'retina'\n",
    "import re\n",
    "from bs4 import BeautifulSoup\n",
    "from nltk.tokenize import WordPunctTokenizer\n",
    "tok = WordPunctTokenizer()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "depressive_tweets_df = pd.read_csv('depression/depressive_unigram_tweets.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "output_type": "execute_result",
     "data": {
      "text/plain": [
       "  Unnamed: 0           id      time  \\\n",
       "0          0  1.15135E+18  21:25:13   \n",
       "1          1  1.15135E+18  21:25:07   \n",
       "2          2  1.15135E+18  21:25:06   \n",
       "3          3  1.15135E+18  21:24:55   \n",
       "4          4  1.15135E+18  21:24:51   \n",
       "\n",
       "                                               tweet  \\\n",
       "0  Wow, my dad yday: “you don’t take those stupid...   \n",
       "1  what part of this was really harmfult of a lot...   \n",
       "2  one of the ways I got through my #depression i...   \n",
       "3  see i wanna do one of them but they all say th...   \n",
       "4  IS IT clinical depression or is it the palpabl...   \n",
       "\n",
       "                                            hashtags cashtags  \n",
       "0                                                 []       []  \n",
       "1                                                 []       []  \n",
       "2  ['#depression', '#uncoveringthenewu', '#change...       []  \n",
       "3                                                 []       []  \n",
       "4                                                 []       []  "
      ],
      "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>Unnamed: 0</th>\n      <th>id</th>\n      <th>time</th>\n      <th>tweet</th>\n      <th>hashtags</th>\n      <th>cashtags</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>0</td>\n      <td>1.15135E+18</td>\n      <td>21:25:13</td>\n      <td>Wow, my dad yday: “you don’t take those stupid...</td>\n      <td>[]</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>1</td>\n      <td>1.15135E+18</td>\n      <td>21:25:07</td>\n      <td>what part of this was really harmfult of a lot...</td>\n      <td>[]</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>2</td>\n      <td>1.15135E+18</td>\n      <td>21:25:06</td>\n      <td>one of the ways I got through my #depression i...</td>\n      <td>['#depression', '#uncoveringthenewu', '#change...</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>3</td>\n      <td>1.15135E+18</td>\n      <td>21:24:55</td>\n      <td>see i wanna do one of them but they all say th...</td>\n      <td>[]</td>\n      <td>[]</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>4</td>\n      <td>1.15135E+18</td>\n      <td>21:24:51</td>\n      <td>IS IT clinical depression or is it the palpabl...</td>\n      <td>[]</td>\n      <td>[]</td>\n    </tr>\n  </tbody>\n</table>\n</div>"
     },
     "metadata": {},
     "execution_count": 3
    }
   ],
   "source": [
    "depressive_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "#depression_tweets_df = pd.read_csv('depression/depressive_unigram_tweets.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "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>conversation_id</th>\n",
       "      <th>created_at</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>timezone</th>\n",
       "      <th>user_id</th>\n",
       "      <th>username</th>\n",
       "      <th>name</th>\n",
       "      <th>place</th>\n",
       "      <th>...</th>\n",
       "      <th>likes_count</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>link</th>\n",
       "      <th>retweet</th>\n",
       "      <th>quote_url</th>\n",
       "      <th>video</th>\n",
       "      <th>user_rt_id</th>\n",
       "      <th>near</th>\n",
       "      <th>geo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1151347096966041603</td>\n",
       "      <td>1151347096966041603</td>\n",
       "      <td>1563337513000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>21:25:13</td>\n",
       "      <td>PDT</td>\n",
       "      <td>68141680</td>\n",
       "      <td>paulsonmyheart</td>\n",
       "      <td>wit ☾ h♥️</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/PaulsonMyHeart/status/1151...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1151347069627576320</td>\n",
       "      <td>1150980638247231489</td>\n",
       "      <td>1563337507000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>21:25:07</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1125157678957907970</td>\n",
       "      <td>gaymiyas</td>\n",
       "      <td>robin</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/gaymiyas/status/1151347069...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1151347066255396865</td>\n",
       "      <td>1151347066255396865</td>\n",
       "      <td>1563337506000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>21:25:06</td>\n",
       "      <td>PDT</td>\n",
       "      <td>988965488918253568</td>\n",
       "      <td>authornesiewing</td>\n",
       "      <td>Author Nesi Ewing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>['#depression', '#uncoveringthenewu', '#change...</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/AuthorNesiEwing/status/115...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1151347022789611520</td>\n",
       "      <td>1151343977267892225</td>\n",
       "      <td>1563337495000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>21:24:55</td>\n",
       "      <td>PDT</td>\n",
       "      <td>794267753179992064</td>\n",
       "      <td>sebsmish</td>\n",
       "      <td>andaluna 🌙</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/sebsmish/status/1151347022...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1151347006406893568</td>\n",
       "      <td>1151347006406893568</td>\n",
       "      <td>1563337491000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>21:24:51</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1121246242401660928</td>\n",
       "      <td>gbrrants</td>\n",
       "      <td>femme brulee 2</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/gbrrants/status/1151347006...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      conversation_id     created_at        date  \\\n",
       "0  1151347096966041603  1151347096966041603  1563337513000  2019-07-16   \n",
       "1  1151347069627576320  1150980638247231489  1563337507000  2019-07-16   \n",
       "2  1151347066255396865  1151347066255396865  1563337506000  2019-07-16   \n",
       "3  1151347022789611520  1151343977267892225  1563337495000  2019-07-16   \n",
       "4  1151347006406893568  1151347006406893568  1563337491000  2019-07-16   \n",
       "\n",
       "       time timezone              user_id         username               name  \\\n",
       "0  21:25:13      PDT             68141680   paulsonmyheart          wit ☾ h♥️   \n",
       "1  21:25:07      PDT  1125157678957907970         gaymiyas              robin   \n",
       "2  21:25:06      PDT   988965488918253568  authornesiewing  Author Nesi Ewing   \n",
       "3  21:24:55      PDT   794267753179992064         sebsmish         andaluna 🌙   \n",
       "4  21:24:51      PDT  1121246242401660928         gbrrants     femme brulee 2   \n",
       "\n",
       "  place  ... likes_count                                           hashtags  \\\n",
       "0   NaN  ...           0                                                 []   \n",
       "1   NaN  ...           0                                                 []   \n",
       "2   NaN  ...           0  ['#depression', '#uncoveringthenewu', '#change...   \n",
       "3   NaN  ...           0                                                 []   \n",
       "4   NaN  ...           0                                                 []   \n",
       "\n",
       "  cashtags                                               link  retweet  \\\n",
       "0       []  https://twitter.com/PaulsonMyHeart/status/1151...      NaN   \n",
       "1       []  https://twitter.com/gaymiyas/status/1151347069...      NaN   \n",
       "2       []  https://twitter.com/AuthorNesiEwing/status/115...      NaN   \n",
       "3       []  https://twitter.com/sebsmish/status/1151347022...      NaN   \n",
       "4       []  https://twitter.com/gbrrants/status/1151347006...      NaN   \n",
       "\n",
       "   quote_url  video user_rt_id near geo  \n",
       "0        NaN      0        NaN  NaN NaN  \n",
       "1        NaN      0        NaN  NaN NaN  \n",
       "2        NaN      0        NaN  NaN NaN  \n",
       "3        NaN      0        NaN  NaN NaN  \n",
       "4        NaN      0        NaN  NaN NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#depression_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [],
   "source": [
    "#depression_tweets_df.drop(['date', 'timezone', 'username', 'name', 'conversation_id', 'created_at', 'user_id', 'place', 'likes_count', 'link', 'retweet', 'quote_url', 'video', 'user_rt_id', 'near', 'geo', 'mentions', 'urls', 'photos', 'replies_count', 'retweets_count'], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "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>time</th>\n",
       "      <th>tweet</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1151347096966041603</td>\n",
       "      <td>21:25:13</td>\n",
       "      <td>Wow, my dad yday: “you don’t take those stupid...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1151347069627576320</td>\n",
       "      <td>21:25:07</td>\n",
       "      <td>what part of this was really harmfult of a lot...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1151347066255396865</td>\n",
       "      <td>21:25:06</td>\n",
       "      <td>one of the ways I got through my #depression i...</td>\n",
       "      <td>['#depression', '#uncoveringthenewu', '#change...</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1151347022789611520</td>\n",
       "      <td>21:24:55</td>\n",
       "      <td>see i wanna do one of them but they all say th...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1151347006406893568</td>\n",
       "      <td>21:24:51</td>\n",
       "      <td>IS IT clinical depression or is it the palpabl...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      time  \\\n",
       "0  1151347096966041603  21:25:13   \n",
       "1  1151347069627576320  21:25:07   \n",
       "2  1151347066255396865  21:25:06   \n",
       "3  1151347022789611520  21:24:55   \n",
       "4  1151347006406893568  21:24:51   \n",
       "\n",
       "                                               tweet  \\\n",
       "0  Wow, my dad yday: “you don’t take those stupid...   \n",
       "1  what part of this was really harmfult of a lot...   \n",
       "2  one of the ways I got through my #depression i...   \n",
       "3  see i wanna do one of them but they all say th...   \n",
       "4  IS IT clinical depression or is it the palpabl...   \n",
       "\n",
       "                                            hashtags cashtags  \n",
       "0                                                 []       []  \n",
       "1                                                 []       []  \n",
       "2  ['#depression', '#uncoveringthenewu', '#change...       []  \n",
       "3                                                 []       []  \n",
       "4                                                 []       []  "
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#depression_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [],
   "source": [
    "#depressed_tweets_df = pd.read_csv('depressed/tweets.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "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>conversation_id</th>\n",
       "      <th>created_at</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>timezone</th>\n",
       "      <th>user_id</th>\n",
       "      <th>username</th>\n",
       "      <th>name</th>\n",
       "      <th>place</th>\n",
       "      <th>...</th>\n",
       "      <th>likes_count</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>link</th>\n",
       "      <th>retweet</th>\n",
       "      <th>quote_url</th>\n",
       "      <th>video</th>\n",
       "      <th>user_rt_id</th>\n",
       "      <th>near</th>\n",
       "      <th>geo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1151315262748205057</td>\n",
       "      <td>1151313086525116421</td>\n",
       "      <td>1563329923000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>19:18:43</td>\n",
       "      <td>PDT</td>\n",
       "      <td>930813312786366464</td>\n",
       "      <td>keytodepress</td>\n",
       "      <td>Cupid</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/KeytoDepress/status/115131...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1151315254615400448</td>\n",
       "      <td>1151314716091985920</td>\n",
       "      <td>1563329921000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>19:18:41</td>\n",
       "      <td>PDT</td>\n",
       "      <td>771371705063370752</td>\n",
       "      <td>_ron_247</td>\n",
       "      <td>MCKAY SEASON SZN (52-39)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/_ron_247/status/1151315254...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1151315222692429825</td>\n",
       "      <td>1151315222692429825</td>\n",
       "      <td>1563329914000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>19:18:34</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1020503873369194496</td>\n",
       "      <td>jan550n</td>\n",
       "      <td>elizabeth</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/jan550n/status/11513152226...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1151315218011549696</td>\n",
       "      <td>1151315218011549696</td>\n",
       "      <td>1563329913000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>19:18:33</td>\n",
       "      <td>PDT</td>\n",
       "      <td>2812237658</td>\n",
       "      <td>ran_engbot</td>\n",
       "      <td>Ran Yakumo</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/ran_engbot/status/11513152...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1151315209413386240</td>\n",
       "      <td>1151315209413386240</td>\n",
       "      <td>1563329910000</td>\n",
       "      <td>2019-07-16</td>\n",
       "      <td>19:18:30</td>\n",
       "      <td>PDT</td>\n",
       "      <td>4833251469</td>\n",
       "      <td>sasstelligence</td>\n",
       "      <td>Stressed, Depressed Espressos</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/Sasstelligence/status/1151...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      conversation_id     created_at        date  \\\n",
       "0  1151315262748205057  1151313086525116421  1563329923000  2019-07-16   \n",
       "1  1151315254615400448  1151314716091985920  1563329921000  2019-07-16   \n",
       "2  1151315222692429825  1151315222692429825  1563329914000  2019-07-16   \n",
       "3  1151315218011549696  1151315218011549696  1563329913000  2019-07-16   \n",
       "4  1151315209413386240  1151315209413386240  1563329910000  2019-07-16   \n",
       "\n",
       "       time timezone              user_id        username  \\\n",
       "0  19:18:43      PDT   930813312786366464    keytodepress   \n",
       "1  19:18:41      PDT   771371705063370752        _ron_247   \n",
       "2  19:18:34      PDT  1020503873369194496         jan550n   \n",
       "3  19:18:33      PDT           2812237658      ran_engbot   \n",
       "4  19:18:30      PDT           4833251469  sasstelligence   \n",
       "\n",
       "                            name place  ... likes_count hashtags cashtags  \\\n",
       "0                          Cupid   NaN  ...           0       []       []   \n",
       "1       MCKAY SEASON SZN (52-39)   NaN  ...           0       []       []   \n",
       "2                      elizabeth   NaN  ...           0       []       []   \n",
       "3                     Ran Yakumo   NaN  ...           0       []       []   \n",
       "4  Stressed, Depressed Espressos   NaN  ...           1       []       []   \n",
       "\n",
       "                                                link  retweet  quote_url  \\\n",
       "0  https://twitter.com/KeytoDepress/status/115131...      NaN        NaN   \n",
       "1  https://twitter.com/_ron_247/status/1151315254...      NaN        NaN   \n",
       "2  https://twitter.com/jan550n/status/11513152226...      NaN        NaN   \n",
       "3  https://twitter.com/ran_engbot/status/11513152...      NaN        NaN   \n",
       "4  https://twitter.com/Sasstelligence/status/1151...      NaN        NaN   \n",
       "\n",
       "   video user_rt_id near geo  \n",
       "0      0        NaN  NaN NaN  \n",
       "1      0        NaN  NaN NaN  \n",
       "2      0        NaN  NaN NaN  \n",
       "3      0        NaN  NaN NaN  \n",
       "4      0        NaN  NaN NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#depressed_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [],
   "source": [
    "#depressed_tweets_df.drop(['date', 'timezone', 'username', 'name', 'conversation_id', 'created_at', 'user_id', 'place', 'likes_count', 'link', 'retweet', 'quote_url', 'video', 'user_rt_id', 'near', 'geo', 'mentions', 'urls', 'photos', 'replies_count', 'retweets_count'], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "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>time</th>\n",
       "      <th>tweet</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1151315262748205057</td>\n",
       "      <td>19:18:43</td>\n",
       "      <td>Listen!! IM SORRY!!   With her elder spirits g...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1151315254615400448</td>\n",
       "      <td>19:18:41</td>\n",
       "      <td>Im so pissed and depressed at the same time</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1151315222692429825</td>\n",
       "      <td>19:18:34</td>\n",
       "      <td>I’m just a hot mess that’s stressed, depressed...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1151315218011549696</td>\n",
       "      <td>19:18:33</td>\n",
       "      <td>Chen's probably depressed too since she's no l...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1151315209413386240</td>\n",
       "      <td>19:18:30</td>\n",
       "      <td>Do you like it when I shake it for ya, daddy? ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      time  \\\n",
       "0  1151315262748205057  19:18:43   \n",
       "1  1151315254615400448  19:18:41   \n",
       "2  1151315222692429825  19:18:34   \n",
       "3  1151315218011549696  19:18:33   \n",
       "4  1151315209413386240  19:18:30   \n",
       "\n",
       "                                               tweet hashtags cashtags  \n",
       "0  Listen!! IM SORRY!!   With her elder spirits g...       []       []  \n",
       "1        Im so pissed and depressed at the same time       []       []  \n",
       "2  I’m just a hot mess that’s stressed, depressed...       []       []  \n",
       "3  Chen's probably depressed too since she's no l...       []       []  \n",
       "4  Do you like it when I shake it for ya, daddy? ...       []       []  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "#depressed_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [],
   "source": [
    "hopeless_tweets_df = pd.read_csv('hopeless/tweets.csv')"
   ]
  },
  {
   "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>conversation_id</th>\n",
       "      <th>created_at</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>timezone</th>\n",
       "      <th>user_id</th>\n",
       "      <th>username</th>\n",
       "      <th>name</th>\n",
       "      <th>place</th>\n",
       "      <th>...</th>\n",
       "      <th>likes_count</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>link</th>\n",
       "      <th>retweet</th>\n",
       "      <th>quote_url</th>\n",
       "      <th>video</th>\n",
       "      <th>user_rt_id</th>\n",
       "      <th>near</th>\n",
       "      <th>geo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1151526536471728134</td>\n",
       "      <td>1151526536471728134</td>\n",
       "      <td>1563380295000</td>\n",
       "      <td>2019-07-17</td>\n",
       "      <td>09:18:15</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1070085811650117633</td>\n",
       "      <td>greesybot</td>\n",
       "      <td>greesybot</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/greesybot/status/115152653...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1151526442922139649</td>\n",
       "      <td>1151524002457882624</td>\n",
       "      <td>1563380272000</td>\n",
       "      <td>2019-07-17</td>\n",
       "      <td>09:17:52</td>\n",
       "      <td>PDT</td>\n",
       "      <td>853583752483807232</td>\n",
       "      <td>umutsuz_vakayim</td>\n",
       "      <td>Hopeless</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/umutsuz_vakayim/status/115...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1151526396210110464</td>\n",
       "      <td>1151526396210110464</td>\n",
       "      <td>1563380261000</td>\n",
       "      <td>2019-07-17</td>\n",
       "      <td>09:17:41</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1120246244075626496</td>\n",
       "      <td>hopeless95</td>\n",
       "      <td>𐂂</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/hopeless95/status/11515263...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1151526283890683904</td>\n",
       "      <td>1151525753990725632</td>\n",
       "      <td>1563380235000</td>\n",
       "      <td>2019-07-17</td>\n",
       "      <td>09:17:15</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1147135129489301505</td>\n",
       "      <td>hopehopexx</td>\n",
       "      <td>Hopeless</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/Hopehopexx/status/11515262...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1151526267738628097</td>\n",
       "      <td>1151526267738628097</td>\n",
       "      <td>1563380231000</td>\n",
       "      <td>2019-07-17</td>\n",
       "      <td>09:17:11</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1120246244075626496</td>\n",
       "      <td>hopeless95</td>\n",
       "      <td>𐂂</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/hopeless95/status/11515262...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      conversation_id     created_at        date  \\\n",
       "0  1151526536471728134  1151526536471728134  1563380295000  2019-07-17   \n",
       "1  1151526442922139649  1151524002457882624  1563380272000  2019-07-17   \n",
       "2  1151526396210110464  1151526396210110464  1563380261000  2019-07-17   \n",
       "3  1151526283890683904  1151525753990725632  1563380235000  2019-07-17   \n",
       "4  1151526267738628097  1151526267738628097  1563380231000  2019-07-17   \n",
       "\n",
       "       time timezone              user_id         username       name place  \\\n",
       "0  09:18:15      PDT  1070085811650117633        greesybot  greesybot   NaN   \n",
       "1  09:17:52      PDT   853583752483807232  umutsuz_vakayim   Hopeless   NaN   \n",
       "2  09:17:41      PDT  1120246244075626496       hopeless95          𐂂   NaN   \n",
       "3  09:17:15      PDT  1147135129489301505       hopehopexx   Hopeless   NaN   \n",
       "4  09:17:11      PDT  1120246244075626496       hopeless95          𐂂   NaN   \n",
       "\n",
       "   ... likes_count hashtags cashtags  \\\n",
       "0  ...           0       []       []   \n",
       "1  ...           0       []       []   \n",
       "2  ...           1       []       []   \n",
       "3  ...           0       []       []   \n",
       "4  ...           1       []       []   \n",
       "\n",
       "                                                link  retweet  quote_url  \\\n",
       "0  https://twitter.com/greesybot/status/115152653...      NaN        NaN   \n",
       "1  https://twitter.com/umutsuz_vakayim/status/115...      NaN        NaN   \n",
       "2  https://twitter.com/hopeless95/status/11515263...      NaN        NaN   \n",
       "3  https://twitter.com/Hopehopexx/status/11515262...      NaN        NaN   \n",
       "4  https://twitter.com/hopeless95/status/11515262...      NaN        NaN   \n",
       "\n",
       "   video user_rt_id near geo  \n",
       "0      0        NaN  NaN NaN  \n",
       "1      0        NaN  NaN NaN  \n",
       "2      0        NaN  NaN NaN  \n",
       "3      0        NaN  NaN NaN  \n",
       "4      0        NaN  NaN NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hopeless_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "hopeless_tweets_df.drop(['date', 'timezone', 'username', 'name', 'conversation_id', 'created_at', 'user_id', 'place', 'likes_count', 'link', 'retweet', 'quote_url', 'video', 'user_rt_id', 'near', 'geo', 'mentions', 'urls', 'photos', 'replies_count', 'retweets_count'], axis = 1, inplace = True)"
   ]
  },
  {
   "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>id</th>\n",
       "      <th>time</th>\n",
       "      <th>tweet</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1151526536471728134</td>\n",
       "      <td>09:18:15</td>\n",
       "      <td>Hopeless, crazed, and dispossessed, I walked o...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1151526442922139649</td>\n",
       "      <td>09:17:52</td>\n",
       "      <td>KAP haberini beklerken serSERİn olmuştuk</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1151526396210110464</td>\n",
       "      <td>09:17:41</td>\n",
       "      <td>17-july-2019. 🦉💛.</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1151526283890683904</td>\n",
       "      <td>09:17:15</td>\n",
       "      <td>เป็นไรสาวน้อย</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1151526267738628097</td>\n",
       "      <td>09:17:11</td>\n",
       "      <td>انا قاعده اعيش اسعد ايام حياتي💛.</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      time  \\\n",
       "0  1151526536471728134  09:18:15   \n",
       "1  1151526442922139649  09:17:52   \n",
       "2  1151526396210110464  09:17:41   \n",
       "3  1151526283890683904  09:17:15   \n",
       "4  1151526267738628097  09:17:11   \n",
       "\n",
       "                                               tweet hashtags cashtags  \n",
       "0  Hopeless, crazed, and dispossessed, I walked o...       []       []  \n",
       "1           KAP haberini beklerken serSERİn olmuştuk       []       []  \n",
       "2                                  17-july-2019. 🦉💛.       []       []  \n",
       "3                                      เป็นไรสาวน้อย       []       []  \n",
       "4                   انا قاعده اعيش اسعد ايام حياتي💛.       []       []  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "hopeless_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [],
   "source": [
    "lonely_tweets_df = pd.read_csv('lonely/tweets.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "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>conversation_id</th>\n",
       "      <th>created_at</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>timezone</th>\n",
       "      <th>user_id</th>\n",
       "      <th>username</th>\n",
       "      <th>name</th>\n",
       "      <th>place</th>\n",
       "      <th>...</th>\n",
       "      <th>likes_count</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>link</th>\n",
       "      <th>retweet</th>\n",
       "      <th>quote_url</th>\n",
       "      <th>video</th>\n",
       "      <th>user_rt_id</th>\n",
       "      <th>near</th>\n",
       "      <th>geo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1152982582843326466</td>\n",
       "      <td>1152982582843326466</td>\n",
       "      <td>1563727443000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>09:44:03</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1151002890573701120</td>\n",
       "      <td>monbebe93</td>\n",
       "      <td>제시카</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/monbebe93/status/115298258...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>https://twitter.com/OI_IO999/status/1152978766...</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1152982578741284865</td>\n",
       "      <td>1152916420587675648</td>\n",
       "      <td>1563727442000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>09:44:02</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1065697539259854849</td>\n",
       "      <td>sugarplum_skz</td>\n",
       "      <td>lonely wolf</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/sugarplum_skz/status/11529...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1152982577181024259</td>\n",
       "      <td>1152976191781048322</td>\n",
       "      <td>1563727442000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>09:44:02</td>\n",
       "      <td>PDT</td>\n",
       "      <td>704212959950667776</td>\n",
       "      <td>lonely_walsh</td>\n",
       "      <td>Elizabeth</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/lonely_walsh/status/115298...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1152982576153239552</td>\n",
       "      <td>1152982576153239552</td>\n",
       "      <td>1563727442000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>09:44:02</td>\n",
       "      <td>PDT</td>\n",
       "      <td>284959188</td>\n",
       "      <td>lonelyoakradio</td>\n",
       "      <td>Lonely Oak radio</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>['#nowplaying']</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/LonelyOakRadio/status/1152...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1152982566263296000</td>\n",
       "      <td>1152982566263296000</td>\n",
       "      <td>1563727439000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>09:43:59</td>\n",
       "      <td>PDT</td>\n",
       "      <td>144328187</td>\n",
       "      <td>noelle_amor</td>\n",
       "      <td>YaYa🌹</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/Noelle_Amor/status/1152982...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      conversation_id     created_at        date  \\\n",
       "0  1152982582843326466  1152982582843326466  1563727443000  2019-07-21   \n",
       "1  1152982578741284865  1152916420587675648  1563727442000  2019-07-21   \n",
       "2  1152982577181024259  1152976191781048322  1563727442000  2019-07-21   \n",
       "3  1152982576153239552  1152982576153239552  1563727442000  2019-07-21   \n",
       "4  1152982566263296000  1152982566263296000  1563727439000  2019-07-21   \n",
       "\n",
       "       time timezone              user_id        username              name  \\\n",
       "0  09:44:03      PDT  1151002890573701120       monbebe93               제시카   \n",
       "1  09:44:02      PDT  1065697539259854849   sugarplum_skz       lonely wolf   \n",
       "2  09:44:02      PDT   704212959950667776    lonely_walsh         Elizabeth   \n",
       "3  09:44:02      PDT            284959188  lonelyoakradio  Lonely Oak radio   \n",
       "4  09:43:59      PDT            144328187     noelle_amor             YaYa🌹   \n",
       "\n",
       "  place  ... likes_count         hashtags cashtags  \\\n",
       "0   NaN  ...           0               []       []   \n",
       "1   NaN  ...           0               []       []   \n",
       "2   NaN  ...           0               []       []   \n",
       "3   NaN  ...           0  ['#nowplaying']       []   \n",
       "4   NaN  ...           0               []       []   \n",
       "\n",
       "                                                link  retweet  \\\n",
       "0  https://twitter.com/monbebe93/status/115298258...      NaN   \n",
       "1  https://twitter.com/sugarplum_skz/status/11529...      NaN   \n",
       "2  https://twitter.com/lonely_walsh/status/115298...      NaN   \n",
       "3  https://twitter.com/LonelyOakRadio/status/1152...      NaN   \n",
       "4  https://twitter.com/Noelle_Amor/status/1152982...      NaN   \n",
       "\n",
       "                                           quote_url  video user_rt_id near  \\\n",
       "0  https://twitter.com/OI_IO999/status/1152978766...      0        NaN  NaN   \n",
       "1                                                NaN      0        NaN  NaN   \n",
       "2                                                NaN      0        NaN  NaN   \n",
       "3                                                NaN      0        NaN  NaN   \n",
       "4                                                NaN      0        NaN  NaN   \n",
       "\n",
       "  geo  \n",
       "0 NaN  \n",
       "1 NaN  \n",
       "2 NaN  \n",
       "3 NaN  \n",
       "4 NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lonely_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "lonely_tweets_df.drop(['date', 'timezone', 'username', 'name', 'conversation_id', 'created_at', 'user_id', 'place', 'likes_count', 'link', 'retweet', 'quote_url', 'video', 'user_rt_id', 'near', 'geo', 'mentions', 'urls', 'photos', 'replies_count', 'retweets_count'], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>id</th>\n",
       "      <th>time</th>\n",
       "      <th>tweet</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1152982582843326466</td>\n",
       "      <td>09:44:03</td>\n",
       "      <td>i dont know why but he looks so lonely in this...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1152982578741284865</td>\n",
       "      <td>09:44:02</td>\n",
       "      <td>Я после того как увидела их начала отращивать ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1152982577181024259</td>\n",
       "      <td>09:44:02</td>\n",
       "      <td>Even follow you on all social networks</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1152982576153239552</td>\n",
       "      <td>09:44:02</td>\n",
       "      <td>#Nowplaying: Garmonsway, Gibbon and Harrington...</td>\n",
       "      <td>['#nowplaying']</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1152982566263296000</td>\n",
       "      <td>09:43:59</td>\n",
       "      <td>Laying in this hammock every Sunday alone is g...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      time  \\\n",
       "0  1152982582843326466  09:44:03   \n",
       "1  1152982578741284865  09:44:02   \n",
       "2  1152982577181024259  09:44:02   \n",
       "3  1152982576153239552  09:44:02   \n",
       "4  1152982566263296000  09:43:59   \n",
       "\n",
       "                                               tweet         hashtags cashtags  \n",
       "0  i dont know why but he looks so lonely in this...               []       []  \n",
       "1  Я после того как увидела их начала отращивать ...               []       []  \n",
       "2             Even follow you on all social networks               []       []  \n",
       "3  #Nowplaying: Garmonsway, Gibbon and Harrington...  ['#nowplaying']       []  \n",
       "4  Laying in this hammock every Sunday alone is g...               []       []  "
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "lonely_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "antidepressant_tweets_df = pd.read_csv('antidepressant/tweets.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "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>conversation_id</th>\n",
       "      <th>created_at</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>timezone</th>\n",
       "      <th>user_id</th>\n",
       "      <th>username</th>\n",
       "      <th>name</th>\n",
       "      <th>place</th>\n",
       "      <th>...</th>\n",
       "      <th>likes_count</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>link</th>\n",
       "      <th>retweet</th>\n",
       "      <th>quote_url</th>\n",
       "      <th>video</th>\n",
       "      <th>user_rt_id</th>\n",
       "      <th>near</th>\n",
       "      <th>geo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1152991919137538048</td>\n",
       "      <td>1152991908391739392</td>\n",
       "      <td>1563729669000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:21:09</td>\n",
       "      <td>PDT</td>\n",
       "      <td>794617098106441728</td>\n",
       "      <td>harlequimsy</td>\n",
       "      <td>Darnielle 🤦🏻‍♀️</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/harlequimsy/status/1152991...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1152991631722913793</td>\n",
       "      <td>1152991631722913793</td>\n",
       "      <td>1563729601000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:20:01</td>\n",
       "      <td>PDT</td>\n",
       "      <td>959487925992947714</td>\n",
       "      <td>aspiringapollo</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/AspiringApollo/status/1152...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1152991531789406209</td>\n",
       "      <td>1152986023447732224</td>\n",
       "      <td>1563729577000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:19:37</td>\n",
       "      <td>PDT</td>\n",
       "      <td>2391838146</td>\n",
       "      <td>al_pal_22</td>\n",
       "      <td>brogram</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/al_pal_22/status/115299153...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1152991116733628416</td>\n",
       "      <td>1152991116733628416</td>\n",
       "      <td>1563729478000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:17:58</td>\n",
       "      <td>PDT</td>\n",
       "      <td>510205955</td>\n",
       "      <td>iceberged</td>\n",
       "      <td>Iceberg SelfHelp</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>['#medication', '#antidepressants', '#eatingdi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/IcebergED/status/115299111...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1152990783420751872</td>\n",
       "      <td>1152862679452790785</td>\n",
       "      <td>1563729398000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:16:38</td>\n",
       "      <td>PDT</td>\n",
       "      <td>34530161</td>\n",
       "      <td>matchlessmarie</td>\n",
       "      <td>Amanda [matchless] Marie</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/MatchlessMarie/status/1152...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      conversation_id     created_at        date  \\\n",
       "0  1152991919137538048  1152991908391739392  1563729669000  2019-07-21   \n",
       "1  1152991631722913793  1152991631722913793  1563729601000  2019-07-21   \n",
       "2  1152991531789406209  1152986023447732224  1563729577000  2019-07-21   \n",
       "3  1152991116733628416  1152991116733628416  1563729478000  2019-07-21   \n",
       "4  1152990783420751872  1152862679452790785  1563729398000  2019-07-21   \n",
       "\n",
       "       time timezone             user_id        username  \\\n",
       "0  10:21:09      PDT  794617098106441728     harlequimsy   \n",
       "1  10:20:01      PDT  959487925992947714  aspiringapollo   \n",
       "2  10:19:37      PDT          2391838146       al_pal_22   \n",
       "3  10:17:58      PDT           510205955       iceberged   \n",
       "4  10:16:38      PDT            34530161  matchlessmarie   \n",
       "\n",
       "                       name place  ... likes_count  \\\n",
       "0           Darnielle 🤦🏻‍♀️   NaN  ...           0   \n",
       "1                   Anthony   NaN  ...           0   \n",
       "2                   brogram   NaN  ...           0   \n",
       "3          Iceberg SelfHelp   NaN  ...           0   \n",
       "4  Amanda [matchless] Marie   NaN  ...           1   \n",
       "\n",
       "                                            hashtags cashtags  \\\n",
       "0                                                 []       []   \n",
       "1                                                 []       []   \n",
       "2                                                 []       []   \n",
       "3  ['#medication', '#antidepressants', '#eatingdi...       []   \n",
       "4                                                 []       []   \n",
       "\n",
       "                                                link  retweet  quote_url  \\\n",
       "0  https://twitter.com/harlequimsy/status/1152991...      NaN        NaN   \n",
       "1  https://twitter.com/AspiringApollo/status/1152...      NaN        NaN   \n",
       "2  https://twitter.com/al_pal_22/status/115299153...      NaN        NaN   \n",
       "3  https://twitter.com/IcebergED/status/115299111...      NaN        NaN   \n",
       "4  https://twitter.com/MatchlessMarie/status/1152...      NaN        NaN   \n",
       "\n",
       "   video user_rt_id near geo  \n",
       "0      0        NaN  NaN NaN  \n",
       "1      0        NaN  NaN NaN  \n",
       "2      0        NaN  NaN NaN  \n",
       "3      0        NaN  NaN NaN  \n",
       "4      0        NaN  NaN NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "antidepressant_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "antidepressant_tweets_df.drop(['date', 'timezone', 'username', 'name', 'conversation_id', 'created_at', 'user_id', 'place', 'likes_count', 'link', 'retweet', 'quote_url', 'video', 'user_rt_id', 'near', 'geo', 'mentions', 'urls', 'photos', 'replies_count', 'retweets_count'], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>time</th>\n",
       "      <th>tweet</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1152991919137538048</td>\n",
       "      <td>10:21:09</td>\n",
       "      <td>I hate that the antidepressants made me feel w...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1152991631722913793</td>\n",
       "      <td>10:20:01</td>\n",
       "      <td>Your beliefs ultimately are manifested in your...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1152991531789406209</td>\n",
       "      <td>10:19:37</td>\n",
       "      <td>I think current trends lead to a world where e...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1152991116733628416</td>\n",
       "      <td>10:17:58</td>\n",
       "      <td>Anti-Depressants and Recovery  https://www.mar...</td>\n",
       "      <td>['#medication', '#antidepressants', '#eatingdi...</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1152990783420751872</td>\n",
       "      <td>10:16:38</td>\n",
       "      <td>Have you thought about getting a sleep study d...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      time  \\\n",
       "0  1152991919137538048  10:21:09   \n",
       "1  1152991631722913793  10:20:01   \n",
       "2  1152991531789406209  10:19:37   \n",
       "3  1152991116733628416  10:17:58   \n",
       "4  1152990783420751872  10:16:38   \n",
       "\n",
       "                                               tweet  \\\n",
       "0  I hate that the antidepressants made me feel w...   \n",
       "1  Your beliefs ultimately are manifested in your...   \n",
       "2  I think current trends lead to a world where e...   \n",
       "3  Anti-Depressants and Recovery  https://www.mar...   \n",
       "4  Have you thought about getting a sleep study d...   \n",
       "\n",
       "                                            hashtags cashtags  \n",
       "0                                                 []       []  \n",
       "1                                                 []       []  \n",
       "2                                                 []       []  \n",
       "3  ['#medication', '#antidepressants', '#eatingdi...       []  \n",
       "4                                                 []       []  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "antidepressant_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "antidepressants_tweets_df = pd.read_csv('antidepressants/tweets.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "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>conversation_id</th>\n",
       "      <th>created_at</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>timezone</th>\n",
       "      <th>user_id</th>\n",
       "      <th>username</th>\n",
       "      <th>name</th>\n",
       "      <th>place</th>\n",
       "      <th>...</th>\n",
       "      <th>likes_count</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>link</th>\n",
       "      <th>retweet</th>\n",
       "      <th>quote_url</th>\n",
       "      <th>video</th>\n",
       "      <th>user_rt_id</th>\n",
       "      <th>near</th>\n",
       "      <th>geo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1152995178359218176</td>\n",
       "      <td>1152995178359218176</td>\n",
       "      <td>1563730446000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:34:06</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1134809541818929152</td>\n",
       "      <td>neumnelo</td>\n",
       "      <td>🍓⚢</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/neumnelo/status/1152995178...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1152994945537576960</td>\n",
       "      <td>1152994945537576960</td>\n",
       "      <td>1563730391000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:33:11</td>\n",
       "      <td>PDT</td>\n",
       "      <td>709759485162598400</td>\n",
       "      <td>csevern5</td>\n",
       "      <td>C Severn</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/csevern5/status/1152994945...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1152994834359209985</td>\n",
       "      <td>1152994145700634625</td>\n",
       "      <td>1563730364000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:32:44</td>\n",
       "      <td>PDT</td>\n",
       "      <td>969718541703368704</td>\n",
       "      <td>healingapriori</td>\n",
       "      <td>A Kid That Knows Nothing</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/healingapriori/status/1152...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1152994452606033920</td>\n",
       "      <td>1152994452606033920</td>\n",
       "      <td>1563730273000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:31:13</td>\n",
       "      <td>PDT</td>\n",
       "      <td>864470942159953920</td>\n",
       "      <td>liferenewedjax</td>\n",
       "      <td>Life Renewed Counseling</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/liferenewedjax/status/1152...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1152994432188370949</td>\n",
       "      <td>1152994432188370949</td>\n",
       "      <td>1563730268000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:31:08</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1029517541608108033</td>\n",
       "      <td>glitterfairy420</td>\n",
       "      <td>𝕵𝖊𝖓𝖓𝖎𝖋𝖊𝖗★</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/Glitterfairy420/status/115...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      conversation_id     created_at        date  \\\n",
       "0  1152995178359218176  1152995178359218176  1563730446000  2019-07-21   \n",
       "1  1152994945537576960  1152994945537576960  1563730391000  2019-07-21   \n",
       "2  1152994834359209985  1152994145700634625  1563730364000  2019-07-21   \n",
       "3  1152994452606033920  1152994452606033920  1563730273000  2019-07-21   \n",
       "4  1152994432188370949  1152994432188370949  1563730268000  2019-07-21   \n",
       "\n",
       "       time timezone              user_id         username  \\\n",
       "0  10:34:06      PDT  1134809541818929152         neumnelo   \n",
       "1  10:33:11      PDT   709759485162598400         csevern5   \n",
       "2  10:32:44      PDT   969718541703368704   healingapriori   \n",
       "3  10:31:13      PDT   864470942159953920   liferenewedjax   \n",
       "4  10:31:08      PDT  1029517541608108033  glitterfairy420   \n",
       "\n",
       "                       name place  ... likes_count hashtags cashtags  \\\n",
       "0                        🍓⚢   NaN  ...           0       []       []   \n",
       "1                  C Severn   NaN  ...           0       []       []   \n",
       "2  A Kid That Knows Nothing   NaN  ...           0       []       []   \n",
       "3   Life Renewed Counseling   NaN  ...           0       []       []   \n",
       "4                 𝕵𝖊𝖓𝖓𝖎𝖋𝖊𝖗★   NaN  ...           0       []       []   \n",
       "\n",
       "                                                link  retweet  quote_url  \\\n",
       "0  https://twitter.com/neumnelo/status/1152995178...      NaN        NaN   \n",
       "1  https://twitter.com/csevern5/status/1152994945...      NaN        NaN   \n",
       "2  https://twitter.com/healingapriori/status/1152...      NaN        NaN   \n",
       "3  https://twitter.com/liferenewedjax/status/1152...      NaN        NaN   \n",
       "4  https://twitter.com/Glitterfairy420/status/115...      NaN        NaN   \n",
       "\n",
       "   video user_rt_id near geo  \n",
       "0      0        NaN  NaN NaN  \n",
       "1      0        NaN  NaN NaN  \n",
       "2      0        NaN  NaN NaN  \n",
       "3      0        NaN  NaN NaN  \n",
       "4      0        NaN  NaN NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "antidepressants_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [],
   "source": [
    "antidepressants_tweets_df.drop(['date', 'timezone', 'username', 'name', 'conversation_id', 'created_at', 'user_id', 'place', 'likes_count', 'link', 'retweet', 'quote_url', 'video', 'user_rt_id', 'near', 'geo', 'mentions', 'urls', 'photos', 'replies_count', 'retweets_count'], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "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>time</th>\n",
       "      <th>tweet</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1152995178359218176</td>\n",
       "      <td>10:34:06</td>\n",
       "      <td>i can't think logically and all of shit i say ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1152994945537576960</td>\n",
       "      <td>10:33:11</td>\n",
       "      <td>Recently moved to Australia and was ASTOUNDED ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1152994834359209985</td>\n",
       "      <td>10:32:44</td>\n",
       "      <td>Maybe I should go back on my antidepressants. ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1152994452606033920</td>\n",
       "      <td>10:31:13</td>\n",
       "      <td>What It’s Like to Know You’ll Be on Antidepres...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1152994432188370949</td>\n",
       "      <td>10:31:08</td>\n",
       "      <td>Do antidepressants work? :/</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      time  \\\n",
       "0  1152995178359218176  10:34:06   \n",
       "1  1152994945537576960  10:33:11   \n",
       "2  1152994834359209985  10:32:44   \n",
       "3  1152994452606033920  10:31:13   \n",
       "4  1152994432188370949  10:31:08   \n",
       "\n",
       "                                               tweet hashtags cashtags  \n",
       "0  i can't think logically and all of shit i say ...       []       []  \n",
       "1  Recently moved to Australia and was ASTOUNDED ...       []       []  \n",
       "2  Maybe I should go back on my antidepressants. ...       []       []  \n",
       "3  What It’s Like to Know You’ll Be on Antidepres...       []       []  \n",
       "4                        Do antidepressants work? :/       []       []  "
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "antidepressants_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "suicide_tweets_df = pd.read_csv('suicide/tweets.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "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>conversation_id</th>\n",
       "      <th>created_at</th>\n",
       "      <th>date</th>\n",
       "      <th>time</th>\n",
       "      <th>timezone</th>\n",
       "      <th>user_id</th>\n",
       "      <th>username</th>\n",
       "      <th>name</th>\n",
       "      <th>place</th>\n",
       "      <th>...</th>\n",
       "      <th>likes_count</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>link</th>\n",
       "      <th>retweet</th>\n",
       "      <th>quote_url</th>\n",
       "      <th>video</th>\n",
       "      <th>user_rt_id</th>\n",
       "      <th>near</th>\n",
       "      <th>geo</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1152996044604682241</td>\n",
       "      <td>1152996044604682241</td>\n",
       "      <td>1563730653000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:37:33</td>\n",
       "      <td>PDT</td>\n",
       "      <td>2958699552</td>\n",
       "      <td>imonlylj</td>\n",
       "      <td>Misunderśtøød x Mìdaś ㊗️️</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/ImonlyLj/status/1152996044...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1152995993148899329</td>\n",
       "      <td>1152995993148899329</td>\n",
       "      <td>1563730641000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:37:21</td>\n",
       "      <td>PDT</td>\n",
       "      <td>29907109</td>\n",
       "      <td>_kingneal</td>\n",
       "      <td>King.</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/_kingneal/status/115299599...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1152995985053900800</td>\n",
       "      <td>1152995985053900800</td>\n",
       "      <td>1563730639000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:37:19</td>\n",
       "      <td>PDT</td>\n",
       "      <td>1152971452846694401</td>\n",
       "      <td>ventingbroken</td>\n",
       "      <td>Venting (More people are broken than it seems)</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/VentingBroken/status/11529...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1152995984642887683</td>\n",
       "      <td>1152995984642887683</td>\n",
       "      <td>1563730639000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:37:19</td>\n",
       "      <td>PDT</td>\n",
       "      <td>2561945708</td>\n",
       "      <td>awesome_thebest</td>\n",
       "      <td>Just me</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/awesome_thebest/status/115...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1152995955559620608</td>\n",
       "      <td>1152995955559620608</td>\n",
       "      <td>1563730632000</td>\n",
       "      <td>2019-07-21</td>\n",
       "      <td>10:37:12</td>\n",
       "      <td>PDT</td>\n",
       "      <td>891371293563596800</td>\n",
       "      <td>drmo7og</td>\n",
       "      <td>Dr.mo7og</td>\n",
       "      <td>NaN</td>\n",
       "      <td>...</td>\n",
       "      <td>0</td>\n",
       "      <td>['#sam', '#suicide']</td>\n",
       "      <td>[]</td>\n",
       "      <td>https://twitter.com/DrMo7oG/status/11529959555...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>5 rows × 26 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      conversation_id     created_at        date  \\\n",
       "0  1152996044604682241  1152996044604682241  1563730653000  2019-07-21   \n",
       "1  1152995993148899329  1152995993148899329  1563730641000  2019-07-21   \n",
       "2  1152995985053900800  1152995985053900800  1563730639000  2019-07-21   \n",
       "3  1152995984642887683  1152995984642887683  1563730639000  2019-07-21   \n",
       "4  1152995955559620608  1152995955559620608  1563730632000  2019-07-21   \n",
       "\n",
       "       time timezone              user_id         username  \\\n",
       "0  10:37:33      PDT           2958699552         imonlylj   \n",
       "1  10:37:21      PDT             29907109        _kingneal   \n",
       "2  10:37:19      PDT  1152971452846694401    ventingbroken   \n",
       "3  10:37:19      PDT           2561945708  awesome_thebest   \n",
       "4  10:37:12      PDT   891371293563596800          drmo7og   \n",
       "\n",
       "                                             name place  ... likes_count  \\\n",
       "0                       Misunderśtøød x Mìdaś ㊗️️   NaN  ...           0   \n",
       "1                                           King.   NaN  ...           0   \n",
       "2  Venting (More people are broken than it seems)   NaN  ...           0   \n",
       "3                                         Just me   NaN  ...           0   \n",
       "4                                        Dr.mo7og   NaN  ...           0   \n",
       "\n",
       "               hashtags cashtags  \\\n",
       "0                    []       []   \n",
       "1                    []       []   \n",
       "2                    []       []   \n",
       "3                    []       []   \n",
       "4  ['#sam', '#suicide']       []   \n",
       "\n",
       "                                                link  retweet  quote_url  \\\n",
       "0  https://twitter.com/ImonlyLj/status/1152996044...      NaN        NaN   \n",
       "1  https://twitter.com/_kingneal/status/115299599...      NaN        NaN   \n",
       "2  https://twitter.com/VentingBroken/status/11529...      NaN        NaN   \n",
       "3  https://twitter.com/awesome_thebest/status/115...      NaN        NaN   \n",
       "4  https://twitter.com/DrMo7oG/status/11529959555...      NaN        NaN   \n",
       "\n",
       "   video user_rt_id near geo  \n",
       "0      0        NaN  NaN NaN  \n",
       "1      0        NaN  NaN NaN  \n",
       "2      0        NaN  NaN NaN  \n",
       "3      0        NaN  NaN NaN  \n",
       "4      0        NaN  NaN NaN  \n",
       "\n",
       "[5 rows x 26 columns]"
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "suicide_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "suicide_tweets_df.drop(['date', 'timezone', 'username', 'name', 'conversation_id', 'created_at', 'user_id', 'place', 'likes_count', 'link', 'retweet', 'quote_url', 'video', 'user_rt_id', 'near', 'geo', 'mentions', 'urls', 'photos', 'replies_count', 'retweets_count'], axis = 1, inplace = True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "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>time</th>\n",
       "      <th>tweet</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>cashtags</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1152996044604682241</td>\n",
       "      <td>10:37:33</td>\n",
       "      <td>Suicide Thoughts ....</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1152995993148899329</td>\n",
       "      <td>10:37:21</td>\n",
       "      <td>If I wake up as a white person in my next life...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1152995985053900800</td>\n",
       "      <td>10:37:19</td>\n",
       "      <td>I fixed my bio (Cant add a banner because Twit...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1152995984642887683</td>\n",
       "      <td>10:37:19</td>\n",
       "      <td>Weaponizign Suicide disturbs me a lot Cardi B ...</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1152995955559620608</td>\n",
       "      <td>10:37:12</td>\n",
       "      <td>#sam harcelé par ses camarades de classe se #s...</td>\n",
       "      <td>['#sam', '#suicide']</td>\n",
       "      <td>[]</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                    id      time  \\\n",
       "0  1152996044604682241  10:37:33   \n",
       "1  1152995993148899329  10:37:21   \n",
       "2  1152995985053900800  10:37:19   \n",
       "3  1152995984642887683  10:37:19   \n",
       "4  1152995955559620608  10:37:12   \n",
       "\n",
       "                                               tweet              hashtags  \\\n",
       "0                              Suicide Thoughts ....                    []   \n",
       "1  If I wake up as a white person in my next life...                    []   \n",
       "2  I fixed my bio (Cant add a banner because Twit...                    []   \n",
       "3  Weaponizign Suicide disturbs me a lot Cardi B ...                    []   \n",
       "4  #sam harcelé par ses camarades de classe se #s...  ['#sam', '#suicide']   \n",
       "\n",
       "  cashtags  \n",
       "0       []  \n",
       "1       []  \n",
       "2       []  \n",
       "3       []  \n",
       "4       []  "
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "suicide_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/Users/anneb/anaconda3/lib/python3.7/site-packages/ipykernel_launcher.py:1: FutureWarning: Sorting because non-concatenation axis is not aligned. A future version\n",
      "of pandas will change to not sort by default.\n",
      "\n",
      "To accept the future behavior, pass 'sort=False'.\n",
      "\n",
      "To retain the current behavior and silence the warning, pass 'sort=True'.\n",
      "\n",
      "  \"\"\"Entry point for launching an IPython kernel.\n"
     ]
    },
    {
     "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>Unnamed: 0</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>id</th>\n",
       "      <th>time</th>\n",
       "      <th>tweet</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:13</td>\n",
       "      <td>Wow, my dad yday: “you don’t take those stupid...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:07</td>\n",
       "      <td>what part of this was really harmfult of a lot...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#depression', '#uncoveringthenewu', '#change...</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:06</td>\n",
       "      <td>one of the ways I got through my #depression i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:55</td>\n",
       "      <td>see i wanna do one of them but they all say th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:51</td>\n",
       "      <td>IS IT clinical depression or is it the palpabl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:46</td>\n",
       "      <td>My new mantra for dealing with my anxiety/depr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:41</td>\n",
       "      <td>Can I get a woot woot for 3 months depression ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:37</td>\n",
       "      <td>Hope it's working for you.  I was on sertralin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:22</td>\n",
       "      <td>When my depression and anxiety strike at the s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:20</td>\n",
       "      <td>I want to leave, but I'm still waiting for you...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:07</td>\n",
       "      <td>lrt i have FUCKING DEPRESSION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:07</td>\n",
       "      <td>If you’re a new mother who is tired from postp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:04</td>\n",
       "      <td>Currently 5:23 and I’ve got depression  Ranger...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:01</td>\n",
       "      <td>omg wish I could swim cause I'm gonna drown in...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:00</td>\n",
       "      <td>I don’t talk about it much at all unless you’r...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:55</td>\n",
       "      <td>🚨🚨🚨 If someone can help me by suggesting me ho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:39</td>\n",
       "      <td>luv 2 just start crying bc you're thinking of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:33</td>\n",
       "      <td>yOu cAnT hUrT mE DePrEsSiOn GoT mE AlReAdY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:32</td>\n",
       "      <td>The free market cab cure your depression, just...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:31</td>\n",
       "      <td>I’m not steeped enough in the research to have...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#triggerwarning']</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:28</td>\n",
       "      <td>I feel like I can’t work for more than two to ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:28</td>\n",
       "      <td>dvdRadio 102 Still looking for a title.  (That...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:27</td>\n",
       "      <td>Do you recommend this for every kind of depres...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:26</td>\n",
       "      <td>I was having a bad day and was all depressed. ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:25</td>\n",
       "      <td>but it completely makes sense tho it a surviva...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:23</td>\n",
       "      <td>For example a top has to know how to deal with...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:17</td>\n",
       "      <td>So. Here is the short and skinny about me here...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:12</td>\n",
       "      <td>me when someone points out my crippling anxiet...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:05</td>\n",
       "      <td>No one:  Literally no one:  Clair Boucher/ム尺ﾉﾶ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:22:52</td>\n",
       "      <td>As a platoon leader I have to deal with that m...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225147</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368125251338242</td>\n",
       "      <td>17:02:25</td>\n",
       "      <td>Suicide by oyster is a noble way to go  https:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225148</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368121723965440</td>\n",
       "      <td>17:02:24</td>\n",
       "      <td>floors are covered in water, so obviously a cl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225149</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368089264205825</td>\n",
       "      <td>17:02:17</td>\n",
       "      <td>That's a depressingly relatable perspective.  ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225150</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368083346120705</td>\n",
       "      <td>17:02:15</td>\n",
       "      <td>@glitterndior https://twitter.com/DankNeme/sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225151</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368075833872384</td>\n",
       "      <td>17:02:13</td>\n",
       "      <td>TW for suicide and fatphobia.  My mom has seve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225152</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368031642869762</td>\n",
       "      <td>17:02:03</td>\n",
       "      <td>« Le professeur meurt et Tokyo se suicide » jl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225153</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368026013982720</td>\n",
       "      <td>17:02:02</td>\n",
       "      <td>Telling a gay youth is choices are suicide, ex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225154</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368025192058880</td>\n",
       "      <td>17:02:01</td>\n",
       "      <td>Tokyo tue professor et se suicide</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225155</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368018585980928</td>\n",
       "      <td>17:02:00</td>\n",
       "      <td>suicide's time :))</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225156</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368009643798528</td>\n",
       "      <td>17:01:58</td>\n",
       "      <td>For Those Considering Suicide  https://youtu.b...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225157</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367994976309248</td>\n",
       "      <td>17:01:54</td>\n",
       "      <td>Tf suicide isn’t no joke  https://twitter.com/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225158</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367988194123776</td>\n",
       "      <td>17:01:53</td>\n",
       "      <td>It always brings to mind the “body in the bag ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225159</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#suicidesilence', '#youonlyliveonce', '#lege...</td>\n",
       "      <td>1152367958796062721</td>\n",
       "      <td>17:01:45</td>\n",
       "      <td>You only live once so just go fucking nuts!Go!...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225160</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367936046346241</td>\n",
       "      <td>17:01:40</td>\n",
       "      <td>i cant wait to entrap a woman into a web of vi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225161</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367856283029506</td>\n",
       "      <td>17:01:21</td>\n",
       "      <td>고마웠었어 #€</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225162</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367827321544707</td>\n",
       "      <td>17:01:14</td>\n",
       "      <td>The “Clinton Suicide Squad “ is gearing up as ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225163</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367826348531712</td>\n",
       "      <td>17:01:14</td>\n",
       "      <td>Last Monday a I had to tell a client his benef...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225164</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367802705174528</td>\n",
       "      <td>17:01:08</td>\n",
       "      <td>http://bit.ly/MurderOfTalent  Why is the publ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225165</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367775291019264</td>\n",
       "      <td>17:01:02</td>\n",
       "      <td>戸塚：電車の車内でケータイが鳴った一八木さんが「いま電話の中だから電車切るぞ」って言ってケー...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225166</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367743833923584</td>\n",
       "      <td>17:00:54</td>\n",
       "      <td>y'a pas d'incruste ti é la famille</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225167</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#mentalhealth', '#suicideprevention']</td>\n",
       "      <td>1152367735445131264</td>\n",
       "      <td>17:00:52</td>\n",
       "      <td>A study will use CCTV from certain locations t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225168</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367689433636866</td>\n",
       "      <td>17:00:41</td>\n",
       "      <td>Since I was reminded of her today, everyone pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225169</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367664192471040</td>\n",
       "      <td>17:00:35</td>\n",
       "      <td>Mariko was a quick favorite for me. I'm glad s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225170</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367606919237635</td>\n",
       "      <td>17:00:22</td>\n",
       "      <td>pic.twitter.com/sm9tNmrEQJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225171</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367589961732096</td>\n",
       "      <td>17:00:18</td>\n",
       "      <td>https://youtu.be/WJ0OkkIDZug   Deathnote is r...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225172</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367589030391809</td>\n",
       "      <td>17:00:17</td>\n",
       "      <td>えっ？！オニィ結構なお歳……（今知った） 変な声でちゃった(笑)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225173</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#physicianfriday', '#suicide', '#physicians'...</td>\n",
       "      <td>1152367565483761664</td>\n",
       "      <td>17:00:12</td>\n",
       "      <td>#PhysicianFriday \"Let's empower doctors to tak...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225174</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#aztrauma', '#traumatraining', '#suicide', '...</td>\n",
       "      <td>1152367519283367936</td>\n",
       "      <td>17:00:01</td>\n",
       "      <td>A spike in suicides among teenage boys in the ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225175</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367516083204096</td>\n",
       "      <td>17:00:00</td>\n",
       "      <td>Need some support? Check out the following res...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225176</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367515978424321</td>\n",
       "      <td>17:00:00</td>\n",
       "      <td>You can improve the quality of life for a frie...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>225177 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 cashtags                                           hashtags  \\\n",
       "0               0       []                                                 []   \n",
       "1               1       []                                                 []   \n",
       "2               2       []  ['#depression', '#uncoveringthenewu', '#change...   \n",
       "3               3       []                                                 []   \n",
       "4               4       []                                                 []   \n",
       "5               5       []                                                 []   \n",
       "6               6       []                                                 []   \n",
       "7               7       []                                                 []   \n",
       "8               8       []                                                 []   \n",
       "9               9       []                                                 []   \n",
       "10             10       []                                                 []   \n",
       "11             11       []                                                 []   \n",
       "12             12       []                                                 []   \n",
       "13             13       []                                                 []   \n",
       "14             14       []                                                 []   \n",
       "15             15       []                                                 []   \n",
       "16             16       []                                                 []   \n",
       "17             17       []                                                 []   \n",
       "18             18       []                                                 []   \n",
       "19             19       []                                                 []   \n",
       "20             20       []                                ['#triggerwarning']   \n",
       "21             21       []                                                 []   \n",
       "22             22       []                                                 []   \n",
       "23             23       []                                                 []   \n",
       "24             24       []                                                 []   \n",
       "25             25       []                                                 []   \n",
       "26             26       []                                                 []   \n",
       "27             27       []                                                 []   \n",
       "28             28       []                                                 []   \n",
       "29             29       []                                                 []   \n",
       "...           ...      ...                                                ...   \n",
       "225147        NaN       []                                                 []   \n",
       "225148        NaN       []                                                 []   \n",
       "225149        NaN       []                                                 []   \n",
       "225150        NaN       []                                                 []   \n",
       "225151        NaN       []                                                 []   \n",
       "225152        NaN       []                                                 []   \n",
       "225153        NaN       []                                                 []   \n",
       "225154        NaN       []                                                 []   \n",
       "225155        NaN       []                                                 []   \n",
       "225156        NaN       []                                                 []   \n",
       "225157        NaN       []                                                 []   \n",
       "225158        NaN       []                                                 []   \n",
       "225159        NaN       []  ['#suicidesilence', '#youonlyliveonce', '#lege...   \n",
       "225160        NaN       []                                                 []   \n",
       "225161        NaN       []                                                 []   \n",
       "225162        NaN       []                                                 []   \n",
       "225163        NaN       []                                                 []   \n",
       "225164        NaN       []                                                 []   \n",
       "225165        NaN       []                                                 []   \n",
       "225166        NaN       []                                                 []   \n",
       "225167        NaN       []            ['#mentalhealth', '#suicideprevention']   \n",
       "225168        NaN       []                                                 []   \n",
       "225169        NaN       []                                                 []   \n",
       "225170        NaN       []                                                 []   \n",
       "225171        NaN       []                                                 []   \n",
       "225172        NaN       []                                                 []   \n",
       "225173        NaN       []  ['#physicianfriday', '#suicide', '#physicians'...   \n",
       "225174        NaN       []  ['#aztrauma', '#traumatraining', '#suicide', '...   \n",
       "225175        NaN       []                                                 []   \n",
       "225176        NaN       []                                                 []   \n",
       "\n",
       "                         id      time  \\\n",
       "0               1.15135E+18  21:25:13   \n",
       "1               1.15135E+18  21:25:07   \n",
       "2               1.15135E+18  21:25:06   \n",
       "3               1.15135E+18  21:24:55   \n",
       "4               1.15135E+18  21:24:51   \n",
       "5               1.15135E+18  21:24:46   \n",
       "6               1.15135E+18  21:24:41   \n",
       "7               1.15135E+18  21:24:37   \n",
       "8               1.15135E+18  21:24:22   \n",
       "9               1.15135E+18  21:24:20   \n",
       "10              1.15135E+18  21:24:07   \n",
       "11              1.15135E+18  21:24:07   \n",
       "12              1.15135E+18  21:24:04   \n",
       "13              1.15135E+18  21:24:01   \n",
       "14              1.15135E+18  21:24:00   \n",
       "15              1.15135E+18  21:23:55   \n",
       "16              1.15135E+18  21:23:39   \n",
       "17              1.15135E+18  21:23:33   \n",
       "18              1.15135E+18  21:23:32   \n",
       "19              1.15135E+18  21:23:31   \n",
       "20              1.15135E+18  21:23:28   \n",
       "21              1.15135E+18  21:23:28   \n",
       "22              1.15135E+18  21:23:27   \n",
       "23              1.15135E+18  21:23:26   \n",
       "24              1.15135E+18  21:23:25   \n",
       "25              1.15135E+18  21:23:23   \n",
       "26              1.15135E+18  21:23:17   \n",
       "27              1.15135E+18  21:23:12   \n",
       "28              1.15135E+18  21:23:05   \n",
       "29              1.15135E+18  21:22:52   \n",
       "...                     ...       ...   \n",
       "225147  1152368125251338242  17:02:25   \n",
       "225148  1152368121723965440  17:02:24   \n",
       "225149  1152368089264205825  17:02:17   \n",
       "225150  1152368083346120705  17:02:15   \n",
       "225151  1152368075833872384  17:02:13   \n",
       "225152  1152368031642869762  17:02:03   \n",
       "225153  1152368026013982720  17:02:02   \n",
       "225154  1152368025192058880  17:02:01   \n",
       "225155  1152368018585980928  17:02:00   \n",
       "225156  1152368009643798528  17:01:58   \n",
       "225157  1152367994976309248  17:01:54   \n",
       "225158  1152367988194123776  17:01:53   \n",
       "225159  1152367958796062721  17:01:45   \n",
       "225160  1152367936046346241  17:01:40   \n",
       "225161  1152367856283029506  17:01:21   \n",
       "225162  1152367827321544707  17:01:14   \n",
       "225163  1152367826348531712  17:01:14   \n",
       "225164  1152367802705174528  17:01:08   \n",
       "225165  1152367775291019264  17:01:02   \n",
       "225166  1152367743833923584  17:00:54   \n",
       "225167  1152367735445131264  17:00:52   \n",
       "225168  1152367689433636866  17:00:41   \n",
       "225169  1152367664192471040  17:00:35   \n",
       "225170  1152367606919237635  17:00:22   \n",
       "225171  1152367589961732096  17:00:18   \n",
       "225172  1152367589030391809  17:00:17   \n",
       "225173  1152367565483761664  17:00:12   \n",
       "225174  1152367519283367936  17:00:01   \n",
       "225175  1152367516083204096  17:00:00   \n",
       "225176  1152367515978424321  17:00:00   \n",
       "\n",
       "                                                    tweet  \n",
       "0       Wow, my dad yday: “you don’t take those stupid...  \n",
       "1       what part of this was really harmfult of a lot...  \n",
       "2       one of the ways I got through my #depression i...  \n",
       "3       see i wanna do one of them but they all say th...  \n",
       "4       IS IT clinical depression or is it the palpabl...  \n",
       "5       My new mantra for dealing with my anxiety/depr...  \n",
       "6       Can I get a woot woot for 3 months depression ...  \n",
       "7       Hope it's working for you.  I was on sertralin...  \n",
       "8       When my depression and anxiety strike at the s...  \n",
       "9       I want to leave, but I'm still waiting for you...  \n",
       "10                          lrt i have FUCKING DEPRESSION  \n",
       "11      If you’re a new mother who is tired from postp...  \n",
       "12      Currently 5:23 and I’ve got depression  Ranger...  \n",
       "13      omg wish I could swim cause I'm gonna drown in...  \n",
       "14      I don’t talk about it much at all unless you’r...  \n",
       "15      🚨🚨🚨 If someone can help me by suggesting me ho...  \n",
       "16      luv 2 just start crying bc you're thinking of ...  \n",
       "17             yOu cAnT hUrT mE DePrEsSiOn GoT mE AlReAdY  \n",
       "18      The free market cab cure your depression, just...  \n",
       "19      I’m not steeped enough in the research to have...  \n",
       "20      I feel like I can’t work for more than two to ...  \n",
       "21      dvdRadio 102 Still looking for a title.  (That...  \n",
       "22      Do you recommend this for every kind of depres...  \n",
       "23      I was having a bad day and was all depressed. ...  \n",
       "24      but it completely makes sense tho it a surviva...  \n",
       "25      For example a top has to know how to deal with...  \n",
       "26      So. Here is the short and skinny about me here...  \n",
       "27      me when someone points out my crippling anxiet...  \n",
       "28      No one:  Literally no one:  Clair Boucher/ム尺ﾉﾶ...  \n",
       "29      As a platoon leader I have to deal with that m...  \n",
       "...                                                   ...  \n",
       "225147  Suicide by oyster is a noble way to go  https:...  \n",
       "225148  floors are covered in water, so obviously a cl...  \n",
       "225149  That's a depressingly relatable perspective.  ...  \n",
       "225150  @glitterndior https://twitter.com/DankNeme/sta...  \n",
       "225151  TW for suicide and fatphobia.  My mom has seve...  \n",
       "225152  « Le professeur meurt et Tokyo se suicide » jl...  \n",
       "225153  Telling a gay youth is choices are suicide, ex...  \n",
       "225154                  Tokyo tue professor et se suicide  \n",
       "225155                                 suicide's time :))  \n",
       "225156  For Those Considering Suicide  https://youtu.b...  \n",
       "225157  Tf suicide isn’t no joke  https://twitter.com/...  \n",
       "225158  It always brings to mind the “body in the bag ...  \n",
       "225159  You only live once so just go fucking nuts!Go!...  \n",
       "225160  i cant wait to entrap a woman into a web of vi...  \n",
       "225161                                           고마웠었어 #€  \n",
       "225162  The “Clinton Suicide Squad “ is gearing up as ...  \n",
       "225163  Last Monday a I had to tell a client his benef...  \n",
       "225164   http://bit.ly/MurderOfTalent  Why is the publ...  \n",
       "225165  戸塚：電車の車内でケータイが鳴った一八木さんが「いま電話の中だから電車切るぞ」って言ってケー...  \n",
       "225166                 y'a pas d'incruste ti é la famille  \n",
       "225167  A study will use CCTV from certain locations t...  \n",
       "225168  Since I was reminded of her today, everyone pl...  \n",
       "225169  Mariko was a quick favorite for me. I'm glad s...  \n",
       "225170                         pic.twitter.com/sm9tNmrEQJ  \n",
       "225171   https://youtu.be/WJ0OkkIDZug   Deathnote is r...  \n",
       "225172                   えっ？！オニィ結構なお歳……（今知った） 変な声でちゃった(笑)  \n",
       "225173  #PhysicianFriday \"Let's empower doctors to tak...  \n",
       "225174  A spike in suicides among teenage boys in the ...  \n",
       "225175  Need some support? Check out the following res...  \n",
       "225176  You can improve the quality of life for a frie...  \n",
       "\n",
       "[225177 rows x 6 columns]"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_row_reindex = pd.concat([depression_tweets_df, hopeless_tweets_df, lonely_tweets_df, antidepressant_tweets_df, antidepressants_tweets_df, suicide_tweets_df], ignore_index=True)\n",
    "\n",
    "df_row_reindex"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "metadata": {},
   "outputs": [],
   "source": [
    "df = df_row_reindex"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 42,
   "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>Unnamed: 0</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>id</th>\n",
       "      <th>time</th>\n",
       "      <th>tweet</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:13</td>\n",
       "      <td>Wow, my dad yday: “you don’t take those stupid...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:07</td>\n",
       "      <td>what part of this was really harmfult of a lot...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#depression', '#uncoveringthenewu', '#change...</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:06</td>\n",
       "      <td>one of the ways I got through my #depression i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:55</td>\n",
       "      <td>see i wanna do one of them but they all say th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:51</td>\n",
       "      <td>IS IT clinical depression or is it the palpabl...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  Unnamed: 0 cashtags                                           hashtags  \\\n",
       "0          0       []                                                 []   \n",
       "1          1       []                                                 []   \n",
       "2          2       []  ['#depression', '#uncoveringthenewu', '#change...   \n",
       "3          3       []                                                 []   \n",
       "4          4       []                                                 []   \n",
       "\n",
       "            id      time                                              tweet  \n",
       "0  1.15135E+18  21:25:13  Wow, my dad yday: “you don’t take those stupid...  \n",
       "1  1.15135E+18  21:25:07  what part of this was really harmfult of a lot...  \n",
       "2  1.15135E+18  21:25:06  one of the ways I got through my #depression i...  \n",
       "3  1.15135E+18  21:24:55  see i wanna do one of them but they all say th...  \n",
       "4  1.15135E+18  21:24:51  IS IT clinical depression or is it the palpabl...  "
      ]
     },
     "execution_count": 42,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "depressive_twint_tweets_df = df_row_reindex\n",
    "depressive_twint_tweets_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 44,
   "metadata": {},
   "outputs": [],
   "source": [
    "depressive_twint_tweets_df = df.drop_duplicates()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 48,
   "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>Unnamed: 0</th>\n",
       "      <th>cashtags</th>\n",
       "      <th>hashtags</th>\n",
       "      <th>id</th>\n",
       "      <th>time</th>\n",
       "      <th>tweet</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:13</td>\n",
       "      <td>Wow, my dad yday: “you don’t take those stupid...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:07</td>\n",
       "      <td>what part of this was really harmfult of a lot...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#depression', '#uncoveringthenewu', '#change...</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:25:06</td>\n",
       "      <td>one of the ways I got through my #depression i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:55</td>\n",
       "      <td>see i wanna do one of them but they all say th...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:51</td>\n",
       "      <td>IS IT clinical depression or is it the palpabl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:46</td>\n",
       "      <td>My new mantra for dealing with my anxiety/depr...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>6</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:41</td>\n",
       "      <td>Can I get a woot woot for 3 months depression ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>7</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:37</td>\n",
       "      <td>Hope it's working for you.  I was on sertralin...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>8</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:22</td>\n",
       "      <td>When my depression and anxiety strike at the s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>9</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:20</td>\n",
       "      <td>I want to leave, but I'm still waiting for you...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>10</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:07</td>\n",
       "      <td>lrt i have FUCKING DEPRESSION</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>11</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:07</td>\n",
       "      <td>If you’re a new mother who is tired from postp...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>12</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:04</td>\n",
       "      <td>Currently 5:23 and I’ve got depression  Ranger...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>13</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:01</td>\n",
       "      <td>omg wish I could swim cause I'm gonna drown in...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>14</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:24:00</td>\n",
       "      <td>I don’t talk about it much at all unless you’r...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>15</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:55</td>\n",
       "      <td>🚨🚨🚨 If someone can help me by suggesting me ho...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>16</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:39</td>\n",
       "      <td>luv 2 just start crying bc you're thinking of ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>17</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:33</td>\n",
       "      <td>yOu cAnT hUrT mE DePrEsSiOn GoT mE AlReAdY</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>18</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:32</td>\n",
       "      <td>The free market cab cure your depression, just...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>19</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:31</td>\n",
       "      <td>I’m not steeped enough in the research to have...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>20</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#triggerwarning']</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:28</td>\n",
       "      <td>I feel like I can’t work for more than two to ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>21</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:28</td>\n",
       "      <td>dvdRadio 102 Still looking for a title.  (That...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>22</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:27</td>\n",
       "      <td>Do you recommend this for every kind of depres...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>23</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:26</td>\n",
       "      <td>I was having a bad day and was all depressed. ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>24</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:25</td>\n",
       "      <td>but it completely makes sense tho it a surviva...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>25</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:23</td>\n",
       "      <td>For example a top has to know how to deal with...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>26</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:17</td>\n",
       "      <td>So. Here is the short and skinny about me here...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>27</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:12</td>\n",
       "      <td>me when someone points out my crippling anxiet...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>28</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:23:05</td>\n",
       "      <td>No one:  Literally no one:  Clair Boucher/ム尺ﾉﾶ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>29</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.15135E+18</td>\n",
       "      <td>21:22:52</td>\n",
       "      <td>As a platoon leader I have to deal with that m...</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225147</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368125251338242</td>\n",
       "      <td>17:02:25</td>\n",
       "      <td>Suicide by oyster is a noble way to go  https:...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225148</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368121723965440</td>\n",
       "      <td>17:02:24</td>\n",
       "      <td>floors are covered in water, so obviously a cl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225149</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368089264205825</td>\n",
       "      <td>17:02:17</td>\n",
       "      <td>That's a depressingly relatable perspective.  ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225150</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368083346120705</td>\n",
       "      <td>17:02:15</td>\n",
       "      <td>@glitterndior https://twitter.com/DankNeme/sta...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225151</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368075833872384</td>\n",
       "      <td>17:02:13</td>\n",
       "      <td>TW for suicide and fatphobia.  My mom has seve...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225152</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368031642869762</td>\n",
       "      <td>17:02:03</td>\n",
       "      <td>« Le professeur meurt et Tokyo se suicide » jl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225153</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368026013982720</td>\n",
       "      <td>17:02:02</td>\n",
       "      <td>Telling a gay youth is choices are suicide, ex...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225154</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368025192058880</td>\n",
       "      <td>17:02:01</td>\n",
       "      <td>Tokyo tue professor et se suicide</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225155</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368018585980928</td>\n",
       "      <td>17:02:00</td>\n",
       "      <td>suicide's time :))</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225156</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152368009643798528</td>\n",
       "      <td>17:01:58</td>\n",
       "      <td>For Those Considering Suicide  https://youtu.b...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225157</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367994976309248</td>\n",
       "      <td>17:01:54</td>\n",
       "      <td>Tf suicide isn’t no joke  https://twitter.com/...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225158</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367988194123776</td>\n",
       "      <td>17:01:53</td>\n",
       "      <td>It always brings to mind the “body in the bag ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225159</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#suicidesilence', '#youonlyliveonce', '#lege...</td>\n",
       "      <td>1152367958796062721</td>\n",
       "      <td>17:01:45</td>\n",
       "      <td>You only live once so just go fucking nuts!Go!...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225160</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367936046346241</td>\n",
       "      <td>17:01:40</td>\n",
       "      <td>i cant wait to entrap a woman into a web of vi...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225161</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367856283029506</td>\n",
       "      <td>17:01:21</td>\n",
       "      <td>고마웠었어 #€</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225162</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367827321544707</td>\n",
       "      <td>17:01:14</td>\n",
       "      <td>The “Clinton Suicide Squad “ is gearing up as ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225163</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367826348531712</td>\n",
       "      <td>17:01:14</td>\n",
       "      <td>Last Monday a I had to tell a client his benef...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225164</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367802705174528</td>\n",
       "      <td>17:01:08</td>\n",
       "      <td>http://bit.ly/MurderOfTalent  Why is the publ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225165</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367775291019264</td>\n",
       "      <td>17:01:02</td>\n",
       "      <td>戸塚：電車の車内でケータイが鳴った一八木さんが「いま電話の中だから電車切るぞ」って言ってケー...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225166</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367743833923584</td>\n",
       "      <td>17:00:54</td>\n",
       "      <td>y'a pas d'incruste ti é la famille</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225167</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#mentalhealth', '#suicideprevention']</td>\n",
       "      <td>1152367735445131264</td>\n",
       "      <td>17:00:52</td>\n",
       "      <td>A study will use CCTV from certain locations t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225168</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367689433636866</td>\n",
       "      <td>17:00:41</td>\n",
       "      <td>Since I was reminded of her today, everyone pl...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225169</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367664192471040</td>\n",
       "      <td>17:00:35</td>\n",
       "      <td>Mariko was a quick favorite for me. I'm glad s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225170</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367606919237635</td>\n",
       "      <td>17:00:22</td>\n",
       "      <td>pic.twitter.com/sm9tNmrEQJ</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225171</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367589961732096</td>\n",
       "      <td>17:00:18</td>\n",
       "      <td>https://youtu.be/WJ0OkkIDZug   Deathnote is r...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225172</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367589030391809</td>\n",
       "      <td>17:00:17</td>\n",
       "      <td>えっ？！オニィ結構なお歳……（今知った） 変な声でちゃった(笑)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225173</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#physicianfriday', '#suicide', '#physicians'...</td>\n",
       "      <td>1152367565483761664</td>\n",
       "      <td>17:00:12</td>\n",
       "      <td>#PhysicianFriday \"Let's empower doctors to tak...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225174</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>['#aztrauma', '#traumatraining', '#suicide', '...</td>\n",
       "      <td>1152367519283367936</td>\n",
       "      <td>17:00:01</td>\n",
       "      <td>A spike in suicides among teenage boys in the ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225175</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367516083204096</td>\n",
       "      <td>17:00:00</td>\n",
       "      <td>Need some support? Check out the following res...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>225176</th>\n",
       "      <td>NaN</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>1152367515978424321</td>\n",
       "      <td>17:00:00</td>\n",
       "      <td>You can improve the quality of life for a frie...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>224273 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0 cashtags                                           hashtags  \\\n",
       "0               0       []                                                 []   \n",
       "1               1       []                                                 []   \n",
       "2               2       []  ['#depression', '#uncoveringthenewu', '#change...   \n",
       "3               3       []                                                 []   \n",
       "4               4       []                                                 []   \n",
       "5               5       []                                                 []   \n",
       "6               6       []                                                 []   \n",
       "7               7       []                                                 []   \n",
       "8               8       []                                                 []   \n",
       "9               9       []                                                 []   \n",
       "10             10       []                                                 []   \n",
       "11             11       []                                                 []   \n",
       "12             12       []                                                 []   \n",
       "13             13       []                                                 []   \n",
       "14             14       []                                                 []   \n",
       "15             15       []                                                 []   \n",
       "16             16       []                                                 []   \n",
       "17             17       []                                                 []   \n",
       "18             18       []                                                 []   \n",
       "19             19       []                                                 []   \n",
       "20             20       []                                ['#triggerwarning']   \n",
       "21             21       []                                                 []   \n",
       "22             22       []                                                 []   \n",
       "23             23       []                                                 []   \n",
       "24             24       []                                                 []   \n",
       "25             25       []                                                 []   \n",
       "26             26       []                                                 []   \n",
       "27             27       []                                                 []   \n",
       "28             28       []                                                 []   \n",
       "29             29       []                                                 []   \n",
       "...           ...      ...                                                ...   \n",
       "225147        NaN       []                                                 []   \n",
       "225148        NaN       []                                                 []   \n",
       "225149        NaN       []                                                 []   \n",
       "225150        NaN       []                                                 []   \n",
       "225151        NaN       []                                                 []   \n",
       "225152        NaN       []                                                 []   \n",
       "225153        NaN       []                                                 []   \n",
       "225154        NaN       []                                                 []   \n",
       "225155        NaN       []                                                 []   \n",
       "225156        NaN       []                                                 []   \n",
       "225157        NaN       []                                                 []   \n",
       "225158        NaN       []                                                 []   \n",
       "225159        NaN       []  ['#suicidesilence', '#youonlyliveonce', '#lege...   \n",
       "225160        NaN       []                                                 []   \n",
       "225161        NaN       []                                                 []   \n",
       "225162        NaN       []                                                 []   \n",
       "225163        NaN       []                                                 []   \n",
       "225164        NaN       []                                                 []   \n",
       "225165        NaN       []                                                 []   \n",
       "225166        NaN       []                                                 []   \n",
       "225167        NaN       []            ['#mentalhealth', '#suicideprevention']   \n",
       "225168        NaN       []                                                 []   \n",
       "225169        NaN       []                                                 []   \n",
       "225170        NaN       []                                                 []   \n",
       "225171        NaN       []                                                 []   \n",
       "225172        NaN       []                                                 []   \n",
       "225173        NaN       []  ['#physicianfriday', '#suicide', '#physicians'...   \n",
       "225174        NaN       []  ['#aztrauma', '#traumatraining', '#suicide', '...   \n",
       "225175        NaN       []                                                 []   \n",
       "225176        NaN       []                                                 []   \n",
       "\n",
       "                         id      time  \\\n",
       "0               1.15135E+18  21:25:13   \n",
       "1               1.15135E+18  21:25:07   \n",
       "2               1.15135E+18  21:25:06   \n",
       "3               1.15135E+18  21:24:55   \n",
       "4               1.15135E+18  21:24:51   \n",
       "5               1.15135E+18  21:24:46   \n",
       "6               1.15135E+18  21:24:41   \n",
       "7               1.15135E+18  21:24:37   \n",
       "8               1.15135E+18  21:24:22   \n",
       "9               1.15135E+18  21:24:20   \n",
       "10              1.15135E+18  21:24:07   \n",
       "11              1.15135E+18  21:24:07   \n",
       "12              1.15135E+18  21:24:04   \n",
       "13              1.15135E+18  21:24:01   \n",
       "14              1.15135E+18  21:24:00   \n",
       "15              1.15135E+18  21:23:55   \n",
       "16              1.15135E+18  21:23:39   \n",
       "17              1.15135E+18  21:23:33   \n",
       "18              1.15135E+18  21:23:32   \n",
       "19              1.15135E+18  21:23:31   \n",
       "20              1.15135E+18  21:23:28   \n",
       "21              1.15135E+18  21:23:28   \n",
       "22              1.15135E+18  21:23:27   \n",
       "23              1.15135E+18  21:23:26   \n",
       "24              1.15135E+18  21:23:25   \n",
       "25              1.15135E+18  21:23:23   \n",
       "26              1.15135E+18  21:23:17   \n",
       "27              1.15135E+18  21:23:12   \n",
       "28              1.15135E+18  21:23:05   \n",
       "29              1.15135E+18  21:22:52   \n",
       "...                     ...       ...   \n",
       "225147  1152368125251338242  17:02:25   \n",
       "225148  1152368121723965440  17:02:24   \n",
       "225149  1152368089264205825  17:02:17   \n",
       "225150  1152368083346120705  17:02:15   \n",
       "225151  1152368075833872384  17:02:13   \n",
       "225152  1152368031642869762  17:02:03   \n",
       "225153  1152368026013982720  17:02:02   \n",
       "225154  1152368025192058880  17:02:01   \n",
       "225155  1152368018585980928  17:02:00   \n",
       "225156  1152368009643798528  17:01:58   \n",
       "225157  1152367994976309248  17:01:54   \n",
       "225158  1152367988194123776  17:01:53   \n",
       "225159  1152367958796062721  17:01:45   \n",
       "225160  1152367936046346241  17:01:40   \n",
       "225161  1152367856283029506  17:01:21   \n",
       "225162  1152367827321544707  17:01:14   \n",
       "225163  1152367826348531712  17:01:14   \n",
       "225164  1152367802705174528  17:01:08   \n",
       "225165  1152367775291019264  17:01:02   \n",
       "225166  1152367743833923584  17:00:54   \n",
       "225167  1152367735445131264  17:00:52   \n",
       "225168  1152367689433636866  17:00:41   \n",
       "225169  1152367664192471040  17:00:35   \n",
       "225170  1152367606919237635  17:00:22   \n",
       "225171  1152367589961732096  17:00:18   \n",
       "225172  1152367589030391809  17:00:17   \n",
       "225173  1152367565483761664  17:00:12   \n",
       "225174  1152367519283367936  17:00:01   \n",
       "225175  1152367516083204096  17:00:00   \n",
       "225176  1152367515978424321  17:00:00   \n",
       "\n",
       "                                                    tweet  \n",
       "0       Wow, my dad yday: “you don’t take those stupid...  \n",
       "1       what part of this was really harmfult of a lot...  \n",
       "2       one of the ways I got through my #depression i...  \n",
       "3       see i wanna do one of them but they all say th...  \n",
       "4       IS IT clinical depression or is it the palpabl...  \n",
       "5       My new mantra for dealing with my anxiety/depr...  \n",
       "6       Can I get a woot woot for 3 months depression ...  \n",
       "7       Hope it's working for you.  I was on sertralin...  \n",
       "8       When my depression and anxiety strike at the s...  \n",
       "9       I want to leave, but I'm still waiting for you...  \n",
       "10                          lrt i have FUCKING DEPRESSION  \n",
       "11      If you’re a new mother who is tired from postp...  \n",
       "12      Currently 5:23 and I’ve got depression  Ranger...  \n",
       "13      omg wish I could swim cause I'm gonna drown in...  \n",
       "14      I don’t talk about it much at all unless you’r...  \n",
       "15      🚨🚨🚨 If someone can help me by suggesting me ho...  \n",
       "16      luv 2 just start crying bc you're thinking of ...  \n",
       "17             yOu cAnT hUrT mE DePrEsSiOn GoT mE AlReAdY  \n",
       "18      The free market cab cure your depression, just...  \n",
       "19      I’m not steeped enough in the research to have...  \n",
       "20      I feel like I can’t work for more than two to ...  \n",
       "21      dvdRadio 102 Still looking for a title.  (That...  \n",
       "22      Do you recommend this for every kind of depres...  \n",
       "23      I was having a bad day and was all depressed. ...  \n",
       "24      but it completely makes sense tho it a surviva...  \n",
       "25      For example a top has to know how to deal with...  \n",
       "26      So. Here is the short and skinny about me here...  \n",
       "27      me when someone points out my crippling anxiet...  \n",
       "28      No one:  Literally no one:  Clair Boucher/ム尺ﾉﾶ...  \n",
       "29      As a platoon leader I have to deal with that m...  \n",
       "...                                                   ...  \n",
       "225147  Suicide by oyster is a noble way to go  https:...  \n",
       "225148  floors are covered in water, so obviously a cl...  \n",
       "225149  That's a depressingly relatable perspective.  ...  \n",
       "225150  @glitterndior https://twitter.com/DankNeme/sta...  \n",
       "225151  TW for suicide and fatphobia.  My mom has seve...  \n",
       "225152  « Le professeur meurt et Tokyo se suicide » jl...  \n",
       "225153  Telling a gay youth is choices are suicide, ex...  \n",
       "225154                  Tokyo tue professor et se suicide  \n",
       "225155                                 suicide's time :))  \n",
       "225156  For Those Considering Suicide  https://youtu.b...  \n",
       "225157  Tf suicide isn’t no joke  https://twitter.com/...  \n",
       "225158  It always brings to mind the “body in the bag ...  \n",
       "225159  You only live once so just go fucking nuts!Go!...  \n",
       "225160  i cant wait to entrap a woman into a web of vi...  \n",
       "225161                                           고마웠었어 #€  \n",
       "225162  The “Clinton Suicide Squad “ is gearing up as ...  \n",
       "225163  Last Monday a I had to tell a client his benef...  \n",
       "225164   http://bit.ly/MurderOfTalent  Why is the publ...  \n",
       "225165  戸塚：電車の車内でケータイが鳴った一八木さんが「いま電話の中だから電車切るぞ」って言ってケー...  \n",
       "225166                 y'a pas d'incruste ti é la famille  \n",
       "225167  A study will use CCTV from certain locations t...  \n",
       "225168  Since I was reminded of her today, everyone pl...  \n",
       "225169  Mariko was a quick favorite for me. I'm glad s...  \n",
       "225170                         pic.twitter.com/sm9tNmrEQJ  \n",
       "225171   https://youtu.be/WJ0OkkIDZug   Deathnote is r...  \n",
       "225172                   えっ？！オニィ結構なお歳……（今知った） 変な声でちゃった(笑)  \n",
       "225173  #PhysicianFriday \"Let's empower doctors to tak...  \n",
       "225174  A spike in suicides among teenage boys in the ...  \n",
       "225175  Need some support? Check out the following res...  \n",
       "225176  You can improve the quality of life for a frie...  \n",
       "\n",
       "[224273 rows x 6 columns]"
      ]
     },
     "execution_count": 48,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "depressive_twint_tweets_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "metadata": {},
   "outputs": [],
   "source": [
    "export_csv = depressive_twint_tweets_df.to_csv(r'depressive_unigram_tweets_final.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "name": "Python 3.8.3 64-bit ('base': conda)",
   "display_name": "Python 3.8.3 64-bit ('base': conda)",
   "metadata": {
    "interpreter": {
     "hash": "49e8b44c8c86fbe7b3f3589e64730502565b20435433ce44148baa614a6d2e5f"
    }
   }
  },
  "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.8.3-final"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}