Eliminates a value less than 1 and replace with nan for all the row
1 次查看(过去 30 天)
显示 更早的评论
Good Day, thank you for reading me, i am using matlab R2019 and i have this problem.
I need to eliminate from the vector of wind Velocity values less than 1 and replace with nan in all the row, so the vector of wind direction is also NaN, and everything is ok, but in the final start to replace all with NaN
Can you please tell me, what i am doing wrong
i attach the code and the file.
Thank you very much for your valious time, i know the program is very simple but before it was working
opts = detectImportOptions('tempdat.xlsx','DataRange','A5','VariableNamesRange','A2');
TT = readtimetable('tempdat.xlsx',opts);
TT = retime(TT,'regular','fillwithmissing','TimeStep',minutes(10));Matrix = TT{:,:}; %convert values to matrix
V = Matrix(:,2:3);
VelVien = V(:,1);
ind = (abs(VelVien)<=1);
VelVien(ind)=NaN;
V(ind,:)=NaN;
writetimetable(TT, 'somefile.xlsx');
Best
4 个评论
Codeshadow
2020-6-1
Could you please show me the error message you get? Your code seems to work in r2020a.
采纳的回答
Star Strider
2020-6-1
What you want the result to be is not obvious.
Try this:
TT(ind,:)={NaN};
.
2 个评论
更多回答(0 个)
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Characters and Strings 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!