如何得到排序后的数据帧索引

Question

当我将排序函数应用于数据帧索引时，只打印值

我试过了。索引和排序一起，但不起作用

Andhra Pradesh                609949.85
Arunachal Pradesh              18796.07
Assam                         224247.19
Bihar                         413513.59
Chhattisgarh                  260786.98
Goa                            45012.75

我要排序的数字和打印在左边的索引

Andhra Pradesh                609949.85
Bihar                         413513.59
Chhattisgarh                  260786.98
Assam                         224247.19
Goa                            45012.75
Arunachal Pradesh              18796.07

Answer 1

你需要^{}

数据帧的ascending=False是按降序排列的，默认情况下是True。

df.sort_values(by=['col'], ascending=False)

数据帧：

>>> df
               Col_1      Col_2
0     Andhra Pradesh  609949.85
1  Arunachal Pradesh   18796.07
2              Assam  224247.19
3              Bihar  413513.59
4       Chhattisgarh  260786.98
5                Goa   45012.75

结果：

>>> df.sort_values(by=['Col_2'], ascending=False)
               Col_1      Col_2
0     Andhra Pradesh  609949.85
3              Bihar  413513.59
4       Chhattisgarh  260786.98
2              Assam  224247.19
5                Goa   45012.75
1  Arunachal Pradesh   18796.07

Answer 2

试试这个

import pandas as pd
indexx = ["Andhra Pradesh","Arunachal Pradesh","Assam","Bihar","Chhattisgarh","Goa"]
values = [609949.85,18796.07,224247.19,413513.59,260786.98,45012.75] 
df = pd.DataFrame(values, index=indexx, columns=['value'])

print(df["value"].sort_values(ascending=False))

Andhra Pradesh       609949.85
Bihar                413513.59
Chhattisgarh         260786.98
Assam                224247.19
Goa                   45012.75
Arunachal Pradesh     18796.07

Answer 3

在pandas我们有sort_values

df=df.sort_values('col')