K-Means Cluster Analysis with a Date Attribute

HanHan Member Posts: 2 Newbie
I need help doing a cluster analysis with a date attribute. So far, I have my titanic data input, normalized data, date to numerical, and replaced missing values. I am confused about how to run a proper k-means at this point. I have my data files. My data has transaction numbers with repeating values so maybe that is throwing me off? I'm not really skilled at using this software.

Answers

  • HanHan Member Posts: 2 Newbie
    I want to group all sales by customer to show number of days, number of transactions, and total revenue by customer.
  • MarcoBarradasMarcoBarradas Administrator, Employee, RapidMiner Certified Analyst, Member Posts: 271 Unicorn
    Hi @Han

    You are trying to get the aggregates of those values.
    You'll need to use the Aggregate operator.

    Please watch the video it would help you understand how summarize your dataset.Β 

    Aggregations & Joining intro | RapidMiner

Sign In or Register to comment.