Hi to everyone,
I need help to figure out how to merge multiples frequencies CSV files, adding headers as filenames, don't have duplicate in rows and adding 0 if species are absent in that sample.
I write an example:
table_1.csv
Spongiibacter marinus,62
Vibrio owensii,54
Vibrio azureus,53
table_2.csv
Pseudohongiella nitratireducens,52
Vibrio owensii,52
Vibrio thalassae,51
table_3.csv
Alteromonas oceani,49
Motilimonas pumilua,45
Spongiibacter marinus,62
what I would like to obtain is:
Species, table_1.csv, table_2.csv, table_3.csv
Spongiibacter marinus, 62 , 0 , 62
Vibrio owensii, 54 , 52 , 0
Vibrio azureus, 53 , 0 , 0
Pseudohongiella nitratireducens, 0 , 52 , 0
Vibrio thalassae, 0 , 51 , 0
Alteromonas oceani, 0 , 0 , 49
Motilimonas pumilua, 0 , 0 , 45
I have seen several similar topics but none have been helpful in achieving this result
Really thanks to who will kindly help me! Cheers
