Practicing with grouped summaries
We can use pivot_wider() in association with the output of grouped summaries as well.
This exercise is part of the course
Introduction to Text Analysis in R
Exercise instructions
- Append
tidy_twitterto the afinn sentiment dictionary. - Group by both complaint label and whether or not the user is verified.
- Summarize the data to create a new column,
aggregate_value, which contains the sum ofvalue. - Spread the
complaint_labelandaggregate_valuecolumns.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
tidy_twitter %>%
# Append the afinn sentiment dictionary
___(___) %>%
# Group by both complaint label and whether or not the user is verified
___(___) %>%
# Summarize the data with an aggregate_value = sum(value)
___(___) %>%
# Spread the complaint_label and aggregate_value columns
___(___) %>%
mutate(overall_sentiment = Complaint + `Non-Complaint`)