Hi,
Using the iris dataset as an example (a small subset below), I need to aggregate (sum) the Petal.Width for each species:
Petal.Width. Species
0.2 setosa
0.2 setosa
0.2 setosa
1.4 versicolor
1.5 versicolor
1.5 versicolor
To result in:
Species Count
setosa 0.6
versicolor 4.4
I've tried various ways of doing this without success. Does anyone have any ideas?
Many thanks for your help