RAPIDMINER 9.7 BETA ANNOUNCEMENT

The beta program for the RapidMiner 9.7 release is now available. Lots of amazing new improvements including true version control!

CLICK HERE TO DOWNLOAD

How to group a dataset based on an attribute

MahyarMahyar Member Posts: 2 Newbie
I have a dataset containing two attributes: date time and occupancy number
I want to have the maximum occupancy number in each day( no matter what hour), can anyone help me do this?

Answers

  • kaymankayman Member Posts: 464   Unicorn
    this can be done with the aggregate operator. You select the attribute to group on and you can then aggregate on sum, count, first , last or whatever is required
    Tghadiallymschmitzsgenzer
  • MahyarMahyar Member Posts: 2 Newbie
    I cannot find out how it works. This is my data, I want to know how I can have each day and the maximum occupancy on a new example set
  • lionelderkrikorlionelderkrikor Moderator, RapidMiner Certified Analyst, Member Posts: 1,056   Unicorn
    Hi @Mahyar,

    Within the aggregate operator, You have to set : 
    In aggregation attributes  : 
        - set Occupancy as aggregation attribute  and select maximum as aggregation function.
    In group by attributes
       -  select DateTime

    You can find in attached file a process to help you.

    Regards,

    Lionel



Sign In or Register to comment.