I have a sample dataframe df.
I would like to know if there is a way to return all values that begin w a special character.
I currently have it to only return values with the ‘@’ sign, but would like all special characters. Or at least how to list multiple options using regex
Fruits
Apple
-Orange
$Pear
Cherry
@Grape
df.str.contains(r'^\[@]')]
>Solution :
Assuming you define special character as anything which is not alphanumeric, we can try:
df[df["Fruits"].str.contains(r'^[^A-Za-z0-9]')]