similar to: gdata selectively not working

Hi list, I would like to capture the console output of a Perl script by running the script from R. I have tried the following: # Create perl script cat( 'print "Hello World\n";',file="hello.pl" ) # Trial 1 system(command="c:\\Perl64\\bin\\perl hello.pl") -I saw no output for the above command. I have used this method before to run perl scripts that

I have a user who wants a version of Perl built with -Duse64bitint that is accessable as perl64. I've pulled down the src.rpm and I'm going through the perl.spec file looking to see what all needs to be changed. So, before I really screw up my system, I thought I would ask if anyone here has any particular advice. Help? -- Matt

Hello I am trying to import an Excel file but I am loosing the headers, My headers are in the first to rows of the EXCEL file. In the following R output, the NA are supposed to be the second item in the Header. Is there any way to Import more than one row as headers?. Thank you Felipe Parra > Data<-odbcConnectExcel('Curva LIBOR.xlsx',readOnly=T,) >

I've suddenly started seeing a consistent problem with read.xls. No matter what xls file I try I always get an error message of this type: Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file '/var/folders/cb/vvshkpm90lx_y2n69qlyw4z40000gn/T//RtmpK50r4g/file546a2722.csv' missing! In addition: Warning message: running command

I've created a Perl script that translates Microsoft Excel (.xls) files into comma-delimited text files (.csv) using the Perl Spreadsheet::ParseExcel module. Usage ----- perl xls2csv.pl <excel file> [<output file>] [<worksheet number>] Translate the Microsoft Excel spreadsheet file contained in <excel file> into comma separated value format (CSV) and store in

Dear All, When I use read.xls() in gdata package to read xls files, I noticed an issue and couldn't find any solutions after I serched all previous posts. In the excel file, the number value, for example, is actually 2.3456789 but formatted as 2.3 (Format Cells ---> Decimal places:1). After I use read.xls() to import the excel file, I found that, in R, this number is read as the formatted

Hi: Im trying to use gdata 1.1.2 on a rails3 ruby1.9 project I added gem ''gdata'' to Gemfile but keep getting the error: uninitialized constant GData:: I installed the gem with no problem Does anybody knows how to setup rails3 with gdata? I''ll really appreciate any advice -- You received this message because you are subscribed to the Google Groups "Ruby on

I wanted to install the package "gdata". Here are the commands I gave and the responses: install.packages("gdata") Warning in install.packages("gdata") : argument 'lib' is missing: using '/Users/dbae/Library/R/library' trying URL 'http://cran.uk.r-project.org/bin/macosx/universal/contrib/2.8/gdata_2.4.2.tgz' Content type

Hi one col in my Excel file contains many numbers. But on line 3000 and some other lines are strings like "FG 1". "RODBS" seems to omit this lines. "gdata" works, but is much slower. Is this a bug of RODBC or do I apply it wrong? Example with the same "file.xlsx" library(RODBC); excel <- odbcConnectExcel2007("file.xlsx") tab <-

Hi Using R 2.10.1 on a mac os 10.6.2, I have have a problem with gdata package. When I use the command read.xls, I get this error-message: Erreur dans xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Unable to read translated csv file '/var/folders/gb/gbzQ4sqTF-KK3D5m6v-IJE+++TI/-Tmp-//Rtmp3Hprw9/file10d63af1.csv'. Erreur dans file.exists(tfn) : argument 'file'

Dear R-list members, I have a data file with thousands of lines (cases), where each line contains the values of several variables. I would like to separate these lines in small groups, with each group followed by a blank line, to ease the visual inspection of the data in some situations. I am writing the output files with function write.fwf in library gdata, for correct column alignment. Below

Hello, We have submitted the updated version of gdata, gmodels, gplots and gtools to CRAN. Summary of the changes is attached at the end. Best, Nitin ______________________ Nitin Jain, PhD <nitin.jain at pfizer.com> Non Clinical Statistics Pfizer, Inc. (Groton, CT) Bldg: 260, # 1451 Ph: (860) 686-2526 (Office) Fax: (860) 686-6170 Brief description of changes: CHANGES IN GDATA 2.1.2

Hello, We have submitted the updated version of gdata, gmodels, gplots and gtools to CRAN. Summary of the changes is attached at the end. Best, Nitin ______________________ Nitin Jain, PhD <nitin.jain at pfizer.com> Non Clinical Statistics Pfizer, Inc. (Groton, CT) Bldg: 260, # 1451 Ph: (860) 686-2526 (Office) Fax: (860) 686-6170 Brief description of changes: CHANGES IN GDATA 2.1.2

Dear List: I encountered this strange problem. I want to read dates in a R program. This is a sample data: Dates 12/12/08 14/12/08 18/01/08 28/02/08 16/06/08 19/07/08 28/09/08 If I save these dates in a .csv file, and read it in R using "read.csv", I can perfectly read the data, and the commands "months(Dates)", "days(Dates)" work perfectly fine. On the other hand,

Dear all, I have a problem with the function read.xls from the gdata package, error message see below. Two examples: First, I try to read my data, which does not work; Secondly, I tried the example code/data with the Iris data, which worked Any idea? Thanks, Lars > path<-"I:/subProjects/bh/HPGD/" > > setwd(path) > > xls <- "Platten_Liste_090421.xls"

Dear R-list This is just message to inform that the there is an issue with write.fwf in the gdata library (from version 2.5.0 on). It does not seem to accept further arguments to write.table like "eol" as the help file indicates as it stops when executing tmp <- lapply(x, format.info, ...). Great package though - I use it a lot except for this function :) See example below. >

Dear list, I have some .xls files that I need to read into R. I am able to do so using read.xls in the gdata package, however the helper functions sheetNames and sheetCount fail. This is the error: Unable to open file '~/SharedFolder/MyData/mydata.xls'. Warning: running command ''/usr/bin/perl' '/usr/local/lib/R/site-library/gdata/perl/sheetCount.pl'

Dear R People: If I put in: > findPerl Error: object 'findPerl' not found But if I use: > gdata:::findPerl function (perl, verbose = "FALSE") { errorMsg <- "perl executable not found. Use perl= argument to specify the correct path." if (missing(perl)) { perl = "perl" } perl = Sys.which(perl) if (perl == "" ||

I'm trying to make a factor with levels for day of week, appear as Monday-Sunday, rather than alphabetically. I'm using reorder.factor from gdata package, but obviously not using it properly. What am I doing wrong? Thanks. >data <- read.table("DataEarly2008.txt", sep=" ", header=T, as.is=1:2) >str(data) 'data.frame': 7953 obs. of 9 variables: $

Hello eveRybody (and probably special regards to Gabor G....), I recently upgraded from R-2.9.2-win32 to R-10.1.0-win32, and I'm using Windows XP Professional 2002 with service pack 3 on a PC with IntelCore Duo CPU@ 3.00 GHz. Last time I used it (some weeks ago, before upgrading), one of my scripts (including the two lines cited below) used to run OK. When I ran it yesterday evening (after