0

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

out put

anirban karak
  • 732
  • 7
  • 20

0 Answers0