清空筛选条件
清空筛选条件

How do I make an entire row in a table NaN?

32 次查看（过去 30 天）
FsC
FsC 2022-10-27
评论： FsC 2022-10-27
I am trying to make all values in specific rows of a table NaN.
My table (T) contains 4 columns (time, x position, y position, pressure). I use the value of the pressure to determine when X and Y are 'on' or 'off'. I then want to set all values in rows where it is 'off' to NaN
% get on and off T data
isOn = find(T.Pressure >0);
isOff = find(T.Pressure==0);
I have tried the following:
T(isOff,:) = NaN;
as well as:
for i = 1:length(isOff)
T(i,:) = NaN
end
But both give the error: Right hand side of an assignment into a table must be another table or a cell array.
What is the issue? Is there a way to do this using vectorization without having an extensive loop?
Thank you for your help!

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

采纳的回答

David Hill
David Hill 2022-10-27
T(isOff,:) = {NaN};%does this work?

更多回答（1 个）

Voss
Voss 2022-10-27
T{isOff,:} = NaN; % use curly braces {}

类别

在 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