similar to: append something to an xls file

Dear R Users, I apology for not being able to provide an adequately informative subject. Let me describe my problem with an example. For a matrix * (mat <- matrix(c(1,1,2,2,2,3,3, 5,9,1,3,7,4,8), ncol = 2))* my desired output is * (desired <- matrix(c(1,2,3, 5,1,4), ncol = 2))* That is, the first column is numerically grouped and only the first item in each group is wanted. The

Dear R users: I am drawing a graph with the following code: Tau<-seq(0.05,0.95,0.05); Pi <- seq(0.19,0.01,-0.01); par(cex.axis=0.8,ps=9,mar=c(1.5,1,0.5,1), oma=c(1,1,0.2,1) ,tck=-0.01); plot(Tau,Pi, type='l', xlab="Tau",ylab="Pi",col=4); I want to make the graph take as little space as possible. Here I run into two problems. One is that the labels are gone, the

Dear R users, I am leaning MCMC sampling, and have a problem while trying to sample exponential r.v.'s via the following code: samp <- MCMCmetrop1R(dexp, theta.init=1, rate=2, mcmc=5000, burnin=500, thin=10, verbose=500, logfun=FALSE) I tried other distribtions such as Normal, Gamma with shape>1, it works perfectly fine. Can someon

Dear useRs, Can someone help me to adjust the color of math annotation in a legend? The following code gives me a black "alpha = 2". x=y=1:100 z=seq(0.5,50,by=0.5) plot(x,y,type='l',col='black') lines(x,z,col='red') legend('topleft',c(expression(paste(alpha," = ", 1)), expression(paste(alpha," = ",

I can currently append an entire worksheet with write.xls, but would also like to be able to append within the same worksheet. Is this possible? It doesn't seem to work if I use append = T Thanks, Mark -- Mark W. Kimpel MD Neuroinformatics Department of Psychiatry Indiana University School of Medicine

I remember in one slide of Prof. Ripley's presentation overhead, he said the most popular data analysis software is excel. So is there any resource or tutorial on this topic? Thank you so much!

One can import data from Excel ODBC source, but of course it is user's responsibility to ensure that the data are consistent. Each worksheet in the Excel workbook can be accessed as a table (for example, for Sheet1, you should type "select * from [Sheet1$]". The worksheet should have first row containing the column names, and the data rows should follow (the

Hi, If I open up a worksheet in MS Excel 97, the file name is modified by appending an extra .xls to the name. Multiple .xls's are possible, and it is not necessary to save the worksheet. I'm running Wine-20010305 compiled on a SuSE 7.0 running a stock 2.4.2 Linux kernel. MS Excel is being run from an existing Win98 system partition. Thought someone might want to know, Dick --

Hi, i'm using read.xls, and it counts more rows in my Excel than I really have. i've used both: especie26 <- read.xls("especie26cargar.xls") datos26 <- read.xls("especie26cargar.xls", header = TRUE, as.is = FALSE, na.strings = "NA", skip = 0, check.names = TRUE, fill = FALSE, strip.white = FALSE, blank.lines.skip = TRUE) when i

Hi, I encountered a problem of not being able to read in an excel spreadsheet using read.xls() in the xlsReadWrite package. can anyone help? Here is an example code write.xls(matrix(1:9,nrow=3),"ttt.xls") read.xls("ttt.xls") Error in read.xls("ttt.xls") : Unexpected error. Message: Can't find the file "ttt.xls" The "ttt.xls" file was

Dear R users, I've learned today about RODBC package in order to import xls file to dataframes and export the dataframes to xls files. However I have some problems. Please excuse me if these are basic but as I said, I've just begun with this package. Also this email is quite long, but everything is related, so I don't think it would be better to split it. Moreover, there's a

Jorge was kind enough to point out that I made a mistake in referencing gabor's solution. See below. Thanks Jorge. -------- Begin forwarded message -------- Subject: Re: [R] Writing xls - multiple sheets Date: 3/12/2009 6:03:13 PM From: Jorge Ivan Velez To: markleeds@verizon.net Hi Mark, Yes, he did (as always), but it is not what Ferry needed. Here is Gabor's post:

Hi, How can I write the output to an excel (csv) file without printing row names (i.e without breaks). Here is my code: library( fn <- function() { q <- c(1,2,3) write.csv(q,"C:/Temp/op.xls", append = TRUE, row.names = FALSE,quote = FALSE) } # Function Call for(i in 1:3) { fn() } Present Output : x 1 2 3 x 1 2

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

Hello, I am using 3.0.15pre2. Share definitions: [Grupes] path = /home/Grupes writeable = yes admin users = DOMAIN+administrator valid users = @"DOMAIN+domain users" store dos attributes = yes map hidden = no map system = no map archive = no dos filemode = yes File ACLs before opening: # file: Pazymejimai-forma2.xls # owner: root # group:

Hi all, There have been quite a few threads in the recent months pertaining to the ability to directly write native Excel (.xls) files from R. For example, exporting R matrices and/or data frames to an Excel file, with perhaps the ability to create multiple tabs (worksheets) within a single file, with one tab/sheet per R object. There exists the xlsReadWrite package on CRAN by Hans-Peter Suter,

Hi all! I recently had a problem with a shared excel file which was rsynced from the file- to the backupserver. The backups of this file went wrong and I can't figure out why. The whole rsync and dump to tapes works like charm for a few month now. The situation was as followed. That xls lived (and was backuped) happily for 5 days. Then the users startet to share this file among 4 or 5 people.

I have attached a file downloaded from database mirWalk. Apparently it is in XLS format (this is the extension of the downloaded file). However, I cannot open it with OpenOffife spreadsheet program and Excel itself cannot separate the columns as it does when a true XLS file is loaded. I tried to read the attached downloaded file through R function "read.xls" and got the following

Hi, I would like to find a way to append data to an excel file through each iteration of a for loop. Is there a way to use a command such as write.table and append each iteration to a different sheet? Thanks [[alternative HTML version deleted]]

R 2.0.0 patched under win2000. MS Office Excel 2003. ODBC Drivers? This may not come as a surprise -- sqlFetch() (and perhaps other ?) appear not to handle table/worksheet names with spaces in them in Excel tables. I was not able to find documentation that specifically mentioned this, although the Help pages vaguely hinted that there might be difficulty with Excel's "peculiar