How to replace all the values of a variable in a dataset following a condition
2 次查看(过去 30 天)
显示 更早的评论
Hi all. I have a dataset 'data' (16 x 70 fields), which is a structure. Each field has 14 vectors, 1 with strings (1 value) and the rest with integers (1 value per field). I want to replace all the values of one of those vectors for each field (let's call it VECTOR) for the whole data set following the criteria: if it's 0, replace it with 1, if it's 1, replace it with 0. I've tried this:
data(data.VECTOR == 1) = 0;
data(data.VECTOR == 0) = 1;
But it doesn't work. Any ideas?
By the way, there are only three possible values: -1, 0, 1. I want to replace the 0 with 1, and the 1 with 0, while leaving the -1 unchanged.
12 个评论
Walter Roberson
2019-1-12
编辑:Walter Roberson
2019-1-12
Another approach if your original values are only -1, 0, 1:
map = [-1, 1, 9]; %new values for -1, 0, 1
for idx = 1 : numel(data)
data(idx).sideReport = map(data(idx).sideReport + 2);
data(idx).sideAccu = map(data(idx).sideAccu + 2);
end
adding 2 transforms the -1, 0, 1 (not valid indices) to [1 2 3], which can be used in a lookup table.
回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Author Block Masks 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!