You can, but you would have to convert them to character first. It would be
more sensible to use vector numeric comparisons. I strongly recommend that you
go read "An Introduction to R", since you are asking questions that are
explained there.
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnew...@dcn.davis.ca.us> Basics: ##.#. ##.#. Live Go...
Live: OO#.. Dead: OO#.. Playing
Research Engineer (Solar/Batteries O.O#. #.O#. with
/Software/Embedded Controllers) .OO#. .OO#. rocks...1k
---------------------------------------------------------------------------
Sent from my phone. Please excuse my brevity.
"Bansal, Vikas" <vikas.ban...@kcl.ac.uk> wrote:
Thanks for your reply.
Can I use grep with numbers also?
5961 T 17 0 9
5962 T 17 0 9
5963 A 17 0 9
5964 G 13 0 10
5965 G 13 0 9
5966 G 13 0 13
5967 T 13 0 8
5968 T 13 0 5
5969 A 13 0 13
5970 G 13 0 13
5971 G 13 0 4
5972 G 13 0 13
5973 T 13 0 13
like in 5th column.If I want only rows whose value is more than 10 in 5th
column?
Thanking you,
Warm Regards
Vikas Bansal
Msc Bioinformatics
Kings College London
_____________________________________________
From: Phil Spector [spec...@stat.berkeley.edu]
Sent: Monday, July 25, 2011 12:29 AM
To: Bansal, Vikas
Cc: r-help@r-project.org
Subject: Re: [R] Deleting rows and store the deleted rows in new data frame
There's no need to use sapply or loops with grep -- it's
already vectorized. So you can find the rows you're
interested in with
> wh = grep('^[.,]+$',df[,9])
store them with
> sf = df[wh,]
and delete them with
> df = df[-wh,]
- Phil Spector
Statistical Computing Facility
Department of Statistics
UC Berkeley
spec...@stat.berkeley.edu
On Sun, 24 Jul 2011, Bansal, Vikas wrote:
> Dear all,
>
> I am using grep but I did not understand the problem as I am doing something
> wrong.Please help me.
> I am using this code-
>
> sf=data.frame(sapply(df[],function(x) grep('\\.&\\,', df[,9])))
>
> the thing is i have a data frame(df) like this-
>
>
> 10 135349467 g G 4 0 0 5 ,,,.,
> 10 135349468 t T 2 0 0 5 ,,c.,
> 10 135349469 g G 7 0 0 5 ,,a.,
> 10 135349470 c C 8 0 0 5 ,,,.,
> 10 135349471 a A 10 0 0 5 ,,,.,
> 10 135349472 g G 7 0 0 6 aa,.,,
> 10 135349473 g G 7 0 0 6 ,,c.,,
> 10 135349474 g G 4 0 0 6 ,,,.,,
> 10 135349475 a A 8 0 0 6 ,,,.,,
> 10 135349476 t T 1 0 0 6 g,,.,,
> 10 135349477 a A 7 0 0 6 ,,,.,,
> 10 135349478 a A 11 0 0 6 ,,,.,,
>
> I want to delete those rows which contains only . and , in column 9.
> and i want to store those rows in new data frame sf.
>
> so my output should be-
>
> df
>
>
> 10 135349468 t T 2 0 0 5 ,,c.,
> 10 135349469 g G 7 0 0 5 ,,a.,
> 10 135349472 g G 7 0 0 6 aa,.,,
> 10 135349473 g G 7 0 0 6 ,,c.,,
> 10 135349476 t T 1 0 0 6 g,,.,,
>
>
> sf
>
> 10 135349467 g G 4 0 0 5 ,,,.,
> 10 135349470 c C 8 0 0 5 ,,,.,
> 10 135349471 a A 10 0 0 5 ,,,.,
> 10 135349474 g G 4 0 0 6 ,,,.,,
> 10 135349475 a A 8 0 0 6 ,,,.,,
> 10 135349477 a A 7 0 0 6 ,,,.,,
> 10 135349478 a A 11 0 0 6 ,,,.,,
>
>
>
> Thanking you,
> Warm Regards
> Vikas Bansal
> Msc Bioinformatics
> Kings College London
>_____________________________________________
> 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.
>
_____________________________________________
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.
[[alternative HTML version deleted]]
______________________________________________
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.
