PANDAS - Count and store values with 2 variables columns

i am trying to solve a problem but i even know how to think. I have the output below:

1     JJAT  36.0  2     JJEL  28.5  3     JJEL  36.0  4     JJEL  36.0  5     JJAA  30.0  6     JJEL  36.0  7     JJEL  22.5  

I need to count the respectives numbers, my desired output:

JJAT  36.0  1  JJEL  22.5  1  JJEL  28.5  1  JJEL  36.0  3  JJAA  30.0  1  

the output can be in another format. I tryed groupby but it misses the correlation(name with numbers and counts)

https://stackoverflow.com/questions/67410624/pandas-count-and-store-values-with-2-variables-columns May 06, 2021 at 09:07AM