Displaying 1 result from an estimated 1 matches for "cftc_cot".
2013 Jul 22
1
problem loading large xlsx file into r
...ease find the code and error below. The file I was trying to read has 36,500 rows X 188 col, ~ 37 MB size.
> options( java.parameters = "-Xmx4g" )
> library(xlsx)
Loading required package: xlsxjars
Loading required package: rJava
> cftc = read.xlsx("d:\\Krishna\\Research\\CFTC_COT\\cftcdata.xlsx", 1)
Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, :
java.lang.OutOfMemoryError: Java heap space
> sessionInfo()
R version 3.0.1 (2013-05-16)
Platform: x86_64-w64-mingw32/x64 (64-bit)
locale:
[1] LC_COLLATE=English_...