Web scrape in Python

I need to go to a website and input a zip code and press a button to submit it. Then the website will shows a new page where I can click an icon to download the generated excel file. I wonder how I accomplish this task in python. I am new to Web programming but know a little bit about python. I tried python requests but failed. Thanks.