reverse_dct = {}
for k,v in dct.items():
for i in v:
reverse_dct[i] = k
df = pd.DataFrame({'text_column':text_column})
df['word_type'] = df['text_column'].explode().map(reverse_dct).dropna().groupby(level=0).apply(','.join)
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