How can i group a column of a data-frame and count the instance of other related rows making them a column in new data-frame?

Asked Mar 06 '20 at 07:41

Active Mar 06 '20 at 07:41

Viewed 9 times

I have a Dataframe like this.

A     B
dog  yes
cat  yes
dog  no
cat  yes

and I need an output df like this.

A   yes No
dog  1  1
Cat  2  0

asked Mar 06 '20 at 07:41

R.singh

@ChrisA can you help me here? – R.singh Mar 06 '20 at 07:46
1

Try `pd.get_dummies(df, columns=['B'],prefix='',prefix_sep='').groupby('A').sum().reset_index()` – moys Mar 06 '20 at 07:51

0 Answers0