Find specific entry based on column value in table

2 views (last 30 days)
NFC
NFC on 30 Apr 2021
Commented: Cris LaPierre on 30 Apr 2021
Apologies if this has been asnwered somewhere but I was unable to find a simple answer to what I strongly suspect is a really simple operation in MATLAB. I have a simple table (see attached), and I want to extract the number that corresponds to the name 'Bob'. (so in this case, 2). How would I extract this? Essentially I am looking for the row index of a table where the column value is something specific.
Thanks,

Accepted Answer

Cris LaPierre
Cris LaPierre on 30 Apr 2021
I'd create a logical array of the name column, and use that to extract the number from the first column. You can learn about logical arrays in Ch 12 of MATLAB Onramp. This page on accessing data in a table is likely also helpful.
The code might be something like this
n = data.Number(data.Name=='Bob')
  4 Comments
Cris LaPierre
Cris LaPierre on 30 Apr 2021
I missed that detail. I think I like the strcmp approach better anyway.

Sign in to comment.

More Answers (0)

Community Treasure Hunt

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

Start Hunting!