I noticed that there's an issue with how timestamps are handled using the Excel reader you're using. It doesn't materially impact the analysis, but it's not correctly classifying the dates into months.
For example N is 1145 not 1100 for January.
Notice the 1,145
Scented_All %>% filter(Date>="2020-01-01") %>% filter(Date<"2020-02-01")
# # A tibble: 1,145 x 4
# CandleID Date Rating Review
# <dbl> <dttm> <dbl> <chr>
# 1 1 2020-01-31 00:00:00 2 Yankee Candles just aren’t any good anymore. For a Yankee Candle, and t~
# 2 1 2020-01-07 00:00:00 5 Smells amazing As miss I try to consistently give other (smaller companie~
# 3 1 2020-01-19 00:00:00 5 Yankee candles are top notch This has been lasting me regular burns throu~
# 4 1 2020-01-16 00:00:00 4 Yankee Doodle Yankee candles are a wonderful addition to the interior of ~
# 5 1 2020-01-12 00:00:00 4 Too strong and artificial smelling. I love candles that smell like Christ~
# 6 1 2020-01-20 00:00:00 5 The best real tree smell I’ve found! I’ve tried a lot of candles tryi~
# 7 1 2020-01-29 00:00:00 4 Luv the scent It arrived with the glass jar broken. It was for myself and~
# 8 1 2020-01-07 00:00:00 5 Perfect Price when on sale! I purchased this because it was on sale. Norm~
# 9 1 2020-01-09 00:00:00 5 Smells like my dream home I didn't expect to love this candle, but I got ~
# 10 1 2020-01-26 00:00:00 1 Wouldn’t buy again. Almost no scent.
# # ... with 1,135 more rows
You can check this one in Excel.
Scented_All %>% filter(Date>="2020-01-01") %>% filter(Date<"2020-02-01") %>% .[76,]
## A tibble: 1 x 4
# CandleID Date Rating Review
# <dbl> <dttm> <dbl> <chr>
#1 1 2020-02-01 00:00:00 5 My favorite scent Long lasting. My favorite scent.
I noticed that there's an issue with how timestamps are handled using the Excel reader you're using. It doesn't materially impact the analysis, but it's not correctly classifying the dates into months.
For example N is 1145 not 1100 for January.
Notice the 1,145
You can check this one in Excel.