dividing a table into an array of subtables
2 views (last 30 days)
Show older comments
Hello i have an array which look like in the photo bellow. every contactID has one or many activities(which are listed on the next rows under an empty contact id).
for example in line 15's contact id we have one activity and the next activity is at line 16.
how can i make an array of "contact_id"'s and in every cell we will have a sub array which adds all the activities if the following empty "contact id cell" as one array for this contact id?
thanks
![](https://www.mathworks.com/matlabcentral/answers/uploaded_files/169246/image.jpeg)
mark |
0 Comments
Accepted Answer
Robert
on 7 Nov 2017
In general, your task will be easier if you start by filling in those blank IDs. I will use data to refer to your table.
%%Fill in blanks (assumes first row is not blank)
for ii = 1:height(data)
ID = data.ContactID{ii};
if ~isempty(ID) % First occurance
prev = ID;
else % Not first occurance
data.ContactID{ii} = prev;
end
end
Then you can gather the IDs and select table subsets by common ID
[ID, ~, index] = unique(data.ContactID);
grouped = table();
grouped.ContactID = ID;
grouped.ActivityData = cell(height(grouped), 1);
for ii = 1:length(ID)
grouped.ActivityData{ii} = data(index == ii, 2:end);
end
You could also do this in a containers.Map object instead of a table.
grouped = containers.Map();
for ID = unique(data.ContactID)'
grouped(ID{1}) = data(strcmp(data.ContactID, ID{1}), 2:end);
end
5 Comments
More Answers (0)
See Also
Categories
Find more on Tables 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!