利用Python实现报表自动化

# 导入源数据
import pandas as pd
from datetime import datetime
data = pd.read_csv(r'/Users/faye/Desktop/order-14.1.csv',parse_dates = ['成交时间'])   # parse_dates将数据解析为时间格式
data.head() # 预览前五行数据
# 利用函数提高编码效率
def get_month_data(data):
    sale = (data['单价'] * data['销量']).sum()
    traffic = data['订单ID'].drop_duplicates().count()
    s_t = sale / traffic
    return (sale,traffic,s_t)
this_month = data[(data['成交时间'] >= datetime(2018,2,1)) & (data['成交时间'] <= datetime(2018,2,28))]
last_month = data[(data['成交时间'] >= datetime(2018,1,1)) & (data['成交时间'] <= datetime(2018,1,31))]
same_month = data[(data['成交时间'] >= datetime(2017,2,1)) & (data['成交时间'] <= datetime(2017,2,28))]
# 计算本月指标
sale_1 ,traffic_1,s_t_1 = get_month_data(this_month)
# 计算上月指标
sale_2 ,traffic_2,s_t_2 = get_month_data(last_month)
# 计算去年同期指标
sale_3