Putting time series data together

1 次查看（过去 30 天）
Tim Moriarty
Tim Moriarty 2015-12-2
评论： dpb 2015-12-2
I have imported three excel files as tables: calendar, data1, data 2. I have unstacked data 1 and data 2 and now I want to put data 1 and data 2 into the calendar table and use the date column in all three as the joining key. Data 1 and data 2 are over 1000 columns wide and there are time intervals where there is no data in each of data 1 and 2 and these missing data timestamps varry between data 1 and data 2. Essentially I want to use the calender table as a "master" table as it only has dates as a variable and then insert the data from data 1 and data 2. I am trying to time align the data and I have tried inner and outer join and horizonal concat with no success. Any help would be greatly appreciated
  1 个评论
dpb
dpb 2015-12-2
I don't know about the table operations as don't have recent-enough version. I'd likely use independent vectors for the time stamps and combination of intersect and friends to select the rows and then insert those results into the table.

请先登录，再进行评论。

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

回答（0 个）

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by