您正在关注此问题

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

how to import average and maximum data from excel sheet .

3 次查看（过去 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);

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_1078428

⋮

链接

此评论的直接链接

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

Done thank u so much dear from your helping and support.

Sudhakar Shinde 2020-10-22

此评论的直接链接

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

⋮

链接

此评论的直接链接

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

Welcome. glad to help.

请先登录，再进行评论。

另请参阅

类别

MATLAB Data Import and Analysis

在 Help Center 和 File Exchange 中查找有关 Data Import and Analysis 的更多信息

产品

MATLAB
Symbolic Math Toolbox

版本

R2017a

Community Treasure Hunt

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

Start Hunting!

发生错误

由于页面发生更改，无法完成操作。请重新加载页面以查看其更新后的状态。

Translated by

选择网站

选择网站以获取翻译的可用内容，以及查看当地活动和优惠。根据您的位置，我们建议您选择：。

(English)
(Deutsch)
(Français)

（简体中文）
(English)

您也可以从以下列表中选择网站：

如何获得最佳网站性能

选择中国网站（中文或英文）以获得最佳网站性能。其他 MathWorks 国家/地区网站并未针对您所在位置的访问进行优化。

美洲

América Latina (Español)
Canada (English)
United States (English)

欧洲

Belgium (English)
Denmark (English)
Deutschland (Deutsch)
España (Español)
Finland (English)
France (Français)
Ireland (English)
Italia (Italiano)
Luxembourg (English)

Netherlands (English)
Norway (English)
Österreich (Deutsch)
Portugal (English)
Sweden (English)
Switzerland
United Kingdom(English)

亚太

Australia (English)
India (English)
New Zealand (English)
中国
- 简体中文Chinese
- English
日本Japanese (日本語)
한국Korean (한국어)

联系您当地的办事处

how to import average and maximum data from excel sheet .

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

how to import average and maximum data from excel sheet .

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

采纳的回答

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

更多回答（0 个）

另请参阅

类别

标签

产品

版本

Community Treasure Hunt

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

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