I have a dataset of 56,040 tweets in R called 'tweets' collected in the week following the roe v wade announcement. I'm attempting to analyze using sentiment analysis scores. I have three columns:
- 'stance' = included for each tweet - includes either 'life' or 'choice' depending on which stance the tweet is taking.
- 'POSIX' = the timestamp of when the date was posted, currently in YYYY-MM-DD-HH-MM-SS format.
- 'score' = the sentiment score for each tweet, ranging from around -10 to 10.
I've tried various ways without success and honestly don't know what I'm doing but figure this can't be that difficult. I'm attempting to create a line graph with two lines (one for life and another for choice) over the course of the timeframe (right after midnight on the 22nd until 11:59 on the 3rd) showing the average sentiment score of tweets by hour, controlling for the number of tweets that were sent out at that hour. Any suggestions?
So far I've attempted various ggplot and plotly attempts with no success. Pls help lol