Python自动化开发-微信交易统计源代码

# pip install pandas 处理数据的模块 # pip install xlwt import pandas as pd import numpy as np df = pd.read_csv('a.csv',header=16) df['金额'] = pd.to_numeric(df['金额(元)'].str[1:],errors='ignore') df['交易时间'] = pd.to_datetime(df['交易时间'],errors='ignore') df['时段'] = df['交易时间'].apply(lambda x: x.strftime('%H')) df['月份'] = df['交易时间'].apply(lambda x: x.strftime('%Y-%m')) out_file_name = 'out.xls' writer = pd.ExcelWriter(out_file_name) df.to_excel(excel_writer=writer,sheet_name='原始数据') # print(df) # 交易时间的分析 df2 = pd.pivot_table(df,index=['月份'],values=['金额'],aggfunc=(sum,len,max,np.mean)) # 保存结果到excel df2.to_excel(excel_writer=writer,sheet_name='交易时间的分析') # print(df2) # 交易对手分析 df3 = pd.pivot_table(df,index=['交易对方'],values=['金额'],aggfunc=(sum,len)) # 保存结果到excel df3.to_excel(excel_writer=writer,sheet_name='交交易对方分析') writer.save() writer.close()