Collapse rows while merging other values

Asked Jun 02 '20 at 01:40

Active Jun 02 '20 at 01:40

Viewed 9 times

I have a dataframe that looks like this:

> head(df)
  Gene                                         Region
1 ANKS1B                      Brain...Hypothalamus
2 ANKS1B                          Brain...Amygdala
5 AXE2 Brain...Nucleus.accumbens..basal.ganglia.
6 AXE2           Brain...Putamen..basal.ganglia.

I want to turn it into this

> head(df)
  Gene                                               Region
1 ANKS1B              Brain...Hypothalamus, Brain...Amygdala
5 AXE2                Brain...Nucleus.accumbens..basal.ganglia., Brain...Putamen..basal.ganglia.

Essentially, I want to collapse rows in which the gene value is the same, and append the Region, separated by a ",". How can I do this? My dataframe is ~50,000 rows.

asked Jun 02 '20 at 01:40

Workhorse

1,500
1
17
27

1

`aggregate(Region~Gene, df, toString)` – Ronak Shah Jun 02 '20 at 01:41
this works but deletes values which are not duplicated. Is there a way to prevent that? – Workhorse Jun 02 '20 at 01:58
1

Yes, probably you need to add those variables in group too. `aggregate(Region~Gene + col1 + col2, df, toString)` If this is not what you want please update your post. – Ronak Shah Jun 02 '20 at 02:00

Collapse rows while merging other values

0 Answers0