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.
Questo esercizio fa parte del corso
Joining Data with pandas
Istruzioni dell'esercizio
- Concatenate the three tables together vertically in order with the oldest month first, adding
'7Jul','8Aug', and'9Sep'askeysfor their respective months, and save toinv_jul_thr_sep. - Use the
.agg()method to find the average of thetotalcolumn from the grouped invoices. - Create a bar chart of
avg_inv_by_month.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
# 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()