Home/ Questions/How can I handle - attempt to set 'colnames' on an object with less than two dimensions?
Next
Answered
Javier Evans
  • 6
Asked: 2022-05-18T18:32:17+00:00 In:

How can I handle – attempt to set ‘colnames’ on an object with less than two dimensions?

  • 6

. Advertisement .

..3..

. Advertisement .

..4..

I get the error message:

Error in `colnames<-`(`*tmp*`, value = c("SPY.Open", "SPY.High", "SPY.Low", : 
  attempt to set 'colnames' on an object with less than two dimensions # creating the column names

Has anyone ever faced this problem? How to troubleshoot the “attempt to set ‘colnames’ on an object with less than two dimensions”. The problem appears when I try to operate the following program:

# rm(list = ls()) # generally considered as bad manner in an MWE
 require(quantmod)
 options(scipen=999)
 spy <- getSymbols(("SPY") , src = 'yahoo', from = '2016-01-01', auto.assign = T)
 spy<-cbind(SPY)
 tail(SPY)
  SPY.Open SPY.High SPY.Low SPY.Close SPY.Volume SPY.Adjusted
 2016-01-14 189.55 193.26 187.66 191.93 240795600 191.93
 2016-01-15 186.77 188.76 185.52 187.81 324846400 187.81
 2016-01-19 189.96 190.11 186.20 188.06 190196000 188.06
 2016-01-20 185.03 187.50 181.02 185.65 280016900 185.65
 2016-01-21 186.21 188.87 184.64 186.69 189174000 186.69
 2016-01-22 189.78 190.76 188.88 190.52 163849600 190.52
q <- c("2016-01-25",100,200,200,200,200,200) # creating the data
 colnames(q) <- colnames(SPY) # creating column names as in SPY
xts
Share

1 Answer

  1. Best Answer
    Expert

    The cause:

    This error occurs because you are trying to set ‘colnames’ on an object which have more than two dimensions.

    Solution:

    Perhaps following is what you expect:

    q <- data.frame(100,200,200,200,200,200)
colnames(q) <- colnames(SPY)
q <- xts(q, as.Date("2016-01-26"))
# SPY.Open SPY.High SPY.Low SPY.Close SPY.Volume SPY.Adjusted
# 2016-01-26 100 200 200 200 200 200

class(SPY)
# [1] "xts" "zoo"
class(q)
# [1] "xts" "zoo"

tail(rbind(SPY, q))
# SPY.Open SPY.High SPY.Low SPY.Close SPY.Volume SPY.Adjusted
# 2016-01-19 189.96 190.11 186.20 188.06 190196000 188.06
# 2016-01-20 185.03 187.50 181.02 185.65 280016900 185.65
# 2016-01-21 186.21 188.87 184.64 186.69 189174000 186.69
# 2016-01-22 189.78 190.76 188.88 190.52 163849600 190.52
# 2016-01-25 189.92 190.15 187.41 187.64 122676200 187.64
# 2016-01-26 100.00 200.00 200.00 200.00 200 200.00
    • 0

Leave an answer

You must login to add an answer.

Need An Account,