Deciding when to do data manipulation using Python, SQL
Use Python for manipulation relating to cell values: string manipulation, deduplication and fuzzy matching.
Use SQL for other manipulation.
It’s much easier to do things step-by-step in SQL and see what the effect is.
This post is licensed under CC BY 4.0 by the author.