Combine two data tables with same column names + Replace NAs with 0s

PHOTO

Wed May 11 2022 05:20:09 GMT+0000 (Coordinated Universal Time)

df1 %>%
  full_join(df2, by = c("column_name_1", "column_name_2"), 
            suffix = c("_df1", "_df2")) 
%>%
  replace_na(list(n_batman = 0, n_star_wars = 0))

COPY

Worked on data camp

Save snippets that work from anywhere online with our extensions

Comments

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

Combine two data tables with same column names + Replace NAs with 0s

Save snippets that work from anywhere online with our extensions

Comments

More like this

Data cleaning

Browse more snippets >>

Combine two data tables with same column names + Replace NAs with 0s

Save snippets that work from anywhere online with our extensions

Comments

More like this

Data cleaning

Browse more snippets >>

Embed code snippet