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.
data frame subscription
7 messages · Henrique Dallazuanna, Arnaud Gaboury, David Winsemius
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100512/094713f9/attachment.pl>
TY. Didn't know this function.
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
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
An embedded and charset-unspecified text was scrubbed... Name: not available URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20100512/b8d3fe25/attachment.pl>
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
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