[R] Select rows from Data Frame with conditions
Jeff Newmiller
jdnewmil at dcn.davis.CA.us
Fri Mar 8 03:24:02 CET 2013
Something along the lines of
top100 <- A[match(B,A[,1]),]
Please provide R code with sample data and desired output. See http://stackoverflow.com/questions/5963269/how-to-make-a-great-r-reproducible-example
---------------------------------------------------------------------------
Jeff Newmiller The ..... ..... Go Live...
DCN:<jdnewmil at 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.
Sachinthaka Abeywardana <sachin.abeywardana at gmail.com> wrote:
>Hi all,
>
>I have two dataframes. The first (A) contains all the stock prices for
>today including today. So the first column is the stock Symbol and the
>second column is the stock price. The second (B) is the symbol list in
>the
>top 100 stocks.
>
>I want to pick out from dataframe A only the rows containing the
>symbols
>from B. i.e. something like:
>
> prices <- A[A[,1]==B,2]
>
>is there any way to do this without using a for loop, I have to do this
>365
>times (i.e. for one year).
>
>Thanks,
>Sachin
>
> [[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