Read them in as character and then convert them:
> x <- c('4,123.45', '1,234,567.89')
> x
[1] "4,123.45" "1,234,567.89"
> as.numeric(gsub(',', '', x))
[1] 4123.45 1234567.89
>
On Thu, Feb 11, 2010 at 2:39 PM, Mark Breman <breman.m...@gmail.com> wrote:
> Hello,
>
> Is there an easy way to read a csv file with numeric values that contain
> thousands seperators. The file looks like this:
>
> Date;opening;High;Low;closing;Volume
> 12/02/08;4,764.95;4,897.62;4,729.13;4,895.31;-
> 13/02/08;4,868.02;4,927.81;4,833.85;4,898.60;-
> 14/02/08;4,942.18;4,962.43;4,877.88;4,895.99;-
>
> I want to get the numeric values as..., well, numeric values, and not as
> character strings.
>
> I tried read.csv() with the colClasses parameter but that does not help and
> it looks like read.csv() does not support the big.mark="," parameter.
>
> Thanks,
>
> -Mark-
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help@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.
>
--
Jim Holtman
Cincinnati, OH
+1 513 646 9390
What is the problem that you are trying to solve?
______________________________________________
R-help@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.
