xxxxxxxxxx
data["column_name"] = data["column_name"].replace("#"," ",regex = True)
"#" ==> what you want to remove
" " ==> what you want to add
regex ==> text patterns that you can use to automate searching through and replacing elements within strings of text