We work with the accounting department of a company that sells motorcycle parts. The company operates three warehouses in a large metropolitan area.
Let's help them to analyze past sales data. Your colleague wants to capture sales by payment method. She also needs to know the average unit price for each product line.
Create a report to answer our colleague's questions. Include:
- What are the total sales for each payment method?
- What is the average unit price for each product line?
- Create plots to visualize findings for questions 1 and 2.
- Investigate further (e.g., average purchase value by client type, total purchase value by product line, etc.)
- Summarize your findings.
- Programming Language
- Python3
- Libraries
- Pandas
- Matplotlib
- Clone project
- Create a branch
- Open jupyter_notebook.ipynb
- Analyse Data
- Summarize your findings
- Create a pull request