Database System Concepts
Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

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 vector of dates

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))

}

Expert Solution
Check Mark
Still need help?
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Thank you. Could you additionally provide a code where you use the apply() function ? (Just for ACF! :)  

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Thank you. Could you additionally provide a code where you use the apply() function ? (Just for ACF! :)  

Solution
Bartleby Expert
by Bartleby Expert
SEE SOLUTION
Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Text book image
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Text book image
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Text book image
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
Text book image
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education