Lab $7$

Do programming problem $1-5.$

Data: sales.csv

A data file contains sales transactions for a year, including these fields:

time of purchase

$,$ product ID

region

count of product purchased.

In these exercises, you'll create pivot tables and a pivot chart to summarize the data.

Read data from sales.csv into a DataFrame

Review the data using head$()$

Summarize sales by product using a pivot table

values$=$'count'

index$=$'product'

aggfunc$=$'sum'

Summarize sales by product and region using a pivot table

values$=$'count'

index$=$'product'

columns$=$'region'

aggfunc$=$'sum'

From the two$-$dimensional pivot table, create a stacked horizontal bar chart, using

the DataFrame plot$()$ method and these settings:

kind$=$'barh'

stacked$=$True