Access last index value of dataframe

Question

I have an example dataframe (df) for 2 products:

                         BBG.XAMS.FUR.S               BBG.XAMS.MT.S
date                                                               
2014-10-23                 -2368.850388                    0.000000
2014-10-24                  6043.456178                    0.000000
2015-03-23                    -0.674996                   -0.674997
2015-03-24                    82.704951                   11.868748
2015-03-25                   -11.027327                   84.160210

Is there a way to retrieve the last index value of a dataframe only. So in this example the date value I need retrieved is 2015-03-25?

EdChum · Accepted Answer · 2015-09-01 22:24:03Z

34

The following gives you the last index value:

df.index[-1]

Example:

In [37]:

df.index[-1]
Out[37]:
Timestamp('2015-03-25 00:00:00')

Or you could access the index attribute of the tail:

In [40]:

df.tail(1).index[0]
Out[40]:
Timestamp('2015-03-25 00:00:00')

answered Sep 1, 2015 at 22:24

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

Comments

dsugasa · Accepted Answer · 2018-10-05 15:31:20Z

10

Old post, but df.last_valid_index() also works.

answered Oct 5, 2018 at 15:31

dsugasa

6831 gold badge10 silver badges27 bronze badges

Collectives™ on Stack Overflow

Access last index value of dataframe

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related