Pandas DataFrame combine() Method
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.