dividing a table into an array of subtables

Question

fima v 2017-11-7

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/365600-dividing-a-table-into-an-array-of-subtables

评论： Robert 2017-11-16

file.xls

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

mark |

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

请先登录，再回答此问题。

Answer 1

Robert 2017-11-7

1
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/365600-dividing-a-table-into-an-array-of-subtables#answer_289877

在 MATLAB Online 中打开

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 个评论
显示 3更早的评论隐藏 3更早的评论

fima v 2017-11-7

编辑：fima v 2017-11-7

Hello ,how its possible keep only the latest activity which has the highest date among them , for each contact ?

Thanks

Robert 2017-11-16

You should take a look at the second output of unique . It gives you the index of the first occurrence of each unique value. Specify that you want the 'last' occurrence and or sort your data by date as needed.

请先登录，再进行评论。