python sorted by column 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 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)
Example 3: python dataframe sort by column name
>>> result = df.sort(['A', 'B'], ascending=[1, 0])
Example 4: sort a dataframe
sort_na_first = gapminder.sort_values('lifeExp',na_position='first')