/Python/Py - count if a word is present in a column

Py - count if a word is present in a column

words = 'one two three'.split()

df.assign(counts=df.texts.str.count('|'.join(words)))

        texts  counts
0  throne one       2
1     bar one       1
2     foo two       1
3   bar three       1
4     foo two       1
5     bar two       1
6     foo one       1
7   foo three       1
8   one three       2

Source: stackoverflow.com

Similar codes

0 vote179 views1 answer
Django default template location
Python Django
0 vote147 views1 answer
Pyplot savefig
Python
-1 vote145 views1 answer
Pandas numpy multiplicar dos columnas segun una condicion
Python
0 vote148 views1 answer
How to save the history of keras model
Python
0 vote141 views1 answer
Python fillna with mean in a dataframe
Python
0 vote137 views1 answer
Split() vs split(' ')
Python
2 votes144 views1 answer
How to print hostname in python
Python
32 votes152 views6 answers
Else if python
Python
0 vote141 views1 answer
Django serializer,
Python
2 votes162 views1 answer
How to save query data into dataframe pscopg2
Python