目录
pandas 分组排序:
dtype_dict = {'order_no': str, 'sbbh': str,'barcode':str}
if not os.path.exists(excel_file_o):
print('not exists',excel_file_o)
exit(11)
df = pd.read_excel(excel_file_o, dtype=dtype_dict,sheet_name='国内Venus及其他')
df.sort_values('qty', ascending=False).groupby('order_no').head()
开始乱码:
# -*- coding: gbk -*-
import pandas as pd
if __name__ == '__main__':
df = pd.read_excel(r'C:\Users\Administrator\Desktop\小明日记.xlsx', sheet_name='其他')
header = df.columns.tolist()
print(header)
for data in df.items():
print(df)
后来又不乱码了:
# -*- coding: gbk -*-
import pandas as pd
if __name__ == '__main__':
df = pd.read_excel(r'C:\Users\Administrator\Desktop\明细1716.xlsx', sheet_name='国内')
datas=df.values.tolist()
header = df.columns.tolist()
print(header)
for data in datas:
print(data)