How to check if a csv file is empty in pandas?

0 votes
Jun 30, 2019 in Python by anonymous
3,162 views

2 answers to this question.

0 votes

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')
answered Jul 1, 2019 by Esha
0 votes

Try this:

df = pd.DataFrame(columns=['Name', 'ID', 'Department'])
if df.empty == True:
print('DataFrame is empty')
else:
print('DataFrame is not empty')
answered Jul 1, 2019 by Bob

Related Questions In Python

+1 vote
1 answer

How to check if a string is in a file, using python?

Hi, Try the below given code: with open('myfile.txt') as ...READ MORE

answered Jul 4, 2019 in Python by Shabnam
• 920 points
175 views
0 votes
1 answer

How to check if any value is NaN in a Pandas DataFrame?

Hello @kartik, If you need to know how ...READ MORE

answered Jun 15 in Python by Niroj
• 32,990 points
70 views
+1 vote
1 answer

How to check if a string is null in python

Try this: if cookie and not cookie.isspace(): # the ...READ MORE

answered Aug 20, 2018 in Python by Priyaj
• 57,530 points
12,369 views
0 votes
1 answer

How do I check if a list is empty in python?

Hey @Vedant, that's pretty simple and straightforward: if ...READ MORE

answered May 27, 2019 in Python by Karthik
163 views
0 votes
1 answer

How to check whether a pandas DataFrame is empty?

Hello @kartik, I use the len function. It's much faster ...READ MORE

answered Apr 23 in Python by Niroj
• 32,990 points
106 views
0 votes
1 answer

How to check if an element is present in a Django queryset?

Hello @kartik, You can use the following code: if ...READ MORE

answered May 27 in Python by Niroj
• 32,990 points
79 views
0 votes
1 answer

How to check if a value exists in pandas dataframe index?

Hello @kartik, Basically instead of raising exception I ...READ MORE

answered Jun 15 in Python by Niroj
• 32,990 points
104 views
0 votes
1 answer

How do I use urllib to see if a website is 404 or 200 in Python?

For Python 3, try doing this: import urllib.request, ...READ MORE

answered Nov 29, 2018 in Python by Nymeria
• 3,540 points

edited Dec 11, 2018 by Nymeria 4,528 views
0 votes
1 answer

How to check if a list is empty in python?

To check if a list is empty ...READ MORE

answered May 27, 2019 in Python by Nisa
• 1,090 points
117 views
0 votes
1 answer

How to check if a substring is present in a string using Python?

To check if the substring exists in ...READ MORE

answered May 9, 2019 in Python by Sharan
179 views