How can i concatinate similar rows in a dataset with matching values of input variables?

Asked Jan 29 '21 at 07:41

Active Jan 29 '21 at 07:45

Viewed 14 times

Consider input dataset as below:

Name	age	skills	certificateid
Axon	23	java	123
Axon	23	R	456
Axon	23	Python	789
Angie	26	R	145
Romeo	30	R	786
Romeo	30	Python	093

My output should be :

Name	age	skills	certificateid
Axon	23,23,23	java,R,Python	123,456,789
Angie	26	R	145
Romeo	30,30	R,Python	786,093

Can you please provide solution for this rowwise?

asked Jan 29 '21 at 07:41

`result<- aggregate(.~Name, data, toString)` – Ronak Shah Jan 29 '21 at 07:45
@Ronak could you please elaborate..This isnt giving me desired output – Globetrotter Sujay Krishna Jan 29 '21 at 08:08
Please read about [how to ask a good question](http://stackoverflow.com/help/how-to-ask) and [how to give a reproducible example](http://stackoverflow.com/questions/5963269). – Ronak Shah Jan 29 '21 at 08:09
My question is clear ...looks like your aren't aware of this. aggregate() isn't a solution for this – Globetrotter Sujay Krishna Jan 29 '21 at 08:11

0 Answers0