title: How to pass variable values dynamically in pandas sql query
body: <p>How to pass variable parameters dynamically</p>
  
  <pre><code>order = 10100
  
  status = 'Shipped'
  
  df1 = pd.read_sql_query("SELECT  * from orders where orderNumber =""" +  
  str(10100) + """ and status = """ + 'status' +"""  order by orderNumber """,cnx)
  </code></pre>
  
  <p>TypeError: must be str, not int</p>
  
  <p>getting above error although i converted to strings any idea?</p>
  
  <p>is there any alternative wy to pass the parameters?</p>