Review_divider_code.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "efficient-rally",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "varying-phase",
   "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>Review_ID</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Reviewer_Location</th>\n",
       "      <th>Review_Text</th>\n",
       "      <th>Branch</th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>is_good_review</th>\n",
       "      <th>review_clean</th>\n",
       "      <th>neg</th>\n",
       "      <th>...</th>\n",
       "      <th>word_yet</th>\n",
       "      <th>word_york</th>\n",
       "      <th>word_you</th>\n",
       "      <th>word_young</th>\n",
       "      <th>word_yr</th>\n",
       "      <th>word_yrs</th>\n",
       "      <th>word_yum</th>\n",
       "      <th>word_yummy</th>\n",
       "      <th>word_zero</th>\n",
       "      <th>word_zone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>122944085</td>\n",
       "      <td>5</td>\n",
       "      <td>United States</td>\n",
       "      <td>Spotlessly clean and so organized considering ...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2011</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>spotlessly clean organize consider thousand vi...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>290851203</td>\n",
       "      <td>5</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pricey but worth it, unfortunately the big thu...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>pricey worth unfortunately big thunder mountai...</td>\n",
       "      <td>0.115</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>168087311</td>\n",
       "      <td>4</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Disneyland is a magical place. Everyone, parti...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2013</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>disneyland magical place everyone particularly...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>282417360</td>\n",
       "      <td>5</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Disney land is a must when visiting Paris. The...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>disney land must visit paris frozen show best ...</td>\n",
       "      <td>0.028</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>160953212</td>\n",
       "      <td>3</td>\n",
       "      <td>India</td>\n",
       "      <td>The HK Disneyland is definitely small, but it'...</td>\n",
       "      <td>Disneyland_HongKong</td>\n",
       "      <td>2012</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>hk disneyland definitely small definitely fun ...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3999</th>\n",
       "      <td>290217727</td>\n",
       "      <td>5</td>\n",
       "      <td>Australia</td>\n",
       "      <td>There's a reason why they call Disneyland  The...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>there's reason call disneyland happy place ear...</td>\n",
       "      <td>0.042</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4000</th>\n",
       "      <td>174264188</td>\n",
       "      <td>1</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>I visited Disneyland Paris with my family (tee...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>visit disneyland paris family teenage daughter...</td>\n",
       "      <td>0.081</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4001</th>\n",
       "      <td>638583788</td>\n",
       "      <td>5</td>\n",
       "      <td>United States</td>\n",
       "      <td>What a great day we had we did so much before ...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2018</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>great day much great guide grandson amaze well...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4002</th>\n",
       "      <td>226159775</td>\n",
       "      <td>5</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>It has been a childhood dream of mine to go to...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2013</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>childhood dream mine go disneyland whether you...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.432261</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4003</th>\n",
       "      <td>143521522</td>\n",
       "      <td>4</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Well my wife and I visted in October 2012 for ...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2012</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>well wife visted october parcs real complaint ...</td>\n",
       "      <td>0.030</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>4004 rows × 2150 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Review_ID  Rating Reviewer_Location  \\\n",
       "0     122944085       5     United States   \n",
       "1     290851203       5    United Kingdom   \n",
       "2     168087311       4            Canada   \n",
       "3     282417360       5          Pakistan   \n",
       "4     160953212       3             India   \n",
       "...         ...     ...               ...   \n",
       "3999  290217727       5         Australia   \n",
       "4000  174264188       1    United Kingdom   \n",
       "4001  638583788       5     United States   \n",
       "4002  226159775       5       Philippines   \n",
       "4003  143521522       4    United Kingdom   \n",
       "\n",
       "                                            Review_Text  \\\n",
       "0     Spotlessly clean and so organized considering ...   \n",
       "1     Pricey but worth it, unfortunately the big thu...   \n",
       "2     Disneyland is a magical place. Everyone, parti...   \n",
       "3     Disney land is a must when visiting Paris. The...   \n",
       "4     The HK Disneyland is definitely small, but it'...   \n",
       "...                                                 ...   \n",
       "3999  There's a reason why they call Disneyland  The...   \n",
       "4000  I visited Disneyland Paris with my family (tee...   \n",
       "4001  What a great day we had we did so much before ...   \n",
       "4002  It has been a childhood dream of mine to go to...   \n",
       "4003  Well my wife and I visted in October 2012 for ...   \n",
       "\n",
       "                     Branch  Year  Month  is_good_review  \\\n",
       "0     Disneyland_California  2011     10               1   \n",
       "1          Disneyland_Paris  2015      7               1   \n",
       "2     Disneyland_California  2013      7               1   \n",
       "3          Disneyland_Paris  2015      6               1   \n",
       "4       Disneyland_HongKong  2012      9               0   \n",
       "...                     ...   ...    ...             ...   \n",
       "3999  Disneyland_California  2015      7               1   \n",
       "4000       Disneyland_Paris  2013      8               0   \n",
       "4001  Disneyland_California  2018     12               1   \n",
       "4002  Disneyland_California  2013     10               1   \n",
       "4003       Disneyland_Paris  2012     10               1   \n",
       "\n",
       "                                           review_clean    neg  ...  word_yet  \\\n",
       "0     spotlessly clean organize consider thousand vi...  0.000  ...       0.0   \n",
       "1     pricey worth unfortunately big thunder mountai...  0.115  ...       0.0   \n",
       "2     disneyland magical place everyone particularly...  0.000  ...       0.0   \n",
       "3     disney land must visit paris frozen show best ...  0.028  ...       0.0   \n",
       "4     hk disneyland definitely small definitely fun ...  0.000  ...       0.0   \n",
       "...                                                 ...    ...  ...       ...   \n",
       "3999  there's reason call disneyland happy place ear...  0.042  ...       0.0   \n",
       "4000  visit disneyland paris family teenage daughter...  0.081  ...       0.0   \n",
       "4001  great day much great guide grandson amaze well...  0.000  ...       0.0   \n",
       "4002  childhood dream mine go disneyland whether you...  0.000  ...       0.0   \n",
       "4003  well wife visted october parcs real complaint ...  0.030  ...       0.0   \n",
       "\n",
       "      word_york  word_you  word_young  word_yr  word_yrs  word_yum  \\\n",
       "0           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "1           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "2           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "3           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "4           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "...         ...       ...         ...      ...       ...       ...   \n",
       "3999        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "4000        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "4001        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "4002        0.0       0.0    0.432261      0.0       0.0       0.0   \n",
       "4003        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "\n",
       "      word_yummy  word_zero  word_zone  \n",
       "0            0.0        0.0        0.0  \n",
       "1            0.0        0.0        0.0  \n",
       "2            0.0        0.0        0.0  \n",
       "3            0.0        0.0        0.0  \n",
       "4            0.0        0.0        0.0  \n",
       "...          ...        ...        ...  \n",
       "3999         0.0        0.0        0.0  \n",
       "4000         0.0        0.0        0.0  \n",
       "4001         0.0        0.0        0.0  \n",
       "4002         0.0        0.0        0.0  \n",
       "4003         0.0        0.0        0.0  \n",
       "\n",
       "[4004 rows x 2150 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_df = pd.read_csv(\"Resources/all_reviews_data.csv\", encoding='ISO-8859-1')\n",
    "all_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "residential-comparative",
   "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>Review_ID</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Reviewer_Location</th>\n",
       "      <th>Review_Text</th>\n",
       "      <th>Branch</th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>is_good_review</th>\n",
       "      <th>review_clean</th>\n",
       "      <th>neg</th>\n",
       "      <th>...</th>\n",
       "      <th>word_yet</th>\n",
       "      <th>word_york</th>\n",
       "      <th>word_you</th>\n",
       "      <th>word_young</th>\n",
       "      <th>word_yr</th>\n",
       "      <th>word_yrs</th>\n",
       "      <th>word_yum</th>\n",
       "      <th>word_yummy</th>\n",
       "      <th>word_zero</th>\n",
       "      <th>word_zone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>122944085</td>\n",
       "      <td>5</td>\n",
       "      <td>United States</td>\n",
       "      <td>Spotlessly clean and so organized considering ...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2011</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>spotlessly clean organize consider thousand vi...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>290851203</td>\n",
       "      <td>5</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Pricey but worth it, unfortunately the big thu...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>pricey worth unfortunately big thunder mountai...</td>\n",
       "      <td>0.115</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>168087311</td>\n",
       "      <td>4</td>\n",
       "      <td>Canada</td>\n",
       "      <td>Disneyland is a magical place. Everyone, parti...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2013</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>disneyland magical place everyone particularly...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>282417360</td>\n",
       "      <td>5</td>\n",
       "      <td>Pakistan</td>\n",
       "      <td>Disney land is a must when visiting Paris. The...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2015</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "      <td>disney land must visit paris frozen show best ...</td>\n",
       "      <td>0.028</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>633178209</td>\n",
       "      <td>5</td>\n",
       "      <td>United States</td>\n",
       "      <td>Went with a group of Disneyfied adults on a we...</td>\n",
       "      <td>Disneyland_HongKong</td>\n",
       "      <td>2018</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>go group disneyfied adult week day park deck h...</td>\n",
       "      <td>0.048</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3998</th>\n",
       "      <td>220207400</td>\n",
       "      <td>5</td>\n",
       "      <td>Thailand</td>\n",
       "      <td>In order to stay for the fireworks, reach disn...</td>\n",
       "      <td>Disneyland_HongKong</td>\n",
       "      <td>2014</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>order stay fireworks reach disneyland onwards ...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3999</th>\n",
       "      <td>290217727</td>\n",
       "      <td>5</td>\n",
       "      <td>Australia</td>\n",
       "      <td>There's a reason why they call Disneyland  The...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2015</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>there's reason call disneyland happy place ear...</td>\n",
       "      <td>0.042</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4001</th>\n",
       "      <td>638583788</td>\n",
       "      <td>5</td>\n",
       "      <td>United States</td>\n",
       "      <td>What a great day we had we did so much before ...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2018</td>\n",
       "      <td>12</td>\n",
       "      <td>1</td>\n",
       "      <td>great day much great guide grandson amaze well...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4002</th>\n",
       "      <td>226159775</td>\n",
       "      <td>5</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>It has been a childhood dream of mine to go to...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2013</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>childhood dream mine go disneyland whether you...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.432261</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4003</th>\n",
       "      <td>143521522</td>\n",
       "      <td>4</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>Well my wife and I visted in October 2012 for ...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2012</td>\n",
       "      <td>10</td>\n",
       "      <td>1</td>\n",
       "      <td>well wife visted october parcs real complaint ...</td>\n",
       "      <td>0.030</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>3218 rows × 2150 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Review_ID  Rating Reviewer_Location  \\\n",
       "0     122944085       5     United States   \n",
       "1     290851203       5    United Kingdom   \n",
       "2     168087311       4            Canada   \n",
       "3     282417360       5          Pakistan   \n",
       "5     633178209       5     United States   \n",
       "...         ...     ...               ...   \n",
       "3998  220207400       5          Thailand   \n",
       "3999  290217727       5         Australia   \n",
       "4001  638583788       5     United States   \n",
       "4002  226159775       5       Philippines   \n",
       "4003  143521522       4    United Kingdom   \n",
       "\n",
       "                                            Review_Text  \\\n",
       "0     Spotlessly clean and so organized considering ...   \n",
       "1     Pricey but worth it, unfortunately the big thu...   \n",
       "2     Disneyland is a magical place. Everyone, parti...   \n",
       "3     Disney land is a must when visiting Paris. The...   \n",
       "5     Went with a group of Disneyfied adults on a we...   \n",
       "...                                                 ...   \n",
       "3998  In order to stay for the fireworks, reach disn...   \n",
       "3999  There's a reason why they call Disneyland  The...   \n",
       "4001  What a great day we had we did so much before ...   \n",
       "4002  It has been a childhood dream of mine to go to...   \n",
       "4003  Well my wife and I visted in October 2012 for ...   \n",
       "\n",
       "                     Branch  Year  Month  is_good_review  \\\n",
       "0     Disneyland_California  2011     10               1   \n",
       "1          Disneyland_Paris  2015      7               1   \n",
       "2     Disneyland_California  2013      7               1   \n",
       "3          Disneyland_Paris  2015      6               1   \n",
       "5       Disneyland_HongKong  2018     10               1   \n",
       "...                     ...   ...    ...             ...   \n",
       "3998    Disneyland_HongKong  2014      7               1   \n",
       "3999  Disneyland_California  2015      7               1   \n",
       "4001  Disneyland_California  2018     12               1   \n",
       "4002  Disneyland_California  2013     10               1   \n",
       "4003       Disneyland_Paris  2012     10               1   \n",
       "\n",
       "                                           review_clean    neg  ...  word_yet  \\\n",
       "0     spotlessly clean organize consider thousand vi...  0.000  ...       0.0   \n",
       "1     pricey worth unfortunately big thunder mountai...  0.115  ...       0.0   \n",
       "2     disneyland magical place everyone particularly...  0.000  ...       0.0   \n",
       "3     disney land must visit paris frozen show best ...  0.028  ...       0.0   \n",
       "5     go group disneyfied adult week day park deck h...  0.048  ...       0.0   \n",
       "...                                                 ...    ...  ...       ...   \n",
       "3998  order stay fireworks reach disneyland onwards ...  0.000  ...       0.0   \n",
       "3999  there's reason call disneyland happy place ear...  0.042  ...       0.0   \n",
       "4001  great day much great guide grandson amaze well...  0.000  ...       0.0   \n",
       "4002  childhood dream mine go disneyland whether you...  0.000  ...       0.0   \n",
       "4003  well wife visted october parcs real complaint ...  0.030  ...       0.0   \n",
       "\n",
       "      word_york  word_you  word_young  word_yr  word_yrs  word_yum  \\\n",
       "0           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "1           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "2           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "3           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "5           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "...         ...       ...         ...      ...       ...       ...   \n",
       "3998        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "3999        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "4001        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "4002        0.0       0.0    0.432261      0.0       0.0       0.0   \n",
       "4003        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "\n",
       "      word_yummy  word_zero  word_zone  \n",
       "0            0.0        0.0        0.0  \n",
       "1            0.0        0.0        0.0  \n",
       "2            0.0        0.0        0.0  \n",
       "3            0.0        0.0        0.0  \n",
       "5            0.0        0.0        0.0  \n",
       "...          ...        ...        ...  \n",
       "3998         0.0        0.0        0.0  \n",
       "3999         0.0        0.0        0.0  \n",
       "4001         0.0        0.0        0.0  \n",
       "4002         0.0        0.0        0.0  \n",
       "4003         0.0        0.0        0.0  \n",
       "\n",
       "[3218 rows x 2150 columns]"
      ]
     },
     "execution_count": 9,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "positive = all_df.loc[all_df['is_good_review'] == 1] \n",
    "positive"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "enormous-nickname",
   "metadata": {},
   "outputs": [],
   "source": [
    "positive.to_csv('Resources/positive_only.csv', index=True)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "framed-aircraft",
   "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>Review_ID</th>\n",
       "      <th>Rating</th>\n",
       "      <th>Reviewer_Location</th>\n",
       "      <th>Review_Text</th>\n",
       "      <th>Branch</th>\n",
       "      <th>Year</th>\n",
       "      <th>Month</th>\n",
       "      <th>is_good_review</th>\n",
       "      <th>review_clean</th>\n",
       "      <th>neg</th>\n",
       "      <th>...</th>\n",
       "      <th>word_yet</th>\n",
       "      <th>word_york</th>\n",
       "      <th>word_you</th>\n",
       "      <th>word_young</th>\n",
       "      <th>word_yr</th>\n",
       "      <th>word_yrs</th>\n",
       "      <th>word_yum</th>\n",
       "      <th>word_yummy</th>\n",
       "      <th>word_zero</th>\n",
       "      <th>word_zone</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>160953212</td>\n",
       "      <td>3</td>\n",
       "      <td>India</td>\n",
       "      <td>The HK Disneyland is definitely small, but it'...</td>\n",
       "      <td>Disneyland_HongKong</td>\n",
       "      <td>2012</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>hk disneyland definitely small definitely fun ...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>181002689</td>\n",
       "      <td>2</td>\n",
       "      <td>United States</td>\n",
       "      <td>What was supposed to be a magical 9th birthday...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2013</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>suppose magical birthday trip magic kingdom gr...</td>\n",
       "      <td>0.108</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.157613</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>182759952</td>\n",
       "      <td>1</td>\n",
       "      <td>United States</td>\n",
       "      <td>4 major attractions were closed. We were stuck...</td>\n",
       "      <td>Disneyland_California</td>\n",
       "      <td>2013</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>major attraction close stuck rope line close a...</td>\n",
       "      <td>0.189</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>130784901</td>\n",
       "      <td>3</td>\n",
       "      <td>Malaysia</td>\n",
       "      <td>I have been visiting Disneyland Paris for a fe...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2011</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>visit disneyland paris time suggestion first t...</td>\n",
       "      <td>0.000</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>448101963</td>\n",
       "      <td>2</td>\n",
       "      <td>Australia</td>\n",
       "      <td>Normally don't do reviews on attractions.   bu...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2016</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>normally review attraction want highlight peop...</td>\n",
       "      <td>0.168</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.201793</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3968</th>\n",
       "      <td>276260362</td>\n",
       "      <td>2</td>\n",
       "      <td>Finland</td>\n",
       "      <td>So this has probbably been my 10th time at thi...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2015</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>probbably time park time visit mother ar gradu...</td>\n",
       "      <td>0.036</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3982</th>\n",
       "      <td>462018089</td>\n",
       "      <td>3</td>\n",
       "      <td>United States</td>\n",
       "      <td>I knew the park was smaller than the average D...</td>\n",
       "      <td>Disneyland_HongKong</td>\n",
       "      <td>2017</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>knew park small average disney property surpri...</td>\n",
       "      <td>0.038</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3990</th>\n",
       "      <td>123673478</td>\n",
       "      <td>2</td>\n",
       "      <td>United States</td>\n",
       "      <td>HK Disneyland has a typical disneyland layout ...</td>\n",
       "      <td>Disneyland_HongKong</td>\n",
       "      <td>2012</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>hk disneyland typical disneyland layout qualit...</td>\n",
       "      <td>0.165</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3996</th>\n",
       "      <td>393179635</td>\n",
       "      <td>2</td>\n",
       "      <td>Philippines</td>\n",
       "      <td>If you have been to other Disneyland, keep you...</td>\n",
       "      <td>Disneyland_HongKong</td>\n",
       "      <td>2016</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "      <td>disneyland keep expectation low visit disneyla...</td>\n",
       "      <td>0.079</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4000</th>\n",
       "      <td>174264188</td>\n",
       "      <td>1</td>\n",
       "      <td>United Kingdom</td>\n",
       "      <td>I visited Disneyland Paris with my family (tee...</td>\n",
       "      <td>Disneyland_Paris</td>\n",
       "      <td>2013</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>visit disneyland paris family teenage daughter...</td>\n",
       "      <td>0.081</td>\n",
       "      <td>...</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>786 rows × 2150 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "      Review_ID  Rating Reviewer_Location  \\\n",
       "4     160953212       3             India   \n",
       "9     181002689       2     United States   \n",
       "17    182759952       1     United States   \n",
       "21    130784901       3          Malaysia   \n",
       "33    448101963       2         Australia   \n",
       "...         ...     ...               ...   \n",
       "3968  276260362       2           Finland   \n",
       "3982  462018089       3     United States   \n",
       "3990  123673478       2     United States   \n",
       "3996  393179635       2       Philippines   \n",
       "4000  174264188       1    United Kingdom   \n",
       "\n",
       "                                            Review_Text  \\\n",
       "4     The HK Disneyland is definitely small, but it'...   \n",
       "9     What was supposed to be a magical 9th birthday...   \n",
       "17    4 major attractions were closed. We were stuck...   \n",
       "21    I have been visiting Disneyland Paris for a fe...   \n",
       "33    Normally don't do reviews on attractions.   bu...   \n",
       "...                                                 ...   \n",
       "3968  So this has probbably been my 10th time at thi...   \n",
       "3982  I knew the park was smaller than the average D...   \n",
       "3990  HK Disneyland has a typical disneyland layout ...   \n",
       "3996  If you have been to other Disneyland, keep you...   \n",
       "4000  I visited Disneyland Paris with my family (tee...   \n",
       "\n",
       "                     Branch  Year  Month  is_good_review  \\\n",
       "4       Disneyland_HongKong  2012      9               0   \n",
       "9     Disneyland_California  2013     10               0   \n",
       "17    Disneyland_California  2013     10               0   \n",
       "21         Disneyland_Paris  2011      6               0   \n",
       "33         Disneyland_Paris  2016     12               0   \n",
       "...                     ...   ...    ...             ...   \n",
       "3968       Disneyland_Paris  2015      5               0   \n",
       "3982    Disneyland_HongKong  2017      2               0   \n",
       "3990    Disneyland_HongKong  2012      1               0   \n",
       "3996    Disneyland_HongKong  2016      7               0   \n",
       "4000       Disneyland_Paris  2013      8               0   \n",
       "\n",
       "                                           review_clean    neg  ...  word_yet  \\\n",
       "4     hk disneyland definitely small definitely fun ...  0.000  ...       0.0   \n",
       "9     suppose magical birthday trip magic kingdom gr...  0.108  ...       0.0   \n",
       "17    major attraction close stuck rope line close a...  0.189  ...       0.0   \n",
       "21    visit disneyland paris time suggestion first t...  0.000  ...       0.0   \n",
       "33    normally review attraction want highlight peop...  0.168  ...       0.0   \n",
       "...                                                 ...    ...  ...       ...   \n",
       "3968  probbably time park time visit mother ar gradu...  0.036  ...       0.0   \n",
       "3982  knew park small average disney property surpri...  0.038  ...       0.0   \n",
       "3990  hk disneyland typical disneyland layout qualit...  0.165  ...       0.0   \n",
       "3996  disneyland keep expectation low visit disneyla...  0.079  ...       0.0   \n",
       "4000  visit disneyland paris family teenage daughter...  0.081  ...       0.0   \n",
       "\n",
       "      word_york  word_you  word_young  word_yr  word_yrs  word_yum  \\\n",
       "4           0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "9           0.0       0.0    0.157613      0.0       0.0       0.0   \n",
       "17          0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "21          0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "33          0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "...         ...       ...         ...      ...       ...       ...   \n",
       "3968        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "3982        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "3990        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "3996        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "4000        0.0       0.0    0.000000      0.0       0.0       0.0   \n",
       "\n",
       "      word_yummy  word_zero  word_zone  \n",
       "4            0.0   0.000000        0.0  \n",
       "9            0.0   0.000000        0.0  \n",
       "17           0.0   0.000000        0.0  \n",
       "21           0.0   0.000000        0.0  \n",
       "33           0.0   0.201793        0.0  \n",
       "...          ...        ...        ...  \n",
       "3968         0.0   0.000000        0.0  \n",
       "3982         0.0   0.000000        0.0  \n",
       "3990         0.0   0.000000        0.0  \n",
       "3996         0.0   0.000000        0.0  \n",
       "4000         0.0   0.000000        0.0  \n",
       "\n",
       "[786 rows x 2150 columns]"
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "negative = all_df.loc[all_df['is_good_review'] == 0] \n",
    "negative"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "taken-century",
   "metadata": {},
   "outputs": [],
   "source": [
    "negative.to_csv('Resources/negative_only.csv', index=True)  "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "third-parts",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}