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!

Deze oefening maakt deel uit van de cursus

Introduction to AWS Boto in Python

Cursus bekijken

Oefeninstructies

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.

Praktische interactieve oefening

Probeer deze oefening eens door deze voorbeeldcode in te vullen.

for index, row in dumping_df.iterrows():
  	# Get the public_description into a variable
    description = dumping_df.loc[index, 'public_description']
    if description != '':
      	# Translate the public description
        resp = translate.____(
            ____=description, 
            ____='auto', ____='en')
        # Store original language in original_lang column
        dumping_df.loc[index, 'original_lang'] = resp['____']
        # Store the translation in the translated_desc column
        dumping_df.loc[index, 'translated_desc'] = resp['____']
# Preview the resulting DataFrame
dumping_df = dumping_df[['service_request_id', 'original_lang', 'translated_desc']]
dumping_df.head()

Code bewerken en uitvoeren