[R] Splitting Data Into Different Series

uot;date", "value", "code"))) dados433 <- matrix(data = NA, nrow = 6, ncol = 3, byrow= FALSE) dados2005 <- matrix(data = NA, nrow = 6, ncol = 3, byrow= FALSE) dados3939 <- matrix(data = NA, nrow = 6, ncol = 3, byrow= FALSE) for(i in seq(along=dados[,3])) {

Re: [R] Splitting Data Into Different Series

Dear Rui and Arun, Thanks a lot for your help. I will test all the proposed solutions ;-) Best regards, Henrique Andrade 2012/8/6 Rui Barradas : > Hello, > > Try the following. > > split(data.frame(dados), dados[, "code"]) > > Also, it's better to have dat

[R] Saving Splitted Series to Excel via XLConnect

(c(1,2,3,4,5,6,7,8,9, 10,11,12,13,14,15,16,17,18),c("date","value","code" dados2 <- split(dados, dados$code) dados2 library(XLConnect) wb <- loadWorkbook("Teste.xlsx", create = TRUE) createSheet(wb,

Re: [R] Saving Splitted Series to Excel via XLConnect

Dear Arun, Thanks a lot for your help, but I really need to save the splitted data in a Excel file (xlsx or xls). This is because I will need to make links between different Excel workbooks. Best regards, Henrique Andrade Enviado via iPhone Em 08/08/2012, às 17:25, arun escreveu: > Hi, &g

Re: [R] Saving Splitted Series to Excel via XLConnect

t;- (3*i) - 2 writeWorksheet(wb, dados2[[i]], sheet = "Planilha", startCol = column)}) saveWorkbook(wb) I did not use the option to build a new sheet for each "i" because I have more than 200 objects in my real problem. Again, many thanks to you guys! Best regard