How can we load a pandas dataframe using an empty csv file and how can we check that the csv file choosen by us for loading the dataframe is empty?

Question

I am working on a project in which I want to load a dataframe using the csv file and check if the file from which I want to load the dataframe is empty or not. If the csv file is empty then as soon as the statement df=pd.read_csv(file.csv) is encountered , I get the error pandas.errors.EmptyDataError: No columns to parse from file Please help me

#custom error class defined correctly
try:
    #file.csv is an empty csv file
   df=pd.read_csv(file.csv)
   if df:
        print("Dataframe loaded successfully!!")
   else:
        raise Empty_csv_file_Error("The csv file is empty!!")
except Empty_csv_file_Error as e:
    print(e.msg)

Error encountered while loading the dataframe using empty csv file :- pandas.errors.EmptyDataError: No columns to parse from file

Craig · Accepted Answer · 2021-12-09 20:17:38Z

2

The pandas error is telling you that the file is empty, so just catch it:

import pandas as pd

try:
    #file.csv is an empty csv file
   df=pd.read_csv("file.csv")
except pd.errors.EmptyDataError:
    print("The CSV file is empty")
else:
    print("Dataframe loaded successfully!!")

edited Dec 9, 2021 at 20:17

answered Jul 22, 2019 at 2:21

Craig

4,8751 gold badge20 silver badges28 bronze badges

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

Collectives™ on Stack Overflow

How can we load a pandas dataframe using an empty csv file and how can we check that the csv file choosen by us for loading the dataframe is empty?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related