0

I have two pandas dataframe.

Code

import pandas as pd

data1 = {'Name':['tom', 'nick', 'krish', 'jack'], 'Age':[20, 21, 19, 18],'Mark':[43,44,45,46]}
df1 = pd.DataFrame(data1)
data2 = {'Name':['nick','tom'], 'Age':[21, 20]}
df2 = pd.DataFrame(data2)

DataFrame 1

    Name  Age  Mark
0    tom   20    43
1   nick   21    44
2  krish   19    45
3   jack   18    46

DataFrame 2

   Name  Age
0  nick   21
1   tom   20

I am trying to crate a new column Mark in pandas dataframe 2 from dataframe 1 which have matching Name in both dataframes but not a success in any of my attempts.

Resultant Dataframe Needed

   Name  Age  Mark
0  nick   21    44
1   tom   20    43

Thanks in advance

imhans4305
  • 677
  • 1
  • 16

0 Answers0