Hi everybody,
I am looking for help. I have the data like that and I would like to put each value by year in "business_freedom" file into "stocks" file.
I have more than 300 stock ticker and nine variables such as "business_freedom".
Thank you in advance.
stocks<-data.frame(
year = c(2016L, 2017L, 2018L, 2009L, 2010L, 2011L, 2012L, 2013L,
2014L, 2015L, 2016L, 2017L, 2018L, 2009L, 2010L, 2011L,
2012L, 2013L, 2014L, 2015L),
business_freedom = c(NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA, NA,
NA, NA, NA, NA, NA, NA),
ticker = as.factor(c("AAA", "AAA", "AAA", "AAM", "AAM", "AAM",
"AAM", "AAM", "AAM", "AAM", "AAM", "AAM",
"AAM", "ABT", "ABT", "ABT", "ABT", "ABT", "ABT",
"ABT"))
)
business_freedom <- data.frame(
year = c(2018L, 2017L, 2016L, 2015L, 2014L, 2013L, 2012L, 2011L,
2010L, 2009L),
business_freedom = c(63.2, 61.2, 58.3, 61.5, 62, 63.8, 61.1, 61.6, 60.7, 60)
)