import pandas as pd
df = pd.DataFrame(index=list(range(5)), data={'c': [4, 2, 2, 4, 2]})
df.index = df.index[::-1]
print(df.sort(column='c', ascending=False))
Sort pandas dataframe both on values of a column and index?