[[pandas]] offers multiple ways to [[join]] DataFrames or Series. See the [pandas guide to merging](https://pandas.pydata.org/docs/user_guide/merging.html) for all available options. - `pandas.merge` is the most flexible option and the right choice in most cases. - `pandas.DataFrame.join` joins the column of another DataFrame on the index or a key column. > [!Tip] > To run SQL queries on Pandas DataFrames, try [[DuckDB]]. Left, right, inner, outer and cross joins #rough ## Validation Joining data can return unexpected results.