How to Strip Brackets and Quotes from Pandas Cells Using Regex

1. Introduction

Hello, I am a Python enthusiast. A recent question in a Python community asked how to remove the characters [, ], and single quotes from an Excel field such as "中山分公司['张三']" when loading it into a Pandas DataFrame.

One attempted solution was:

df['备注']=df['备注'].str.replace(r'\[','',regex=True).replace(r'\]','',regex=True).replace(r'\'','',regex=True)

The result was empty, prompting further discussion.

2. Implementation

Community members suggested using regular expressions to match and replace the unwanted characters, while an alternative is to call str.replace multiple times for each character.

Below are code screenshots illustrating different approaches:

All methods successfully removed the unwanted characters, allowing the data to be processed correctly.

3. Conclusion

This article reviewed a common Pandas string‑cleaning problem, demonstrating both a regular‑expression solution and a series of str.replace calls. The provided code snippets enable readers to quickly apply the fix to similar issues in their own projects.