How can I detect a seasonal pattern row-wise? I´ve provided an exemplary data frame. The goal is to identify whether or not there is a seasonal pattern for each Keyword using ACF or spectral analysis
How can I detect a seasonal pattern row-wise? I´ve provided an exemplary data frame.
The goal is to identify whether or not there is a seasonal pattern for each Keyword using ACF or spectral analysis
library(tidyverse)
# Create a
dates <- seq(as.Date("2019-01-01"), as.Date("2023-01-09"), by = "months")
# Create a vector of random keywords (replace with your own keywords)
keywords <- c("Keyword1", "Keyword2", "Keyword3", "Keyword4", "Keyword5", "Keyword6", "Keyword7", "Keyword8", "Keyword9", "Keyword10", "Keyword11", "Keyword12", "Keyword13", "Keyword14", "Keyword15", "Keyword16", "Keyword17", "Keyword18", "Keyword19", "Keyword20") # Create a data frame df <- tibble("Google trends" = keywords)
# Add date columns
for (i in 1:length(dates)) {
col_name <- format(dates[i], "%d-%m-%Y")
df <- df %>% mutate(!!col_name := sample(1:100, length(keywords), replace = TRUE))
}
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 4 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Thank you. Could you additionally provide a code where you use the apply() function ? (Just for ACF! :)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![Database System Concepts](https://www.bartleby.com/isbn_cover_images/9780078022159/9780078022159_smallCoverImage.jpg)
![Starting Out with Python (4th Edition)](https://www.bartleby.com/isbn_cover_images/9780134444321/9780134444321_smallCoverImage.gif)
![Digital Fundamentals (11th Edition)](https://www.bartleby.com/isbn_cover_images/9780132737968/9780132737968_smallCoverImage.gif)
![C How to Program (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780133976892/9780133976892_smallCoverImage.gif)
![Database Systems: Design, Implementation, & Manag…](https://www.bartleby.com/isbn_cover_images/9781337627900/9781337627900_smallCoverImage.gif)
![Programmable Logic Controllers](https://www.bartleby.com/isbn_cover_images/9780073373843/9780073373843_smallCoverImage.gif)