Export from pandas to MS SQL using to_sql and sqlalchemy

Question

My problem is with Float values

example:

df = pd.DataFrame([1.45])

conn_str = 'mssql+pyodbc:///?odbc_connect={}'.format(params)
engine = create_engine(conn_str)

df.to_sql(name='teste',con=engine, if_exists='replace',index=False)

table is generated in my SQL successfully, the problem is the shape of the float that comes with comma instead of dot (1.45) how do I export with point separator(1.45)

Obs: in other tables of my bank are with separator by point

Thank you.

Answer 1

Use locale:

import locale
locale.setlocale(locale.LC_ALL, str('en_US.UTF-8'))