How to handle except errors to be saved to a list

Question

I have a routine where I have to read from a Excel which has a column with links to get individual .xlsx/.xls files that people upload into the form containing some information.

My problem is, people do not always upload the correct file format. So I had to create exceptions to handle that. I save the links that have a exception in a list, but I don't know which exception blocked it. Here's my code:

erros = []
for i in links:
    try:
        name = i[50:]
        df = pd.read_excel(i, header = 1, usecols = col_names, encoding = 'utf-8') #usecols = names)
        file_name = r"%s\%s" %(pasta_sol,name)

        writer = pd.ExcelWriter(file_name , engine='xlsxwriter')
        df.to_excel(writer, header = True, index = True)
        writer.close()

    except (TypeError, IndexError, ValueError, XLRDError, BadZipFile, urllib.error.URLError) as e:
        erros.append(i)

There is a way to append to each file that has a exception which one was it? It could be a list or a new df that looks like it:

erros = [['http://abs.company.pdf', 'TypeError'],['http://abs.company.xls','XLRDError']]

or df.

*There are thousands of files to read per day.

Thanks

Does this answer your question? [How to get name of exception that was caught in Python?](https://stackoverflow.com/questions/18176602/how-to-get-name-of-exception-that-was-caught-in-python) — joel, May 14 '20 at 20:37
@KarlKnechtel you mean, create one except for each error and the append? I didn't try Tapiwa answer below yet, but wouldn't it be the same? — Gustavo Rottgering, May 14 '20 at 21:07
@mkrieger1 because I need the name of the file, so we can communicate the user the resend it. — Gustavo Rottgering, May 14 '20 at 21:08
@mkrieger1 As simple as that will solved my problem. I'm still learning a lot and thanks to this community I can keep growing. I know it can improved but for now I get what I want. Thanks! — Gustavo Rottgering, May 14 '20 at 21:17

score 0 · Answer 1 · answered May 14 '20 at 21:02

This is isnt exactly what you wanted but its close enough. Hope it helps

  errors = []
    for i in links:
        try:
            name = i[50:]
            df = pd.read_excel(i, header = 1, usecols = col_names, encoding = 'utf-8') #usecols = names)
            file_name = r"%s\%s" %(pasta_sol,name)

        writer = pd.ExcelWriter(file_name , engine='xlsxwriter')
        df.to_excel(writer, header = True, index = True)
        writer.close()

    except (TypeError, IndexError, ValueError, XLRDError, BadZipFile, urllib.error.URLError) as e:
        errors.append([file_name, e.args[0]])

print(errors) # doesnt print the error name but the description of the error e.g "division by zero"

How to handle except errors to be saved to a list

1 Answers1