similar to: strange behavior of RODBC and/or ssconvert

Hi, I had some excel files that I needed to read into R, there were alot so I didn't want to do them by hand in gnumeric. I tried all the recommendations in the data import/export manuals, including RODBC, and for some reason they all failed on these files. Then I stumbled on ssconvert, a script that wraps all gnumerics converters, see

Unsubscribe -----Original Message----- From: r-help-request at r-project.org Date: Wed, 05 May 2010 12:00:09 To: <r-help at r-project.org> Subject: R-help Digest, Vol 87, Issue 5 Send R-help mailing list submissions to r-help at r-project.org To subscribe or unsubscribe via the World Wide Web, visit https://stat.ethz.ch/mailman/listinfo/r-help or, via email, send a message with subject

I''m currently new to Rails and Ruby and I''m trying to learn from my mistakes, this time I''m trying to upload 2 files from a form for later processing, however, after I hit the "Submit" button. I keep getting this error: TypeError in UploadFilesController#create app/controllers/upload_files_controller.rb:28:in `new''

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.

Hello, I use a software that outputs the data in a form/dialect(?) of xml (I think its called "SpreadsheetML", see below for an excerpt). It allows (admittedly) easy import of such files into Excel. I would like, however, to import it directly into R. I am familiar how to do that with standard xml-files (mostly thanks to Duncan Temple Lang's help). But I haven't found the right

Hi Peter, The ssconvert tool (part of gnumeric) is very good at converting spreadsheets to csv-files. There is a wrapper in the "gnumeric" package on cran. Cheers, Thomas > Date: Fri, 4 Oct 2013 09:08:50 +0100 > From: Barry Rowlingson <b.rowlingson at lancaster.ac.uk> > To: Peter Maclean <pmaclean2011 at yahoo.com> > Cc: "r-help at r-project.org"

hello perl experts i am working with "ast-rad-acc.pl" from http://www.voip-info.org/tiki-index.php?page=PortaOne+Radius+auth i dont know why $cdr{'DNID'} and $cdr{'CALLERID'} under 'sub send_acc {' are empty. i m successfully connected with asterisk manager and when call i hangup my perl application is getting that all other thing are ok but i dont know why only

Dear R-community, I'm analysing some noise using the nlme-package. I'm writing in order to get my usage of lme verified. In practise, a number of samples have been processed by a machine measuring the same signal at four different channels. I want to model the noise. I have taken the noise (the signal is from position 1 to 3500, and after that there is only noise). My data looks like

Estimad en s, Junto con saludar, quería saber si alguien me podría ayudar con este gráfico, tengo un análisis de datos del año 2016 de 3 variables con dos dimensiones (muestra objetivo y muestra lograda), y quería agregar la comparación con el año 2015, me gustaría agregar un gráfico de linea y puntos para el año 2015, pero no he podido lograrlo , la idea es generar un gráfico de esta forma.

I imported a spreadsheet into a variable sh e.g. sh$aaaa, sh$bbbb, etc... doing the following: tsSource <- ts(paste("sh$",NAMEVARIABLE,sep="") ... ) fails. The paste isn't evaluating properly. What is the proper way to concatenate a data source with a member name such that they evaluate properly. actual code below: doEnv <-

Hi All, I'm using R 2.11.1 on 64 bit windows XP. The little function I wrote below I use often to import the first 1001 lines in an excel sheet to R. This works fine on the 32 bit version of R but fails on the 64 bit [both on the same machine, using the same function, importing the same .xls file]. The message from 64 bit R is: Error in sqlTables(channel1) : first argument is not an

Ilio Fornasero writes: > Yet, I am at this point. > > > > > ## 01. Finding the dataverse server and making a search > Sys.setenv("DATAVERSE_SERVER" =3D "dataverse.harvard.edu") > dataverse_search(".Hunger") > > > ## 02. Loading the dataset (in this example, I have chosen the word ".Hunge= > r" to get > # one list and

Hi all, I'm new in the list, and I have a problem upgrading from asterisk 1.2 to asterisk 1.4: There is a diference from asterisk1.2 to asterisk1.4 in AMI events. When I do a call to a queue (with the same extensions.conf dial plan) with ast1.2 and ast1.4, in ast1.2 apper 3 newcallerid event in ast1.4 apper only 2. It is normal? anyone knows it? what is the reason? I

Hello, I'm having some difficulty getting Icecast working. I was able to use Icecast and shoutcast when they were both installed on the same Windows XP box, but when I moved icecast to a Linux box, the same icecast.xml configuration doesn't seem to work. I am able to connect to Icecast using shoutcast streaming source and stream the mp3 source to Icecast, however whenever I attempt to

I have tried to compile the working Fortran-90 routines (see attachment) to interface them with R. The compiler automatically caled by R CMD command line prints a bunch of error messages (as follows). I think I'm better off translating the Fortran implementation into R ... which is what I hoped I could avoid. Maura host705:Desktop mauede$ R CMD SHLIB ford.f90 gfortran -arch i386

I'm running Asterisk CVS-v1-0-12/20/04. I'm using PHP with Manager API Here is the code: #################################################################### # Make call #################################################################### $socket = fsockopen($ask_db,"5038", $errno, $errstr, $timeout); if (!$socket) { echo "$errstr ($errno)<br /\n"; } else {

Hello, I have a number of Excel .xlsx files that aren't indexed properly. To illustrate, I have a file called "this is a test.xlsx". It consists of four cells: | this | | is | | a | | test | It gets indexed but I am unable to search for it. I was able to determine the index number and use delve to see the term list: #delve users -r 16496 Term List for record #16496:

Buen día, Estoy extrayendo solo una parte de texto de una celda en Excel, pero tengo un inconveniente. Quiero extraer el texto desde donde dice *textura* hasta el siguiente punto, pero hay unas celdas que dicen *texturas* y me está extrayendo también ésta *s*, cómo podría cambiar el siguiente código para que me extraiga tanto textura como texturas. Quedo muy atento, gracias. rm(list = ls())

Estimados Como logro en el forest plot que el gráfico quede en unos margenes que se pueda ver completo. Adjunto archivo saludos José library(readxl) Sistolica <- read_excel("000 EN DISEñO/0000 eli cardio 2/0000 para metanalisis/Sistolica.xlsx") library(meta m <- metacont(Ne, Me, Se, Nc, Mc, Sc, studlab=paste(Author, year), forest(m) funnel(m) ------------ próxima

Estimados En este modelo no puedo hacer el plot(svmfit,df11 ) #AQUI NO TRABAJA Le adjunto Excel library(readxl) df11 attach(df11) df11$fallecido=factor(df11$fallecido) # Selección de una submuestra del 70% de los datos set.seed(101) tamano.total <- nrow(df11) tamano.entreno <- round(tamano.total*0.7) datos.indices <- sample(1:tamano.total , size=tamano.entreno) datos.entreno <-