Altair RISE

A program to recognize and reward our most engaged community members

Nominate Yourself Now!

How to invert the order of data?

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.

Find more posts tagged with

AI Studio

Data Sets

Data Import

Accepted answers

varunm1

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.

Thanks

varunm1

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.

Sorting.rmp

All comments

varunm1

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.

Thanks

DeniKatsman

Is there any chance you could explain to me how to actually do it in a couple of words?

DeniKatsman

nvm, the pictures only showed up now for some reason, thank you!

varunm1

Sorting.rmp

DeniKatsman

Thank you very much