Replacing table cell elements based on values of other table elements
2 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Agnish Dutta
le 7 Fév 2020
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?
Réponses (1)
Voir également
Catégories
En savoir plus sur Probability Distributions dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!