search for: plan1

.... library(RODBC) # required for those who want to repeat these lines 1st, I noticed that the following sequence does not work: channel <- odbcConnextExcel("test.xls") tables <- sqlTables(channel) name1 <- tables[1, "TABLE_NAME"] # this should be the name plan1 <- sqlFetch(channel, name1) # bang! odbcClose(channel) However, I can circumvent this with: channel <- odbcConnextExcel("test.xls") tables <- sqlTables(channel) name1 <- tables[1, "TABLE_NAME"] # this should be the name plan1 <- sqlQuery(channel, sp...

...got an excel file as attached. I imported it successful with the commands: library(RODBC) channel <- odbcConnectExcel("data2.xls") tables <- sqlTables(channel) # list the names of the spreadsheets name1 <- tables[1, "TABLE_NAME"] # get the name of the 1st spreadsheet plan1 <- sqlQuery(channel, sprintf("select * from [%s]", name1)) odbcClose(channel) # close it Now I want to store each row in variable. Additionally the result should be a list again so that I can handle each entry for itself. Ideas? Perhaps a list again? Now I want to find on the one ha...

...<- sprintf("%s_mean", itemName); resultNames <- c(resultNames, newColumnName) } LVMean = mean(result, na.rm=TRUE); result <- cbind(result, LVMean) resultNames <- c(resultNames, "LVMean") names(result) <- resultNames; return(result) } rPlanning <- data.frame(plan1, plan2, plan3, plan4, plan5, plan6, plan7) a <- groupMeanForAllItems(rPlanning, u_proj) print(a) ## end ######## Output: groupname plan1_mean plan2_mean plan3_mean plan4_mean plan5_mean plan6_mean plan7_mean LVMean 1 a 4.375.000 5.625.000 5.500.000 5.250.000 6.500.000 4.375.000 5.125.000 N...

Hello all, my first project is on it''s way, and I am loving it! But, and that''s a big BUT: Active Record does not use prepared statements! How is that? Everybody is bragging about performance and the most obvious tuning measure is missing. Ok, I don''t know, if MySQL can even do them as I am using Postgres, but still. I started looking at the code and it is not

Dear R-experts, It is a quite stupid question but please help me. I am very confuced. I am able to import normal txt ant mat-files to R but unable to import .xls-file I do not understand the online help. Can please anyone send me the corresponding command lines? The .xls-file is attached. In my file we use commas for the decimal format (example: 0,712), changes might be needed. Thanks, Corinna

Hello, I have this in excel Control 543_BU 123_AT 432_CU I want to be able to import to R so that it will read like this c<-c("543_BU","123_AT","432_CU") output: [1] "543_BU" "123_AT" "432_CU" This is just a short version. I have about 200000 rows and i need a simpler way instead of typing each one. thanks -- View this message