Dear group,

 

Here is my df, trades1 :

 

trades1 <-

structure(list(Instrument.Long.Name = c("CORN", "CORN", "CORN", 

"CORN", "CORN", "SOYBEANS", "SOYBEANS", "SOYBEANS", "SOYBEANS", 

"SOYBEANS", "SOYBEANS", "STANDARD LEAD USD", "STANDARD LEAD USD", 

"SPCL HIGH GRADE ZINC USD", "SPCL HIGH GRADE ZINC USD", "SPCL HIGH GRADE
ZINC USD", 

"ROBUSTA COFFEE (10)", "ROBUSTA COFFEE (10)", "ROBUSTA COFFEE (10)", 

"ROBUSTA COFFEE (10)", "ROBUSTA COFFEE (10)", "ROBUSTA COFFEE (10)", 

"ROBUSTA COFFEE (10)", "ROBUSTA COFFEE (10)"), Buy.Sell..Cleared. = c("Buy",


"Buy", "Sell", "Buy", "Sell", "Buy", "Buy", "Buy", "Buy", "Sell", 

"Sell", "Buy", "Sell", "Buy", "Sell", "Sell", "Buy", "Buy", "Buy", 

"Buy", "Buy", "Buy", "Buy", "Buy"), Volume = c(1L, 1L, 5L, 1L, 

1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 1L, 

1L, 1L, 1L, 1L), Price = c("361.5000", "361.5000", "361.0000", 

"372.5000", "374.0000", "990.0000", "992.2500", "995.2500", "995.7500", 

"992.2500", "997.5000", "2,251.5000", "2,369.5000", "2,406.0000", 

"2,421.5000", "2,448.5000", "1,380.0000", "1,383.0000", "1,383.0000", 

"1,386.0000", "1,386.0000", "1,388.0000", "1,389.0000", "1,389.0000"

), Net.Charges..sum. = c(-4.32, -4.32, -21.6, -4.32, -4.32, -4.32, 

-4.32, -4.32, -4.32, -4.32, -4.32, -12.5, -12.5, -12.5, -12.5, 

-12.5, -3.3, -3.3, -3.3, -3.3, -3.3, -3.3, -3.3, -3.3)), .Names =
c("Instrument.Long.Name", 

"Buy.Sell..Cleared.", "Volume", "Price", "Net.Charges..sum."), class =
"data.frame", row.names = c(NA, 

-24L))

 

I got it from this command line :

 

>trades1=read.csv2("LSCTrades.csv",dec=".",sep=",",as.is=T,h=T,skip=1)

 

The csv file has some numbers with thousands separator as a ".", so the
class for my "Price" column is character, when I want it numeric.

I can't change the column class, even when playing with the read.csv or
as.numeric commands and all their arguments.

 

Any help would be appreciate.

 

 

 

 

 

 

***************************

Arnaud Gaboury

Mobile: +41 79 392 79 56

BBM: 255B488F

***************************

 


	[[alternative HTML version deleted]]

