analysis_type4.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# This page gives a new method of dataframe separation for `positive` and `negative` tweets based on `negative-words2.exd` file."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd \n",
    "import glob\n",
    "import os"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Compiled tweets can also be procured from processed2/tweets2.csv"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdin",
     "output_type": "stream",
     "text": [
      "Enter the path for raw data file:  /media/ambijat/Datrat/ipytoneeee/CNUS\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['/media/ambijat/Datrat/ipytoneeee/CNUS/datewise/tweet01062020.csv', '/media/ambijat/Datrat/ipytoneeee/CNUS/datewise/tweet02062020.csv', '/media/ambijat/Datrat/ipytoneeee/CNUS/datewise/tweet03062020.csv']\n"
     ]
    }
   ],
   "source": [
    "process_path = input(\"Enter the path for raw data file: \")\n",
    "all_files = []\n",
    "all_files = glob.glob(process_path + \"/datewise/\" + \"*.csv\")\n",
    "print(list(all_files))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user</th>\n",
       "      <th>reuser</th>\n",
       "      <th>full_text</th>\n",
       "      <th>range</th>\n",
       "      <th>created_at</th>\n",
       "      <th>id</th>\n",
       "      <th>in_reply_to_user_id</th>\n",
       "      <th>user.location</th>\n",
       "      <th>date</th>\n",
       "      <th>date2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>namjoonayo</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>Mon Jun 01 23:59:57 +0000 2020</td>\n",
       "      <td>1267606846824542200</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-06-01 23:59:57+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ngdasokau</td>\n",
       "      <td>BarrySheerman</td>\n",
       "      <td>RT @BarrySheerman: Will the Johnson Government...</td>\n",
       "      <td>140</td>\n",
       "      <td>Mon Jun 01 23:59:57 +0000 2020</td>\n",
       "      <td>1267606845763367000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>2020-06-01 23:59:57+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>geoffreypcdog</td>\n",
       "      <td>benedictrogers</td>\n",
       "      <td>RT @benedictrogers: Seven former foreign secre...</td>\n",
       "      <td>140</td>\n",
       "      <td>Mon Jun 01 23:59:57 +0000 2020</td>\n",
       "      <td>1267606843322331100</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-06-01 23:59:57+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Marisa15061974</td>\n",
       "      <td>WDVL4</td>\n",
       "      <td>RT @WDVL4: China pidió a empresas estatales qu...</td>\n",
       "      <td>140</td>\n",
       "      <td>Mon Jun 01 23:59:56 +0000 2020</td>\n",
       "      <td>1267606839547625500</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-06-01 23:59:56+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>nytimesworld</td>\n",
       "      <td>RT @nytimesworld: The gathering to remember Ti...</td>\n",
       "      <td>140</td>\n",
       "      <td>Mon Jun 01 23:59:55 +0000 2020</td>\n",
       "      <td>1267606835428593700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>2020-06-01 23:59:55+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>SenatorLankford</td>\n",
       "      <td>RT @SenatorLankford: while Americans protest i...</td>\n",
       "      <td>140</td>\n",
       "      <td>Mon Jun 01 23:59:50 +0000 2020</td>\n",
       "      <td>1267606815530823700</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>2020-06-01 23:59:50+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alankawing</td>\n",
       "      <td>bopinion</td>\n",
       "      <td>RT @bopinion: Taiwan, the U.S., Canada and Aus...</td>\n",
       "      <td>140</td>\n",
       "      <td>Mon Jun 01 23:59:48 +0000 2020</td>\n",
       "      <td>1267606806215356400</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-06-01 23:59:48+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>MailOnline</td>\n",
       "      <td>RT @MailOnline: Hong Kong's pro-Beijing govern...</td>\n",
       "      <td>139</td>\n",
       "      <td>Mon Jun 01 23:59:48 +0000 2020</td>\n",
       "      <td>1267606805720400000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Hong Kong</td>\n",
       "      <td>2020-06-01 23:59:48+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chowcch1</td>\n",
       "      <td>bopinion</td>\n",
       "      <td>RT @bopinion: Taiwan, the U.S., Canada and Aus...</td>\n",
       "      <td>140</td>\n",
       "      <td>Mon Jun 01 23:59:48 +0000 2020</td>\n",
       "      <td>1267606805284180000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>2020-06-01 23:59:48+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FidelisToJusti1</td>\n",
       "      <td>FidelisToJusti1</td>\n",
       "      <td>RT @FidelisToJusti1: What @realDonaldTrump is ...</td>\n",
       "      <td>139</td>\n",
       "      <td>Mon Jun 01 23:59:45 +0000 2020</td>\n",
       "      <td>1267606795637461000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Queens, NY</td>\n",
       "      <td>2020-06-01 23:59:45+00:00</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              user           reuser  \\\n",
       "0       namjoonayo         cannacae   \n",
       "1        ngdasokau    BarrySheerman   \n",
       "2    geoffreypcdog   benedictrogers   \n",
       "3   Marisa15061974            WDVL4   \n",
       "4     Tony13945454     nytimesworld   \n",
       "5   kangaroolooloo  SenatorLankford   \n",
       "6       Alankawing         bopinion   \n",
       "7     Tony13945454       MailOnline   \n",
       "8         Chowcch1         bopinion   \n",
       "9  FidelisToJusti1  FidelisToJusti1   \n",
       "\n",
       "                                           full_text  range  \\\n",
       "0  RT @cannacae: i know BLM is important rn but i...    140   \n",
       "1  RT @BarrySheerman: Will the Johnson Government...    140   \n",
       "2  RT @benedictrogers: Seven former foreign secre...    140   \n",
       "3  RT @WDVL4: China pidió a empresas estatales qu...    140   \n",
       "4  RT @nytimesworld: The gathering to remember Ti...    140   \n",
       "5  RT @SenatorLankford: while Americans protest i...    140   \n",
       "6  RT @bopinion: Taiwan, the U.S., Canada and Aus...    140   \n",
       "7  RT @MailOnline: Hong Kong's pro-Beijing govern...    139   \n",
       "8  RT @bopinion: Taiwan, the U.S., Canada and Aus...    140   \n",
       "9  RT @FidelisToJusti1: What @realDonaldTrump is ...    139   \n",
       "\n",
       "                       created_at                   id  in_reply_to_user_id  \\\n",
       "0  Mon Jun 01 23:59:57 +0000 2020  1267606846824542200                  NaN   \n",
       "1  Mon Jun 01 23:59:57 +0000 2020  1267606845763367000                  NaN   \n",
       "2  Mon Jun 01 23:59:57 +0000 2020  1267606843322331100                  NaN   \n",
       "3  Mon Jun 01 23:59:56 +0000 2020  1267606839547625500                  NaN   \n",
       "4  Mon Jun 01 23:59:55 +0000 2020  1267606835428593700                  NaN   \n",
       "5  Mon Jun 01 23:59:50 +0000 2020  1267606815530823700                  NaN   \n",
       "6  Mon Jun 01 23:59:48 +0000 2020  1267606806215356400                  NaN   \n",
       "7  Mon Jun 01 23:59:48 +0000 2020  1267606805720400000                  NaN   \n",
       "8  Mon Jun 01 23:59:48 +0000 2020  1267606805284180000                  NaN   \n",
       "9  Mon Jun 01 23:59:45 +0000 2020  1267606795637461000                  NaN   \n",
       "\n",
       "  user.location                       date    date2  \n",
       "0           NaN  2020-06-01 23:59:57+00:00  1062020  \n",
       "1     Hong Kong  2020-06-01 23:59:57+00:00  1062020  \n",
       "2           NaN  2020-06-01 23:59:57+00:00  1062020  \n",
       "3           NaN  2020-06-01 23:59:56+00:00  1062020  \n",
       "4     Hong Kong  2020-06-01 23:59:55+00:00  1062020  \n",
       "5     Hong Kong  2020-06-01 23:59:50+00:00  1062020  \n",
       "6           NaN  2020-06-01 23:59:48+00:00  1062020  \n",
       "7     Hong Kong  2020-06-01 23:59:48+00:00  1062020  \n",
       "8           NaN  2020-06-01 23:59:48+00:00  1062020  \n",
       "9    Queens, NY  2020-06-01 23:59:45+00:00  1062020  "
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets = pd.concat((pd.read_csv(f, lineterminator='\\n', sep = ';') for f in all_files))\n",
    "tweets.head(10)"
   ]
  },
  {
   "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>user</th>\n",
       "      <th>reuser</th>\n",
       "      <th>full_text</th>\n",
       "      <th>range</th>\n",
       "      <th>date2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>namjoonayo</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ngdasokau</td>\n",
       "      <td>BarrySheerman</td>\n",
       "      <td>RT @BarrySheerman: Will the Johnson Government...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>geoffreypcdog</td>\n",
       "      <td>benedictrogers</td>\n",
       "      <td>RT @benedictrogers: Seven former foreign secre...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Marisa15061974</td>\n",
       "      <td>WDVL4</td>\n",
       "      <td>RT @WDVL4: China pidió a empresas estatales qu...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>nytimesworld</td>\n",
       "      <td>RT @nytimesworld: The gathering to remember Ti...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             user          reuser  \\\n",
       "0      namjoonayo        cannacae   \n",
       "1       ngdasokau   BarrySheerman   \n",
       "2   geoffreypcdog  benedictrogers   \n",
       "3  Marisa15061974           WDVL4   \n",
       "4    Tony13945454    nytimesworld   \n",
       "\n",
       "                                           full_text  range    date2  \n",
       "0  RT @cannacae: i know BLM is important rn but i...    140  1062020  \n",
       "1  RT @BarrySheerman: Will the Johnson Government...    140  1062020  \n",
       "2  RT @benedictrogers: Seven former foreign secre...    140  1062020  \n",
       "3  RT @WDVL4: China pidió a empresas estatales qu...    140  1062020  \n",
       "4  RT @nytimesworld: The gathering to remember Ti...    140  1062020  "
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets2 = tweets.iloc[:,[0, 1, 2, 3, -1]]\n",
    "tweets2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "116017"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tweets2)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "negative-words2.exd\n"
     ]
    }
   ],
   "source": [
    "negative = []\n",
    "n_file = \"negative-words2.exd\"\n",
    "print(n_file)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open (n_file, \"r\") as nwfile:\n",
    "    for line in nwfile:\n",
    "        negative.append(line.strip())"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "list"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "type(negative)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "4779"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(negative)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/media/ambijat/Datrat/ipytoneeee/CNUS/processed2\n"
     ]
    }
   ],
   "source": [
    "processed2_path = process_path + \"/\" + 'processed2'\n",
    "print(processed2_path)\n",
    "if not os.path.exists(processed2_path):\n",
    "    os.makedirs(processed2_path)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "tweets3 = tweets2[tweets2['full_text'].str.contains(r'(?:{})'.format('|'.join(negative)), regex=True, na=False)].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "88498"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tweets3)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user</th>\n",
       "      <th>reuser</th>\n",
       "      <th>full_text</th>\n",
       "      <th>range</th>\n",
       "      <th>date2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ngdasokau</td>\n",
       "      <td>BarrySheerman</td>\n",
       "      <td>RT @BarrySheerman: Will the Johnson Government...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>geoffreypcdog</td>\n",
       "      <td>benedictrogers</td>\n",
       "      <td>RT @benedictrogers: Seven former foreign secre...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>nytimesworld</td>\n",
       "      <td>RT @nytimesworld: The gathering to remember Ti...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>SenatorLankford</td>\n",
       "      <td>RT @SenatorLankford: while Americans protest i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>MailOnline</td>\n",
       "      <td>RT @MailOnline: Hong Kong's pro-Beijing govern...</td>\n",
       "      <td>139</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             user           reuser  \\\n",
       "1       ngdasokau    BarrySheerman   \n",
       "2   geoffreypcdog   benedictrogers   \n",
       "4    Tony13945454     nytimesworld   \n",
       "5  kangaroolooloo  SenatorLankford   \n",
       "7    Tony13945454       MailOnline   \n",
       "\n",
       "                                           full_text  range    date2  \n",
       "1  RT @BarrySheerman: Will the Johnson Government...    140  1062020  \n",
       "2  RT @benedictrogers: Seven former foreign secre...    140  1062020  \n",
       "4  RT @nytimesworld: The gathering to remember Ti...    140  1062020  \n",
       "5  RT @SenatorLankford: while Americans protest i...    140  1062020  \n",
       "7  RT @MailOnline: Hong Kong's pro-Beijing govern...    139  1062020  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets3.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "tweets3['RT'] = tweets3['full_text'].str.contains(r\"^(?:RT\\s@\\w+:)\", case=False) == True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user</th>\n",
       "      <th>reuser</th>\n",
       "      <th>full_text</th>\n",
       "      <th>range</th>\n",
       "      <th>date2</th>\n",
       "      <th>RT</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>ngdasokau</td>\n",
       "      <td>BarrySheerman</td>\n",
       "      <td>RT @BarrySheerman: Will the Johnson Government...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>geoffreypcdog</td>\n",
       "      <td>benedictrogers</td>\n",
       "      <td>RT @benedictrogers: Seven former foreign secre...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>nytimesworld</td>\n",
       "      <td>RT @nytimesworld: The gathering to remember Ti...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>SenatorLankford</td>\n",
       "      <td>RT @SenatorLankford: while Americans protest i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>MailOnline</td>\n",
       "      <td>RT @MailOnline: Hong Kong's pro-Beijing govern...</td>\n",
       "      <td>139</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>FidelisToJusti1</td>\n",
       "      <td>FidelisToJusti1</td>\n",
       "      <td>RT @FidelisToJusti1: What @realDonaldTrump is ...</td>\n",
       "      <td>139</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>next_china</td>\n",
       "      <td>RT @next_china: Hong Kong’s finance workers ar...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>KelvinWo4</td>\n",
       "      <td>BarrySheerman</td>\n",
       "      <td>RT @BarrySheerman: Will the Johnson Government...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>FidelisToJusti1</td>\n",
       "      <td>NaN</td>\n",
       "      <td>What @realDonaldTrump is threatening if govern...</td>\n",
       "      <td>280</td>\n",
       "      <td>1062020</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>WSJPolitics</td>\n",
       "      <td>RT @WSJPolitics: President Trump said Friday t...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>kathyktk</td>\n",
       "      <td>USAenEspanol</td>\n",
       "      <td>RT @USAenEspanol: .@SecPompeo: El presidente T...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>Andrew_Adonis</td>\n",
       "      <td>RT @Andrew_Adonis: We need a cross-party allia...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Jeffrey44012270</td>\n",
       "      <td>BarrySheerman</td>\n",
       "      <td>RT @BarrySheerman: Will the Johnson Government...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>MailOnline</td>\n",
       "      <td>RT @MailOnline: Hong Kong's pro-Beijing govern...</td>\n",
       "      <td>139</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>nytimesworld</td>\n",
       "      <td>RT @nytimesworld: The gathering to remember Ti...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>JohnChi08726030</td>\n",
       "      <td>joshuawongcf</td>\n",
       "      <td>RT @joshuawongcf: Thank you for Seven former f...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>beynate</td>\n",
       "      <td>RT @beynate: Joined @AmnestyNow and colleagues...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>NPazderski</td>\n",
       "      <td>NotHoodlum</td>\n",
       "      <td>RT @NotHoodlum: Don’t let this go unnoticed in...</td>\n",
       "      <td>105</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>Solefinder88</td>\n",
       "      <td>NaN</td>\n",
       "      <td>@CBSNews After this #Trump cannot criticize #C...</td>\n",
       "      <td>84</td>\n",
       "      <td>1062020</td>\n",
       "      <td>False</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>Andrew_Adonis</td>\n",
       "      <td>RT @Andrew_Adonis: We need a cross-party allia...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "      <td>True</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               user           reuser  \\\n",
       "1         ngdasokau    BarrySheerman   \n",
       "2     geoffreypcdog   benedictrogers   \n",
       "4      Tony13945454     nytimesworld   \n",
       "5    kangaroolooloo  SenatorLankford   \n",
       "7      Tony13945454       MailOnline   \n",
       "9   FidelisToJusti1  FidelisToJusti1   \n",
       "10   kangaroolooloo       next_china   \n",
       "11        KelvinWo4    BarrySheerman   \n",
       "13  FidelisToJusti1              NaN   \n",
       "14   kangaroolooloo      WSJPolitics   \n",
       "16         kathyktk     USAenEspanol   \n",
       "18     Tony13945454    Andrew_Adonis   \n",
       "19  Jeffrey44012270    BarrySheerman   \n",
       "20   kangaroolooloo       MailOnline   \n",
       "23   kangaroolooloo     nytimesworld   \n",
       "24  JohnChi08726030     joshuawongcf   \n",
       "26     Tony13945454          beynate   \n",
       "28       NPazderski       NotHoodlum   \n",
       "29     Solefinder88              NaN   \n",
       "30   kangaroolooloo    Andrew_Adonis   \n",
       "\n",
       "                                            full_text  range    date2     RT  \n",
       "1   RT @BarrySheerman: Will the Johnson Government...    140  1062020   True  \n",
       "2   RT @benedictrogers: Seven former foreign secre...    140  1062020   True  \n",
       "4   RT @nytimesworld: The gathering to remember Ti...    140  1062020   True  \n",
       "5   RT @SenatorLankford: while Americans protest i...    140  1062020   True  \n",
       "7   RT @MailOnline: Hong Kong's pro-Beijing govern...    139  1062020   True  \n",
       "9   RT @FidelisToJusti1: What @realDonaldTrump is ...    139  1062020   True  \n",
       "10  RT @next_china: Hong Kong’s finance workers ar...    140  1062020   True  \n",
       "11  RT @BarrySheerman: Will the Johnson Government...    140  1062020   True  \n",
       "13  What @realDonaldTrump is threatening if govern...    280  1062020  False  \n",
       "14  RT @WSJPolitics: President Trump said Friday t...    140  1062020   True  \n",
       "16  RT @USAenEspanol: .@SecPompeo: El presidente T...    140  1062020   True  \n",
       "18  RT @Andrew_Adonis: We need a cross-party allia...    140  1062020   True  \n",
       "19  RT @BarrySheerman: Will the Johnson Government...    140  1062020   True  \n",
       "20  RT @MailOnline: Hong Kong's pro-Beijing govern...    139  1062020   True  \n",
       "23  RT @nytimesworld: The gathering to remember Ti...    140  1062020   True  \n",
       "24  RT @joshuawongcf: Thank you for Seven former f...    140  1062020   True  \n",
       "26  RT @beynate: Joined @AmnestyNow and colleagues...    140  1062020   True  \n",
       "28  RT @NotHoodlum: Don’t let this go unnoticed in...    105  1062020   True  \n",
       "29  @CBSNews After this #Trump cannot criticize #C...     84  1062020  False  \n",
       "30  RT @Andrew_Adonis: We need a cross-party allia...    140  1062020   True  "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets3.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "negative_tweets = tweets3"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/media/ambijat/Datrat/ipytoneeee/CNUS/processed2/negative_tweets4.csv\n"
     ]
    }
   ],
   "source": [
    "negpath = os.path.join(processed2_path, 'negative_tweets4.csv')\n",
    "print(negpath)\n",
    "negative_tweets.to_csv(negpath, index = False, header = True, encoding = 'utf-8', sep = ';')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "tweets4 = tweets2[~tweets2['full_text'].str.contains(r'(?:{})'.format('|'.join(negative)), regex=True, na=False)].copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>user</th>\n",
       "      <th>reuser</th>\n",
       "      <th>full_text</th>\n",
       "      <th>range</th>\n",
       "      <th>date2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>namjoonayo</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Marisa15061974</td>\n",
       "      <td>WDVL4</td>\n",
       "      <td>RT @WDVL4: China pidió a empresas estatales qu...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Alankawing</td>\n",
       "      <td>bopinion</td>\n",
       "      <td>RT @bopinion: Taiwan, the U.S., Canada and Aus...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Chowcch1</td>\n",
       "      <td>bopinion</td>\n",
       "      <td>RT @bopinion: Taiwan, the U.S., Canada and Aus...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>GayFairyCat</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>bopinion</td>\n",
       "      <td>RT @bopinion: Taiwan, the U.S., Canada and Aus...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>TornadoMario347</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>distorted_worth</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>NOWORNE27782301</td>\n",
       "      <td>LibDems</td>\n",
       "      <td>RT @LibDems: The UK has a moral &amp;amp; legal du...</td>\n",
       "      <td>148</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>bopinion</td>\n",
       "      <td>RT @bopinion: Taiwan, the U.S., Canada and Aus...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>GAUTAMSAITEZA</td>\n",
       "      <td>narendra_rajans</td>\n",
       "      <td>RT @narendra_rajans: Tibet belongs to China\\n\\...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>MerlinM81258194</td>\n",
       "      <td>SarahChampionMP</td>\n",
       "      <td>RT @SarahChampionMP: UK ministers under pressu...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>kangaroolooloo</td>\n",
       "      <td>SarahChampionMP</td>\n",
       "      <td>RT @SarahChampionMP: UK ministers under pressu...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>Tony13945454</td>\n",
       "      <td>SarahChampionMP</td>\n",
       "      <td>RT @SarahChampionMP: UK ministers under pressu...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>53</th>\n",
       "      <td>alcisrip</td>\n",
       "      <td>NaN</td>\n",
       "      <td>Engraçado ver a China lançando nota de repudio...</td>\n",
       "      <td>80</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>56</th>\n",
       "      <td>a_btxt</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>57</th>\n",
       "      <td>5_demand</td>\n",
       "      <td>joshuawongcf</td>\n",
       "      <td>RT @joshuawongcf: 조슈아 웡: 홍콩은 우리가 사는 곳, 스스로 운명 ...</td>\n",
       "      <td>128</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>porepore09</td>\n",
       "      <td>ryo384_ir</td>\n",
       "      <td>RT @ryo384_ir: NYT論説…「一国二制度」という概念は、１９８４年の中英共同宣...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>62</th>\n",
       "      <td>heartcosts</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>65</th>\n",
       "      <td>joondery</td>\n",
       "      <td>cannacae</td>\n",
       "      <td>RT @cannacae: i know BLM is important rn but i...</td>\n",
       "      <td>140</td>\n",
       "      <td>1062020</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "               user           reuser  \\\n",
       "0        namjoonayo         cannacae   \n",
       "3    Marisa15061974            WDVL4   \n",
       "6        Alankawing         bopinion   \n",
       "8          Chowcch1         bopinion   \n",
       "12      GayFairyCat         cannacae   \n",
       "15     Tony13945454         bopinion   \n",
       "17  TornadoMario347         cannacae   \n",
       "21  distorted_worth         cannacae   \n",
       "22  NOWORNE27782301          LibDems   \n",
       "25   kangaroolooloo         bopinion   \n",
       "27    GAUTAMSAITEZA  narendra_rajans   \n",
       "31  MerlinM81258194  SarahChampionMP   \n",
       "40   kangaroolooloo  SarahChampionMP   \n",
       "43     Tony13945454  SarahChampionMP   \n",
       "53         alcisrip              NaN   \n",
       "56           a_btxt         cannacae   \n",
       "57         5_demand     joshuawongcf   \n",
       "61       porepore09        ryo384_ir   \n",
       "62       heartcosts         cannacae   \n",
       "65         joondery         cannacae   \n",
       "\n",
       "                                            full_text  range    date2  \n",
       "0   RT @cannacae: i know BLM is important rn but i...    140  1062020  \n",
       "3   RT @WDVL4: China pidió a empresas estatales qu...    140  1062020  \n",
       "6   RT @bopinion: Taiwan, the U.S., Canada and Aus...    140  1062020  \n",
       "8   RT @bopinion: Taiwan, the U.S., Canada and Aus...    140  1062020  \n",
       "12  RT @cannacae: i know BLM is important rn but i...    140  1062020  \n",
       "15  RT @bopinion: Taiwan, the U.S., Canada and Aus...    140  1062020  \n",
       "17  RT @cannacae: i know BLM is important rn but i...    140  1062020  \n",
       "21  RT @cannacae: i know BLM is important rn but i...    140  1062020  \n",
       "22  RT @LibDems: The UK has a moral &amp; legal du...    148  1062020  \n",
       "25  RT @bopinion: Taiwan, the U.S., Canada and Aus...    140  1062020  \n",
       "27  RT @narendra_rajans: Tibet belongs to China\\n\\...    140  1062020  \n",
       "31  RT @SarahChampionMP: UK ministers under pressu...    140  1062020  \n",
       "40  RT @SarahChampionMP: UK ministers under pressu...    140  1062020  \n",
       "43  RT @SarahChampionMP: UK ministers under pressu...    140  1062020  \n",
       "53  Engraçado ver a China lançando nota de repudio...     80  1062020  \n",
       "56  RT @cannacae: i know BLM is important rn but i...    140  1062020  \n",
       "57  RT @joshuawongcf: 조슈아 웡: 홍콩은 우리가 사는 곳, 스스로 운명 ...    128  1062020  \n",
       "61  RT @ryo384_ir: NYT論説…「一国二制度」という概念は、１９８４年の中英共同宣...    140  1062020  \n",
       "62  RT @cannacae: i know BLM is important rn but i...    140  1062020  \n",
       "65  RT @cannacae: i know BLM is important rn but i...    140  1062020  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tweets4.head(20)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "27519"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(tweets4)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "positive_tweets = tweets4"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "116017\n"
     ]
    }
   ],
   "source": [
    "total_tweets = len(negative_tweets) +  len(positive_tweets)\n",
    "print(total_tweets)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "/media/ambijat/Datrat/ipytoneeee/CNUS/processed2/positive_tweets4.csv\n"
     ]
    }
   ],
   "source": [
    "pospath = os.path.join(processed2_path, 'positive_tweets4.csv')\n",
    "print(pospath)\n",
    "positive_tweets.to_csv(pospath, index = False, header = True, encoding = 'utf-8', sep = ';')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 4
}