RFM Helper Functions

RFM_helper_functions.py

#get days since last invoice (Recency)
def get_history(x):
    d = data[data['client_id'] == x.client_id]
    d_max = max(d['invoice_date'])
    t = datetime.today()
    y = t - d_max
    return y.days

  
#count number of invoices for client (Frequency)
c_invoices_dict = collections.Counter(data['client_description'])
def get_counts(x):
    return c_invoices_dict[x.client_description]

  
#get total amount of all invoices for client (Monetary Value)
def total_invoices(x):
   d = data[data['client_description'] == x.client_description]
   total = d.amount.sum()
   return total