How to conditionally merge rows in a table

Question

Blue 2021-1-8

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/712198-how-to-conditionally-merge-rows-in-a-table

编辑： Stephen23 2021-1-8

Hi,

I have a quick question - I have the following table T and I would like to merge the rows where the values of the variables lat, lon and id are identical and where only the values of the key variable are different. The desired output is shown.

lat = [45.67, 45.67, 56.89, 78.61]';
lon = [-66.45, -66.45, -65, -67]';
id = [202, 202, 201, 200]';
key = {'A', 'B', 'C', 'C'}';
T = table(lat, lon, id, key)
[C, ia, ic] = unique(T(:, 1:3),'rows')
% desired output:
lat = [45.67, 56.89, 78.61]';
lon = [-66.45, -65, -67]';
id = [202, 201, 200]';
key = {'A, B', 'C', 'C'}';
desired_output = table(lat, lon, id, key)

Thank you,

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

请先登录，再进行评论。

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

Answer 1

Stephen23 2021-1-8

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/712198-how-to-conditionally-merge-rows-in-a-table#answer_593903

编辑：Stephen23 2021-1-8

在 MATLAB Online 中打开

lat = [45.67, 45.67, 56.89, 78.61]';
lon = [-66.45, -66.45, -65, -67]';
id = [202, 202, 201, 200]';
key = {'A', 'B', 'C', 'C'}';
T = table(lat, lon, id, key)
T = 4x4 table
     lat      lon      id      key 
    _____    ______    ___    _____

    45.67    -66.45    202    {'A'}
    45.67    -66.45    202    {'B'}
    56.89       -65    201    {'C'}
    78.61       -67    200    {'C'}
[C, ia, ic] = unique(T(:, 1:3),'rows');
C.key = splitapply(@(s)join(s,', '),T.key,ic)
C = 3x4 table
     lat      lon      id       key   
    _____    ______    ___    ________

    45.67    -66.45    202    {'A, B'}
    56.89       -65    201    {'C'   }
    78.61       -67    200    {'C'   }