PY
py
1
2
3
4
5
6
7
8
9
10
11
12
13
# Q&A pandas finding name in other column
import pandas as pd
data = [['@a', 'hello'],
['@b', '@c @a'],
['@c', '@b @a']]
df = pd.DataFrame(data, columns=['Names', 'Posts'])
df.set_index('Names', inplace=True)
df['Mentions'] = 0
for name in df.index:
df.at[name, 'Mentions'] = df['Posts'].str.contains(name).sum()
print(df)
Enter to Rename, Shift+Enter to Preview
OUTPUT
Run