Import csv with polluted data

Hi everyone,   I am trying to import some data with a CSV file (separator : comma).    But the data is a real disaster.   Let's take the content of only 2 columns of this file and some examples...