New to R would like to find a way to find the mean of each states

[NewtoR1]

Hello,
So I was wondering if there was a simpler way to find the mean of all the USA states mean of each population.

So we have a bunch of counties here is a example of how the data.frame is organized

   county.name state.name state.abbr pop.size pop.density poverty age.19_under
1      Autauga    Alabama         AL    48612          82    10.4         26.9
2      Baldwin    Alabama         AL   162586         102    10.2         23.5
3      Barbour    Alabama         AL    28414          32    22.1         24.3

I would like to know if there is a way to get the mean of each states pop.size without having to write out each mean by creating a bunch of new data.frames.

Is is grouping the numbers together in the post but they are seperate. It is not all one number

[phiggins]

To find the mean population of all of the counties in each state, use the

data %>%
group_by(group) %>%
summarize(mean_ctypop = mean(county_pop)

construction,

as in the toy example below with only 2 states and 5 counties

library(tidyverse) #load library

# now build vectors for the toy example
cty <- c("Autauga", "Baldwin", "Baldwin", "Washtenaw", "Wayne")
state <- c(rep("Alabama", 3), rep("Michigan", 2))
pop <- c(48612, 162586, 28414, 1753893, 370963)

# now assemble into a data frame from vectors
df <- data.frame(cty, state, pop)

df #  show the dataframe df

# now run the pipe
df %>%          # take the data frame, then
  group_by(state) %>%    # group_by state, then
  summarize(mean_cty = mean(pop))  # summarize with a new variable, mean_cty

#> # A tibble: 2 x 2
#>   state    mean_cty
#>   <fct>       <dbl>
#> 1 Alabama    79871.
#> 2 Michigan 1062428

You will find that this construction of

data %>%
group_by(group) %>%
summarize(make a new variable)

comes in handy often

^{Created on 2019-09-05 by the reprex package (v0.3.0)}

[jcblum]

@NewtoR1

Is is grouping the numbers together in the post but they are seperate. It is not all one number

Take a look at this FAQ to learn how to format plain text and code in your posts here

FAQ: How to format your code

Formatting Code: the Basics All code or console output you include in your posts should be formatted properly. Luckily, this is very easy to do! Just use the code formatting button at the top of the post editing box: [image] Select some code Click the </> button! The code formatting button automatically adds special Markdown formatting symbols to whatever you selected. If you check the preview pane to the right of your post, you'll see that the forum software now outputs nicely formatted code . [04] The code formatting button is pretty smart! It can tell the difference between snippets of code that are part of a sentence and blocks of code that stand alone. …

[NewtoR1]

Thank you very much for the help I will try that out. You have saved me a lot of typing

[NewtoR1]

Whop my fault I will look that over thank you for your help in making it look nice

[phiggins]

That formatted code does look a lot better. To format the code in my response, I used the reprex package, which is very helpful for making reproducible examples for this kind of posting. Reprex takes code that you have copied and formats it nicely to your clipboard for later pasting to a message board like this one.

Tutorials on how to use reprex can be found here

1. https://reprex.tidyverse.org/articles/articles/learn-reprex.html
2. https://www.jessemaegan.com/post/so-you-ve-been-asked-to-make-a-reprex/

Welcome to the RStudio Community!