pandas sort by two columns 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

>>> 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: sort by two columns in pandas

df.sort_values(['a', 'b'], ascending=[True, False])

Example 4: pandas sort values by multiple columns

df = df.sort_values(["b", "c"], ascending = (False, True))

Example 5: sort columns dataframe

df = df.reindex(sorted(df.columns), axis=1)

Example 6: merge two dataframes based on column

df_merge_col = pd.merge(df_row, df3, on='id')

df_merge_col