How to make a plotly bar graph with the correct value count with python?

Question

data looks like this

A	label
string	negative
string	negative
string	negative
string	positive
string	positive
string	negative
string	positive

I want to make a simple plotly bar chart showing two bars - the count of positive and the count of negative, next to each other, blue and red.

If I do this

fig = px.bar(df, x=df["label"])

then I get this (btw do you know why the colors are muted out of nowhere?):

When I hover it says "count = 1 " I want it to say the actual count.. and I want to make the negative bar red. How do I do that?

See plotly color sequencing for details.

Kosmos
– Kosmos

2021-10-29 20:29:02 +00:00
Commented Oct 29, 2021 at 20:29 — Kosmos
– Kosmos, Commented Oct 29, 2021 at 20:29

Rob Raymond · Accepted Answer · 2021-10-29 21:48:57Z

1

plotly has histogram chart type. https://plotly.com/python/histograms/

import io
import pandas as pd
import plotly.express as px

df = pd.read_csv(io.StringIO("""A,label
string,negative
string,negative
string,negative
string,positive
string,positive
string,negative
string,positive"""))

px.histogram(df, x="label", color="label", color_discrete_sequence=["red","blue"])

answered Oct 29, 2021 at 21:48

Rob Raymond

31.5k3 gold badges19 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Kosmos · Accepted Answer · 2021-10-29 20:27:24Z

1

Do groupby and aggregate with count to get a new DataFrame with the count for the two classes under label:

fig = px.bar(df.groupby([‘a’]).count(),x=‘label’,color =‘label’, color_discrete_sequence=[‘blue’,’red’])

edited Oct 29, 2021 at 20:27

answered Oct 29, 2021 at 20:19

Kosmos

5173 silver badges14 bronze badges

Collectives™ on Stack Overflow

How to make a plotly bar graph with the correct value count with python?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related