How can I find out some specific dates from two date lists?

3 Ansichten (letzte 30 Tage)
Hi, I have two date lists. DateList1.m contains dates from 1984 to 2022 (with many gaps) and DateList2.m constains dates from 2005 to 2019 (with no gap). I want to make a table that contains all temperature data between 9:00 am to 11:00 am from DateList2.m but those specific dates need to be in dateList1.m as well.
Can anyone please suggest how to code this problem? Any feedback will be much appreciated!

Akzeptierte Antwort

Cris LaPierre
Cris LaPierre am 8 Jun. 2023
You have date information in DateList1, and date+time information in DateList2.
I would add a column to DateList2 that is just the date. You might find the dateshift function helpful for this. Then I could use ismember to find which dates in DateList2 are in DateList1. At the sime time, you could check that the day time is between 9 and 11 am. Use the hour function with the corresponding relational operators.
  4 Kommentare
Ashfaq Ahmed
Ashfaq Ahmed am 8 Jun. 2023
Thank you so much. You really know tons of functions!!

Melden Sie sich an, um zu kommentieren.

Weitere Antworten (0)


Mehr zu Tables finden Sie in Help Center und File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by