New to pandas, tried different forums so ending up posting here for help. I have a below dataframe
Dept Faculty CSE AA CSE AB CSE AC CSE AD ECE BA ECE AA ECE BC ECE BD Trying to get something like this, i.e Faculty names along with total count per department
Dept Faculty Count CSE AA 4 AB AC AD ECE BA 4 AA BC BD Trying df.groupby('Dept')[Faculty].count() gives count, but looking for Faculty names actual values column as well along with the count column
Can someone help?
