清空筛选条件
清空筛选条件

Replacing table cell elements based on values of other table elements

2 次查看（过去 30 天）
S H
S H 2019-9-20
评论： Agnish Dutta 2020-2-7
There is a call-array table such as:
type node rank
____ ________ ____
'abc' '3 0' ','
'acd' '0 3' ','
'bcd' '0 3' ','
'aaa' '3 2' ','
'abb' '4 2' ','
'baa' '4 0' ','
'ccc' '0 2' ','
'caa' '2 1' ','
'cdd' '0 1' ','
'csd' '1 0' ','
'css' '3 1' ','
'bff' '0' ','
'gre' '2 2' ','
'hhh' '3' ','
'qwe' '1' ','
'pin' '3' '1'
'pin' '2' '2'
'pin' '4' '3'
'pin' '1' '4'
The size of table.node{1} is 1x3 cell array. It is not a 1x2 array. Table is using bar | as delimiter.
I need to change non zero node values based the rank of their corresponding pin (listed in the last rows of the table). In other words, I need something similar to:
For any non-zero table.node cell element, find the corresponding index of table.type==pin and change the table.node cell element with table.rank{index}
The table should become:
type node rank
____ ________ ____
'abc' '1 0' ','
'acd' '0 1' ','
'bcd' '0 1' ','
'aaa' '1 2' ','
'abb' '3 2' ','
'baa' '3 0' ','
'ccc' '0 2' ','
'caa' '2 4' ','
'cdd' '0 4' ','
'csd' '4 0' ','
'css' '1 4' ','
'bff' '0' ','
'gre' '2 2' ','
'hhh' '1' ','
'qwe' '4' ','
'pin' '1' '1'
'pin' '2' '2'
'pin' '3' '3'
'pin' '4' '4'
What is the shortest command to do this?
  5 个评论
显示 3更早的评论
S H
S H 2020-2-7
Here is the example:
Table.Type(1) is 'abc'. Its corresponding Table.node(1) is '3 0'. I want to renumber this based on the pin==3 rank. So the result should be '1 0'.
Agnish Dutta
Agnish Dutta 2020-2-7
Would it be ok to split this table into two i.e. create a separate table for the "pin" rows first for your use case?

请先登录，再进行评论。

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

回答（1 个）

S H
S H 2020-2-7
Here is the example:
Table.Type(1) is 'abc'. Its corresponding Table.node(1) is '3 0'. I want to renumber this based on the pin==3 rank. So the result should be '1 0'.

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by