AmazonProductReviewsScrapping.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [],
   "source": [
    "from lxml import html\n",
    "from json import dump,loads\n",
    "from requests import get\n",
    "import json\n",
    "from re import sub\n",
    "from dateutil import parser as dateparser\n",
    "from time import sleep\n",
    "from lxml import html  \n",
    "import requests\n",
    "from pprint import pprint\n",
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Put product page reviews link in \"amazon_rev_url\""
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=1\n"
     ]
    }
   ],
   "source": [
    "amazon_rev_url = \"https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=1\"#+str(page_num)\n",
    "user_agent = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36'\n",
    "print(amazon_rev_url)\n",
    "headers = {'User-Agent': user_agent}\n",
    "page = requests.get(amazon_rev_url, headers = headers)\n",
    "parser = html.fromstring(page.content)\n",
    "xpath_reviews = '//div[@data-hook=\"review\"]'\n",
    "reviews = parser.xpath(xpath_reviews)\n",
    "xpath_rating  = './/i[@data-hook=\"review-star-rating\"]//text()' \n",
    "xpath_title   = './/a[@data-hook=\"review-title\"]//text()'\n",
    "xpath_author  = './/a[@data-hook=\"review-author\"]//text()'\n",
    "xpath_date    = './/span[@data-hook=\"review-date\"]//text()'\n",
    "xpath_body    = './/span[@data-hook=\"review-body\"]//text()'\n",
    "# xpath_helpful = './/span[@data-hook=\"helpful-vote-statement\"]//text()'\n",
    "xpath_total_reviews = './/span[@data-hook=\"total-review-count\"]//text()'\n",
    "xpath_verified = './/span[@data-hook=\"avp-badge\"]//text()'\n",
    "xpath_helpful_votes = './/span[@data-hook=\"helpful-vote-statement\"]//text()'"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "Total_Pages:  114\n"
     ]
    }
   ],
   "source": [
    "total_reviews = int(parser.xpath(xpath_total_reviews)[0].replace(\",\",\"\"))\n",
    "total_pages = total_reviews//10\n",
    "print(\"Total_Pages: \", total_pages)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=1\n",
      "\n",
      "----------0---------\n",
      "\n",
      "----------1---------\n",
      "\n",
      "----------2---------\n",
      "\n",
      "----------3---------\n",
      "\n",
      "----------4---------\n",
      "\n",
      "----------5---------\n",
      "\n",
      "----------6---------\n",
      "\n",
      "----------7---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=2\n",
      "\n",
      "----------8---------\n",
      "\n",
      "----------9---------\n",
      "\n",
      "----------10---------\n",
      "\n",
      "----------11---------\n",
      "\n",
      "----------12---------\n",
      "\n",
      "----------13---------\n",
      "\n",
      "----------14---------\n",
      "\n",
      "----------15---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=3\n",
      "\n",
      "----------16---------\n",
      "\n",
      "----------17---------\n",
      "\n",
      "----------18---------\n",
      "\n",
      "----------19---------\n",
      "\n",
      "----------20---------\n",
      "\n",
      "----------21---------\n",
      "\n",
      "----------22---------\n",
      "\n",
      "----------23---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=4\n",
      "\n",
      "----------24---------\n",
      "\n",
      "----------25---------\n",
      "\n",
      "----------26---------\n",
      "\n",
      "----------27---------\n",
      "\n",
      "----------28---------\n",
      "\n",
      "----------29---------\n",
      "\n",
      "----------30---------\n",
      "\n",
      "----------31---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=5\n",
      "\n",
      "----------32---------\n",
      "\n",
      "----------33---------\n",
      "\n",
      "----------34---------\n",
      "\n",
      "----------35---------\n",
      "\n",
      "----------36---------\n",
      "\n",
      "----------37---------\n",
      "\n",
      "----------38---------\n",
      "\n",
      "----------39---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=6\n",
      "\n",
      "----------40---------\n",
      "\n",
      "----------41---------\n",
      "\n",
      "----------42---------\n",
      "\n",
      "----------43---------\n",
      "\n",
      "----------44---------\n",
      "\n",
      "----------45---------\n",
      "\n",
      "----------46---------\n",
      "\n",
      "----------47---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=7\n",
      "\n",
      "----------48---------\n",
      "\n",
      "----------49---------\n",
      "\n",
      "----------50---------\n",
      "\n",
      "----------51---------\n",
      "\n",
      "----------52---------\n",
      "\n",
      "----------53---------\n",
      "\n",
      "----------54---------\n",
      "\n",
      "----------55---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=8\n",
      "\n",
      "----------56---------\n",
      "\n",
      "----------57---------\n",
      "\n",
      "----------58---------\n",
      "\n",
      "----------59---------\n",
      "\n",
      "----------60---------\n",
      "\n",
      "----------61---------\n",
      "\n",
      "----------62---------\n",
      "\n",
      "----------63---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=9\n",
      "\n",
      "----------64---------\n",
      "\n",
      "----------65---------\n",
      "\n",
      "----------66---------\n",
      "\n",
      "----------67---------\n",
      "\n",
      "----------68---------\n",
      "\n",
      "----------69---------\n",
      "\n",
      "----------70---------\n",
      "\n",
      "----------71---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=10\n",
      "\n",
      "----------72---------\n",
      "\n",
      "----------73---------\n",
      "\n",
      "----------74---------\n",
      "\n",
      "----------75---------\n",
      "\n",
      "----------76---------\n",
      "\n",
      "----------77---------\n",
      "\n",
      "----------78---------\n",
      "\n",
      "----------79---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=11\n",
      "\n",
      "----------80---------\n",
      "\n",
      "----------81---------\n",
      "\n",
      "----------82---------\n",
      "\n",
      "----------83---------\n",
      "\n",
      "----------84---------\n",
      "\n",
      "----------85---------\n",
      "\n",
      "----------86---------\n",
      "\n",
      "----------87---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=12\n",
      "\n",
      "----------88---------\n",
      "\n",
      "----------89---------\n",
      "\n",
      "----------90---------\n",
      "\n",
      "----------91---------\n",
      "\n",
      "----------92---------\n",
      "\n",
      "----------93---------\n",
      "\n",
      "----------94---------\n",
      "\n",
      "----------95---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=13\n",
      "\n",
      "----------96---------\n",
      "\n",
      "----------97---------\n",
      "\n",
      "----------98---------\n",
      "\n",
      "----------99---------\n",
      "\n",
      "----------100---------\n",
      "\n",
      "----------101---------\n",
      "\n",
      "----------102---------\n",
      "\n",
      "----------103---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=14\n",
      "\n",
      "----------104---------\n",
      "\n",
      "----------105---------\n",
      "\n",
      "----------106---------\n",
      "\n",
      "----------107---------\n",
      "\n",
      "----------108---------\n",
      "\n",
      "----------109---------\n",
      "\n",
      "----------110---------\n",
      "\n",
      "----------111---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=15\n",
      "\n",
      "----------112---------\n",
      "\n",
      "----------113---------\n",
      "\n",
      "----------114---------\n",
      "\n",
      "----------115---------\n",
      "\n",
      "----------116---------\n",
      "\n",
      "----------117---------\n",
      "\n",
      "----------118---------\n",
      "\n",
      "----------119---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=16\n",
      "\n",
      "----------120---------\n",
      "\n",
      "----------121---------\n",
      "\n",
      "----------122---------\n",
      "\n",
      "----------123---------\n",
      "\n",
      "----------124---------\n",
      "\n",
      "----------125---------\n",
      "\n",
      "----------126---------\n",
      "\n",
      "----------127---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=17\n",
      "\n",
      "----------128---------\n",
      "\n",
      "----------129---------\n",
      "\n",
      "----------130---------\n",
      "\n",
      "----------131---------\n",
      "\n",
      "----------132---------\n",
      "\n",
      "----------133---------\n",
      "\n",
      "----------134---------\n",
      "\n",
      "----------135---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=18\n",
      "\n",
      "----------136---------\n",
      "\n",
      "----------137---------\n",
      "\n",
      "----------138---------\n",
      "\n",
      "----------139---------\n",
      "\n",
      "----------140---------\n",
      "\n",
      "----------141---------\n",
      "\n",
      "----------142---------\n",
      "\n",
      "----------143---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=19\n",
      "\n",
      "----------144---------\n",
      "\n",
      "----------145---------\n",
      "\n",
      "----------146---------\n",
      "\n",
      "----------147---------\n",
      "\n",
      "----------148---------\n",
      "\n",
      "----------149---------\n",
      "\n",
      "----------150---------\n",
      "\n",
      "----------151---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=20\n",
      "\n",
      "----------152---------\n",
      "\n",
      "----------153---------\n",
      "\n",
      "----------154---------\n",
      "\n",
      "----------155---------\n",
      "\n",
      "----------156---------\n",
      "\n",
      "----------157---------\n",
      "\n",
      "----------158---------\n",
      "\n",
      "----------159---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=21\n",
      "\n",
      "----------160---------\n",
      "\n",
      "----------161---------\n",
      "\n",
      "----------162---------\n",
      "\n",
      "----------163---------\n",
      "\n",
      "----------164---------\n",
      "\n",
      "----------165---------\n",
      "\n",
      "----------166---------\n",
      "\n",
      "----------167---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=22\n",
      "\n",
      "----------168---------\n",
      "\n",
      "----------169---------\n",
      "\n",
      "----------170---------\n",
      "\n",
      "----------171---------\n",
      "\n",
      "----------172---------\n",
      "\n",
      "----------173---------\n",
      "\n",
      "----------174---------\n",
      "\n",
      "----------175---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=23\n",
      "\n",
      "----------176---------\n",
      "\n",
      "----------177---------\n",
      "\n",
      "----------178---------\n",
      "\n",
      "----------179---------\n",
      "\n",
      "----------180---------\n",
      "\n",
      "----------181---------\n",
      "\n",
      "----------182---------\n",
      "\n",
      "----------183---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=24\n",
      "\n",
      "----------184---------\n",
      "\n",
      "----------185---------\n",
      "\n",
      "----------186---------\n",
      "\n",
      "----------187---------\n",
      "\n",
      "----------188---------\n",
      "\n",
      "----------189---------\n",
      "\n",
      "----------190---------\n",
      "\n",
      "----------191---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=25\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----------192---------\n",
      "\n",
      "----------193---------\n",
      "\n",
      "----------194---------\n",
      "\n",
      "----------195---------\n",
      "\n",
      "----------196---------\n",
      "\n",
      "----------197---------\n",
      "\n",
      "----------198---------\n",
      "\n",
      "----------199---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=26\n",
      "\n",
      "----------200---------\n",
      "\n",
      "----------201---------\n",
      "\n",
      "----------202---------\n",
      "\n",
      "----------203---------\n",
      "\n",
      "----------204---------\n",
      "\n",
      "----------205---------\n",
      "\n",
      "----------206---------\n",
      "\n",
      "----------207---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=27\n",
      "\n",
      "----------208---------\n",
      "\n",
      "----------209---------\n",
      "\n",
      "----------210---------\n",
      "\n",
      "----------211---------\n",
      "\n",
      "----------212---------\n",
      "\n",
      "----------213---------\n",
      "\n",
      "----------214---------\n",
      "\n",
      "----------215---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=28\n",
      "\n",
      "----------216---------\n",
      "\n",
      "----------217---------\n",
      "\n",
      "----------218---------\n",
      "\n",
      "----------219---------\n",
      "\n",
      "----------220---------\n",
      "\n",
      "----------221---------\n",
      "\n",
      "----------222---------\n",
      "\n",
      "----------223---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=29\n",
      "\n",
      "----------224---------\n",
      "\n",
      "----------225---------\n",
      "\n",
      "----------226---------\n",
      "\n",
      "----------227---------\n",
      "\n",
      "----------228---------\n",
      "\n",
      "----------229---------\n",
      "\n",
      "----------230---------\n",
      "\n",
      "----------231---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=30\n",
      "\n",
      "----------232---------\n",
      "\n",
      "----------233---------\n",
      "\n",
      "----------234---------\n",
      "\n",
      "----------235---------\n",
      "\n",
      "----------236---------\n",
      "\n",
      "----------237---------\n",
      "\n",
      "----------238---------\n",
      "\n",
      "----------239---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=31\n",
      "\n",
      "----------240---------\n",
      "\n",
      "----------241---------\n",
      "\n",
      "----------242---------\n",
      "\n",
      "----------243---------\n",
      "\n",
      "----------244---------\n",
      "\n",
      "----------245---------\n",
      "\n",
      "----------246---------\n",
      "\n",
      "----------247---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=32\n",
      "\n",
      "----------248---------\n",
      "\n",
      "----------249---------\n",
      "\n",
      "----------250---------\n",
      "\n",
      "----------251---------\n",
      "\n",
      "----------252---------\n",
      "\n",
      "----------253---------\n",
      "\n",
      "----------254---------\n",
      "\n",
      "----------255---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=33\n",
      "\n",
      "----------256---------\n",
      "\n",
      "----------257---------\n",
      "\n",
      "----------258---------\n",
      "\n",
      "----------259---------\n",
      "\n",
      "----------260---------\n",
      "\n",
      "----------261---------\n",
      "\n",
      "----------262---------\n",
      "\n",
      "----------263---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=34\n",
      "\n",
      "----------264---------\n",
      "\n",
      "----------265---------\n",
      "\n",
      "----------266---------\n",
      "\n",
      "----------267---------\n",
      "\n",
      "----------268---------\n",
      "\n",
      "----------269---------\n",
      "\n",
      "----------270---------\n",
      "\n",
      "----------271---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=35\n",
      "\n",
      "----------272---------\n",
      "\n",
      "----------273---------\n",
      "\n",
      "----------274---------\n",
      "\n",
      "----------275---------\n",
      "\n",
      "----------276---------\n",
      "\n",
      "----------277---------\n",
      "\n",
      "----------278---------\n",
      "\n",
      "----------279---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=36\n",
      "\n",
      "----------280---------\n",
      "\n",
      "----------281---------\n",
      "\n",
      "----------282---------\n",
      "\n",
      "----------283---------\n",
      "\n",
      "----------284---------\n",
      "\n",
      "----------285---------\n",
      "\n",
      "----------286---------\n",
      "\n",
      "----------287---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=37\n",
      "\n",
      "----------288---------\n",
      "\n",
      "----------289---------\n",
      "\n",
      "----------290---------\n",
      "\n",
      "----------291---------\n",
      "\n",
      "----------292---------\n",
      "\n",
      "----------293---------\n",
      "\n",
      "----------294---------\n",
      "\n",
      "----------295---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=38\n",
      "\n",
      "----------296---------\n",
      "\n",
      "----------297---------\n",
      "\n",
      "----------298---------\n",
      "\n",
      "----------299---------\n",
      "\n",
      "----------300---------\n",
      "\n",
      "----------301---------\n",
      "\n",
      "----------302---------\n",
      "\n",
      "----------303---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=39\n",
      "\n",
      "----------304---------\n",
      "\n",
      "----------305---------\n",
      "\n",
      "----------306---------\n",
      "\n",
      "----------307---------\n",
      "\n",
      "----------308---------\n",
      "\n",
      "----------309---------\n",
      "\n",
      "----------310---------\n",
      "\n",
      "----------311---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=40\n",
      "\n",
      "----------312---------\n",
      "\n",
      "----------313---------\n",
      "\n",
      "----------314---------\n",
      "\n",
      "----------315---------\n",
      "\n",
      "----------316---------\n",
      "\n",
      "----------317---------\n",
      "\n",
      "----------318---------\n",
      "\n",
      "----------319---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=41\n",
      "\n",
      "----------320---------\n",
      "\n",
      "----------321---------\n",
      "\n",
      "----------322---------\n",
      "\n",
      "----------323---------\n",
      "\n",
      "----------324---------\n",
      "\n",
      "----------325---------\n",
      "\n",
      "----------326---------\n",
      "\n",
      "----------327---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=42\n",
      "\n",
      "----------328---------\n",
      "\n",
      "----------329---------\n",
      "\n",
      "----------330---------\n",
      "\n",
      "----------331---------\n",
      "\n",
      "----------332---------\n",
      "\n",
      "----------333---------\n",
      "\n",
      "----------334---------\n",
      "\n",
      "----------335---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=43\n",
      "\n",
      "----------336---------\n",
      "\n",
      "----------337---------\n",
      "\n",
      "----------338---------\n",
      "\n",
      "----------339---------\n",
      "\n",
      "----------340---------\n",
      "\n",
      "----------341---------\n",
      "\n",
      "----------342---------\n",
      "\n",
      "----------343---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=44\n",
      "\n",
      "----------344---------\n",
      "\n",
      "----------345---------\n",
      "\n",
      "----------346---------\n",
      "\n",
      "----------347---------\n",
      "\n",
      "----------348---------\n",
      "\n",
      "----------349---------\n",
      "\n",
      "----------350---------\n",
      "\n",
      "----------351---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=45\n",
      "\n",
      "----------352---------\n",
      "\n",
      "----------353---------\n",
      "\n",
      "----------354---------\n",
      "\n",
      "----------355---------\n",
      "\n",
      "----------356---------\n",
      "\n",
      "----------357---------\n",
      "\n",
      "----------358---------\n",
      "\n",
      "----------359---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=46\n",
      "\n",
      "----------360---------\n",
      "\n",
      "----------361---------\n",
      "\n",
      "----------362---------\n",
      "\n",
      "----------363---------\n",
      "\n",
      "----------364---------\n",
      "\n",
      "----------365---------\n",
      "\n",
      "----------366---------\n",
      "\n",
      "----------367---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=47\n",
      "\n",
      "----------368---------\n",
      "\n",
      "----------369---------\n",
      "\n",
      "----------370---------\n",
      "\n",
      "----------371---------\n",
      "\n",
      "----------372---------\n",
      "\n",
      "----------373---------\n",
      "\n",
      "----------374---------\n",
      "\n",
      "----------375---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=48\n",
      "\n",
      "----------376---------\n",
      "\n",
      "----------377---------\n",
      "\n",
      "----------378---------\n",
      "\n",
      "----------379---------\n",
      "\n",
      "----------380---------\n",
      "\n",
      "----------381---------\n",
      "\n",
      "----------382---------\n",
      "\n",
      "----------383---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=49\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----------384---------\n",
      "\n",
      "----------385---------\n",
      "\n",
      "----------386---------\n",
      "\n",
      "----------387---------\n",
      "\n",
      "----------388---------\n",
      "\n",
      "----------389---------\n",
      "\n",
      "----------390---------\n",
      "\n",
      "----------391---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=50\n",
      "\n",
      "----------392---------\n",
      "\n",
      "----------393---------\n",
      "\n",
      "----------394---------\n",
      "\n",
      "----------395---------\n",
      "\n",
      "----------396---------\n",
      "\n",
      "----------397---------\n",
      "\n",
      "----------398---------\n",
      "\n",
      "----------399---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=51\n",
      "\n",
      "----------400---------\n",
      "\n",
      "----------401---------\n",
      "\n",
      "----------402---------\n",
      "\n",
      "----------403---------\n",
      "\n",
      "----------404---------\n",
      "\n",
      "----------405---------\n",
      "\n",
      "----------406---------\n",
      "\n",
      "----------407---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=52\n",
      "\n",
      "----------408---------\n",
      "\n",
      "----------409---------\n",
      "\n",
      "----------410---------\n",
      "\n",
      "----------411---------\n",
      "\n",
      "----------412---------\n",
      "\n",
      "----------413---------\n",
      "\n",
      "----------414---------\n",
      "\n",
      "----------415---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=53\n",
      "\n",
      "----------416---------\n",
      "\n",
      "----------417---------\n",
      "\n",
      "----------418---------\n",
      "\n",
      "----------419---------\n",
      "\n",
      "----------420---------\n",
      "\n",
      "----------421---------\n",
      "\n",
      "----------422---------\n",
      "\n",
      "----------423---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=54\n",
      "\n",
      "----------424---------\n",
      "\n",
      "----------425---------\n",
      "\n",
      "----------426---------\n",
      "\n",
      "----------427---------\n",
      "\n",
      "----------428---------\n",
      "\n",
      "----------429---------\n",
      "\n",
      "----------430---------\n",
      "\n",
      "----------431---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=55\n",
      "\n",
      "----------432---------\n",
      "\n",
      "----------433---------\n",
      "\n",
      "----------434---------\n",
      "\n",
      "----------435---------\n",
      "\n",
      "----------436---------\n",
      "\n",
      "----------437---------\n",
      "\n",
      "----------438---------\n",
      "\n",
      "----------439---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=56\n",
      "\n",
      "----------440---------\n",
      "\n",
      "----------441---------\n",
      "\n",
      "----------442---------\n",
      "\n",
      "----------443---------\n",
      "\n",
      "----------444---------\n",
      "\n",
      "----------445---------\n",
      "\n",
      "----------446---------\n",
      "\n",
      "----------447---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=57\n",
      "\n",
      "----------448---------\n",
      "\n",
      "----------449---------\n",
      "\n",
      "----------450---------\n",
      "\n",
      "----------451---------\n",
      "\n",
      "----------452---------\n",
      "\n",
      "----------453---------\n",
      "\n",
      "----------454---------\n",
      "\n",
      "----------455---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=58\n",
      "\n",
      "----------456---------\n",
      "\n",
      "----------457---------\n",
      "\n",
      "----------458---------\n",
      "\n",
      "----------459---------\n",
      "\n",
      "----------460---------\n",
      "\n",
      "----------461---------\n",
      "\n",
      "----------462---------\n",
      "\n",
      "----------463---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=59\n",
      "\n",
      "----------464---------\n",
      "\n",
      "----------465---------\n",
      "\n",
      "----------466---------\n",
      "\n",
      "----------467---------\n",
      "\n",
      "----------468---------\n",
      "\n",
      "----------469---------\n",
      "\n",
      "----------470---------\n",
      "\n",
      "----------471---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=60\n",
      "\n",
      "----------472---------\n",
      "\n",
      "----------473---------\n",
      "\n",
      "----------474---------\n",
      "\n",
      "----------475---------\n",
      "\n",
      "----------476---------\n",
      "\n",
      "----------477---------\n",
      "\n",
      "----------478---------\n",
      "\n",
      "----------479---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=61\n",
      "\n",
      "----------480---------\n",
      "\n",
      "----------481---------\n",
      "\n",
      "----------482---------\n",
      "\n",
      "----------483---------\n",
      "\n",
      "----------484---------\n",
      "\n",
      "----------485---------\n",
      "\n",
      "----------486---------\n",
      "\n",
      "----------487---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=62\n",
      "\n",
      "----------488---------\n",
      "\n",
      "----------489---------\n",
      "\n",
      "----------490---------\n",
      "\n",
      "----------491---------\n",
      "\n",
      "----------492---------\n",
      "\n",
      "----------493---------\n",
      "\n",
      "----------494---------\n",
      "\n",
      "----------495---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=63\n",
      "\n",
      "----------496---------\n",
      "\n",
      "----------497---------\n",
      "\n",
      "----------498---------\n",
      "\n",
      "----------499---------\n",
      "\n",
      "----------500---------\n",
      "\n",
      "----------501---------\n",
      "\n",
      "----------502---------\n",
      "\n",
      "----------503---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=64\n",
      "\n",
      "----------504---------\n",
      "\n",
      "----------505---------\n",
      "\n",
      "----------506---------\n",
      "\n",
      "----------507---------\n",
      "\n",
      "----------508---------\n",
      "\n",
      "----------509---------\n",
      "\n",
      "----------510---------\n",
      "\n",
      "----------511---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=65\n",
      "\n",
      "----------512---------\n",
      "\n",
      "----------513---------\n",
      "\n",
      "----------514---------\n",
      "\n",
      "----------515---------\n",
      "\n",
      "----------516---------\n",
      "\n",
      "----------517---------\n",
      "\n",
      "----------518---------\n",
      "\n",
      "----------519---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=66\n",
      "\n",
      "----------520---------\n",
      "\n",
      "----------521---------\n",
      "\n",
      "----------522---------\n",
      "\n",
      "----------523---------\n",
      "\n",
      "----------524---------\n",
      "\n",
      "----------525---------\n",
      "\n",
      "----------526---------\n",
      "\n",
      "----------527---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=67\n",
      "\n",
      "----------528---------\n",
      "\n",
      "----------529---------\n",
      "\n",
      "----------530---------\n",
      "\n",
      "----------531---------\n",
      "\n",
      "----------532---------\n",
      "\n",
      "----------533---------\n",
      "\n",
      "----------534---------\n",
      "\n",
      "----------535---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=68\n",
      "\n",
      "----------536---------\n",
      "\n",
      "----------537---------\n",
      "\n",
      "----------538---------\n",
      "\n",
      "----------539---------\n",
      "\n",
      "----------540---------\n",
      "\n",
      "----------541---------\n",
      "\n",
      "----------542---------\n",
      "\n",
      "----------543---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=69\n",
      "\n",
      "----------544---------\n",
      "\n",
      "----------545---------\n",
      "\n",
      "----------546---------\n",
      "\n",
      "----------547---------\n",
      "\n",
      "----------548---------\n",
      "\n",
      "----------549---------\n",
      "\n",
      "----------550---------\n",
      "\n",
      "----------551---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=70\n",
      "\n",
      "----------552---------\n",
      "\n",
      "----------553---------\n",
      "\n",
      "----------554---------\n",
      "\n",
      "----------555---------\n",
      "\n",
      "----------556---------\n",
      "\n",
      "----------557---------\n",
      "\n",
      "----------558---------\n",
      "\n",
      "----------559---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=71\n",
      "\n",
      "----------560---------\n",
      "\n",
      "----------561---------\n",
      "\n",
      "----------562---------\n",
      "\n",
      "----------563---------\n",
      "\n",
      "----------564---------\n",
      "\n",
      "----------565---------\n",
      "\n",
      "----------566---------\n",
      "\n",
      "----------567---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=72\n",
      "\n",
      "----------568---------\n",
      "\n",
      "----------569---------\n",
      "\n",
      "----------570---------\n",
      "\n",
      "----------571---------\n",
      "\n",
      "----------572---------\n",
      "\n",
      "----------573---------\n",
      "\n",
      "----------574---------\n",
      "\n",
      "----------575---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=73\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----------576---------\n",
      "\n",
      "----------577---------\n",
      "\n",
      "----------578---------\n",
      "\n",
      "----------579---------\n",
      "\n",
      "----------580---------\n",
      "\n",
      "----------581---------\n",
      "\n",
      "----------582---------\n",
      "\n",
      "----------583---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=74\n",
      "\n",
      "----------584---------\n",
      "\n",
      "----------585---------\n",
      "\n",
      "----------586---------\n",
      "\n",
      "----------587---------\n",
      "\n",
      "----------588---------\n",
      "\n",
      "----------589---------\n",
      "\n",
      "----------590---------\n",
      "\n",
      "----------591---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=75\n",
      "\n",
      "----------592---------\n",
      "\n",
      "----------593---------\n",
      "\n",
      "----------594---------\n",
      "\n",
      "----------595---------\n",
      "\n",
      "----------596---------\n",
      "\n",
      "----------597---------\n",
      "\n",
      "----------598---------\n",
      "\n",
      "----------599---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=76\n",
      "\n",
      "----------600---------\n",
      "\n",
      "----------601---------\n",
      "\n",
      "----------602---------\n",
      "\n",
      "----------603---------\n",
      "\n",
      "----------604---------\n",
      "\n",
      "----------605---------\n",
      "\n",
      "----------606---------\n",
      "\n",
      "----------607---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=77\n",
      "\n",
      "----------608---------\n",
      "\n",
      "----------609---------\n",
      "\n",
      "----------610---------\n",
      "\n",
      "----------611---------\n",
      "\n",
      "----------612---------\n",
      "\n",
      "----------613---------\n",
      "\n",
      "----------614---------\n",
      "\n",
      "----------615---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=78\n",
      "\n",
      "----------616---------\n",
      "\n",
      "----------617---------\n",
      "\n",
      "----------618---------\n",
      "\n",
      "----------619---------\n",
      "\n",
      "----------620---------\n",
      "\n",
      "----------621---------\n",
      "\n",
      "----------622---------\n",
      "\n",
      "----------623---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=79\n",
      "\n",
      "----------624---------\n",
      "\n",
      "----------625---------\n",
      "\n",
      "----------626---------\n",
      "\n",
      "----------627---------\n",
      "\n",
      "----------628---------\n",
      "\n",
      "----------629---------\n",
      "\n",
      "----------630---------\n",
      "\n",
      "----------631---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=80\n",
      "\n",
      "----------632---------\n",
      "\n",
      "----------633---------\n",
      "\n",
      "----------634---------\n",
      "\n",
      "----------635---------\n",
      "\n",
      "----------636---------\n",
      "\n",
      "----------637---------\n",
      "\n",
      "----------638---------\n",
      "\n",
      "----------639---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=81\n",
      "\n",
      "----------640---------\n",
      "\n",
      "----------641---------\n",
      "\n",
      "----------642---------\n",
      "\n",
      "----------643---------\n",
      "\n",
      "----------644---------\n",
      "\n",
      "----------645---------\n",
      "\n",
      "----------646---------\n",
      "\n",
      "----------647---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=82\n",
      "\n",
      "----------648---------\n",
      "\n",
      "----------649---------\n",
      "\n",
      "----------650---------\n",
      "\n",
      "----------651---------\n",
      "\n",
      "----------652---------\n",
      "\n",
      "----------653---------\n",
      "\n",
      "----------654---------\n",
      "\n",
      "----------655---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=83\n",
      "\n",
      "----------656---------\n",
      "\n",
      "----------657---------\n",
      "\n",
      "----------658---------\n",
      "\n",
      "----------659---------\n",
      "\n",
      "----------660---------\n",
      "\n",
      "----------661---------\n",
      "\n",
      "----------662---------\n",
      "\n",
      "----------663---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=84\n",
      "\n",
      "----------664---------\n",
      "\n",
      "----------665---------\n",
      "\n",
      "----------666---------\n",
      "\n",
      "----------667---------\n",
      "\n",
      "----------668---------\n",
      "\n",
      "----------669---------\n",
      "\n",
      "----------670---------\n",
      "\n",
      "----------671---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=85\n",
      "\n",
      "----------672---------\n",
      "\n",
      "----------673---------\n",
      "\n",
      "----------674---------\n",
      "\n",
      "----------675---------\n",
      "\n",
      "----------676---------\n",
      "\n",
      "----------677---------\n",
      "\n",
      "----------678---------\n",
      "\n",
      "----------679---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=86\n",
      "\n",
      "----------680---------\n",
      "\n",
      "----------681---------\n",
      "\n",
      "----------682---------\n",
      "\n",
      "----------683---------\n",
      "\n",
      "----------684---------\n",
      "\n",
      "----------685---------\n",
      "\n",
      "----------686---------\n",
      "\n",
      "----------687---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=87\n",
      "\n",
      "----------688---------\n",
      "\n",
      "----------689---------\n",
      "\n",
      "----------690---------\n",
      "\n",
      "----------691---------\n",
      "\n",
      "----------692---------\n",
      "\n",
      "----------693---------\n",
      "\n",
      "----------694---------\n",
      "\n",
      "----------695---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=88\n",
      "\n",
      "----------696---------\n",
      "\n",
      "----------697---------\n",
      "\n",
      "----------698---------\n",
      "\n",
      "----------699---------\n",
      "\n",
      "----------700---------\n",
      "\n",
      "----------701---------\n",
      "\n",
      "----------702---------\n",
      "\n",
      "----------703---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=89\n",
      "\n",
      "----------704---------\n",
      "\n",
      "----------705---------\n",
      "\n",
      "----------706---------\n",
      "\n",
      "----------707---------\n",
      "\n",
      "----------708---------\n",
      "\n",
      "----------709---------\n",
      "\n",
      "----------710---------\n",
      "\n",
      "----------711---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=90\n",
      "\n",
      "----------712---------\n",
      "\n",
      "----------713---------\n",
      "\n",
      "----------714---------\n",
      "\n",
      "----------715---------\n",
      "\n",
      "----------716---------\n",
      "\n",
      "----------717---------\n",
      "\n",
      "----------718---------\n",
      "\n",
      "----------719---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=91\n",
      "\n",
      "----------720---------\n",
      "\n",
      "----------721---------\n",
      "\n",
      "----------722---------\n",
      "\n",
      "----------723---------\n",
      "\n",
      "----------724---------\n",
      "\n",
      "----------725---------\n",
      "\n",
      "----------726---------\n",
      "\n",
      "----------727---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=92\n",
      "\n",
      "----------728---------\n",
      "\n",
      "----------729---------\n",
      "\n",
      "----------730---------\n",
      "\n",
      "----------731---------\n",
      "\n",
      "----------732---------\n",
      "\n",
      "----------733---------\n",
      "\n",
      "----------734---------\n",
      "\n",
      "----------735---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=93\n",
      "\n",
      "----------736---------\n",
      "\n",
      "----------737---------\n",
      "\n",
      "----------738---------\n",
      "\n",
      "----------739---------\n",
      "\n",
      "----------740---------\n",
      "\n",
      "----------741---------\n",
      "\n",
      "----------742---------\n",
      "\n",
      "----------743---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=94\n",
      "\n",
      "----------744---------\n",
      "\n",
      "----------745---------\n",
      "\n",
      "----------746---------\n",
      "\n",
      "----------747---------\n",
      "\n",
      "----------748---------\n",
      "\n",
      "----------749---------\n",
      "\n",
      "----------750---------\n",
      "\n",
      "----------751---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=95\n",
      "\n",
      "----------752---------\n",
      "\n",
      "----------753---------\n",
      "\n",
      "----------754---------\n",
      "\n",
      "----------755---------\n",
      "\n",
      "----------756---------\n",
      "\n",
      "----------757---------\n",
      "\n",
      "----------758---------\n",
      "\n",
      "----------759---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=96\n",
      "\n",
      "----------760---------\n",
      "\n",
      "----------761---------\n",
      "\n",
      "----------762---------\n",
      "\n",
      "----------763---------\n",
      "\n",
      "----------764---------\n",
      "\n",
      "----------765---------\n",
      "\n",
      "----------766---------\n",
      "\n",
      "----------767---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=97\n"
     ]
    },
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "\n",
      "----------768---------\n",
      "\n",
      "----------769---------\n",
      "\n",
      "----------770---------\n",
      "\n",
      "----------771---------\n",
      "\n",
      "----------772---------\n",
      "\n",
      "----------773---------\n",
      "\n",
      "----------774---------\n",
      "\n",
      "----------775---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=98\n",
      "\n",
      "----------776---------\n",
      "\n",
      "----------777---------\n",
      "\n",
      "----------778---------\n",
      "\n",
      "----------779---------\n",
      "\n",
      "----------780---------\n",
      "\n",
      "----------781---------\n",
      "\n",
      "----------782---------\n",
      "\n",
      "----------783---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=99\n",
      "\n",
      "----------784---------\n",
      "\n",
      "----------785---------\n",
      "\n",
      "----------786---------\n",
      "\n",
      "----------787---------\n",
      "\n",
      "----------788---------\n",
      "\n",
      "----------789---------\n",
      "\n",
      "----------790---------\n",
      "\n",
      "----------791---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=100\n",
      "\n",
      "----------792---------\n",
      "\n",
      "----------793---------\n",
      "\n",
      "----------794---------\n",
      "\n",
      "----------795---------\n",
      "\n",
      "----------796---------\n",
      "\n",
      "----------797---------\n",
      "\n",
      "----------798---------\n",
      "\n",
      "----------799---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=101\n",
      "\n",
      "----------800---------\n",
      "\n",
      "----------801---------\n",
      "\n",
      "----------802---------\n",
      "\n",
      "----------803---------\n",
      "\n",
      "----------804---------\n",
      "\n",
      "----------805---------\n",
      "\n",
      "----------806---------\n",
      "\n",
      "----------807---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=102\n",
      "\n",
      "----------808---------\n",
      "\n",
      "----------809---------\n",
      "\n",
      "----------810---------\n",
      "\n",
      "----------811---------\n",
      "\n",
      "----------812---------\n",
      "\n",
      "----------813---------\n",
      "\n",
      "----------814---------\n",
      "\n",
      "----------815---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=103\n",
      "\n",
      "----------816---------\n",
      "\n",
      "----------817---------\n",
      "\n",
      "----------818---------\n",
      "\n",
      "----------819---------\n",
      "\n",
      "----------820---------\n",
      "\n",
      "----------821---------\n",
      "\n",
      "----------822---------\n",
      "\n",
      "----------823---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=104\n",
      "\n",
      "----------824---------\n",
      "\n",
      "----------825---------\n",
      "\n",
      "----------826---------\n",
      "\n",
      "----------827---------\n",
      "\n",
      "----------828---------\n",
      "\n",
      "----------829---------\n",
      "\n",
      "----------830---------\n",
      "\n",
      "----------831---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=105\n",
      "\n",
      "----------832---------\n",
      "\n",
      "----------833---------\n",
      "\n",
      "----------834---------\n",
      "\n",
      "----------835---------\n",
      "\n",
      "----------836---------\n",
      "\n",
      "----------837---------\n",
      "\n",
      "----------838---------\n",
      "\n",
      "----------839---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=106\n",
      "\n",
      "----------840---------\n",
      "\n",
      "----------841---------\n",
      "\n",
      "----------842---------\n",
      "\n",
      "----------843---------\n",
      "\n",
      "----------844---------\n",
      "\n",
      "----------845---------\n",
      "\n",
      "----------846---------\n",
      "\n",
      "----------847---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=107\n",
      "\n",
      "----------848---------\n",
      "\n",
      "----------849---------\n",
      "\n",
      "----------850---------\n",
      "\n",
      "----------851---------\n",
      "\n",
      "----------852---------\n",
      "\n",
      "----------853---------\n",
      "\n",
      "----------854---------\n",
      "\n",
      "----------855---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=108\n",
      "\n",
      "----------856---------\n",
      "\n",
      "----------857---------\n",
      "\n",
      "----------858---------\n",
      "\n",
      "----------859---------\n",
      "\n",
      "----------860---------\n",
      "\n",
      "----------861---------\n",
      "\n",
      "----------862---------\n",
      "\n",
      "----------863---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=109\n",
      "\n",
      "----------864---------\n",
      "\n",
      "----------865---------\n",
      "\n",
      "----------866---------\n",
      "\n",
      "----------867---------\n",
      "\n",
      "----------868---------\n",
      "\n",
      "----------869---------\n",
      "\n",
      "----------870---------\n",
      "\n",
      "----------871---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=110\n",
      "\n",
      "----------872---------\n",
      "\n",
      "----------873---------\n",
      "\n",
      "----------874---------\n",
      "\n",
      "----------875---------\n",
      "\n",
      "----------876---------\n",
      "\n",
      "----------877---------\n",
      "\n",
      "----------878---------\n",
      "\n",
      "----------879---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=111\n",
      "\n",
      "----------880---------\n",
      "\n",
      "----------881---------\n",
      "\n",
      "----------882---------\n",
      "\n",
      "----------883---------\n",
      "\n",
      "----------884---------\n",
      "\n",
      "----------885---------\n",
      "\n",
      "----------886---------\n",
      "\n",
      "----------887---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=112\n",
      "\n",
      "----------888---------\n",
      "\n",
      "----------889---------\n",
      "\n",
      "----------890---------\n",
      "\n",
      "----------891---------\n",
      "\n",
      "----------892---------\n",
      "\n",
      "----------893---------\n",
      "\n",
      "----------894---------\n",
      "\n",
      "----------895---------\n",
      "https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=113\n",
      "\n",
      "----------896---------\n",
      "\n",
      "----------897---------\n",
      "\n",
      "----------898---------\n",
      "\n",
      "----------899---------\n",
      "\n",
      "----------900---------\n",
      "\n",
      "----------901---------\n",
      "\n",
      "----------902---------\n",
      "\n",
      "----------903---------\n",
      "\r"
     ]
    }
   ],
   "source": [
    "cnt = 0\n",
    "reviews_df = pd.DataFrame(columns = ['rating', 'title', 'author', 'date', 'body', 'verified','helpful_votes', 'sentiment'])\n",
    "for page_num in range(1, total_pages):\n",
    "    amazon_rev_url = \"https://www.amazon.in/Apple-iPhone-X-64GB-Silver/product-reviews/B0711T2L8K/ref=cm_cr_getr_d_paging_btm_prev_1?ie=UTF8&reviewerType=all_reviews&pageNumber=\"+str(page_num)\n",
    "    user_agent = 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_6) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/62.0.3202.94 Safari/537.36'\n",
    "    print(amazon_rev_url)\n",
    "    headers = {'User-Agent': user_agent}\n",
    "    page = requests.get(amazon_rev_url, headers = headers)\n",
    "    parser = html.fromstring(page.content)\n",
    "    xpath_reviews = '//div[@data-hook=\"review\"]'\n",
    "    reviews = parser.xpath(xpath_reviews)\n",
    "    xpath_rating  = './/i[@data-hook=\"review-star-rating\"]//text()' \n",
    "    xpath_title   = './/a[@data-hook=\"review-title\"]//text()'\n",
    "    xpath_author  = './/a[@data-hook=\"review-author\"]//text()'\n",
    "    xpath_date    = './/span[@data-hook=\"review-date\"]//text()'\n",
    "    xpath_body    = './/span[@data-hook=\"review-body\"]//text()'\n",
    "    # xpath_helpful = './/span[@data-hook=\"helpful-vote-statement\"]//text()'\n",
    "    xpath_total_reviews = './/span[@data-hook=\"total-review-count\"]//text()'\n",
    "    xpath_verified = './/span[@data-hook=\"avp-badge\"]//text()'\n",
    "    xpath_helpful_votes = './/span[@data-hook=\"helpful-vote-statement\"]//text()'\n",
    "    for i, review in enumerate(reviews):\n",
    "        rating  = float(review.xpath(xpath_rating)[0].split()[0].replace(\",\",\"\"))\n",
    "        title   = review.xpath(xpath_title)[0]\n",
    "        author  = review.xpath(xpath_author)\n",
    "        date    = review.xpath(xpath_date)[0]\n",
    "        body    = review.xpath(xpath_body)[0]\n",
    "#         helpful = review.xpath(xpath_helpful)[0]\n",
    "        if len(review.xpath(xpath_helpful_votes)) > 0:\n",
    "            helpful_votes = review.xpath(xpath_helpful_votes)[0].split()[0].replace(\",\",\"\")\n",
    "        if helpful_votes == 'One':\n",
    "            helpful_votes = 1\n",
    "        helpful_votes = int(helpful_votes)\n",
    "        if len(review.xpath(xpath_verified)) > 0:\n",
    "            verified = review.xpath(xpath_verified)[0]\n",
    "            if verified == 'Verified Purchase':\n",
    "                verified = True\n",
    "            else:\n",
    "                verified = False\n",
    "        else:\n",
    "            verified = False\n",
    "            \n",
    "        if rating < 3: \n",
    "            sentiment = 'Negative'\n",
    "        else:\n",
    "            sentiment = 'Positive'\n",
    "        \n",
    "        review_dict = {'rating': rating,\n",
    "                       'title': title,\n",
    "                       'author': author,             \n",
    "                       'date': date,\n",
    "                       'body': body,\n",
    "                        \"verified\" : verified,\n",
    "                        \"helpful_votes\" : helpful_votes,\n",
    "                        \"sentiment\" : sentiment}\n",
    "        print(\"\\n----------{}---------\\n\".format(cnt), end = '\\r')\n",
    "        cnt += 1\n",
    "#         pprint(review_dict)\n",
    "        reviews_df = reviews_df.append(review_dict, ignore_index=True)\n",
    "    \n",
    "        \n",
    "        "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 47,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "(904, 8)"
      ]
     },
     "execution_count": 47,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_df.shape"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 51,
   "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>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>body</th>\n",
       "      <th>verified</th>\n",
       "      <th>helpful_votes</th>\n",
       "      <th>sentiment</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Amazon Return support is too poor</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>I purchased iphone X on 26th Oct'18 and starte...</td>\n",
       "      <td>True</td>\n",
       "      <td>1146</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5.0</td>\n",
       "      <td>An amazing deal at INR 69,999/-</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-12</td>\n",
       "      <td>This is my 3rd iPhone after iPhone 4S and iPho...</td>\n",
       "      <td>True</td>\n",
       "      <td>226</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Amazing beast(iPhone X 256 GB) for discount!!</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-11</td>\n",
       "      <td>Thanks to Appario Retail Private Ltd, I got th...</td>\n",
       "      <td>True</td>\n",
       "      <td>155</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Battery charging is very bad in my new iPhone X</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-02</td>\n",
       "      <td>I ordered new iPhone X grey on Amazon sale. Ph...</td>\n",
       "      <td>True</td>\n",
       "      <td>71</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Shame don't buy</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-24</td>\n",
       "      <td>Apple iPhone X (Space Grey, 3GB RAM, 64GB Stor...</td>\n",
       "      <td>True</td>\n",
       "      <td>55</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5.0</td>\n",
       "      <td>The Best Device ! All i need is my Iphone.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-08</td>\n",
       "      <td>What a pleasure to own iphonex. I bought it wh...</td>\n",
       "      <td>True</td>\n",
       "      <td>41</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Bad product (BUT GOOD SERVICE FROM AMAZON)😊</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-27</td>\n",
       "      <td>Got a defective phone .... phone receiver not ...</td>\n",
       "      <td>True</td>\n",
       "      <td>30</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Not satisfied</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-15</td>\n",
       "      <td>In this image something is at the back cover. ...</td>\n",
       "      <td>True</td>\n",
       "      <td>33</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Iphone was not in working condition</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-25</td>\n",
       "      <td>I had a worst experience in purchasing Iphone ...</td>\n",
       "      <td>True</td>\n",
       "      <td>33</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.0</td>\n",
       "      <td>US adapter, not indian</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-22</td>\n",
       "      <td>Comes with the wrong adapter. Otherwise a nice...</td>\n",
       "      <td>True</td>\n",
       "      <td>22</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Heating, US model(without engraving at back)</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-11</td>\n",
       "      <td>Everybody's aware of specs and pros, cons on a...</td>\n",
       "      <td>True</td>\n",
       "      <td>18</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Product is not working properly</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-26</td>\n",
       "      <td>Facing lot of problems whithin 3 days it is no...</td>\n",
       "      <td>True</td>\n",
       "      <td>18</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Waste of money</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-02-18</td>\n",
       "      <td>Camera replace but still not working portrait ...</td>\n",
       "      <td>True</td>\n",
       "      <td>13</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Replacement of the defective item</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-16</td>\n",
       "      <td>There is a pink linear line on the screen. Ins...</td>\n",
       "      <td>True</td>\n",
       "      <td>13</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Iphone X 264gb at 71500... Steal Deal for an I...</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>The biggest pro for me is its battery. Thats s...</td>\n",
       "      <td>True</td>\n",
       "      <td>9</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Faulty device delivered</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-19</td>\n",
       "      <td>Faulty touchscreen of the device, contacted Am...</td>\n",
       "      <td>True</td>\n",
       "      <td>7</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Looks nice and premium.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-28</td>\n",
       "      <td>Looks really nice and premium. Price is very h...</td>\n",
       "      <td>True</td>\n",
       "      <td>8</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Iohonx</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-05</td>\n",
       "      <td>It's bad  experience from Amazon ,after one mo...</td>\n",
       "      <td>True</td>\n",
       "      <td>9</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Received a phone with scratch on screen</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-25</td>\n",
       "      <td>Never noticed but received the product with a ...</td>\n",
       "      <td>True</td>\n",
       "      <td>10</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5.0</td>\n",
       "      <td>iPhone like never before</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-12</td>\n",
       "      <td>Amazing phone waited for a year and finally go...</td>\n",
       "      <td>True</td>\n",
       "      <td>7</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Iphone X - Better phone to buy in 2018 &amp; 2019</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-02</td>\n",
       "      <td>I was confused between Iphone X and Iphone XR ...</td>\n",
       "      <td>True</td>\n",
       "      <td>6</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Awesome phone with small disappointments</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-12</td>\n",
       "      <td>The phone is simply awesome- The display, the ...</td>\n",
       "      <td>True</td>\n",
       "      <td>6</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Loving it</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-26</td>\n",
       "      <td>Best picture Nd photo clarity</td>\n",
       "      <td>True</td>\n",
       "      <td>8</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Worth a penny.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-02-11</td>\n",
       "      <td>I bought iPhone X from amazon almost 1month ag...</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Thank you Amazon for the amazing deal</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-12</td>\n",
       "      <td>Found the perfect deal during the Great Indian...</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Well it's Apple</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-09</td>\n",
       "      <td>This pjone is lit. I gifted it to my sister ca...</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Iphone x</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-14</td>\n",
       "      <td>Received the box intact.</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Genuine review by heart</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-12</td>\n",
       "      <td>The battery life was better than previous ipho...</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Good experience.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-04</td>\n",
       "      <td>I had an iphone 6s, i wanted to upgrade it so ...</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Well balanced phone.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-02</td>\n",
       "      <td>I bought this phone for just camera.I travel a...</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>874</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Don't purchase</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-14</td>\n",
       "      <td>Price high</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>875</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Poor people dont lookout here.😂</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-07-15</td>\n",
       "      <td>Amazing phone</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>876</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Five Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-06-04</td>\n",
       "      <td>siraaaa</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>877</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Five Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-07-21</td>\n",
       "      <td>Loved it</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>878</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Five Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-04-09</td>\n",
       "      <td>Very Nice working iPhone have an emojik system...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>879</th>\n",
       "      <td>5.0</td>\n",
       "      <td>The best from Apple!</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-04-01</td>\n",
       "      <td>Much has already been said about the phone but...</td>\n",
       "      <td>True</td>\n",
       "      <td>5</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>880</th>\n",
       "      <td>1.0</td>\n",
       "      <td>People can’t hear me on calls from iphonex</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-05-01</td>\n",
       "      <td>I am iPhone user from last 6 years. I have had...</td>\n",
       "      <td>True</td>\n",
       "      <td>50</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>881</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Does it Worth Your money?</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-05-01</td>\n",
       "      <td>The iPhone X was a huge gamble from Apple, but...</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>882</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Superb</td>\n",
       "      <td>[]</td>\n",
       "      <td>2017-12-29</td>\n",
       "      <td>One of the best phone available in the market</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>883</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Superb product!</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-11</td>\n",
       "      <td>Great product with great deal on Amazon.</td>\n",
       "      <td>True</td>\n",
       "      <td>9</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>884</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Five Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-02-16</td>\n",
       "      <td>Good</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>885</th>\n",
       "      <td>1.0</td>\n",
       "      <td>My iPhone 10 brought in Mid December 2017</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-04-02</td>\n",
       "      <td>I brought this phone from Amazon only because ...</td>\n",
       "      <td>True</td>\n",
       "      <td>50</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>886</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Two Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-03-25</td>\n",
       "      <td>Phone recieved in good quality but speaker is ...</td>\n",
       "      <td>True</td>\n",
       "      <td>8</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>887</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Defective product</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-02-05</td>\n",
       "      <td>Incoming call not displaying immediately. Touc...</td>\n",
       "      <td>True</td>\n",
       "      <td>34</td>\n",
       "      <td>Negative</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>888</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Don't want this mobile</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-08-27</td>\n",
       "      <td>Not like this mobile</td>\n",
       "      <td>False</td>\n",
       "      <td>34</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>889</th>\n",
       "      <td>5.0</td>\n",
       "      <td>cool prdect</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-04-15</td>\n",
       "      <td>It is a very good prdect and very well Pack</td>\n",
       "      <td>False</td>\n",
       "      <td>34</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>890</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Four Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-08-11</td>\n",
       "      <td>Osmmm phone best phone good looking</td>\n",
       "      <td>False</td>\n",
       "      <td>34</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>891</th>\n",
       "      <td>5.0</td>\n",
       "      <td>iPhone X has very good battery, efficient to m...</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-04-19</td>\n",
       "      <td>iPhone X  has  very good battery, efficient to...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>892</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Four Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2017-12-11</td>\n",
       "      <td>Amazing Phone</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>893</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Your money will not go waste. Amazing camera</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-01-29</td>\n",
       "      <td>This is the phone you should buy if you can af...</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>894</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Five Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-07-15</td>\n",
       "      <td>Better than 8+</td>\n",
       "      <td>False</td>\n",
       "      <td>4</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>895</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Dream</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-03-05</td>\n",
       "      <td>My dream phone I love it</td>\n",
       "      <td>False</td>\n",
       "      <td>5</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>896</th>\n",
       "      <td>5.0</td>\n",
       "      <td>BEST iPHONE EVER IS iPHONE X</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-02-12</td>\n",
       "      <td>Hi This is a very good product under Rs82,999 ...</td>\n",
       "      <td>False</td>\n",
       "      <td>6</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>897</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Epic phone but to expensuve</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-04-30</td>\n",
       "      <td>Epic phone but very expensive</td>\n",
       "      <td>False</td>\n",
       "      <td>6</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>898</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Five Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-02-07</td>\n",
       "      <td>Nice one!!!</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>899</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Good</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-02-13</td>\n",
       "      <td>Very good version</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>900</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Iphone</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-06-10</td>\n",
       "      <td>Hello this is iPhone x</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>901</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Awesome iPhone X</td>\n",
       "      <td>[]</td>\n",
       "      <td>2017-12-22</td>\n",
       "      <td>The iphone X has come up with some spectacular...</td>\n",
       "      <td>True</td>\n",
       "      <td>28</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>902</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Five Stars</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-02-13</td>\n",
       "      <td>Does all the multitasking</td>\n",
       "      <td>False</td>\n",
       "      <td>28</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>903</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Super</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-08-05</td>\n",
       "      <td>Excellent</td>\n",
       "      <td>False</td>\n",
       "      <td>28</td>\n",
       "      <td>Positive</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>904 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     rating                                              title author  \\\n",
       "0       1.0                  Amazon Return support is too poor     []   \n",
       "1       5.0                    An amazing deal at INR 69,999/-     []   \n",
       "2       5.0      Amazing beast(iPhone X 256 GB) for discount!!     []   \n",
       "3       1.0    Battery charging is very bad in my new iPhone X     []   \n",
       "4       1.0                                    Shame don't buy     []   \n",
       "5       5.0         The Best Device ! All i need is my Iphone.     []   \n",
       "6       1.0        Bad product (BUT GOOD SERVICE FROM AMAZON)😊     []   \n",
       "7       3.0                                      Not satisfied     []   \n",
       "8       1.0                Iphone was not in working condition     []   \n",
       "9       1.0                             US adapter, not indian     []   \n",
       "10      4.0       Heating, US model(without engraving at back)     []   \n",
       "11      1.0                    Product is not working properly     []   \n",
       "12      3.0                                     Waste of money     []   \n",
       "13      1.0                  Replacement of the defective item     []   \n",
       "14      5.0  Iphone X 264gb at 71500... Steal Deal for an I...     []   \n",
       "15      1.0                            Faulty device delivered     []   \n",
       "16      5.0                            Looks nice and premium.     []   \n",
       "17      1.0                                             Iohonx     []   \n",
       "18      1.0            Received a phone with scratch on screen     []   \n",
       "19      5.0                           iPhone like never before     []   \n",
       "20      5.0      Iphone X - Better phone to buy in 2018 & 2019     []   \n",
       "21      4.0           Awesome phone with small disappointments     []   \n",
       "22      5.0                                          Loving it     []   \n",
       "23      5.0                                     Worth a penny.     []   \n",
       "24      5.0              Thank you Amazon for the amazing deal     []   \n",
       "25      5.0                                    Well it's Apple     []   \n",
       "26      1.0                                           Iphone x     []   \n",
       "27      2.0                            Genuine review by heart     []   \n",
       "28      5.0                                   Good experience.     []   \n",
       "29      5.0                               Well balanced phone.     []   \n",
       "..      ...                                                ...    ...   \n",
       "874     5.0                                     Don't purchase     []   \n",
       "875     5.0                    Poor people dont lookout here.😂     []   \n",
       "876     5.0                                         Five Stars     []   \n",
       "877     5.0                                         Five Stars     []   \n",
       "878     5.0                                         Five Stars     []   \n",
       "879     5.0                               The best from Apple!     []   \n",
       "880     1.0         People can’t hear me on calls from iphonex     []   \n",
       "881     4.0                          Does it Worth Your money?     []   \n",
       "882     5.0                                             Superb     []   \n",
       "883     5.0                                    Superb product!     []   \n",
       "884     5.0                                         Five Stars     []   \n",
       "885     1.0          My iPhone 10 brought in Mid December 2017     []   \n",
       "886     2.0                                          Two Stars     []   \n",
       "887     1.0                                  Defective product     []   \n",
       "888     4.0                             Don't want this mobile     []   \n",
       "889     5.0                                        cool prdect     []   \n",
       "890     4.0                                         Four Stars     []   \n",
       "891     5.0  iPhone X has very good battery, efficient to m...     []   \n",
       "892     4.0                                         Four Stars     []   \n",
       "893     5.0       Your money will not go waste. Amazing camera     []   \n",
       "894     5.0                                         Five Stars     []   \n",
       "895     5.0                                              Dream     []   \n",
       "896     5.0                       BEST iPHONE EVER IS iPHONE X     []   \n",
       "897     4.0                        Epic phone but to expensuve     []   \n",
       "898     5.0                                         Five Stars     []   \n",
       "899     4.0                                               Good     []   \n",
       "900     5.0                                             Iphone     []   \n",
       "901     5.0                                   Awesome iPhone X     []   \n",
       "902     5.0                                         Five Stars     []   \n",
       "903     5.0                                              Super     []   \n",
       "\n",
       "          date                                               body verified  \\\n",
       "0   2018-10-31  I purchased iphone X on 26th Oct'18 and starte...     True   \n",
       "1   2018-10-12  This is my 3rd iPhone after iPhone 4S and iPho...     True   \n",
       "2   2018-10-11  Thanks to Appario Retail Private Ltd, I got th...     True   \n",
       "3   2018-11-02  I ordered new iPhone X grey on Amazon sale. Ph...     True   \n",
       "4   2018-10-24  Apple iPhone X (Space Grey, 3GB RAM, 64GB Stor...     True   \n",
       "5   2018-11-08  What a pleasure to own iphonex. I bought it wh...     True   \n",
       "6   2018-10-27  Got a defective phone .... phone receiver not ...     True   \n",
       "7   2019-01-15  In this image something is at the back cover. ...     True   \n",
       "8   2018-10-25  I had a worst experience in purchasing Iphone ...     True   \n",
       "9   2018-10-22  Comes with the wrong adapter. Otherwise a nice...     True   \n",
       "10  2018-10-11  Everybody's aware of specs and pros, cons on a...     True   \n",
       "11  2018-11-26  Facing lot of problems whithin 3 days it is no...     True   \n",
       "12  2019-02-18  Camera replace but still not working portrait ...     True   \n",
       "13  2018-10-16  There is a pink linear line on the screen. Ins...     True   \n",
       "14  2018-10-23  The biggest pro for me is its battery. Thats s...     True   \n",
       "15  2018-10-19  Faulty touchscreen of the device, contacted Am...     True   \n",
       "16  2018-10-28  Looks really nice and premium. Price is very h...     True   \n",
       "17  2018-12-05  It's bad  experience from Amazon ,after one mo...     True   \n",
       "18  2018-10-25  Never noticed but received the product with a ...     True   \n",
       "19  2018-10-12  Amazing phone waited for a year and finally go...     True   \n",
       "20  2018-12-02  I was confused between Iphone X and Iphone XR ...     True   \n",
       "21  2018-10-12  The phone is simply awesome- The display, the ...     True   \n",
       "22  2019-01-26                      Best picture Nd photo clarity     True   \n",
       "23  2019-02-11  I bought iPhone X from amazon almost 1month ag...     True   \n",
       "24  2018-11-12  Found the perfect deal during the Great Indian...     True   \n",
       "25  2018-11-09  This pjone is lit. I gifted it to my sister ca...     True   \n",
       "26  2019-01-14                           Received the box intact.     True   \n",
       "27  2018-12-12  The battery life was better than previous ipho...     True   \n",
       "28  2018-11-04  I had an iphone 6s, i wanted to upgrade it so ...     True   \n",
       "29  2018-11-02  I bought this phone for just camera.I travel a...     True   \n",
       "..         ...                                                ...      ...   \n",
       "874 2018-10-14                                         Price high    False   \n",
       "875 2018-07-15                                      Amazing phone    False   \n",
       "876 2018-06-04                                            siraaaa    False   \n",
       "877 2018-07-21                                           Loved it    False   \n",
       "878 2018-04-09  Very Nice working iPhone have an emojik system...    False   \n",
       "879 2018-04-01  Much has already been said about the phone but...     True   \n",
       "880 2018-05-01  I am iPhone user from last 6 years. I have had...     True   \n",
       "881 2018-05-01  The iPhone X was a huge gamble from Apple, but...    False   \n",
       "882 2017-12-29      One of the best phone available in the market     True   \n",
       "883 2018-12-11           Great product with great deal on Amazon.     True   \n",
       "884 2018-02-16                                               Good     True   \n",
       "885 2018-04-02  I brought this phone from Amazon only because ...     True   \n",
       "886 2018-03-25  Phone recieved in good quality but speaker is ...     True   \n",
       "887 2018-02-05  Incoming call not displaying immediately. Touc...     True   \n",
       "888 2018-08-27                               Not like this mobile    False   \n",
       "889 2018-04-15        It is a very good prdect and very well Pack    False   \n",
       "890 2018-08-11                Osmmm phone best phone good looking    False   \n",
       "891 2018-04-19  iPhone X  has  very good battery, efficient to...     True   \n",
       "892 2017-12-11                                      Amazing Phone     True   \n",
       "893 2018-01-29  This is the phone you should buy if you can af...     True   \n",
       "894 2018-07-15                                     Better than 8+    False   \n",
       "895 2018-03-05                           My dream phone I love it    False   \n",
       "896 2018-02-12  Hi This is a very good product under Rs82,999 ...    False   \n",
       "897 2018-04-30                      Epic phone but very expensive    False   \n",
       "898 2018-02-07                                        Nice one!!!     True   \n",
       "899 2018-02-13                                  Very good version    False   \n",
       "900 2018-06-10                             Hello this is iPhone x    False   \n",
       "901 2017-12-22  The iphone X has come up with some spectacular...     True   \n",
       "902 2018-02-13                          Does all the multitasking    False   \n",
       "903 2018-08-05                                          Excellent    False   \n",
       "\n",
       "    helpful_votes sentiment  \n",
       "0            1146  Negative  \n",
       "1             226  Positive  \n",
       "2             155  Positive  \n",
       "3              71  Negative  \n",
       "4              55  Negative  \n",
       "5              41  Positive  \n",
       "6              30  Negative  \n",
       "7              33  Positive  \n",
       "8              33  Negative  \n",
       "9              22  Negative  \n",
       "10             18  Positive  \n",
       "11             18  Negative  \n",
       "12             13  Positive  \n",
       "13             13  Negative  \n",
       "14              9  Positive  \n",
       "15              7  Negative  \n",
       "16              8  Positive  \n",
       "17              9  Negative  \n",
       "18             10  Negative  \n",
       "19              7  Positive  \n",
       "20              6  Positive  \n",
       "21              6  Positive  \n",
       "22              8  Positive  \n",
       "23              3  Positive  \n",
       "24              3  Positive  \n",
       "25              4  Positive  \n",
       "26              4  Negative  \n",
       "27              3  Negative  \n",
       "28              4  Positive  \n",
       "29              4  Positive  \n",
       "..            ...       ...  \n",
       "874             2  Positive  \n",
       "875             2  Positive  \n",
       "876             1  Positive  \n",
       "877             1  Positive  \n",
       "878             1  Positive  \n",
       "879             5  Positive  \n",
       "880            50  Negative  \n",
       "881             1  Positive  \n",
       "882             3  Positive  \n",
       "883             9  Positive  \n",
       "884             2  Positive  \n",
       "885            50  Negative  \n",
       "886             8  Negative  \n",
       "887            34  Negative  \n",
       "888            34  Positive  \n",
       "889            34  Positive  \n",
       "890            34  Positive  \n",
       "891             2  Positive  \n",
       "892             2  Positive  \n",
       "893             4  Positive  \n",
       "894             4  Positive  \n",
       "895             5  Positive  \n",
       "896             6  Positive  \n",
       "897             6  Positive  \n",
       "898             1  Positive  \n",
       "899             1  Positive  \n",
       "900             1  Positive  \n",
       "901            28  Positive  \n",
       "902            28  Positive  \n",
       "903            28  Positive  \n",
       "\n",
       "[904 rows x 8 columns]"
      ]
     },
     "execution_count": 51,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 77,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pickle\n",
    "with open('amz_df.pkl', 'wb') as handle:\n",
    "    pickle.dump(reviews_df, handle)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": [
    "with open('amz_df.pkl', 'rb') as handle:\n",
    "    reviews_df = pickle.load(handle)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "1.0"
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_df['rating'].min()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "metadata": {},
   "outputs": [],
   "source": [
    "def normalize(df):\n",
    "    result = df.copy()\n",
    "    feature_name = 'rating'\n",
    "    \n",
    "    max_value = df[feature_name].max()\n",
    "    min_value = df[feature_name].min()\n",
    "    print(min_value,max_value)\n",
    "    result['sentiment_range'] = 2*((df[feature_name] - min_value) / (max_value - min_value)) - 1.0\n",
    "    return result"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 68,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "1.0 5.0\n"
     ]
    }
   ],
   "source": [
    "reviews_df = normalize(reviews_df)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 70,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "array([-1. ,  1. ,  0. ,  0.5, -0.5])"
      ]
     },
     "execution_count": 70,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_df.sentiment_range.unique()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 69,
   "metadata": {
    "scrolled": true
   },
   "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>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>author</th>\n",
       "      <th>date</th>\n",
       "      <th>body</th>\n",
       "      <th>verified</th>\n",
       "      <th>helpful_votes</th>\n",
       "      <th>sentiment</th>\n",
       "      <th>sentiment_range</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Amazon Return support is too poor</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-31</td>\n",
       "      <td>I purchased iphone X on 26th Oct'18 and starte...</td>\n",
       "      <td>True</td>\n",
       "      <td>1146</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>5.0</td>\n",
       "      <td>An amazing deal at INR 69,999/-</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-12</td>\n",
       "      <td>This is my 3rd iPhone after iPhone 4S and iPho...</td>\n",
       "      <td>True</td>\n",
       "      <td>226</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Amazing beast(iPhone X 256 GB) for discount!!</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-11</td>\n",
       "      <td>Thanks to Appario Retail Private Ltd, I got th...</td>\n",
       "      <td>True</td>\n",
       "      <td>155</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Battery charging is very bad in my new iPhone X</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-02</td>\n",
       "      <td>I ordered new iPhone X grey on Amazon sale. Ph...</td>\n",
       "      <td>True</td>\n",
       "      <td>71</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Shame don't buy</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-24</td>\n",
       "      <td>Apple iPhone X (Space Grey, 3GB RAM, 64GB Stor...</td>\n",
       "      <td>True</td>\n",
       "      <td>55</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>5.0</td>\n",
       "      <td>The Best Device ! All i need is my Iphone.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-08</td>\n",
       "      <td>What a pleasure to own iphonex. I bought it wh...</td>\n",
       "      <td>True</td>\n",
       "      <td>41</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Bad product (BUT GOOD SERVICE FROM AMAZON)😊</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-27</td>\n",
       "      <td>Got a defective phone .... phone receiver not ...</td>\n",
       "      <td>True</td>\n",
       "      <td>30</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Not satisfied</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-15</td>\n",
       "      <td>In this image something is at the back cover. ...</td>\n",
       "      <td>True</td>\n",
       "      <td>33</td>\n",
       "      <td>Positive</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Iphone was not in working condition</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-25</td>\n",
       "      <td>I had a worst experience in purchasing Iphone ...</td>\n",
       "      <td>True</td>\n",
       "      <td>33</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1.0</td>\n",
       "      <td>US adapter, not indian</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-22</td>\n",
       "      <td>Comes with the wrong adapter. Otherwise a nice...</td>\n",
       "      <td>True</td>\n",
       "      <td>22</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Heating, US model(without engraving at back)</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-11</td>\n",
       "      <td>Everybody's aware of specs and pros, cons on a...</td>\n",
       "      <td>True</td>\n",
       "      <td>18</td>\n",
       "      <td>Positive</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Product is not working properly</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-26</td>\n",
       "      <td>Facing lot of problems whithin 3 days it is no...</td>\n",
       "      <td>True</td>\n",
       "      <td>18</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>3.0</td>\n",
       "      <td>Waste of money</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-02-18</td>\n",
       "      <td>Camera replace but still not working portrait ...</td>\n",
       "      <td>True</td>\n",
       "      <td>13</td>\n",
       "      <td>Positive</td>\n",
       "      <td>0.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Replacement of the defective item</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-16</td>\n",
       "      <td>There is a pink linear line on the screen. Ins...</td>\n",
       "      <td>True</td>\n",
       "      <td>13</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Iphone X 264gb at 71500... Steal Deal for an I...</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-23</td>\n",
       "      <td>The biggest pro for me is its battery. Thats s...</td>\n",
       "      <td>True</td>\n",
       "      <td>9</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Faulty device delivered</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-19</td>\n",
       "      <td>Faulty touchscreen of the device, contacted Am...</td>\n",
       "      <td>True</td>\n",
       "      <td>7</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Looks nice and premium.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-28</td>\n",
       "      <td>Looks really nice and premium. Price is very h...</td>\n",
       "      <td>True</td>\n",
       "      <td>8</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Iohonx</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-05</td>\n",
       "      <td>It's bad  experience from Amazon ,after one mo...</td>\n",
       "      <td>True</td>\n",
       "      <td>9</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Received a phone with scratch on screen</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-25</td>\n",
       "      <td>Never noticed but received the product with a ...</td>\n",
       "      <td>True</td>\n",
       "      <td>10</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>5.0</td>\n",
       "      <td>iPhone like never before</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-12</td>\n",
       "      <td>Amazing phone waited for a year and finally go...</td>\n",
       "      <td>True</td>\n",
       "      <td>7</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Iphone X - Better phone to buy in 2018 &amp; 2019</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-02</td>\n",
       "      <td>I was confused between Iphone X and Iphone XR ...</td>\n",
       "      <td>True</td>\n",
       "      <td>6</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Awesome phone with small disappointments</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-12</td>\n",
       "      <td>The phone is simply awesome- The display, the ...</td>\n",
       "      <td>True</td>\n",
       "      <td>6</td>\n",
       "      <td>Positive</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Loving it</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-26</td>\n",
       "      <td>Best picture Nd photo clarity</td>\n",
       "      <td>True</td>\n",
       "      <td>8</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Worth a penny.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-02-11</td>\n",
       "      <td>I bought iPhone X from amazon almost 1month ag...</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Thank you Amazon for the amazing deal</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-12</td>\n",
       "      <td>Found the perfect deal during the Great Indian...</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Well it's Apple</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-09</td>\n",
       "      <td>This pjone is lit. I gifted it to my sister ca...</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Iphone x</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-14</td>\n",
       "      <td>Received the box intact.</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>2.0</td>\n",
       "      <td>Genuine review by heart</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-12</td>\n",
       "      <td>The battery life was better than previous ipho...</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Good experience.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-04</td>\n",
       "      <td>I had an iphone 6s, i wanted to upgrade it so ...</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Well balanced phone.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-02</td>\n",
       "      <td>I bought this phone for just camera.I travel a...</td>\n",
       "      <td>True</td>\n",
       "      <td>4</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>30</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Great just great</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-16</td>\n",
       "      <td>This is my first iphone i was a long time andr...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>31</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Defective software. Doesn't load appstore.. Ve...</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-02-02</td>\n",
       "      <td>Very annoying purchase. There is no appstore o...</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>32</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Got at 68k</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-19</td>\n",
       "      <td>Got at 68k</td>\n",
       "      <td>True</td>\n",
       "      <td>7</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>33</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Worth the purchase</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-27</td>\n",
       "      <td>My first ever iphone and this much expensive p...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>34</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Truly a phone which will leave an impression</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-10-29</td>\n",
       "      <td>Apple has always been a coin with 2 sides, it ...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Great phone</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-03</td>\n",
       "      <td>Actually I was too scared to buy such an expen...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Worth Every Cent!! love it Apple😍😍</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-30</td>\n",
       "      <td>iPhone X is like no other phone out there. Is ...</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>37</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Best phone under 65k even in 2019</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-20</td>\n",
       "      <td>This is my 4th IPhone X purchase all in used i...</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38</th>\n",
       "      <td>1.0</td>\n",
       "      <td>No Point buying from AMAZON, No Warranty is gi...</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-12-21</td>\n",
       "      <td>My Phone stopped working suddenly and when sub...</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>39</th>\n",
       "      <td>1.0</td>\n",
       "      <td>Got faulty product.. :(</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-10</td>\n",
       "      <td>On 1st Jan 2019 i bought this phone for me.</td>\n",
       "      <td>True</td>\n",
       "      <td>3</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>40</th>\n",
       "      <td>2.0</td>\n",
       "      <td>An expensive phone with great features but a w...</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-09</td>\n",
       "      <td>The great thing about the phone is ease of use...</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>Negative</td>\n",
       "      <td>-0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>41</th>\n",
       "      <td>5.0</td>\n",
       "      <td>A premium glass sandwich!!</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-15</td>\n",
       "      <td>Was quite confused whether to go with iPhone X...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>42</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Best iphone ever</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-16</td>\n",
       "      <td>One of the crafted and precisely design iphone...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>43</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Easily the best iPhone ever</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-02-04</td>\n",
       "      <td>Amazing phone. This is the first time am Porch...</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>44</th>\n",
       "      <td>5.0</td>\n",
       "      <td>GEM</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-09-11</td>\n",
       "      <td>God of notches</td>\n",
       "      <td>True</td>\n",
       "      <td>6</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>45</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Very good</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-21</td>\n",
       "      <td>I can’t believe iPhone X performance. I used S...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>46</th>\n",
       "      <td>4.0</td>\n",
       "      <td>Still a powerhouse of a phone</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-09</td>\n",
       "      <td>I got the phone during the Great Indian Festiv...</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "      <td>0.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>47</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Jus go for it.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-11-30</td>\n",
       "      <td>This phone is absolute beauty. I am using this...</td>\n",
       "      <td>True</td>\n",
       "      <td>1</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Awesome Phone Ever.</td>\n",
       "      <td>[]</td>\n",
       "      <td>2019-01-24</td>\n",
       "      <td>There are 2 typea of phone 1st is Phone and  2...</td>\n",
       "      <td>True</td>\n",
       "      <td>2</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>49</th>\n",
       "      <td>5.0</td>\n",
       "      <td>Kaafi sexy phone</td>\n",
       "      <td>[]</td>\n",
       "      <td>2018-09-14</td>\n",
       "      <td>Everything perfect.</td>\n",
       "      <td>True</td>\n",
       "      <td>6</td>\n",
       "      <td>Positive</td>\n",
       "      <td>1.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "    rating                                              title author  \\\n",
       "0      1.0                  Amazon Return support is too poor     []   \n",
       "1      5.0                    An amazing deal at INR 69,999/-     []   \n",
       "2      5.0      Amazing beast(iPhone X 256 GB) for discount!!     []   \n",
       "3      1.0    Battery charging is very bad in my new iPhone X     []   \n",
       "4      1.0                                    Shame don't buy     []   \n",
       "5      5.0         The Best Device ! All i need is my Iphone.     []   \n",
       "6      1.0        Bad product (BUT GOOD SERVICE FROM AMAZON)😊     []   \n",
       "7      3.0                                      Not satisfied     []   \n",
       "8      1.0                Iphone was not in working condition     []   \n",
       "9      1.0                             US adapter, not indian     []   \n",
       "10     4.0       Heating, US model(without engraving at back)     []   \n",
       "11     1.0                    Product is not working properly     []   \n",
       "12     3.0                                     Waste of money     []   \n",
       "13     1.0                  Replacement of the defective item     []   \n",
       "14     5.0  Iphone X 264gb at 71500... Steal Deal for an I...     []   \n",
       "15     1.0                            Faulty device delivered     []   \n",
       "16     5.0                            Looks nice and premium.     []   \n",
       "17     1.0                                             Iohonx     []   \n",
       "18     1.0            Received a phone with scratch on screen     []   \n",
       "19     5.0                           iPhone like never before     []   \n",
       "20     5.0      Iphone X - Better phone to buy in 2018 & 2019     []   \n",
       "21     4.0           Awesome phone with small disappointments     []   \n",
       "22     5.0                                          Loving it     []   \n",
       "23     5.0                                     Worth a penny.     []   \n",
       "24     5.0              Thank you Amazon for the amazing deal     []   \n",
       "25     5.0                                    Well it's Apple     []   \n",
       "26     1.0                                           Iphone x     []   \n",
       "27     2.0                            Genuine review by heart     []   \n",
       "28     5.0                                   Good experience.     []   \n",
       "29     5.0                               Well balanced phone.     []   \n",
       "30     5.0                                   Great just great     []   \n",
       "31     1.0  Defective software. Doesn't load appstore.. Ve...     []   \n",
       "32     5.0                                         Got at 68k     []   \n",
       "33     5.0                                 Worth the purchase     []   \n",
       "34     5.0       Truly a phone which will leave an impression     []   \n",
       "35     5.0                                        Great phone     []   \n",
       "36     5.0                 Worth Every Cent!! love it Apple😍😍     []   \n",
       "37     5.0                  Best phone under 65k even in 2019     []   \n",
       "38     1.0  No Point buying from AMAZON, No Warranty is gi...     []   \n",
       "39     1.0                            Got faulty product.. :(     []   \n",
       "40     2.0  An expensive phone with great features but a w...     []   \n",
       "41     5.0                         A premium glass sandwich!!     []   \n",
       "42     5.0                                   Best iphone ever     []   \n",
       "43     5.0                        Easily the best iPhone ever     []   \n",
       "44     5.0                                                GEM     []   \n",
       "45     5.0                                          Very good     []   \n",
       "46     4.0                      Still a powerhouse of a phone     []   \n",
       "47     5.0                                     Jus go for it.     []   \n",
       "48     5.0                                Awesome Phone Ever.     []   \n",
       "49     5.0                                   Kaafi sexy phone     []   \n",
       "\n",
       "         date                                               body verified  \\\n",
       "0  2018-10-31  I purchased iphone X on 26th Oct'18 and starte...     True   \n",
       "1  2018-10-12  This is my 3rd iPhone after iPhone 4S and iPho...     True   \n",
       "2  2018-10-11  Thanks to Appario Retail Private Ltd, I got th...     True   \n",
       "3  2018-11-02  I ordered new iPhone X grey on Amazon sale. Ph...     True   \n",
       "4  2018-10-24  Apple iPhone X (Space Grey, 3GB RAM, 64GB Stor...     True   \n",
       "5  2018-11-08  What a pleasure to own iphonex. I bought it wh...     True   \n",
       "6  2018-10-27  Got a defective phone .... phone receiver not ...     True   \n",
       "7  2019-01-15  In this image something is at the back cover. ...     True   \n",
       "8  2018-10-25  I had a worst experience in purchasing Iphone ...     True   \n",
       "9  2018-10-22  Comes with the wrong adapter. Otherwise a nice...     True   \n",
       "10 2018-10-11  Everybody's aware of specs and pros, cons on a...     True   \n",
       "11 2018-11-26  Facing lot of problems whithin 3 days it is no...     True   \n",
       "12 2019-02-18  Camera replace but still not working portrait ...     True   \n",
       "13 2018-10-16  There is a pink linear line on the screen. Ins...     True   \n",
       "14 2018-10-23  The biggest pro for me is its battery. Thats s...     True   \n",
       "15 2018-10-19  Faulty touchscreen of the device, contacted Am...     True   \n",
       "16 2018-10-28  Looks really nice and premium. Price is very h...     True   \n",
       "17 2018-12-05  It's bad  experience from Amazon ,after one mo...     True   \n",
       "18 2018-10-25  Never noticed but received the product with a ...     True   \n",
       "19 2018-10-12  Amazing phone waited for a year and finally go...     True   \n",
       "20 2018-12-02  I was confused between Iphone X and Iphone XR ...     True   \n",
       "21 2018-10-12  The phone is simply awesome- The display, the ...     True   \n",
       "22 2019-01-26                      Best picture Nd photo clarity     True   \n",
       "23 2019-02-11  I bought iPhone X from amazon almost 1month ag...     True   \n",
       "24 2018-11-12  Found the perfect deal during the Great Indian...     True   \n",
       "25 2018-11-09  This pjone is lit. I gifted it to my sister ca...     True   \n",
       "26 2019-01-14                           Received the box intact.     True   \n",
       "27 2018-12-12  The battery life was better than previous ipho...     True   \n",
       "28 2018-11-04  I had an iphone 6s, i wanted to upgrade it so ...     True   \n",
       "29 2018-11-02  I bought this phone for just camera.I travel a...     True   \n",
       "30 2019-01-16  This is my first iphone i was a long time andr...     True   \n",
       "31 2019-02-02  Very annoying purchase. There is no appstore o...     True   \n",
       "32 2018-10-19                                         Got at 68k     True   \n",
       "33 2018-11-27  My first ever iphone and this much expensive p...     True   \n",
       "34 2018-10-29  Apple has always been a coin with 2 sides, it ...     True   \n",
       "35 2018-11-03  Actually I was too scared to buy such an expen...     True   \n",
       "36 2018-12-30  iPhone X is like no other phone out there. Is ...     True   \n",
       "37 2018-12-20  This is my 4th IPhone X purchase all in used i...     True   \n",
       "38 2018-12-21  My Phone stopped working suddenly and when sub...     True   \n",
       "39 2019-01-10        On 1st Jan 2019 i bought this phone for me.     True   \n",
       "40 2018-11-09  The great thing about the phone is ease of use...     True   \n",
       "41 2019-01-15  Was quite confused whether to go with iPhone X...     True   \n",
       "42 2018-11-16  One of the crafted and precisely design iphone...     True   \n",
       "43 2019-02-04  Amazing phone. This is the first time am Porch...     True   \n",
       "44 2018-09-11                                     God of notches     True   \n",
       "45 2019-01-21  I can’t believe iPhone X performance. I used S...     True   \n",
       "46 2018-11-09  I got the phone during the Great Indian Festiv...     True   \n",
       "47 2018-11-30  This phone is absolute beauty. I am using this...     True   \n",
       "48 2019-01-24  There are 2 typea of phone 1st is Phone and  2...     True   \n",
       "49 2018-09-14                                Everything perfect.     True   \n",
       "\n",
       "   helpful_votes sentiment  sentiment_range  \n",
       "0           1146  Negative             -1.0  \n",
       "1            226  Positive              1.0  \n",
       "2            155  Positive              1.0  \n",
       "3             71  Negative             -1.0  \n",
       "4             55  Negative             -1.0  \n",
       "5             41  Positive              1.0  \n",
       "6             30  Negative             -1.0  \n",
       "7             33  Positive              0.0  \n",
       "8             33  Negative             -1.0  \n",
       "9             22  Negative             -1.0  \n",
       "10            18  Positive              0.5  \n",
       "11            18  Negative             -1.0  \n",
       "12            13  Positive              0.0  \n",
       "13            13  Negative             -1.0  \n",
       "14             9  Positive              1.0  \n",
       "15             7  Negative             -1.0  \n",
       "16             8  Positive              1.0  \n",
       "17             9  Negative             -1.0  \n",
       "18            10  Negative             -1.0  \n",
       "19             7  Positive              1.0  \n",
       "20             6  Positive              1.0  \n",
       "21             6  Positive              0.5  \n",
       "22             8  Positive              1.0  \n",
       "23             3  Positive              1.0  \n",
       "24             3  Positive              1.0  \n",
       "25             4  Positive              1.0  \n",
       "26             4  Negative             -1.0  \n",
       "27             3  Negative             -0.5  \n",
       "28             4  Positive              1.0  \n",
       "29             4  Positive              1.0  \n",
       "30             2  Positive              1.0  \n",
       "31             1  Negative             -1.0  \n",
       "32             7  Positive              1.0  \n",
       "33             2  Positive              1.0  \n",
       "34             2  Positive              1.0  \n",
       "35             2  Positive              1.0  \n",
       "36             1  Positive              1.0  \n",
       "37             1  Positive              1.0  \n",
       "38             3  Negative             -1.0  \n",
       "39             3  Negative             -1.0  \n",
       "40             1  Negative             -0.5  \n",
       "41             2  Positive              1.0  \n",
       "42             2  Positive              1.0  \n",
       "43             1  Positive              1.0  \n",
       "44             6  Positive              1.0  \n",
       "45             2  Positive              1.0  \n",
       "46             1  Positive              0.5  \n",
       "47             1  Positive              1.0  \n",
       "48             2  Positive              1.0  \n",
       "49             6  Positive              1.0  "
      ]
     },
     "execution_count": 69,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "reviews_df.head(n =50)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "HE_ENV",
   "language": "python",
   "name": "he_env"
  },
  "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.5.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}