Counting values ​​in a column

7 次查看（过去 30 天）
Zuzana Pániková
Zuzana Pániková 2022-8-23
评论： Zuzana Pániková 2023-9-10
Hello,
I have 2 columns in Excel that I would need to calculate in Matlab. In the first column I have a formula: =IF(J2=1;IF(ISNUMBER(K1);K1+1;1);0) In the second column: =IF(AND(J2=1;J3<>1);K2;0) After column J, I have it calculated in matlab. Thank you very much for the advice.
I created column J in matlab with the command: T.Platoon=double(T.CasRozdiel<=4). I have added a matlab file in the attachment.
How it looks in excel.
  4 个评论
显示 2更早的评论
Image Analyst
Image Analyst 2022-8-24
I'm not sure what you want. Why not simply read your existing Excel workbook in to MATLAB with readtable? The computed values (the numbers), not the formulas, are what should be read in. And since you did the computations in Excel, then numbers should be right.
Zuzana Pániková
Zuzana Pániková 2022-8-24
I have Excel to check whether what Matlab calculates fits with Excel. Excel can no longer calculate the new data that I have to calculate. I have a lot of data for Excel.

请先登录，再进行评论。

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

采纳的回答

Hornett
Hornett 2023-9-4
I understood that you want to calculate the values of two other columns based on some conditions in MATLAB.
You can try the following code
This code will iterate over each cell value of platoon and calculate the platoonTemp based on condition “if(J2=1;If(isnumber(K1);K1+1;1);0)” and similarly platoonTemp2 is calculated from values of platoonTemp based on condition “if(and(J2=1;J3<>1);K2;0)”.
n = size(T,1)
platoonTemp = zeros(n,1);
platoonTemp2 = zeros(n,1);
for i = 1:n
if T.Platoon(i)==1
if i~=1
platoonTemp(i)=platoonTemp(i-1)+1;
else
platoonTemp(i)=1;
end
end
if i~=n && T.Platoon(i)==1 && T.Platoon(i+1)~=1
platoonTemp2(i)=platoonTemp(i)
end
end
T.Temp1 = platoonTemp
T.Temp2 = platoonTemp2
I hope it answered your query

更多回答（0 个）

类别

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

标签

产品


版本

R2022a

Community Treasure Hunt

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

Start Hunting!

Translated by