[R] decimal separator from comma to dot

[mbressan at arpa.veneto.it]

YES, THANK YOU ALL
for the good lessons learned both about the netiquette of this mailing
list and the R coding

max

> Hi,
> Try:
>  df$POT2_TX<- df$POT_TX
> df[,6:7]<- lapply(df[,6:7],function(x)
> as.numeric(as.character(sub(",",".",x))))
>  str(df)
> #'data.frame':    10 obs. of  7 variables:
> # $ IDANT    : int  37837 37838 37839 37840 37841 37842 37843 40720 40721
> 40722
> # $ N_TX     : int  6 6 6 4 1 1 1 2 2 1
> # $ TILT     : int  0 0 0 0 6 6 6 0 0 0
> # $ DIREZIONE: int  50 220 110 50 220 110 50 170 70 270
> # $ DATA_INI : Factor w/ 2 levels "20/10/2004","29/08/2002": 2 2 2 2 2 2 2
> 1 1 1
> # $ POT_TX   : num  8 8 8 4 11.5 11.5 11.5 10 10 10
> # $ POT2_TX  : num  8 8 8 4 11.5 11.5 11.5 10 10 10
> A.K.
>
>
>
> ----- Original Message -----
> From: "mbressan at arpa.veneto.it" <mbressan at arpa.veneto.it>
> To: David Winsemius <dwinsemius at comcast.net>
> Cc: r-help at r-project.org; maxbre <mbressan at arpa.veneto.it>
> Sent: Friday, August 9, 2013 3:35 PM
> Subject: Re: [R] decimal separator from comma to dot
>
> This is my reproducible example
>
> df<-structure(list(IDANT = c(37837L, 37838L, 37839L, 37840L, 37841L, 
> 37842L, 37843L, 40720L, 40721L, 40722L), N_TX = c(6L, 6L, 6L, 
> 4L, 1L, 1L, 1L, 2L, 2L, 1L), TILT = c(0L, 0L, 0L, 0L, 6L, 6L, 
> 6L, 0L, 0L, 0L), DIREZIONE = c(50L, 220L, 110L, 50L, 220L, 110L, 
> 50L, 170L, 70L, 270L), DATA_INI = structure(c(2L, 2L, 2L, 2L, 
> 2L, 2L, 2L, 1L, 1L, 1L), .Label = c("20/10/2004", "29/08/2002" 
> ), class = "factor"), POT_TX = structure(c(4L, 4L, 4L, 3L, 2L, 
> 2L, 2L, 1L, 1L, 1L), .Label = c("10", "11,5", "4", "8"), class =
> "factor")), .Names = c("IDANT", 
> "N_TX", "TILT", "DIREZIONE", "DATA_INI", "POT_TX"), row.names = c(NA, 
> 10L), class = "data.frame") 
>
> from david winsemius reply (quite annoyed by me, sorry for that!)
> http://r.789695.n4.nabble.com/decimal-separator-from-comma-to-dot-td4673414.html#a4673461
> and from faq 7.10
> I learnt this is the correct way to perform the conversion from factor to
> number for a single variable
>
> df$POT_TX <- as.numeric(as.character( sub(",", ".", df$POT_TX )))
>
> but what about the case of more than one column (variable) in a data
> frame?
>
> I hope now my question is fine with the rules of this mailing list
>
> thank you all for the patiente
> I'm learning a lot
>
>
> max
>
> ______________________________________________
> 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.
>
>