I have a 94×4 matrix. A truncated example is below:
A = 434.390000000000 1 NaN NaN434.700000000000 NaN NaN 42.0570000000000434.760000000000 1 NaN NaN438.720000000000 NaN NaN 46.6870000000000441.640000000000 16 NaN NaN441.720000000000 NaN NaN 46.3582500000000447.250000000000 NaN NaN 39.7590000000000453.590000000000 NaN NaN 39.3142500000000556.390000000000 1 NaN NaN558.880000000000 NaN NaN 43.4190000000000562.400000000000 NaN NaN 39.4925000000000566.060000000000 NaN NaN 38.6045000000000568.430000000000 NaN NaN 39.5280000000000573.810000000000 NaN NaN 37.61875000000002009.14000000000 1 NaN NaN2010.26000000000 1 NaN NaN2010.51000000000 1 NaN NaN2011.14000000000 1 NaN NaN2013.80000000000 NaN NaN 39.18900000000002019.39000000000 NaN NaN 36.44700000000002020.89000000000 16 NaN NaN2021.51000000000 16 NaN NaN2023.18000000000 NaN NaN 36.4445000000000
What I would like to do is select all the rows that contain a 1 in column 2 as well as all the rows that follow the 1's that contain NaN's. From the above example this is what I would want:
B =434.390000000000 1 NaN NaN434.700000000000 NaN NaN 42.0570000000000434.760000000000 1 NaN NaN438.720000000000 NaN NaN 46.6870000000000556.390000000000 1 NaN NaN558.880000000000 NaN NaN 43.4190000000000562.400000000000 NaN NaN 39.4925000000000566.060000000000 NaN NaN 38.6045000000000568.430000000000 NaN NaN 39.5280000000000573.810000000000 NaN NaN 37.61875000000002009.14000000000 1 NaN NaN2010.26000000000 1 NaN NaN2010.51000000000 1 NaN NaN2011.14000000000 1 NaN NaN2013.80000000000 NaN NaN 39.18900000000002019.39000000000 NaN NaN 36.4470000000000
Any help is much appreciated and I am happy to clarify anything. Thanks!
Best Answer