How to parse a csv request and enter it into the database?

Question

PHP

Hello, I have a csv table with 1000 rows and a mysql table
Compressed example of two csv files and a final table:

You need to somehow process the csv data and put the data into a table, but only once for each value.
As I see the solution:
1) Create another table, where to enter data from csv by a unique index, if it is entered, then make a request to update the first table
2) -//-, collect data into a variable and enter everything together with one request

Answer 1

discover insert on duplicate key update