Pandas : Get count of repeating column and assign count value in new column

Question

Below is my Data.

CompanyEvents   StartDate:year
Event1              2013
Event1              2013
Event1              2011
Event1              2011
Event1              2012
Event2              2015
Event2              2016
Event2              2016
Event2              2017

I want result is like table below. It should give count of repeating years of same event.

CompanyEvents   StartDate:year  StartDate:year_count
Event1          2013                 2
Event1          2013                 2
Event1          2011                 2
Event1          2011                 2
Event1          2012                 1
Event2          2015                 1
Event2          2013                 1
Event2          2016                 2
Event2          2017                 1
Event3          2011                 1

score 0 · Answer 1 · answered Mar 15 '22 at 05:36

0

There you go, using groupby and transform :

Pandas GroupBy Transform

df['StartDate:year_count'] = df.groupby('StartDate:year')['StartDate:year'].transform('count')

answered Mar 15 '22 at 05:36

Ibrahim Ayoup

377
1
12

Pandas : Get count of repeating column and assign count value in new column

1 Answers1