How to plot points with corresponding colour

Given I have an excel data where a1 is the first row of data, a2 is the second row of data and b is the corresponding label. B has either blue or red. When I plot it plots it all as a scatter plot but in blue. I want to make the points red when b says red for that label. How do i do this??

Answer 1

[Dyuman Joshi]

(Assuming there are only red and blue colors for the plot) Use logical indexing -

%Check which elements of B are red
idx = strcmp(B, 'red');

f = figure;
hold on
%plot data with red color 
scatter(a1(idx), a2(idx), [], 'r')
%plot data with blue color
scatter(a2(~idx), a2(~idx), [], 'b')
hold off

[Hannah]

I tried that and it is not really working properly. I do not know if its my file that is the problem.

After uploading my excel dataset, this is how my codes look like

Dataset.Y(strcmp(Dataset.Y, 'red')) = {'-1'}
Dataset.Y(strcmp(Dataset.Y, 'blue')) = {'1'}
Dataset.Y = str2double(Dataset.Y)
data = table2array(Dataset)

%I think I am going wrong when plotting it or when turning the data into a
%matrix asthe number of rows do not match the height of the table