Find obs not present in both dfs - missing obs. Anti_join

PHOTO

Wed May 11 2022 13:12:08 GMT+0000 (Coordinated Universal Time)

Saved by @Treenose

incomplete_df %>%
  anti_join(complete_df, by = "column_2b_sorted") #returns rows mising in incomplete_df

#If column names are not the same:
incomplete_df %>%
  anti_join(complete_df, by = c("column_2b_sorted_incomplete" = "column_2b_sorted_complete")

https://towardsdatascience.com/get-started-using-anti-joins-in-r-837af13be286

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

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 >>