Just wanted to share a simple py script that I built to automate uploading multiple csv files to a postgres database.<p>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.<p>I used this script almost everyday at my past job to upload data from other teams and departments.<p>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.
Didn't see the videos, but I want to thank you for your post.<p>I don't know if you "know" Django ORM or pyDAL... If use a database abstraction module you could extend your project easily to other databases.