I have an excel file which contains 4076 rows and 13 columns. I want the average of every 42 rows of every single column and then store them in a new spreadsheet.Can you help me with the code?I'm a beginner using Matlab and I don't know much.

2 ビュー (過去 30 日間)
Sofia Fourkioti
Sofia Fourkioti 2017 年 11 月 4 日
コメント済み: Sofia Fourkioti 2017 年 11 月 5 日
here some of my efforts from different codes I found ... no results

サインインしてこの質問に回答する。

採用された回答

Image Analyst
Image Analyst 2017 年 11 月 4 日
What about conv2()?
B = conv2(A, ones(42, 1)/42, 'valid');

その他の回答 (1 件)

Andrei Bobrov
Andrei Bobrov 2017 年 11 月 4 日
B = rand(4076,13);
a = 42;
i0 = ceil((1:size(B,1))'/a);
[ii,jj] = ndgrid(i0,1:size(B,2));
out = accumarray([ii(:),jj(:)],B(:),[],@mean);

カテゴリ

Help Center および File Exchange で Spreadsheets についてさらに検索

タグ

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by