Extract data in a single vector after a FOR cycle
显示 更早的评论
Hello,
In the excel attached there are two columns of numerical data (113*85=9605 rows) I want to get the medium value for each row, and the maximum value every 85 rows. The final column vector (vect_max) of 113 elements has to contain the 113 biggest numbers. This script doesn't work properly, can you help me? Thank you!
clear
clc
numdata=xlsread('prova_matlab.xlsx');
media=mean(numdata,2);
vect_max=zeros(113,1);
for i=1:85:112*85
for j=1:113
blocco=media(i:84+i);
vect_max(j)=max(blocco)
end
end
采纳的回答
Fabio Freschi
2019-9-4
Ciao,
You can try to reshape your data, then apply max on the columns
media_reshape = reshape(media,85,113);
max_media = max(media_reshape,[],1);
6 个评论
Orazio Alberto Terracciano
2019-9-4
Fabio Freschi
2019-9-4
编辑：Fabio Freschi
2019-9-4
The maximum is extracted from the mean value, so it shouldn't be found in the excel data numdata. Am I missing something?
Orazio Alberto Terracciano
2019-9-4
编辑：Orazio Alberto Terracciano
2019-9-4
Orazio Alberto Terracciano
2019-9-4
Fabio Freschi
2019-9-4
you can extract the row of the maximum in the reshaped vector
[max_media, idx_max_loc] = max(media_reshape,[],1);
But these value must be translated by multiples of 85 to get the indices of the rows in the original vector, I mean, the first entry in idx_max_loc have to be multiplied by 85*0, the second for 85*1 and so on
idx_max_glo = (0:112).*85+idx_max_loc
The matrix you want is
max_data = numdata(idx_max_glo,:)
Orazio Alberto Terracciano
2019-9-4
更多回答（0 个）
类别
在 帮助中心 和 File Exchange 中查找有关 Spreadsheets 的更多信息
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
Translated by 
