pandas groupby error for collection repeated values?

Asked Jun 29 '19 at 06:59

Active Jun 29 '19 at 07:18

Viewed 41 times

I am trying to gather all the repeated values and their count.

My Dataset:

In the above picture suppose fox appears 3 then Fox 3 in that way I want. I tried to use group by but it shows me error of "Sum." something.

studios.groupby(a).value_counts().to_frame('count')

Thanks in advance

asked Jun 29 '19 at 06:59

Yash Choksi

you just want to calculate count of duplicates in studio column ? – tawab_shakeel Jun 29 '19 at 07:00
1

[Please don't post images of code/data (or links to them)](http://meta.stackoverflow.com/questions/285551/why-may-i-not-upload-images-of-code-on-so-when-asking-a-question) – anky Jun 29 '19 at 07:00
@tawab_shakeel That's what I want! – Yash Choksi Jun 29 '19 at 07:06
@anky_91 Thank you for advise I will look forward to it! – Yash Choksi Jun 29 '19 at 07:07
bdw `df['studio_count']=df.studio+' '+df.groupby('studio).studio.transform('size').astype(str)` seems to do your job – anky Jun 29 '19 at 07:12

0 Answers0