python数据分析--------电商打折套路为例

以下是本人做的 电商打折套路分析第二部分 分析代码以及结论

# -*- coding: utf-8 -*-
"""
Spyder Editor

This is a temporary script file.
"""
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt

import warnings
warnings.filterwarnings

from bokeh.plotting import figure ,show,output_file
from bokeh.models import ColumnDataSource
from bokeh.models import HoverTool

import os
os.chdir("C:\\Users\\Administrator\\Desktop\\python项目\\2电商打折")
df=pd.read_excel("双十一数据.xlsx",sheetname=0)
df.fillna(0,inplace=True)
df.index=df["update-time"]
df["date"]=df.index.day

data_zk=result3_data2[result3_data2["zkl"]<0.96]
result4_zkld=data_zk.groupby("店名_x")["zkl"].mean()
n_dz=data_zk["店名_x"].value_counts()
n_bdz=result3_data2["店名_x"].value_counts()
result4_dzspbl=pd.DataFrame({"打折商品数":n_dz,"不打折商品数":n_bdz})
result4_dzspbl["打折商品比例"]=resu