find doesn't work with tables

Question

0 个投票

hello

I'm trying to find the index vector of where appears a value in a one column of a table (not an array nor a cell).

However, "find" gives me the error shown on the snapshot.

Any ideas

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Follow Question

Answer 1

Guillaume 2017-3-27

在 MATLAB Online 中打开

3 个投票

You would save yourself a lot of headache if you used the variable names instead of numerical indices for accessing the content of your tables:

big_table.UniqueWellID %instead of big_table{:, 1}

In any case, your main problem is that you want to compare char arrays, which you can't do with ==. Use strcmp to compare char arrays

find(strcmp(big_table.UniqueWellID, t1_u.UniqueWellID(1)))
%or if you really insist on using numerical indexing:
find(strcmp(big_table{:, 1}, t1_u{1, 1}))

1 个评论
显示 -1更早的评论隐藏 -1更早的评论

Abdelmoumen Bacetti 2017-3-28

That was so precise and concise answer. Thank you so much.

请先登录，再进行评论。

Answer 2

Peter Perkins 2017-3-27

1 个投票

find isn't going to work on a table, but it will work on the contents of a table. So Guillaume, is right that if you're looking for values in one variable, use dot subscripting.

Those strings, and the fact that you're searching for multiple hits for a single value, leads me to think you should be using categorical for the strings. And then when you get to the point when you need to find all the groups of rows in the table, not just one, you can easily use varfun or rowfun with that categorical as a grouping variable. Hard to give specific advice without knowing where you're headed.