[Rd] Please make Pre-3.1 read.csv (type.convert) behavior available
Tom Kraljevic
tomk at 0xdata.com
Sat Apr 26 22:12:09 CEST 2014
Hi,
One additional follow-up here.
Unfortunately, I hit what looks like an R parsing bug that makes the Java Double.toHexString() output
unreliable for reading by R. (This is really unfortunate, because the format is intended to be lossless
and it looks like it’s so close to fully working.)
You can see the spec for the conversion here:
http://docs.oracle.com/javase/7/docs/api/java/lang/Double.html#toHexString(double)
The last value in the list below is not parsed by R in the way I expected, and causes the column to flip
from numeric to factor.
-0x1.8ff831c7ffffdp-1
-0x1.aff831c7ffffdp-1
-0x1.bff831c7ffffdp-1
-0x1.cff831c7ffffdp-1
-0x1.dff831c7ffffdp-1
-0x1.eff831c7ffffdp-1
-0x1.fff831c7ffffdp-1 <<<<< this value is not parsed as a number and flips the column from numeric to factor.
Below is the R output from adding one row at a time to “bad.csv”.
The last attempt results in a factor rather than a numeric column.
What’s really odd about it is that the .a through .e case work fine but the .f case doesn’t.
Thanks,
Tom
> bad.df = read.csv(file="/Users/tomk/bad.csv", header=F)
> str(bad.df)
'data.frame': 1 obs. of 1 variable:
$ V1: num -0.781
> bad.df = read.csv(file="/Users/tomk/bad.csv", header=F)
> str(bad.df)
'data.frame': 2 obs. of 1 variable:
$ V1: num -0.781 -0.844
> bad.df = read.csv(file="/Users/tomk/bad.csv", header=F)
> str(bad.df)
'data.frame': 3 obs. of 1 variable:
$ V1: num -0.781 -0.844 -0.875
> bad.df = read.csv(file="/Users/tomk/bad.csv", header=F)
> str(bad.df)
'data.frame': 4 obs. of 1 variable:
$ V1: num -0.781 -0.844 -0.875 -0.906
> bad.df = read.csv(file="/Users/tomk/bad.csv", header=F)
> str(bad.df)
'data.frame': 5 obs. of 1 variable:
$ V1: num -0.781 -0.844 -0.875 -0.906 -0.937
> bad.df = read.csv(file="/Users/tomk/bad.csv", header=F)
> str(bad.df)
'data.frame': 6 obs. of 1 variable:
$ V1: num -0.781 -0.844 -0.875 -0.906 -0.937 ...
> bad.df = read.csv(file="/Users/tomk/bad.csv", header=F)
> str(bad.df)
'data.frame': 7 obs. of 1 variable:
$ V1: Factor w/ 7 levels "-0x1.8ff831c7ffffdp-1",..: 1 2 3 4 5 6 7
More information about the R-devel
mailing list