Check if csv file is empty in pandas

Question

I have-

data=pd.read_csv('data.csv')
if data.empty==False:
    do something

In my code the dataframe data generated sometimes is empty depending on some conditions. Now when the csv file is empty its throwing error-

EmptyDataError: No columns to parse from file

what should I do to avoid this error?

Alderven · Accepted Answer · 2020-02-07 13:07:27Z

5

You can use try-except construction:

import pandas as pd

try:
    data = pd.read_csv('data.csv')
except pd.errors.EmptyDataError:
    print('Empty csv file!')

answered Feb 7, 2020 at 12:59

Alderven

8,2885 gold badges28 silver badges42 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1