if dataframe 1 column == dataframe 2 column , then print the colum2 in df2.
dataframe1
ColumnA 
john
mike
rose
lilly
duke
harry
dataframe 2
column A      ColumnB
john              aus
jonson            swiss
jerry             ireland
tom               europe
nik               england
jullie            london
mike              newjersy
suppy             china
rose              japan
peter             newyork
lilly             london
duke               us
harry              uk
output should be
if column A in Dataframe1 == column A in datframe 2 then print columnB in dataframe1 required output should be dataframe1
ColumnA   columnB
john        aus
mike        newjersy
rose        japan
lilly       london
duke         us
harry        uk
Can anyone help me out of this thanks inadvance
 
    