Matching dates in two different tables and inserting value in separate column in second table when dates match.

2 次查看（过去 30 天）
Wendy Cameron
Wendy Cameron 2018-5-10
评论： Wendy Cameron 2018-5-12
I want to match a date from one table column, with a date from a second table, and when the dates match, insert a value in a separate column in the second table, corresponding to that date. For example the first table is a list of flowering dates each year and the second table is the daily weather data for those years i.e. the tables are different sizes. If the date in the first table matches the date in the weather data, I want to insert "flowering" in a separate column corresponding to that date in the second table. This is so so I can then do for example temperature summations leading up to flowering.

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

采纳的回答

Guillaume
Guillaume 2018-5-10
That sounds very straightforward as long as you want an exact match for the date down to the second (I'm assuming your dates are stored as datetime
ismatch = ismember(yourfirsttable.datecolumn, yoursecondtable.datecolumn);
yoursecondtable.newcolumn = categorical(ismatch, [false true], {'not flowering', 'flowering'});
would be an option. Another option would be to label the new column flowering and just have true/false as values of the column:
yoursecondtable.flowering = ismatch;
  3 个评论
显示 1更早的评论
Guillaume
Guillaume 2018-5-11
I'm sure it can be done and probably fairly easily, however I don't completely understand what you want. An example with some data would make it much clearer.
Wendy Cameron
Wendy Cameron 2018-5-12
Please find attached some sample data. Miniprac shows a column of budburst dates and a column of flowering dates. Mini dates is the spreadsheet I want to match the dates to and when the dates match write either "budburst" or "flowering" in the second column (which I have inserted as an example in Minidates). Using your method, I can do each column separately and then merge them but I thought it would be neater if it could be done in one step. My actual data of course is more detailed than this but this cut down version I hope indicates more simply what I am hoping to achieve.
Thank you. Wendy

请先登录，再进行评论。

更多回答（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