How to invert the order of data?
DeniKatsman
Member Posts: 4 
Contributor I
in Help
Hello,
I am sure this is quite simple but I just do not know how to do it because I am completely new to RapidMiner. This is a graph of XRP (digital asset) price: ( I was not allowed to post it because I am a new account ) But basically:
The CSV file that I downloaded goes in the DESCENDING ORDER (from 2018 down to 2013) and I need it to be in the ASCENDING order for the obvious reason that this graph reads from right to left (and I obviously want it to read from left to right). I tried tweaking the CSV file by creating a column besides with the multiple series and then sorting it, but after I save it, it does not work properly anymore. Either way I would like to know a solution in RapidMiner. Thank you. All the settings and XML are completely default.
I am sure this is quite simple but I just do not know how to do it because I am completely new to RapidMiner. This is a graph of XRP (digital asset) price: ( I was not allowed to post it because I am a new account ) But basically:
The CSV file that I downloaded goes in the DESCENDING ORDER (from 2018 down to 2013) and I need it to be in the ASCENDING order for the obvious reason that this graph reads from right to left (and I obviously want it to read from left to right). I tried tweaking the CSV file by creating a column besides with the multiple series and then sorting it, but after I save it, it does not work properly anymore. Either way I would like to know a solution in RapidMiner. Thank you. All the settings and XML are completely default.
Tagged:
0
Best Answers
-
varunm1
Moderator, Member Posts: 1,207 
Unicorn
The simple thing is to use generate ID operator after your dataset and then use sort operator (based on id column) to get in whichever type you want.
ThanksRegards,
Varun
https://www.varunmandalapu.com/Be Safe. Follow precautions and Maintain Social Distancing
5 -
varunm1
Moderator, Member Posts: 1,207 Unicorn
I attached rapidminer process in this post. So the below process is for Titanic dataset which is available in RM. I attached operator Generate ID which will create ID values (1,2,3,...) for all samples. The I attach sort operator in the parameters I provide attribute name as "id" and can sort either in increasing or decreasing order.
To use this process, you need to download the file in this post and go to FILE --> Import Process in RM and point this to the below file in your PC.
Regards,
Varun
https://www.varunmandalapu.com/Be Safe. Follow precautions and Maintain Social Distancing
6
Answers