I am just starting out in numpy. I am trying to load data from a csv file using numpy.I have lines in the data in this format
Input Format:
893,3,"kelly,Mr. James",male,34.5.
I am using genfromtxt to load it using delimiter = ','
, dtypes = None
.
But using this loads the data as below:
893,3,'"kelly,' , ',Mr. James"', 'male', 34,5.
Expected Output:
893,3,"kelly,Mr. James",'male',34,5
.
Dont know how to use delimiters properly for this.