trim_highlow.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 15,
   "metadata": {},
   "outputs": [],
   "source": [
    "import gzip, csv, json\n",
    "import pandas as pd\n",
    "import seaborn as sb\n",
    "import numpy as np\n",
    "import matplotlib.pyplot as plt\n",
    "import random"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [],
   "source": [
    "time_ref = pd.read_csv('final_low.csv', sep=',', header=None, names=['author', 'count', 'month'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_ref = pd.read_csv('./low.csv', sep=',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>author</th>\n",
       "      <th>num_archived_comm</th>\n",
       "      <th>num_subs</th>\n",
       "      <th>min_score</th>\n",
       "      <th>max_score</th>\n",
       "      <th>avg_score</th>\n",
       "      <th>std_score</th>\n",
       "      <th>num_contra_comm</th>\n",
       "      <th>num_gilded_comm</th>\n",
       "      <th>num_distinguished_comm</th>\n",
       "      <th>...</th>\n",
       "      <th>avg_replies</th>\n",
       "      <th>std_replies</th>\n",
       "      <th>num_gilded_posts</th>\n",
       "      <th>num_distinguished_posts</th>\n",
       "      <th>num_posts</th>\n",
       "      <th>month_active_posts</th>\n",
       "      <th>consp_posts</th>\n",
       "      <th>num_stickied_posts</th>\n",
       "      <th>num_over18_posts</th>\n",
       "      <th>avg_postlen</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>_TheDreamer_</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>5</td>\n",
       "      <td>1.625000</td>\n",
       "      <td>1.407886</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.548387</td>\n",
       "      <td>23.300699</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0.525997</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>79.322581</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>BlueCaffe</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-3</td>\n",
       "      <td>12</td>\n",
       "      <td>1.583333</td>\n",
       "      <td>3.502164</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>22.483871</td>\n",
       "      <td>79.365345</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>1.037200</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>0</td>\n",
       "      <td>45.645161</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>vegority7</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-4</td>\n",
       "      <td>155</td>\n",
       "      <td>16.357143</td>\n",
       "      <td>40.759345</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>3.000000</td>\n",
       "      <td>5.156378</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>5.226300</td>\n",
       "      <td>18</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>102.722222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>Godlikeconspiracy</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.888889</td>\n",
       "      <td>6.197601</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>1.002080</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>64.814815</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>JimEastWestSr_SUX</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>3.272727</td>\n",
       "      <td>3.947093</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>8.937500</td>\n",
       "      <td>9.066192</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>16</td>\n",
       "      <td>0.600165</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>0</td>\n",
       "      <td>64.437500</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>Stepwithvigilance</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-1</td>\n",
       "      <td>20</td>\n",
       "      <td>2.180556</td>\n",
       "      <td>2.815082</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>16.365385</td>\n",
       "      <td>43.659569</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>6.455086</td>\n",
       "      <td>52</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>98.211538</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>trollingtrollers</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>699</td>\n",
       "      <td>24.444444</td>\n",
       "      <td>103.827557</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>34.384615</td>\n",
       "      <td>72.083908</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>2.896401</td>\n",
       "      <td>13</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>185.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>purplepeopleeaters94</td>\n",
       "      <td>0</td>\n",
       "      <td>5</td>\n",
       "      <td>-6</td>\n",
       "      <td>23</td>\n",
       "      <td>2.905512</td>\n",
       "      <td>3.818154</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>21.913043</td>\n",
       "      <td>22.003952</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>23</td>\n",
       "      <td>11.661671</td>\n",
       "      <td>23</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>55.608696</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>SandyHoaxParent</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>-18</td>\n",
       "      <td>15</td>\n",
       "      <td>1.090909</td>\n",
       "      <td>4.169759</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.774194</td>\n",
       "      <td>2.765377</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>0.144751</td>\n",
       "      <td>31</td>\n",
       "      <td>31</td>\n",
       "      <td>1</td>\n",
       "      <td>26.225806</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>pumaspacetrain</td>\n",
       "      <td>3</td>\n",
       "      <td>5</td>\n",
       "      <td>-1</td>\n",
       "      <td>21</td>\n",
       "      <td>2.745283</td>\n",
       "      <td>3.375151</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9.416667</td>\n",
       "      <td>4.907477</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>12</td>\n",
       "      <td>13.942422</td>\n",
       "      <td>12</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>66.916667</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>charitwo</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-13</td>\n",
       "      <td>32</td>\n",
       "      <td>5.461538</td>\n",
       "      <td>10.261504</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>75.066667</td>\n",
       "      <td>164.668701</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>1.157483</td>\n",
       "      <td>15</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>124.400000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>DAY_OF_THEE_ROPE</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>-34</td>\n",
       "      <td>60</td>\n",
       "      <td>3.794979</td>\n",
       "      <td>8.659515</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9.272727</td>\n",
       "      <td>11.816783</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>7.009171</td>\n",
       "      <td>22</td>\n",
       "      <td>22</td>\n",
       "      <td>0</td>\n",
       "      <td>74.636364</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>WixFix</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9.484848</td>\n",
       "      <td>15.449760</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>0.339850</td>\n",
       "      <td>18</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>49.606061</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>TheModernGnostic</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-4</td>\n",
       "      <td>2</td>\n",
       "      <td>0.222222</td>\n",
       "      <td>1.592466</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.017857</td>\n",
       "      <td>0.133631</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>56</td>\n",
       "      <td>1.908844</td>\n",
       "      <td>49</td>\n",
       "      <td>56</td>\n",
       "      <td>0</td>\n",
       "      <td>70.446429</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>Global_Agenda</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1</td>\n",
       "      <td>1.000000</td>\n",
       "      <td>NaN</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>0.240506</td>\n",
       "      <td>0.894645</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>79</td>\n",
       "      <td>5.756645</td>\n",
       "      <td>78</td>\n",
       "      <td>79</td>\n",
       "      <td>0</td>\n",
       "      <td>68.645570</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>_Lokis_Revenge</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>-2</td>\n",
       "      <td>29</td>\n",
       "      <td>3.508772</td>\n",
       "      <td>5.922484</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.489796</td>\n",
       "      <td>28.464248</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>0.525931</td>\n",
       "      <td>15</td>\n",
       "      <td>49</td>\n",
       "      <td>0</td>\n",
       "      <td>48.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>CRYlikeROBBIEparker</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>1</td>\n",
       "      <td>4</td>\n",
       "      <td>1.750000</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.518519</td>\n",
       "      <td>18.780863</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>27</td>\n",
       "      <td>5.562223</td>\n",
       "      <td>26</td>\n",
       "      <td>27</td>\n",
       "      <td>0</td>\n",
       "      <td>32.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>Junglist87</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>143</td>\n",
       "      <td>11.094340</td>\n",
       "      <td>25.077008</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>26.307692</td>\n",
       "      <td>70.890038</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>4.144426</td>\n",
       "      <td>12</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>65.692308</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>anonymousgate</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>-2</td>\n",
       "      <td>23</td>\n",
       "      <td>4.586207</td>\n",
       "      <td>4.888158</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>38.684211</td>\n",
       "      <td>73.386384</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>9.997154</td>\n",
       "      <td>18</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>89.000000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>verity_</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>2.631579</td>\n",
       "      <td>3.803661</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.482759</td>\n",
       "      <td>15.830848</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>29</td>\n",
       "      <td>1.813530</td>\n",
       "      <td>23</td>\n",
       "      <td>29</td>\n",
       "      <td>0</td>\n",
       "      <td>64.896552</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>doobeyhoser</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>-4</td>\n",
       "      <td>143</td>\n",
       "      <td>9.000000</td>\n",
       "      <td>28.709944</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.100000</td>\n",
       "      <td>5.492000</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>30</td>\n",
       "      <td>0.422368</td>\n",
       "      <td>19</td>\n",
       "      <td>30</td>\n",
       "      <td>0</td>\n",
       "      <td>47.033333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>curiousorganelle</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>-11</td>\n",
       "      <td>213</td>\n",
       "      <td>4.557078</td>\n",
       "      <td>18.959885</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.235294</td>\n",
       "      <td>7.437485</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>18.802230</td>\n",
       "      <td>16</td>\n",
       "      <td>17</td>\n",
       "      <td>0</td>\n",
       "      <td>71.764706</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>logan_f</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>-3</td>\n",
       "      <td>79</td>\n",
       "      <td>3.629213</td>\n",
       "      <td>8.756014</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>18.333333</td>\n",
       "      <td>19.554563</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>7.558664</td>\n",
       "      <td>14</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>50.733333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>HairlessApe</td>\n",
       "      <td>20</td>\n",
       "      <td>11</td>\n",
       "      <td>-8</td>\n",
       "      <td>30</td>\n",
       "      <td>4.000000</td>\n",
       "      <td>6.621790</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>11.477612</td>\n",
       "      <td>50.660408</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>134</td>\n",
       "      <td>20.791413</td>\n",
       "      <td>133</td>\n",
       "      <td>134</td>\n",
       "      <td>0</td>\n",
       "      <td>81.649254</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>legend747</td>\n",
       "      <td>0</td>\n",
       "      <td>4</td>\n",
       "      <td>-3</td>\n",
       "      <td>44</td>\n",
       "      <td>3.858156</td>\n",
       "      <td>5.270048</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.620690</td>\n",
       "      <td>8.470439</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>58</td>\n",
       "      <td>17.331317</td>\n",
       "      <td>56</td>\n",
       "      <td>58</td>\n",
       "      <td>0</td>\n",
       "      <td>61.103448</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>klooj_</td>\n",
       "      <td>0</td>\n",
       "      <td>21</td>\n",
       "      <td>-66</td>\n",
       "      <td>697</td>\n",
       "      <td>10.775194</td>\n",
       "      <td>61.800238</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>20.100000</td>\n",
       "      <td>33.467816</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>5.258345</td>\n",
       "      <td>13</td>\n",
       "      <td>20</td>\n",
       "      <td>1</td>\n",
       "      <td>69.200000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>Itmustjustbeme</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>-10</td>\n",
       "      <td>51</td>\n",
       "      <td>3.089744</td>\n",
       "      <td>5.393391</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>12.050000</td>\n",
       "      <td>16.847536</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>13.362576</td>\n",
       "      <td>19</td>\n",
       "      <td>20</td>\n",
       "      <td>0</td>\n",
       "      <td>63.100000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>MrTinFoilHat187</td>\n",
       "      <td>0</td>\n",
       "      <td>6</td>\n",
       "      <td>-13</td>\n",
       "      <td>53</td>\n",
       "      <td>2.601852</td>\n",
       "      <td>6.798763</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.400000</td>\n",
       "      <td>16.540238</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>40</td>\n",
       "      <td>6.050165</td>\n",
       "      <td>39</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>72.975000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>mrjohnnyp</td>\n",
       "      <td>0</td>\n",
       "      <td>17</td>\n",
       "      <td>-3</td>\n",
       "      <td>214</td>\n",
       "      <td>7.213415</td>\n",
       "      <td>20.086245</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.736842</td>\n",
       "      <td>12.735960</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>19</td>\n",
       "      <td>9.886267</td>\n",
       "      <td>17</td>\n",
       "      <td>19</td>\n",
       "      <td>0</td>\n",
       "      <td>96.157895</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>hurtpeoplehurtpe0ple</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>-5</td>\n",
       "      <td>51</td>\n",
       "      <td>3.963636</td>\n",
       "      <td>8.517876</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>15.803922</td>\n",
       "      <td>51.653081</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>7.001221</td>\n",
       "      <td>50</td>\n",
       "      <td>51</td>\n",
       "      <td>0</td>\n",
       "      <td>97.137255</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>6885</th>\n",
       "      <td>sunshine242</td>\n",
       "      <td>0</td>\n",
       "      <td>7</td>\n",
       "      <td>-2</td>\n",
       "      <td>33</td>\n",
       "      <td>3.540984</td>\n",
       "      <td>5.117206</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>12.733333</td>\n",
       "      <td>8.899973</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>15</td>\n",
       "      <td>14.852139</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "      <td>0</td>\n",
       "      <td>80.333333</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6886</th>\n",
       "      <td>DontShoot2Kill</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>-2</td>\n",
       "      <td>201</td>\n",
       "      <td>8.088235</td>\n",
       "      <td>34.207360</td>\n",
       "      <td>4</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.030303</td>\n",
       "      <td>9.967086</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>33</td>\n",
       "      <td>1.202983</td>\n",
       "      <td>11</td>\n",
       "      <td>33</td>\n",
       "      <td>0</td>\n",
       "      <td>102.393939</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6887</th>\n",
       "      <td>Sursum_Corda</td>\n",
       "      <td>5</td>\n",
       "      <td>39</td>\n",
       "      <td>-10</td>\n",
       "      <td>124</td>\n",
       "      <td>4.723881</td>\n",
       "      <td>12.183060</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.500000</td>\n",
       "      <td>8.125848</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>21.170998</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>68.111111</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6888</th>\n",
       "      <td>mistahbang</td>\n",
       "      <td>90</td>\n",
       "      <td>21</td>\n",
       "      <td>-48</td>\n",
       "      <td>518</td>\n",
       "      <td>5.789916</td>\n",
       "      <td>35.165282</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>32.388889</td>\n",
       "      <td>41.269757</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>18</td>\n",
       "      <td>20.850160</td>\n",
       "      <td>11</td>\n",
       "      <td>18</td>\n",
       "      <td>0</td>\n",
       "      <td>44.722222</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6889</th>\n",
       "      <td>MasterOfNotAThing</td>\n",
       "      <td>0</td>\n",
       "      <td>32</td>\n",
       "      <td>-20</td>\n",
       "      <td>92</td>\n",
       "      <td>4.012987</td>\n",
       "      <td>10.098849</td>\n",
       "      <td>8</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>18.960000</td>\n",
       "      <td>76.365066</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>25</td>\n",
       "      <td>23.485949</td>\n",
       "      <td>11</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>90.760000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6890</th>\n",
       "      <td>Ironmanjc3</td>\n",
       "      <td>0</td>\n",
       "      <td>24</td>\n",
       "      <td>-88</td>\n",
       "      <td>53</td>\n",
       "      <td>1.007353</td>\n",
       "      <td>10.550406</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>4.590909</td>\n",
       "      <td>5.011027</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>22</td>\n",
       "      <td>3.292707</td>\n",
       "      <td>11</td>\n",
       "      <td>22</td>\n",
       "      <td>1</td>\n",
       "      <td>61.318182</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6891</th>\n",
       "      <td>bhaga</td>\n",
       "      <td>0</td>\n",
       "      <td>13</td>\n",
       "      <td>-54</td>\n",
       "      <td>197</td>\n",
       "      <td>6.511278</td>\n",
       "      <td>16.472558</td>\n",
       "      <td>32</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.615385</td>\n",
       "      <td>15.641169</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>26</td>\n",
       "      <td>19.728821</td>\n",
       "      <td>11</td>\n",
       "      <td>26</td>\n",
       "      <td>0</td>\n",
       "      <td>105.076923</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6892</th>\n",
       "      <td>kyle_rearden</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>-8</td>\n",
       "      <td>4</td>\n",
       "      <td>1.025974</td>\n",
       "      <td>1.385774</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.468750</td>\n",
       "      <td>4.235034</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>64</td>\n",
       "      <td>3.408873</td>\n",
       "      <td>11</td>\n",
       "      <td>64</td>\n",
       "      <td>0</td>\n",
       "      <td>56.968750</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6893</th>\n",
       "      <td>joshthephysicist</td>\n",
       "      <td>1112</td>\n",
       "      <td>89</td>\n",
       "      <td>-31</td>\n",
       "      <td>554</td>\n",
       "      <td>5.728855</td>\n",
       "      <td>21.616480</td>\n",
       "      <td>17</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>15.207921</td>\n",
       "      <td>41.968159</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>101</td>\n",
       "      <td>5.027130</td>\n",
       "      <td>11</td>\n",
       "      <td>101</td>\n",
       "      <td>0</td>\n",
       "      <td>67.287129</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6894</th>\n",
       "      <td>RedPillEH</td>\n",
       "      <td>0</td>\n",
       "      <td>31</td>\n",
       "      <td>-95</td>\n",
       "      <td>397</td>\n",
       "      <td>2.437282</td>\n",
       "      <td>19.501700</td>\n",
       "      <td>47</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>7.744186</td>\n",
       "      <td>19.766987</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>86</td>\n",
       "      <td>7.732324</td>\n",
       "      <td>11</td>\n",
       "      <td>86</td>\n",
       "      <td>1</td>\n",
       "      <td>56.511628</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6895</th>\n",
       "      <td>Farthrower1</td>\n",
       "      <td>0</td>\n",
       "      <td>20</td>\n",
       "      <td>-3</td>\n",
       "      <td>59</td>\n",
       "      <td>3.794118</td>\n",
       "      <td>7.367715</td>\n",
       "      <td>2</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>12.432432</td>\n",
       "      <td>33.507495</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>37</td>\n",
       "      <td>10.850082</td>\n",
       "      <td>11</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>39.486486</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6896</th>\n",
       "      <td>teein_off</td>\n",
       "      <td>0</td>\n",
       "      <td>9</td>\n",
       "      <td>-7</td>\n",
       "      <td>166</td>\n",
       "      <td>5.184874</td>\n",
       "      <td>19.149707</td>\n",
       "      <td>5</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>1.833333</td>\n",
       "      <td>3.721504</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>21.079121</td>\n",
       "      <td>11</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>40.142857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6897</th>\n",
       "      <td>Dosbi_Ausbi</td>\n",
       "      <td>0</td>\n",
       "      <td>35</td>\n",
       "      <td>-42</td>\n",
       "      <td>870</td>\n",
       "      <td>4.857934</td>\n",
       "      <td>39.513541</td>\n",
       "      <td>67</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.643678</td>\n",
       "      <td>12.410589</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>87</td>\n",
       "      <td>15.637632</td>\n",
       "      <td>11</td>\n",
       "      <td>87</td>\n",
       "      <td>2</td>\n",
       "      <td>68.597701</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6898</th>\n",
       "      <td>mineben256</td>\n",
       "      <td>1</td>\n",
       "      <td>21</td>\n",
       "      <td>-4</td>\n",
       "      <td>34</td>\n",
       "      <td>1.950777</td>\n",
       "      <td>3.156549</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>11.750000</td>\n",
       "      <td>25.646828</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>23.940161</td>\n",
       "      <td>11</td>\n",
       "      <td>52</td>\n",
       "      <td>0</td>\n",
       "      <td>54.653846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6899</th>\n",
       "      <td>gobuffs10</td>\n",
       "      <td>70</td>\n",
       "      <td>58</td>\n",
       "      <td>-45</td>\n",
       "      <td>279</td>\n",
       "      <td>5.059337</td>\n",
       "      <td>20.420663</td>\n",
       "      <td>12</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>13.980000</td>\n",
       "      <td>13.377547</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>50</td>\n",
       "      <td>23.374653</td>\n",
       "      <td>11</td>\n",
       "      <td>50</td>\n",
       "      <td>1</td>\n",
       "      <td>60.420000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6900</th>\n",
       "      <td>BeatnikMessiah</td>\n",
       "      <td>0</td>\n",
       "      <td>51</td>\n",
       "      <td>-5</td>\n",
       "      <td>386</td>\n",
       "      <td>4.341826</td>\n",
       "      <td>21.001619</td>\n",
       "      <td>6</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.083333</td>\n",
       "      <td>6.049203</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>36</td>\n",
       "      <td>24.226234</td>\n",
       "      <td>11</td>\n",
       "      <td>36</td>\n",
       "      <td>0</td>\n",
       "      <td>25.194444</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6901</th>\n",
       "      <td>Boroku87</td>\n",
       "      <td>0</td>\n",
       "      <td>2</td>\n",
       "      <td>1</td>\n",
       "      <td>3</td>\n",
       "      <td>1.500000</td>\n",
       "      <td>0.755929</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.900000</td>\n",
       "      <td>6.260412</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>70</td>\n",
       "      <td>5.608296</td>\n",
       "      <td>11</td>\n",
       "      <td>70</td>\n",
       "      <td>10</td>\n",
       "      <td>37.114286</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6902</th>\n",
       "      <td>Bannanadonut342</td>\n",
       "      <td>0</td>\n",
       "      <td>11</td>\n",
       "      <td>-3</td>\n",
       "      <td>3</td>\n",
       "      <td>1.088889</td>\n",
       "      <td>0.848052</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.761905</td>\n",
       "      <td>5.011253</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>42</td>\n",
       "      <td>2.618324</td>\n",
       "      <td>11</td>\n",
       "      <td>42</td>\n",
       "      <td>0</td>\n",
       "      <td>79.642857</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6903</th>\n",
       "      <td>MrArchibaldMeatpants</td>\n",
       "      <td>0</td>\n",
       "      <td>122</td>\n",
       "      <td>-92</td>\n",
       "      <td>193</td>\n",
       "      <td>2.485493</td>\n",
       "      <td>10.633664</td>\n",
       "      <td>25</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>9.337838</td>\n",
       "      <td>14.994316</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>74</td>\n",
       "      <td>23.864327</td>\n",
       "      <td>11</td>\n",
       "      <td>74</td>\n",
       "      <td>17</td>\n",
       "      <td>61.932432</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6904</th>\n",
       "      <td>SlothropsKnob</td>\n",
       "      <td>0</td>\n",
       "      <td>186</td>\n",
       "      <td>-10</td>\n",
       "      <td>1168</td>\n",
       "      <td>11.614148</td>\n",
       "      <td>65.917401</td>\n",
       "      <td>10</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>19.615385</td>\n",
       "      <td>96.189387</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>52</td>\n",
       "      <td>21.315178</td>\n",
       "      <td>11</td>\n",
       "      <td>52</td>\n",
       "      <td>1</td>\n",
       "      <td>85.153846</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6905</th>\n",
       "      <td>RogueTaxidermist</td>\n",
       "      <td>0</td>\n",
       "      <td>49</td>\n",
       "      <td>-78</td>\n",
       "      <td>984</td>\n",
       "      <td>12.080605</td>\n",
       "      <td>72.016998</td>\n",
       "      <td>11</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>6.598639</td>\n",
       "      <td>38.663272</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>294</td>\n",
       "      <td>23.092553</td>\n",
       "      <td>11</td>\n",
       "      <td>294</td>\n",
       "      <td>2</td>\n",
       "      <td>23.010204</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6906</th>\n",
       "      <td>Nuttin_Up</td>\n",
       "      <td>0</td>\n",
       "      <td>164</td>\n",
       "      <td>-199</td>\n",
       "      <td>2534</td>\n",
       "      <td>6.159222</td>\n",
       "      <td>53.124431</td>\n",
       "      <td>414</td>\n",
       "      <td>3</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>26.094017</td>\n",
       "      <td>115.062500</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>117</td>\n",
       "      <td>24.970808</td>\n",
       "      <td>11</td>\n",
       "      <td>117</td>\n",
       "      <td>0</td>\n",
       "      <td>76.341880</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6907</th>\n",
       "      <td>Mr_dog</td>\n",
       "      <td>19</td>\n",
       "      <td>49</td>\n",
       "      <td>-17</td>\n",
       "      <td>595</td>\n",
       "      <td>7.615152</td>\n",
       "      <td>37.230740</td>\n",
       "      <td>13</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.882353</td>\n",
       "      <td>12.633910</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>136</td>\n",
       "      <td>24.564686</td>\n",
       "      <td>11</td>\n",
       "      <td>136</td>\n",
       "      <td>2</td>\n",
       "      <td>108.455882</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6908</th>\n",
       "      <td>TH3SCARFATH3R</td>\n",
       "      <td>212</td>\n",
       "      <td>101</td>\n",
       "      <td>-30</td>\n",
       "      <td>887</td>\n",
       "      <td>6.106369</td>\n",
       "      <td>34.922433</td>\n",
       "      <td>40</td>\n",
       "      <td>0</td>\n",
       "      <td>3</td>\n",
       "      <td>...</td>\n",
       "      <td>12.620968</td>\n",
       "      <td>21.851157</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>124</td>\n",
       "      <td>24.595594</td>\n",
       "      <td>11</td>\n",
       "      <td>124</td>\n",
       "      <td>3</td>\n",
       "      <td>105.879032</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6909</th>\n",
       "      <td>Philosophyoffreehood</td>\n",
       "      <td>0</td>\n",
       "      <td>108</td>\n",
       "      <td>-71</td>\n",
       "      <td>4159</td>\n",
       "      <td>3.092821</td>\n",
       "      <td>90.138950</td>\n",
       "      <td>46</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>2.004367</td>\n",
       "      <td>5.452746</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>229</td>\n",
       "      <td>24.780046</td>\n",
       "      <td>11</td>\n",
       "      <td>229</td>\n",
       "      <td>0</td>\n",
       "      <td>51.991266</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6910</th>\n",
       "      <td>TheCicc</td>\n",
       "      <td>0</td>\n",
       "      <td>103</td>\n",
       "      <td>-43</td>\n",
       "      <td>426</td>\n",
       "      <td>5.043608</td>\n",
       "      <td>20.018099</td>\n",
       "      <td>37</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>10.831858</td>\n",
       "      <td>19.267340</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>113</td>\n",
       "      <td>15.625083</td>\n",
       "      <td>11</td>\n",
       "      <td>113</td>\n",
       "      <td>1</td>\n",
       "      <td>42.486726</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6911</th>\n",
       "      <td>madisonrebel</td>\n",
       "      <td>501</td>\n",
       "      <td>201</td>\n",
       "      <td>-194</td>\n",
       "      <td>2407</td>\n",
       "      <td>5.731975</td>\n",
       "      <td>43.860051</td>\n",
       "      <td>315</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>17.045045</td>\n",
       "      <td>49.149750</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>111</td>\n",
       "      <td>24.192700</td>\n",
       "      <td>11</td>\n",
       "      <td>111</td>\n",
       "      <td>14</td>\n",
       "      <td>100.441441</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6912</th>\n",
       "      <td>toby224</td>\n",
       "      <td>11</td>\n",
       "      <td>139</td>\n",
       "      <td>-107</td>\n",
       "      <td>108</td>\n",
       "      <td>1.052324</td>\n",
       "      <td>8.232972</td>\n",
       "      <td>270</td>\n",
       "      <td>1</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>17.100000</td>\n",
       "      <td>36.883812</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>290</td>\n",
       "      <td>19.047575</td>\n",
       "      <td>11</td>\n",
       "      <td>290</td>\n",
       "      <td>0</td>\n",
       "      <td>67.527586</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6913</th>\n",
       "      <td>A_solo_tripper</td>\n",
       "      <td>0</td>\n",
       "      <td>68</td>\n",
       "      <td>-9</td>\n",
       "      <td>245</td>\n",
       "      <td>2.964736</td>\n",
       "      <td>13.087459</td>\n",
       "      <td>9</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.727778</td>\n",
       "      <td>6.915153</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>180</td>\n",
       "      <td>19.480988</td>\n",
       "      <td>11</td>\n",
       "      <td>180</td>\n",
       "      <td>19</td>\n",
       "      <td>79.738889</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6914</th>\n",
       "      <td>744EvergreenTerrace</td>\n",
       "      <td>0</td>\n",
       "      <td>163</td>\n",
       "      <td>-31</td>\n",
       "      <td>154</td>\n",
       "      <td>1.255532</td>\n",
       "      <td>5.181933</td>\n",
       "      <td>23</td>\n",
       "      <td>0</td>\n",
       "      <td>0</td>\n",
       "      <td>...</td>\n",
       "      <td>5.850192</td>\n",
       "      <td>10.421838</td>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>781</td>\n",
       "      <td>16.883605</td>\n",
       "      <td>11</td>\n",
       "      <td>781</td>\n",
       "      <td>7</td>\n",
       "      <td>54.464789</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>6915 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                    author  num_archived_comm  num_subs  min_score  max_score  \\\n",
       "0             _TheDreamer_                  0         1          1          5   \n",
       "1                BlueCaffe                  0         1         -3         12   \n",
       "2                vegority7                  0         1         -4        155   \n",
       "3        Godlikeconspiracy                  0         1          0          0   \n",
       "4        JimEastWestSr_SUX                  0         1          0         21   \n",
       "5        Stepwithvigilance                  0         1         -1         20   \n",
       "6         trollingtrollers                  0         3          1        699   \n",
       "7     purplepeopleeaters94                  0         5         -6         23   \n",
       "8          SandyHoaxParent                  0         7        -18         15   \n",
       "9           pumaspacetrain                  3         5         -1         21   \n",
       "10                charitwo                  0         1        -13         32   \n",
       "11        DAY_OF_THEE_ROPE                  0        21        -34         60   \n",
       "12                  WixFix                  0         1          1          1   \n",
       "13        TheModernGnostic                  0         1         -4          2   \n",
       "14           Global_Agenda                  0         1          1          1   \n",
       "15          _Lokis_Revenge                  0         2         -2         29   \n",
       "16     CRYlikeROBBIEparker                  0         3          1          4   \n",
       "17              Junglist87                  0         4          0        143   \n",
       "18           anonymousgate                  0         1         -2         23   \n",
       "19                 verity_                  0         2          0         15   \n",
       "20             doobeyhoser                  0         2         -4        143   \n",
       "21        curiousorganelle                  0         6        -11        213   \n",
       "22                 logan_f                  0         4         -3         79   \n",
       "23             HairlessApe                 20        11         -8         30   \n",
       "24               legend747                  0         4         -3         44   \n",
       "25                  klooj_                  0        21        -66        697   \n",
       "26          Itmustjustbeme                  0         2        -10         51   \n",
       "27         MrTinFoilHat187                  0         6        -13         53   \n",
       "28               mrjohnnyp                  0        17         -3        214   \n",
       "29    hurtpeoplehurtpe0ple                  0         3         -5         51   \n",
       "...                    ...                ...       ...        ...        ...   \n",
       "6885           sunshine242                  0         7         -2         33   \n",
       "6886        DontShoot2Kill                  0         2         -2        201   \n",
       "6887          Sursum_Corda                  5        39        -10        124   \n",
       "6888            mistahbang                 90        21        -48        518   \n",
       "6889     MasterOfNotAThing                  0        32        -20         92   \n",
       "6890            Ironmanjc3                  0        24        -88         53   \n",
       "6891                 bhaga                  0        13        -54        197   \n",
       "6892          kyle_rearden                  0         9         -8          4   \n",
       "6893      joshthephysicist               1112        89        -31        554   \n",
       "6894             RedPillEH                  0        31        -95        397   \n",
       "6895           Farthrower1                  0        20         -3         59   \n",
       "6896             teein_off                  0         9         -7        166   \n",
       "6897           Dosbi_Ausbi                  0        35        -42        870   \n",
       "6898            mineben256                  1        21         -4         34   \n",
       "6899             gobuffs10                 70        58        -45        279   \n",
       "6900        BeatnikMessiah                  0        51         -5        386   \n",
       "6901              Boroku87                  0         2          1          3   \n",
       "6902       Bannanadonut342                  0        11         -3          3   \n",
       "6903  MrArchibaldMeatpants                  0       122        -92        193   \n",
       "6904         SlothropsKnob                  0       186        -10       1168   \n",
       "6905      RogueTaxidermist                  0        49        -78        984   \n",
       "6906             Nuttin_Up                  0       164       -199       2534   \n",
       "6907                Mr_dog                 19        49        -17        595   \n",
       "6908         TH3SCARFATH3R                212       101        -30        887   \n",
       "6909  Philosophyoffreehood                  0       108        -71       4159   \n",
       "6910               TheCicc                  0       103        -43        426   \n",
       "6911          madisonrebel                501       201       -194       2407   \n",
       "6912               toby224                 11       139       -107        108   \n",
       "6913        A_solo_tripper                  0        68         -9        245   \n",
       "6914   744EvergreenTerrace                  0       163        -31        154   \n",
       "\n",
       "      avg_score   std_score  num_contra_comm  num_gilded_comm  \\\n",
       "0      1.625000    1.407886                0                0   \n",
       "1      1.583333    3.502164                0                0   \n",
       "2     16.357143   40.759345                0                0   \n",
       "3      0.000000         NaN                0                0   \n",
       "4      3.272727    3.947093                2                0   \n",
       "5      2.180556    2.815082                2                0   \n",
       "6     24.444444  103.827557                2                0   \n",
       "7      2.905512    3.818154                3                0   \n",
       "8      1.090909    4.169759                5                0   \n",
       "9      2.745283    3.375151                6                0   \n",
       "10     5.461538   10.261504                9                0   \n",
       "11     3.794979    8.659515               13                0   \n",
       "12     1.000000         NaN                0                0   \n",
       "13     0.222222    1.592466                0                0   \n",
       "14     1.000000         NaN                0                0   \n",
       "15     3.508772    5.922484                0                0   \n",
       "16     1.750000    1.500000                0                0   \n",
       "17    11.094340   25.077008                0                0   \n",
       "18     4.586207    4.888158                1                0   \n",
       "19     2.631579    3.803661                1                0   \n",
       "20     9.000000   28.709944                2                0   \n",
       "21     4.557078   18.959885                2                0   \n",
       "22     3.629213    8.756014                4                0   \n",
       "23     4.000000    6.621790                4                0   \n",
       "24     3.858156    5.270048                5                0   \n",
       "25    10.775194   61.800238                5                0   \n",
       "26     3.089744    5.393391                6                0   \n",
       "27     2.601852    6.798763                6                0   \n",
       "28     7.213415   20.086245                8                0   \n",
       "29     3.963636    8.517876               10                0   \n",
       "...         ...         ...              ...              ...   \n",
       "6885   3.540984    5.117206                1                0   \n",
       "6886   8.088235   34.207360                4                0   \n",
       "6887   4.723881   12.183060                2                0   \n",
       "6888   5.789916   35.165282                5                0   \n",
       "6889   4.012987   10.098849                8                0   \n",
       "6890   1.007353   10.550406                5                0   \n",
       "6891   6.511278   16.472558               32                0   \n",
       "6892   1.025974    1.385774                1                0   \n",
       "6893   5.728855   21.616480               17                1   \n",
       "6894   2.437282   19.501700               47                1   \n",
       "6895   3.794118    7.367715                2                0   \n",
       "6896   5.184874   19.149707                5                0   \n",
       "6897   4.857934   39.513541               67                0   \n",
       "6898   1.950777    3.156549                9                0   \n",
       "6899   5.059337   20.420663               12                0   \n",
       "6900   4.341826   21.001619                6                0   \n",
       "6901   1.500000    0.755929                0                0   \n",
       "6902   1.088889    0.848052                1                0   \n",
       "6903   2.485493   10.633664               25                0   \n",
       "6904  11.614148   65.917401               10                0   \n",
       "6905  12.080605   72.016998               11                0   \n",
       "6906   6.159222   53.124431              414                3   \n",
       "6907   7.615152   37.230740               13                0   \n",
       "6908   6.106369   34.922433               40                0   \n",
       "6909   3.092821   90.138950               46                0   \n",
       "6910   5.043608   20.018099               37                0   \n",
       "6911   5.731975   43.860051              315                1   \n",
       "6912   1.052324    8.232972              270                1   \n",
       "6913   2.964736   13.087459                9                0   \n",
       "6914   1.255532    5.181933               23                0   \n",
       "\n",
       "      num_distinguished_comm     ...       avg_replies  std_replies  \\\n",
       "0                          0     ...          6.548387    23.300699   \n",
       "1                          0     ...         22.483871    79.365345   \n",
       "2                          0     ...          3.000000     5.156378   \n",
       "3                          0     ...          4.888889     6.197601   \n",
       "4                          0     ...          8.937500     9.066192   \n",
       "5                          0     ...         16.365385    43.659569   \n",
       "6                          0     ...         34.384615    72.083908   \n",
       "7                          0     ...         21.913043    22.003952   \n",
       "8                          0     ...          1.774194     2.765377   \n",
       "9                          0     ...          9.416667     4.907477   \n",
       "10                         0     ...         75.066667   164.668701   \n",
       "11                         0     ...          9.272727    11.816783   \n",
       "12                         0     ...          9.484848    15.449760   \n",
       "13                         0     ...          0.017857     0.133631   \n",
       "14                         0     ...          0.240506     0.894645   \n",
       "15                         0     ...          6.489796    28.464248   \n",
       "16                         0     ...          7.518519    18.780863   \n",
       "17                         0     ...         26.307692    70.890038   \n",
       "18                         0     ...         38.684211    73.386384   \n",
       "19                         0     ...          4.482759    15.830848   \n",
       "20                         0     ...          4.100000     5.492000   \n",
       "21                         0     ...          7.235294     7.437485   \n",
       "22                         0     ...         18.333333    19.554563   \n",
       "23                         0     ...         11.477612    50.660408   \n",
       "24                         0     ...          4.620690     8.470439   \n",
       "25                         0     ...         20.100000    33.467816   \n",
       "26                         0     ...         12.050000    16.847536   \n",
       "27                         0     ...          5.400000    16.540238   \n",
       "28                         0     ...          6.736842    12.735960   \n",
       "29                         0     ...         15.803922    51.653081   \n",
       "...                      ...     ...               ...          ...   \n",
       "6885                       0     ...         12.733333     8.899973   \n",
       "6886                       0     ...          5.030303     9.967086   \n",
       "6887                       0     ...          6.500000     8.125848   \n",
       "6888                       0     ...         32.388889    41.269757   \n",
       "6889                       0     ...         18.960000    76.365066   \n",
       "6890                       0     ...          4.590909     5.011027   \n",
       "6891                       0     ...          7.615385    15.641169   \n",
       "6892                       0     ...          2.468750     4.235034   \n",
       "6893                       0     ...         15.207921    41.968159   \n",
       "6894                       0     ...          7.744186    19.766987   \n",
       "6895                       0     ...         12.432432    33.507495   \n",
       "6896                       0     ...          1.833333     3.721504   \n",
       "6897                       0     ...          6.643678    12.410589   \n",
       "6898                       0     ...         11.750000    25.646828   \n",
       "6899                       0     ...         13.980000    13.377547   \n",
       "6900                       0     ...          5.083333     6.049203   \n",
       "6901                       0     ...          2.900000     6.260412   \n",
       "6902                       0     ...          2.761905     5.011253   \n",
       "6903                       0     ...          9.337838    14.994316   \n",
       "6904                       0     ...         19.615385    96.189387   \n",
       "6905                       0     ...          6.598639    38.663272   \n",
       "6906                       0     ...         26.094017   115.062500   \n",
       "6907                       0     ...          5.882353    12.633910   \n",
       "6908                       3     ...         12.620968    21.851157   \n",
       "6909                       0     ...          2.004367     5.452746   \n",
       "6910                       0     ...         10.831858    19.267340   \n",
       "6911                       0     ...         17.045045    49.149750   \n",
       "6912                       0     ...         17.100000    36.883812   \n",
       "6913                       0     ...          5.727778     6.915153   \n",
       "6914                       0     ...          5.850192    10.421838   \n",
       "\n",
       "      num_gilded_posts  num_distinguished_posts  num_posts  \\\n",
       "0                    0                        0         31   \n",
       "1                    0                        0         31   \n",
       "2                    0                        0         18   \n",
       "3                    0                        0         27   \n",
       "4                    0                        0         16   \n",
       "5                    0                        0         52   \n",
       "6                    0                        0         13   \n",
       "7                    0                        0         23   \n",
       "8                    0                        0         31   \n",
       "9                    0                        0         12   \n",
       "10                   0                        0         15   \n",
       "11                   0                        0         22   \n",
       "12                   0                        0         33   \n",
       "13                   0                        0         56   \n",
       "14                   0                        0         79   \n",
       "15                   0                        0         49   \n",
       "16                   0                        0         27   \n",
       "17                   0                        0         13   \n",
       "18                   0                        0         19   \n",
       "19                   0                        0         29   \n",
       "20                   0                        0         30   \n",
       "21                   0                        0         17   \n",
       "22                   0                        0         15   \n",
       "23                   0                        0        134   \n",
       "24                   0                        0         58   \n",
       "25                   0                        0         20   \n",
       "26                   0                        0         20   \n",
       "27                   0                        0         40   \n",
       "28                   0                        0         19   \n",
       "29                   0                        0         51   \n",
       "...                ...                      ...        ...   \n",
       "6885                 0                        0         15   \n",
       "6886                 0                        0         33   \n",
       "6887                 0                        0         18   \n",
       "6888                 0                        0         18   \n",
       "6889                 0                        0         25   \n",
       "6890                 0                        0         22   \n",
       "6891                 0                        0         26   \n",
       "6892                 1                        0         64   \n",
       "6893                 0                        0        101   \n",
       "6894                 0                        0         86   \n",
       "6895                 0                        0         37   \n",
       "6896                 0                        0         42   \n",
       "6897                 0                        0         87   \n",
       "6898                 0                        0         52   \n",
       "6899                 0                        0         50   \n",
       "6900                 0                        0         36   \n",
       "6901                 0                        0         70   \n",
       "6902                 0                        0         42   \n",
       "6903                 0                        0         74   \n",
       "6904                 0                        0         52   \n",
       "6905                 0                        0        294   \n",
       "6906                 0                        0        117   \n",
       "6907                 0                        0        136   \n",
       "6908                 1                        0        124   \n",
       "6909                 0                        0        229   \n",
       "6910                 0                        0        113   \n",
       "6911                 0                        0        111   \n",
       "6912                 0                        0        290   \n",
       "6913                 0                        0        180   \n",
       "6914                 0                        1        781   \n",
       "\n",
       "      month_active_posts  consp_posts  num_stickied_posts  num_over18_posts  \\\n",
       "0               0.525997           31                  31                 0   \n",
       "1               1.037200           31                  31                 0   \n",
       "2               5.226300           18                  18                 0   \n",
       "3               1.002080           27                  27                 0   \n",
       "4               0.600165           16                  16                 0   \n",
       "5               6.455086           52                  52                 0   \n",
       "6               2.896401           13                  13                 0   \n",
       "7              11.661671           23                  23                 0   \n",
       "8               0.144751           31                  31                 1   \n",
       "9              13.942422           12                  12                 0   \n",
       "10              1.157483           15                  15                 0   \n",
       "11              7.009171           22                  22                 0   \n",
       "12              0.339850           18                  33                 0   \n",
       "13              1.908844           49                  56                 0   \n",
       "14              5.756645           78                  79                 0   \n",
       "15              0.525931           15                  49                 0   \n",
       "16              5.562223           26                  27                 0   \n",
       "17              4.144426           12                  13                 0   \n",
       "18              9.997154           18                  19                 0   \n",
       "19              1.813530           23                  29                 0   \n",
       "20              0.422368           19                  30                 0   \n",
       "21             18.802230           16                  17                 0   \n",
       "22              7.558664           14                  15                 0   \n",
       "23             20.791413          133                 134                 0   \n",
       "24             17.331317           56                  58                 0   \n",
       "25              5.258345           13                  20                 1   \n",
       "26             13.362576           19                  20                 0   \n",
       "27              6.050165           39                  40                 0   \n",
       "28              9.886267           17                  19                 0   \n",
       "29              7.001221           50                  51                 0   \n",
       "...                  ...          ...                 ...               ...   \n",
       "6885           14.852139           11                  15                 0   \n",
       "6886            1.202983           11                  33                 0   \n",
       "6887           21.170998           11                  18                 0   \n",
       "6888           20.850160           11                  18                 0   \n",
       "6889           23.485949           11                  25                 0   \n",
       "6890            3.292707           11                  22                 1   \n",
       "6891           19.728821           11                  26                 0   \n",
       "6892            3.408873           11                  64                 0   \n",
       "6893            5.027130           11                 101                 0   \n",
       "6894            7.732324           11                  86                 1   \n",
       "6895           10.850082           11                  37                 0   \n",
       "6896           21.079121           11                  42                 0   \n",
       "6897           15.637632           11                  87                 2   \n",
       "6898           23.940161           11                  52                 0   \n",
       "6899           23.374653           11                  50                 1   \n",
       "6900           24.226234           11                  36                 0   \n",
       "6901            5.608296           11                  70                10   \n",
       "6902            2.618324           11                  42                 0   \n",
       "6903           23.864327           11                  74                17   \n",
       "6904           21.315178           11                  52                 1   \n",
       "6905           23.092553           11                 294                 2   \n",
       "6906           24.970808           11                 117                 0   \n",
       "6907           24.564686           11                 136                 2   \n",
       "6908           24.595594           11                 124                 3   \n",
       "6909           24.780046           11                 229                 0   \n",
       "6910           15.625083           11                 113                 1   \n",
       "6911           24.192700           11                 111                14   \n",
       "6912           19.047575           11                 290                 0   \n",
       "6913           19.480988           11                 180                19   \n",
       "6914           16.883605           11                 781                 7   \n",
       "\n",
       "      avg_postlen  \n",
       "0       79.322581  \n",
       "1       45.645161  \n",
       "2      102.722222  \n",
       "3       64.814815  \n",
       "4       64.437500  \n",
       "5       98.211538  \n",
       "6      185.000000  \n",
       "7       55.608696  \n",
       "8       26.225806  \n",
       "9       66.916667  \n",
       "10     124.400000  \n",
       "11      74.636364  \n",
       "12      49.606061  \n",
       "13      70.446429  \n",
       "14      68.645570  \n",
       "15      48.142857  \n",
       "16      32.111111  \n",
       "17      65.692308  \n",
       "18      89.000000  \n",
       "19      64.896552  \n",
       "20      47.033333  \n",
       "21      71.764706  \n",
       "22      50.733333  \n",
       "23      81.649254  \n",
       "24      61.103448  \n",
       "25      69.200000  \n",
       "26      63.100000  \n",
       "27      72.975000  \n",
       "28      96.157895  \n",
       "29      97.137255  \n",
       "...           ...  \n",
       "6885    80.333333  \n",
       "6886   102.393939  \n",
       "6887    68.111111  \n",
       "6888    44.722222  \n",
       "6889    90.760000  \n",
       "6890    61.318182  \n",
       "6891   105.076923  \n",
       "6892    56.968750  \n",
       "6893    67.287129  \n",
       "6894    56.511628  \n",
       "6895    39.486486  \n",
       "6896    40.142857  \n",
       "6897    68.597701  \n",
       "6898    54.653846  \n",
       "6899    60.420000  \n",
       "6900    25.194444  \n",
       "6901    37.114286  \n",
       "6902    79.642857  \n",
       "6903    61.932432  \n",
       "6904    85.153846  \n",
       "6905    23.010204  \n",
       "6906    76.341880  \n",
       "6907   108.455882  \n",
       "6908   105.879032  \n",
       "6909    51.991266  \n",
       "6910    42.486726  \n",
       "6911   100.441441  \n",
       "6912    67.527586  \n",
       "6913    79.738889  \n",
       "6914    54.464789  \n",
       "\n",
       "[6915 rows x 32 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_ref"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "metadata": {},
   "outputs": [],
   "source": [
    "tr = pd.Series(time_ref.month.values,index=time_ref.author).to_dict()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'KnowledgeBoost': '1485907200',\n",
       " '2totwo': '1483228800',\n",
       " 'Dandy-Space-Guy': '1488326400',\n",
       " 'slick_bridges': '1454284800',\n",
       " 'TryingToStart4': '1493596800',\n",
       " 'freeyourmind13': '1509494400',\n",
       " 'thenoorys': '1456790400',\n",
       " 'frothface': '1477958400',\n",
       " 'tututang': '1475280000',\n",
       " 'DeplorableinTX': '1483228800',\n",
       " 'armchairCueB': '1512086400',\n",
       " 'justinjoker2389': '1493596800',\n",
       " 'hot_potato_321': '1488326400',\n",
       " 'scottie6561': '1493596800',\n",
       " '90s_camp': '1470009600',\n",
       " '1727301': '1483228800',\n",
       " 'HD3D': '1472688000',\n",
       " 'AFriendlyCivilian': '1491004800',\n",
       " 'slowbrowsersarefunny': '1488326400',\n",
       " 'ThrowAwayDCNSA': '1498867200',\n",
       " 'Crown118': '1451606400',\n",
       " 'jje5002': '1483228800',\n",
       " 'verybadsheep': '1451606400',\n",
       " '8bitfruy': '1512086400',\n",
       " 'BigPharmaSucks': '1504224000',\n",
       " 'asshole_279': '1498867200',\n",
       " 'TibetanSkyFuneral': '1501545600',\n",
       " 'nliausacmmv': '1483228800',\n",
       " 'FBI_Breast_Inspector': '1477958400',\n",
       " 'monicahi': '1459468800',\n",
       " 'bestnewsevah': '1459468800',\n",
       " 'Politicschmolitics': '1512086400',\n",
       " 'VladimirVladmirPutin': '1477958400',\n",
       " 'inh-uman': '1480550400',\n",
       " 'TheRealBaseborn': '1493596800',\n",
       " 'high-priest-of-slack': '1456790400',\n",
       " 'nighthawk1961': '1462060800',\n",
       " 'TheSaxonFive': '1480550400',\n",
       " 'Ezazcil': '1493596800',\n",
       " 'riskoooo': '1480550400',\n",
       " 'ghettobx': '1491004800',\n",
       " 'upyoursshill': '1506816000',\n",
       " 'OwnRellik': '1488326400',\n",
       " 'Dosbi_Ausbi': '1475280000',\n",
       " 'the_crown_fits': '1477958400',\n",
       " 'IndecentLongExposure': '1483228800',\n",
       " 'shadeforce1': '1493596800',\n",
       " 'tendieizdanite': '1483228800',\n",
       " 'watching98': '1477958400',\n",
       " 'chasmoffaith': '1472688000',\n",
       " 'PhilipMarma': '1459468800',\n",
       " 'Dredgelord': '1488326400',\n",
       " 'Moosetappropriate': '1512086400',\n",
       " 'eaglejm': '1475280000',\n",
       " 'timstolt1': '1493596800',\n",
       " 'austin_nance': '1491004800',\n",
       " 'frankthecrank1': '1488326400',\n",
       " 'YateHihudis': '1491004800',\n",
       " 'bassinastor': '1506816000',\n",
       " '120z8t': '1451606400',\n",
       " 'DrFucksAlot': '1509494400',\n",
       " 'tenderpoettech': '1477958400',\n",
       " 'TernUpTheBass': '1488326400',\n",
       " 'Non-equilibrium': '1451606400',\n",
       " 'veryhopefulanon': '1483228800',\n",
       " 'pablodiablo906': '1472688000',\n",
       " 'max1715': '1506816000',\n",
       " 'mrshekelstein18': '1506816000',\n",
       " 'GonnaVote2': '1477958400',\n",
       " 'podcastman': '1498867200',\n",
       " 'InTrbl': '1456790400',\n",
       " 'Beaustrodamus': '1491004800',\n",
       " 'Tacos_On_A_Tuesday': '1491004800',\n",
       " 'garthsworld': '1472688000',\n",
       " 'white_s2k': '1493596800',\n",
       " 'wizardofthefuture': '1512086400',\n",
       " 'uhyeahokwhateva': '1509494400',\n",
       " 'PM_ME_YOUR_BLOACH': '1501545600',\n",
       " 'coldoll514': '1491004800',\n",
       " 'imar00': '1498867200',\n",
       " 'mrjosemeehan': '1454284800',\n",
       " 'findmeastray': '1506816000',\n",
       " 'DoshawnMandic': '1506816000',\n",
       " 'ActionConquersFear': '1485907200',\n",
       " 'Maxwyfe': '1491004800',\n",
       " 'AllTheWayTrump': '1483228800',\n",
       " 'FUCK_GLOBALISTS': '1480550400',\n",
       " 'MrFlizToYou': '1512086400',\n",
       " 'ThankGodIExist': '1485907200',\n",
       " 'ENYAY7': '1451606400',\n",
       " 'brettcal82': '1475280000',\n",
       " 'RedeyedRider': '1488326400',\n",
       " 'NoBreaks2016': '1506816000',\n",
       " 'Leeeskii': '1498867200',\n",
       " 'Metatron313': '1509494400',\n",
       " 'Syzygye': '1472688000',\n",
       " 'dont_ask_my_name': '1501545600',\n",
       " 'Drinkgamedrunk': '1467331200',\n",
       " 'cesarjulius': '1470009600',\n",
       " 'spezzingout': '1480550400',\n",
       " 'SimplySabrina': '1454284800',\n",
       " 'demostravius': '1459468800',\n",
       " 'BeamUsUpMrScott': '1451606400',\n",
       " 'tymaan': '1485907200',\n",
       " 'BuddhaForce4': '1475280000',\n",
       " 'truthWILLsetyoufree7': '1498867200',\n",
       " 'justforthissubred': '1488326400',\n",
       " 'Cho-Dai': '1488326400',\n",
       " 'africanmuzungu': '1498867200',\n",
       " 'ike_ola': '1485907200',\n",
       " 'ibnotsk': '1475280000',\n",
       " 'Trollygag': '1498867200',\n",
       " 'DucitperLuce': '1470009600',\n",
       " 'Dyeredit': '1493596800',\n",
       " 'deaddrop23': '1470009600',\n",
       " '349days': '1512086400',\n",
       " 'NickFurry808': '1501545600',\n",
       " 'fisforfish': '1485907200',\n",
       " 'tatertatertatertot': '1459468800',\n",
       " 'loxsey': '1451606400',\n",
       " 'B00B54yoo': '1488326400',\n",
       " 'mennitti': '1480550400',\n",
       " 'Eric_Partman': '1506816000',\n",
       " 'Opinionatedcivilian': '1459468800',\n",
       " 'Notso_Pure_Michigan': '1496275200',\n",
       " 'advavnalncsnsacn': '1512086400',\n",
       " 'Pls_PM_me_uranus': '1493596800',\n",
       " 'holographictomato': '1506816000',\n",
       " 'Michaelphelpsisquick': '1483228800',\n",
       " 'BadTimeSkeleton': '1491004800',\n",
       " 'favoritecattoy': '1509494400',\n",
       " 'owlcammaga': '1493596800',\n",
       " 'subtech7': '1506816000',\n",
       " 'dve46': '1512086400',\n",
       " 'curse2themax': '1493596800',\n",
       " 'quackyMcDuck': '1477958400',\n",
       " 'damaged_but_whole': '1454284800',\n",
       " 'Mankybot': '1454284800',\n",
       " 'HotWeeWeeJefferson': '1509494400',\n",
       " 'werejustnoise': '1506816000',\n",
       " 'ZiggyAventure': '1512086400',\n",
       " 'joculator': '1485907200',\n",
       " '1984Freeman': '1501545600',\n",
       " 'drwooo': '1470009600',\n",
       " 'raiderguys92': '1472688000',\n",
       " 'TrumpDid9_11': '1496275200',\n",
       " '-INFOWARS-': '1480550400',\n",
       " 'Iceboundend': '1493596800',\n",
       " 'TedTurnersDogfrom': '1509494400',\n",
       " 'VagabondTruth': '1462060800',\n",
       " 'toekneemontana': '1477958400',\n",
       " 'sipofsoma': '1475280000',\n",
       " 'WaldoGumbs': '1472688000',\n",
       " 'UnicornMuffinTop': '1493596800',\n",
       " 'Madara_Uchihaa': '1459468800',\n",
       " 'GSF1212': '1477958400',\n",
       " 'fuckingcoups': '1470009600',\n",
       " 'HahThatsSilly': '1491004800',\n",
       " 'Triplechins': '1451606400',\n",
       " 'sock_lover': '1485907200',\n",
       " 'CelineHagbard': '1485907200',\n",
       " 'Axana': '1477958400',\n",
       " 'MisanthropePlatypus': '1483228800',\n",
       " 'Milodidit24': '1488326400',\n",
       " 'lockhherup': '1498867200',\n",
       " 'mw8912a': '1462060800',\n",
       " 'Allinon72': '1496275200',\n",
       " 'SoupGFX': '1477958400',\n",
       " 'Lordidude': '1496275200',\n",
       " 'WorkingLikaBoss': '1475280000',\n",
       " 'lvysaur': '1483228800',\n",
       " 'Br00ce': '1509494400',\n",
       " 'Surroundedbyidiots12': '1456790400',\n",
       " 'Starbucks_': '1475280000',\n",
       " 'dreamslaughter': '1467331200',\n",
       " 'Badgersuit': '1485907200',\n",
       " 'altxatu': '1485907200',\n",
       " 'anti-unique_username': '1493596800',\n",
       " 'CrazyMike366': '1475280000',\n",
       " 'EricClaptonsDeadSon': '1470009600',\n",
       " 'bi-hi-chi': '1485907200',\n",
       " 'babrams76': '1475280000',\n",
       " 'AlphaDope': '1501545600',\n",
       " 'Turbodiesel67': '1483228800',\n",
       " 'strangeDOTAgames': '1509494400',\n",
       " 'DrDerpinheimer': '1504224000',\n",
       " 'garmonboziamilkshake': '1477958400',\n",
       " 'gavin_freemason': '1485907200',\n",
       " 'MM_mm12': '1498867200',\n",
       " 'Glassclose': '1512086400',\n",
       " 'luis_correa': '1467331200',\n",
       " 'PresidentAntifa': '1512086400',\n",
       " 'axeheadroad': '1509494400',\n",
       " 'mikellerseviltwin': '1496275200',\n",
       " 'milnesand': '1498867200',\n",
       " 'utu_': '1456790400',\n",
       " 'wheresmybowl': '1456790400',\n",
       " 'gameslave2': '1506816000',\n",
       " 'fght': '1506816000',\n",
       " 'jwccs46': '1470009600',\n",
       " 'Eat1nPussyKickinAss': '1496275200',\n",
       " 'Lorkes34': '1493596800',\n",
       " 'ganjamaninacan': '1475280000',\n",
       " 'CTR_autobot_v31': '1493596800',\n",
       " 'AfricaLive1': '1512086400',\n",
       " 'STARVE_THE_BEAST': '1459468800',\n",
       " 'Folwart': '1477958400',\n",
       " 'd8_thc': '1472688000',\n",
       " 'JohnqNC': '1498867200',\n",
       " 'coldxrain': '1493596800',\n",
       " 'epic_soundtracks': '1488326400',\n",
       " 'wahmifeels': '1506816000',\n",
       " 'RandallWho': '1483228800',\n",
       " 'always_a_hoot': '1483228800',\n",
       " 'ixAp0c': '1459468800',\n",
       " 'LAT3LY': '1485907200',\n",
       " 'jakedaily': '1485907200',\n",
       " 'Mantheistic': '1506816000',\n",
       " 'bguy030': '1483228800',\n",
       " 'natetom': '1509494400',\n",
       " 'shitbric': '1456790400',\n",
       " 'DJsupaman': '1493596800',\n",
       " 'SoTiredOfWinning': '1504224000',\n",
       " 'umbrajoke': '1462060800',\n",
       " 'smokeytokerton': '1467331200',\n",
       " 'Love_And_Light33': '1477958400',\n",
       " 'LightBerry81': '1491004800',\n",
       " 'TheRealIsNow': '1475280000',\n",
       " 'FakeRacer': '1456790400',\n",
       " 'NotNowImOnReddit': '1470009600',\n",
       " 'thisisnotmyreality': '1459468800',\n",
       " 'fuckyou_dumbass': '1470009600',\n",
       " 'realister': '1470009600',\n",
       " 'JVteam': '1493596800',\n",
       " 'Flavius_Stilicho': '1480550400',\n",
       " 'Gideon_Jefferson': '1480550400',\n",
       " 'MapleBaconPoutine': '1472688000',\n",
       " 'maxt0r': '1454284800',\n",
       " 'qodeshi': '1512086400',\n",
       " 'sarinonline': '1509494400',\n",
       " 'Reverse-Racism': '1506816000',\n",
       " 'goddoll': '1467331200',\n",
       " 'Hapmurcie': '1491004800',\n",
       " 'vmont': '1480550400',\n",
       " 'ronpaulbacon': '1498867200',\n",
       " 'spudral': '1485907200',\n",
       " 'HairBrian': '1485907200',\n",
       " 'Autistic_Chad': '1493596800',\n",
       " 'Sing_about_me': '1506816000',\n",
       " 'varianlogic': '1459468800',\n",
       " 'scotch_toker': '1485907200',\n",
       " 'Toczix': '1488326400',\n",
       " 'fucks_with_shills': '1512086400',\n",
       " 'castle_kafka': '1506816000',\n",
       " 'JDman460': '1480550400',\n",
       " 'R3dTim': '1456790400',\n",
       " 'Greenmonster71': '1488326400',\n",
       " 'Takeme2yourleader': '1475280000',\n",
       " 'COUTS_132': '1464739200',\n",
       " 'Hektik352': '1470009600',\n",
       " 'casesully50': '1512086400',\n",
       " 'PoopInMyBottom': '1477958400',\n",
       " 'Sportfreunde': '1477958400',\n",
       " '0ccidentalist': '1475280000',\n",
       " 'Alex_Jewns': '1475280000',\n",
       " 'CeleryStore': '1509494400',\n",
       " 'StanishInquisition': '1480550400',\n",
       " 'ifyourheadexplodes': '1496275200',\n",
       " 'kingcubfan': '1464739200',\n",
       " 'Thor_PR_Rep': '1475280000',\n",
       " 'vendor111': '1462060800',\n",
       " 'qxcvr': '1451606400',\n",
       " 'Hopalonger': '1512086400',\n",
       " 'thisisthetaxi': '1483228800',\n",
       " 'bacare': '1483228800',\n",
       " 'tagg1230': '1454284800',\n",
       " 'birthdaysuit11': '1470009600',\n",
       " 'louixiii': '1496275200',\n",
       " 'emmacom': '1509494400',\n",
       " 'GolfinPoker': '1509494400',\n",
       " 'Princess_Wannatoke': '1509494400',\n",
       " 'anti_shadowban': '1491004800',\n",
       " 'anonymousgate': '1480550400',\n",
       " 'malcomte': '1451606400',\n",
       " 'xxmissmiserxx': '1498867200',\n",
       " 'friendlylooking': '1512086400',\n",
       " 'McLovin804': '1475280000',\n",
       " 'afniluser': '1496275200',\n",
       " 'mmaisprettycool': '1491004800',\n",
       " 'dalomi9': '1506816000',\n",
       " 'HalfDOME': '1506816000',\n",
       " 'muikwoksing': '1488326400',\n",
       " 'Pebls': '1512086400',\n",
       " 'babysfirstmillcard': '1506816000',\n",
       " 'J_Dub_TX': '1483228800',\n",
       " 'SaKarlaNakaMora': '1501545600',\n",
       " 'Stillwatch': '1477958400',\n",
       " 'Spooge': '1496275200',\n",
       " 'lamentationsoftheir': '1475280000',\n",
       " 'skatalon2': '1493596800',\n",
       " 'babaroga73': '1470009600',\n",
       " 'belisaurius': '1472688000',\n",
       " 'RedVodka19': '1493596800',\n",
       " 'greggerypeccary': '1456790400',\n",
       " 'VladPutinBro': '1506816000',\n",
       " 'qwertymm8383': '1493596800',\n",
       " 'ADPNova': '1480550400',\n",
       " 'scott5280': '1485907200',\n",
       " 'E-werd': '1483228800',\n",
       " 'disposable_account01': '1470009600',\n",
       " 'dissdigg': '1456790400',\n",
       " 'Stunner900': '1483228800',\n",
       " 'makedesign': '1459468800',\n",
       " 'Metriacanthosaurus': '1480550400',\n",
       " 'Turpekal_Thrizz': '1498867200',\n",
       " 'borkborkborko': '1491004800',\n",
       " 'msjenkin': '1477958400',\n",
       " 'lvl10troll': '1501545600',\n",
       " 'J-Barron': '1488326400',\n",
       " 'Goatinsheepsclothing': '1459468800',\n",
       " 'justthetipsir17': '1501545600',\n",
       " 'iemploreyou': '1488326400',\n",
       " 'wheelinganddealing': '1456790400',\n",
       " 'HangisLife': '1483228800',\n",
       " 'gryphon_844': '1512086400',\n",
       " 'MisoSoup': '1496275200',\n",
       " 'shmusko01': '1451606400',\n",
       " 'Audrion': '1472688000',\n",
       " 'Mellyanish': '1509494400',\n",
       " 'RelentlessGrind': '1509494400',\n",
       " 'Paracelcus': '1483228800',\n",
       " 'pinko_zinko': '1512086400',\n",
       " 'JerfFoo': '1493596800',\n",
       " 'Coontang': '1498867200',\n",
       " 'Pyrokhar': '1488326400',\n",
       " 'winter_sucks_balls': '1456790400',\n",
       " 'waltdanger87': '1506816000',\n",
       " '-954-': '1456790400',\n",
       " 'Kyle6969': '1493596800',\n",
       " 'Katynrosja': '1483228800',\n",
       " 'oaklandbrokeland': '1509494400',\n",
       " 'Dewshan': '1488326400',\n",
       " 'DonCrassus': '1498867200',\n",
       " 'hio__State': '1483228800',\n",
       " 'photenth': '1475280000',\n",
       " 'lionhart280': '1498867200',\n",
       " 'ObserverOfTruth': '1491004800',\n",
       " 'ceejthemoonman': '1483228800',\n",
       " 'Herxheim': '1483228800',\n",
       " 'gamedevresponder': '1493596800',\n",
       " 'AmbitiousTrader': '1509494400',\n",
       " 'PrincessIceheart': '1496275200',\n",
       " 'sudo-tleilaxu': '1483228800',\n",
       " 'AhhShiet': '1509494400',\n",
       " 'RIDER_OF_BROHAN': '1509494400',\n",
       " 'Tassnomass': '1506816000',\n",
       " 'weknownothingatall': '1509494400',\n",
       " 'Eric_Es': '1491004800',\n",
       " 'Gilded_Lioness': '1480550400',\n",
       " 'TV_tan': '1509494400',\n",
       " 'BizarroMork': '1493596800',\n",
       " 'DudeBroBrahBossChief': '1475280000',\n",
       " 'igweyliogsuh': '1488326400',\n",
       " 'kidxer': '1496275200',\n",
       " 'TheNimbleBanana': '1485907200',\n",
       " '1111111111111144': '1506816000',\n",
       " 'druhill007': '1488326400',\n",
       " 'OneOfDozens': '1477958400',\n",
       " 'Die_u_black_turd': '1506816000',\n",
       " 'THES8N': '1512086400',\n",
       " 'Hobo_Taco': '1501545600',\n",
       " 'KalimantanJuro': '1451606400',\n",
       " 'mtryp': '1472688000',\n",
       " 'Fronesis': '1512086400',\n",
       " 'saurongetti': '1451606400',\n",
       " 'Evil_Skip_Bayless': '1498867200',\n",
       " 'BTBishops': '1496275200',\n",
       " 'yung_hott_kidd': '1501545600',\n",
       " 'autopornbot': '1464739200',\n",
       " 'abzzzzzzzzzz': '1493596800',\n",
       " 'Kanzisbuddy': '1472688000',\n",
       " 'blamethelag21': '1493596800',\n",
       " 'dbstfbh': '1491004800',\n",
       " 'dumbflame': '1496275200',\n",
       " 'Foo_001': '1488326400',\n",
       " 'monkey-see-doggy-do': '1454284800',\n",
       " 'jamisonglory': '1464739200',\n",
       " 'zippityd0dah': '1485907200',\n",
       " 'Goats_throwaway': '1506816000',\n",
       " 'SkepticalFaceless': '1454284800',\n",
       " 'horse_and_buggy': '1491004800',\n",
       " 'angusshangus': '1501545600',\n",
       " 'Brad_Wesley': '1483228800',\n",
       " 'PandaK00sh': '1488326400',\n",
       " 'doctorspooge': '1480550400',\n",
       " 'TheCIASellsDrugs': '1509494400',\n",
       " 'princessprettypetty': '1488326400',\n",
       " 'uhuhuhu': '1483228800',\n",
       " 'damaged_unicycle': '1477958400',\n",
       " 'redtape20': '1477958400',\n",
       " 'BobMajerle': '1493596800',\n",
       " 'The_Masterbolt': '1491004800',\n",
       " 'lord_allonymous': '1493596800',\n",
       " 'Aninoop': '1456790400',\n",
       " 'Master-Chief-Kief': '1485907200',\n",
       " 'JU5TIN_HERGINA': '1462060800',\n",
       " 'Antartika': '1451606400',\n",
       " 'TimMH1': '1475280000',\n",
       " 'poply': '1483228800',\n",
       " 'Patello': '1491004800',\n",
       " 'franciseight': '1509494400',\n",
       " 'LuchaDemon': '1504224000',\n",
       " 'molybdenumsteels': '1506816000',\n",
       " 'AnnaBortion': '1491004800',\n",
       " 'jr111222': '1488326400',\n",
       " 'slyweazal': '1480550400',\n",
       " 'Wolfwoman1210': '1480550400',\n",
       " '50calls0replies': '1509494400',\n",
       " 'DrauglinRog': '1459468800',\n",
       " 'truckerslife': '1480550400',\n",
       " 'Poobyrd': '1475280000',\n",
       " 'ZWhitford': '1467331200',\n",
       " 'SMJ1980': '1512086400',\n",
       " 'FBI_Shitpost': '1477958400',\n",
       " 'smackson': '1491004800',\n",
       " 'Acyren': '1485907200',\n",
       " 'They-drew-firstblood': '1480550400',\n",
       " 'pboswell': '1501545600',\n",
       " 'drogean2': '1475280000',\n",
       " 'HiggsBoson_82': '1475280000',\n",
       " 'hi_do_you_like_it': '1485907200',\n",
       " 'TheFatMistake': '1509494400',\n",
       " 'de_la_sankarbocknov': '1506816000',\n",
       " 'bagelofdoom': '1467331200',\n",
       " 'smellofburntalmonds': '1488326400',\n",
       " 'EasyFunMoney': '1488326400',\n",
       " 'Jarrz': '1488326400',\n",
       " 'Aelinsaar': '1491004800',\n",
       " 'slee_stak': '1477958400',\n",
       " 'QS_iron': '1477958400',\n",
       " 'subesue': '1483228800',\n",
       " 'Abram1769': '1472688000',\n",
       " 'TruthSeeker1776': '1493596800',\n",
       " 'MoonbeamThunderbutt': '1472688000',\n",
       " 'kneeonbelly': '1496275200',\n",
       " 'Frost_999': '1509494400',\n",
       " 'cmonsmokesletsgo': '1498867200',\n",
       " 'BushWillWin': '1485907200',\n",
       " 'applextrent': '1485907200',\n",
       " 'FC_Stargate_United': '1491004800',\n",
       " 'Generic_On_Reddit': '1485907200',\n",
       " 'blvsh': '1498867200',\n",
       " 'lanceloomis': '1509494400',\n",
       " 'Changinggirl': '1475280000',\n",
       " 'Leonhart359': '1483228800',\n",
       " 'gulfstreamg650driver': '1459468800',\n",
       " 'qwerty1088': '1485907200',\n",
       " 'peterjackson2050': '1509494400',\n",
       " 'ciandy3': '1498867200',\n",
       " 'Ketchary': '1470009600',\n",
       " 'TheTopSnek': '1485907200',\n",
       " 'LOL_REALITY': '1472688000',\n",
       " 'DominarRygelThe16th': '1477958400',\n",
       " 'Long_Tetris_Piece': '1512086400',\n",
       " 'FR3DF3NST3R': '1485907200',\n",
       " 'dumbthings': '1491004800',\n",
       " '4563546g3': '1456790400',\n",
       " 'reddit4663': '1485907200',\n",
       " 'crazycanine': '1493596800',\n",
       " 'pikaras': '1475280000',\n",
       " 'Moonwalkingturtle': '1504224000',\n",
       " 'Gnome_Sayin': '1496275200',\n",
       " 'RuthlessTomato': '1451606400',\n",
       " 'TNBadBoy': '1480550400',\n",
       " 'stridernfs': '1454284800',\n",
       " 'ineffablename': '1506816000',\n",
       " 'thisisgettingworse': '1480550400',\n",
       " 'toxic_banana': '1485907200',\n",
       " 'Swineavionics': '1498867200',\n",
       " 'Artemis_Webb': '1485907200',\n",
       " 'mysteryroach': '1485907200',\n",
       " 'buttsloan': '1472688000',\n",
       " 'creamyturtle': '1512086400',\n",
       " 'The_UnderQueen': '1493596800',\n",
       " 'Vaperator': '1509494400',\n",
       " 'tykeryerson': '1470009600',\n",
       " 'BakedPastaParty': '1506816000',\n",
       " 'vea_ariam': '1491004800',\n",
       " 'gojo345': '1467331200',\n",
       " 'MaxwellStaxwell': '1451606400',\n",
       " 'Bump-4-Trump': '1483228800',\n",
       " 'Guerrilla_Time': '1509494400',\n",
       " 'CoolHandLukeSkywalka': '1509494400',\n",
       " 'Jubei07': '1470009600',\n",
       " 'Hitachi3': '1498867200',\n",
       " '3rdeyenotblind': '1493596800',\n",
       " 'EverGreenPLO': '1456790400',\n",
       " 'ae911truth-': '1462060800',\n",
       " 'seeker135': '1512086400',\n",
       " 'azzazaz': '1470009600',\n",
       " 'DickLikeAWorm': '1480550400',\n",
       " 'amoebassassian': '1477958400',\n",
       " 'PhrenicAcid': '1485907200',\n",
       " 'JUSTIN_HERGINA': '1451606400',\n",
       " 'magalodon45': '1504224000',\n",
       " 'calvinshobbs': '1451606400',\n",
       " 'Victawr': '1488326400',\n",
       " 'danc3r': '1475280000',\n",
       " 'C0matoes': '1454284800',\n",
       " 'octodo': '1498867200',\n",
       " 'Carthonas': '1480550400',\n",
       " 'Sax_maniacs': '1498867200',\n",
       " 'PravdaEst': '1512086400',\n",
       " 'cervecerias': '1488326400',\n",
       " 'BeaconOfAnonDim': '1483228800',\n",
       " 'FogOfInformation': '1451606400',\n",
       " 'hartofeugene': '1491004800',\n",
       " 'kummybears': '1498867200',\n",
       " 'xaqaria': '1477958400',\n",
       " 'irishbastard3000': '1512086400',\n",
       " 'xovertime22x': '1454284800',\n",
       " 'CointellBro': '1464739200',\n",
       " 'campbellsouup': '1477958400',\n",
       " 'acct2clarify4myself': '1477958400',\n",
       " 'thefirdblu': '1477958400',\n",
       " 'CJGodley1776': '1491004800',\n",
       " 'Kimochiru': '1485907200',\n",
       " 'menotconvinced': '1488326400',\n",
       " 'harris101': '1512086400',\n",
       " 'Please_Dont_Laugh': '1480550400',\n",
       " 'Nickilas': '1477958400',\n",
       " 'gologologolo': '1467331200',\n",
       " 'setthetrap': '1477958400',\n",
       " 'makinguphistory': '1512086400',\n",
       " 'MaliciousHippie': '1493596800',\n",
       " 'putadickinit': '1483228800',\n",
       " 'atleastlisten': '1493596800',\n",
       " 'euclidsbrother': '1483228800',\n",
       " 'Sek101': '1459468800',\n",
       " 'CounterSpinYT': '1488326400',\n",
       " 'Loboisreal': '1472688000',\n",
       " 'Ahem_Sure': '1485907200',\n",
       " 'mrselismith': '1506816000',\n",
       " 'O_B_L': '1485907200',\n",
       " 'lmpetus': '1451606400',\n",
       " 'Satori42': '1491004800',\n",
       " 'Nick12506': '1462060800',\n",
       " 'mouth_full_of_weenie': '1470009600',\n",
       " 'twomillcities': '1470009600',\n",
       " 'TrumpCanada': '1485907200',\n",
       " 'buzzlite': '1464739200',\n",
       " 'redwormcharlie': '1475280000',\n",
       " 'Irons_in_the_fire': '1488326400',\n",
       " 'themiddleman007': '1472688000',\n",
       " 'FactsAndEvidence': '1464739200',\n",
       " 'Slagworks': '1472688000',\n",
       " 'jhenry922': '1472688000',\n",
       " 'Lav92': '1485907200',\n",
       " 'jk729': '1454284800',\n",
       " 'FreedomsTorch': '1512086400',\n",
       " 'serialp0rt': '1506816000',\n",
       " 'tibetan_astronaut': '1504224000',\n",
       " 'Razor_Dn': '1491004800',\n",
       " 'Someone_Who_Isnt_You': '1470009600',\n",
       " 'DeathMetalDeath': '1480550400',\n",
       " 'datsraysis': '1501545600',\n",
       " 'Glueman71': '1485907200',\n",
       " 'YungTSJ': '1506816000',\n",
       " 'reccession': '1491004800',\n",
       " 'heineycan': '1498867200',\n",
       " 'PhilipAnthonyMI5': '1504224000',\n",
       " 'adambellford': '1480550400',\n",
       " 'whakka': '1501545600',\n",
       " 'Imabouttosleep': '1488326400',\n",
       " 'kiwisrkool': '1483228800',\n",
       " 'MarcoBoogers': '1472688000',\n",
       " 'djang084': '1506816000',\n",
       " 'sydewayzsoundz': '1470009600',\n",
       " 'x0_Kiss0fDeath': '1488326400',\n",
       " 'jedediahbennett': '1488326400',\n",
       " 'Juicebochts': '1491004800',\n",
       " 'sevenfacedsin': '1464739200',\n",
       " 'youareabarbarian': '1496275200',\n",
       " 'dyingiseasy': '1477958400',\n",
       " 'out-of_mana': '1506816000',\n",
       " 'reality_crusher': '1485907200',\n",
       " 'Jaxkr': '1470009600',\n",
       " 'young_alfredo': '1483228800',\n",
       " 'daneelr_olivaw': '1464739200',\n",
       " 'SynisterSilence': '1509494400',\n",
       " 'Rossman690': '1485907200',\n",
       " 'Tman972': '1506816000',\n",
       " 'Squirrelmanity': '1475280000',\n",
       " 'theundergroundsstar': '1506816000',\n",
       " 'omegawarrior3': '1483228800',\n",
       " 'CryoSage': '1475280000',\n",
       " 'clgfandom': '1504224000',\n",
       " 'Sodaducky': '1454284800',\n",
       " 'TormundMembersOnly': '1485907200',\n",
       " 'WanderingVirginia': '1485907200',\n",
       " 'diachi_revived': '1501545600',\n",
       " 'Waiting4AM8': '1477958400',\n",
       " 'Badadvicebilly': '1477958400',\n",
       " 'TH3SCARFATH3R': '1504224000',\n",
       " 'WorkingReddit': '1493596800',\n",
       " '_C0bb_': '1472688000',\n",
       " 'slobbie': '1451606400',\n",
       " 'hurf_mcdurf': '1480550400',\n",
       " 'MattyMoses': '1509494400',\n",
       " 'FreshPrinceofEternia': '1509494400',\n",
       " 'exicleus': '1491004800',\n",
       " 'doodoopoopscoop': '1506816000',\n",
       " 'DawnPendraig': '1493596800',\n",
       " 'el_beso_negro': '1488326400',\n",
       " 'Chrisgomez182': '1504224000',\n",
       " 'uranusvomited': '1480550400',\n",
       " 'quackchomp': '1496275200',\n",
       " 'nhstadt': '1501545600',\n",
       " 'die-ente': '1485907200',\n",
       " 'Fulliotomatix': '1509494400',\n",
       " 'Matt199620': '1506816000',\n",
       " 'NewYorkJewbag': '1475280000',\n",
       " 'c0olking': '1501545600',\n",
       " 'TheDaisyCutter': '1493596800',\n",
       " 'L00kInside': '1501545600',\n",
       " 'RANDOMLY_AGGRESSIVE': '1506816000',\n",
       " 'aleister': '1498867200',\n",
       " 'Ikantbeliveit': '1498867200',\n",
       " 'MKULTRAMONARCHMOUSE': '1477958400',\n",
       " 'Qu1nlan': '1467331200',\n",
       " 'Uhillbilly': '1475280000',\n",
       " 'Wormhog': '1456790400',\n",
       " 'YoureAllRobots': '1483228800',\n",
       " 'psilocybecyclone': '1459468800',\n",
       " 'JohnnyChimpo13': '1480550400',\n",
       " 'heykarlll': '1475280000',\n",
       " 'infamousnexus': '1491004800',\n",
       " 'TheTriviumOrg': '1491004800',\n",
       " 'PanickedPaladin': '1480550400',\n",
       " 'spamisakindofmeat': '1506816000',\n",
       " 'EndlessCompassion': '1454284800',\n",
       " 'TheHidden308': '1488326400',\n",
       " 'TheCrimsonCorndog': '1472688000',\n",
       " 'Brnmar13': '1506816000',\n",
       " 'LetMeFuckYourFace': '1506816000',\n",
       " 'Freqwaves': '1475280000',\n",
       " 'ghostwr1ter': '1475280000',\n",
       " 'ncm0229': '1475280000',\n",
       " 'lewdite': '1485907200',\n",
       " 'sangiga': '1501545600',\n",
       " 'davidickewasright': '1488326400',\n",
       " 'PStuLovesCrackk': '1467331200',\n",
       " 'FreshCope44': '1509494400',\n",
       " 'Slanderson77': '1454284800',\n",
       " '_Dazzle_': '1496275200',\n",
       " 'hannaht633': '1504224000',\n",
       " 'duckshoe2': '1451606400',\n",
       " 'mistamuncha': '1480550400',\n",
       " 'xxbeast15': '1483228800',\n",
       " 'faderjack': '1488326400',\n",
       " 'exoriare': '1480550400',\n",
       " 'RightNowImReady': '1475280000',\n",
       " 'mrnightowl': '1475280000',\n",
       " 'ZweiHollowFangs': '1506816000',\n",
       " 'bg3712': '1512086400',\n",
       " 'RikaMX': '1477958400',\n",
       " 'WestCoastHippy': '1488326400',\n",
       " '_josepi_': '1454284800',\n",
       " 'jasperellis': '1506816000',\n",
       " 'trollingtrollers': '1488326400',\n",
       " 'billmurri': '1512086400',\n",
       " '34adamlee77': '1451606400',\n",
       " 'ckyrulez': '1504224000',\n",
       " 'atherius_sin': '1472688000',\n",
       " 'AyKop47': '1475280000',\n",
       " 'ACiDGRiM': '1483228800',\n",
       " 'mooseknucks26': '1488326400',\n",
       " 'KaleMunoz': '1501545600',\n",
       " 'Kumode': '1483228800',\n",
       " 'Khepri_Rising': '1480550400',\n",
       " 'ClimateMaster': '1477958400',\n",
       " 'Hendrix811': '1512086400',\n",
       " '7laymanc': '1477958400',\n",
       " 'Yung_Relight': '1483228800',\n",
       " 'newuser1997': '1496275200',\n",
       " 'whereispepesilvia': '1491004800',\n",
       " 'WolfThawra': '1483228800',\n",
       " 'nakedtime313': '1464739200',\n",
       " 'frydchiken333': '1488326400',\n",
       " 'ChieferSutherland': '1491004800',\n",
       " 'crs205': '1483228800',\n",
       " 'TedCruzEatsBoogers2': '1488326400',\n",
       " 'NashCop': '1506816000',\n",
       " 'Jurgrady': '1512086400',\n",
       " 'Darkwind85': '1483228800',\n",
       " 'simendem': '1488326400',\n",
       " 'burn_reddit_burn': '1483228800',\n",
       " 'rachelchocolate': '1477958400',\n",
       " 'Nightauditor1981': '1470009600',\n",
       " 'kurisu7885': '1509494400',\n",
       " 'Blunt4words20': '1477958400',\n",
       " 'Myhouseisamess': '1475280000',\n",
       " 'vbullinger': '1456790400',\n",
       " 'TheHighBlatman': '1480550400',\n",
       " 'shortmanlongfingers': '1509494400',\n",
       " 'U_CAN_TRUST_HILLARY': '1509494400',\n",
       " 'theantidilluvian': '1509494400',\n",
       " 'chappaquiditch': '1467331200',\n",
       " 'jaspersnutts': '1483228800',\n",
       " 'docganja': '1512086400',\n",
       " 'ClearlyJames': '1512086400',\n",
       " 'denizen42': '1470009600',\n",
       " 'Xrpfan': '1512086400',\n",
       " 'viscous_continuity': '1504224000',\n",
       " 'TheHoboExpress': '1491004800',\n",
       " 'theprofiteer': '1480550400',\n",
       " 'antiward': '1456790400',\n",
       " 'flyingcaveman': '1451606400',\n",
       " 'reredrumasiyrallih': '1470009600',\n",
       " 'CrashedonMars': '1496275200',\n",
       " 'innerlondonviolence': '1506816000',\n",
       " 'Moir53': '1475280000',\n",
       " 'ZionsDownvoteBrigade': '1477958400',\n",
       " 'xcitableone': '1485907200',\n",
       " 'KickedinTheDick': '1472688000',\n",
       " 'Marionumber1': '1480550400',\n",
       " 'mithex': '1488326400',\n",
       " '1_wing_angel': '1512086400',\n",
       " 'TitusAndroniKus': '1509494400',\n",
       " 'jadeski': '1485907200',\n",
       " 'snarkesor': '1488326400',\n",
       " 'LEGALinSCCCA': '1470009600',\n",
       " 'TaxAllHairDye': '1506816000',\n",
       " 'dudewheresmycar-ma': '1506816000',\n",
       " 'Paranoiaaaattack': '1488326400',\n",
       " 'Redchevron': '1459468800',\n",
       " 'TheKillector': '1485907200',\n",
       " 'avoidgettingraped': '1475280000',\n",
       " 'dionthorn': '1498867200',\n",
       " 'XyZeR': '1483228800',\n",
       " 'Amidza': '1509494400',\n",
       " 'The_All_Golden': '1501545600',\n",
       " 'p8107': '1485907200',\n",
       " 'Rambles64': '1512086400',\n",
       " '-o-o-o': '1470009600',\n",
       " 'Fidgeting_Demiurg': '1472688000',\n",
       " 'Beginning_End': '1506816000',\n",
       " 'child_of_old': '1485907200',\n",
       " 'MetalLadyBenz': '1512086400',\n",
       " 'lone_geek': '1477958400',\n",
       " 'Glaesher': '1506816000',\n",
       " 'Agnos': '1462060800',\n",
       " 'LTS1287': '1480550400',\n",
       " 'RedditSilverRobot': '1506816000',\n",
       " 'r3d-f0x': '1498867200',\n",
       " 'mrwednesday314': '1477958400',\n",
       " 'vapedoutofmymind': '1491004800',\n",
       " 'DildoEngineer69': '1493596800',\n",
       " 'Anti-Hero_of_Time': '1498867200',\n",
       " 'HasidicJew123': '1467331200',\n",
       " 'ithasanh': '1480550400',\n",
       " 'cpujockey': '1512086400',\n",
       " 'yalpelgoog': '1496275200',\n",
       " 'Emighty': '1485907200',\n",
       " 'radickulous': '1493596800',\n",
       " 'Memeliciouz': '1491004800',\n",
       " 'wrathofheaven1111': '1477958400',\n",
       " 'zanzibarLunch': '1488326400',\n",
       " 'trubaited': '1491004800',\n",
       " 'brianm41': '1488326400',\n",
       " 'NukaWax': '1504224000',\n",
       " 'bezzzerk': '1498867200',\n",
       " 'klakkr': '1475280000',\n",
       " 'TrueBlueMichiganMan': '1462060800',\n",
       " 'FrankReshman': '1483228800',\n",
       " 'CaptKamClique': '1504224000',\n",
       " 'alucepstesumuf': '1485907200',\n",
       " 'Sluts_Love_Me': '1488326400',\n",
       " 'clickwhistle': '1488326400',\n",
       " 'BeingStoned': '1462060800',\n",
       " 'workingthebridge': '1501545600',\n",
       " 'n1ght_cab': '1496275200',\n",
       " 'MahSelectah': '1493596800',\n",
       " 'thedogshittacos': '1480550400',\n",
       " 'NagevegaN': '1501545600',\n",
       " 'Ian_For_President': '1506816000',\n",
       " 'DirtieHarry': '1496275200',\n",
       " 'occupythekitchen': '1477958400',\n",
       " 'idkifthrowaway1': '1506816000',\n",
       " 'deathcabforben': '1477958400',\n",
       " 'Hail_Trump_69': '1512086400',\n",
       " 'zhibdon': '1477958400',\n",
       " 'ExaltB2': '1491004800',\n",
       " 'ButlerianJihadist': '1501545600',\n",
       " 's69-5': '1472688000',\n",
       " 'sciencesez': '1483228800',\n",
       " 'DougieJones84': '1506816000',\n",
       " 'IBetThisIsTakenToo': '1477958400',\n",
       " 'rockhounding': '1509494400',\n",
       " 'KingOfDaVillage': '1456790400',\n",
       " 'bartikus': '1475280000',\n",
       " 'reammeupscotty': '1512086400',\n",
       " 'brasiwsu': '1477958400',\n",
       " 'Tasgall': '1504224000',\n",
       " 'LosJones': '1498867200',\n",
       " '20thsieclefox': '1488326400',\n",
       " 'Blewedup': '1477958400',\n",
       " 'luniz6178': '1483228800',\n",
       " 'NotDaFeds': '1496275200',\n",
       " 'AmericaAndJesus': '1459468800',\n",
       " 'chunk_le_funk': '1506816000',\n",
       " 'bri9and': '1485907200',\n",
       " 'BuddhistSC': '1483228800',\n",
       " 'ayyyits777': '1512086400',\n",
       " 'doihavemakeanewword': '1475280000',\n",
       " 'Rhodechill': '1504224000',\n",
       " 'bacasarus_rex': '1485907200',\n",
       " 'Xanny': '1475280000',\n",
       " 'Grundelwald': '1483228800',\n",
       " 'condogula': '1504224000',\n",
       " 'Hitpiecesmash': '1475280000',\n",
       " 'BlackStarPrince': '1459468800',\n",
       " 'necrambo': '1496275200',\n",
       " 'The_Ruffneck': '1480550400',\n",
       " 'masaul91': '1506816000',\n",
       " 'Werpogil': '1483228800',\n",
       " 'shadowbanyourface': '1496275200',\n",
       " 'easyasitwas': '1509494400',\n",
       " 'quietthomas': '1451606400',\n",
       " 'kybarnet': '1501545600',\n",
       " 'Rimm': '1454284800',\n",
       " 'phillmorton82': '1477958400',\n",
       " 'tryingmyhardest88': '1464739200',\n",
       " 'reddbullish': '1454284800',\n",
       " 'opsechill': '1470009600',\n",
       " 'Megatrilobyte': '1491004800',\n",
       " 'obeytrafficlights': '1475280000',\n",
       " 'Dick_Wingnut': '1488326400',\n",
       " 'Raneados': '1483228800',\n",
       " 'cojoco': '1483228800',\n",
       " 'LeviPerson': '1501545600',\n",
       " 'Smiley_Iris': '1491004800',\n",
       " 'egbdfaces': '1498867200',\n",
       " 'HillaryIsAFaggotSoRU': '1480550400',\n",
       " 'inteuniso': '1496275200',\n",
       " 'Singularity2soon': '1504224000',\n",
       " 'Bmyrab': '1456790400',\n",
       " 'students4trumpMI': '1485907200',\n",
       " 'sharia_law': '1467331200',\n",
       " 'BigBrownBeav': '1459468800',\n",
       " 'rorschachsqt': '1470009600',\n",
       " 'CantGoToNaples': '1509494400',\n",
       " 'TotalNewsTV': '1470009600',\n",
       " 'judgeshawpk': '1483228800',\n",
       " 'WHY111': '1451606400',\n",
       " 'samacora': '1451606400',\n",
       " 'ChiefReefOGhashdb': '1504224000',\n",
       " 'Vailhem': '1501545600',\n",
       " 'ThumpNuts': '1464739200',\n",
       " 'combatjellyfish': '1480550400',\n",
       " 'Cynikal818': '1488326400',\n",
       " 'hj860815': '1491004800',\n",
       " 'Thekidseateverything': '1493596800',\n",
       " 'danjo_kandui': '1496275200',\n",
       " 'Mrfantasdic': '1451606400',\n",
       " 'AssuredlyAThrowAway': '1464739200',\n",
       " 'therager': '1485907200',\n",
       " 'Totality-Infinity': '1475280000',\n",
       " 'dwcmwa': '1480550400',\n",
       " 'mrcassette': '1456790400',\n",
       " 'Grip_Mod_Parts': '1477958400',\n",
       " 'DownUpOverAndBack': '1506816000',\n",
       " 'quantum_of_quantum': '1501545600',\n",
       " 'faunprincess': '1506816000',\n",
       " 'macksbond': '1493596800',\n",
       " 'BARchitecture': '1477958400',\n",
       " 'pawsmface': '1512086400',\n",
       " 'laseyload': '1462060800',\n",
       " 'JediMasterSteveDave': '1462060800',\n",
       " 'gitarooman87': '1493596800',\n",
       " 'GrassandBricks': '1451606400',\n",
       " 'Lost_boy_Takanawa': '1483228800',\n",
       " 'Throw671542': '1454284800',\n",
       " 'SpacePirat3': '1504224000',\n",
       " 'poshpotdllr': '1512086400',\n",
       " 'MrJDouble': '1483228800',\n",
       " 'Mike_Rubin': '1472688000',\n",
       " 'Srynaive': '1506816000',\n",
       " '-0-1-0-': '1488326400',\n",
       " 'EvlSteveDave': '1506816000',\n",
       " 'NotOneStar': '1506816000',\n",
       " 'Objectively_Stated': '1483228800',\n",
       " 'Mod_Impersonator': '1480550400',\n",
       " 'KeefHerban': '1493596800',\n",
       " 'ApotropaicSpirit': '1504224000',\n",
       " 'amisupposedtopost': '1454284800',\n",
       " 'remchien': '1485907200',\n",
       " 'CuckedByJaredFogle': '1464739200',\n",
       " 'King-Hell': '1451606400',\n",
       " 'Stransky316': '1506816000',\n",
       " '-AVENTUS-': '1512086400',\n",
       " 'Brodusgus': '1451606400',\n",
       " 'levelheadedmofo': '1509494400',\n",
       " 'trackerbishop3': '1491004800',\n",
       " 'ChillyWillster': '1485907200',\n",
       " 'columbo33': '1506816000',\n",
       " 'Based1776': '1506816000',\n",
       " 'TyrannosuarezRex': '1475280000',\n",
       " 'GeorgeWebbRapedMe': '1496275200',\n",
       " 'MoldyLocksNesMonster': '1493596800',\n",
       " '_papi_chulo': '1477958400',\n",
       " 'Cadaverlanche': '1475280000',\n",
       " 'antisocially_awkward': '1480550400',\n",
       " 'no_easy-way': '1501545600',\n",
       " 'JrSlimss': '1512086400',\n",
       " '-TruthHurts-': '1464739200',\n",
       " 'ConformitySucks': '1493596800',\n",
       " 'Arfalicious': '1498867200',\n",
       " 'OnAllDAY': '1485907200',\n",
       " 'PotFoodLover': '1491004800',\n",
       " 'Lucifer_The_Unclean': '1454284800',\n",
       " 'DontShoot2Kill': '1485907200',\n",
       " 'Barons_Cyber_Account': '1493596800',\n",
       " 'ILikeMyBlueEyes': '1475280000',\n",
       " 'drummer1248': '1464739200',\n",
       " 'covertoperations911': '1480550400',\n",
       " 'Deathoftheages': '1451606400',\n",
       " 'Dsalter123': '1480550400',\n",
       " 'MethaCat': '1509494400',\n",
       " 'Granite66': '1472688000',\n",
       " 'NikoTheApostate': '1483228800',\n",
       " 'cadhoit_ban': '1509494400',\n",
       " 'ewrogers': '1485907200',\n",
       " 'ebonifragaria': '1493596800',\n",
       " 'RueKing': '1493596800',\n",
       " 'AgentofAnarchy': '1496275200',\n",
       " 'PreachyVegan': '1493596800',\n",
       " 'trynafinishbowl': '1485907200',\n",
       " '1forthethumb': '1477958400',\n",
       " 'ConspiracyCorners': '1480550400',\n",
       " 'ufoinsight': '1483228800',\n",
       " 'kaerfasiyrallih': '1475280000',\n",
       " 'pazur13': '1501545600',\n",
       " 'yldas': '1493596800',\n",
       " 'LordHelmschen': '1512086400',\n",
       " 'CallMeShudd': '1480550400',\n",
       " 'iamanian': '1475280000',\n",
       " 'Sirkke': '1501545600',\n",
       " 'punkinhat': '1477958400',\n",
       " 'chadthecat': '1498867200',\n",
       " 'VivaLaRevolucione': '1488326400',\n",
       " 'theBrineySeaMan': '1493596800',\n",
       " 'helpimnaked': '1506816000',\n",
       " 'JoeBidenIsAFkingSick': '1488326400',\n",
       " 'CannedCheese006': '1512086400',\n",
       " 'ReallyBigDeal': '1485907200',\n",
       " 'nuttmeg8': '1491004800',\n",
       " 'cjnewson88': '1498867200',\n",
       " 'another_being': '1509494400',\n",
       " 'needsakoreangf': '1456790400',\n",
       " 'lordhandlee': '1509494400',\n",
       " 'DrGreybush710': '1509494400',\n",
       " 'barefootbraylyn': '1491004800',\n",
       " 'TrollsRLifeless': '1477958400',\n",
       " 'Sirchinaman': '1488326400',\n",
       " 'Low_Level_Outsider': '1498867200',\n",
       " 'n939x': '1506816000',\n",
       " 'typwar': '1459468800',\n",
       " 'bengle': '1451606400',\n",
       " 'liverpoolrob': '1475280000',\n",
       " 'SnazzyD': '1475280000',\n",
       " 'BeastPenguin': '1477958400',\n",
       " 'NotAMurderousAI': '1512086400',\n",
       " 'MJshoe': '1496275200',\n",
       " 'CYAAfghanistan': '1501545600',\n",
       " 'DerbyHC': '1493596800',\n",
       " 'Most-Obvious-Comment': '1485907200',\n",
       " 'dlbr2017': '1501545600',\n",
       " 'Troppin': '1456790400',\n",
       " 'DingusMacLeod': '1451606400',\n",
       " 'bearwave': '1456790400',\n",
       " 'idontreadinbox': '1485907200',\n",
       " 'Teledildonicdreams': '1491004800',\n",
       " 'Chillypill': '1456790400',\n",
       " 'josefshaw': '1496275200',\n",
       " 'supercubansandwich': '1480550400',\n",
       " 'Mii_IRL': '1496275200',\n",
       " 'reddefect': '1451606400',\n",
       " 'mrevil_tx': '1477958400',\n",
       " 'getityetquestionmark': '1451606400',\n",
       " 'SouthTampon': '1472688000',\n",
       " 'SlothropsKnob': '1472688000',\n",
       " 'OstranenieStrangely': '1506816000',\n",
       " 'an_actualiser': '1496275200',\n",
       " 'HublotKingCole': '1501545600',\n",
       " 'DoctorPrisme': '1477958400',\n",
       " 'kcufRTCsllihs': '1491004800',\n",
       " 'Magason': '1501545600',\n",
       " 'atheists4jesus': '1477958400',\n",
       " '-R0SE': '1477958400',\n",
       " ...}"
      ]
     },
     "execution_count": 20,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "tr"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 21,
   "metadata": {},
   "outputs": [],
   "source": [
    "new_tr = pd.DataFrame(tr.items(), columns=['author', 'month'])"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "import arrow\n",
    "def monthtoutc(month):\n",
    "    if int(month) > 12:\n",
    "        year = 2017\n",
    "        month = month-12\n",
    "    else:\n",
    "        year = 2016\n",
    "        \n",
    "        \n",
    "    return arrow.get(year, int(month), 1).timestamp\n",
    "    "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 22,
   "metadata": {},
   "outputs": [],
   "source": [
    "data_ref=data_ref.merge(new_tr, how='left')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 23,
   "metadata": {},
   "outputs": [
    {
     "ename": "KeyError",
     "evalue": "'created_utc'",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m\u001b[0m",
      "\u001b[0;31mKeyError\u001b[0mTraceback (most recent call last)",
      "\u001b[0;32m<ipython-input-23-6e91e11189d9>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mfinal_feats\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mdata_ref\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mloc\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mdata_ref\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'created_utc'\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m<\u001b[0m \u001b[0mdata_ref\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m'month'\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;32m/home/shruvp5/.local/lib/python2.7/site-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36m__getitem__\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   2686\u001b[0m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_multilevel\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2687\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2688\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_getitem_column\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2689\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2690\u001b[0m     \u001b[0;32mdef\u001b[0m \u001b[0m_getitem_column\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/shruvp5/.local/lib/python2.7/site-packages/pandas/core/frame.pyc\u001b[0m in \u001b[0;36m_getitem_column\u001b[0;34m(self, key)\u001b[0m\n\u001b[1;32m   2693\u001b[0m         \u001b[0;31m# get column\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2694\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mcolumns\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mis_unique\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2695\u001b[0;31m             \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_get_item_cache\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2696\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2697\u001b[0m         \u001b[0;31m# duplicate columns & possible reduce dimensionality\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/shruvp5/.local/lib/python2.7/site-packages/pandas/core/generic.pyc\u001b[0m in \u001b[0;36m_get_item_cache\u001b[0;34m(self, item)\u001b[0m\n\u001b[1;32m   2487\u001b[0m         \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mcache\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2488\u001b[0m         \u001b[0;32mif\u001b[0m \u001b[0mres\u001b[0m \u001b[0;32mis\u001b[0m \u001b[0mNone\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 2489\u001b[0;31m             \u001b[0mvalues\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_data\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   2490\u001b[0m             \u001b[0mres\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_box_item_values\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mvalues\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   2491\u001b[0m             \u001b[0mcache\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mres\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/shruvp5/.local/lib/python2.7/site-packages/pandas/core/internals.pyc\u001b[0m in \u001b[0;36mget\u001b[0;34m(self, item, fastpath)\u001b[0m\n\u001b[1;32m   4113\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4114\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0misna\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 4115\u001b[0;31m                 \u001b[0mloc\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mitem\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   4116\u001b[0m             \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   4117\u001b[0m                 \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mnp\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0marange\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mlen\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0misna\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mitems\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/home/shruvp5/.local/lib/python2.7/site-packages/pandas/core/indexes/base.pyc\u001b[0m in \u001b[0;36mget_loc\u001b[0;34m(self, key, method, tolerance)\u001b[0m\n\u001b[1;32m   3078\u001b[0m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3079\u001b[0m             \u001b[0;32mexcept\u001b[0m \u001b[0mKeyError\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m-> 3080\u001b[0;31m                 \u001b[0;32mreturn\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_engine\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_loc\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0m_maybe_cast_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m   3081\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m   3082\u001b[0m         \u001b[0mindexer\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mself\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_indexer\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0mkey\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmethod\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mmethod\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mtolerance\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mtolerance\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/index.pyx\u001b[0m in \u001b[0;36mpandas._libs.index.IndexEngine.get_loc\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;32mpandas/_libs/hashtable_class_helper.pxi\u001b[0m in \u001b[0;36mpandas._libs.hashtable.PyObjectHashTable.get_item\u001b[0;34m()\u001b[0m\n",
      "\u001b[0;31mKeyError\u001b[0m: 'created_utc'"
     ]
    }
   ],
   "source": [
    "final_feats = data_ref.loc[data_ref['created_utc'] < data_ref['month']]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 13,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>author</th>\n",
       "      <th>num_comments</th>\n",
       "      <th>archived</th>\n",
       "      <th>created_utc</th>\n",
       "      <th>subreddit</th>\n",
       "      <th>post_len</th>\n",
       "      <th>saved</th>\n",
       "      <th>stickied</th>\n",
       "      <th>score</th>\n",
       "      <th>over_18</th>\n",
       "      <th>gilded</th>\n",
       "      <th>quaratine</th>\n",
       "      <th>distinguished</th>\n",
       "      <th>month</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>4ad</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "      <td>1492372280</td>\n",
       "      <td>hiking</td>\n",
       "      <td>88</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>1</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1475280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>4ad</td>\n",
       "      <td>6</td>\n",
       "      <td>False</td>\n",
       "      <td>1492545319</td>\n",
       "      <td>Austria</td>\n",
       "      <td>42</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>7</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1475280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>4ad</td>\n",
       "      <td>4</td>\n",
       "      <td>False</td>\n",
       "      <td>1492531314</td>\n",
       "      <td>CampingGear</td>\n",
       "      <td>51</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>10</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1475280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>4ad</td>\n",
       "      <td>5</td>\n",
       "      <td>False</td>\n",
       "      <td>1491574312</td>\n",
       "      <td>iamveryculinary</td>\n",
       "      <td>39</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>9</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1475280000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4ad</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>1492530674</td>\n",
       "      <td>hiking</td>\n",
       "      <td>51</td>\n",
       "      <td>NaN</td>\n",
       "      <td>False</td>\n",
       "      <td>2</td>\n",
       "      <td>False</td>\n",
       "      <td>0</td>\n",
       "      <td>False</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1475280000</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "  author  num_comments archived  created_utc        subreddit  post_len saved  \\\n",
       "0    4ad             7    False   1492372280           hiking        88   NaN   \n",
       "1    4ad             6    False   1492545319          Austria        42   NaN   \n",
       "2    4ad             4    False   1492531314      CampingGear        51   NaN   \n",
       "3    4ad             5    False   1491574312  iamveryculinary        39   NaN   \n",
       "4    4ad             0    False   1492530674           hiking        51   NaN   \n",
       "\n",
       "   stickied  score  over_18  gilded quaratine distinguished       month  \n",
       "0     False      1    False       0     False           NaN  1475280000  \n",
       "1     False      7    False       0     False           NaN  1475280000  \n",
       "2     False     10    False       0     False           NaN  1475280000  \n",
       "3     False      9    False       0     False           NaN  1475280000  \n",
       "4     False      2    False       0     False           NaN  1475280000  "
      ]
     },
     "execution_count": 13,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "data_ref.head()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [],
   "source": [
    "final_feats.to_csv('./final_low_features_posts.gz', compression='gzip', sep=',')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 2",
   "language": "python",
   "name": "python2"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 2
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython2",
   "version": "2.7.12"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}