I have many different datasets from different samples. Each of these has two columns: A - species list and B - counts. Not all of these species are present in each of my samples therefore I would like to merge these columns together and when one of these species is not present it will be NA/zero.
In summary my new merged dataset needs to have: column A with all the species list and the following columns with the species counts for each of my samples.
I have done this with "full.join" but when I have many datasets to merge, this is not convenient anymore. I guess I would need to build a loop but I am not really good at it yet and I'd need some help.
Any help would be more than appreciated, I am stuck.
Thanks in advance