Info
This question is closed. Reopen it to edit or answer.
Can I join with 1 variable and 1 value as "keyword"?
2 views (last 30 days)
Show older comments
Hi!
Can I match by dates and by country names?
I've matched by dates, but the code capture all countries.
Thanks
1 Comment
Adam Danz
on 29 May 2020
Images of text are always really hard to work with. Copying the text directly is much better (just FYI for future posts).
Answers (1)
Adam Danz
on 29 May 2020
isMatch = dateMatches && ismember(T.Country, {'Austria','Belgium'});
Replace dateMatches with your date-matching code that produces a logical vector of date matches.
Replace T with your table name and list the countries you'd like to match.
isMatch is a logical vector of row-matches.
2 Comments
Adam Danz
on 31 May 2020
Edited: Adam Danz
on 2 Jun 2020
I thought you had alread done that. In your question, "I've matched by dates, but the code capture all countries.".
If you have a list of dates D and a 2nd list of dates D2, to find the dates in D that are listed in D2,
ismember(dateshift(D,'start','day'), dateshift(D2,'start','day'))
If you're trying to find all dates in D that are within range of date1 to date2,
D >= date1 & D <= date2;
See Also
Products
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!