Python: Hvplot negative values coloring

Question

I try to do interactive bar chart with hvplot, but I would like to color negative values.

I tried using cmap but it colors positives values negatively too.

Answer 1

You can use a compositional HoloView plot for this.

plot1 = df[df['Results']>0].hvplot.bar(y='Results')
plot2 = df[df['Results']<0].hvplot.bar(y='Results')

plot1*plot2

Note: sorry I can't post images directly yet as this is my first entry on stackoverflow, but this link will show you the plot result https://i.stack.imgur.com/bnoFg.png

Here the full code below, you can adapt it to your dataframe :

# create a dataframe with column 'Name' as index
dict = {'Name':["Rick", "Sam", "Kelly", "Al"],
        'Results':[-90, +40, +80, -28]}

df = pd.DataFrame(dict)
df.index=df['Name']

# create 2 hvplots: 1 for positive results, and 1 for negative results 
plot1 = df[df['Results']>0].hvplot.bar(y='Results')
plot2 = df[df['Results']<0].hvplot.bar(y='Results')

# layout plot1 and plot2 content on the same frame using a compositional plot 
plot1*plot2