[R] Small vector into large data frame

[Adams, Jean]

Use the p_f numbers as an "index" of spot$pxlast.  Suppose your data frame
is called mydata,

mydata$newvar <- spot$pxlast[mydata$p_f]

Jean

On Fri, Nov 14, 2014 at 8:48 AM, Francesca Pancotto <
francesca.pancotto at unimore.it> wrote:

> Dear Contributors
> I seem not to get the general rule applying to the use of loops.
> I need some help. I have a database in which i need to generate a variable
> according to the following rule.
>
>
> This is the database head
>
>       bank_name       date px_last       Q_Y p_made p_for p_m p_f
> aba.1       ABA 2006-10-24    1.28 p406-q406    406   406   1   1
> aba.2       ABA 2006-11-30    1.31 p406-q406    406   406   1   1
> aba.3       ABA 2006-10-24    1.29 p406-q107    406   107   1   2
> aba.4       ABA 2006-11-30    1.33 p406-q107    406   107   1   2
> aba.5       ABA 2006-10-24    1.31 p406-q207    406   207   1   3
> aba.6       ABA 2006-11-30    1.35 p406-q207    406   207   1   3
>
>
> the variable p_f takes values from 1 to 19 in a non regular way.
>
> then I have a vector of 19 elements
>
> > spot$pxlast
>  [1] 1.32 1.34 1.35 1.43 1.46 1.58 1.58 1.41 1.40 1.33 1.40 1.46 1.43 1.35
> 1.22 1.36 1.34 1.42 1.42
>
> I need to create a variable to attach to the data frame which is composed
> of 11500 rows that takes values
> 1.32 when p_f==1
> 1.34 when p_f==2
>
> It seems so easy but I cannot find a way to do it in an efficient way.
> Thanks in advance for any help.
>
>
>
> Francesca
>
>
>
>         [[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.
>

	[[alternative HTML version deleted]]