Kristi, Several people have already suggested you use dput() to provide your data.
In R, dput(table1) dput(table2) Then copy and paste the output of those commands into your email. There's no way to reliably copy and paste your raw data: using dput() is the best way to provide it. Sarah On Thu, May 10, 2012 at 1:18 PM, Kristi Glover <kristi.glo...@hotmail.com> wrote: > > Hi R-usuar, > I still find the table is not in readable formate. I now forwarded the > email.hope it works. I sent it to my account . It was perfect- but when I > sent it to R help- then it comes with unreadable formate. This is my last > try. If not, then I will try to do in Excel manually. cheers, > > From: kristi.glo...@hotmail.com > To: kristi.glo...@hotmail.com > Subject: RE: [R] averaging two tables (rows with columns) > Date: Thu, 10 May 2012 14:06:41 -0300 > > > > > > Hi John , Petr and R userI am sorry that my data was not readable formate in > the last email. Agin I am trying to send it. hope this time, that table can > be readable. > As I mentioned earlier that I was struggling to figure out on how I can > calculate the average from the two tables in R. Any one can help me? really > your helpwould 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 occurrence data> table1 X speciesX speciesY speciesZ > speciesXX1 Plot1 1 0 1 02 Plot2 0 > 1 1 03 plot3 1 0 0 14 plot4 > 0 0 1 0 > > Table 2: table 2. species tolerance data >>table2 X EnviA EnviB EnviC1 SpeciesX 0.21 0.40 0.172 >>SpeciesY 0.10 0.15 0.183 SpeciesXY 0.14 0.16 0.19 > > You may noticed that table 2 does not have species Z which was in table > > Table 3: 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: averages species tolerance in each plot based on EnviA > such as: >> table3.a X speciesX speciesY speciesZ speciesXX average1 plot1 0.21 >> NA Nodata 0.14 0.1752 plot2 NA 0.1 Nodata >> NA 0.1003 plot3 NA NA Nodata 0.14 0.1404 plot4 >> 0.21 NA Nodata NA 0.210Table 4 > >> table3.b: Result table 1b: average species tolerance in plot based on EnviB >> X speciesX speciesY speciesZ speciesXX average1 plot1 0.4 NA >> Nodata 0.16 0.282 plot2 NA 0.15 Nodata NA >> 0.153 plot3 NA NA Nodata 0.16 0.164 plot4 0.4 >> NA Nodata NA 0.40 > I hope this time the data would be readable formate. Would any one help me > how I can calculate these?Thanks > Kristi Golver== > > > >> Date: Thu, 10 May 2012 08:01:11 -0800 >> From: jrkrid...@inbox.com >> Subject: RE: [R] averaging two tables (rows with columns) >> To: kristi.glo...@hotmail.com; r-help@r-project.org >> >> Kristi, >> Your data has come through in a totally unreadable layout. >> >> Have a look at ?dput as a handy way to present sample data. Just run >> dput(mydata), copy the output and paste into the email. >> >> John Kane >> Kingston ON Canada >> ______________________________________________ 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.
