Azzera filtri
Azzera filtri

Ismember as a condition?

4 visualizzazioni (ultimi 30 giorni)
Daphne PARLIARI
Daphne PARLIARI il 30 Gen 2020
Commentato: Daphne PARLIARI il 30 Gen 2020
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 Commenti
Mohammad Sami
Mohammad Sami il 30 Gen 2020
Modificato: Mohammad Sami il 30 Gen 2020
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 il 30 Gen 2020
Modificato: Daphne PARLIARI il 30 Gen 2020
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).

Accedi per commentare.

Risposta accettata

Mohammad Sami
Mohammad Sami il 30 Gen 2020
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 Commenti
Daphne PARLIARI
Daphne PARLIARI il 30 Gen 2020
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 il 30 Gen 2020
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');

Accedi per commentare.

Più risposte (0)

Categorie

Scopri di più su Tables in Help Center e File Exchange

Community Treasure Hunt

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

Start Hunting!

Translated by