/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

5 votes118 views2 answers
Encrypt and decrypt python
Python
3 votes110 views2 answers
Add sheet to existing workbook openpyxl
Python
0 vote116 views1 answer
Python pipe select where
Python
1 vote163 views1 answer
Drop row with condition dataframe
Python
0 vote122 views1 answer
Heroku[web.1]: Process exited with status 3
Python
13 votes108 views3 answers
Django form example
Python
0 vote120 views1 answer
Arima A date index has been provided, but it has no associated frequency information and so will be ignored when e.g. forecasting
Python
0 vote111 views1 answer
Python get text between two points
Python
4 votes111 views3 answers
Python image crop
Python
0 vote128 views1 answer
Inpunt and output
Python