I want to show rows as column after the group by in pandas.
import pandas as pd
df1= pd.read_csv('Employee_Attrition.csv')
df4=df1[['BusinessTravel','JobRole']]
print(df4.head())
df4grouped = df4.groupby('BusinessTravel').count()
print(df4grouped)
jobRolegroped = df4.groupby('JobRole').count()
jobRolegroped
I want the output as below
**BusinessTravel**     **Sales Representative** **Research Director** ...other category    
Non-Travel                0                           1               ... some number   
Travel_Frequently         2                           3               ... some number
Travel_Rarely             10                          5               ... some number

