A shop's orders table holds only the product id (product_id). To build a report you need to attach each product's name and price to every order. Complete attach_product_info(orders, products). orders the orders table β columns order_id, product_id, qty. products the products table β columns product_id, name, price. Join the two tables on product_id and return a new DataFrame in which each order row carries the product's name and price. Example Two orders (product_id A and B) come back with each product's name and price filled in.
A shop's orders table holds only the product id, so building a report means attaching each product's name and price to every order. This problem has you complete the joining function with pandas, linking the two tables (orders and products) on the product id and returning a new table where each order row carries name and price. You leave the originals unchanged and verify in code that the result's rows and columns come out as required.
A lookup join that attaches product name and price to each order β common in reports and feature building. Verify, on real data, that the result has the required columns and leaves the original tables unchanged.