How to group by categorical values in pandas dataframe

Question

I have a dataframe like this -

Folder    FileName 
A            1
B            2
C            1

And I want to create one like this, which counts the occurence of each file in each folder -

FileName A B C
   1     1 0 1
   2     0 1 0

Is there an intuitive way to achieve this?

It's `pd.crosstab(df.FileName, df.Folder)` – cs95 Dec 05 '18 at 10:47 — cs95, Dec 05 '18 at 10:47

Mohamed Thasin ah · Answer 1 · 2018-12-05T10:53:26.593

1

try this,

print pd.crosstab(df['Folder'],df['FileName']).T

As @coldspeed suggests,

print pd.crosstab(df['FileName'],df['Folder']) #more convenient way

edited Dec 05 '18 at 10:53

answered Dec 05 '18 at 10:48

Mohamed Thasin ah

To avoid the transpose, switch the arguments. Anyway, this is a pivot problem. – cs95 Dec 05 '18 at 10:50
@coldspeed- you're right, I updated the solution, thanks a lot – Mohamed Thasin ah Dec 05 '18 at 10:54

1 Answers1