[R] How to convert factors to numbers

chuck.01 CharlieTheBrown77 at gmail.com
Fri Mar 23 15:31:16 CET 2012


Using your posed data, the variable price was numeric:

data.precios <-
read.table("http://r.789695.n4.nabble.com/file/n4498828/p_diarios.txt",
header=T)

str(data.precios)
'data.frame':	1996 obs. of  2 variables:
 $ time : int  37988 37991 37993 37994 37995 37998 37999 38000 38001 38002
...
 $ price: num  18.1 26.1 30.9 34.7 27.6 ...


HOWEVER!
If I follow your code (eg. using " read.table(... , dec=",", sep="\t")":

 data.precios <-
read.table("http://r.789695.n4.nabble.com/file/n4498828/p_diarios.txt", 
header =TRUE , dec=",", sep="\t")
> str(data.precios)
'data.frame':	1996 obs. of  2 variables:
 $ time : int  37988 37991 37993 37994 37995 37998 37999 38000 38001 38002
...
 $ price: Factor w/ 1639 levels "10.80","12.53",..: 12 126 213 342 160 186
219 37 54 69 ...

It is a factor.... but I can change it like this:

> Price <- as.numeric(data.precios$price) 
> str(lPrice)
 num [1:1996] 12 126 213 342 160 186 219 37 54 69 ...


I think avoiding it ever becoming a factor would be the better path. 
Good luck. 





sandro wrote
> 
> Hello, I am relatively new to using R.
> 
> The text file contains the date and price .  I want to read and manipulate
> the data in R.  However, when I use read.table, it treats all of the data
> as "factors" and I do not know how to treat the data as numbers:
> 
>  http://r.789695.n4.nabble.com/file/n4498828/p_diarios.txt p_diarios.txt 
> 
> setwd ("C:\\Users\\Sandro\\Dropbox\\R")
> data.precios <- read.table ("p_diarios.txt ", header =TRUE
> , dec=",", sep="\t")
> Time <- data.precios$time # 01.02.2004 - 12.05.2011
> Price <- data.precios$price # Historical spot price
> log.Price <- log(data.precios$price)
> Error en Math.factor(c(12L, 126L, 213L, 342L, 160L, 186L, 219L, 37L, 54L, 
> : 
>   log not meaningful for factors
> 
> As you can see, I cannot calculate the price logarithms.
> 
> Any help is appreciated.
> 
> Sandro
> 


--
View this message in context: http://r.789695.n4.nabble.com/How-to-convert-factors-to-numbers-tp4498828p4499019.html
Sent from the R help mailing list archive at Nabble.com.



More information about the R-help mailing list