0

I have following table:

  id  Key  series_no
  0    B      a3
  1    B      t7
  2    A      u3
  3    A      p8
  2    A      7u
  1    B      zz

I would like to perform count function at column Key that will groupby id column. Below is my expected output

  id  Key  series_no   count
  0    B      a3        1
  1    B      t7        2
  2    A      u3        2
  3    A      p8        1
  2    A      7u        2
  1    B      zz        2

I have try below code but does not work for me:

 df["count"]=df["Key"].groupby(["id","Key"]).count()

Anyone have ideas?

Shi Jie Tio
  • 2,479
  • 5
  • 24
  • 41

0 Answers0