用python指令给指定的字段排升降序

import pandas as pd
import xlrd
import xlwt

#  读写指定路径下的相关文件
df = pd.read_excel(r"D:\About My Work\price\2019.07\7-04\广州仓\InData_20190704233637.xlsx")
df

 

# 给“采购单价”字段按升序排列
# df.sort_values(by = ["采购单价"],ascending = True)
# 打印输出
df.sort_values(by = ["采购单价"],ascending = True).to_excel(excel_writer = r"C:\Users\滕玉龙\Desktop\广州验收单价.xlsx",sheet_name = "按采购单价排升序")

 

# 给“实际数”字段按升序排列
# df.sort_values(by = ["实际数"],ascending = False)
# 打印并输出结果
df.sort_values(by = ["实际数"],ascending = False).to_excel(excel_writer = r"C:\Users\滕玉龙\Desktop\广州.xlsx",sheet_name = "按实际数倒序排列")

转载于:https://my.oschina.net/u/3750423/blog/3069877