Create a dataframe from some rows of another dataframe

Question

Here is the DataFrame I am working with, for reference.

data2 = {'col10':[1.0, 2.0, 3.0, 4.0], 'col11':[100, 200, 300, 400]}
df = pd.DataFrame(data2, index = ['a', 'b', 'c', 'd'])

I'm trying to create a new DataFrame, df2, from the last two rows of this column. I'm not sure how to do this and would appreciate some tips.

IoaTzimas · Accepted Answer · 2020-12-18 17:39:44Z

1

Try this:

newdf=df.loc[['c','d']]

>>> print(newdf)
   col10  col11
c    3.0    300
d    4.0    400

If you want a more generic solution, for example if you don;t know the index of your last tow rows, you can use the following:

newdf=df.iloc[-2:]

>>> print(newdf)
   col10  col11
c    3.0    300
d    4.0    400

answered Dec 18, 2020 at 17:39

IoaTzimas

10.6k2 gold badges15 silver badges32 bronze badges

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

1 Answer 1