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.
6 freelancers are bidding on average $63 for this job
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