pandas data frame look up for a part of the string code example
Example 1: python search for word is in column
df[df.column.str.contains("word")]
Example 2: python - find specific name in a df
i = df[df['Name']=='Will']
print(i)
df[df.column.str.contains("word")]
i = df[df['Name']=='Will']
print(i)