需求:
数据清洗,将字符串数据中的任意格式的空白字符(中英文空格,换行,换页符等任意全角空格符)匹配并替换掉
解决方案:
def varchar_process(x):
if (not x is None) and (not ':' in str(x)):
try:
s = re.sub(r'\s+', '', x, re.M)
except:
s = x
else:
s = x
return s