Extend / replicate a value by column when found in array

10 views (last 30 days)
Say I have a matrix 5x5 with binary entries 0 and 1
A=[1 1 1 1 1;1 0 1 1 1;1 0 1 0 0;0 1 1 0 1;1 1 1 0 0]
I'd like to have as a result, a matrix where when the array is parsed by column, if 0 is found, then all rows indexed after are 0:
B=[1 1 1 1 1;1 0 1 1 1;1 0 1 0 0;0 0 1 0 0;0 0 1 0 0]
Any clue for a fast computing solution ? FYI every column is independent.
  2 Comments
KALYAN ACHARJYA
KALYAN ACHARJYA on 6 Sep 2018
Edited: KALYAN ACHARJYA on 6 Sep 2018
@cedric The question is not clear for me
cedric W
cedric W on 6 Sep 2018
That's why I tried to give an example: A is the input matrix, B is the output. Say columns are #of simulations, rows are days. If on a column,on one day the value is 0, then for all the next days it will remain at 0. And you loop for the number so simulations you have. Simulations (columns therefore) are independent. Hope this is clearer.

Sign in to comment.

Accepted Answer

Guillaume
Guillaume on 6 Sep 2018
Edited: Guillaume on 6 Sep 2018
This is trivially achieved with cumprod since as soon as a 0 is encountered in a column the cumulative product is 0 from then on:
A = [1 1 1 1 1;1 0 1 1 1;1 0 1 0 0;0 1 1 0 1;1 1 1 0 0]
B = cumprod(A)
  1 Comment
cedric W
cedric W on 6 Sep 2018
Nice indeed. I was thinking about using cumsum but could find the solution. Thank you !

Sign in to comment.

More Answers (0)

Categories

Find more on Multidimensional Arrays in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!