Making elements in an array zero

Hello everyone,
This might be a very basic question or not im not sure.
I have an array say
[1 5 7 9 3 7 0 0 0
1 5 7 9 3 7 0 0 0
1 5 7 9 3 7 0 0 0
1 5 7 9 3 7 0 0 0
1 5 7 9 3 7 0 0 0
0 0 0 0 0 0 0 0 0
0 0 0 0 0 0 0 0 0]
I have to empty these zeros from the table maintaing the array structure as the cell locations are assigned to some other variables.
Even though i make them blank in the input file, when it is read using uiget file this appears as nan and that i converted to zero assuming that the interp1 will work out .
But unfortunately it accounts for these zeros and throws unique grid points error.
So i plan to make these zero's blank or rather the nan elements to blank.
Can anyone help me in this?
I cannot disturb the row column used in the array.
Hope to get a solution.
Thank you

2 Comments

So you want to basically replace zeros with nan or remove the entire row/column filled with zeros?
I have to remove the entire rows /column, so that they are not involved in carrying out the interpolation.If i keep them as zeros interpolation throws error.

Sign in to comment.

 Accepted Answer

a(~any(a,2),:)=[]; % where a is your matrix
a(:,~any(a))=[]

More Answers (1)

KSSV
KSSV on 30 Jan 2019
Edited: KSSV on 30 Jan 2019
Let A be your matrix.
A(A==0) = NaN ;

1 Comment

My intention is to remove them, not assign nan.
Thank you

Sign in to comment.

Tags

Asked:

on 30 Jan 2019

Commented:

on 30 Jan 2019

Community Treasure Hunt

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

Start Hunting!