利用pandas进行图表的基础的绘制,以下是根据课程学习的代码部分。供自己日后学习备查。
import pandas
import matplotlib.pyplot as plt
books = pandas.read_excel("./15天父商品流量.xlsx",index_col="序列")
books["订单商品数量转化率"] = books["已订购商品数量"]/books["买家访问次数"]
books.to_excel("./15天父商品流量.xlsx")
books = books.loc[books["age"].apply(lambda a: 18<=a<26)].loc[books.score.apply(lambda b: 80<=b<100)]
books = pandas.read_excel("./cauclate.xlsx",index_col="id")
books["total"] = books.oct + books.nov + books.nov
books.sort_values(by='total',inplace=True)
books.plot.bar(x="field",y="num",color = "red",title="machine language percent")
books.plot.barh(x="field",y=["oct","nov","dec"],stacked = True)
plt.xlabel("field",fontsize = 16, fontweight = "bold")
plt.yla