dataframe sort by column pandas code example
Example 1: sort dataframe by column
df.sort_values(by='col1', ascending=False)
Example 2: dataframe sort by column
sorted = df.sort_values('column-to-sort-on', ascending=False)
df.sort_values('name', inplace=True)
Example 3: order pandas dataframe by column 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 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))