Skip to main content
 首页 » 编程设计

python之如何对 Pandas 中的两个字段进行排序

2025年02月15日8emanlee

我有以下数据类型:

id=["SA3342","ASD345","SFZX34","ASDFS5","SDFDS4","SFDDSF1"] 
arrival_time = ["0"," 2016-05-19 13:50:00","2016-05-19 21:25:00","0","2016-05-24 18:30:00","2016-05-26 12:15:00"] 
departure_time = ["2016-05-19 08:25:00","2016-05-19 16:00:00","2016-05-20 07:45:00","2016-05-24 12:50:00","2016-05-25 23:00:00","2016-05-26 19:45:00"] 

获取以下数据:

id              arrival_time                departure_time 
SA3342                 0                  2016-05-19 08:25:00 
ASD345          2016-05-19 13:50:00       2016-05-19 16:00:00 
SFZX34          2016-05-19 21:25:00       2016-05-20 07:45:00 
ASDFS5                    0               2016-05-24 12:50:00 
SDFDS4          2016-05-24 18:30:00       2016-05-25 23:00:00 
SFDDSF1          2016-05-26 12:15:00       2016-05-26 19:45:00 

如何根据“id”和出发时间对数据类型进行排序?

我尝试了以下代码,但没有成功:

df = df.sort_values(['id', 'departure_time'], inplace=True, by='date')     

我收到以下错误:

TypeError: sort_values() got multiple values for keyword argument 'by' 

请您参考如下方法:

看来您需要删除 assign if parameter inplace=True 并删除 sort_values 中的第二个 by :

df.sort_values(by=['id', 'departure_time'], inplace=True)     
print (df) 
        id          arrival_time       departure_time 
1   ASD345   2016-05-19 13:50:00  2016-05-19 16:00:00 
3   ASDFS5                     0  2016-05-24 12:50:00 
0   SA3342                     0  2016-05-19 08:25:00 
4   SDFDS4   2016-05-24 18:30:00  2016-05-25 23:00:00 
5  SFDDSF1   2016-05-26 12:15:00  2016-05-26 19:45:00 
2   SFZX34   2016-05-19 21:25:00  2016-05-20 07:45:00 

或者删除 inplace=True 和第二个 by:

df = df.sort_values(by=['id', 'departure_time'])     
print (df) 
        id          arrival_time       departure_time 
1   ASD345   2016-05-19 13:50:00  2016-05-19 16:00:00 
3   ASDFS5                     0  2016-05-24 12:50:00 
0   SA3342                     0  2016-05-19 08:25:00 
4   SDFDS4   2016-05-24 18:30:00  2016-05-25 23:00:00 
5  SFDDSF1   2016-05-26 12:15:00  2016-05-26 19:45:00 
2   SFZX34   2016-05-19 21:25:00  2016-05-20 07:45:00