check for empty dataframe code example

Example 1: empty dataframe

newDF = pd.DataFrame() #creates a new dataframe that's empty
newDF = newDF.append(oldDF, ignore_index = True) # ignoring index is optional
# try printing some data from newDF
print newDF.head() #again optional

Example 2: check empty dataframe

df.empty == True

Example 3: dataframe pandas empty

>>> df_empty = pd.DataFrame({'A' : []})
>>> df_empty
Empty DataFrame
Columns: [A]
Index: []
>>> df_empty.empty
True

Example 4: check for an empty dataframe

# Check for an empty dataframe using pandas:
data = {'num': [1,'Nan',3,4,'NaN']}
df = pd.DataFrame(data)

'''
True: the DataFrame is empty
False: the DataFrame contains values
'''

df.empty