您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

how to import average and maximum data from excel sheet .

1 次查看（过去 30 天）

显示更早的评论

Engineer Batoor khan mummand 2020-10-20

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet

评论： Sudhakar Shinde 2020-10-22

采纳的回答： Sudhakar Shinde

solar02.xlsx

hi all:

i want to import avarege data of each day from above excel file but avarege of that values which is greater than 0.

second i want find greatest average value day in that excel file .

thanks

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

采纳的回答

Sudhakar Shinde 2020-10-20

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#answer_518743

⋮

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#answer_518743

编辑：Sudhakar Shinde 2020-10-20

在 MATLAB Online 中打开

[~,Num,Data]=xlsread('solar02.xlsx');
%Average values greater than zero
Average = mean(Data(2:end,3)>0);
%Maximum
max(Average);

12 个评论
显示 10更早的评论隐藏 10更早的评论

Engineer Batoor khan mummand 2020-10-20

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1073243

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1073243

thank you so much dear:

i have used your code but it gave me this error .

Undefined operator '>' for input arguments of type 'cell'.

Error in SOLARRR (line 3)

Average = mean(Data(2:end,3)>0);

Sudhakar Shinde 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1077953

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1077953

编辑：Sudhakar Shinde 2020-10-22

在 MATLAB Online 中打开

this will also work for you.

[Num,text,Data]=xlsread('solar02.xlsx');
Average=mean(Num>0)

Engineer Batoor khan mummand 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1077963

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1077963

thanks dear:

it will give us average of all the values but i need each day average for all data given excel file .

thanks

Engineer Batoor khan mummand 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1077973

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1077973

as you know we have 365 day in one year so output will be 365 values but average value of each day dear.

thanks

Engineer Batoor khan mummand 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1077993

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1077993

let me explain my problem dear :

i need average of each day i want to take average of those values in each day which is grather than 200.

thanks

Engineer Batoor khan mummand 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078168

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078168

编辑：Engineer Batoor khan mummand 2020-10-22

thanks dear Sudhakar Shind:

i used this code but it gives me average of all values in each day i mean not greather than 200.

[numbers, strings, rawData] = xlsread('solar02.xlsx')

daysOfWeek = strings(2:end, 2);

sequentialDays = ones(length(daysOfWeek), 1);

for k = 2 : length(sequentialDays)

if ~strcmpi(daysOfWeek{k}, daysOfWeek{k-1})

% It's not the same as the prior day so we're starting a new day.

sequentialDays(k:end) = (sequentialDays(k-1) + 1);

end

% Get the averages over any and all hours of each day.

dailyAverages = splitapply(@mean, numbers, sequentialDays);

plot(dailyAverages, 'b-', 'LineWidth', 2);

title('Daily Average of Solar Radiation', 'FontSize', 18);

xlabel('Day', 'FontSize', 18);

ylabel('Average over the Day', 'FontSize', 18);

grid on;

Engineer Batoor khan mummand 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078183

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078183

but my purpose is that first of all matlab should ignor all those values which are less than 200 and than take average of each day i hope you got my point.

thanks

Sudhakar Shinde 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078198

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078198

在 MATLAB Online 中打开

does this works:

% Get the averages over any and all hours of each day.
dailyAverages = splitapply(@mean, numbers>200, sequentialDays);

Engineer Batoor khan mummand 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078218

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078218

hi:

it gives me an error of (' empty double column vector')

thanks

Sudhakar Shinde 2020-10-22

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078238

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/619538-how-to-import-average-and-maximum-data-from-excel-sheet#comment_1078238

编辑：Sudhakar Shinde 2020-10-22

在 MATLAB Online 中打开

This is your area of interest:

%Use below code lines in your code:
Id = (numbers>200);
numbers=numbers(Id);
sequentialDays = sequentialDays(Id);
G = findgroups(sequentialDays);
% Get the averages over any and all hours of each day.
dailyAverages = splitapply(@mean, numbers, G);