Use the two files given (Volume_Symbol, and MarketVolume) to create the 3rd file MarketShare.
1. Eliminate any Symbols without a '-', these should all be ignored
Column Headers: Symbol, UKey, Qty, MarketVolume, MarketShare
Symbol: grab symbol from Volume_Symbol (There may be multiple symbols that are the same)
Ukey: grab UKey from Volume_Symbol (There may also be multiple UKey's that are the same)
Qty: From Volume_Symbol grab the larget Qty from the row for each symbol. If Symbols are not unique, add them together (Cumulative Value)
MarketVolume: Take the unique UKey and Search MarketVolume for a Value
MarketShare: Divide Qty/MarketVolume to return decimal.
Please let me know if you have any questions.
Hello, I understood all requirements. Ready to start right now and finish in a few hours. Best, Vyacheslav
6 freelancers are bidding on average $63 for this job
Hello, I am a python developer. I will be glad to help. I can not see 'Qty' in Volume_Symbol. Regards,
Dear sir, I've read your requirements, also check 3 attached files carefully. With expertise in Python/Parse file, I could be a good fit. Kind regards, Tin Tan
I HAVE MADE PART OF YOUR PROGRAM (SCRIPT). You can see the demo and how it looks here: [url removed, login to view] As you can see, I know how to do this. The reason why I haven't ma Daha Fazla