[R] create a new data frame after comparing two columns of the previous data frame

David Winsemius dwinsemius at comcast.net
Tue Jun 28 01:26:56 CEST 2011


On Jun 27, 2011, at 6:56 PM, jim holtman wrote:

> Use "&" instead of "&&"
>

Yes, and don't forget the comma!

--  
David.
> On Mon, Jun 27, 2011 at 6:01 PM, Nanami 13
> <deconstructed.morning at gmail.com> wrote:
>> Hi everyone,
>>
>> I am trying to find a way to filter a table; If I am given for  
>> example the
>> following table:
>>> head(intra)
>>   chr miRNA   start     end strand              ACC              
>> hsa_ID
>> region region_start region_end   gene_id transcrip_id
>> 1 chr1 miRNA 1102484 1102578      + ACC="MI0000342"; ID="hsa- 
>> mir-200b";
>> exon      1102484    1102578 NR_029639    NR_029639
>> 2 chr1 miRNA 1103243 1103332      + ACC="MI0000737"; ID="hsa- 
>> mir-200a";
>> exon      1103243    1103332 NR_029834    NR_029834
>> 3 chr1 miRNA 1104385 1104467      + ACC="MI0001641";  ID="hsa- 
>> mir-429";
>> exon      1104385    1104467 NR_029957    NR_029957
>> 4 chr1 miRNA 3044539 3044599      + ACC="MI0015861"; ID="hsa- 
>> mir-4251";
>> exon      3044539    3044599 NR_036215    NR_036215
>> 5 chr1 miRNA 3477260 3477354      - ACC="MI0003556"; ID="hsa- 
>> mir-551a";
>> exon      3477260    3477354 NR_030277    NR_030277
>> 6 chr1 miRNA 6489894 6489956      - ACC="MI0015864"; ID="hsa- 
>> mir-4252";
>> exon      6489894    6489956 NR_036218    NR_036218
>>
>> I would only like to keep in the table the rows that have intra 
>> $start !=
>> intra$region_start and intra$end != intra$region_end.
>> I've tried using this but I get the following error:
>>
>>
>>> intra<- intra[(intra$start != intra$region_start )&&(intra$end !=
>> intra$region_end)]
>>> head(intra)
>> data frame with 0 columns and 6 rows
>>
>> Thank you,
>>
>> best,
>> Nanami
>>
>>        [[alternative HTML version deleted]]
>>
>> ______________________________________________
>> R-help at 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.
>>
>
>
>
> -- 
> Jim Holtman
> Data Munger Guru
>
> What is the problem that you are trying to solve?
>
> ______________________________________________
> R-help at 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.

David Winsemius, MD
West Hartford, CT



More information about the R-help mailing list