0

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)>
DonPre
  • 158
  • 7
Gerry
  • 33
  • 5
  • Maybe this can help you [link](https://stackoverflow.com/questions/27835619/urllib-and-ssl-certificate-verify-failed-error) – DonPre Oct 20 '22 at 14:46

0 Answers0