<p>我有大约1.3米的字符串(代表用户在发送IT帮助热线时的需求)在Pandas df中。我还有一系列的29813个名字,我想从这些字符串中删除,这样我只剩下描述问题的单词。这是一个数据的小例子-它可以工作,但它花费的时间太长了。我正在寻找一种更有效的方法来实现这个结果:</p>
<p>输入:</p>
<pre><code>List1 = ["George Lucas has a problem logging in",
"George Clooney is trying to download data into a spreadsheet",
"Bart Graham needs to logon to CRM urgently",
"Lucy Anne George needs to pull management reports"]
List2 = ["Access Team", "Microsoft Team", "Access Team", "Reporting Team"]
df = pd.DataFrame({"Team":List2, "Text":List1})
xwords = pd.Series(["George", "Lucas", "Clooney", "Lucy", "Anne", "Bart", "Graham"])
for word in range(len(xwords)):
df["Text"] = df["Text"].str.replace(xwords[word], "! ")
# Just using ! in the example so one can clearly see the result
</code></pre>
<p>输出:</p>
^{pr2}$
<p>我已经试着寻找答案了一段时间:如果我因为缺乏经验而错过了某个地方,请温柔一点,让我知道!在</p>
<p>非常感谢:)</p>