Matrix Manipulation of a specific column
7 次查看(过去 30 天)
显示 更早的评论
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 个评论
回答(1 个)
Hyeokjin Jho
2018-9-27
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 个评论
Hyeokjin Jho
2018-10-1
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}.
另请参阅
类别
在 Help Center 和 File Exchange 中查找有关 Timetables 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!