Effacer les filtres
Effacer les filtres

extract numbers from cell array and calculate mean

3 vues (au cours des 30 derniers jours)
JB
JB le 30 Avr 2018
Commenté : Jan le 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' }

Réponse acceptée

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

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Matrix Indexing dans Help Center et File Exchange

Tags

Produits

Community Treasure Hunt

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

Start Hunting!

Translated by