How can I merge successive row values (sum of the values) of the column Y according to a condition in column X?

Question

Laty El 2022-4-19

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1699885-how-can-i-merge-successive-row-values-sum-of-the-values-of-the-column-y-according-to-a-condition-i

回答： Peter Perkins 2022-5-18

Dear,

Hope everyone is doing well!

My issue is: I have a two data columns (X and Y) and datime column (10 min interval). I want to merge the successive row values (sum) of column Y if the corresponding values of column X are 0. Otherwise, if one of the X row equals to 1, then no merge.

Knowing that X contains only 0 and 1 values.

Thank you for your collaboration.

2 个评论
显示无隐藏无

Matt J 2022-4-19

Doesn't that mean that all the Y values in the data you've shown will be summed? There are no ones in the X column at all, so why have you designated only the specific rows circled in red?

Peter Perkins 2022-5-18

Also you have not said what merging does to the timestamps.

请先登录，再进行评论。

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

Answer 1

Peter Perkins 2022-5-18

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/1699885-how-can-i-merge-successive-row-values-sum-of-the-values-of-the-column-y-according-to-a-condition-i#answer_966685

You want to do grouped sums, where the groups are defined by consecutive zeros in X. Once you have the groups defined as a new variable in (what should be) a timetable, it's a simple matter of calling groupsummary. Usually defining groups like that involves tricks with cumsum and diff. But without a clear example of what you have and what you want, I won't hazard a guess.