|
|
|
|
|
by falco925
2021 days ago
|
|
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. |
|