Hi, I am analyzing a huge excel table with OTUs. In the table, I have 2910 columns and 365 rows.Each column represents one individual (n=2910). Rows represent microbial species (n=365). I have the total of all OTUs of microbial species under each column. Then I need to get the percentages of each species in each individual.I started to do this in excel but I have to repeat this for 2910 times which is going to be very time-consuming. I am sure there should be a smart way to do this and just wondering whether there is any R script to do this.Any help is much appreciated. Many thanks, Thilini
*Thilini Jayasinghe* PhD Candidate Liggins Institute The University of Auckland Building 503/201, 85 Park Road, Grafton, Auckland 2023 Mobile: +64 220211604 Email: [email protected] [[alternative HTML version deleted]] ______________________________________________ [email protected] mailing list -- To UNSUBSCRIBE and more, see 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.

