Importing a csv that has duplicate rows into mysql

I have a csv file I would like to import into a table. The csv file has many duplicate rows that I do not need. How do I import this data into a table without the duplicate rows if it is possible.

tia

First import the file into a table.

then run a query using GROUP BY to remove duplicates

SELECT * FROM oldtable WHERE 1 GROUP BY [columns to remove duplicates from];

CREATE TABLE newtable
SELECT distinct * FROM oldtable