MATLAB: Call specific rows of a table then choose rows that has specific criteria in those rows .

table

I want to say for each radius celltracker_group2.time == 10 if radius<=3 and cell_type==4 then GroupCount=GroupCoutn+1.

Any help?

Best Answer

I want to say for each radius celltracker_group2.time == 10 if radius<=3 and cell_type==4 then GroupCount=GroupCoutn+1

Easily done:

selectedrows = celltracker_group2.time == 10 & celltracker_group2.radius <= 3 & celltracker_group2.celltype == 4;  %logical vector indicating which rows match the condition
celltracker_group2.GroupCount(selectedrows) = celltracker_group2.GroupCount(selectedrows) + 1;  %add 1 to groupcount of the rows that match the condition

Related Solutions

MATLAB: Putting similar numbers into groups within an array

If you have the Statistics and Machine Learning Toolbox (for pdist2) and the Image Processing Toolbox (for bwlabel), you can do this:

m = [...
7340.1
7340.3
7340.6
7349.0
7349.4
7358.0
7358.1
7358.2
7358.7]
% % New groups would look like follows:
% % Group 1
% 7340.1
% 7340.3
% 7340.6
% % Group 2
% 7349.0
% 7349.4
% % Group 3
% 7358.0
% 7358.1
% 7358.2
% 7358.7]
% First sort m so that close by ones has adjacent indexes.
m = sort(m, 'ascend')
% Get distance of every element to every other element.
distances = pdist2(m, m)
% Find out which pairs are within 2 of each other.
within2 = distances > 0 & distances < 2
% Erase upper triangle to get rid of redundancy
numElements = numel(m);
t = logical(triu(ones(numElements, numElements), 0))
within2(t) = 0
% Label each group with an ID number.
[labeledGroups, numGroups] = bwlabel(within2)
% Put each group into a cell array
for k = 1 : numGroups
  [rows, columns] = find(labeledGroups == k);
  indexes = unique([rows, columns]);
  groups{k} = m(indexes);
end
celldisp(groups); % Display the results in the command window.

It gives you your desired result. Should work for other arrays also, though I didn't test it with any others.

MATLAB: Index in position 1 exceeds array bounds (must not exceed 1).

You created a row vector named text instead of text being the name of a MATLAB plotting call.

... and then you access that row vector as if it were a 3D array, which is why you get the indexing error.

Best Answer

Related Solutions

MATLAB: Putting similar numbers into groups within an array

MATLAB: Index in position 1 exceeds array bounds (must not exceed 1).

Related Question