从Pandas数据框中选择行以构建条形图

Question

我正在尝试从以下数据框绘制条形图（matplotlib）：

供应商出现多次，每年最多出现一个条目。（年份范围为2012-2020年）

给定一个供应商名称（比如“验光师学院”）-寻找如何形成x=年、y=给定供应商支付金额的直方图的指导

得到的任何帮助都是巨大的

数据>&燃气轮机；某些数据的Json版本：

[{"Vendor Name":" (CMC Chester LTD) Trading as The N","year":2020,"Amount Paid":-37500.0},
{"Vendor Name":" COLLEGE OF OPTOMETRISTS","year":2013,"Amount Paid":-35300.0},
{"Vendor Name":" COLLEGE OF OPTOMETRISTS","year":2014,"Amount Paid":-36180.0},
{"Vendor Name":" COLLEGE OF OPTOMETRISTS","year":2015,"Amount Paid":-72360.0},
{"Vendor Name":" COLLEGE OF OPTOMETRISTS","year":2016,"Amount Paid":-36180.0},
{"Vendor Name":" COLLEGE OF OPTOMETRISTS","year":2017,"Amount Paid":-36180.0},
{"Vendor Name":" COLLEGE OF OPTOMETRISTS","year":2018,"Amount Paid":-36180.0},
{"Vendor Name":" COLLEGE OF OPTOMETRISTS","year":2019,"Amount Paid":-36180.0},
{"Vendor Name":" COOKE & ARKWRIGHT CLIENT AC","year":2012,"Amount Paid":-515693.4},
{"Vendor Name":" COOKE & ARKWRIGHT CLIENT AC","year":2013,"Amount Paid":-511219.2},
{"Vendor Name":" COOKE & ARKWRIGHT CLIENT AC","year":2014,"Amount Paid":-82072.2},
{"Vendor Name":" FFGF LTD","year":2019,"Amount Paid":-25698.57},
{"Vendor Name":" FFGF LTD","year":2020,"Amount Paid":-28900.35}]

Answer 1

只需使用二进制掩码过滤这些行

假设您的数据帧名为df，并使用hist方法绘制：

df[df['Vendor Name'] == WHATEVERNAMEYOUWANT].hist()