sort dataframe alphabetically

Question

birth_data.sort_values(by='name',ascending = True)

name numbers
1. bruh 96570
2. gib 95095
3. mel 115195
4. nish 112055
5. raw 88018

I can sort the "numbers" but if i replace it with "name" I receive an error.

KeyError                                  Traceback (most recent call last)
~\Anaconda3\lib\site-packages\pandas\core\indexes\base.py in get_loc(self, key, method, tolerance)
   2441             try:
-> 2442                 return self._engine.get_loc(key)
   2443             except KeyError:

pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas\_libs\index.pyx in pandas._libs.index.IndexEngine.get_loc()

pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

pandas\_libs\hashtable_class_helper.pxi in pandas._libs.hashtable.PyObjectHashTable.get_item()

KeyError: 'name'

During handling of the above exception, another exception occurred:

It means there are no column name, what is print (df.columns.tolist()) ? — jezrael
– jezrael, Commented Feb 21, 2018 at 9:47

jbra95 · Accepted Answer · 2018-02-21 09:50:15Z

2

Try that:

birth_data.sort_values(by=['name'], ascending = True)

Edit: Are you sure there is a column called 'name'?

answered Feb 21, 2018 at 9:50

jbra95

9092 gold badges12 silver badges31 bronze badges

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

2 Comments

Sociopath Over a year ago

by parameter can be a string or list of strings.

jbra95 Over a year ago

You are right. I think that the problem is the dataframe don't have a "name" column.

Collectives™ on Stack Overflow

sort dataframe alphabetically

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related