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: 662 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
  • 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,195 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.