column order pandas code example

Example 1: sort dataframe by column

df.sort_values(by='col1', ascending=False)

Example 2: reorder columns pandas

cols = df.columns.tolist()
# Rearrange the list any way you want
cols = cols[-1:] + cols[:-1]
df = df[cols]

Example 3: rearrange columns pandas

You could also do something like this:

df = df[['mean', '0', '1', '2', '3']]
You can get the list of columns with:

cols = list(df.columns.values)
The output will produce:

['0', '1', '2', '3', 'mean']

Example 4: pandas order dataframe by column of other dataframe

df1 = df1.set_index('column_in_df1')
df1 = df1.reindex(index=df2['column_in_df2'])
df1 = df1.reset_index()