I am trying to filter a column in a dataframe for all the entries which contain a certain substring:

Let's say for the above, i want to filter for all the rows that contain ada in their name. So that would be rows 5 and 6 only. I would write something like this:

SELECT * from MailList where 'ada' in email

But this doesn't work.

CodePudding user response：

If this is a SQL question, you can use LIKE operator as:

... where email like '