df.Team.replace(d,inplace=True) df Out[176]: Market Status Team 0 Chicago 1 tom@email.com 1 Chicago 1 tom@email.com 2 SFBay 3 Julia@email.com 3 SFBay 1 Julia@email.com 4 SFBay 1 Julia@email.com