I am trying to download data that is loaded as an excel file on the following page under a tab "download data": https://www.atlantafed.org/chcs/wage-growth-tracker?panel=1
When I "inspect" the link I see the following: https://www.atlantafed.org/-/media/documents/datafiles/chcs/wage-growth-tracker/wage-growth-data.xlsx
My question is, how can I use Python to automatically download the file, instead of having to manually open the excel file, save it, and then open it?
I have tried:
pd.read_excel(url)
but I get the following error:
URLError: <urlopen error [SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: certificate has expired (_ssl.c:1129)>