Trying to filter a column, im doing multi value contains in my filter which works fine, how do I get this to hide anything that doesn't contain those names?
(max_row, max_col) = df_routers.shape
worksheet1.autofilter(0,0,max_row, max_col -1)
worksheet1.filter_column(0, 'x == *usa-123* or x == *usa-abc*')
for row_num in (df_routers.index[(df_routers['Device Name'] != '*usa-123* or *usa-abc*')].tolist()):
worksheet1.set_row(row_num + 1, options={'hidden' : True})
