If you want to find rows that contain one of the substrings in a list, join that list using “|” then use the str.contains method.
str.contains
My previous tips on pandas.
DuckDB: Simplify DataFrame Analysis with Serverless SQL
Simplifying Dataset Comparison with Datacompy
Fuzzy Joining Tables with Non-Exact Matching Entries