how to sort a dataframe in python based on a column code example
Example 1: sort a dataframe by a column valuepython
>>> 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 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 by dataframe
DataFrame.sort_values(self, by, axis=0, ascending=True,
inplace=False, kind='quicksort',
na_position='last',
ignore_index=False)
df.sort_values(by=['ColToSortBy'])
Example 4: sort a dataframe
sort_na_first = gapminder.sort_values('lifeExp',na_position='first')
Example 5: 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))