title: How to pass a python variable as a sqlite column name in a for-loop
body: <p>It looks like similar questions have been asked but I didn't find an answer.</p>
  
  <p>The cities in the cities list have corresponding column names in a database.  I'm trying to find a specific city's pressure with pyowm, then insert that value into the appropriate column.</p>
  
  <p>The error is that there is not a column named "city".  I can see what the problem is but do not know how to fix it.  Any help is greatly appreciated!</p>
  
  <pre><code>import pyowm
  import sqlite3
  
  conn = sqlite3.connect(r"C:\Users\Hanley Smith\Desktop\machinelearning\pressure_table.db")
  cursor = conn.cursor()
  
  owm = pyowm.OWM('eb68e3b0c908251771e67882d7a8ddff')
  
  cities = ["tokyo", "jakarta"]
  
  for city in cities:
      weather = owm.weather_at_place(city).get_weather()
      pressure = weather.get_pressure()['press']
      cursor.execute("INSERT INTO PRESSURE (city) values (?)", (pressure,))
  
  conn.commit()
  </code></pre>