sort dataframe in pandas code example

Example 1: 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 2: sort_values

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

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

Example 4: how to sort the dataframe in python

import pandas as pd
df1=pd.read_csv("registration.csv")
df2=pd.read_csv("payment.csv")
df=pd.merge(df1,df2)
print(df.iloc[:,[0,1,3,4]].to_string(index=False))