0

I am new to dataframes and pandas and just need insight on how this might work.

Compare Name Column in Import_tab sheet to Name Column in Name sheet and if there is a match retrieve data from Email Column in Name Sheet and then replace the value in the Email Column in Import_Tab sheet.

I have stored the different sheets into different dataframes

Import_tab = pd.read_excel(dump_file, sheet_name='Import')
Name = pd.read_excel(dump_file,sheet_name='Name')

Import_tab dataframe:

enter image description here

Name dataframe:

enter image description here

The end result in the Import_tab dataframe should be:

enter image description here

Shiv Patel
  • 39
  • 1
  • 1
  • 5

0 Answers0