[R] calculate an value in dependence of another column

[arun]

Hi,

You could try:
dat1 <- read.table(text="ORDER  DESTINY    VALUE
A        NY          100
B        BER          10
C        FRA        100
D        WAS        50
E        BER         20",sep="",header=TRUE,stringsAsFactors=FALSE)
 within(dat1,WEIGHT <- as.numeric(factor(DESTINY,levels=c("FRA","BER","NY","WAS")))*VALUE)


A.K.




On Friday, January 17, 2014 4:15 AM, Mat <matthias.weber at fnt.de> 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.



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

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