Average of rows based on oter column

1 次查看（过去 30 天）
YEMY
YEMY 2022-6-23
回答： Image Analyst 2022-6-23
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.

请先登录，再回答此问题。

回答（1 个）

Image Analyst
Image Analyst 2022-6-23
Try grpstats, groupsummary, or splitapply. You might also want to take a look at findgroups

类别

在 Help Center 和 File Exchange 中查找有关 Spreadsheets 的更多信息

标签

产品


版本

R2020b

Community Treasure Hunt

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

Start Hunting!

Translated by