averaging two tables (rows with columns)
Hi as already mentioned your data can not be deciphered. Use dput(table1) for sending usable data.
From what you describe probably
?aggregate can be used. But without suitable data you hardly get any advice. Regards Petr
Hi R user,I am struggling to figure out on how I can calculate the
average
from the two tables in R. Any one can help me? really your help would
be
grateful- I am spending so much time to figure it out. It should not be
so
hard, I think. I have very big data but I have created a hypothetical data for
simplification.
for example I have : table 1 table 1: species occurance data speciesX speciesY speciesZ speciesXX Plot1 1 0 1 0 Plot2 0 1 1 0 Plot3 0 0 0 1 Plot4 1 0 1 0 Table 2 table 2. species tolerance data EnviA EnviB EnviC speciesX 0.21 0.4 0.17 speciesY 0.1 0.15 0.18 speciesXX 0.14 0.16 0.19 You may noticed that table 2 does not have species Z which was in table
1.
Now I want to get the average value of species tolerance in each plot based on each environmental value (EnviA or EnviB etc)The example of the
out come (final table I was looking for it) Results table 1a: average species tolerance in each plot based on EnviA Result Table 3. Average species tolerance in each plot based on EnviA speciesX speciesY speciesZ speciesXX Average Plot1 0.21 NA Nodata 0.14 0.175 Plot2 NA 0.1 Nodata NA 0.1 Plot3 NA NA Nodata 0.14 0.14 Plot4 0.21 NA Nodata NA 0.21 Result table 1b: average species tolerance in plot based on EnviB Table 4. Average species tolerance in each plot based on EnviB speciesX speciesY speciesZ speciesXX Average Plot1 0.4 NA Nodata 0.16 0.28 Plot2 NA 0.15 Nodata NA 0.15 Plot3 NA NA Nodata 0.16 0.16 Plot4 0.4 NA Nodata NA 0.4 Would any one help me how I can calculate these?Thanks Kristi Golver====== [[alternative HTML version deleted]]
______________________________________________ R-help at 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.