我正在尝试从以下数据框中绘制条形图(matplotlib):
供应商出现多次,每年最多一次。(年范围2012-2020)
给定供应商名称(例如“光学验光师”)-寻找有关如何形成x =年,y =给定供应商支付金额的直方图的指导。
任何帮助大受好评。
DATA >> 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}]
只需使用二进制掩码过滤这些行。
假设您的数据框已命名,df
并使用以下hist
方法进行绘制:
df[df['Vendor Name'] == WHATEVERNAMEYOUWANT].hist()
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句