So basically I have a dataframe that looks like this
| location | crime | occurences |
|---|---|---|
| NSW | homicide | 2 |
| NSW | theft | 1 |
| VIC | homicide | 6 |
| VIC | theft | 6 |
| QLD | homicide | 2 |
| QLD | theft | 8 |
| QLD | assault | 3 |
But I need to sum the crimes into one row so it just looks like this
| location | totalCrime |
|---|---|
| NSW | 3 |
| VIC | 12 |
| QLD | 13 |
Sorry if the question isn't clear. Any help is appreciated thanks.
