How do you find data points that match a specific value?
Show older comments
I have a data set (data.tib) that has x, y and z coordinates in columns 1, 2, and 3, respectively. I want to find all unique z values so I used "uz = unique(data.tib(:,3));". For each z-axis position, I want to count how many x-y coordinates there are for each unique z. I was thinking of using "length()" to count how many and then some variation of the "find()" command.
Answers (1)
I would use groupsummary. If you group by z, the resulting table automatically contains a group count.
x=randi(10,100,1);
y=randi(10,100,1);
z=randi(10,100,1);
data = table(x,y,z);
% group
out = groupsummary(data,'z')
3 Comments
Talia Vaughn
on 10 Nov 2021
Talia Vaughn
on 10 Nov 2021
Cris LaPierre
on 10 Nov 2021
Edited: Cris LaPierre
on 10 Nov 2021
See how to access data in a table. Continuing the example I shared previously, this will access the group count value in the ith row
out.GroupCount(i)
Categories
Find more on Logical in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!