1. Learn
    2. /
  2. Courses
    3. /
  3. Introduction to AWS Boto in Python
Connected

Exercise

Translating Get It Done requests

Often, Get It Done requests come in with multiple languages in the description. This is a challenge for many City teams. In order to review the requests, many city teams need to have a translator on staff, or hope they know someone who speaks the language.

The Streets director asked Sam to help. He wanted her to translate the Get It Done requests by running a job at the end of every day.

Sam decides to run the requests through the AWS translate service. She has already loaded the CSV into the dumping_df variable and subset it to the following columns:

Get It Done requests in many languages

Help Sam translate the requests to Spanish by running them through the AWS translate service!

Instructions

100 XP
  • For each row in the DataFrame, translate it to English.
  • Store the original language in the original_lang column.
  • Store the new translation in the translated_desc column.