Lab 5_Python Sentiment.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Message</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0|0|5|The Canon Rebel T3i takes the consumer l...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>If you are considering the Rebel T3i vs T2i, t...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Canon Rebel T3i  vs. 60D vs. 7D</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sensor and Image Quality:  All three cameras s...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Exposure Metering: The three cameras all share...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "                                             Message\n",
       "0  0|0|5|The Canon Rebel T3i takes the consumer l...\n",
       "1  If you are considering the Rebel T3i vs T2i, t...\n",
       "2                    Canon Rebel T3i  vs. 60D vs. 7D\n",
       "3  Sensor and Image Quality:  All three cameras s...\n",
       "4  Exposure Metering: The three cameras all share..."
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# read file \n",
    "df = pd.read_table(\"short_input.txt\",header = None, names = ['Message'])\n",
    "df.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def IsNotNull(value):\n",
    "    return value is not None and len(value) > 0"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# create dictionary list (prositive)\n",
    "\n",
    "dict_p = []\n",
    "f = open('positive-words.txt', 'r')   \n",
    "for line in f:\n",
    "   t = line.strip().lower()\n",
    "   if (IsNotNull(t)):\n",
    "      dict_p.append(t)\n",
    "f.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# create dictionary list (negative)\n",
    "\n",
    "dict_n = []\n",
    "f = open('negative-words.txt', 'r')   \n",
    "for line in f:\n",
    "   t = line.strip().lower()\n",
    "   if (IsNotNull(t)):\n",
    "      dict_n.append(t)\n",
    "f.close()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "# count of positive and negative words that appeared in each message\n",
    "# net count which is calculated by positive count subtracting negative count. \n",
    "\n",
    "poscnt = []\n",
    "negcnt = []\n",
    "netcnt = []\n",
    "\n",
    "for nrow in range(0,len(df)):\n",
    "    \n",
    "    text = df.Message[nrow].lower()\n",
    "    qa = 0\n",
    "    qb = 0\n",
    "\n",
    "    for word in dict_p :\n",
    "        if (word in text) :\n",
    "            qa = qa + 1\n",
    "\n",
    "    for word in dict_n :\n",
    "        if (word in text) :\n",
    "            qb = qb + 1\n",
    "\n",
    "    qc = qa - qb\n",
    "    \n",
    "    poscnt.append(qa)\n",
    "    negcnt.append(qb)\n",
    "    netcnt.append(qc)\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Message</th>\n",
       "      <th>poscnt</th>\n",
       "      <th>negcnt</th>\n",
       "      <th>netcnt</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0|0|5|The Canon Rebel T3i takes the consumer l...</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>If you are considering the Rebel T3i vs T2i, t...</td>\n",
       "      <td>8</td>\n",
       "      <td>12</td>\n",
       "      <td>-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>Canon Rebel T3i  vs. 60D vs. 7D</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Sensor and Image Quality:  All three cameras s...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>Exposure Metering: The three cameras all share...</td>\n",
       "      <td>3</td>\n",
       "      <td>7</td>\n",
       "      <td>-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Autofocus: The T3i shares a similar autofocus ...</td>\n",
       "      <td>7</td>\n",
       "      <td>6</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>Construction: As you can probably figure out f...</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>ISO: Since they all share a very similar senso...</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>-3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>Controls: As with construction, the buttons an...</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>Menus and Custom Functions: These allow for gr...</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>http://www.amazon.com/gp/product/B004PLNMR8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>Canon T3i Experience - The Still Photographer'...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>and</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>http://www.amazon.com/gp/product/B0045UA75O</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Your World 60D - The Photographer's Guide to O...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>which walk you through all of the Menu setting...</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>Wireless Flash: Like the 7D and 60D, the T3i i...</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Articulating LCD Screen: The big new feature t...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>Viewfinder: The T3i has a pentamirror viewfind...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>Processor: The T3i shares the same Digic 4 pro...</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>-4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>Continuous Shooting Speed: The T3i can shoot 3...</td>\n",
       "      <td>5</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>Memory Card: The T3i and 60D use the SD memory...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>Battery: The T3i and T2i use the smaller LP-E8...</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>Size and Weight: The T3i is smaller and lighte...</td>\n",
       "      <td>8</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>AF Microadjustment: The 7D has this feature, t...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>Locking Mode Dial: This is a new feature for a...</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Full HD video: Of course they all offer this c...</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>Flash Sync: the 60D and T3i do not have a PC s...</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>Ease of operation: While beginners may find al...</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>http://www.amazon.com/gp/product/B004PLNMR8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>441</th>\n",
       "      <td>Compatibility with SD/SDHC/SDXC memory cards.</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>442</th>\n",
       "      <td>Compatible with the full line of Canon EF and ...</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>443</th>\n",
       "      <td>The EOS 60D features a new, Canon-designed 18....</td>\n",
       "      <td>7</td>\n",
       "      <td>7</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>444</th>\n",
       "      <td>Features worth noting</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>445</th>\n",
       "      <td>When you look at this class of DSLR, sophistic...</td>\n",
       "      <td>7</td>\n",
       "      <td>1</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>446</th>\n",
       "      <td>Built-In Wireless Flash Control (new feature f...</td>\n",
       "      <td>7</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>447</th>\n",
       "      <td>Vari Angle LCD (new feature for Rebels) The T3...</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>448</th>\n",
       "      <td>Full HD Movie Recording with Controls On the T...</td>\n",
       "      <td>4</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>449</th>\n",
       "      <td>Video Snapshot Function This feature allows yo...</td>\n",
       "      <td>8</td>\n",
       "      <td>6</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>450</th>\n",
       "      <td>Creative Filters After you've captured an imag...</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>451</th>\n",
       "      <td>Setting Maximum Speed for Auto ISO Existing-li...</td>\n",
       "      <td>10</td>\n",
       "      <td>7</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>452</th>\n",
       "      <td>Star Ratings In Camera While viewing images in...</td>\n",
       "      <td>5</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>453</th>\n",
       "      <td>Copyright Information Setting When you access ...</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>454</th>\n",
       "      <td>Image quality</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>455</th>\n",
       "      <td>With either kit lens, the 18-55mm or the 18-13...</td>\n",
       "      <td>11</td>\n",
       "      <td>4</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>456</th>\n",
       "      <td>Even though either kit zoom isn't a particular...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>457</th>\n",
       "      <td>In our lab tests, the T3i performed incredibly...</td>\n",
       "      <td>5</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>458</th>\n",
       "      <td>Drawbacks</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>459</th>\n",
       "      <td>The limited amount of physical real estate on ...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>460</th>\n",
       "      <td>The T3i would also benefit from the addition o...</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>461</th>\n",
       "      <td>And finally, as with most Canon cameras, Auto ...</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>-2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>462</th>\n",
       "      <td>I would recommend that to anyone looking to bu...</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>463</th>\n",
       "      <td>0|112|5|This camera was purchased for my son (...</td>\n",
       "      <td>6</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>464</th>\n",
       "      <td>0|113|5|First off, I have been in the video pr...</td>\n",
       "      <td>7</td>\n",
       "      <td>4</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>465</th>\n",
       "      <td>The tech on this thing is great, with the abil...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>466</th>\n",
       "      <td>Leaving it in auto mode, even a child can use ...</td>\n",
       "      <td>6</td>\n",
       "      <td>11</td>\n",
       "      <td>-5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>467</th>\n",
       "      <td>The battery life is very good. I purchased two...</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>468</th>\n",
       "      <td>0|114|5|I've always considered myself a \"Good ...</td>\n",
       "      <td>21</td>\n",
       "      <td>14</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>469</th>\n",
       "      <td>0|115|5|I have had my Rebel Ti3 camera and kit...</td>\n",
       "      <td>26</td>\n",
       "      <td>17</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>470</th>\n",
       "      <td>Look, this was a great shopping experience fro...</td>\n",
       "      <td>9</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>471 rows × 4 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Message  poscnt  negcnt  netcnt\n",
       "0    0|0|5|The Canon Rebel T3i takes the consumer l...       3       8      -5\n",
       "1    If you are considering the Rebel T3i vs T2i, t...       8      12      -4\n",
       "2                      Canon Rebel T3i  vs. 60D vs. 7D       0       0       0\n",
       "3    Sensor and Image Quality:  All three cameras s...       1       0       1\n",
       "4    Exposure Metering: The three cameras all share...       3       7      -4\n",
       "5    Autofocus: The T3i shares a similar autofocus ...       7       6       1\n",
       "6    Construction: As you can probably figure out f...       7       7       0\n",
       "7    ISO: Since they all share a very similar senso...       0       3      -3\n",
       "8    Controls: As with construction, the buttons an...       9       9       0\n",
       "9    Menus and Custom Functions: These allow for gr...       7       5       2\n",
       "10         http://www.amazon.com/gp/product/B004PLNMR8       0       0       0\n",
       "11   Canon T3i Experience - The Still Photographer'...       1       0       1\n",
       "12                                                 and       0       0       0\n",
       "13         http://www.amazon.com/gp/product/B0045UA75O       0       0       0\n",
       "14   Your World 60D - The Photographer's Guide to O...       1       0       1\n",
       "15   which walk you through all of the Menu setting...       8       3       5\n",
       "16   Wireless Flash: Like the 7D and 60D, the T3i i...       2       1       1\n",
       "17   Articulating LCD Screen: The big new feature t...       4       5      -1\n",
       "18   Viewfinder: The T3i has a pentamirror viewfind...       3       1       2\n",
       "19   Processor: The T3i shares the same Digic 4 pro...       1       5      -4\n",
       "20   Continuous Shooting Speed: The T3i can shoot 3...       5       3       2\n",
       "21   Memory Card: The T3i and 60D use the SD memory...       0       0       0\n",
       "22   Battery: The T3i and T2i use the smaller LP-E8...       0       0       0\n",
       "23   Size and Weight: The T3i is smaller and lighte...       8       3       5\n",
       "24   AF Microadjustment: The 7D has this feature, t...       1       1       0\n",
       "25   Locking Mode Dial: This is a new feature for a...       2       3      -1\n",
       "26   Full HD video: Of course they all offer this c...       4       3       1\n",
       "27   Flash Sync: the 60D and T3i do not have a PC s...       1       1       0\n",
       "28   Ease of operation: While beginners may find al...       9       4       5\n",
       "29         http://www.amazon.com/gp/product/B004PLNMR8       0       0       0\n",
       "..                                                 ...     ...     ...     ...\n",
       "441      Compatibility with SD/SDHC/SDXC memory cards.       0       0       0\n",
       "442  Compatible with the full line of Canon EF and ...       1       0       1\n",
       "443  The EOS 60D features a new, Canon-designed 18....       7       7       0\n",
       "444                              Features worth noting       2       0       2\n",
       "445  When you look at this class of DSLR, sophistic...       7       1       6\n",
       "446  Built-In Wireless Flash Control (new feature f...       7       5       2\n",
       "447  Vari Angle LCD (new feature for Rebels) The T3...      17       9       8\n",
       "448  Full HD Movie Recording with Controls On the T...       4       2       2\n",
       "449  Video Snapshot Function This feature allows yo...       8       6       2\n",
       "450  Creative Filters After you've captured an imag...       3       4      -1\n",
       "451  Setting Maximum Speed for Auto ISO Existing-li...      10       7       3\n",
       "452  Star Ratings In Camera While viewing images in...       5       1       4\n",
       "453  Copyright Information Setting When you access ...       2       1       1\n",
       "454                                      Image quality       0       0       0\n",
       "455  With either kit lens, the 18-55mm or the 18-13...      11       4       7\n",
       "456  Even though either kit zoom isn't a particular...       2       2       0\n",
       "457  In our lab tests, the T3i performed incredibly...       5       2       3\n",
       "458                                          Drawbacks       0       2      -2\n",
       "459  The limited amount of physical real estate on ...       3       3       0\n",
       "460  The T3i would also benefit from the addition o...       4       5      -1\n",
       "461  And finally, as with most Canon cameras, Auto ...       0       2      -2\n",
       "462  I would recommend that to anyone looking to bu...       3       0       3\n",
       "463  0|112|5|This camera was purchased for my son (...       6       3       3\n",
       "464  0|113|5|First off, I have been in the video pr...       7       4       3\n",
       "465  The tech on this thing is great, with the abil...       3       1       2\n",
       "466  Leaving it in auto mode, even a child can use ...       6      11      -5\n",
       "467  The battery life is very good. I purchased two...       4       0       4\n",
       "468  0|114|5|I've always considered myself a \"Good ...      21      14       7\n",
       "469  0|115|5|I have had my Rebel Ti3 camera and kit...      26      17       9\n",
       "470  Look, this was a great shopping experience fro...       9       4       5\n",
       "\n",
       "[471 rows x 4 columns]"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['poscnt'] = poscnt\n",
    "df['negcnt'] = negcnt\n",
    "df['netcnt'] = netcnt\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "#write result into csv\n",
    "df.to_csv('python_result.csv')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "anaconda-cloud": {},
  "kernelspec": {
   "display_name": "Python [default]",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 1
}