一、單列排序
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))
輸出結(jié)果：
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()的入?yún)y和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"],ascending=[True,False],inplace=True)
print(df.head(10))
輸出結(jié)果：
Name Price Worthy
ID
18 Product_018 11.22 No
15 Product_015 10.31 No
3 Product_003 9.62 No
9 Product_009 8.98 No
6 Product_006 7.34 No
12 Product_012 7.29 No
2 Product_002 11.99 Yes
17 Product_017 11.95 Yes
8 Product_008 11.14 Yes
4 Product_004 11.08 Yes
