03_T5_detect_lang.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "id": "48e841ac",
   "metadata": {},
   "source": [
    "## Data preparation for review.csv"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "101e427a",
   "metadata": {},
   "source": [
    "We use this notebook to detect the commants language"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "3e4df0e0",
   "metadata": {},
   "outputs": [],
   "source": [
    "#pip install googletrans"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "id": "fc473bcf",
   "metadata": {},
   "outputs": [],
   "source": [
    "import numpy as np\n",
    "import pandas as pd\n",
    "from langdetect import detect\n",
    "import nltk\n",
    "import emoji\n",
    "from googletrans import Translator\n",
    "import re\n",
    "import unicodedata\n",
    "import matplotlib.pyplot as plt\n",
    "from deep_translator import GoogleTranslator"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "id": "ef101d14",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>109</td>\n",
       "      <td>449036</td>\n",
       "      <td>2011-08-15</td>\n",
       "      <td>927861</td>\n",
       "      <td>Edwin</td>\n",
       "      <td>The host canceled my reservation the day befor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>109</td>\n",
       "      <td>74506539</td>\n",
       "      <td>2016-05-15</td>\n",
       "      <td>22509885</td>\n",
       "      <td>Jenn</td>\n",
       "      <td>Me and two friends stayed for four and a half ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2708</td>\n",
       "      <td>13994902</td>\n",
       "      <td>2014-06-09</td>\n",
       "      <td>10905424</td>\n",
       "      <td>Kuberan</td>\n",
       "      <td>i had a wonderful stay. Everything from start ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>180926</td>\n",
       "      <td>424635</td>\n",
       "      <td>2011-08-06</td>\n",
       "      <td>892106</td>\n",
       "      <td>Brian</td>\n",
       "      <td>Rebecca was a great host!  She was very friend...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>180926</td>\n",
       "      <td>13396837</td>\n",
       "      <td>2014-05-26</td>\n",
       "      <td>3220350</td>\n",
       "      <td>Julia</td>\n",
       "      <td>We had a wonderful time in this cabin with our...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   listing_id        id        date  reviewer_id reviewer_name  \\\n",
       "0         109    449036  2011-08-15       927861         Edwin   \n",
       "1         109  74506539  2016-05-15     22509885          Jenn   \n",
       "2        2708  13994902  2014-06-09     10905424       Kuberan   \n",
       "3      180926    424635  2011-08-06       892106         Brian   \n",
       "4      180926  13396837  2014-05-26      3220350         Julia   \n",
       "\n",
       "                                            comments  \n",
       "0  The host canceled my reservation the day befor...  \n",
       "1  Me and two friends stayed for four and a half ...  \n",
       "2  i had a wonderful stay. Everything from start ...  \n",
       "3  Rebecca was a great host!  She was very friend...  \n",
       "4  We had a wonderful time in this cabin with our...  "
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_csv('reviews.csv')\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "id": "ccfbb9b1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['listing_id', 'id', 'date', 'reviewer_id', 'reviewer_name', 'comments'], dtype='object')"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "id": "a4b2dbad",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "listing_id         0\n",
       "id                 0\n",
       "date               0\n",
       "reviewer_id        0\n",
       "reviewer_name      2\n",
       "comments         325\n",
       "dtype: int64"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check missing value\n",
    "df.isnull().sum()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "id": "3f551f86",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1398664, 6)"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check number of rows\n",
    "df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "225a7981",
   "metadata": {},
   "source": [
    "#### Since we have more than 1 millions data, so we are going to drop the nan value."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "id": "a65256eb",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>109</td>\n",
       "      <td>449036</td>\n",
       "      <td>2011-08-15</td>\n",
       "      <td>927861</td>\n",
       "      <td>Edwin</td>\n",
       "      <td>The host canceled my reservation the day befor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>109</td>\n",
       "      <td>74506539</td>\n",
       "      <td>2016-05-15</td>\n",
       "      <td>22509885</td>\n",
       "      <td>Jenn</td>\n",
       "      <td>Me and two friends stayed for four and a half ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2708</td>\n",
       "      <td>13994902</td>\n",
       "      <td>2014-06-09</td>\n",
       "      <td>10905424</td>\n",
       "      <td>Kuberan</td>\n",
       "      <td>i had a wonderful stay. Everything from start ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>180926</td>\n",
       "      <td>424635</td>\n",
       "      <td>2011-08-06</td>\n",
       "      <td>892106</td>\n",
       "      <td>Brian</td>\n",
       "      <td>Rebecca was a great host!  She was very friend...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>180926</td>\n",
       "      <td>13396837</td>\n",
       "      <td>2014-05-26</td>\n",
       "      <td>3220350</td>\n",
       "      <td>Julia</td>\n",
       "      <td>We had a wonderful time in this cabin with our...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   listing_id        id        date  reviewer_id reviewer_name   \n",
       "0         109    449036  2011-08-15       927861         Edwin  \\\n",
       "1         109  74506539  2016-05-15     22509885          Jenn   \n",
       "2        2708  13994902  2014-06-09     10905424       Kuberan   \n",
       "3      180926    424635  2011-08-06       892106         Brian   \n",
       "4      180926  13396837  2014-05-26      3220350         Julia   \n",
       "\n",
       "                                            comments  \n",
       "0  The host canceled my reservation the day befor...  \n",
       "1  Me and two friends stayed for four and a half ...  \n",
       "2  i had a wonderful stay. Everything from start ...  \n",
       "3  Rebecca was a great host!  She was very friend...  \n",
       "4  We had a wonderful time in this cabin with our...  "
      ]
     },
     "execution_count": 6,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dropna()\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c20a3883",
   "metadata": {},
   "source": [
    "#### Since this is a large dataset, we want to try with a small dataset to test our code, and see what values inside comments."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "id": "00feac90",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(10000, 6)"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# We randomly select 10k rows from orginal dataframe.\n",
    "test_df = df.sample(n=10000)\n",
    "test_df = test_df.reset_index(drop=True)\n",
    "test_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "id": "c92a4f1f",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Detect language\n",
    "def detect_language(text):\n",
    "    try:\n",
    "        return detect(text)\n",
    "    except:\n",
    "        return 'Error'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "id": "5f1106b9",
   "metadata": {},
   "outputs": [],
   "source": [
    "test_df['language'] = test_df['comments'].apply(detect_language)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "id": "f31bd06b",
   "metadata": {},
   "outputs": [],
   "source": [
    "# We want to fully display the value in a cell. \n",
    "pd.set_option('display.max_colwidth', None)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "id": "65d5df15",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>6959</th>\n",
       "      <td>18960421</td>\n",
       "      <td>597116270936607326</td>\n",
       "      <td>2022-04-03</td>\n",
       "      <td>4112501</td>\n",
       "      <td>Ann</td>\n",
       "      <td>All the other reviewers are accurate in descriptions of this listing in terms of comfort, location, etc. great place overall. &lt;br/&gt;&lt;br/&gt;The neighbor does have a large dog and the owner also has a small dog. Both dogs bark periodically, including at night.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1860</th>\n",
       "      <td>37915615</td>\n",
       "      <td>700956697</td>\n",
       "      <td>2020-10-16</td>\n",
       "      <td>23193060</td>\n",
       "      <td>Rob</td>\n",
       "      <td>Wonder place to stay.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7650</th>\n",
       "      <td>23844300</td>\n",
       "      <td>630115289</td>\n",
       "      <td>2020-06-16</td>\n",
       "      <td>122279480</td>\n",
       "      <td>Samuel</td>\n",
       "      <td>Ralph's place is amazing with incredible views of topanga canyon! We appreciated that there were all the cooking basics and even a dishwasher.  It was in a great location and close enough for multiple day trips to awesome southern california destinations. Very clean and worth the stay.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3270</th>\n",
       "      <td>20235457</td>\n",
       "      <td>240424077</td>\n",
       "      <td>2018-03-04</td>\n",
       "      <td>68523532</td>\n",
       "      <td>Jaclyn</td>\n",
       "      <td>We stayed here for a girls trip, and the house was perfect! Not only want the location beautiful the house was comfy and cozy. All the beds were so comfortable and there were plenty of amenities for all of us. Chris was a wonderful host!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3672</th>\n",
       "      <td>734008696855755257</td>\n",
       "      <td>834917563524891632</td>\n",
       "      <td>2023-02-25</td>\n",
       "      <td>333131712</td>\n",
       "      <td>Alejandra</td>\n",
       "      <td>Awesome place!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4042</th>\n",
       "      <td>15356852</td>\n",
       "      <td>561144520</td>\n",
       "      <td>2019-11-08</td>\n",
       "      <td>31614617</td>\n",
       "      <td>Amy</td>\n",
       "      <td>Lovely place with a cute patio with fireplace and hot tub. The space is very quaint which fit 2 guests perfectly. There were a few things that could be improved (shower head leaking water to the outside of the bathroom) and some ants but overall it was still bearable and more just nuisances. I would still recommend this place as Silver Lake is a cute neighborhood!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6823</th>\n",
       "      <td>3227096</td>\n",
       "      <td>59495804</td>\n",
       "      <td>2016-01-11</td>\n",
       "      <td>217354</td>\n",
       "      <td>Jennifer</td>\n",
       "      <td>Eric was a fantastic host, very friendly and responsive, and I absolutely loved his place. Quiet, comfortable, well laid out, with everything I needed for a great weeklong stay. Great view out the main window. And there was even a beautiful bouquet of flowers on the table when I arrived, and he had thoughtfully brought in extra heaters and blanket, since there was cold weather in the forecast. Also really appreciated being able to bring my dog. Would definitely stay here again. Thank you!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1584</th>\n",
       "      <td>37911722</td>\n",
       "      <td>730108848</td>\n",
       "      <td>2021-02-09</td>\n",
       "      <td>117966637</td>\n",
       "      <td>Christina</td>\n",
       "      <td>Highly recommend!! Everything was great to the home and location.  The home can get chilly at times the space heater helps and opening the blinds to allow sun worked to keep warm.  The best host you’ll experience, can’t wait to return on next visit.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8033</th>\n",
       "      <td>27402338</td>\n",
       "      <td>459848784</td>\n",
       "      <td>2019-05-27</td>\n",
       "      <td>194705607</td>\n",
       "      <td>Troy</td>\n",
       "      <td>Wendy is a wonderful host. The home is beautiful and the views are amazing! We really enjoyed our family time in this beautiful setting. Everything was so much more than we expected. Thank you so much for making our time special!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7243</th>\n",
       "      <td>51910351</td>\n",
       "      <td>605084841893493717</td>\n",
       "      <td>2022-04-14</td>\n",
       "      <td>123638879</td>\n",
       "      <td>Yannick</td>\n",
       "      <td>I had an amazing stay. Very beautiful and clean apt. Thanks for the excellent communication.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4041</th>\n",
       "      <td>18854117</td>\n",
       "      <td>747922423440410890</td>\n",
       "      <td>2022-10-28</td>\n",
       "      <td>446068667</td>\n",
       "      <td>Katya</td>\n",
       "      <td>Cozy little place that offers everything you need for a pleasant stay!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7961</th>\n",
       "      <td>26417268</td>\n",
       "      <td>619563328707464823</td>\n",
       "      <td>2022-05-04</td>\n",
       "      <td>333424866</td>\n",
       "      <td>Charles</td>\n",
       "      <td>The place was nice though the tub and shower situation could use some work. It is in a GREAT location two blocks from Route 66. Lots of great food choices in the area. Easy access in and out of the place. Also easy to get on the highway from the location.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4066</th>\n",
       "      <td>6386860</td>\n",
       "      <td>481904438093377670</td>\n",
       "      <td>2021-10-26</td>\n",
       "      <td>10284865</td>\n",
       "      <td>Faith</td>\n",
       "      <td>What a lovely month that I had staying in this hillside cabin. True to all the reviews left prior for Will and to the space-I am glad that I also got the same opportunity to be a part of this wonderful experience.&lt;br/&gt;1)\\tThis spot was perfect for one person. &lt;br/&gt;2)\\tAll my basic needs were met. Onsite parking that you will become a pro at manuevering in and out of.  Will also gave great tips on backing into the spot.&lt;br/&gt;3)\\tI fully enjoyed the patio space for my meals, reading, working on my laptop, and enjoying nature along with sunsets.&lt;br/&gt;4)\\tThe space will also really discipline you to buy just enough grocery for the week and eat everything up. It really feeds into my minimalist side. Costco shopping might not work unless you find friends/colleagues to split portions up.&lt;br/&gt;5)\\tThe space has three windows and bring a comfortable breeze and plenty of sunshine into the cabin.&lt;br/&gt;6)\\tWill keeps the cabin really clean and supplies everything that you need. If you ever have a question, he is quick to respond. One time, I needed pliers for fixing something of mine, and the next day it appeared in front of the cabin &lt;br/&gt;7)\\tWill provides you with an amazing snack basket upon arrival and it will last you for a week a good long time. &lt;br/&gt;8)\\tThroughout my stay, Will offered additional fresh fruits and snacks.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8967</th>\n",
       "      <td>31908993</td>\n",
       "      <td>660334536</td>\n",
       "      <td>2020-09-04</td>\n",
       "      <td>231717107</td>\n",
       "      <td>Kedravious</td>\n",
       "      <td>Nice place to stay.  Just no AC</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9103</th>\n",
       "      <td>25547280</td>\n",
       "      <td>590648803183637663</td>\n",
       "      <td>2022-03-25</td>\n",
       "      <td>24225563</td>\n",
       "      <td>Lisa</td>\n",
       "      <td>A lovely garden room. Thea was helpful and welcoming. The room was well-appointed and the bed very comfortable.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3314</th>\n",
       "      <td>32902278</td>\n",
       "      <td>627110870</td>\n",
       "      <td>2020-05-31</td>\n",
       "      <td>194977348</td>\n",
       "      <td>Aleyda</td>\n",
       "      <td>Amanda’s cottage has a great location, it’s a comfortable space. Beautiful touches in and outside of the property. I love all the house plants inside of the cottage and the overall peacefulness of the place.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6632</th>\n",
       "      <td>23545678</td>\n",
       "      <td>503871083</td>\n",
       "      <td>2019-08-06</td>\n",
       "      <td>282221849</td>\n",
       "      <td>Bryce</td>\n",
       "      <td>Great place! Takes the idea of an Airbnb and adds an extra level of usefulness by cultivating a community of creativity. Friendly and family oriented. Definitely would recommend, definitely staying again.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6409</th>\n",
       "      <td>9974487</td>\n",
       "      <td>502992528284103201</td>\n",
       "      <td>2021-11-24</td>\n",
       "      <td>357925674</td>\n",
       "      <td>Jessica</td>\n",
       "      <td>Really close to a lot of stuff and nice private space</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3520</th>\n",
       "      <td>5184818</td>\n",
       "      <td>700115450374136153</td>\n",
       "      <td>2022-08-23</td>\n",
       "      <td>247698158</td>\n",
       "      <td>Kaitlyn</td>\n",
       "      <td>i really hate to have to do this i’ve never had to do this before but want to warn others.. first i will say this house is beautiful, it’s nice and has everything needed! however during our stay the wifi was out the entire stay.. we asked the host if we can fix it, they told us we have to go up on their attic on a 10ft ladder to fix the wifi.. i was nice and told the host i just had a acl tear and i don’t feel comfortable climbing a ladder and they kept saying it was the only way to fix it.. not once did they offer to come out and fix it for us they kept bugging to call us and saying to do it ourselves when we said we didn’t feel&lt;br/&gt;comfortable.. also the amount of rules and stuff the host send us overwhelming like it’s crazy it’s like your working to for them when you leave  .. so just a heads up i didn’t want to have to do this i tried to peacefully message them to fix this but they denied and denied after our stay to make things better so beware before booking! between the all the rules and everything it feels like a job to stay here</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4840</th>\n",
       "      <td>12431405</td>\n",
       "      <td>82966783</td>\n",
       "      <td>2016-06-30</td>\n",
       "      <td>38638072</td>\n",
       "      <td>Alessandro</td>\n",
       "      <td>What an inviting house to come to after a long drive. Helanie and her family made us feel immediately comfortable and welcomed when we arrived, and so throughout our whole stay. The room is spacious, the bed divine and the bathroom two steps from the room. Also the fan saved us at night as it can get warm in that area. A lovely breakfast awaited us in the morning, really appreciated it! I was given a list of things to do and see in LA by Helanie's daughter which I am really grateful for. All in all I would definitely recommend this place to anyone, as I doubt you could come across a sweeter and more cheerful family!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1613</th>\n",
       "      <td>16497826</td>\n",
       "      <td>395695685277364652</td>\n",
       "      <td>2021-06-29</td>\n",
       "      <td>276072689</td>\n",
       "      <td>Emily</td>\n",
       "      <td>Overall the space was very spacious, cute, and comfortable. The location was great for where we wanted to go. We had some issues with the wifi. We were told there was a washer which was not the case but there was a laundry mat across the street that was very nice that we ended up using. Parking was easy to find and and we really enjoyed the taco shop nearby.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1271</th>\n",
       "      <td>696061</td>\n",
       "      <td>27844992</td>\n",
       "      <td>2015-03-13</td>\n",
       "      <td>10880062</td>\n",
       "      <td>Jason</td>\n",
       "      <td>Staying at Buz's place allowed us to engage the local culture and activities with ease and immediacy...one block walk and you are there! Moreover, from here we were able drive to Sanata Monica, LA and Hollywood quickly (even with the LA traffic being what it is). In short, you really can't go wrong staying at Buz's place. Thanks Buz!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6359</th>\n",
       "      <td>11606890</td>\n",
       "      <td>237938661</td>\n",
       "      <td>2018-02-24</td>\n",
       "      <td>148004788</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>Everything about this place is wonderful I give it 5 stars overall.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3706</th>\n",
       "      <td>50912459</td>\n",
       "      <td>728346941179179741</td>\n",
       "      <td>2022-10-01</td>\n",
       "      <td>68377964</td>\n",
       "      <td>Nathalie</td>\n",
       "      <td>Great location!! Very clean. Very well stocked. But noisy street. Better suited for two people who can share the bedroom that is away from the windows. Convenience store and CVS just steps away. Fantastic restaurants/bar just next to the building.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5594</th>\n",
       "      <td>48632945</td>\n",
       "      <td>446355064898803884</td>\n",
       "      <td>2021-09-07</td>\n",
       "      <td>64061936</td>\n",
       "      <td>Judy</td>\n",
       "      <td>This place is magical! Our kids had so much fun and didn’t want to leave.  I would definitely stay again!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1705</th>\n",
       "      <td>1408665</td>\n",
       "      <td>418638718</td>\n",
       "      <td>2019-03-02</td>\n",
       "      <td>148410472</td>\n",
       "      <td>Mateo</td>\n",
       "      <td>Beautiful place</td>\n",
       "      <td>ro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2765</th>\n",
       "      <td>958435</td>\n",
       "      <td>46291459</td>\n",
       "      <td>2015-09-09</td>\n",
       "      <td>38463509</td>\n",
       "      <td>Katherine</td>\n",
       "      <td>I spent quite a bit of time reading previous reviews, and I can say the house lived up to my expectations. It was clean, comfortable and had all the amenities we could have hoped for. I really couldn't have asked for more in terms of the home - and its proximity to the beach, shops, etc. made it easy to get around (although we did just stay at the house for most evenings!)\\r&lt;br/&gt;\\r&lt;br/&gt;In addition, Ray was very responsive and had everything set up so that we really felt at home for a long weekend. I wouldn't hesitate to stay there again, especially with Ray as the host!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2364</th>\n",
       "      <td>1243943</td>\n",
       "      <td>753701739</td>\n",
       "      <td>2021-05-01</td>\n",
       "      <td>166272912</td>\n",
       "      <td>Ryan</td>\n",
       "      <td>Fantastic host. Spectacular home. Thank you for hosting us. Would love to stay there again!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>759</th>\n",
       "      <td>2604409</td>\n",
       "      <td>12664084</td>\n",
       "      <td>2014-05-07</td>\n",
       "      <td>12870539</td>\n",
       "      <td>Ardith</td>\n",
       "      <td>We had a great experience at the Casaredondela as it was within walking distance of our son's home with whom we were visiting.  Unfortunately Mike was out of town and we didn't get to meet him in person, but he made satisfactory arrangements for our arrival and departure.  The hideaway is small, but the bed is comfortable, nice linens, TV, bathroom adequate and the kitchenette well-stocked. A toaster would have been a welcome addition to the \"kitchen\". This is a converted closet-kitchen, very compact and no sink for dish clean-up (except outside or in bathroom). The apartment was clean and the neighborhood quiet. We felt safe walking at night.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4326</th>\n",
       "      <td>635549294691530389</td>\n",
       "      <td>840750465883649862</td>\n",
       "      <td>2023-03-05</td>\n",
       "      <td>10930193</td>\n",
       "      <td>Megan</td>\n",
       "      <td>We enjoyed our stay. It was great to have so many bathrooms so everyone had space to get ready. Neighbors were a bit loud one of the nights, but was possibly just an anomaly. Overall it had everything we needed and was located centrally so getting food delivered was no problem. Hosts were responsive and friendly!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3171</th>\n",
       "      <td>15363623</td>\n",
       "      <td>483740379</td>\n",
       "      <td>2019-07-07</td>\n",
       "      <td>35013990</td>\n",
       "      <td>Ruby</td>\n",
       "      <td>Tanya was amazing! Her place was absolutely lovely! It was exactly what we needed! Everything was super clean and the style was so cute! Definitely recommend</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3181</th>\n",
       "      <td>36879034</td>\n",
       "      <td>513564198</td>\n",
       "      <td>2019-08-19</td>\n",
       "      <td>46038971</td>\n",
       "      <td>Marisa</td>\n",
       "      <td>This place was beyond amazing. Super clean and in a great neighborhood with zero hassle parking. I forgot to pack toiletries but Ara had travel sized shampoo &amp; conditioner that saved the day. Highly recommend staying here if you’re looking for a quality air bnb!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7719</th>\n",
       "      <td>740673899758651445</td>\n",
       "      <td>800068304163744232</td>\n",
       "      <td>2023-01-08</td>\n",
       "      <td>51033135</td>\n",
       "      <td>Ahuitz</td>\n",
       "      <td>Such a warm and comfy place! We had a lovely time staying here. We had access to grill, cook, and enjoy a delicious dinner in the beautiful kitchen/ dining area. Parking was convenient. Completely satisfied with our stay!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4594</th>\n",
       "      <td>9515835</td>\n",
       "      <td>109979403</td>\n",
       "      <td>2016-10-23</td>\n",
       "      <td>2268715</td>\n",
       "      <td>Jackie</td>\n",
       "      <td>Thank you! We loved our stay, the apartment was terrific and our host was very friendly and welcoming. The location was absolutely ideal for walking to the beach and Main St. We borrowed the 2 bikes to head to Manhattan Beach--what a lovely bike ride. We definitely hope to return to Santa Monica and would love to stay here when we do. Thanks again!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9682</th>\n",
       "      <td>50307044</td>\n",
       "      <td>754490979035458668</td>\n",
       "      <td>2022-11-06</td>\n",
       "      <td>60216728</td>\n",
       "      <td>Rhonda</td>\n",
       "      <td>Nicely updated apt near shops and restaurants. Never met Rachel but she always answered texts.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7343</th>\n",
       "      <td>44506198</td>\n",
       "      <td>759370235</td>\n",
       "      <td>2021-05-16</td>\n",
       "      <td>10035830</td>\n",
       "      <td>Caitlin</td>\n",
       "      <td>Sweet little spot in the heart of the cutest neighborhood.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9706</th>\n",
       "      <td>16790728</td>\n",
       "      <td>205283755</td>\n",
       "      <td>2017-10-21</td>\n",
       "      <td>44868349</td>\n",
       "      <td>Ruben</td>\n",
       "      <td>Quiet, clean neighborhood with a view of the mountains in the horizon. Kerri was very kind and very easy to reach. Important to note that there are other guests in multiple rooms, so the place is set up like a bed and breakfast. Backyard is huge and everything (restaurants, gas stations theatres, etc) is only a few blocks down.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9293</th>\n",
       "      <td>48172578</td>\n",
       "      <td>552191953582051081</td>\n",
       "      <td>2022-01-31</td>\n",
       "      <td>5091766</td>\n",
       "      <td>Emily</td>\n",
       "      <td>We had such a fantastic stay at Karla and Nathan's apartment. It was spotless when we arrived, and throughout our stay there were super communicative and quick to respond to any questions we had. It's been properly set up as a home, rather than temporary accommodation so there's literally everything you could possibly need (sharp knives included). They're also really lovely people! 10/10 would recommend.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3508</th>\n",
       "      <td>15817479</td>\n",
       "      <td>281372482</td>\n",
       "      <td>2018-06-24</td>\n",
       "      <td>16635292</td>\n",
       "      <td>Sourav</td>\n",
       "      <td>Robert was a nice and helpful host. Met us for check in and let us get settled in immediately.  We were exhausted after a local 5K so that was much appreciated.  We were there for such a short time that we didn't use the wifi, but I would have appreciated a printout or something in the room. Not a big deal. He has two amazing dogs who are so friendly! I wish we had had more time spend there and hangout.  We left the wrong keys upon leaving and he helped coordinate an exchange the next day.  He had local recommendations as well which were appreciated!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2231</th>\n",
       "      <td>17443238</td>\n",
       "      <td>597511947</td>\n",
       "      <td>2020-01-25</td>\n",
       "      <td>27632358</td>\n",
       "      <td>Yiming</td>\n",
       "      <td>We had a great night at Mick &amp; Misty’s place. Since I mentioned that we had 4 people, they even made all beds (sofa bed and the extra mattress) for us beforehand. Mick and Misty are very friendly and responding to our questions very quickly. The place is also super clean and well decorated. Definitely recommended!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1078</th>\n",
       "      <td>38383086</td>\n",
       "      <td>541122832</td>\n",
       "      <td>2019-10-04</td>\n",
       "      <td>296419709</td>\n",
       "      <td>Corrine</td>\n",
       "      <td>Gabe goes above and beyond to make sure his guests are accommodated and comfortable! He makes you feel at home when visiting a new city! If we are ever in California again, we will be sure to stay with Gabe! I 100% recommend this bnb to anyone looking in the area! The room was clean and comfortable as well as the shared bathroom and living spaces!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8428</th>\n",
       "      <td>608853421060858978</td>\n",
       "      <td>650773948854033833</td>\n",
       "      <td>2022-06-16</td>\n",
       "      <td>231004508</td>\n",
       "      <td>Chun-Lin</td>\n",
       "      <td>The place is really comfortable</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2499</th>\n",
       "      <td>2263028</td>\n",
       "      <td>277187650</td>\n",
       "      <td>2018-06-15</td>\n",
       "      <td>184907409</td>\n",
       "      <td>Former member</td>\n",
       "      <td>很漂亮的房子 睡觉的房间远离马路 很安静 停车也很方便 机场下来十几分钟就能到。非常方便。</td>\n",
       "      <td>zh-cn</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6981</th>\n",
       "      <td>20996440</td>\n",
       "      <td>500208813</td>\n",
       "      <td>2019-08-01</td>\n",
       "      <td>271654634</td>\n",
       "      <td>Angela</td>\n",
       "      <td>Everything as expected. Pool was definitely the best part!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7096</th>\n",
       "      <td>34566501</td>\n",
       "      <td>757151783</td>\n",
       "      <td>2021-05-10</td>\n",
       "      <td>19249071</td>\n",
       "      <td>Kimberly</td>\n",
       "      <td>This is a perfect little getaway spot! The RV is spacious and the bed is so comfortable!! Everything was clean and we appreciated how well stocked the cupboards were with household essentials. The backyard and pool are pristine and so enjoyable!! We will absolutely be back again!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4185</th>\n",
       "      <td>13766525</td>\n",
       "      <td>123995858</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>97637062</td>\n",
       "      <td>Max</td>\n",
       "      <td>Mary is a great host!  Very attentive and helpful throughout my stay.  The studio is clean and tastefully updated.  Bed is super comfortable and the place has everything from bedding and toiletries to a full kitchen with all the dishes/pots and pans etc..  Fast WiFi too, which is a +.&lt;br/&gt; I totally recommend staying here and having Mary as a host.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3092</th>\n",
       "      <td>29235527</td>\n",
       "      <td>644015319</td>\n",
       "      <td>2020-07-29</td>\n",
       "      <td>102841549</td>\n",
       "      <td>Joshua</td>\n",
       "      <td>I'll start by saying we stayed here for almost 2 weeks. To be honest, we would have stayed another 2 weeks if we could have! The touches in this space were the best of any Airbnb we have stayed in at this price point. I love a soft comfy bed and pillows that your head just sinks into and that was exactly what they had here. My wife and I were here doing some business planning and just needed a space that we could work from and it was well provided. The couch, the dinner table, and the outdoor patio were great! You also can't beat only being about 3 blocks from the beach and boardwalk. This family has multiple other listings so if this one isn't available I would highly recommend one of their other properties. If they put as much care and thought into one I would imagine they spread that same care to their other listings.&lt;br/&gt;&lt;br/&gt;Thank you again for a wonderful stay!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2125</th>\n",
       "      <td>35304145</td>\n",
       "      <td>485588184132717056</td>\n",
       "      <td>2021-10-31</td>\n",
       "      <td>180156606</td>\n",
       "      <td>Zion</td>\n",
       "      <td>Beautiful family vacation. My children and I felt right at home. Veronica was excellent with communicating and made sure our stay was comfortable and enjoyable. Perfect location and Amazing views. Looking forward to coming back. Thanks Again Veronica.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6439</th>\n",
       "      <td>7513709</td>\n",
       "      <td>453071255</td>\n",
       "      <td>2019-05-14</td>\n",
       "      <td>51499924</td>\n",
       "      <td>Sarah</td>\n",
       "      <td>Room was exactly like what’s shown on the pictures, hosts were great and helpful, place was clean and location was great too!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7816</th>\n",
       "      <td>20946612</td>\n",
       "      <td>468565636</td>\n",
       "      <td>2019-06-12</td>\n",
       "      <td>251979061</td>\n",
       "      <td>Edward</td>\n",
       "      <td>This was my first time staying at an Airbnb and I must say the bar has been set very high!  Megan made everything very easy. Everything about the place was fantastic for sure.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1723</th>\n",
       "      <td>23688368</td>\n",
       "      <td>431372599</td>\n",
       "      <td>2019-03-31</td>\n",
       "      <td>208040131</td>\n",
       "      <td>Ayrial</td>\n",
       "      <td>The space was beautiful and Biana and Tony were very helpful. The only thing I would say was a bit strange was that their home was on the property. For the most part our visit was pretty private but we did walk in on a birthday party which was awkward. But overall it was a nice home and they were there to accommodate and help us on our visit</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2580</th>\n",
       "      <td>51246620</td>\n",
       "      <td>506583927228313658</td>\n",
       "      <td>2021-11-29</td>\n",
       "      <td>260802742</td>\n",
       "      <td>Arrianne</td>\n",
       "      <td>Daniel is genuinely one of the best hosts we’ve had before! He was very welcoming with this home and everything was very neat and clean. The condominium is stunning with amazing views of the mountains. The neighborhood area is very nice and safe as well. You will not regret it if you choose to stay here!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6029</th>\n",
       "      <td>3255501</td>\n",
       "      <td>191241911</td>\n",
       "      <td>2017-09-06</td>\n",
       "      <td>135843866</td>\n",
       "      <td>Lili</td>\n",
       "      <td>Awesome spot! Would reccommend!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3159</th>\n",
       "      <td>39002364</td>\n",
       "      <td>600047483</td>\n",
       "      <td>2020-01-31</td>\n",
       "      <td>41730237</td>\n",
       "      <td>Nancy</td>\n",
       "      <td>The amazing beautiful photos are accurate!  What a great place to stay within walking distance of so much in Pasadena.  &lt;br/&gt;&lt;br/&gt;Modern and clean!  The kitchen appliances were so amazing that we decided to stay in and cook one night instead of going to the great restaurants close by.  Traders Joes is just a block away.&lt;br/&gt;&lt;br/&gt;Very quiet.  Very secure feeling.  Indoor gated garage.  Great host.  We will definitely stay here for future trips to Pasadena.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8406</th>\n",
       "      <td>7845614</td>\n",
       "      <td>199397551</td>\n",
       "      <td>2017-10-01</td>\n",
       "      <td>152266552</td>\n",
       "      <td>Michael</td>\n",
       "      <td>This was a great location, in a very quiet neighborhood, located in a very busy city. We locked ourselves out and the host responded in 10 minutes to get us back in. Great service. The beds were very comfortable and there was enough parking for 3 cars in the driveway. We had a wonderful time and look forward to visiting this little beauty again soon.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7172</th>\n",
       "      <td>9048768</td>\n",
       "      <td>161088587</td>\n",
       "      <td>2017-06-16</td>\n",
       "      <td>134490529</td>\n",
       "      <td>金秋</td>\n",
       "      <td>clean and quite, nice place. near the bus station, several mins to downtown and usc.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3959</th>\n",
       "      <td>21714396</td>\n",
       "      <td>727523053</td>\n",
       "      <td>2021-01-29</td>\n",
       "      <td>357729481</td>\n",
       "      <td>Haley</td>\n",
       "      <td>Gabriela’s place was very clean and comfortable. The location is amazing and we really enjoyed our stay! Would definitely recommend!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9717</th>\n",
       "      <td>49021466</td>\n",
       "      <td>584055476135108131</td>\n",
       "      <td>2022-03-16</td>\n",
       "      <td>159844657</td>\n",
       "      <td>Samantha</td>\n",
       "      <td>This is cute place in a nice, very quiet location.  We felt secure and would stay here again!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8581</th>\n",
       "      <td>3440825</td>\n",
       "      <td>666444683</td>\n",
       "      <td>2020-09-20</td>\n",
       "      <td>362774326</td>\n",
       "      <td>John</td>\n",
       "      <td>Amazing! Picture perfect view, beautiful pool and pool house.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6292</th>\n",
       "      <td>6835580</td>\n",
       "      <td>718963240861542608</td>\n",
       "      <td>2022-09-18</td>\n",
       "      <td>16527498</td>\n",
       "      <td>Jessica</td>\n",
       "      <td>What a beautiful home and excellent location! Extraordinarily clean and comfortable. It was the perfect spot for my small family.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              listing_id                  id        date  reviewer_id   \n",
       "6959            18960421  597116270936607326  2022-04-03      4112501  \\\n",
       "1860            37915615           700956697  2020-10-16     23193060   \n",
       "7650            23844300           630115289  2020-06-16    122279480   \n",
       "3270            20235457           240424077  2018-03-04     68523532   \n",
       "3672  734008696855755257  834917563524891632  2023-02-25    333131712   \n",
       "4042            15356852           561144520  2019-11-08     31614617   \n",
       "6823             3227096            59495804  2016-01-11       217354   \n",
       "1584            37911722           730108848  2021-02-09    117966637   \n",
       "8033            27402338           459848784  2019-05-27    194705607   \n",
       "7243            51910351  605084841893493717  2022-04-14    123638879   \n",
       "4041            18854117  747922423440410890  2022-10-28    446068667   \n",
       "7961            26417268  619563328707464823  2022-05-04    333424866   \n",
       "4066             6386860  481904438093377670  2021-10-26     10284865   \n",
       "8967            31908993           660334536  2020-09-04    231717107   \n",
       "9103            25547280  590648803183637663  2022-03-25     24225563   \n",
       "3314            32902278           627110870  2020-05-31    194977348   \n",
       "6632            23545678           503871083  2019-08-06    282221849   \n",
       "6409             9974487  502992528284103201  2021-11-24    357925674   \n",
       "3520             5184818  700115450374136153  2022-08-23    247698158   \n",
       "4840            12431405            82966783  2016-06-30     38638072   \n",
       "1613            16497826  395695685277364652  2021-06-29    276072689   \n",
       "1271              696061            27844992  2015-03-13     10880062   \n",
       "6359            11606890           237938661  2018-02-24    148004788   \n",
       "3706            50912459  728346941179179741  2022-10-01     68377964   \n",
       "5594            48632945  446355064898803884  2021-09-07     64061936   \n",
       "1705             1408665           418638718  2019-03-02    148410472   \n",
       "2765              958435            46291459  2015-09-09     38463509   \n",
       "2364             1243943           753701739  2021-05-01    166272912   \n",
       "759              2604409            12664084  2014-05-07     12870539   \n",
       "4326  635549294691530389  840750465883649862  2023-03-05     10930193   \n",
       "3171            15363623           483740379  2019-07-07     35013990   \n",
       "3181            36879034           513564198  2019-08-19     46038971   \n",
       "7719  740673899758651445  800068304163744232  2023-01-08     51033135   \n",
       "4594             9515835           109979403  2016-10-23      2268715   \n",
       "9682            50307044  754490979035458668  2022-11-06     60216728   \n",
       "7343            44506198           759370235  2021-05-16     10035830   \n",
       "9706            16790728           205283755  2017-10-21     44868349   \n",
       "9293            48172578  552191953582051081  2022-01-31      5091766   \n",
       "3508            15817479           281372482  2018-06-24     16635292   \n",
       "2231            17443238           597511947  2020-01-25     27632358   \n",
       "1078            38383086           541122832  2019-10-04    296419709   \n",
       "8428  608853421060858978  650773948854033833  2022-06-16    231004508   \n",
       "2499             2263028           277187650  2018-06-15    184907409   \n",
       "6981            20996440           500208813  2019-08-01    271654634   \n",
       "7096            34566501           757151783  2021-05-10     19249071   \n",
       "4185            13766525           123995858  2016-12-31     97637062   \n",
       "3092            29235527           644015319  2020-07-29    102841549   \n",
       "2125            35304145  485588184132717056  2021-10-31    180156606   \n",
       "6439             7513709           453071255  2019-05-14     51499924   \n",
       "7816            20946612           468565636  2019-06-12    251979061   \n",
       "1723            23688368           431372599  2019-03-31    208040131   \n",
       "2580            51246620  506583927228313658  2021-11-29    260802742   \n",
       "6029             3255501           191241911  2017-09-06    135843866   \n",
       "3159            39002364           600047483  2020-01-31     41730237   \n",
       "8406             7845614           199397551  2017-10-01    152266552   \n",
       "7172             9048768           161088587  2017-06-16    134490529   \n",
       "3959            21714396           727523053  2021-01-29    357729481   \n",
       "9717            49021466  584055476135108131  2022-03-16    159844657   \n",
       "8581             3440825           666444683  2020-09-20    362774326   \n",
       "6292             6835580  718963240861542608  2022-09-18     16527498   \n",
       "\n",
       "      reviewer_name   \n",
       "6959            Ann  \\\n",
       "1860            Rob   \n",
       "7650         Samuel   \n",
       "3270         Jaclyn   \n",
       "3672      Alejandra   \n",
       "4042            Amy   \n",
       "6823       Jennifer   \n",
       "1584      Christina   \n",
       "8033           Troy   \n",
       "7243        Yannick   \n",
       "4041          Katya   \n",
       "7961        Charles   \n",
       "4066          Faith   \n",
       "8967     Kedravious   \n",
       "9103           Lisa   \n",
       "3314         Aleyda   \n",
       "6632          Bryce   \n",
       "6409        Jessica   \n",
       "3520        Kaitlyn   \n",
       "4840     Alessandro   \n",
       "1613          Emily   \n",
       "1271          Jason   \n",
       "6359        Matthew   \n",
       "3706       Nathalie   \n",
       "5594           Judy   \n",
       "1705          Mateo   \n",
       "2765      Katherine   \n",
       "2364           Ryan   \n",
       "759          Ardith   \n",
       "4326          Megan   \n",
       "3171           Ruby   \n",
       "3181         Marisa   \n",
       "7719         Ahuitz   \n",
       "4594         Jackie   \n",
       "9682         Rhonda   \n",
       "7343        Caitlin   \n",
       "9706          Ruben   \n",
       "9293          Emily   \n",
       "3508         Sourav   \n",
       "2231         Yiming   \n",
       "1078        Corrine   \n",
       "8428       Chun-Lin   \n",
       "2499  Former member   \n",
       "6981         Angela   \n",
       "7096       Kimberly   \n",
       "4185            Max   \n",
       "3092         Joshua   \n",
       "2125           Zion   \n",
       "6439          Sarah   \n",
       "7816         Edward   \n",
       "1723         Ayrial   \n",
       "2580       Arrianne   \n",
       "6029           Lili   \n",
       "3159          Nancy   \n",
       "8406        Michael   \n",
       "7172             金秋   \n",
       "3959          Haley   \n",
       "9717       Samantha   \n",
       "8581           John   \n",
       "6292        Jessica   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    comments   \n",
       "6959                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         All the other reviewers are accurate in descriptions of this listing in terms of comfort, location, etc. great place overall. <br/><br/>The neighbor does have a large dog and the owner also has a small dog. Both dogs bark periodically, including at night.  \\\n",
       "1860                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Wonder place to stay.   \n",
       "7650                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Ralph's place is amazing with incredible views of topanga canyon! We appreciated that there were all the cooking basics and even a dishwasher.  It was in a great location and close enough for multiple day trips to awesome southern california destinations. Very clean and worth the stay.   \n",
       "3270                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           We stayed here for a girls trip, and the house was perfect! Not only want the location beautiful the house was comfy and cozy. All the beds were so comfortable and there were plenty of amenities for all of us. Chris was a wonderful host!   \n",
       "3672                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Awesome place!   \n",
       "4042                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Lovely place with a cute patio with fireplace and hot tub. The space is very quaint which fit 2 guests perfectly. There were a few things that could be improved (shower head leaking water to the outside of the bathroom) and some ants but overall it was still bearable and more just nuisances. I would still recommend this place as Silver Lake is a cute neighborhood!   \n",
       "6823                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Eric was a fantastic host, very friendly and responsive, and I absolutely loved his place. Quiet, comfortable, well laid out, with everything I needed for a great weeklong stay. Great view out the main window. And there was even a beautiful bouquet of flowers on the table when I arrived, and he had thoughtfully brought in extra heaters and blanket, since there was cold weather in the forecast. Also really appreciated being able to bring my dog. Would definitely stay here again. Thank you!   \n",
       "1584                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               Highly recommend!! Everything was great to the home and location.  The home can get chilly at times the space heater helps and opening the blinds to allow sun worked to keep warm.  The best host you’ll experience, can’t wait to return on next visit.   \n",
       "8033                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Wendy is a wonderful host. The home is beautiful and the views are amazing! We really enjoyed our family time in this beautiful setting. Everything was so much more than we expected. Thank you so much for making our time special!   \n",
       "7243                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            I had an amazing stay. Very beautiful and clean apt. Thanks for the excellent communication.   \n",
       "4041                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Cozy little place that offers everything you need for a pleasant stay!   \n",
       "7961                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         The place was nice though the tub and shower situation could use some work. It is in a GREAT location two blocks from Route 66. Lots of great food choices in the area. Easy access in and out of the place. Also easy to get on the highway from the location.   \n",
       "4066  What a lovely month that I had staying in this hillside cabin. True to all the reviews left prior for Will and to the space-I am glad that I also got the same opportunity to be a part of this wonderful experience.<br/>1)\\tThis spot was perfect for one person. <br/>2)\\tAll my basic needs were met. Onsite parking that you will become a pro at manuevering in and out of.  Will also gave great tips on backing into the spot.<br/>3)\\tI fully enjoyed the patio space for my meals, reading, working on my laptop, and enjoying nature along with sunsets.<br/>4)\\tThe space will also really discipline you to buy just enough grocery for the week and eat everything up. It really feeds into my minimalist side. Costco shopping might not work unless you find friends/colleagues to split portions up.<br/>5)\\tThe space has three windows and bring a comfortable breeze and plenty of sunshine into the cabin.<br/>6)\\tWill keeps the cabin really clean and supplies everything that you need. If you ever have a question, he is quick to respond. One time, I needed pliers for fixing something of mine, and the next day it appeared in front of the cabin <br/>7)\\tWill provides you with an amazing snack basket upon arrival and it will last you for a week a good long time. <br/>8)\\tThroughout my stay, Will offered additional fresh fruits and snacks.   \n",
       "8967                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Nice place to stay.  Just no AC   \n",
       "9103                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         A lovely garden room. Thea was helpful and welcoming. The room was well-appointed and the bed very comfortable.   \n",
       "3314                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Amanda’s cottage has a great location, it’s a comfortable space. Beautiful touches in and outside of the property. I love all the house plants inside of the cottage and the overall peacefulness of the place.   \n",
       "6632                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Great place! Takes the idea of an Airbnb and adds an extra level of usefulness by cultivating a community of creativity. Friendly and family oriented. Definitely would recommend, definitely staying again.   \n",
       "6409                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Really close to a lot of stuff and nice private space   \n",
       "3520                                                                                                                                                                                                                                                                                           i really hate to have to do this i’ve never had to do this before but want to warn others.. first i will say this house is beautiful, it’s nice and has everything needed! however during our stay the wifi was out the entire stay.. we asked the host if we can fix it, they told us we have to go up on their attic on a 10ft ladder to fix the wifi.. i was nice and told the host i just had a acl tear and i don’t feel comfortable climbing a ladder and they kept saying it was the only way to fix it.. not once did they offer to come out and fix it for us they kept bugging to call us and saying to do it ourselves when we said we didn’t feel<br/>comfortable.. also the amount of rules and stuff the host send us overwhelming like it’s crazy it’s like your working to for them when you leave  .. so just a heads up i didn’t want to have to do this i tried to peacefully message them to fix this but they denied and denied after our stay to make things better so beware before booking! between the all the rules and everything it feels like a job to stay here   \n",
       "4840                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        What an inviting house to come to after a long drive. Helanie and her family made us feel immediately comfortable and welcomed when we arrived, and so throughout our whole stay. The room is spacious, the bed divine and the bathroom two steps from the room. Also the fan saved us at night as it can get warm in that area. A lovely breakfast awaited us in the morning, really appreciated it! I was given a list of things to do and see in LA by Helanie's daughter which I am really grateful for. All in all I would definitely recommend this place to anyone, as I doubt you could come across a sweeter and more cheerful family!    \n",
       "1613                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Overall the space was very spacious, cute, and comfortable. The location was great for where we wanted to go. We had some issues with the wifi. We were told there was a washer which was not the case but there was a laundry mat across the street that was very nice that we ended up using. Parking was easy to find and and we really enjoyed the taco shop nearby.   \n",
       "1271                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Staying at Buz's place allowed us to engage the local culture and activities with ease and immediacy...one block walk and you are there! Moreover, from here we were able drive to Sanata Monica, LA and Hollywood quickly (even with the LA traffic being what it is). In short, you really can't go wrong staying at Buz's place. Thanks Buz!   \n",
       "6359                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Everything about this place is wonderful I give it 5 stars overall.   \n",
       "3706                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Great location!! Very clean. Very well stocked. But noisy street. Better suited for two people who can share the bedroom that is away from the windows. Convenience store and CVS just steps away. Fantastic restaurants/bar just next to the building.   \n",
       "5594                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               This place is magical! Our kids had so much fun and didn’t want to leave.  I would definitely stay again!   \n",
       "1705                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Beautiful place   \n",
       "2765                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       I spent quite a bit of time reading previous reviews, and I can say the house lived up to my expectations. It was clean, comfortable and had all the amenities we could have hoped for. I really couldn't have asked for more in terms of the home - and its proximity to the beach, shops, etc. made it easy to get around (although we did just stay at the house for most evenings!)\\r<br/>\\r<br/>In addition, Ray was very responsive and had everything set up so that we really felt at home for a long weekend. I wouldn't hesitate to stay there again, especially with Ray as the host!    \n",
       "2364                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Fantastic host. Spectacular home. Thank you for hosting us. Would love to stay there again!   \n",
       "759                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              We had a great experience at the Casaredondela as it was within walking distance of our son's home with whom we were visiting.  Unfortunately Mike was out of town and we didn't get to meet him in person, but he made satisfactory arrangements for our arrival and departure.  The hideaway is small, but the bed is comfortable, nice linens, TV, bathroom adequate and the kitchenette well-stocked. A toaster would have been a welcome addition to the \"kitchen\". This is a converted closet-kitchen, very compact and no sink for dish clean-up (except outside or in bathroom). The apartment was clean and the neighborhood quiet. We felt safe walking at night.   \n",
       "4326                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              We enjoyed our stay. It was great to have so many bathrooms so everyone had space to get ready. Neighbors were a bit loud one of the nights, but was possibly just an anomaly. Overall it had everything we needed and was located centrally so getting food delivered was no problem. Hosts were responsive and friendly!   \n",
       "3171                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Tanya was amazing! Her place was absolutely lovely! It was exactly what we needed! Everything was super clean and the style was so cute! Definitely recommend   \n",
       "3181                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  This place was beyond amazing. Super clean and in a great neighborhood with zero hassle parking. I forgot to pack toiletries but Ara had travel sized shampoo & conditioner that saved the day. Highly recommend staying here if you’re looking for a quality air bnb!   \n",
       "7719                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Such a warm and comfy place! We had a lovely time staying here. We had access to grill, cook, and enjoy a delicious dinner in the beautiful kitchen/ dining area. Parking was convenient. Completely satisfied with our stay!   \n",
       "4594                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Thank you! We loved our stay, the apartment was terrific and our host was very friendly and welcoming. The location was absolutely ideal for walking to the beach and Main St. We borrowed the 2 bikes to head to Manhattan Beach--what a lovely bike ride. We definitely hope to return to Santa Monica and would love to stay here when we do. Thanks again!   \n",
       "9682                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Nicely updated apt near shops and restaurants. Never met Rachel but she always answered texts.   \n",
       "7343                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Sweet little spot in the heart of the cutest neighborhood.   \n",
       "9706                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               Quiet, clean neighborhood with a view of the mountains in the horizon. Kerri was very kind and very easy to reach. Important to note that there are other guests in multiple rooms, so the place is set up like a bed and breakfast. Backyard is huge and everything (restaurants, gas stations theatres, etc) is only a few blocks down.   \n",
       "9293                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 We had such a fantastic stay at Karla and Nathan's apartment. It was spotless when we arrived, and throughout our stay there were super communicative and quick to respond to any questions we had. It's been properly set up as a home, rather than temporary accommodation so there's literally everything you could possibly need (sharp knives included). They're also really lovely people! 10/10 would recommend.   \n",
       "3508                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Robert was a nice and helpful host. Met us for check in and let us get settled in immediately.  We were exhausted after a local 5K so that was much appreciated.  We were there for such a short time that we didn't use the wifi, but I would have appreciated a printout or something in the room. Not a big deal. He has two amazing dogs who are so friendly! I wish we had had more time spend there and hangout.  We left the wrong keys upon leaving and he helped coordinate an exchange the next day.  He had local recommendations as well which were appreciated!   \n",
       "2231                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             We had a great night at Mick & Misty’s place. Since I mentioned that we had 4 people, they even made all beds (sofa bed and the extra mattress) for us beforehand. Mick and Misty are very friendly and responding to our questions very quickly. The place is also super clean and well decorated. Definitely recommended!   \n",
       "1078                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Gabe goes above and beyond to make sure his guests are accommodated and comfortable! He makes you feel at home when visiting a new city! If we are ever in California again, we will be sure to stay with Gabe! I 100% recommend this bnb to anyone looking in the area! The room was clean and comfortable as well as the shared bathroom and living spaces!   \n",
       "8428                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         The place is really comfortable   \n",
       "2499                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           很漂亮的房子 睡觉的房间远离马路 很安静 停车也很方便 机场下来十几分钟就能到。非常方便。   \n",
       "6981                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Everything as expected. Pool was definitely the best part!   \n",
       "7096                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                This is a perfect little getaway spot! The RV is spacious and the bed is so comfortable!! Everything was clean and we appreciated how well stocked the cupboards were with household essentials. The backyard and pool are pristine and so enjoyable!! We will absolutely be back again!   \n",
       "4185                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Mary is a great host!  Very attentive and helpful throughout my stay.  The studio is clean and tastefully updated.  Bed is super comfortable and the place has everything from bedding and toiletries to a full kitchen with all the dishes/pots and pans etc..  Fast WiFi too, which is a +.<br/> I totally recommend staying here and having Mary as a host.   \n",
       "3092                                                                                                                                                                                                                                                                                                                                                                                                                                                                         I'll start by saying we stayed here for almost 2 weeks. To be honest, we would have stayed another 2 weeks if we could have! The touches in this space were the best of any Airbnb we have stayed in at this price point. I love a soft comfy bed and pillows that your head just sinks into and that was exactly what they had here. My wife and I were here doing some business planning and just needed a space that we could work from and it was well provided. The couch, the dinner table, and the outdoor patio were great! You also can't beat only being about 3 blocks from the beach and boardwalk. This family has multiple other listings so if this one isn't available I would highly recommend one of their other properties. If they put as much care and thought into one I would imagine they spread that same care to their other listings.<br/><br/>Thank you again for a wonderful stay!   \n",
       "2125                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Beautiful family vacation. My children and I felt right at home. Veronica was excellent with communicating and made sure our stay was comfortable and enjoyable. Perfect location and Amazing views. Looking forward to coming back. Thanks Again Veronica.   \n",
       "6439                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Room was exactly like what’s shown on the pictures, hosts were great and helpful, place was clean and location was great too!   \n",
       "7816                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         This was my first time staying at an Airbnb and I must say the bar has been set very high!  Megan made everything very easy. Everything about the place was fantastic for sure.   \n",
       "1723                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 The space was beautiful and Biana and Tony were very helpful. The only thing I would say was a bit strange was that their home was on the property. For the most part our visit was pretty private but we did walk in on a birthday party which was awkward. But overall it was a nice home and they were there to accommodate and help us on our visit   \n",
       "2580                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Daniel is genuinely one of the best hosts we’ve had before! He was very welcoming with this home and everything was very neat and clean. The condominium is stunning with amazing views of the mountains. The neighborhood area is very nice and safe as well. You will not regret it if you choose to stay here!   \n",
       "6029                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Awesome spot! Would reccommend!   \n",
       "3159                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             The amazing beautiful photos are accurate!  What a great place to stay within walking distance of so much in Pasadena.  <br/><br/>Modern and clean!  The kitchen appliances were so amazing that we decided to stay in and cook one night instead of going to the great restaurants close by.  Traders Joes is just a block away.<br/><br/>Very quiet.  Very secure feeling.  Indoor gated garage.  Great host.  We will definitely stay here for future trips to Pasadena.   \n",
       "8406                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        This was a great location, in a very quiet neighborhood, located in a very busy city. We locked ourselves out and the host responded in 10 minutes to get us back in. Great service. The beds were very comfortable and there was enough parking for 3 cars in the driveway. We had a wonderful time and look forward to visiting this little beauty again soon.   \n",
       "7172                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    clean and quite, nice place. near the bus station, several mins to downtown and usc.   \n",
       "3959                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Gabriela’s place was very clean and comfortable. The location is amazing and we really enjoyed our stay! Would definitely recommend!   \n",
       "9717                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           This is cute place in a nice, very quiet location.  We felt secure and would stay here again!   \n",
       "8581                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Amazing! Picture perfect view, beautiful pool and pool house.   \n",
       "6292                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       What a beautiful home and excellent location! Extraordinarily clean and comfortable. It was the perfect spot for my small family.   \n",
       "\n",
       "     language  \n",
       "6959       en  \n",
       "1860       en  \n",
       "7650       en  \n",
       "3270       en  \n",
       "3672       en  \n",
       "4042       en  \n",
       "6823       en  \n",
       "1584       en  \n",
       "8033       en  \n",
       "7243       en  \n",
       "4041       en  \n",
       "7961       en  \n",
       "4066       en  \n",
       "8967       en  \n",
       "9103       en  \n",
       "3314       en  \n",
       "6632       en  \n",
       "6409       en  \n",
       "3520       en  \n",
       "4840       en  \n",
       "1613       en  \n",
       "1271       en  \n",
       "6359       en  \n",
       "3706       en  \n",
       "5594       en  \n",
       "1705       ro  \n",
       "2765       en  \n",
       "2364       en  \n",
       "759        en  \n",
       "4326       en  \n",
       "3171       en  \n",
       "3181       en  \n",
       "7719       en  \n",
       "4594       en  \n",
       "9682       en  \n",
       "7343       en  \n",
       "9706       en  \n",
       "9293       en  \n",
       "3508       en  \n",
       "2231       en  \n",
       "1078       en  \n",
       "8428       en  \n",
       "2499    zh-cn  \n",
       "6981       en  \n",
       "7096       en  \n",
       "4185       en  \n",
       "3092       en  \n",
       "2125       en  \n",
       "6439       en  \n",
       "7816       en  \n",
       "1723       en  \n",
       "2580       en  \n",
       "6029       en  \n",
       "3159       en  \n",
       "8406       en  \n",
       "7172       en  \n",
       "3959       en  \n",
       "9717       en  \n",
       "8581       en  \n",
       "6292       en  "
      ]
     },
     "execution_count": 11,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df.sample(60)"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "d3487e1a",
   "metadata": {},
   "source": [
    "Now our code is working for detecting language, so we can apply it to the orginial dataset. \n",
    "\n",
    "Also, we can see the following in our dataset.\n",
    "- There are '.' as value.\n",
    "- There are more than 1 language in a cell. For example, Chinese + English.\n",
    "- There are special character such as '< br/ >' and '/r' inside the value.\n",
    "- There are emoji inside the value.\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "id": "c5518874",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>76</th>\n",
       "      <td>40991848</td>\n",
       "      <td>684077096836429315</td>\n",
       "      <td>2022-08-01</td>\n",
       "      <td>468892239</td>\n",
       "      <td>Anthony</td>\n",
       "      <td>.</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>747</th>\n",
       "      <td>53827863</td>\n",
       "      <td>787023248482143130</td>\n",
       "      <td>2022-12-21</td>\n",
       "      <td>151996612</td>\n",
       "      <td>Daphne</td>\n",
       "      <td>.</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1630</th>\n",
       "      <td>36839383</td>\n",
       "      <td>581896435330297326</td>\n",
       "      <td>2022-03-13</td>\n",
       "      <td>204721483</td>\n",
       "      <td>Luis</td>\n",
       "      <td>.</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2109</th>\n",
       "      <td>45421298</td>\n",
       "      <td>476142100163998565</td>\n",
       "      <td>2021-10-18</td>\n",
       "      <td>394815724</td>\n",
       "      <td>Gwendolyn</td>\n",
       "      <td>.</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5331</th>\n",
       "      <td>611761264091669516</td>\n",
       "      <td>627601134929496375</td>\n",
       "      <td>2022-05-15</td>\n",
       "      <td>317155639</td>\n",
       "      <td>Briana</td>\n",
       "      <td>.</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5919</th>\n",
       "      <td>706717423990881259</td>\n",
       "      <td>795814617252515294</td>\n",
       "      <td>2023-01-02</td>\n",
       "      <td>340385420</td>\n",
       "      <td>Patricia</td>\n",
       "      <td>.</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7133</th>\n",
       "      <td>38812665</td>\n",
       "      <td>458691903656025998</td>\n",
       "      <td>2021-09-24</td>\n",
       "      <td>372978466</td>\n",
       "      <td>Dave</td>\n",
       "      <td>.</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7935</th>\n",
       "      <td>14573464</td>\n",
       "      <td>438848049</td>\n",
       "      <td>2019-04-17</td>\n",
       "      <td>28025264</td>\n",
       "      <td>Charles</td>\n",
       "      <td>.</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              listing_id                  id        date  reviewer_id   \n",
       "76              40991848  684077096836429315  2022-08-01    468892239  \\\n",
       "747             53827863  787023248482143130  2022-12-21    151996612   \n",
       "1630            36839383  581896435330297326  2022-03-13    204721483   \n",
       "2109            45421298  476142100163998565  2021-10-18    394815724   \n",
       "5331  611761264091669516  627601134929496375  2022-05-15    317155639   \n",
       "5919  706717423990881259  795814617252515294  2023-01-02    340385420   \n",
       "7133            38812665  458691903656025998  2021-09-24    372978466   \n",
       "7935            14573464           438848049  2019-04-17     28025264   \n",
       "\n",
       "     reviewer_name comments language  \n",
       "76         Anthony        .    Error  \n",
       "747         Daphne        .    Error  \n",
       "1630          Luis        .    Error  \n",
       "2109     Gwendolyn        .    Error  \n",
       "5331        Briana        .    Error  \n",
       "5919      Patricia        .    Error  \n",
       "7133          Dave        .    Error  \n",
       "7935       Charles        .    Error  "
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "test_df[test_df['comments']=='.']"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "983f3df0",
   "metadata": {},
   "source": [
    "______"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "776c501d",
   "metadata": {},
   "source": [
    "### Apply on large dataset\n",
    "#### Data cleaning"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "id": "8aef88b2",
   "metadata": {},
   "outputs": [],
   "source": [
    "cleaned_df = df[df['comments'] != '.']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "id": "1c3f7ced",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Remove special characters\n",
    "cleaned_df.loc[:, 'comments'] = cleaned_df.loc[:, 'comments'].str.replace(r':\\)|<3|\\r|<br/>', ' ', regex=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "id": "7e6cfa63",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>161032</th>\n",
       "      <td>3194941</td>\n",
       "      <td>24190331</td>\n",
       "      <td>2014-12-22</td>\n",
       "      <td>23192102</td>\n",
       "      <td>Asel</td>\n",
       "      <td>Thank you Lucia and Nick, we had such a wonderful time.  Everything was perfect, house is very clean and cosy , location is convenient, price is more than fair.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        listing_id        id        date  reviewer_id reviewer_name   \n",
       "161032     3194941  24190331  2014-12-22     23192102          Asel  \\\n",
       "\n",
       "                                                                                                                                                                  comments  \n",
       "161032  Thank you Lucia and Nick, we had such a wonderful time.  Everything was perfect, house is very clean and cosy , location is convenient, price is more than fair.    "
      ]
     },
     "execution_count": 15,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check if whether it is successfully removed. id = 24190331\n",
    "cleaned_df[cleaned_df['id']==24190331]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "16b3c805",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Remove emoji\n",
    "cleaned_df.loc[:, 'comments'] = cleaned_df['comments'].apply(lambda x: emoji.demojize(str(x))) # Convert emoji to text\n",
    "cleaned_df.loc[:, 'comments'] = cleaned_df['comments'].str.replace(r':[^:]+:', '', regex=True) # Remove the emoji text\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "277112c0",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>327040</th>\n",
       "      <td>9365179</td>\n",
       "      <td>500106629941392940</td>\n",
       "      <td>2021-11-20</td>\n",
       "      <td>34077134</td>\n",
       "      <td>Nicole</td>\n",
       "      <td>This place looks even better in person! Everything decorated so perfectly. The bed is extremely comfortable and cozy. I coulda stay in all day! I will definitely be returning.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "        listing_id                  id        date  reviewer_id reviewer_name   \n",
       "327040     9365179  500106629941392940  2021-11-20     34077134        Nicole  \\\n",
       "\n",
       "                                                                                                                                                                                comments  \n",
       "327040  This place looks even better in person! Everything decorated so perfectly. The bed is extremely comfortable and cozy. I coulda stay in all day! I will definitely be returning.   "
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Check with id = 500106629941392940, 131790407\n",
    "cleaned_df[cleaned_df['id']==500106629941392940]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "9453953d",
   "metadata": {},
   "source": [
    "#### Detect language"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "be70dac1",
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "/var/folders/jh/nyglx1sn7pn4r0h2m50ghdbm0000gn/T/ipykernel_21471/528983996.py:1: SettingWithCopyWarning: \n",
      "A value is trying to be set on a copy of a slice from a DataFrame.\n",
      "Try using .loc[row_indexer,col_indexer] = value instead\n",
      "\n",
      "See the caveats in the documentation: https://pandas.pydata.org/pandas-docs/stable/user_guide/indexing.html#returning-a-view-versus-a-copy\n",
      "  cleaned_df['language'] = cleaned_df['comments'].apply(detect_language)\n"
     ]
    }
   ],
   "source": [
    "cleaned_df['language'] = cleaned_df['comments'].apply(detect_language)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "d0da0980",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>109</td>\n",
       "      <td>449036</td>\n",
       "      <td>2011-08-15</td>\n",
       "      <td>927861</td>\n",
       "      <td>Edwin</td>\n",
       "      <td>The host canceled my reservation the day before arrival.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>109</td>\n",
       "      <td>74506539</td>\n",
       "      <td>2016-05-15</td>\n",
       "      <td>22509885</td>\n",
       "      <td>Jenn</td>\n",
       "      <td>Me and two friends stayed for four and a half months. It was a great place to stay! The apartment was very comfortable and I really enjoyed having the park with running path across the street. The only downside was it wasn't within walking distance to restaurants, bars, or coffee shops. But they are a short drive away. Overall, great stay!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2708</td>\n",
       "      <td>13994902</td>\n",
       "      <td>2014-06-09</td>\n",
       "      <td>10905424</td>\n",
       "      <td>Kuberan</td>\n",
       "      <td>i had a wonderful stay. Everything from start to the end was perfect.  Will come back again.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>180926</td>\n",
       "      <td>424635</td>\n",
       "      <td>2011-08-06</td>\n",
       "      <td>892106</td>\n",
       "      <td>Brian</td>\n",
       "      <td>Rebecca was a great host!  She was very friendly and also had two very friendly dogs.  The cabin was great, although it had some bugs, but I guess you can't really escape that when you're out in mountains. The beds were really really comfortable - probably even more comfortable then the bed I have at home.  There backyard is really really big and they have some farm animals, like goats and pigs.  My friends came here to have a quiet place to retreat, and we got that here.  There place was also about 2-3 miles from the beach which was really nice!  It was great to have both of two worlds, the mountains and the beach at the same time.  I would come and stay here again.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>180926</td>\n",
       "      <td>13396837</td>\n",
       "      <td>2014-05-26</td>\n",
       "      <td>3220350</td>\n",
       "      <td>Julia</td>\n",
       "      <td>We had a wonderful time in this cabin with our \"family of 6!\" Even the giant goat encounter, the non-working fridge, and the dog barking all through the night, it was a lovely getaway. We did a lot of hiking with amazing views and the kids absolutely loved playing in the countryside with all the wooden logs, the kayak (?), the rustic \"tools,\" and many other things. Rebecca and Alice are wonderful and friendly hosts, and we enjoyed interacting with them a lot!</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   listing_id        id        date  reviewer_id reviewer_name   \n",
       "0         109    449036  2011-08-15       927861         Edwin  \\\n",
       "1         109  74506539  2016-05-15     22509885          Jenn   \n",
       "2        2708  13994902  2014-06-09     10905424       Kuberan   \n",
       "3      180926    424635  2011-08-06       892106         Brian   \n",
       "4      180926  13396837  2014-05-26      3220350         Julia   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              comments   \n",
       "0                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             The host canceled my reservation the day before arrival.  \\\n",
       "1                                                                                                                                                                                                                                                                                                                                                Me and two friends stayed for four and a half months. It was a great place to stay! The apartment was very comfortable and I really enjoyed having the park with running path across the street. The only downside was it wasn't within walking distance to restaurants, bars, or coffee shops. But they are a short drive away. Overall, great stay!   \n",
       "2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         i had a wonderful stay. Everything from start to the end was perfect.  Will come back again.   \n",
       "3  Rebecca was a great host!  She was very friendly and also had two very friendly dogs.  The cabin was great, although it had some bugs, but I guess you can't really escape that when you're out in mountains. The beds were really really comfortable - probably even more comfortable then the bed I have at home.  There backyard is really really big and they have some farm animals, like goats and pigs.  My friends came here to have a quiet place to retreat, and we got that here.  There place was also about 2-3 miles from the beach which was really nice!  It was great to have both of two worlds, the mountains and the beach at the same time.  I would come and stay here again.   \n",
       "4                                                                                                                                                                                                                      We had a wonderful time in this cabin with our \"family of 6!\" Even the giant goat encounter, the non-working fridge, and the dog barking all through the night, it was a lovely getaway. We did a lot of hiking with amazing views and the kids absolutely loved playing in the countryside with all the wooden logs, the kayak (?), the rustic \"tools,\" and many other things. Rebecca and Alice are wonderful and friendly hosts, and we enjoyed interacting with them a lot!   \n",
       "\n",
       "  language  \n",
       "0       en  \n",
       "1       en  \n",
       "2       en  \n",
       "3       en  \n",
       "4       en  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "0f67c30c",
   "metadata": {},
   "source": [
    "Check 'error' comments. Based on below table, we can see that the values are empty string, symbols and numbers. We have many data, so we will drop these data."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "b7ff34af",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1673</th>\n",
       "      <td>5729</td>\n",
       "      <td>328280107</td>\n",
       "      <td>2018-09-25</td>\n",
       "      <td>204357260</td>\n",
       "      <td>旻昇</td>\n",
       "      <td></td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6555</th>\n",
       "      <td>75212</td>\n",
       "      <td>179580260</td>\n",
       "      <td>2017-08-07</td>\n",
       "      <td>2165421</td>\n",
       "      <td>Michelle</td>\n",
       "      <td></td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7274</th>\n",
       "      <td>237988</td>\n",
       "      <td>286217988</td>\n",
       "      <td>2018-07-05</td>\n",
       "      <td>197324233</td>\n",
       "      <td>Hatun</td>\n",
       "      <td></td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7687</th>\n",
       "      <td>239032</td>\n",
       "      <td>315029032</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>85461631</td>\n",
       "      <td>Samantha</td>\n",
       "      <td>*</td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7990</th>\n",
       "      <td>76561</td>\n",
       "      <td>708061245</td>\n",
       "      <td>2020-11-10</td>\n",
       "      <td>369321456</td>\n",
       "      <td>Eduardo</td>\n",
       "      <td></td>\n",
       "      <td>Error</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397627</th>\n",
       "      <td>808076848392842110</td>\n",
       "      <td>830620664038776991</td>\n",
       "      <td>2023-02-19</td>\n",
       "      <td>158560741</td>\n",
       "      <td>Andres</td>\n",
       "      <td></td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397705</th>\n",
       "      <td>808433155800964194</td>\n",
       "      <td>830575726045064295</td>\n",
       "      <td>2023-02-19</td>\n",
       "      <td>86165718</td>\n",
       "      <td>Cali</td>\n",
       "      <td></td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1397828</th>\n",
       "      <td>811797564924517493</td>\n",
       "      <td>831280184012179542</td>\n",
       "      <td>2023-02-20</td>\n",
       "      <td>495627058</td>\n",
       "      <td>Melly</td>\n",
       "      <td></td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398054</th>\n",
       "      <td>816031169626975181</td>\n",
       "      <td>830541326722918273</td>\n",
       "      <td>2023-02-19</td>\n",
       "      <td>325245237</td>\n",
       "      <td>Jameel</td>\n",
       "      <td></td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1398636</th>\n",
       "      <td>832968156831473087</td>\n",
       "      <td>836396397243340629</td>\n",
       "      <td>2023-02-27</td>\n",
       "      <td>493117519</td>\n",
       "      <td>Stacy</td>\n",
       "      <td></td>\n",
       "      <td>Error</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2137 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 listing_id                  id        date  reviewer_id   \n",
       "1673                   5729           328280107  2018-09-25    204357260  \\\n",
       "6555                  75212           179580260  2017-08-07      2165421   \n",
       "7274                 237988           286217988  2018-07-05    197324233   \n",
       "7687                 239032           315029032  2018-08-27     85461631   \n",
       "7990                  76561           708061245  2020-11-10    369321456   \n",
       "...                     ...                 ...         ...          ...   \n",
       "1397627  808076848392842110  830620664038776991  2023-02-19    158560741   \n",
       "1397705  808433155800964194  830575726045064295  2023-02-19     86165718   \n",
       "1397828  811797564924517493  831280184012179542  2023-02-20    495627058   \n",
       "1398054  816031169626975181  830541326722918273  2023-02-19    325245237   \n",
       "1398636  832968156831473087  836396397243340629  2023-02-27    493117519   \n",
       "\n",
       "        reviewer_name comments language  \n",
       "1673               旻昇             Error  \n",
       "6555         Michelle             Error  \n",
       "7274            Hatun             Error  \n",
       "7687         Samantha        *    Error  \n",
       "7990          Eduardo             Error  \n",
       "...               ...      ...      ...  \n",
       "1397627        Andres             Error  \n",
       "1397705          Cali             Error  \n",
       "1397828         Melly             Error  \n",
       "1398054        Jameel             Error  \n",
       "1398636         Stacy             Error  \n",
       "\n",
       "[2137 rows x 7 columns]"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_df[cleaned_df['language']=='Error']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "id": "a35e5a78",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1395336, 7)"
      ]
     },
     "execution_count": 21,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "cleaned_df = cleaned_df.drop(cleaned_df[cleaned_df['language'] == 'Error'].index)\n",
    "cleaned_df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "50250f69",
   "metadata": {},
   "source": [
    "Check how many are detected as english. "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "id": "b98f501d",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<AxesSubplot:xlabel='language'>"
      ]
     },
     "execution_count": 22,
     "metadata": {},
     "output_type": "execute_result"
    },
    {
     "data": {
      "image/png": "iVBORw0KGgoAAAANSUhEUgAAAXUAAAEiCAYAAAAGdkKHAAAAOXRFWHRTb2Z0d2FyZQBNYXRwbG90bGliIHZlcnNpb24zLjUuMSwgaHR0cHM6Ly9tYXRwbG90bGliLm9yZy/YYfK9AAAACXBIWXMAAAsTAAALEwEAmpwYAAAg90lEQVR4nO3deZwcVb338c83CRiUIGAGRAKEaBARQSAsKsqiXgNcQUQQZFEviI8KFxf0hkdl9V5ERB+ViAQERFkMihgxErwIskMmCQQSQENACaJESABRlujv+eOcZmo63dOdpCczOfm+X69+TVfVqVOna/nVqXOqahQRmJlZGYYMdAHMzKxzHNTNzArioG5mVhAHdTOzgjiom5kVxEHdzKwgAxrUJV0g6XFJ97aZ/iBJcyXNkXRpf5fPzGxVo4G8T13SO4C/ARdHxNYt0o4FJgN7RsQiSRtExOMro5xmZquKAa2pR8SNwJPVcZJeK+kaSTMk3SRpyzzpY8DEiFiU53VANzOrMxjb1CcBx0bEDsDxwHfz+C2ALSTdIul2SeMHrIRmZoPUsIEuQJWktYG3AldIqo1+Wf47DBgL7A6MAm6U9KaIWLySi2lmNmgNqqBOunJYHBFvbjBtAXBHRLwIPCTpd6QgP30lls/MbFAbVM0vEfE0KWAfCKBk2zz5KlItHUkjSc0x8wegmGZmg9ZA39J4GXAb8HpJCyQdCRwKHCnpbmAOsF9OPg14QtJc4Hrg8xHxxECU28xssBrQWxrNzKyzBlXzi5mZrZgB6ygdOXJkjB49eqAWb2a2SpoxY8ZfI6Kr2fQBC+qjR4+mu7t7oBZvZrZKkvSHvqa7+cXMrCAO6mZmBXFQNzMriIO6mVlBHNTNzArioG5mVhAHdTOzgjiom5kVxEHdzKwgA/4+9dETftlr+OGv7jNAJTEzW/W5pm5mVhAHdTOzgjiom5kVxEHdzKwgDupmZgVxUDczK4iDuplZQRzUzcwK4qBuZlYQB3Uzs4I4qJuZFcRB3cysIA7qZmYFaRnUJV0g6XFJ9zaZfqik2ZLukXSrpG07X0wzM2tHOzX1i4DxfUx/CNgtIt4EnAZM6kC5zMxsObR8n3pE3ChpdB/Tb60M3g6M6kC5zMxsOXS6Tf1I4FfNJko6WlK3pO6FCxd2eNFmZtaxoC5pD1JQ/69maSJiUkSMi4hxXV1dnVq0mZllHfl3dpK2Ac4H9oqIJzqRp5mZLbsVrqlL2hS4Ejg8In634kUyM7Pl1bKmLukyYHdgpKQFwEnAGgAR8T3gROBVwHclASyJiHH9VWAzM2uunbtfDmkx/SjgqI6VyMzMlpufKDUzK4iDuplZQRzUzcwK4qBuZlYQB3Uzs4I4qJuZFcRB3cysIA7qZmYFcVA3MyuIg7qZWUEc1M3MCuKgbmZWEAd1M7OCOKibmRXEQd3MrCAO6mZmBXFQNzMriIO6mVlBHNTNzArioG5mVhAHdTOzgjiom5kVxEHdzKwgLYO6pAskPS7p3ibTJenbkuZJmi1p+84X08zM2tFOTf0iYHwf0/cCxubP0cA5K14sMzNbHi2DekTcCDzZR5L9gIsjuR1YV9JGnSqgmZm1rxNt6hsDj1SGF+RxS5F0tKRuSd0LFy7swKLNzKxqpXaURsSkiBgXEeO6urpW5qLNzFYLnQjqjwKbVIZH5XFmZraSdSKoTwGOyHfB7AI8FRGPdSBfMzNbRsNaJZB0GbA7MFLSAuAkYA2AiPgeMBXYG5gH/B34aH8V1szM+tYyqEfEIS2mB/CpjpXIzMyWm58oNTMriIO6mVlBHNTNzArioG5mVhAHdTOzgjiom5kVxEHdzKwgDupmZgVxUDczK4iDuplZQRzUzcwK4qBuZlYQB3Uzs4I4qJuZFcRB3cysIA7qZmYFcVA3MyuIg7qZWUEc1M3MCuKgbmZWEAd1M7OCOKibmRWkraAuabykByTNkzShwfRNJV0vaZak2ZL27nxRzcyslZZBXdJQYCKwF7AVcIikreqSfQmYHBHbAQcD3+10Qc3MrLV2auo7AfMiYn5EvABcDuxXlyaAdfL3VwJ/6lwRzcysXe0E9Y2BRyrDC/K4qpOBwyQtAKYCxzbKSNLRkroldS9cuHA5imtmZn3pVEfpIcBFETEK2Bv4oaSl8o6ISRExLiLGdXV1dWjRZmZW005QfxTYpDI8Ko+rOhKYDBARtwHDgZGdKKCZmbWvnaA+HRgraXNJa5I6QqfUpfkj8E4ASW8gBXW3r5iZrWQtg3pELAGOAaYB95Hucpkj6VRJ++ZknwM+Julu4DLgIxER/VVoMzNrbFg7iSJiKqkDtDruxMr3ucDbOls0MzNbVn6i1MysIA7qZmYFcVA3MyuIg7qZWUEc1M3MCuKgbmZWEAd1M7OCOKibmRXEQd3MrCAO6mZmBXFQNzMriIO6mVlBHNTNzArioG5mVhAHdTOzgjiom5kVxEHdzKwgDupmZgVxUDczK4iDuplZQRzUzcwK4qBuZlYQB3Uzs4K0FdQljZf0gKR5kiY0SXOQpLmS5ki6tLPFNDOzdgxrlUDSUGAi8G5gATBd0pSImFtJMxY4AXhbRCyStEF/FdjMzJprp6a+EzAvIuZHxAvA5cB+dWk+BkyMiEUAEfF4Z4tpZmbtaCeobww8UhlekMdVbQFsIekWSbdLGt8oI0lHS+qW1L1w4cLlK7GZmTXVqY7SYcBYYHfgEOA8SevWJ4qISRExLiLGdXV1dWjRZmZW005QfxTYpDI8Ko+rWgBMiYgXI+Ih4HekIG9mZitRO0F9OjBW0uaS1gQOBqbUpbmKVEtH0khSc8z8zhXTzMza0TKoR8QS4BhgGnAfMDki5kg6VdK+Odk04AlJc4Hrgc9HxBP9VWgzM2us5S2NABExFZhaN+7EyvcAPps/ZmY2QPxEqZlZQRzUzcwK4qBuZlYQB3Uzs4I4qJuZFcRB3cysIA7qZmYFcVA3MyuIg7qZWUEc1M3MCuKgbmZWEAd1M7OCOKibmRXEQd3MrCAO6mZmBXFQNzMriIO6mVlBHNTNzArioG5mVhAHdTOzgjiom5kVxEHdzKwgbQV1SeMlPSBpnqQJfaQ7QFJIGte5IpqZWbtaBnVJQ4GJwF7AVsAhkrZqkG4EcBxwR6cLaWZm7Wmnpr4TMC8i5kfEC8DlwH4N0p0GnAE818HymZnZMmgnqG8MPFIZXpDHvUTS9sAmEfHLDpbNzMyW0Qp3lEoaAnwD+FwbaY+W1C2pe+HChSu6aDMzq9NOUH8U2KQyPCqPqxkBbA3cIOlhYBdgSqPO0oiYFBHjImJcV1fX8pfazMwaaieoTwfGStpc0prAwcCU2sSIeCoiRkbE6IgYDdwO7BsR3f1SYjMza6plUI+IJcAxwDTgPmByRMyRdKqkffu7gGZm1r5h7SSKiKnA1LpxJzZJu/uKF8vMzJaHnyg1MyuIg7qZWUEc1M3MCuKgbmZWEAd1M7OCOKibmRXEQd3MrCAO6mZmBXFQNzMriIO6mVlBHNTNzArioG5mVhAHdTOzgjiom5kVxEHdzKwgDupmZgVxUDczK4iDuplZQRzUzcwK4qBuZlYQB3Uzs4I4qJuZFcRB3cysIG0FdUnjJT0gaZ6kCQ2mf1bSXEmzJV0nabPOF9XMzFppGdQlDQUmAnsBWwGHSNqqLtksYFxEbAP8BPhapwtqZmattVNT3wmYFxHzI+IF4HJgv2qCiLg+Iv6eB28HRnW2mGZm1o52gvrGwCOV4QV5XDNHAr9qNEHS0ZK6JXUvXLiw/VKamVlbOtpRKukwYBxwZqPpETEpIsZFxLiurq5OLtrMzIBhbaR5FNikMjwqj+tF0ruALwK7RcTznSmemZkti3Zq6tOBsZI2l7QmcDAwpZpA0nbAucC+EfF454tpZmbtaBnUI2IJcAwwDbgPmBwRcySdKmnfnOxMYG3gCkl3SZrSJDszM+tH7TS/EBFTgal1406sfH9Xh8tlZmbLwU+UmpkVxEHdzKwgDupmZgVxUDczK4iDuplZQRzUzcwK4qBuZlYQB3Uzs4I4qJuZFcRB3cysIA7qZmYFcVA3MyuIg7qZWUEc1M3MCuKgbmZWEAd1M7OCOKibmRXEQd3MrCAO6mZmBXFQNzMriIO6mVlBHNTNzArioG5mVpBh7SSSNB74FjAUOD8ivlo3/WXAxcAOwBPAByPi4U4UcPSEX770/eGv7tN0WqPpZmarm5ZBXdJQYCLwbmABMF3SlIiYW0l2JLAoIl4n6WDgDOCD/VHgdrUK+D4hmFmJ2qmp7wTMi4j5AJIuB/YDqkF9P+Dk/P0nwNmSFBHRwbKuNMtyQljWk8XyzrsiJ6mVNa9PjGYDT63irqQPAOMj4qg8fDiwc0QcU0lzb06zIA8/mNP8tS6vo4Gj8+DrgQcqk0cCvdK3OW1VnHcwlmmg5h2MZVqReQdjmQZq3sFYpoGat5P5bhYRXU1ziog+P8AHSO3oteHDgbPr0twLjKoMPwiMbJV3XR7dyzNtVZx3MJbJ68K/x+ti1VwX9Z927n55FNikMjwqj2uYRtIw4JWkDlMzM1uJ2gnq04GxkjaXtCZwMDClLs0U4MP5+weA30Q+xZiZ2crTsqM0IpZIOgaYRrql8YKImCPpVNJlwRTg+8APJc0DniQF/mU1aTmnrYrzDsYyDdS8g7FMKzLvYCzTQM07GMs0UPP2Z5l6adlRamZmqw4/UWpmVhAHdTOzgjiom5kVZFAGdUlDJV0y0OXoBEnX5b9ntEh3XDvjlrMMG0jatPbpRJ51+a8naZtO57uqyK/SaDpN0mdWZnkGK0lDJL11Bebvl2NE0vvz+6s6qlGektbPf/ttvxiwjlJJXcDHgNFU7sKJiP/I028G9oyIFxrMexxwIfAMcD6wHTAhIq6tpBkKbFiX9x8lbQGcA2wYEVvnYLRvRHylMu+GwI558M6IeDyPfyXpdQhvz9N+C5waEU/l6WsAnwDeUZn+CeAo0h1CHwJU/S0RMTPPOzMitq/7nbMiYjtJ10XEO+um/Q2YX79ucv4REdtI2hc4C3gN8DiwGXBfRLwx59EF/BewFTC8ksfZDfKtlvlKSTcA+5LW74yc/y0R8dmc94VA/c71KuCUPvKdKekXwGXAzyPi2aV+XB/bQNKP8vBNEXF/g3kfBG4Hbspp5lSmDSe9w+iNVNZFZX98qMHvISLGSJoP/BS4MHq/E6mW950RsVPduPc3Ww/A+yLiCEnfabLM/8x5/DAiDq/L9+GIGC3pnrp5lYc/0sdyAe4G5kTEls0SSDoyIr5fN+6rETGh1fFV26eb5PuLRr+3YlQfx0ijeZ8CuoFzge1ZOtZcnPO4ENgTuBH4MXANsE4f5SAinszznhoRJ1bKMxS4OCIOlfRL0rZ8MU/bCLg6InbIw0vtF5V8xgKnU3dsRsSYvsoFbb6lsZ/8nHRw/S/wzwbT5wO3SJoCvHRwR8Q3gP+IiG9Jeg+wHukp1x8C1wJIOhY4CfgL8K/arMA2wHnA50kbmoiYLelSoLbTHQScCdxAOhC+I+nzEfET4ALS07MH5TwPJ51cagfoOcAawHcr0/8EfJn00NY36n5jSDqPFOw3z7+1ZgSwOJ/ZR0paj54TwjrAn0lB9Wv599QojwM4DdgF+N+84+8BHFZJewlpJ94H+D+kZw0WAu+tL2cl7wCuBF4ZEU9LOoq0E58kaXZlnqsr34cD+5Pe4nlWXZ7VfPcEvk56GdzpkqYDl5MOhOdy2r62wfdJwf47kl4LzAJujIhv5bRbATvnNGdKej0wOyL2J+0/9wPvAU4FDgXuq5RxXN3vORBYPw9vS7qN93xJQ3IZL4+Ip/P0WySdTVrXtX35w6TbfzcA3gr8Jo/fA1gbOIL0ZPYimntjdSA/+FerBF1EOoEtqJvnovw36NmfXtoWEbGnpAckbRoRf2yy3AMkPRcRl+TlTqQn8PR5fAHXSToAuLLBsyzzgVcDP8rDh5CO4WeAd9L4GHmyMm8XqUIAaR96BtiC9J6qPwN30RNrgvRmWSLio7lCtlde5kTStl1Iz75J3fqqBddNJJ0QEafnmvlk0n4HcBUwOb9qZRPS8zzHV8rfaL+oVfQuJMWwb5L2iY/SbsvKsjx+2skPcFeT8T/MfxfnH9Xrk6fNzn+/Deyfv8+q5DEPeFWT/Kc3SH9X5fvdwAaV4S7g7mZlrp+3wfTavF8mnYB2BnYj1ebfQao97w7clsfXPtsDnwEeAp4n7bS1z93AMTnfmQ2WWVs/3ZXfNKS+jMCMavrq+snfh5OC2xcr2+DEPO0eYCPSiXTH+nwalGkIcGv+vhbwOeBnpBPEZ4DhdemHkt4MOhl4uq/9pm4bDCWdyE4A/gDcX5k2DHgLMIF00rkNOLe6P1TW3RrA7S324RkNxu1GesL6WeAHwOuA6/PnN9VPTn8tsFFl/o2Av5Guru7O+8z6dZ8TSAFrCfB0/jxDeor79JzPScAcUsXpGFLNuVrOg4B1Kvvmz4Dt8/CNOb/rSIFoCjClMu9awK9JAfAHwLeW4fh6hlTReqFS7qer+2tdObvp+xgZVr/fNijL8+RWiRbbcw1SheZK4K+V/fZwevb7TUnvtarNI+DSvE2uBT5dl+engF+Qjpe31k2r3y+ur+wXtWPznr72t0afgaypXy1p74iYWjd+B0mvAf4IfKfJvDMkTSOdLSdIGkFPjRzgEdKlVyN/zbW4tEXSWfSxyvQhkZtbsifoOUP+Q9KuEXFznvdtwD8qaf8p6bUR8WCePoaemsGfSQfLKFKNYRdSkHsnKfi8pUFZZwLfzFceawK75nLflLLXPcCYuhryCOCW/H2xpLVz+kskPU6lRgC8mP8+Jmkf0lXF+pXpV5FOrjOBWk25Vms5hfRA2s0RMT3/1t83+A01Y0m1UkiB4GnSSRnSlcrF5Nq3pLVIB9cHSQfuDyr5NN0GSv0XryAd/DeRTjbVbfk06eD6BnBeRFRfZVFbF4slbU3aXrXyIql62T+EVHMflqcNJV3tfJR0iX8W6Sro7cBU0hXiAfS+/K+tx00iorr//YUU1K8j7d8zKtNqTWtjSFcyX8u/Z0xEnJL7S15NSnQKcEpu/vgg8FtJCyLiXTmvL0XEZEm70nOFdA6p0jEc+Pe65Z5Raw/OjiLtH7fk5awfqUmiz+MrIkbkfMbSu8kP4BWSxkTPG2HHAK+IiD/Q/BipWbt6dSFpM9IVD8Df83p5rNGMkvbK62h30hX6+fRcCU4kxZY9SVdwzwA/lfTxShbfIl2Z3ALcKOksel6lItKJ4G5gF0m7RGptIC+rXm2/eD5f9f1e6eHPRyu/p08DGdSPA06Q9ALpgKpd5nyJtENvTjpL19SmjyG1fX4JmBsRf88786craecDN+Q2redrI/PK/BTpCa0tJT1KqgkfCilKkt4XP43el3G1E8+xwPdzuy6kS+OfVpZ7PHB9bmOFdBB/NH//T1I7/e0RsYekLYH/kXRzROwq6RkaNElExDqkGv1T9A6CI0mB73RSzbPmmXxwQWqeeY60rg8jNdtU27S/kn/L50gn0HXq1uOoiBhPY+8FdouIWvPAolzG2nr8Jyk41fyZ1H4PsHVEbFWZdr2kuXneyaTXPV+Ty3RjRFRP2J8AflC3DT6cv88mNfFsncuyWNJtEVE78R5COjF+EjhK0q05/+uASbmJ60ukmunapBpszVn0bJ8lwMOkJhhIJ7PrgTMj4tbKPD+R9A76Pjle12B/uyIijpV0TkR8gubWIVUO9iRt12dI++OOlTSPk9b9E1ROUvRUNvYhneB+KanWRDIsIn5bXVA+0c5g6X10H2DvPDyGPo6vnM9RpP2xV+WG1LzyadJxWz1+jm5wbFSXXztGPgfcrNRvUivLn3MM+CswV9Kd9I4H++avR5CaQD4eES9Nz3aOiO0lzcrzLFJ6XUp9M+Ii4A2kk+NoeioiQU+MqA/K1eOjdiLtIp08rgJeToobp5G28Ydpw0B2lA4hbezNI+LUHJg3iog78vSmO7Skc8hnz4h4Qz4Yr42IHfP0kxrM9hZym3u2FqnG9Sy8FPBrrxE+kXTwQ+pQ+1meNpO0Yv+Qp+1DutzaOU8/kFR7HQ28Ly/zi5E6AKdHxI6S7iLtKM9LmhO507LFuppbFwQbjqtMa3SiqLUH/ovUDnkmqVZ2XEQszvOtD3w9ejoHJwHfiYh7GixjVtR1eFXHSbo3IrZuUr4fkd70eXse3hn4VKTOwSOAqyK113+Z1Al+WkTMymlfRnq/0GuBdUnBOyLi1Er+I0gdgscDr46IXnch5BPqXqQg8hp6TjYvJcl/o7JfDKdBbTvvu1eS+nlq63E94KzKemy6LvL099PT8XtjbX9rRblzvW693x0R20r6JKm22QVcAUyOSieupKtJtb93k66G/kFPG/6Y/L1mBKkT/LA870HANZVttD1pG82sbJ/RpKu+p6lsn3x1WavcvLlWuYmI91eOn81JFZK3ko+fNtbFcFJgH0d6oeCvSZXCF0n/tOcL1eTAGbXjtkW+d+RyTM/ruosUa2rru1Gsqe0XOwL/l6X3mYZ3iuV19yTpKuZXpCuH+hsrnlx6zt4Gsqbe8LKGXMtoUUNpdvYkDy91h0Ve+SNI73HfkdRRK1J72Z2VpDOARyLfxVHnA6QD5EOk2vPhwL9Vpn85Iq6QtA6pc6N6SbtA0rqkM/CvJS2i5+TQysx82VYNgt3NEkfErvnviEbTJb2KVDv6ey0Q5fRPSqoG6l2Bjyjd+fE8lTtrgCGS1qvV1PMJobo/zZC0Y0RMb1CEHYBbJdU64jYFHsgH/Osi4uK6ZoHvkdYhpO22mFTr7fW2UKVmql1z/g+TOixvqkz/KalT80FSU9jhpKBW3S9qHXHvpfd+cRVL17ZrNq9bj4vq1uOtkt7U6OSY019JasddVi8qNf3Umjq66GmG3IRU4birybwHAeNJJ/HFSndmHEOqPfd19Qd9N91Ut8+fGiz3uYh4ThKSXhYR9yt1WEPP8TOiQb6tXMzSTXrbR8SBktZodOXR5hXAt0n9DRtI+m9SDPhSJW2j2natg/1HpIrFvfRuHm7m5aSmomrTW62FotpS0bdoo+G9Pz7kDj56d6gs1dHYZN47SB1itTy66vL5NbBuZXg9YFr0dAKNqEwbQaod1YbvJ11eP0i6nJ9N747EWm/6NcBadeWalf+eDnyo/vdV0u1Gqoms2ebvvS/vFA/nz7/yuHvoo3OyRZ4bkTviKuPWp3fHzGaNPnnaEXldnZY/9wOH97EeXyprs3zz596+1mFtepPfdDwpAAxrMv0L9O4cvBLYrs39oq/lNlyPtd+c95cXSf8UprYuns1pn6Gns7NXx2Eb2/BQ0kloAfDfOf8DO32sNlhu0/28r/WUp/+MdIV1cl7nPwemLsvx0yTfuQ3GPVZb11SOZVKT0I+W4fduSWpWOgZ4Q4u0LwNuyN9vbpH2nkqZ5pCaymo3QJyzvNtnIGvqfdUyWml19uyKpWtOtfbEDem57Yv8fcPK8HsaLG+aendGrk86qdwhiei5nHpU0rmk2t8Z+XJqqduQoq7W0IZm7drLLSIeU+rQuU3SFXn0gaTgUEvT9EoiUm26m1SjAnh/9L5Hu9F6bJmvpIdbrMO+ar3bRsTX6/Kr3st9WER8rclVQKv9oq/lNluPNzb7nTXR5GqqHRFxiaQZpPZoke6Jvq/FbJ3Q137e6qpk//z1ZEnXk5pKrmkj31YaXc3eQLorpdWVR58iPfOw1HMPTbyc1F8AcJKk80k172pbfu2qrNoZvQT4S0QsyWn6aqno00C2qR9K77sbPkC6rLuizxl75t+Snp35uurOnHf0/aN3T/jPIjXZfJF06Vlrt3wf8OOIOL2PZW3WV1lqQUrSy0kB+J6I+H2+pH1TVB6KGmwkbUVPYP5NNHh4ZiWXp891qNSh+jp6bvWsPmzV6wEupfu2Z0fue1DPgyqn5/wvrYxruF+QLuOD1LQ0ltQJX98UNejWY39qso1uJV1l9LmeliPfPo8f9TxktQapCe2PeXgz0u2sDfudOkW9H/IaSu7ojIizc9/RlqRa+EvPy0Tua+m3Mg1UUIe+A/MK5jue1AP/25z324GjI2Janr49vTumZnViudb/mpxgP5k/a5HaJCFt9xeASRFxQp63UefgnRGxbZ6+1H7R7gl9dTdQ62mgt0/d8nvVtiU9EBGvbzxnP5ZpIIN6f5I0knS7FKSe9r7+6asVQNLptQDeZPoqdyVlqy6l1w+cubKv2ooN6jWSTo6Ikwe6HLZyebvbQJN0H+nW20Z3j/XfcleDoL7Ui7KsfN7uNtCaNQ31d5PQQN79srKodRIrkLe7DaiB6m9ZHWrqQ6L3Y+a2GvB2t9VVkUFdLd7VbmXydjcrt/ml1bvarUze7rbaK7WmfldEvHmgy2Erl7e72SD9H6UdcLWkvVsns8J4u9tqr6iaet1b19YmPVH4Ar3fumaF8XY361FUTT0iRuQDuBt4b0QMj4h18kuTfjzAxbN+4u1u1qOooF4xGviCpBMr43YYoLLYyjMab3dbzZUa1BeTXhT2akm/UM+/PrOyLcbb3VZzpQZ1RcSSiPgk6b8p3Uzv/89oZfJ2t9Veqfepf6/2JSIuyu88/tQAlsdWDm93W+0VdfeLmdnqrtTmFzOz1ZKDuplZQRzUbZUl6W8DXQazwcZB3cysIA7qtsqTtLak6yTNlHSPpP3y+NGS7pN0nqQ5kq6VtFaetqOk2ZLuknSmpHvz+I9IOruS99WSds/fz5HUnfM6pZJmb0n3S5oh6dv5H1wj6RWSLpB0p6RZtXKZ9ScHdSvBc8D++d/X7QGcJan2n4/GAhMj4o2kh5MOyOMvBD6e3+rY7mt6vxgR44BtgN0kbSNpOHAusFdE7AB0VdMDv4mInXK5zpT0iuX9kWbtcFC3Egj4H0mzSe9S3xjYME97KCLuyt9nAKMlrQuMiIjb8vhL21zOQZJmArOANwJbAVsC8yPioZzmskr6fwMmSLoLuAEYDmy6TL/MbBmV+vCRrV4OJdWQd4iIFyU9TAqgkP6Le80/gbVa5LWE3pWd4QCSNgeOB3aMiEWSLqosoxkBB0TEA+38CLNOcE3dSvBK4PEc0PcAGv4X95qIWAw8I2nnPOrgyuSHgTdLGiJpE2CnPH4d4FngKUkbAnvl8Q8AYySNzsMfrOQ1DTi21hQkabvl+G1my8Q1dSvBJcAv8msBuoH725jnSOA8Sf8Cfgs8lcffAjwEzAXuA2YCRMTdkmblvB/J6YiIf0j6JHCNpGeB6ZVlnAb8P2C2pCE5339fgd9p1pJfE2CrJUlrR8Tf8vcJwEYRcdyK5JVr5BOB30fENztYXLO2ufnFVlf75NsZ7wXeDnxlBfL6WO4MnUNqCjq3A+UzWy6uqZuZFcQ1dTOzgjiom5kVxEHdzKwgDupmZgVxUDczK8j/B+8tIZHRsxt3AAAAAElFTkSuQmCC\n",
      "text/plain": [
       "<Figure size 432x288 with 1 Axes>"
      ]
     },
     "metadata": {
      "needs_background": "light"
     },
     "output_type": "display_data"
    }
   ],
   "source": [
    "# plot the chart\n",
    "value_counts = cleaned_df['language'].value_counts()\n",
    "value_counts.plot(kind='bar')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "id": "ee142f0d",
   "metadata": {},
   "outputs": [],
   "source": [
    "en_df = cleaned_df[cleaned_df['language']=='en']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "id": "0a0a2257",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(1311870, 7)"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "en_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "id": "bdb827e7",
   "metadata": {},
   "outputs": [],
   "source": [
    "# 17070149, 62953383, 74312785, 25197378"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "id": "0de41259",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1025406</th>\n",
       "      <td>38799388</td>\n",
       "      <td>599032802</td>\n",
       "      <td>2020-01-28</td>\n",
       "      <td>62953383</td>\n",
       "      <td>Dohyup</td>\n",
       "      <td>카드키가 세번 이상 작동한적이 없어요 모두들 같은걸로 고생하고요. 진...짜 귀찮고 카운터에 줄 항상 서있어서 앨리베이터 왔다갔다 기다렸다 하는거때문에 15분족히 잡아먹어요 그것도 매일매일.아예 나갔다 오시면 그냥 바로 카드키 안된다고 하고 바꾸는게 효율적. 위치는 보시다시피 좋습니다.  Terrible card key problems. Stayed there for 3 nights and i had to change my card three times. Thats every night me going back and forth from the room to the counter. Theres always people lining up at the counter so you had to wait. Just  imagine how frustrating that would be. Other than that everything else was great.</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "         listing_id         id        date  reviewer_id reviewer_name   \n",
       "1025406    38799388  599032802  2020-01-28     62953383        Dohyup  \\\n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   comments   \n",
       "1025406  카드키가 세번 이상 작동한적이 없어요 모두들 같은걸로 고생하고요. 진...짜 귀찮고 카운터에 줄 항상 서있어서 앨리베이터 왔다갔다 기다렸다 하는거때문에 15분족히 잡아먹어요 그것도 매일매일.아예 나갔다 오시면 그냥 바로 카드키 안된다고 하고 바꾸는게 효율적. 위치는 보시다시피 좋습니다.  Terrible card key problems. Stayed there for 3 nights and i had to change my card three times. Thats every night me going back and forth from the room to the counter. Theres always people lining up at the counter so you had to wait. Just  imagine how frustrating that would be. Other than that everything else was great.  \\\n",
       "\n",
       "        language  \n",
       "1025406       en  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "en_df[en_df['reviewer_id']==62953383]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "id": "9285f853",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>380</th>\n",
       "      <td>52871</td>\n",
       "      <td>491132264</td>\n",
       "      <td>2019-07-19</td>\n",
       "      <td>74312785</td>\n",
       "      <td>倩</td>\n",
       "      <td>Micah的房子干净整洁，地理位置特别好，转个弯就是一条街的餐厅，两个街区有二十四小时超市，Micah会提供加州牌照的parking permit，停车就在门口很方便。房东很热情到门口迎接，交代一些注意事项。 Nice, clean place. Very close to many good restaurants. Easy parking and convenient drive to anywhere. Micah is a warm man and he is always there for helping me. It will still be my choice for next trip. ٩(˃̶͈̀௰˂̶͈́)و</td>\n",
       "      <td>en</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     listing_id         id        date  reviewer_id reviewer_name   \n",
       "380       52871  491132264  2019-07-19     74312785             倩  \\\n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                               comments   \n",
       "380  Micah的房子干净整洁，地理位置特别好，转个弯就是一条街的餐厅，两个街区有二十四小时超市，Micah会提供加州牌照的parking permit，停车就在门口很方便。房东很热情到门口迎接，交代一些注意事项。 Nice, clean place. Very close to many good restaurants. Easy parking and convenient drive to anywhere. Micah is a warm man and he is always there for helping me. It will still be my choice for next trip. ٩(˃̶͈̀௰˂̶͈́)و  \\\n",
       "\n",
       "    language  \n",
       "380       en  "
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "en_df[en_df['reviewer_id']==74312785]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "eedf9f26",
   "metadata": {},
   "source": [
    "Since we find that the language detection is not very accuracy. So we will use regular expression to clean it again."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "id": "75ec35e2",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_review_df = en_df.copy()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "id": "3e30199d",
   "metadata": {},
   "outputs": [],
   "source": [
    "final_review_df['comments2'] = final_review_df['comments'].apply(lambda x: re.sub(r\"[^A-Za-z0-9\\s,.!?]\", '', str(x)))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 30,
   "id": "12ae2238",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "      <th>comments2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [listing_id, id, date, reviewer_id, reviewer_name, comments, language, comments2]\n",
       "Index: []"
      ]
     },
     "execution_count": 30,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_review_df[final_review_df['reviewer_id']==25197378]"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "826c8c3f",
   "metadata": {},
   "source": [
    "#### We find that there are many comments are useless. So we will remove the data based on the length that is less than 3."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "id": "3cfa6c1b",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "      <th>comments2</th>\n",
       "      <th>text_length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>52137</th>\n",
       "      <td>621233</td>\n",
       "      <td>407643992</td>\n",
       "      <td>2019-02-02</td>\n",
       "      <td>108351329</td>\n",
       "      <td>Sterling</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235357</th>\n",
       "      <td>5728008</td>\n",
       "      <td>54834490</td>\n",
       "      <td>2015-11-23</td>\n",
       "      <td>48439195</td>\n",
       "      <td>Mishel</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>655846</th>\n",
       "      <td>20775165</td>\n",
       "      <td>555545086</td>\n",
       "      <td>2019-10-27</td>\n",
       "      <td>127446404</td>\n",
       "      <td>Nicolle</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>809415</th>\n",
       "      <td>26356811</td>\n",
       "      <td>422665516</td>\n",
       "      <td>2019-03-11</td>\n",
       "      <td>188170678</td>\n",
       "      <td>Rob</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903417</th>\n",
       "      <td>31101008</td>\n",
       "      <td>659180887</td>\n",
       "      <td>2020-08-31</td>\n",
       "      <td>351684508</td>\n",
       "      <td>Tristen</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972684</th>\n",
       "      <td>35486822</td>\n",
       "      <td>592835118660236272</td>\n",
       "      <td>2022-03-28</td>\n",
       "      <td>304474943</td>\n",
       "      <td>Kenneth</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1043069</th>\n",
       "      <td>39300364</td>\n",
       "      <td>508812347196201861</td>\n",
       "      <td>2021-12-02</td>\n",
       "      <td>49124901</td>\n",
       "      <td>Shaquille</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1103701</th>\n",
       "      <td>43329347</td>\n",
       "      <td>727771164</td>\n",
       "      <td>2021-01-30</td>\n",
       "      <td>385411537</td>\n",
       "      <td>Shamia</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1173263</th>\n",
       "      <td>48158561</td>\n",
       "      <td>741947633</td>\n",
       "      <td>2021-03-24</td>\n",
       "      <td>238802018</td>\n",
       "      <td>Derek</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1236823</th>\n",
       "      <td>51284419</td>\n",
       "      <td>770367108919245822</td>\n",
       "      <td>2022-11-28</td>\n",
       "      <td>486410982</td>\n",
       "      <td>Ali</td>\n",
       "      <td>o</td>\n",
       "      <td>en</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1297419</th>\n",
       "      <td>54214302</td>\n",
       "      <td>565288069883387076</td>\n",
       "      <td>2022-02-18</td>\n",
       "      <td>375801226</td>\n",
       "      <td>Tanya</td>\n",
       "      <td>C</td>\n",
       "      <td>en</td>\n",
       "      <td>C</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1325547</th>\n",
       "      <td>590577034826950978</td>\n",
       "      <td>692780910445535240</td>\n",
       "      <td>2022-08-13</td>\n",
       "      <td>287920055</td>\n",
       "      <td>Taylor</td>\n",
       "      <td>o</td>\n",
       "      <td>en</td>\n",
       "      <td>o</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 listing_id                  id        date  reviewer_id   \n",
       "52137                621233           407643992  2019-02-02    108351329  \\\n",
       "235357              5728008            54834490  2015-11-23     48439195   \n",
       "655846             20775165           555545086  2019-10-27    127446404   \n",
       "809415             26356811           422665516  2019-03-11    188170678   \n",
       "903417             31101008           659180887  2020-08-31    351684508   \n",
       "972684             35486822  592835118660236272  2022-03-28    304474943   \n",
       "1043069            39300364  508812347196201861  2021-12-02     49124901   \n",
       "1103701            43329347           727771164  2021-01-30    385411537   \n",
       "1173263            48158561           741947633  2021-03-24    238802018   \n",
       "1236823            51284419  770367108919245822  2022-11-28    486410982   \n",
       "1297419            54214302  565288069883387076  2022-02-18    375801226   \n",
       "1325547  590577034826950978  692780910445535240  2022-08-13    287920055   \n",
       "\n",
       "        reviewer_name comments language comments2  text_length  \n",
       "52137        Sterling        C       en         C            1  \n",
       "235357         Mishel        C       en         C            1  \n",
       "655846        Nicolle        C       en         C            1  \n",
       "809415            Rob        C       en         C            1  \n",
       "903417        Tristen        C       en         C            1  \n",
       "972684        Kenneth        C       en         C            1  \n",
       "1043069     Shaquille        C       en         C            1  \n",
       "1103701        Shamia        C       en         C            1  \n",
       "1173263         Derek        C       en         C            1  \n",
       "1236823           Ali        o       en         o            1  \n",
       "1297419         Tanya        C       en         C            1  \n",
       "1325547        Taylor        o       en         o            1  "
      ]
     },
     "execution_count": 31,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_review_df['text_length'] = final_review_df['comments2'].apply(len)\n",
    "final_review_df[(final_review_df['text_length'] == final_review_df['text_length'].min())]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 144,
   "id": "74eae0a2",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "      <th>comments2</th>\n",
       "      <th>text_length</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>640347</th>\n",
       "      <td>20286737</td>\n",
       "      <td>770431721691013076</td>\n",
       "      <td>2022-11-28</td>\n",
       "      <td>127995805</td>\n",
       "      <td>Edwin</td>\n",
       "      <td>Great home feeling and welcome. Very great hosts.</td>\n",
       "      <td>en</td>\n",
       "      <td>Great home feeling and welcome. Very great hosts.</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1343437</th>\n",
       "      <td>624131989893429408</td>\n",
       "      <td>704435184701705124</td>\n",
       "      <td>2022-08-29</td>\n",
       "      <td>236670172</td>\n",
       "      <td>Linda</td>\n",
       "      <td>We have an awesome stay. Xi was responsive and provided excellent services via text. The neighborhood is quiet. The place is clean, very spacious, kitchen/ laundry area is well equipped, with other amenities. Beautiful backyard with picnic table. The location is very convenient. Checking in and out was super smooth. Highly recommended to everyone.</td>\n",
       "      <td>en</td>\n",
       "      <td>We have an awesome stay. Xi was responsive and provided excellent services via text. The neighborhood is quiet. The place is clean, very spacious, kitchen laundry area is well equipped, with other amenities. Beautiful backyard with picnic table. The location is very convenient. Checking in and out was super smooth. Highly recommended to everyone.</td>\n",
       "      <td>348</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>935966</th>\n",
       "      <td>33250843</td>\n",
       "      <td>736318073</td>\n",
       "      <td>2021-03-04</td>\n",
       "      <td>359606280</td>\n",
       "      <td>Jordan</td>\n",
       "      <td>Exactly as advertised. Josie was very hospitable.</td>\n",
       "      <td>en</td>\n",
       "      <td>Exactly as advertised. Josie was very hospitable.</td>\n",
       "      <td>49</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>552212</th>\n",
       "      <td>17570773</td>\n",
       "      <td>179909651</td>\n",
       "      <td>2017-08-08</td>\n",
       "      <td>34576931</td>\n",
       "      <td>Izabella</td>\n",
       "      <td>Ed was a great host! The place was a perfect beach getaway for us and everything was perfect.</td>\n",
       "      <td>en</td>\n",
       "      <td>Ed was a great host! The place was a perfect beach getaway for us and everything was perfect.</td>\n",
       "      <td>93</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168995</th>\n",
       "      <td>3282972</td>\n",
       "      <td>755381513</td>\n",
       "      <td>2021-05-05</td>\n",
       "      <td>346892226</td>\n",
       "      <td>Dymond</td>\n",
       "      <td>This place was way better than expected . Super cute and secluded with a beautiful outdoor space. The bed was comfy , the area was cute and trisja was super helpful . We would definitely recommend this place to anyone looking for comfortable and peaceful stay.</td>\n",
       "      <td>en</td>\n",
       "      <td>This place was way better than expected . Super cute and secluded with a beautiful outdoor space. The bed was comfy , the area was cute and trisja was super helpful . We would definitely recommend this place to anyone looking for comfortable and peaceful stay.</td>\n",
       "      <td>260</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                 listing_id                  id        date  reviewer_id   \n",
       "640347             20286737  770431721691013076  2022-11-28    127995805  \\\n",
       "1343437  624131989893429408  704435184701705124  2022-08-29    236670172   \n",
       "935966             33250843           736318073  2021-03-04    359606280   \n",
       "552212             17570773           179909651  2017-08-08     34576931   \n",
       "168995              3282972           755381513  2021-05-05    346892226   \n",
       "\n",
       "        reviewer_name   \n",
       "640347          Edwin  \\\n",
       "1343437         Linda   \n",
       "935966         Jordan   \n",
       "552212       Izabella   \n",
       "168995         Dymond   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                              comments   \n",
       "640347                                                                                                                                                                                                                                                                                                               Great home feeling and welcome. Very great hosts.  \\\n",
       "1343437  We have an awesome stay. Xi was responsive and provided excellent services via text. The neighborhood is quiet. The place is clean, very spacious, kitchen/ laundry area is well equipped, with other amenities. Beautiful backyard with picnic table. The location is very convenient. Checking in and out was super smooth. Highly recommended to everyone.   \n",
       "935966                                                                                                                                                                                                                                                                                                               Exactly as advertised. Josie was very hospitable.   \n",
       "552212                                                                                                                                                                                                                                                                   Ed was a great host! The place was a perfect beach getaway for us and everything was perfect.   \n",
       "168995                                                                                            This place was way better than expected . Super cute and secluded with a beautiful outdoor space. The bed was comfy , the area was cute and trisja was super helpful . We would definitely recommend this place to anyone looking for comfortable and peaceful stay.   \n",
       "\n",
       "        language   \n",
       "640347        en  \\\n",
       "1343437       en   \n",
       "935966        en   \n",
       "552212        en   \n",
       "168995        en   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                            comments2   \n",
       "640347                                                                                                                                                                                                                                                                                                              Great home feeling and welcome. Very great hosts.  \\\n",
       "1343437  We have an awesome stay. Xi was responsive and provided excellent services via text. The neighborhood is quiet. The place is clean, very spacious, kitchen laundry area is well equipped, with other amenities. Beautiful backyard with picnic table. The location is very convenient. Checking in and out was super smooth. Highly recommended to everyone.   \n",
       "935966                                                                                                                                                                                                                                                                                                              Exactly as advertised. Josie was very hospitable.   \n",
       "552212                                                                                                                                                                                                                                                                  Ed was a great host! The place was a perfect beach getaway for us and everything was perfect.   \n",
       "168995                                                                                           This place was way better than expected . Super cute and secluded with a beautiful outdoor space. The bed was comfy , the area was cute and trisja was super helpful . We would definitely recommend this place to anyone looking for comfortable and peaceful stay.   \n",
       "\n",
       "         text_length  \n",
       "640347            49  \n",
       "1343437          348  \n",
       "935966            49  \n",
       "552212            93  \n",
       "168995           260  "
      ]
     },
     "execution_count": 144,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "final_review_df = final_review_df[final_review_df['text_length'] >2]\n",
    "final_review_df.sample(5)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 145,
   "id": "ee3bc314",
   "metadata": {},
   "outputs": [],
   "source": [
    "# save to csv\n",
    "final_review_df.to_csv('final_review_df.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "397eea43",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "5dbb07c3",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "markdown",
   "id": "666f5a23",
   "metadata": {},
   "source": [
    "#### Translate other language to english"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "id": "e3ec5a23",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>2708</td>\n",
       "      <td>222420570</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>155985882</td>\n",
       "      <td>Manami</td>\n",
       "      <td>ホストはとても親切で英語の発音の仕方など丁寧に教えてくれた。  部屋はリビングを板で仕切っているのであまりプライバシーが守られていない。 朝になると電話の音やキッチンの音や話し声がそのまま聞こえる。  ハリウッドの中心地から歩いて15分程なのでロケーションは最高はとても便利。 スーパーやその他ショップ、バス停も徒歩5分以内。</td>\n",
       "      <td>ja</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>180926</td>\n",
       "      <td>623253801</td>\n",
       "      <td>2020-04-27</td>\n",
       "      <td>173904821</td>\n",
       "      <td>Shamikah</td>\n",
       "      <td>such a peaceful space!</td>\n",
       "      <td>ro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>180926</td>\n",
       "      <td>631566322</td>\n",
       "      <td>2020-06-22</td>\n",
       "      <td>350686458</td>\n",
       "      <td>Ekaterina</td>\n",
       "      <td>Peaceful escape</td>\n",
       "      <td>ro</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>52871</td>\n",
       "      <td>556835</td>\n",
       "      <td>2011-09-22</td>\n",
       "      <td>904557</td>\n",
       "      <td>Aurelie</td>\n",
       "      <td>L appartement est tres bien situé et fidele aux photos du site.  Micah a ete adorable avec nous et a tout fait pour que l on se sente bien.</td>\n",
       "      <td>fr</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>146</th>\n",
       "      <td>52871</td>\n",
       "      <td>21087281</td>\n",
       "      <td>2014-10-11</td>\n",
       "      <td>20963527</td>\n",
       "      <td>Bei</td>\n",
       "      <td>首先感谢房东先生第一天给我们的warm welcome，还特别提醒我们车辆可以停放的路边。刚到的那天是晚上所以门牌号有点不好找，而且有些门牌号都隐藏在里面，我们大概找了15分钟，晕噢。后来终于找到了，是一间类似公寓的房子。出入都很方便。房间里的摆设和布置也很温馨，wifi和电视都有，房东还很细心的留下了电视机使用图，很不错！总体来说这两天的入住很愉快。谢谢！</td>\n",
       "      <td>zh-cn</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "     listing_id         id        date  reviewer_id reviewer_name   \n",
       "10         2708  222420570  2017-12-29    155985882        Manami  \\\n",
       "33       180926  623253801  2020-04-27    173904821      Shamikah   \n",
       "39       180926  631566322  2020-06-22    350686458     Ekaterina   \n",
       "61        52871     556835  2011-09-22       904557       Aurelie   \n",
       "146       52871   21087281  2014-10-11     20963527           Bei   \n",
       "\n",
       "                                                                                                                                                                                 comments   \n",
       "10                    ホストはとても親切で英語の発音の仕方など丁寧に教えてくれた。  部屋はリビングを板で仕切っているのであまりプライバシーが守られていない。 朝になると電話の音やキッチンの音や話し声がそのまま聞こえる。  ハリウッドの中心地から歩いて15分程なのでロケーションは最高はとても便利。 スーパーやその他ショップ、バス停も徒歩5分以内。  \\\n",
       "33                                                                                                                                                                 such a peaceful space!   \n",
       "39                                                                                                                                                                        Peaceful escape   \n",
       "61                                          L appartement est tres bien situé et fidele aux photos du site.  Micah a ete adorable avec nous et a tout fait pour que l on se sente bien.     \n",
       "146  首先感谢房东先生第一天给我们的warm welcome，还特别提醒我们车辆可以停放的路边。刚到的那天是晚上所以门牌号有点不好找，而且有些门牌号都隐藏在里面，我们大概找了15分钟，晕噢。后来终于找到了，是一间类似公寓的房子。出入都很方便。房间里的摆设和布置也很温馨，wifi和电视都有，房东还很细心的留下了电视机使用图，很不错！总体来说这两天的入住很愉快。谢谢！   \n",
       "\n",
       "    language  \n",
       "10        ja  \n",
       "33        ro  \n",
       "39        ro  \n",
       "61        fr  \n",
       "146    zh-cn  "
      ]
     },
     "execution_count": 68,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "non_en_df = cleaned_df[cleaned_df['language']!='en']\n",
    "non_en_df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "id": "2208c543",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(83412, 7)"
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "non_en_df.shape"
   ]
  },
  {
   "cell_type": "markdown",
   "id": "c9a81048",
   "metadata": {},
   "source": [
    "We find that there are nan in the comments. So we need to drop them."
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 106,
   "id": "4e0338a9",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>11071</th>\n",
       "      <td>84636</td>\n",
       "      <td>495249203</td>\n",
       "      <td>2019-07-25</td>\n",
       "      <td>274807820</td>\n",
       "      <td>Quintin</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17223</th>\n",
       "      <td>124199</td>\n",
       "      <td>579036832961614906</td>\n",
       "      <td>2022-03-09</td>\n",
       "      <td>300215176</td>\n",
       "      <td>Flower</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28770</th>\n",
       "      <td>409740</td>\n",
       "      <td>555105315841340348</td>\n",
       "      <td>2022-02-04</td>\n",
       "      <td>27285770</td>\n",
       "      <td>Kadeem</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31988</th>\n",
       "      <td>438464</td>\n",
       "      <td>668226343566784763</td>\n",
       "      <td>2022-07-10</td>\n",
       "      <td>16837415</td>\n",
       "      <td>Zachary</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35555</th>\n",
       "      <td>400940</td>\n",
       "      <td>222095314</td>\n",
       "      <td>2017-12-28</td>\n",
       "      <td>54891561</td>\n",
       "      <td>Irene</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</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",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1374761</th>\n",
       "      <td>703727818646989923</td>\n",
       "      <td>811705425859581621</td>\n",
       "      <td>2023-01-24</td>\n",
       "      <td>471367329</td>\n",
       "      <td>Zhuqing</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1384213</th>\n",
       "      <td>733307482015690100</td>\n",
       "      <td>800097596655374997</td>\n",
       "      <td>2023-01-08</td>\n",
       "      <td>345715194</td>\n",
       "      <td>Karvon</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1386163</th>\n",
       "      <td>740120053187181887</td>\n",
       "      <td>834945061408842470</td>\n",
       "      <td>2023-02-25</td>\n",
       "      <td>382912469</td>\n",
       "      <td>Matthew</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1390732</th>\n",
       "      <td>759306265762146686</td>\n",
       "      <td>803005517846458209</td>\n",
       "      <td>2023-01-12</td>\n",
       "      <td>9721087</td>\n",
       "      <td>Joy</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1391697</th>\n",
       "      <td>763769619346224380</td>\n",
       "      <td>790722767106430523</td>\n",
       "      <td>2022-12-26</td>\n",
       "      <td>396551317</td>\n",
       "      <td>Sri Vidya Surya Haritha</td>\n",
       "      <td>nan</td>\n",
       "      <td>tl</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>325 rows × 7 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 listing_id                  id        date  reviewer_id   \n",
       "11071                 84636           495249203  2019-07-25    274807820  \\\n",
       "17223                124199  579036832961614906  2022-03-09    300215176   \n",
       "28770                409740  555105315841340348  2022-02-04     27285770   \n",
       "31988                438464  668226343566784763  2022-07-10     16837415   \n",
       "35555                400940           222095314  2017-12-28     54891561   \n",
       "...                     ...                 ...         ...          ...   \n",
       "1374761  703727818646989923  811705425859581621  2023-01-24    471367329   \n",
       "1384213  733307482015690100  800097596655374997  2023-01-08    345715194   \n",
       "1386163  740120053187181887  834945061408842470  2023-02-25    382912469   \n",
       "1390732  759306265762146686  803005517846458209  2023-01-12      9721087   \n",
       "1391697  763769619346224380  790722767106430523  2022-12-26    396551317   \n",
       "\n",
       "                   reviewer_name comments language  \n",
       "11071                    Quintin      nan       tl  \n",
       "17223                     Flower      nan       tl  \n",
       "28770                     Kadeem      nan       tl  \n",
       "31988                    Zachary      nan       tl  \n",
       "35555                      Irene      nan       tl  \n",
       "...                          ...      ...      ...  \n",
       "1374761                  Zhuqing      nan       tl  \n",
       "1384213                   Karvon      nan       tl  \n",
       "1386163                  Matthew      nan       tl  \n",
       "1390732                      Joy      nan       tl  \n",
       "1391697  Sri Vidya Surya Haritha      nan       tl  \n",
       "\n",
       "[325 rows x 7 columns]"
      ]
     },
     "execution_count": 106,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "non_en_df[non_en_df['comments']=='nan']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 124,
   "id": "bc1eebc3",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(83087, 7)"
      ]
     },
     "execution_count": 124,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "non_en_df = non_en_df[non_en_df['comments'] != 'nan']\n",
    "non_en_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 116,
   "id": "5ec46cff",
   "metadata": {},
   "outputs": [],
   "source": [
    "def translate_to_english(text):\n",
    "    translator = GoogleTranslator(source='auto', target='en')\n",
    "    return translator.translate(text)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 118,
   "id": "faa3fb27",
   "metadata": {},
   "outputs": [],
   "source": [
    "non_en_df2 = non_en_df.sample(n=10000)\n",
    "non_en_df2 = non_en_df2.reset_index(drop=True)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 123,
   "id": "4d63fabf",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "      <th>comments2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>26568418</td>\n",
       "      <td>530460913</td>\n",
       "      <td>2019-09-15</td>\n",
       "      <td>13862960</td>\n",
       "      <td>Barbara</td>\n",
       "      <td>Le studio était génial et répondait largement à nos attentes !   Très bien placé et proche de Melrose Ave, nous n’étions pas loin du quartier branché de Beverly Hills. Michelle et Sam étaient au top pendant notre séjour et nous avons adoré leurs chiens  (surtout Harley, il était tellement adorable).   Nous gardons cette adresse et nous reviendrons c’est sur ! Merci encore !</td>\n",
       "      <td>fr</td>\n",
       "      <td>The studio was great and more than met our expectations! Very well located and close to Melrose Ave, we were not far from the trendy area of ​​Beverly Hills. Michelle and Sam were top notch during our stay and we loved their dogs (especially Harley, he was so adorable). We keep this address and we will come back for sure! Thanks again !</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>20887150</td>\n",
       "      <td>530500198</td>\n",
       "      <td>2019-09-15</td>\n",
       "      <td>21043735</td>\n",
       "      <td>Kyungjin</td>\n",
       "      <td>DiDi 의 친절함과 세심한 배려에 너무나도 잘 쉬고 갑니다. 예쁜 뒷마당도 너무 분위기 좋았습니다. 같이 지낸 제니와 갸토도 너무 이쁘고 귀여웠어요. 정말 미국 가정적인 분위기에서 잘 지냈습니다^^ 공항이랑 해변이랑도 가까워서 편리했습니다!</td>\n",
       "      <td>ko</td>\n",
       "      <td>I rested very well thanks to DiDi's kindness and meticulous consideration. The beautiful backyard was also very atmospheric. Jennie and Gyato who were together were also very pretty and cute. I really had a good time in an American family atmosphere. It was convenient because it was close to the airport and the beach!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2516719</td>\n",
       "      <td>301783188</td>\n",
       "      <td>2018-08-04</td>\n",
       "      <td>198523214</td>\n",
       "      <td>Jessica</td>\n",
       "      <td>Belle maison avec une belle chambre confortable. Environnement calme et respectueux. Et près de venice beach en auto en plus!</td>\n",
       "      <td>fr</td>\n",
       "      <td>Beautiful house with a nice comfortable bedroom. Calm and respectful environment. And near Venice Beach by car too!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1677768</td>\n",
       "      <td>604869245</td>\n",
       "      <td>2020-02-12</td>\n",
       "      <td>38444104</td>\n",
       "      <td>Theresa</td>\n",
       "      <td>Ett lugnt och trivsamt ställe med gästvänliga människor (och hundar).</td>\n",
       "      <td>sv</td>\n",
       "      <td>A quiet and pleasant place with hospitable people (and dogs).</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>18098133</td>\n",
       "      <td>428696795</td>\n",
       "      <td>2019-03-25</td>\n",
       "      <td>209953999</td>\n",
       "      <td>Sydney</td>\n",
       "      <td>Great space, clean, private.</td>\n",
       "      <td>ro</td>\n",
       "      <td>Great space, clean, private.</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   listing_id         id        date  reviewer_id reviewer_name   \n",
       "0    26568418  530460913  2019-09-15     13862960       Barbara  \\\n",
       "1    20887150  530500198  2019-09-15     21043735      Kyungjin   \n",
       "2     2516719  301783188  2018-08-04    198523214       Jessica   \n",
       "3     1677768  604869245  2020-02-12     38444104       Theresa   \n",
       "4    18098133  428696795  2019-03-25    209953999        Sydney   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                   comments   \n",
       "0  Le studio était génial et répondait largement à nos attentes !   Très bien placé et proche de Melrose Ave, nous n’étions pas loin du quartier branché de Beverly Hills. Michelle et Sam étaient au top pendant notre séjour et nous avons adoré leurs chiens  (surtout Harley, il était tellement adorable).   Nous gardons cette adresse et nous reviendrons c’est sur ! Merci encore !  \\\n",
       "1                                                                                                                                                                                                                                                   DiDi 의 친절함과 세심한 배려에 너무나도 잘 쉬고 갑니다. 예쁜 뒷마당도 너무 분위기 좋았습니다. 같이 지낸 제니와 갸토도 너무 이쁘고 귀여웠어요. 정말 미국 가정적인 분위기에서 잘 지냈습니다^^ 공항이랑 해변이랑도 가까워서 편리했습니다!   \n",
       "2                                                                                                                                                                                                                                                            Belle maison avec une belle chambre confortable. Environnement calme et respectueux. Et près de venice beach en auto en plus!    \n",
       "3                                                                                                                                                                                                                                                                                                                     Ett lugnt och trivsamt ställe med gästvänliga människor (och hundar).   \n",
       "4                                                                                                                                                                                                                                                                                                                                                              Great space, clean, private.   \n",
       "\n",
       "  language   \n",
       "0       fr  \\\n",
       "1       ko   \n",
       "2       fr   \n",
       "3       sv   \n",
       "4       ro   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                            comments2  \n",
       "0  The studio was great and more than met our expectations! Very well located and close to Melrose Ave, we were not far from the trendy area of ​​Beverly Hills. Michelle and Sam were top notch during our stay and we loved their dogs (especially Harley, he was so adorable). We keep this address and we will come back for sure! Thanks again !  \n",
       "1                     I rested very well thanks to DiDi's kindness and meticulous consideration. The beautiful backyard was also very atmospheric. Jennie and Gyato who were together were also very pretty and cute. I really had a good time in an American family atmosphere. It was convenient because it was close to the airport and the beach!  \n",
       "2                                                                                                                                                                                                                                 Beautiful house with a nice comfortable bedroom. Calm and respectful environment. And near Venice Beach by car too!  \n",
       "3                                                                                                                                                                                                                                                                                       A quiet and pleasant place with hospitable people (and dogs).  \n",
       "4                                                                                                                                                                                                                                                                                                                        Great space, clean, private.  "
      ]
     },
     "execution_count": 123,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "non_en_df2.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 120,
   "id": "6c6e2e75",
   "metadata": {},
   "outputs": [],
   "source": [
    "non_en_df2['comments2'] = non_en_df2['comments'].apply(lambda x: translate_to_english(x))\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 122,
   "id": "e5e1af30",
   "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>listing_id</th>\n",
       "      <th>id</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer_id</th>\n",
       "      <th>reviewer_name</th>\n",
       "      <th>comments</th>\n",
       "      <th>language</th>\n",
       "      <th>comments2</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>1613</th>\n",
       "      <td>17286928</td>\n",
       "      <td>714628498960591805</td>\n",
       "      <td>2022-09-12</td>\n",
       "      <td>131731765</td>\n",
       "      <td>Moonhee</td>\n",
       "      <td>어웈 념뮤 펼룝옒요 청옹말 싫맗히얘욣 됸양꺄웟욞 쳘퉤류 카지맛요  와 너무 좋은 숙소입니다 la에서 잘쉬다가 갑니다.</td>\n",
       "      <td>ko</td>\n",
       "      <td>Wow, I didn't like it, I didn't like it, I didn't like it.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2579</th>\n",
       "      <td>21325548</td>\n",
       "      <td>518505746</td>\n",
       "      <td>2019-08-26</td>\n",
       "      <td>107545149</td>\n",
       "      <td>Mahamadou</td>\n",
       "      <td>Super appartement !</td>\n",
       "      <td>fr</td>\n",
       "      <td>Great apartment!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>735514791620448966</td>\n",
       "      <td>748682913084121476</td>\n",
       "      <td>2022-10-29</td>\n",
       "      <td>138745626</td>\n",
       "      <td>Daniel</td>\n",
       "      <td>Moderno departamento</td>\n",
       "      <td>pt</td>\n",
       "      <td>modern apartment</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1646</th>\n",
       "      <td>33884448</td>\n",
       "      <td>736140288</td>\n",
       "      <td>2021-03-03</td>\n",
       "      <td>377548800</td>\n",
       "      <td>Jackie</td>\n",
       "      <td>5 stars</td>\n",
       "      <td>sv</td>\n",
       "      <td>5 stars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1223</th>\n",
       "      <td>7594667</td>\n",
       "      <td>431146387465330103</td>\n",
       "      <td>2021-08-17</td>\n",
       "      <td>222761444</td>\n",
       "      <td>Yohannes</td>\n",
       "      <td>Beautiful place</td>\n",
       "      <td>ro</td>\n",
       "      <td>Beautiful place</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4719</th>\n",
       "      <td>10454154</td>\n",
       "      <td>708071000</td>\n",
       "      <td>2020-11-10</td>\n",
       "      <td>134982534</td>\n",
       "      <td>Kris</td>\n",
       "      <td>Nice cozy spot</td>\n",
       "      <td>pl</td>\n",
       "      <td>Nice cozy spot</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7345</th>\n",
       "      <td>44408051</td>\n",
       "      <td>666717983943939945</td>\n",
       "      <td>2022-07-08</td>\n",
       "      <td>356565979</td>\n",
       "      <td>Nique</td>\n",
       "      <td>Nice place</td>\n",
       "      <td>ro</td>\n",
       "      <td>Nice place</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1789</th>\n",
       "      <td>52388463</td>\n",
       "      <td>758122387318333869</td>\n",
       "      <td>2022-11-11</td>\n",
       "      <td>146596188</td>\n",
       "      <td>Coline</td>\n",
       "      <td>Anita est une super hôte. Nous avons eu la chance d’avoir du réseau sur place et elle a été très réactive. Le lieu est magique. Nous avions un peu peur du froid de novembre mais les couettes chaudes et le chauffage nous ont permis de passer une bonne nuit. Tout est prévu sur place pour passer un bon moment (barbecue, jeu, brasero)</td>\n",
       "      <td>fr</td>\n",
       "      <td>Anita is a great host. We were lucky to have a network on site and she was very responsive. The place is magical. We were a little afraid of the November cold, but the warm duvets and the heating allowed us to have a good night's sleep. Everything is provided on site to have a good time (barbecue, game, brazier)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4514</th>\n",
       "      <td>15974796</td>\n",
       "      <td>732182821</td>\n",
       "      <td>2021-02-17</td>\n",
       "      <td>387897800</td>\n",
       "      <td>Sanford</td>\n",
       "      <td>Decent</td>\n",
       "      <td>nl</td>\n",
       "      <td>Decent</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3696</th>\n",
       "      <td>286866</td>\n",
       "      <td>508422199</td>\n",
       "      <td>2019-08-12</td>\n",
       "      <td>144422525</td>\n",
       "      <td>Candice</td>\n",
       "      <td>房子两室有点小，房间设施那么新，卫生间很小很旧，洗澡的时候下水还是堵的。两个卫生间只有一个能洗浴，另一个没有洗澡设施。房子价格预定和后来的价格波动特别大，后来便宜很多～～</td>\n",
       "      <td>zh-cn</td>\n",
       "      <td>The two rooms of the house are a bit small, the room facilities are so new, the bathroom is very small and old, and the water is still blocked when taking a shower. Only one of the two bathrooms can take a bath, and the other has no bathing facilities. The house price reservation and subsequent price fluctuations were particularly large, and it was much cheaper later~~</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>948</th>\n",
       "      <td>53871874</td>\n",
       "      <td>812481206767828471</td>\n",
       "      <td>2023-01-25</td>\n",
       "      <td>29480299</td>\n",
       "      <td>슬아</td>\n",
       "      <td>지하주차공간이 확보되어 안전하게 주차할 수 있었습니다. 체크인 안내도 정확하고 어렵지 않았습니다. 침구가 좋고 인테리어가 깔끔해요. 화장실이 2개라 유용하게 잘 썼습니다. 수건도 넉넉했구요. 와이파이도 문제 없이 사용했어요.  예약 전 에어비앤비 상으로 보이는 위치와 다릅니다만, 예약 후 바로 정확한 주소를 받았습니다. 그로브몰 및 홀푸드마켓과 인접해요.  큰 길가에 있어 치안 걱정 없이 이용했어요!</td>\n",
       "      <td>ko</td>\n",
       "      <td>Underground parking space was secured, so we were able to park safely. Check-in information was accurate and not difficult. The bedding is good and the interior is tidy. There are 2 bathrooms, so I put them to good use. There were also plenty of towels. I also used wifi without any problems. It's different from the location shown on Airbnb before booking, but I received the correct address right after booking. Close to Grove Mall and Whole Foods Market. It's on the main road, so I used it without worrying about security!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8217</th>\n",
       "      <td>6975613</td>\n",
       "      <td>78237840</td>\n",
       "      <td>2016-06-05</td>\n",
       "      <td>56034400</td>\n",
       "      <td>Muriel</td>\n",
       "      <td>Tropical oasis is een absolute aanrader. Een grote slaapkamer, aparte eetkamer/keuken, heel schoon en een prachtige tuin met zwembad en jacuzzi. Kristy en Hendrik zijn zeer gastvrij en aardig.   Erg prettig dat je de auto op het eigen terrein kan parkeren, een auto is een must om te hebben als je LA wil bezichtigen waar alles ver van elkaar vandaag ligt. We hebben een hier een heerlijke tijd gehad en zullen in de toekomst zeker weer voor Tropical oasis kiezen.</td>\n",
       "      <td>nl</td>\n",
       "      <td>Tropical oasis is an absolute must. A large bedroom, separate dining room / kitchen, very clean and a beautiful garden with swimming pool and jacuzzi. Kristy and Hendrik are very hospitable and nice. Very nice that you can park the car on your own property, a car is a must if you want to visit LA where everything is far apart today. We had a wonderful time here and will definitely choose Tropical oasis again in the future.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8257</th>\n",
       "      <td>19549802</td>\n",
       "      <td>536453477</td>\n",
       "      <td>2019-09-26</td>\n",
       "      <td>44098246</td>\n",
       "      <td>Fabian</td>\n",
       "      <td>Super Wohnung für LA. Es muss einen aber klar sein, dass ein Auto gebraucht wird, wie überall in LA. Von der Wohnung ist man bei allen Touristenattraktionen innerhalb von 30 min (ohne Stau). Die Kommunikation war sehr rudimentär aber hat ausgereicht. Ich kann die saubere Wohnung nur empfehlen.</td>\n",
       "      <td>de</td>\n",
       "      <td>Great apartment for LA. But it must be clear that a car is needed, like everywhere in LA. From the apartment you can reach all tourist attractions within 30 minutes (no traffic jams). The communication was very rudimentary but was sufficient. I can only recommend the clean apartment.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1819</th>\n",
       "      <td>20638964</td>\n",
       "      <td>695678378016241772</td>\n",
       "      <td>2022-08-17</td>\n",
       "      <td>159151109</td>\n",
       "      <td>Rebeca</td>\n",
       "      <td>Es un lugar muy lindo y acogedor!</td>\n",
       "      <td>es</td>\n",
       "      <td>It is a very nice and cozy place!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2892</th>\n",
       "      <td>21296775</td>\n",
       "      <td>573961912051444845</td>\n",
       "      <td>2022-03-02</td>\n",
       "      <td>38650342</td>\n",
       "      <td>Carlos</td>\n",
       "      <td>Best Airbnb ever!</td>\n",
       "      <td>de</td>\n",
       "      <td>Best Airbnb ever!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3057</th>\n",
       "      <td>40457964</td>\n",
       "      <td>657368892381950947</td>\n",
       "      <td>2022-06-25</td>\n",
       "      <td>215925789</td>\n",
       "      <td>Richard</td>\n",
       "      <td>非常干净整洁</td>\n",
       "      <td>ko</td>\n",
       "      <td>very clean and tidy</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>839</th>\n",
       "      <td>51200485</td>\n",
       "      <td>535596910813549554</td>\n",
       "      <td>2022-01-08</td>\n",
       "      <td>423350781</td>\n",
       "      <td>Fabiola</td>\n",
       "      <td>El lugar es tal y como en sus fotos, buena ubicación, espacioso.</td>\n",
       "      <td>es</td>\n",
       "      <td>The place is just like in its photos, good location, spacious.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2492</th>\n",
       "      <td>4637876</td>\n",
       "      <td>315028342</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>112480895</td>\n",
       "      <td>Zhana</td>\n",
       "      <td>very good</td>\n",
       "      <td>af</td>\n",
       "      <td>very good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3889</th>\n",
       "      <td>32651301</td>\n",
       "      <td>795719730868130463</td>\n",
       "      <td>2023-01-02</td>\n",
       "      <td>490234224</td>\n",
       "      <td>Hilda</td>\n",
       "      <td>Fue excelente el lugar  Y la atención es buena grasias</td>\n",
       "      <td>es</td>\n",
       "      <td>The place was excellent and the attention is good thanks</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8449</th>\n",
       "      <td>5895035</td>\n",
       "      <td>553271845</td>\n",
       "      <td>2019-10-23</td>\n",
       "      <td>192690860</td>\n",
       "      <td>Jiayi</td>\n",
       "      <td>5 stars</td>\n",
       "      <td>sv</td>\n",
       "      <td>5 stars</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8087</th>\n",
       "      <td>50150217</td>\n",
       "      <td>673300367517219920</td>\n",
       "      <td>2022-07-17</td>\n",
       "      <td>458333180</td>\n",
       "      <td>Octavio</td>\n",
       "      <td>Such a cute little place!</td>\n",
       "      <td>ro</td>\n",
       "      <td>Such a cute little place!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9982</th>\n",
       "      <td>32651301</td>\n",
       "      <td>535574810</td>\n",
       "      <td>2019-09-24</td>\n",
       "      <td>46079568</td>\n",
       "      <td>Yuhan</td>\n",
       "      <td>Beautiful house!</td>\n",
       "      <td>fr</td>\n",
       "      <td>Beautiful house!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6711</th>\n",
       "      <td>13265608</td>\n",
       "      <td>206105575</td>\n",
       "      <td>2017-10-23</td>\n",
       "      <td>70116025</td>\n",
       "      <td>Gabriel</td>\n",
       "      <td>Recomendo, o apartamento é excelente, o bairro é ótimo.</td>\n",
       "      <td>pt</td>\n",
       "      <td>I recommend, the apartment is excellent, the neighborhood is great.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3360</th>\n",
       "      <td>951044</td>\n",
       "      <td>79222605</td>\n",
       "      <td>2016-06-12</td>\n",
       "      <td>66177585</td>\n",
       "      <td>Elisa</td>\n",
       "      <td>Reb é molto gentile, friendly e disponibile. C'è una bella atmosfera familiare nella sua casa ed allo stesso tempo si può avere molta privacy. Lo Zen Den è super carino, molto pulito e confortevole. C'è tutto quello che può servire a chi viaggia, comprese adattatori per prese usb. La doccia perfetta! Il resto della casa ed il cortile a disposizione degli ospiti airbnb, la cucina super attrezzata e organizzata per gli ospiti.   La zona è tranquilla e molto comoda per raggiungere downtown, venice beach, aeroporto etc.   Ci siamo trovati molto bene, super consigliato!! ;)</td>\n",
       "      <td>it</td>\n",
       "      <td>Reb is very kind, friendly and helpful. There is a nice family atmosphere in her house and at the same time you can have a lot of privacy. The Zen Den is super cute, very clean and comfortable. There is everything a traveler may need, including adapters for USB sockets. The perfect shower! The rest of the house and the courtyard available to airbnb guests, the super-equipped and organized kitchen for guests. The area is quiet and very convenient for reaching downtown, venice beach, the airport, etc. We had a great time, super recommended!! ;)</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>959</th>\n",
       "      <td>9139954</td>\n",
       "      <td>261052800</td>\n",
       "      <td>2018-05-05</td>\n",
       "      <td>4917784</td>\n",
       "      <td>Mariana</td>\n",
       "      <td>O apartamento de Angelique é  exatamente como as fotos: bonito, espaçoso e bem cuidado. Perfeito para duas pessoas terem uma estadia confortável.  A vizinhança não é muito barulhenta e a localização e muito boa, principalmente se você pretende visitar venice, Santa monica  e downtown. Os hosts são muito atenciosos. Definitivamente me hospedaria novamente!</td>\n",
       "      <td>pt</td>\n",
       "      <td>Angelique's apartment is exactly like the pictures: beautiful, spacious and well maintained. Perfect for two people to have a comfortable stay. The neighborhood is not too noisy and the location is very good, especially if you plan to visit Venice, Santa Monica and downtown. Hosts are very attentive. I would definitely stay again!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8985</th>\n",
       "      <td>20541545</td>\n",
       "      <td>534468810</td>\n",
       "      <td>2019-09-22</td>\n",
       "      <td>127275549</td>\n",
       "      <td>Luli</td>\n",
       "      <td>El alojamiento esta ubicado en una zona perfecta para el turismo ya que llegas caminando a Walk of Fame sin problemas, tiene cochera privada, con lo cual si utilizas vehiculo es muy comodo. El departamento tiene lo justo para su utilidad y tiene mucha privacidad. Gracias Willie por tu amabilidad!</td>\n",
       "      <td>es</td>\n",
       "      <td>The accommodation is located in a perfect area for tourism since you can walk to Walk of Fame without problems, it has a private garage, so if you use a car it is very comfortable. The apartment has just enough for its utility and has a lot of privacy. Thanks Willie for your kindness!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>854</th>\n",
       "      <td>67089</td>\n",
       "      <td>176421977</td>\n",
       "      <td>2017-07-30</td>\n",
       "      <td>23315833</td>\n",
       "      <td>Hind</td>\n",
       "      <td>Logement bien équipé. L'appartement se trouve au fond du jardin à partager et est très calme. Très bien situé ; aussi  bien par rapport à la plage: Venice ou Santa Monica que part rapport à LA même. J'y retournerai sans hésiter</td>\n",
       "      <td>fr</td>\n",
       "      <td>Well equipped accommodation. The apartment is at the bottom of the shared garden and is very quiet. Great location; both in relation to the beach: Venice or Santa Monica as well as in relation to LA itself. I would go back without hesitation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8288</th>\n",
       "      <td>13001874</td>\n",
       "      <td>402824258</td>\n",
       "      <td>2019-01-19</td>\n",
       "      <td>34650666</td>\n",
       "      <td>Thomas</td>\n",
       "      <td>Très belle maison design, spacieuse et lumineuse. Très bon séjour !</td>\n",
       "      <td>fr</td>\n",
       "      <td>Very beautiful design house, spacious and bright. Very good stay!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8836</th>\n",
       "      <td>2494793</td>\n",
       "      <td>820466367442314736</td>\n",
       "      <td>2023-02-05</td>\n",
       "      <td>177188544</td>\n",
       "      <td>Shunsuke</td>\n",
       "      <td>短い間のステイでしたが、ロケーションもよく、Akikoさんが色々親切にしていただけたこともあり、快適に過ごせました！また来る機会があればここを利用したいと思いました！</td>\n",
       "      <td>ja</td>\n",
       "      <td>It was a short stay, but the location was good, and Akiko was kind to me in various ways, so I was able to spend a comfortable time! If there is an opportunity to come again, I would like to use this place!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7249</th>\n",
       "      <td>7308568</td>\n",
       "      <td>603106395</td>\n",
       "      <td>2020-02-08</td>\n",
       "      <td>315423353</td>\n",
       "      <td>Guilherme</td>\n",
       "      <td>Ótimo Lugar</td>\n",
       "      <td>lt</td>\n",
       "      <td>great place</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4774</th>\n",
       "      <td>934488</td>\n",
       "      <td>179545664</td>\n",
       "      <td>2017-08-07</td>\n",
       "      <td>59266363</td>\n",
       "      <td>Joerg</td>\n",
       "      <td>Das Studio von Lisa war genau das, was wir für unseren Aufenthalt in Venice gesucht hatten.  Das Rooftop ist wunderschön, mit Gasgrill.  Die Fahrräder sind genial, zum entdecken u Abends zu den Restaurants zu fahren.  Ausstattung, wie Küche u Waschmaschine sind top.  Gerne zum weiter empfehlen.  Danke Lisa</td>\n",
       "      <td>de</td>\n",
       "      <td>Lisa's studio was exactly what we were looking for for our stay in Venice. The rooftop is beautiful with a gas grill. The bikes are great for discovering and driving to the restaurants in the evening. Facilities such as kitchen and washing machine are great. Happy to recommend. Thank you Lisa</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>415</th>\n",
       "      <td>16897539</td>\n",
       "      <td>297977302</td>\n",
       "      <td>2018-07-28</td>\n",
       "      <td>35798285</td>\n",
       "      <td>Anaïs</td>\n",
       "      <td>Scott est très aimable et intéressant ! Il a su nous accueillir chaleureusement.  La maison est bien située, proche des transports pour se rendre près des bars etc.  La chambre est joliment décorée. En revanche, un petit coup de ménage aurait été appréciable dans la salle de bain.</td>\n",
       "      <td>fr</td>\n",
       "      <td>Scott is very personable and interesting! He knew how to welcome us warmly. The house is well located, close to transport to get to bars etc. The room is nicely decorated. On the other hand, a little cleaning would have been appreciated in the bathroom.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8966</th>\n",
       "      <td>43769430</td>\n",
       "      <td>402907854654762792</td>\n",
       "      <td>2021-07-09</td>\n",
       "      <td>44046872</td>\n",
       "      <td>仕偉</td>\n",
       "      <td>很棒的位子 有車庫 唯一廁所比較少 其他都很棒 設備齊全的！</td>\n",
       "      <td>ko</td>\n",
       "      <td>A great seat with a garage. The only toilet is relatively small. Everything else is great and well-equipped!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9836</th>\n",
       "      <td>797242428525831407</td>\n",
       "      <td>828347635743377860</td>\n",
       "      <td>2023-02-16</td>\n",
       "      <td>418125193</td>\n",
       "      <td>Nathalie</td>\n",
       "      <td>Dans l’ensemble notre séjour s’est bien passé , les instructions étaient clairs le quartier et l’emplacement idéal et ce que nous souhaitions , rien à redire sur l’hôte ou le logement satisfait de cette expérience</td>\n",
       "      <td>fr</td>\n",
       "      <td>Overall our stay went well, the instructions were clear the neighborhood and the ideal location and what we wanted, nothing to complain about the host or the accommodation satisfied with this experience</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6079</th>\n",
       "      <td>13296286</td>\n",
       "      <td>324775632</td>\n",
       "      <td>2018-09-17</td>\n",
       "      <td>212335508</td>\n",
       "      <td>Kasey</td>\n",
       "      <td>Nice clean apartment, convenient location.</td>\n",
       "      <td>fr</td>\n",
       "      <td>Nice clean apartment, convenient location.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7081</th>\n",
       "      <td>2558409</td>\n",
       "      <td>278786221</td>\n",
       "      <td>2018-06-18</td>\n",
       "      <td>15084268</td>\n",
       "      <td>Nina</td>\n",
       "      <td>Valeries Zuhause ist sehr schön und gepflegt. Die Nachbarschaft war sehr angenehm und ruhig aber dennoch sehr nah an Venice Beach (fußläufig in ca. 20 Minuten) und somit zentral gelegen. Das Zimmer war sehr schön und gemütlich eingerichtet, alles war sehr sauber und durchdacht. Valerie ist eine sehr offene und herzliche Gastgeberin, wir haben uns rundum wohl gefühlt. Wir können Valeries Unterkunft uneingeschränkt empfehlen.</td>\n",
       "      <td>de</td>\n",
       "      <td>Valerie's home is very beautiful and well maintained. The neighborhood was very pleasant and quiet, but still very close to Venice Beach (about a 20-minute walk) and therefore centrally located. The room was very nice and comfortably furnished, everything was very clean and well thought out. Valerie is a very open and warm hostess, we felt very comfortable. We can fully recommend Valerie's accommodation.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2601</th>\n",
       "      <td>239032</td>\n",
       "      <td>143412466</td>\n",
       "      <td>2017-04-11</td>\n",
       "      <td>389547</td>\n",
       "      <td>Nina</td>\n",
       "      <td>Nice place</td>\n",
       "      <td>ro</td>\n",
       "      <td>Nice place</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4734</th>\n",
       "      <td>663876</td>\n",
       "      <td>152323397</td>\n",
       "      <td>2017-05-15</td>\n",
       "      <td>49047144</td>\n",
       "      <td>Zhenye</td>\n",
       "      <td>房子在beverly hill，房间干净，整洁，周围环境安静漂亮，性价比高，附近有超市和饭店。</td>\n",
       "      <td>zh-cn</td>\n",
       "      <td>The house is in Beverly Hill. The room is clean and tidy. The surrounding environment is quiet and beautiful. The price is high. There are supermarkets and restaurants nearby.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>574</th>\n",
       "      <td>20494469</td>\n",
       "      <td>515312656</td>\n",
       "      <td>2019-08-22</td>\n",
       "      <td>267958089</td>\n",
       "      <td>Chunting</td>\n",
       "      <td>Very good</td>\n",
       "      <td>af</td>\n",
       "      <td>Very good</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>947</th>\n",
       "      <td>20585</td>\n",
       "      <td>3664776</td>\n",
       "      <td>2013-03-01</td>\n",
       "      <td>3099470</td>\n",
       "      <td>Ayelet</td>\n",
       "      <td>Beautiful place! Wonderful host</td>\n",
       "      <td>ro</td>\n",
       "      <td>Beautiful place! Wonderful host</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2399</th>\n",
       "      <td>19059291</td>\n",
       "      <td>414165432</td>\n",
       "      <td>2019-02-18</td>\n",
       "      <td>152344061</td>\n",
       "      <td>欢萍</td>\n",
       "      <td>Rina的房子出乎我们的预料，因为我们是在晚上10点左右才到达Rina的房子，Rina却及时回复了我们并解除了房子的警报，我们感到很安心。</td>\n",
       "      <td>zh-cn</td>\n",
       "      <td>Rina's house was beyond our expectations, because we arrived at Rina's house around 10pm, Rina responded to us in time and disarmed the house, we felt very relieved.</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>19568480</td>\n",
       "      <td>668155381</td>\n",
       "      <td>2020-09-26</td>\n",
       "      <td>256637806</td>\n",
       "      <td>Ivonne Alejandra</td>\n",
       "      <td>Fue una estancia muy agradable, la zona pareciera no tan bonita pero es muy tranquila y el alojamiento súper lindo, tal cual se muestra en las imágenes... al entrar, es un mundo aparte; Manuel y Lisa súper anfitriones y por supuesto que volveremos a hospedarnos aquí</td>\n",
       "      <td>es</td>\n",
       "      <td>It was a very pleasant stay, the area seems not so beautiful but it is very quiet and the accommodation is super cute, as shown in the images... upon entering, it is a world apart; Manuel and Lisa super hosts and of course we will stay here again</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9120</th>\n",
       "      <td>18754469</td>\n",
       "      <td>362151352</td>\n",
       "      <td>2018-12-25</td>\n",
       "      <td>21158294</td>\n",
       "      <td>Sunny</td>\n",
       "      <td>完美的洛杉矶住宿选择！位置超好，停车方便，兄妹俩经营着家里留下的大House，就是一个完美的家！各项设施齐全，早餐丰富，在有泳池的院子里惬意美好。虽然是合住，但完全独立不影响起居，还能和世界各地朋友聊天。房东友好，给我建议了几处餐厅酒吧，都是很棒的选择！我还回到洛杉矶，选择这里！也一定会推荐给朋友们。旅行结束了，但尤其想念LA居住的时光。祝你们幸福！</td>\n",
       "      <td>zh-cn</td>\n",
       "      <td>The perfect Los Angeles lodging choice! The location is super good, the parking is convenient, the brother and sister run the big house left by the family, it is a perfect home! The facilities are complete, the breakfast is rich, and the yard with the swimming pool is cozy and beautiful. Although they live together, they are completely independent without affecting their daily life, and they can also chat with friends from all over the world. The host is friendly and suggested several restaurants and bars to me, all of which are great choices! I'm still back in Los Angeles and choose here! Will definitely recommend to friends too. The trip is over, but I especially miss the time I lived in LA. I wish you happiness!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>22129896</td>\n",
       "      <td>555547163</td>\n",
       "      <td>2019-10-27</td>\n",
       "      <td>46778144</td>\n",
       "      <td>John C</td>\n",
       "      <td>Clean, comfortable and quiet!</td>\n",
       "      <td>fr</td>\n",
       "      <td>Clean, comfortable and quiet!</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8510</th>\n",
       "      <td>16252716</td>\n",
       "      <td>389091566200659462</td>\n",
       "      <td>2021-06-20</td>\n",
       "      <td>364751117</td>\n",
       "      <td>Michael</td>\n",
       "      <td>Great place for a great price</td>\n",
       "      <td>ro</td>\n",
       "      <td>Great place for a great price</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1777</th>\n",
       "      <td>662966348551612762</td>\n",
       "      <td>742798279746477968</td>\n",
       "      <td>2022-10-21</td>\n",
       "      <td>318256418</td>\n",
       "      <td>Whitney</td>\n",
       "      <td>Awesome stay and view</td>\n",
       "      <td>af</td>\n",
       "      <td>Awesome stay and view</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>955</th>\n",
       "      <td>7998050</td>\n",
       "      <td>464912712</td>\n",
       "      <td>2019-06-06</td>\n",
       "      <td>134299424</td>\n",
       "      <td>陈</td>\n",
       "      <td>有独立的出入口，街区也很安全，路边可以停车，虽然卫生间不在房间内，但是基本算独立使用</td>\n",
       "      <td>zh-cn</td>\n",
       "      <td>There are independent entrances and exits, and the neighborhood is very safe. Parking is available on the roadside. Although the bathroom is not in the room, it is basically used independently</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4312</th>\n",
       "      <td>41779962</td>\n",
       "      <td>704312708</td>\n",
       "      <td>2020-10-26</td>\n",
       "      <td>244765890</td>\n",
       "      <td>Sergio</td>\n",
       "      <td>Es un lugar muy acogedor arlene es una persona muy amable resuelve todas tus dudas, la habitación es muy cómoda y limpia, arlene se preocupa que llegues y te sientas muy cómodo como en tu casa volvería sin dudarlo</td>\n",
       "      <td>es</td>\n",
       "      <td>It is a very cozy place, Arlene is a very kind person, she answers all your questions, the room is very comfortable and clean, Arlene cares that you arrive and feel very comfortable at home. I would return without hesitation</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3882</th>\n",
       "      <td>3485758</td>\n",
       "      <td>478968899715334116</td>\n",
       "      <td>2021-10-22</td>\n",
       "      <td>89045846</td>\n",
       "      <td>Ethan</td>\n",
       "      <td>집도 깨끗하고, 소통도 원할하고 베니스비치와 정말 가까워요 최고의 숙박이었습니다 다시 머물고 싶은곳</td>\n",
       "      <td>ko</td>\n",
       "      <td>The house is clean, communication is easy, and it's really close to Venice Beach. It was the best stay. A place I want to stay again</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2140</th>\n",
       "      <td>16189358</td>\n",
       "      <td>686333065008960243</td>\n",
       "      <td>2022-08-04</td>\n",
       "      <td>444728281</td>\n",
       "      <td>Yeonho</td>\n",
       "      <td>Excelent</td>\n",
       "      <td>ca</td>\n",
       "      <td>Excellent</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "              listing_id                  id        date  reviewer_id   \n",
       "1613            17286928  714628498960591805  2022-09-12    131731765  \\\n",
       "2579            21325548           518505746  2019-08-26    107545149   \n",
       "185   735514791620448966  748682913084121476  2022-10-29    138745626   \n",
       "1646            33884448           736140288  2021-03-03    377548800   \n",
       "1223             7594667  431146387465330103  2021-08-17    222761444   \n",
       "4719            10454154           708071000  2020-11-10    134982534   \n",
       "7345            44408051  666717983943939945  2022-07-08    356565979   \n",
       "1789            52388463  758122387318333869  2022-11-11    146596188   \n",
       "4514            15974796           732182821  2021-02-17    387897800   \n",
       "3696              286866           508422199  2019-08-12    144422525   \n",
       "948             53871874  812481206767828471  2023-01-25     29480299   \n",
       "8217             6975613            78237840  2016-06-05     56034400   \n",
       "8257            19549802           536453477  2019-09-26     44098246   \n",
       "1819            20638964  695678378016241772  2022-08-17    159151109   \n",
       "2892            21296775  573961912051444845  2022-03-02     38650342   \n",
       "3057            40457964  657368892381950947  2022-06-25    215925789   \n",
       "839             51200485  535596910813549554  2022-01-08    423350781   \n",
       "2492             4637876           315028342  2018-08-27    112480895   \n",
       "3889            32651301  795719730868130463  2023-01-02    490234224   \n",
       "8449             5895035           553271845  2019-10-23    192690860   \n",
       "8087            50150217  673300367517219920  2022-07-17    458333180   \n",
       "9982            32651301           535574810  2019-09-24     46079568   \n",
       "6711            13265608           206105575  2017-10-23     70116025   \n",
       "3360              951044            79222605  2016-06-12     66177585   \n",
       "959              9139954           261052800  2018-05-05      4917784   \n",
       "8985            20541545           534468810  2019-09-22    127275549   \n",
       "854                67089           176421977  2017-07-30     23315833   \n",
       "8288            13001874           402824258  2019-01-19     34650666   \n",
       "8836             2494793  820466367442314736  2023-02-05    177188544   \n",
       "7249             7308568           603106395  2020-02-08    315423353   \n",
       "4774              934488           179545664  2017-08-07     59266363   \n",
       "415             16897539           297977302  2018-07-28     35798285   \n",
       "8966            43769430  402907854654762792  2021-07-09     44046872   \n",
       "9836  797242428525831407  828347635743377860  2023-02-16    418125193   \n",
       "6079            13296286           324775632  2018-09-17    212335508   \n",
       "7081             2558409           278786221  2018-06-18     15084268   \n",
       "2601              239032           143412466  2017-04-11       389547   \n",
       "4734              663876           152323397  2017-05-15     49047144   \n",
       "574             20494469           515312656  2019-08-22    267958089   \n",
       "947                20585             3664776  2013-03-01      3099470   \n",
       "2399            19059291           414165432  2019-02-18    152344061   \n",
       "12              19568480           668155381  2020-09-26    256637806   \n",
       "9120            18754469           362151352  2018-12-25     21158294   \n",
       "797             22129896           555547163  2019-10-27     46778144   \n",
       "8510            16252716  389091566200659462  2021-06-20    364751117   \n",
       "1777  662966348551612762  742798279746477968  2022-10-21    318256418   \n",
       "955              7998050           464912712  2019-06-06    134299424   \n",
       "4312            41779962           704312708  2020-10-26    244765890   \n",
       "3882             3485758  478968899715334116  2021-10-22     89045846   \n",
       "2140            16189358  686333065008960243  2022-08-04    444728281   \n",
       "\n",
       "         reviewer_name   \n",
       "1613           Moonhee  \\\n",
       "2579         Mahamadou   \n",
       "185             Daniel   \n",
       "1646            Jackie   \n",
       "1223          Yohannes   \n",
       "4719              Kris   \n",
       "7345             Nique   \n",
       "1789            Coline   \n",
       "4514           Sanford   \n",
       "3696           Candice   \n",
       "948                 슬아   \n",
       "8217            Muriel   \n",
       "8257            Fabian   \n",
       "1819            Rebeca   \n",
       "2892            Carlos   \n",
       "3057           Richard   \n",
       "839            Fabiola   \n",
       "2492             Zhana   \n",
       "3889             Hilda   \n",
       "8449             Jiayi   \n",
       "8087           Octavio   \n",
       "9982             Yuhan   \n",
       "6711           Gabriel   \n",
       "3360             Elisa   \n",
       "959            Mariana   \n",
       "8985              Luli   \n",
       "854               Hind   \n",
       "8288            Thomas   \n",
       "8836          Shunsuke   \n",
       "7249         Guilherme   \n",
       "4774             Joerg   \n",
       "415              Anaïs   \n",
       "8966                仕偉   \n",
       "9836          Nathalie   \n",
       "6079             Kasey   \n",
       "7081              Nina   \n",
       "2601              Nina   \n",
       "4734            Zhenye   \n",
       "574           Chunting   \n",
       "947             Ayelet   \n",
       "2399                欢萍   \n",
       "12    Ivonne Alejandra   \n",
       "9120             Sunny   \n",
       "797             John C   \n",
       "8510           Michael   \n",
       "1777           Whitney   \n",
       "955                  陈   \n",
       "4312            Sergio   \n",
       "3882             Ethan   \n",
       "2140            Yeonho   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             comments   \n",
       "1613                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              어웈 념뮤 펼룝옒요 청옹말 싫맗히얘욣 됸양꺄웟욞 쳘퉤류 카지맛요  와 너무 좋은 숙소입니다 la에서 잘쉬다가 갑니다.    \\\n",
       "2579                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Super appartement !   \n",
       "185                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Moderno departamento   \n",
       "1646                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          5 stars   \n",
       "1223                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  Beautiful place   \n",
       "4719                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Nice cozy spot   \n",
       "7345                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Nice place   \n",
       "1789                                                                                                                                                                                                                                                     Anita est une super hôte. Nous avons eu la chance d’avoir du réseau sur place et elle a été très réactive. Le lieu est magique. Nous avions un peu peur du froid de novembre mais les couettes chaudes et le chauffage nous ont permis de passer une bonne nuit. Tout est prévu sur place pour passer un bon moment (barbecue, jeu, brasero)   \n",
       "4514                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Decent   \n",
       "3696                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            房子两室有点小，房间设施那么新，卫生间很小很旧，洗澡的时候下水还是堵的。两个卫生间只有一个能洗浴，另一个没有洗澡设施。房子价格预定和后来的价格波动特别大，后来便宜很多～～   \n",
       "948                                                                                                                                                                                                                                                                                                                                                                 지하주차공간이 확보되어 안전하게 주차할 수 있었습니다. 체크인 안내도 정확하고 어렵지 않았습니다. 침구가 좋고 인테리어가 깔끔해요. 화장실이 2개라 유용하게 잘 썼습니다. 수건도 넉넉했구요. 와이파이도 문제 없이 사용했어요.  예약 전 에어비앤비 상으로 보이는 위치와 다릅니다만, 예약 후 바로 정확한 주소를 받았습니다. 그로브몰 및 홀푸드마켓과 인접해요.  큰 길가에 있어 치안 걱정 없이 이용했어요!   \n",
       "8217                                                                                                                 Tropical oasis is een absolute aanrader. Een grote slaapkamer, aparte eetkamer/keuken, heel schoon en een prachtige tuin met zwembad en jacuzzi. Kristy en Hendrik zijn zeer gastvrij en aardig.   Erg prettig dat je de auto op het eigen terrein kan parkeren, een auto is een must om te hebben als je LA wil bezichtigen waar alles ver van elkaar vandaag ligt. We hebben een hier een heerlijke tijd gehad en zullen in de toekomst zeker weer voor Tropical oasis kiezen.   \n",
       "8257                                                                                                                                                                                                                                                                                           Super Wohnung für LA. Es muss einen aber klar sein, dass ein Auto gebraucht wird, wie überall in LA. Von der Wohnung ist man bei allen Touristenattraktionen innerhalb von 30 min (ohne Stau). Die Kommunikation war sehr rudimentär aber hat ausgereicht. Ich kann die saubere Wohnung nur empfehlen.   \n",
       "1819                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Es un lugar muy lindo y acogedor!   \n",
       "2892                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Best Airbnb ever!   \n",
       "3057                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           非常干净整洁   \n",
       "839                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  El lugar es tal y como en sus fotos, buena ubicación, espacioso.   \n",
       "2492                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        very good   \n",
       "3889                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           Fue excelente el lugar  Y la atención es buena grasias   \n",
       "8449                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          5 stars   \n",
       "8087                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Such a cute little place!   \n",
       "9982                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Beautiful house!   \n",
       "6711                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Recomendo, o apartamento é excelente, o bairro é ótimo.    \n",
       "3360  Reb é molto gentile, friendly e disponibile. C'è una bella atmosfera familiare nella sua casa ed allo stesso tempo si può avere molta privacy. Lo Zen Den è super carino, molto pulito e confortevole. C'è tutto quello che può servire a chi viaggia, comprese adattatori per prese usb. La doccia perfetta! Il resto della casa ed il cortile a disposizione degli ospiti airbnb, la cucina super attrezzata e organizzata per gli ospiti.   La zona è tranquilla e molto comoda per raggiungere downtown, venice beach, aeroporto etc.   Ci siamo trovati molto bene, super consigliato!! ;)   \n",
       "959                                                                                                                                                                                                                             O apartamento de Angelique é  exatamente como as fotos: bonito, espaçoso e bem cuidado. Perfeito para duas pessoas terem uma estadia confortável.  A vizinhança não é muito barulhenta e a localização e muito boa, principalmente se você pretende visitar venice, Santa monica  e downtown. Os hosts são muito atenciosos. Definitivamente me hospedaria novamente!   \n",
       "8985                                                                                                                                                                                                                                                                                        El alojamiento esta ubicado en una zona perfecta para el turismo ya que llegas caminando a Walk of Fame sin problemas, tiene cochera privada, con lo cual si utilizas vehiculo es muy comodo. El departamento tiene lo justo para su utilidad y tiene mucha privacidad. Gracias Willie por tu amabilidad!   \n",
       "854                                                                                                                                                                                                                                                                                                                                                               Logement bien équipé. L'appartement se trouve au fond du jardin à partager et est très calme. Très bien situé ; aussi  bien par rapport à la plage: Venice ou Santa Monica que part rapport à LA même. J'y retournerai sans hésiter   \n",
       "8288                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Très belle maison design, spacieuse et lumineuse. Très bon séjour !   \n",
       "8836                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              短い間のステイでしたが、ロケーションもよく、Akikoさんが色々親切にしていただけたこともあり、快適に過ごせました！また来る機会があればここを利用したいと思いました！   \n",
       "7249                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Ótimo Lugar   \n",
       "4774                                                                                                                                                                                                                                                                              Das Studio von Lisa war genau das, was wir für unseren Aufenthalt in Venice gesucht hatten.  Das Rooftop ist wunderschön, mit Gasgrill.  Die Fahrräder sind genial, zum entdecken u Abends zu den Restaurants zu fahren.  Ausstattung, wie Küche u Waschmaschine sind top.  Gerne zum weiter empfehlen.  Danke Lisa   \n",
       "415                                                                                                                                                                                                                                                                                                        Scott est très aimable et intéressant ! Il a su nous accueillir chaleureusement.  La maison est bien située, proche des transports pour se rendre près des bars etc.  La chambre est joliment décorée. En revanche, un petit coup de ménage aurait été appréciable dans la salle de bain.    \n",
       "8966                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   很棒的位子 有車庫 唯一廁所比較少 其他都很棒 設備齊全的！   \n",
       "9836                                                                                                                                                                                                                                                                                                                                                                            Dans l’ensemble notre séjour s’est bien passé , les instructions étaient clairs le quartier et l’emplacement idéal et ce que nous souhaitions , rien à redire sur l’hôte ou le logement satisfait de cette expérience   \n",
       "6079                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Nice clean apartment, convenient location.   \n",
       "7081                                                                                                                                                      Valeries Zuhause ist sehr schön und gepflegt. Die Nachbarschaft war sehr angenehm und ruhig aber dennoch sehr nah an Venice Beach (fußläufig in ca. 20 Minuten) und somit zentral gelegen. Das Zimmer war sehr schön und gemütlich eingerichtet, alles war sehr sauber und durchdacht. Valerie ist eine sehr offene und herzliche Gastgeberin, wir haben uns rundum wohl gefühlt. Wir können Valeries Unterkunft uneingeschränkt empfehlen.   \n",
       "2601                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Nice place    \n",
       "4734                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  房子在beverly hill，房间干净，整洁，周围环境安静漂亮，性价比高，附近有超市和饭店。   \n",
       "574                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Very good   \n",
       "947                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   Beautiful place! Wonderful host   \n",
       "2399                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Rina的房子出乎我们的预料，因为我们是在晚上10点左右才到达Rina的房子，Rina却及时回复了我们并解除了房子的警报，我们感到很安心。   \n",
       "12                                                                                                                                                                                                                                                                                                                        Fue una estancia muy agradable, la zona pareciera no tan bonita pero es muy tranquila y el alojamiento súper lindo, tal cual se muestra en las imágenes... al entrar, es un mundo aparte; Manuel y Lisa súper anfitriones y por supuesto que volveremos a hospedarnos aquí    \n",
       "9120                                                                                                                                                                                                                                                                                                                                                                                                                 完美的洛杉矶住宿选择！位置超好，停车方便，兄妹俩经营着家里留下的大House，就是一个完美的家！各项设施齐全，早餐丰富，在有泳池的院子里惬意美好。虽然是合住，但完全独立不影响起居，还能和世界各地朋友聊天。房东友好，给我建议了几处餐厅酒吧，都是很棒的选择！我还回到洛杉矶，选择这里！也一定会推荐给朋友们。旅行结束了，但尤其想念LA居住的时光。祝你们幸福！   \n",
       "797                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Clean, comfortable and quiet!   \n",
       "8510                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    Great place for a great price   \n",
       "1777                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Awesome stay and view   \n",
       "955                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        有独立的出入口，街区也很安全，路边可以停车，虽然卫生间不在房间内，但是基本算独立使用   \n",
       "4312                                                                                                                                                                                                                                                                                                                                                                            Es un lugar muy acogedor arlene es una persona muy amable resuelve todas tus dudas, la habitación es muy cómoda y limpia, arlene se preocupa que llegues y te sientas muy cómodo como en tu casa volvería sin dudarlo   \n",
       "3882                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          집도 깨끗하고, 소통도 원할하고 베니스비치와 정말 가까워요 최고의 숙박이었습니다 다시 머물고 싶은곳   \n",
       "2140                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Excelent   \n",
       "\n",
       "     language   \n",
       "1613       ko  \\\n",
       "2579       fr   \n",
       "185        pt   \n",
       "1646       sv   \n",
       "1223       ro   \n",
       "4719       pl   \n",
       "7345       ro   \n",
       "1789       fr   \n",
       "4514       nl   \n",
       "3696    zh-cn   \n",
       "948        ko   \n",
       "8217       nl   \n",
       "8257       de   \n",
       "1819       es   \n",
       "2892       de   \n",
       "3057       ko   \n",
       "839        es   \n",
       "2492       af   \n",
       "3889       es   \n",
       "8449       sv   \n",
       "8087       ro   \n",
       "9982       fr   \n",
       "6711       pt   \n",
       "3360       it   \n",
       "959        pt   \n",
       "8985       es   \n",
       "854        fr   \n",
       "8288       fr   \n",
       "8836       ja   \n",
       "7249       lt   \n",
       "4774       de   \n",
       "415        fr   \n",
       "8966       ko   \n",
       "9836       fr   \n",
       "6079       fr   \n",
       "7081       de   \n",
       "2601       ro   \n",
       "4734    zh-cn   \n",
       "574        af   \n",
       "947        ro   \n",
       "2399    zh-cn   \n",
       "12         es   \n",
       "9120    zh-cn   \n",
       "797        fr   \n",
       "8510       ro   \n",
       "1777       af   \n",
       "955     zh-cn   \n",
       "4312       es   \n",
       "3882       ko   \n",
       "2140       ca   \n",
       "\n",
       "                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 comments2  \n",
       "1613                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Wow, I didn't like it, I didn't like it, I didn't like it.  \n",
       "2579                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Great apartment!  \n",
       "185                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       modern apartment  \n",
       "1646                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               5 stars  \n",
       "1223                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       Beautiful place  \n",
       "4719                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Nice cozy spot  \n",
       "7345                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Nice place  \n",
       "1789                                                                                                                                                                                                                                                                                                                                                                                                                             Anita is a great host. We were lucky to have a network on site and she was very responsive. The place is magical. We were a little afraid of the November cold, but the warm duvets and the heating allowed us to have a good night's sleep. Everything is provided on site to have a good time (barbecue, game, brazier)  \n",
       "4514                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                Decent  \n",
       "3696                                                                                                                                                                                                                                                                                                                                                                   The two rooms of the house are a bit small, the room facilities are so new, the bathroom is very small and old, and the water is still blocked when taking a shower. Only one of the two bathrooms can take a bath, and the other has no bathing facilities. The house price reservation and subsequent price fluctuations were particularly large, and it was much cheaper later~~  \n",
       "948                                                                                                                                                                                                         Underground parking space was secured, so we were able to park safely. Check-in information was accurate and not difficult. The bedding is good and the interior is tidy. There are 2 bathrooms, so I put them to good use. There were also plenty of towels. I also used wifi without any problems. It's different from the location shown on Airbnb before booking, but I received the correct address right after booking. Close to Grove Mall and Whole Foods Market. It's on the main road, so I used it without worrying about security!  \n",
       "8217                                                                                                                                                                                                                                                                                                            Tropical oasis is an absolute must. A large bedroom, separate dining room / kitchen, very clean and a beautiful garden with swimming pool and jacuzzi. Kristy and Hendrik are very hospitable and nice. Very nice that you can park the car on your own property, a car is a must if you want to visit LA where everything is far apart today. We had a wonderful time here and will definitely choose Tropical oasis again in the future.  \n",
       "8257                                                                                                                                                                                                                                                                                                                                                                                                                                                          Great apartment for LA. But it must be clear that a car is needed, like everywhere in LA. From the apartment you can reach all tourist attractions within 30 minutes (no traffic jams). The communication was very rudimentary but was sufficient. I can only recommend the clean apartment.  \n",
       "1819                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     It is a very nice and cozy place!  \n",
       "2892                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Best Airbnb ever!  \n",
       "3057                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   very clean and tidy  \n",
       "839                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         The place is just like in its photos, good location, spacious.  \n",
       "2492                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             very good  \n",
       "3889                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              The place was excellent and the attention is good thanks  \n",
       "8449                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               5 stars  \n",
       "8087                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Such a cute little place!  \n",
       "9982                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Beautiful house!  \n",
       "6711                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   I recommend, the apartment is excellent, the neighborhood is great.  \n",
       "3360                                                                                                                                                                                  Reb is very kind, friendly and helpful. There is a nice family atmosphere in her house and at the same time you can have a lot of privacy. The Zen Den is super cute, very clean and comfortable. There is everything a traveler may need, including adapters for USB sockets. The perfect shower! The rest of the house and the courtyard available to airbnb guests, the super-equipped and organized kitchen for guests. The area is quiet and very convenient for reaching downtown, venice beach, the airport, etc. We had a great time, super recommended!! ;)  \n",
       "959                                                                                                                                                                                                                                                                                                                                                                                                           Angelique's apartment is exactly like the pictures: beautiful, spacious and well maintained. Perfect for two people to have a comfortable stay. The neighborhood is not too noisy and the location is very good, especially if you plan to visit Venice, Santa Monica and downtown. Hosts are very attentive. I would definitely stay again!  \n",
       "8985                                                                                                                                                                                                                                                                                                                                                                                                                                                         The accommodation is located in a perfect area for tourism since you can walk to Walk of Fame without problems, it has a private garage, so if you use a car it is very comfortable. The apartment has just enough for its utility and has a lot of privacy. Thanks Willie for your kindness!  \n",
       "854                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      Well equipped accommodation. The apartment is at the bottom of the shared garden and is very quiet. Great location; both in relation to the beach: Venice or Santa Monica as well as in relation to LA itself. I would go back without hesitation  \n",
       "8288                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                     Very beautiful design house, spacious and bright. Very good stay!  \n",
       "8836                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        It was a short stay, but the location was good, and Akiko was kind to me in various ways, so I was able to spend a comfortable time! If there is an opportunity to come again, I would like to use this place!  \n",
       "7249                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           great place  \n",
       "4774                                                                                                                                                                                                                                                                                                                                                                                                                                                 Lisa's studio was exactly what we were looking for for our stay in Venice. The rooftop is beautiful with a gas grill. The bikes are great for discovering and driving to the restaurants in the evening. Facilities such as kitchen and washing machine are great. Happy to recommend. Thank you Lisa  \n",
       "415                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Scott is very personable and interesting! He knew how to welcome us warmly. The house is well located, close to transport to get to bars etc. The room is nicely decorated. On the other hand, a little cleaning would have been appreciated in the bathroom.  \n",
       "8966                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          A great seat with a garage. The only toilet is relatively small. Everything else is great and well-equipped!  \n",
       "9836                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Overall our stay went well, the instructions were clear the neighborhood and the ideal location and what we wanted, nothing to complain about the host or the accommodation satisfied with this experience  \n",
       "6079                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Nice clean apartment, convenient location.  \n",
       "7081                                                                                                                                                                                                                                                                                                                               Valerie's home is very beautiful and well maintained. The neighborhood was very pleasant and quiet, but still very close to Venice Beach (about a 20-minute walk) and therefore centrally located. The room was very nice and comfortably furnished, everything was very clean and well thought out. Valerie is a very open and warm hostess, we felt very comfortable. We can fully recommend Valerie's accommodation.  \n",
       "2601                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            Nice place  \n",
       "4734                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       The house is in Beverly Hill. The room is clean and tidy. The surrounding environment is quiet and beautiful. The price is high. There are supermarkets and restaurants nearby.  \n",
       "574                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                              Very good  \n",
       "947                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        Beautiful place! Wonderful host  \n",
       "2399                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Rina's house was beyond our expectations, because we arrived at Rina's house around 10pm, Rina responded to us in time and disarmed the house, we felt very relieved.  \n",
       "12                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  It was a very pleasant stay, the area seems not so beautiful but it is very quiet and the accommodation is super cute, as shown in the images... upon entering, it is a world apart; Manuel and Lisa super hosts and of course we will stay here again  \n",
       "9120  The perfect Los Angeles lodging choice! The location is super good, the parking is convenient, the brother and sister run the big house left by the family, it is a perfect home! The facilities are complete, the breakfast is rich, and the yard with the swimming pool is cozy and beautiful. Although they live together, they are completely independent without affecting their daily life, and they can also chat with friends from all over the world. The host is friendly and suggested several restaurants and bars to me, all of which are great choices! I'm still back in Los Angeles and choose here! Will definitely recommend to friends too. The trip is over, but I especially miss the time I lived in LA. I wish you happiness!  \n",
       "797                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          Clean, comfortable and quiet!  \n",
       "8510                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         Great place for a great price  \n",
       "1777                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                 Awesome stay and view  \n",
       "955                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                       There are independent entrances and exits, and the neighborhood is very safe. Parking is available on the roadside. Although the bathroom is not in the room, it is basically used independently  \n",
       "4312                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                      It is a very cozy place, Arlene is a very kind person, she answers all your questions, the room is very comfortable and clean, Arlene cares that you arrive and feel very comfortable at home. I would return without hesitation  \n",
       "3882                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  The house is clean, communication is easy, and it's really close to Venice Beach. It was the best stay. A place I want to stay again  \n",
       "2140                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                             Excellent  "
      ]
     },
     "execution_count": 122,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "non_en_df2.sample(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 126,
   "id": "55690853",
   "metadata": {},
   "outputs": [],
   "source": [
    "# Test with big dataset now\n",
    "#non_en_df['comments2'] = non_en_df['comments'].apply(lambda x: translate_to_english(x))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 127,
   "id": "db632e55",
   "metadata": {},
   "outputs": [],
   "source": [
    "#non_en_df.sample(50)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "6349ece9",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3 (ipykernel)",
   "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.9.7"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}