How can I remove some specific rows in which zero an nan values exist?

Hi all

I have a cell array called "stations2". I intend to remove simultanesly all rows for which the second column is zero or nan. How can I do that?

[Walter Roberson]

Your example file does not contain any cell arrays.

[Matt J]

No, your attached stations2.mat contains no cell arrays (which wouldn't be appropriate anyway).

[Behrooz Daneshian]

oh my bad. It is a double

Answer 1

[Matt J]

load stations2

cutrows=stations2(:,2)==0|isnan(stations2(:,2));

stations2

stations2 = 10×4

1.0e+03 * 2.0120 0.3690 0.0347 0.1830 2.0130 0.2155 0.0383 0.1360 2.0140 0 0.0478 NaN 2.0150 NaN NaN NaN 2.0160 0.1570 0.0431 0.0990 2.0170 0.0315 0.0420 0.1050 2.0180 0.0035 0.0437 0.0950 2.0190 0.0755 0.0417 0.1270 2.0200 0.2165 0.0385 0.1610 2.0210 0.3970 0.0353 0.1560

stations2(cutrows,:)=[]

stations2 = 8×4

1.0e+03 * 2.0120 0.3690 0.0347 0.1830 2.0130 0.2155 0.0383 0.1360 2.0160 0.1570 0.0431 0.0990 2.0170 0.0315 0.0420 0.1050 2.0180 0.0035 0.0437 0.0950 2.0190 0.0755 0.0417 0.1270 2.0200 0.2165 0.0385 0.1610 2.0210 0.3970 0.0353 0.1560

[Behrooz Daneshian]

It did not work

[Matt J]

I've edited the answer. Make sure you're running my latest version.