how to take average with specific condition and write to excel file again ?

4 次查看（过去 30 天）
MUKESH KUMAR
MUKESH KUMAR 2018-10-1
评论： MUKESH KUMAR 2018-10-2

I had a excel file testM.xls data size(45*7)(as shown in Sheet1), first column shows the time and rest of the columns shows the values in 15 min interval for each hours. Now I want to take average of 4 values (for hourly basis data calculation) from corresponding hours and write there in excel file (as shown in Sheet2).

    % So Sheet2 data is calculated as:
    % for column 2nd of Sheet2: 
     B(2)=4.25        %average of values [B(2):B(5)] from Sheet1;
     B(3)=6        %average of values [B(6):B(9)] from Sheet1;
 % and so on till 
     B(12)=5      %average of values [B(42):B(45)] from Sheet1

Then how can I find using matlab for loop for all columns to find out the values hourly basis. Thanks

请先登录，再回答此问题。

采纳的回答

ANKUR KUMAR
ANKUR KUMAR 2018-10-1
clc
clear
A=xlsread('testM.xls');
AA=A(:,2:end);
AAA=squeeze(nanmean(reshape(AA,4,[],6),1))
xlswrite('testM.xls',[[0:10]' AAA],'sheet3','A1')
  3 个评论
显示 1更早的评论

请先登录，再进行评论。

更多回答（0 个）

类别

在 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