Secondary y-axis for time series

hvPlot
1

Hi!
I am working with two DataFrames, one storing various power data and on storting temperature data, both with the same DateTime index. From the power DataFrame merged_df and df_OT I would like to create a bokeh plot using hvplot that displays the power and temperature data with two differnent y-axis to be able to better view the variations of the parameter. So far, I have tried differnt solutions with no luck.

So far I have just managed to get a satifying output for the power alone:

bokeh_plot (1)
bokeh_plot (1)770×330 48.2 KB

To getthe output with the temperature on the secondary axis I have tried the following:

# Create two line plots for each y-axis
plot1 = merged_df.hvplot.line(groupby=['index.year', 'index.month', 'index.day'], widget_type='scrubber', widget_location='bottom')
plot2 = df_OT.hvplot.line(groupby=['index.year', 'index.month', 'index.day'], widget_type='scrubber', widget_location='bottom')

# Concatenate the plots vertically
combined_plot = plot1 * plot2

# Set the y-axis options manually
overlay_plot.opts(yaxis='left', yaxis2='right')

# Display the plot
combined_plot

giving an error as follows:

---------------------------------------------------------------------------
TypeError                                 Traceback (most recent call last)
Cell In[17], line 6
      3 plot2 = df_OT.hvplot.line(groupby=['index.year', 'index.month', 'index.day'], widget_type='scrubber', widget_location='bottom')
      5 # Concatenate the plots vertically
----> 6 combined_plot = plot1 * plot2
      8 # Set the y-axis options manually
      9 overlay_plot.opts(yaxis='left', yaxis2='right')

TypeError: unsupported operand type(s) for *: 'Column' and 'Column'

when trying the alternative following option I get a similar error:

plot1 = merged_df.hvplot(groupby=['index.year','index.month','index.day'], widget_type='scrubber', widget_location='bottom').opts(yaxis='left')
plot2 = df_OT.hvplot(groupby=['index.year','index.month','index.day'], widget_type='scrubber', widget_location='bottom').opts(yaxis='right')

# Overlay the two line plots
overlay_plot = plot1 * plot2

# Display the plot
overlay_plot

error

AttributeError: ‘Column’ object has no attribute ‘opts’

Do you see any solution that would help fix that issue?

2

I think hvplot should definitely document this better, but when using widget_type/widget_location, it gets converted into a Panel layout object, namely Column.

So you need to widget, hv_obj = plot1 (maybe reversed) and then multiply the hv_objs
Something like Rasterize displaying nodata missing_value _FillValue for integer (uint16) data - #4 by ahuang11

3

Thank you for your help, it was helpful to highlight the fact that the plots objects I had created were composed of 2 different objects. However when trying to overlay the hv-objs components of the plots there was still an error TypeError: unsupported operand type(s) for *: 'HoloViews' and 'HoloViews'.

I just removed the widget options on both my plots and the code runs, but the output still does not show the plot2 secondary y-axis nor its legend which is annoying.

plot1 = merged_df.hvplot.line(groupby=['index.year', 'index.month', 'index.day']).opts(yaxis='left')
plot2 = df_OT.hvplot.line(groupby=['index.year', 'index.month', 'index.day']).opts(yaxis='right')

overlay = plot1 * plot2
overlay
4

Hi @AFJOOL1,

Have a look for twin_y I think you can hook it in from bokeh, I was just looking and bokeh can now do this be good if this filters through if not already

https://docs.bokeh.org/en/latest/docs/examples/basic/axes/twin_axes.html