Data Cleaning: SQL v Python Pandas v Power BI Power Query: REPLACE, DROP COLUMNS, HANDLE NULLS
A series where I use all 3 applications to clean data showing you the pros and cons of each and which one I prefer for which task. This video will show you how to replace values, drop unwanted columns and handle nulls and blanks.
My code is available here: https://github.com/hthomas229/PurpleC...