The owner of a chain store ask the data engineer to prepare a report presenting the following information:

1. The list of stores that sell each product.
2. The average sales of each product.
3. The maximum and minimum monthly sales of each product.
4. The store id and city name in which the maximum sales are recorded of each product.
5. The product name that recoded the maximum average sales.
6. The list of stores that no longer offer each product.

This is the dataset:

URL = "https://bit.ly/34DDvsQ"

Dataframe/Python