pandas 排序 给excel_Pandas4——excel排序

一、单列排序

import pandas as pd

df=pd.read_excel("D:\\python_pandas\\sample\\demo05\\List.xlsx",index_col="ID")

df.sort_values(by="Worthy",ascending=True,inplace=True)

print(df.head(10))

输出结果：

Name Price Worthy

ID

18 Product_018 11.22 No

3 Product_003 9.62 No

6 Product_006 7.34 No

15 Product_015 10.31 No

9 Product_009 8.98 No

12 Product_012 7.29 No

1 Product_001 9.82 Yes

17 Product_017 11.95 Yes

16 Product_016 10.26 Yes

14 Product_014 9.16 Yes

一、多重排序

给sort_values()的入参by和ascending传list

import pandas as pd

df=pd.read_excel("D:\\python_pandas\\sample\\demo05\\List.xlsx",index_col="ID")

df.sort_values(by=["Worthy","Price"],asce