A leading bank wants to develop a customer segmentation to give promotional offers to its customers. They collected a sample that summarizes the activities of users during the past few months. perform segmentation based on credit card usage.

a ) Hierarchical clustering on scaled data.

b) what is number of optimum clusters

c) Determine optimum clusters using K-Means clustering on scaled data.

d)Describe cluster profiles for the clusters defined.

Dataset for Problem can be downloaded from : https://drive.google.com/file/d/1-kjC2n40HTJtyGHEj4LMx1qdTcUJzP1S/view?usp=sharing

DataDictionaryforMarketSegmentation:

1. spending: Amount spent by the customer per month (in 1000s)
2. advance_payments: Amount paid by the customer in advance by cash (in 100s)
3. probability_of_full_payment: Probability of payment done in full by the customer to the bank
4. current_balance: Balance amount left in the account to make purchases (in 1000s)
5. credit_limit: Limit of the amount in credit card (10000s)
6. min_payment_amt : minimum paid by the customer while making payments for purchases made monthly (in 100s)
7. max_spent_in_single_shopping: Maximum amount spent in one purchase (in 1000s)