Info

此问题已关闭。 请重新打开它进行编辑或回答。

Can I join with 1 variable and 1 value as "keyword"?

2 次查看（过去 30 天）
Mario Diaco
Mario Diaco 2020-5-29
关闭： MATLAB Answer Bot 2021-8-20
Hi!
Can I match by dates and by country names?
I've matched by dates, but the code capture all countries.
Thanks
  1 个评论
Adam Danz
Adam Danz 2020-5-29
Images of text are always really hard to work with. Copying the text directly is much better (just FYI for future posts).

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

回答（1 个）

Adam Danz
Adam Danz 2020-5-29
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 个评论
Mario Diaco
Mario Diaco 2020-5-30
Thanks for the suggestions. How I can create a logical vector of date to match?
dateMatches =
60×1 datetime array
31-Jan-2015
28-Feb-2015
31-Mar-2015
30-Apr-2015
31-May-2015
30-Jun-2015
31-Jul-2015
31-Aug-2015
30-Sep-2015
31-Oct-2015
30-Nov-2015
31-Dec-2015...
Adam Danz
Adam Danz 2020-5-31
编辑：Adam Danz 2020-6-2
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;

标签

产品

Community Treasure Hunt

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

Start Hunting!

Translated by