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 <dannyboy...@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

______________________________________________
R-help@r-project.org mailing list
https://stat.ethz.ch/mailman/listinfo/r-help
PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
and provide commented, minimal, self-contained, reproducible code.

Reply via email to