Join / Replace data in CSV from another CSV -


i have 2 seperate csv files, 1 'products', other 'users'.

products.csv

name | owner | price belt | 5121 | 14.25 shoe | 3692 | 20.50 

users.csv

name | user# | phone_number rick | 3692  | 8888675309 sami | 5121  | 8888675309 

i resulting csv replace 'owner' field corresponding name other csv, so:

updated_products.csv

name | owner | price belt | sami | 14.25 shoe | rick | 20.50 

i'm using windows, suggestions?


Comments