Translate a column with python using textblob library

[vgferreira]

Hi!

I'm trying to translate a column of my table, using Python's TextBlob library. this is my code.

from textblob import TextBlob

def translation(text):
   blob = TextBlob(text)
   return str(blob.translate(from_lang = 'pt', to = 'en'))

dataset['translation'] = dataset['CardDescription'].apply(translation)

it generates the following error.

TypeError: The `text` argument passed to `__init__(text)` must be a string, not <class 'float'>

however my CardDescription column is formatted as text.

I tested it using a string variable and it worked.

I don't know the reason for the error, can someone help me?

Thanks in advance!

[v-easonf-msft]

Hi, @vgferreira 

This is an error message related to the python script, not powerbi.

You should check the encoding you are using for your file.

Reference:

TextBlob --- The `text` argument passed to `__init__(text)` must be a string, not <class 'float'> 

Python 2.7 and Textblob - TypeError: The `text` argument passed to `__init__(text)` must be a string... 

Best Regards,
Community Support Team _ Eason