How can I add str after specific row in R

Question

I have a list of protein of fruit fly and its ortholog protein of silkworm, they are in a 2031*2 data frame, now I have another list which is some of the protein presented above and it’s gene name ,how do I add another column in the first data frame, and place the gene name of that protein after it according to the second list. For example

List1:
1  a
2  b
3  c
List2:
A  a
C  c
After opration
1  a  A
2  b  
3  c  C

dy_by · Answer 1 · 2021-12-07T14:02:49.217

0

just join frames using dplyr

df1 <- data.frame(df1colname1 = 1:3,
                  df1colname2 = c('a','b', 'c'))
df2 <- data.frame(df2colname1 = c('A', 'C'),
                  df2colname2 = c('a', 'c'))

library(dplyr)
df.after.opration <- inner_join(df1, df2, by = c('df1colname2' = 'df2colname2'))

out

  df1colname1 df1colname2 df2colname1
1           1           a           A
2           3           c           C

if you want to keep all df1 rows use left_join

df.after.opration <- left_join(df1, df2, by = c('df1colname2' = 'df2colname2'))

out

  df1colname1 df1colname2 df2colname1
1           1           a           A
2           2           b        <NA>
3           3           c           C

edited Dec 07 '21 at 14:02

answered Dec 07 '21 at 12:29

dy_by

1,061
1
4
13

Thanks a lot, I'll try – 程劲韬 Dec 07 '21 at 13:45
I got problem like this > join_Ortho <- left_join(Orthopair, convert, by= c('Orthopair."Dro"' = 'convert."V2"')) 错误: Join columns must be present in data. x Problem with `Orthopair."Dro"`. – 程劲韬 Dec 07 '21 at 13:52
is some code wrong – 程劲韬 Dec 07 '21 at 13:53
1

sorry , my misunderstanding ,i got it right,thx – 程劲韬 Dec 07 '21 at 13:59

How can I add str after specific row in R

1 Answers1