How to match two date columns

4 ビュー (過去 30 日間)
Chris H
Chris H 2019 年 10 月 10 日
編集済み: Turlough Hughes 2019 年 10 月 17 日
Eg of data:Name of dataset in my workspace is dsColShort
run_date trade_date Volume
735934 732604 100
735934 732655 200
735934 732658 50
735934 732658 100
735934 732689 400
735934 732724 600
735934 735934 700
I need to match up when column 'run_date' == 'trade_date'. I only want to show the row that matches. eg, there will be a 732604 in trade_date column that matches a separate row in run_date column but I do not want those to populate. Only if it's in the same row that they match.
any advice on what function I can use? or if I need to define any of the rows as a separate variable?
Thanks
  5 件のコメント
Chris H
Chris H 2019 年 10 月 17 日
Hey just figured it out. I was pulling the wrong column name for the actual volumes. Your formula :
idx=dsColShort.run_date==dsColShort.trade_date;
dsColShort(idx,1:3)
pretty much worked so thank you!
Turlough Hughes
Turlough Hughes 2019 年 10 月 17 日
No problem :)

サインインしてコメントする。

採用された回答

Turlough Hughes
Turlough Hughes 2019 年 10 月 17 日
編集済み: Turlough Hughes 2019 年 10 月 17 日
To find the rows in your table, called dsColShort, wherein run_date and trade_date are equal you can use the following code
idx=dsColShort.run_date==dsColShort.trade_date;
We can then use this logical index to return the rows where your condition has been satisifed:
dsColShort(idx,1:3)

その他の回答 (0 件)

カテゴリ

Help Center および File Exchange2-D and 3-D Plots についてさらに検索

製品

Community Treasure Hunt

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

Start Hunting!

Translated by