How to plot scatter plot with conditions?

Hi,

I have 2 columns of data (below table is an extract).

If the Time in row (i+1) - row (i) is less than 3, I want to plot the corresponding PW in a scatter plot. How can I do this in Matlab?

For example, the Time value in row 2 subtract the Time value in row 1 is zero, hence the PW value of 10 and 10.2 will be plotted in a scatter plot.

Thanks in advance.

Answer 1

[Davide Masiello]

data = readmatrix('table.xlsx');
time = data(:,1);
PW   = data(:,2);

You can identify all the indexes for which the difference between two rows is less then three in the following way.

idx  = abs(diff(time)) < 3; 

However, idx now has length(time)-1 elements (because it perofrms subraction of i+1 and i elements one pair at a time).

You can easily fix it with

idx = [idx(1);idx];

And then plot your selected data

scatter(time(idx),PW(idx),[],PW(idx),"filled")

[Jayden Yeo]

Thanks for the quick reply. It works. Using the same table, is it possible to use a different colour markers for each of the 3 blocks of data highlighted in orange in the table?

[Davide Masiello]

Hi @Jayden Yeo, I've edited my answer, now the scattered marks are colored according to the PW value.

If it helped, please consider accepting the answer. Cheers.