Append only last row in a panda dataframe to a new dataframe

Question

I have the following panda dataframe:(df)

How can I append only the last row (Date 2021-01-22) to a new dataframe (df_new)?

check `append` https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.append.html — Epsi95, Jan 23 '21 at 16:36

r.burak · Accepted Answer · 2021-01-23T17:19:31.497

1

df_new = df_new.append(df.tail(1))

if df_new is not defined. The following code will do it.

df_new = df.tail(1)

edited Jan 23 '21 at 17:19

answered Jan 23 '21 at 16:58

r.burak

I am get the following NameError: name 'df_new' is not defined. How do I define df_new? df_new = pd.DataFrame(last_row) , rigth? – Yvar Jan 23 '21 at 17:13
df_new = df.tail(1) will do the trick. – r.burak Jan 23 '21 at 17:18

1 Answers1