Excel

Introduction This tutorial was inspired by the R Curious tutorial at useR! 2018, and follows on thematically from the R Curious workshop notes as an extension. It is aimed at those with a background in Excel, who would also like to use R for data analysis. This tutorial compares the things you would normally do in Excel, but with an equivalent function in R. This introductory level tutorial assumes you have already installed R and R studio and had a brief introduction to the R basics and R Markdown.

I have been experimenting with spatial data and looking at ways to combine data objects to get different views and perspectives. This post has the following objectives: Import and load data direct to R without manually saving files to a local directory, so that the end to end process is reproducible. Use vectors to efficiently clean the Excel sheet, reducing manual steps where possible so that the process could be leveraged to clean other Excel sheets in the Census data.