[R] calculate an value in dependence of another column

[Mat]

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.



--
View this message in context: http://r.789695.n4.nabble.com/calculate-an-value-in-dependence-of-another-column-tp4683727.html
Sent from the R help mailing list archive at Nabble.com.