0

I have a dataframe:

data= data.frame( colA = c("house", "dog", "dog", "cat", "table", "table", "table"), colB= (c(1,2,6,3,9,1,7)))

and I would to create a new dataframe with unique elements of column colA and another column with the sums of numbers of colB that have the same element of colA.

Example:

data
   colA colB
1 house    1
2   dog    2
3   dog    6
4   cat    3
5 table    9
6 table    1
7 table    7

new dataframe expected:

data1
   colA colB
1 house    1
2   dog    8
3   cat    3
4 table    17
jonny jeep
  • 383
  • 3
  • 12

0 Answers0