Question

How to check if a csv file is empty in pandas

Answer 1

Try this code:

import pandas as pd

df = pd.read_csv(filename)
if(df.empty):
    print ('CSV file is empty')
else:
    print ('CSV file is not empty')

Answer 2

Try this:

df = pd.DataFrame(columns=['Name', 'ID', 'Department'])
if df.empty == True:
print('DataFrame is empty')
else:
print('DataFrame is not empty')