Sort Pandas DataFrame by column

Question

How do I sort a pandas data-frame by column? I read here http://pandas.pydata.org/...sort_values about sort_values. When I run

df = pd.DataFrame([(2,'a'),(1,'b')],columns = ['num','let'])
df
df.sort_values(by='num', axis=1, ascending=True, inplace=True)

I obtain error KeyError: 'num'

Remove axis=1, this is looking for index labels that match 'num' — EdChum
– EdChum, Commented Oct 5, 2017 at 11:00

EdChum · Accepted Answer · 2017-10-05 11:14:27Z

3

You should remove axis=1, this tries to look for index labels that match 'num' which don't exist:

In[33]:
df.sort_values(by='num')

Out[33]: 
   num let
1    1   b
0    2   a

The default is axis=0 which looks for columns that match 'num'

answered Oct 5, 2017 at 11:14

EdChum

397k204 gold badges836 silver badges583 bronze badges

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

1 Comment

Carlo Over a year ago

Thank you very much EdChum, it worked. I was mislead by the description on the documentation pandas.pydata.org/pandas-docs/version/0.19.2/generated/… where is written " {0 or ‘index’, 1 or ‘columns’}" and by the fact that for dropping columns I use .drop(labes=['let'],axis=1)

Collectives™ on Stack Overflow

Sort Pandas DataFrame by column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related