26 Oct Join Pandas DataFrame

In Python, we can easily join Pandas DataFrames using the join() method. This will join the columns of two different DataFrames.

Before moving further, we’ve prepared a video tutorial to join Pandas DataFrame:

Let us see an example and create two DataFrames and join them:

import pandas as pd
 
# Dataset
data1 = {
  'id': ["S01", "S02", "S03", "S04", "S05"],
  'student': ["Amit", "John", "Jacob", "David", "Steve"],
  'roll': [101, 102, 103, 104, 105]
}
data2 = {
  'rank': [1, 4, 3, 5, 2],
  'marks': [95, 70, 80, 60, 90]
}
 
# DataFrame
dataFrame1 = pd.DataFrame(data1)
print("DataFrame1 =\n",dataFrame1)
dataFrame2 = pd.DataFrame(data2)
print("\nDataFrame2 =\n",dataFrame2)

# Join two DataFrames
resDF = dataFrame1.join(dataFrame2)
print("\nJoining DataFrames =\n",resDF)

Output

DataFrame1 =
     id student  roll
0  S01    Amit   101
1  S02    John   102
2  S03   Jacob   103
3  S04   David   104
4  S05   Steve   105

DataFrame2 =
    rank  marks
0     1     95
1     4     70
2     3     80
3     5     60
4     2     90

Joining DataFrames =
     id student  roll  rank  marks
0  S01    Amit   101     1     95
1  S02    John   102     4     70
2  S03   Jacob   103     3     80
3  S04   David   104     5     60
4  S05   Steve   105     2     90

If you liked the tutorial, spread the word and share the link and our website Studyopedia with others.

For Videos, Join Our YouTube Channel: Join Now