sort values by two columns 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: sort by two columns in pandas

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

Example 3: pandas sort values by multiple columns

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

Example 4: sort df by column

df.rename(columns={1:'month'},inplace=True)
df['month'] = pd.Categorical(df['month'],categories=['December','November','October','September','August','July','June','May','April','March','February','January'],ordered=True)
df = df.sort_values('month',ascending=False)