Multiple series on y axis; and the possibility of a secondary y axis

46 views
Skip to first unread message

Parikshit Bhinde

unread,
May 2, 2018, 2:13:38 PM5/2/18
to Glue users
Hi,

I have a pandas df called callSeries which has multiple columns. The first column is a time stamp column and the remaining columns are price of various items on those different timestamps. When i add the dataframe using qglue(data1=callSeries) and plot it on a 2D scatter plot, the timestamp column is automatically plotted on the x-axis (which is what i want) and the next column is plotted on the y-axis. I would like to plot the remaining columns on the y-axis as well (it would look like multiple lines on the graph). Also, there is a particular column where the range of values is different from the range of values in the other columns and ideally i would like to plot it using a secondary y-axis if its possible.

Thanks!
Parikshit

Thomas Robitaille

unread,
Jun 6, 2018, 4:27:11 PM6/6/18
to glue...@googlegroups.com
Hi Parikshit,

I apologise for the delay in getting back to you - this isn't possible
at the moment. Your best bet for now would be to develop a very simple
custom viewer here:

http://docs.glueviz.org/en/stable/customizing_guide/custom_viewer.html

based on your specific requirements. Let me know if you give this a
try and have any questions!

Cheers,
Tom
> --
> You received this message because you are subscribed to the Google Groups "Glue users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to glue-viz+u...@googlegroups.com.
> To post to this group, send email to glue...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/glue-viz/c84dabe8-df8c-4708-a08b-bd7473d6bc40%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

Bishara Korkor

unread,
Jun 6, 2018, 4:48:03 PM6/6/18
to glue...@googlegroups.com
Hey all,

Chiming in for a suggestion if you are inclined to use an existing example. You may find some inspiration from the example of the Mario Viewer (see:https://github.com/glue-viz/example_data_viewers). Multiple time series are plotted with a selection tool. Your data representation needs to change a little bit, going from the representation

time, asset1value, asset2value, ..., assetNvalue

to the representation

time, assetvalue, assettype, assetscale

It is a bit redundant, but as long as your dataset isn't too large that example should set you in a good direction. Again, you can use your current representation with a different custom viewer, just offering a starting point if you are inclined to use it. 

Bishara



On Wed, Jun 6, 2018 at 1:26 PM, Thomas Robitaille <thomas.p....@gmail.com> wrote:
Hi Parikshit,

I apologise for the delay in getting back to you - this isn't possible
at the moment. Your best bet for now would be to develop a very simple
custom viewer here:

http://docs.glueviz.org/en/stable/customizing_guide/custom_viewer.html

based on your specific requirements. Let me know if you give this a
try and have any questions!

Cheers,
Tom


On Wed, 2 May 2018 at 19:13, Parikshit Bhinde <parixit...@gmail.com> wrote:
>
> Hi,
>
> I have a pandas df called callSeries which has multiple columns. The first column is a time stamp column and the remaining columns are price of various items on those different timestamps. When i add the dataframe using qglue(data1=callSeries) and plot it on a 2D scatter plot, the timestamp column is automatically plotted on the x-axis (which is what i want) and the next column is plotted on the y-axis. I would like to plot the remaining columns on the y-axis as well (it would look like multiple lines on the graph). Also, there is a particular column where the range of values is different from the range of values in the other columns and ideally i would like to plot it using a secondary y-axis if its possible.
>
> Thanks!
> Parikshit
>
> --
> You received this message because you are subscribed to the Google Groups "Glue users" group.
> To unsubscribe from this group and stop receiving emails from it, send an email to glue-viz+unsubscribe@googlegroups.com.

> To post to this group, send email to glue...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/glue-viz/c84dabe8-df8c-4708-a08b-bd7473d6bc40%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Glue users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to glue-viz+unsubscribe@googlegroups.com.

To post to this group, send email to glue...@googlegroups.com.

Parikshit Bhinde

unread,
Jun 10, 2018, 12:07:32 AM6/10/18
to glue...@googlegroups.com
Thanks Thomas and Bishara! I'll give it a shot and let you guys know how it goes.

Regards,
Parikshit

> To unsubscribe from this group and stop receiving emails from it, send an email to glue-viz+u...@googlegroups.com.

> To post to this group, send email to glue...@googlegroups.com.
> To view this discussion on the web visit https://groups.google.com/d/msgid/glue-viz/c84dabe8-df8c-4708-a08b-bd7473d6bc40%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.

--
You received this message because you are subscribed to the Google Groups "Glue users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to glue-viz+u...@googlegroups.com.

To post to this group, send email to glue...@googlegroups.com.

--
You received this message because you are subscribed to the Google Groups "Glue users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to glue-viz+u...@googlegroups.com.

To post to this group, send email to glue...@googlegroups.com.
Reply all
Reply to author
Forward
0 new messages