How to calculate the average columns values for a table in matlab ?
1 view (last 30 days)
Show older comments
ahmed obaid
on 31 Mar 2017
Commented: ahmed obaid
on 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 Comments
Accepted Answer
Andrei Bobrov
on 31 Mar 2017
Edited: Andrei Bobrov
on 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)];
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!