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