python pandas 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: create empty pandas dataframe

df = pd.DataFrame(columns=['a', 'b', 'c'])

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