[R] Removing rows if certain elements are found in character string
MacQueen, Don
macqueen1 at llnl.gov
Thu Jul 5 20:13:35 CEST 2012
Perhaps I've missed something, but if it's really true that the goal is to
remove rows if the first non-zero element is "D" or "d", then how about
this:
tmp <- gsub('0','',df$ch)
first <- substr(tmp,1,1)
subset(df, tolower(first) != 'd')
and of course it could be rolled up into a single expression, but I wrote
it in several steps to make it easy to follow. No need to wrap one's brain
around regular expressions (which is hard for me!)
-Don
--
Don MacQueen
Lawrence Livermore National Laboratory
7000 East Ave., L-627
Livermore, CA 94550
925-423-1062
On 7/2/12 3:48 PM, "Claudia Penaloza" <claudiapenaloza at gmail.com> wrote:
>I would like to remove rows from the following data frame (df) if there
>are
>only two specific elements found in the df$ch character string (I want to
>remove rows with only "0" & "D" or "0" & "d"). Alternatively, I would like
>to remove rows if the first non-zero element is "D" or "d".
>
>
> ch count
>1 0000000000D0000000000000000000000000000000000000 0.007368;
>2 0000000000d0000000000000000000000000000000000000 0.002456;
>3 000000000T00000000000000000000000000000000000000 0.007368;
>4 000000000TD0000000000000000000000000000000000000 0.007368;
>5 000000000T00000000000000000000000000000000000000 0.002456;
>6 000000000Td0000000000000000000000000000000000000 0.002456;
>7 00000000T000000000000000000000000000000000000000 0.007368;
>8 00000000T0D0000000000000000000000000000000000000 0.007368;
>9 00000000T000000000000000000000000000000000000000 0.002456;
>10 00000000T0d0000000000000000000000000000000000000 0.002456;
>
>
>I tried the following but it doesn't work if there is more than one
>character per string:
>
>>df <- df[!df$ch %in% c("0","D"),]
>>df <- df[!df$ch %in% c("0","d"),]
>
>Any help greatly appreciated,
>Claudia
>
> [[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.
More information about the R-help
mailing list