[R] data frame subscription

[arnaud Gaboury]

I was just adding the minus sign to the line when I got your mail.
Yes, it works that way.

TY for the transform function.





> -----Original Message-----
> From: David Winsemius [mailto:dwinsemius at comcast.net]
> Sent: Wednesday, May 12, 2010 5:07 PM
> To: Henrique Dallazuanna
> Cc: arnaud Gaboury; r-help at r-project.org
> Subject: Re: [R] data frame subscription
> 
> Couldn't you just put a minus sign in from of the derived "prix"
> expression?
> 
> transform(pose16, prix = - POSITION * SETTLEMENT, SETTLEMENT = NULL,
> POSITION
> = POSITION * -1)
> 
> On May 12, 2010, at 10:59 AM, Henrique Dallazuanna wrote:
> 
> > But:
> >
> > pose16$POSITION * pose16$SETTLEMENT is
> > [1]  -702.90   244.77   166.48  2273.80 24876.00  2985.00    80.90
> > -15.95  2512.50 -2423.00
> >
> > not:
> > c(702.9,  -244.77, -166.48, -2273.8, -24876, -2985, -80.9, 15.95,
> > -2512.5,
> > 2423)
> >
> >
> > On Wed, May 12, 2010 at 11:53 AM, arnaud Gaboury
> > <arnaud.gaboury at gmail.com>wrote:
> >
> >> The result is different with your code.
> >>
> >> My result is :
> >>
> >> pose16 <-
> >> structure(list(DESCRIPTION = structure(c(1L, 2L, 3L, 4L, 5L,
> >> 6L, 7L, 8L, 9L, 12L), .Label = c("COPPER May/10", "COTTON NO.2 Jul/
> >> 10",
> >> "CRUDE OIL miNY May/10", "GOLD Jun/10", "ROBUSTA COFFEE (10)
> Jul/10",
> >> "SOYBEANS Jul/10", "SUGAR NO.11 Jul/10", "SUGAR NO.11 May/10",
> >> "WHEAT Jul/10", "PRIMARY NICKEL USD", "PRM HGH GD ALUMINIUM USD",
> >> "SPCL HIGH GRADE ZINC USD", "STANDARD LEAD USD"), class = "factor"),
> >>    POSITION = c(2, -3, -2, -2, -18, -3, -5, 1, -5, 1), prix =
> >> c(702.9,
> >>   -244.77, -166.48, -2273.8, -24876, -2985, -80.9, 15.95, -2512.5,
> >>   2423)), .Names = c("DESCRIPTION", "POSITION", "prix"), row.names =
> >> c("1",
> >> "2", "3", "4", "5", "6", "7", "8", "9", "51"), class = "data.frame")
> >>
> >> Your result is :
> >>
> >> pose16 <-
> >> structure(list(DESCRIPTION = structure(c(1L, 2L, 3L, 4L, 5L,
> >> 6L, 7L, 8L, 9L, 12L), .Label = c("COPPER May/10", "COTTON NO.2 Jul/
> >> 10",
> >> "CRUDE OIL miNY May/10", "GOLD Jun/10", "ROBUSTA COFFEE (10)
> Jul/10",
> >> "SOYBEANS Jul/10", "SUGAR NO.11 Jul/10", "SUGAR NO.11 May/10",
> >> "WHEAT Jul/10", "PRIMARY NICKEL USD", "PRM HGH GD ALUMINIUM USD",
> >> "SPCL HIGH GRADE ZINC USD", "STANDARD LEAD USD"), class = "factor"),
> >>    POSITION = c(2, -3, -2, -2, -18, -3, -5, 1, -5, 1), prix =
> >> c(-702.9,
> >>   244.77, 166.48, 2273.8, 24876, 2985, 80.9, -15.95, 2512.5,
> >>   -2423)), .Names = c("DESCRIPTION", "POSITION", "prix"), row.names
> =
> >> c("1",
> >> "2", "3", "4", "5", "6", "7", "8", "9", "51"), class = "data.frame")
> >>
> >>
> >>
> >>
> >> From: Henrique Dallazuanna [mailto:wwwhsd at gmail.com]
> >> Sent: Wednesday, May 12, 2010 3:32 PM
> >> To: arnaud Gaboury
> >> Cc: r-help at r-project.org
> >> Subject: Re: [R] data frame subscription
> >>
> >> Try this:
> >>
> >> transform(pose16, prix = POSITION * SETTLEMENT, SETTLEMENT = NULL,
> >> POSITION
> >> = POSITION * -1)
> >>
> >> On Wed, May 12, 2010 at 9:50 AM, arnaud Gaboury
> <arnaud.gaboury at gmail.com
> >> >
> >> wrote:
> >> Dear group,
> >>
> >> Here is my df :
> >>
> >> pose16 <-
> >> structure(list(DESCRIPTION = structure(c(1L, 2L, 3L, 4L, 5L,
> >> 6L, 7L, 8L, 9L, 12L), .Label = c("COPPER May/10", "COTTON NO.2 Jul/
> >> 10",
> >> "CRUDE OIL miNY May/10", "GOLD Jun/10", "ROBUSTA COFFEE (10)
> Jul/10",
> >> "SOYBEANS Jul/10", "SUGAR NO.11 Jul/10", "SUGAR NO.11 May/10",
> >> "WHEAT Jul/10", "PRIMARY NICKEL USD", "PRM HGH GD ALUMINIUM USD",
> >> "SPCL HIGH GRADE ZINC USD", "STANDARD LEAD USD"), class = "factor"),
> >>   POSITION = c(-2, 3, 2, 2, 18, 3, 5, -1, 5, -1), SETTLEMENT =
> >> c(351.45,
> >>   81.59, 83.24, 1136.9, 1382, 995, 16.18, 15.95, 502.5, 2423
> >>   )), .Names = c("DESCRIPTION", "POSITION", "SETTLEMENT"),
> >> row.names =
> >> c("1",
> >> "2", "3", "4", "5", "6", "7", "8", "9", "51"), class = "data.frame")
> >>
> >> Here is my code :
> >>
> >>> pose16$prix<-pose16[,2]*pose16[,3]
> >>> pose16<-pose16[,-3]
> >>> pose16[,-1]<- -pose16[,-1]
> >>
> >> It works fine, as the resulting df is what I want. I am just
> >> wandering if
> >> these 3 command lines can be writen in only 1 or 2 lines??
> >>
> >> TY for the help.
> >>
> >> ______________________________________________
> >> 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.
> >>
> >>
> >>
> >> --
> >> Henrique Dallazuanna
> >> Curitiba-Paraná-Brasil
> >> 25° 25' 40" S 49° 16' 22" O
> >>
> >>
> >
> >
> > --
> > Henrique Dallazuanna
> > Curitiba-Paraná-Brasil
> > 25° 25' 40" S 49° 16' 22" O
> >
> > 	[[alternative HTML version deleted]]
> >
> > ______________________________________________
> > 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.
> 
> David Winsemius, MD
> West Hartford, CT