Ismember as a condition?

3 次查看（过去 30 天）
Daphne PARLIARI
Daphne PARLIARI 2020-1-30
评论： Daphne PARLIARI 2020-1-30
Hello guys.
I am trying to achieve something easy I think, but I don't know the correct way.
I have two tables, let's say WRF and Obs, that contain hourly values of several variables. What I want to do is calculate things and produce graphs, for the dates that both tables have data.
Eg, WRF contains data from 1/7/2019 to 30/9/2019 and Obs from 31/3/2019 to 30/9/2019.
I tried
ismatch = ismember(Obs.Hourly_DATE, WRF.Date);
which returns 0s kai 1s. How do I take one step further and use the 1s to calculate the things I want?
Thank you in advance!
  4 个评论
显示 2更早的评论
Mohammad Sami
Mohammad Sami 2020-1-30
编辑：Mohammad Sami 2020-1-30
Ok the innerjoin should then correctly merge the two tables together on the common datetime values. Do verify the newtable created before using it further.
Daphne PARLIARI
Daphne PARLIARI 2020-1-30
编辑：Daphne PARLIARI 2020-1-30
Something goes wrong... Attached please find the Obs table, the WRF table and newtable.
Newtable is far too long. I think the problem is that I have to consider columns Time, also (for both tables, WRF and Obs).

请先登录，再进行评论。

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

采纳的回答

Mohammad Sami
Mohammad Sami 2020-1-30
Yes needed to combine with the time column.
load Obs.mat
load WRF.mat
WRF_Data.Date = WRF_Data.Date + duration(hour(WRF_Data.Time),minute(WRF_Data.Time),0)
Obs_Data.Hourly_DATE + duration(string(Obs_Data.Time),'InputFormat','hh:mm');
newtable = innerjoin(Obs_Data,WRF_Data,'LeftKeys','Hourly_DATE','RightKeys','Date');
  2 个评论
Daphne PARLIARI
Daphne PARLIARI 2020-1-30
Works fine with a mistake though:
In newtable, column Time_WRF_Data is in datetime format and it appears 00:00 in all rows....
Daphne PARLIARI
Daphne PARLIARI 2020-1-30
The mistake I mentioned above is easily corrected this way:
WRF_Data.Date = WRF_Data.Date + duration(hour(WRF_Data.Time),minute(WRF_Data.Time),0);
Obs_Data.Hourly_DATE = Obs_Data.Hourly_DATE + duration(string(Obs_Data.Time),'InputFormat','hh:mm');
All_Data = innerjoin(Obs_Data,WRF_Data,'LeftKeys','Hourly_DATE','RightKeys','Date');

请先登录，再进行评论。

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Live Scripts and Functions 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by