Breaking News: Grepper is joining You.com. Read the official announcement!

data.table iterieren über Spalten.

Nikolaus Kresse answered on August 7, 2022 Popularity 5/10 Helpfulness 3/10

answer data.table iterieren über Spalten.

data.table iterieren über Spalten.

Comment

#Iterate through column names
columnNames <- names(dt)[-1]
lst <- list()
dtForecast <- data.table()
for (currentColumn in columnNames) {
  #Create list for current series and perform operations
  subList <- list()
  subList$Name <- currentColumn
  subList$Data <- dt[, get(currentColumn)]
  subList$TSData <- ts(subList$Data, start=2015, frequency=365)
  subList$Fit <- stlf(subList$TSData)
  subList$Forecast <- forecast(subList$Fit, h=365)
  subList$Predictions <- subList$Forecast$mean
  plot(subList$Forecast)
  
  #Append sublist to list
  lst[[currentColumn]] <- subList
  
  #Create forecast data table and append to final table
  dtCur <- data.table(
    Name = subList$Name,
    Type = c(
      rep("Data", length(subList$Data)),
      rep("Prediction", length(subList$Predictions))
    ),
    Series = c(subList$Data, subList$Predictions)
  )
  dtCur[, Case := sequence(.N)]
  dtForecast <- rbindlist(list(dtForecast, dtCur))
}

Popularity 5/10 Helpfulness 3/10 Language whatever

Source: r-coding.de

Tags: data.table iterate r whatever

Link to this answer
Share Copy Link

Contributed on Aug 07 2022

Nikolaus Kresse

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

data.table iterieren über Spalten.

Contents

More Related Answers

data.table iterieren über Spalten.

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.