djE4wBRN

1var1            object
2var2        datetime64[ns]
3var3             object
4var4            object
5var5             int64
6var6            float64
7	
8CREATE TABLE IF NOT EXISTS "table_name" (
9"var1" TEXT,
10"var2" DATETIME,
11"var3" TEXT,
12"var4" TEXT,
13"var5" INT,
14"var6" REAL
15);
16	
17query = 'insert into first_north4 (var1, var2, var3, var4, var5, var6) values (?, ?, ?, ?, ?, ?)'
18values = [tuple(x) for x in df.values]
19cur.executemany(query, values)
20	
21sqlite3.InterfaceError: Error binding parameter 1 - probably unsupported type.