I have a dataframe like this:
col1 col2 col3
1 apple 50
2 apple 25
3 banana 30
4 banana 20
5 apple 100
6 apple 10
I want to get the sum of col3 for unique col2.
For example--
col1 col2 col3
1 apple 185
2 banana 50
