Left outer join

Q: How deeply does Pandas Workout: 200 exercises to make you a stronger data analyst cover left outer join?

Explains the left-side row-selection rule and demonstrates index preparation, joining, grouping, and aggregation.

As explained in Pandas Workout: 200 exercises to make you a stronger data analyst

A left join retains rows driven by the left input and attaches matching rows from the right input when available.

A left outer join combines normalized data while preserving the rows driven by the left DataFrame. Matching rows from the right DataFrame are attached when available, making separate datasets analyzable together. section 6.8

Combine products with sales

Set product_id as the index in products_df and sales_df, then run products_df.join(sales_df). The product rows drive the result, while matching sales information is attached. Continue by grouping the joined result by name, date, or both, then summing quantity or retail_price. section 6.8

products_df.join(sales_df)

Inspect the concise pandas operation that joins products_df and sales_df after product_id becomes the index. section 6.8

How Pandas Workout: 200 exercises to make you a stronger data analyst covers it

Cover of Pandas Workout: 200 exercises to make you a stronger data analyst

liveBook manning.com

Read Pandas Workout: 200 exercises to make you a stronger data analyst on liveBook Get the book at manning.com

Also explained in

liveBook manning.com

Grokking AI ApplicationsA join that retains every row from the left table and adds matching rows from the right table when available.
liveBook manning.com

The Well-Grounded Data AnalystA left join combines records from two datasets while retaining every record from the left dataset and matching records from the right dataset when available.
liveBook manning.com

Build Financial Software with Generative AI (From Scratch)A left join is a relational query operation that returns every row from the left relation and matching rows from the right relation, representing missing matches with null values.
liveBook manning.com

Statistics Slam DunkA left join is a tabular merge that retains all rows from one input and attaches matching values from a second input.
liveBook manning.com

Learn SQL in a Month of LunchesA left outer join is an SQL join that returns all rows from the left table together with matching rows from the right table, representing missing right-side matches with null values.

Compare how 6 books explain left outer join →

Related concepts

missing valueproduces · A missing value is a marker or condition indicating that an expected data value or reference is absent, unavailable, unknown, or inapplicable.
joinkind of · A join is an operation that combines records or rows from multiple data sources according to specified matching conditions or relationships.
inner joinalternative to · An inner join is a relational operation that returns combinations of rows only when the join condition matches records in both input relations.
$lookupused by · $lookup is a MongoDB aggregation-pipeline stage that joins documents from another collection, typically using a left outer join.
where clausecontrasts with · A WHERE clause is a query-language clause that restricts returned or affected records to those satisfying a specified predicate.

This explainer was generated by Manning's knowledge graph from the text of Pandas Workout: 200 exercises to make you a stronger data analyst. The section links point to the parts of the book it draws on.