How to calculate the average columns values for a table in matlab ?

1 visualización (últimos 30 días)
ahmed obaid
ahmed obaid el 31 de Mzo. de 2017
Comentada: ahmed obaid el 31 de Mzo. de 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)

Iniciar sesión para responder a esta pregunta.

Respuesta aceptada

Andrei Bobrov
Andrei Bobrov el 31 de Mzo. de 2017
Editada: Andrei Bobrov el 31 de Mzo. de 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)];

Más respuestas (0)

Categorías

Más información sobre Spreadsheets en Help Center y File Exchange.

Etiquetas

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by