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
– Kevin J. Chase

2018-03-10 22:39:47 +00:00
Commented Mar 10, 2018 at 22:39 — Kevin J. Chase
– Kevin J. Chase, Commented Mar 10, 2018 at 22:39

trouselife · Accepted Answer · 2018-03-10 21:30:45Z

0

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)

answered Mar 10, 2018 at 21:30

trouselife

96718 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Add row to dataframe syntax issue

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related