How would I filter data on multiple criteria through the spreadsheet using python(pandas)?
I am trying to filter transactions with all Curr1=USD, where Trade Time within 1 minute, Have the same Notional 1 and have the Price within .5% spread between transactions. Then the row with the furthest(highest) Maturity would be moved to a different Sheet in excel.
Example of the data: GoogleDrive Excel File
Thank you in advance!
No comments:
Post a Comment