The wunderground API is pretty great for that. You just need to register for a key. Here is an ipython notebook to get you started: https://github.com/joshmalina/pollution/blob/master/Build_historical_weather_data.ipynbhttps://github.com/joshmalina/pollution/blob/master/notebooks/Build_historical_weather_data.ipynb