Reshaping data and Joining tables

LIBD Rstats Club: Reshaping data and Joining tables
Presented By : Manisha Barse
Date: May 30, 2025

Recording link to our rstats club presentation: https://youtu.be/5L133h_1SNo

Topics covered:
#RStats #Tidyverse
1. Reshaping data: pivot_wider, pivot_longer, separate, unite
2. Joining tables:
a) joins: mutating(inner,right, left, full), filter(semi, anti)
b) binding: by columns, by rows
c) set operators: intersect, union, set diff, set equal

Transcript

1. Reshaping Data and Joining Tables RStats presentation Presented By: Manisha Barse May 30, 2025
2. Objectives Reshaping, merging, and comparing are essential. We'll explore: • Pivoting (wide ↔ long) • Joins • Set operations
3. R Script demo https://github.com/manishabarse/LIBD_presentation/tree/main/Data_Transformation
4. Summary pivot_wider(): Long -> Wide (spread key-value pairs into multiple columns) pivot_longer(): Wide -> Long (collapse multiple columns into key-value pairs) separate(): Split one column into multiple columns by separator unite(): Combine multiple columns into one column, joining by separator
5. Summary Joins https://github.com/rstudio/cheatsheets
6. Summary https://github.com/rstudio/cheatsheets
7. Thank you