Practicing with grouped summaries
We can use pivot_wider() in association with the output of grouped summaries as well.
Este exercício faz parte do curso
Introduction to Text Analysis in R
Instruções do exercício
- 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.
Exercício interativo prático
Experimente este exercício completando este código de exemplo.
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`)