Re: [R] Spliting a huge vector

2006-09-21 Thread Dave Evens
=diff(c(0, cut.values))) Thanks for all the responses so far. Any additional responses are welcome. Many thanks, Dave --- Dave Evens [EMAIL PROTECTED] wrote: Dear R users, I have a huge vector that I would like to split into unequal slices. However, the only way I can do

[R] Spliting a huge vector

2006-09-20 Thread Dave Evens
Dear R users, I have a huge vector that I would like to split into unequal slices. However, the only way I can do this is to create another huge vector to define the groups that are used to split the original vector, e.g. # my vector is this a.vector - seq(2, by=5, length=100) # indices where

[R] lapply question

2005-07-20 Thread Dave Evens
Dear members, I have numerous arrays that are organised in a list. For example, suppose I have 2 arrays in a list called alist alist - list(array(rpois(12,5), 6:8) , array(rpois(15,5), 10:12)) with array dimnames dimnames(alist[[1]]) - list(LETTERS[1:6], paste(namesd, 1:7, sep=),

[R] reading non-existing files

2005-06-07 Thread Dave Evens
Dear all, I'm trying to read to a collection of files in a loop using odbcConnectExcel - but not all of the files exist. This is the code I have for(i in 1:no.of.subs){ channel - odbcConnectExcel(paste(working.dir, subs[i], .xls, sep=)) datafiles[[i]] - as.matrix(sqlFetch(channel, Data))

[R] reading multiple files

2005-05-24 Thread Dave Evens
Dear All, How do I read in multiple data frames or matrices in a loop, e.g. for (i in 1:n) { channel - odbcConnectExcel(filenames) file[i] - as.data.frame(sqlFetch(channel, sheet)) } I would like file[i] to be the name of the data.frame (i.e. file[1], file[2], file[3],...etc) rather

[R] problem with RODBC

2005-04-20 Thread Dave Evens
Dear all, I'm reading data via the RODBC connection using odbcConnectExcel. I use sqlFetch(channel, sheetx) to identify the correct tab. It appears to read the data without any problems. However, when I exact a portion of data - the row number specified is 1 less than in the actual excel file

[R] grubbs.test

2005-04-14 Thread Dave Evens
Dear All, I have small samples of data (between 6 and 15) for numerious time series points. I am assuming the data for each time point is normally distributed. The problem is that the data arrvies sporadically and I would like to detect the number of outliers after I have six data points for any

[R] Importing data into R

2005-04-07 Thread Dave Evens
I have a highly formated Excel with multiple tabs. Is it currently possible to read this data into R without changing the format of the Excel file? Also, is it possible to write back to the same Excel file or at least create a new Excel file with the same formatting as before with modified