r - summarize the table by states such as population under 10 meters by states.?

Question

I need help with coding something in R. This is the question I'm trying to answer: summarize the table by states such as population under 10 meters by states.? This is from an excel file, I already loaded the excel file in r studio but I'm struggling to code this.

This is exactly how the columns looks like in the csv file:

pop| elevations| lecz| pop_source| year| NAME| STATE_NAME| POP2010

Answer 1

Assuming you loaded your data into something called raw_data, then try this:

library(tidyverse)
summarized_data <- raw_data %>% 
    group_by(STATE_NAME) %>% 
    filter(year == max(year)) %>% 
    filter(elevations < 10) %>% 
    summarize(pop = sum(pop))

But it is very hard to know for sure since you didn't provide a sample of your data using something like dput(raw_data).