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.
Este exercício faz parte do curso
Introduction to AWS Boto in Python
Instruções do exercício
- Detect the sentiment of
'public_description'for every row. - Store the result in the
'sentiment'column.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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()