Matrix Manipulation of a specific column
8 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
I have data in excel that is 17 columns by 4800 rows. The 17 columns represent different muscles, and the rows represent times they are "activated." For each column I need to know which numbers in that column are greater then 10 and what that number is. Once I find all those different numbers I need to sum them up. Just uncertain how to do this. Thank You!
0 commentaires
Réponses (1)
Hyeokjin Jho
le 27 Sep 2018
Assuming Data is the matrix that containing your data,
threshold = 10;
for i = size(Data,2)
pickedColumn = Data(:,i);
selectedNumbers{i} = pickedColumn(pickedColumn>threshold);
summedNumbers(i) = sum(selectedNumbers{i});
end
will work.
Numbers greater than 10 of column i is stored in selectedNumbers{i}, and summed value in summedNumbers(i)
2 commentaires
Hyeokjin Jho
le 1 Oct 2018
Apparently Data seems to be a table instead of normal matrix.
threshold = 10; for i = size(Data,2) pickedColumn = Data{:,i}; selectedNumbers{i} = pickedColumn(pickedColumn>threshold); summedNumbers(i) = sum(selectedNumbers{i}); end
To extract data from table, you have to change Data(:,i) to Data{:,i}.
Voir également
Catégories
En savoir plus sur Timetables dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!