Please see the structure of my data in the image below.
I am trying to automate/ create the last three variables/columns ( highlighted in green). How can I program this in R please?
They should pull in data from the same year as the bond was issued ( time T+)), they would get this year from the first column
Could you please turn this into a self-contained reprex (short for reproducible example)? It will help us help you if we can be sure we're all working with/looking at the same stuff, and it's difficult to read screenshots (not to mention, extra work for someone trying to help you to type all that data in).
install.packages("reprex")
If you've never heard of a reprex before, you might want to start by reading the tidyverse.org help page. The reprex dos and don'ts are also useful.
If you run into problems with access to your clipboard, you can specify an outfile for the reprex, and then copy and paste the contents into the forum.
reprex::reprex(input = "fruits_stringdist.R", outfile = "fruits_stringdist.md")
For pointers specific to the community site, check out the reprex FAQ, linked to below.
Hi @mara - I think you have a typo - don't you mean install.packages("reprex") (not install.reprex)?
Yup! Thanks, fixed that one!