Concatenate DataFrames along rows or columns

Group DataFrame using one or more columns

Read a CSV file into a DataFrame

Combine DataFrames using database-style joins

pandas

merge

join

pd.merge

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

Merge on column id

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

Left join on column id

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

View the first few rows of a DataFrame

Get concise summary of DataFrame

Generate descriptive statistics of numeric columns