data_extraction_electronics.ipynb

{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## Amazon Reviews\n",
    "\n",
    "Data Source: https://nijianmo.github.io/amazon/index.html\n",
    "\n",
    "This notebook takes in the zipped reviews and meta data from the Amazon review data of Electronics.\n",
    "\n",
    "Since the files are large and product characteristics vary, we will extract one popular product's information for further modeling and analysis."
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Data Cleaning\n",
    "\n",
    "Json to dataframe"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import gzip\n",
    "import json\n",
    "\n",
    "def parse(path):\n",
    "  g = gzip.open(path, 'rb')\n",
    "  for l in g:\n",
    "    yield json.loads(l)\n",
    "\n",
    "def getDF(path):\n",
    "  i = 0\n",
    "  df = {}\n",
    "  for d in parse(path):\n",
    "    df[i] = d\n",
    "    i += 1\n",
    "  return pd.DataFrame.from_dict(df, orient='index')\n",
    "\n",
    "df = getDF('Electronics_5.json.gz')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "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>overall</th>\n",
       "      <th>vote</th>\n",
       "      <th>verified</th>\n",
       "      <th>reviewTime</th>\n",
       "      <th>reviewerID</th>\n",
       "      <th>asin</th>\n",
       "      <th>style</th>\n",
       "      <th>reviewerName</th>\n",
       "      <th>reviewText</th>\n",
       "      <th>summary</th>\n",
       "      <th>unixReviewTime</th>\n",
       "      <th>image</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>5.0</td>\n",
       "      <td>67</td>\n",
       "      <td>True</td>\n",
       "      <td>09 18, 1999</td>\n",
       "      <td>AAP7PPBU72QFM</td>\n",
       "      <td>0151004714</td>\n",
       "      <td>{'Format:': ' Hardcover'}</td>\n",
       "      <td>D. C. Carrad</td>\n",
       "      <td>This is the best novel I have read in 2 or 3 y...</td>\n",
       "      <td>A star is born</td>\n",
       "      <td>937612800</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>3.0</td>\n",
       "      <td>5</td>\n",
       "      <td>True</td>\n",
       "      <td>10 23, 2013</td>\n",
       "      <td>A2E168DTVGE6SV</td>\n",
       "      <td>0151004714</td>\n",
       "      <td>{'Format:': ' Kindle Edition'}</td>\n",
       "      <td>Evy</td>\n",
       "      <td>Pages and pages of introspection, in the style...</td>\n",
       "      <td>A stream of consciousness novel</td>\n",
       "      <td>1382486400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>5.0</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "      <td>09 2, 2008</td>\n",
       "      <td>A1ER5AYS3FQ9O3</td>\n",
       "      <td>0151004714</td>\n",
       "      <td>{'Format:': ' Paperback'}</td>\n",
       "      <td>Kcorn</td>\n",
       "      <td>This is the kind of novel to read when you hav...</td>\n",
       "      <td>I'm a huge fan of the author and this one did ...</td>\n",
       "      <td>1220313600</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>5.0</td>\n",
       "      <td>13</td>\n",
       "      <td>False</td>\n",
       "      <td>09 4, 2000</td>\n",
       "      <td>A1T17LMQABMBN5</td>\n",
       "      <td>0151004714</td>\n",
       "      <td>{'Format:': ' Hardcover'}</td>\n",
       "      <td>Caf Girl Writes</td>\n",
       "      <td>What gorgeous language! What an incredible wri...</td>\n",
       "      <td>The most beautiful book I have ever read!</td>\n",
       "      <td>968025600</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>3.0</td>\n",
       "      <td>8</td>\n",
       "      <td>True</td>\n",
       "      <td>02 4, 2000</td>\n",
       "      <td>A3QHJ0FXK33OBE</td>\n",
       "      <td>0151004714</td>\n",
       "      <td>{'Format:': ' Hardcover'}</td>\n",
       "      <td>W. Shane Schmidt</td>\n",
       "      <td>I was taken in by reviews that compared this b...</td>\n",
       "      <td>A dissenting view--In part.</td>\n",
       "      <td>949622400</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   overall vote  verified   reviewTime      reviewerID        asin  \\\n",
       "0      5.0   67      True  09 18, 1999   AAP7PPBU72QFM  0151004714   \n",
       "1      3.0    5      True  10 23, 2013  A2E168DTVGE6SV  0151004714   \n",
       "2      5.0    4     False   09 2, 2008  A1ER5AYS3FQ9O3  0151004714   \n",
       "3      5.0   13     False   09 4, 2000  A1T17LMQABMBN5  0151004714   \n",
       "4      3.0    8      True   02 4, 2000  A3QHJ0FXK33OBE  0151004714   \n",
       "\n",
       "                            style      reviewerName  \\\n",
       "0       {'Format:': ' Hardcover'}      D. C. Carrad   \n",
       "1  {'Format:': ' Kindle Edition'}               Evy   \n",
       "2       {'Format:': ' Paperback'}             Kcorn   \n",
       "3       {'Format:': ' Hardcover'}   Caf Girl Writes   \n",
       "4       {'Format:': ' Hardcover'}  W. Shane Schmidt   \n",
       "\n",
       "                                          reviewText  \\\n",
       "0  This is the best novel I have read in 2 or 3 y...   \n",
       "1  Pages and pages of introspection, in the style...   \n",
       "2  This is the kind of novel to read when you hav...   \n",
       "3  What gorgeous language! What an incredible wri...   \n",
       "4  I was taken in by reviews that compared this b...   \n",
       "\n",
       "                                             summary  unixReviewTime image  \n",
       "0                                     A star is born       937612800   NaN  \n",
       "1                    A stream of consciousness novel      1382486400   NaN  \n",
       "2  I'm a huge fan of the author and this one did ...      1220313600   NaN  \n",
       "3          The most beautiful book I have ever read!       968025600   NaN  \n",
       "4                        A dissenting view--In part.       949622400   NaN  "
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Aggregate with Metadata"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Group reviews data by products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 27,
   "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>overall</th>\n",
       "      <th>asin</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>ID</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>B003L1ZYYW</th>\n",
       "      <td>8617</td>\n",
       "      <td>B003L1ZYYW</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B0019HL8Q8</th>\n",
       "      <td>8160</td>\n",
       "      <td>B0019HL8Q8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B0019EHU8G</th>\n",
       "      <td>7777</td>\n",
       "      <td>B0019EHU8G</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B0015DYMVO</th>\n",
       "      <td>7380</td>\n",
       "      <td>B0015DYMVO</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B000VS4HDM</th>\n",
       "      <td>6802</td>\n",
       "      <td>B000VS4HDM</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B000YJAWUA</th>\n",
       "      <td>1</td>\n",
       "      <td>B000YJAWUA</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B0013MYX8E</th>\n",
       "      <td>1</td>\n",
       "      <td>B0013MYX8E</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B000WGS5B8</th>\n",
       "      <td>1</td>\n",
       "      <td>B000WGS5B8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B00166G6EG</th>\n",
       "      <td>1</td>\n",
       "      <td>B00166G6EG</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>B0013MYX9S</th>\n",
       "      <td>1</td>\n",
       "      <td>B0013MYX9S</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>160052 rows × 2 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "            overall        asin\n",
       "ID                             \n",
       "B003L1ZYYW     8617  B003L1ZYYW\n",
       "B0019HL8Q8     8160  B0019HL8Q8\n",
       "B0019EHU8G     7777  B0019EHU8G\n",
       "B0015DYMVO     7380  B0015DYMVO\n",
       "B000VS4HDM     6802  B000VS4HDM\n",
       "...             ...         ...\n",
       "B000YJAWUA        1  B000YJAWUA\n",
       "B0013MYX8E        1  B0013MYX8E\n",
       "B000WGS5B8        1  B000WGS5B8\n",
       "B00166G6EG        1  B00166G6EG\n",
       "B0013MYX9S        1  B0013MYX9S\n",
       "\n",
       "[160052 rows x 2 columns]"
      ]
     },
     "execution_count": 27,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tbl = df.groupby('asin').agg({'overall':'count'})\n",
    "tbl = tbl.sort_values(by = ['overall'], ascending = False)\n",
    "tbl['asin'] = tbl.index\n",
    "tbl = tbl.rename_axis(\"ID\")\n",
    "tbl"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Read in metadata and merge with aggregated review data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 28,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "C:\\Users\\lliu9\\Anaconda3\\lib\\site-packages\\IPython\\core\\interactiveshell.py:3058: DtypeWarning: Columns (18) have mixed types. Specify dtype option on import or set low_memory=False.\n",
      "  interactivity=interactivity, compiler=compiler, result=result)\n"
     ]
    }
   ],
   "source": [
    "# read in meta data and inner merge with review data by asin\n",
    "meta = pd.read_csv('meta.csv')\n",
    "new = tbl.merge(meta, on = 'asin', how = 'inner')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 29,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['overall', 'asin', 'Unnamed: 0', 'category', 'description', 'title',\n",
       "       'image', 'brand', 'feature', 'rank', 'main_cat', 'date', 'price',\n",
       "       'also_buy', 'also_view', 'similar_item', 'tech1', 'tech2', 'details',\n",
       "       'fit'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 29,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "new.columns"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Exploratory playground"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 135,
   "metadata": {},
   "outputs": [],
   "source": [
    "def keep_recent(new):\n",
    "    '''The function returns whether the product is released after 2016.'''\n",
    "    try:\n",
    "        if int(new['date'][-4:]) > 2016:\n",
    "            return 1\n",
    "        else:\n",
    "            return 0\n",
    "    except:\n",
    "        return 0\n",
    "    \n",
    "new['newitem'] = new.apply(keep_recent, axis = 1)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 137,
   "metadata": {},
   "outputs": [],
   "source": [
    "sim_df = new[new['newitem'] == 1][['asin', 'title', 'overall', 'brand']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 142,
   "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>asin</th>\n",
       "      <th>title</th>\n",
       "      <th>overall</th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>B00BP5KOPA</td>\n",
       "      <td>Logitech MK270 Wireless Keyboard and Mouse Combo - Keyboard and Mouse Included, 2.4GHz Dropout-Free Connection, Long Battery Life (Frustration-Free Packaging)</td>\n",
       "      <td>4625</td>\n",
       "      <td>Logitech</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>B001TH7GUU</td>\n",
       "      <td>AmazonBasics USB 2.0 Extension Cable - A-Male to A-Female - 9.8 Feet (3 Meters)</td>\n",
       "      <td>4503</td>\n",
       "      <td>AmazonBasics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>36</th>\n",
       "      <td>B009D79VH4</td>\n",
       "      <td>Transcend USB 3.0 SDHC / SDXC / microSDHC / SDXC Card Reader, TS-RDF5K (Black)</td>\n",
       "      <td>3747</td>\n",
       "      <td>Transcend</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>48</th>\n",
       "      <td>B001XURP8Q</td>\n",
       "      <td>Sandisk Cruzer 32GB USB 32 GB Flash Drive, Black - SDCZ36-032G</td>\n",
       "      <td>3166</td>\n",
       "      <td>SanDisk</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>51</th>\n",
       "      <td>B004OVECU0</td>\n",
       "      <td>Logitech Harmony 650 Infrared All in One Remote Control, Universal Remote Logitech, Programmable Remote (Silver)</td>\n",
       "      <td>3132</td>\n",
       "      <td>Logitech</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>61</th>\n",
       "      <td>B001TH7GSW</td>\n",
       "      <td>AmazonBasics Digital Optical Audio Toslink Cable - 6 Feet (1.8 Meters)</td>\n",
       "      <td>3016</td>\n",
       "      <td>AmazonBasics</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>75</th>\n",
       "      <td>B00APCMMEK</td>\n",
       "      <td>Transcend 16GB MicroSDHC Class10 UHS-1 Memory Card with Adapter 60 MB/s (TS16GUSDU1)</td>\n",
       "      <td>2848</td>\n",
       "      <td>Transcend</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>89</th>\n",
       "      <td>B000WU2LXC</td>\n",
       "      <td>ARCTIC MX-2 - Thermal Compound Paste, Carbon Based High Performance, Heatsink Paste, Thermal Compound CPU for All Coolers, Thermal Interface Material - 4 Grams</td>\n",
       "      <td>2586</td>\n",
       "      <td>ARCTIC</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>92</th>\n",
       "      <td>B000A6PPOK</td>\n",
       "      <td>Microsoft Natural Ergonomic Keyboard 4000</td>\n",
       "      <td>2567</td>\n",
       "      <td>Microsoft</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>B00DSUTX3O</td>\n",
       "      <td>WD Black 750GB Performance Mobile Hard Disk Drive - 7200 RPM SATA 6 Gb/s 16MB Cache 9.5 MM 2.5 Inch - WD7500BPKX</td>\n",
       "      <td>2442</td>\n",
       "      <td>Western Digital</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           asin  \\\n",
       "19   B00BP5KOPA   \n",
       "26   B001TH7GUU   \n",
       "36   B009D79VH4   \n",
       "48   B001XURP8Q   \n",
       "51   B004OVECU0   \n",
       "61   B001TH7GSW   \n",
       "75   B00APCMMEK   \n",
       "89   B000WU2LXC   \n",
       "92   B000A6PPOK   \n",
       "102  B00DSUTX3O   \n",
       "\n",
       "                                                                                                                                                               title  \\\n",
       "19   Logitech MK270 Wireless Keyboard and Mouse Combo - Keyboard and Mouse Included, 2.4GHz Dropout-Free Connection, Long Battery Life (Frustration-Free Packaging)    \n",
       "26   AmazonBasics USB 2.0 Extension Cable - A-Male to A-Female - 9.8 Feet (3 Meters)                                                                                   \n",
       "36   Transcend USB 3.0 SDHC / SDXC / microSDHC / SDXC Card Reader, TS-RDF5K (Black)                                                                                    \n",
       "48   Sandisk Cruzer 32GB USB 32 GB Flash Drive, Black - SDCZ36-032G                                                                                                    \n",
       "51   Logitech Harmony 650 Infrared All in One Remote Control, Universal Remote Logitech, Programmable Remote (Silver)                                                  \n",
       "61   AmazonBasics Digital Optical Audio Toslink Cable - 6 Feet (1.8 Meters)                                                                                            \n",
       "75   Transcend 16GB MicroSDHC Class10 UHS-1 Memory Card with Adapter 60 MB/s (TS16GUSDU1)                                                                              \n",
       "89   ARCTIC MX-2 - Thermal Compound Paste, Carbon Based High Performance, Heatsink Paste, Thermal Compound CPU for All Coolers, Thermal Interface Material - 4 Grams   \n",
       "92   Microsoft Natural Ergonomic Keyboard 4000                                                                                                                         \n",
       "102  WD Black 750GB Performance Mobile Hard Disk Drive - 7200 RPM SATA 6 Gb/s 16MB Cache 9.5 MM 2.5 Inch - WD7500BPKX                                                  \n",
       "\n",
       "     overall            brand  \n",
       "19   4625     Logitech         \n",
       "26   4503     AmazonBasics     \n",
       "36   3747     Transcend        \n",
       "48   3166     SanDisk          \n",
       "51   3132     Logitech         \n",
       "61   3016     AmazonBasics     \n",
       "75   2848     Transcend        \n",
       "89   2586     ARCTIC           \n",
       "92   2567     Microsoft        \n",
       "102  2442     Western Digital  "
      ]
     },
     "execution_count": 142,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sim_df.head(10)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "##### Explore different brands"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 140,
   "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>asin</th>\n",
       "      <th>title</th>\n",
       "      <th>overall</th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "Empty DataFrame\n",
       "Columns: [asin, title, overall, brand]\n",
       "Index: []"
      ]
     },
     "execution_count": 140,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Amazon products\n",
    "sim_df[sim_df['brand']=='Amazon'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 141,
   "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>asin</th>\n",
       "      <th>title</th>\n",
       "      <th>overall</th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2913</th>\n",
       "      <td>B00UGBMRQ8</td>\n",
       "      <td>Apple MacBook Pro 15\" Core i7 2.8GHz Retina (MGXG2LL/A), 16GB RAM, 512GB Solid State Drive (Refurbished)</td>\n",
       "      <td>349</td>\n",
       "      <td>Apple</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4039</th>\n",
       "      <td>B0096VDM8G</td>\n",
       "      <td>Apple MacBook Pro 15-Inch Laptop with Retina Display, 2.2 Ghz Intel core i7, 16GB DDR3L, 512GB SSD (Z0RC0005YR)</td>\n",
       "      <td>269</td>\n",
       "      <td>Apple</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10007</th>\n",
       "      <td>B00B3Y4U4E</td>\n",
       "      <td>Apple MD862ZM/A Thunderbolt Cable - 0.5 M (NEWEST VERSION)</td>\n",
       "      <td>126</td>\n",
       "      <td>Apple</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14257</th>\n",
       "      <td>B0186RZAWQ</td>\n",
       "      <td>Apple Smart Keyboard for iPad Pro 12.9</td>\n",
       "      <td>92</td>\n",
       "      <td>Apple</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18190</th>\n",
       "      <td>B01H29JY62</td>\n",
       "      <td>Apple Magic Keyboard (Wireless, Rechargable) (Spanish) - Silver</td>\n",
       "      <td>73</td>\n",
       "      <td>Apple</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             asin  \\\n",
       "2913   B00UGBMRQ8   \n",
       "4039   B0096VDM8G   \n",
       "10007  B00B3Y4U4E   \n",
       "14257  B0186RZAWQ   \n",
       "18190  B01H29JY62   \n",
       "\n",
       "                                                                                                                 title  \\\n",
       "2913   Apple MacBook Pro 15\" Core i7 2.8GHz Retina (MGXG2LL/A), 16GB RAM, 512GB Solid State Drive (Refurbished)          \n",
       "4039   Apple MacBook Pro 15-Inch Laptop with Retina Display, 2.2 Ghz Intel core i7, 16GB DDR3L, 512GB SSD (Z0RC0005YR)   \n",
       "10007  Apple MD862ZM/A Thunderbolt Cable - 0.5 M (NEWEST VERSION)                                                        \n",
       "14257  Apple Smart Keyboard for iPad Pro 12.9                                                                            \n",
       "18190  Apple Magic Keyboard (Wireless, Rechargable) (Spanish) - Silver                                                   \n",
       "\n",
       "       overall  brand  \n",
       "2913   349      Apple  \n",
       "4039   269      Apple  \n",
       "10007  126      Apple  \n",
       "14257  92       Apple  \n",
       "18190  73       Apple  "
      ]
     },
     "execution_count": 141,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Apple products\n",
    "sim_df[sim_df['brand']=='Apple'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 66,
   "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>asin</th>\n",
       "      <th>title</th>\n",
       "      <th>overall</th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5382</th>\n",
       "      <td>B00UHHRLEO</td>\n",
       "      <td>New Original Gold Xiaomi 2nd Piston Earphone I...</td>\n",
       "      <td>213</td>\n",
       "      <td>Xiaomi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8266</th>\n",
       "      <td>B00V9RKSAA</td>\n",
       "      <td>Xiaomi Piston III Headset Earphones with Remot...</td>\n",
       "      <td>149</td>\n",
       "      <td>Xiaomi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12652</th>\n",
       "      <td>B018AMDCLI</td>\n",
       "      <td>Xiaomi ZBW4326TY Professional Store Hybrid Dua...</td>\n",
       "      <td>103</td>\n",
       "      <td>Xiaomi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29086</th>\n",
       "      <td>B00ODPLC8C</td>\n",
       "      <td>Original Xiaomi Piston Earphone Ii Headphone H...</td>\n",
       "      <td>45</td>\n",
       "      <td>Xiaomi</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>50448</th>\n",
       "      <td>B013N5VS5Y</td>\n",
       "      <td>Xiaomi Piston 3 Headphones In-Ear Bass Earphon...</td>\n",
       "      <td>24</td>\n",
       "      <td>Xiaomi</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             asin                                              title  overall  \\\n",
       "5382   B00UHHRLEO  New Original Gold Xiaomi 2nd Piston Earphone I...      213   \n",
       "8266   B00V9RKSAA  Xiaomi Piston III Headset Earphones with Remot...      149   \n",
       "12652  B018AMDCLI  Xiaomi ZBW4326TY Professional Store Hybrid Dua...      103   \n",
       "29086  B00ODPLC8C  Original Xiaomi Piston Earphone Ii Headphone H...       45   \n",
       "50448  B013N5VS5Y  Xiaomi Piston 3 Headphones In-Ear Bass Earphon...       24   \n",
       "\n",
       "        brand  \n",
       "5382   Xiaomi  \n",
       "8266   Xiaomi  \n",
       "12652  Xiaomi  \n",
       "29086  Xiaomi  \n",
       "50448  Xiaomi  "
      ]
     },
     "execution_count": 66,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sim_df[sim_df['brand']=='Xiaomi'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 67,
   "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>asin</th>\n",
       "      <th>title</th>\n",
       "      <th>overall</th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>2025</th>\n",
       "      <td>B013LKLS2E</td>\n",
       "      <td>Huawei Watch Stainless Steel with Stainless St...</td>\n",
       "      <td>455</td>\n",
       "      <td>Huawei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3572</th>\n",
       "      <td>B013LKLIC4</td>\n",
       "      <td>Huawei Watch Stainless Steel with Stainless St...</td>\n",
       "      <td>296</td>\n",
       "      <td>Huawei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17091</th>\n",
       "      <td>B00KKRC4I4</td>\n",
       "      <td>Huawei Ascend W1 - Windows 8 Smartphone - Unlo...</td>\n",
       "      <td>77</td>\n",
       "      <td>Huawei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26725</th>\n",
       "      <td>B01FWIJ690</td>\n",
       "      <td>Huawei MateBook Signature Edition 2 in 1 PC Ta...</td>\n",
       "      <td>49</td>\n",
       "      <td>Huawei</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27650</th>\n",
       "      <td>B00CTPQAGW</td>\n",
       "      <td>OEM Manufactured Standard Battery (1500 mAh, N...</td>\n",
       "      <td>47</td>\n",
       "      <td>Huawei</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "             asin                                              title  overall  \\\n",
       "2025   B013LKLS2E  Huawei Watch Stainless Steel with Stainless St...      455   \n",
       "3572   B013LKLIC4  Huawei Watch Stainless Steel with Stainless St...      296   \n",
       "17091  B00KKRC4I4  Huawei Ascend W1 - Windows 8 Smartphone - Unlo...       77   \n",
       "26725  B01FWIJ690  Huawei MateBook Signature Edition 2 in 1 PC Ta...       49   \n",
       "27650  B00CTPQAGW  OEM Manufactured Standard Battery (1500 mAh, N...       47   \n",
       "\n",
       "        brand  \n",
       "2025   Huawei  \n",
       "3572   Huawei  \n",
       "17091  Huawei  \n",
       "26725  Huawei  \n",
       "27650  Huawei  "
      ]
     },
     "execution_count": 67,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sim_df[sim_df['brand']=='Huawei'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 80,
   "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>asin</th>\n",
       "      <th>title</th>\n",
       "      <th>overall</th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>5625</th>\n",
       "      <td>B00FU83YWS</td>\n",
       "      <td>Lenovo Thinkpad E545 20B20011US  Laptop (Windo...</td>\n",
       "      <td>205</td>\n",
       "      <td>Lenovo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8614</th>\n",
       "      <td>B00F2ENU92</td>\n",
       "      <td>Lenovo Yoga Multimode 10-inch Tablet</td>\n",
       "      <td>144</td>\n",
       "      <td>Lenovo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8677</th>\n",
       "      <td>B005L2NTTQ</td>\n",
       "      <td>Lenovo N5902 Enhanced Multimedia Remote with B...</td>\n",
       "      <td>143</td>\n",
       "      <td>Lenovo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9658</th>\n",
       "      <td>B000LRI2ZC</td>\n",
       "      <td>2GB PC2-5300 667MHZ DDR2 Sdram</td>\n",
       "      <td>130</td>\n",
       "      <td>Lenovo</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9703</th>\n",
       "      <td>B00JAIEAU4</td>\n",
       "      <td>Lenovo IdeaTab A8-50 8-Inch 16 GB Tablet</td>\n",
       "      <td>130</td>\n",
       "      <td>Lenovo</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            asin                                              title  overall  \\\n",
       "5625  B00FU83YWS  Lenovo Thinkpad E545 20B20011US  Laptop (Windo...      205   \n",
       "8614  B00F2ENU92               Lenovo Yoga Multimode 10-inch Tablet      144   \n",
       "8677  B005L2NTTQ  Lenovo N5902 Enhanced Multimedia Remote with B...      143   \n",
       "9658  B000LRI2ZC                     2GB PC2-5300 667MHZ DDR2 Sdram      130   \n",
       "9703  B00JAIEAU4           Lenovo IdeaTab A8-50 8-Inch 16 GB Tablet      130   \n",
       "\n",
       "       brand  \n",
       "5625  Lenovo  \n",
       "8614  Lenovo  \n",
       "8677  Lenovo  \n",
       "9658  Lenovo  \n",
       "9703  Lenovo  "
      ]
     },
     "execution_count": 80,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sim_df[sim_df['brand']=='Lenovo'].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "#### Explore different products"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 71,
   "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>asin</th>\n",
       "      <th>title</th>\n",
       "      <th>overall</th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>135</th>\n",
       "      <td>B00P7EVST6</td>\n",
       "      <td>Arlo - Wireless Home Security Camera System | ...</td>\n",
       "      <td>2130</td>\n",
       "      <td>Arlo Technologies, Inc</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3110</th>\n",
       "      <td>B0010SIAV2</td>\n",
       "      <td>Giottos MH621 Quick Release Adapter with Short...</td>\n",
       "      <td>332</td>\n",
       "      <td>Giotto's</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3848</th>\n",
       "      <td>B00K3GI8Y6</td>\n",
       "      <td>General 3-way Adjustable Hand Grip Stabilizer ...</td>\n",
       "      <td>279</td>\n",
       "      <td>General</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4147</th>\n",
       "      <td>B0042J6VUS</td>\n",
       "      <td>Mini Adjustable Tripod+camera Holder for Iphon...</td>\n",
       "      <td>264</td>\n",
       "      <td>EastVita</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5300</th>\n",
       "      <td>B00K67QUQK</td>\n",
       "      <td>The OFFICIAL ROXANT PRO video camera stabilize...</td>\n",
       "      <td>215</td>\n",
       "      <td>Roxant</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            asin                                              title  overall  \\\n",
       "135   B00P7EVST6  Arlo - Wireless Home Security Camera System | ...     2130   \n",
       "3110  B0010SIAV2  Giottos MH621 Quick Release Adapter with Short...      332   \n",
       "3848  B00K3GI8Y6  General 3-way Adjustable Hand Grip Stabilizer ...      279   \n",
       "4147  B0042J6VUS  Mini Adjustable Tripod+camera Holder for Iphon...      264   \n",
       "5300  B00K67QUQK  The OFFICIAL ROXANT PRO video camera stabilize...      215   \n",
       "\n",
       "                       brand  \n",
       "135   Arlo Technologies, Inc  \n",
       "3110                Giotto's  \n",
       "3848                 General  \n",
       "4147                EastVita  \n",
       "5300                  Roxant  "
      ]
     },
     "execution_count": 71,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sim_df[sim_df['title'].str.contains(\"camera\",na = False)].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "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>asin</th>\n",
       "      <th>title</th>\n",
       "      <th>overall</th>\n",
       "      <th>brand</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>151</th>\n",
       "      <td>B00XMD7KPU</td>\n",
       "      <td>Anker 4-Port USB 3.0 Ultra Slim Data Hub for M...</td>\n",
       "      <td>2000</td>\n",
       "      <td>Anker</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>431</th>\n",
       "      <td>B001N7PANQ</td>\n",
       "      <td>var aPageStart = (new Date()).getTime();\\nvar ...</td>\n",
       "      <td>1176</td>\n",
       "      <td>mCover</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>B001NJO6AC</td>\n",
       "      <td>var aPageStart = (new Date()).getTime();\\nvar ...</td>\n",
       "      <td>1166</td>\n",
       "      <td>mCover</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>525</th>\n",
       "      <td>B01AHKYIRS</td>\n",
       "      <td>[2 in 1 Pack] Anker USB-C (Male) to Micro USB ...</td>\n",
       "      <td>1067</td>\n",
       "      <td>Anker</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>568</th>\n",
       "      <td>B00DQ5RYP0</td>\n",
       "      <td>HooToo USB C Hub, 6-in-1 Premium USB C Adapter...</td>\n",
       "      <td>1022</td>\n",
       "      <td>HooToo</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "           asin                                              title  overall  \\\n",
       "151  B00XMD7KPU  Anker 4-Port USB 3.0 Ultra Slim Data Hub for M...     2000   \n",
       "431  B001N7PANQ  var aPageStart = (new Date()).getTime();\\nvar ...     1176   \n",
       "444  B001NJO6AC  var aPageStart = (new Date()).getTime();\\nvar ...     1166   \n",
       "525  B01AHKYIRS  [2 in 1 Pack] Anker USB-C (Male) to Micro USB ...     1067   \n",
       "568  B00DQ5RYP0  HooToo USB C Hub, 6-in-1 Premium USB C Adapter...     1022   \n",
       "\n",
       "      brand  \n",
       "151   Anker  \n",
       "431  mCover  \n",
       "444  mCover  \n",
       "525   Anker  \n",
       "568  HooToo  "
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sim_df[sim_df['title'].str.contains(\"MacBook\",na = False)].head()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### Extract Sample Data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 148,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "92    Microsoft Natural Ergonomic Keyboard 4000\n",
      "Name: title, dtype: object\n"
     ]
    }
   ],
   "source": [
    "#pd.set_option('display.max_colwidth', 1)\n",
    "print(new[new['asin']=='B000A6PPOK']['title'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 153,
   "metadata": {},
   "outputs": [],
   "source": [
    "new[new['asin']=='B000A6PPOK'].head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 149,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "Index(['overall', 'vote', 'verified', 'reviewTime', 'reviewerID', 'asin',\n",
       "       'style', 'reviewerName', 'reviewText', 'summary', 'unixReviewTime',\n",
       "       'image'],\n",
       "      dtype='object')"
      ]
     },
     "execution_count": 149,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df.columns"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 151,
   "metadata": {},
   "outputs": [],
   "source": [
    "pdt = df[df['asin']=='B000A6PPOK']\n",
    "pdt.to_csv('sample.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.2"
  },
  "toc": {
   "base_numbering": 1,
   "nav_menu": {
    "height": "310px",
    "width": "352px"
   },
   "number_sections": true,
   "sideBar": true,
   "skip_h1_title": false,
   "title_cell": "Table of Contents",
   "title_sidebar": "Contents",
   "toc_cell": false,
   "toc_position": {},
   "toc_section_display": true,
   "toc_window_display": false
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}