joining multiple lists
I'm not sure that merge will do what you originally requested. At least look at rbind before deciding to go with merge.
On Apr 23, 2009, at 9:30 PM, Daniel Bradley wrote:
Merge()! Thanks! On Fri, Apr 24, 2009 at 11:26 AM, Daniel Bradley <dannyboy477 at gmail.com
wrote:
Hi! I'm reading and cleaning data from multiple excel spreadsheets. All the data has the same column names and the natural next step is to join the lists of data together to make one list for reporting purposes. I had thought that c(file1data, file2data) would do the trick but that seems to append the new columns to the list so I end up with duplicate column names "col1" "col2" "col3" "col1" col2" "col3" rather than consolidated column data. It's obviously a straight forward operation, but damned if I can find a straight forward explanation on the web. Any assistance would be most appreciated!
David Winsemius, MD Heritage Laboratories West Hartford, CT