How can seasonality be analyzed per row? on a massive dataset with many observations? My code below does not work for large datasets (just on smaller ones). # Function to detect seasonal patterns using ACF for a single row detect_seasonal_acf <- function(row) { acf_result <- acf(row, lag.max = 12) return(acf_result$acf) } # Apply the function row-wise seasonal_acf_results <- apply(data[, -1], 1, detect_seasonal_acf) # Check for significant peaks (e.g., peaks above a certain threshold) significant_peaks <- sapply(seasonal_acf_results, function(acf_values) { max(acf_values) > 2/sqrt(length(acf_values)) }) # The 'significant_peaks' vector will indicate if there's a seasonal pattern for each keyword subset_data$Seasonal_Pattern_ACF <- significant_peaks
How can seasonality be analyzed per row? on a massive dataset with many observations?
My code below does not work for large datasets (just on smaller ones).
# Function to detect seasonal patterns using ACF for a single row
detect_seasonal_acf <- function(row) { acf_result <- acf(row, lag.max = 12)
return(acf_result$acf) }
# Apply the function row-wise
seasonal_acf_results <- apply(data[, -1], 1, detect_seasonal_acf)
# Check for significant peaks (e.g., peaks above a certain threshold)
significant_peaks <- sapply(seasonal_acf_results, function(acf_values) { max(acf_values) > 2/sqrt(length(acf_values)) })
# The 'significant_peaks'
Step by step
Solved in 4 steps