how to only change the cells with NAN values in a table?
1 view (last 30 days)
Show older comments
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?
0 Comments
Answers (1)
Walter Roberson
on 23 Jul 2022
[Lia, Locb] = ismember(datatable2.Date, EDPALL.Date);
Lia = Lia & isnan(datatable2.NE8);
indx = Locb(Lia);
datatable2.NE8(Lia) = EDPAll.EDP6(indx);
0 Comments
See Also
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!