Question: (Closed) Merging data coloum wise in R
0
gravatar for David_emir
13 months ago by
David_emir310
India
David_emir310 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 • 645 views
ADD COMMENTlink modified 6 months ago by ewre210 • written 13 months ago by David_emir310
3

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

ADD REPLYlink written 13 months ago by Devon Ryan88k

Run ?cbind and look at the examples.

ADD REPLYlink written 13 months ago by Alex Reynolds27k

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 6 months ago by RamRS20k
3
gravatar for biplab
13 months ago by
biplab70
University of California, Davis
biplab70 wrote:

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

ADD COMMENTlink written 13 months ago by biplab70
0
gravatar for pfs
13 months ago by
pfs250
USA/Boston
pfs250 wrote:

Look into the merge command.

ADD COMMENTlink written 13 months ago by pfs250
0
gravatar for ewre
6 months ago by
ewre210
United States
ewre210 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 6 months ago by ewre210
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: 1241 users visited in the last hour