sort row in pandas code example

Example 1: sort dataframe by column

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

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: sorting rows and columns in pandas

df.sort_values(by="ColumnName", axis=0, ascending=False, inplace=False, kind='quicksort')
#axis 0 is rows and axis 1 is columns. For axis 0 by needs to contain column name

Example 4: pandas dataframe sort by column name first 10 values

print df
   0  Bytes  Client             Ip
0  1      1    1000   192.168.10.2
1  0      0    2000  192.168.10.12
2  2      2     500   192.168.10.4
3  3      3     159  192.168.10.56

print df.nlargest(3, 'Client')
   0  Bytes  Client             Ip
1  0      0    2000  192.168.10.12
0  1      1    1000   192.168.10.2
2  2      2     500   192.168.10.4