Just wanted to share a simple py script that I built to automate uploading multiple csv files to a postgres database.
The script will clean the file name and column headers and create the SQL statements to create the db table and upload the file to the database, automatically.
I used this script almost everyday at my past job to upload data from other teams and departments.
I recorded a tutorial on youtube for anyone that wants to try to build it out (links in the README). Hope this is helpful either as a way to easily upload files to a db or as practice getting better building python scripts to automate your work.
The script will clean the file name and column headers and create the SQL statements to create the db table and upload the file to the database, automatically.
I used this script almost everyday at my past job to upload data from other teams and departments.
I recorded a tutorial on youtube for anyone that wants to try to build it out (links in the README). Hope this is helpful either as a way to easily upload files to a db or as practice getting better building python scripts to automate your work.