Challenge Summary: Imagine you work for a small company that sells products online. Your manager has asked you to analyse the sales data from the past year to determine which products are the best selling. You have also been asked to identify any trends in customer purchasing behaviour.
- A. Use Pandas to read in the sales data from the CSV file provided in the “student materials” folder on Slack (sales_dataset.csv)
- B. Calculate the total sales for each product
- C. Determine the average sale price for each product category
- D. Identify the month with the highest sales and the month with the lowest sales
- E. Determine which customers made the most purchases and how much they spent in total
- F. Write the results of your analysis as a CSV file
For more information please se ipynb Jupiter Notebook with all the work.