绘制一个条形图，比较大Pandas的年数

Question

我有以下数据帧

Date_x  BNF Chapter_x   VTM_NM  Occurance_x     Date_y  BNF Chapter_y   Occurance_y
0   2016-12-01  1   Not Specified   2994      2015-12-01    1           3212
1   2016-12-01  1   Mesalazine      2543      2015-12-01    1           2397
2   2016-12-01  1   Omeprazole      2307      2015-12-01    1           2370
3   2016-12-01  1   Esomeprazole    1535      2015-12-01    1           1516
4   2016-12-01  1   Lansoprazole    1511      2015-12-01    1           1547

我用这个代码绘制了一个有两个条形图的条形图，一个代表2015年，另一个代表2016年

^{pr2}$

但是x轴显示的是索引0 1 2 3 4

- I want it to show the drug names

我该怎么做呢？在

Answer 1

我想你可以开始玩了。在

import pandas as pd
df = pd.DataFrame({"date_x":[2015]*5,
                   "Occurance_x":[2994, 2543, 2307, 1535, 1511],
                   "VTM_NM":["Not Specified", "Mesalazine", "Omeprazole",
                             "Esomeprazole", "Lansoprazole"],
                   "date_y":[2016]*5,
                   "Occurance_y":[3212, 2397, 2370, 1516, 1547]})

ax = df[["VTM_NM","Occurance_x", "Occurance_y"]].plot(x='VTM_NM', 
                                                      kind='bar', 
                                                      color=["g","b"],
                                                      rot=45)
ax.legend(["2015", "2016"]);