sort by two columns pandas code example

Example 1: df sort values

>>> df.sort_values(by=['col1'], ascending = False)
    col1 col2 col3
0   A    2    0
1   A    1    1
2   B    9    9
5   C    4    3
4   D    7    2
3   NaN  8    4

Example 2: sorting by column in pandas

#Python, Pandas
#Sorting dataframe df on the values of a column col1
#Temporary
df.sort_values(by=["col1"]) 

#Permanent
df.sort_values(by=["col1"], inplace = True)

Example 3: sort by two columns in pandas

df.sort_values(['a', 'b'], ascending=[True, False])

Example 4: sort dataframe by column

df.sort_values(by='col1', ascending=False, na_position='first', inplace=True)

Example 5: order dataframe by multiple columns python

df = df.sort_values(["b", "c"], ascending = (False, True))

Example 6: sort columns dataframe

df = df.reindex(sorted(df.columns), axis=1)