清空筛选条件
清空筛选条件

Where is my mistake in coding ?

1 次查看（过去 30 天）
Dung Le
Dung Le 2016-1-5
评论： Image Analyst 2016-1-5
I separate input data (in file panel.xlsx) into groups based on 4 conditions (in file criteria.xlsx), namely:
  1. Province (64 values)
  2. Number of employees (3 ranges): 2-10; 11-49; 50-10000
  3. Industry ID (89 values)
  4. Year (2 ranges): 2005-2007; 2008-2010
Then i want to calculate mean for each group and assign this mean to every observation in each group. Above is my code, could you please point out what's wrong in the code and fix it. Thank you very much! And i already attach two files used for calculation.
clear all
clc
A=xlsread('criteria.xlsx');
B=xlsread('panel.xlsx');
for i=1:89
for j=1:64
for k=1:3
for h=1:2
rowsToAverage = (B(:,5) == A(i,1)) && (B(:,4) == A(j,2)) && (A(k,4) > B(:,2) > A(k,3)) && (A(h,5) < B(:,1) < A(h,6)) && ~isnan(B(:,3));
meanOfBigNumbers= mean(B(rowsToAverage, 3));
B(rowsToAverage, 6) = meanOfBigNumbers;
end
end
end
end
xlswrite('panel.xlsx',B)
  3 个评论
显示 1更早的评论
Dung Le
Dung Le 2016-1-5
编辑：Walter Roberson 2016-1-5
I'm sorry, I have just attached two related files. Matlab reports error in the line:
rowsToAverage = (B(:,5) == A(i,1)) && (B(:,4) == A(j,2)) && (A(k,4) > B(:,2) > A(k,3)) && (A(h,5) < B(:,1) < A(h,6)) && ~isnan(B(:,3));
I'm don't know how to foxed this code!
Stephen23
Stephen23 2016-1-5
编辑：Stephen23 2016-1-5
Yes, but what is the error message? We cannot read your mind or your computer screen, so you have to tell us what the error message is.

请先登录，再进行评论。

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

采纳的回答

Walter Roberson
Walter Roberson 2016-1-5
(B(:,5) == A(i,1)) is a vector calculation. You cannot combine vector values with other values using && like you do. You will need to switch to & instead of &&
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2016-1-5
It would have been faster if you had included the actual error message, we could have explained hours ago...
Image Analyst
Image Analyst 2016-1-5
Or if he had used my code in his duplicate question instead of unvectorizing the operation.

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 String Parsing 的更多信息

标签

尚未输入任何标签。

Community Treasure Hunt

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

Start Hunting!

Translated by