how to import average specific data from excel file ?

2 次查看（过去 30 天）
Engineer Batoor khan mummand
评论： Engineer Batoor khan mummand 2020-10-21
HI all:
i want to import average of each day from above excel file but average of those values which is greather than 200.
this is my code but when i run this code it give me below error.
thanks
clc;
clear all;
close all;
[~,Num,Data]=xlsread('solar02.xlsx');
%Average values greater than zero
Average = mean(Data(2:end,3)>0);
Error
Undefined operator '>' for input arguments of type 'cell'.
Error in babab (line 7)
Average = mean(Data(2:end,3)>0);
>>

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

采纳的回答

drummer
drummer 2020-10-21
Your Data(2:end, 3) is cell type.
You can convert your Data column to array before.
arrayData = cell2mat(Data2:end, 3));
Then, you perform your average with your condition
average = mean(arrayData>0);
Cheers.
  1 个评论
Engineer Batoor khan mummand
Engineer Batoor khan mummand 2020-10-21
thanks problem solved but it gives me nan at the answr but i want average of each day which is given in excel file ...
thanks

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by