Sorting a pandas dataframe by its index

Question

The following is a sample of my dataframe. As you'll notice, the index (which is datetimeindex) is not sorted.

               Item Details  Unit    Op.  Qty Price  Op. Amt.
Month
2013-04-01           5 In 1   Pcs  -56.0     172.78  -9675.58
2014-01-01         14" Blad   Pcs  -5.0      157.49   -787.45
2013-09-01  Zorrik 311 Gram   Pcs  -1.0      270.01   -270.01

I wanted to sort the index and its respective rows also. I found the following way to sort the datetimeindex:

all_data.index.sort_values()

DatetimeIndex(['2013-04-01', '2013-04-01', '2013-04-01', '2013-04-01',
           '2013-04-01', '2013-04-01', '2013-04-01', '2013-04-01',
           '2013-04-01', '2013-04-01',
           ...
           '2014-02-01', '2014-02-01', '2014-02-01', '2014-02-01',
           '2014-02-01', '2014-02-01', '2014-02-01', '2014-02-01',
           '2014-02-01', '2014-02-01'],
          dtype='datetime64[ns]', name=u'Month', length=71232, freq=None)

But it is sorting only the index; how can I sort the entire dataframe according to the sorted index?

jezrael · Accepted Answer · 2016-10-26 12:51:35Z

79

I think you need sort_index:

all_data = all_data.sort_index()

edited Oct 26, 2016 at 12:51

answered Oct 26, 2016 at 12:49

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

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

Comments

cottontail · Accepted Answer · 2023-03-25 06:34:31Z

1

df.sort_index() does the job but if the index is already sorted separately (as in the OP) and you want to sort the dataframe by it, then loc is what you want.

sorted_idx = df.index.sort_values()

df = df.loc[sorted_idx]

answered Mar 25, 2023 at 6:34

cottontail

25.6k25 gold badges184 silver badges176 bronze badges

Collectives™ on Stack Overflow

Sorting a pandas dataframe by its index

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