Due to recent updates, all users are required to create an Altair One account to login to the RapidMiner community. Click the Register button to create your account using the same email that you have previously used to login to the RapidMiner community. This will ensure that any previously created content will be synced to your Altair One account. Once you login, you will be asked to provide a username that identifies you to other Community users. Email us at Community with questions.
"Concatenating text fields over a time period"
Contributor I
Hi all,
I've examples from a database with two attributes- a 'data_time' and a 'text'. I'm trying to aggregate all examples from the same day into a single example, so what I want to do is concatenate their text fields and set the Time field to the beginning of the day (actually i'd like to be more general and do it over any period, but the day will do for now!)
For example, the two examples
Cheers!
I've examples from a database with two attributes- a 'data_time' and a 'text'. I'm trying to aggregate all examples from the same day into a single example, so what I want to do is concatenate their text fields and set the Time field to the beginning of the day (actually i'd like to be more general and do it over any period, but the day will do for now!)
For example, the two examples
would be concatenated into a single one:
date_time | text
-----------------------------------
01/16/2011 23:09:34 | "foo foo"
01/16/2011 10:05:25 | "bar bar"
I'm also turning the examples into word vectors with "Process Documents from Data", so I think I can use the Aggregate operator after that, but I can't figure out how.
date_time | text
-----------------------------------
01/16/2011 00:00:00 | "foo foo bar bar"
Cheers!
Tagged:
0
Answers
Look at this process: http://www.myexperiment.org/workflows/1568.html
I think it's doing almost what you want to do.
RicharD.