loop or other better solution for mixing?

1 次查看（过去 30 天）

addy fang 2020-7-27

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/571000-loop-or-other-better-solution-for-mixing

编辑： per isakson 2020-7-28

Hello, I want to do some mixing and wonder if there is any better solution other than looping.

I want to mix any number of ingredients to make one solution. The total percentage of the ingredients added up should equal to 100%. The percentage of each ingredient can be from 0% to 100%. I need to go through and save all the possible compositions with distinct names, and do calculations in order to find out the best composition.

Starting with two databases A and B, each with 4 columns of numerical data. I will need to produce and save all the mixed combination. For example, 10% of each column in A add 90% of the corresponding column in B, and save the result. The total percentage is 100%. This could be done with loop. x=0:0.1:1, C=x*A+(1-x)*b. This seems straightforward, if I only have two databases A and B.

If I have three databases, A, B and C, to produce D. So I need two loops?

If I have A, B, C and D, to produce E, so I need to have three loops?

If I want to mix more, do I have to create another loop again?

As the number of the databases I want to mix increase, this looping solution seems inefficient. Because everytime the numer of database changes, I need to rewrite my code again.

I was wondering if there is any better solution for this problem. So it does not need me to redo the coding even if I change the number of databases to be mixed. I hope I only need one code to run whatever number of databases that I want to mix.

I tried the following for two components and it did not work:

data1=importdata('\rawdata1.txt');
data2=importdata('\rawdata2.txt');
for x = 0:10:100, y = 0:10:100 & x+y=100;    
    data = data1.*x + data2.*y;
    
    folder = '\Desktop\';
    filename = sprintf('data_component1_%d_component1_%d.xls', x, y);
    fullfilename = fullfile(folder, filename);
    xlswrite(fullfilename, data);
end