Edit

Share via


Use ai.translate with pandas

The ai.translate function uses generative AI to translate input text into a new language (of your choice), with a single line of code.

Note

Overview

The ai.translate function extends the pandas Series class. To translate each input row into a target language of your choice, call the function on a pandas DataFrame text column.

The function returns a pandas Series that contains translations, which you can store in a new DataFrame column.

Tip

The ai.translate function was tested with 10 languages: Czech, English, Finnish, French, German, Greek, Italian, Polish, Spanish, and Swedish. Your results with other languages might vary.

Syntax

df["translations"] = df["text"].ai.translate("target_language")

Parameters

Name Description
to_lang
Required
A string representing the target language for text translations.

Returns

The function returns a pandas Series that contains translations for each row of input text. If the input text is null, the result is null.

Example

# This code uses AI. Always review output for mistakes. 

df = pd.DataFrame([
        "Hello! How are you doing today?", 
        "Tell me what you'd like to know, and I'll do my best to help.", 
        "The only thing we have to fear is fear itself."
    ], columns=["text"])

df["translations"] = df["text"].ai.translate("spanish")
display(df)

This example code cell provides the following output:

Screenshot of a data frame with columns 'text' and 'translations'. The 'translations' column contains the text translated to Spanish.