how to compare between multiple text files with same columns but different rows?

2 views (last 30 days)
Dear all,
I have 5 text files with 13 columns but different rows. How could i compare those files to check if they have some common information?
I appreciate any help!

Accepted Answer

Walter Roberson
Walter Roberson on 12 Jul 2017
You can readtable() the files, and you can use intersect() on the various columns of the resulting table.
You will not find anything useful in common. KEGG_PATHWAY is the same for both of them in the first column, and otherwise all they have in common is some pop hits and some counts (which are clearly useless identifying information.)

More Answers (0)

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!