The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here

How to group a dataset based on an attribute

MahyarMahyar Member Posts: 2 Learner I
in Help
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 Learner I
    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 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.