How do i merge more than two csv files in r studio based on gene_id and log2.fold_change? Is there a easy code or package for it? Thank you.
I believe the standard way to do this is by successively merging into a resulting dataframe. That is, if you wish to merge e.g. [1,2,3,4,5], you'd do merge(1, merge(2, merge(3, merge(4, 5) ) ) ). This is actually supported explicitly in Pandas — one place where I wish R's dataframes had the same built-in capabilities.
merge(1, merge(2, merge(3, merge(4, 5) ) ) )
The fastest way to do this is with the dplyr package. This follows the same procedure as Rob mentioned in his comment above, but using dplyr::inner_join() is much faster.