I have 3 excel workbooks all containing population data for 3 different years. Each datasheet has location codes as the first column and then population data in the subsequent columns. I want to look at each data sheet, define a specific code and create a table for the total population for each year. Here is an example of the datasheet:
All 3 datasheets look the same. I have defined them as this:
pop_2016 <- read_excel("Wigan LSOA - Mid year 2016.xlsx", sheet="Persons")
pop_2017 <- read_excel("Wigan LSOA - Mid year 2017.xlsx", sheet="Persons")
pop_2018 <- read_excel("Wigan LSOA - Mid year 2018.xlsx", sheet="Persons")
So for each of pop_2016, pop_2017, pop_2018 I want to look in the column "2011 super" at a specific code (E01006283) and the total population associated with it in the "All ages" column".
This is my first time writing a script so I'm a total beginner.