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.

Join two example sets by relative time value

Thrhw31Thrhw31 Member Posts: 2 Contributor I
edited November 2019 in Help
Hey,

I'm using Rapidminer for mining some time series data. My imported example set contains several regular attributes and one ID-Attribute called "time". Now I have two of those sets and with different frequencies and precisions.

example set 1:    
time Attribute X
0.3 3.1
0.62.8
0.9 2.5
1.22.7
...
example set 2      
time Attribute Y
0.11 250
0.21251
0.31 248
0.41255
0.51 248
0.61253
...
I want to join this sets without getting many missing values. Not like this one:                      
time Attribute x Attribute Y
0.11?250
0.21?251
0.3 3.1 ?
0.31 ?248
0.41?255
0.51 ? 248
0.6 2.8 ?
0.61 ?253
...
It would be nice if RM could link the time-ID with the higher precision to the lower precision (closest match, like 0.31 to 0.3). I cant simple round time, because I dont know the precision of my imported data. Perhaps I can use a groovy/java code-snipped, but unfortunately I have no experience with java programming. Every kind of help would be nice :)

greetings from germany
Thilo

EDIT:
My solution (for now) is
- round the attribute time (two decimal places) of all example sets
- use join to merge the sets
Problem occur if my example set have more than 2 relevant decimal places, like  0.111, 0.112 , 0.113 ... 
That's why I'm searching for an alternative solution
Tagged:

Answers

Sign In or Register to comment.