How to calculate the average columns values for a table in matlab ?
1 visualizzazione (ultimi 30 giorni)
Mostra commenti meno recenti
ahmed obaid
il 31 Mar 2017
Commentato: ahmed obaid
il 31 Mar 2017
Dear Experiences
i have a data table include numeric values .. i need to calculate the average values of table columns and then eliminate columns their average less than certain values (such as 0.002) , then write new table to new excel file. i will thanks any one can give a help on this duty ..
attached my portion of data table (when its imported to matlab using read table function)
0 Commenti
Risposta accettata
Andrei Bobrov
il 31 Mar 2017
Modificato: Andrei Bobrov
il 31 Mar 2017
EDIT
x = readtable('test.xls');
k = .002;
t = varfun(@isnumeric, x,'OutputFormat','uniform');
x1 = x(:,t);
out = [x(:,~t), x1(:,varfun(@mean, x1,'OutputFormat','uniform') > k)];
Più risposte (0)
Vedere anche
Categorie
Scopri di più su Spreadsheets in Help Center e File Exchange
Prodotti
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!