How to match two date columns

4 visualizaciones (últimos 30 días)
Chris H
Chris H el 10 de Oct. de 2019
Editada: Turlough Hughes el 17 de Oct. de 2019
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 comentarios
Chris H
Chris H el 17 de Oct. de 2019
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 el 17 de Oct. de 2019
No problem :)

Iniciar sesión para comentar.

Respuesta aceptada

Turlough Hughes
Turlough Hughes el 17 de Oct. de 2019
Editada: Turlough Hughes el 17 de Oct. de 2019
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)

Más respuestas (0)

Categorías

Más información sobre 2-D and 3-D Plots en Help Center y File Exchange.

Productos

Community Treasure Hunt

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

Start Hunting!

Translated by