AI Solution

Translating CSV and JSON Files with OCI Language

Introduction

Advancements in AI and large language models have led to significant improvements in language translation, making it much more accurate and easy to use.

In this solution, we’ll use Oracle Cloud Infrastructure (OCI) Language to enable the translation of specific columns in CSV files or keys in CSV and JSON documents while preserving the original structure of the files. This use case is particularly useful for localizing data files while maintaining their format and untranslated fields.

The following OCI services are present in this solution:

  • OCI Compute or OCI Cloud Shell for easily running the code in this solution’s repository, having authenticated the environment with the OCI SDK
  • OCI Language for document/field translation

Demo

Demo: Translating CSV and JSON Files with OCI Language (1:41)

Prerequisites and setup

  1. Oracle Cloud account—sign-up page
  2. Python 3.8 or higher—download
  3. OCI SDK—documentation
  4. Asynchronous job policies for identity and access management—documentation
  5. Document translation via OCI Language—documentation