Average of rows based on oter column

Hello,

I have a very big dataframe with many columns, I am interested in making the average of a variable X only between 8am and 7pm (the hours column is introduced in the dataframe and expressed in military time (8am = 0800 or 800) and I have records every 30 minutes.

As an addition and if it is possible, I want to know the count of how many rows have been used to make the average for each day, as I have missing data and not all the 30 minutes observations are present.

Thank you.

[dpb]

Use a timetable and retime and/or groupsummary Read about grouping variables in general...

Answer 1

[Image Analyst]

Try grpstats, groupsummary, or splitapply. You might also want to take a look at findgroups