pandas/merge

Merge DataFrames

Combine DataFrames using database-style joins

pandas
merge
join

Command

pd.merge

Explanation

pd.merge() is used to merge two DataFrames based on a key column.

Examples

Merge on column id

pd.merge(df1, df2, on="id")

Left join on column id

pd.merge(df1, df2, how="left", on="id")