为什么apply()返回转置的xts矩阵? [英] Why apply() returns a transposed xts matrix?
问题描述
我想在xts矩阵的所有周期上运行一个函数. apply()非常快,但是返回的矩阵与原始对象相比具有转置尺寸:
I want to run a function on all periods of an xts matrix. apply() is very fast but the returned matrix has transposed dimensions compared to the original object:
> dim(myxts)
[1] 7429 48
> myxts.2 = apply(myxts, 1 , function(x) { return(x) })
> dim(myxts.2)
[1] 48 7429
> str(myxts)
An 'xts' object from 2012-01-03 09:30:00 to 2012-01-30 16:00:00 containing:
Data: num [1:7429, 1:48] 4092500 4098500 4091500 4090300 4095200 ...
- attr(*, "dimnames")=List of 2
..$ : NULL
..$ : chr [1:48] "Open" "High" "Low" "Close" ...
Indexed by objects of class: [POSIXlt,POSIXt] TZ:
xts Attributes:
NULL
> str(myxts.2)
num [1:48, 1:7429] 4092500 4098500 4091100 4098500 0 ...
- attr(*, "dimnames")=List of 2
..$ : chr [1:48] "Open" "High" "Low" "Close" ...
..$ : chr [1:7429] "2012-01-03 09:30:00" "2012-01-03 09:31:00" "2012-01-03 09:32:00" "2012-01-03 09:33:00" ...
> nrow(myxts)
[1] 7429
> head(myxts)
Open High Low Close
2012-01-03 09:30:00 4092500 4098500 4091100 4098500
2012-01-03 09:31:00 4098500 4099500 4092000 4092000
2012-01-03 09:32:00 4091500 4095000 4090000 4090200
2012-01-03 09:33:00 4090300 4096400 4090300 4094900
2012-01-03 09:34:00 4095200 4100000 4095200 4099900
2012-01-03 09:35:00 4100000 4100000 4096500 4097500
如何保存myxts尺寸?
How can I preserve myxts dimensions?
推荐答案
apply
就是这样做的.来自?apply
:
That's what apply
is documented to do. From ?apply
:
值:
If each call to ‘FUN’ returns a vector of length ‘n’, then ‘apply’
returns an array of dimension ‘c(n, dim(X)[MARGIN])’ if ‘n > 1’.
在您的情况下,为'n'=48
(因为您要遍历行),因此apply
将返回维度为c(48, 7429)
的数组.
In your case, 'n'=48
(because you're looping over rows), so apply
will return an array of dimension c(48, 7429)
.
还要注意,myxts.2
不是xts对象.这是一个常规数组.您有两种选择:
Also note that myxts.2
is not an xts object. It's a regular array. You have a couple options:
-
在重新创建xts对象之前转置
apply
的结果:
data(sample_matrix)
myxts <- as.xts(sample_matrix)
dim(myxts) # [1] 180 4
myxts.2 <- apply(myxts, 1 , identity)
dim(myxts.2) # [1] 4 180
myxts.2 <- xts(t(apply(myxts, 1 , identity)), index(myxts))
dim(myxts.2) # [1] 180 4
对函数进行矢量化处理,使其可以在xts的所有行上运行
对象并返回一个xts对象.那你不用担心
大约apply
.
Vectorize your function so it operates on all the rows of an xts
object and returns an xts object. Then you don't have to worry
about apply
at all.
最后,请开始提供可复制的示例.这并不难,并且使人们更容易获得帮助.我在上面提供了一个示例,希望您可以在以下问题中使用它.
Finally, please start providing reproducible examples. It's not that hard and it makes it a lot easier for people to help. I've provided an example above and I hope you can use it in your following questions.
这篇关于为什么apply()返回转置的xts矩阵?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!