How to average strings and numbers in the same table
2 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
Elizabeth Korthals
am 7 Okt. 2021
Kommentiert: Steven Lord
am 7 Okt. 2021
I have a table that looks like this:
filename X Y Item Number
'A1B10' 60 25 'A1B10-0'
'A1B10' 45 21 'A1B10-0'
'A3B10' 70 24 'A3B10-1'
'A3B10' 40 23 'A3B10-2'
'A3B5' 38 21 'A3B5-1'
I want to average all rows that have the exact same "Item Number". However, I am not sure how to do this while preserving the "filename".
In other words, the table would look like this in the end:
filename X Y Item Number
'A1B10' 82.5 23 'A1B10-0'
'A3B10' 70 24 'A3B10-1'
'A3B10' 40 23 'A3B10-2'
'A3B5' 38 21 'A3B5-1'
Any thoughts on how I could approach this?
1 Kommentar
Image Analyst
am 7 Okt. 2021
The first way I'd approach it is to read this link:
and attach your table in a .mat file with the paperclip icon. Or else give us code to build that table. If you make it easy for people to help you, you'll get more and faster answers. We don't have this table -- you do. So please supply it to us so we can try things and give you code.
In the meantime, check out the splitapply(), findgroups(), and groupsummary() functions.
Akzeptierte Antwort
Steven Lord
am 7 Okt. 2021
Something like this?
filename = {'A1B10'; 'A1B10'; 'A3B10'; 'A3B10'; 'A3B5'};
X = [60; 45; 70; 40; 38];
Y = [25; 21; 24; 23; 21];
itemNumber = {'A1B10-0'; 'A1B10-0'; 'A3B10-1'; 'A3B10-2'; 'A3B5-1'};
T = table(filename, X, Y, itemNumber)
G = groupsummary(T, {'itemNumber', 'filename'}, @mean)
Siehe auch
Kategorien
Mehr zu Cell Arrays finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!