我认为你的代码应该是这样的
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