How can I make countplot of multiple label with multiple column

Question

Given data like down below

test = pd.DataFrame(np.array([
    ["Yes", "No", "No", "Yes", "Maybe"],
    ["Yes", "Yes", "Yes", "Maybe", "Maybe"],
    ["Maybe", "Yes", "Yes", "No", "No"],
    ["No", "Yes", "Maybe", "No", "No"],
    ["Maybe", "Maybe", "Maybe", "No", "Yes"],
    ])
    ,columns=['a','b','c','d', 'e'])

I want something that looks like image down below.

So column a would have bar graph that has three bar each indicating count of 2 "Yes", 1 "No", 2 "Maybe". And so does the columns remaining.

I tried making new dataframe temp = df.apply(pd.Series.value_counts) and with sns.countplot() but It resulted just 5 bar instead of 3*5 bar.

Please help me to make bar graph that has multilabel from multiple column.

Corralien · Accepted Answer · 2021-11-12 11:56:39Z

2

Use melt:

import pandas as pd
import seaborn as sns
import matplotlib.pyplot as plt

data = {'a': ['Yes', 'Yes', 'Maybe', 'No', 'Maybe'],
        'b': ['No', 'Yes', 'Yes', 'Yes', 'Maybe'],
        'c': ['No', 'Yes', 'Yes', 'Maybe', 'Maybe'],
        'd': ['Yes', 'Maybe', 'No', 'No', 'No'],
        'e': ['Maybe', 'Maybe', 'No', 'No', 'Yes']}

df = pd.DataFrame(data)
df1 = df.melt(var_name='Additional service', value_name='Has service')

sns.countplot(x='Additional service', hue='Has service', data=df1)
plt.show()

answered Nov 12, 2021 at 11:56

Corralien

121k8 gold badges44 silver badges69 bronze badges

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

1 Comment

이가원 Over a year ago

So I didn't need to use value count since count plot itself sum it up for me... How dumb I am... Thanks!!!

Collectives™ on Stack Overflow

How can I make countplot of multiple label with multiple column

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related