Aggregating and plotting Data in Python Dataframe

Question

Suppose I have a Dataframe

Product |   Price
------------------
    A   |   20
    B   |   10
    A   |   10
    B   |   15
    A   |

How should I get the aggregated average values (excluding null values) and plot a graph.

A   | 15
B   | 12.5

So I would plot a graph for this table. I have though of using groupby but not sure how it would work for this scenarios.

Bubble Bubble Bubble Gut · Accepted Answer · 2017-06-15 20:06:12Z

1

Yes, you can use groupby and create a barplot after that:

import seaborn as sns

p_df = df.groupby('Product', as_index=False)['Price'].agg({'Avg':np.mean})

#barplot with seaborn
sns.barplot(p_df.Product, p_df.Avg)

answered Jun 15, 2017 at 20:06

Bubble Bubble Bubble Gut

3,37617 silver badges30 bronze badges

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

Comments

Ankan Roy · Accepted Answer · 2017-06-15 20:08:30Z

0

you can do groupby in the dataframe by

#lets suppose your dataframe is df
df.groupby('product').mean()

this will return you a new data frame

answered Jun 15, 2017 at 20:08

Ankan Roy

176 bronze badges

Collectives™ on Stack Overflow

Aggregating and plotting Data in Python Dataframe

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