Python Script to Download Springer Textbooks

download_textbooks.py

import requests, wget
import pandas as pd
df = pd.read_excel("Free+English+textbooks.xlsx")
for index, row in df.iterrows():
        # loop through the excel list
        file_name = f"{row.loc['Book Title']}_{row.loc['Edition']}".replace('/','-').replace(':','-')
        url = f"{row.loc['OpenURL']}"
        r = requests.get(url) 
        download_url = f"{r.url.replace('book','content/pdf')}.pdf"
        wget.download(download_url, f"./download/{file_name}.pdf") 
        print(f"downloading {file_name}.pdf Complete ....")

This is a great project.
But after running it, I get this error:

Here is the code setup in my Sublime Text 3 editor:

I have initially installed all necessary packages using pip install ... command. Please, what could be wrong?

UPDATE
I found out that there is a /break character in the some cells in the Edition column of Free+English+textbooks.xlsx.

The error now is that its downloading all files in <100kb PDFs (which is unusual).

Please, what could be wrong this time?

Please, what could be wrong this time?

reCapthca unfortunately :(