sqlite3 "OperationalError: near "(": syntax error" python

python sqlite

Simply put, let the DB API do that formatting:

c.execute("INSERT INTO Data_Output6 VALUES (?, ?)", (xdates[i], Averages_norm[-1]))

And refer to the documentation https://docs.python.org/2/library/sqlite3.html where is mentioned:

Instead, use the DB-API’s parameter substitution.

CodeHunter