I would like to know how I can go through a column and remove the strings that are between square brackets.
Example
'String [more string]'
after
'String'
Can anyone help me?
I thought about using regular expressions. However, I don't know how to zoom in. I think it can be done by writing a lambda function.
You might do it following way
import pandas as pd
df = pd.DataFrame({'col1':['String [more string]']})
df['col2'] = df['col1'].str.replace(r'\[.*\]', '', regex=True)
print(df)
gives output
col1 col2
0 String [more string] String
Observe we need to escape [
to get literal [
as [
has special meaning otherwise.