I have data frame:
| SRR1 | SRR2 | SRR3 |
|---|---|---|
| NA | RS1 | RS1 |
| RS2 | NA | RS2 |
| RS3 | RS3 | RS3 |
I want to add column ID with data from column SRR1,2,3:
| ID | :---- |
|---|---|
| RS1 | :---- |
| RS2 | :---- |
| RS3 | :---- |
Asked
Active
Viewed 11 times
0
-
Try `df %>% mutate(ID = coalesce(SRR1, SRR2, SRR3))` where `df` is your dataframe – Karthik S Apr 02 '21 at 09:02
-
@KarthikS thanks for your answer! It gives me columns "SRR1.ID SRR2.ID ..." – Vik02 Apr 02 '21 at 09:06