[FIXED] Pandas: seaborn countplot from several columns

Issue

I have a dataframe with several categorical columns. I know how to do countplot which routinly plots ONE column. Q: how to plot maximum count from ALL columns in one plot?

here is an exemplary dataframe to clarify the question:

import pandas as pd
import numpy as np
import seaborn as sns

testdf=pd.DataFrame(({   'Ahome' :   pd.Categorical(["home"]*10),
                         'Bsearch' : pd.Categorical(["search"]*8 + ["NO"]*2),
                          'Cbuy' : pd.Categorical(["buy"]*5 + ["NO"]*5),
                          'Dcheck' : pd.Categorical(["check"]*3 + ["NO"]*7),
                      
                     
                     } ))
testdf.head(10)
sns.countplot(data=testdf,x='Bsearch');

The last line is just using normal countplot for one column. I'd like to have the columns category (home,search,buy and check) in x-axis and their frequency in y-axis.

Solution

You need to use countplot as below:

df = pd.melt(testdf)
sns.countplot(data=df.loc[df['value']!="NO"], x='variable', hue='value')

Output:

Answered By - harvpan