删除指定列名
data = data.drop('商品id9', axis=1)
#模糊删除列名
data.drop(data.filter(regex='订单商品名称1', axis=1).columns, axis=1, inplace=True)
#毫秒级时间戳
data['created'] = pd.to_datetime(data['created'], unit='ms', utc=True)
#可能因为时区需要增加8小时
data['created'] = data['created'] + pd.Timedelta(hours=8)
list转dataframe 转excel
df = pd.DataFrame (list_指标表现[1:], columns=list_指标表现[0])
df.to_excel (final_dir + "\\" + day + filename, index=False)
