[R] Re ading multiple Excel 2007 files with a loop

I have several hundred Excel 2007 data files in a folder. I would like to read every file in a single given folder using a loop. I have searched the FAQ, the forum archives here, other or older R boards and the R Import / Export documentation, and have asked some very knowledgeable R users

Re: [R] Re ading multiple Excel 2007 files with a loop

Thank you for all of the responses. They were all very helpful. The best response came from a gentleman at Berkeley who suggested I change the channel statement to that used below: Mark Miller Gainesville, Florida library(RODBC) setwd(U:/test folder) fname -

[R] splitting scientific names into genus, species, and subspecies

I have a list of scientific names in a data set. I would like to split the names into genus, species and subspecies. Not all names include a subspecies. Could someone show me how to do this? My example code is: a - matrix(c('genusA speciesA', 10, 'genusB speciesAA', 20,

Re: [R] re placing NA in character column

I am guessing that your NA is not really an NA_character, but rather a factor with a level of NA. See if str(s1) confirms my suspicions. df1 - read.table(textConnection( Firstname Lastname Age + 1Bob Smith 20 + 2 John Clark NA + 3 Andy NA40), header=T)