Options

K-Means Cluster Analysis with a Date Attribute

HanHan Member Posts: 2 Newbie
in Help
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

  • Options
    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.
  • Options
    MarcoBarradasMarcoBarradas Administrator, Employee, RapidMiner Certified Analyst, Member Posts: 272 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.