This is homework for a data analysis class, I have taken a small part of the table. As you can see in the image above, I have a table with several headings. The table is full of data from a trading desk, headers include Amount traded,counter party(who we traded with), amount intially ordered , and the various providers who were showing the amount the offered (size). I need a function of some sort that can: 1. link the counter party to the Provider row by row. 2. do a calculation based on which provider the we traded with(counterpart) went through. the calculation is called fill ratio which is = (Amounttraded)/min(amountordered,size(depending on the provider) for example the 1st row fill ratio would be (1000000.0)/min(amount ordered=100000.0),(size based on provider=CS=100000.0) meaning fill ratio in this case is 1 if CS only showed 500000.0 then the fill ratio would be 0.5.
Thank you, please don't hesitate to comment for more info if needed
Aucun commentaire:
Enregistrer un commentaire