How do I select specific data from a matrix with a loop?

I have done research on viewing behavior in football matches. I want to create a graph with the frequency on the y-axis and on the x-axis the viewing behavior over the 10 before the first touch of the ball. From the matrix (see image) I must therefore first encode when there is a first ball contact, then at the corresponding time I have to view the viewing behavior in the previous 10 seconds. Selecting he first touch of the ball succeeded, but not 'code' the interval of 10 seconds before the first touch. Who could help me?

[Stephen23]

@jakobjakob: please upload the code you have been writing by clicking the paperclip button.

[jakobjakob]

The problem is that i don't have a code about this specific part. Maybe you have some tips to select a interval in a matrix?

Answer 1

[Stephen23]

Fundamentally it will come down to indexing into your data matrix C (which seems to be a cell array: is this correct?). Here is an outline:

• convert the time column to a numeric vector, e.g. TV = [C{:,1}];.
• loop through each "touch" value...
• get the index of the "touch" row, e.g. idx.
• use idx to get the time of that row: TT = TV(idx).
• compare all times in to find the ones that you want, e.g. idt = TV>=TT-10 & TV<=TT.
• you can then analyze those rows: C(idt,:).