I have a table with 768 rows x 3 columns. I'm trying to exclude rows based on the values of the third column. Here is the beginning of the table:
'date' 'id' 'action'
'20200120' 5 276x1 double
'20200120' 4 1264x1 double
As you can see, each cell of the third column (action) actually contains hundreds of values.
These values are either 0 or 1, based on whether an action is performed (1) or not (0), each row of that cell corresponding to a specific timepoint.
I only want to know which individuals (id) performed any action at all, i.e. for the individual 5, among the 276 values of its 'action' cell, is there at least one value that isn't 0 (that is 1)?
Any help would be greatly appreciated. Returning a single average value for each 'action' cell would be one way but I don't know how to