1. Learn
    2. /
  2. Courses
    3. /
  3. Customer Segmentation in Python
Connected

Exercise

Calculate RFM Score

Great work, you will now finish the job by assigning customers to three groups based on the MonetaryValue percentiles and then calculate an RFM_Score which is a sum of the R, F, and M values.

The datamart has been loaded with the R and F values you have created in the previous exercise.

Instructions

100 XP
  • Create labels for MonetaryValue with an increasing range of 1 through 3.
  • Assign these labels to three equal percentile groups based on MonetaryValue.
  • Create new column M based on the MonetaryValue percentile group.
  • Calculate RFM_Score based on the sum of R, F, and M column values.