I need to put a new column in my data frame, using dplyr::mutate who simply calculate the row means if the column name starts with V.
I tried to use
fcst_prices <- fcst_prices %>%
mutate(
Mean_Fcsts = rowMeans(select(starts_with("V")), na.rm=TRUE)
)
data:
glimpse(fcst_prices)
Rows: 504
Columns: 1,000
$ V1 <dbl> 0.9882854, 0.9943432, 1.0066737, 1.0358174, 1.0318638, 1.05~
$ V2 <dbl> 1.0067812, 0.9780687, 1.0038225, 1.0131935, 1.0089143, 1.03~
$ V3 <dbl> 1.018123, 1.011892, 1.025020, 1.066394, 1.059514, 1.065158,~
$ V4 <dbl> 1.0072748, 0.9973791, 0.9791292, 0.9534645, 0.9765678, 0.95~
$ V5 <dbl> 0.9783680, 0.9655283, 0.9649827, 1.0490434, 1.0503648, 1.06~
$ V6 <dbl> 1.0027197, 0.9870110, 0.9734787, 0.9764613, 0.9662142, 0.94~
$ V7 <dbl> 0.9951287, 1.0177348, 1.0054102, 1.0174618, 0.9996121, 0.98~
$ V8 <dbl> 0.9856348, 0.9969825, 0.9779560, 0.9971946, 1.0053000, 1.02~
$ V9 <dbl> 1.000684, 1.009189, 1.024402, 1.032096, 1.053807, 1.068524,~
$ V10 <dbl> 1.0068093, 0.9939374, 0.9802338, 0.9885188, 0.9622480, 0.96~
$ V11 <dbl> 0.9988063, 1.0051448, 1.0142188, 1.0223961, 1.0399016, 1.03~
$ V12 <dbl> 1.017846, 1.012508, 1.024628, 1.024206, 1.004845, 1.022993,~
$ V13 <dbl> 1.0206625, 0.9939849, 0.9607511, 0.9852449, 0.9395213, 0.92~
$ V14 <dbl> 1.0161157, 1.0085123, 1.0095981, 1.0017129, 0.9897123, 0.99~
$ V15 <dbl> 0.9585678, 0.9820704, 0.9911285, 0.9817727, 0.9911644, 1.00~
$ V16 <dbl> 0.9941426, 0.9927010, 0.9917946, 0.9889182, 0.9925894, 0.99~
$ V17 <dbl> 0.9979804, 1.0214071, 1.0286764, 1.0415425, 1.0409966, 1.04~
$ V18 <dbl> 0.9878930, 0.9820520, 0.9741155, 0.9707525, 0.9548519, 0.96~
$ V19 <dbl> 0.9871881, 1.0021602, 1.0243242, 0.9994608, 1.0003129, 0.99~
$ V20 <dbl> 0.9828258, 0.9910219, 1.0019939, 0.9944902, 0.9552034, 0.93~
$ V21 <dbl> 0.9888249, 0.9718689, 0.9760357, 0.9850335, 0.9819784, 1.01~
$ V22 <dbl> 0.9981441, 1.0049319, 0.9887205, 0.9895039, 1.0148411, 1.01~
$ V23 <dbl> 0.9970455, 1.0061045, 1.0248983, 1.0224870, 1.0197655, 1.03~
$ V24 <dbl> 1.0125220, 1.0253541, 1.0307841, 1.0425741, 1.0344221, 1.02~
$ V25 <dbl> 0.9914851, 0.9711403, 0.9917044, 0.9963411, 1.0075890, 1.00~
$ V26 <dbl> 1.0011011, 1.0078956, 1.0029757, 1.0049124, 1.0332714, 1.06~
$ V27 <dbl> 1.0159438, 1.0158054, 1.0104938, 1.0020727, 1.0017532, 1.01~
$ V28 <dbl> 0.9846138, 0.9908568, 0.9851029, 0.9398689, 0.9388180, 0.92~
$ V29 <dbl> 0.9913572, 0.9970750, 0.9957020, 0.9994990, 0.9960493, 1.00~
$ V30 <dbl> 0.9675074, 0.9495288, 0.9357869, 0.9164587, 0.9231961, 0.93~
$ V31 <dbl> 0.9884108, 1.0102067, 1.0023929, 1.0282738, 1.0292449, 1.02~
$ V32 <dbl> 1.0003712, 1.0018117, 1.0124738, 1.0117079, 1.0192414, 1.02~
$ V33 <dbl> 0.9740372, 0.9587591, 0.9711541, 1.0084787, 1.0095611, 0.99~
$ V34 <dbl> 0.9996792, 1.0078209, 1.0109785, 1.0188314, 1.0302227, 1.03~
$ V35 <dbl> 1.0119468, 1.0127999, 1.0289631, 1.0143031, 1.0543618, 1.05~
But that doesn't work. How can I solve this?
