Calculating the average every three months

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 个评论

Would you mind sharing what does the data look like? Run:
>> data(1:10, :)
and put the result here.
Also, what command are you using to load the data? Is it from an Excel file?

I used the import tool build up on matlab

sunspot1(1:10, :)
ans =
10×3 table
Year month sunspot
____ _____ _______
1980 12 246.9
1981 1 156.6
1981 2 189.9
1981 3 196.6
1981 4 225.3
1981 5 194.7
1981 6 131.6
1981 7 205.3
1981 8 242.5
1981 9 245.3
Those are the results of that approach
Ah, thanks. I hadn't seen that you included your xlsx file in the post. See my answer below.

请先登录,再进行评论。

 采纳的回答

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 个)

类别

在 帮助中心 和 File Exchange 中查找有关 Logical 的更多信息

Community Treasure Hunt

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

Start Hunting!

Translated by