python - 将函数应用于 DataFrame 列中的内容并将其保存在另一个中的最佳方法

Question

大家好，这就是问题所在，我有一个像这样的 DataFrame:

     item_id  item_title  item_content  title_trans  content_trans0    1        "First"     "Stuff"       NaN          NaN     ...      ...         ...           ...          ...99   100      "Last"      "More stuff"  NaN          NaN

What i intend to do is apply a translation for the title and content column, saving the output to its respective last columns. (Translation will be done with TextBlob or python translate).Output should look like this:

     item_id  item_title  item_content  title_trans  content_trans0    1        "First"     "Stuff"       "Primera"    "Cosas"     ...      ...         ...           ...          ...99   100      "Last"      "More stuff"  "Última"     "Más cosas"

My latest idea was to make a for with DataFrame.iterrows(), and save each output with iloc, kinda like this:

for index, item in DataFrame.iterrows():
    raw_text = '\n'.join(item['item_title'], item['item_content'])
    trans_text = str(TextBlob(raw_text).translate(to='es'))
    title, content = trans_text.split('\n')
    DataFrame.iloc(index, 'title_trans') = title
    DataFrame.iloc(index, 'content_trans') = content

无论这对于小数据集有多好，如果我将其应用到大量数据集(数千个)，我可以看到它会如何开始减慢。有没有一种方法可以映射它或者比 for 循环更有效的方法？

Answer 1

尝试使用应用:

df['title_trans'] = df['item_title'].apply(lambda x: str(TextBlob(x).translate(to='es')))
df['content_trans'] = df['item_content'].apply(lambda x: str(TextBlob(x).translate(to='es')))