-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathsource_code.py
More file actions
106 lines (82 loc) · 2.84 KB
/
Copy pathsource_code.py
File metadata and controls
106 lines (82 loc) · 2.84 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
# --------------------------
# Step 1: Import libraries
# --------------------------
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
from sklearn.preprocessing import StandardScaler
from sklearn.cluster import KMeans
import warnings
import os
# Suppress joblib CPU warning
warnings.filterwarnings("ignore", category=UserWarning, module="joblib")
os.environ["LOKY_MAX_CPU_COUNT"] = "4" # set manually to avoid WMIC issue
# --------------------------
# Step 2: Load dataset
# --------------------------
df = pd.read_csv("marketing_campaign.csv", sep="\t")
print("Shape:", df.shape)
print(df.head())
# --------------------------
# Step 3: Data Cleaning
# --------------------------
# Fill missing Income with median
df["Income"] = df["Income"].fillna(df["Income"].median())
# Convert Dt_Customer (format = dd-mm-yyyy)
df["Dt_Customer"] = pd.to_datetime(df["Dt_Customer"], format="%d-%m-%Y")
# Create Age feature
df["Age"] = 2025 - df["Year_Birth"]
# Create Total Spending
df["Total_Spent"] = df[[
"MntWines","MntFruits","MntMeatProducts",
"MntFishProducts","MntSweetProducts","MntGoldProds"
]].sum(axis=1)
# Drop unnecessary columns
df.drop(["ID","Z_CostContact","Z_Revenue"], axis=1, inplace=True)
print("\nCleaned Columns:", df.columns)
# --------------------------
# Step 4: Exploratory Data Analysis
# --------------------------
# Age Distribution
plt.figure(figsize=(6,4))
sns.histplot(df["Age"], bins=30, kde=True, color="blue")
plt.title("Age Distribution")
plt.show()
# Income vs Spending
plt.figure(figsize=(6,4))
sns.scatterplot(x="Income", y="Total_Spent", data=df, alpha=0.6)
plt.title("Income vs Total Spending")
plt.show()
# Response Count
plt.figure(figsize=(5,3))
sns.countplot(x="Response", data=df, palette="Set2")
plt.title("Campaign Response Distribution")
plt.show()
# --------------------------
# Step 5: Clustering
# --------------------------
# Select features for clustering
features = ["Income","Recency","Total_Spent",
"NumWebPurchases","NumCatalogPurchases","NumStorePurchases"]
X = df[features]
# Standardize
scaler = StandardScaler()
X_scaled = scaler.fit_transform(X)
# Apply KMeans (4 clusters)
kmeans = KMeans(n_clusters=4, random_state=42)
df["Cluster"] = kmeans.fit_predict(X_scaled)
# --------------------------
# Step 6: Cluster Visualization
# --------------------------
plt.figure(figsize=(7,5))
sns.scatterplot(x="Income", y="Total_Spent", hue="Cluster", data=df, palette="Set2", alpha=0.7)
plt.title("Customer Segmentation: Income vs Spending")
plt.show()
# --------------------------
# Step 7: Cluster Insights
# --------------------------
cluster_summary = df.groupby("Cluster")[["Income","Age","Total_Spent","Recency"]].mean().round(2)
print("\nCluster Summary:\n", cluster_summary)
# Count customers per cluster
print("\nCluster Counts:\n", df["Cluster"].value_counts())