scored_talk_posts.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>talk_page_revision_id</th>\n",
       "      <th>article_title</th>\n",
       "      <th>thread_title</th>\n",
       "      <th>username</th>\n",
       "      <th>post_text</th>\n",
       "      <th>post_timestamp</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>507861346</td>\n",
       "      <td>14 July Revolution</td>\n",
       "      <td>Biased</td>\n",
       "      <td>UNKNOWN_CONTRIBUTOR</td>\n",
       "      <td>This article seems to justify and approve the ...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>507861346</td>\n",
       "      <td>14 July Revolution</td>\n",
       "      <td>Flag</td>\n",
       "      <td>UNKNOWN_CONTRIBUTOR</td>\n",
       "      <td>The flag of the belligerents on the left side,...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Agenda</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>Details available hereLihaas (talk) 06:44, 27 ...</td>\n",
       "      <td>2012-08-27 00:44:14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Agenda</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>Unfortunately it does not cover the issues whi...</td>\n",
       "      <td>2012-08-27 03:22:39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Agenda</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>:Its the official agenda...Lihaas (talk) 09:58...</td>\n",
       "      <td>2012-08-28 03:58:45.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Appraisal</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>There is a lot of such issues about NAM role i...</td>\n",
       "      <td>2012-08-29 20:01:47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Appraisal</td>\n",
       "      <td>Jethro B</td>\n",
       "      <td>Probably \"overview\" --Activism1234 02:15, 30 A...</td>\n",
       "      <td>2012-08-29 20:15:19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Appraisal</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>:Definately should be added. Either as per ACT...</td>\n",
       "      <td>2012-08-29 20:18:53.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Ban at the Summit</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>Where should we put this part:\\nIn addition, U...</td>\n",
       "      <td>2012-08-29 20:36:21.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Ban at the Summit</td>\n",
       "      <td>Jethro B</td>\n",
       "      <td>Thanks for the Persian ref, I'm fine with keep...</td>\n",
       "      <td>2012-08-29 20:41:10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Ban at the Summit</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>-) I am happy that you know Persian well.--Sey...</td>\n",
       "      <td>2012-08-29 20:46:03.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Ban at the Summit</td>\n",
       "      <td>Jethro B</td>\n",
       "      <td>:Google Translate. --Activism1234 03:33, 30 Au...</td>\n",
       "      <td>2012-08-29 21:33:32.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Ban at the Summit</td>\n",
       "      <td>Jethro B</td>\n",
       "      <td>Althought not totally convinced by the reliabi...</td>\n",
       "      <td>2012-08-30 00:45:47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Ban at the Summit</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>:The summit is today and tomorrow, the events ...</td>\n",
       "      <td>2012-08-30 04:28:19.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Controversy title</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>Per this, the controversy IS the reaction of n...</td>\n",
       "      <td>2012-08-26 23:28:27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Controversy title</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>Do you mean we should change the \"Controversy\"...</td>\n",
       "      <td>2012-08-26 23:36:22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Controversy title</td>\n",
       "      <td>Jethro B</td>\n",
       "      <td>The controversy is ed around the attendance of...</td>\n",
       "      <td>2012-08-27 00:04:47.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Controversy title</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>:I meant the subsection. The attendance of the...</td>\n",
       "      <td>2012-08-27 01:24:10.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Error in translations</td>\n",
       "      <td>ZxxZxxZ</td>\n",
       "      <td>The phrases in the section are misleading. Thi...</td>\n",
       "      <td>2012-09-02 20:00:20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Error in translations</td>\n",
       "      <td>Jethro B</td>\n",
       "      <td>I can't say whether that's true or not - Wikip...</td>\n",
       "      <td>2012-09-02 21:35:46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Fatah–Hamas rivalry</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>\"In late August, President Mahmoud Ahmadinejad...</td>\n",
       "      <td>2012-08-27 03:16:22.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Fatah–Hamas rivalry</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>Your edit made it more vauge, so i everted tha...</td>\n",
       "      <td>2012-08-28 04:00:17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Fatah–Hamas rivalry</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>:As I understand Iran has invited Abbas as the...</td>\n",
       "      <td>2012-08-28 05:27:31.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Fatah–Hamas rivalry</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>::Haniyeh's reaction should be added thenLihaa...</td>\n",
       "      <td>2012-08-30 04:33:59.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Fatah–Hamas rivalry</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>:::I added it.--Seyyed(t-c) 12:38, 30 August 2...</td>\n",
       "      <td>2012-08-30 06:38:33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Gallery</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>I dont see the point in a gallery here. All th...</td>\n",
       "      <td>2012-08-28 03:40:46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Gallery</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>I agree with you.--Seyyed(t-c) 11:28, 28 Augus...</td>\n",
       "      <td>2012-08-28 05:28:03.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Gallery</td>\n",
       "      <td>Jethro B</td>\n",
       "      <td>Agree. Only gallery I'd support is one of the ...</td>\n",
       "      <td>2012-08-29 20:22:18.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>Gallery</td>\n",
       "      <td>Lihaas</td>\n",
       "      <td>:TEMPLATE[done] removaedLihaas (talk) 10:26, 3...</td>\n",
       "      <td>2012-08-30 04:26:38.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>510528946</td>\n",
       "      <td>16th Summit of the Non-Aligned Movement</td>\n",
       "      <td>How many Delegation do participate?</td>\n",
       "      <td>Sa.vakilian</td>\n",
       "      <td>\"In the first day of the summit 110 foreign de...</td>\n",
       "      <td>2012-08-26 23:14:34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38443</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>\"Failed verification\"</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>:::I was getting a bit confused by the lead of...</td>\n",
       "      <td>2008-03-06 10:33:20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38444</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Extraneous</td>\n",
       "      <td>ColdSnow</td>\n",
       "      <td>Dear 212.143.214.179,\\nI don't know how releva...</td>\n",
       "      <td>2008-03-09 10:07:33.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38445</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Amire80</td>\n",
       "      <td>The organization is definitely notable.</td>\n",
       "      <td>2008-03-05 08:52:00.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38446</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Amire80</td>\n",
       "      <td>The article should be expanded, of course. --A...</td>\n",
       "      <td>2008-03-05 08:52:00.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38447</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>A bald assertion. No substantiation = no value...</td>\n",
       "      <td>2008-03-05 09:02:14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38448</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>First find some WP:RSs. HrafnTalkStalk 15:02, ...</td>\n",
       "      <td>2008-03-05 09:02:14.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38449</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Amire80</td>\n",
       "      <td>:This organization is very notable in Israel. ...</td>\n",
       "      <td>2008-03-05 09:22:01.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38450</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>::This article was created 6 hours ago, using ...</td>\n",
       "      <td>2008-03-05 09:31:51.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38451</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Amire80</td>\n",
       "      <td>:::We're in the business of writing an encyclo...</td>\n",
       "      <td>2008-03-05 09:41:35.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38452</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>WP:COI creation + no sources = absolutely zero...</td>\n",
       "      <td>2008-03-05 10:01:08.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38453</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>Three external links: one to the subject's non...</td>\n",
       "      <td>2008-03-05 10:16:17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38454</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Amire80</td>\n",
       "      <td>An improvement to your formula: COI creation +...</td>\n",
       "      <td>2008-03-05 10:19:48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38455</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Amire80</td>\n",
       "      <td>It's not a bare mention. Leaving aside the org...</td>\n",
       "      <td>2008-03-05 10:26:57.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38456</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>:I was talking about the lack of a presumption...</td>\n",
       "      <td>2008-03-05 10:49:39.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38457</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>:I suggest you read WP:V#Non-English sources. ...</td>\n",
       "      <td>2008-03-05 10:56:27.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38458</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Notability</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>::It is such verification problems (due to lac...</td>\n",
       "      <td>2008-03-05 11:03:46.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38459</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Speedy deletion</td>\n",
       "      <td>Hrafn</td>\n",
       "      <td>Please don't delete this article, \\nThe Zomet ...</td>\n",
       "      <td>2008-03-05 07:50:48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38460</th>\n",
       "      <td>235819840</td>\n",
       "      <td>Zomet Institute</td>\n",
       "      <td>Today's NYT Article</td>\n",
       "      <td>UNKNOWN_CONTRIBUTOR</td>\n",
       "      <td>Can someone implement some of the information ...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38461</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>A Palestinian who doesn't believe Palestinians...</td>\n",
       "      <td>Nadav S</td>\n",
       "      <td>How could Zuheir be identified as a Palestinia...</td>\n",
       "      <td>2011-12-11 15:53:34.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38462</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>A Palestinian who doesn't believe Palestinians...</td>\n",
       "      <td>AnonMoos</td>\n",
       "      <td>I don't really know that -- there's no necessa...</td>\n",
       "      <td>2011-12-12 05:42:42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38463</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>Trouw interview</td>\n",
       "      <td>Lopakhin</td>\n",
       "      <td>I emailed Trouw, and received a reply from Han...</td>\n",
       "      <td>2008-03-06 13:59:48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38464</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>Trouw interview</td>\n",
       "      <td>AnonMoos</td>\n",
       "      <td>I'm having problems viewing it now, since I do...</td>\n",
       "      <td>2008-03-06 16:40:17.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38465</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>Trouw interview</td>\n",
       "      <td>AnonMoos</td>\n",
       "      <td>By the way, Wikipedia article pages are techni...</td>\n",
       "      <td>2008-03-06 16:45:42.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38466</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>Trouw interview</td>\n",
       "      <td>AnonMoos</td>\n",
       "      <td>:Thanks... AnonMoos (talk) 09:23, 7 March 2008...</td>\n",
       "      <td>2008-03-07 03:23:58.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38467</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>Trouw interview</td>\n",
       "      <td>Zero0000</td>\n",
       "      <td>Here is my transcription of the text kindly pr...</td>\n",
       "      <td>2010-09-17 23:21:48.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38468</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>Trouw interview</td>\n",
       "      <td>Netziv</td>\n",
       "      <td>Google's translation is clear, if awkward:\\n\"B...</td>\n",
       "      <td>2010-10-11 11:53:04.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38469</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>Trouw interview</td>\n",
       "      <td>Zero0000</td>\n",
       "      <td>The tag should remain until the translation is...</td>\n",
       "      <td>2010-10-11 16:14:20.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38470</th>\n",
       "      <td>513268164</td>\n",
       "      <td>Zuheir Mohsen</td>\n",
       "      <td>Trouw interview</td>\n",
       "      <td>Whaledad</td>\n",
       "      <td>:Better late than never(?). Here's a translati...</td>\n",
       "      <td>2012-02-27 13:05:23.0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38471</th>\n",
       "      <td>513247430</td>\n",
       "      <td>Zvi Hirsch Kalischer</td>\n",
       "      <td>Untitled</td>\n",
       "      <td>UNKNOWN_CONTRIBUTOR</td>\n",
       "      <td>One of the best things about the post-WW2 Bene...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>38472</th>\n",
       "      <td>513269515</td>\n",
       "      <td>Zvi Zamir</td>\n",
       "      <td>WikiProject class rating</td>\n",
       "      <td>BetacommandBot</td>\n",
       "      <td>This article was automatically assessed becaus...</td>\n",
       "      <td>2007-11-09 15:18:57.0</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>38473 rows × 6 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       talk_page_revision_id                            article_title  \\\n",
       "0                  507861346                       14 July Revolution   \n",
       "1                  507861346                       14 July Revolution   \n",
       "2                  510528946  16th Summit of the Non-Aligned Movement   \n",
       "3                  510528946  16th Summit of the Non-Aligned Movement   \n",
       "4                  510528946  16th Summit of the Non-Aligned Movement   \n",
       "5                  510528946  16th Summit of the Non-Aligned Movement   \n",
       "6                  510528946  16th Summit of the Non-Aligned Movement   \n",
       "7                  510528946  16th Summit of the Non-Aligned Movement   \n",
       "8                  510528946  16th Summit of the Non-Aligned Movement   \n",
       "9                  510528946  16th Summit of the Non-Aligned Movement   \n",
       "10                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "11                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "12                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "13                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "14                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "15                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "16                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "17                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "18                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "19                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "20                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "21                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "22                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "23                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "24                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "25                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "26                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "27                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "28                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "29                 510528946  16th Summit of the Non-Aligned Movement   \n",
       "...                      ...                                      ...   \n",
       "38443              235819840                          Zomet Institute   \n",
       "38444              235819840                          Zomet Institute   \n",
       "38445              235819840                          Zomet Institute   \n",
       "38446              235819840                          Zomet Institute   \n",
       "38447              235819840                          Zomet Institute   \n",
       "38448              235819840                          Zomet Institute   \n",
       "38449              235819840                          Zomet Institute   \n",
       "38450              235819840                          Zomet Institute   \n",
       "38451              235819840                          Zomet Institute   \n",
       "38452              235819840                          Zomet Institute   \n",
       "38453              235819840                          Zomet Institute   \n",
       "38454              235819840                          Zomet Institute   \n",
       "38455              235819840                          Zomet Institute   \n",
       "38456              235819840                          Zomet Institute   \n",
       "38457              235819840                          Zomet Institute   \n",
       "38458              235819840                          Zomet Institute   \n",
       "38459              235819840                          Zomet Institute   \n",
       "38460              235819840                          Zomet Institute   \n",
       "38461              513268164                            Zuheir Mohsen   \n",
       "38462              513268164                            Zuheir Mohsen   \n",
       "38463              513268164                            Zuheir Mohsen   \n",
       "38464              513268164                            Zuheir Mohsen   \n",
       "38465              513268164                            Zuheir Mohsen   \n",
       "38466              513268164                            Zuheir Mohsen   \n",
       "38467              513268164                            Zuheir Mohsen   \n",
       "38468              513268164                            Zuheir Mohsen   \n",
       "38469              513268164                            Zuheir Mohsen   \n",
       "38470              513268164                            Zuheir Mohsen   \n",
       "38471              513247430                     Zvi Hirsch Kalischer   \n",
       "38472              513269515                                Zvi Zamir   \n",
       "\n",
       "                                            thread_title             username  \\\n",
       "0                                                 Biased  UNKNOWN_CONTRIBUTOR   \n",
       "1                                                   Flag  UNKNOWN_CONTRIBUTOR   \n",
       "2                                                 Agenda               Lihaas   \n",
       "3                                                 Agenda          Sa.vakilian   \n",
       "4                                                 Agenda               Lihaas   \n",
       "5                                              Appraisal          Sa.vakilian   \n",
       "6                                              Appraisal             Jethro B   \n",
       "7                                              Appraisal               Lihaas   \n",
       "8                                      Ban at the Summit          Sa.vakilian   \n",
       "9                                      Ban at the Summit             Jethro B   \n",
       "10                                     Ban at the Summit          Sa.vakilian   \n",
       "11                                     Ban at the Summit             Jethro B   \n",
       "12                                     Ban at the Summit             Jethro B   \n",
       "13                                     Ban at the Summit               Lihaas   \n",
       "14                                     Controversy title               Lihaas   \n",
       "15                                     Controversy title          Sa.vakilian   \n",
       "16                                     Controversy title             Jethro B   \n",
       "17                                     Controversy title               Lihaas   \n",
       "18                                 Error in translations              ZxxZxxZ   \n",
       "19                                 Error in translations             Jethro B   \n",
       "20                                   Fatah–Hamas rivalry          Sa.vakilian   \n",
       "21                                   Fatah–Hamas rivalry               Lihaas   \n",
       "22                                   Fatah–Hamas rivalry          Sa.vakilian   \n",
       "23                                   Fatah–Hamas rivalry               Lihaas   \n",
       "24                                   Fatah–Hamas rivalry          Sa.vakilian   \n",
       "25                                               Gallery               Lihaas   \n",
       "26                                               Gallery          Sa.vakilian   \n",
       "27                                               Gallery             Jethro B   \n",
       "28                                               Gallery               Lihaas   \n",
       "29                   How many Delegation do participate?          Sa.vakilian   \n",
       "...                                                  ...                  ...   \n",
       "38443                              \"Failed verification\"                Hrafn   \n",
       "38444                                         Extraneous             ColdSnow   \n",
       "38445                                         Notability              Amire80   \n",
       "38446                                         Notability              Amire80   \n",
       "38447                                         Notability                Hrafn   \n",
       "38448                                         Notability                Hrafn   \n",
       "38449                                         Notability              Amire80   \n",
       "38450                                         Notability                Hrafn   \n",
       "38451                                         Notability              Amire80   \n",
       "38452                                         Notability                Hrafn   \n",
       "38453                                         Notability                Hrafn   \n",
       "38454                                         Notability              Amire80   \n",
       "38455                                         Notability              Amire80   \n",
       "38456                                         Notability                Hrafn   \n",
       "38457                                         Notability                Hrafn   \n",
       "38458                                         Notability                Hrafn   \n",
       "38459                                    Speedy deletion                Hrafn   \n",
       "38460                                Today's NYT Article  UNKNOWN_CONTRIBUTOR   \n",
       "38461  A Palestinian who doesn't believe Palestinians...              Nadav S   \n",
       "38462  A Palestinian who doesn't believe Palestinians...             AnonMoos   \n",
       "38463                                    Trouw interview             Lopakhin   \n",
       "38464                                    Trouw interview             AnonMoos   \n",
       "38465                                    Trouw interview             AnonMoos   \n",
       "38466                                    Trouw interview             AnonMoos   \n",
       "38467                                    Trouw interview             Zero0000   \n",
       "38468                                    Trouw interview               Netziv   \n",
       "38469                                    Trouw interview             Zero0000   \n",
       "38470                                    Trouw interview             Whaledad   \n",
       "38471                                           Untitled  UNKNOWN_CONTRIBUTOR   \n",
       "38472                           WikiProject class rating       BetacommandBot   \n",
       "\n",
       "                                               post_text  \\\n",
       "0      This article seems to justify and approve the ...   \n",
       "1      The flag of the belligerents on the left side,...   \n",
       "2      Details available hereLihaas (talk) 06:44, 27 ...   \n",
       "3      Unfortunately it does not cover the issues whi...   \n",
       "4      :Its the official agenda...Lihaas (talk) 09:58...   \n",
       "5      There is a lot of such issues about NAM role i...   \n",
       "6      Probably \"overview\" --Activism1234 02:15, 30 A...   \n",
       "7      :Definately should be added. Either as per ACT...   \n",
       "8      Where should we put this part:\\nIn addition, U...   \n",
       "9      Thanks for the Persian ref, I'm fine with keep...   \n",
       "10     -) I am happy that you know Persian well.--Sey...   \n",
       "11     :Google Translate. --Activism1234 03:33, 30 Au...   \n",
       "12     Althought not totally convinced by the reliabi...   \n",
       "13     :The summit is today and tomorrow, the events ...   \n",
       "14     Per this, the controversy IS the reaction of n...   \n",
       "15     Do you mean we should change the \"Controversy\"...   \n",
       "16     The controversy is ed around the attendance of...   \n",
       "17     :I meant the subsection. The attendance of the...   \n",
       "18     The phrases in the section are misleading. Thi...   \n",
       "19     I can't say whether that's true or not - Wikip...   \n",
       "20     \"In late August, President Mahmoud Ahmadinejad...   \n",
       "21     Your edit made it more vauge, so i everted tha...   \n",
       "22     :As I understand Iran has invited Abbas as the...   \n",
       "23     ::Haniyeh's reaction should be added thenLihaa...   \n",
       "24     :::I added it.--Seyyed(t-c) 12:38, 30 August 2...   \n",
       "25     I dont see the point in a gallery here. All th...   \n",
       "26     I agree with you.--Seyyed(t-c) 11:28, 28 Augus...   \n",
       "27     Agree. Only gallery I'd support is one of the ...   \n",
       "28     :TEMPLATE[done] removaedLihaas (talk) 10:26, 3...   \n",
       "29     \"In the first day of the summit 110 foreign de...   \n",
       "...                                                  ...   \n",
       "38443  :::I was getting a bit confused by the lead of...   \n",
       "38444  Dear 212.143.214.179,\\nI don't know how releva...   \n",
       "38445            The organization is definitely notable.   \n",
       "38446  The article should be expanded, of course. --A...   \n",
       "38447  A bald assertion. No substantiation = no value...   \n",
       "38448  First find some WP:RSs. HrafnTalkStalk 15:02, ...   \n",
       "38449  :This organization is very notable in Israel. ...   \n",
       "38450  ::This article was created 6 hours ago, using ...   \n",
       "38451  :::We're in the business of writing an encyclo...   \n",
       "38452  WP:COI creation + no sources = absolutely zero...   \n",
       "38453  Three external links: one to the subject's non...   \n",
       "38454  An improvement to your formula: COI creation +...   \n",
       "38455  It's not a bare mention. Leaving aside the org...   \n",
       "38456  :I was talking about the lack of a presumption...   \n",
       "38457  :I suggest you read WP:V#Non-English sources. ...   \n",
       "38458  ::It is such verification problems (due to lac...   \n",
       "38459  Please don't delete this article, \\nThe Zomet ...   \n",
       "38460  Can someone implement some of the information ...   \n",
       "38461  How could Zuheir be identified as a Palestinia...   \n",
       "38462  I don't really know that -- there's no necessa...   \n",
       "38463  I emailed Trouw, and received a reply from Han...   \n",
       "38464  I'm having problems viewing it now, since I do...   \n",
       "38465  By the way, Wikipedia article pages are techni...   \n",
       "38466  :Thanks... AnonMoos (talk) 09:23, 7 March 2008...   \n",
       "38467  Here is my transcription of the text kindly pr...   \n",
       "38468  Google's translation is clear, if awkward:\\n\"B...   \n",
       "38469  The tag should remain until the translation is...   \n",
       "38470  :Better late than never(?). Here's a translati...   \n",
       "38471  One of the best things about the post-WW2 Bene...   \n",
       "38472  This article was automatically assessed becaus...   \n",
       "\n",
       "              post_timestamp  \n",
       "0                        NaN  \n",
       "1                        NaN  \n",
       "2      2012-08-27 00:44:14.0  \n",
       "3      2012-08-27 03:22:39.0  \n",
       "4      2012-08-28 03:58:45.0  \n",
       "5      2012-08-29 20:01:47.0  \n",
       "6      2012-08-29 20:15:19.0  \n",
       "7      2012-08-29 20:18:53.0  \n",
       "8      2012-08-29 20:36:21.0  \n",
       "9      2012-08-29 20:41:10.0  \n",
       "10     2012-08-29 20:46:03.0  \n",
       "11     2012-08-29 21:33:32.0  \n",
       "12     2012-08-30 00:45:47.0  \n",
       "13     2012-08-30 04:28:19.0  \n",
       "14     2012-08-26 23:28:27.0  \n",
       "15     2012-08-26 23:36:22.0  \n",
       "16     2012-08-27 00:04:47.0  \n",
       "17     2012-08-27 01:24:10.0  \n",
       "18     2012-09-02 20:00:20.0  \n",
       "19     2012-09-02 21:35:46.0  \n",
       "20     2012-08-27 03:16:22.0  \n",
       "21     2012-08-28 04:00:17.0  \n",
       "22     2012-08-28 05:27:31.0  \n",
       "23     2012-08-30 04:33:59.0  \n",
       "24     2012-08-30 06:38:33.0  \n",
       "25     2012-08-28 03:40:46.0  \n",
       "26     2012-08-28 05:28:03.0  \n",
       "27     2012-08-29 20:22:18.0  \n",
       "28     2012-08-30 04:26:38.0  \n",
       "29     2012-08-26 23:14:34.0  \n",
       "...                      ...  \n",
       "38443  2008-03-06 10:33:20.0  \n",
       "38444  2008-03-09 10:07:33.0  \n",
       "38445  2008-03-05 08:52:00.0  \n",
       "38446  2008-03-05 08:52:00.0  \n",
       "38447  2008-03-05 09:02:14.0  \n",
       "38448  2008-03-05 09:02:14.0  \n",
       "38449  2008-03-05 09:22:01.0  \n",
       "38450  2008-03-05 09:31:51.0  \n",
       "38451  2008-03-05 09:41:35.0  \n",
       "38452  2008-03-05 10:01:08.0  \n",
       "38453  2008-03-05 10:16:17.0  \n",
       "38454  2008-03-05 10:19:48.0  \n",
       "38455  2008-03-05 10:26:57.0  \n",
       "38456  2008-03-05 10:49:39.0  \n",
       "38457  2008-03-05 10:56:27.0  \n",
       "38458  2008-03-05 11:03:46.0  \n",
       "38459  2008-03-05 07:50:48.0  \n",
       "38460                    NaN  \n",
       "38461  2011-12-11 15:53:34.0  \n",
       "38462  2011-12-12 05:42:42.0  \n",
       "38463  2008-03-06 13:59:48.0  \n",
       "38464  2008-03-06 16:40:17.0  \n",
       "38465  2008-03-06 16:45:42.0  \n",
       "38466  2008-03-07 03:23:58.0  \n",
       "38467  2010-09-17 23:21:48.0  \n",
       "38468  2010-10-11 11:53:04.0  \n",
       "38469  2010-10-11 16:14:20.0  \n",
       "38470  2012-02-27 13:05:23.0  \n",
       "38471                    NaN  \n",
       "38472  2007-11-09 15:18:57.0  \n",
       "\n",
       "[38473 rows x 6 columns]"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "all_talk = pd.read_csv('/home/michael/school/research/wp/wikipedia/data/talk/ipc_talkpages_byarticle.csv')\n",
    "all_talk"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "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>article</th>\n",
       "      <th>thread_title</th>\n",
       "      <th>editor</th>\n",
       "      <th>editor_talk</th>\n",
       "      <th>other_talk</th>\n",
       "      <th>#editor_turns</th>\n",
       "      <th>#other_turns</th>\n",
       "      <th>words_in_common</th>\n",
       "      <th>intersection/editor</th>\n",
       "      <th>intersection/other</th>\n",
       "      <th>...</th>\n",
       "      <th>T13</th>\n",
       "      <th>T14</th>\n",
       "      <th>SENTI::POS</th>\n",
       "      <th>SENTI::NEG</th>\n",
       "      <th>editor_score</th>\n",
       "      <th>nonbow_pred</th>\n",
       "      <th>pred</th>\n",
       "      <th>num_users</th>\n",
       "      <th>edpred</th>\n",
       "      <th>fold</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>Restatement</td>\n",
       "      <td>Bless sins</td>\n",
       "      <td>:\"The massacure was preformed by muslims, ther...</td>\n",
       "      <td>Restatement: Sometime ago I asked for source o...</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>40</td>\n",
       "      <td>0.769231</td>\n",
       "      <td>0.017058</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001481</td>\n",
       "      <td>0.001481</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.620913</td>\n",
       "      <td>0.463035</td>\n",
       "      <td>7</td>\n",
       "      <td>0.506138</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>Restatement</td>\n",
       "      <td>Ceedjee</td>\n",
       "      <td>Restatement: Sometime ago I asked for source o...</td>\n",
       "      <td>The massacure was preformed by muslims, theref...</td>\n",
       "      <td>9</td>\n",
       "      <td>9</td>\n",
       "      <td>471</td>\n",
       "      <td>0.349407</td>\n",
       "      <td>0.448999</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000117</td>\n",
       "      <td>0.261022</td>\n",
       "      <td>32.0</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.572965</td>\n",
       "      <td>0.796302</td>\n",
       "      <td>7</td>\n",
       "      <td>0.500023</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>Restatement</td>\n",
       "      <td>GHcool</td>\n",
       "      <td>:::::::Nishidani's argument for why the Hebron...</td>\n",
       "      <td>Restatement: Sometime ago I asked for source o...</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>54</td>\n",
       "      <td>0.729730</td>\n",
       "      <td>0.023246</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000913</td>\n",
       "      <td>0.401444</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.968750</td>\n",
       "      <td>0.617757</td>\n",
       "      <td>0.638528</td>\n",
       "      <td>7</td>\n",
       "      <td>0.580395</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>Restatement</td>\n",
       "      <td>Ian Pitchford</td>\n",
       "      <td>:And by that logic all killings by Jews would ...</td>\n",
       "      <td>Restatement: Sometime ago I asked for source o...</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>23</td>\n",
       "      <td>0.851852</td>\n",
       "      <td>0.009705</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002151</td>\n",
       "      <td>0.002151</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.626133</td>\n",
       "      <td>0.353466</td>\n",
       "      <td>7</td>\n",
       "      <td>0.603239</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>Restatement</td>\n",
       "      <td>Nishidani</td>\n",
       "      <td>::::::I disagree with your my friend. Benny Mo...</td>\n",
       "      <td>Restatement: Sometime ago I asked for source o...</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>273</td>\n",
       "      <td>0.423256</td>\n",
       "      <td>0.155822</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000153</td>\n",
       "      <td>0.283555</td>\n",
       "      <td>34.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.860870</td>\n",
       "      <td>0.581121</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.510341</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>Restatement</td>\n",
       "      <td>PalestineRemembered</td>\n",
       "      <td>:::I'm not sure how you can say \"Hebron massac...</td>\n",
       "      <td>Restatement: Sometime ago I asked for source o...</td>\n",
       "      <td>1</td>\n",
       "      <td>17</td>\n",
       "      <td>73</td>\n",
       "      <td>0.760417</td>\n",
       "      <td>0.031725</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000660</td>\n",
       "      <td>0.175090</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.710870</td>\n",
       "      <td>0.616858</td>\n",
       "      <td>0.507072</td>\n",
       "      <td>7</td>\n",
       "      <td>0.595210</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>Restatement</td>\n",
       "      <td>Yahel Guhan</td>\n",
       "      <td>The massacure was preformed by muslims, theref...</td>\n",
       "      <td>Restatement: Sometime ago I asked for source o...</td>\n",
       "      <td>2</td>\n",
       "      <td>16</td>\n",
       "      <td>33</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.014025</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001852</td>\n",
       "      <td>0.001852</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.500000</td>\n",
       "      <td>0.621627</td>\n",
       "      <td>0.631426</td>\n",
       "      <td>7</td>\n",
       "      <td>0.524619</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>false rumors</td>\n",
       "      <td>Nableezy</td>\n",
       "      <td>This is silly, but a. false rumors is not exac...</td>\n",
       "      <td>I'd like to point out that the days before the...</td>\n",
       "      <td>3</td>\n",
       "      <td>17</td>\n",
       "      <td>50</td>\n",
       "      <td>0.588235</td>\n",
       "      <td>0.028201</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001026</td>\n",
       "      <td>0.073913</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.610954</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.466697</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>false rumors</td>\n",
       "      <td>Nishidani</td>\n",
       "      <td>::(ec)It violates WP:NPOV but has some support...</td>\n",
       "      <td>This is silly, but a. false rumors is not exac...</td>\n",
       "      <td>9</td>\n",
       "      <td>11</td>\n",
       "      <td>307</td>\n",
       "      <td>0.237800</td>\n",
       "      <td>0.541446</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000121</td>\n",
       "      <td>0.351416</td>\n",
       "      <td>57.0</td>\n",
       "      <td>20.0</td>\n",
       "      <td>0.996139</td>\n",
       "      <td>0.593936</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.631038</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>false rumors</td>\n",
       "      <td>Plot Spoiler</td>\n",
       "      <td>Disagree with your position. Whether the rumor...</td>\n",
       "      <td>This is silly, but a. false rumors is not exac...</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>43</td>\n",
       "      <td>0.614286</td>\n",
       "      <td>0.024049</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001111</td>\n",
       "      <td>0.001111</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.611561</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.614233</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>false rumors</td>\n",
       "      <td>Pluto2012</td>\n",
       "      <td>I'd like to point out that the days before the...</td>\n",
       "      <td>This is silly, but a. false rumors is not exac...</td>\n",
       "      <td>4</td>\n",
       "      <td>16</td>\n",
       "      <td>168</td>\n",
       "      <td>0.661417</td>\n",
       "      <td>0.104738</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000460</td>\n",
       "      <td>0.326092</td>\n",
       "      <td>11.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.596919</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.573189</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>1929 Hebron massacre</td>\n",
       "      <td>false rumors</td>\n",
       "      <td>Vanished user lt94ma34le12</td>\n",
       "      <td>::::::The rumours were that a massacre was tak...</td>\n",
       "      <td>This is silly, but a. false rumors is not exac...</td>\n",
       "      <td>1</td>\n",
       "      <td>19</td>\n",
       "      <td>22</td>\n",
       "      <td>0.785714</td>\n",
       "      <td>0.012022</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002564</td>\n",
       "      <td>0.147679</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.745098</td>\n",
       "      <td>0.621461</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.631907</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus</td>\n",
       "      <td>Brewcrewer</td>\n",
       "      <td>:To reiterate some of the salient points made ...</td>\n",
       "      <td>Does anybody think there is consensus for the ...</td>\n",
       "      <td>1</td>\n",
       "      <td>69</td>\n",
       "      <td>34</td>\n",
       "      <td>0.708333</td>\n",
       "      <td>0.008521</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001111</td>\n",
       "      <td>0.142208</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.583133</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.625979</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus</td>\n",
       "      <td>Dlv999</td>\n",
       "      <td>::Clearly no consensus, these figure do not re...</td>\n",
       "      <td>Does anybody think there is consensus for the ...</td>\n",
       "      <td>18</td>\n",
       "      <td>52</td>\n",
       "      <td>839</td>\n",
       "      <td>0.637054</td>\n",
       "      <td>0.308343</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000133</td>\n",
       "      <td>0.457191</td>\n",
       "      <td>51.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>0.869565</td>\n",
       "      <td>0.530606</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.517580</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus</td>\n",
       "      <td>Jabotito48</td>\n",
       "      <td>::Another source: Arabs killed 133 Jews and wo...</td>\n",
       "      <td>Does anybody think there is consensus for the ...</td>\n",
       "      <td>1</td>\n",
       "      <td>69</td>\n",
       "      <td>29</td>\n",
       "      <td>0.828571</td>\n",
       "      <td>0.007245</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002299</td>\n",
       "      <td>0.002299</td>\n",
       "      <td>0.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.167488</td>\n",
       "      <td>0.588342</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.614020</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus</td>\n",
       "      <td>Oncenawhile</td>\n",
       "      <td>Does anybody think there is consensus for the ...</td>\n",
       "      <td>Please read WP:Consensus which explains, \"Here...</td>\n",
       "      <td>20</td>\n",
       "      <td>50</td>\n",
       "      <td>736</td>\n",
       "      <td>0.655387</td>\n",
       "      <td>0.252487</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000152</td>\n",
       "      <td>0.225220</td>\n",
       "      <td>42.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.788136</td>\n",
       "      <td>0.541281</td>\n",
       "      <td>0.753924</td>\n",
       "      <td>7</td>\n",
       "      <td>0.483097</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus</td>\n",
       "      <td>Shrike</td>\n",
       "      <td>:The source in the lead currently states that ...</td>\n",
       "      <td>Does anybody think there is consensus for the ...</td>\n",
       "      <td>2</td>\n",
       "      <td>68</td>\n",
       "      <td>39</td>\n",
       "      <td>0.764706</td>\n",
       "      <td>0.009782</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001626</td>\n",
       "      <td>0.001626</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.739130</td>\n",
       "      <td>0.585801</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.611930</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus</td>\n",
       "      <td>Vanished user lt94ma34le12</td>\n",
       "      <td>Please read WP:Consensus which explains, \"Here...</td>\n",
       "      <td>Does anybody think there is consensus for the ...</td>\n",
       "      <td>21</td>\n",
       "      <td>49</td>\n",
       "      <td>728</td>\n",
       "      <td>0.658228</td>\n",
       "      <td>0.248295</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000139</td>\n",
       "      <td>0.526139</td>\n",
       "      <td>43.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>0.357447</td>\n",
       "      <td>0.542755</td>\n",
       "      <td>0.068906</td>\n",
       "      <td>7</td>\n",
       "      <td>0.455967</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus</td>\n",
       "      <td>Zero0000</td>\n",
       "      <td>No, actually you have brushed aside reasonable...</td>\n",
       "      <td>Does anybody think there is consensus for the ...</td>\n",
       "      <td>4</td>\n",
       "      <td>66</td>\n",
       "      <td>156</td>\n",
       "      <td>0.750000</td>\n",
       "      <td>0.040731</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000439</td>\n",
       "      <td>0.165775</td>\n",
       "      <td>12.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.937778</td>\n",
       "      <td>0.578581</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.577084</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus (again)</td>\n",
       "      <td>Brewcrewer</td>\n",
       "      <td>::I'm not exaggerating but I think OAW reverte...</td>\n",
       "      <td>(1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...</td>\n",
       "      <td>1</td>\n",
       "      <td>77</td>\n",
       "      <td>25</td>\n",
       "      <td>0.714286</td>\n",
       "      <td>0.004662</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001852</td>\n",
       "      <td>0.001852</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.663793</td>\n",
       "      <td>0.578607</td>\n",
       "      <td>0.932676</td>\n",
       "      <td>5</td>\n",
       "      <td>0.599022</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus (again)</td>\n",
       "      <td>Jethro B</td>\n",
       "      <td>:::::::::Just to check... Am I included in \"su...</td>\n",
       "      <td>(1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...</td>\n",
       "      <td>23</td>\n",
       "      <td>55</td>\n",
       "      <td>1131</td>\n",
       "      <td>0.668835</td>\n",
       "      <td>0.305181</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000109</td>\n",
       "      <td>0.275448</td>\n",
       "      <td>67.0</td>\n",
       "      <td>18.0</td>\n",
       "      <td>0.975610</td>\n",
       "      <td>0.526717</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.475458</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus (again)</td>\n",
       "      <td>Oncenawhile</td>\n",
       "      <td>(1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...</td>\n",
       "      <td>The Shaw Report says 116 Arabs in total were k...</td>\n",
       "      <td>37</td>\n",
       "      <td>41</td>\n",
       "      <td>1533</td>\n",
       "      <td>0.553430</td>\n",
       "      <td>0.583555</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000081</td>\n",
       "      <td>0.413328</td>\n",
       "      <td>140.0</td>\n",
       "      <td>35.0</td>\n",
       "      <td>0.319672</td>\n",
       "      <td>0.513006</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.270524</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus (again)</td>\n",
       "      <td>Tritomex</td>\n",
       "      <td>:::In summary I would say the two Karen Armstr...</td>\n",
       "      <td>(1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...</td>\n",
       "      <td>2</td>\n",
       "      <td>76</td>\n",
       "      <td>64</td>\n",
       "      <td>0.800000</td>\n",
       "      <td>0.012037</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000913</td>\n",
       "      <td>0.060857</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.580782</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.571101</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>1929 Palestine riots</td>\n",
       "      <td>Consensus (again)</td>\n",
       "      <td>Zero0000</td>\n",
       "      <td>The Shaw Report says 116 Arabs in total were k...</td>\n",
       "      <td>(1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...</td>\n",
       "      <td>1</td>\n",
       "      <td>77</td>\n",
       "      <td>124</td>\n",
       "      <td>0.738095</td>\n",
       "      <td>0.023714</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000447</td>\n",
       "      <td>0.138467</td>\n",
       "      <td>3.0</td>\n",
       "      <td>6.0</td>\n",
       "      <td>0.915556</td>\n",
       "      <td>0.574408</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.612783</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>1936–39 Arab revolt in Palestine</td>\n",
       "      <td>Purpose of riots and allegations of detentions...</td>\n",
       "      <td>AladdinSE</td>\n",
       "      <td>Certainly to put an end to Jewish immigration,...</td>\n",
       "      <td>The purpose of the riots was to put an end to ...</td>\n",
       "      <td>8</td>\n",
       "      <td>22</td>\n",
       "      <td>368</td>\n",
       "      <td>0.606260</td>\n",
       "      <td>0.261364</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000180</td>\n",
       "      <td>0.184760</td>\n",
       "      <td>23.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.111111</td>\n",
       "      <td>0.562309</td>\n",
       "      <td>0.006716</td>\n",
       "      <td>4</td>\n",
       "      <td>0.513338</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>1936–39 Arab revolt in Palestine</td>\n",
       "      <td>Purpose of riots and allegations of detentions...</td>\n",
       "      <td>Jayjg</td>\n",
       "      <td>:I find Doron's argument persuasive. Jayjg(tal...</td>\n",
       "      <td>The purpose of the riots was to put an end to ...</td>\n",
       "      <td>2</td>\n",
       "      <td>28</td>\n",
       "      <td>38</td>\n",
       "      <td>0.745098</td>\n",
       "      <td>0.019348</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001515</td>\n",
       "      <td>0.079055</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.966667</td>\n",
       "      <td>0.611486</td>\n",
       "      <td>0.005668</td>\n",
       "      <td>4</td>\n",
       "      <td>0.594287</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>1936–39 Arab revolt in Palestine</td>\n",
       "      <td>Purpose of riots and allegations of detentions...</td>\n",
       "      <td>Leifern</td>\n",
       "      <td>The purpose of the riots was to put an end to ...</td>\n",
       "      <td>Certainly to put an end to Jewish immigration,...</td>\n",
       "      <td>7</td>\n",
       "      <td>23</td>\n",
       "      <td>325</td>\n",
       "      <td>0.671488</td>\n",
       "      <td>0.212280</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000221</td>\n",
       "      <td>0.203683</td>\n",
       "      <td>24.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.960000</td>\n",
       "      <td>0.570209</td>\n",
       "      <td>0.437216</td>\n",
       "      <td>4</td>\n",
       "      <td>0.476375</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>1936–39 Arab revolt in Palestine</td>\n",
       "      <td>Purpose of riots and allegations of detentions...</td>\n",
       "      <td>Zero0000</td>\n",
       "      <td>The \"emergency\" practices that the British ado...</td>\n",
       "      <td>The purpose of the riots was to put an end to ...</td>\n",
       "      <td>2</td>\n",
       "      <td>28</td>\n",
       "      <td>116</td>\n",
       "      <td>0.620321</td>\n",
       "      <td>0.063457</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000463</td>\n",
       "      <td>0.264312</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.272727</td>\n",
       "      <td>0.595978</td>\n",
       "      <td>0.336923</td>\n",
       "      <td>4</td>\n",
       "      <td>0.584237</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>1947–48 Civil War in Mandatory Palestine</td>\n",
       "      <td>Errors and POV</td>\n",
       "      <td>Pluto2012</td>\n",
       "      <td>- Added by Ykantor without signature (Pluto201...</td>\n",
       "      <td>The Arabs started the war. This sentence is wr...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>23</td>\n",
       "      <td>0.534884</td>\n",
       "      <td>0.057357</td>\n",
       "      <td>...</td>\n",
       "      <td>0.002083</td>\n",
       "      <td>0.191614</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.612654</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>2</td>\n",
       "      <td>0.635160</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>1947–48 Civil War in Mandatory Palestine</td>\n",
       "      <td>Errors and POV</td>\n",
       "      <td>Ykantor</td>\n",
       "      <td>The Arabs started the war. This sentence is wr...</td>\n",
       "      <td>- Added by Ykantor without signature (Pluto201...</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>23</td>\n",
       "      <td>0.057357</td>\n",
       "      <td>0.534884</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000252</td>\n",
       "      <td>0.269910</td>\n",
       "      <td>14.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.644839</td>\n",
       "      <td>0.255258</td>\n",
       "      <td>2</td>\n",
       "      <td>0.559567</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <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",
       "      <th>2043</th>\n",
       "      <td>West Bank</td>\n",
       "      <td>Legal status</td>\n",
       "      <td>Mor2</td>\n",
       "      <td>looking at this paragraph at the Legal status ...</td>\n",
       "      <td>Hi, the UNSC at least said in the cited source...</td>\n",
       "      <td>10</td>\n",
       "      <td>14</td>\n",
       "      <td>424</td>\n",
       "      <td>0.464403</td>\n",
       "      <td>0.544987</td>\n",
       "      <td>...</td>\n",
       "      <td>0.003773</td>\n",
       "      <td>0.124187</td>\n",
       "      <td>43.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.533666</td>\n",
       "      <td>0.554176</td>\n",
       "      <td>0.722660</td>\n",
       "      <td>3</td>\n",
       "      <td>0.417054</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2044</th>\n",
       "      <td>West Bank closures</td>\n",
       "      <td>un-encyclopedic</td>\n",
       "      <td>Amoruso</td>\n",
       "      <td>btw, I just looked at the maps. All the blocks...</td>\n",
       "      <td>On the fence OR where the settlements are... y...</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>29</td>\n",
       "      <td>0.284314</td>\n",
       "      <td>0.508772</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000775</td>\n",
       "      <td>0.000775</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.582467</td>\n",
       "      <td>0.432421</td>\n",
       "      <td>2</td>\n",
       "      <td>0.573829</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2045</th>\n",
       "      <td>West Bank closures</td>\n",
       "      <td>un-encyclopedic</td>\n",
       "      <td>Pockets23</td>\n",
       "      <td>OK, I'm coming to realise that I'm wasting my ...</td>\n",
       "      <td>btw, I just looked at the maps. All the blocks...</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>19</td>\n",
       "      <td>0.612903</td>\n",
       "      <td>0.148438</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001852</td>\n",
       "      <td>0.001852</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.625000</td>\n",
       "      <td>0.591165</td>\n",
       "      <td>0.821935</td>\n",
       "      <td>2</td>\n",
       "      <td>0.589103</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2046</th>\n",
       "      <td>Western Wall</td>\n",
       "      <td>Location</td>\n",
       "      <td>Asad112</td>\n",
       "      <td>For those who do not support showing a map of ...</td>\n",
       "      <td>:It's still not part of Israel. Let's not have...</td>\n",
       "      <td>19</td>\n",
       "      <td>35</td>\n",
       "      <td>777</td>\n",
       "      <td>0.646961</td>\n",
       "      <td>0.399076</td>\n",
       "      <td>...</td>\n",
       "      <td>0.010571</td>\n",
       "      <td>0.111639</td>\n",
       "      <td>47.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.891304</td>\n",
       "      <td>0.545504</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.452236</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2047</th>\n",
       "      <td>Western Wall</td>\n",
       "      <td>Location</td>\n",
       "      <td>Chesdovi</td>\n",
       "      <td>::::Sorry, first just to be clear, are you say...</td>\n",
       "      <td>For those who do not support showing a map of ...</td>\n",
       "      <td>14</td>\n",
       "      <td>40</td>\n",
       "      <td>647</td>\n",
       "      <td>0.684656</td>\n",
       "      <td>0.293690</td>\n",
       "      <td>...</td>\n",
       "      <td>0.003316</td>\n",
       "      <td>0.068709</td>\n",
       "      <td>36.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.943925</td>\n",
       "      <td>0.554025</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.507883</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2048</th>\n",
       "      <td>Western Wall</td>\n",
       "      <td>Location</td>\n",
       "      <td>Cptnono</td>\n",
       "      <td>::::No map at all then? This issue is causing ...</td>\n",
       "      <td>For those who do not support showing a map of ...</td>\n",
       "      <td>5</td>\n",
       "      <td>49</td>\n",
       "      <td>189</td>\n",
       "      <td>0.684783</td>\n",
       "      <td>0.065808</td>\n",
       "      <td>...</td>\n",
       "      <td>0.007116</td>\n",
       "      <td>0.041597</td>\n",
       "      <td>9.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>0.582003</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.602339</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2049</th>\n",
       "      <td>Western Wall</td>\n",
       "      <td>Location</td>\n",
       "      <td>Hertz1888</td>\n",
       "      <td>TEMPLATE[od] I don't presume to speak for the ...</td>\n",
       "      <td>For those who do not support showing a map of ...</td>\n",
       "      <td>2</td>\n",
       "      <td>52</td>\n",
       "      <td>76</td>\n",
       "      <td>0.752475</td>\n",
       "      <td>0.024943</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000741</td>\n",
       "      <td>0.000741</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.586355</td>\n",
       "      <td>0.993729</td>\n",
       "      <td>5</td>\n",
       "      <td>0.571825</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2050</th>\n",
       "      <td>Western Wall</td>\n",
       "      <td>Location</td>\n",
       "      <td>Rym torch</td>\n",
       "      <td>Asad, the location (israel vs. OPT) is a matte...</td>\n",
       "      <td>For those who do not support showing a map of ...</td>\n",
       "      <td>2</td>\n",
       "      <td>52</td>\n",
       "      <td>89</td>\n",
       "      <td>0.741667</td>\n",
       "      <td>0.029392</td>\n",
       "      <td>...</td>\n",
       "      <td>0.026573</td>\n",
       "      <td>0.025283</td>\n",
       "      <td>10.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.585644</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.593127</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2051</th>\n",
       "      <td>Yigal Amir</td>\n",
       "      <td>Computer Science student</td>\n",
       "      <td>Gidonb</td>\n",
       "      <td>I have read this in several articles. I provid...</td>\n",
       "      <td>I don't think Yigal was a computer science stu...</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>24</td>\n",
       "      <td>0.242424</td>\n",
       "      <td>0.461538</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000794</td>\n",
       "      <td>0.173662</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.798030</td>\n",
       "      <td>0.590379</td>\n",
       "      <td>0.678503</td>\n",
       "      <td>2</td>\n",
       "      <td>0.703875</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2052</th>\n",
       "      <td>Yigal Amir</td>\n",
       "      <td>Computer Science student</td>\n",
       "      <td>Haham hanuka</td>\n",
       "      <td>I don't think Yigal was a computer science stu...</td>\n",
       "      <td>I have read this in several articles. I provid...</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>24</td>\n",
       "      <td>0.461538</td>\n",
       "      <td>0.242424</td>\n",
       "      <td>...</td>\n",
       "      <td>0.048347</td>\n",
       "      <td>0.132171</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.068306</td>\n",
       "      <td>0.580343</td>\n",
       "      <td>0.756786</td>\n",
       "      <td>2</td>\n",
       "      <td>0.554812</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2053</th>\n",
       "      <td>Yigal Amir</td>\n",
       "      <td>Murdered? Killed? Assassinated?  Or what?</td>\n",
       "      <td>Gidonb</td>\n",
       "      <td>:Haham Hanuka, if this is the case than the JF...</td>\n",
       "      <td>I think it would be better to let the reader t...</td>\n",
       "      <td>3</td>\n",
       "      <td>8</td>\n",
       "      <td>98</td>\n",
       "      <td>0.608696</td>\n",
       "      <td>0.141618</td>\n",
       "      <td>...</td>\n",
       "      <td>0.034228</td>\n",
       "      <td>0.027761</td>\n",
       "      <td>4.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.760300</td>\n",
       "      <td>0.592108</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.559923</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2054</th>\n",
       "      <td>Yigal Amir</td>\n",
       "      <td>Murdered? Killed? Assassinated?  Or what?</td>\n",
       "      <td>Guy Montag</td>\n",
       "      <td>Sorry, but I don't see what the dispute is wit...</td>\n",
       "      <td>I think it would be better to let the reader t...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>91</td>\n",
       "      <td>0.561728</td>\n",
       "      <td>0.131693</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000551</td>\n",
       "      <td>0.175556</td>\n",
       "      <td>4.0</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.922078</td>\n",
       "      <td>0.593140</td>\n",
       "      <td>0.794569</td>\n",
       "      <td>5</td>\n",
       "      <td>0.566204</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2055</th>\n",
       "      <td>Yigal Amir</td>\n",
       "      <td>Murdered? Killed? Assassinated?  Or what?</td>\n",
       "      <td>Haham hanuka</td>\n",
       "      <td>I think it would be better to let the reader t...</td>\n",
       "      <td>A \"helpful killing\"? You really test my abilit...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>28</td>\n",
       "      <td>0.823529</td>\n",
       "      <td>0.034188</td>\n",
       "      <td>...</td>\n",
       "      <td>0.054250</td>\n",
       "      <td>0.001550</td>\n",
       "      <td>4.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.305556</td>\n",
       "      <td>0.612285</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.548578</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2056</th>\n",
       "      <td>Yigal Amir</td>\n",
       "      <td>Murdered? Killed? Assassinated?  Or what?</td>\n",
       "      <td>Jpgordon</td>\n",
       "      <td>A \"helpful killing\"? You really test my abilit...</td>\n",
       "      <td>I think it would be better to let the reader t...</td>\n",
       "      <td>2</td>\n",
       "      <td>9</td>\n",
       "      <td>38</td>\n",
       "      <td>0.760000</td>\n",
       "      <td>0.047323</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001667</td>\n",
       "      <td>0.001667</td>\n",
       "      <td>1.0</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.912500</td>\n",
       "      <td>0.610119</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.596204</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2057</th>\n",
       "      <td>Yigal Amir</td>\n",
       "      <td>Murdered? Killed? Assassinated?  Or what?</td>\n",
       "      <td>Kempler video</td>\n",
       "      <td>last night met with person with more documents...</td>\n",
       "      <td>I think it would be better to let the reader t...</td>\n",
       "      <td>1</td>\n",
       "      <td>10</td>\n",
       "      <td>21</td>\n",
       "      <td>0.420000</td>\n",
       "      <td>0.026152</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001111</td>\n",
       "      <td>0.165947</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.041667</td>\n",
       "      <td>0.614408</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>5</td>\n",
       "      <td>0.711503</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2058</th>\n",
       "      <td>Yishuv</td>\n",
       "      <td>problematic definition</td>\n",
       "      <td>Amoruso</td>\n",
       "      <td>many if not all of the old yishuv were zionist...</td>\n",
       "      <td>While I have agreed with you on similar issues...</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>14</td>\n",
       "      <td>0.152174</td>\n",
       "      <td>0.437500</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000717</td>\n",
       "      <td>0.039323</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.904762</td>\n",
       "      <td>0.607979</td>\n",
       "      <td>0.736113</td>\n",
       "      <td>2</td>\n",
       "      <td>0.574013</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2059</th>\n",
       "      <td>Yishuv</td>\n",
       "      <td>problematic definition</td>\n",
       "      <td>Tewfik</td>\n",
       "      <td>While I have agreed with you on similar issues...</td>\n",
       "      <td>many if not all of the old yishuv were zionist...</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>14</td>\n",
       "      <td>0.437500</td>\n",
       "      <td>0.152174</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001361</td>\n",
       "      <td>0.001361</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.200000</td>\n",
       "      <td>0.595123</td>\n",
       "      <td>0.472037</td>\n",
       "      <td>2</td>\n",
       "      <td>0.558360</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2060</th>\n",
       "      <td>Yitzhak Rabin</td>\n",
       "      <td>POV pushing</td>\n",
       "      <td>Gidonb</td>\n",
       "      <td>Sorry if your commercial interests were hurt, ...</td>\n",
       "      <td>Is there any reasonable explanation why Gidonb...</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>13</td>\n",
       "      <td>0.270833</td>\n",
       "      <td>0.082278</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001149</td>\n",
       "      <td>0.224555</td>\n",
       "      <td>6.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.609125</td>\n",
       "      <td>0.668406</td>\n",
       "      <td>2</td>\n",
       "      <td>0.607002</td>\n",
       "      <td>7</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2061</th>\n",
       "      <td>Yitzhak Rabin</td>\n",
       "      <td>POV pushing</td>\n",
       "      <td>Kempler video</td>\n",
       "      <td>Is there any reasonable explanation why Gidonb...</td>\n",
       "      <td>Sorry if your commercial interests were hurt, ...</td>\n",
       "      <td>2</td>\n",
       "      <td>2</td>\n",
       "      <td>12</td>\n",
       "      <td>0.226415</td>\n",
       "      <td>0.078431</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001389</td>\n",
       "      <td>0.001389</td>\n",
       "      <td>2.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.022989</td>\n",
       "      <td>0.611272</td>\n",
       "      <td>0.710533</td>\n",
       "      <td>2</td>\n",
       "      <td>0.512358</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2062</th>\n",
       "      <td>Yitzhak Shamir</td>\n",
       "      <td>Shamir passes away?</td>\n",
       "      <td>6SJ7</td>\n",
       "      <td>I don't see anything about it on nytimes.com, ...</td>\n",
       "      <td>Has the former Prime Minister died? GoodDay (t...</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>35</td>\n",
       "      <td>0.411765</td>\n",
       "      <td>0.443038</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000833</td>\n",
       "      <td>0.188707</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.564201</td>\n",
       "      <td>0.682177</td>\n",
       "      <td>2</td>\n",
       "      <td>0.595575</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2063</th>\n",
       "      <td>Yitzhak Shamir</td>\n",
       "      <td>Shamir passes away?</td>\n",
       "      <td>GoodDay</td>\n",
       "      <td>Has the former Prime Minister died? GoodDay (t...</td>\n",
       "      <td>I don't see anything about it on nytimes.com, ...</td>\n",
       "      <td>3</td>\n",
       "      <td>2</td>\n",
       "      <td>31</td>\n",
       "      <td>0.455882</td>\n",
       "      <td>0.322917</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001449</td>\n",
       "      <td>0.055032</td>\n",
       "      <td>4.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.142857</td>\n",
       "      <td>0.571667</td>\n",
       "      <td>0.307198</td>\n",
       "      <td>2</td>\n",
       "      <td>0.552838</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2064</th>\n",
       "      <td>Zarqa River</td>\n",
       "      <td>Merge</td>\n",
       "      <td>Badagnani</td>\n",
       "      <td>::I undid the merge because there was text fro...</td>\n",
       "      <td>Jabbok (primarily) discusses the biblical refe...</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>22</td>\n",
       "      <td>0.628571</td>\n",
       "      <td>0.137500</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001667</td>\n",
       "      <td>0.001667</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.036496</td>\n",
       "      <td>0.592597</td>\n",
       "      <td>0.842075</td>\n",
       "      <td>2</td>\n",
       "      <td>0.616180</td>\n",
       "      <td>9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2065</th>\n",
       "      <td>Zarqa River</td>\n",
       "      <td>Merge</td>\n",
       "      <td>NoCal100</td>\n",
       "      <td>Jabbok (primarily) discusses the biblical refe...</td>\n",
       "      <td>:Thanks. I support the merge. :) ChildofMidnig...</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>52</td>\n",
       "      <td>0.448276</td>\n",
       "      <td>0.658228</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>0.000694</td>\n",
       "      <td>3.0</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.986254</td>\n",
       "      <td>0.547303</td>\n",
       "      <td>0.743332</td>\n",
       "      <td>2</td>\n",
       "      <td>0.626797</td>\n",
       "      <td>0</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2066</th>\n",
       "      <td>Zionism</td>\n",
       "      <td>Anti-Zionism=Anti-Semitism meme inserted into ...</td>\n",
       "      <td>Dlv999</td>\n",
       "      <td>I would argue that this is undue and not suita...</td>\n",
       "      <td>It is wp:undue in the lead.\\nThis article conc...</td>\n",
       "      <td>9</td>\n",
       "      <td>40</td>\n",
       "      <td>496</td>\n",
       "      <td>0.657825</td>\n",
       "      <td>0.206066</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000179</td>\n",
       "      <td>0.330466</td>\n",
       "      <td>26.0</td>\n",
       "      <td>5.0</td>\n",
       "      <td>0.333333</td>\n",
       "      <td>0.567284</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.539127</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2067</th>\n",
       "      <td>Zionism</td>\n",
       "      <td>Anti-Zionism=Anti-Semitism meme inserted into ...</td>\n",
       "      <td>IranitGreenberg</td>\n",
       "      <td>::Your version gives anti-Zionist opinions muc...</td>\n",
       "      <td>It is wp:undue in the lead.\\nThis article conc...</td>\n",
       "      <td>15</td>\n",
       "      <td>34</td>\n",
       "      <td>751</td>\n",
       "      <td>0.631092</td>\n",
       "      <td>0.381025</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000145</td>\n",
       "      <td>0.236798</td>\n",
       "      <td>14.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>0.595506</td>\n",
       "      <td>0.549430</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.626605</td>\n",
       "      <td>4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2068</th>\n",
       "      <td>Zionism</td>\n",
       "      <td>Anti-Zionism=Anti-Semitism meme inserted into ...</td>\n",
       "      <td>Iselilja</td>\n",
       "      <td>I think the current version (after new revisio...</td>\n",
       "      <td>It is wp:undue in the lead.\\nThis article conc...</td>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>31</td>\n",
       "      <td>0.688889</td>\n",
       "      <td>0.009949</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001550</td>\n",
       "      <td>0.220120</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.478261</td>\n",
       "      <td>0.591615</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.614646</td>\n",
       "      <td>8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2069</th>\n",
       "      <td>Zionism</td>\n",
       "      <td>Anti-Zionism=Anti-Semitism meme inserted into ...</td>\n",
       "      <td>Pluto2012</td>\n",
       "      <td>It is wp:undue in the lead.\\nThis article conc...</td>\n",
       "      <td>I would argue that this is undue and not suita...</td>\n",
       "      <td>12</td>\n",
       "      <td>37</td>\n",
       "      <td>450</td>\n",
       "      <td>0.775862</td>\n",
       "      <td>0.174351</td>\n",
       "      <td>...</td>\n",
       "      <td>0.004867</td>\n",
       "      <td>0.297218</td>\n",
       "      <td>7.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.353774</td>\n",
       "      <td>0.572612</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.593536</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2070</th>\n",
       "      <td>Zionism</td>\n",
       "      <td>Anti-Zionism=Anti-Semitism meme inserted into ...</td>\n",
       "      <td>Sean.hoyland</td>\n",
       "      <td>::Saying the JVL is an RS is overstating it an...</td>\n",
       "      <td>It is wp:undue in the lead.\\nThis article conc...</td>\n",
       "      <td>2</td>\n",
       "      <td>47</td>\n",
       "      <td>58</td>\n",
       "      <td>0.690476</td>\n",
       "      <td>0.018850</td>\n",
       "      <td>...</td>\n",
       "      <td>0.000952</td>\n",
       "      <td>0.201033</td>\n",
       "      <td>2.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>0.991354</td>\n",
       "      <td>0.590900</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.715438</td>\n",
       "      <td>5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2071</th>\n",
       "      <td>Zionism</td>\n",
       "      <td>Anti-Zionism=Anti-Semitism meme inserted into ...</td>\n",
       "      <td>Tritomex</td>\n",
       "      <td>: Agree with IranitGreenberg. The edits made b...</td>\n",
       "      <td>It is wp:undue in the lead.\\nThis article conc...</td>\n",
       "      <td>5</td>\n",
       "      <td>44</td>\n",
       "      <td>165</td>\n",
       "      <td>0.670732</td>\n",
       "      <td>0.056604</td>\n",
       "      <td>...</td>\n",
       "      <td>0.021941</td>\n",
       "      <td>0.244532</td>\n",
       "      <td>4.0</td>\n",
       "      <td>3.0</td>\n",
       "      <td>0.595506</td>\n",
       "      <td>0.587039</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.564525</td>\n",
       "      <td>1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2072</th>\n",
       "      <td>Zionism</td>\n",
       "      <td>Anti-Zionism=Anti-Semitism meme inserted into ...</td>\n",
       "      <td>Yambaram</td>\n",
       "      <td>:::Sean.hoyland I hope you're aware of the fac...</td>\n",
       "      <td>It is wp:undue in the lead.\\nThis article conc...</td>\n",
       "      <td>1</td>\n",
       "      <td>48</td>\n",
       "      <td>29</td>\n",
       "      <td>0.690476</td>\n",
       "      <td>0.009298</td>\n",
       "      <td>...</td>\n",
       "      <td>0.001235</td>\n",
       "      <td>0.227768</td>\n",
       "      <td>1.0</td>\n",
       "      <td>0.0</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>0.591719</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>7</td>\n",
       "      <td>0.622491</td>\n",
       "      <td>2</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>2073 rows × 48 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                       article  \\\n",
       "0                         1929 Hebron massacre   \n",
       "1                         1929 Hebron massacre   \n",
       "2                         1929 Hebron massacre   \n",
       "3                         1929 Hebron massacre   \n",
       "4                         1929 Hebron massacre   \n",
       "5                         1929 Hebron massacre   \n",
       "6                         1929 Hebron massacre   \n",
       "7                         1929 Hebron massacre   \n",
       "8                         1929 Hebron massacre   \n",
       "9                         1929 Hebron massacre   \n",
       "10                        1929 Hebron massacre   \n",
       "11                        1929 Hebron massacre   \n",
       "12                        1929 Palestine riots   \n",
       "13                        1929 Palestine riots   \n",
       "14                        1929 Palestine riots   \n",
       "15                        1929 Palestine riots   \n",
       "16                        1929 Palestine riots   \n",
       "17                        1929 Palestine riots   \n",
       "18                        1929 Palestine riots   \n",
       "19                        1929 Palestine riots   \n",
       "20                        1929 Palestine riots   \n",
       "21                        1929 Palestine riots   \n",
       "22                        1929 Palestine riots   \n",
       "23                        1929 Palestine riots   \n",
       "24            1936–39 Arab revolt in Palestine   \n",
       "25            1936–39 Arab revolt in Palestine   \n",
       "26            1936–39 Arab revolt in Palestine   \n",
       "27            1936–39 Arab revolt in Palestine   \n",
       "28    1947–48 Civil War in Mandatory Palestine   \n",
       "29    1947–48 Civil War in Mandatory Palestine   \n",
       "...                                        ...   \n",
       "2043                                 West Bank   \n",
       "2044                        West Bank closures   \n",
       "2045                        West Bank closures   \n",
       "2046                              Western Wall   \n",
       "2047                              Western Wall   \n",
       "2048                              Western Wall   \n",
       "2049                              Western Wall   \n",
       "2050                              Western Wall   \n",
       "2051                                Yigal Amir   \n",
       "2052                                Yigal Amir   \n",
       "2053                                Yigal Amir   \n",
       "2054                                Yigal Amir   \n",
       "2055                                Yigal Amir   \n",
       "2056                                Yigal Amir   \n",
       "2057                                Yigal Amir   \n",
       "2058                                    Yishuv   \n",
       "2059                                    Yishuv   \n",
       "2060                             Yitzhak Rabin   \n",
       "2061                             Yitzhak Rabin   \n",
       "2062                            Yitzhak Shamir   \n",
       "2063                            Yitzhak Shamir   \n",
       "2064                               Zarqa River   \n",
       "2065                               Zarqa River   \n",
       "2066                                   Zionism   \n",
       "2067                                   Zionism   \n",
       "2068                                   Zionism   \n",
       "2069                                   Zionism   \n",
       "2070                                   Zionism   \n",
       "2071                                   Zionism   \n",
       "2072                                   Zionism   \n",
       "\n",
       "                                           thread_title  \\\n",
       "0                                           Restatement   \n",
       "1                                           Restatement   \n",
       "2                                           Restatement   \n",
       "3                                           Restatement   \n",
       "4                                           Restatement   \n",
       "5                                           Restatement   \n",
       "6                                           Restatement   \n",
       "7                                          false rumors   \n",
       "8                                          false rumors   \n",
       "9                                          false rumors   \n",
       "10                                         false rumors   \n",
       "11                                         false rumors   \n",
       "12                                            Consensus   \n",
       "13                                            Consensus   \n",
       "14                                            Consensus   \n",
       "15                                            Consensus   \n",
       "16                                            Consensus   \n",
       "17                                            Consensus   \n",
       "18                                            Consensus   \n",
       "19                                    Consensus (again)   \n",
       "20                                    Consensus (again)   \n",
       "21                                    Consensus (again)   \n",
       "22                                    Consensus (again)   \n",
       "23                                    Consensus (again)   \n",
       "24    Purpose of riots and allegations of detentions...   \n",
       "25    Purpose of riots and allegations of detentions...   \n",
       "26    Purpose of riots and allegations of detentions...   \n",
       "27    Purpose of riots and allegations of detentions...   \n",
       "28                                       Errors and POV   \n",
       "29                                       Errors and POV   \n",
       "...                                                 ...   \n",
       "2043                                       Legal status   \n",
       "2044                                    un-encyclopedic   \n",
       "2045                                    un-encyclopedic   \n",
       "2046                                           Location   \n",
       "2047                                           Location   \n",
       "2048                                           Location   \n",
       "2049                                           Location   \n",
       "2050                                           Location   \n",
       "2051                           Computer Science student   \n",
       "2052                           Computer Science student   \n",
       "2053          Murdered? Killed? Assassinated?  Or what?   \n",
       "2054          Murdered? Killed? Assassinated?  Or what?   \n",
       "2055          Murdered? Killed? Assassinated?  Or what?   \n",
       "2056          Murdered? Killed? Assassinated?  Or what?   \n",
       "2057          Murdered? Killed? Assassinated?  Or what?   \n",
       "2058                             problematic definition   \n",
       "2059                             problematic definition   \n",
       "2060                                        POV pushing   \n",
       "2061                                        POV pushing   \n",
       "2062                                Shamir passes away?   \n",
       "2063                                Shamir passes away?   \n",
       "2064                                              Merge   \n",
       "2065                                              Merge   \n",
       "2066  Anti-Zionism=Anti-Semitism meme inserted into ...   \n",
       "2067  Anti-Zionism=Anti-Semitism meme inserted into ...   \n",
       "2068  Anti-Zionism=Anti-Semitism meme inserted into ...   \n",
       "2069  Anti-Zionism=Anti-Semitism meme inserted into ...   \n",
       "2070  Anti-Zionism=Anti-Semitism meme inserted into ...   \n",
       "2071  Anti-Zionism=Anti-Semitism meme inserted into ...   \n",
       "2072  Anti-Zionism=Anti-Semitism meme inserted into ...   \n",
       "\n",
       "                          editor  \\\n",
       "0                     Bless sins   \n",
       "1                        Ceedjee   \n",
       "2                         GHcool   \n",
       "3                  Ian Pitchford   \n",
       "4                      Nishidani   \n",
       "5            PalestineRemembered   \n",
       "6                    Yahel Guhan   \n",
       "7                       Nableezy   \n",
       "8                      Nishidani   \n",
       "9                   Plot Spoiler   \n",
       "10                     Pluto2012   \n",
       "11    Vanished user lt94ma34le12   \n",
       "12                    Brewcrewer   \n",
       "13                        Dlv999   \n",
       "14                    Jabotito48   \n",
       "15                   Oncenawhile   \n",
       "16                        Shrike   \n",
       "17    Vanished user lt94ma34le12   \n",
       "18                      Zero0000   \n",
       "19                    Brewcrewer   \n",
       "20                      Jethro B   \n",
       "21                   Oncenawhile   \n",
       "22                      Tritomex   \n",
       "23                      Zero0000   \n",
       "24                     AladdinSE   \n",
       "25                         Jayjg   \n",
       "26                       Leifern   \n",
       "27                      Zero0000   \n",
       "28                     Pluto2012   \n",
       "29                       Ykantor   \n",
       "...                          ...   \n",
       "2043                        Mor2   \n",
       "2044                     Amoruso   \n",
       "2045                   Pockets23   \n",
       "2046                     Asad112   \n",
       "2047                    Chesdovi   \n",
       "2048                     Cptnono   \n",
       "2049                   Hertz1888   \n",
       "2050                   Rym torch   \n",
       "2051                      Gidonb   \n",
       "2052                Haham hanuka   \n",
       "2053                      Gidonb   \n",
       "2054                  Guy Montag   \n",
       "2055                Haham hanuka   \n",
       "2056                    Jpgordon   \n",
       "2057               Kempler video   \n",
       "2058                     Amoruso   \n",
       "2059                      Tewfik   \n",
       "2060                      Gidonb   \n",
       "2061               Kempler video   \n",
       "2062                        6SJ7   \n",
       "2063                     GoodDay   \n",
       "2064                   Badagnani   \n",
       "2065                    NoCal100   \n",
       "2066                      Dlv999   \n",
       "2067             IranitGreenberg   \n",
       "2068                    Iselilja   \n",
       "2069                   Pluto2012   \n",
       "2070                Sean.hoyland   \n",
       "2071                    Tritomex   \n",
       "2072                    Yambaram   \n",
       "\n",
       "                                            editor_talk  \\\n",
       "0     :\"The massacure was preformed by muslims, ther...   \n",
       "1     Restatement: Sometime ago I asked for source o...   \n",
       "2     :::::::Nishidani's argument for why the Hebron...   \n",
       "3     :And by that logic all killings by Jews would ...   \n",
       "4     ::::::I disagree with your my friend. Benny Mo...   \n",
       "5     :::I'm not sure how you can say \"Hebron massac...   \n",
       "6     The massacure was preformed by muslims, theref...   \n",
       "7     This is silly, but a. false rumors is not exac...   \n",
       "8     ::(ec)It violates WP:NPOV but has some support...   \n",
       "9     Disagree with your position. Whether the rumor...   \n",
       "10    I'd like to point out that the days before the...   \n",
       "11    ::::::The rumours were that a massacre was tak...   \n",
       "12    :To reiterate some of the salient points made ...   \n",
       "13    ::Clearly no consensus, these figure do not re...   \n",
       "14    ::Another source: Arabs killed 133 Jews and wo...   \n",
       "15    Does anybody think there is consensus for the ...   \n",
       "16    :The source in the lead currently states that ...   \n",
       "17    Please read WP:Consensus which explains, \"Here...   \n",
       "18    No, actually you have brushed aside reasonable...   \n",
       "19    ::I'm not exaggerating but I think OAW reverte...   \n",
       "20    :::::::::Just to check... Am I included in \"su...   \n",
       "21    (1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...   \n",
       "22    :::In summary I would say the two Karen Armstr...   \n",
       "23    The Shaw Report says 116 Arabs in total were k...   \n",
       "24    Certainly to put an end to Jewish immigration,...   \n",
       "25    :I find Doron's argument persuasive. Jayjg(tal...   \n",
       "26    The purpose of the riots was to put an end to ...   \n",
       "27    The \"emergency\" practices that the British ado...   \n",
       "28    - Added by Ykantor without signature (Pluto201...   \n",
       "29    The Arabs started the war. This sentence is wr...   \n",
       "...                                                 ...   \n",
       "2043  looking at this paragraph at the Legal status ...   \n",
       "2044  btw, I just looked at the maps. All the blocks...   \n",
       "2045  OK, I'm coming to realise that I'm wasting my ...   \n",
       "2046  For those who do not support showing a map of ...   \n",
       "2047  ::::Sorry, first just to be clear, are you say...   \n",
       "2048  ::::No map at all then? This issue is causing ...   \n",
       "2049  TEMPLATE[od] I don't presume to speak for the ...   \n",
       "2050  Asad, the location (israel vs. OPT) is a matte...   \n",
       "2051  I have read this in several articles. I provid...   \n",
       "2052  I don't think Yigal was a computer science stu...   \n",
       "2053  :Haham Hanuka, if this is the case than the JF...   \n",
       "2054  Sorry, but I don't see what the dispute is wit...   \n",
       "2055  I think it would be better to let the reader t...   \n",
       "2056  A \"helpful killing\"? You really test my abilit...   \n",
       "2057  last night met with person with more documents...   \n",
       "2058  many if not all of the old yishuv were zionist...   \n",
       "2059  While I have agreed with you on similar issues...   \n",
       "2060  Sorry if your commercial interests were hurt, ...   \n",
       "2061  Is there any reasonable explanation why Gidonb...   \n",
       "2062  I don't see anything about it on nytimes.com, ...   \n",
       "2063  Has the former Prime Minister died? GoodDay (t...   \n",
       "2064  ::I undid the merge because there was text fro...   \n",
       "2065  Jabbok (primarily) discusses the biblical refe...   \n",
       "2066  I would argue that this is undue and not suita...   \n",
       "2067  ::Your version gives anti-Zionist opinions muc...   \n",
       "2068  I think the current version (after new revisio...   \n",
       "2069  It is wp:undue in the lead.\\nThis article conc...   \n",
       "2070  ::Saying the JVL is an RS is overstating it an...   \n",
       "2071  : Agree with IranitGreenberg. The edits made b...   \n",
       "2072  :::Sean.hoyland I hope you're aware of the fac...   \n",
       "\n",
       "                                             other_talk  #editor_turns  \\\n",
       "0     Restatement: Sometime ago I asked for source o...              1   \n",
       "1     The massacure was preformed by muslims, theref...              9   \n",
       "2     Restatement: Sometime ago I asked for source o...              1   \n",
       "3     Restatement: Sometime ago I asked for source o...              1   \n",
       "4     Restatement: Sometime ago I asked for source o...              1   \n",
       "5     Restatement: Sometime ago I asked for source o...              1   \n",
       "6     Restatement: Sometime ago I asked for source o...              2   \n",
       "7     I'd like to point out that the days before the...              3   \n",
       "8     This is silly, but a. false rumors is not exac...              9   \n",
       "9     This is silly, but a. false rumors is not exac...              1   \n",
       "10    This is silly, but a. false rumors is not exac...              4   \n",
       "11    This is silly, but a. false rumors is not exac...              1   \n",
       "12    Does anybody think there is consensus for the ...              1   \n",
       "13    Does anybody think there is consensus for the ...             18   \n",
       "14    Does anybody think there is consensus for the ...              1   \n",
       "15    Please read WP:Consensus which explains, \"Here...             20   \n",
       "16    Does anybody think there is consensus for the ...              2   \n",
       "17    Does anybody think there is consensus for the ...             21   \n",
       "18    Does anybody think there is consensus for the ...              4   \n",
       "19    (1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...              1   \n",
       "20    (1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...             23   \n",
       "21    The Shaw Report says 116 Arabs in total were k...             37   \n",
       "22    (1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...              2   \n",
       "23    (1) Jewish casualties:\\n:*PROPOSED TEXT: \"133 ...              1   \n",
       "24    The purpose of the riots was to put an end to ...              8   \n",
       "25    The purpose of the riots was to put an end to ...              2   \n",
       "26    Certainly to put an end to Jewish immigration,...              7   \n",
       "27    The purpose of the riots was to put an end to ...              2   \n",
       "28    The Arabs started the war. This sentence is wr...              1   \n",
       "29    - Added by Ykantor without signature (Pluto201...              3   \n",
       "...                                                 ...            ...   \n",
       "2043  Hi, the UNSC at least said in the cited source...             10   \n",
       "2044  On the fence OR where the settlements are... y...              3   \n",
       "2045  btw, I just looked at the maps. All the blocks...              1   \n",
       "2046  :It's still not part of Israel. Let's not have...             19   \n",
       "2047  For those who do not support showing a map of ...             14   \n",
       "2048  For those who do not support showing a map of ...              5   \n",
       "2049  For those who do not support showing a map of ...              2   \n",
       "2050  For those who do not support showing a map of ...              2   \n",
       "2051  I don't think Yigal was a computer science stu...              3   \n",
       "2052  I have read this in several articles. I provid...              2   \n",
       "2053  I think it would be better to let the reader t...              3   \n",
       "2054  I think it would be better to let the reader t...              1   \n",
       "2055  A \"helpful killing\"? You really test my abilit...              1   \n",
       "2056  I think it would be better to let the reader t...              2   \n",
       "2057  I think it would be better to let the reader t...              1   \n",
       "2058  While I have agreed with you on similar issues...              2   \n",
       "2059  many if not all of the old yishuv were zionist...              1   \n",
       "2060  Is there any reasonable explanation why Gidonb...              1   \n",
       "2061  Sorry if your commercial interests were hurt, ...              2   \n",
       "2062  Has the former Prime Minister died? GoodDay (t...              1   \n",
       "2063  I don't see anything about it on nytimes.com, ...              3   \n",
       "2064  Jabbok (primarily) discusses the biblical refe...              1   \n",
       "2065  :Thanks. I support the merge. :) ChildofMidnig...              3   \n",
       "2066  It is wp:undue in the lead.\\nThis article conc...              9   \n",
       "2067  It is wp:undue in the lead.\\nThis article conc...             15   \n",
       "2068  It is wp:undue in the lead.\\nThis article conc...              1   \n",
       "2069  I would argue that this is undue and not suita...             12   \n",
       "2070  It is wp:undue in the lead.\\nThis article conc...              2   \n",
       "2071  It is wp:undue in the lead.\\nThis article conc...              5   \n",
       "2072  It is wp:undue in the lead.\\nThis article conc...              1   \n",
       "\n",
       "      #other_turns  words_in_common  intersection/editor  intersection/other  \\\n",
       "0               17               40             0.769231            0.017058   \n",
       "1                9              471             0.349407            0.448999   \n",
       "2               17               54             0.729730            0.023246   \n",
       "3               17               23             0.851852            0.009705   \n",
       "4               17              273             0.423256            0.155822   \n",
       "5               17               73             0.760417            0.031725   \n",
       "6               16               33             0.750000            0.014025   \n",
       "7               17               50             0.588235            0.028201   \n",
       "8               11              307             0.237800            0.541446   \n",
       "9               19               43             0.614286            0.024049   \n",
       "10              16              168             0.661417            0.104738   \n",
       "11              19               22             0.785714            0.012022   \n",
       "12              69               34             0.708333            0.008521   \n",
       "13              52              839             0.637054            0.308343   \n",
       "14              69               29             0.828571            0.007245   \n",
       "15              50              736             0.655387            0.252487   \n",
       "16              68               39             0.764706            0.009782   \n",
       "17              49              728             0.658228            0.248295   \n",
       "18              66              156             0.750000            0.040731   \n",
       "19              77               25             0.714286            0.004662   \n",
       "20              55             1131             0.668835            0.305181   \n",
       "21              41             1533             0.553430            0.583555   \n",
       "22              76               64             0.800000            0.012037   \n",
       "23              77              124             0.738095            0.023714   \n",
       "24              22              368             0.606260            0.261364   \n",
       "25              28               38             0.745098            0.019348   \n",
       "26              23              325             0.671488            0.212280   \n",
       "27              28              116             0.620321            0.063457   \n",
       "28               3               23             0.534884            0.057357   \n",
       "29               1               23             0.057357            0.534884   \n",
       "...            ...              ...                  ...                 ...   \n",
       "2043            14              424             0.464403            0.544987   \n",
       "2044             2               29             0.284314            0.508772   \n",
       "2045             4               19             0.612903            0.148438   \n",
       "2046            35              777             0.646961            0.399076   \n",
       "2047            40              647             0.684656            0.293690   \n",
       "2048            49              189             0.684783            0.065808   \n",
       "2049            52               76             0.752475            0.024943   \n",
       "2050            52               89             0.741667            0.029392   \n",
       "2051             2               24             0.242424            0.461538   \n",
       "2052             3               24             0.461538            0.242424   \n",
       "2053             8               98             0.608696            0.141618   \n",
       "2054            10               91             0.561728            0.131693   \n",
       "2055            10               28             0.823529            0.034188   \n",
       "2056             9               38             0.760000            0.047323   \n",
       "2057            10               21             0.420000            0.026152   \n",
       "2058             1               14             0.152174            0.437500   \n",
       "2059             2               14             0.437500            0.152174   \n",
       "2060             3               13             0.270833            0.082278   \n",
       "2061             2               12             0.226415            0.078431   \n",
       "2062             4               35             0.411765            0.443038   \n",
       "2063             2               31             0.455882            0.322917   \n",
       "2064             5               22             0.628571            0.137500   \n",
       "2065             3               52             0.448276            0.658228   \n",
       "2066            40              496             0.657825            0.206066   \n",
       "2067            34              751             0.631092            0.381025   \n",
       "2068            48               31             0.688889            0.009949   \n",
       "2069            37              450             0.775862            0.174351   \n",
       "2070            47               58             0.690476            0.018850   \n",
       "2071            44              165             0.670732            0.056604   \n",
       "2072            48               29             0.690476            0.009298   \n",
       "\n",
       "      ...        T13       T14  SENTI::POS  SENTI::NEG  editor_score  \\\n",
       "0     ...   0.001481  0.001481         0.0         3.0      0.000000   \n",
       "1     ...   0.000117  0.261022        32.0        12.0      0.800000   \n",
       "2     ...   0.000913  0.401444         1.0         1.0      0.968750   \n",
       "3     ...   0.002151  0.002151         0.0         1.0      1.000000   \n",
       "4     ...   0.000153  0.283555        34.0         5.0      0.860870   \n",
       "5     ...   0.000660  0.175090         4.0         1.0      0.710870   \n",
       "6     ...   0.001852  0.001852         1.0         1.0      0.500000   \n",
       "7     ...   0.001026  0.073913         3.0         0.0      0.000000   \n",
       "8     ...   0.000121  0.351416        57.0        20.0      0.996139   \n",
       "9     ...   0.001111  0.001111         1.0         0.0      1.000000   \n",
       "10    ...   0.000460  0.326092        11.0         3.0      1.000000   \n",
       "11    ...   0.002564  0.147679         0.0         0.0      0.745098   \n",
       "12    ...   0.001111  0.142208         2.0         1.0      0.000000   \n",
       "13    ...   0.000133  0.457191        51.0        22.0      0.869565   \n",
       "14    ...   0.002299  0.002299         0.0         3.0      0.167488   \n",
       "15    ...   0.000152  0.225220        42.0        10.0      0.788136   \n",
       "16    ...   0.001626  0.001626         2.0         1.0      0.739130   \n",
       "17    ...   0.000139  0.526139        43.0         9.0      0.357447   \n",
       "18    ...   0.000439  0.165775        12.0         0.0      0.937778   \n",
       "19    ...   0.001852  0.001852         1.0         0.0      0.663793   \n",
       "20    ...   0.000109  0.275448        67.0        18.0      0.975610   \n",
       "21    ...   0.000081  0.413328       140.0        35.0      0.319672   \n",
       "22    ...   0.000913  0.060857         4.0         0.0      1.000000   \n",
       "23    ...   0.000447  0.138467         3.0         6.0      0.915556   \n",
       "24    ...   0.000180  0.184760        23.0         3.0      0.111111   \n",
       "25    ...   0.001515  0.079055         1.0         1.0      0.966667   \n",
       "26    ...   0.000221  0.203683        24.0         3.0      0.960000   \n",
       "27    ...   0.000463  0.264312         1.0         2.0      0.272727   \n",
       "28    ...   0.002083  0.191614         0.0         0.0      0.000000   \n",
       "29    ...   0.000252  0.269910        14.0         2.0      1.000000   \n",
       "...   ...        ...       ...         ...         ...           ...   \n",
       "2043  ...   0.003773  0.124187        43.0         3.0      0.533666   \n",
       "2044  ...   0.000775  0.000775         1.0         0.0      1.000000   \n",
       "2045  ...   0.001852  0.001852         1.0         0.0      0.625000   \n",
       "2046  ...   0.010571  0.111639        47.0         3.0      0.891304   \n",
       "2047  ...   0.003316  0.068709        36.0         3.0      0.943925   \n",
       "2048  ...   0.007116  0.041597         9.0         3.0      0.000000   \n",
       "2049  ...   0.000741  0.000741         2.0         1.0      1.000000   \n",
       "2050  ...   0.026573  0.025283        10.0         0.0      1.000000   \n",
       "2051  ...   0.000794  0.173662         4.0         1.0      0.798030   \n",
       "2052  ...   0.048347  0.132171         4.0         0.0      0.068306   \n",
       "2053  ...   0.034228  0.027761         4.0         2.0      0.760300   \n",
       "2054  ...   0.000551  0.175556         4.0         4.0      0.922078   \n",
       "2055  ...   0.054250  0.001550         4.0         1.0      0.305556   \n",
       "2056  ...   0.001667  0.001667         1.0         2.0      0.912500   \n",
       "2057  ...   0.001111  0.165947         2.0         0.0      0.041667   \n",
       "2058  ...   0.000717  0.039323         0.0         0.0      0.904762   \n",
       "2059  ...   0.001361  0.001361         3.0         0.0      0.200000   \n",
       "2060  ...   0.001149  0.224555         6.0         1.0      1.000000   \n",
       "2061  ...   0.001389  0.001389         2.0         1.0      0.022989   \n",
       "2062  ...   0.000833  0.188707         4.0         0.0      1.000000   \n",
       "2063  ...   0.001449  0.055032         4.0         0.0      0.142857   \n",
       "2064  ...   0.001667  0.001667         0.0         0.0      0.036496   \n",
       "2065  ...   0.000694  0.000694         3.0         1.0      0.986254   \n",
       "2066  ...   0.000179  0.330466        26.0         5.0      0.333333   \n",
       "2067  ...   0.000145  0.236798        14.0         8.0      0.595506   \n",
       "2068  ...   0.001550  0.220120         1.0         0.0      0.478261   \n",
       "2069  ...   0.004867  0.297218         7.0         0.0      0.353774   \n",
       "2070  ...   0.000952  0.201033         2.0         0.0      0.991354   \n",
       "2071  ...   0.021941  0.244532         4.0         3.0      0.595506   \n",
       "2072  ...   0.001235  0.227768         1.0         0.0      1.000000   \n",
       "\n",
       "      nonbow_pred      pred  num_users    edpred  fold  \n",
       "0        0.620913  0.463035          7  0.506138     3  \n",
       "1        0.572965  0.796302          7  0.500023     9  \n",
       "2        0.617757  0.638528          7  0.580395     5  \n",
       "3        0.626133  0.353466          7  0.603239     9  \n",
       "4        0.581121  1.000000          7  0.510341     1  \n",
       "5        0.616858  0.507072          7  0.595210     9  \n",
       "6        0.621627  0.631426          7  0.524619     1  \n",
       "7        0.610954  1.000000          5  0.466697     1  \n",
       "8        0.593936  1.000000          5  0.631038     4  \n",
       "9        0.611561  1.000000          5  0.614233     2  \n",
       "10       0.596919  1.000000          5  0.573189     0  \n",
       "11       0.621461  1.000000          5  0.631907     0  \n",
       "12       0.583133  1.000000          7  0.625979     7  \n",
       "13       0.530606  1.000000          7  0.517580     0  \n",
       "14       0.588342  1.000000          7  0.614020     0  \n",
       "15       0.541281  0.753924          7  0.483097     6  \n",
       "16       0.585801  1.000000          7  0.611930     4  \n",
       "17       0.542755  0.068906          7  0.455967     2  \n",
       "18       0.578581  1.000000          7  0.577084     9  \n",
       "19       0.578607  0.932676          5  0.599022     1  \n",
       "20       0.526717  0.000000          5  0.475458     9  \n",
       "21       0.513006  1.000000          5  0.270524     5  \n",
       "22       0.580782  1.000000          5  0.571101     4  \n",
       "23       0.574408  1.000000          5  0.612783     5  \n",
       "24       0.562309  0.006716          4  0.513338     6  \n",
       "25       0.611486  0.005668          4  0.594287     1  \n",
       "26       0.570209  0.437216          4  0.476375     9  \n",
       "27       0.595978  0.336923          4  0.584237     7  \n",
       "28       0.612654  1.000000          2  0.635160     5  \n",
       "29       0.644839  0.255258          2  0.559567     8  \n",
       "...           ...       ...        ...       ...   ...  \n",
       "2043     0.554176  0.722660          3  0.417054     6  \n",
       "2044     0.582467  0.432421          2  0.573829     4  \n",
       "2045     0.591165  0.821935          2  0.589103     9  \n",
       "2046     0.545504  1.000000          5  0.452236     0  \n",
       "2047     0.554025  0.000000          5  0.507883     8  \n",
       "2048     0.582003  1.000000          5  0.602339     8  \n",
       "2049     0.586355  0.993729          5  0.571825     6  \n",
       "2050     0.585644  1.000000          5  0.593127     4  \n",
       "2051     0.590379  0.678503          2  0.703875     7  \n",
       "2052     0.580343  0.756786          2  0.554812     1  \n",
       "2053     0.592108  1.000000          5  0.559923     1  \n",
       "2054     0.593140  0.794569          5  0.566204     6  \n",
       "2055     0.612285  1.000000          5  0.548578     4  \n",
       "2056     0.610119  1.000000          5  0.596204     7  \n",
       "2057     0.614408  1.000000          5  0.711503     2  \n",
       "2058     0.607979  0.736113          2  0.574013     8  \n",
       "2059     0.595123  0.472037          2  0.558360     8  \n",
       "2060     0.609125  0.668406          2  0.607002     7  \n",
       "2061     0.611272  0.710533          2  0.512358     6  \n",
       "2062     0.564201  0.682177          2  0.595575     6  \n",
       "2063     0.571667  0.307198          2  0.552838     5  \n",
       "2064     0.592597  0.842075          2  0.616180     9  \n",
       "2065     0.547303  0.743332          2  0.626797     0  \n",
       "2066     0.567284  0.000000          7  0.539127     3  \n",
       "2067     0.549430  0.000000          7  0.626605     4  \n",
       "2068     0.591615  0.000000          7  0.614646     8  \n",
       "2069     0.572612  0.000000          7  0.593536     6  \n",
       "2070     0.590900  0.000000          7  0.715438     5  \n",
       "2071     0.587039  0.000000          7  0.564525     1  \n",
       "2072     0.591719  0.000000          7  0.622491     2  \n",
       "\n",
       "[2073 rows x 48 columns]"
      ]
     },
     "execution_count": 3,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "icwsm_data = pd.read_csv('/home/michael/school/research/wp/wikipedia/data/revert_discussion_features.csv')\n",
    "icwsm_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "655"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "scored_threads = set(zip(icwsm_data['article'], icwsm_data['thread_title']))\n",
    "len(scored_threads)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {
    "collapsed": false,
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "9145\n",
      "38473\n"
     ]
    }
   ],
   "source": [
    "mask = [tup in scored_threads for tup in zip(all_talk['article_title'], all_talk['thread_title'])]\n",
    "scored_talk = all_talk[mask]\n",
    "print(len(scored_talk))\n",
    "print(len(all_talk))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "scored_talk.to_csv('/home/michael/school/research/wp/wikipedia/data/scored_ipc_talk.csv', index=None)"
   ]
  }
 ],
 "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.5.2+"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 0
}