This is a test version of Biostars. For the public version, visit https://www.biostars.org.
How to link non-unique colnames in two different files ?

I have a file1 with example col names as follows xyz-123 xyz-234 abc-345 abc-789. Another file2 with row names xyz abc. How to link file2 and file1 using row names of file2. Please note xyz-123 xyz-234 have different information from same patient. I need to link those files and process into edgeR. File1 is rna sequencing data while file2 is patient metadata. Thanks

r dplyr
• 736 views • link
written by Björn • Björn

Have you tried anything yet?

• 0 views • link
written by ATpoint ATpoint

You don't provide enough information for us to provide helpful answers. Besides, similar questions have been asked several times before (see join on the command-line, or merge() in R):

How to merge column text files using terminal command?

compare and search a list of ids in two text file

Perl :Help to match two IDs from two tables and print to a .txt file

merge two files

Unix - compare 2 files - sort by 1st column (the key to both files), then compare rest of data in a single line

• 0 views • link
written by h.mon h.mon

Hello Björn!

We believe that this post does not fit the main topic of this site.

Not enough information.

For this reason we have closed your question. This allows us to keep the site focused on the topics that the community can help with.

If you disagree please tell us why in a reply below, we'll be happy to talk about it.

Cheers!

• 0 views • link
written by h.mon h.mon

0 answers

No answers yet.

Log in to answer this question.

More posts like this