Great gist! This is really helpful to ppl who finished Wes' great book and want to catch up the further improvement on pandas. I cannot believe I am the first one to leave a message here.
However, I did come asking for help. I'm not sure how whether the post request still works. The 3rd cell gave me a trace back.
Actually it would be helpful if you can show how should I download the zip file manually.
Thank you again for the great post explaining the recent development.
EDIT: I think I understand the problem now. It is indeed a python 2/3 problem, I think Py2 didn't wait until the request was complete for some reason. I separated the 3rd cell and got it to run smoothly.
I might be wrong, but in the second cell
with open("flights.csv", 'wb') as f:
should be replaced with
with open("flights.csv.zip", 'wb') as f:
since that's what you are then unzipping in the following cell.
P.S. Great post series, and I can't wait to see the second edition of Wes's book!
Hi @sbraden , You can open this link https://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=236&DB_Short_Name=On-Time in your browser, choose year to 2014, tick the items in the following list, and then click the 'Download' button on the right. You will get a zip file that should satisfy you.