total noob here, sorry for the beginner question. I've been racking my brain in Pandas trying to filter a series in a Dataframe to locate rows that contain one among a list of strings.
import pandas as pd
streets = ['CONGRESS', 'GUADALUPE', 'BEN WHITE', 'LAMAR', 'MANCHACA', 'BURNET', 'ANDERSON', 'BRAKER' ]
# the actual list of street names is much longer than this
strs = pd.read_csv('short_term_rental_locations.csv')
# the following returns no values, or all 'False' values to be more accurate
strs[strs['PROP_ADDRESS'].isin(streets)]
# but if I use .contains, i can find rows that contain part of the
# street names, but .contains has a limit of six positional arguments.
strs[strs['PROP_ADDRESS'].str.contains('CONGRESS')]
I've tried using wildcard * with .isin to no avail. I feel so dumb for struggling with this. Any help much appreciated. Thanks!