combining elements in a data frame

Hi:

Q1: Try something like

# Formula interface works for R-2.11.0 and later versions
RTavg <- aggregate(RT ~ word, data = alldat, FUN = mean)
merge(CCCW, RTavg, by.x = row.names(CCCW), by.y = 'word', all = TRUE)

If the merge doesn't work (which is entirely possible), you might want
to define a variable word in CCCW first and then try again with
something like
merge(CCCW, RTavg, by = 'word', all = TRUE)

IIRC, all = TRUE keeps words from both data frames filling missing
values with NA, all.x keeps everything from the first argument of
merge() and all.y keeps everything from the second argument. If you
omit the option, it returns only the words that occur in both data
frames. From your description, it appears you want all.x = TRUE where
x = CCCW. See ?merge for specific details.

Q2:  See ?table and ?ftable

Utterly untested code in the absence of a reproducible example, so
caveat emptor.

Dennis

On Thu, Jul 14, 2011 at 9:17 PM, Lee Averell

combining elements in a data frame

Thread (2 messages)