I have 2 excel Files
File1= 2 COlumns namely: Reference Number and Vehicle Applications
Reference Number Vehicle Applications
XYZ111 Polo, Golf, BMW
ABC222 Golf, BMW
File2= 2 Columns namely: Car Model and Total Sales
Car Model Total Sales
Polo 500
Golf 1000
BMW 100
I am trying to find which car models from File2 are present in vehicle applications of File1 and if present I want to calculate total sales.
For Eg: In first row of File1: Polo and Golf are present then next to it I need calculation of sales which would be Golf Sales+Polo Sales=1500
What I have tried:
I have tried importing the library re to find the values and sub strings.
Please note, I am new to Python