Dear all,
I have one problem and did not find any solution.Please I want your help.
I have two data frames and I want to concatenate them.But the thing is-
two data frames are like this-
V1 V2 A C G T
10 135344109 0 0 1 0
10 135344110 0 1 0 0
10 135344111 0 0 1 0
10 135344112 0 0 1 0
10 135344113 0 0 1 0
10 135344114 1 0 0 0
10 135344115 1 0 0 0
10 135344116 0 0 0 1
10 135344117 0 1 0 0
10 135344118 0 0 0 1
second data frame-
V1 V2 A C G T
10 135344111 1 0 1 0
10 135344113 0 0 1 0
10 135344109 0 3 1 0
10 135344114 1 0 0 0
10 145344115 1 0 0 0
10 135344116 1 0 0 1
10 132344117 0 1 0 0
10 135344118 0 0 0 1
10 135344110 0 1 0 0
now i have to create a new data frame which has insert column 3,4,5 and 6 of
second data frame in first data frame if the value in second column is same in
both the data frames (values in V2 column).So the output(new data frame) should
be-
V1 V2 A C G T A C G
T
10 135344109 0 0 1 0 0 3 1 0
10 135344110 0 1 0 0 0 1 0 0
10 135344111 0 0 1 0 1 0 1 0
10 135344113 0 0 1 0 0 0 1 0
10 135344114 1 0 0 0 1 0 0 0
10 135344116 0 0 0 1 1 0 0
1
10 135344118 0 0 0 1 0 0 0
1
I f you see the output, second column values-
V2
135344109
135344110
135344111
135344113
135344114
135344116
135344118
these values are common in both input dataframes.
Thanking you,
Warm Regards
Vikas Bansal
Msc Bioinformatics
Kings College London
________________________________________
From: David Winsemius [dwinsem...@comcast.net]
Sent: Monday, July 04, 2011 12:11 AM
To: Bansal, Vikas
Cc: Dennis Murphy; r-help@r-project.org
Subject: Re: [R] For help in R coding
On Jul 3, 2011, at 6:10 PM, Bansal, Vikas wrote:
>
> ________________________________________
> From: David Winsemius [dwinsem...@comcast.net]
> Sent: Sunday, July 03, 2011 7:08 PM
>>
>
> the code is same i just want to add a condition so that it should
> check that if in column 3, the character is A then make number of A
> equal to total number of . and ,
>
> Should I explain better or can you please tell me which thing is not
> clear?
My second posting today had a solution.
>
>>
> --
> David.
>>
>>
>>
>> Can you please help me how to use this if condition in your coding
>> or we can also do it by using some other condition rather than if
>> condition?
>>
>
David Winsemius, MD
West Hartford, CT
______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.
