How to conditionally merge rows in a table

25 Ansichten (letzte 30 Tage)
Blue
Blue am 8 Jan. 2021
Bearbeitet: Stephen23 am 8 Jan. 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,

Akzeptierte Antwort

Stephen23
Stephen23 am 8 Jan. 2021
Bearbeitet: Stephen23 am 8 Jan. 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)
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' }

Weitere Antworten (0)

Kategorien

Mehr zu Cell Arrays finden Sie in Help Center und File Exchange

Tags

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by