Replace NA's with column mean

PHOTO

Wed Aug 17 2022 12:31:22 GMT+0000 (Coordinated Universal Time)

Saved by @Treenose

###### Generic ###########
my_df %>% 
  mutate(x1 = replace_na(x1,mean(x1, na.rm = TRUE)))

####### Simba specific ############
data %>%
group_by(                                     # Replace missing values with group mean
    Variables) %>% 
  mutate(
    Values = replace_na(Values, mean(Values, na.rm = TRUE))
  )

Missing values in SIMBA data table to be replaced with group mean

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

SIMBA analysis

@Treenose

fct_collapse: Collapse factor levels into manually defined groups str_detect: Detect patterns in texts, using fixed("") for "(, ), *, ', $, +" Lineplot of variable for each participant, facetted by treatment and visit Replace NA's with column mean

Data cleaning

@Treenose

str_detect: Detect patterns in texts, using fixed("") for "(, ), *, ', $, +" fct_collapse: Collapse factor levels into manually defined groups Trim (remove whitespace from) column names and set to lowercase Set values out of range to upper detection limit in new column Find obs not present in both dfs - missing obs. Anti_join Filter-join df1 for observations also in df2 Filter dataframe1 by column in dataframe2 inner_join, arrange and add suffixes Combine two data tables with same column names + Replace NAs with 0s Separate or join variables over/from 2 columns - tidyr::separate() / unite() Replace NA with previous row value - fill() Replace NA's with column mean

Browse more snippets >>