Stuart’s MATLAB Videos

Watch and Learn

Making a MATLAB Script to Compare Two Long Lists of Strings from Excel

I often need to compare long lists of strings, usually URLs. If I have less than a few thousand, and the data is already in Excel, I will use the MATCH and INDEX functions in Excel to do this. However, if the lists are in the order of tens of thousands or hundreds of thousands, Excel struggles. Here, I write a very simple MATLAB script to input two lists of strings from Excel spreadsheets, compare using setdiff, and intersect and write the results back.

This video uses the code-along style.

Play the video in full screen mode for a better viewing experience.

|
  • print

评论

要发表评论,请点击 此处 登录到您的 MathWorks 帐户或创建一个新帐户。