Calculating the average every three months
4 Ansichten (letzte 30 Tage)
Ältere Kommentare anzeigen
desert_scientist90
am 24 Okt. 2019
Bearbeitet: Artemio Soto Breceda
am 24 Okt. 2019
Hi all, I leaning matlab thru practice and patience, I have the following dataset with sunspot observations for 38 years. I am trying to get the average of months 12,1,2 per year. I was using the code below but I am getting the following error message. " Undefined operator '>=' for input arguments of type 'table'."
Any advise will be greatly appreciated.
IDX=data(:,3) >= 5;
fdata = data(idx,:);
iex = fdata(:,3) <= 7;
fildata = fdata(iex,:);
year = fildata(:,2);
avr = accumarray(year,fildata(:,1))./3;
idx = avr(:,1) > 0;
avr = avr(idx,1);
4 Kommentare
Artemio Soto Breceda
am 24 Okt. 2019
Bearbeitet: Artemio Soto Breceda
am 24 Okt. 2019
Ah, thanks. I hadn't seen that you included your xlsx file in the post. See my answer below.
Akzeptierte Antwort
Artemio Soto Breceda
am 24 Okt. 2019
You have two options, to convert your table into an array with:
data_array = data{:,:};
or to use the same expression, but with curly braces, like this:
IDX = data{:,3} >= 5; % The curly braces do what you want
0 Kommentare
Weitere Antworten (0)
Siehe auch
Kategorien
Mehr zu Data Import from MATLAB finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!