Post

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.