This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Merging data coloum wise in R

Hello All,

I am using R to merge two different CSV file into one new file. both of them has got gene name (1st column) same and the subsequent columns will be my sample ID, I need the output file as follow'

1st_file.csv

Gene    sample1 sample2 smpleN
a   1   4   7
b   2   5   8
c   3   6   9

2nd_file.csv

Gene    sample3 sample4 smpleN1
a   1   4   7
b   2   5   8
c   3   6   9

I need to have a combined file a

Gene    sample1 sample2 smpleN  sample3 sample4 smpleN1
a   1   4   7   1   4   7
b   2   5   8   2   5   8
c   3   6   9   3   6   9

Please let me know how to get this in R

r csv
• 1,639 views • link
updated by ewre ewre • written by David_emir David_emir

What have you tried? You can generally google for things like this.

• 0 views • link
written by Devon Ryan Devon Ryan

Run ?cbind and look at the examples.

• 0 views • link
written by Alex Reynolds Alex Reynolds

Hello David_emir!

We believe that this post does not fit the main topic of this site.

This is a pure R question. Please search StackOverflow.

For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.

If you disagree please tell us why in a reply below, we'll be happy to talk about it.

Cheers!

• 0 views • link
written by Ram Ram

3 answers

Read both files in R. Then use: merge(file1, file2, by='Gene', all=TRUE)

• 0 views • link
written by biplab biplab

Look into the merge command.

• 0 views • link
written by pfs pfs

inner_join from dplyr package is another option if you want:

library(dplyr);library(readr)
d1 = read_csv("1st_file.csv"); d2=read_csv("2st_file.csv")
d3 = inner_join(d1,d2, by = 'Gene')
• 0 views • link
written by ewre ewre

Log in to answer this question.

More posts like this