title: How can I update a specific cell in a sqlite database through python
body: <p>I have a database full of numbers but as a string. My main goal is to get a cell in the SQLite database, turn it into a float and then update the cell with it. However I don't understand how to update a specific cell in a SQLite database. Here is my code.</p>
  <pre><code>for row in cur:
      for col in row:
          try:
              fcol = float(col)
              cur.execute('UPDATE test SET ')
          except:
              print(&quot;FAIL&quot;)
              print(col)
              continue
          print(&quot;Replaced&quot;,col)
      print(&quot;Row done&quot;)
  print(&quot;Completed&quot;)
  </code></pre>
  <p>Basically my question is how I can update a specific cell of a SQLite database.</p>