Tutorials References Exercises Videos Menu
Create Website Get Certified Upgrade

Pandas DataFrame combine() Method

❮ DataFrame Reference


Example

Combine two DataFrames columnwise, and return the largest column:

import pandas as pd

df1 = pd.DataFrame([[1, 2], [3, 4]])
df2 = pd.DataFrame([[5, 6], [7, 8]])

def myfunc(a, b) :
  if (a.sum() > b.sum()):
    return a
  else:
    return b

print(df1.combine(df2, myfunc))
Try it Yourself »

Definition and Usage

The combine() method combines two DataFrame objects, and uses a specified function two decide which column to keep.


Syntax

dataframe.combine(other, func, fill_value, overwrite)

Parameters

The fill_value and overwrite parameters are keyword arguments.

Parameter Value Description
other   Required. A DataFrame.
func   Required. A function that will compare the columns and return one of them.
fill_value Number|None Optional. Default None. A value to fill empty cells with.
overwrite True|False Optional. Default True. Specify whether columns that do not exists in the second DataFrame will be overwritten (with NaN) or not

Return Value

A DataFrame with the results.


❮ DataFrame Reference