1
I would like a help to build a distinct (distinct) count of a data frame. Follow the data:
Filial Matrícula Valor
ABC 100 R$ 500,00
XYZ 200 R$ 850,00
XYZ 100 R$ 320,00
JCT 300 R$ 512,00
JCT 300 R$ 98,00
ABC 300 R$ 1.012,00
I would like the R to give me the consolidated showing the distinct count of the column "Registration" as well as the sum of the column "Value". Similar to what the Excel dynamic table already does. The result I want is:
Filial Contagem/Matricula Valor
ABC 2 R$ 1.512,00
JCT 1 R$ 610,00
XYZ 2 R$ 1.170,00
Possible duplicate of Get different values from a column - Data Frame - R Language
– Tomás Barcellos