sort column values pandas code example
Example 1: sort a dataframe by a column valuepython
>>> df.sort_values(by=['col1'])
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 dataframe by column
df.sort_values(by='col1', ascending=False)
Example 3: df.sort_values(by='col1',asending=True)
>>> df.sort_values(by='col1', ascending=False)
col1 col2 col3 col4
4 D 7 2 e
5 C 4 3 F
2 B 9 9 c
0 A 2 0 a
1 A 1 1 B
3 NaN 8 4 D
Example 4: dataframe sort by column
sorted = df.sort_values('column-to-sort-on', ascending=False)
df.sort_values('name', inplace=True)
Example 5: sort dataframe by column
df.sort_values(by='col1', ascending=False, na_position='first', inplace=True)