Сross table

gritsay

what i can cross table data in RapidMiner 5. For Example:

Original Table:

date            |  volume 
01.01.2010  |  1
01.01.2010  |  1
01.01.2010  |  1
02.01.2010  |  2
02.01.2010  |  2

Postprocessing table:

date            |  volume 
01.01.2010  |  3
02.01.2010  |  4


which operator to use?

IngoRM

Hi,

there is a process on myExperiment showing how you can do that. Just install the Community Extension (in the Help menu --> "Update RapidMiner...") and activate the myExperiment Browser. Search for the process:

"Cross tabulation via aggregation and pivoting"

and download it. It will show you how you can calculate a cross table (contingency table) with RapidMiner.

More information about the Community Extension can be found in our latest blog entry at

http://rapid-i.com/component/option,com_myblog/show,50-Processes-on-myExperiment.html/Itemid,172/

Cheers,
Ingo

gritsay

Thanks!