# [R] calculate an value in dependence of another column

Mat matthias.weber at fnt.de
Fri Jan 17 10:12:31 CET 2014

```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.

```