python-ecology-lesson icon indicating copy to clipboard operation
python-ecology-lesson copied to clipboard

Ordering of left/right does not matter for *any* join

Open maneesha opened this issue 5 years ago • 1 comments

The Combining DataFrames with Pandas notes that:

For inner joins, the order of the left and right arguments does not matter.

However, this is true of all joins. I would suggest modifying this text to reflect this. Otherwise it is misleading and implies that it may matter for other types of joins.

maneesha avatar Dec 10 '19 13:12 maneesha

I believe order matters for left and right (outer) joins. Could you please clarify your point?

maxim-belkin avatar Feb 20 '20 00:02 maxim-belkin

@maneesha Thank you for your report. Order does matter for certain joins, e.g., the left join preserves all rows for the left argument, so I'm closing this one.

btovar avatar May 16 '23 12:05 btovar