This is a test version of Biostars. For the public version, visit https://www.biostars.org.
Count frequency of elements of one file in another file

I have 2 file 

file 1-

M1  M2
M1  M3
M3  M1
M3  M2
M4  M5
M7  M6

file 2-
P1  M1,M2,M5,M6
P2  M1,M2,M3,M5
P3  M4,M5,M7,M6

I want to count the frequency of the file 1 pair of column 1 and column 2 in file 2. Expected output-

M1  M2  2
M1  M3  1
M3  M1  1
M3  M2  1
M4  M5  1
M7  M6  1
r .csv
• 662 views • link
written by xxxxxxxx • xxxxxxxx

Could you explain how this question relates to bioinformatics?

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

Hello xxxxxxxx!

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

Not a bioinformatics question

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 lakhujanivijay lakhujanivijay

0 answers

No answers yet.

Log in to answer this question.

More posts like this