Replace values in matrix by first non-zero value in previous row

3 次查看(过去 30 天)
Hi, how can i replace zero values in a matrix by the first occurring non-zero value in that matrix if you would loop backwards in each column? I.e. how can i carry forward a value as long as its next value in the same column is zero (without looping through each value in the matrix!)
Example: m_start = [3;0;0;4;0;5] replace_non_zero_values (m_start) = [3;3;3;4;4;5]
Hope you can help, thanks very much! Steven

采纳的回答

Stephen23
Stephen23 2018-3-5
编辑:Stephen23 2018-3-5
>> M = [3;0;0;4;0;5];
>> idx = M~=0;
>> tmp = M(idx);
>> tmp(cumsum(idx))
ans =
3
3
3
4
4
5
Note this assumes that the first value is nonzero. You will need to think of how to deal with leading zeros!
  5 个评论
Guillaume
Guillaume 2018-3-5
编辑:Guillaume 2018-3-5
idx = M(:) ~= 0
tmp = M(idx);
reshape(tmp(cumsum(idx)), size(M))
As with the original answer, this will go badly wrong if any column starts with a 0.

请先登录,再进行评论。

更多回答(0 个)

类别

Help CenterFile Exchange 中查找有关 Numerical Integration and Differentiation 的更多信息

产品

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by