how to import average specific data from excel file ?
조회 수: 1 (최근 30일)
이전 댓글 표시
Engineer Batoor khan mummand
2020년 10월 21일
댓글: 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);
>>
댓글 수: 0
채택된 답변
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.
추가 답변 (0개)
참고 항목
카테고리
Help Center 및 File Exchange에서 Spreadsheets에 대해 자세히 알아보기
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!