Juan Perez LlorenteDataset Cleaning with Pandas (Python)Up to 60-70% of any data project is spent on data cleaning and preparation and having the proper skills is crucialJan 31, 20231Jan 31, 20231
Juan Perez LlorenteCalculating month-on-month (MoM) percentage variation with SQLOne of the most important metrics for a business is the growth variation between periods (annual, quarterly, monthly) as it is a great…Nov 23, 2022Nov 23, 2022
Juan Perez LlorenteData Analysis Project with Python. Quality of Movies in Streaming PlatformsPython project in which I analyze the rating of movies in streaming platformsAug 30, 2022Aug 30, 2022
Juan Perez LlorenteinDev GeniusA Selenium Use Case: Extracting IMDb User RatingA couple of months ago I found on Kaggle three datasets that contained information about titles available on Netflix, Amazon Prime Video…Jun 15, 2022Jun 15, 2022
Juan Perez LlorenteWhen Python meets SQLAfter finishing my degree in Business Administration I enrolled on a Data Analytics bootcamp to take my first steps in becoming a…May 9, 20221May 9, 20221
Juan Perez LlorenteThe magic power of UNPIVOT in SQLFew are the times in which we work with a table or dataset that has either perfect data quality or strucutre, and in most cases we need to…Feb 15, 20221Feb 15, 20221