pandas sort rows 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: sorting by column in pandas

#Python, Pandas
#Sorting dataframe df on the values of a column col1
#Temporary
df.sort_values(by=["col1"]) 

#Permanent
df.sort_values(by=["col1"], inplace = True)

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