I have a simple long-form dataset I would like to generate bar charts from. The dataframe looks like this:
data = {'Year':[2019,2019,2019,2020,2020,2020,2021,2021,2021],
'Month_diff':[0,1,2,0,1,2,0,1,2],
'data': [12,10,13,16,12,18,19,45,34]}
df = pd.DataFrame(data)
I would like to plot a bar chart that has 3 rows, each for 2019, 2020 and 2021. X axis being month_diff
and data
goes on Y axis.
How do I do this?
If the data was in different columns, then I could have just used this code:
df.plot(x="X", y=["A", "B", "C"], kind="bar")
But my data
is in a single column and ideally, I'd like to have different row for each year.
CodePudding user response: