title: Pandas read_CSV reading into one column, won't seperate on ","
body: <p>I'm having issues getting a csv file to separate on the comma. Only option that has worked, is using excel Data--> Text to column, separate on comma. When I do this and open the file it will work, however everything  I try in python simply opens into one column. What am I missing?</p>
  
  <p>In the first DF I attempt to open the csv and seperate into multiple columns. The second DF is the excel file after I have data-Text to column on the "," value. </p>
  
  <p>9-16-17 to 9-30-17</p>
  
  <p>Report Filter:
  {Claim Status Code} (ID) = "P" And {Claim Source Code} (ID) = "X" And {Claim Source Code} (ID) = "X" And {Claim Fill Date} (ID) </p>
  
  <p>General Purpose 1 (GP1) - Member CDD,"Member Name - Last, First","Product/Drug Label Name","Claim Fill Date","Submitted Unit Quantity","Total Days Supply","Total Copay Amount","Total Net Cost"</p>
  
  <p>0026,"PERSON, FAKEONE","OTHERINFO TAB 875MG","9/26/2017","20","10","$8.75","$0.00"
  0026,"PERSON, FAKETWO","INFORMATION 400/5ML","9/24/2017","200","10","$0.00","$0.00"
  0026,"PERSON, FAKETHREE","DATAENTRY 40MG","9/25/2017","15","30","$0.00","$20.59"</p>
  
  <p><a href="https://i.stack.imgur.com/qj7xw.png" rel="nofollow noreferrer">Jupyter Notebook</a></p>