Chapter 4 user data analysis

Data preprocessing

• Data loading
  
• Check the data type and whether there are missing values
  
• take order_dt Convert integer to time type
  
• Add a column to the source data to represent the month ：astype(‘datetime64[M]’)
  

Monthly data analysis

• Total amount spent per month , Draw a curve to show
  
  
  • Monthly product purchases by all users
    
  • The total number of monthly consumption by all users
    
  • Count the monthly consumption
    

User individual consumption data analysis

• Statistical description of the total amount and times of user consumption
  

• Scatter diagram of user consumption amount and product quantity
  

• The vertical distribution of the total consumption amount of each user （ Consumption amount in 1000 Distribution within ）
  

• The vertical distribution of the total consumption of each user （ The quantity of consumer goods is 100 Distribution within times ）

Consumer behavior analysis

• The month distribution and number statistics of users' first consumption , Draw a line chart
  

• Time distribution and number statistics of users' last consumption , Draw a line chart
  

• Proportion of new and old customers （ Consumption once is for old users , Consumption has been for old users for many times ）

• Analyze the first consumption and the last consumption time of each user ,ps：agg([‘func1’,‘func2’]) Specify the aggregation of grouped results

• Analyze the total purchase volume of each user 、 Table of total consumption amount and last consumption time rfm
  

• Look at the picture

Analysis of user life cycle