Mager

I have two sample data frames, df1 and df2 as given below. df1 has the list of selected tennis match fixtures with player names(player1_name,player_name2) and the date they were played. Full names are used here for players.

df2 has the list of all tennis match results(winner, loser) for each date. Here, the first letter of first names and full last names are used. The player names for fixtures and for results were scraped from different websites. So there could be some cases where last names may not exactly match. Taking this into consideration, I would like to add a new column to df1 that says if player1 or player2 won. Basically, I would want to map player1_name and player2_name from df1 to winner and loser from df2 by some means of partial matching given the same date.