Data Science

Final Project Part 3: Feature Engineering

Senior Data Analyst
May 23, 2026
5 min read

Engineered Features

df['tenure_months'] = (pd.Timestamp.now() - df['signup_date']).dt.days / 30

df['purchase_frequency'] = df['total_orders'] / df['tenure_months']

df['avg_order_value'] = df['total_spend'] / df['total_orders']

df['days_since_last_order'] = (pd.Timestamp.now() - df['last_order_date']).dt.days

*Day 144: Model Training.*

Ready to put your knowledge into practice?

Join SQL Mastery and learn through interactive exercises.