Subtract a different number from every group n of values in a table

1 次查看（过去 30 天）

Stormi Noll 2021-3-12

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/771208-subtract-a-different-number-from-every-group-n-of-values-in-a-table

评论： ANKUR KUMAR 2021-3-15

I am trying to find the perturbations in my data based on a 30 minute time average for 24 hour data.

My original data has 1728000 rows, divided by 48 is 36000. So each of the 36000 entries need to subtract value 1 from the other table, the next 36000 entries will subtract value 2. I have tried for loops and I can't get anything to work past the 36000 entries.

I need something to perform the following:

big_table.uprime(1:36000) = big_table.B_Ux_2(1:36000) - thirtymin.u30(1);

big_table.uprime(36001:72000) = big_table.B_Ux_2(36001:72000) - thirtymin.u30(2);

and so on

0 个评论
显示 -2更早的评论隐藏 -2更早的评论

请先登录，再进行评论。

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

回答（1 个）

ANKUR KUMAR 2021-3-12

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/771208-subtract-a-different-number-from-every-group-n-of-values-in-a-table#answer_646543

在 MATLAB Online 中打开

You can use reshape to perform operations:

data=randi(20,1,1728000);
B=reshape(data,36000,[]);
B=B-ones(size(B,1),size(B,2)).*[1:size(B,2)];
data_new=reshape(B,size(data,1),[]);

4 个评论
显示 2更早的评论隐藏 2更早的评论

Stormi Noll 2021-3-13

B = reshape(big_table.B_Ux_2 ,6000, []);

for i = 1:288

B(:,i) = B(:,i) - fivemin.u5(i);

end

big_table.uprime5 = reshape(B, size(big_table, 1), []);

I used a combination of our methods. Thanks for the advice.

ANKUR KUMAR 2021-3-15

Could you please accept the answer if it helps you.

请先登录，再进行评论。

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

类别

MATLAB Language Fundamentals Data Types Numeric Types Logical

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

Community Treasure Hunt

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

Start Hunting!

Translated by