Filter contents of a table

2 次查看（过去 30 天）
Deepa Maheshvare
Deepa Maheshvare 2019-11-24
评论： Deepa Maheshvare 2019-11-24
The following contents are stored in a table, in variable 'tbl',
Multico value
______________
{'1'} {'2'} 1
{'2'} {'3'} 2
{'3'} {'4'} 1
{'4'} {'5'} 2
I would like to do the following,
variable = 2,
If the variable is present in tbl.Multico, I would like to retain only those rows and delete the remining rows.
Example,
Multico value
______________
{'1'} {'2'} 1
{'2'} {'3'} 2
Also, if variable is present in column 2 of Multico, the value in column 2 of tbl will remain unchanged. If the variable is
in column 1 of Multico the sign of the value in column2 of tbl will change.
Th expected output is,
Multico value
______________
{'1'} {'2'} 1
{'2'} {'3'} -2
I'd like to ask for suggstions on how this can be done.
Is there a function similar to python's groupby for filtering contents of a table?

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

采纳的回答

Guillaume
Guillaume 2019-11-24
Any reason why Multico is a cell array? If all the cells are just scalar, then it's a waste of memory and complicates the code for no good reason.
So first step, convert that cell array into a 2 column matrix:
yourtable.Multico = cell2mat(yourtable.Multico);
Your filtering is then trivially done:
serchval = 2;
newtable = yourtable(any(yourtable.Multico == searchval, 2), :)
If you then want to change the sign of value when searchval is in first column of Multico:
tochange = newtable.Multico(1, :) == searchval;
newtable.value(tochange) = -newtable.value(tochange)
  4 个评论
显示 2更早的评论
Deepa Maheshvare
Deepa Maheshvare 2019-11-24
编辑：Deepa Maheshvare 2019-11-24
Thanks a lot. However, I get the following error.
The logical indices contain a true value outside of the array bounds.
Is it because we are trying to index with [0 1] stored in tochange (newtable.value(tochange))?
Answering you question,
Why don't you stick with numeric node numbers instead of naming them?
I want to access the nodes for deleting and adding edges. I am not sure how to access the nodes without names.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Type Identification 的更多信息

标签

产品


版本

R2019b

Community Treasure Hunt

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

Start Hunting!

Translated by