Logical indexing with matrix
1 view (last 30 days)
I have a matrix which is 197*14. The 1. column is datenum of dates, the 2. column is day, the 3. is month, the 4. is year and the rest of the matrix is data. I want to calculate the mean per month of the data. So far I have used logical indexing to find the different months and then used the given index to calculate the mean. However, it only calculates the mean of the first column and not all of the matrix. Here is what I have done for one month:
Price=GaspriceFM(:,5:end); % To get only the data
[JulyIDX,~,~] = find(GaspriceFM(:,3) == 7); % Find data from July
How do I get it to calculate the mean per column of the entire matrix? Thank you very much in advance!