Pandas sort row values

Question

I have a pandas dataframe like this:

    Col1  Col2  Col3
1   1092  203   802 

Is it possible to sort this dataframe and get a result like this：

    Col1  Col3  Col2
1   1092  802   203 

I tried sort_values but it doesn't work. My work around is df.T.sort_values(...)

Answer 1

Starting from 0.19.0, you could sort the columns based on row values.

df.sort_values(by=1, ascending=False, axis=1)

---

Bar chart:

Using ggplot:

melt_df = pd.melt(df, var_name='Cols')
ggplot(aes(x="Cols", weight="value"), melt_df) + geom_bar()

Using built-in:

melt_df.plot.bar(x=['Cols'], y=['value'], legend=False, cmap=plt.cm.Spectral)
plt.show()