How do I find the mean and standard deviation of each column for this data?
34 次查看(过去 30 天)
显示 更早的评论
what code would produce a table of the mean and standard deviation
2 个评论
Ameer Hamza
2020-11-9
Several of your tables have string data types. What do you want to do with those columns?
回答(2 个)
Ameer Hamza
2020-11-9
Try this
data = readtable('banking_data.csv');
idx = cellfun(@(x) isa(x, 'double'), table2cell(data(1, :)));
data = data{:,idx};
data_mean = mean(data);
data_std = std(data);
0 个评论
Steven Lord
2020-11-9
If you've read this data into a table array you can extract those variables in the table that contain numeric data then use varfun to perform an operation on each variable in the extracted table.
% Sample table
load patients
patients = table(LastName,Gender,Age,Height,Weight,Smoker,Systolic,Diastolic);
head(patients)
% Use vartype to extract just numeric data (Age, Height, Weight, Systolic, Diastolic)
numericData = patients(:, vartype('numeric'));
head(numericData) % note no LastName, Gender, or Smoker variables
% Take the mean and std of each variable in the smaller table numericData
meanData = varfun(@mean, numericData)
stdData = varfun(@std, numericData)
0 个评论
另请参阅
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!