merging multiple frequencies tables
1
0
Entering edit mode
10 weeks ago
Lapsus • 0

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

otu table merging frequencies • 178 views
ADD COMMENT
0
Entering edit mode
10 weeks ago
Lapsus • 0

UPDATE: I have solved the problem using a R function that I have found online!

ADD COMMENT

Login before adding your answer.

Traffic: 2221 users visited in the last hour
Help About
FAQ
Access RSS
API
Stats

Use of this site constitutes acceptance of our User Agreement and Privacy Policy.

Powered by the version 2.3.6