How do I take a small array, keyed by a datetime variable which is a subset of a larger array and replace the values in the larger array with the values from the smaller array?

Question

T4H14 2018-5-14

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400719-how-do-i-take-a-small-array-keyed-by-a-datetime-variable-which-is-a-subset-of-a-larger-array-and-re

评论： Ameer Hamza 2018-5-14

What is the best way to take an table which is keyed by a datetime variable and replace the data in a much larger taable (same variables in both) with the data in the smaller table? The smaller table could fall anywhere in the larger table's date range but the smaller table will be made up of contiguous dates.

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

请先登录，再进行评论。

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

Answer 1

Guillaume 2018-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400719-how-do-i-take-a-small-array-keyed-by-a-datetime-variable-which-is-a-subset-of-a-larger-array-and-re#answer_320179

在 MATLAB Online 中打开

[isinsmall, where] = ismember(bigtable.datevariable, smalltable.datevariable);
bigtable(isinsmall, :) = smalltable(where, :);

Assuming both tables have the same variable names.

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

请先登录，再进行评论。

Answer 2

Ameer Hamza 2018-5-14

0
链接

此回答的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/400719-how-do-i-take-a-small-array-keyed-by-a-datetime-variable-which-is-a-subset-of-a-larger-array-and-re#answer_320170

在 MATLAB Online 中打开

If both tables have same variable names, you can insert the small table inside large table much like inserting rows inside the matrix. For example

bigTable = ... % you big table
smallTable = ... % your small table
newBigTable = [bigTable(1:5, :); smallTable; bigTable(5:end, :)];

this will insert small table after 5 rows of the large tables and then insert the remaining large table at the end.

2 个评论
显示无隐藏无

T4H14 2018-5-14

What if instead of simply inserting you actually have to match the dates of the small table to dates in the large table and replace the large table data with the small table data? For example, if the large data set includes dates for every day in 2018 but you want to replace May 1-15 in the large data set with the small data set data?