Filter löschen
Filter löschen

extract numbers from cell array and calculate mean

1 Ansicht (letzte 30 Tage)
JB
JB am 30 Apr. 2018
Kommentiert: Jan am 1 Mai 2018
I have a cell array containing numbers and strings. Can someone help me with a code that can calculate the mean of the numbers in each row?
Mix = {
'U' [4.7506e+05] [5.0141e+05] [5.4067e+05] [ 542976] [5.7124e+05]
[3.9810e+05] [4.4926e+05] 'U' [ 531440] [5.3655e+05] 'O'
[3.0915e+05] [3.6336e+05] [3.7107e+05] [3.8252e+05] [3.3988e+05] [4.3384e+05]
'U' 'U' 'U' 'O' 'U' [3.7107e+05]
'U' [3.7107e+05] 'U' [3.8252e+05] 'U' 'O' }

Akzeptierte Antwort

Fangjun Jiang
Fangjun Jiang am 30 Apr. 2018
index=cellfun(@isnumeric,Mix);
Mix(~index)={0};
mean(cell2mat(Mix),2)
  2 Kommentare
JB
JB am 30 Apr. 2018
Thanks a lot Fangjun, that is perfect
Jan
Jan am 1 Mai 2018
+1. I've overseen that the means are wanted for each row.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)

Kategorien

Mehr zu Matrix Indexing finden Sie in Help Center und File Exchange

Tags

Produkte

Community Treasure Hunt

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

Start Hunting!

Translated by