how to import average specific data from excel file ?

1 回表示 (過去 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 ExchangeSpreadsheets についてさらに検索

タグ

製品


リリース

R2017a

Community Treasure Hunt

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

Start Hunting!

Translated by