How do I find the mean and standard deviation of each column for this data?
16 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
what code would produce a table of the mean and standard deviation
2 Kommentare
Ameer Hamza
am 9 Nov. 2020
Several of your tables have string data types. What do you want to do with those columns?
Antworten (2)
Ameer Hamza
am 9 Nov. 2020
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 Kommentare
Steven Lord
am 9 Nov. 2020
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 Kommentare
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!