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.
This exercise is part of the course
Introduction to AWS Boto in Python
Exercise instructions
- Detect the sentiment of
'public_description'for every row. - Store the result in the
'sentiment'column.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
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()