Back to problems

Implement left join on Python lists, no packages

Algorithm · Citadel · Medium

Write a pure Python function left_join(left, right) that reproduces the row semantics of a SQL LEFT JOIN on the id field. Use only the Python standard library; do not import pandas or any other third-party package. Each entry in left is a dictionary that may contain an id key plus arbitrary extra fields. Each entry in right is a dictionary with an id key plus extra fields. The non-id fields of right are guaranteed not to overlap with non-id fields of left. Return a list of…

Checking your access…