Sometimes, we want to remove unwanted parts from strings in a column with Python Pandas.
In this article, we’ll look at how to remove unwanted parts from strings in a column with Python Pandas.
How to remove unwanted parts from strings in a column with Python Pandas?
To remove unwanted parts from strings in a column with Python Pandas, we can use the lstrip and rstrip methods.
For instance, we write
data['result'] = data['result'].map(lambda x: x.lstrip('+-').rstrip('aAbBcC'))
to call map on the values in the result column.
We call it with a lambda function that calls lstrip to remove the characters listed on the left end of the string.
Likewise, we call rstrip to remove the characters listed in the right side of the string.
Conclusion
To remove unwanted parts from strings in a column with Python Pandas, we can use the lstrip and rstrip methods.