In this assignment use customer_data.csv, you will conduct data mining analysis on customer data which have basic data l

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

In this assignment use customer_data.csv, you will conduct data mining analysis on customer data which have basic data l

Post by answerhappygod »

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.
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply