how to only change the cells with NAN values in a table?

2 次查看（过去 30 天）
Salma fathi
Salma fathi 2022-7-23
回答： Walter Roberson 2022-7-23
I am trying to apply the following operation on certain rows in a tabel of data
[Lia, Locb] = ismember(datatable2.Date, EDPALL.Date);
indx = Locb(Locb > 0);
datatable2.NE8(Lia) = EDPAll.EDP6(indx);
finding that if any matching dates between some two tables and if satisfied we copy the corresponding value of the variable EDP6 into the variable NE8 in the other table.
But how can we modify this to restric it to happen only to the cells that has NAN values in the variable NE8?

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

回答（1 个）

Walter Roberson
Walter Roberson 2022-7-23
[Lia, Locb] = ismember(datatable2.Date, EDPALL.Date);
Lia = Lia & isnan(datatable2.NE8);
indx = Locb(Lia);
datatable2.NE8(Lia) = EDPAll.EDP6(indx);

类别

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

标签

产品


版本

R2021b

Community Treasure Hunt

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

Start Hunting!

Translated by