Question: (Closed) Merging data coloum wise in R
1
gravatar for David_emir
23 months ago by
David_emir360
India
David_emir360 wrote:

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

csv R • 946 views
ADD COMMENTlink modified 16 months ago by ewre220 • written 23 months ago by David_emir360
3

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

ADD REPLYlink written 23 months ago by Devon Ryan93k

Run ?cbind and look at the examples.

ADD REPLYlink written 23 months ago by Alex Reynolds29k

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!

ADD REPLYlink written 16 months ago by RamRS25k
3
gravatar for biplab
23 months ago by
biplab100
University of California, Davis
biplab100 wrote:

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

ADD COMMENTlink written 23 months ago by biplab100
0
gravatar for pfs
23 months ago by
pfs270
USA/Boston
pfs270 wrote:

Look into the merge command.

ADD COMMENTlink written 23 months ago by pfs270
0
gravatar for ewre
16 months ago by
ewre220
United States
ewre220 wrote:

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')
ADD COMMENTlink written 16 months ago by ewre220
Please log in to add an answer.
The thread is closed. No new answers may be added.

Help
Access

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.
Powered by Biostar version 2.3.0
Traffic: 1694 users visited in the last hour