title: How to insert multiple IDs into a sql statement?
body: <p>New to python and pandas, Im facing the following issue:</p>
  
  <p>I would like to pass multiple string into a sql query and struggle to insert the delimiter ',' :</p>
  
  <pre><code>Example data
  
  import pandas as pd
  
  data = [['Alex',10],['Bob',12],['Clarke',13]]
  df = pd.DataFrame(data,columns=['Name','Age'])
  print (df)
  
  # Remove header (Not sure whether that is necessary)
  df.columns = df.iloc[0]
  
  
  pd.read_sql(
  
      """
  SELECT
  *
  
  FROM emptable
  WHERE empID IN ('{}',)
  
      """.format(df.ix[:, 0]), # Which corresponds to 'Alex','Bob','Clarke'
  
      con = connection)
  </code></pre>
  
  <p>I tried different combinations, however None of them have worked out.</p>