Concatenating with keys

The leadership of the music streaming company has come to you and asked you for assistance in analyzing sales for a recent business quarter. They would like to know which month in the quarter saw the highest average invoice total. You have been given three tables with invoice data named inv_jul, inv_aug, and inv_sep. Concatenate these tables into one to create a graph of the average monthly invoice total.

This exercise is part of the course

Joining Data with pandas

View Course

Exercise instructions

Concatenate the three tables together vertically in order with the oldest month first, adding '7Jul', '8Aug', and '9Sep' as keys for their respective months, and save to inv_jul_thr_sep.
Use the .agg() method to find the average of the total column from the grouped invoices.
Create a bar chart of avg_inv_by_month.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

# Concatenate the tables and add keys
inv_jul_thr_sep = pd.concat(____, 
                            keys=____)

# Group the invoices by the index keys and find avg of the total column
avg_inv_by_month = inv_jul_thr_sep.groupby(level=0).agg({'total':'----'})

# Bar plot of avg_inv_by_month
avg_inv_by_month.____
plt.show()

Edit and Run Code