SQLAlchemy fault

Shaozhong SHI shishaozhong at gmail.com
Wed Oct 20 05:31:58 EDT 2021


I read a txt file into Pandas Dataframe, and found a lot of nulls in a
column.

Then, I used SQLAlchemy and psycopg2.  I created engine.

I loaded data onto PostgreSQL.

Strange thing happened.

The column has no null at all.

Does it mean that the data has been modified somewhere along the line?

Does anyone know the robust and fast loading of Pandas frame data onto
Postgres database?

Regards,

David


More information about the Python-list mailing list