Have a requirement that
have dataframe1 has columns [‘sheet’,‘Date’,‘Processed_date’]
have dataframe2 has columns [‘sheet’,‘Date’,‘Processed_date’]
now I have to compare the value of ‘sheet’ of two dataframe - if the values is same then have to update the date and process date to excel sheet.
if value of '‘sheet’ column is not same then have to insert.
insert works fine but how to update the other columns if the sheet value is same.
Any leads thank you.