Sort Dataframe by Index then by Column

Question

I have a dataframe that I sorted by the datetime index. Since there are many entries for each date, I would like it to further sort by the column "Ticker" alphabetically within each date. How do you do this? Image of dataframe attached

Anurag Dabas · Accepted Answer · 2021-08-09 17:30:37Z

3

You can try reset_index()+sort_values()+set_index():

so the idea is to reset the current index then sort 'Date' along with 'Ticker' then after sorting set 'Date' as index

df=df.reset_index().sort_values(['Date','Ticker']).set_index('Date')

edited Aug 9, 2021 at 17:30

answered Aug 9, 2021 at 17:20

Anurag Dabas

24.3k9 gold badges25 silver badges41 bronze badges

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

1 Comment

sammywemmy Over a year ago

try df.sort_values(['Date','Ticker']), since the index has a name, it should work (at least with Pandas 1.1)

Collectives™ on Stack Overflow

Sort Dataframe by Index then by Column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related