Datasets converted.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "import xml.etree.ElementTree as Xet\n",
    "import pandas as pd\n",
    "\n",
    "cols = [\"unique_id\", \"asin\", \"product_name\", \"product_type\", \"helpful\", \"rating\", \n",
    "        \"title\", \"date\", \"reviewer\", \"reviewer_location\", \"review_text\"]\n",
    "rows = []\n",
    "\n",
    "# Parsing the XML file\n",
    "xmlparse = Xet.parse('books.xml')\n",
    "root = xmlparse.getroot()\n",
    "for i in root:\n",
    "    unique_id = i.find(\"unique_id\").text\n",
    "    asin = i.find(\"asin\").text\n",
    "    product_name = i.find(\"product_name\").text\n",
    "    product_type = i.find(\"product_type\").text\n",
    "    helpful = i.find(\"helpful\").text\n",
    "    rating = i.find(\"rating\").text\n",
    "    title = i.find(\"title\").text\n",
    "    date = i.find(\"date\").text\n",
    "    reviewer = i.find(\"reviewer\").text\n",
    "    reviewer_location = i.find(\"reviewer_location\").text\n",
    "    review_text = i.find(\"review_text\").text\n",
    "\n",
    "\n",
    "    rows.append({\"unique_id\": unique_id,\n",
    "                 \"asin\": asin,\n",
    "                 \"product_name\": product_name,\n",
    "                 \"product_type\": product_type,\n",
    "                 \"helpful\": helpful,\n",
    "                 \"rating\": rating,\n",
    "                 \"title\": title,\n",
    "                 \"date\": date,\n",
    "                 \"reviewer\": reviewer,\n",
    "                 \"reviewer_location\": reviewer_location,\n",
    "                 \"review_text\": review_text\n",
    "                })\n",
    "\n",
    "df = pd.DataFrame(rows, columns=cols)\n",
    "\n",
    "# Writing dataframe to csv\n",
    "df.to_csv('books.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unique_id</th>\n",
       "      <th>asin</th>\n",
       "      <th>product_name</th>\n",
       "      <th>product_type</th>\n",
       "      <th>helpful</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer</th>\n",
       "      <th>reviewer_location</th>\n",
       "      <th>review_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>\\n1884956068:a_mainstay_reference_for_spanish-...</td>\n",
       "      <td>\\n1884956068\\n</td>\n",
       "      <td>\\nManual pedi�trico para los due�os del nuevo ...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n7 of 8\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nA mainstay reference for Spanish-speaking ho...</td>\n",
       "      <td>\\nApril 6, 2000\\n</td>\n",
       "      <td>\\nMidwest Book Review\\n</td>\n",
       "      <td>\\nOregon, WI USA\\n</td>\n",
       "      <td>\\nThis all-Spanish handbook for parents with n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>\\n0679728740:you_want_the_necrophiliac_to_esca...</td>\n",
       "      <td>\\n0679728740\\n</td>\n",
       "      <td>\\nChild of God: Books: Cormac Mccarthy\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n0 of 1\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nYou want the necrophiliac to escape?\\n</td>\n",
       "      <td>\\nOctober 20, 2006\\n</td>\n",
       "      <td>\\nBrian Asquith\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\nMcCarthy's writing and portrayal of Lester B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>\\n0679728740:low_brow_and_juvenile:bruce_miller\\n</td>\n",
       "      <td>\\n0679728740\\n</td>\n",
       "      <td>\\nChild of God: Books: Cormac Mccarthy\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n2 of 5\\n</td>\n",
       "      <td>\\n2.0\\n</td>\n",
       "      <td>\\nLow brow and juvenile\\n</td>\n",
       "      <td>\\nSeptember 26, 2006\\n</td>\n",
       "      <td>\\nBruce Miller\\n</td>\n",
       "      <td>\\nShippensburg, PA United States\\n</td>\n",
       "      <td>\\nDo you giggle uncontrollably when poking cor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>\\n0679728740:mccarthy,_a_brave_writer_with_an_...</td>\n",
       "      <td>\\n0679728740\\n</td>\n",
       "      <td>\\nChild of God: Books: Cormac Mccarthy\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n4 of 5\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nMcCarthy, a brave writer with an incredible ...</td>\n",
       "      <td>\\nJuly 24, 2005\\n</td>\n",
       "      <td>\\nChristopher Davis \"Christopher E.D.\"\\n</td>\n",
       "      <td>\\nCleveland, MS\\n</td>\n",
       "      <td>\\nI was initiated into the world of Cormac McC...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>\\n0679728740:sevierville_in_child_of_god:alex_...</td>\n",
       "      <td>\\n0679728740\\n</td>\n",
       "      <td>\\nChild of God: Books: Cormac Mccarthy\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n11 of 14\\n</td>\n",
       "      <td>\\n4.0\\n</td>\n",
       "      <td>\\nSEVIERVILLE in Child of God\\n</td>\n",
       "      <td>\\nNovember 20, 2002\\n</td>\n",
       "      <td>\\nAlex Johnson\\n</td>\n",
       "      <td>\\nSevierville, Tennessee\\n</td>\n",
       "      <td>\\nI cannot speak to the literary points in the...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           unique_id            asin  \\\n",
       "0  \\n1884956068:a_mainstay_reference_for_spanish-...  \\n1884956068\\n   \n",
       "1  \\n0679728740:you_want_the_necrophiliac_to_esca...  \\n0679728740\\n   \n",
       "2  \\n0679728740:low_brow_and_juvenile:bruce_miller\\n  \\n0679728740\\n   \n",
       "3  \\n0679728740:mccarthy,_a_brave_writer_with_an_...  \\n0679728740\\n   \n",
       "4  \\n0679728740:sevierville_in_child_of_god:alex_...  \\n0679728740\\n   \n",
       "\n",
       "                                        product_name product_type  \\\n",
       "0  \\nManual pedi�trico para los due�os del nuevo ...    \\nbooks\\n   \n",
       "1           \\nChild of God: Books: Cormac Mccarthy\\n    \\nbooks\\n   \n",
       "2           \\nChild of God: Books: Cormac Mccarthy\\n    \\nbooks\\n   \n",
       "3           \\nChild of God: Books: Cormac Mccarthy\\n    \\nbooks\\n   \n",
       "4           \\nChild of God: Books: Cormac Mccarthy\\n    \\nbooks\\n   \n",
       "\n",
       "        helpful   rating                                              title  \\\n",
       "0    \\n7 of 8\\n  \\n5.0\\n  \\nA mainstay reference for Spanish-speaking ho...   \n",
       "1    \\n0 of 1\\n  \\n5.0\\n           \\nYou want the necrophiliac to escape?\\n   \n",
       "2    \\n2 of 5\\n  \\n2.0\\n                          \\nLow brow and juvenile\\n   \n",
       "3    \\n4 of 5\\n  \\n5.0\\n  \\nMcCarthy, a brave writer with an incredible ...   \n",
       "4  \\n11 of 14\\n  \\n4.0\\n                    \\nSEVIERVILLE in Child of God\\n   \n",
       "\n",
       "                     date                                  reviewer  \\\n",
       "0       \\nApril 6, 2000\\n                   \\nMidwest Book Review\\n   \n",
       "1    \\nOctober 20, 2006\\n                         \\nBrian Asquith\\n   \n",
       "2  \\nSeptember 26, 2006\\n                          \\nBruce Miller\\n   \n",
       "3       \\nJuly 24, 2005\\n  \\nChristopher Davis \"Christopher E.D.\"\\n   \n",
       "4   \\nNovember 20, 2002\\n                          \\nAlex Johnson\\n   \n",
       "\n",
       "                    reviewer_location  \\\n",
       "0                  \\nOregon, WI USA\\n   \n",
       "1                                \\n\\n   \n",
       "2  \\nShippensburg, PA United States\\n   \n",
       "3                   \\nCleveland, MS\\n   \n",
       "4          \\nSevierville, Tennessee\\n   \n",
       "\n",
       "                                         review_text  \n",
       "0  \\nThis all-Spanish handbook for parents with n...  \n",
       "1  \\nMcCarthy's writing and portrayal of Lester B...  \n",
       "2  \\nDo you giggle uncontrollably when poking cor...  \n",
       "3  \\nI was initiated into the world of Cormac McC...  \n",
       "4  \\nI cannot speak to the literary points in the...  "
      ]
     },
     "execution_count": 19,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "\"\\nThis all-Spanish handbook for parents with new babies will prove essential for any concerned about a child's health. Manual Pediatrico appeared first in English; the Spanish edition provides essential health information at a glance for parents unversed in medical care; and should be a mainstay of  any Spanish-speaking home with children\\n\""
      ]
     },
     "execution_count": 23,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['review_text'][0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 24,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "unique_id            object\n",
       "asin                 object\n",
       "product_name         object\n",
       "product_type         object\n",
       "helpful              object\n",
       "rating               object\n",
       "title                object\n",
       "date                 object\n",
       "reviewer             object\n",
       "reviewer_location    object\n",
       "review_text          object\n",
       "dtype: object"
      ]
     },
     "execution_count": 24,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.dtypes"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['unique_id']=df['unique_id'].apply(str).str.replace('\\n','')\n",
    "df['asin']=df['asin'].apply(str).str.replace('\\n','')\n",
    "df['product_name']=df['product_name'].apply(str).str.replace('\\n','')\n",
    "df['product_type']=df['product_type'].apply(str).str.replace('\\n','')\n",
    "df['helpful']=df['helpful'].apply(str).str.replace('\\n','')\n",
    "df['rating']=df['rating'].apply(str).str.replace('\\n','')\n",
    "df['title']=df['title'].apply(str).str.replace('\\n','')\n",
    "df['date']=df['date'].apply(str).str.replace('\\n','')\n",
    "df['reviewer']=df['reviewer'].apply(str).str.replace('\\n','')\n",
    "df['reviewer_location']=df['reviewer_location'].apply(str).str.replace('\\n','')\n",
    "df['review_text']=df['review_text'].apply(str).str.replace('\\n','')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 26,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unique_id</th>\n",
       "      <th>asin</th>\n",
       "      <th>product_name</th>\n",
       "      <th>product_type</th>\n",
       "      <th>helpful</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer</th>\n",
       "      <th>reviewer_location</th>\n",
       "      <th>review_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1884956068:a_mainstay_reference_for_spanish-sp...</td>\n",
       "      <td>1884956068</td>\n",
       "      <td>Manual pedi�trico para los due�os del nuevo be...</td>\n",
       "      <td>books</td>\n",
       "      <td>7 of 8</td>\n",
       "      <td>5.0</td>\n",
       "      <td>A mainstay reference for Spanish-speaking home...</td>\n",
       "      <td>April 6, 2000</td>\n",
       "      <td>Midwest Book Review</td>\n",
       "      <td>Oregon, WI USA</td>\n",
       "      <td>This all-Spanish handbook for parents with new...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>0679728740:you_want_the_necrophiliac_to_escape...</td>\n",
       "      <td>0679728740</td>\n",
       "      <td>Child of God: Books: Cormac Mccarthy</td>\n",
       "      <td>books</td>\n",
       "      <td>0 of 1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>You want the necrophiliac to escape?</td>\n",
       "      <td>October 20, 2006</td>\n",
       "      <td>Brian Asquith</td>\n",
       "      <td></td>\n",
       "      <td>McCarthy's writing and portrayal of Lester Bal...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0679728740:low_brow_and_juvenile:bruce_miller</td>\n",
       "      <td>0679728740</td>\n",
       "      <td>Child of God: Books: Cormac Mccarthy</td>\n",
       "      <td>books</td>\n",
       "      <td>2 of 5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Low brow and juvenile</td>\n",
       "      <td>September 26, 2006</td>\n",
       "      <td>Bruce Miller</td>\n",
       "      <td>Shippensburg, PA United States</td>\n",
       "      <td>Do you giggle uncontrollably when poking corps...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0679728740:mccarthy,_a_brave_writer_with_an_in...</td>\n",
       "      <td>0679728740</td>\n",
       "      <td>Child of God: Books: Cormac Mccarthy</td>\n",
       "      <td>books</td>\n",
       "      <td>4 of 5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>McCarthy, a brave writer with an incredible co...</td>\n",
       "      <td>July 24, 2005</td>\n",
       "      <td>Christopher Davis \"Christopher E.D.\"</td>\n",
       "      <td>Cleveland, MS</td>\n",
       "      <td>I was initiated into the world of Cormac McCar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>0679728740:sevierville_in_child_of_god:alex_jo...</td>\n",
       "      <td>0679728740</td>\n",
       "      <td>Child of God: Books: Cormac Mccarthy</td>\n",
       "      <td>books</td>\n",
       "      <td>11 of 14</td>\n",
       "      <td>4.0</td>\n",
       "      <td>SEVIERVILLE in Child of God</td>\n",
       "      <td>November 20, 2002</td>\n",
       "      <td>Alex Johnson</td>\n",
       "      <td>Sevierville, Tennessee</td>\n",
       "      <td>I cannot speak to the literary points in the n...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                           unique_id        asin  \\\n",
       "0  1884956068:a_mainstay_reference_for_spanish-sp...  1884956068   \n",
       "1  0679728740:you_want_the_necrophiliac_to_escape...  0679728740   \n",
       "2      0679728740:low_brow_and_juvenile:bruce_miller  0679728740   \n",
       "3  0679728740:mccarthy,_a_brave_writer_with_an_in...  0679728740   \n",
       "4  0679728740:sevierville_in_child_of_god:alex_jo...  0679728740   \n",
       "\n",
       "                                        product_name product_type   helpful  \\\n",
       "0  Manual pedi�trico para los due�os del nuevo be...        books    7 of 8   \n",
       "1               Child of God: Books: Cormac Mccarthy        books    0 of 1   \n",
       "2               Child of God: Books: Cormac Mccarthy        books    2 of 5   \n",
       "3               Child of God: Books: Cormac Mccarthy        books    4 of 5   \n",
       "4               Child of God: Books: Cormac Mccarthy        books  11 of 14   \n",
       "\n",
       "  rating                                              title  \\\n",
       "0    5.0  A mainstay reference for Spanish-speaking home...   \n",
       "1    5.0               You want the necrophiliac to escape?   \n",
       "2    2.0                              Low brow and juvenile   \n",
       "3    5.0  McCarthy, a brave writer with an incredible co...   \n",
       "4    4.0                        SEVIERVILLE in Child of God   \n",
       "\n",
       "                 date                              reviewer  \\\n",
       "0       April 6, 2000                   Midwest Book Review   \n",
       "1    October 20, 2006                         Brian Asquith   \n",
       "2  September 26, 2006                          Bruce Miller   \n",
       "3       July 24, 2005  Christopher Davis \"Christopher E.D.\"   \n",
       "4   November 20, 2002                          Alex Johnson   \n",
       "\n",
       "                reviewer_location  \\\n",
       "0                  Oregon, WI USA   \n",
       "1                                   \n",
       "2  Shippensburg, PA United States   \n",
       "3                   Cleveland, MS   \n",
       "4          Sevierville, Tennessee   \n",
       "\n",
       "                                         review_text  \n",
       "0  This all-Spanish handbook for parents with new...  \n",
       "1  McCarthy's writing and portrayal of Lester Bal...  \n",
       "2  Do you giggle uncontrollably when poking corps...  \n",
       "3  I was initiated into the world of Cormac McCar...  \n",
       "4  I cannot speak to the literary points in the n...  "
      ]
     },
     "execution_count": 26,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('book_dataset.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>unique_id</th>\n",
       "      <th>asin</th>\n",
       "      <th>product_name</th>\n",
       "      <th>product_type</th>\n",
       "      <th>helpful</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer</th>\n",
       "      <th>reviewer_location</th>\n",
       "      <th>review_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>1884956068:a_mainstay_reference_for_spanish-sp...</td>\n",
       "      <td>1884956068</td>\n",
       "      <td>Manual pedi�trico para los due�os del nuevo be...</td>\n",
       "      <td>books</td>\n",
       "      <td>7 of 8</td>\n",
       "      <td>5.0</td>\n",
       "      <td>A mainstay reference for Spanish-speaking home...</td>\n",
       "      <td>April 6, 2000</td>\n",
       "      <td>Midwest Book Review</td>\n",
       "      <td>Oregon, WI USA</td>\n",
       "      <td>This all-Spanish handbook for parents with new...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>0679728740:you_want_the_necrophiliac_to_escape...</td>\n",
       "      <td>0679728740</td>\n",
       "      <td>Child of God: Books: Cormac Mccarthy</td>\n",
       "      <td>books</td>\n",
       "      <td>0 of 1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>You want the necrophiliac to escape?</td>\n",
       "      <td>October 20, 2006</td>\n",
       "      <td>Brian Asquith</td>\n",
       "      <td></td>\n",
       "      <td>McCarthy's writing and portrayal of Lester Bal...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>0679728740:low_brow_and_juvenile:bruce_miller</td>\n",
       "      <td>0679728740</td>\n",
       "      <td>Child of God: Books: Cormac Mccarthy</td>\n",
       "      <td>books</td>\n",
       "      <td>2 of 5</td>\n",
       "      <td>2.0</td>\n",
       "      <td>Low brow and juvenile</td>\n",
       "      <td>September 26, 2006</td>\n",
       "      <td>Bruce Miller</td>\n",
       "      <td>Shippensburg, PA United States</td>\n",
       "      <td>Do you giggle uncontrollably when poking corps...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0679728740:mccarthy,_a_brave_writer_with_an_in...</td>\n",
       "      <td>0679728740</td>\n",
       "      <td>Child of God: Books: Cormac Mccarthy</td>\n",
       "      <td>books</td>\n",
       "      <td>4 of 5</td>\n",
       "      <td>5.0</td>\n",
       "      <td>McCarthy, a brave writer with an incredible co...</td>\n",
       "      <td>July 24, 2005</td>\n",
       "      <td>Christopher Davis \"Christopher E.D.\"</td>\n",
       "      <td>Cleveland, MS</td>\n",
       "      <td>I was initiated into the world of Cormac McCar...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>0679728740:sevierville_in_child_of_god:alex_jo...</td>\n",
       "      <td>0679728740</td>\n",
       "      <td>Child of God: Books: Cormac Mccarthy</td>\n",
       "      <td>books</td>\n",
       "      <td>11 of 14</td>\n",
       "      <td>4.0</td>\n",
       "      <td>SEVIERVILLE in Child of God</td>\n",
       "      <td>November 20, 2002</td>\n",
       "      <td>Alex Johnson</td>\n",
       "      <td>Sevierville, Tennessee</td>\n",
       "      <td>I cannot speak to the literary points in the n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41995</td>\n",
       "      <td>0972894403:that's_it!:terrie_cash</td>\n",
       "      <td>0972894403</td>\n",
       "      <td>Open Your Mind, Open Your Heart: Books: W. Mar...</td>\n",
       "      <td>books</td>\n",
       "      <td></td>\n",
       "      <td>5.0</td>\n",
       "      <td>That's it!</td>\n",
       "      <td>May 10, 2004</td>\n",
       "      <td>Terrie Cash</td>\n",
       "      <td>USA</td>\n",
       "      <td>In reading this book, I traveled on a wonderfu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41996</td>\n",
       "      <td>0972894403:open_your_heart,_open_your_mind:hel...</td>\n",
       "      <td>0972894403</td>\n",
       "      <td>Open Your Mind, Open Your Heart: Books: W. Mar...</td>\n",
       "      <td>books</td>\n",
       "      <td></td>\n",
       "      <td>5.0</td>\n",
       "      <td>Open Your Heart, Open Your Mind</td>\n",
       "      <td>January 13, 2004</td>\n",
       "      <td>helen bellanger</td>\n",
       "      <td>apo, ap United States</td>\n",
       "      <td>This wonderful book touches the inner soul.You...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41997</td>\n",
       "      <td>0972894403:living_god's_will:patricia_newsome</td>\n",
       "      <td>0972894403</td>\n",
       "      <td>Open Your Mind, Open Your Heart: Books: W. Mar...</td>\n",
       "      <td>books</td>\n",
       "      <td>1 of 1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Living God's Will</td>\n",
       "      <td>January 8, 2004</td>\n",
       "      <td>Patricia Newsome</td>\n",
       "      <td>USA</td>\n",
       "      <td>I am a 45 year old woman who has been on a que...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41998</td>\n",
       "      <td>0972894403:it_is_a_blessing:michael_abney,_sr.</td>\n",
       "      <td>0972894403</td>\n",
       "      <td>Open Your Mind, Open Your Heart: Books: W. Mar...</td>\n",
       "      <td>books</td>\n",
       "      <td></td>\n",
       "      <td>5.0</td>\n",
       "      <td>It is a Blessing</td>\n",
       "      <td>January 7, 2004</td>\n",
       "      <td>Michael Abney, Sr.</td>\n",
       "      <td></td>\n",
       "      <td>It is written that you should hide the Word of...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41999</td>\n",
       "      <td>0830833900:called_to_monday:r._eberz</td>\n",
       "      <td>0830833900</td>\n",
       "      <td>Loving Monday: Succeeding in Business Without ...</td>\n",
       "      <td>books</td>\n",
       "      <td>2 of 2</td>\n",
       "      <td>4.0</td>\n",
       "      <td>Called to Monday</td>\n",
       "      <td>November 20, 2005</td>\n",
       "      <td>R. Eberz</td>\n",
       "      <td>Beijing, PRC</td>\n",
       "      <td>John Beckett has the feel of an average guy th...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>42000 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               unique_id        asin  \\\n",
       "0      1884956068:a_mainstay_reference_for_spanish-sp...  1884956068   \n",
       "1      0679728740:you_want_the_necrophiliac_to_escape...  0679728740   \n",
       "2          0679728740:low_brow_and_juvenile:bruce_miller  0679728740   \n",
       "3      0679728740:mccarthy,_a_brave_writer_with_an_in...  0679728740   \n",
       "4      0679728740:sevierville_in_child_of_god:alex_jo...  0679728740   \n",
       "...                                                  ...         ...   \n",
       "41995                  0972894403:that's_it!:terrie_cash  0972894403   \n",
       "41996  0972894403:open_your_heart,_open_your_mind:hel...  0972894403   \n",
       "41997      0972894403:living_god's_will:patricia_newsome  0972894403   \n",
       "41998     0972894403:it_is_a_blessing:michael_abney,_sr.  0972894403   \n",
       "41999               0830833900:called_to_monday:r._eberz  0830833900   \n",
       "\n",
       "                                            product_name product_type  \\\n",
       "0      Manual pedi�trico para los due�os del nuevo be...        books   \n",
       "1                   Child of God: Books: Cormac Mccarthy        books   \n",
       "2                   Child of God: Books: Cormac Mccarthy        books   \n",
       "3                   Child of God: Books: Cormac Mccarthy        books   \n",
       "4                   Child of God: Books: Cormac Mccarthy        books   \n",
       "...                                                  ...          ...   \n",
       "41995  Open Your Mind, Open Your Heart: Books: W. Mar...        books   \n",
       "41996  Open Your Mind, Open Your Heart: Books: W. Mar...        books   \n",
       "41997  Open Your Mind, Open Your Heart: Books: W. Mar...        books   \n",
       "41998  Open Your Mind, Open Your Heart: Books: W. Mar...        books   \n",
       "41999  Loving Monday: Succeeding in Business Without ...        books   \n",
       "\n",
       "        helpful rating                                              title  \\\n",
       "0        7 of 8    5.0  A mainstay reference for Spanish-speaking home...   \n",
       "1        0 of 1    5.0               You want the necrophiliac to escape?   \n",
       "2        2 of 5    2.0                              Low brow and juvenile   \n",
       "3        4 of 5    5.0  McCarthy, a brave writer with an incredible co...   \n",
       "4      11 of 14    4.0                        SEVIERVILLE in Child of God   \n",
       "...         ...    ...                                                ...   \n",
       "41995              5.0                                         That's it!   \n",
       "41996              5.0                    Open Your Heart, Open Your Mind   \n",
       "41997    1 of 1    5.0                                  Living God's Will   \n",
       "41998              5.0                                   It is a Blessing   \n",
       "41999    2 of 2    4.0                                   Called to Monday   \n",
       "\n",
       "                     date                              reviewer  \\\n",
       "0           April 6, 2000                   Midwest Book Review   \n",
       "1        October 20, 2006                         Brian Asquith   \n",
       "2      September 26, 2006                          Bruce Miller   \n",
       "3           July 24, 2005  Christopher Davis \"Christopher E.D.\"   \n",
       "4       November 20, 2002                          Alex Johnson   \n",
       "...                   ...                                   ...   \n",
       "41995        May 10, 2004                           Terrie Cash   \n",
       "41996    January 13, 2004                       helen bellanger   \n",
       "41997     January 8, 2004                      Patricia Newsome   \n",
       "41998     January 7, 2004                    Michael Abney, Sr.   \n",
       "41999   November 20, 2005                              R. Eberz   \n",
       "\n",
       "                    reviewer_location  \\\n",
       "0                      Oregon, WI USA   \n",
       "1                                       \n",
       "2      Shippensburg, PA United States   \n",
       "3                       Cleveland, MS   \n",
       "4              Sevierville, Tennessee   \n",
       "...                               ...   \n",
       "41995                             USA   \n",
       "41996           apo, ap United States   \n",
       "41997                             USA   \n",
       "41998                                   \n",
       "41999                    Beijing, PRC   \n",
       "\n",
       "                                             review_text  \n",
       "0      This all-Spanish handbook for parents with new...  \n",
       "1      McCarthy's writing and portrayal of Lester Bal...  \n",
       "2      Do you giggle uncontrollably when poking corps...  \n",
       "3      I was initiated into the world of Cormac McCar...  \n",
       "4      I cannot speak to the literary points in the n...  \n",
       "...                                                  ...  \n",
       "41995  In reading this book, I traveled on a wonderfu...  \n",
       "41996  This wonderful book touches the inner soul.You...  \n",
       "41997  I am a 45 year old woman who has been on a que...  \n",
       "41998  It is written that you should hide the Word of...  \n",
       "41999  John Beckett has the feel of an average guy th...  \n",
       "\n",
       "[42000 rows x 11 columns]"
      ]
     },
     "execution_count": 28,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "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>unique_id</th>\n",
       "      <th>asin</th>\n",
       "      <th>product_name</th>\n",
       "      <th>product_type</th>\n",
       "      <th>helpful</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer</th>\n",
       "      <th>reviewer_location</th>\n",
       "      <th>review_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>\\n0785758968:one_of_the_best_crichton_novels:j...</td>\n",
       "      <td>\\n0785758968\\n</td>\n",
       "      <td>\\nSphere: Books: Michael Crichton\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n0 of 1\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nOne of the best Crichton novels\\n</td>\n",
       "      <td>\\nJuly 1, 2006\\n</td>\n",
       "      <td>\\nJoseph M\\n</td>\n",
       "      <td>\\nColorado, USA\\n</td>\n",
       "      <td>\\nSphere by Michael Crichton is an excellant n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>\\n0452279550:the_medicine_of_the_future:wafa_r...</td>\n",
       "      <td>\\n0452279550\\n</td>\n",
       "      <td>\\nHealing from the Heart: A Leading Surgeon Co...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n34 of 41\\n</td>\n",
       "      <td>\\n4.0\\n</td>\n",
       "      <td>\\nThe Medicine of the Future\\n</td>\n",
       "      <td>\\nNovember 6, 2002\\n</td>\n",
       "      <td>\\nWafa Rashed\\n</td>\n",
       "      <td>\\nJabriya, KUWAIT\\n</td>\n",
       "      <td>\\nDr. Oz is an accomplished heart surgeon in t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>\\n1599620065:beautiful!:sarah_silva_\"sar\"\\n</td>\n",
       "      <td>\\n1599620065\\n</td>\n",
       "      <td>\\nMythology: DC Comics Art of Alex Ross 2007 C...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nBeautiful!\\n</td>\n",
       "      <td>\\nJune 13, 2006\\n</td>\n",
       "      <td>\\nSarah Silva \"Sar\"\\n</td>\n",
       "      <td>\\nSan Diego, CA USA\\n</td>\n",
       "      <td>\\nThe most gorgeous artwork in comic books. Co...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>\\n0743277724:for_lovers_of_robicheaux:g._rouss...</td>\n",
       "      <td>\\n0743277724\\n</td>\n",
       "      <td>\\nPegasus Descending: A Dave Robicheaux Novel ...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n1 of 1\\n</td>\n",
       "      <td>\\n4.0\\n</td>\n",
       "      <td>\\nFor lovers of Robicheaux\\n</td>\n",
       "      <td>\\nNovember 2, 2006\\n</td>\n",
       "      <td>\\nG. Rousseau\\n</td>\n",
       "      <td>\\nFinistere, France\\n</td>\n",
       "      <td>\\nThis book is for lovers of Robicheaux.  His ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>\\n061318114X:excellent_and_broad_survey_of_the...</td>\n",
       "      <td>\\n061318114X\\n</td>\n",
       "      <td>\\nGuns, Germs, and Steel: The Fates of Human S...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n7 of 9\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nExcellent and broad survey of the developmen...</td>\n",
       "      <td>\\nOctober 6, 2006\\n</td>\n",
       "      <td>\\nPatrick D. Goonan \"www.meaningful-life.us\"\\n</td>\n",
       "      <td>\\nPleasanton, CA\\n</td>\n",
       "      <td>\\nThis is going to be a short and sweet review...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>995</td>\n",
       "      <td>\\n0618256288:interesting_and_educational_and_c...</td>\n",
       "      <td>\\n0618256288\\n</td>\n",
       "      <td>\\nWhat Do You Do with a Tail Like This? (Calde...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n8 of 9\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nInteresting and educational and children LOV...</td>\n",
       "      <td>\\nJuly 24, 2005\\n</td>\n",
       "      <td>\\nAidan's Mom\\n</td>\n",
       "      <td>\\nAtlanta, Georgia\\n</td>\n",
       "      <td>\\nBoth of my boys love this book and request i...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>\\n0152024867:best_book_for_teaching_children_a...</td>\n",
       "      <td>\\n0152024867\\n</td>\n",
       "      <td>\\nThe Shaman's Apprentice: A Tale of the Amazo...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n9 of 9\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nBest book for teaching children about people...</td>\n",
       "      <td>\\nJuly 30, 1998\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\n\"The Shaman's Apprentice\" presents more info...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>\\n1565843584:fascinating_look_at_america_50_ye...</td>\n",
       "      <td>\\n1565843584\\n</td>\n",
       "      <td>\\nInside U.S.A: Books: John Gunther\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n4 of 4\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nFascinating look at America 50 years ago\\n</td>\n",
       "      <td>\\nMarch 17, 1998\\n</td>\n",
       "      <td>\\nMichael B. Crutcher\\n</td>\n",
       "      <td>\\nLouisville, KY USA\\n</td>\n",
       "      <td>\\nJohn Gunther's INSIDE U.S.A. comes as close ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>\\n1580131581:it's_shofar_time!:jewish_book_wor...</td>\n",
       "      <td>\\n1580131581\\n</td>\n",
       "      <td>\\nIt's Shofar Time!: Books: Latifa Berry Kropf...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n1 of 1\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nIT'S SHOFAR TIME!\\n</td>\n",
       "      <td>\\nOctober 3, 2006\\n</td>\n",
       "      <td>\\nJewish Book World Magazine\\n</td>\n",
       "      <td>\\nNew York, NY\\n</td>\n",
       "      <td>\\nThis is the sixth and final addition to the ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>\\n0316059625:we_love_this_book!:m._little\\n</td>\n",
       "      <td>\\n0316059625\\n</td>\n",
       "      <td>\\nThe Peace Book: Books: Todd Parr\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\n5.0\\n</td>\n",
       "      <td>\\nWe Love This Book!\\n</td>\n",
       "      <td>\\nMarch 24, 2006\\n</td>\n",
       "      <td>\\nM. Little\\n</td>\n",
       "      <td>\\nBrunswick, MD\\n</td>\n",
       "      <td>\\nPretty much all of the Todd Parr books we've...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             unique_id            asin  \\\n",
       "0    \\n0785758968:one_of_the_best_crichton_novels:j...  \\n0785758968\\n   \n",
       "1    \\n0452279550:the_medicine_of_the_future:wafa_r...  \\n0452279550\\n   \n",
       "2          \\n1599620065:beautiful!:sarah_silva_\"sar\"\\n  \\n1599620065\\n   \n",
       "3    \\n0743277724:for_lovers_of_robicheaux:g._rouss...  \\n0743277724\\n   \n",
       "4    \\n061318114X:excellent_and_broad_survey_of_the...  \\n061318114X\\n   \n",
       "..                                                 ...             ...   \n",
       "995  \\n0618256288:interesting_and_educational_and_c...  \\n0618256288\\n   \n",
       "996  \\n0152024867:best_book_for_teaching_children_a...  \\n0152024867\\n   \n",
       "997  \\n1565843584:fascinating_look_at_america_50_ye...  \\n1565843584\\n   \n",
       "998  \\n1580131581:it's_shofar_time!:jewish_book_wor...  \\n1580131581\\n   \n",
       "999        \\n0316059625:we_love_this_book!:m._little\\n  \\n0316059625\\n   \n",
       "\n",
       "                                          product_name product_type  \\\n",
       "0                  \\nSphere: Books: Michael Crichton\\n    \\nbooks\\n   \n",
       "1    \\nHealing from the Heart: A Leading Surgeon Co...    \\nbooks\\n   \n",
       "2    \\nMythology: DC Comics Art of Alex Ross 2007 C...    \\nbooks\\n   \n",
       "3    \\nPegasus Descending: A Dave Robicheaux Novel ...    \\nbooks\\n   \n",
       "4    \\nGuns, Germs, and Steel: The Fates of Human S...    \\nbooks\\n   \n",
       "..                                                 ...          ...   \n",
       "995  \\nWhat Do You Do with a Tail Like This? (Calde...    \\nbooks\\n   \n",
       "996  \\nThe Shaman's Apprentice: A Tale of the Amazo...    \\nbooks\\n   \n",
       "997              \\nInside U.S.A: Books: John Gunther\\n    \\nbooks\\n   \n",
       "998  \\nIt's Shofar Time!: Books: Latifa Berry Kropf...    \\nbooks\\n   \n",
       "999               \\nThe Peace Book: Books: Todd Parr\\n    \\nbooks\\n   \n",
       "\n",
       "          helpful   rating                                              title  \\\n",
       "0      \\n0 of 1\\n  \\n5.0\\n                \\nOne of the best Crichton novels\\n   \n",
       "1    \\n34 of 41\\n  \\n4.0\\n                     \\nThe Medicine of the Future\\n   \n",
       "2            \\n\\n  \\n5.0\\n                                     \\nBeautiful!\\n   \n",
       "3      \\n1 of 1\\n  \\n4.0\\n                       \\nFor lovers of Robicheaux\\n   \n",
       "4      \\n7 of 9\\n  \\n5.0\\n  \\nExcellent and broad survey of the developmen...   \n",
       "..            ...      ...                                                ...   \n",
       "995    \\n8 of 9\\n  \\n5.0\\n  \\nInteresting and educational and children LOV...   \n",
       "996    \\n9 of 9\\n  \\n5.0\\n  \\nBest book for teaching children about people...   \n",
       "997    \\n4 of 4\\n  \\n5.0\\n       \\nFascinating look at America 50 years ago\\n   \n",
       "998    \\n1 of 1\\n  \\n5.0\\n                              \\nIT'S SHOFAR TIME!\\n   \n",
       "999          \\n\\n  \\n5.0\\n                             \\nWe Love This Book!\\n   \n",
       "\n",
       "                     date                                        reviewer  \\\n",
       "0        \\nJuly 1, 2006\\n                                    \\nJoseph M\\n   \n",
       "1    \\nNovember 6, 2002\\n                                 \\nWafa Rashed\\n   \n",
       "2       \\nJune 13, 2006\\n                           \\nSarah Silva \"Sar\"\\n   \n",
       "3    \\nNovember 2, 2006\\n                                 \\nG. Rousseau\\n   \n",
       "4     \\nOctober 6, 2006\\n  \\nPatrick D. Goonan \"www.meaningful-life.us\"\\n   \n",
       "..                    ...                                             ...   \n",
       "995     \\nJuly 24, 2005\\n                                 \\nAidan's Mom\\n   \n",
       "996     \\nJuly 30, 1998\\n                                            \\n\\n   \n",
       "997    \\nMarch 17, 1998\\n                         \\nMichael B. Crutcher\\n   \n",
       "998   \\nOctober 3, 2006\\n                  \\nJewish Book World Magazine\\n   \n",
       "999    \\nMarch 24, 2006\\n                                   \\nM. Little\\n   \n",
       "\n",
       "          reviewer_location                                        review_text  \n",
       "0         \\nColorado, USA\\n  \\nSphere by Michael Crichton is an excellant n...  \n",
       "1       \\nJabriya, KUWAIT\\n  \\nDr. Oz is an accomplished heart surgeon in t...  \n",
       "2     \\nSan Diego, CA USA\\n  \\nThe most gorgeous artwork in comic books. Co...  \n",
       "3     \\nFinistere, France\\n  \\nThis book is for lovers of Robicheaux.  His ...  \n",
       "4        \\nPleasanton, CA\\n  \\nThis is going to be a short and sweet review...  \n",
       "..                      ...                                                ...  \n",
       "995    \\nAtlanta, Georgia\\n  \\nBoth of my boys love this book and request i...  \n",
       "996                    \\n\\n  \\n\"The Shaman's Apprentice\" presents more info...  \n",
       "997  \\nLouisville, KY USA\\n  \\nJohn Gunther's INSIDE U.S.A. comes as close ...  \n",
       "998        \\nNew York, NY\\n  \\nThis is the sixth and final addition to the ...  \n",
       "999       \\nBrunswick, MD\\n  \\nPretty much all of the Todd Parr books we've...  \n",
       "\n",
       "[1000 rows x 11 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import xml.etree.ElementTree as Xet\n",
    "import pandas as pd\n",
    "\n",
    "cols = [\"unique_id\", \"asin\", \"product_name\", \"product_type\", \"helpful\", \"rating\", \n",
    "        \"title\", \"date\", \"reviewer\", \"reviewer_location\", \"review_text\"]\n",
    "rows = []\n",
    "\n",
    "# Parsing the XML file\n",
    "xmlparse = Xet.parse('positive_review.xml')\n",
    "root = xmlparse.getroot()\n",
    "for i in root:\n",
    "    unique_id = i.find(\"unique_id\").text\n",
    "    asin = i.find(\"asin\").text\n",
    "    product_name = i.find(\"product_name\").text\n",
    "    product_type = i.find(\"product_type\").text\n",
    "    helpful = i.find(\"helpful\").text\n",
    "    rating = i.find(\"rating\").text\n",
    "    title = i.find(\"title\").text\n",
    "    date = i.find(\"date\").text\n",
    "    reviewer = i.find(\"reviewer\").text\n",
    "    reviewer_location = i.find(\"reviewer_location\").text\n",
    "    review_text = i.find(\"review_text\").text\n",
    "\n",
    "\n",
    "    rows.append({\"unique_id\": unique_id,\n",
    "                 \"asin\": asin,\n",
    "                 \"product_name\": product_name,\n",
    "                 \"product_type\": product_type,\n",
    "                 \"helpful\": helpful,\n",
    "                 \"rating\": rating,\n",
    "                 \"title\": title,\n",
    "                 \"date\": date,\n",
    "                 \"reviewer\": reviewer,\n",
    "                 \"reviewer_location\": reviewer_location,\n",
    "                 \"review_text\": review_text\n",
    "                })\n",
    "\n",
    "df = pd.DataFrame(rows, columns=cols)\n",
    "\n",
    "# Writing dataframe to csv\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['unique_id']=df['unique_id'].apply(str).str.replace('\\n','')\n",
    "df['asin']=df['asin'].apply(str).str.replace('\\n','')\n",
    "df['product_name']=df['product_name'].apply(str).str.replace('\\n','')\n",
    "df['product_type']=df['product_type'].apply(str).str.replace('\\n','')\n",
    "df['helpful']=df['helpful'].apply(str).str.replace('\\n','')\n",
    "df['rating']=df['rating'].apply(str).str.replace('\\n','')\n",
    "df['title']=df['title'].apply(str).str.replace('\\n','')\n",
    "df['date']=df['date'].apply(str).str.replace('\\n','')\n",
    "df['reviewer']=df['reviewer'].apply(str).str.replace('\\n','')\n",
    "df['reviewer_location']=df['reviewer_location'].apply(str).str.replace('\\n','')\n",
    "df['review_text']=df['review_text'].apply(str).str.replace('\\n','')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "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>unique_id</th>\n",
       "      <th>asin</th>\n",
       "      <th>product_name</th>\n",
       "      <th>product_type</th>\n",
       "      <th>helpful</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer</th>\n",
       "      <th>reviewer_location</th>\n",
       "      <th>review_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0785758968:one_of_the_best_crichton_novels:jos...</td>\n",
       "      <td>0785758968</td>\n",
       "      <td>Sphere: Books: Michael Crichton</td>\n",
       "      <td>books</td>\n",
       "      <td>0 of 1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>One of the best Crichton novels</td>\n",
       "      <td>July 1, 2006</td>\n",
       "      <td>Joseph M</td>\n",
       "      <td>Colorado, USA</td>\n",
       "      <td>Sphere by Michael Crichton is an excellant nov...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>0452279550:the_medicine_of_the_future:wafa_rashed</td>\n",
       "      <td>0452279550</td>\n",
       "      <td>Healing from the Heart: A Leading Surgeon Comb...</td>\n",
       "      <td>books</td>\n",
       "      <td>34 of 41</td>\n",
       "      <td>4.0</td>\n",
       "      <td>The Medicine of the Future</td>\n",
       "      <td>November 6, 2002</td>\n",
       "      <td>Wafa Rashed</td>\n",
       "      <td>Jabriya, KUWAIT</td>\n",
       "      <td>Dr. Oz is an accomplished heart surgeon in the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>1599620065:beautiful!:sarah_silva_\"sar\"</td>\n",
       "      <td>1599620065</td>\n",
       "      <td>Mythology: DC Comics Art of Alex Ross 2007 Cal...</td>\n",
       "      <td>books</td>\n",
       "      <td></td>\n",
       "      <td>5.0</td>\n",
       "      <td>Beautiful!</td>\n",
       "      <td>June 13, 2006</td>\n",
       "      <td>Sarah Silva \"Sar\"</td>\n",
       "      <td>San Diego, CA USA</td>\n",
       "      <td>The most gorgeous artwork in comic books. Cont...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>0743277724:for_lovers_of_robicheaux:g._rousseau</td>\n",
       "      <td>0743277724</td>\n",
       "      <td>Pegasus Descending: A Dave Robicheaux Novel (D...</td>\n",
       "      <td>books</td>\n",
       "      <td>1 of 1</td>\n",
       "      <td>4.0</td>\n",
       "      <td>For lovers of Robicheaux</td>\n",
       "      <td>November 2, 2006</td>\n",
       "      <td>G. Rousseau</td>\n",
       "      <td>Finistere, France</td>\n",
       "      <td>This book is for lovers of Robicheaux.  His de...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>061318114X:excellent_and_broad_survey_of_the_d...</td>\n",
       "      <td>061318114X</td>\n",
       "      <td>Guns, Germs, and Steel: The Fates of Human Soc...</td>\n",
       "      <td>books</td>\n",
       "      <td>7 of 9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Excellent and broad survey of the development ...</td>\n",
       "      <td>October 6, 2006</td>\n",
       "      <td>Patrick D. Goonan \"www.meaningful-life.us\"</td>\n",
       "      <td>Pleasanton, CA</td>\n",
       "      <td>This is going to be a short and sweet review b...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>995</td>\n",
       "      <td>0618256288:interesting_and_educational_and_chi...</td>\n",
       "      <td>0618256288</td>\n",
       "      <td>What Do You Do with a Tail Like This? (Caldeco...</td>\n",
       "      <td>books</td>\n",
       "      <td>8 of 9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Interesting and educational and children LOVE IT!</td>\n",
       "      <td>July 24, 2005</td>\n",
       "      <td>Aidan's Mom</td>\n",
       "      <td>Atlanta, Georgia</td>\n",
       "      <td>Both of my boys love this book and request it ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>0152024867:best_book_for_teaching_children_abo...</td>\n",
       "      <td>0152024867</td>\n",
       "      <td>The Shaman's Apprentice: A Tale of the Amazon ...</td>\n",
       "      <td>books</td>\n",
       "      <td>9 of 9</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Best book for teaching children about people a...</td>\n",
       "      <td>July 30, 1998</td>\n",
       "      <td></td>\n",
       "      <td></td>\n",
       "      <td>\"The Shaman's Apprentice\" presents more inform...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>1565843584:fascinating_look_at_america_50_year...</td>\n",
       "      <td>1565843584</td>\n",
       "      <td>Inside U.S.A: Books: John Gunther</td>\n",
       "      <td>books</td>\n",
       "      <td>4 of 4</td>\n",
       "      <td>5.0</td>\n",
       "      <td>Fascinating look at America 50 years ago</td>\n",
       "      <td>March 17, 1998</td>\n",
       "      <td>Michael B. Crutcher</td>\n",
       "      <td>Louisville, KY USA</td>\n",
       "      <td>John Gunther's INSIDE U.S.A. comes as close to...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>1580131581:it's_shofar_time!:jewish_book_world...</td>\n",
       "      <td>1580131581</td>\n",
       "      <td>It's Shofar Time!: Books: Latifa Berry Kropf,T...</td>\n",
       "      <td>books</td>\n",
       "      <td>1 of 1</td>\n",
       "      <td>5.0</td>\n",
       "      <td>IT'S SHOFAR TIME!</td>\n",
       "      <td>October 3, 2006</td>\n",
       "      <td>Jewish Book World Magazine</td>\n",
       "      <td>New York, NY</td>\n",
       "      <td>This is the sixth and final addition to the au...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>0316059625:we_love_this_book!:m._little</td>\n",
       "      <td>0316059625</td>\n",
       "      <td>The Peace Book: Books: Todd Parr</td>\n",
       "      <td>books</td>\n",
       "      <td></td>\n",
       "      <td>5.0</td>\n",
       "      <td>We Love This Book!</td>\n",
       "      <td>March 24, 2006</td>\n",
       "      <td>M. Little</td>\n",
       "      <td>Brunswick, MD</td>\n",
       "      <td>Pretty much all of the Todd Parr books we've r...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             unique_id        asin  \\\n",
       "0    0785758968:one_of_the_best_crichton_novels:jos...  0785758968   \n",
       "1    0452279550:the_medicine_of_the_future:wafa_rashed  0452279550   \n",
       "2              1599620065:beautiful!:sarah_silva_\"sar\"  1599620065   \n",
       "3      0743277724:for_lovers_of_robicheaux:g._rousseau  0743277724   \n",
       "4    061318114X:excellent_and_broad_survey_of_the_d...  061318114X   \n",
       "..                                                 ...         ...   \n",
       "995  0618256288:interesting_and_educational_and_chi...  0618256288   \n",
       "996  0152024867:best_book_for_teaching_children_abo...  0152024867   \n",
       "997  1565843584:fascinating_look_at_america_50_year...  1565843584   \n",
       "998  1580131581:it's_shofar_time!:jewish_book_world...  1580131581   \n",
       "999            0316059625:we_love_this_book!:m._little  0316059625   \n",
       "\n",
       "                                          product_name product_type   helpful  \\\n",
       "0                      Sphere: Books: Michael Crichton        books    0 of 1   \n",
       "1    Healing from the Heart: A Leading Surgeon Comb...        books  34 of 41   \n",
       "2    Mythology: DC Comics Art of Alex Ross 2007 Cal...        books             \n",
       "3    Pegasus Descending: A Dave Robicheaux Novel (D...        books    1 of 1   \n",
       "4    Guns, Germs, and Steel: The Fates of Human Soc...        books    7 of 9   \n",
       "..                                                 ...          ...       ...   \n",
       "995  What Do You Do with a Tail Like This? (Caldeco...        books    8 of 9   \n",
       "996  The Shaman's Apprentice: A Tale of the Amazon ...        books    9 of 9   \n",
       "997                  Inside U.S.A: Books: John Gunther        books    4 of 4   \n",
       "998  It's Shofar Time!: Books: Latifa Berry Kropf,T...        books    1 of 1   \n",
       "999                   The Peace Book: Books: Todd Parr        books             \n",
       "\n",
       "    rating                                              title  \\\n",
       "0      5.0                    One of the best Crichton novels   \n",
       "1      4.0                         The Medicine of the Future   \n",
       "2      5.0                                         Beautiful!   \n",
       "3      4.0                           For lovers of Robicheaux   \n",
       "4      5.0  Excellent and broad survey of the development ...   \n",
       "..     ...                                                ...   \n",
       "995    5.0  Interesting and educational and children LOVE IT!   \n",
       "996    5.0  Best book for teaching children about people a...   \n",
       "997    5.0           Fascinating look at America 50 years ago   \n",
       "998    5.0                                  IT'S SHOFAR TIME!   \n",
       "999    5.0                                 We Love This Book!   \n",
       "\n",
       "                 date                                    reviewer  \\\n",
       "0        July 1, 2006                                    Joseph M   \n",
       "1    November 6, 2002                                 Wafa Rashed   \n",
       "2       June 13, 2006                           Sarah Silva \"Sar\"   \n",
       "3    November 2, 2006                                 G. Rousseau   \n",
       "4     October 6, 2006  Patrick D. Goonan \"www.meaningful-life.us\"   \n",
       "..                ...                                         ...   \n",
       "995     July 24, 2005                                 Aidan's Mom   \n",
       "996     July 30, 1998                                               \n",
       "997    March 17, 1998                         Michael B. Crutcher   \n",
       "998   October 3, 2006                  Jewish Book World Magazine   \n",
       "999    March 24, 2006                                   M. Little   \n",
       "\n",
       "      reviewer_location                                        review_text  \n",
       "0         Colorado, USA  Sphere by Michael Crichton is an excellant nov...  \n",
       "1       Jabriya, KUWAIT  Dr. Oz is an accomplished heart surgeon in the...  \n",
       "2     San Diego, CA USA  The most gorgeous artwork in comic books. Cont...  \n",
       "3     Finistere, France  This book is for lovers of Robicheaux.  His de...  \n",
       "4        Pleasanton, CA  This is going to be a short and sweet review b...  \n",
       "..                  ...                                                ...  \n",
       "995    Atlanta, Georgia  Both of my boys love this book and request it ...  \n",
       "996                      \"The Shaman's Apprentice\" presents more inform...  \n",
       "997  Louisville, KY USA  John Gunther's INSIDE U.S.A. comes as close to...  \n",
       "998        New York, NY  This is the sixth and final addition to the au...  \n",
       "999       Brunswick, MD  Pretty much all of the Todd Parr books we've r...  \n",
       "\n",
       "[1000 rows x 11 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('positive_review.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 39,
   "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>unique_id</th>\n",
       "      <th>asin</th>\n",
       "      <th>product_name</th>\n",
       "      <th>product_type</th>\n",
       "      <th>helpful</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer</th>\n",
       "      <th>reviewer_location</th>\n",
       "      <th>review_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>\\n0312355645:horrible_book,_horrible.:mark_gos...</td>\n",
       "      <td>\\n0312355645\\n</td>\n",
       "      <td>\\nRunning with Scissors: A Memoir: Books: Augu...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n4 of 9\\n</td>\n",
       "      <td>\\n1.0\\n</td>\n",
       "      <td>\\nHorrible book, horrible.\\n</td>\n",
       "      <td>\\nNovember 14, 2006\\n</td>\n",
       "      <td>\\nMark Gospri\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\nTHis book was horrible.  If it was possible ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>\\n1559278676:shallow_self-indulgence:joseph_s....</td>\n",
       "      <td>\\n1559278676\\n</td>\n",
       "      <td>\\nRunning with Scissors: A Memoir: Books: Augu...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n1 of 6\\n</td>\n",
       "      <td>\\n1.0\\n</td>\n",
       "      <td>\\nshallow self-indulgence\\n</td>\n",
       "      <td>\\nNovember 15, 2006\\n</td>\n",
       "      <td>\\nJoseph S. Perrott \"avid reader\"\\n</td>\n",
       "      <td>\\nphiladelphia, pa. United States\\n</td>\n",
       "      <td>\\nI like to use the Amazon reviews when purcha...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>\\n1559278676:horrible_book,_horrible.:mark_gos...</td>\n",
       "      <td>\\n1559278676\\n</td>\n",
       "      <td>\\nRunning with Scissors: A Memoir: Books: Augu...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n4 of 9\\n</td>\n",
       "      <td>\\n1.0\\n</td>\n",
       "      <td>\\nHorrible book, horrible.\\n</td>\n",
       "      <td>\\nNovember 14, 2006\\n</td>\n",
       "      <td>\\nMark Gospri\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\nTHis book was horrible.  If it was possible ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>\\n0425193373:disappointment:reader_\"reader\"\\n</td>\n",
       "      <td>\\n0425193373\\n</td>\n",
       "      <td>\\nFierce Conversations: Achieving Sucess at Wo...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n10 of 13\\n</td>\n",
       "      <td>\\n1.0\\n</td>\n",
       "      <td>\\nDisappointment\\n</td>\n",
       "      <td>\\nMarch 13, 2006\\n</td>\n",
       "      <td>\\nReader \"Reader\"\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\nI'm not sure who's writing these reviews, bu...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>\\n0142004030:a_disappointing_mess:a._ross\\n</td>\n",
       "      <td>\\n0142004030\\n</td>\n",
       "      <td>\\nLost in a Good Book (Thursday Next Novels): ...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n6 of 7\\n</td>\n",
       "      <td>\\n2.0\\n</td>\n",
       "      <td>\\nA Disappointing Mess\\n</td>\n",
       "      <td>\\nMay 17, 2006\\n</td>\n",
       "      <td>\\nA. Ross\\n</td>\n",
       "      <td>\\nWashington, DC\\n</td>\n",
       "      <td>\\nI picked up the first book in this series (T...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>995</td>\n",
       "      <td>\\n0385514573:a_nice_place_to_visit....:nina_sh...</td>\n",
       "      <td>\\n0385514573\\n</td>\n",
       "      <td>\\nDeadly Slipper: A Novel of Death in the Dord...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n5 of 10\\n</td>\n",
       "      <td>\\n2.0\\n</td>\n",
       "      <td>\\na nice place to visit....\\n</td>\n",
       "      <td>\\nFebruary 25, 2006\\n</td>\n",
       "      <td>\\nNina Shishkoff \"mycologist\"\\n</td>\n",
       "      <td>\\nMount Airy, MD\\n</td>\n",
       "      <td>\\nIf I had been an editor and received \"Deadly...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>996</td>\n",
       "      <td>\\n0385514573:boring:o._gonzalez\\n</td>\n",
       "      <td>\\n0385514573\\n</td>\n",
       "      <td>\\nDeadly Slipper: A Novel of Death in the Dord...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n2 of 3\\n</td>\n",
       "      <td>\\n1.0\\n</td>\n",
       "      <td>\\nboring\\n</td>\n",
       "      <td>\\nJuly 30, 2005\\n</td>\n",
       "      <td>\\nO. Gonzalez\\n</td>\n",
       "      <td>\\nAshburn, VA\\n</td>\n",
       "      <td>\\nThis book is very disappointing. The writing...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>997</td>\n",
       "      <td>\\n097160200X:lacking:m._roman_\"matt1234567\"\\n</td>\n",
       "      <td>\\n097160200X\\n</td>\n",
       "      <td>\\nSitting Pretty: Looking and Feeling Better W...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n7 of 7\\n</td>\n",
       "      <td>\\n1.0\\n</td>\n",
       "      <td>\\nLacking\\n</td>\n",
       "      <td>\\nMay 3, 2005\\n</td>\n",
       "      <td>\\nM. Roman \"matt1234567\"\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\nI was extremely disappointed by this book/pa...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>998</td>\n",
       "      <td>\\n1564147363:okay_for_ideas:stacy_e._burrell_\"...</td>\n",
       "      <td>\\n1564147363\\n</td>\n",
       "      <td>\\nThe 100 Best Businesses to Start When You Do...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n22 of 22\\n</td>\n",
       "      <td>\\n2.0\\n</td>\n",
       "      <td>\\nOkay for ideas\\n</td>\n",
       "      <td>\\nMarch 23, 2005\\n</td>\n",
       "      <td>\\nStacy E. Burrell \"Stacy's Blog (See stacybur...</td>\n",
       "      <td>\\nDetroit, MI USA\\n</td>\n",
       "      <td>\\nThis book is the typical package of business...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>999</td>\n",
       "      <td>\\n0312273193:it's_just_\"reefer_madness\"_:r._jo...</td>\n",
       "      <td>\\n0312273193\\n</td>\n",
       "      <td>\\nThe Hunting of the President: The Ten-Year C...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n8 of 62\\n</td>\n",
       "      <td>\\n1.0\\n</td>\n",
       "      <td>\\nIt's just \"Reefer Madness\" \\n</td>\n",
       "      <td>\\nAugust 13, 2004\\n</td>\n",
       "      <td>\\nR. Johns\\n</td>\n",
       "      <td>\\nCT\\n</td>\n",
       "      <td>\\nAnd you shouldn't inhale.\\nSeveral reviewers...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1000 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             unique_id            asin  \\\n",
       "0    \\n0312355645:horrible_book,_horrible.:mark_gos...  \\n0312355645\\n   \n",
       "1    \\n1559278676:shallow_self-indulgence:joseph_s....  \\n1559278676\\n   \n",
       "2    \\n1559278676:horrible_book,_horrible.:mark_gos...  \\n1559278676\\n   \n",
       "3        \\n0425193373:disappointment:reader_\"reader\"\\n  \\n0425193373\\n   \n",
       "4          \\n0142004030:a_disappointing_mess:a._ross\\n  \\n0142004030\\n   \n",
       "..                                                 ...             ...   \n",
       "995  \\n0385514573:a_nice_place_to_visit....:nina_sh...  \\n0385514573\\n   \n",
       "996                  \\n0385514573:boring:o._gonzalez\\n  \\n0385514573\\n   \n",
       "997      \\n097160200X:lacking:m._roman_\"matt1234567\"\\n  \\n097160200X\\n   \n",
       "998  \\n1564147363:okay_for_ideas:stacy_e._burrell_\"...  \\n1564147363\\n   \n",
       "999  \\n0312273193:it's_just_\"reefer_madness\"_:r._jo...  \\n0312273193\\n   \n",
       "\n",
       "                                          product_name product_type  \\\n",
       "0    \\nRunning with Scissors: A Memoir: Books: Augu...    \\nbooks\\n   \n",
       "1    \\nRunning with Scissors: A Memoir: Books: Augu...    \\nbooks\\n   \n",
       "2    \\nRunning with Scissors: A Memoir: Books: Augu...    \\nbooks\\n   \n",
       "3    \\nFierce Conversations: Achieving Sucess at Wo...    \\nbooks\\n   \n",
       "4    \\nLost in a Good Book (Thursday Next Novels): ...    \\nbooks\\n   \n",
       "..                                                 ...          ...   \n",
       "995  \\nDeadly Slipper: A Novel of Death in the Dord...    \\nbooks\\n   \n",
       "996  \\nDeadly Slipper: A Novel of Death in the Dord...    \\nbooks\\n   \n",
       "997  \\nSitting Pretty: Looking and Feeling Better W...    \\nbooks\\n   \n",
       "998  \\nThe 100 Best Businesses to Start When You Do...    \\nbooks\\n   \n",
       "999  \\nThe Hunting of the President: The Ten-Year C...    \\nbooks\\n   \n",
       "\n",
       "          helpful   rating                            title  \\\n",
       "0      \\n4 of 9\\n  \\n1.0\\n     \\nHorrible book, horrible.\\n   \n",
       "1      \\n1 of 6\\n  \\n1.0\\n      \\nshallow self-indulgence\\n   \n",
       "2      \\n4 of 9\\n  \\n1.0\\n     \\nHorrible book, horrible.\\n   \n",
       "3    \\n10 of 13\\n  \\n1.0\\n               \\nDisappointment\\n   \n",
       "4      \\n6 of 7\\n  \\n2.0\\n         \\nA Disappointing Mess\\n   \n",
       "..            ...      ...                              ...   \n",
       "995   \\n5 of 10\\n  \\n2.0\\n    \\na nice place to visit....\\n   \n",
       "996    \\n2 of 3\\n  \\n1.0\\n                       \\nboring\\n   \n",
       "997    \\n7 of 7\\n  \\n1.0\\n                      \\nLacking\\n   \n",
       "998  \\n22 of 22\\n  \\n2.0\\n               \\nOkay for ideas\\n   \n",
       "999   \\n8 of 62\\n  \\n1.0\\n  \\nIt's just \"Reefer Madness\" \\n   \n",
       "\n",
       "                      date                                           reviewer  \\\n",
       "0    \\nNovember 14, 2006\\n                                    \\nMark Gospri\\n   \n",
       "1    \\nNovember 15, 2006\\n                \\nJoseph S. Perrott \"avid reader\"\\n   \n",
       "2    \\nNovember 14, 2006\\n                                    \\nMark Gospri\\n   \n",
       "3       \\nMarch 13, 2006\\n                                \\nReader \"Reader\"\\n   \n",
       "4         \\nMay 17, 2006\\n                                        \\nA. Ross\\n   \n",
       "..                     ...                                                ...   \n",
       "995  \\nFebruary 25, 2006\\n                    \\nNina Shishkoff \"mycologist\"\\n   \n",
       "996      \\nJuly 30, 2005\\n                                    \\nO. Gonzalez\\n   \n",
       "997        \\nMay 3, 2005\\n                         \\nM. Roman \"matt1234567\"\\n   \n",
       "998     \\nMarch 23, 2005\\n  \\nStacy E. Burrell \"Stacy's Blog (See stacybur...   \n",
       "999    \\nAugust 13, 2004\\n                                       \\nR. Johns\\n   \n",
       "\n",
       "                       reviewer_location  \\\n",
       "0                                   \\n\\n   \n",
       "1    \\nphiladelphia, pa. United States\\n   \n",
       "2                                   \\n\\n   \n",
       "3                                   \\n\\n   \n",
       "4                     \\nWashington, DC\\n   \n",
       "..                                   ...   \n",
       "995                   \\nMount Airy, MD\\n   \n",
       "996                      \\nAshburn, VA\\n   \n",
       "997                                 \\n\\n   \n",
       "998                  \\nDetroit, MI USA\\n   \n",
       "999                               \\nCT\\n   \n",
       "\n",
       "                                           review_text  \n",
       "0    \\nTHis book was horrible.  If it was possible ...  \n",
       "1    \\nI like to use the Amazon reviews when purcha...  \n",
       "2    \\nTHis book was horrible.  If it was possible ...  \n",
       "3    \\nI'm not sure who's writing these reviews, bu...  \n",
       "4    \\nI picked up the first book in this series (T...  \n",
       "..                                                 ...  \n",
       "995  \\nIf I had been an editor and received \"Deadly...  \n",
       "996  \\nThis book is very disappointing. The writing...  \n",
       "997  \\nI was extremely disappointed by this book/pa...  \n",
       "998  \\nThis book is the typical package of business...  \n",
       "999  \\nAnd you shouldn't inhale.\\nSeveral reviewers...  \n",
       "\n",
       "[1000 rows x 11 columns]"
      ]
     },
     "execution_count": 39,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "import xml.etree.ElementTree as Xet\n",
    "import pandas as pd\n",
    "\n",
    "cols = [\"unique_id\", \"asin\", \"product_name\", \"product_type\", \"helpful\", \"rating\", \n",
    "        \"title\", \"date\", \"reviewer\", \"reviewer_location\", \"review_text\"]\n",
    "rows = []\n",
    "\n",
    "# Parsing the XML file\n",
    "xmlparse = Xet.parse('negative_review.xml')\n",
    "root = xmlparse.getroot()\n",
    "for i in root:\n",
    "    unique_id = i.find(\"unique_id\").text\n",
    "    asin = i.find(\"asin\").text\n",
    "    product_name = i.find(\"product_name\").text\n",
    "    product_type = i.find(\"product_type\").text\n",
    "    helpful = i.find(\"helpful\").text\n",
    "    rating = i.find(\"rating\").text\n",
    "    title = i.find(\"title\").text\n",
    "    date = i.find(\"date\").text\n",
    "    reviewer = i.find(\"reviewer\").text\n",
    "    reviewer_location = i.find(\"reviewer_location\").text\n",
    "    review_text = i.find(\"review_text\").text\n",
    "\n",
    "\n",
    "    rows.append({\"unique_id\": unique_id,\n",
    "                 \"asin\": asin,\n",
    "                 \"product_name\": product_name,\n",
    "                 \"product_type\": product_type,\n",
    "                 \"helpful\": helpful,\n",
    "                 \"rating\": rating,\n",
    "                 \"title\": title,\n",
    "                 \"date\": date,\n",
    "                 \"reviewer\": reviewer,\n",
    "                 \"reviewer_location\": reviewer_location,\n",
    "                 \"review_text\": review_text\n",
    "                })\n",
    "\n",
    "df = pd.DataFrame(rows, columns=cols)\n",
    "\n",
    "# Writing dataframe to csv\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 40,
   "metadata": {},
   "outputs": [],
   "source": [
    "df['unique_id']=df['unique_id'].apply(str).str.replace('\\n','')\n",
    "df['asin']=df['asin'].apply(str).str.replace('\\n','')\n",
    "df['product_name']=df['product_name'].apply(str).str.replace('\\n','')\n",
    "df['product_type']=df['product_type'].apply(str).str.replace('\\n','')\n",
    "df['helpful']=df['helpful'].apply(str).str.replace('\\n','')\n",
    "df['rating']=df['rating'].apply(str).str.replace('\\n','')\n",
    "df['title']=df['title'].apply(str).str.replace('\\n','')\n",
    "df['date']=df['date'].apply(str).str.replace('\\n','')\n",
    "df['reviewer']=df['reviewer'].apply(str).str.replace('\\n','')\n",
    "df['reviewer_location']=df['reviewer_location'].apply(str).str.replace('\\n','')\n",
    "df['review_text']=df['review_text'].apply(str).str.replace('\\n','')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv('negative_review.csv', index=False)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [],
   "source": [
    "df=pd.read_csv(\"books.csv\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>unique_id</th>\n",
       "      <th>asin</th>\n",
       "      <th>product_name</th>\n",
       "      <th>product_type</th>\n",
       "      <th>helpful</th>\n",
       "      <th>rating</th>\n",
       "      <th>title</th>\n",
       "      <th>date</th>\n",
       "      <th>reviewer</th>\n",
       "      <th>reviewer_location</th>\n",
       "      <th>review_text</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>\\n1884956068:a_mainstay_reference_for_spanish-...</td>\n",
       "      <td>\\n1884956068\\n</td>\n",
       "      <td>\\nManual pedi�trico para los due�os del nuevo ...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n7 of 8\\n</td>\n",
       "      <td>5.0</td>\n",
       "      <td>\\nA mainstay reference for Spanish-speaking ho...</td>\n",
       "      <td>\\nApril 6, 2000\\n</td>\n",
       "      <td>\\nMidwest Book Review\\n</td>\n",
       "      <td>\\nOregon, WI USA\\n</td>\n",
       "      <td>\\nThis all-Spanish handbook for parents with n...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>\\n0679728740:you_want_the_necrophiliac_to_esca...</td>\n",
       "      <td>\\n0679728740\\n</td>\n",
       "      <td>\\nChild of God: Books: Cormac Mccarthy\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n0 of 1\\n</td>\n",
       "      <td>5.0</td>\n",
       "      <td>\\nYou want the necrophiliac to escape?\\n</td>\n",
       "      <td>\\nOctober 20, 2006\\n</td>\n",
       "      <td>\\nBrian Asquith\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\nMcCarthy's writing and portrayal of Lester B...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>\\n0679728740:low_brow_and_juvenile:bruce_miller\\n</td>\n",
       "      <td>\\n0679728740\\n</td>\n",
       "      <td>\\nChild of God: Books: Cormac Mccarthy\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n2 of 5\\n</td>\n",
       "      <td>2.0</td>\n",
       "      <td>\\nLow brow and juvenile\\n</td>\n",
       "      <td>\\nSeptember 26, 2006\\n</td>\n",
       "      <td>\\nBruce Miller\\n</td>\n",
       "      <td>\\nShippensburg, PA United States\\n</td>\n",
       "      <td>\\nDo you giggle uncontrollably when poking cor...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>\\n0679728740:mccarthy,_a_brave_writer_with_an_...</td>\n",
       "      <td>\\n0679728740\\n</td>\n",
       "      <td>\\nChild of God: Books: Cormac Mccarthy\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n4 of 5\\n</td>\n",
       "      <td>5.0</td>\n",
       "      <td>\\nMcCarthy, a brave writer with an incredible ...</td>\n",
       "      <td>\\nJuly 24, 2005\\n</td>\n",
       "      <td>\\nChristopher Davis \"Christopher E.D.\"\\n</td>\n",
       "      <td>\\nCleveland, MS\\n</td>\n",
       "      <td>\\nI was initiated into the world of Cormac McC...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>4</td>\n",
       "      <td>4</td>\n",
       "      <td>\\n0679728740:sevierville_in_child_of_god:alex_...</td>\n",
       "      <td>\\n0679728740\\n</td>\n",
       "      <td>\\nChild of God: Books: Cormac Mccarthy\\n</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n11 of 14\\n</td>\n",
       "      <td>4.0</td>\n",
       "      <td>\\nSEVIERVILLE in Child of God\\n</td>\n",
       "      <td>\\nNovember 20, 2002\\n</td>\n",
       "      <td>\\nAlex Johnson\\n</td>\n",
       "      <td>\\nSevierville, Tennessee\\n</td>\n",
       "      <td>\\nI cannot speak to the literary points in the...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41995</td>\n",
       "      <td>41995</td>\n",
       "      <td>\\n0972894403:that's_it!:terrie_cash\\n</td>\n",
       "      <td>\\n0972894403\\n</td>\n",
       "      <td>\\nOpen Your Mind, Open Your Heart: Books: W. M...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>5.0</td>\n",
       "      <td>\\nThat's it!\\n</td>\n",
       "      <td>\\nMay 10, 2004\\n</td>\n",
       "      <td>\\nTerrie Cash\\n</td>\n",
       "      <td>\\nUSA\\n</td>\n",
       "      <td>\\nIn reading this book, I traveled on a wonder...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41996</td>\n",
       "      <td>41996</td>\n",
       "      <td>\\n0972894403:open_your_heart,_open_your_mind:h...</td>\n",
       "      <td>\\n0972894403\\n</td>\n",
       "      <td>\\nOpen Your Mind, Open Your Heart: Books: W. M...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>5.0</td>\n",
       "      <td>\\nOpen Your Heart, Open Your Mind\\n</td>\n",
       "      <td>\\nJanuary 13, 2004\\n</td>\n",
       "      <td>\\nhelen bellanger\\n</td>\n",
       "      <td>\\napo, ap United States\\n</td>\n",
       "      <td>\\nThis wonderful book touches the inner soul.Y...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41997</td>\n",
       "      <td>41997</td>\n",
       "      <td>\\n0972894403:living_god's_will:patricia_newsome\\n</td>\n",
       "      <td>\\n0972894403\\n</td>\n",
       "      <td>\\nOpen Your Mind, Open Your Heart: Books: W. M...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n1 of 1\\n</td>\n",
       "      <td>5.0</td>\n",
       "      <td>\\nLiving God's Will\\n</td>\n",
       "      <td>\\nJanuary 8, 2004\\n</td>\n",
       "      <td>\\nPatricia Newsome\\n</td>\n",
       "      <td>\\nUSA\\n</td>\n",
       "      <td>\\nI am a 45 year old woman who has been on a q...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41998</td>\n",
       "      <td>41998</td>\n",
       "      <td>\\n0972894403:it_is_a_blessing:michael_abney,_s...</td>\n",
       "      <td>\\n0972894403\\n</td>\n",
       "      <td>\\nOpen Your Mind, Open Your Heart: Books: W. M...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>5.0</td>\n",
       "      <td>\\nIt is a Blessing\\n</td>\n",
       "      <td>\\nJanuary 7, 2004\\n</td>\n",
       "      <td>\\nMichael Abney, Sr.\\n</td>\n",
       "      <td>\\n\\n</td>\n",
       "      <td>\\nIt is written that you should hide the Word ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <td>41999</td>\n",
       "      <td>41999</td>\n",
       "      <td>\\n0830833900:called_to_monday:r._eberz\\n</td>\n",
       "      <td>\\n0830833900\\n</td>\n",
       "      <td>\\nLoving Monday: Succeeding in Business Withou...</td>\n",
       "      <td>\\nbooks\\n</td>\n",
       "      <td>\\n2 of 2\\n</td>\n",
       "      <td>4.0</td>\n",
       "      <td>\\nCalled to Monday\\n</td>\n",
       "      <td>\\nNovember 20, 2005\\n</td>\n",
       "      <td>\\nR. Eberz\\n</td>\n",
       "      <td>\\nBeijing, PRC\\n</td>\n",
       "      <td>\\nJohn Beckett has the feel of an average guy ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>42000 rows × 12 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       Unnamed: 0                                          unique_id  \\\n",
       "0               0  \\n1884956068:a_mainstay_reference_for_spanish-...   \n",
       "1               1  \\n0679728740:you_want_the_necrophiliac_to_esca...   \n",
       "2               2  \\n0679728740:low_brow_and_juvenile:bruce_miller\\n   \n",
       "3               3  \\n0679728740:mccarthy,_a_brave_writer_with_an_...   \n",
       "4               4  \\n0679728740:sevierville_in_child_of_god:alex_...   \n",
       "...           ...                                                ...   \n",
       "41995       41995              \\n0972894403:that's_it!:terrie_cash\\n   \n",
       "41996       41996  \\n0972894403:open_your_heart,_open_your_mind:h...   \n",
       "41997       41997  \\n0972894403:living_god's_will:patricia_newsome\\n   \n",
       "41998       41998  \\n0972894403:it_is_a_blessing:michael_abney,_s...   \n",
       "41999       41999           \\n0830833900:called_to_monday:r._eberz\\n   \n",
       "\n",
       "                 asin                                       product_name  \\\n",
       "0      \\n1884956068\\n  \\nManual pedi�trico para los due�os del nuevo ...   \n",
       "1      \\n0679728740\\n           \\nChild of God: Books: Cormac Mccarthy\\n   \n",
       "2      \\n0679728740\\n           \\nChild of God: Books: Cormac Mccarthy\\n   \n",
       "3      \\n0679728740\\n           \\nChild of God: Books: Cormac Mccarthy\\n   \n",
       "4      \\n0679728740\\n           \\nChild of God: Books: Cormac Mccarthy\\n   \n",
       "...               ...                                                ...   \n",
       "41995  \\n0972894403\\n  \\nOpen Your Mind, Open Your Heart: Books: W. M...   \n",
       "41996  \\n0972894403\\n  \\nOpen Your Mind, Open Your Heart: Books: W. M...   \n",
       "41997  \\n0972894403\\n  \\nOpen Your Mind, Open Your Heart: Books: W. M...   \n",
       "41998  \\n0972894403\\n  \\nOpen Your Mind, Open Your Heart: Books: W. M...   \n",
       "41999  \\n0830833900\\n  \\nLoving Monday: Succeeding in Business Withou...   \n",
       "\n",
       "      product_type       helpful  rating  \\\n",
       "0        \\nbooks\\n    \\n7 of 8\\n     5.0   \n",
       "1        \\nbooks\\n    \\n0 of 1\\n     5.0   \n",
       "2        \\nbooks\\n    \\n2 of 5\\n     2.0   \n",
       "3        \\nbooks\\n    \\n4 of 5\\n     5.0   \n",
       "4        \\nbooks\\n  \\n11 of 14\\n     4.0   \n",
       "...            ...           ...     ...   \n",
       "41995    \\nbooks\\n          \\n\\n     5.0   \n",
       "41996    \\nbooks\\n          \\n\\n     5.0   \n",
       "41997    \\nbooks\\n    \\n1 of 1\\n     5.0   \n",
       "41998    \\nbooks\\n          \\n\\n     5.0   \n",
       "41999    \\nbooks\\n    \\n2 of 2\\n     4.0   \n",
       "\n",
       "                                                   title  \\\n",
       "0      \\nA mainstay reference for Spanish-speaking ho...   \n",
       "1               \\nYou want the necrophiliac to escape?\\n   \n",
       "2                              \\nLow brow and juvenile\\n   \n",
       "3      \\nMcCarthy, a brave writer with an incredible ...   \n",
       "4                        \\nSEVIERVILLE in Child of God\\n   \n",
       "...                                                  ...   \n",
       "41995                                     \\nThat's it!\\n   \n",
       "41996                \\nOpen Your Heart, Open Your Mind\\n   \n",
       "41997                              \\nLiving God's Will\\n   \n",
       "41998                               \\nIt is a Blessing\\n   \n",
       "41999                               \\nCalled to Monday\\n   \n",
       "\n",
       "                         date                                  reviewer  \\\n",
       "0           \\nApril 6, 2000\\n                   \\nMidwest Book Review\\n   \n",
       "1        \\nOctober 20, 2006\\n                         \\nBrian Asquith\\n   \n",
       "2      \\nSeptember 26, 2006\\n                          \\nBruce Miller\\n   \n",
       "3           \\nJuly 24, 2005\\n  \\nChristopher Davis \"Christopher E.D.\"\\n   \n",
       "4       \\nNovember 20, 2002\\n                          \\nAlex Johnson\\n   \n",
       "...                       ...                                       ...   \n",
       "41995        \\nMay 10, 2004\\n                           \\nTerrie Cash\\n   \n",
       "41996    \\nJanuary 13, 2004\\n                       \\nhelen bellanger\\n   \n",
       "41997     \\nJanuary 8, 2004\\n                      \\nPatricia Newsome\\n   \n",
       "41998     \\nJanuary 7, 2004\\n                    \\nMichael Abney, Sr.\\n   \n",
       "41999   \\nNovember 20, 2005\\n                              \\nR. Eberz\\n   \n",
       "\n",
       "                        reviewer_location  \\\n",
       "0                      \\nOregon, WI USA\\n   \n",
       "1                                    \\n\\n   \n",
       "2      \\nShippensburg, PA United States\\n   \n",
       "3                       \\nCleveland, MS\\n   \n",
       "4              \\nSevierville, Tennessee\\n   \n",
       "...                                   ...   \n",
       "41995                             \\nUSA\\n   \n",
       "41996           \\napo, ap United States\\n   \n",
       "41997                             \\nUSA\\n   \n",
       "41998                                \\n\\n   \n",
       "41999                    \\nBeijing, PRC\\n   \n",
       "\n",
       "                                             review_text  \n",
       "0      \\nThis all-Spanish handbook for parents with n...  \n",
       "1      \\nMcCarthy's writing and portrayal of Lester B...  \n",
       "2      \\nDo you giggle uncontrollably when poking cor...  \n",
       "3      \\nI was initiated into the world of Cormac McC...  \n",
       "4      \\nI cannot speak to the literary points in the...  \n",
       "...                                                  ...  \n",
       "41995  \\nIn reading this book, I traveled on a wonder...  \n",
       "41996  \\nThis wonderful book touches the inner soul.Y...  \n",
       "41997  \\nI am a 45 year old woman who has been on a q...  \n",
       "41998  \\nIt is written that you should hide the Word ...  \n",
       "41999  \\nJohn Beckett has the feel of an average guy ...  \n",
       "\n",
       "[42000 rows x 12 columns]"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "<bound method Series.unique of 0        \\nbooks\\n\n",
       "1        \\nbooks\\n\n",
       "2        \\nbooks\\n\n",
       "3        \\nbooks\\n\n",
       "4        \\nbooks\\n\n",
       "           ...    \n",
       "41995    \\nbooks\\n\n",
       "41996    \\nbooks\\n\n",
       "41997    \\nbooks\\n\n",
       "41998    \\nbooks\\n\n",
       "41999    \\nbooks\\n\n",
       "Name: product_type, Length: 42000, dtype: object>"
      ]
     },
     "execution_count": 5,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['product_type'].unique(0)"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}