how to import average and maximum data from excel sheet .

2020 10 20
1 个回答
回答已采纳
更新时间：2020 10 22
5 次查看（30 天）

0 个投票

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

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

 采纳的回答

Sudhakar Shinde
Sudhakar Shinde 2020-10-20
编辑：Sudhakar Shinde 2020-10-20

0 个投票

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

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

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
Sudhakar Shinde 2020-10-22
编辑：Sudhakar Shinde 2020-10-22
this will also work for you.
[Num,text,Data]=xlsread('solar02.xlsx');
Average=mean(Num>0)
thanks dear:
it will give us average of all the values but i need each day average for all data given excel file .
thanks
as you know we have 365 day in one year so output will be 365 values but average value of each day dear.
thanks
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
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
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;
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
Sudhakar Shinde 2020-10-22
does this works:
% Get the averages over any and all hours of each day.
dailyAverages = splitapply(@mean, numbers>200, sequentialDays);
hi:
it gives me an error of (' empty double column vector')
thanks
Sudhakar Shinde
Sudhakar Shinde 2020-10-22
编辑：Sudhakar Shinde 2020-10-22
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);
Done thank u so much dear from your helping and support.

请先登录，再进行评论。

更多回答（0 个）

类别

在 帮助中心 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

产品

版本

R2017a

标签

Community Treasure Hunt

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

Start Hunting!

Translated by