In this assignment use customer_data.csv, you will conduct data mining analysis on customer data which have basic data l
Posted: Sat May 14, 2022 6:54 pm
In this assignment use customer_data.csv,
you will conduct data mining analysis on customer data which have
basic data like age, gender, annual income in k$ and spending
score. The goal of this assignment is to identify customer cluster
'segments' using K-Means Clustering in order to gain insight which
customers segments should the company target for marketing.
1. Join the X_pca and cust_km_output into one data
frame X_pca_df and name the predicted column as
'cluster'
2. Run the pair plot on X_pca_df, color the data points by their
clusters and interpret the plot.
3.Join the X_pca_df with the original data
frame customers_df and plot a scatter plot of
Income vs Spending and color the data points by their clusters.
Discuss the plot results.
4.Create a summary table (sample below) and fill the value with
the median value for each group.
Hint: Use groupby function.
Using Python please.
You can use ANY datatset. Does not matter.
you will conduct data mining analysis on customer data which have
basic data like age, gender, annual income in k$ and spending
score. The goal of this assignment is to identify customer cluster
'segments' using K-Means Clustering in order to gain insight which
customers segments should the company target for marketing.
1. Join the X_pca and cust_km_output into one data
frame X_pca_df and name the predicted column as
'cluster'
2. Run the pair plot on X_pca_df, color the data points by their
clusters and interpret the plot.
3.Join the X_pca_df with the original data
frame customers_df and plot a scatter plot of
Income vs Spending and color the data points by their clusters.
Discuss the plot results.
4.Create a summary table (sample below) and fill the value with
the median value for each group.
Hint: Use groupby function.
Using Python please.
You can use ANY datatset. Does not matter.