Hi,
I had another question. If you had say a vector (e.g., called data)
with 235 elements and each element looked like the following
data[[1]]
Column A-B Column Z-S Column A-S....
1 2 5 .......
data[[2]]
Column Z-B Column A-S Column A-B....
2 1 3 .......
Anyway, each element consists of one row that lists the names of the
columns and the second row is the counts of those columns. What I
wanted to do is merge all the elements from the vector so that I
aggregate the counts for every column in the vector elements. So if a
column name (e.g., Column A-B) is present in two elements, then I
would want those elements that have the same column name to aggregated
their counts; however, if the column name is unique then I simply just
want to integrate that column with the total. The example below shows
the result of what I mean using the two elements above:
result=data[[1]] + data[[2]].......
Column A-B Column Z-S Column A-S Column Z-B.........
4 2 6
2.......
So what I want would take the 235 elements, aggregate the column names
and counts, and produce one output variable (e.g., called result)
that has all the column names and counts present in the 235 elements.
I tried using sapply, (e.g., sapply(data,function(.df){sum(.df)}) ),
but this only just provided aggregate counts without producing the
column names. I tried an aggregate() function, but that didnt
aggregate my data exactly the way I wanted, perhaps I got the syntax
wrong though. Anyway, is there a better and easier way to do this?
Thanks in a advance again.
Mark
______________________________________________
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.
