[R] constructing a vector from a dataframe and another vector

Jeff Miller jdm at xnet.com
Thu Feb 1 05:22:01 CET 2001

Hi All,

I have a dataframe, divs, that looks like this:

>  divs
          date             ticker         dividend
263     20010322    ADBE      0.025
264     20010628    ADBE      0.025
265     20010927    ADBE      0.025
4308   20010212     ED          0.550
4309   20010514     ED          0.410
5416   20010330     GE          0.137
5417   20010629     GE          0.137
5418   20010928     GE          0.137

and a character vector of symbols that might, for example,  look like this:

syms <- c("ADBE", "AAPL", "ED", "ED", "ADBE")

>From these two data objects, I'd like to construct the following numeric
vector of dividends:

 divvec <-   c( .025, .025, .025, .550, .410, .550, .410, .550, .410, .025,
.025, .025)

In other words, I'd like to construct a numeric vector by replacing each
symbol in syms
by the dividends associated with that symbol in the dataframe divs.

Symbols can occur more than once in syms, and some of the symbols in syms
might not
be in divs.

I see that if each symbol  occurred only once in syms, it's just a matter of
re-ordering divs
and using as.vector(divs[,"dividend"]). I don't see how to proceed when
occur more than once in syms.

Is there a clean way to do this?

Many thanks in advance,

        Jeff Miller

r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch

More information about the R-help mailing list