Is it possible to sort a data set by 2 variables? And group by 2 variables?
1
Answers
IngoRMAdministrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, Community Manager, RMResearcher, Member, University ProfessorPosts: 1,751 RM Founder
Hi,
in the data views (tables) it is possible to sort according more than one column by pressing the CTRL-key while selecting several of the column headers.
The sorting, grouping, and aggregation operators however do currently only support one column, sorry.
we recently extended the [tt]Aggregation[/tt] operator in so far that it allows grouping by more than one attribute. The parameter [tt]group_by_attributes[/tt] now allows the specification of multiple attributes using regular expressions. However, the extension is at the moment only contained in the RapidMiner developer version which is accessible via CVS and Eclipse. You find an explaination of how to checkout the developer version at
Answers
in the data views (tables) it is possible to sort according more than one column by pressing the CTRL-key while selecting several of the column headers.
The sorting, grouping, and aggregation operators however do currently only support one column, sorry.
Cheers,
Ingo
we recently extended the [tt]Aggregation[/tt] operator in so far that it allows grouping by more than one attribute. The parameter [tt]group_by_attributes[/tt] now allows the specification of multiple attributes using regular expressions. However, the extension is at the moment only contained in the RapidMiner developer version which is accessible via CVS and Eclipse. You find an explaination of how to checkout the developer version at
http://rapid-i.com/content/view/25/48/lang,de/
Regards,
Tobias
This is one of the reasons i am stuck with my delivery, it is not possible in RM to process this way? Its an ETL operation, im generating a KPI.
Dortmund, Germany