フィルターのクリア

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

1 回表示 (過去 30 日間)
Stormi Noll
Stormi Noll 2021 年 3 月 12 日
コメント済み: 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

回答 (1 件)

ANKUR KUMAR
ANKUR KUMAR 2021 年 3 月 12 日
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 件のコメント
Stormi Noll
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
ANKUR KUMAR 2021 年 3 月 15 日
Could you please accept the answer if it helps you.

サインインしてコメントする。

カテゴリ

Help Center および File ExchangeLogical についてさらに検索

Community Treasure Hunt

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

Start Hunting!

Translated by