Surprise! We've been running on hardware provided by BuyVM for a few months and wanted to show them a little appreciation.
Running a paste site comes with unique challenges, ones that aren't always obvious and hard to control. As such, BuyVM offered us a home where we could worry less about the hosting side of things and focus on maintaining a clean and useful service! Go check them out and show them some love!
Description: local subreddit checker
Submitted on May 11, 2015 at 04:48 AM

Section 1 (Python)

import praw
import csv

pathToTSV = "/path/to/NA Subreddit List - Cities.tsv"
with open(pathToTSV) as tsv:
    reader = csv.reader(tsv, dialect="excel-tab")
    rows = list(reader)

entries = {}
for row in rows[1:]:
    entry   = {}
    entry['Country']        = row[0]
    entry['State/Province'] = row[1]
    entry['City']           = row[2]
    entry['Subreddit']      = row[3]
    entry['URL']            = row[4]
    entry['Subscribers']    = row[5]
    entry['Population']     = row[6]
    entry['Activity']       = row[7]
    entry['Full Address']   = row[8]
    entries[row[3]] = entry

r = praw.Reddit(user_agent='name-of-your-bot')

for subreddit in [k[3:] for k in entries.keys()]:
    sub = r.get_subreddit(subreddit)
    subscribers = sub.subscribers