How to conditionally merge rows in a table
10 visualizaciones (últimos 30 días)
Mostrar comentarios más antiguos
Blue
el 8 de En. de 2021
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 comentarios
Respuesta aceptada
Stephen23
el 8 de En. de 2021
Editada: Stephen23
el 8 de En. de 2021
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');
C.key = splitapply(@(s)join(s,', '),T.key,ic)
0 comentarios
Más respuestas (0)
Ver también
Categorías
Más información sobre Other Formats en Help Center y File Exchange.
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!