Skip to content
Advertisement

How to upload data from csv to database(PostgreSQL) on python

I have a few parsers that collect data and make csv file, after collecting data I need to upload data from csv to my database(PostgreSQL)

p.s.table in database is already exist and just need to append data

How can I do this?

I have try to use sqlalchemy, but after connection don’t know what to do

JavaScript

Didn’t find information that could help me

Advertisement

Answer

Probably you are learning, because you didn’t check the google before. I recommand to study the following:

https://docs.python.org/3/library/csv.html#csv.DictReader https://docs.sqlalchemy.org/en/14/tutorial/data_insert.html#tutorial-core-insert

So basically you have to do something like this:

JavaScript

Then commit!

Good luck!

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement