How can I use accumarray in order to evaluate the place where users spend most of their time?

2 vues (au cours des 30 derniers jours)
Hello everybody, I would like to make a question. I have the array Z with
Z(:,1)=USER_ID
Z(:,2)=PLACE
Z(:,3)=DATE
Z(:,4)=TIME
For each user I compute the most visited location as
% L = accumarray(Z(:,1),Z(:,2),[max(Z(:,1)) 1],@mode);
How can I evaluate the location in which users spend most of their time? For each location visited by each user I should evaluate the timespan in days and then choose the location where this timespan is maximum.
Thanks for your support.
  2 commentaires
Andrei Bobrov
Andrei Bobrov le 9 Juil 2015
Z(:,4) - interval of time (in hours or minutes)?
Emanuele Massaro
Emanuele Massaro le 9 Juil 2015
Z(:,4) is in form of "hhmmss". But for now I just care about the timespan in days Z(:,3). I am doing
L1 = accumarray(Z(:,1:2),Z(:,4),[max(Z(:,1)) max(Z(:,2))],@sum);
What do you think?

Connectez-vous pour commenter.

Réponses (0)

Catégories

En savoir plus sur Tables dans Help Center et File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by