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(...)

Do you have just one row? Or you want to sort it according to the first row? — Nickil Maveli
– Nickil Maveli, Commented Nov 5, 2016 at 13:32
Your solution of transposing, sorting, and transposing again is the current solution. See this post and bug report. — 3novak
– 3novak, Commented Nov 5, 2016 at 13:34

Nickil Maveli · Accepted Answer · 2016-11-05 14:09:10Z

14

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()

answered Nov 5, 2016 at 13:35

Nickil Maveli

29.8k10 gold badges86 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Er, this doesn't work if your table has more than one row, right?