Plotting pandas dataframe series with seaborn

Question

I am new to Seaborn and Pandas

My DataFrame:

df

Search                      A       B       C       D           Language
Best TV for netflix         51      7.5     25.7    TV          en
Best TV for firestick       42      6.3     34.77   TV          es
TV cheap                    32      2.7     69.33   Cheap       en
Cheap TV                    44      14.7    74.14   Best        fr
...

I am learning to plot data with seaborn.

My goal is to be able to plot:

Occurence count per column, for example bar or any other plot where the values would be the value_counts() of the column
The maximum values per column, for example - maximum values of columns A and B per category Language
Sum of column A per category D

Should I first do calculations to get the numbers I need for the plots or are there more subtle ways of plotting pandas dataframes with seaborn as per seaborn documentation it is said that it was made to work well with pandas dataframes.

What I've tried

count = df['Language'].value_counts()
head = count.head(5)
sns.barplot(x=head, y=count, data=df)
plt.show()

Which plots the top5 language categories. But I don't know how to plot the second and third points in my goal section.

Thank you for your suggestions.

ignoring_gravity · Accepted Answer · 2020-01-06 13:57:46Z

1

Maximum values per language:

grouped_data = df.groupby('Language')[['A', 'B']].max().reset_index()
sns.barplot(x='Language', y='A', data=grouped_data)

sns.barplot(x='Language', y='B', data=grouped_data)

Sum of column A per category D:

sns.barplot(x='D', y='A', data=df.groupby('D').A.sum().reset_index())

answered Jan 6, 2020 at 13:57

ignoring_gravity

11.1k7 gold badges45 silver badges99 bronze badges

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

2 Comments

Jonas Palačionis Over a year ago

And saving the outputs is plt.savefig('name.png') or sns_plot.savefig("output.png")?

ignoring_gravity Over a year ago

@JonasPalačionis If you run ax = sns.barplot(x='Language', y='A', data=grouped_data) then you can save it with ax.get_figure().savefig('name.png')

Collectives™ on Stack Overflow

Plotting pandas dataframe series with seaborn

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