Remove rows that contain pipe ( | ) symbol

Asked Dec 07 '17 at 12:22

Active Dec 07 '17 at 12:38

Viewed 42 times

I have to remove rows that contain the pipe symbol.

My Input:

 > gene_anotation   

    probeset_id GeneSymbol Ensembl_gene_id
    17406395            Arfip1            <NA>
    17393207 LOC101056658|Ahcy            <NA>
    17467690             Ptcd3            <NA>
    17400375              Ctss            <NA>

My Expected output:

 > gene_anotation   

    probeset_id GeneSymbol Ensembl_gene_id
    17406395            Arfip1            <NA>
    17467690             Ptcd3            <NA>
    17400375              Ctss            <NA>

I already tried these, but with no results:

gene_anotation[!grepl("|", gene_anotation$GeneSymbol),]

gene_anotation[!gene_anotation$GeneSymbol == "|", ]

edited Dec 07 '17 at 12:38

Sotos

51,121
6
32
66

asked Dec 07 '17 at 12:22

ASF

Have you tried to escape the `|` within `grepl`? Try `grepl("\|", gene_anotation$GeneSymbol)` – LAP Dec 07 '17 at 12:24
2

or rather `grepl("\\|", gene_anotation$GeneSymbol)` – Roland Dec 07 '17 at 12:24
Oops, one backslash got lost. – LAP Dec 07 '17 at 12:25
Yes, the double escape worked! thank you @Roland – ASF Dec 07 '17 at 12:29
3

or better yet, use `fixed = TRUE`, i.e. `grepl("|", gene_anotation$GeneSymbol, fixed = TRUE)` – Sotos Dec 07 '17 at 12:37
stringr + tidyverse approach: `gene_anotation %>% filter(!str_detect(pattern='\\|', string=GeneSymbol))` – Otto Kässi Dec 07 '17 at 13:08

Remove rows that contain pipe ( | ) symbol

0 Answers0