pandas mysql insert_python – Pandas将数据插入MySQL

我认为你的代码应该是这样的

import pandas as pd

from pandas.io import sql

from sqlalchemy import create_engine

df = pd.read_csv('File.csv', usercols=['ID', 'START_DATE'], skiprows=skip)

print(df)

engine = create_engine('mysql://username:password@localhost/dbname')

with engine.connect() as conn, conn.begin():

df.to_sql('Table1', conn, if_exists='replace')

但是,关于你的问题,除非我对Pandas的理解有误,无论目前有哪些列,这些都将被写入mysql表同名的列中.

如果您需要不同的列名,则需要重命名DataFrame中的列名

index : boolean, default True

Write DataFrame index as a column.

index_label : string or sequence, default None Column label for index column(s). If None is given (default) and index is True, then the index names are used