Write a perl script to update a column from one csv file to another

Please see the document and perl script. We have a csv file with ~50k lines that we want to update with information from a second csv file with ~200k lines. We want to use a script similar to the perl script attached, and with the same performance (less than 15 minutes to run and finish). The output should be written to a third csv file. All csv files are utf-8 encoded. Sample inputs and outputs are also attached.