#!/usr/bin/python import requests with open('nytimes_in.csv', 'w') as f: for file in range(1, 31): url = "http://stat.columbia.edu/~rachel/datasets/nyt{0}.csv".format(file) print "Retrieving:", url response = requests.get(url) if response.ok: lines = response.text.splitlines(True) for i, line in enumerate(lines): # Only copy the header once if file == 1 or i > 0: f.write(line)