I have two data frames. The first is a list of email addresses 

```
email_ad                   Band 30     Band 40
example_email@gmail.com
sample_email@gmail.com

```

The second is the following data frame

```
email_ad                 Name       Manager_Name   Manager_Band_level 
example_email@gmail.com. Tom Banks  Boss1          30
sample_email@gmail.com.  Bill Bob   Boss2          40

```

I want to map each email in the first dataframe to the second, if the email is a match, then check the Manager Band level. Based off the number, fill that corresponding manager's email into the "Band 30" or "Band 40" categories. 

So the desired dataframe is the following: 

```
email_ad                   Band 30     Band 40
example_email@gmail.com    Boss1
sample_email@gmail.com.                Boss2

```

if someone could please help me for syntax that would be amazing. I was additionally stuck making a dictionary out of only certain columns in the dataframe. Thanks so much!!