splitapply doesn't split well into bins

4 Ansichten (letzte 30 Tage)
Amit Ifrach
Amit Ifrach am 11 Okt. 2021
Kommentiert: Matt J am 13 Okt. 2021
Hi guys,
I wanted splitapply command to split to 90 different bins. somewhy it returns only 50.
Here is the process I made:
First, 'cell1areas' (size - 18800X1) - a variable that contains vector of areas was loaded.
then 'bins' or 'groups' from 0 to 90000 in 1000 spacing was created in 'edges' variable.
after that, discretize function was applied to the area vector data. the max value of the variable dis is 62 (max(dis)).
valid function was apllied to check rather the data is a number or NaN.
last, splitapply function was called with @sum to sum all values for each group.
The problem is, that the spltsum variable have 50 'bins' or vector elements in it, instead of the desired 90 (which is the number of bins in edges) or even 62(!) like the discretize gave only 62 different numbers and not 90.
Thanks in advace, this community is great and really helpfull!
the code:
edges=[0 0:1000:90000 90000];
dis=discretize(cell1areas, edges);
spltsum=splitapply(@sum , cell1areas(valid) , findgroups(dis(valid)) );

Akzeptierte Antwort

Matt J
Matt J am 11 Okt. 2021
Bearbeitet: Matt J am 13 Okt. 2021
You can use accumarray instead.
spltsum=accumarray(dis(valid), cell1areas(valid) , [90,1]);
  5 Kommentare
Matt J
Matt J am 13 Okt. 2021
Not all 90 bins contain counts. If you don't tell accumarray how many bins you have, it will assume you only have max(dis(valid)) bins.

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)


Mehr zu Preprocessing Data finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by