# Group discretized data and determine mean

4 views (last 30 days)
Tessa Kol on 8 Sep 2020
Answered: Tessa Kol on 8 Sep 2020
Dear all,
With help of the community I discretized my data, x-coordinates of particles, into bins. For every bin I want to take the mean of all the x-coordinates that are in the bin. However, as time goes by the bins will be empty since the particles will move out of the bin to another bin. Thus, I can not use the function splitapply to group and take the mean of the x-coordinates in every bin. What can be an alternative for this problem?
for i = 1:length(files)
...
% Define the range of the bins
rng_x{i} = -0.3:0.06:0.3;
% Assign the data of x-coordinate to a predefined range
disc_x{i} = discretize(expData{i,1}(:,1),rng_x{i});
...
end

Tessa Kol on 8 Sep 2020
I found the solution myself. Here is an example for a single data file:
mean = accumarray(disc_x{1,1}(:,1), expData{1,1}(:,2),[6 1], @mean);

R2020a

### Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!