How can I do a time series graph with several attributes in the y axis for several domain dimension?

santosj

Hi,

I am using Rapid Miner for my master thesis project and I am right now doing the data exploration of my data. I want to do a specific time series graph but I do not know how to do it in Rapid Miner. I have been searching on the internet for several days on this matter but I cannot find anything..I hope you can help me! I would be very thankful.

The graph that I want to do is a time series graph that has as follows: In the x axis a number of days as an index and in the y axis, several attributes. So far so good. My problem is that I do not know how to plot each attribute that I have in the y axis at a time span in days that I have saved in several attributes. The aim of the series graph that I want to do is to view the evolution of a set of parameters through time were I have the values of all these parameters as well as when they were measured in days. Thank you very much!

lionelderkrikor

Hi again@santosj,

Interesting problem !

If I good understand, one way to perform what you want to do is to use theDe-Pivotoperator.

By using this operator, you obtain the Blood Pressure according to the time like this :

and then you can plot these data like this :

You can find the process here :

<连接摇来摇去m_op="Read Excel" from_port="output" to_op="Generate Attributes" to_port="example set input"/>
<连接摇来摇去m_op="Generate Attributes" from_port="example set output" to_op="Select Attributes" to_port="example set input"/>
<连接摇来摇去m_op="Select Attributes" from_port="example set output" to_op="De-Pivot" to_port="example set input"/>
<连接摇来摇去m_op="De-Pivot" from_port="example set output" to_port="result 1"/>

and the Excel example set (from your partial dataset) here :

https://drive.google.com/open?id=1ZKmTSpj_jHV1rtaxBBCgpgwCIF-zl4zP

I hope it helps,

Regards,

Lionel

lionelderkrikor

Hi@santosj,

Can you share your dataset, please ?

Regards,

Lionel

lionelderkrikor

Hi again@santosj,

1.Go to theResultswindows (after running your process)

2. Go to theChartsPanel

3. SelectSeriesasChart Style(if RapidMiner has not set automatically)

4. Set yourIndexDimension(your time attibute) and Plot Series(the attribute you want to display in your chart). (Ctrtl + select the attribute you want to display).

Here the screenshot to help you :

Hope it helps,

Regards,

Lionel

santosj

Thank you for your reply!

I, unfortunately, cannot share the data that I have but I send you a similar dataset to better convey my question.

在附加的Excel文件可以看到患者that have carried out a treatment to lower their blood pressure. What I would like to do is to plot these blood pressures in a time series graph for each time span on days (Date of the 2 months measurement - Treatment Date), (Date of the 3 months measurement - Treatment Date) and (Date of the 6 months measurement - Treatment Date) to see graphically if the patients improved after the treatment they have carried out to lower their blood pressure. I have already calculated these time spans in the Rapid Miner Platform with the attribute generator operator. I could also use as a domain graph the indication of "2 months", "3 months" and "6 months", that I do not know how to do it also, but I taught to use the time span because I would like to afterward add to the graph the standard deviations of the time span.

Thank you

santosj

Thank you for your help,

Unfortunately, my difficulty lays on the index because I need to represent the several time spans in days that I have mentioned before...Do you have any clue on how I could do it?

Thank you for your time,

santosj

Wow! I am impressed!

It is exactly that. You solved my problem! I´ve already tested it and it works!

I am very grateful...Thank you very much!

Jud

lionelderkrikor

You're welcome Jud.

Good luck for your master thesis project.

Regards,

Lionel