How to assign a vector to dataframe when vector has fewer rows than dataframe?

Asked Oct 12 '21 at 14:25

Active Oct 13 '21 at 06:07

Viewed 40 times

I am trying to calculate stock returns on the basis of prices, but since returns will only be calculable from t=2 and so on, I'm one replacement short from being able to assign the returns vector to the original dataframe.

I have assigned NA values to the dframe$returns to begin with, but this hasn't helped. I need a way to come around this issue.

Here's what I have so far:

dframe$returns <- NA
n <- nrows(dframe)
dframe$returns <- (dframe[2:n,adj.price]-dframe[1:(n-1),adj.price])/dframe[1:(n-1),adj.price]

I've tried Google, and I only find people creating return vectors, which is not the real problem, as my issue is how to deal with assigning a vector to a dataframe, where the vector is shorter than the dataframe. Anyone here that can help me?

edited Oct 13 '21 at 06:07

Skaqqs

4,010
1
7
21

asked Oct 12 '21 at 14:25

thomas.diridondo

what about `dframe$returns <- c(NA, (dframe[2:n,adj.price]-dframe[1:(n-1),adj.price])/dframe[1:(n-1),adj.price])` – Skaqqs Oct 12 '21 at 14:28
[See here](https://stackoverflow.com/q/5963269/5325862) on making a reproducible example that is easier for folks to help with. Right now it would be hard to do more than guess as to what's going on – camille Oct 12 '21 at 14:31
It certainly did! I also understand the solution, thank you so much! – thomas.diridondo Oct 12 '21 at 14:32
You're welcome. Good luck – Skaqqs Oct 12 '21 at 14:34

How to assign a vector to dataframe when vector has fewer rows than dataframe?

0 Answers0