Home / Dataframe / Pandas / Pyodbc / Python / Sql Server

Python And Sql : Replacing The Empty Strings Of A Dataframe By A “null” Value Of Sql To Insert The Data In A Database Without Error Of Format

October 21, 2023 Post a Comment

Let's say that I have this dataframe and this code to insert my data in the data base : import pandas as pd import pyodbc REFERENCE = ['GZF882348G', 'SFGUZBJLNJU', 'FTLNGZ242112

Solution 1:

Replace NaN with None

sql_data = df.replace({np.nan:None}).to_numpy().tolist()

Baca Juga

Inserting Values Into A Access 2003 Database From A Python Application Using Pyodbc
Add New Row Based On An If Condition Via Python
Subprocess.popen With A Unicode Path

Python Guru

Python And Sql : Replacing The Empty Strings Of A Dataframe By A “null” Value Of Sql To Insert The Data In A Database Without Error Of Format

Solution 1:

Post a Comment for "Python And Sql : Replacing The Empty Strings Of A Dataframe By A “null” Value Of Sql To Insert The Data In A Database Without Error Of Format"