similar to: Read shortcuts of MS Excel files through R

offline? te lo envío a tu email, pq no creo que a toda la lista sea buena idea. El 15 de agosto de 2014, 9:47, Jorge I Velez <jorgeivanvelez en gmail.com> escribió: > De nada, Miguel. Es posible que me envies el archivo offline? --JIV > > > > 2014-08-15 17:45 GMT+10:00 Miguel Fiandor Gutiérrez < > miguel.fiandor.gutierrez en gmail.com>: > > Gracias

Hi, I am facing trouble when trying to read large xlsx file into R. please 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 =

I am trying to read an xlsx spreadsheet (1506 rows, 501columns) all populated but getting the following error: Please advise as to how to get around this issue. > res <- read.xlsx("c:\\BSE_v2.xlsx",1) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: Java heap space Here is the session info:

Buenos días, Me gustaría compartir una duda con la que me acabo de encontrar y no se como solucionar, por si podrías echarme una mano: Trabajo con bases de datos en R que importo de excel. Cargando las librerías de: rJava , xlsxjars y xlsx. Al principio no parecía haber ningún inconveniente, pero después de un tiempo de trabajo me aparece el siguiente error en la consola de datos: *Error in

Dear list, I'm running windows xp with R 2.12.0. I'm trying to load a excel spreadsheet into R using the xlsx package. I posted my code below with the error I get. > res <- read.xlsx("Copy of test_excel_input_data.xlsx", 6) Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.IllegalStateException: Cannot get

I?ve got an Excel workbook with about 30 worksheets. Each worksheet has 10000 rows of data over 30 columns. I?d like to read the data from each worksheet into a dataframe or matrix in R for processing. Normally, I use read.csv when interacting with Excel but I?d rather manipulate a multisheet workbook directly than set about splitting the original workbook and saving down each part as a csv.

Dear R People: I have been experimenting with rPython, rSymPy, and rJython. Here is my latest snag: > library(rJython) Loading required package: rJava Loading required package: rjson > library(rSymPy) > rJython <- rJython() > x <- "x" > y <- "y" > rJython$exec("from sympy import *") Error in .jcall("RJavaTools",

Hello everybody, I'm running R under Mac OS 10.6.3 on a MacBook 2.16 GHz Intel Core 2 Duo. I've recently installed R 2.11.0 and the RImageJ library v. 0.1-142. When trying to follow the example given in the package manual and I get the following error: download.file( "http://www.google.fr/intl/en_en/images/logo.gif", dest = "google.gif" ) trying URL

I am experimenting with rSymPy, and it seems to work nice. However, I dislike the need to wrap all sympy expressions within quotes, it leads to ugly calls like library(rSymPy) Var("x,y,z") sympy("(x+y)**2") and so on. Inspired by the function cq from mvbutiles package: library(mvbutils) > cq function (...) { as.character(sapply(as.list(match.call(expand.dots =

I think remember this error from trying to write an Excel file that already existed. If this file already exists, try to delete it and see, if this solves the issue. Besides that you're writing that you are "Using write.xlsx to extract data from an Excel file", write.xlsx() is to write an Excel file, not to read from it. Should be read.xlsx() then iirc. ? ? Gesendet:?Freitag, 15.

Estimada Lorena Creo que lo comentado por Miguel y su interpretación de memoria son correctos, pero me permito una prueba, desde Rcmdr hay una opción para importar datos de Excel, esa alternativa ¿también falla?. Me refiero a intentar abrir un archivo con los datos que necesita, por las dudas en que aparezca algún mensaje distinto, que no creo, pero son solo 10 segundos de prueba. ¿Puede

Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we get the following error, when trying to write the data frames to the excel sheets: Error in ls(envir = envir, all.names = private) : invalid 'envir' argument We figured out that

Readers, Openjdk and ibm java versions have failed to install, all reporting a bad elf, e.g. ./ibm-java-i386-sdk-7.0-0.0.bin Preparing to install... Extracting the JRE from the installer archive... Unpacking the JRE... Extracting the installation resources from the installer archive... Configuring the installer for this system's environment... strings: '/lib/libc.so.6': No such file

Hi, I have a bit of a problem with as.numeric or as.double. I read in an excel-file (either xlsx::read.xlsx2 or gdata::read.xls). Select a subset and then try to make it numeric: # read in the excel-file alldata<-read.xlsx2("input.xls",1) # select the subset s<-subset(alldata, select=c("cI","cII","cIII","cIV","cV")) # unluckily

Colleagues, Using write.xlsx to extract data from an Excel file, I get this error message. Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", cl, : java.lang.OutOfMemoryError: GC overhead limit exceeded I was thinking that this might be a RAM issue but with 16 GB RAM, I wasn't expecting this error message. Any guidance would be

? Thu, 14 Mar 2024 14:12:12 +0000 Subia Thomas OI-US-LIV5 <Thomas.Subia at draexlmaier.com> ?????: > Using write.xlsx to extract data from an Excel file, I get this error > message. > > > Error in .jcall("RJavaTools", "Ljava/lang/Object;", "invokeMethod", > cl, : java.lang.OutOfMemoryError: GC overhead limit exceeded There seems to be a

Hola Lorena. Te recomiendo que uses XLConnect para trabajar con ficheros Excel. Esta recomendación está basada en mi experiencia personal, no tengo una opinión magistral ni razones para convencerte. Simplemente, a mí es lo que mejor me ha funcionado (que, seguramente, no coincidirá con un montón de gente de la que lee esta lista). Eso sí... independientemente de los paquetes que uses... los

Dear All, I'd like to use Weka functions that are not implemented (do not have interface) in RWeka, like the Remove function and others in the future! The .java() functionality is for that purpose but I haven't seen any example with Weka functions. Could anyone give me hand in how to do it? For instace if I want to use the weka.filters.unsupervised.attribute.Remove? 1. in the R console,

hi on my device i can sample only at 32khz and want to use speex at 16khz so i need to down-convert the input signal by factor of 2. does anyone provide me a reference to some code that does that? are there any trick to do that? i tried to add to subsequent sample but the result was very bad. what are the requrment from a decimation filter for audio? thanks, nir -------------- next part

Hello everyone, im runing a java program under Wine, but sometimes when i try to get some report in the report viewer which is an smaller DLL app, it Crash giving a message in the console, On Windows XP, the same program and JVM version runs perfectly. Here Is the the message: # # An unexpected error has been detected by Java Runtime Environment: # # EXCEPTION_ACCESS_VIOLATION (0xc0000005) at