Getting request sentiment
After successfully translating Get It Done cases for the Streets Director, he asked for one more thing. He really wants to understand how people in the City feel about his department's work. She believes she can answer that question via sentiment analysis of Get It Done requests. She has already loaded the CSV into the dumping_df variable and subset it to the following columns:
In this exercise, you will help Sam better understand the moods of the voices of the people that submit Get It Done cases, and whether they are coming into the interaction with the City in a positive mood or a negative one.
Deze oefening maakt deel uit van de cursus
Introduction to AWS Boto in Python
Oefeninstructies
- Detect the sentiment of
'public_description'for every row. - Store the result in the
'sentiment'column.
Praktische interactieve oefening
Probeer deze oefening eens door deze voorbeeldcode in te vullen.
for index, row in dumping_df.iterrows():
# Get the translated_desc into a variable
description = dumping_df.loc[index, 'public_description']
if description != '':
# Get the detect_sentiment response
response = comprehend.____(
____=description,
____='en')
# Get the sentiment key value into sentiment column
dumping_df.loc[index, 'sentiment'] = response['____']
# Preview the dataframe
dumping_df.head()