Pandas to_sql insert only some columns
You'll need to perform two steps:


You get ride of the id column in the pandas dataframe:

df=df.drop(columns=['id'])

Add the index=False param: to the .to_sql() method:

selected.to_sql('dataiswa', engine, index=False)