Answers for "Empty DataFrame in pandas"

pandas create empty dataframe

# Basic syntax:
import pandas as pd
empty_dataframe = pd.DataFrame()

# Create empty dataframe with column names
empty_dataframe = pd.DataFrame(columns=['your', 'column', 'names'])

# Create empty dataframe with row names
empty_dataframe = pd.DataFrame(index=['your', 'row', 'names'])

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

how to check for empty dataframe

df_empty = pd.DataFrame({'A' : []})
df_empty.empty # True

dataframe pandas empty

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

python empty dataframe

# Create Empty DataFrame with column names
df = pd.DataFrame(columns=['species','name','age'])
df.loc[1] = ['dog','Fido','3']  # Populate Row at index 1 (row 1)
df.loc[2] = ['cat','Felix','2'] # Populate Row at index 2 (row 2)
print(df) 
# Output:
#   species   name age
# 1     dog   Fido   3
# 2     cat  Felix   2