Downloads_Visualizations.ipynb

{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [
    {
     "name": "stderr",
     "output_type": "stream",
     "text": [
      "IOPub data rate exceeded.\n",
      "The notebook server will temporarily stop sending output\n",
      "to the client in order to avoid crashing it.\n",
      "To change this limit, set the config variable\n",
      "`--NotebookApp.iopub_data_rate_limit`.\n"
     ]
    }
   ],
   "source": [
    "from plotly import __version__\n",
    "from plotly.offline import download_plotlyjs, init_notebook_mode\n",
    "from plotly.offline import iplot as iplot_offline\n",
    "from plotly.offline import plot as plot_offline\n",
    "from plotly.plotly import iplot, plot\n",
    "from plotly.graph_objs import Scatter\n",
    "# from plotly.tools import FigureFactory as FF\n",
    "init_notebook_mode() # run at the start of every ipython notebook to use plotly.offline\n",
    "                     # this injects the plotly.js source files into the notebook\n",
    "\n",
    "%matplotlib inline\n",
    "import matplotlib as plt\n",
    "plt.style.use('ggplot')\n",
    "import scripts.daily_data as dd\n",
    "import pandas as pd\n",
    "import numpy as np\n",
    "from scipy import stats\n",
    "from datetime import datetime\n",
    "import plotly.plotly as py\n",
    "import plotly.graph_objs as go\n",
    "from plotly.graph_objs import graph_objs\n",
    "\n",
    "import requests"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import os, re\n",
    "import datetime as dt"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "testset = ['./raw_data/three-month-export_2016-04-04.csv', './raw_data/three-month-export_2016-04-17.csv']"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "['./raw_data/three-month-export_2016-04-04.csv', './raw_data/three-month-export_2016-04-17.csv']\n"
     ]
    }
   ],
   "source": [
    "print(testset)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "2016-04-04\n",
      "2016-04-17\n"
     ]
    }
   ],
   "source": [
    "def get_time_from_filename(filename: str):\n",
    "    regex = r'[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]'\n",
    "    return re.findall(regex, filename)[0]\n",
    "print(get_time_from_filename(testset[0]))\n",
    "print(get_time_from_filename(testset[1]))"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "ename": "NameError",
     "evalue": "name 'make_df' is not defined",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-6-a2e41de8786e>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[0;32m----> 1\u001b[0;31m \u001b[0mmake_df\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mtestset\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mdownloads_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mvalues\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;36m0\u001b[0m\u001b[0;34m]\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mnum_downloads\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m",
      "\u001b[0;31mNameError\u001b[0m: name 'make_df' is not defined"
     ]
    }
   ],
   "source": [
    "make_df(testset[0]).downloads_df.values[0].num_downloads"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def make_df(filename: str) -> pd.DataFrame:\n",
    "    df_time = get_time_from_filename(filename)\n",
    "    df = pd.read_csv(filename, parse_dates=['release_date'])\n",
    "    data = {\n",
    "        'title': df.item_title.values,\n",
    "        'release_date': df.release_date.values,\n",
    "        'downloads': [[(df_time, num_downloads)]\n",
    "                      for num_downloads in df.downloads__total.values],\n",
    "        'downloads_df': [pd.DataFrame({ 'num_downloads': num_downloads}, index=[df_time])\n",
    "                                      for num_downloads in df.downloads__total.values]\n",
    "    }\n",
    "    return pd.DataFrame(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "def update_df_data(base_df, new_df):\n",
    "    for index, row in new_df.iterrows():\n",
    "        if row.title in base_df.title.values:\n",
    "            if row.downloads not in base_df[base_df.title == row.title].downloads.values:\n",
    "                base_df[base_df.title == row.title].downloads.values[0].append(row.downloads[0])\n",
    "                base_df.loc[base_df.title == row.title, 'downloads_df'] = pd.concat(\n",
    "                    [base_df.loc[base_df.title == row.title, 'downloads_df'].values[0],\n",
    "                        row.downloads_df])\n",
    "        else:\n",
    "            base_df = base_df.append(row)\n",
    "#         print(pd.concat([base_df.loc[base_df.title == row.title, 'downloads_df'].values[0],\n",
    "#                         row.downloads_df]))\n",
    "#     print(type(base_df.loc[base_df.title == row.title, 'downloads_df'].values[0]))\n",
    "    return base_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "base_df = pd.DataFrame(columns=['title', 'release_date', 'downloads', 'downloads_df'])"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "ename": "TypeError",
     "evalue": "cannot concatenate a non-NDFrame object",
     "output_type": "error",
     "traceback": [
      "\u001b[0;31m---------------------------------------------------------------------------\u001b[0m",
      "\u001b[0;31mTypeError\u001b[0m                                 Traceback (most recent call last)",
      "\u001b[0;32m<ipython-input-10-df26525c66c6>\u001b[0m in \u001b[0;36m<module>\u001b[0;34m()\u001b[0m\n\u001b[1;32m      7\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0mfile\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msplit\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m'.'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m[\u001b[0m\u001b[0;34m-\u001b[0m\u001b[0;36m1\u001b[0m\u001b[0;34m]\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mextensions\u001b[0m \u001b[0;32mand\u001b[0m \u001b[0;34m'three'\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mfile\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m      8\u001b[0m                 \u001b[0mfilepath\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mos\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mpath\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mjoin\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mroot\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0mfile\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m----> 9\u001b[0;31m                 \u001b[0mbase_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mupdate_df_data\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mbase_df\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mmake_df\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mfilepath\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     10\u001b[0m \u001b[0mbase_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mbase_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0msort_values\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mby\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0;34m'release_date'\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mreset_index\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m<ipython-input-8-9842bc4b3b50>\u001b[0m in \u001b[0;36mupdate_df_data\u001b[0;34m(base_df, new_df)\u001b[0m\n\u001b[1;32m      6\u001b[0m                 base_df.loc[base_df.title == row.title, 'downloads_df'] = pd.concat(\n\u001b[1;32m      7\u001b[0m                     [base_df.loc[base_df.title == row.title, 'downloads_df'].values[0],\n\u001b[0;32m----> 8\u001b[0;31m                         row.downloads_df])\n\u001b[0m\u001b[1;32m      9\u001b[0m         \u001b[0;32melse\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m     10\u001b[0m             \u001b[0mbase_df\u001b[0m \u001b[0;34m=\u001b[0m \u001b[0mbase_df\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mappend\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mrow\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/pandas/core/reshape/concat.py\u001b[0m in \u001b[0;36mconcat\u001b[0;34m(objs, axis, join, join_axes, ignore_index, keys, levels, names, verify_integrity, copy)\u001b[0m\n\u001b[1;32m    204\u001b[0m                        \u001b[0mkeys\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mkeys\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mlevels\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mlevels\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mnames\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mnames\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    205\u001b[0m                        \u001b[0mverify_integrity\u001b[0m\u001b[0;34m=\u001b[0m\u001b[0mverify_integrity\u001b[0m\u001b[0;34m,\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 206\u001b[0;31m                        copy=copy)\n\u001b[0m\u001b[1;32m    207\u001b[0m     \u001b[0;32mreturn\u001b[0m \u001b[0mop\u001b[0m\u001b[0;34m.\u001b[0m\u001b[0mget_result\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    208\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;32m/Library/Frameworks/Python.framework/Versions/3.5/lib/python3.5/site-packages/pandas/core/reshape/concat.py\u001b[0m in \u001b[0;36m__init__\u001b[0;34m(self, objs, axis, join, join_axes, keys, levels, names, ignore_index, verify_integrity, copy)\u001b[0m\n\u001b[1;32m    261\u001b[0m         \u001b[0;32mfor\u001b[0m \u001b[0mobj\u001b[0m \u001b[0;32min\u001b[0m \u001b[0mobjs\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    262\u001b[0m             \u001b[0;32mif\u001b[0m \u001b[0;32mnot\u001b[0m \u001b[0misinstance\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0mobj\u001b[0m\u001b[0;34m,\u001b[0m \u001b[0mNDFrame\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m:\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0;32m--> 263\u001b[0;31m                 \u001b[0;32mraise\u001b[0m \u001b[0mTypeError\u001b[0m\u001b[0;34m(\u001b[0m\u001b[0;34m\"cannot concatenate a non-NDFrame object\"\u001b[0m\u001b[0;34m)\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n\u001b[0m\u001b[1;32m    264\u001b[0m \u001b[0;34m\u001b[0m\u001b[0m\n\u001b[1;32m    265\u001b[0m             \u001b[0;31m# consolidate\u001b[0m\u001b[0;34m\u001b[0m\u001b[0;34m\u001b[0m\u001b[0m\n",
      "\u001b[0;31mTypeError\u001b[0m: cannot concatenate a non-NDFrame object"
     ]
    }
   ],
   "source": [
    "path = './raw_data/'\n",
    "extensions = ('.csv')\n",
    "\n",
    "if os.path.isdir(path):\n",
    "    for root, dirs, files in os.walk(os.path.abspath(path)):\n",
    "        for file in files:\n",
    "            if file.split('.')[-1] in extensions and 'three' in file:\n",
    "                filepath = os.path.join(root,file)\n",
    "                base_df = update_df_data(base_df, make_df(filepath))\n",
    "base_df = base_df.sort_values(by='release_date').reset_index()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 107,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "nan"
      ]
     },
     "execution_count": 107,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "base_df.downloads_df.values[0]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 103,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style>\n",
       "    .dataframe thead tr:only-child th {\n",
       "        text-align: right;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: left;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>index</th>\n",
       "      <th>title</th>\n",
       "      <th>release_date</th>\n",
       "      <th>downloads</th>\n",
       "      <th>downloads_df</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>79</td>\n",
       "      <td>Episode #1 - Introduction</td>\n",
       "      <td>2015-06-01 00:34:44</td>\n",
       "      <td>[(2016-08-14, 1106), (2017-09-23, 3009), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>78</td>\n",
       "      <td>TBP02 - Holding Up the Sky</td>\n",
       "      <td>2015-06-07 23:17:25</td>\n",
       "      <td>[(2016-08-14, 712), (2017-09-23, 2511), (2017-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>77</td>\n",
       "      <td>TBP03 - Bridging the Gender Gap</td>\n",
       "      <td>2015-06-15 01:30:08</td>\n",
       "      <td>[(2016-08-14, 574), (2017-09-23, 2374), (2017-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>76</td>\n",
       "      <td>TBP04 - Change Jar 2.0</td>\n",
       "      <td>2015-06-20 12:57:42</td>\n",
       "      <td>[(2016-08-14, 601), (2017-09-23, 2484), (2017-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>75</td>\n",
       "      <td>TBP05 - The World's Strongest</td>\n",
       "      <td>2015-06-28 22:55:15</td>\n",
       "      <td>[(2016-08-14, 510), (2017-09-23, 2373), (2017-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>74</td>\n",
       "      <td>TBP06 - Aboard the Pequod</td>\n",
       "      <td>2015-07-02 15:44:18</td>\n",
       "      <td>[(2016-08-14, 437), (2017-09-23, 2294), (2017-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>73</td>\n",
       "      <td>TBP07 - Under the Iron Veil</td>\n",
       "      <td>2015-07-06 13:30:54</td>\n",
       "      <td>[(2016-08-14, 494), (2017-09-23, 2536), (2017-...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>72</td>\n",
       "      <td>TBP08 - Bitcoin For The Bottom Billion</td>\n",
       "      <td>2015-07-09 20:35:37</td>\n",
       "      <td>[(2016-08-14, 570), (2017-09-23, 678), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>71</td>\n",
       "      <td>TBP09 - The Curious Case of Remittance</td>\n",
       "      <td>2015-07-19 18:11:43</td>\n",
       "      <td>[(2016-08-14, 503), (2017-09-23, 604), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>70</td>\n",
       "      <td>TBP10 - Bottoms Up</td>\n",
       "      <td>2015-07-24 13:32:59</td>\n",
       "      <td>[(2016-08-14, 440), (2017-09-23, 525), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>69</td>\n",
       "      <td>TBP11 - The End of Money</td>\n",
       "      <td>2015-08-03 04:12:02</td>\n",
       "      <td>[(2016-08-14, 534), (2017-09-23, 678), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>68</td>\n",
       "      <td>TBP12 - Boring Economics</td>\n",
       "      <td>2015-08-08 00:53:49</td>\n",
       "      <td>[(2016-08-14, 606), (2017-09-23, 742), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>67</td>\n",
       "      <td>TBP13 - The Greatest Truths</td>\n",
       "      <td>2015-08-15 13:01:54</td>\n",
       "      <td>[(2016-08-14, 434), (2017-09-23, 493), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>66</td>\n",
       "      <td>TBP14 - Sex and the Single Bitcoin</td>\n",
       "      <td>2015-08-23 20:25:05</td>\n",
       "      <td>[(2016-08-14, 533), (2017-09-23, 648), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>65</td>\n",
       "      <td>TBP15 - Ants Marching</td>\n",
       "      <td>2015-08-30 19:31:14</td>\n",
       "      <td>[(2016-08-14, 381), (2017-09-23, 484), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>64</td>\n",
       "      <td>TBP16 - The Dual Revolution</td>\n",
       "      <td>2015-09-06 14:23:52</td>\n",
       "      <td>[(2016-08-14, 414), (2017-09-23, 527), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>63</td>\n",
       "      <td>TBP17 - Oiling the Squeaky Wheel</td>\n",
       "      <td>2015-09-13 03:29:00</td>\n",
       "      <td>[(2016-08-14, 484), (2017-09-23, 565), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>62</td>\n",
       "      <td>TBP18 - From Cradle to Grave</td>\n",
       "      <td>2015-09-20 16:31:41</td>\n",
       "      <td>[(2016-08-14, 383), (2017-09-23, 468), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>61</td>\n",
       "      <td>TBP19 - Branding the Disruptive</td>\n",
       "      <td>2015-09-27 19:28:31</td>\n",
       "      <td>[(2016-08-14, 408), (2017-09-23, 499), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>60</td>\n",
       "      <td>TBP20 - Bottoms Up 2</td>\n",
       "      <td>2015-10-01 19:18:33</td>\n",
       "      <td>[(2016-08-14, 374), (2017-09-23, 474), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>59</td>\n",
       "      <td>TBP21 - Call For Papers</td>\n",
       "      <td>2015-10-10 13:06:37</td>\n",
       "      <td>[(2016-08-14, 357), (2017-09-23, 465), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>58</td>\n",
       "      <td>TBP22 - Vote With Your Feet</td>\n",
       "      <td>2015-10-15 14:15:56</td>\n",
       "      <td>[(2016-08-14, 317), (2017-09-23, 408), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>57</td>\n",
       "      <td>TBP23 - It’s a Mad, Mad, Mad, Mad Bitcoin World</td>\n",
       "      <td>2015-10-25 16:37:15</td>\n",
       "      <td>[(2016-08-14, 381), (2017-09-23, 465), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>56</td>\n",
       "      <td>TBP24 - Betting On Bitcoin</td>\n",
       "      <td>2015-11-01 19:02:29</td>\n",
       "      <td>[(2016-08-14, 618), (2017-09-23, 765), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>55</td>\n",
       "      <td>TBP25 - The $199 Incentive</td>\n",
       "      <td>2015-11-08 03:33:14</td>\n",
       "      <td>[(2016-08-14, 430), (2017-09-23, 500), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>54</td>\n",
       "      <td>TBP26 - Change Jar 3.0</td>\n",
       "      <td>2015-11-15 01:50:17</td>\n",
       "      <td>[(2016-08-14, 507), (2017-09-23, 577), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>53</td>\n",
       "      <td>TBP27 - London Calling</td>\n",
       "      <td>2015-11-22 16:30:21</td>\n",
       "      <td>[(2016-08-14, 551), (2017-09-23, 644), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>52</td>\n",
       "      <td>TBP28 - Modern Day Gold Rush</td>\n",
       "      <td>2015-11-29 17:24:50</td>\n",
       "      <td>[(2016-08-14, 557), (2017-09-23, 658), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>51</td>\n",
       "      <td>TBP29 - Take the Power Back</td>\n",
       "      <td>2015-12-06 16:35:49</td>\n",
       "      <td>[(2016-08-14, 582), (2017-09-23, 719), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>50</td>\n",
       "      <td>TBP30 - Bottoms Up 3</td>\n",
       "      <td>2015-12-13 18:30:27</td>\n",
       "      <td>[(2016-08-14, 472), (2017-09-23, 566), (2017-1...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>230</th>\n",
       "      <td>10</td>\n",
       "      <td>TBP156 - Combined Forces for Better Results</td>\n",
       "      <td>2017-09-28 02:57:13</td>\n",
       "      <td>[(2017-10-16, 3770), (2017-10-02, 3128), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>231</th>\n",
       "      <td>9</td>\n",
       "      <td>TBP157 - Modern Day Gold Rush Pt. II</td>\n",
       "      <td>2017-10-01 15:19:21</td>\n",
       "      <td>[(2017-10-16, 3511), (2017-10-02, 1750), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>232</th>\n",
       "      <td>8</td>\n",
       "      <td>Buy or Sell, What the Hell #3</td>\n",
       "      <td>2017-10-02 02:38:55</td>\n",
       "      <td>[(2017-10-16, 3487), (2017-11-19, 4039), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>233</th>\n",
       "      <td>7</td>\n",
       "      <td>Episode #17: On-Ramping with Dee</td>\n",
       "      <td>2017-10-03 11:46:40</td>\n",
       "      <td>[(2017-10-16, 3070), (2017-11-19, 3536), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>234</th>\n",
       "      <td>6</td>\n",
       "      <td>An Ethereum Podcast: Episode #4</td>\n",
       "      <td>2017-10-04 04:03:08</td>\n",
       "      <td>[(2017-10-16, 3892), (2017-11-19, 4627), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>235</th>\n",
       "      <td>5</td>\n",
       "      <td>The Ether Review #73 — Kik, Establishing a Mic...</td>\n",
       "      <td>2017-10-05 00:22:37</td>\n",
       "      <td>[(2017-10-16, 2638), (2017-11-19, 3159), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>236</th>\n",
       "      <td>4</td>\n",
       "      <td>TBP158 - The Credit Protocol</td>\n",
       "      <td>2017-10-05 02:54:09</td>\n",
       "      <td>[(2017-10-16, 3147), (2017-11-19, 3689), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>237</th>\n",
       "      <td>3</td>\n",
       "      <td>TBP Announcements: DOVU</td>\n",
       "      <td>2017-10-06 21:48:28</td>\n",
       "      <td>[(2017-10-16, 3037), (2017-11-19, 3582), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>238</th>\n",
       "      <td>2</td>\n",
       "      <td>TBP159 - Diary of a Made Man</td>\n",
       "      <td>2017-10-08 20:11:57</td>\n",
       "      <td>[(2017-10-16, 4016), (2017-11-19, 4938), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>239</th>\n",
       "      <td>1</td>\n",
       "      <td>BlockChannel Episode 31: Settling the Score, w...</td>\n",
       "      <td>2017-10-14 00:35:30</td>\n",
       "      <td>[(2017-10-16, 2626), (2017-11-19, 3685), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>240</th>\n",
       "      <td>0</td>\n",
       "      <td>TBP160 - Bitcoin Beats</td>\n",
       "      <td>2017-10-15 18:38:50</td>\n",
       "      <td>[(2017-10-16, 2087), (2017-11-19, 3951), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>241</th>\n",
       "      <td>17</td>\n",
       "      <td>BlockChannel Episode 32: Greasing the Blockcha...</td>\n",
       "      <td>2017-10-16 19:47:54</td>\n",
       "      <td>[(2017-11-19, 3853), (2017-11-12, 3756), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>242</th>\n",
       "      <td>16</td>\n",
       "      <td>TBP Announcements: Simply Vital Health</td>\n",
       "      <td>2017-10-17 00:24:23</td>\n",
       "      <td>[(2017-11-19, 3647), (2017-11-12, 3549), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>243</th>\n",
       "      <td>15</td>\n",
       "      <td>An Ethereum Podcast: Episode #5</td>\n",
       "      <td>2017-10-20 16:25:55</td>\n",
       "      <td>[(2017-11-19, 3913), (2017-11-12, 3766), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>244</th>\n",
       "      <td>14</td>\n",
       "      <td>TBP Announcements: STACK</td>\n",
       "      <td>2017-10-22 01:12:19</td>\n",
       "      <td>[(2017-11-19, 3468), (2017-11-12, 3361)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>245</th>\n",
       "      <td>1</td>\n",
       "      <td>TBP Announcements: Get Stack</td>\n",
       "      <td>2017-10-22 01:12:19</td>\n",
       "      <td>[(2017-10-22, 1324)]</td>\n",
       "      <td>num_downloads\n",
       "2017-10-22          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>246</th>\n",
       "      <td>13</td>\n",
       "      <td>TBP161 - A Foundation for the Data Economy</td>\n",
       "      <td>2017-10-22 05:30:59</td>\n",
       "      <td>[(2017-11-19, 4503), (2017-11-12, 4374), (2017...</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>247</th>\n",
       "      <td>12</td>\n",
       "      <td>BTCPODcast.mp3</td>\n",
       "      <td>2017-10-25 14:03:59</td>\n",
       "      <td>[(2017-11-19, 146), (2017-11-12, 145)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>248</th>\n",
       "      <td>11</td>\n",
       "      <td>TBP162 - Sweet Talk</td>\n",
       "      <td>2017-10-26 14:29:23</td>\n",
       "      <td>[(2017-11-19, 4069), (2017-11-12, 3896)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>249</th>\n",
       "      <td>10</td>\n",
       "      <td>BlockChannel Episode 33: Incentivizing Creator...</td>\n",
       "      <td>2017-10-27 02:12:10</td>\n",
       "      <td>[(2017-11-19, 3351), (2017-11-12, 3198)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>250</th>\n",
       "      <td>9</td>\n",
       "      <td>Buy or Sell, What the Hell #4</td>\n",
       "      <td>2017-10-27 20:26:45</td>\n",
       "      <td>[(2017-11-19, 4438), (2017-11-12, 4194)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>251</th>\n",
       "      <td>8</td>\n",
       "      <td>TBP163 - Savings and Savior</td>\n",
       "      <td>2017-10-29 03:38:25</td>\n",
       "      <td>[(2017-11-19, 3803), (2017-11-12, 3622)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>252</th>\n",
       "      <td>7</td>\n",
       "      <td>TBP164 - The Benefits of Familiarity</td>\n",
       "      <td>2017-10-30 19:55:02</td>\n",
       "      <td>[(2017-11-19, 4289), (2017-11-12, 4045)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>253</th>\n",
       "      <td>6</td>\n",
       "      <td>Devcon3: Recap Part 1</td>\n",
       "      <td>2017-11-03 01:13:35</td>\n",
       "      <td>[(2017-11-19, 4464), (2017-11-12, 4077)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>254</th>\n",
       "      <td>5</td>\n",
       "      <td>TBP165 - Praise for Cryptoassets</td>\n",
       "      <td>2017-11-05 11:46:28</td>\n",
       "      <td>[(2017-11-19, 3764), (2017-11-12, 3278)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>255</th>\n",
       "      <td>4</td>\n",
       "      <td>Devcon3: Recap Part 2</td>\n",
       "      <td>2017-11-05 14:54:24</td>\n",
       "      <td>[(2017-11-19, 5309), (2017-11-12, 4753)]</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>256</th>\n",
       "      <td>3</td>\n",
       "      <td>TBP166 - ATMs and ICOs</td>\n",
       "      <td>2017-11-12 23:08:43</td>\n",
       "      <td>[(2017-11-19, 4770)]</td>\n",
       "      <td>num_downloads\n",
       "2017-11-19          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>257</th>\n",
       "      <td>2</td>\n",
       "      <td>TBP Announcements: Globitex</td>\n",
       "      <td>2017-11-15 03:54:35</td>\n",
       "      <td>[(2017-11-19, 3238)]</td>\n",
       "      <td>num_downloads\n",
       "2017-11-19          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>258</th>\n",
       "      <td>1</td>\n",
       "      <td>TBP Announcements: Quantstamp</td>\n",
       "      <td>2017-11-16 16:00:09</td>\n",
       "      <td>[(2017-11-19, 2919)]</td>\n",
       "      <td>num_downloads\n",
       "2017-11-19          ...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>259</th>\n",
       "      <td>0</td>\n",
       "      <td>TBP167 - The Broader Economy III</td>\n",
       "      <td>2017-11-19 13:52:29</td>\n",
       "      <td>[(2017-11-19, 506)]</td>\n",
       "      <td>num_downloads\n",
       "2017-11-19          ...</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>260 rows × 5 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     index                                              title  \\\n",
       "0       79                          Episode #1 - Introduction   \n",
       "1       78                         TBP02 - Holding Up the Sky   \n",
       "2       77                    TBP03 - Bridging the Gender Gap   \n",
       "3       76                             TBP04 - Change Jar 2.0   \n",
       "4       75                      TBP05 - The World's Strongest   \n",
       "5       74                          TBP06 - Aboard the Pequod   \n",
       "6       73                        TBP07 - Under the Iron Veil   \n",
       "7       72             TBP08 - Bitcoin For The Bottom Billion   \n",
       "8       71             TBP09 - The Curious Case of Remittance   \n",
       "9       70                                 TBP10 - Bottoms Up   \n",
       "10      69                           TBP11 - The End of Money   \n",
       "11      68                           TBP12 - Boring Economics   \n",
       "12      67                        TBP13 - The Greatest Truths   \n",
       "13      66                 TBP14 - Sex and the Single Bitcoin   \n",
       "14      65                              TBP15 - Ants Marching   \n",
       "15      64                        TBP16 - The Dual Revolution   \n",
       "16      63                   TBP17 - Oiling the Squeaky Wheel   \n",
       "17      62                       TBP18 - From Cradle to Grave   \n",
       "18      61                    TBP19 - Branding the Disruptive   \n",
       "19      60                               TBP20 - Bottoms Up 2   \n",
       "20      59                            TBP21 - Call For Papers   \n",
       "21      58                        TBP22 - Vote With Your Feet   \n",
       "22      57    TBP23 - It’s a Mad, Mad, Mad, Mad Bitcoin World   \n",
       "23      56                         TBP24 - Betting On Bitcoin   \n",
       "24      55                         TBP25 - The $199 Incentive   \n",
       "25      54                             TBP26 - Change Jar 3.0   \n",
       "26      53                             TBP27 - London Calling   \n",
       "27      52                       TBP28 - Modern Day Gold Rush   \n",
       "28      51                        TBP29 - Take the Power Back   \n",
       "29      50                               TBP30 - Bottoms Up 3   \n",
       "..     ...                                                ...   \n",
       "230     10        TBP156 - Combined Forces for Better Results   \n",
       "231      9               TBP157 - Modern Day Gold Rush Pt. II   \n",
       "232      8                      Buy or Sell, What the Hell #3   \n",
       "233      7                   Episode #17: On-Ramping with Dee   \n",
       "234      6                    An Ethereum Podcast: Episode #4   \n",
       "235      5  The Ether Review #73 — Kik, Establishing a Mic...   \n",
       "236      4                       TBP158 - The Credit Protocol   \n",
       "237      3                            TBP Announcements: DOVU   \n",
       "238      2                       TBP159 - Diary of a Made Man   \n",
       "239      1  BlockChannel Episode 31: Settling the Score, w...   \n",
       "240      0                             TBP160 - Bitcoin Beats   \n",
       "241     17  BlockChannel Episode 32: Greasing the Blockcha...   \n",
       "242     16             TBP Announcements: Simply Vital Health   \n",
       "243     15                    An Ethereum Podcast: Episode #5   \n",
       "244     14                           TBP Announcements: STACK   \n",
       "245      1                       TBP Announcements: Get Stack   \n",
       "246     13         TBP161 - A Foundation for the Data Economy   \n",
       "247     12                                     BTCPODcast.mp3   \n",
       "248     11                                TBP162 - Sweet Talk   \n",
       "249     10  BlockChannel Episode 33: Incentivizing Creator...   \n",
       "250      9                      Buy or Sell, What the Hell #4   \n",
       "251      8                        TBP163 - Savings and Savior   \n",
       "252      7               TBP164 - The Benefits of Familiarity   \n",
       "253      6                              Devcon3: Recap Part 1   \n",
       "254      5                   TBP165 - Praise for Cryptoassets   \n",
       "255      4                              Devcon3: Recap Part 2   \n",
       "256      3                             TBP166 - ATMs and ICOs   \n",
       "257      2                        TBP Announcements: Globitex   \n",
       "258      1                      TBP Announcements: Quantstamp   \n",
       "259      0                   TBP167 - The Broader Economy III   \n",
       "\n",
       "           release_date                                          downloads  \\\n",
       "0   2015-06-01 00:34:44  [(2016-08-14, 1106), (2017-09-23, 3009), (2017...   \n",
       "1   2015-06-07 23:17:25  [(2016-08-14, 712), (2017-09-23, 2511), (2017-...   \n",
       "2   2015-06-15 01:30:08  [(2016-08-14, 574), (2017-09-23, 2374), (2017-...   \n",
       "3   2015-06-20 12:57:42  [(2016-08-14, 601), (2017-09-23, 2484), (2017-...   \n",
       "4   2015-06-28 22:55:15  [(2016-08-14, 510), (2017-09-23, 2373), (2017-...   \n",
       "5   2015-07-02 15:44:18  [(2016-08-14, 437), (2017-09-23, 2294), (2017-...   \n",
       "6   2015-07-06 13:30:54  [(2016-08-14, 494), (2017-09-23, 2536), (2017-...   \n",
       "7   2015-07-09 20:35:37  [(2016-08-14, 570), (2017-09-23, 678), (2017-1...   \n",
       "8   2015-07-19 18:11:43  [(2016-08-14, 503), (2017-09-23, 604), (2017-1...   \n",
       "9   2015-07-24 13:32:59  [(2016-08-14, 440), (2017-09-23, 525), (2017-1...   \n",
       "10  2015-08-03 04:12:02  [(2016-08-14, 534), (2017-09-23, 678), (2017-1...   \n",
       "11  2015-08-08 00:53:49  [(2016-08-14, 606), (2017-09-23, 742), (2017-1...   \n",
       "12  2015-08-15 13:01:54  [(2016-08-14, 434), (2017-09-23, 493), (2017-1...   \n",
       "13  2015-08-23 20:25:05  [(2016-08-14, 533), (2017-09-23, 648), (2017-1...   \n",
       "14  2015-08-30 19:31:14  [(2016-08-14, 381), (2017-09-23, 484), (2017-1...   \n",
       "15  2015-09-06 14:23:52  [(2016-08-14, 414), (2017-09-23, 527), (2017-1...   \n",
       "16  2015-09-13 03:29:00  [(2016-08-14, 484), (2017-09-23, 565), (2017-1...   \n",
       "17  2015-09-20 16:31:41  [(2016-08-14, 383), (2017-09-23, 468), (2017-1...   \n",
       "18  2015-09-27 19:28:31  [(2016-08-14, 408), (2017-09-23, 499), (2017-1...   \n",
       "19  2015-10-01 19:18:33  [(2016-08-14, 374), (2017-09-23, 474), (2017-1...   \n",
       "20  2015-10-10 13:06:37  [(2016-08-14, 357), (2017-09-23, 465), (2017-1...   \n",
       "21  2015-10-15 14:15:56  [(2016-08-14, 317), (2017-09-23, 408), (2017-1...   \n",
       "22  2015-10-25 16:37:15  [(2016-08-14, 381), (2017-09-23, 465), (2017-1...   \n",
       "23  2015-11-01 19:02:29  [(2016-08-14, 618), (2017-09-23, 765), (2017-1...   \n",
       "24  2015-11-08 03:33:14  [(2016-08-14, 430), (2017-09-23, 500), (2017-1...   \n",
       "25  2015-11-15 01:50:17  [(2016-08-14, 507), (2017-09-23, 577), (2017-1...   \n",
       "26  2015-11-22 16:30:21  [(2016-08-14, 551), (2017-09-23, 644), (2017-1...   \n",
       "27  2015-11-29 17:24:50  [(2016-08-14, 557), (2017-09-23, 658), (2017-1...   \n",
       "28  2015-12-06 16:35:49  [(2016-08-14, 582), (2017-09-23, 719), (2017-1...   \n",
       "29  2015-12-13 18:30:27  [(2016-08-14, 472), (2017-09-23, 566), (2017-1...   \n",
       "..                  ...                                                ...   \n",
       "230 2017-09-28 02:57:13  [(2017-10-16, 3770), (2017-10-02, 3128), (2017...   \n",
       "231 2017-10-01 15:19:21  [(2017-10-16, 3511), (2017-10-02, 1750), (2017...   \n",
       "232 2017-10-02 02:38:55  [(2017-10-16, 3487), (2017-11-19, 4039), (2017...   \n",
       "233 2017-10-03 11:46:40  [(2017-10-16, 3070), (2017-11-19, 3536), (2017...   \n",
       "234 2017-10-04 04:03:08  [(2017-10-16, 3892), (2017-11-19, 4627), (2017...   \n",
       "235 2017-10-05 00:22:37  [(2017-10-16, 2638), (2017-11-19, 3159), (2017...   \n",
       "236 2017-10-05 02:54:09  [(2017-10-16, 3147), (2017-11-19, 3689), (2017...   \n",
       "237 2017-10-06 21:48:28  [(2017-10-16, 3037), (2017-11-19, 3582), (2017...   \n",
       "238 2017-10-08 20:11:57  [(2017-10-16, 4016), (2017-11-19, 4938), (2017...   \n",
       "239 2017-10-14 00:35:30  [(2017-10-16, 2626), (2017-11-19, 3685), (2017...   \n",
       "240 2017-10-15 18:38:50  [(2017-10-16, 2087), (2017-11-19, 3951), (2017...   \n",
       "241 2017-10-16 19:47:54  [(2017-11-19, 3853), (2017-11-12, 3756), (2017...   \n",
       "242 2017-10-17 00:24:23  [(2017-11-19, 3647), (2017-11-12, 3549), (2017...   \n",
       "243 2017-10-20 16:25:55  [(2017-11-19, 3913), (2017-11-12, 3766), (2017...   \n",
       "244 2017-10-22 01:12:19           [(2017-11-19, 3468), (2017-11-12, 3361)]   \n",
       "245 2017-10-22 01:12:19                               [(2017-10-22, 1324)]   \n",
       "246 2017-10-22 05:30:59  [(2017-11-19, 4503), (2017-11-12, 4374), (2017...   \n",
       "247 2017-10-25 14:03:59             [(2017-11-19, 146), (2017-11-12, 145)]   \n",
       "248 2017-10-26 14:29:23           [(2017-11-19, 4069), (2017-11-12, 3896)]   \n",
       "249 2017-10-27 02:12:10           [(2017-11-19, 3351), (2017-11-12, 3198)]   \n",
       "250 2017-10-27 20:26:45           [(2017-11-19, 4438), (2017-11-12, 4194)]   \n",
       "251 2017-10-29 03:38:25           [(2017-11-19, 3803), (2017-11-12, 3622)]   \n",
       "252 2017-10-30 19:55:02           [(2017-11-19, 4289), (2017-11-12, 4045)]   \n",
       "253 2017-11-03 01:13:35           [(2017-11-19, 4464), (2017-11-12, 4077)]   \n",
       "254 2017-11-05 11:46:28           [(2017-11-19, 3764), (2017-11-12, 3278)]   \n",
       "255 2017-11-05 14:54:24           [(2017-11-19, 5309), (2017-11-12, 4753)]   \n",
       "256 2017-11-12 23:08:43                               [(2017-11-19, 4770)]   \n",
       "257 2017-11-15 03:54:35                               [(2017-11-19, 3238)]   \n",
       "258 2017-11-16 16:00:09                               [(2017-11-19, 2919)]   \n",
       "259 2017-11-19 13:52:29                                [(2017-11-19, 506)]   \n",
       "\n",
       "                                          downloads_df  \n",
       "0                                                  NaN  \n",
       "1                                                  NaN  \n",
       "2                                                  NaN  \n",
       "3                                                  NaN  \n",
       "4                                                  NaN  \n",
       "5                                                  NaN  \n",
       "6                                                  NaN  \n",
       "7                                                  NaN  \n",
       "8                                                  NaN  \n",
       "9                                                  NaN  \n",
       "10                                                 NaN  \n",
       "11                                                 NaN  \n",
       "12                                                 NaN  \n",
       "13                                                 NaN  \n",
       "14                                                 NaN  \n",
       "15                                                 NaN  \n",
       "16                                                 NaN  \n",
       "17                                                 NaN  \n",
       "18                                                 NaN  \n",
       "19                                                 NaN  \n",
       "20                                                 NaN  \n",
       "21                                                 NaN  \n",
       "22                                                 NaN  \n",
       "23                                                 NaN  \n",
       "24                                                 NaN  \n",
       "25                                                 NaN  \n",
       "26                                                 NaN  \n",
       "27                                                 NaN  \n",
       "28                                                 NaN  \n",
       "29                                                 NaN  \n",
       "..                                                 ...  \n",
       "230                                                NaN  \n",
       "231                                                NaN  \n",
       "232                                                NaN  \n",
       "233                                                NaN  \n",
       "234                                                NaN  \n",
       "235                                                NaN  \n",
       "236                                                NaN  \n",
       "237                                                NaN  \n",
       "238                                                NaN  \n",
       "239                                                NaN  \n",
       "240                                                NaN  \n",
       "241                                                NaN  \n",
       "242                                                NaN  \n",
       "243                                                NaN  \n",
       "244                                                NaN  \n",
       "245              num_downloads\n",
       "2017-10-22          ...  \n",
       "246                                                NaN  \n",
       "247                                                NaN  \n",
       "248                                                NaN  \n",
       "249                                                NaN  \n",
       "250                                                NaN  \n",
       "251                                                NaN  \n",
       "252                                                NaN  \n",
       "253                                                NaN  \n",
       "254                                                NaN  \n",
       "255                                                NaN  \n",
       "256              num_downloads\n",
       "2017-11-19          ...  \n",
       "257              num_downloads\n",
       "2017-11-19          ...  \n",
       "258              num_downloads\n",
       "2017-11-19          ...  \n",
       "259              num_downloads\n",
       "2017-11-19          ...  \n",
       "\n",
       "[260 rows x 5 columns]"
      ]
     },
     "execution_count": 103,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "base_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.5.0"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}