Loop over a list of variables indexed by numbers

Question

alpedhuez 2021-8-14

评论： alpedhuez 2021-8-14

Suppose I have a table

              Day1Vistors Day1Sales Day2Visitors Day2Sales
NY            10 100  15  45
SF            5   20  10  50

Then I want to calculate Day1SalesPerVisitor, Day2SalesPerVisitor

I would lke to write a loop over variable names like

for i=1:2
    DayiSalesPerVisitor=DayiSales./DayiVisitor;
end

How can one operationalize it?

Answer 1

Matt J 2021-8-14

编辑：Matt J 2021-8-14

Where your table is T,

for i=1:2
   DaySalesPerVisitor{i}=T{:,2*i}./T{:,2*i-1};
end

Alternatively,

A=table2array(T);
DaySalesPerVisitor=A(:,2:2:end)./A(:,1:2:end);

alpedhuez 2021-8-14

Wanted more general method to run loop over variable names but this would surely work.