pedro_galher
pedro_galher

Reputation: 384

Check if Excel is empty

I have a bunch of excel files automatically generated by a process. However, some of them are empty because the process stopped before actually writing anything. These excels do not even contain any columns, so they are just an empty sheet.

I'm now runnin some scripts on each of the excels, so I would like to check if the excel is empty, and if so, skip it.

I have tried:

pandas.DataFrame.empty

But I still get the message: EmptyDataError: No columns to parse from file

How can I perform this check?

Upvotes: 1

Views: 328

Answers (1)

mozway
mozway

Reputation: 260335

Why not using a try/except:

try:
    # try reading the excel file
    df = pd.read_excel(…) # or pd.read_csv(…)
except pd.errors.EmptyDataError:
    # do something else if this fails
    df = pd.DataFrame()

Upvotes: 1

Related Questions