How to sort a Pandas DataFrame by index?

Question

When there is a DataFrame like the following:

import pandas as pd

df = pd.DataFrame([1, 1, 1, 1, 1], index=[100, 29, 234, 1, 150], columns=['A'])

How can I sort this dataframe by index with each combination of index and column value intact?

Answer 1

Use sort_index method with inplace=True to operate in place.

import pandas as pd

df = pd.DataFrame([1, 2, 3, 4, 5], index=[100, 29, 234, 1, 150], columns=['A'])

df.sort_index(inplace=True)

print(df.to_string())

Output:

     A

1    4

29   2

100  1

150  5

234  3