Info
この質問は閉じられています。 編集または回答するには再度開いてください。
Can I join with 1 variable and 1 value as "keyword"?
2 ビュー (過去 30 日間)
古いコメントを表示
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
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
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 件のコメント
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!