search for: nastrings

Hi, I am trying to use sqlSave to write a dataframe to an existing table in a DB2 database. The database contains two schemas. My experience is the following: (1) in the case that tablename is left empty in sqlSave, R writes to the instance level schema (2) in the case that a tablename is specified and that table name exists only once in the database, R will write to that table irrespective

Hi, ?I have a list of files in one of my working directories: "chr17.chunk1.dose.fvd" "chr17.chunk1.dose.fvi" "chr17.chunk1.prob.fvd"? "chr17.chunk1.prob.fvi"? ........... ......... ........ "chr17.chunk10.dose.fvd" "chr17.chunk10.dose.fvi" "chr17.chunk10.prob.fvd" "chr17.chunk10.prob.fvi" And I am

Hi group, I try to write a frame to a table (RODBC). I use colnames(temp6) <- c("ind_id","ser_id","period_id","year","calc","mean") sqlSave(channel, temp6, tablename = "series_indices_test",append= TRUE, rownames=FALSE, verbose = FALSE, test = FALSE, nastring = -999999, fast = FALSE) This is giving me an error: Error in

I am trying to export a dateframe created in R: > Duration_summary V1 2.5 % 97.5 % V4 2.5 % 97.5 % [1,] 1 0.46076018 1.128776 1.000000 0.5280828 0.9576338 [2,] 0 0.00000000 0.000000 1.000000 0.1741793 1.2352705 [3,] 1 0.46566719 1.313711 1.000000 0.7233312 1.4097987 [4,] 1 0.38866371 2.453226 0.976024 0.6377314 1.3493957 [5,] 1 0.08894066 1.036830

I am running R version 2.9.2 on Windows XP OS with RODBC version Version: 1.3-0. Has anyone out there in the R user community successfully appended records to a DB2 table on a remote database using the sqlSave function in the RODBC package? (or by any other means from R?) I posed a similar question a few months ago and unfortunately, did not receive a response. I was hoping recent upgrades to

Natively read and write Excel (.xls) files. Supports Windows 32-bit only (atm). A new version has been released: -- changes -- o read.xls - new arguments 'checkNames' - recognize NA values according to a new 'naStrings' argument - recognize NaN values - recognize 'true', 'false' (not case-sensitive) as logical when determing a class for data.frame column; when the value in the first cell is an integer, a numeric will be assumed nevertheless - colnames are more consistent with R usage...

Natively read and write Excel (.xls) files. Supports Windows 32-bit only (atm). A new version has been released: -- changes -- o read.xls - new arguments 'checkNames' - recognize NA values according to a new 'naStrings' argument - recognize NaN values - recognize 'true', 'false' (not case-sensitive) as logical when determing a class for data.frame column; when the value in the first cell is an integer, a numeric will be assumed nevertheless - colnames are more consistent with R usage...

Dear all, I cannot reading a .xlsm file using read.xls. I executed: read.xls("resultados.xlsm", colNames = TRUE, sheet = 1, type = "data.frame", from = 1, rowNames = NA, colClasses = "character", checkNames = TRUE, dateTime = "numeric", naStrings = NA, stringsAsFactors = F) Error: Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Incorrect number of arguments (11), expecting 10 for 'ReadXls' If I just write read.xls("resultados.xlsm") It give me the same error. Regards, Sebastián. [[alternative...

Hey everyone, I don't have a question. Instead some helpful advice with things I've learned from trying to connect 'R' to databases using RODBC. ROBDC is a very handy tool that, once you have everything fixed up nicely, is a great way to have scripts run fairly autonomously, safe in the knowledge that data isn't accidentally messed up. But I was fairly ignorant

...e R. Estoy tratando de leer un archivo excel con read.xls usando la siguiente sentencia: read.xls("resultados.xlsm", colNames = TRUE, sheet = 1, type = "data.frame", from = 1, rowNames = NA, colClasses = "character", checkNames = TRUE, dateTime = "numeric", naStrings = NA, stringsAsFactors = F) Pero me da el siguiente error: Error en .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Incorrect number of arguments (11), expecting 10 for ''ReadXls'' Si utilizo directamente: read.xls("resultados.xlsm") Me da...

Hello I am trying to move data between R and other systems (e.g. SAS and MS SQL Server) using RODBC. I think I have the most recent version of RODBC (0.9) and here is some other system info: > odbcGetInfo(channel) [1] "Microsoft SQL Server version 08.00.0679. Driver ODBC version 03.52" > version _ platform i386-pc-mingw32 arch i386 os mingw32 system i386,

I am running R version 2.8.1 on Windows XP OS. This works fine. (Data.frame dta is created with records from the DB2 table.): sql <- "select * from storage.testappend_slt order by uut" dta <- sqlQuery(channel,sql) But when I try to append records (from data.frame newdta) to the same DB2 table. I get an error: sqlSave(channel, newdta, tablename = storage.testappend_slt, append

...m http://127.0.0.1:12275/library/xlsReadWrite/html/read.xls.html and put them in the following code... ----------------- data1<-read.xls("Z:/WORK_2012/Data/test.xls",colNames=TRUE,sheet=1, type="data.frame",from=1,rowNames=TRUE,checkNames=TRUE,dateTime="isodate", naStrings=NA,stringsAsFactors=TRUE) Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Incorrect number of arguments (11), expecting 10 for 'ReadXls' ---------------- It would be great if anyone can let me know where the code went wrong and any suggestion on how to...

I am running R version 2.8.1 on Windows XP OS. recs is a one-row, eighteen-column data.frame I want to insert into a DB2 table. sqlSave(channel, recs, tablename = "testappend_slt", append = TRUE, + rownames = FALSE, colnames = FALSE, + verbose = TRUE, oldstyle = FALSE, + safer = TRUE, addPK = FALSE, + fast = FALSE, test = FALSE, nastring = NULL) Query:

Hi R-helpers, I have imported data from Excel using the following code: library(xlsReadWrite) data <- read.xls(data,colClasses=c("character")) and this results in all of the empty (blank) cells in the imported Excel file also being empty (blank) in the resulting dataframe. I am not used to having blanks (rather NAs) and I think these are caused by the colClasses argument. I would

Dear useRs, The seqinR package is a library of utilities to retrieve and analyse biological sequences. A new version of seqinR, seqinR 1.0-7, has been released on CRAN. Here is a summary of changes: o A new *experimental* function extractseqs() to download sequences thru zlib compressed sockets from an ACNUC server is released. Preliminary tests suggest that working with about 100,000

Dear useRs, The seqinR package is a library of utilities to retrieve and analyse biological sequences. A new version of seqinR, seqinR 1.0-7, has been released on CRAN. Here is a summary of changes: o A new *experimental* function extractseqs() to download sequences thru zlib compressed sockets from an ACNUC server is released. Preliminary tests suggest that working with about 100,000

...cols must be inside Excel data area, to/from can be outside - TRUE: rows/cols/to/from must all be inside Excel data area - FALSE: rows/cols/to/from are allowed to be outside the Excel data area - values which cannot be converted become NA (for double it was NaN before) o write.xls - naStrings the DEFAULT CHANGES from NA to '', i.e. cells will be cleared o read.xls/write.xls - rows/cols arguments can be used together. This is kind of subsetting Excel: 'ExcelSheet[<rows>, <cols>]', i.e. 'ExcelSheet[c(3, 4, 6), c(2, 4)]' - colNames - supports...