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)