How to create a table with means and standard deviations by group

Question

I have success creating a table of means and standard deviations, but now I need to separate the variables results by two groups, in this case by gender.

cols<-c('edad','experiencia','indigena','mestizo','blanco','años_educ')

stargazer(base[which(base$año=="2009"),][, cols], type = "text", 
   summary.stat = c("min", "p25", "median", "p75", "max", "mean", "sd"))

This code has allowed me to create this well formatted table, it also contain other stats, but now I want to dived the results by groups with more or less the same code. How can I achieve this?

============================================================
Statistic   Min Pctl(25) Median Pctl(75) Max  Mean  St. Dev.
------------------------------------------------------------ 
edad         0     13      25      47    99  30.701  21.997 
experiencia  0     2       8       20    80  12.924  14.222 
indigena     0     0       0       0      1  0.080   0.271  
mestizo      0     1       1       1      1  0.814   0.389  
blanco       0     0       0       0      1  0.053   0.224  
años_educ    0     5       7       12    21  8.423   4.563  
------------------------------------------------------------

Answer 1

The best way about such operations is probably using dplyr.

# install.packages("dplyr")
library(dplyr)

data <- tibble(
  grp = rep(c("M", "F"), 5), # gender column
  value = runif(10, 5, 10)
)

data %>% 
    group_by(grp) %>% # our group
    summarise( # summarise operation by group
        mean = mean(value),
        std = sd(value)
    )