inner_join, arrange and add suffixes

PHOTO

Wed May 11 2022 12:31:34 GMT+0000 (Coordinated Universal Time)

Saved by @Treenose

parts_joined %>%
  # Sort the number of star wars pieces in descending order 
arrange(desc(n_star_wars)) %>%
  # Join the colors table to the parts_joined table
inner_join(colors, by = c("color_id" = "id")) %>%
  # Join the parts table to the previous join 
inner_join(parts, by = "part_num", suffix = c("_color", "_part") )

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