# 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)
df.head()
| 商品 | 商家A | 商家B | 年份 | |
|---|---|---|---|---|
| 0 | 衬衫 | 71 | 45 | 2012 |
| 1 | 毛衣 | 105 | 79 | 2012 |
| 2 | 领带 | 50 | 84 | 2012 |
| 3 | 裤子 | 136 | 101 | 2012 |
| 4 | 风衣 | 56 | 40 | 2012 |
df.echart.bar3d("年份", "商品", "商家A", visualmap=True, visualmap_opts={"max_": 170}).render_notebook()