Movies-ETL ETL pipeline on movie data using Python and postgreSQL Overview This project consisted on a automated Extraction, Transformation and Load pipeline. This ETL extracted movie data from wikipedia, kaggle, and MovieLens to clean it, transform it, and merge it using Pandas. The product was a merged table with movies and ratings loaded to PostgreSQL. Resources Data sources: movies_metadata.csv ratings.csv wikipedia_movies.json Software: Python PostgreSQL Pandas SQLAlchemy Regular Expressions Results Summary The pipeline was created under the following assumptions: I was […]