Calculating the average every three months

1 次查看（过去 30 天）
desert_scientist90
desert_scientist90 2019-10-24
编辑： Artemio Soto Breceda 2019-10-24
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 个评论
显示 2更早的评论
desert_scientist90
desert_scientist90 2019-10-24
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
Artemio Soto Breceda
Artemio Soto Breceda 2019-10-24
编辑：Artemio Soto Breceda 2019-10-24
Ah, thanks. I hadn't seen that you included your xlsx file in the post. See my answer below.

请先登录，再进行评论。

请先登录，再回答此问题。

采纳的回答

Artemio Soto Breceda
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 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by