Pandas: df not displaying correctly

I have a csv file that looks something like this:

              0            1
0 full_name, Andrew Dean, Milly Mayer,
1 automotive, 216 DYV, ...
...

I now would like to convert this into a pandas df that should look like this

  full_name         automotive      ...
0 Andrew Dean       216 DYV         ...
1 ...               ...

I already asked this question and in general got a pretty good answer (.T)! But what I missed earlier, that my header row are numbers and the first column (that holds all the column names) has no number at all! I also noticed: If i try to import the csv and put it into a df I actually get:

  ,0,1,2,3,4,5, ...
0
1
2
3
...

So I get the header row and the indices, but no actual data?? I hope this was not to confusing, because I am very confused myself...

How many English words
do you know?
Test your English vocabulary size, and measure
how many words do you know
Online Test
Powered by Examplum