- 🔥 Aim for this lesson
- 🛠️ Problem
- 🚀 Solutions
- 🔥 Learned
Using a real world data, I am going to cleaned the data and analyze what my data needs to be answered using what I learned in Python.
- What is the yearly sales trend?
- Which product sold the most in 2016?
- Among the three product categories, which one had the lowest sale in 2018?
- What is the yearl sales trend of the three customer groups?
- Are we getting more corporate customers?
Sales Data Analysis
Ans. The product that sold the most in 2018 is Canon imageCLASS 2200 Advanced Copier with 14000 sales
- Analyze the Data
- Clean the Data
- Applied the methods learned from the previous lesson/s
- fillna() method - to fill null values into non null
- to_datetime() method - to convert object into date data type
- astype method() - to convert a object into string readable
- Working with DataFrame
- dropna(), isnull, and isna() nethods - for null vaues in data
- describe() method - information of dataframe
- simple filtering with conditionals
- arranging with sort_values
- aggregate method
- Modelling the Data
- More about Data Analysis Steps
- More about Pandas basic methods
- barplot() - for making barcharts from matplotlib.pyplot packages
- lineplot() - for making line charts from matplotlib.pyplot packages
- label() - for labeling the axes
- title() - for making title in the charts
- show() - displaying the charts
© 2022 Donard Azura