df %>%
mutate(trimmed_column = str_trim(column),
trimmed_column_lower = str_to_lower(trimmed_column))
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))
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter