how to import average specific data from excel file ?
1 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
Engineer Batoor khan mummand
le 21 Oct 2020
Commenté : Engineer Batoor khan mummand
le 21 Oct 2020
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);
>>
0 commentaires
Réponse acceptée
drummer
le 21 Oct 2020
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.
Plus de réponses (0)
Voir également
Catégories
En savoir plus sur Spreadsheets dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!