Draw revenue − budget per month as bars: green where actual beat the budget (≥ 0) and red where it missed. Add a black line at 0 and the title Variance from budget.
import pandas as pd
monthly = pd.DataFrame({
"month": ["Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec"],
"revenue": [420, 380, 510, 560, 600, 580, 640, 700, 660, 820, 950, 1100],
"orders": [210, 190, 240, 260, 275, 270, 290, 310, 300, 360, 410, 470],
"ad_spend": [60, 55, 70, 75, 80, 78, 85, 90, 88, 110, 130, 150],
"returns": [12, 10, 15, 14, 18, 16, 17, 20, 19, 25, 30, 34],
})
import matplotlib.pyplot as plt
budget = [450, 450, 500, 550, 600, 600, 650, 700, 700, 800, 900, 1000]Draw the chart. It is checked on what it shows: the data, the title and axis labels, the legend and the category names, and the colours and line styles. Size and fonts don't matter.
Each hint gives a little more help. Try on your own first.
Run your code to see the output here.