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?
1 Ansicht (letzte 30 Tage)
Ältere Kommentare anzeigen
T4H14
am 14 Mai 2018
Kommentiert: Ameer Hamza
am 14 Mai 2018
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 Kommentare
Akzeptierte Antwort
Guillaume
am 14 Mai 2018
[isinsmall, where] = ismember(bigtable.datevariable, smalltable.datevariable);
bigtable(isinsmall, :) = smalltable(where, :);
Assuming both tables have the same variable names.
0 Kommentare
Weitere Antworten (2)
Ameer Hamza
am 14 Mai 2018
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 Kommentare
Ameer Hamza
am 14 Mai 2018
In that case, refer to @Guillaume's answer. It will overwrite the values in the big table with values in the small table.
Peter Perkins
am 14 Mai 2018
The answer might be join, or maybe outerjoin. It might also be synchronize. It's hard to tell from your question.
0 Kommentare
Siehe auch
Kategorien
Mehr zu Tables finden Sie in Help Center und File Exchange
Produkte
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!