Add row to dataframe syntax issue

Question

I am trying to add a new row to the dataframe df based on this post but I'm getting the syntax wrong. What am I missing?

df = pd.DataFrame(columns=['poll1', 'poll2','tval','pval'])
temp = pd.DataFrame([0,0,1,2], columns=['poll1', 'poll2','tval','pval'])
df.append(temp)
print(df)

Please [edit] your question to include the error message. – Kevin J. Chase Mar 10 '18 at 22:39 — Kevin J. Chase, Mar 10 '18 at 22:39

score 0 · Accepted Answer · answered Mar 10 '18 at 21:30

df = pd.DataFrame(columns=['poll1', 'poll2','tval','pval'], data=[[0,0,1,2]])
print(df)

or if you want to use append:

cols = ['poll1', 'poll2','tval','pval']
df = pd.DataFrame(columns=cols)
temp = pd.DataFrame(data=[[0,0,1,2]], columns = cols)
df = df.append(temp)
print(df)

Add row to dataframe syntax issue

1 Answers1