擅长:python、mysql、java
<p>这将处理您的场景:</p>
<pre><code>import pandas as pd
from collections import Counter
query = "data analysis"
wordlist = query.split(" ")
#print(wordlist)
# row wise frequency count
df['text_new'] = df.text.str.split().apply(lambda x: Counter(x))
output = pd.DataFrame()
# iterate row by row
for index, row in df.iterrows():
temp = dict()
for word in wordlist:
temp['title'] = row['title']
temp['lemma'] = word
temp['count'] = row['text_new'][word]
temp['lineid'] = row['lineid']
output = output.append(temp, ignore_index=True)
#print(output)
</code></pre>