Easy ETL Program with Python
This video walks you through creating an quick and easy Extract (Transform) and Load program using python. In less than 30 lines of code you will be able to be up and running with your data.
The video walks through the entire development process, but if you want to go straight to the code, visit: https://gitlab.com/oscarvalles/py4all...
Also, this video leverages using pgpass for password storage. If you are new to that, go to: • using .pgpass with Python
I also recommend reading up on the following libraries as they offer rich features for data interaction within the Python programming language:
petl: https://petl.readthedocs.io/en/latest...
psycopg2: http://initd.org/psycopg/
sqlalchemy: https://www.sqlalchemy.org/
On this page of the site you can watch the video online Easy ETL Program with Python with a duration of hours minute second in good quality, which was uploaded by the user Analyst's Corner 12 August 2017, share the link with friends and acquaintances, this video has already been watched 74,057 times on youtube and it was liked by 579 viewers. Enjoy your viewing!
