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

3 visualizaciones (últimos 30 días)
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.

Respuesta aceptada

Guillaume
Guillaume el 10 de Mayo de 2018
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 comentarios
Guillaume
Guillaume el 11 de Mayo de 2018
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 el 12 de Mayo de 2018
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

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Dates and Time en Help Center y File Exchange.

Etiquetas

Community Treasure Hunt

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

Start Hunting!

Translated by