pandas get all rows that contain string code example Example: column contains substring python df2 = df.filter(regex='spike') print(df2)