How to change certain values of a column in a table depending on a certain time range ?

6 次查看（过去 30 天）
Gayan Lankeshwara
Gayan Lankeshwara 2020-4-13
评论： Gayan Lankeshwara 2020-4-13
Hi there,
I have an array Total and then I created a timetable to combine them together.
t1 = datetime(2020,04,01, 0,0,0);
t2 = datetime(2020,04,01, 23,59,59);
Date = [t1:seconds(10):t2]' ;
T = table(Date,Total);
totalaggregated = table2timetable(T) ;
Now I want to replace the value in Total column ONLY for the following time range,
TR = timerange('2020-04-01 14:50:00','2020-04-01 15:10:00');
So that
Total = Total * 0.75
Can any one please help me how to do this ?
Thanks.
Regards,
Gayan

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

采纳的回答

Tommy
Tommy 2020-4-13
Try this:
totalaggregated{TR,{'Total'}} = 0.75*totalaggregated{TR,{'Total'}};

更多回答（0 个）

类别

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

标签

产品


版本

R2019a

Community Treasure Hunt

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

Start Hunting!

Translated by