I have a csv file that I want to import but each line of the csv file contains data that i dont want to keep (need to be filtered) and length of each line is different (in one column might have two different information but it is still string). The csv file dont have header but it can be added using excel but i dont think its a good idea.
(id, typeA,typeB,typeC) --> header that i add in the csv
But some line, dont have type B, so it became like this
Is there a way i can import this kind of csv without modifying the csv?