You could be interesting in this book to get more used to how data manipulation can be achieved efficiently
Some pointers with dplyr
- you can add columns using
mutate()
- you can rename you column using
rename()
You can do many other thing to prepare you data.
You can get access to tutorials too:
Look at Rstudio Primers for example.
Hope it helps.