python - 按字母顺序对数据框排序

Question

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

• 姓名号码
• 布鲁96570
• 吉布95095
• 梅尔 115195
• 完成112055
• 原始88018

我可以对“数字”进行排序，但如果我将其替换为“名称”，则会收到错误。

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:

Answer 1

尝试一下:

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

编辑:您确定有一个名为“名称”的列吗？