0

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

Plasma
  • 1,903
  • 1
  • 22
  • 37
Shravya Vaggu
  • 41
  • 1
  • 6

0 Answers0