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