[R] calculate an value in dependence of another column

[Gerrit Eichner]

Hi, Mat,

e. g., try something like

ORDER$VALUE * c( NY = 3, BER = 2, FRA = 1, WAS = 4)[ ORDER$DESTINY]

  Hth  --  Gerrit

On Fri, 17 Jan 2014, Mat wrote:

> Hello together,
>
> i have a little problem, to create a new column, in a data.frame.
> I know i can calculate one column with as a example 2 like this:
> ORDER$WEIGHT <- ORDER$VALUE * 2
>
> But how can i create the ORDER$WEIGHT with different numbers, like this one.
>
> I have a data.frame like this one:
>
> ORDER   DESTINY    VALUE
> A         NY          100
> B         BER          10
> C         FRA         100
> D         WAS         50
>
> I want now the column ORDER$WEIGHT in dependence of "DESTINY". NY should be
> *3, BER *2, FRA*1 and WAS * 4.
>
> The solution look like this one:
>
> ORDER   DESTINY    VALUE   WEIGHT
> A         NY          100          300
> B         BER          10             20
> C         FRA         100            100
> D         WAS         50             200
>
> Maybe anyone can help me, how i can do this?
>
> Thank you.