您正在关注此问题

您将在关注的内容源中看到更新。
您可能会收到电子邮件，具体取决于您的通信预设项。

New to Matlab and need help with simple calc

1 次查看（过去 30 天）

显示更早的评论

Neesha 2013-10-31

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc

⋮

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc

评论： Walter Roberson 2013-11-6

在 MATLAB Online 中打开

I have two matrices not in particular order for the context info. As per file attached - tab 'MatlabForum'

For given Restaurant name and Item Name i want to multiple 'Type' Ordered with dish for the given qtr.

For example

RestaurantThree Tacos 2500*50 in QuarterOne and so on up to QuarterFour

How do i do it?

For

10 个评论
显示 8更早的评论隐藏 8更早的评论

Walter Roberson 2013-10-31

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177455

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177455

Sorry no file seems to be attached.

Neesha 2013-11-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177560

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177560

MatlabForum.csv

Here it is , hope this works.

Walter Roberson 2013-11-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177583

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177583

在 MATLAB Online 中打开

Sample input extracted from file:

Restaurant  Item  Category  Type  QuarterOne  QuarterTwo  QuarterThree  QuarterFour
RestaurantOne  PaneerMasala  Indian  dish  1000  1000  2000  3000

Walter Roberson 2013-11-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177585

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177585

Your description suggests that you want to multiply something by something, but I have not been able to figure out what, or why you would want to order them. Is the data for Matrix1 a price, and the data for Matrix2 a volume (or the other way around perhaps) ? So you want to find the corresponding entries and multiply them together to get earnings ?

Neesha 2013-11-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177595

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177595

So if you can look into file, i have to matrices.

Both has 'Type'. First one has 'dish' , second matrix has 'ordered'.

I want to multiply 'dish' numbers of for each qtr with 'ordered' number for the same qtr of the same resturant and item. So you can see for ResturantThree Tacos for QuarterOne answer shd be = 2500*50. Hope this helps

Neesha 2013-11-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177596

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177596

My challenge here is that data in both matrix are in random order for the given resturant and item.

How do i make sure the the same Resturant and Item's 'dish' is multiplied with 'ordered'

Neesha 2013-11-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177599

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177599

I have uploaded file which has 'result matrix'. that can help to convey what i want to do.

Neesha 2013-11-1

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177600

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_177600

MatlabForum.xls

Here is the file

Andy 2013-11-6

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_178460

⋮

链接

此评论的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/104535-new-to-matlab-and-need-help-with-simple-calc#comment_178460

Have you thought about just running the matrices through a sort routine to start with? A simple "bubble" sort would be quick for a short matrix, you would just have to check both the Restaurant and Item columns.