insert an array according to the values from another variable

Question

0 个投票

From the following example:

time = [733774,733774,733775,733775,733775,733776,733776];
bthD = [20,10,0,15,10,20,10];
bthA = (1000:100:1600);
%Hypsographic curve
Hypso = [(10:1:20)',(1000:100:2000)'];
d = [1,1.3,1,2.5,2.5,1,1.2];
data = horzcat(time',bthD',d');
[uniqueTimes,idx,idx] = unique(time);% finds the unique times and the index
counts = hist(time,uniqueTimes);% finds the distribution of uniqueTimes in time
expandedData = mat2cell(data,counts,length(uniqueTimes));

I would like to add another 'column' into expandedData which show the corresponding areas of the depths (expandedData{i}(:,2)). The area at each depth is given by the variable Hypso, which stands for hypsographic curve, so, the first column refers to the depths and the second column refers to areas. So, in this example I would like to go into each cell in expandedData and find the area for the corresponding depth from 'Hypso'. Hope this makes sense.