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

Exercise

Detecting language

The City Council is wondering whether it's worth it to build a Spanish version of the Get It Done application. There is a large Spanish speaking constituency, but they are not sure if they will engage. Building in multi-lingual translation complicates the system and needs to be justified.

They ask Sam to figure out how many people are posting requests in Spanish.

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 quantify the demand for a Spanish version of the Get It Done application. Figure out how many requesters use Spanish and print the final result!

Instructions

100 XP
  • For each row in the DataFrame, detect the dominant language.
  • Assign the first selected language to the 'lang' column.
  • Count the total number of posts in Spanish.