summary - Summarize each category of rows in one column using R -


i'm wondering if possible in r: have 2 columns. column (primaryhistory2.dept) has bunch of categorical data, column b (primaryhistry2.act.enroll) has numbers , nas. looks this

i want summary of column b each category in column a. like, "nut" in column a, want see min, max, mean, median, nas, etc. , see every category. when use summary() command.

not sure if possible.. thank in advance!

@moody_mudskipper results i'm looking for. without column names it's hard read. enter image description here

and base r, it's not doing counts nas, see lot of nas in file. enter image description here

very possible using dplyr library:

library(dplyr) most.of.the.answer = df %>%      group_by(primaryhistory2.dept) %>%     summarise(min = min(primaryhistry2.act.enroll, na.rm = true), max = max(primaryhistry2.act.enroll, na.rm = true), mean = mean(primaryhistry2.act.enroll, na.rm = true), median = median(primaryhistry2.act.enroll, na.rm = true)) 

(assuming dataframe called df)

for counting na's, try dplyr's filter feature:

count.nas = df %>% filter(is.na(primaryhistry2.act.enroll)) %>%     group_by(primaryhistory2.dept) %>%     summarise(count.na = n()) 

i'll leave merge 2 dataframes.


Comments

Popular posts from this blog

angular - Ionic slides - dynamically add slides before and after -

minify - Minimizing css files -

Add a dynamic header in angular 2 http provider -