CODEWITHSUNDEEP
matlabindexing
Christina
Christina

Reputation: 27

reassign values in one table, based on value in another table in matlab

I have a table in matlab ("data_table"), and I would like to reassign some values to NaN by looking up a logical "1" in another table - ("artifact_table"). All cells which have a 1 need to be assigned a NaN value in "data_table"

enter image description here

enter image description here so the end result is this:

enter image description here

Upvotes: 0

Views: 47

Answers (1)

Dominic D
Dominic D

Reputation: 1808

I'm unsure if it's possible to directly do this in one line of code, but you can do the following using a temporary variable (from the docs here). This assumes you haven't changed the name of the second dimension in the table from its default value Variables.

data = data_table.Variables;
data(artifact_table.Variables == 1) = NaN;
data_table.Variables = data;

Upvotes: 1

Related Questions