Dataframe to postgresql - Saving the dataframe to memory using StringIO

Shaozhong SHI shishaozhong at gmail.com
Thu Oct 22 05:27:14 EDT 2020


I found this last option is very interesting.

Saving the dataframe to memory using StringIO

https://naysan.ca/2020/06/21/pandas-to-postgresql-using-psycopg2-copy_from/

But, testing shows
unicode argument expected, got 'str'

Any working example for getting DataFrame into a PostgreSQL table directly?

Regards,

David


More information about the Python-list mailing list