add sum of two columns as new column r code example

Example: r sum based on two columns

aggregate(x$Frequency, by=list(Category=x$Category), FUN=sum)
  Category  x
1    First 30
2   Second  5
3    Third 34