topic Re: Convert languages (Chines) into English in Data & Schema Discussions

Convert languages (Chines) into English

danishnov — Wed, 16 Aug 2023 16:48:06 GMT

Hi Team,

I am looking to convert languages (Chines) into English or any other format. Do we have any function in incorta to use in formula column or any other suggestion.

Re: Convert languages (Chines) into English

JoeM — Fri, 18 Aug 2023 15:49:08 GMT

@danishnov - Here's a video and script of my solution:

import pandas as pd from translate import Translator df = read("Translation.Translations") pdf = df.toPandas() def translate_to_english(chinese_text): try: translator = Translator(to_lang="en", from_lang="zh") translation = translator.translate(chinese_text) return translation except Exception as e: print(f"Error translating '{chinese_text}': {e}") return "" # Apply translation function to the 'Chinese_Phrase' column and create a new 'English_Translation' column pdf['Machine_Translation'] = pdf['Chinese_Phrase'].apply(translate_to_english) df_all = spark.createDataFrame(pdf) save(df_all)

Re: Convert languages (Chines) into English

Shashidhar — Tue, 12 Sep 2023 15:13:04 GMT

Thank you @JoeM ,

The Code you have shared is obsolutely working fine. Below is the screenshot how it translated.

Regards,

Shashidhar.S