We can make the plot interactive using panel. we need to reformat our print function to a general function that can handle year 2019, 2020 or both and we need to create a widget to select the years. We will make a grid layout to display the widget, the plot and the table. First we make sure we can run the panel form the notebook by panel.extension()
Important! If you use matplotlib instead of bokeh or holov you must make sure to return an interactive plot using pn.pane.Matplotlib(fig)
import panel as pn
pn.extension()
#generalize function
def plot_sales(labels = df_sales['month'], location = " Drenthe", years = ['2020']):
width = 0.35 # the width of the bars
fig, ax = plt.subplots()
n = len(years)
x = np.arange(len(labels))
pos = x - width/n
color = {'2019':'lightgrey', '2020':'grey'}
for year in years:
sales = df_sales[int(year)]
ax.bar(pos, sales, width, label=year, color = color[year])
pos = pos + width
ax.set_ylabel('gemiddeld aantallen verkocht')
ax.set_title('Verkoop in' + location)
ax.legend()
ax.set_xticks(x)
ax.set_xticklabels(labels)
plt.gcf().autofmt_xdate(rotation=90, which = 'major', ha="center")
plt.figsize=(8, 6)
fig.tight_layout()
########## return a panel object! ########
mpl_pane = pn.pane.Matplotlib(fig)
return mpl_pane
