Practicing with grouped summaries
We can use pivot_wider() in association with the output of grouped summaries as well.
Questo esercizio fa parte del corso
Introduction to Text Analysis in R
Istruzioni dell'esercizio
- 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.
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
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`)