且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

如何从一列对 pandas 数据框进行排序

更新时间:2022-12-03 19:43:26

使用 sort_values 按特定列的值对 df 进行排序:

Use sort_values to sort the df by a specific column's values:

In [18]:
df.sort_values('2')

Out[18]:
        0          1     2
4    85.6    January   1.0
3    95.5   February   2.0
7   104.8      March   3.0
0   354.7      April   4.0
8   283.5        May   5.0
6   238.7       June   6.0
5   152.0       July   7.0
1    55.4     August   8.0
11  212.7  September   9.0
10  249.6    October  10.0
9   278.8   November  11.0
2   176.5   December  12.0

如果您想按两列排序,请将列标签列表传递给 sort_values,并根据排序优先级对列标签进行排序.如果您使用 df.sort_values(['2', '0']),结果将按列 2 排序,然后按列 0.当然,这对于这个例子来说没有意义,因为 df['2'] 中的每个值都是唯一的.

If you want to sort by two columns, pass a list of column labels to sort_values with the column labels ordered according to sort priority. If you use df.sort_values(['2', '0']), the result would be sorted by column 2 then column 0. Granted, this does not really make sense for this example because each value in df['2'] is unique.