我有这样的数据集
import pandas as pd
df = pd.DataFrame({'word': ['abs e learning ', 'abs e-learning', 'abs e&learning', 'abs elearning']})
我想要得到
word
0 abs elearning
1 abs elearning
2 abs elearning
3 abs elearning
我做如下
re_map = {r'\be learning\b': 'elearning', r'\be-learning\b': 'elearning', r'\be&learning\b': 'elearning'}
import re
for r, map in re_map.items():
df['word'] = re.sub(r, map, df['word'])
和错误
TypeError Traceback (most recent call last)
<ipython-input-42-fbf00d9a0cba> in <module>()
3 s = df['word']
4 for r, map in re_map.items():
----> 5 df['word'] = re.sub(r, map, df['word'])
C:\Users\Edward\Anaconda3\lib\re.py in sub(pattern, repl, string, count, flags)
180 a callable, it's passed the match object and must return
181 a replacement string to be used."""
--> 182 return _compile(pattern, flags).sub(repl, string, count)
183
184 def subn(pattern, repl, string, count=0, flags=0):
TypeError: expected string or bytes-like object
我可以这样应用 str
for r, map in re_map.items():
df['word'] = re.sub(r, map, str(df['word']))
没有错误,但我无法如我所愿地获得 pd.dataFrame
word
0 0 0 0 abs elearning \n1 abs elearning\...\n1 0 0 abs elearning \n1 abs elearning\...\n2 0 0 abs elearning \n1 abs ele...
1 0 0 0 abs elearning \n1 abs elearning\...\n1 0 0 abs elearning \n1 abs elearning\...\n2 0 0 abs elearning \n1 abs ele...
2 0 0 0 abs elearning \n1 abs elearning\...\n1 0 0 abs elearning \n1 abs elearning\...\n2 0 0 abs elearning \n1 abs ele...
3 0 0 0 abs elearning \n1 abs elearning\...\n1 0 0 abs elearning \n1 abs elearning\...\n2 0 0 abs elearning \n1 abs ele...
如何改进呢?