Given the row value of a specific variable in a table, find the corresponding row index.

51 次查看（过去 30 天）
yuxuan-z
yuxuan-z 2020-1-30
评论： François LINANT 2022-12-16
An extended question of this part:
Is there any way to locate the row indices of "Manchester City" and "Manchester United" (observations of the variable "Team" in the table) instead of 'observing the rows directly'?
Or more generally, given a value of a specific variable, how could I get its row index for extraction?
question.png
  1 个评论
Geoff Hayes
Geoff Hayes 2020-1-30
Can you extract the first column (if that corresponds to team names) of data (from the table) and the do a find or strcmp (assuming cell array of strings for the teams) to get the row indices of those matching teams?

请先登录，再进行评论。

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

采纳的回答

Vinai Datta Thatiparthi
Hello Yee,
Geoff's answer is spot on. If you were to put his idea into code, it would look something like this -
index = find(strcmp(table.Team, 'Manchester City') == 1);
To elaborate, table.Team isolates the first column of the table. The function strcmp compares the elements of the column cell vector with the string that you want to match (in this case, ManC). Further, the find function returns the index of the value which was a positive match from the string comparison.
Hope this helps!

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Matrix Indexing 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by