Help with if condition

1 次查看（过去 30 天）

显示更早的评论

Carlos Alvarez-Santullano 2017-5-5

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/338970-help-with-if-condition

关闭： Stephen23 2017-5-6

在 MATLAB Online 中打开

he thing is i have a matrix where the first column is the code of the item sold and the second column is the week where that item were sold. Im trying to know the frecuency of sales of each item im working with (meaning this if the item has been sold every week or just in a few weeks).

This is my matrix

Item   week
    1
    1
    2
    2
    2
    2 
    3
n         53

So i want to know how to make a code that give me as a result this

Item   week1   week2  week3  week4  week5
  0012     1       1      0      0      1
  0013     0       0      1      0      0
    n      1       0      1      1      0

Meaning this the item 0012 were sold on week1 week2 week5 no sales for week3 and week4.

And it would be so much better if possible if the code result is this:

Item   week1   week2   week3   week4  week5
0012     1       2       0       0      3
0013     0       0       1       2      0
  n      1       0       3       2      0