MATLAB: How could avoid too have loop in big data

big dataloopsaving time

I have a big data set(near to 13G). it is a table with information about different agencies at a different time(every day of 10 years). I use unique() to make groups for months and years and agencies. (is it true?) I need to calculate the mean of each agency at all month and years.how could I save time?

Best Answer

You can use findgroups/splitapply or put the data in a table and use varfun or grpstats.
Upload some data if you need code.
Related Question