SqLite near field error

sqlite
python

#1

I wrote the code below which creates a DB with one table and 5 columns. When I run this code I get the error message below ( error in the line that reads “c.execute(sqlstr)”) .
The error is obviously related to inserting values. Any ideas?

Error message:
sqlstr: INSERT INTO table1 Day VALUES 1.0
Runtime error (Exception): near “Day”: syntax error
Traceback:
** line 36, in script**

import sqlite3
import sys

TabelName = 'table1'
values = [1, 1, 1.0, 1.0, 0]
columnsNmes =['Day', 'Month', 'Hour', 'HOY', 'Sun Falling on Tower Facade']
fieldTypes = [REAL,REAL,REAL,REAL,REAL]
filepath = 'C:\xampp\htdocs\FT-test9.db'

conn = sqlite3.connect(filePath)
c = conn.cursor()

if tableName and columnsNames and fieldTypes:
	try:
		c.execute('CREATE TABLE IF NOT EXISTS {tn} ({nf} {ft})'\
			.format(tn=tableName, nf=columnsNames[0], ft=fieldTypes[0]))
	
   
		for i, j in zip(columnsNames[1:], fieldTypes[1:]):
			c.execute("ALTER TABLE {tn} ADD COLUMN '{cn}' {ct}"\
				.format(tn=tableName, cn=i, ct=j))
	except:
		pass
		
newData = []
for d in data:
	f =float(d)
	newData.append(f)
	
for m,n in zip(columnsNames, newData):
	sqlstr = ("INSERT INTO {tn} {cn} VALUES {vv}".format(tn=tableName, cn=m, vv=n))
	print('sqlstr: {}'.format(sqlstr))
	c.execute(sqlstr)
 
conn.commit()
conn.close()

#2

columnsNmes

should be columnsNames(as you used columnsNames in if statement)