【Python】用 Python 帮财务小妹生成 Excel 报表，小妹直说一辈子。。。

df = pd.read_excel("sales-funnel.xlsx")table = pd.pivot_table(df,index=["Manager","Rep","Product"],               values=["Price","Quantity"],               aggfunc=[np.sum,np.mean],fill_value=0) table

table.xs('Debra Henley', level=0)

table.xs(('Debra Henley','Craig Booker'), level=0)

table.index.get_level_values(0)table.index.get_level_values(1)table.index.get_level_values(0).unique()

Index(['Debra Henley', 'Debra Henley', 'Debra Henley', 'Debra Henley',       'Debra Henley', 'Debra Henley', 'Debra Henley', 'Fred Anderson',       'Fred Anderson', 'Fred Anderson', 'Fred Anderson', 'Fred Anderson',       'Fred Anderson'],      dtype='object', name='Manager')

Index(['Craig Booker', 'Craig Booker', 'Craig Booker', 'Daniel Hilton',       'Daniel Hilton', 'John Smith', 'John Smith', 'Cedric Moss',       'Cedric Moss', 'Cedric Moss', 'Wendy Yule', 'Wendy Yule', 'Wendy Yule'],      dtype='object', name='Rep')

Index(['Debra Henley', 'Fred Anderson'], dtype='object', name='Manager')

for manager in table.index.get_level_values(0).unique():    print(table.xs(manager, level=0))

writer = pd.ExcelWriter('output.xlsx')
for manager in table.index.get_level_values(0).unique():    temp_df = table.xs(manager, level=0)    temp_df.to_excel(writer,manager)
writer.save()

if __name__ == "__main__":    parser = argparse.ArgumentParser(description='Script to generate sales report')    parser.add_argument('infile', type=argparse.FileType('r'),                        help="report source file in Excel")    parser.add_argument('outfile', type=argparse.FileType('w'),                        help="output file in Excel")    args = parser.parse_args()    # We need to pass the full file name instead of the file object    sales_report = create_pivot(args.infile.name)    save_report(sales_report, args.outfile.name)