Форум сайта python.su
0
Добрый день!
У меня есть код:
import pandas as pd from sqlalchemy import create_engine data=[[18:04:23, 24, 0.63790, 45, 892] [18:12:27, 32, 0.54881, 36, 701] [18:34:34, 46, 0.45972, 27, 610] [18:59:56, 02, 0.36363, 08, 529] [18:59:56, 02, 0.36363, 08, 529] [18:59:56, 02, 0.36363, 08, 529] [18:59:56, 02, 0.36363, 08, 529] [19:06:23, 67, 0.27054, 99, 438] [19:23:43, 56, 0.18145, 80, 347] [19:32:45, 99, 0.09236, 71, 256] [19:43:12, 13, 0.90327, 62, 165] [19:43:12, 13, 0.90327, 62, 165] [20:04:00, 24, 0.81418, 53, 074] [20:38:24, 54, 0.72509, 44, 983] [20:47:46, 75, 0.63690, 35, 892] [21:04:59, 83, 0.54781, 26, 701] [06:04:23, 67, 0.52342, 26, 345]] db_connection = 'mysql+pymysql://AAA:OOO@localhost/PPAP' conn = create_engine(db_connection) for i in data: pd.read_sql('INSERT IGNORE test (Time,ID,X,Y) VALUES(%s,%s,%s,%s)' % (i[0],i[1],i[2],i[3]), conn)
Офлайн
0
Проблема решилась заменой на conn.execute.
Офлайн