Average of every 25 rows in a table
4 vues (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Hello,
I have a table of 10 columns and 1000 rows. I would like to take the average of each column for every 25 rows. How to code that please?
Thank you
0 commentaires
Réponse acceptée
Abhishek Tiwari
le 3 Juil 2022
Hi,
This might work,
% Sample data
data = rand(1000, 10);
% Calculating Output Dimension (#columns will be same)
rows = 1000/25;
output = ones(rows, 10);
% Start first 25 entries then compute mean and increase index for next
% 25 entries
for row = 0:rows-1
output(row+1, :) = mean(data(25*row+1:25*(row+1),:));
end
output
3 commentaires
Abhishek Tiwari
le 5 Juil 2022
Modifié(e) : Abhishek Tiwari
le 5 Juil 2022
Just defining dimension of output table... It is better than create one dynamically, saves time. When we average every 25 rows for each column dimension of output table is reduced from 1000 to 1000/25 (=40) but column remains same.
Plus de réponses (1)
Akira Agata
le 3 Juil 2022
Modifié(e) : Akira Agata
le 3 Juil 2022
Another possible solution:
% Sample data
data = rand(1000, 10);
% Grouping
group = repelem(1:size(data, 1)/25, 25)';
% Apply mean function for each group
output = splitapply(@mean, data, group);
3 commentaires
Akira Agata
le 4 Juil 2022
I just wanted to create "group number".
For more information, please take a look at the following.
Voir également
Catégories
En savoir plus sur Tables dans Help Center et File Exchange
Produits
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!