sort pandas series by column code example

Example 1: sort dataframe by column

df.sort_values(by='col1', ascending=False)

Example 2: 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 3: 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 4: sort dataframe by column

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

Example 5: sort a dataframe

sort_na_first = gapminder.sort_values('lifeExp',na_position='first')