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

Gerrit Eichner Gerrit.Eichner at math.uni-giessen.de
Fri Jan 17 10:36:59 CET 2014

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

```