Calculating the frequency of each row in Pandas DataFrame

Question

Suppose I have given datasets:

Sr.No|Query
-----
 1.   a
 2.   a
 3.   b
 4.   b
 5.   a

I want the following result :

Sr.No | Query | Frequency
1.    a         3
2.    a         3
3.    b         2
4.    b         2
5.    a         3

Please note that the duplicates should not be removed.

Can you explain how you arrive at the frequency here? also please edit your question so it looks presentable — EdChum
– EdChum, Commented Aug 3, 2016 at 11:12

jezrael · Accepted Answer · 2016-08-03 11:18:34Z

1

You can use transform with size:

df['Frequency']= df.groupby('Query')['Query'].transform('size')
print (df)
   Sr.No Query  Frequency
0    1.0     a          3
1    2.0     a          3
2    3.0     b          2
3    4.0     b          2
4    5.0     a          3

edited Aug 3, 2016 at 11:18

answered Aug 3, 2016 at 11:13

jezrael

868k103 gold badges1.4k silver badges1.3k bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Calculating the frequency of each row in Pandas DataFrame

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related