Is there a way to apply loops to multiply across various columns in a dataframe?
I have two data frames, one of them is prices and one is quantities.
They each have five years in them: 2013:2017.
So, I would like to divide
vector1 <- prices[,1] / quantities[,1]
vector2 <- prices[,2] / quantities[,2]
Is there a way to do this in a loop so my code can be more efficient?
Also, I have a data frame with 22 rows. I would like to divide the 21 upper rows to the row at the bottom for every column:
first <- df[,1] / df[22,1]
second <- df[,2] / df[22,2]
Is this something that can be implemented in a loop as well?
Have a nice day everyone!