remove first value that appears after sequence of NaNs

Hi,

In my dataset, the first value that appears after a sequence of NaNs needs be removed. This removed value also need to be made NaN so that I dont consider in further anlaysis. I have attached the example dataset for your reference, I have colored some of those value to be removed in red.

I highly appreciate your help.

Thanks!

[madhan ravi]

A short example would help.

[MatLab Code N]

I have attached the excel file with example dataset

Answer 1

[Star Strider]

Try this:

D = readmatrix('example_data.xlsx');
R01 = strfind(isnan(D(:,1)).', [1 0]);                  % Find Indices Of [0 1] Transitions
Out = D;                                                % Duplicate Original Matrix In 'Out'
Out(R01+1,:) = NaN;                                     % Replace Appropriate Values With 'NaN'

This appears to do what you want on the rows that I checked. It assumes that the NaN values are the same rows in both columns, since they appear to be in the posted file. The ‘Out’ matrix is the output of the code.

.

[MatLab Code N]

Thanks it worked!

[Star Strider]

As always, my pleasure!