MATLAB: Calculating average from 2 rows

calculation average

Hi guys, I have a cell array with 90 cells. Each cell consists of 6 columns and approximately one million rows. Column 1 shows date. Column 2 shows time. Column 3 shows max value. Column 4 shows min value. Column 5 shows closing value. I want to do the following: i want to calculate the average value of max and min of every row in column 3 and 4. For instance, if the max value is 6 and the min value is 2 then the average of the two is 4.

Best Answer

It sounds like you just want to add a seventh column to each cell in your cell array. Just sum the third and fourth columns and divide by two

 % iterate over each cell
 for k=1:length(myCells)
    myCells{k} = [myCells{k} (0.5*(myCells{k}(:,3)+myCells{k}(:,4)))];
 end

The above assumes that myCells is your cell array with 90 cells.

Related Solutions

MATLAB: How to add columns with a certain formula

AA - you seem to have a good idea of the algorithm, so it should be straightforward to implement. Suppose myData, a matrix of dimension 1000000x6, is one element in your cell array. Then

 % assume that myData is 2D
 [m,n] = size(myData);
 % size your output column
 calcData = zeros(m,1);
 % iterate in steps of 60
 stepSize = 60;
 for k=1:stepSize:m
    % set the start and end indices for the block of sixty
    startIdx = k;
    endIdx   = min(m,k+stepSize-1);
    % determine the min and max values
    minCol4 = min(myData(startIdx:endIdx,4));
    maxCol3 = max(myData(startIdx:endIdx,3));
    % do the calculation
    calcData(startIdx:endIdx) = (myData(startIdx:endIdx,6) - minCol4)/(maxCol3-minCol4);
 end

Note that we do the min(m,k+stepSize-1); to make sure that we do not set the end index to something beyond the end of the array. Once the code has completed the above loop, you can do whatever you wish with the calcData column (prepend to myData for example), and then move on to the next cell array element.

MATLAB: How to count the amount of cells

 your_count = cellfun(@(x) numel(x),your_cell_array);

Best Answer

Related Solutions

MATLAB: How to add columns with a certain formula

MATLAB: How to count the amount of cells

Related Question