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

Pandas To Sql Server
Convert Csv Blank Cell To Sql Null In Python
Pandas: Efficient Way To Select Rows From A Dataframe Using Multiple Criteria

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"