Pandas DataFrame join() Method
Example
Add the content of one DataFrame to another:
import pandas as pd
data1 = {
"name": ["Sally", "Mary",
"John"],
"age": [50, 40, 30]
}
data2 = {
"qualified":
[True, False, False]
}
df1 = pd.DataFrame(data1)
df2 = pd.DataFrame(data2)
newdf = df1.join(df2)
Try it Yourself »
Definition and Usage
The join() method inserts column(s) from another DataFrame, or Series.
Syntax
dataframe.join(other, on, how, lsuffix, rsuffix, sort)
Parameters
The join, on,
how, lsuffix ,
rsuffix, sort
parameters are
keyword arguments.
| Parameter | Value | Description |
|---|---|---|
| other | Required. A DataFrame, a Series or a list of DataFrames. | |
| on | String List |
Optional. Specifies in what level to do the joining |
| how | 'left' |
Optional. Default 'left'. Specifies which index to use |
| lsuffix | Sring | Optional. Default '', Specifies a string to add for overlapping columns |
| rsuffix | Sring | Optional. Default '', Specifies a string to add for overlapping columns |
| sort | True |
Optional. Default False. Specifies whether to sort the DataFrame by the join key or not |
Return Value
A new DataFrame, with the updated result.
This method does not change the original DataFrame.
