🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How to invert the order of data?

User: "DeniKatsman"
New Altair Community Member
Updated by Jocelyn
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

Sort by:
1 - 5 of 51
    User: "varunm1"
    New Altair Community Member
    Accepted Answer
    Updated by 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
    User: "DeniKatsman"
    New Altair Community Member
    OP
    Is there any chance you could explain to me how to actually do it in a couple of words?
    User: "DeniKatsman"
    New Altair Community Member
    OP
    nvm, the pictures only showed up now for some reason, thank you!
    User: "varunm1"
    New Altair Community Member
    Accepted Answer
    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.
    User: "DeniKatsman"
    New Altair Community Member
    OP
    Thank you very much