order by column 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: 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 3: sort dataframe by column
df.sort_values(by='col1', ascending=False)
Example 4: dataframe, sort by columns
final_df = df.sort_values(by=['2'], ascending=False)
Example 5: dataframe sort by column
sorted = df.sort_values('column-to-sort-on', ascending=False)
df.sort_values('name', inplace=True)
Example 6: 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)