arnaud Gaboury
2010-Apr-30 07:39 UTC
[R] read.csv and blank character in object name of my data.frame
Dear group,
Here is my data frame:
position100415 <-
structure(list(DESCRIPTION = structure(1:9, .Label = c(" SUGAR NO.11 Jul/10
",
" SUGAR NO.11 May/10 ", "CORN May/10 ", "COTTON NO.2
Jul/10 ",
"CRUDE OIL miNY May/10 ", "ROBUSTA COFFEE (10) Jul/10 ",
"SILVER May/10 ",
"SOYBEANS Jul/10 ", "WHEAT May/10 "), class =
"factor"), POSITION = c(3,
-1, 3, 4, 3, 10, 1, 1, 6), SETTLEMENT = c(17.08, 16.85, 363.25,
82.12, 85.51, 1386, 1843.3, 993, 480.25)), .Names = c("DESCRIPTION",
"POSITION", "SETTLEMENT"), row.names = c(NA, 9L), class =
"data.frame")
As you can see, I have a blank at the end of each name of objects of list
DESCRIPTION (e.g "COTTON NO.2 Jul/10_",. I need to remove them.
My data frame has been obtained from a .csv file and then a few command
lines.
Here is the first line of my code :
pose=read.csv2("LSCPos100415.csv",sep=",",dec=".",as.is=T,h=T,skip=1)[,c(4,8
,14,15)]
As you can see, the blank already exists (e.g "CORN May/10_"), so it
should
come from the Excel file itself.
pose <-
structure(list(DESCRIPTION = c("CORN May/10 ", "CORN May/10
",
"SOYBEANS Jul/10 ", "WHEAT May/10 ", "WHEAT May/10
", "WHEAT May/10 ",
"WHEAT May/10 ", "WHEAT May/10 ", "WHEAT May/10 ",
"COTTON NO.2 Jul/10 ",
"COTTON NO.2 Jul/10 ", " SUGAR NO.11 Jul/10 ", " SUGAR
NO.11 Jul/10 ",
" SUGAR NO.11 Jul/10 ", " SUGAR NO.11 May/10 ", "CRUDE
OIL miNY May/10 ",
"CRUDE OIL miNY May/10 ", "ROBUSTA COFFEE (10) Jul/10 ",
"ROBUSTA COFFEE
(10) Jul/10 ",
"ROBUSTA COFFEE (10) Jul/10 ", "ROBUSTA COFFEE (10) Jul/10
",
"ROBUSTA COFFEE (10) Jul/10 ", "ROBUSTA COFFEE (10) Jul/10
",
"ROBUSTA COFFEE (10) Jul/10 ", "ROBUSTA COFFEE (10) Jul/10
",
"ROBUSTA COFFEE (10) Jul/10 ", "SILVER May/10 ", "PRM
HGH GD ALUMINIUM USD
09/07/10 ",
"PRM HGH GD ALUMINIUM USD 09/07/10 ", "PRIMARY NICKEL USD
04/06/10 ",
"PRIMARY NICKEL USD 04/06/10 ", "PRIMARY NICKEL USD 10/06/10
",
"PRIMARY NICKEL USD 10/06/10 ", "STANDARD LEAD USD 01/07/10
",
"STANDARD LEAD USD 01/07/10 ", "STANDARD LEAD USD 01/07/10
",
"STANDARD LEAD USD 01/07/10 ", "STANDARD LEAD USD 01/07/10
",
"STANDARD LEAD USD 01/07/10 ", "STANDARD LEAD USD 01/07/10
",
"STANDARD LEAD USD 06/07/10 ", "STANDARD LEAD USD 19/04/10
",
"STANDARD LEAD USD 19/04/10 ", "STANDARD LEAD USD 22/06/10
",
"STANDARD LEAD USD 23/06/10 ", "STANDARD LEAD USD 23/06/10
",
"STANDARD LEAD USD 23/06/10 ", "STANDARD LEAD USD 25/06/10
",
"STANDARD LEAD USD 25/06/10 ", "STANDARD LEAD USD 29/06/10
",
"STANDARD LEAD USD 29/06/10 ", "SPCL HIGH GRADE ZINC USD 06/07/10
",
"SPCL HIGH GRADE ZINC USD 06/07/10 ", "SPCL HIGH GRADE ZINC USD
06/07/10 ",
"SPCL HIGH GRADE ZINC USD 06/07/10 ", "SPCL HIGH GRADE ZINC USD
06/07/10 ",
"SPCL HIGH GRADE ZINC USD 06/07/10 ", "SPCL HIGH GRADE ZINC USD
06/07/10 ",
"SPCL HIGH GRADE ZINC USD 07/07/10 ", "SPCL HIGH GRADE ZINC USD
07/07/10 ",
"SPCL HIGH GRADE ZINC USD 07/07/10 ", "SPCL HIGH GRADE ZINC USD
08/07/10 ",
"SPCL HIGH GRADE ZINC USD 08/07/10 ", "SPCL HIGH GRADE ZINC USD
08/07/10 ",
"SPCL HIGH GRADE ZINC USD 09/07/10 ", "SPCL HIGH GRADE ZINC USD
09/07/10 ",
"SPCL HIGH GRADE ZINC USD 09/07/10 ", "SPCL HIGH GRADE ZINC USD
09/07/10 ",
"SPCL HIGH GRADE ZINC USD 09/07/10 ", "SPCL HIGH GRADE ZINC USD
13/07/10 ",
"SPCL HIGH GRADE ZINC USD 13/07/10 ", "SPCL HIGH GRADE ZINC USD
14/07/10 ",
"SPCL HIGH GRADE ZINC USD 14/07/10 ", "SPCL HIGH GRADE ZINC USD
14/07/10 ",
"SPCL HIGH GRADE ZINC USD 14/07/10 ", "SPCL HIGH GRADE ZINC USD
15/07/10 ",
"SPCL HIGH GRADE ZINC USD 15/07/10 ", "SPCL HIGH GRADE ZINC USD
15/07/10 ",
"SPCL HIGH GRADE ZINC USD 15/07/10 ", "SPCL HIGH GRADE ZINC USD
17/05/10 ",
"SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD
17/05/10 ",
"SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD
17/05/10 ",
"SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD
17/05/10 ",
"SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD
17/05/10 ",
"SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD
17/05/10 ",
"SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD
17/05/10 ",
"SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD
17/05/10 ",
"SPCL HIGH GRADE ZINC USD 18/05/10 ", "SPCL HIGH GRADE ZINC USD
18/05/10 ",
"SPCL HIGH GRADE ZINC USD 18/05/10 ", "SPCL HIGH GRADE ZINC USD
18/05/10 ",
"SPCL HIGH GRADE ZINC USD 18/05/10 ", "SPCL HIGH GRADE ZINC USD
19/04/10 ",
"SPCL HIGH GRADE ZINC USD 19/04/10 ", "SPCL HIGH GRADE ZINC USD
19/04/10 ",
"SPCL HIGH GRADE ZINC USD 19/04/10 ", "SPCL HIGH GRADE ZINC USD
19/05/10 ",
"SPCL HIGH GRADE ZINC USD 20/04/10 ", "SPCL HIGH GRADE ZINC USD
20/04/10 ",
"SPCL HIGH GRADE ZINC USD 21/04/10 ", "SPCL HIGH GRADE ZINC USD
21/04/10 ",
"SPCL HIGH GRADE ZINC USD 21/05/10 ", "SPCL HIGH GRADE ZINC USD
21/05/10 ",
"SPCL HIGH GRADE ZINC USD 21/05/10 ", "SPCL HIGH GRADE ZINC USD
21/05/10 ",
"SPCL HIGH GRADE ZINC USD 21/05/10 ", "SPCL HIGH GRADE ZINC USD
21/05/10 ",
"SPCL HIGH GRADE ZINC USD 21/05/10 ", "SPCL HIGH GRADE ZINC USD
22/04/10 ",
"SPCL HIGH GRADE ZINC USD 22/04/10 ", "SPCL HIGH GRADE ZINC USD
22/04/10 ",
"SPCL HIGH GRADE ZINC USD 22/04/10 ", "SPCL HIGH GRADE ZINC USD
22/06/10 ",
"SPCL HIGH GRADE ZINC USD 22/06/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD
24/05/10 ",
"SPCL HIGH GRADE ZINC USD 24/06/10 ", "SPCL HIGH GRADE ZINC USD
24/06/10 ",
"SPCL HIGH GRADE ZINC USD 25/05/10 ", "SPCL HIGH GRADE ZINC USD
25/05/10 ",
"SPCL HIGH GRADE ZINC USD 25/05/10 ", "SPCL HIGH GRADE ZINC USD
25/06/10 ",
"SPCL HIGH GRADE ZINC USD 25/06/10 ", "SPCL HIGH GRADE ZINC USD
26/04/10 ",
"SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD
26/04/10 ",
"SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD
26/04/10 ",
"SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD
26/04/10 ",
"SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD
26/04/10 ",
"SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD
26/04/10 ",
"SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD
26/04/10 "
), CREATED.DATE = c("14/04/2010", "14/04/2010",
"14/04/2010",
"08/04/2010", "08/04/2010", "12/04/2010",
"14/04/2010", "14/04/2010",
"14/04/2010", "15/04/2010", "15/04/2010",
"15/04/2010", "15/04/2010",
"15/04/2010", "15/04/2010", "12/04/2010",
"15/04/2010", "15/04/2010",
"15/04/2010", "15/04/2010", "15/04/2010",
"15/04/2010", "15/04/2010",
"15/04/2010", "15/04/2010", "15/04/2010",
"15/04/2010", "09/04/2010",
"09/04/2010", "04/03/2010", "05/03/2010",
"10/03/2010", "10/03/2010",
"01/04/2010", "01/04/2010", "01/04/2010",
"01/04/2010", "01/04/2010",
"01/04/2010", "01/04/2010", "06/04/2010",
"18/01/2010", "25/01/2010",
"22/03/2010", "23/03/2010", "23/03/2010",
"23/03/2010", "25/03/2010",
"26/03/2010", "29/03/2010", "29/03/2010",
"06/04/2010", "06/04/2010",
"06/04/2010", "06/04/2010", "06/04/2010",
"06/04/2010", "06/04/2010",
"07/04/2010", "07/04/2010", "07/04/2010",
"08/04/2010", "08/04/2010",
"08/04/2010", "09/04/2010", "09/04/2010",
"09/04/2010", "09/04/2010",
"09/04/2010", "13/04/2010", "13/04/2010",
"14/04/2010", "14/04/2010",
"14/04/2010", "14/04/2010", "15/04/2010",
"15/04/2010", "15/04/2010",
"15/04/2010", "16/02/2010", "16/02/2010",
"16/02/2010", "16/02/2010",
"16/02/2010", "16/02/2010", "16/02/2010",
"17/02/2010", "17/02/2010",
"17/02/2010", "17/02/2010", "17/02/2010",
"17/02/2010", "17/02/2010",
"17/02/2010", "18/02/2010", "18/02/2010",
"18/02/2010", "18/02/2010",
"18/02/2010", "18/01/2010", "18/01/2010",
"18/01/2010", "25/01/2010",
"19/02/2010", "20/01/2010", "20/01/2010",
"21/01/2010", "21/01/2010",
"22/02/2010", "22/02/2010", "22/02/2010",
"22/02/2010", "22/02/2010",
"22/02/2010", "22/02/2010", "22/01/2010",
"22/01/2010", "25/01/2010",
"25/01/2010", "22/03/2010", "22/03/2010",
"23/02/2010", "23/02/2010",
"23/02/2010", "23/02/2010", "23/02/2010",
"23/02/2010", "23/02/2010",
"24/02/2010", "24/02/2010", "24/02/2010",
"24/02/2010", "24/02/2010",
"24/02/2010", "24/02/2010", "24/02/2010",
"24/02/2010", "24/02/2010",
"24/02/2010", "24/02/2010", "24/03/2010",
"24/03/2010", "25/02/2010",
"25/02/2010", "25/02/2010", "25/03/2010",
"26/03/2010", "25/01/2010",
"25/01/2010", "25/01/2010", "25/01/2010",
"25/01/2010", "25/01/2010",
"26/01/2010", "26/01/2010", "26/01/2010",
"26/01/2010", "26/01/2010",
"26/01/2010", "26/01/2010"), QUANITY = c(1, 2, 1, 1, 1, 1,
1,
1, 1, 2, 2, 1, 1, 1, -1, 2, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1,
-1, 1, 1, -1, -1, 1, 1, -1, 1, -1, -1, 1, -1, 1, 1, -1, -1, 1,
-1, 1, -1, 1, 1, -1, -1, -1, 1, -1, -1, 1, 1, 1, -1, -1, 1, 1,
-1, -1, 1, -1, 1, 1, -1, -1, 1, -1, 1, 1, -1, 1, 1, -1, -2, 2,
-2, 1, 1, -1, -1, 1, 1, -1, 1, 1, -1, -1, 1, 2, -1, -1, -1, -1,
-1, -1, 1, 1, 2, -1, 1, 1, -1, 1, -1, -1, -1, 1, 1, -1, 1, 1,
-1, -1, -1, -1, 1, -1, 1, 1, 1, -1, -1, -1, -1, -1, -1, 1, 1,
-1, -1, 1, 1, 1, 1, -1, 1, -1, 2, -1, 1, 1, 2, -1, -1, -1, -1,
2, -2, -1, 1, 2, -1, 2, -1), CLOSING.PRICE = c("363.2500",
"363.2500",
"993.0000", "480.2500", "480.2500",
"480.2500", "480.2500", "480.2500",
"480.2500", "82.1200", "82.1200",
"17.0800", "17.0800", "17.0800",
"16.8500", "85.5100", "85.5100",
"1,386.0000", "1,386.0000",
"1,386.0000", "1,386.0000", "1,386.0000",
"1,386.0000", "1,386.0000",
"1,386.0000", "1,386.0000", "1,843.3000",
"2,469.9300", "2,469.9300",
"27,196.8600", "27,196.8600", "27,201.6800",
"27,201.6800", "2,337.1000",
"2,337.1000", "2,337.1000", "2,337.1000",
"2,337.1000", "2,337.1000",
"2,337.1000", "2,338.1400", "2,315.7500",
"2,315.7500", "2,335.2400",
"2,335.4500", "2,335.4500", "2,335.4500",
"2,335.8600", "2,335.8600",
"2,336.6900", "2,336.6900", "2,505.9700",
"2,505.9700", "2,505.9700",
"2,505.9700", "2,505.9700", "2,505.9700",
"2,505.9700", "2,506.3100",
"2,506.3100", "2,506.3100", "2,506.6500",
"2,506.6500", "2,506.6500",
"2,506.9800", "2,506.9800", "2,506.9800",
"2,506.9800", "2,506.9800",
"2,508.3300", "2,508.3300", "2,508.6600",
"2,508.6600", "2,508.6600",
"2,508.6600", "2,509.0000", "2,509.0000",
"2,509.0000", "2,509.0000",
"2,487.9600", "2,487.9600", "2,487.9600",
"2,487.9600", "2,487.9600",
"2,487.9600", "2,487.9600", "2,487.9600",
"2,487.9600", "2,487.9600",
"2,487.9600", "2,487.9600", "2,487.9600",
"2,487.9600", "2,487.9600",
"2,488.3600", "2,488.3600", "2,488.3600",
"2,488.3600", "2,488.3600",
"2,476.7500", "2,476.7500", "2,476.7500",
"2,476.7500", "2,488.7500",
"2,477.2500", "2,477.2500", "2,477.7500",
"2,477.7500", "2,489.4400",
"2,489.4400", "2,489.4400", "2,489.4400",
"2,489.4400", "2,489.4400",
"2,489.4400", "2,478.1400", "2,478.1400",
"2,478.1400", "2,478.1400",
"2,501.2700", "2,501.2700", "2,490.4700",
"2,490.4700", "2,490.4700",
"2,490.4700", "2,490.4700", "2,490.4700",
"2,490.4700", "2,490.4700",
"2,490.4700", "2,490.4700", "2,490.4700",
"2,490.4700", "2,490.4700",
"2,490.4700", "2,490.4700", "2,490.4700",
"2,490.4700", "2,490.4700",
"2,490.4700", "2,501.9400", "2,501.9400",
"2,490.8100", "2,490.8100",
"2,490.8100", "2,502.2800", "2,502.2800",
"2,479.7100", "2,479.7100",
"2,479.7100", "2,479.7100", "2,479.7100",
"2,479.7100", "2,479.7100",
"2,479.7100", "2,479.7100", "2,479.7100",
"2,479.7100", "2,479.7100",
"2,479.7100")), .Names = c("DESCRIPTION",
"CREATED.DATE", "QUANITY",
"CLOSING.PRICE"), class = "data.frame", row.names = c(NA,
-160L
))
As I can't change anything on the Excel side, how can I remove these blanks
on the R side??
TY for help.
arnaud Gaboury
2010-Apr-30 11:17 UTC
[R] read.csv and blank character in object name of my data.frame
TY so much, I ignored about this argument. Adding stripe.white=T as an argument in my read.csv does the job.> -----Original Message----- > From: Uwe Ligges [mailto:ligges at statistik.tu-dortmund.de] > Sent: Friday, April 30, 2010 1:08 PM > To: arnaud Gaboury > Cc: r-help at r-project.org > Subject: Re: [R] read.csv and blank character in object name of my > data.frame > > See ?read.table and its argument "strip.white". > > Uwe Ligges > > > On 30.04.2010 09:39, arnaud Gaboury wrote: > > Dear group, > > > > Here is my data frame: > > > > position100415<- > > structure(list(DESCRIPTION = structure(1:9, .Label = c(" SUGAR NO.11 > Jul/10 > > ", > > " SUGAR NO.11 May/10 ", "CORN May/10 ", "COTTON NO.2 Jul/10 ", > > "CRUDE OIL miNY May/10 ", "ROBUSTA COFFEE (10) Jul/10 ", "SILVER > May/10 ", > > "SOYBEANS Jul/10 ", "WHEAT May/10 "), class = "factor"), POSITION > c(3, > > -1, 3, 4, 3, 10, 1, 1, 6), SETTLEMENT = c(17.08, 16.85, 363.25, > > 82.12, 85.51, 1386, 1843.3, 993, 480.25)), .Names = c("DESCRIPTION", > > "POSITION", "SETTLEMENT"), row.names = c(NA, 9L), class > "data.frame") > > > > As you can see, I have a blank at the end of each name of objects of > list > > DESCRIPTION (e.g "COTTON NO.2 Jul/10_",. I need to remove them. > > My data frame has been obtained from a .csv file and then a few > command > > lines. > > Here is the first line of my code : > > > > > pose=read.csv2("LSCPos100415.csv",sep=",",dec=".",as.is=T,h=T,skip=1)[, > c(4,8 > > ,14,15)] > > > > As you can see, the blank already exists (e.g "CORN May/10_"), so it > should > > come from the Excel file itself. > > > > pose<- > > structure(list(DESCRIPTION = c("CORN May/10 ", "CORN May/10 ", > > "SOYBEANS Jul/10 ", "WHEAT May/10 ", "WHEAT May/10 ", "WHEAT May/10 > ", > > "WHEAT May/10 ", "WHEAT May/10 ", "WHEAT May/10 ", "COTTON NO.2 > Jul/10 ", > > "COTTON NO.2 Jul/10 ", " SUGAR NO.11 Jul/10 ", " SUGAR NO.11 Jul/10 > ", > > " SUGAR NO.11 Jul/10 ", " SUGAR NO.11 May/10 ", "CRUDE OIL miNY > May/10 ", > > "CRUDE OIL miNY May/10 ", "ROBUSTA COFFEE (10) Jul/10 ", "ROBUSTA > COFFEE > > (10) Jul/10 ", > > "ROBUSTA COFFEE (10) Jul/10 ", "ROBUSTA COFFEE (10) Jul/10 ", > > "ROBUSTA COFFEE (10) Jul/10 ", "ROBUSTA COFFEE (10) Jul/10 ", > > "ROBUSTA COFFEE (10) Jul/10 ", "ROBUSTA COFFEE (10) Jul/10 ", > > "ROBUSTA COFFEE (10) Jul/10 ", "SILVER May/10 ", "PRM HGH GD > ALUMINIUM USD > > 09/07/10 ", > > "PRM HGH GD ALUMINIUM USD 09/07/10 ", "PRIMARY NICKEL USD 04/06/10 ", > > "PRIMARY NICKEL USD 04/06/10 ", "PRIMARY NICKEL USD 10/06/10 ", > > "PRIMARY NICKEL USD 10/06/10 ", "STANDARD LEAD USD 01/07/10 ", > > "STANDARD LEAD USD 01/07/10 ", "STANDARD LEAD USD 01/07/10 ", > > "STANDARD LEAD USD 01/07/10 ", "STANDARD LEAD USD 01/07/10 ", > > "STANDARD LEAD USD 01/07/10 ", "STANDARD LEAD USD 01/07/10 ", > > "STANDARD LEAD USD 06/07/10 ", "STANDARD LEAD USD 19/04/10 ", > > "STANDARD LEAD USD 19/04/10 ", "STANDARD LEAD USD 22/06/10 ", > > "STANDARD LEAD USD 23/06/10 ", "STANDARD LEAD USD 23/06/10 ", > > "STANDARD LEAD USD 23/06/10 ", "STANDARD LEAD USD 25/06/10 ", > > "STANDARD LEAD USD 25/06/10 ", "STANDARD LEAD USD 29/06/10 ", > > "STANDARD LEAD USD 29/06/10 ", "SPCL HIGH GRADE ZINC USD 06/07/10 ", > > "SPCL HIGH GRADE ZINC USD 06/07/10 ", "SPCL HIGH GRADE ZINC USD > 06/07/10 ", > > "SPCL HIGH GRADE ZINC USD 06/07/10 ", "SPCL HIGH GRADE ZINC USD > 06/07/10 ", > > "SPCL HIGH GRADE ZINC USD 06/07/10 ", "SPCL HIGH GRADE ZINC USD > 06/07/10 ", > > "SPCL HIGH GRADE ZINC USD 07/07/10 ", "SPCL HIGH GRADE ZINC USD > 07/07/10 ", > > "SPCL HIGH GRADE ZINC USD 07/07/10 ", "SPCL HIGH GRADE ZINC USD > 08/07/10 ", > > "SPCL HIGH GRADE ZINC USD 08/07/10 ", "SPCL HIGH GRADE ZINC USD > 08/07/10 ", > > "SPCL HIGH GRADE ZINC USD 09/07/10 ", "SPCL HIGH GRADE ZINC USD > 09/07/10 ", > > "SPCL HIGH GRADE ZINC USD 09/07/10 ", "SPCL HIGH GRADE ZINC USD > 09/07/10 ", > > "SPCL HIGH GRADE ZINC USD 09/07/10 ", "SPCL HIGH GRADE ZINC USD > 13/07/10 ", > > "SPCL HIGH GRADE ZINC USD 13/07/10 ", "SPCL HIGH GRADE ZINC USD > 14/07/10 ", > > "SPCL HIGH GRADE ZINC USD 14/07/10 ", "SPCL HIGH GRADE ZINC USD > 14/07/10 ", > > "SPCL HIGH GRADE ZINC USD 14/07/10 ", "SPCL HIGH GRADE ZINC USD > 15/07/10 ", > > "SPCL HIGH GRADE ZINC USD 15/07/10 ", "SPCL HIGH GRADE ZINC USD > 15/07/10 ", > > "SPCL HIGH GRADE ZINC USD 15/07/10 ", "SPCL HIGH GRADE ZINC USD > 17/05/10 ", > > "SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD > 17/05/10 ", > > "SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD > 17/05/10 ", > > "SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD > 17/05/10 ", > > "SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD > 17/05/10 ", > > "SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD > 17/05/10 ", > > "SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD > 17/05/10 ", > > "SPCL HIGH GRADE ZINC USD 17/05/10 ", "SPCL HIGH GRADE ZINC USD > 17/05/10 ", > > "SPCL HIGH GRADE ZINC USD 18/05/10 ", "SPCL HIGH GRADE ZINC USD > 18/05/10 ", > > "SPCL HIGH GRADE ZINC USD 18/05/10 ", "SPCL HIGH GRADE ZINC USD > 18/05/10 ", > > "SPCL HIGH GRADE ZINC USD 18/05/10 ", "SPCL HIGH GRADE ZINC USD > 19/04/10 ", > > "SPCL HIGH GRADE ZINC USD 19/04/10 ", "SPCL HIGH GRADE ZINC USD > 19/04/10 ", > > "SPCL HIGH GRADE ZINC USD 19/04/10 ", "SPCL HIGH GRADE ZINC USD > 19/05/10 ", > > "SPCL HIGH GRADE ZINC USD 20/04/10 ", "SPCL HIGH GRADE ZINC USD > 20/04/10 ", > > "SPCL HIGH GRADE ZINC USD 21/04/10 ", "SPCL HIGH GRADE ZINC USD > 21/04/10 ", > > "SPCL HIGH GRADE ZINC USD 21/05/10 ", "SPCL HIGH GRADE ZINC USD > 21/05/10 ", > > "SPCL HIGH GRADE ZINC USD 21/05/10 ", "SPCL HIGH GRADE ZINC USD > 21/05/10 ", > > "SPCL HIGH GRADE ZINC USD 21/05/10 ", "SPCL HIGH GRADE ZINC USD > 21/05/10 ", > > "SPCL HIGH GRADE ZINC USD 21/05/10 ", "SPCL HIGH GRADE ZINC USD > 22/04/10 ", > > "SPCL HIGH GRADE ZINC USD 22/04/10 ", "SPCL HIGH GRADE ZINC USD > 22/04/10 ", > > "SPCL HIGH GRADE ZINC USD 22/04/10 ", "SPCL HIGH GRADE ZINC USD > 22/06/10 ", > > "SPCL HIGH GRADE ZINC USD 22/06/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/05/10 ", "SPCL HIGH GRADE ZINC USD > 24/05/10 ", > > "SPCL HIGH GRADE ZINC USD 24/06/10 ", "SPCL HIGH GRADE ZINC USD > 24/06/10 ", > > "SPCL HIGH GRADE ZINC USD 25/05/10 ", "SPCL HIGH GRADE ZINC USD > 25/05/10 ", > > "SPCL HIGH GRADE ZINC USD 25/05/10 ", "SPCL HIGH GRADE ZINC USD > 25/06/10 ", > > "SPCL HIGH GRADE ZINC USD 25/06/10 ", "SPCL HIGH GRADE ZINC USD > 26/04/10 ", > > "SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD > 26/04/10 ", > > "SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD > 26/04/10 ", > > "SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD > 26/04/10 ", > > "SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD > 26/04/10 ", > > "SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD > 26/04/10 ", > > "SPCL HIGH GRADE ZINC USD 26/04/10 ", "SPCL HIGH GRADE ZINC USD > 26/04/10" > > ), CREATED.DATE = c("14/04/2010", "14/04/2010", "14/04/2010", > > "08/04/2010", "08/04/2010", "12/04/2010", "14/04/2010", "14/04/2010", > > "14/04/2010", "15/04/2010", "15/04/2010", "15/04/2010", "15/04/2010", > > "15/04/2010", "15/04/2010", "12/04/2010", "15/04/2010", "15/04/2010", > > "15/04/2010", "15/04/2010", "15/04/2010", "15/04/2010", "15/04/2010", > > "15/04/2010", "15/04/2010", "15/04/2010", "15/04/2010", "09/04/2010", > > "09/04/2010", "04/03/2010", "05/03/2010", "10/03/2010", "10/03/2010", > > "01/04/2010", "01/04/2010", "01/04/2010", "01/04/2010", "01/04/2010", > > "01/04/2010", "01/04/2010", "06/04/2010", "18/01/2010", "25/01/2010", > > "22/03/2010", "23/03/2010", "23/03/2010", "23/03/2010", "25/03/2010", > > "26/03/2010", "29/03/2010", "29/03/2010", "06/04/2010", "06/04/2010", > > "06/04/2010", "06/04/2010", "06/04/2010", "06/04/2010", "06/04/2010", > > "07/04/2010", "07/04/2010", "07/04/2010", "08/04/2010", "08/04/2010", > > "08/04/2010", "09/04/2010", "09/04/2010", "09/04/2010", "09/04/2010", > > "09/04/2010", "13/04/2010", "13/04/2010", "14/04/2010", "14/04/2010", > > "14/04/2010", "14/04/2010", "15/04/2010", "15/04/2010", "15/04/2010", > > "15/04/2010", "16/02/2010", "16/02/2010", "16/02/2010", "16/02/2010", > > "16/02/2010", "16/02/2010", "16/02/2010", "17/02/2010", "17/02/2010", > > "17/02/2010", "17/02/2010", "17/02/2010", "17/02/2010", "17/02/2010", > > "17/02/2010", "18/02/2010", "18/02/2010", "18/02/2010", "18/02/2010", > > "18/02/2010", "18/01/2010", "18/01/2010", "18/01/2010", "25/01/2010", > > "19/02/2010", "20/01/2010", "20/01/2010", "21/01/2010", "21/01/2010", > > "22/02/2010", "22/02/2010", "22/02/2010", "22/02/2010", "22/02/2010", > > "22/02/2010", "22/02/2010", "22/01/2010", "22/01/2010", "25/01/2010", > > "25/01/2010", "22/03/2010", "22/03/2010", "23/02/2010", "23/02/2010", > > "23/02/2010", "23/02/2010", "23/02/2010", "23/02/2010", "23/02/2010", > > "24/02/2010", "24/02/2010", "24/02/2010", "24/02/2010", "24/02/2010", > > "24/02/2010", "24/02/2010", "24/02/2010", "24/02/2010", "24/02/2010", > > "24/02/2010", "24/02/2010", "24/03/2010", "24/03/2010", "25/02/2010", > > "25/02/2010", "25/02/2010", "25/03/2010", "26/03/2010", "25/01/2010", > > "25/01/2010", "25/01/2010", "25/01/2010", "25/01/2010", "25/01/2010", > > "26/01/2010", "26/01/2010", "26/01/2010", "26/01/2010", "26/01/2010", > > "26/01/2010", "26/01/2010"), QUANITY = c(1, 2, 1, 1, 1, 1, 1, > > 1, 1, 2, 2, 1, 1, 1, -1, 2, 1, 1, 1, 2, 1, 1, 1, 1, 1, 1, 1, > > -1, 1, 1, -1, -1, 1, 1, -1, 1, -1, -1, 1, -1, 1, 1, -1, -1, 1, > > -1, 1, -1, 1, 1, -1, -1, -1, 1, -1, -1, 1, 1, 1, -1, -1, 1, 1, > > -1, -1, 1, -1, 1, 1, -1, -1, 1, -1, 1, 1, -1, 1, 1, -1, -2, 2, > > -2, 1, 1, -1, -1, 1, 1, -1, 1, 1, -1, -1, 1, 2, -1, -1, -1, -1, > > -1, -1, 1, 1, 2, -1, 1, 1, -1, 1, -1, -1, -1, 1, 1, -1, 1, 1, > > -1, -1, -1, -1, 1, -1, 1, 1, 1, -1, -1, -1, -1, -1, -1, 1, 1, > > -1, -1, 1, 1, 1, 1, -1, 1, -1, 2, -1, 1, 1, 2, -1, -1, -1, -1, > > 2, -2, -1, 1, 2, -1, 2, -1), CLOSING.PRICE = c("363.2500", > "363.2500", > > "993.0000", "480.2500", "480.2500", "480.2500", "480.2500", > "480.2500", > > "480.2500", "82.1200", "82.1200", "17.0800", "17.0800", "17.0800", > > "16.8500", "85.5100", "85.5100", "1,386.0000", "1,386.0000", > > "1,386.0000", "1,386.0000", "1,386.0000", "1,386.0000", "1,386.0000", > > "1,386.0000", "1,386.0000", "1,843.3000", "2,469.9300", "2,469.9300", > > "27,196.8600", "27,196.8600", "27,201.6800", "27,201.6800", > "2,337.1000", > > "2,337.1000", "2,337.1000", "2,337.1000", "2,337.1000", "2,337.1000", > > "2,337.1000", "2,338.1400", "2,315.7500", "2,315.7500", "2,335.2400", > > "2,335.4500", "2,335.4500", "2,335.4500", "2,335.8600", "2,335.8600", > > "2,336.6900", "2,336.6900", "2,505.9700", "2,505.9700", "2,505.9700", > > "2,505.9700", "2,505.9700", "2,505.9700", "2,505.9700", "2,506.3100", > > "2,506.3100", "2,506.3100", "2,506.6500", "2,506.6500", "2,506.6500", > > "2,506.9800", "2,506.9800", "2,506.9800", "2,506.9800", "2,506.9800", > > "2,508.3300", "2,508.3300", "2,508.6600", "2,508.6600", "2,508.6600", > > "2,508.6600", "2,509.0000", "2,509.0000", "2,509.0000", "2,509.0000", > > "2,487.9600", "2,487.9600", "2,487.9600", "2,487.9600", "2,487.9600", > > "2,487.9600", "2,487.9600", "2,487.9600", "2,487.9600", "2,487.9600", > > "2,487.9600", "2,487.9600", "2,487.9600", "2,487.9600", "2,487.9600", > > "2,488.3600", "2,488.3600", "2,488.3600", "2,488.3600", "2,488.3600", > > "2,476.7500", "2,476.7500", "2,476.7500", "2,476.7500", "2,488.7500", > > "2,477.2500", "2,477.2500", "2,477.7500", "2,477.7500", "2,489.4400", > > "2,489.4400", "2,489.4400", "2,489.4400", "2,489.4400", "2,489.4400", > > "2,489.4400", "2,478.1400", "2,478.1400", "2,478.1400", "2,478.1400", > > "2,501.2700", "2,501.2700", "2,490.4700", "2,490.4700", "2,490.4700", > > "2,490.4700", "2,490.4700", "2,490.4700", "2,490.4700", "2,490.4700", > > "2,490.4700", "2,490.4700", "2,490.4700", "2,490.4700", "2,490.4700", > > "2,490.4700", "2,490.4700", "2,490.4700", "2,490.4700", "2,490.4700", > > "2,490.4700", "2,501.9400", "2,501.9400", "2,490.8100", "2,490.8100", > > "2,490.8100", "2,502.2800", "2,502.2800", "2,479.7100", "2,479.7100", > > "2,479.7100", "2,479.7100", "2,479.7100", "2,479.7100", "2,479.7100", > > "2,479.7100", "2,479.7100", "2,479.7100", "2,479.7100", "2,479.7100", > > "2,479.7100")), .Names = c("DESCRIPTION", "CREATED.DATE", "QUANITY", > > "CLOSING.PRICE"), class = "data.frame", row.names = c(NA, -160L > > )) > > > > > > As I can't change anything on the Excel side, how can I remove these > blanks > > on the R side?? > > > > TY for 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.