How to create a grouped bar chart with plotly using an existing dataframe

Question

I currently have an existing dataframe with country, mode of arrival and arrival count. I am hoping to create a grouped bar chart but I only know how to create regular bar charts.

This is the formula I am using for now

trace3 = go.Bar(x=df5['cor'],y=df5['arv_count'], name = 'Total arrival count by country in 2013')
iplot([trace3])

This is how the graph looks like:

I want to group it by mode of arrival. By air, land,sea. @AnkushRasgon — helpless
– helpless, Commented Jul 17, 2019 at 9:19

Shafiqa Iqbal · Accepted Answer · 2019-07-17 05:36:28Z

2

I hope this answers your question.Pandas will show grouped bars by columns. Entries in each row but different columns will constitute a group in the resulting plot. Therefore, you need to do something like,

df5.pivot("cor", "arrival", "arv_count").plot(kind='bar')
plt.show()

answered Jul 17, 2019 at 5:36

Shafiqa Iqbal

1785 bronze badges

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

2 Comments

helpless Over a year ago

An error message of "Index contains duplicate entries, cannot reshape" shows up @Shafiqa Iqbal

Shafiqa Iqbal Over a year ago

You must have index with multiple duplicate values. try this df5.reset_index().pivot("cor", "arrival", "arv_count").plot(kind='bar')

Collectives™ on Stack Overflow

How to create a grouped bar chart with plotly using an existing dataframe

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related