Importing csv file to SQL Server using python without an index

Question

I have imported a csv file into SQL Server with python but it is automatically inserting an index column as the first column. I have looked at other questions on SO regarding this issue and have tried things like index_col=false but the index still appears my code is as follows

from sqlalchemy import create_engine
import pandas as pd
engine = create_engine('mssql+pyodbc://'+UID+':'+PWD+'@'+DATABASE)

data = pd.read_csv(r'C:\Users\user\file.txt', chunksize=10000,index_col = False)

for i in data:
    i.to_sql('table1', engine, if_exists='replace')

LeopoldVonBuschLight · Accepted Answer · 2017-06-28 14:49:50Z

1

I think you need to add the index = False parameter to the to_sql method:

for i in data:
    i.to_sql('table1', engine, if_exists='replace', index=False)

answered Jun 28, 2017 at 14:49

LeopoldVonBuschLight

9115 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Importing csv file to SQL Server using python without an index

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related