{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Analyzing the Social Networks of over 2.7 Billion Reddit Comments" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "\n", "This notebook gives detailed information to help better understand our paper. In this notebook, we will demonstrate how to construct the subreddits' social networks created by more than 2.7 billion comments. Additionally, we will demonstrate how to calculate various statistics related to the subreddits. This code is licensed under a BSD license. See [license file]()." ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 0. Setup" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Before we begin, make sure you have installed all the required Python packages. (The instructions below use pip. You can use easy_install, too.) Also, consider using virtualenv for a cleaner installation experience instead of sudo. We also recommend running the code via IPython Notebook.\n", "* sudo pip install --upgrade graphlab-create # We mainly used SFrame object, which is an open source package.\n", "* sudo pip install --upgrade praw\n", "* sudo pip install --upgrade seaborn\n", "* sudo pip install --upgrade networkx" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "# 1. Preparing the Dataset" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "First, we need to download the compressed Reddit dataset files from [pushshift.io website](http://files.pushshift.io/reddit/comments/). This dataset was created by [Jason Michael Baumgartner](https://twitter.com/jasonbaumgartne). Additional details about this dataset can be found at this [Link](https://www.reddit.com/r/datasets/comments/3bxlg7/i_have_every_publicly_available_reddit_comment/). Downloading this hundreds-of-GB dataset can take a considerable amount of time. To save time, you can download only one month’s, or several months’, worth of data. After we download the dataset, we notice that the dataset is organized in directories, where each directory contains the posts of a specific year. These directories contain posts that were published from December 2005 to the most recent month. For this tutorial, we utilized over 2.71 billion comments that were posted from December 2005 through October 2016. Let's create a single SFrame that contains all these posts. To achieve this, we first will convert each monthly zipped file into an SFrame object using the following code:" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "This non-commercial license of GraphLab Create for academic use is assigned .\n" ] }, { "name": "stderr", "output_type": "stream", "text": [ "[INFO] graphlab.cython.cy_server: GraphLab Create v1.10.1 started. Logging: /tmp/graphlab_server_1487345388.log\n" ] }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2009-09.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2009-09.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 100 lines in 1.59448 secs." ], "text/plain": [ "Parsing completed. Parsed 100 lines in 1.59448 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "------------------------------------------------------\n", "Inferred types from first 100 line(s) of file as \n", "column_type_hints=[dict]\n", "If parsing fails due to incorrect types, you can correct\n", "the inferred type list above and pass it to read_csv in\n", "the column_type_hints argument\n", "------------------------------------------------------\n" ] }, { "data": { "text/html": [ "
Read 88555 lines. Lines per second: 30815" ], "text/plain": [ "Read 88555 lines. Lines per second: 30815" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 972023 lines. Lines per second: 112707" ], "text/plain": [ "Read 972023 lines. Lines per second: 112707" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 1590501 lines. Lines per second: 114090" ], "text/plain": [ "Read 1590501 lines. Lines per second: 114090" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2009-09.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2009-09.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 2032276 lines in 17.5218 secs." ], "text/plain": [ "Parsing completed. Parsed 2032276 lines in 17.5218 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2007-07.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2007-07.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 100 lines in 0.198544 secs." ], "text/plain": [ "Parsing completed. Parsed 100 lines in 0.198544 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "------------------------------------------------------\n", "Inferred types from first 100 line(s) of file as \n", "column_type_hints=[dict]\n", "If parsing fails due to incorrect types, you can correct\n", "the inferred type list above and pass it to read_csv in\n", "the column_type_hints argument\n", "------------------------------------------------------\n" ] }, { "data": { "text/html": [ "
Read 94632 lines. Lines per second: 156665" ], "text/plain": [ "Read 94632 lines. Lines per second: 156665" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2007-07.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2007-07.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 203319 lines in 1.03305 secs." ], "text/plain": [ "Parsing completed. Parsed 203319 lines in 1.03305 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2010-04.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2010-04.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 100 lines in 0.488607 secs." ], "text/plain": [ "Parsing completed. Parsed 100 lines in 0.488607 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "------------------------------------------------------\n", "Inferred types from first 100 line(s) of file as \n", "column_type_hints=[dict]\n", "If parsing fails due to incorrect types, you can correct\n", "the inferred type list above and pass it to read_csv in\n", "the column_type_hints argument\n", "------------------------------------------------------\n" ] }, { "data": { "text/html": [ "
Read 92878 lines. Lines per second: 110761" ], "text/plain": [ "Read 92878 lines. Lines per second: 110761" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 987195 lines. Lines per second: 148575" ], "text/plain": [ "Read 987195 lines. Lines per second: 148575" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 1706306 lines. Lines per second: 140170" ], "text/plain": [ "Read 1706306 lines. Lines per second: 140170" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 2334976 lines. Lines per second: 134364" ], "text/plain": [ "Read 2334976 lines. Lines per second: 134364" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 2960967 lines. Lines per second: 128167" ], "text/plain": [ "Read 2960967 lines. Lines per second: 128167" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2010-04.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2010-04.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 3209898 lines in 25.185 secs." ], "text/plain": [ "Parsing completed. Parsed 3209898 lines in 25.185 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2008-02.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2008-02.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 100 lines in 0.617535 secs." ], "text/plain": [ "Parsing completed. Parsed 100 lines in 0.617535 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "------------------------------------------------------\n", "Inferred types from first 100 line(s) of file as \n", "column_type_hints=[dict]\n", "If parsing fails due to incorrect types, you can correct\n", "the inferred type list above and pass it to read_csv in\n", "the column_type_hints argument\n", "------------------------------------------------------\n" ] }, { "data": { "text/html": [ "
Read 90266 lines. Lines per second: 136605" ], "text/plain": [ "Read 90266 lines. Lines per second: 136605" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2008-02.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2008-02.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 441768 lines in 2.41619 secs." ], "text/plain": [ "Parsing completed. Parsed 441768 lines in 2.41619 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2013-11.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2013-11.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 100 lines in 0.398867 secs." ], "text/plain": [ "Parsing completed. Parsed 100 lines in 0.398867 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "------------------------------------------------------\n", "Inferred types from first 100 line(s) of file as \n", "column_type_hints=[dict]\n", "If parsing fails due to incorrect types, you can correct\n", "the inferred type list above and pass it to read_csv in\n", "the column_type_hints argument\n", "------------------------------------------------------\n" ] }, { "data": { "text/html": [ "
Read 93427 lines. Lines per second: 116655" ], "text/plain": [ "Read 93427 lines. Lines per second: 116655" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 1006340 lines. Lines per second: 164450" ], "text/plain": [ "Read 1006340 lines. Lines per second: 164450" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 1743658 lines. Lines per second: 150212" ], "text/plain": [ "Read 1743658 lines. Lines per second: 150212" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 2391411 lines. Lines per second: 143870" ], "text/plain": [ "Read 2391411 lines. Lines per second: 143870" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 3031451 lines. Lines per second: 137447" ], "text/plain": [ "Read 3031451 lines. Lines per second: 137447" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 3594639 lines. Lines per second: 132832" ], "text/plain": [ "Read 3594639 lines. Lines per second: 132832" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 4220255 lines. Lines per second: 128563" ], "text/plain": [ "Read 4220255 lines. Lines per second: 128563" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 4753808 lines. Lines per second: 125179" ], "text/plain": [ "Read 4753808 lines. Lines per second: 125179" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 5301805 lines. Lines per second: 123250" ], "text/plain": [ "Read 5301805 lines. Lines per second: 123250" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 5931101 lines. Lines per second: 121575" ], "text/plain": [ "Read 5931101 lines. Lines per second: 121575" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 6571219 lines. Lines per second: 120869" ], "text/plain": [ "Read 6571219 lines. Lines per second: 120869" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 7197659 lines. Lines per second: 120042" ], "text/plain": [ "Read 7197659 lines. Lines per second: 120042" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 7841761 lines. Lines per second: 119330" ], "text/plain": [ "Read 7841761 lines. Lines per second: 119330" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 8375294 lines. Lines per second: 118202" ], "text/plain": [ "Read 8375294 lines. Lines per second: 118202" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 9026227 lines. Lines per second: 117816" ], "text/plain": [ "Read 9026227 lines. Lines per second: 117816" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 9566787 lines. Lines per second: 117109" ], "text/plain": [ "Read 9566787 lines. Lines per second: 117109" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 10119730 lines. Lines per second: 116743" ], "text/plain": [ "Read 10119730 lines. Lines per second: 116743" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 10671402 lines. Lines per second: 116438" ], "text/plain": [ "Read 10671402 lines. Lines per second: 116438" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 11233997 lines. Lines per second: 115846" ], "text/plain": [ "Read 11233997 lines. Lines per second: 115846" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 11787972 lines. Lines per second: 115434" ], "text/plain": [ "Read 11787972 lines. Lines per second: 115434" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 12353489 lines. Lines per second: 114877" ], "text/plain": [ "Read 12353489 lines. Lines per second: 114877" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 12897495 lines. Lines per second: 114329" ], "text/plain": [ "Read 12897495 lines. Lines per second: 114329" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 13436392 lines. Lines per second: 113802" ], "text/plain": [ "Read 13436392 lines. Lines per second: 113802" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 13988021 lines. Lines per second: 113458" ], "text/plain": [ "Read 13988021 lines. Lines per second: 113458" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 14520339 lines. Lines per second: 113026" ], "text/plain": [ "Read 14520339 lines. Lines per second: 113026" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 15069128 lines. Lines per second: 112649" ], "text/plain": [ "Read 15069128 lines. Lines per second: 112649" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 15609421 lines. Lines per second: 112399" ], "text/plain": [ "Read 15609421 lines. Lines per second: 112399" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 16151055 lines. Lines per second: 112068" ], "text/plain": [ "Read 16151055 lines. Lines per second: 112068" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 16704318 lines. Lines per second: 111809" ], "text/plain": [ "Read 16704318 lines. Lines per second: 111809" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 17241869 lines. Lines per second: 111615" ], "text/plain": [ "Read 17241869 lines. Lines per second: 111615" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 17795142 lines. Lines per second: 111579" ], "text/plain": [ "Read 17795142 lines. Lines per second: 111579" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 18424883 lines. Lines per second: 111525" ], "text/plain": [ "Read 18424883 lines. Lines per second: 111525" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 18975285 lines. Lines per second: 111278" ], "text/plain": [ "Read 18975285 lines. Lines per second: 111278" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 19526267 lines. Lines per second: 111087" ], "text/plain": [ "Read 19526267 lines. Lines per second: 111087" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 20086301 lines. Lines per second: 110780" ], "text/plain": [ "Read 20086301 lines. Lines per second: 110780" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 20639753 lines. Lines per second: 110619" ], "text/plain": [ "Read 20639753 lines. Lines per second: 110619" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 21201167 lines. Lines per second: 110579" ], "text/plain": [ "Read 21201167 lines. Lines per second: 110579" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 21749911 lines. Lines per second: 110421" ], "text/plain": [ "Read 21749911 lines. Lines per second: 110421" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 22283649 lines. Lines per second: 110303" ], "text/plain": [ "Read 22283649 lines. Lines per second: 110303" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 22838839 lines. Lines per second: 110248" ], "text/plain": [ "Read 22838839 lines. Lines per second: 110248" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 23376937 lines. Lines per second: 110130" ], "text/plain": [ "Read 23376937 lines. Lines per second: 110130" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 23917882 lines. Lines per second: 110048" ], "text/plain": [ "Read 23917882 lines. Lines per second: 110048" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 24463955 lines. Lines per second: 109821" ], "text/plain": [ "Read 24463955 lines. Lines per second: 109821" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 24997999 lines. Lines per second: 109753" ], "text/plain": [ "Read 24997999 lines. Lines per second: 109753" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 25640106 lines. Lines per second: 109725" ], "text/plain": [ "Read 25640106 lines. Lines per second: 109725" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 26176052 lines. Lines per second: 109663" ], "text/plain": [ "Read 26176052 lines. Lines per second: 109663" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 26715229 lines. Lines per second: 109540" ], "text/plain": [ "Read 26715229 lines. Lines per second: 109540" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 27268234 lines. Lines per second: 109548" ], "text/plain": [ "Read 27268234 lines. Lines per second: 109548" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 27808660 lines. Lines per second: 109553" ], "text/plain": [ "Read 27808660 lines. Lines per second: 109553" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 28459486 lines. Lines per second: 109741" ], "text/plain": [ "Read 28459486 lines. Lines per second: 109741" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 29016107 lines. Lines per second: 109677" ], "text/plain": [ "Read 29016107 lines. Lines per second: 109677" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 29572557 lines. Lines per second: 109601" ], "text/plain": [ "Read 29572557 lines. Lines per second: 109601" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 30133329 lines. Lines per second: 109591" ], "text/plain": [ "Read 30133329 lines. Lines per second: 109591" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 30692742 lines. Lines per second: 109533" ], "text/plain": [ "Read 30692742 lines. Lines per second: 109533" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 31314738 lines. Lines per second: 109488" ], "text/plain": [ "Read 31314738 lines. Lines per second: 109488" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 31866356 lines. Lines per second: 109523" ], "text/plain": [ "Read 31866356 lines. Lines per second: 109523" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 32403692 lines. Lines per second: 109484" ], "text/plain": [ "Read 32403692 lines. Lines per second: 109484" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 33039587 lines. Lines per second: 109576" ], "text/plain": [ "Read 33039587 lines. Lines per second: 109576" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 33668152 lines. Lines per second: 109537" ], "text/plain": [ "Read 33668152 lines. Lines per second: 109537" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 34306832 lines. Lines per second: 109546" ], "text/plain": [ "Read 34306832 lines. Lines per second: 109546" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 34946529 lines. Lines per second: 109622" ], "text/plain": [ "Read 34946529 lines. Lines per second: 109622" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 35511155 lines. Lines per second: 109566" ], "text/plain": [ "Read 35511155 lines. Lines per second: 109566" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 36056678 lines. Lines per second: 109497" ], "text/plain": [ "Read 36056678 lines. Lines per second: 109497" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 36612604 lines. Lines per second: 109412" ], "text/plain": [ "Read 36612604 lines. Lines per second: 109412" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 37159827 lines. Lines per second: 109401" ], "text/plain": [ "Read 37159827 lines. Lines per second: 109401" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2013-11.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2013-11.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 37396497 lines in 342.139 secs." ], "text/plain": [ "Parsing completed. Parsed 37396497 lines in 342.139 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2015-04.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2015-04.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 100 lines in 0.312336 secs." ], "text/plain": [ "Parsing completed. Parsed 100 lines in 0.312336 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "------------------------------------------------------\n", "Inferred types from first 100 line(s) of file as \n", "column_type_hints=[dict]\n", "If parsing fails due to incorrect types, you can correct\n", "the inferred type list above and pass it to read_csv in\n", "the column_type_hints argument\n", "------------------------------------------------------\n" ] }, { "data": { "text/html": [ "
Read 87621 lines. Lines per second: 111139" ], "text/plain": [ "Read 87621 lines. Lines per second: 111139" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 958672 lines. Lines per second: 155552" ], "text/plain": [ "Read 958672 lines. Lines per second: 155552" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 1655795 lines. Lines per second: 146549" ], "text/plain": [ "Read 1655795 lines. Lines per second: 146549" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 2362006 lines. Lines per second: 139593" ], "text/plain": [ "Read 2362006 lines. Lines per second: 139593" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 2956617 lines. Lines per second: 133005" ], "text/plain": [ "Read 2956617 lines. Lines per second: 133005" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 3554639 lines. Lines per second: 128341" ], "text/plain": [ "Read 3554639 lines. Lines per second: 128341" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 4164682 lines. Lines per second: 124951" ], "text/plain": [ "Read 4164682 lines. Lines per second: 124951" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 4760649 lines. Lines per second: 122688" ], "text/plain": [ "Read 4760649 lines. Lines per second: 122688" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 5272966 lines. Lines per second: 120512" ], "text/plain": [ "Read 5272966 lines. Lines per second: 120512" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 5877312 lines. Lines per second: 118935" ], "text/plain": [ "Read 5877312 lines. Lines per second: 118935" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 6479044 lines. Lines per second: 117519" ], "text/plain": [ "Read 6479044 lines. Lines per second: 117519" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 7005855 lines. Lines per second: 116693" ], "text/plain": [ "Read 7005855 lines. Lines per second: 116693" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 7615144 lines. Lines per second: 115634" ], "text/plain": [ "Read 7615144 lines. Lines per second: 115634" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 8136265 lines. Lines per second: 114780" ], "text/plain": [ "Read 8136265 lines. Lines per second: 114780" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 8750335 lines. Lines per second: 114224" ], "text/plain": [ "Read 8750335 lines. Lines per second: 114224" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 9348939 lines. Lines per second: 113612" ], "text/plain": [ "Read 9348939 lines. Lines per second: 113612" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 9940693 lines. Lines per second: 113174" ], "text/plain": [ "Read 9940693 lines. Lines per second: 113174" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 10544254 lines. Lines per second: 112865" ], "text/plain": [ "Read 10544254 lines. Lines per second: 112865" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 11146698 lines. Lines per second: 112536" ], "text/plain": [ "Read 11146698 lines. Lines per second: 112536" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 11650185 lines. Lines per second: 111939" ], "text/plain": [ "Read 11650185 lines. Lines per second: 111939" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 12241374 lines. Lines per second: 111652" ], "text/plain": [ "Read 12241374 lines. Lines per second: 111652" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 12852366 lines. Lines per second: 111443" ], "text/plain": [ "Read 12852366 lines. Lines per second: 111443" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 13442713 lines. Lines per second: 111099" ], "text/plain": [ "Read 13442713 lines. Lines per second: 111099" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 14030942 lines. Lines per second: 110842" ], "text/plain": [ "Read 14030942 lines. Lines per second: 110842" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 14634795 lines. Lines per second: 110677" ], "text/plain": [ "Read 14634795 lines. Lines per second: 110677" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 15234543 lines. Lines per second: 110483" ], "text/plain": [ "Read 15234543 lines. Lines per second: 110483" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 15822769 lines. Lines per second: 110298" ], "text/plain": [ "Read 15822769 lines. Lines per second: 110298" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 16418992 lines. Lines per second: 110243" ], "text/plain": [ "Read 16418992 lines. Lines per second: 110243" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 16945480 lines. Lines per second: 110102" ], "text/plain": [ "Read 16945480 lines. Lines per second: 110102" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 17537615 lines. Lines per second: 110040" ], "text/plain": [ "Read 17537615 lines. Lines per second: 110040" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 18129754 lines. Lines per second: 109843" ], "text/plain": [ "Read 18129754 lines. Lines per second: 109843" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 18743953 lines. Lines per second: 109789" ], "text/plain": [ "Read 18743953 lines. Lines per second: 109789" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 19260565 lines. Lines per second: 109619" ], "text/plain": [ "Read 19260565 lines. Lines per second: 109619" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 19781895 lines. Lines per second: 109426" ], "text/plain": [ "Read 19781895 lines. Lines per second: 109426" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 20398697 lines. Lines per second: 109443" ], "text/plain": [ "Read 20398697 lines. Lines per second: 109443" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 20999315 lines. Lines per second: 109332" ], "text/plain": [ "Read 20999315 lines. Lines per second: 109332" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 21606085 lines. Lines per second: 109316" ], "text/plain": [ "Read 21606085 lines. Lines per second: 109316" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 22125339 lines. Lines per second: 109170" ], "text/plain": [ "Read 22125339 lines. Lines per second: 109170" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 22716579 lines. Lines per second: 109036" ], "text/plain": [ "Read 22716579 lines. Lines per second: 109036" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 23226544 lines. Lines per second: 108870" ], "text/plain": [ "Read 23226544 lines. Lines per second: 108870" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 23837468 lines. Lines per second: 108834" ], "text/plain": [ "Read 23837468 lines. Lines per second: 108834" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 24430871 lines. Lines per second: 108780" ], "text/plain": [ "Read 24430871 lines. Lines per second: 108780" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 25018270 lines. Lines per second: 108802" ], "text/plain": [ "Read 25018270 lines. Lines per second: 108802" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 25620984 lines. Lines per second: 108784" ], "text/plain": [ "Read 25620984 lines. Lines per second: 108784" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 26220328 lines. Lines per second: 108768" ], "text/plain": [ "Read 26220328 lines. Lines per second: 108768" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 26812801 lines. Lines per second: 108660" ], "text/plain": [ "Read 26812801 lines. Lines per second: 108660" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 27330111 lines. Lines per second: 108603" ], "text/plain": [ "Read 27330111 lines. Lines per second: 108603" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 27946846 lines. Lines per second: 108643" ], "text/plain": [ "Read 27946846 lines. Lines per second: 108643" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 28537022 lines. Lines per second: 108643" ], "text/plain": [ "Read 28537022 lines. Lines per second: 108643" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 48187786 lines. Lines per second: 108075" ], "text/plain": [ "Read 48187786 lines. Lines per second: 108075" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 48777631 lines. Lines per second: 108054" ], "text/plain": [ "Read 48777631 lines. Lines per second: 108054" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 49387231 lines. Lines per second: 108075" ], "text/plain": [ "Read 49387231 lines. Lines per second: 108075" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 49981695 lines. Lines per second: 108058" ], "text/plain": [ "Read 49981695 lines. Lines per second: 108058" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 50569266 lines. Lines per second: 108036" ], "text/plain": [ "Read 50569266 lines. Lines per second: 108036" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 51170286 lines. Lines per second: 108037" ], "text/plain": [ "Read 51170286 lines. Lines per second: 108037" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 51773732 lines. Lines per second: 108010" ], "text/plain": [ "Read 51773732 lines. Lines per second: 108010" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 52366223 lines. Lines per second: 107990" ], "text/plain": [ "Read 52366223 lines. Lines per second: 107990" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 52959875 lines. Lines per second: 107970" ], "text/plain": [ "Read 52959875 lines. Lines per second: 107970" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 53566480 lines. Lines per second: 108004" ], "text/plain": [ "Read 53566480 lines. Lines per second: 108004" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 54156808 lines. Lines per second: 107969" ], "text/plain": [ "Read 54156808 lines. Lines per second: 107969" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 54751484 lines. Lines per second: 107960" ], "text/plain": [ "Read 54751484 lines. Lines per second: 107960" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2015-04.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2015-04.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 55005780 lines in 509.626 secs." ], "text/plain": [ "Parsing completed. Parsed 55005780 lines in 509.626 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Finished parsing file /data/tmp/RC_2016-03.bz2.decompressed" ], "text/plain": [ "Finished parsing file /data/tmp/RC_2016-03.bz2.decompressed" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Parsing completed. Parsed 100 lines in 0.189317 secs." ], "text/plain": [ "Parsing completed. Parsed 100 lines in 0.189317 secs." ] }, "metadata": {}, "output_type": "display_data" }, { "name": "stdout", "output_type": "stream", "text": [ "------------------------------------------------------\n", "Inferred types from first 100 line(s) of file as \n", "column_type_hints=[dict]\n", "If parsing fails due to incorrect types, you can correct\n", "the inferred type list above and pass it to read_csv in\n", "the column_type_hints argument\n", "------------------------------------------------------\n" ] }, { "data": { "text/html": [ "
Read 97333 lines. Lines per second: 168845" ], "text/plain": [ "Read 97333 lines. Lines per second: 168845" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 1080005 lines. Lines per second: 185888" ], "text/plain": [ "Read 1080005 lines. Lines per second: 185888" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 1909710 lines. Lines per second: 172998" ], "text/plain": [ "Read 1909710 lines. Lines per second: 172998" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 2701562 lines. Lines per second: 167108" ], "text/plain": [ "Read 2701562 lines. Lines per second: 167108" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 3467923 lines. Lines per second: 161319" ], "text/plain": [ "Read 3467923 lines. Lines per second: 161319" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 4231987 lines. Lines per second: 157580" ], "text/plain": [ "Read 4231987 lines. Lines per second: 157580" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 5009290 lines. Lines per second: 154457" ], "text/plain": [ "Read 5009290 lines. Lines per second: 154457" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 5769549 lines. Lines per second: 152490" ], "text/plain": [ "Read 5769549 lines. Lines per second: 152490" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 6436298 lines. Lines per second: 150310" ], "text/plain": [ "Read 6436298 lines. Lines per second: 150310" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 7130065 lines. Lines per second: 149038" ], "text/plain": [ "Read 7130065 lines. Lines per second: 149038" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 7796357 lines. Lines per second: 147503" ], "text/plain": [ "Read 7796357 lines. Lines per second: 147503" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 8559683 lines. Lines per second: 146542" ], "text/plain": [ "Read 8559683 lines. Lines per second: 146542" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 9248375 lines. Lines per second: 145701" ], "text/plain": [ "Read 9248375 lines. Lines per second: 145701" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 10032044 lines. Lines per second: 145228" ], "text/plain": [ "Read 10032044 lines. Lines per second: 145228" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 10724434 lines. Lines per second: 144768" ], "text/plain": [ "Read 10724434 lines. Lines per second: 144768" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 11490479 lines. Lines per second: 144395" ], "text/plain": [ "Read 11490479 lines. Lines per second: 144395" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 12255591 lines. Lines per second: 144157" ], "text/plain": [ "Read 12255591 lines. Lines per second: 144157" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 12931788 lines. Lines per second: 143855" ], "text/plain": [ "Read 12931788 lines. Lines per second: 143855" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 13609217 lines. Lines per second: 142995" ], "text/plain": [ "Read 13609217 lines. Lines per second: 142995" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 14358282 lines. Lines per second: 142437" ], "text/plain": [ "Read 14358282 lines. Lines per second: 142437" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 15030833 lines. Lines per second: 142105" ], "text/plain": [ "Read 15030833 lines. Lines per second: 142105" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 15747350 lines. Lines per second: 141460" ], "text/plain": [ "Read 15747350 lines. Lines per second: 141460" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 16513033 lines. Lines per second: 141180" ], "text/plain": [ "Read 16513033 lines. Lines per second: 141180" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 17207458 lines. Lines per second: 141005" ], "text/plain": [ "Read 17207458 lines. Lines per second: 141005" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 17873719 lines. Lines per second: 140663" ], "text/plain": [ "Read 17873719 lines. Lines per second: 140663" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 18637436 lines. Lines per second: 140448" ], "text/plain": [ "Read 18637436 lines. Lines per second: 140448" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 19330691 lines. Lines per second: 140152" ], "text/plain": [ "Read 19330691 lines. Lines per second: 140152" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 20003485 lines. Lines per second: 139969" ], "text/plain": [ "Read 20003485 lines. Lines per second: 139969" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 20672721 lines. Lines per second: 139752" ], "text/plain": [ "Read 20672721 lines. Lines per second: 139752" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 21357763 lines. Lines per second: 139617" ], "text/plain": [ "Read 21357763 lines. Lines per second: 139617" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 22113463 lines. Lines per second: 139393" ], "text/plain": [ "Read 22113463 lines. Lines per second: 139393" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 22782281 lines. Lines per second: 139120" ], "text/plain": [ "Read 22782281 lines. Lines per second: 139120" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 23471168 lines. Lines per second: 139035" ], "text/plain": [ "Read 23471168 lines. Lines per second: 139035" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 24149295 lines. Lines per second: 138944" ], "text/plain": [ "Read 24149295 lines. Lines per second: 138944" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 24829936 lines. Lines per second: 138814" ], "text/plain": [ "Read 24829936 lines. Lines per second: 138814" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 25518255 lines. Lines per second: 138621" ], "text/plain": [ "Read 25518255 lines. Lines per second: 138621" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 26195300 lines. Lines per second: 138538" ], "text/plain": [ "Read 26195300 lines. Lines per second: 138538" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 26981461 lines. Lines per second: 138597" ], "text/plain": [ "Read 26981461 lines. Lines per second: 138597" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 27647834 lines. Lines per second: 138423" ], "text/plain": [ "Read 27647834 lines. Lines per second: 138423" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 28401489 lines. Lines per second: 138375" ], "text/plain": [ "Read 28401489 lines. Lines per second: 138375" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 29085040 lines. Lines per second: 138325" ], "text/plain": [ "Read 29085040 lines. Lines per second: 138325" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 29755782 lines. Lines per second: 138260" ], "text/plain": [ "Read 29755782 lines. Lines per second: 138260" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 30515156 lines. Lines per second: 138098" ], "text/plain": [ "Read 30515156 lines. Lines per second: 138098" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 31211002 lines. Lines per second: 138088" ], "text/plain": [ "Read 31211002 lines. Lines per second: 138088" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 31888427 lines. Lines per second: 137945" ], "text/plain": [ "Read 31888427 lines. Lines per second: 137945" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 32642350 lines. Lines per second: 137896" ], "text/plain": [ "Read 32642350 lines. Lines per second: 137896" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 33323279 lines. Lines per second: 137793" ], "text/plain": [ "Read 33323279 lines. Lines per second: 137793" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 34078348 lines. Lines per second: 137736" ], "text/plain": [ "Read 34078348 lines. Lines per second: 137736" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 34733999 lines. Lines per second: 137665" ], "text/plain": [ "Read 34733999 lines. Lines per second: 137665" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 35516921 lines. Lines per second: 137676" ], "text/plain": [ "Read 35516921 lines. Lines per second: 137676" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 36196952 lines. Lines per second: 137624" ], "text/plain": [ "Read 36196952 lines. Lines per second: 137624" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 36862679 lines. Lines per second: 137525" ], "text/plain": [ "Read 36862679 lines. Lines per second: 137525" ] }, "metadata": {}, "output_type": "display_data" }, { "data": { "text/html": [ "
Read 37552211 lines. Lines per second: 137449" ], "text/plain": [ "Read 37552211 lines. Lines per second: 137449" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import os\n", "import logging\n", "import bz2\n", "from datetime import datetime\n", "import graphlab as gl\n", "import graphlab.aggregate as agg\n", "import fnmatch\n", "\n", "gl.canvas.set_target('ipynb')\n", "gl.set_runtime_config('GRAPHLAB_CACHE_FILE_LOCATIONS', '/data/tmp')\n", "gl.set_runtime_config('GRAPHLAB_DEFAULT_NUM_GRAPH_LAMBDA_WORKERS', 128)\n", "gl.set_runtime_config('GRAPHLAB_DEFAULT_NUM_PYLAMBDA_WORKERS', 128)\n", "\n", "\n", "basedir = \"/data/reddit/raw\" # Replace this with the directory which you downloaded the file into\n", "sframes_dir = \"/data/reddit/sframes/\" # Replace this with the directory you want to save the SFrame to\n", "tmp_dir = \"/data/tmp\" # Replace this with the directory you want to save the SFrame to\n", "\n", "def get_month_from_path(path):\n", " m = os.path.basename(path)\n", " m = m.split(\".\")[0]\n", " return int(m.split(\"-\")[-1])\n", "\n", "def get_year_from_path(path):\n", " y = os.path.basename(path)\n", " y = y.split(\".\")[0]\n", " return int(y.lower().replace(\"rc_\",\"\").split(\"-\")[0])\n", "\n", "def json2sframe(path):\n", " \"\"\"\n", " Creates an SFrame object from the file in the input path\n", " :param path: path to a file that contains a list of JSON objects, each JSON is saved in a separate line.\n", " The file can also be compressed in bz2 format.\n", " :return: SFrame object created from the file in the input path. The SFrame also contains information regarding\n", " each post date & time\n", " :rtype: gl.SFrame\n", " \"\"\"\n", " if not path.endswith(\".bz2\"):\n", " sf = gl.SFrame.read_json(path, orient=\"lines\")\n", " else:\n", " dpath = decompress_bz2(path)\n", " sf = gl.SFrame.read_json(dpath, orient=\"lines\")\n", " #remove the decompressed file\n", " os.remove(dpath)\n", " #add datetime information\n", " sf['month'] = get_month_from_path(path)\n", " sf['year'] = get_year_from_path(path)\n", " sf['datetime']= sf[\"created_utc\"].apply(lambda utc: datetime.fromtimestamp(float(utc)))\n", "\n", " return sf\n", "\n", "def decompress_bz2(inpath, outpath=None):\n", " \"\"\"\n", " Decompress bz2 to the outpath, if the outpath is not provided then decompress the file to the inpath directory\n", " :param inpath: decompress bz2 file to the outpath\n", " :param outpath: output path for the decompress file\n", " :return: the output file path\n", " \"\"\"\n", " if outpath is None:\n", " outpath = tmp_dir + os.path.sep + os.path.basename(inpath) + \".decompressed\"\n", " out_file = file(outpath, 'wb')\n", " logging.info(\"Decompressing file %s to %s\" % (inpath,outpath))\n", " in_file = bz2.BZ2File(inpath, 'rb')\n", " for data in iter(lambda : in_file.read(100 * 1024), b''):\n", " out_file.write(data)\n", " out_file.close()\n", " in_file.close()\n", " return outpath\n", "\n", "def match_files_in_dir(basedir, ext):\n", " \"\"\"\n", " Find all files in the basedir with 'ext' as filename extension\n", " :param basedir: input basedir\n", " :param ext: filename extension\n", " :return: list of file paths with the input extension\n", " \"\"\"\n", " matches = []\n", " for root, dirnames, filenames in os.walk(basedir):\n", " for filename in fnmatch.filter(filenames, ext):\n", " matches.append(os.path.join(root, filename))\n", " return matches\n", "\n", "#Creating all SFrames\n", "for p in match_files_in_dir(basedir, \"*.bz2\"):\n", " logging.info(\"Analyzing of %s \" % p)\n", " outp = sframes_dir + os.path.sep + os.path.basename(p).replace(\".bz2\", \".sframe\")\n", " if os.path.isdir(outp): #if file already exists skip it\n", " logging.info(\"Skipping the analysis of %s file\" % p)\n", " continue\n", " sf = json2sframe(p)\n", " sf.save(outp)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Now let’s join all the SFrame objects into a single object. Please notice that different posts contain different metadata information about each post. Therefore, we will create a single SFrame which contains all the various metadata information." ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [], "source": [ "join_sframe_path = sframes_dir + os.path.sep + \"join_all.sframe\" # Where to save the join large SFrame object\n", "def get_all_cols_names(sframes_dir):\n", " \"\"\"\n", " Return the column names of all SFrames in the input path\n", " :param sframes_dir: directory path which contains SFrames\n", " :return: list of all the column names in all the sframes in the input directory\n", " :rtype: set()\n", " \"\"\"\n", " sframes_paths = [sframes_dir + os.path.sep + s for s in os.listdir(sframes_dir)]\n", " column_names = set()\n", " for p in sframes_paths:\n", " if not p.endswith(\".sframe\"):\n", " continue\n", " print p\n", " sf = gl.load_sframe(p)\n", " column_names |= set(sf.column_names())\n", " return column_names\n", "\n", "def get_sframe_columns_type_dict(sf):\n", " \"\"\"\n", " Returns a dict with the sframe column names as keys and column types as values\n", " :param sf: input SFrame\n", " :return: dict with the sframe column names as keys and column types as values\n", " :rtype dict[str,str]\n", " \"\"\"\n", " n = sf.column_names()\n", " t = sf.column_types()\n", "\n", " return {n[i]: t[i]for i in range(len(n))}\n", "\n", "def update_sframe_columns_types(sf, col_types):\n", " \"\"\"\n", " Updates the input sframe column types according to the input types dict.\n", " :param sf: input SFrame object\n", " :param col_types: dict in which the keys are the column names and the values are the columns types\n", " :return: SFrame object with column types update to the col_types dict. If a column doesn't exist in the SFrame object\n", " then a new column is added with None values\n", " :rtype: gl.SFrame\n", " \"\"\"\n", " sf_cols_dict = get_sframe_columns_type_dict(sf)\n", "\n", " for k,v in col_types.iteritems():\n", " if k not in sf_cols_dict:\n", " sf[k] = None\n", " sf[k] = sf[k].astype(v)\n", " elif v != sf_cols_dict[k]:\n", " sf[k] = sf[k].astype(v)\n", " return sf\n", "\n", "def join_all_sframes(sframes_dir, col_types):\n", " \"\"\"\n", " Joins all SFrames in the input directory where the column types are according to col_types dict\n", " :param sframes_dir:\n", " :param col_types: dict with column names and their corresponding types\n", " :return: merged SFrame of all the SFrames in the input directory\n", " \"rtype: gl.SFrame\n", " \"\"\"\n", " sframes_paths = [sframes_dir + os.path.sep + s for s in os.listdir(sframes_dir) if s.endswith(\".sframe\")]\n", " sframes_paths.sort()\n", " sf = gl.load_sframe(sframes_paths[0])\n", " sf = update_sframe_columns_types(sf, col_types)\n", " for p in sframes_paths[1:]:\n", " if not p.endswith(\".sframe\"):\n", " continue\n", " print \"Joining %s\" % p\n", " sf2 = update_sframe_columns_types(gl.load_sframe(p), col_types)\n", " sf2.__materialize__()\n", " sf = sf.append(sf2)\n", " sf.__materialize__()\n", "\n", " return sf\n", "\n", "\n", "\n", "# use the inferred column type according to last month posts' SFrame. Set all other columns to be \n", "# as type str\n", "#col_names = get_all_cols_names(sframes_dir)\n", "sf = gl.load_sframe(sframes_dir + '/RC_2015-05.sframe')\n", "d = get_sframe_columns_type_dict(sf)\n", "for c in col_names:\n", " if c not in d:\n", " print \"Found new column %s\" %c\n", " d[c] = str\n", "\n", "#Create Single SFrame\n", "sf = join_all_sframes(sframes_dir, d)\n", "sf.save(join_sframe_path)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "At the end of this process, we obtained an SFrame with 2,718,784,464 rows, which is about 444 GB in size. Let's use the show function to get a better understanding of the data.\n" ] }, { "cell_type": "code", "execution_count": 3, "metadata": { "collapsed": false }, "outputs": [], "source": [ "gl.canvas.set_target('ipynb')\n", "sf = gl.load_sframe(join_sframe_path)\n", "#sf.show() # running this can take considerable amount of time" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's clean it by removing columns that aren't useful for creating the subreddit's social network. Namely, we remove the following columns: \"archived,\" \"downs,\" \"retrieved_on,\" \"banned_by,\" \"likes,\" \"user_reports,\" \"saved,\" \"report_reasons,\" \"approved_by,\" \"body_html,\" \"created,\" \"mod_reports,\" and \"num_reports.”\n" ] }, { "cell_type": "code", "execution_count": 4, "metadata": { "collapsed": false }, "outputs": [], "source": [ "sf = sf.remove_columns([\"archived\", \"downs\", \"retrieved_on\", \"banned_by\", \"likes\",\"user_reports\", \"saved\",\n", " \"report_reasons\", \"approved_by\", \"body_html\", \"created\", \"mod_reports\", \"num_reports\"])\n", "sf.__materialize__()" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "Let's also delete users' posts that are from users that are probably bots and from those who have posted too many messages." ] }, { "cell_type": "code", "execution_count": 5, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "+----------------------+-----------+\n", "| author | Count |\n", "+----------------------+-----------+\n", "| [deleted] | 302138049 |\n", "| AutoModerator | 10976942 |\n", "| conspirobot | 575576 |\n", "| ModerationLog | 562192 |\n", "| TweetPoster | 555976 |\n", "| MTGCardFetcher | 444411 |\n", "| RPBot | 436199 |\n", "| autowikibot | 422769 |\n", "| imgurtranscriber | 404441 |\n", "| PoliticBot | 388444 |\n", "| dogetipbot | 374536 |\n", "| ImagesOfNetwork | 355037 |\n", "| throwthrowawaytothee | 344583 |\n", "| Late_Night_Grumbler | 320383 |\n", "| qkme_transcriber | 301974 |\n", "| TweetsInCommentsBot | 282467 |\n", "| TotesMessenger | 222073 |\n", "| Franciscouzo | 202346 |\n", "| havoc_bot | 197761 |\n", "| morbiusgreen | 195312 |\n", "| User_Simulator | 194358 |\n", "| Lots42 | 192985 |\n", "| hit_bot | 182189 |\n", "| -rix | 173022 |\n", "| pixis-4950 | 171907 |\n", "| PornOverlord | 171623 |\n", "| BitcoinAllBot | 170096 |\n", "| UnluckyLuke | 169971 |\n", "| PriceZombie | 163710 |\n", "| amici_ursi | 163288 |\n", "| matts2 | 156381 |\n", "| gifv-bot | 155513 |\n", "| WritingPromptsRobot | 154295 |\n", "| atomicimploder | 148904 |\n", "| autotldr | 146046 |\n", "| TrollaBot | 145737 |\n", "| SnapshillBot | 143317 |\n", "| NoMoreNicksLeft | 135738 |\n", "| MovieGuide | 134567 |\n", "| raddit-bot | 133615 |\n", "| iam4real | 133262 |\n", "| youtubefactsbot | 132521 |\n", "| CaptionBot | 131743 |\n", "| hwsbot | 131402 |\n", "| G_Morgan | 129057 |\n", "| davidjl123 | 128481 |\n", "| noeatnosleep | 125357 |\n", "| samacharbot2 | 125226 |\n", "| backpackwayne | 116002 |\n", "| ttumblrbots | 114590 |\n", "+----------------------+-----------+\n", "[20299812 rows x 2 columns]\n", "\n" ] } ], "source": [ "#First let's find how many posts the most active users posted\n", "posts_count_sf = sf.groupby('author', gl.aggregate.COUNT())\n", "posts_count_sf.sort('Count',ascending=False).print_rows(50)" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "To clean the dataset, we removed redditors who posted over 100,000 times and seemed to post automatic content. Additionally, we used the [praw Python package](https://praw.readthedocs.io/en/latest/) to parse the comments posted in the [BotWatchman subreddit](https://www.reddit.com/r/BotWatchman/) in order to identify bots and remove them. We use the following code to assemble a bots list:" ] }, { "cell_type": "code", "execution_count": 6, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "Delete Users List (951 users):\n", " set(['Removedpixel', 'SoulFire6464', u'RealtechPostBot', u'serendipitybot', u'r2d8', u'arethemodsasleep', u'squis1000', u'The_Penis_Game_Bot', u'whooshbot', u'Zyra_test', u'hitlerbotv2', u'topredditbot', u'VerseBot', u'MusicB0t', u'Explains_FTFY', u'BaddieBot', u'autourbanbot', 'NinjaDiscoJesus', u'thier_2_their_bot', u'amProbablyPooping', u'Insane_Photo_Bot', u'Auto_Neckbeard_Bot', u'shadowbanbot', u'_Rita_', u'Profanity-bot', u'gracefulclaritybot', u'DataFire_bot', 'autowikibot', u'FTFY_Cat', u'yes_answers.', u'DollarSignDouche', u'ELIMINATE_GIFS', u'PlusOneBot', u'CutoutBot', u'visual_clarification', u'triggeredbot', u'haiku_finder_bot', u'Eats_Small_Text_Bot', u'GameDealsBot', u'Craigslist-Bot', u'STEALTHM0UNTAIN', u'LegoLinkBot', 'atomicimploder', u'Dickish_Bot_Bot', 'BitcoinAllBot', u'/u/codes_comments', u'CuteBot6969', u'LittleHelperRobot', u'Anti-Brigade-Bot3', u'autowikiabot', u'Anti-Brigade-Bot8', 'backpackwayne', u'UnobtaniumTipBot', u'YOGSbot', u'Innocence_bot2', u'PreserverBot', u'givesafuckbot', u'youreyoureiswrong', u'gabenizer-bot', u'crushe69', u'Canadian-Sorry-Bot', u'Comrade__Bot', u'GunnitBot', u'checks_for_checks', u'define_bot', u'Hikelsa_bot', u'ThanksObamaBiden', u'rusetipbot', 'pixis-4950', u'autotrope_bot', u'Feathersbumbled', u'NSLbot', u'kittehcointipbot', u'ModisDead', u'ItsSpelledPrincipal', u'demobile_bot', u'acini', u'rawlaying90', u'OneBleachinBot', u'giddyp93', u'NobodyDoesThis', u'image_linker_bot', u'ReddiTron1000', u'WWE_Network_Bot', u'iTunesLinks', u'TheWallGrows', u'PokemonFlairBot', u'StockTrendsBot', u'pikachu_hsu', u'PM_ME_YOUR_COCK_', 'CaptionBot', u'FucksWithTables', u'The_Dad_Bot', u'hearing-aid_bot', u'bee2kg', u'IPostAlotBot', u'stockinfo_bot', u'ASOT_Tracklister_bot', u'resavr_bot', u'chant89', u'StackBot', u'it-is-not-would-of', u'Converts2Useless', u'OnlyRepliesLMAO', u'WillPrismWordsBot', u'magic-8-bot', '-rix', u'DUCCI__BOT', u'Product_Helper_Bot', u'CationBot', u'Readdit_Bot', u'shiftace-', u'Comment_Codebreaker', u'ToBeFairBot', u'thank_mr_skeltal_bot', u'steam_bot', u'RFootballBot', u'ratsb1000', u'RedVanguardBot', u'AVR_Modbot', u'nulli1000', u'DidSomeoneSayBoobs', u'compilebot', u'Brigade_Bot', u'/u/TotesHuman', u'league_match_bot', u'_Sweetiebot', u'much-wow-doge', u'UselessAndBot', u'disapprovalbot', u'ButWhatDoIDoWithIt', u'ASCIICockBot', u'tabledresser', u'cruise_bot', 'G_Morgan', 'autotldr', 'PornOverlord', u'topcoin_tip', u'tagstr1000', u'heads_need_bodies', 'PoliticBot', u'bedoot', u'AAbot', u'gandhiwatchesbot', u'AladeenBot', u'iscuck_bot', u'nice_meme_bot', 'samacharbot2', u'dotaherobot', u'TreeFiddyBot', u'RedditAnalysisBot', u'b6d27f0x3', u'roger_bot', u'BotOfOriginality', u'TheTopCommentBot', u'annoying_yes_bot', u'isDegenerate', u'NightMirrorMoon', u'BOTFORSUBREDDITNAME', u'gandhi_spell_bot', u'Decronym', u'WikiBotEU', u'cartri69', u'ProfanityWatch', u'livid_taco', u'loser_detector_bot', u'IthkuilRobot', u'zalgoskeletor', u'PlayStoreLinks_Bot', u'ShillForMonsanto', u'BrokenArmsBot', u'qznc_bot', 'matts2', u'PonyTipBot', u'Twitch2YouTube', u'GabenCoinTipBot', u'gabentipbot', u'DogeLotteryModBot', u'DrivePower', u'alot-of-bot', u'The-Paranoid-Android', u'YouTube_Time', u'companymi69', u'NotApostolate', u'FFBot', u'wheres_the_karma_bot', u'Wolfram_Bot', u'ImageRehoster', u'highlightsbot', u'codex561', u'garu323', 'raddit-bot', u'YT_Timestamp_Bot', u'WeAppreciateYou', u'hhhehehe_BOT', u'skitchbot', 'Late_Night_Grumbler', u'MumeBot', u'not-cleverbot', u'Gestabot', 'NoMoreNicksLeft', u'TheSpellingAsshole', u'QuoteMe-Bot', u'Dad_Jokes_Inbound', u'lolpenisbot', u'you_thejoke', u'TerperBot', 'GoTradeBot', u'Nepene', u'greeter_bot', u'TitsOrGTFO_Bot', u'saskaai', u'ArmFixerBot', u'I_Love_You_Too_Bot', u'grreviews_bot', 'qkme_transcriber', u'ASOIAFSearchBot', u'Dad_Jokes_Incoming', u'Peteusse', 'SnapshillBot', u'Honey189', u'_AyyLmaoBot_', u'SoThereYouHaveIt', u'ferrarispider52', u'publicmodlogs', u'Joasdisle', u'ItWillGetBetterBot', u'thelinkfixerbot', u'CalvinBot', u'splin69', u'Anti-Brigade-Bot7', u'Rule_13_Bot', u'Shlak2k15', u'Handy_Related_Sub', u'BELITipBot', u'scraptip', u'Antiracism_Bot', u'auto-doge', u'PuushToImgurBot', '[deleted]', u'anusBot', u'Reddit2Trend', u'ToBeFairCounter', u'JotBot', u'WikipediaLinkFixer', u'NFLVideoBot', u'UrbanDicBot', u'maybemaybemaybe_bot', u'fieldpain6969', u'MaveTipBot', u'nsfw_gfys_bot2', u'CortanaBot', u'rumblep666', u'SmallTextReader', u'KSPortBot', u'Define_It', u'_TonyWonder_', u'wrapt6969', u'PnSProtectionService', 'throwthrowawaytothee', u'Control_F', u'XPostLinker', u'phrase_bot', u'TOP_COMMENT_OF_YORE', u'smile_today_', u'bitcointip', u'templatebot', u'Dictionary__Bot', u'Downtotes_Plz', u'Mr_Vladimir_Putin', u'gracefulcharitybot', u'A_random_gif', u'trpbot', u'MetricPleaseBot', u'redditShitBots', u'Anti-Brigade-Bot-35', u'MatchThreadder', u'GrammarianBot', u'SpellingB', u'Mobile_Version', u'Metric_System_Bot', u'FriendlyCamelCaseBot', u'I_Am_Genesis', 'TweetsInCommentsBot', u'AutoNiggaBot', u'DadBot3000', u'VideopokerBot', u'InformativeButFalse', u'mcservers-bot', u'sendto', u'classhole_bot', u'DNotesTip', u'TheAssBot', u'UselessArithmeticBot', u'GoogleTranslateBot', u'MAGNIFIER_BOT', u'DealWithItbot', u'NintendoVideoBot', u'CONFUSED_COPYCAT', u'Sandstorm_Bot', 'ttumblrbots', u'classybot', u'bitofnewsbot', u'MetatasticBot', u'post_only_cocks', u'Deviantart-Mirror', u'ImprovedGrammarBot', u'ShillHill666', u'EscapistVideoBot', u'AntiBrigadeBot', u'IRCR_Info_Bot', u'swiftwee88', u'ICouldntCareLessBot', u'X_BOT', u'clay_davis_bot', u'rumbl1000', u'My_Bot', u'panderingwhore', u'GeekWhackBot', u'TryShouldHaveInstead', u'SauceHunt', u'bust1nbot', u'valkyribot', u'WordCloudBot2', u'OnlyPostsJFC', u'wooshbot', u'infiltration_bot', 'PriceZombie', u'ContentForager', u'SatoshiTipBot', u'BoobBot3000', u'TheButtonStatsBot', u'MonsterMashBot', u'subtext-bot', u'shirley_bot', u'flower_bot', u'BensonTheBot', u'SwearWordPolice', u'Reddit_JS_Bot', u'corgicointip', u'SuchModBot', u'RAOM_Bot', u'haha_bot', u'WeatherReportBot', u'xkcd37bot', u'_chao_', u'NASCARThreadBot', u'/u/TARDIS-BOT', 'AutoModerator', u'ThePoliceBot', u'coinflipbot', u'spinnelein', u'meme_transcriber', 'rollme', u'TablesWillBeFlipped', u'anagrammm', u'rarchives', u'Anti-Brigade-Bot', u'pm_me_your_bw_pics', u'last_cakeday_bot', u'SRS_History_Bot', u'Nazeem_Bot', u'murde1', u'I_Say_No_', u'navigatorbot', u'Anti-Brigade-Bot-1', 'Lots42', u'ThePictureDescribot', u'VeteransResourcesBot', u'fact_check_bot', u'milestone_upvotes', u'goodnotesbot', u'hybrid377', u'BogdanGhita', u'RaceReporter', u'gives_you_boobies', u'Anti-Brigade-Bot-5', u'yes-bot.', u'SubredditMetadataBot', u'AutoInsult', u'mvinfo', u'coinyetipper', u'clothinf89', u'only_posts_chickens', u'Meta_Bot', 'WritingPromptsRobot', u'dgctipbot', u'Correct_Apostrophe_S', u'IAMARacistBot', u'_FallacyBot_', u'decidebot', u'HCE_Replacement_Bot', u'kitabi_vig', u'GrammarCorrectingBot', u'VideoLinkBot', u'scanr', u'GoogleForYouBot', u'Anti-brigade-bot-19', u'Team60sBot', u'Anything_At_All_', u'luckoftheshibe', u'forehead92', u'faketipbot', u'NotRedditEnough', u'FapFindr', u'WatchGroupBot', u'AbixBot', u'AyyLmao2DongerBot', u'thisbotsays', u'PhoenixBot', u'sentimentviewbot', u'AntiHateBrigadingBot', u'edward_r_servo', u'Le_xD_Bot', u'frontbot', u'bRMT_Bot', u'PunknRollBot', u'ConvertsToMetric', u'PCMasterRacebot', u'nba_gif_bot', u'yourebot', u'Could_Care_Corrector', u'GrammerNazi_', u'rubycointipbot', u'/u/hearingaid_bot', u'facts_sphere', 'TweetPoster', u'curly1232', u'AstrosBot', u'chromabot', u'LocationBot', u'webpage_down_bot', u'TheChosenBot', u'c5bot', u'subredditChecker', u'flips_title', u'ObamaRobot', u'ButtTipBot', 'User_Simulator', u'battery_bot', u'/r/bot_police', u'totes_alpha_bot', u'frytipbot', u'provides-id', u'RaGodOfTheSunisaCunt', u'TrendingBot', u'EDC_automod', u'Daily_Fail_Bot', u'lilliecute', u'slapbot', u'BASICALLY_LITERALLY', u'AntiBrigadeBot2', u'tmobaird', u'Link_Demobilizer', u'Spaghetti_Robotti', u'TalkieToasterBot', u'AllahuAkbarBot', u'LinkFixerBot1', u'LinkFixerBot2', u'LinkFixerBot3', 'hit_bot', u'math_or_math_joke', u'nbtip', u'howstat', u'Relevant_News_Bot', u'flip_text_bot', u'PresidentObama___', u'giftoslideshowdotcom', u'DownvotesMcGoats', u'malen-shutup-bot', u'Some_Bot', u'approve_unmoderated', u'leveretb89', u'Gukga-anjeon-bowibu', u'swearjar_bot', u'TheHandOfOmega', u'test_bot0x00', u'URLfixerBot', u'HowIsThisBestOf_Bot', u'RonaldTheRight', u'-faggotbot', u'colorcodebot', 'Franciscouzo', u'Somalia_Bot', 'youtubefactsbot', u'NSA_for_ELS', u'bosk_tino', u'reallygoodbot', u'no_context_bot', u'NoseyPantyBot', u'Shiny-Bot', u'RemindMeBotBro', u'inside_voices', u'penguingun', u'XboxDVRBot', u'GotCrypto', u'CAH_BLACK_BOT', u'ExpectedFactorialBot', u'vertcoinbot', u'NoSobStoryBot2', u'Smile_Bot', u'IFlipCoins', u'memedad-transcriber', u'I_Like_Spaghetti', u'PleaseRespectTables', u'xkcd_transcriber', u'CockBotHDEdition', u'golferbot', u'RemindMeBot', u'tyo-translate', u'GrasiaABot', u'JiffierBot', u'JumpToBot', u'new_eden_news_bot', u'CasualMetricBot', u'Unhandy_Related_Sub', u'tipmoonbot2', u'SwitcharooInventory', u'okc_rating_bot', u'RfreebandzBOT', u'BailyBot', u'MassdropBot', 'RPBot', u'Rad_Rad_Robot', u'pandatips', u'imgur_rehosting', u'YesManBot', u'CantHearYouBotEX', u'UselessConversionBot', u'MY_GLASSES_BITCH', u'Key_Points', u'AwkwardMod', u'JiffyBot', u'FunCatFacts', u'spursgifs_xposterbot', u'SRD_Notifier', 'noeatnosleep', u'isreactionary_bot', u'Sammy-SlimBot', u'PlaylisterBot', u'rotoreuters', u'Celeb_Username_Bot', u'digitipbot', u'reddtipbot', u'ImCongratulating', u'PM_UR_NUDES-PLEASE', u'PlayStoreLinks__Bot', u'HMF_Bot', u'DotaCastingBot', u'thankyoubot', u'A858DE45F56D9BC9', u'quack_bot', u'JennyCherry18', u'ShadowBannedBot', u'Mentioned_Videos', u'fedora_tip_bot', u'Captn_Hook', u'TDTMBot', u'/u/Wraptram', u'haikub0t', u'sunhatd1000', u'NewAustrian', u'Accountabili_bot', u'ExmoBot', u'isReactionaryBot', 'nikorasu_the_great', u'picsonlybot', u'shadowman735', u'jerkbot-3hunna', u'I_Dislike_Spaghetti', u'rss_feed', 'TotesMessenger', u'AutoCorrectionBot', u'LinkDemobilizerBot', u'MemeExDe', u'TicTacToeBot', u'SubredditLinkBot', u'the__meep', u'GoldFact', u'SERIAL_JOKE_KILLER', u'gender_bot', u'peekerbot', u'YTDLBot', u'CamptownRobot', u'_perly_bot', u'tagstra93', u'Barrack_Obama__', u'MuhOutrage_Bot', 'Sir_Willis_CMS', u'cake_day_bot', u'sports_gif_bot', u'StopSayingRIPinPBot', u'nyantip', u'Finnbot', u'Link_Correction_Bot', u'That_Attitude_Bot', u'AwkwardDev', 'dogetipbot', u'YouGotGlitched', u'MarkovBot', u'magic_8_bot', u'haiku_robot', u'AlaTull', u'DeltaBot', u'malo_the_bot', u'DEAL_WITH_IT_bot', 'eaturbrainz', u'Tereshang', u'OfficialCommentRater', u'WontRemindYou', u'BeHappyBot', u'lollygag1000', u'FTFYouBot', u'cahbot', u'CouldBeWorseBot', u'totes_meta_bot', u'autoleprabot', u'AsciBoobsBot', u'freeEBOOKS-Batman', u'WordcloudYou', 'davidjl123', u'English_Helper_Bot', u'I_BITCOIN_CATS', 'morbiusgreen', u'mirror__bot', u'asmccc4123', u'MontrealBot', u'metoobot', u'ac_502002', 'andrewsmith1986', u'citation-is-needed', u'SEO_Killer', u'vertcointipbot', u'VsauceBot', u'Mattyso', u'makeswordcloudsagain', u'The_Marco_Rubio', u'SWTOR_Helper_Bot', u'Virnibot', u'pi_day_bot', u'classhole_robot', u'Shrugfacebot', u'elMatadero_bot', u'Random-ComplimentBOT', u'GoneWildResearcher', u'AndMarquez', u'matthewrobo', u'EveryThingIsSoRaven', u'GreasyBacon', u'bajneeds', u'CantHearYouBot', u'stockbot2000', u'gfycat-bot-sucksdick', u'neutlime', u'let_me_nig_that_4_u', u'Polite_Users_Bot', u'captainhindsightbot', u'AgentKoenigLMD', u'Text_Reader_Bot', u'FedoraTipAutoBot', u'/u/BadSarcasmDetector', u'lmaoRobot', u'ban_pruner', u'elwh392', u'GandhiSpellingBot', u'TwitchToYoutubeBot', u'icehock6969', u'ddlbot', u'relevantxkcd-bot', u'RequirementsBot', u'h0b0_monkey', u'ImJimmieJohnsonBot', u'nrl_cfb', u'PaidBot', u'bitcoinpartybot', u'moderator-bot', u'baseball_gif_bot', u'DropBox_Bot', u'DownvotedComments', u'slickwom-bot', u'kuilinbot', u'Gatherer_bot', u'VideoPostBot', u'WPBot', u'DirectImageLinkerBot', u'user/no_context_bot.', u'jaysbot2', u'ShittyGandhiQuotes', u'stairs1000', u'Wiki_FirstPara_bot', u'Fixes_GrammerNazi_', u'HauntedHashbrown', u'FrownUpsideDownBot', u'Anti-Brigade-Bot-11', u'Anti-Brigade-Bot-12', u'kg2bee', u'RoundUp_bot', u'cmhocbot', u'imirror_bot', u'BHObamanator', u'JokingLikeaBot', u'InternetLyingPolice', u'Raptor_Reading', u'JeopardyQBot', u'PedanticIrishBot', u'domoarigatobtfcboto', u'BritishHaikuBot', u'SurviAvi', u'WikipediaPoster', 'ModerationLog', u'pandatipbot', u'foreigneducationbot', u'non_dm_mirror_bot', u'fedoratips', u'Anti-Reactionary-Bot', u'TheLazyLinker', u'CouldCareFewer', u'InceptionBwongBot', u'/u/trollmaster-5000', u'maaz7', u'allinonebot', u'LineBreakBot', u'WhoopThereItWas', u'u/alot-of-bot', u'AlbumHelperBot', u'NoSleepAutoMod', u'Your_Post_As_A_Movie', u'rSGSpolice', u'TipMoonBot', u'GivesSilverBot300', 'MovieGuide', 'TrollaBot', u'JakeandAmirBot', u'BlackjackBot', u'CHART_BOT', u'bandage1000', u'KarmaConspiracy_Bot', u'BigLebowskiBot', u'grumblehi88', u'BuildAPC4MeBot', u'BotAntagonist', u'clevercommen', u'unitconvert', u'dragoneno6969', u'CreepierSmileBot', u'CIRCLJERK_REPOST_BOT', u'Grumbler_bot', u'DetailsMaster', u'cageypro666', u'SakuraiBot', u'openseadragonizer', u'ImproperGrammarBot', 'imgurtranscriber', 'MasterT231', u'obamabot9000', u'zunjae', u'PoliteUsersBotBot', u'translatesit43times', u'Insigible_Bot', u'VoterBot', u'sara_son19', u'CarterDugSubLinkBot', u'Nidalee_Bot', u'ProductHelperBot', u'CantHearYouBot2', u'moanrigid90', u'changetip', u'redditbots', u'ApiContraption', 'smacksaw', u'RedditMarkovBot', u'edhrec', u'Ladonnalder', u'RepeatBOT', u'dirtymindrebel', u'YT_Bot', u'xkcd_number_bot', u'hitlerbot', u'Rangers_Bot', u'SexSellsStats', u'Forgotten_News_Bot', u'HFY_Tag_Bot', u'ARandomTipAppears', u'LinkedCommentBot', u'LEGO_not_LEGOS_', u'PopcornBot', u'FelineFacts', u'request_bot', u'ReadSmallTextBot', u'MirrorNinjaBot', u'CAH_TEST_BOT', u'delaybot', u'-ecksdee-', u'timewaitsforsome', u'grumpybot', 'MTGCardFetcher', u'BreakfastCerealBot', u'DailMail_Bot', u'tara1', u'SMCTipBot', u'gocougs_bot', u'ThenThanMistakeNoted', u'keysteal_bot', u'DJ_Khaled_Best', u'anon_bot', 'UnluckyLuke', u'beecointipbot', u'QuoteMeBot', u'videos_mod', u'Tumblr_In_Starbucks', u'ExplainsRemovals', u'ComplimentingBot', u'Videos_Mentioned', u'User_History_Bot', u'__bot__', u'Anti_Vladimir_Putin', u'connipti92', u'amazedbot', u'replieswithsmokeweed', u'CreepySmileBotFanBot', u'rule_bot', u'sunhatda666', u'StarboundBot', u'saysjokes', u'IQuoteYouBot', u'colombia_bot', u'zigzagh90', u'IAgreeBot', u'Codebreakerbreaker', u'auto_help_bot', u'PrettyMuchPrettyMuch', u'ADHDbot', u'so_doge_tip', u'ConvertsToText', u'PoliteBot', u'bocketybot', u'maddie_bot', 'ImagesOfNetwork', u'stats-bot', u'imgurerbot', u'potdealer', 'gifv-bot', u'f1bet', u'stormske91', u'notoverticalvideo', u'imgurHostBot', u'amumu_bot', u'Meta_Bot2', u'flappytip', u'Anti-Brigade-Bot-2', u'Anti-Brigade-Bot-3', u'ToMetric', u'Anti-Brigade-Bot-6', u'asmrspambot', u'recursion_bot', u'thewutbot', u'QUICHE-BOT', u'grammar_nazi_bot_13', u'GimliBot', u'AtheismModBot', u'Lionelttson', u'unsta666', u'friendlygame', u'testbotjen', u'sumthenews', u'calcolatore', u'CussWordPolice', u'FixYourGrammarBot', u'Reads_Small_Text_Bot', u'DRKTipBot', u'chawalbanda33', u'ProselytizerBot', u'MultiFunctionBot', u'historymodbot', u'Makes_Small_Text_Bot', u'untouchedURL', 'iam4real', u'LazyLinkerBot', u'tennis_gif_bot', u'Cakeday-Bot', u'IsItDownBot', u'NoGrasiaABot', u'WhenisHL3', u'Gynocologist_Bot', 'havoc_bot', u'archlinkbot', u'rbutrBot', u'DirectImageLinkBot', u'Birthdaytits', u'fa_mirror', u'New_Small_Text_Bot', u'Top_Comment_Repo_Man', 'conspirobot', u'cris9696', u'siteswap-bot', u'SketchNotSkit', u'Anti-Brigade-Bot1917', u'OriginalLinkBot', u'TitleLinkerBot', u'BensonTheSecond', u'godwin_finder', u'SmallSubBot', u'whispen', u'Shrug_Bot', u'raiseyourdongersbot', u'hearing_aids_bot', u'upmo', u'IS_IT_SOLVED', u'AltCodeBot', u'Wink-Bot', u'random-imgur', 'hwsbot', u'snapshot_bot', u'replies_randomly', 'TheNitromeFan', u'khalifa111', u'GoodGuyGold', u'FrontpageWatch', u'RelevantSummary', u'redditreviewbot', u'liver1000', u'Shakespeares_Ghost', u'gfy_bot', u'FirstThingsFirst_bot', u'Stop_Insulting_Mommy', u'a_lot_vs_alot_bot', 'amici_ursi', u'L-O-S-E_not_LOOSE', u'ComradeBot_', u'myrtipbot', u'expired_link_bot', u'Translates10Times', u'BeetusBot', u'ExplanationBot', u'HelperBot_', u'comment_copier_bot', u'Shinybot', u'Bronze-Bot', u'poonta93', u'Brybot', u'SmartphonePitchforks', u'ThatsWhatSheSaidAI', u'adverb_bot', u'RelatedBot', u'youtube_unblock_bot', u'CreepySmileBot', u'rightsbot', u'fsctipbot', u'ParenthesisBot', u'IM_DEFINITELY_A_BOT', u'Clickbait_ReplierBot'])\n" ] } ], "source": [ "import praw\n", "\n", "\n", "def get_bots_set():\n", " #Please insert your Reddit application's authentication information.\n", " #See more details at: https://github.com/reddit/reddit/wiki/OAuth2-Quick-Start-Example#first-steps\n", " secret ='
author | \n", "subreddit | \n", "start_date | \n", "end_date | \n", "posts_num | \n", "activity_time | \n", "
---|---|---|---|---|---|
d4mini0n | \n", "ainbow | \n", "1334038071 | \n", "1427931191 | \n", "9 | \n", "93893120 | \n", "
polinreddit | \n", "news | \n", "1325830586 | \n", "1325830586 | \n", "1 | \n", "0 | \n", "
goliveyourdreams | \n", "relationships | \n", "1337470570 | \n", "1451506045 | \n", "27 | \n", "114035475 | \n", "
ssa111 | \n", "spreading | \n", "1448388980 | \n", "1451500948 | \n", "2 | \n", "3111968 | \n", "
SugarBeets | \n", "malelivingspace | \n", "1356540644 | \n", "1474085882 | \n", "20 | \n", "117545238 | \n", "
Wejurt | \n", "canucks | \n", "1429683528 | \n", "1430083478 | \n", "8 | \n", "399950 | \n", "
themonthofmae | \n", "relationships | \n", "1468165432 | \n", "1468165480 | \n", "2 | \n", "48 | \n", "
Puckhead7 | \n", "ColoradoAvalanche | \n", "1419580278 | \n", "1476590616 | \n", "43 | \n", "57010338 | \n", "
throwitawaytrustme | \n", "relationships | \n", "1448225775 | \n", "1448225775 | \n", "1 | \n", "0 | \n", "
spinstartshere | \n", "Lenovo | \n", "1455307194 | \n", "1456503969 | \n", "3 | \n", "1196775 | \n", "
datetime | \n", "author | \n", "author_flair_css_class | \n", "author_flair_text | \n", "body | \n", "
---|---|---|---|---|
2006-10-18 16:36:27 | \n", "conrad_hex | \n", "null | \n", "null | \n", "It sort of sounds like the caffeinated-baby ... | \n",
"
2006-10-18 16:56:54 | \n", "the_seanald | \n", "null | \n", "null | \n", "The 10 year old inside me chuckled at \"pinches off ... | \n",
"
2006-10-18 17:07:48 | \n", "Mr_Smartypants | \n", "null | \n", "null | \n", "One would think a journalist (or even a ... | \n",
"
2006-10-18 17:10:15 | \n", "tcervl | \n", "null | \n", "null | \n", "almost useful!\\r\\n\\r\\nFor me, in computer science, ... | \n",
"
2006-10-18 17:18:07 | \n", "Lagged2Death | \n", "null | \n", "null | \n", "An entertaining rant. Definitely worth a ... | \n",
"
2006-10-18 18:37:48 | \n", "anonymgrl | \n", "null | \n", "null | \n", ":) | \n", "
2006-10-18 19:13:51 | \n", "Saintstace | \n", "null | \n", "null | \n", "No, but you just gave me the idea to do so. ... | \n",
"
2006-10-18 19:30:02 | \n", "_jjsonp | \n", "null | \n", "null | \n", "that is fascinating. i wonder how long before ... | \n",
"
2006-10-18 20:46:34 | \n", "dsandler | \n", "null | \n", "null | \n", "Or, at least, bolder, which is a trait that ... | \n",
"
2006-10-18 21:09:39 | \n", "NitsujTPU | \n", "compsci | \n", "PhD | Computer Science | \n", "Mind Hacks is awesome. The book is totally w ... | \n",
"
controversiality | \n", "created_utc | \n", "distinguished | \n", "edited | \n", "gilded | \n", "id | \n", "link_id | \n", "parent_id | \n", "retrieved_on | \n", "score | \n", "
---|---|---|---|---|---|---|---|---|---|
0 | \n", "1161189387 | \n", "null | \n", "false | \n", "0 | \n", "cmqc1 | \n", "t3_mpuf | \n", "t3_mpuf | \n", "1473802574 | \n", "2 | \n", "
0 | \n", "1161190614 | \n", "null | \n", "false | \n", "0 | \n", "cmqf7 | \n", "t3_mp5w | \n", "t3_mp5w | \n", "1473802577 | \n", "7 | \n", "
0 | \n", "1161191268 | \n", "null | \n", "false | \n", "0 | \n", "cmqha | \n", "t3_mpuf | \n", "t3_mpuf | \n", "1473802577 | \n", "2 | \n", "
0 | \n", "1161191415 | \n", "null | \n", "false | \n", "0 | \n", "cmqhk | \n", "t3_mppf | \n", "t3_mppf | \n", "1473802577 | \n", "3 | \n", "
0 | \n", "1161191887 | \n", "null | \n", "false | \n", "0 | \n", "cmqiv | \n", "t3_mpjm | \n", "t3_mpjm | \n", "1473802578 | \n", "4 | \n", "
1 | \n", "1161196668 | \n", "null | \n", "false | \n", "0 | \n", "cmqyw | \n", "t3_mp5w | \n", "t1_cmqf7 | \n", "1473802587 | \n", "2 | \n", "
0 | \n", "1161198831 | \n", "null | \n", "false | \n", "0 | \n", "cmr6f | \n", "t3_mr3t | \n", "t3_mr3t | \n", "1473802591 | \n", "3 | \n", "
0 | \n", "1161199802 | \n", "null | \n", "false | \n", "0 | \n", "cmrbo | \n", "t3_mp5w | \n", "t3_mp5w | \n", "1473802593 | \n", "4 | \n", "
0 | \n", "1161204394 | \n", "null | \n", "false | \n", "0 | \n", "cmrsx | \n", "t3_mpuf | \n", "t1_cmqc1 | \n", "1473802603 | \n", "1 | \n", "
0 | \n", "1161205779 | \n", "null | \n", "false | \n", "0 | \n", "cmrxx | \n", "t3_mqcp | \n", "t3_mqcp | \n", "1473802605 | \n", "0 | \n", "
stickied | \n", "subreddit | \n", "subreddit_id | \n", "ups | \n", "month | \n", "year | \n", "banned_by | \n", "replies | \n", "removal_reason | \n", "likes | \n", "user_reports | \n", "
---|---|---|---|---|---|---|---|---|---|---|
false | \n", "science | \n", "t5_mouw | \n", "2 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "7 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "2 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "3 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "4 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "2 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "3 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "4 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "1 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
false | \n", "science | \n", "t5_mouw | \n", "0 | \n", "10 | \n", "2006 | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
saved | \n", "archived | \n", "report_reasons | \n", "approved_by | \n", "downs | \n", "body_html | \n", "score_hidden | \n", "name | \n", "created | \n", "mod_reports | \n", "
---|---|---|---|---|---|---|---|---|---|
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "None | \n", "
num_reports | \n", "
---|
None | \n", "
None | \n", "
None | \n", "
None | \n", "
None | \n", "
None | \n", "
None | \n", "
None | \n", "
None | \n", "
None | \n", "