# import sys
# sys.path.append("../")
import pandas as pd
from pyecharts.faker import Faker
from pandasecharts import echart

products = Faker.choose()
dfs = []
for year in (2012, 2013, 2014, 2015):
    dfs.append(
        pd.DataFrame(
            zip(products, Faker.values(), Faker.values(), [year]*len(products)),
            columns=["商品", "商家A", "商家B", "年份"]
        )
    )
df = pd.concat(dfs, axis=0)

2012年商家A的漏斗图

df.query("年份==2012").echart.funnel("商品", "商家A").render_notebook()

商家A不同年份漏斗图

df.echart.funnel("商品", "商家A", by="年份").render_notebook()

将年份按照时间轴显示

df.echart.funnel("商品", "商家A", timeline="年份").render_notebook()